GET https://info-tintamarreandco.com/produits?page=53

Query Metrics

23 Database Queries
9 Different statements
5.93 ms Query time
1 Invalid entities
44 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.62 ms
(44.21%)
15
SELECT t0.id AS id_1, t0.quantity_in_stock AS quantity_in_stock_2, t0.product_id AS product_id_3, t0.size_id AS size_id_4 FROM product_size t0 WHERE t0.product_id = ?
Parameters:
[
  b"\x01š“µðX|p•cæ¾Gƒ„ð"
]
0.96 ms
(16.23%)
1
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.product_code AS product_code_1, p0_.product_name AS product_name_2, p0_.description AS description_3, p0_.item_code AS item_code_4, p0_.image_filename AS image_filename_5, p0_.is_clearance AS is_clearance_6, p0_.slug AS slug_7, p0_.stock AS stock_8, p0_.price AS price_9, p0_.other_product_specification AS other_product_specification_10, p0_.created_at AS created_at_11, p0_.is_in_selection AS is_in_selection_12 FROM product p0_) dctrn_result) dctrn_table
Parameters:
[]
0.58 ms
(9.70%)
1
SELECT count(p0_.id) AS sclr_0 FROM product p0_
Parameters:
[]
0.51 ms
(8.58%)
1
SELECT DISTINCT id_0 FROM (SELECT p0_.id AS id_0, p0_.product_code AS product_code_1, p0_.product_name AS product_name_2, p0_.description AS description_3, p0_.item_code AS item_code_4, p0_.image_filename AS image_filename_5, p0_.is_clearance AS is_clearance_6, p0_.slug AS slug_7, p0_.stock AS stock_8, p0_.price AS price_9, p0_.other_product_specification AS other_product_specification_10, p0_.created_at AS created_at_11, p0_.is_in_selection AS is_in_selection_12 FROM product p0_) dctrn_result LIMIT 15 OFFSET 780
Parameters:
[]
0.40 ms
(6.78%)
1
SELECT p0_.id AS id_0, p0_.product_code AS product_code_1, p0_.product_name AS product_name_2, p0_.description AS description_3, p0_.item_code AS item_code_4, p0_.image_filename AS image_filename_5, p0_.is_clearance AS is_clearance_6, p0_.slug AS slug_7, p0_.stock AS stock_8, p0_.price AS price_9, p0_.other_product_specification AS other_product_specification_10, p0_.created_at AS created_at_11, p0_.is_in_selection AS is_in_selection_12, p0_.category_id AS category_id_13, p0_.supplier_id AS supplier_id_14 FROM product p0_ WHERE p0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  b"\x01š“µðX|p•cæ¾Gƒ„ð"
  b"\x01š“µðY}hˆ9_Îø$ü\x15"
  b"\x01š“µðY}hˆ9_Îø{â"
  b"\x01š“µðZp¹†#UaXª²¢"
  b"\x01š“µðZp¹†#UaXР>"
  b"\x01š“µð[yc¾\x06†!3Êu"
  b"\x01š“µð[yc¾\x06†!46BÑ"
  b"\x01š“µð\q°¦ÌFßï½äa"
  b"\x01š“µð]ufŠ\x19¬×¥°r\x02"
  b"\x01š“µð]ufŠ\x19¬×¥¹(l"
  b"\x01š“µð^}\x0E¾e·p—÷jU"
  b"\x01š“µð^}\x0E¾e·p˜‡ZO"
  b"\x01š“µð_xÄ‘²¤¦1cúâ"
  b"\x01š“µð_xÄ‘²¤¦1âóY"
  b"\x01š“µð`v¨¯>ùô ïjA"
]
0.27 ms
(4.57%)
1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.slug AS slug_3, c0_.image AS image_4, c0_.banner AS banner_5, c0_.parent_id AS parent_id_6 FROM category c0_ WHERE c0_.parent_id IS NULL
Parameters:
[]
0.22 ms
(3.63%)
1
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.description AS description_2, c0_.slug AS slug_3, c0_.image AS image_4, c0_.banner AS banner_5, c0_.parent_id AS parent_id_6 FROM category c0_ WHERE c0_.parent_id IS NOT NULL
Parameters:
[]
0.19 ms
(3.27%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.logo AS logo_4 FROM brand t0
Parameters:
[]
0.18 ms
(3.02%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.illustration AS illustration_3, t0.slug AS slug_4, t0.banner AS banner_5 FROM job 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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Category 18
App\Entity\Product 15
App\Entity\Brand 6
App\Entity\Job 4
App\Entity\Supplier 1

Entities Mapping

Class Mapping errors
App\Entity\Product
  • The association App\Entity\Product#supplier refers to the inverse side field App\Entity\Supplier#products which does not exist.
App\Entity\Category No errors.
App\Entity\Job No errors.
App\Entity\Brand No errors.
App\Entity\Supplier No errors.
App\Entity\ProductSize No errors.
App\Entity\Size No errors.