Symfony Profiler

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

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;

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

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;

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 = ?

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 = 3;

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

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 = 3 LIMIT 12;

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,
  c2_.id AS id_12,
  c2_.condition_title AS condition_title_13,
  p0_.product_condition_id AS product_condition_id_14,
  p0_.product_category_id AS product_category_id_15,
  p0_.product_model_id AS product_model_id_16,
  i1_.image_product_id AS image_product_id_17
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_18
      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 = ?
  AND p0_.id IN (?, ?, ?, ?)

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, c2_.id AS id_12, c2_.condition_title AS condition_title_13, p0_.product_condition_id AS product_condition_id_14, p0_.product_category_id AS product_category_id_15, p0_.product_model_id AS product_model_id_16, i1_.image_product_id AS image_product_id_17 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_18 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 = 3 AND p0_.id IN (7, 8, 9, 10);

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

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;

SELECT
  t0.id AS id_1,
  t0.brand_logo_image AS brand_logo_image_2
FROM
  brand_logo t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.brand_logo_image AS brand_logo_image_2 FROM brand_logo t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.brand_logo_image AS brand_logo_image_2
FROM
  brand_logo t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.brand_logo_image AS brand_logo_image_2 FROM brand_logo t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.brand_logo_image AS brand_logo_image_2
FROM
  brand_logo t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.brand_logo_image AS brand_logo_image_2 FROM brand_logo t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.brand_logo_image AS brand_logo_image_2
FROM
  brand_logo t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.brand_logo_image AS brand_logo_image_2 FROM brand_logo t0 WHERE t0.id = 4;

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

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;