GET https://test.mopo.fr/product_details/8

Query Metrics

10 Database Queries
6 Different statements
1.87 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.77 ms
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, p0_.product_condition_id AS product_condition_id_10, p0_.product_category_id AS product_category_id_11, p0_.product_model_id AS product_model_id_12 FROM product p0_ INNER JOIN `condition` c1_ ON p0_.product_condition_id = c1_.id INNER JOIN model m2_ ON p0_.product_model_id = m2_.id INNER JOIN brand b3_ ON m2_.model_brand_id = b3_.id WHERE p0_.id = ?
Parameters:
[
  8
]
2 0.33 ms
SELECT i0_.id AS id_0, i0_.image_name AS image_name_1, i0_.image_product_id AS image_product_id_2 FROM image i0_ WHERE i0_.image_product_id = ? ORDER BY i0_.id ASC
Parameters:
[
  8
]
3 0.17 ms
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:
[]
4 0.13 ms
SELECT t0.id AS id_1, t0.brand_logo_image AS brand_logo_image_2 FROM brand_logo t0 WHERE t0.id = ?
Parameters:
[
  2
]
5 0.10 ms
SELECT t0.id AS id_1, t0.brand_logo_image AS brand_logo_image_2 FROM brand_logo t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.07 ms
SELECT t0.id AS id_1, t0.brand_logo_image AS brand_logo_image_2 FROM brand_logo t0 WHERE t0.id = ?
Parameters:
[
  3
]
7 0.07 ms
SELECT t0.id AS id_1, t0.brand_logo_image AS brand_logo_image_2 FROM brand_logo t0 WHERE t0.id = ?
Parameters:
[
  4
]
8 0.09 ms
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:
[]
9 0.09 ms
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 WHERE t0.id = ?
Parameters:
[
  13
]
10 0.07 ms
SELECT t0.id AS id_1, t0.condition_title AS condition_title_2 FROM `condition` t0 WHERE t0.id = ?
Parameters:
[
  3
]

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 No errors.
App\Entity\Condition No errors.
App\Entity\Model No errors.
App\Entity\Brand No errors.
App\Entity\Category No errors.
App\Entity\OrderItem No errors.
App\Entity\Image No errors.
App\Entity\Tag No errors.
App\Entity\BrandLogo No errors.