GET https://test.mopo.fr/

Query Metrics

12 Database Queries
6 Different statements
1.80 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.69 ms
(38.71%)
3
SELECT b0_.id AS id_0, b0_.brand_name AS brand_name_1, b0_.brand_logo_id AS brand_logo_id_2 FROM brand b0_ INNER JOIN brand_logo b1_ ON b0_.brand_logo_id = b1_.id
Parameters:
[]
0.37 ms
(20.77%)
4
SELECT t0.id AS id_1, t0.brand_logo_image AS brand_logo_image_2 FROM brand_logo t0 WHERE t0.id = ?
Parameters:
[
  2
]
0.25 ms
(13.69%)
2
SELECT t0.id AS id_1, t0.condition_title AS condition_title_2 FROM `condition` t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.20 ms
(11.19%)
1
SELECT t0.id AS id_1, t0.brand_name AS brand_name_2, t0.brand_logo_id AS brand_logo_id_3 FROM brand t0
Parameters:
[]
0.17 ms
(9.52%)
1
SELECT p0_.id AS id_0, p0_.product_reference AS product_reference_1, p0_.product_name AS product_name_2, p0_.product_description AS product_description_3, p0_.product_price AS product_price_4, p0_.product_quantity AS product_quantity_5, p0_.product_added_date AS product_added_date_6, p0_.product_year AS product_year_7, p0_.product_km AS product_km_8, p0_.product_weight AS product_weight_9, i1_.id AS id_10, i1_.image_name AS image_name_11, p0_.product_condition_id AS product_condition_id_12, p0_.product_category_id AS product_category_id_13, p0_.product_model_id AS product_model_id_14, i1_.image_product_id AS image_product_id_15 FROM product p0_ LEFT JOIN image i1_ ON p0_.id = i1_.image_product_id INNER JOIN `condition` c2_ ON p0_.product_condition_id = c2_.id INNER JOIN model m3_ ON p0_.product_model_id = m3_.id INNER JOIN brand b4_ ON m3_.model_brand_id = b4_.id WHERE (i1_.id IN (SELECT MAX(i5_.id) AS sclr_16 FROM product p6_ LEFT JOIN image i5_ ON p6_.id = i5_.image_product_id WHERE i5_.image_product_id = p0_.id) OR i1_.id IS NULL) AND p0_.product_quantity > 0 ORDER BY p0_.product_added_date DESC LIMIT 6
Parameters:
[]
0.11 ms
(6.12%)
1
SELECT t0.id AS id_1, t0.model_name AS model_name_2, t0.model_brand_id AS model_brand_id_3 FROM model 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\Brand No errors.
App\Entity\BrandLogo No errors.
App\Entity\Model No errors.
App\Entity\Product No errors.
App\Entity\Image No errors.
App\Entity\Condition No errors.
App\Entity\Category No errors.
App\Entity\OrderItem No errors.
App\Entity\Tag No errors.