Symfony Profiler

SELECT
  DISTINCT s0_.id AS id_0,
  s0_.vendor AS vendor_1,
  s0_.model_seria AS model_seria_2,
  s0_.car AS car_3,
  s0_.year AS year_4,
  s0_.modification AS modification_5,
  s0_.param_pcd AS param_pcd_6,
  s0_.param_dia AS param_dia_7,
  s0_.param_nut AS param_nut_8,
  s0_.param_bolt AS param_bolt_9,
  s0_.tyres_factory AS tyres_factory_10,
  s0_.tyres_replace AS tyres_replace_11,
  s0_.tyres_tuning AS tyres_tuning_12,
  s0_.wheels_factory AS wheels_factory_13,
  s0_.wheels_replace AS wheels_replace_14,
  s0_.wheels_tuning AS wheels_tuning_15
FROM
  search_by_vehicle s0_
WHERE
  s0_.vendor = ?
  AND s0_.car = ?
  AND s0_.year = ?
  AND s0_.modification = ?

SELECT DISTINCT s0_.id AS id_0, s0_.vendor AS vendor_1, s0_.model_seria AS model_seria_2, s0_.car AS car_3, s0_.year AS year_4, s0_.modification AS modification_5, s0_.param_pcd AS param_pcd_6, s0_.param_dia AS param_dia_7, s0_.param_nut AS param_nut_8, s0_.param_bolt AS param_bolt_9, s0_.tyres_factory AS tyres_factory_10, s0_.tyres_replace AS tyres_replace_11, s0_.tyres_tuning AS tyres_tuning_12, s0_.wheels_factory AS wheels_factory_13, s0_.wheels_replace AS wheels_replace_14, s0_.wheels_tuning AS wheels_tuning_15 FROM search_by_vehicle s0_ WHERE s0_.vendor = 'Subaru' AND s0_.car = 'Legacy' AND s0_.year = '1998' AND s0_.modification = '2.5i';

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  product p0_
  LEFT JOIN rest r1_ ON p0_.id = r1_.product_id
  AND (r1_.town = ?)
  LEFT JOIN vendor_priority v2_ ON (
    LOWER(v2_.vendor) = LOWER(p0_.vendor)
  )
  LEFT JOIN vendor_priority v3_ ON (
    LOWER(v3_.vendor) = LOWER(p0_.vendor || ' ' || p0_.model)
  )
WHERE
  (
    (
      p0_.width = ?
      AND p0_.height = ?
      AND p0_.design = ?
      AND p0_.diameter = ?
    )
    AND (p0_.available = true)
  )
  AND p0_.p_type IN ('1')
GROUP BY
  p0_.id,
  v2_.priority,
  v3_.priority

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN rest r1_ ON p0_.id = r1_.product_id AND (r1_.town = 'www') LEFT JOIN vendor_priority v2_ ON (LOWER(v2_.vendor) = LOWER(p0_.vendor)) LEFT JOIN vendor_priority v3_ ON (LOWER(v3_.vendor) = LOWER(p0_.vendor || ' ' || p0_.model)) WHERE ((p0_.width = '225' AND p0_.height = '45' AND p0_.design = 'R' AND p0_.diameter = '16') AND (p0_.available=true)) AND p0_.p_type IN ('1') GROUP BY p0_.id, v2_.priority, v3_.priority;

SELECT
  DISTINCT p0_.id AS id_0,
  MAX(
    CASE WHEN r1_.count IS NULL THEN 0 ELSE 1 END
  ) AS sclr_1,
  COALESCE(v2_.priority, 99999) AS sclr_2,
  COALESCE(v3_.priority, 99999) AS sclr_3,
  p0_.vendor AS vendor_4,
  p0_.model AS model_5
FROM
  product p0_
  LEFT JOIN rest r1_ ON p0_.id = r1_.product_id
  AND (r1_.town = ?)
  LEFT JOIN vendor_priority v2_ ON (
    LOWER(v2_.vendor) = LOWER(p0_.vendor)
  )
  LEFT JOIN vendor_priority v3_ ON (
    LOWER(v3_.vendor) = LOWER(p0_.vendor || ' ' || p0_.model)
  )
WHERE
  (
    (
      p0_.width = ?
      AND p0_.height = ?
      AND p0_.design = ?
      AND p0_.diameter = ?
    )
    AND (p0_.available = true)
  )
  AND p0_.p_type IN ('1')
GROUP BY
  p0_.id,
  v2_.priority,
  v3_.priority
ORDER BY
  sclr_1 DESC,
  sclr_2 ASC,
  sclr_3 ASC,
  p0_.vendor ASC,
  p0_.model ASC
LIMIT
  5

SELECT DISTINCT p0_.id AS id_0, MAX(CASE WHEN r1_.count IS NULL THEN 0 ELSE 1 END) AS sclr_1, COALESCE(v2_.priority, 99999) AS sclr_2, COALESCE(v3_.priority, 99999) AS sclr_3, p0_.vendor AS vendor_4, p0_.model AS model_5 FROM product p0_ LEFT JOIN rest r1_ ON p0_.id = r1_.product_id AND (r1_.town = 'www') LEFT JOIN vendor_priority v2_ ON (LOWER(v2_.vendor) = LOWER(p0_.vendor)) LEFT JOIN vendor_priority v3_ ON (LOWER(v3_.vendor) = LOWER(p0_.vendor || ' ' || p0_.model)) WHERE ((p0_.width = '225' AND p0_.height = '45' AND p0_.design = 'R' AND p0_.diameter = '16') AND (p0_.available=true)) AND p0_.p_type IN ('1') GROUP BY p0_.id, v2_.priority, v3_.priority ORDER BY sclr_1 DESC, sclr_2 ASC, sclr_3 ASC, p0_.vendor ASC, p0_.model ASC LIMIT 5;

SELECT
  count(DISTINCT p0_.id) AS sclr_0
FROM
  product p0_
  LEFT JOIN rest r1_ ON p0_.id = r1_.product_id
  AND (r1_.town = ?)
  LEFT JOIN vendor_priority v2_ ON (
    LOWER(v2_.vendor) = LOWER(p0_.vendor)
  )
  LEFT JOIN vendor_priority v3_ ON (
    LOWER(v3_.vendor) = LOWER(p0_.vendor || ' ' || p0_.model)
  )
WHERE
  (
    (
      p0_.width = ?
      AND p0_.diameter = ?
      AND p0_.et = ?
      AND p0_.calculated_pcd = ?
      AND p0_.hole >= ?
    )
    AND (p0_.available = true)
  )
  AND p0_.p_type IN ('2')
GROUP BY
  p0_.id,
  v2_.priority,
  v3_.priority

SELECT count(DISTINCT p0_.id) AS sclr_0 FROM product p0_ LEFT JOIN rest r1_ ON p0_.id = r1_.product_id AND (r1_.town = 'www') LEFT JOIN vendor_priority v2_ ON (LOWER(v2_.vendor) = LOWER(p0_.vendor)) LEFT JOIN vendor_priority v3_ ON (LOWER(v3_.vendor) = LOWER(p0_.vendor || ' ' || p0_.model)) WHERE ((p0_.width = '6' AND p0_.diameter = '15' AND p0_.et = '48' AND p0_.calculated_pcd = '5 x 100' AND p0_.hole >= '56.1') AND (p0_.available=true)) AND p0_.p_type IN ('2') GROUP BY p0_.id, v2_.priority, v3_.priority;

SELECT
  DISTINCT p0_.id AS id_0,
  MAX(
    CASE WHEN r1_.count IS NULL THEN 0 ELSE 1 END
  ) AS sclr_1,
  COALESCE(v2_.priority, 99999) AS sclr_2,
  COALESCE(v3_.priority, 99999) AS sclr_3,
  p0_.vendor AS vendor_4,
  p0_.model AS model_5
FROM
  product p0_
  LEFT JOIN rest r1_ ON p0_.id = r1_.product_id
  AND (r1_.town = ?)
  LEFT JOIN vendor_priority v2_ ON (
    LOWER(v2_.vendor) = LOWER(p0_.vendor)
  )
  LEFT JOIN vendor_priority v3_ ON (
    LOWER(v3_.vendor) = LOWER(p0_.vendor || ' ' || p0_.model)
  )
WHERE
  (
    (
      p0_.width = ?
      AND p0_.diameter = ?
      AND p0_.et = ?
      AND p0_.calculated_pcd = ?
      AND p0_.hole >= ?
    )
    AND (p0_.available = true)
  )
  AND p0_.p_type IN ('2')
GROUP BY
  p0_.id,
  v2_.priority,
  v3_.priority
ORDER BY
  sclr_1 DESC,
  sclr_2 ASC,
  sclr_3 ASC,
  p0_.vendor ASC,
  p0_.model ASC
LIMIT
  5

SELECT DISTINCT p0_.id AS id_0, MAX(CASE WHEN r1_.count IS NULL THEN 0 ELSE 1 END) AS sclr_1, COALESCE(v2_.priority, 99999) AS sclr_2, COALESCE(v3_.priority, 99999) AS sclr_3, p0_.vendor AS vendor_4, p0_.model AS model_5 FROM product p0_ LEFT JOIN rest r1_ ON p0_.id = r1_.product_id AND (r1_.town = 'www') LEFT JOIN vendor_priority v2_ ON (LOWER(v2_.vendor) = LOWER(p0_.vendor)) LEFT JOIN vendor_priority v3_ ON (LOWER(v3_.vendor) = LOWER(p0_.vendor || ' ' || p0_.model)) WHERE ((p0_.width = '6' AND p0_.diameter = '15' AND p0_.et = '48' AND p0_.calculated_pcd = '5 x 100' AND p0_.hole >= '56.1') AND (p0_.available=true)) AND p0_.p_type IN ('2') GROUP BY p0_.id, v2_.priority, v3_.priority ORDER BY sclr_1 DESC, sclr_2 ASC, sclr_3 ASC, p0_.vendor ASC, p0_.model ASC LIMIT 5;

SELECT
  t0.id AS id_1,
  t0.town AS town_2,
  t0.name AS name_3,
  t0.seo_name AS seo_name_4
FROM
  town t0
WHERE
  t0.town = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.town AS town_2, t0.name AS name_3, t0.seo_name AS seo_name_4 FROM town t0 WHERE t0.town = 'www' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.town AS town_2,
  t0.name AS name_3,
  t0.seo_name AS seo_name_4
FROM
  town t0
WHERE
  t0.town = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.town AS town_2, t0.name AS name_3, t0.seo_name AS seo_name_4 FROM town t0 WHERE t0.town = 'www' LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_.town AS town_1,
  t0_.name AS name_2,
  t0_.seo_name AS seo_name_3
FROM
  town t0_
ORDER BY
  t0_.id ASC

SELECT t0_.id AS id_0, t0_.town AS town_1, t0_.name AS name_2, t0_.seo_name AS seo_name_3 FROM town t0_ ORDER BY t0_.id ASC;