Symfony Profiler

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.brand_line AS brand_line_2,
  w0_.slug AS slug_3,
  w0_.appellation AS appellation_4,
  w0_.vintage AS vintage_5,
  w0_.type AS type_6,
  w0_.sweetness AS sweetness_7,
  w0_.volume_ml AS volume_ml_8,
  w0_.country_short AS country_short_9,
  w0_.origin_full AS origin_full_10,
  w0_.grape AS grape_11,
  w0_.color_desc AS color_desc_12,
  w0_.aroma AS aroma_13,
  w0_.taste AS taste_14,
  w0_.aging AS aging_15,
  w0_.abv AS abv_16,
  w0_.serving_temp AS serving_temp_17,
  w0_.food_pairing AS food_pairing_18,
  w0_.short_description AS short_description_19,
  w0_.stock AS stock_20,
  w0_.production_steps AS production_steps_21,
  w0_.subscription_eligible AS subscription_eligible_22,
  w0_.is_new AS is_new_23,
  w0_.is_featured AS is_featured_24,
  w0_.rating AS rating_25,
  w0_.seo_text AS seo_text_26,
  w0_.position AS position_27,
  w0_.is_active AS is_active_28,
  w0_.created_at AS created_at_29,
  w0_.updated_at AS updated_at_30,
  w0_.price_amount_cents AS price_amount_cents_31,
  w0_.price_currency AS price_currency_32,
  w0_.old_price_amount_cents AS old_price_amount_cents_33,
  w0_.old_price_currency AS old_price_currency_34,
  w0_.taste_days_price_amount_cents AS taste_days_price_amount_cents_35,
  w0_.taste_days_price_currency AS taste_days_price_currency_36
FROM
  wine w0_
WHERE
  w0_.is_active = ?
  AND w0_.slug = ?

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.brand_line AS brand_line_2, w0_.slug AS slug_3, w0_.appellation AS appellation_4, w0_.vintage AS vintage_5, w0_.type AS type_6, w0_.sweetness AS sweetness_7, w0_.volume_ml AS volume_ml_8, w0_.country_short AS country_short_9, w0_.origin_full AS origin_full_10, w0_.grape AS grape_11, w0_.color_desc AS color_desc_12, w0_.aroma AS aroma_13, w0_.taste AS taste_14, w0_.aging AS aging_15, w0_.abv AS abv_16, w0_.serving_temp AS serving_temp_17, w0_.food_pairing AS food_pairing_18, w0_.short_description AS short_description_19, w0_.stock AS stock_20, w0_.production_steps AS production_steps_21, w0_.subscription_eligible AS subscription_eligible_22, w0_.is_new AS is_new_23, w0_.is_featured AS is_featured_24, w0_.rating AS rating_25, w0_.seo_text AS seo_text_26, w0_.position AS position_27, w0_.is_active AS is_active_28, w0_.created_at AS created_at_29, w0_.updated_at AS updated_at_30, w0_.price_amount_cents AS price_amount_cents_31, w0_.price_currency AS price_currency_32, w0_.old_price_amount_cents AS old_price_amount_cents_33, w0_.old_price_currency AS old_price_currency_34, w0_.taste_days_price_amount_cents AS taste_days_price_amount_cents_35, w0_.taste_days_price_currency AS taste_days_price_currency_36 FROM wine w0_ WHERE w0_.is_active = 1 AND w0_.slug = 'primitivo-di-manduria-platinum-edition';

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      position_27
    FROM
      (
        SELECT
          w0_.id AS id_0,
          w0_.name AS name_1,
          w0_.brand_line AS brand_line_2,
          w0_.slug AS slug_3,
          w0_.appellation AS appellation_4,
          w0_.vintage AS vintage_5,
          w0_.type AS type_6,
          w0_.sweetness AS sweetness_7,
          w0_.volume_ml AS volume_ml_8,
          w0_.country_short AS country_short_9,
          w0_.origin_full AS origin_full_10,
          w0_.grape AS grape_11,
          w0_.color_desc AS color_desc_12,
          w0_.aroma AS aroma_13,
          w0_.taste AS taste_14,
          w0_.aging AS aging_15,
          w0_.abv AS abv_16,
          w0_.serving_temp AS serving_temp_17,
          w0_.food_pairing AS food_pairing_18,
          w0_.short_description AS short_description_19,
          w0_.stock AS stock_20,
          w0_.production_steps AS production_steps_21,
          w0_.subscription_eligible AS subscription_eligible_22,
          w0_.is_new AS is_new_23,
          w0_.is_featured AS is_featured_24,
          w0_.rating AS rating_25,
          w0_.seo_text AS seo_text_26,
          w0_.position AS position_27,
          w0_.is_active AS is_active_28,
          w0_.created_at AS created_at_29,
          w0_.updated_at AS updated_at_30,
          w0_.price_amount_cents AS price_amount_cents_31,
          w0_.price_currency AS price_currency_32,
          w0_.old_price_amount_cents AS old_price_amount_cents_33,
          w0_.old_price_currency AS old_price_currency_34,
          w0_.taste_days_price_amount_cents AS taste_days_price_amount_cents_35,
          w0_.taste_days_price_currency AS taste_days_price_currency_36,
          w1_.id AS id_37,
          w1_.path AS path_38,
          w1_.alt AS alt_39,
          w1_.position AS position_40
        FROM
          wine w0_
          LEFT JOIN wine_image w1_ ON w0_.id = w1_.wine_id
        WHERE
          w0_.is_active = ?
          AND w0_.type = ?
          AND w0_.id <> ?
        ORDER BY
          w1_.position ASC
      ) dctrn_result_inner
    ORDER BY
      position_27 ASC
  ) dctrn_result
LIMIT
  4

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, position_27 FROM (SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.brand_line AS brand_line_2, w0_.slug AS slug_3, w0_.appellation AS appellation_4, w0_.vintage AS vintage_5, w0_.type AS type_6, w0_.sweetness AS sweetness_7, w0_.volume_ml AS volume_ml_8, w0_.country_short AS country_short_9, w0_.origin_full AS origin_full_10, w0_.grape AS grape_11, w0_.color_desc AS color_desc_12, w0_.aroma AS aroma_13, w0_.taste AS taste_14, w0_.aging AS aging_15, w0_.abv AS abv_16, w0_.serving_temp AS serving_temp_17, w0_.food_pairing AS food_pairing_18, w0_.short_description AS short_description_19, w0_.stock AS stock_20, w0_.production_steps AS production_steps_21, w0_.subscription_eligible AS subscription_eligible_22, w0_.is_new AS is_new_23, w0_.is_featured AS is_featured_24, w0_.rating AS rating_25, w0_.seo_text AS seo_text_26, w0_.position AS position_27, w0_.is_active AS is_active_28, w0_.created_at AS created_at_29, w0_.updated_at AS updated_at_30, w0_.price_amount_cents AS price_amount_cents_31, w0_.price_currency AS price_currency_32, w0_.old_price_amount_cents AS old_price_amount_cents_33, w0_.old_price_currency AS old_price_currency_34, w0_.taste_days_price_amount_cents AS taste_days_price_amount_cents_35, w0_.taste_days_price_currency AS taste_days_price_currency_36, w1_.id AS id_37, w1_.path AS path_38, w1_.alt AS alt_39, w1_.position AS position_40 FROM wine w0_ LEFT JOIN wine_image w1_ ON w0_.id = w1_.wine_id WHERE w0_.is_active = 1 AND w0_.type = 'RAUDONAS' AND w0_.id <> 3 ORDER BY w1_.position ASC) dctrn_result_inner ORDER BY position_27 ASC) dctrn_result LIMIT 4;

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.brand_line AS brand_line_2,
  w0_.slug AS slug_3,
  w0_.appellation AS appellation_4,
  w0_.vintage AS vintage_5,
  w0_.type AS type_6,
  w0_.sweetness AS sweetness_7,
  w0_.volume_ml AS volume_ml_8,
  w0_.country_short AS country_short_9,
  w0_.origin_full AS origin_full_10,
  w0_.grape AS grape_11,
  w0_.color_desc AS color_desc_12,
  w0_.aroma AS aroma_13,
  w0_.taste AS taste_14,
  w0_.aging AS aging_15,
  w0_.abv AS abv_16,
  w0_.serving_temp AS serving_temp_17,
  w0_.food_pairing AS food_pairing_18,
  w0_.short_description AS short_description_19,
  w0_.stock AS stock_20,
  w0_.production_steps AS production_steps_21,
  w0_.subscription_eligible AS subscription_eligible_22,
  w0_.is_new AS is_new_23,
  w0_.is_featured AS is_featured_24,
  w0_.rating AS rating_25,
  w0_.seo_text AS seo_text_26,
  w0_.position AS position_27,
  w0_.is_active AS is_active_28,
  w0_.created_at AS created_at_29,
  w0_.updated_at AS updated_at_30,
  w0_.price_amount_cents AS price_amount_cents_31,
  w0_.price_currency AS price_currency_32,
  w0_.old_price_amount_cents AS old_price_amount_cents_33,
  w0_.old_price_currency AS old_price_currency_34,
  w0_.taste_days_price_amount_cents AS taste_days_price_amount_cents_35,
  w0_.taste_days_price_currency AS taste_days_price_currency_36,
  w1_.id AS id_37,
  w1_.path AS path_38,
  w1_.alt AS alt_39,
  w1_.position AS position_40,
  w1_.wine_id AS wine_id_41
FROM
  wine w0_
  LEFT JOIN wine_image w1_ ON w0_.id = w1_.wine_id
WHERE
  w0_.is_active = ?
  AND w0_.type = ?
  AND w0_.id <> ?
  AND w0_.id IN (?, ?)
ORDER BY
  w0_.position ASC,
  w1_.position ASC

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.brand_line AS brand_line_2, w0_.slug AS slug_3, w0_.appellation AS appellation_4, w0_.vintage AS vintage_5, w0_.type AS type_6, w0_.sweetness AS sweetness_7, w0_.volume_ml AS volume_ml_8, w0_.country_short AS country_short_9, w0_.origin_full AS origin_full_10, w0_.grape AS grape_11, w0_.color_desc AS color_desc_12, w0_.aroma AS aroma_13, w0_.taste AS taste_14, w0_.aging AS aging_15, w0_.abv AS abv_16, w0_.serving_temp AS serving_temp_17, w0_.food_pairing AS food_pairing_18, w0_.short_description AS short_description_19, w0_.stock AS stock_20, w0_.production_steps AS production_steps_21, w0_.subscription_eligible AS subscription_eligible_22, w0_.is_new AS is_new_23, w0_.is_featured AS is_featured_24, w0_.rating AS rating_25, w0_.seo_text AS seo_text_26, w0_.position AS position_27, w0_.is_active AS is_active_28, w0_.created_at AS created_at_29, w0_.updated_at AS updated_at_30, w0_.price_amount_cents AS price_amount_cents_31, w0_.price_currency AS price_currency_32, w0_.old_price_amount_cents AS old_price_amount_cents_33, w0_.old_price_currency AS old_price_currency_34, w0_.taste_days_price_amount_cents AS taste_days_price_amount_cents_35, w0_.taste_days_price_currency AS taste_days_price_currency_36, w1_.id AS id_37, w1_.path AS path_38, w1_.alt AS alt_39, w1_.position AS position_40, w1_.wine_id AS wine_id_41 FROM wine w0_ LEFT JOIN wine_image w1_ ON w0_.id = w1_.wine_id WHERE w0_.is_active = 1 AND w0_.type = 'RAUDONAS' AND w0_.id <> 3 AND w0_.id IN (1, 4) ORDER BY w0_.position ASC, w1_.position ASC;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      position_27
    FROM
      (
        SELECT
          w0_.id AS id_0,
          w0_.name AS name_1,
          w0_.brand_line AS brand_line_2,
          w0_.slug AS slug_3,
          w0_.appellation AS appellation_4,
          w0_.vintage AS vintage_5,
          w0_.type AS type_6,
          w0_.sweetness AS sweetness_7,
          w0_.volume_ml AS volume_ml_8,
          w0_.country_short AS country_short_9,
          w0_.origin_full AS origin_full_10,
          w0_.grape AS grape_11,
          w0_.color_desc AS color_desc_12,
          w0_.aroma AS aroma_13,
          w0_.taste AS taste_14,
          w0_.aging AS aging_15,
          w0_.abv AS abv_16,
          w0_.serving_temp AS serving_temp_17,
          w0_.food_pairing AS food_pairing_18,
          w0_.short_description AS short_description_19,
          w0_.stock AS stock_20,
          w0_.production_steps AS production_steps_21,
          w0_.subscription_eligible AS subscription_eligible_22,
          w0_.is_new AS is_new_23,
          w0_.is_featured AS is_featured_24,
          w0_.rating AS rating_25,
          w0_.seo_text AS seo_text_26,
          w0_.position AS position_27,
          w0_.is_active AS is_active_28,
          w0_.created_at AS created_at_29,
          w0_.updated_at AS updated_at_30,
          w0_.price_amount_cents AS price_amount_cents_31,
          w0_.price_currency AS price_currency_32,
          w0_.old_price_amount_cents AS old_price_amount_cents_33,
          w0_.old_price_currency AS old_price_currency_34,
          w0_.taste_days_price_amount_cents AS taste_days_price_amount_cents_35,
          w0_.taste_days_price_currency AS taste_days_price_currency_36,
          w1_.id AS id_37,
          w1_.path AS path_38,
          w1_.alt AS alt_39,
          w1_.position AS position_40
        FROM
          wine w0_
          LEFT JOIN wine_image w1_ ON w0_.id = w1_.wine_id
        WHERE
          w0_.is_active = ?
          AND w0_.type <> ?
          AND w0_.id <> ?
        ORDER BY
          w1_.position ASC
      ) dctrn_result_inner
    ORDER BY
      position_27 ASC
  ) dctrn_result
LIMIT
  2

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, position_27 FROM (SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.brand_line AS brand_line_2, w0_.slug AS slug_3, w0_.appellation AS appellation_4, w0_.vintage AS vintage_5, w0_.type AS type_6, w0_.sweetness AS sweetness_7, w0_.volume_ml AS volume_ml_8, w0_.country_short AS country_short_9, w0_.origin_full AS origin_full_10, w0_.grape AS grape_11, w0_.color_desc AS color_desc_12, w0_.aroma AS aroma_13, w0_.taste AS taste_14, w0_.aging AS aging_15, w0_.abv AS abv_16, w0_.serving_temp AS serving_temp_17, w0_.food_pairing AS food_pairing_18, w0_.short_description AS short_description_19, w0_.stock AS stock_20, w0_.production_steps AS production_steps_21, w0_.subscription_eligible AS subscription_eligible_22, w0_.is_new AS is_new_23, w0_.is_featured AS is_featured_24, w0_.rating AS rating_25, w0_.seo_text AS seo_text_26, w0_.position AS position_27, w0_.is_active AS is_active_28, w0_.created_at AS created_at_29, w0_.updated_at AS updated_at_30, w0_.price_amount_cents AS price_amount_cents_31, w0_.price_currency AS price_currency_32, w0_.old_price_amount_cents AS old_price_amount_cents_33, w0_.old_price_currency AS old_price_currency_34, w0_.taste_days_price_amount_cents AS taste_days_price_amount_cents_35, w0_.taste_days_price_currency AS taste_days_price_currency_36, w1_.id AS id_37, w1_.path AS path_38, w1_.alt AS alt_39, w1_.position AS position_40 FROM wine w0_ LEFT JOIN wine_image w1_ ON w0_.id = w1_.wine_id WHERE w0_.is_active = 1 AND w0_.type <> 'RAUDONAS' AND w0_.id <> 3 ORDER BY w1_.position ASC) dctrn_result_inner ORDER BY position_27 ASC) dctrn_result LIMIT 2;

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.brand_line AS brand_line_2,
  w0_.slug AS slug_3,
  w0_.appellation AS appellation_4,
  w0_.vintage AS vintage_5,
  w0_.type AS type_6,
  w0_.sweetness AS sweetness_7,
  w0_.volume_ml AS volume_ml_8,
  w0_.country_short AS country_short_9,
  w0_.origin_full AS origin_full_10,
  w0_.grape AS grape_11,
  w0_.color_desc AS color_desc_12,
  w0_.aroma AS aroma_13,
  w0_.taste AS taste_14,
  w0_.aging AS aging_15,
  w0_.abv AS abv_16,
  w0_.serving_temp AS serving_temp_17,
  w0_.food_pairing AS food_pairing_18,
  w0_.short_description AS short_description_19,
  w0_.stock AS stock_20,
  w0_.production_steps AS production_steps_21,
  w0_.subscription_eligible AS subscription_eligible_22,
  w0_.is_new AS is_new_23,
  w0_.is_featured AS is_featured_24,
  w0_.rating AS rating_25,
  w0_.seo_text AS seo_text_26,
  w0_.position AS position_27,
  w0_.is_active AS is_active_28,
  w0_.created_at AS created_at_29,
  w0_.updated_at AS updated_at_30,
  w0_.price_amount_cents AS price_amount_cents_31,
  w0_.price_currency AS price_currency_32,
  w0_.old_price_amount_cents AS old_price_amount_cents_33,
  w0_.old_price_currency AS old_price_currency_34,
  w0_.taste_days_price_amount_cents AS taste_days_price_amount_cents_35,
  w0_.taste_days_price_currency AS taste_days_price_currency_36,
  w1_.id AS id_37,
  w1_.path AS path_38,
  w1_.alt AS alt_39,
  w1_.position AS position_40,
  w1_.wine_id AS wine_id_41
FROM
  wine w0_
  LEFT JOIN wine_image w1_ ON w0_.id = w1_.wine_id
WHERE
  w0_.is_active = ?
  AND w0_.type <> ?
  AND w0_.id <> ?
  AND w0_.id IN (?)
ORDER BY
  w0_.position ASC,
  w1_.position ASC

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.brand_line AS brand_line_2, w0_.slug AS slug_3, w0_.appellation AS appellation_4, w0_.vintage AS vintage_5, w0_.type AS type_6, w0_.sweetness AS sweetness_7, w0_.volume_ml AS volume_ml_8, w0_.country_short AS country_short_9, w0_.origin_full AS origin_full_10, w0_.grape AS grape_11, w0_.color_desc AS color_desc_12, w0_.aroma AS aroma_13, w0_.taste AS taste_14, w0_.aging AS aging_15, w0_.abv AS abv_16, w0_.serving_temp AS serving_temp_17, w0_.food_pairing AS food_pairing_18, w0_.short_description AS short_description_19, w0_.stock AS stock_20, w0_.production_steps AS production_steps_21, w0_.subscription_eligible AS subscription_eligible_22, w0_.is_new AS is_new_23, w0_.is_featured AS is_featured_24, w0_.rating AS rating_25, w0_.seo_text AS seo_text_26, w0_.position AS position_27, w0_.is_active AS is_active_28, w0_.created_at AS created_at_29, w0_.updated_at AS updated_at_30, w0_.price_amount_cents AS price_amount_cents_31, w0_.price_currency AS price_currency_32, w0_.old_price_amount_cents AS old_price_amount_cents_33, w0_.old_price_currency AS old_price_currency_34, w0_.taste_days_price_amount_cents AS taste_days_price_amount_cents_35, w0_.taste_days_price_currency AS taste_days_price_currency_36, w1_.id AS id_37, w1_.path AS path_38, w1_.alt AS alt_39, w1_.position AS position_40, w1_.wine_id AS wine_id_41 FROM wine w0_ LEFT JOIN wine_image w1_ ON w0_.id = w1_.wine_id WHERE w0_.is_active = 1 AND w0_.type <> 'RAUDONAS' AND w0_.id <> 3 AND w0_.id IN (2) ORDER BY w0_.position ASC, w1_.position ASC;

SELECT
  t0.id AS id_1,
  t0.path AS path_2,
  t0.alt AS alt_3,
  t0.position AS position_4,
  t0.wine_id AS wine_id_5
FROM
  wine_image t0
WHERE
  t0.wine_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.path AS path_2, t0.alt AS alt_3, t0.position AS position_4, t0.wine_id AS wine_id_5 FROM wine_image t0 WHERE t0.wine_id = 3 ORDER BY t0.position ASC;

SELECT
  t0_.trans_key AS trans_key_0,
  t0_.value AS value_1
FROM
  translation_override t0_
WHERE
  t0_.domain = ?
  AND t0_.locale = ?

SELECT t0_.trans_key AS trans_key_0, t0_.value AS value_1 FROM translation_override t0_ WHERE t0_.domain = 'messages' AND t0_.locale = 'lt';

SELECT
  s0_.setting_key AS setting_key_0,
  s0_.value AS value_1
FROM
  site_setting s0_

SELECT s0_.setting_key AS setting_key_0, s0_.value AS value_1 FROM site_setting s0_;