Symfony Profiler

SELECT
  DISTINCT p0_.id AS id_0
FROM
  product p0_
  LEFT JOIN product_type p1_ ON p0_.product_type_id = p1_.id
  LEFT JOIN product_subtype p2_ ON p0_.product_subtype_id = p2_.id
  LEFT JOIN temp_control t3_ ON p0_.temp_control_id = t3_.id
  LEFT JOIN power_source p4_ ON p0_.power_source_id = p4_.id
  LEFT JOIN product_available_countries p6_ ON p0_.id = p6_.product_id
  LEFT JOIN country c5_ ON c5_.id = p6_.country_id
WHERE
  c5_.code IN (?)
LIMIT
  9

SELECT DISTINCT p0_.id AS id_0 FROM product p0_ LEFT JOIN product_type p1_ ON p0_.product_type_id = p1_.id LEFT JOIN product_subtype p2_ ON p0_.product_subtype_id = p2_.id LEFT JOIN temp_control t3_ ON p0_.temp_control_id = t3_.id LEFT JOIN power_source p4_ ON p0_.power_source_id = p4_.id LEFT JOIN product_available_countries p6_ ON p0_.id = p6_.product_id LEFT JOIN country c5_ ON c5_.id = p6_.country_id WHERE c5_.code IN (NULL) LIMIT 9;

SELECT
  DISTINCT p0_.id AS id_0
FROM
  product p0_
  LEFT JOIN product_type p1_ ON p0_.product_type_id = p1_.id
  LEFT JOIN product_subtype p2_ ON p0_.product_subtype_id = p2_.id
  LEFT JOIN temp_control t3_ ON p0_.temp_control_id = t3_.id
  LEFT JOIN power_source p4_ ON p0_.power_source_id = p4_.id
  LEFT JOIN product_available_countries p6_ ON p0_.id = p6_.product_id
  LEFT JOIN country c5_ ON c5_.id = p6_.country_id

SELECT DISTINCT p0_.id AS id_0 FROM product p0_ LEFT JOIN product_type p1_ ON p0_.product_type_id = p1_.id LEFT JOIN product_subtype p2_ ON p0_.product_subtype_id = p2_.id LEFT JOIN temp_control t3_ ON p0_.temp_control_id = t3_.id LEFT JOIN power_source p4_ ON p0_.power_source_id = p4_.id LEFT JOIN product_available_countries p6_ ON p0_.id = p6_.product_id LEFT JOIN country c5_ ON c5_.id = p6_.country_id;

SELECT
  p0_.id AS id_0,
  p0_.product_key AS product_key_1,
  p0_.name AS name_2,
  p0_.description AS description_3,
  p0_.image AS image_4,
  p0_.pharma_certified AS pharma_certified_5,
  p0_.product_detail AS product_detail_6,
  p0_.slug AS slug_7,
  p0_.created_at AS created_at_8,
  p0_.updated_at AS updated_at_9,
  p1_.id AS id_10,
  p1_.name AS name_11,
  p1_.slug AS slug_12,
  p2_.id AS id_13,
  p2_.name AS name_14,
  p2_.slug AS slug_15,
  t3_.id AS id_16,
  t3_.name AS name_17,
  t3_.slug AS slug_18,
  p4_.id AS id_19,
  p4_.name AS name_20,
  p4_.slug AS slug_21,
  c5_.id AS id_22,
  c5_.code AS code_23,
  c5_.name AS name_24,
  p0_.product_type_id AS product_type_id_25,
  p0_.product_subtype_id AS product_subtype_id_26,
  p0_.temp_control_id AS temp_control_id_27,
  p0_.power_source_id AS power_source_id_28,
  p2_.product_type_id AS product_type_id_29
FROM
  product p0_
  LEFT JOIN product_type p1_ ON p0_.product_type_id = p1_.id
  LEFT JOIN product_subtype p2_ ON p0_.product_subtype_id = p2_.id
  LEFT JOIN temp_control t3_ ON p0_.temp_control_id = t3_.id
  LEFT JOIN power_source p4_ ON p0_.power_source_id = p4_.id
  LEFT JOIN product_available_countries p6_ ON p0_.id = p6_.product_id
  LEFT JOIN country c5_ ON c5_.id = p6_.country_id
WHERE
  p0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.product_key AS product_key_1, p0_.name AS name_2, p0_.description AS description_3, p0_.image AS image_4, p0_.pharma_certified AS pharma_certified_5, p0_.product_detail AS product_detail_6, p0_.slug AS slug_7, p0_.created_at AS created_at_8, p0_.updated_at AS updated_at_9, p1_.id AS id_10, p1_.name AS name_11, p1_.slug AS slug_12, p2_.id AS id_13, p2_.name AS name_14, p2_.slug AS slug_15, t3_.id AS id_16, t3_.name AS name_17, t3_.slug AS slug_18, p4_.id AS id_19, p4_.name AS name_20, p4_.slug AS slug_21, c5_.id AS id_22, c5_.code AS code_23, c5_.name AS name_24, p0_.product_type_id AS product_type_id_25, p0_.product_subtype_id AS product_subtype_id_26, p0_.temp_control_id AS temp_control_id_27, p0_.power_source_id AS power_source_id_28, p2_.product_type_id AS product_type_id_29 FROM product p0_ LEFT JOIN product_type p1_ ON p0_.product_type_id = p1_.id LEFT JOIN product_subtype p2_ ON p0_.product_subtype_id = p2_.id LEFT JOIN temp_control t3_ ON p0_.temp_control_id = t3_.id LEFT JOIN power_source p4_ ON p0_.power_source_id = p4_.id LEFT JOIN product_available_countries p6_ ON p0_.id = p6_.product_id LEFT JOIN country c5_ ON c5_.id = p6_.country_id WHERE p0_.id IN (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40) ORDER BY p0_.name ASC;

SELECT
  DISTINCT p0_.product_detail AS product_detail_0
FROM
  product p0_
WHERE
  p0_.product_detail IS NOT NULL
  AND p0_.product_detail <> ''
ORDER BY
  p0_.product_detail ASC

SELECT DISTINCT p0_.product_detail AS product_detail_0 FROM product p0_ WHERE p0_.product_detail IS NOT NULL AND p0_.product_detail <> '' ORDER BY p0_.product_detail ASC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.name AS name_3
FROM
  country t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3 FROM country t0 ORDER BY t0.name ASC;

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.slug AS slug_2,
  p1_.id AS id_3,
  p1_.name AS name_4,
  p1_.slug AS slug_5,
  p1_.product_type_id AS product_type_id_6
FROM
  product_type p0_
  LEFT JOIN product_subtype p1_ ON p0_.id = p1_.product_type_id
ORDER BY
  p0_.name ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p1_.id AS id_3, p1_.name AS name_4, p1_.slug AS slug_5, p1_.product_type_id AS product_type_id_6 FROM product_type p0_ LEFT JOIN product_subtype p1_ ON p0_.id = p1_.product_type_id ORDER BY p0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  temp_control t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM temp_control t0 ORDER BY t0.name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3
FROM
  power_source t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM power_source t0 ORDER BY t0.name ASC;

SELECT
  p0_.slug AS slug_0,
  p1_.slug AS slug_1,
  p2_.product_detail AS product_detail_2,
  t3_.slug AS slug_3,
  p4_.slug AS slug_4
FROM
  product p2_
  LEFT JOIN product_type p0_ ON p2_.product_type_id = p0_.id
  LEFT JOIN product_subtype p1_ ON p2_.product_subtype_id = p1_.id
  LEFT JOIN temp_control t3_ ON p2_.temp_control_id = t3_.id
  LEFT JOIN power_source p4_ ON p2_.power_source_id = p4_.id

SELECT p0_.slug AS slug_0, p1_.slug AS slug_1, p2_.product_detail AS product_detail_2, t3_.slug AS slug_3, p4_.slug AS slug_4 FROM product p2_ LEFT JOIN product_type p0_ ON p2_.product_type_id = p0_.id LEFT JOIN product_subtype p1_ ON p2_.product_subtype_id = p1_.id LEFT JOIN temp_control t3_ ON p2_.temp_control_id = t3_.id LEFT JOIN power_source p4_ ON p2_.power_source_id = p4_.id;