https://afisarl.com/product/calvinkein-underwear-for-men-zb12

Query Metrics

14 Database Queries
14 Different statements
4.06 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.77 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 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "calvinkein-underwear-for-men-zb12"
]
2 0.20 ms
"START TRANSACTION"
Parameters:
[]
3 0.36 ms
UPDATE product SET nombre_vue = ? WHERE id = ?
Parameters:
[
  343
  15
]
4 0.12 ms
"COMMIT"
Parameters:
[]
5 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:
[]
6 0.23 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.hexadecimal AS hexadecimal_2 FROM colors c0_
Parameters:
[]
7 0.23 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:
[]
8 0.24 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:
[]
9 0.28 ms
SELECT t0.id AS id_1, t0.title AS title_2, t0.image AS image_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.is_visible AS is_visible_6, t0.product_id AS product_id_7 FROM product_images t0 WHERE t0.product_id = ?
Parameters:
[
  15
]
10 0.23 ms
SELECT t0.id AS id_1, t0.note AS note_2, t0.comment AS comment_3, t0.created_at AS created_at_4, t0.user_id AS user_id_5, t0.product_id AS product_id_6 FROM reviews_product t0 WHERE t0.product_id = ?
Parameters:
[
  15
]
11 0.27 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 INNER JOIN product_categories ON t0.id = product_categories.categories_id WHERE product_categories.product_id = ?
Parameters:
[
  15
]
12 0.25 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 INNER JOIN product_tag ON t0.id = product_tag.tag_id WHERE product_tag.product_id = ?
Parameters:
[
  15
]
13 0.39 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:
[
  6
]
14 0.21 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\Product
  • The association App\Entity\Product#user refers to the inverse side field App\Entity\User#products which does not exist.
App\Entity\User No errors.
App\Entity\Shop No errors.
App\Entity\ProductImages No errors.
App\Entity\Categories 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\Emballage No errors.
App\Entity\PriceInterval No errors.
App\Entity\Order No errors.
App\Entity\Historique No errors.
App\Entity\Mymarket No errors.
App\Entity\OrderDetails No errors.