302 redirect from GET @brand (842eaa)

GET https://test.mopo.fr/search_results

Query Metrics

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

Queries

Group similar statements

# Time Info
1 0.74 ms
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:
[]
2 0.23 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
Parameters:
[]
3 1.24 ms
SELECT count(DISTINCT p0_.id) AS sclr_0 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 MIN(i5_.id) AS sclr_1 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 AND b4_.id = ?
Parameters:
[
  4
]
4 0.58 ms
SELECT DISTINCT p0_.id AS id_0 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 MIN(i5_.id) AS sclr_1 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 AND b4_.id = ? LIMIT 12
Parameters:
[
  4
]
5 0.34 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:
[]
6 0.25 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
]
7 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
]
8 0.21 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
]
9 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:
[
  4
]
10 0.12 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:
[]

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.