https://importexport.afisarl.com/tags%237-shoes

Query Metrics

21 Database Queries
8 Different statements
4.42 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.78 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.more_information AS more_information_3, p0_.price AS price_4, p0_.is_best_seller AS is_best_seller_5, p0_.is_new_arrival AS is_new_arrival_6, p0_.is_featured AS is_featured_7, p0_.is_special_offer AS is_special_offer_8, p0_.image AS image_9, p0_.quantity AS quantity_10, p0_.created_at AS created_at_11, p0_.tags AS tags_12, p0_.slug AS slug_13, p0_.is_promotional_price AS is_promotional_price_14, p0_.promotional_price AS promotional_price_15, p0_.pourcentage_promotional_price AS pourcentage_promotional_price_16, p0_.etat AS etat_17, p0_.nombre_vue AS nombre_vue_18, p0_.poid_net AS poid_net_19, p0_.longueur AS longueur_20, p0_.largeur AS largeur_21, p0_.hauteur AS hauteur_22, p0_.min_commande AS min_commande_23, p0_.piece_in_package AS piece_in_package_24, p0_.image_de_specification AS image_de_specification_25, p0_.max_price AS max_price_26, p0_.max_commande AS max_commande_27, p0_.user_id AS user_id_28 FROM product p0_ INNER JOIN product_tag p2_ ON p0_.id = p2_.product_id INNER JOIN tag t1_ ON t1_.id = p2_.tag_id WHERE t1_.id = ?
Parameters:
[
  "7"
]
2 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.image AS image_4 FROM tag t0
Parameters:
[]
3 0.38 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:
[]
4 0.14 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.hexadecimal AS hexadecimal_2 FROM colors c0_
Parameters:
[]
5 0.18 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:
[]
6 0.15 ms
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.icon AS icon_2, t0_.image AS image_3 FROM tag t0_
Parameters:
[]
7 0.32 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:
[
  9
]
8 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.hexadecimal AS hexadecimal_3 FROM colors t0 INNER JOIN product_colors ON t0.id = product_colors.colors_id WHERE product_colors.product_id = ?
Parameters:
[
  9
]
9 0.14 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:
[
  10
]
10 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.hexadecimal AS hexadecimal_3 FROM colors t0 INNER JOIN product_colors ON t0.id = product_colors.colors_id WHERE product_colors.product_id = ?
Parameters:
[
  10
]
11 0.16 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:
[
  12
]
12 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.hexadecimal AS hexadecimal_3 FROM colors t0 INNER JOIN product_colors ON t0.id = product_colors.colors_id WHERE product_colors.product_id = ?
Parameters:
[
  12
]
13 0.14 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:
[
  13
]
14 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.hexadecimal AS hexadecimal_3 FROM colors t0 INNER JOIN product_colors ON t0.id = product_colors.colors_id WHERE product_colors.product_id = ?
Parameters:
[
  13
]
15 0.13 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:
[
  14
]
16 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.hexadecimal AS hexadecimal_3 FROM colors t0 INNER JOIN product_colors ON t0.id = product_colors.colors_id WHERE product_colors.product_id = ?
Parameters:
[
  14
]
17 0.13 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:
[
  41
]
18 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.hexadecimal AS hexadecimal_3 FROM colors t0 INNER JOIN product_colors ON t0.id = product_colors.colors_id WHERE product_colors.product_id = ?
Parameters:
[
  41
]
19 0.15 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:
[
  75
]
20 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.hexadecimal AS hexadecimal_3 FROM colors t0 INNER JOIN product_colors ON t0.id = product_colors.colors_id WHERE product_colors.product_id = ?
Parameters:
[
  75
]
21 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.image AS image_4 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\Tag No errors.
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\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.