Symfony Profiler

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_.calculated_price BETWEEN ?
      AND ?
    )
    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 = 'penza') 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_.calculated_price BETWEEN 1500 AND 162270) 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_.calculated_price BETWEEN ?
      AND ?
    )
    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
  32

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 = 'penza') 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_.calculated_price BETWEEN 1500 AND 162270) 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 32;

SELECT
  p0_.id AS id_0,
  p0_.vendor AS vendor_1,
  p0_.model AS model_2,
  p0_.image AS image_3,
  p0_.image_name_opt AS image_name_opt_4,
  p0_.sale AS sale_5,
  p0_.hit AS hit_6,
  p0_.weight AS weight_7,
  p0_.width AS width_8,
  p0_.diameter AS diameter_9,
  p0_.int_code AS int_code_10,
  p0_.vendor_code AS vendor_code_11,
  p0_.updated_at AS updated_at_12,
  p0_.available AS available_13,
  p0_.calculated_price AS calculated_price_14,
  p0_.calculated_price_ext AS calculated_price_ext_15,
  p0_.calculated_external AS calculated_external_16,
  p0_.season AS season_17,
  p0_.studded AS studded_18,
  p0_.height AS height_19,
  p0_."load" AS load_20,
  p0_.speed AS speed_21,
  p0_.design AS design_22,
  p0_.runflat AS runflat_23,
  p0_.usa AS usa_24,
  p0_.screws AS screws_25,
  p0_.hole AS hole_26,
  p0_.pcd AS pcd_27,
  p0_.et AS et_28,
  p0_.color AS color_29,
  p0_.stamped AS stamped_30,
  p0_.calculated_pcd AS calculated_pcd_31,
  p0_.calculated_count AS calculated_count_32,
  p0_.slug AS slug_33,
  MAX(
    CASE WHEN r1_.count IS NULL THEN 0 ELSE 1 END
  ) AS sclr_34,
  COALESCE(v2_.priority, 99999) AS sclr_35,
  COALESCE(v3_.priority, 99999) AS sclr_36,
  p0_.p_type AS p_type_37
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_.calculated_price BETWEEN ?
      AND ?
      AND p0_.id IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?
      )
    )
    AND (p0_.available = true)
  )
  AND p0_.p_type IN ('1')
GROUP BY
  p0_.id,
  v2_.priority,
  v3_.priority
ORDER BY
  sclr_34 DESC,
  sclr_35 ASC,
  sclr_36 ASC,
  p0_.vendor ASC,
  p0_.model ASC

SELECT p0_.id AS id_0, p0_.vendor AS vendor_1, p0_.model AS model_2, p0_.image AS image_3, p0_.image_name_opt AS image_name_opt_4, p0_.sale AS sale_5, p0_.hit AS hit_6, p0_.weight AS weight_7, p0_.width AS width_8, p0_.diameter AS diameter_9, p0_.int_code AS int_code_10, p0_.vendor_code AS vendor_code_11, p0_.updated_at AS updated_at_12, p0_.available AS available_13, p0_.calculated_price AS calculated_price_14, p0_.calculated_price_ext AS calculated_price_ext_15, p0_.calculated_external AS calculated_external_16, p0_.season AS season_17, p0_.studded AS studded_18, p0_.height AS height_19, p0_."load" AS load_20, p0_.speed AS speed_21, p0_.design AS design_22, p0_.runflat AS runflat_23, p0_.usa AS usa_24, p0_.screws AS screws_25, p0_.hole AS hole_26, p0_.pcd AS pcd_27, p0_.et AS et_28, p0_.color AS color_29, p0_.stamped AS stamped_30, p0_.calculated_pcd AS calculated_pcd_31, p0_.calculated_count AS calculated_count_32, p0_.slug AS slug_33, MAX(CASE WHEN r1_.count IS NULL THEN 0 ELSE 1 END) AS sclr_34, COALESCE(v2_.priority, 99999) AS sclr_35, COALESCE(v3_.priority, 99999) AS sclr_36, p0_.p_type AS p_type_37 FROM product p0_ LEFT JOIN rest r1_ ON p0_.id = r1_.product_id AND (r1_.town = 'penza') 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_.calculated_price BETWEEN 1500 AND 162270 AND p0_.id IN ('S_[CORDIANT]_650852166', 'S_[CORDIANT]_650852668', 'S_[CORDIANT]_747289757', 'S_[CORDIANT]_1439292091', 'S_[CORDIANT]_16100050000', 'S_[CORDIANT]_481661926', 'S_[CORDIANT]_732076982', 'S_[CORDIANT]_366617266', 'S_[IKON TYRES (NOKIAN TYRES)]_T731443', 'S_[IKON TYRES (NOKIAN TYRES)]_T731453', 'S_[IKON TYRES (NOKIAN TYRES)]_TS72599', 'S_[IKON TYRES (NOKIAN TYRES)]_T429579', 'S_[IKON TYRES (NOKIAN TYRES)]_T732315', 'S_[IKON TYRES (NOKIAN TYRES)]_T732317', 'S_[IKON TYRES (NOKIAN TYRES)]_T732319', 'S_[IKON TYRES (NOKIAN TYRES)]_T732321', 'S_[IKON TYRES (NOKIAN TYRES)]_T732328', 'S_[IKON TYRES (NOKIAN TYRES)]_T732329', 'S_[IKON TYRES (NOKIAN TYRES)]_T732332', 'S_[IKON TYRES (NOKIAN TYRES)]_T732334', 'S_[ANTARES]_AB3311L', 'S_[DOUBLESTAR]_3PH01856514E000021', 'S_[DOUBLESTAR]_3PUZ2255518E000009', 'S_[FRONWAY]_04660232461794', 'S_[GISLAVED]_03150050000', 'S_[GISLAVED]_03150100000', 'S_[GISLAVED]_03150120000', 'S_[GOODRIDE]_CTS277547', 'S_[GOODRIDE]_CTS277619', 'S_[GOODRIDE]_CTS277742', 'S_[HANKOOK]_1025865', 'S_[HIFLY]_200H2048')) AND (p0_.available=true)) AND p0_.p_type IN ('1') GROUP BY p0_.id, v2_.priority, v3_.priority ORDER BY sclr_34 DESC, sclr_35 ASC, sclr_36 ASC, p0_.vendor ASC, p0_.model ASC;

SELECT
  p0_.id AS id_0,
  p0_.vendor AS vendor_1,
  p0_.model AS model_2,
  p0_.image AS image_3,
  p0_.image_name_opt AS image_name_opt_4,
  p0_.sale AS sale_5,
  p0_.hit AS hit_6,
  p0_.weight AS weight_7,
  p0_.width AS width_8,
  p0_.diameter AS diameter_9,
  p0_.int_code AS int_code_10,
  p0_.vendor_code AS vendor_code_11,
  p0_.updated_at AS updated_at_12,
  p0_.available AS available_13,
  p0_.calculated_price AS calculated_price_14,
  p0_.calculated_price_ext AS calculated_price_ext_15,
  p0_.calculated_external AS calculated_external_16,
  p0_.season AS season_17,
  p0_.studded AS studded_18,
  p0_.height AS height_19,
  p0_."load" AS load_20,
  p0_.speed AS speed_21,
  p0_.design AS design_22,
  p0_.runflat AS runflat_23,
  p0_.usa AS usa_24,
  p0_.screws AS screws_25,
  p0_.hole AS hole_26,
  p0_.pcd AS pcd_27,
  p0_.et AS et_28,
  p0_.color AS color_29,
  p0_.stamped AS stamped_30,
  p0_.calculated_pcd AS calculated_pcd_31,
  p0_.calculated_count AS calculated_count_32,
  p0_.slug AS slug_33,
  p0_.p_type AS p_type_34
FROM
  product p0_
WHERE
  (
    (p0_.sale = true)
    AND (p0_.available = true)
  )
  AND p0_.p_type IN ('1')

SELECT p0_.id AS id_0, p0_.vendor AS vendor_1, p0_.model AS model_2, p0_.image AS image_3, p0_.image_name_opt AS image_name_opt_4, p0_.sale AS sale_5, p0_.hit AS hit_6, p0_.weight AS weight_7, p0_.width AS width_8, p0_.diameter AS diameter_9, p0_.int_code AS int_code_10, p0_.vendor_code AS vendor_code_11, p0_.updated_at AS updated_at_12, p0_.available AS available_13, p0_.calculated_price AS calculated_price_14, p0_.calculated_price_ext AS calculated_price_ext_15, p0_.calculated_external AS calculated_external_16, p0_.season AS season_17, p0_.studded AS studded_18, p0_.height AS height_19, p0_."load" AS load_20, p0_.speed AS speed_21, p0_.design AS design_22, p0_.runflat AS runflat_23, p0_.usa AS usa_24, p0_.screws AS screws_25, p0_.hole AS hole_26, p0_.pcd AS pcd_27, p0_.et AS et_28, p0_.color AS color_29, p0_.stamped AS stamped_30, p0_.calculated_pcd AS calculated_pcd_31, p0_.calculated_count AS calculated_count_32, p0_.slug AS slug_33, p0_.p_type AS p_type_34 FROM product p0_ WHERE ((p0_.sale = true) AND (p0_.available=true)) AND p0_.p_type IN ('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 = 'penza' 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 = 'penza' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.external AS external_2,
  t0.price AS price_3,
  t0.town AS town_4,
  t0.count AS count_5,
  t0.product_id AS product_id_6,
  t0.store_id AS store_id_7
FROM
  rest t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.external AS external_2, t0.price AS price_3, t0.town AS town_4, t0.count AS count_5, t0.product_id AS product_id_6, t0.store_id AS store_id_7 FROM rest t0 WHERE t0.product_id = 'S_[CORDIANT]_650852166';

SELECT
  t0.id AS id_1,
  t0.external AS external_2,
  t0.price AS price_3,
  t0.town AS town_4,
  t0.count AS count_5,
  t0.product_id AS product_id_6,
  t0.store_id AS store_id_7
FROM
  rest t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.external AS external_2, t0.price AS price_3, t0.town AS town_4, t0.count AS count_5, t0.product_id AS product_id_6, t0.store_id AS store_id_7 FROM rest t0 WHERE t0.product_id = 'S_[CORDIANT]_650852668';

SELECT
  t0.id AS id_1,
  t0.external AS external_2,
  t0.price AS price_3,
  t0.town AS town_4,
  t0.count AS count_5,
  t0.product_id AS product_id_6,
  t0.store_id AS store_id_7
FROM
  rest t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.external AS external_2, t0.price AS price_3, t0.town AS town_4, t0.count AS count_5, t0.product_id AS product_id_6, t0.store_id AS store_id_7 FROM rest t0 WHERE t0.product_id = 'S_[CORDIANT]_747289757';

SELECT
  t0.id AS id_1,
  t0.external AS external_2,
  t0.price AS price_3,
  t0.town AS town_4,
  t0.count AS count_5,
  t0.product_id AS product_id_6,
  t0.store_id AS store_id_7
FROM
  rest t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.external AS external_2, t0.price AS price_3, t0.town AS town_4, t0.count AS count_5, t0.product_id AS product_id_6, t0.store_id AS store_id_7 FROM rest t0 WHERE t0.product_id = 'S_[CORDIANT]_1439292091';

SELECT
  t0.id AS id_1,
  t0.external AS external_2,
  t0.price AS price_3,
  t0.town AS town_4,
  t0.count AS count_5,
  t0.product_id AS product_id_6,
  t0.store_id AS store_id_7
FROM
  rest t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.external AS external_2, t0.price AS price_3, t0.town AS town_4, t0.count AS count_5, t0.product_id AS product_id_6, t0.store_id AS store_id_7 FROM rest t0 WHERE t0.product_id = 'S_[CORDIANT]_16100050000';

SELECT
  t0.id AS id_1,
  t0.external AS external_2,
  t0.price AS price_3,
  t0.town AS town_4,
  t0.count AS count_5,
  t0.product_id AS product_id_6,
  t0.store_id AS store_id_7
FROM
  rest t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.external AS external_2, t0.price AS price_3, t0.town AS town_4, t0.count AS count_5, t0.product_id AS product_id_6, t0.store_id AS store_id_7 FROM rest t0 WHERE t0.product_id = 'S_[CORDIANT]_481661926';

SELECT
  t0.id AS id_1,
  t0.external AS external_2,
  t0.price AS price_3,
  t0.town AS town_4,
  t0.count AS count_5,
  t0.product_id AS product_id_6,
  t0.store_id AS store_id_7
FROM
  rest t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.external AS external_2, t0.price AS price_3, t0.town AS town_4, t0.count AS count_5, t0.product_id AS product_id_6, t0.store_id AS store_id_7 FROM rest t0 WHERE t0.product_id = 'S_[CORDIANT]_732076982';

SELECT
  t0.id AS id_1,
  t0.external AS external_2,
  t0.price AS price_3,
  t0.town AS town_4,
  t0.count AS count_5,
  t0.product_id AS product_id_6,
  t0.store_id AS store_id_7
FROM
  rest t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.external AS external_2, t0.price AS price_3, t0.town AS town_4, t0.count AS count_5, t0.product_id AS product_id_6, t0.store_id AS store_id_7 FROM rest t0 WHERE t0.product_id = 'S_[CORDIANT]_366617266';

SELECT
  t0.id AS id_1,
  t0.external AS external_2,
  t0.price AS price_3,
  t0.town AS town_4,
  t0.count AS count_5,
  t0.product_id AS product_id_6,
  t0.store_id AS store_id_7
FROM
  rest t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.external AS external_2, t0.price AS price_3, t0.town AS town_4, t0.count AS count_5, t0.product_id AS product_id_6, t0.store_id AS store_id_7 FROM rest t0 WHERE t0.product_id = 'S_[IKON TYRES (NOKIAN TYRES)]_T731443';