https://afisarl.com/mymarket/categories/djsk784857te13us

Query Metrics

10 Database Queries
10 Different statements
5.05 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 2.37 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4 FROM mymarket t0 WHERE t0.id = ?
Parameters:
[
  "4"
]
2 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4 FROM mymarket t0
Parameters:
[]
3 0.25 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.mymarket_id AS mymarket_id_5 FROM categories t0 WHERE t0.id = ?
Parameters:
[
  "13"
]
4 0.29 ms
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.description AS description_2, m0_.image AS image_3 FROM mymarket m0_
Parameters:
[]
5 0.24 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.hexadecimal AS hexadecimal_2 FROM colors c0_
Parameters:
[]
6 0.19 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.image AS image_3, c0_.mymarket_id AS mymarket_id_4 FROM categories c0_
Parameters:
[]
7 0.22 ms
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.icon AS icon_2, t0_.image AS image_3, t0_.name_english AS name_english_4 FROM tag t0_
Parameters:
[]
8 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.mymarket_id AS mymarket_id_5 FROM categories t0 WHERE t0.mymarket_id = ?
Parameters:
[
  4
]
9 0.40 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.more_information AS more_information_4, t0.price AS price_5, t0.is_best_seller AS is_best_seller_6, t0.is_new_arrival AS is_new_arrival_7, t0.is_featured AS is_featured_8, t0.is_special_offer AS is_special_offer_9, t0.image AS image_10, t0.quantity AS quantity_11, t0.created_at AS created_at_12, t0.tags AS tags_13, t0.slug AS slug_14, t0.is_promotional_price AS is_promotional_price_15, t0.promotional_price AS promotional_price_16, t0.pourcentage_promotional_price AS pourcentage_promotional_price_17, t0.etat AS etat_18, t0.nombre_vue AS nombre_vue_19, t0.poid_net AS poid_net_20, t0.longueur AS longueur_21, t0.largeur AS largeur_22, t0.hauteur AS hauteur_23, t0.min_commande AS min_commande_24, t0.piece_in_package AS piece_in_package_25, t0.image_de_specification AS image_de_specification_26, t0.max_price AS max_price_27, t0.max_commande AS max_commande_28, t0.user_id AS user_id_29 FROM product t0 INNER JOIN product_categories ON t0.id = product_categories.product_id WHERE product_categories.categories_id = ?
Parameters:
[
  13
]
10 0.46 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.image AS image_4, t0.name_english AS name_english_5 FROM tag t0
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Mymarket No errors.
App\Entity\Categories No errors.
App\Entity\Product
  • The association App\Entity\Product#user refers to the inverse side field App\Entity\User#products which does not exist.
App\Entity\Shop No errors.
App\Entity\ProductImages No errors.
App\Entity\RelatedProduct No errors.
App\Entity\ReviewsProduct No errors.
App\Entity\Tag No errors.
App\Entity\Colors No errors.
App\Entity\Size No errors.
App\Entity\User No errors.
App\Entity\Emballage No errors.
App\Entity\PriceInterval No errors.
App\Entity\Order No errors.
App\Entity\Historique No errors.
App\Entity\OrderDetails No errors.