Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.selling_price_ttc AS selling_price_ttc_2,
  t0.reduced_price AS reduced_price_3,
  t0.reduced_price_start AS reduced_price_start_4,
  t0.reduced_price_end AS reduced_price_end_5,
  t0.position AS position_6,
  t0.highlight AS highlight_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.active AS active_10,
  t0.deleted_at AS deleted_at_11,
  t0.image_id AS image_id_12,
  t0.dish_category_id AS dish_category_id_13,
  t0.institution_id AS institution_id_14,
  t0.created_by AS created_by_15,
  t0.updated_by AS updated_by_16,
  t0.deleted_by AS deleted_by_17
FROM
  `dish` t0
WHERE
  t0.id IN (?)
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.selling_price_ttc AS selling_price_ttc_2, t0.reduced_price AS reduced_price_3, t0.reduced_price_start AS reduced_price_start_4, t0.reduced_price_end AS reduced_price_end_5, t0.position AS position_6, t0.highlight AS highlight_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.active AS active_10, t0.deleted_at AS deleted_at_11, t0.image_id AS image_id_12, t0.dish_category_id AS dish_category_id_13, t0.institution_id AS institution_id_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.deleted_by AS deleted_by_17 FROM `dish` t0 WHERE t0.id IN (88, 90, 92) AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.deleted_at AS deleted_at_5,
  t0.dish_id AS dish_id_6,
  t0.wine_id AS wine_id_7,
  t0.institution_id AS institution_id_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.deleted_by AS deleted_by_11
FROM
  `wine_pairing` t0
WHERE
  t0.dish_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.value AS value_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.dish_id AS dish_id_6, t0.wine_id AS wine_id_7, t0.institution_id AS institution_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.deleted_by AS deleted_by_11 FROM `wine_pairing` t0 WHERE t0.dish_id = 88 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.deleted_at AS deleted_at_5,
  t0.dish_id AS dish_id_6,
  t0.wine_id AS wine_id_7,
  t0.institution_id AS institution_id_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.deleted_by AS deleted_by_11
FROM
  `wine_pairing` t0
WHERE
  t0.dish_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.value AS value_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.dish_id AS dish_id_6, t0.wine_id AS wine_id_7, t0.institution_id AS institution_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.deleted_by AS deleted_by_11 FROM `wine_pairing` t0 WHERE t0.dish_id = 90 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.deleted_at AS deleted_at_5,
  t0.dish_id AS dish_id_6,
  t0.wine_id AS wine_id_7,
  t0.institution_id AS institution_id_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.deleted_by AS deleted_by_11
FROM
  `wine_pairing` t0
WHERE
  t0.dish_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.value AS value_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.dish_id AS dish_id_6, t0.wine_id AS wine_id_7, t0.institution_id AS institution_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.deleted_by AS deleted_by_11 FROM `wine_pairing` t0 WHERE t0.dish_id = 92 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.original_name AS original_name_3,
  t0.tag AS tag_4,
  t0.is_default AS is_default_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deleted_at AS deleted_at_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.deleted_by AS deleted_by_11
FROM
  `locale_front` t0
WHERE
  t0.tag = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.tag AS tag_4, t0.is_default AS is_default_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.deleted_by AS deleted_by_11 FROM `locale_front` t0 WHERE t0.tag = 'fr' AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.location AS location_2,
  t0.vintage AS vintage_3,
  t0.video AS video_4,
  t0.organic AS organic_5,
  t0.local AS local_6,
  t0.strength AS strength_7,
  t0.sweetness AS sweetness_8,
  t0.tannins AS tannins_9,
  t0.fruity AS fruity_10,
  t0.reduced_price_start AS reduced_price_start_11,
  t0.reduced_price_end AS reduced_price_end_12,
  t0.position AS position_13,
  t0.highlight AS highlight_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.active AS active_17,
  t0.deleted_at AS deleted_at_18,
  t0.wine_category_id AS wine_category_id_19,
  t0.image_id AS image_id_20,
  t0.review_file_id AS review_file_id_21,
  t0.wine_color_id AS wine_color_id_22,
  t0.institution_id AS institution_id_23,
  t0.created_by AS created_by_24,
  t0.updated_by AS updated_by_25,
  t0.deleted_by AS deleted_by_26
FROM
  `wine` t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.location AS location_2, t0.vintage AS vintage_3, t0.video AS video_4, t0.organic AS organic_5, t0.local AS local_6, t0.strength AS strength_7, t0.sweetness AS sweetness_8, t0.tannins AS tannins_9, t0.fruity AS fruity_10, t0.reduced_price_start AS reduced_price_start_11, t0.reduced_price_end AS reduced_price_end_12, t0.position AS position_13, t0.highlight AS highlight_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.active AS active_17, t0.deleted_at AS deleted_at_18, t0.wine_category_id AS wine_category_id_19, t0.image_id AS image_id_20, t0.review_file_id AS review_file_id_21, t0.wine_color_id AS wine_color_id_22, t0.institution_id AS institution_id_23, t0.created_by AS created_by_24, t0.updated_by AS updated_by_25, t0.deleted_by AS deleted_by_26 FROM `wine` t0 WHERE t0.id = 26 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.original_name AS original_name_3,
  t0.tag AS tag_4,
  t0.is_default AS is_default_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deleted_at AS deleted_at_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.deleted_by AS deleted_by_11
FROM
  `locale_front` t0
WHERE
  t0.tag = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.tag AS tag_4, t0.is_default AS is_default_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.deleted_by AS deleted_by_11 FROM `locale_front` t0 WHERE t0.tag = 'fr' AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.appellation AS appellation_3,
  t0.winery AS winery_4,
  t0.description AS description_5,
  t0.review AS review_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.deleted_at AS deleted_at_9,
  t0.wine_id AS wine_id_10,
  t0.locale_front_id AS locale_front_id_11,
  t0.created_by AS created_by_12,
  t0.updated_by AS updated_by_13,
  t0.deleted_by AS deleted_by_14
FROM
  `wine_translation` t0
WHERE
  (
    t0.locale_front_id = ?
    AND t0.wine_id = ?
  )
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.appellation AS appellation_3, t0.winery AS winery_4, t0.description AS description_5, t0.review AS review_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.wine_id AS wine_id_10, t0.locale_front_id AS locale_front_id_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13, t0.deleted_by AS deleted_by_14 FROM `wine_translation` t0 WHERE (t0.locale_front_id = 1 AND t0.wine_id = 26) AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.original_name AS original_name_3,
  t0.tag AS tag_4,
  t0.is_default AS is_default_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.deleted_at AS deleted_at_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.deleted_by AS deleted_by_11
FROM
  `locale_front` t0
WHERE
  t0.tag = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.original_name AS original_name_3, t0.tag AS tag_4, t0.is_default AS is_default_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.deleted_at AS deleted_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.deleted_by AS deleted_by_11 FROM `locale_front` t0 WHERE t0.tag = 'fr' AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.appellation AS appellation_3,
  t0.winery AS winery_4,
  t0.description AS description_5,
  t0.review AS review_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.deleted_at AS deleted_at_9,
  t0.wine_id AS wine_id_10,
  t0.locale_front_id AS locale_front_id_11,
  t0.created_by AS created_by_12,
  t0.updated_by AS updated_by_13,
  t0.deleted_by AS deleted_by_14
FROM
  `wine_translation` t0
WHERE
  (
    t0.locale_front_id = ?
    AND t0.wine_id = ?
  )
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.appellation AS appellation_3, t0.winery AS winery_4, t0.description AS description_5, t0.review AS review_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.deleted_at AS deleted_at_9, t0.wine_id AS wine_id_10, t0.locale_front_id AS locale_front_id_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13, t0.deleted_by AS deleted_by_14 FROM `wine_translation` t0 WHERE (t0.locale_front_id = 1 AND t0.wine_id = 26) AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.reduced_price AS reduced_price_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.wine_id AS wine_id_7,
  t0.capacity_id AS capacity_id_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.deleted_by AS deleted_by_11
FROM
  `wine_price` t0
WHERE
  t0.wine_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.price AS price_2, t0.reduced_price AS reduced_price_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.wine_id AS wine_id_7, t0.capacity_id AS capacity_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.deleted_by AS deleted_by_11 FROM `wine_price` t0 WHERE t0.wine_id = 26 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.deleted_at AS deleted_at_5,
  t0.institution_id AS institution_id_6,
  t0.created_by AS created_by_7,
  t0.updated_by AS updated_by_8,
  t0.deleted_by AS deleted_by_9
FROM
  `capacity` t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.deleted_at AS deleted_at_5, t0.institution_id AS institution_id_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.deleted_by AS deleted_by_9 FROM `capacity` t0 WHERE t0.id = 231 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.url AS url_3,
  t0.phone AS phone_4,
  t0.is_default AS is_default_5,
  t0.facebook AS facebook_6,
  t0.instagram AS instagram_7,
  t0.facebook_token AS facebook_token_8,
  t0.sender_sms AS sender_sms_9,
  t0.hash AS hash_10,
  t0.qr_code_last_download_at AS qr_code_last_download_at_11,
  t0.description AS description_12,
  t0.is_pdf_menu_active AS is_pdf_menu_active_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.deleted_at AS deleted_at_16,
  t0.active AS active_17,
  t0.document_id AS document_id_18,
  t0.user_id AS user_id_19,
  t0.address_id AS address_id_20,
  t0.qr_code_id AS qr_code_id_21,
  t22.id AS id_23,
  t22.title AS title_24,
  t22.sub_title AS sub_title_25,
  t22.background_color AS background_color_26,
  t22.title_color AS title_color_27,
  t22.sub_title_color AS sub_title_color_28,
  t22.button_background_color AS button_background_color_29,
  t22.button_text_color AS button_text_color_30,
  t22.display_logo AS display_logo_31,
  t22.display_mode AS display_mode_32,
  t22.created_at AS created_at_33,
  t22.updated_at AS updated_at_34,
  t22.deleted_at AS deleted_at_35,
  t22.institution_id AS institution_id_36,
  t22.created_by AS created_by_37,
  t22.updated_by AS updated_by_38,
  t22.deleted_by AS deleted_by_39,
  t40.id AS id_41,
  t40.primary_color AS primary_color_42,
  t40.primary_variant_color AS primary_variant_color_43,
  t40.text_over_primary_color AS text_over_primary_color_44,
  t40.created_at AS created_at_45,
  t40.updated_at AS updated_at_46,
  t40.deleted_at AS deleted_at_47,
  t40.institution_id AS institution_id_48,
  t40.created_by AS created_by_49,
  t40.updated_by AS updated_by_50,
  t40.deleted_by AS deleted_by_51,
  t52.id AS id_53,
  t52.average_review_score AS average_review_score_54,
  t52.one_star_number AS one_star_number_55,
  t52.two_star_number AS two_star_number_56,
  t52.three_star_number AS three_star_number_57,
  t52.four_star_number AS four_star_number_58,
  t52.five_star_number AS five_star_number_59,
  t52.created_at AS created_at_60,
  t52.updated_at AS updated_at_61,
  t52.deleted_at AS deleted_at_62,
  t52.institution_id AS institution_id_63,
  t52.created_by AS created_by_64,
  t52.updated_by AS updated_by_65,
  t52.deleted_by AS deleted_by_66,
  t0.created_by AS created_by_67,
  t0.updated_by AS updated_by_68,
  t0.deleted_by AS deleted_by_69
FROM
  `institution` t0
  LEFT JOIN `pdfmenu_personalization` t22 ON t22.institution_id = t0.id
  LEFT JOIN `institution_app_personalization` t40 ON t40.institution_id = t0.id
  LEFT JOIN `institution_review_summary` t52 ON t52.institution_id = t0.id
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.url AS url_3, t0.phone AS phone_4, t0.is_default AS is_default_5, t0.facebook AS facebook_6, t0.instagram AS instagram_7, t0.facebook_token AS facebook_token_8, t0.sender_sms AS sender_sms_9, t0.hash AS hash_10, t0.qr_code_last_download_at AS qr_code_last_download_at_11, t0.description AS description_12, t0.is_pdf_menu_active AS is_pdf_menu_active_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.deleted_at AS deleted_at_16, t0.active AS active_17, t0.document_id AS document_id_18, t0.user_id AS user_id_19, t0.address_id AS address_id_20, t0.qr_code_id AS qr_code_id_21, t22.id AS id_23, t22.title AS title_24, t22.sub_title AS sub_title_25, t22.background_color AS background_color_26, t22.title_color AS title_color_27, t22.sub_title_color AS sub_title_color_28, t22.button_background_color AS button_background_color_29, t22.button_text_color AS button_text_color_30, t22.display_logo AS display_logo_31, t22.display_mode AS display_mode_32, t22.created_at AS created_at_33, t22.updated_at AS updated_at_34, t22.deleted_at AS deleted_at_35, t22.institution_id AS institution_id_36, t22.created_by AS created_by_37, t22.updated_by AS updated_by_38, t22.deleted_by AS deleted_by_39, t40.id AS id_41, t40.primary_color AS primary_color_42, t40.primary_variant_color AS primary_variant_color_43, t40.text_over_primary_color AS text_over_primary_color_44, t40.created_at AS created_at_45, t40.updated_at AS updated_at_46, t40.deleted_at AS deleted_at_47, t40.institution_id AS institution_id_48, t40.created_by AS created_by_49, t40.updated_by AS updated_by_50, t40.deleted_by AS deleted_by_51, t52.id AS id_53, t52.average_review_score AS average_review_score_54, t52.one_star_number AS one_star_number_55, t52.two_star_number AS two_star_number_56, t52.three_star_number AS three_star_number_57, t52.four_star_number AS four_star_number_58, t52.five_star_number AS five_star_number_59, t52.created_at AS created_at_60, t52.updated_at AS updated_at_61, t52.deleted_at AS deleted_at_62, t52.institution_id AS institution_id_63, t52.created_by AS created_by_64, t52.updated_by AS updated_by_65, t52.deleted_by AS deleted_by_66, t0.created_by AS created_by_67, t0.updated_by AS updated_by_68, t0.deleted_by AS deleted_by_69 FROM `institution` t0 LEFT JOIN `pdfmenu_personalization` t22 ON t22.institution_id = t0.id LEFT JOIN `institution_app_personalization` t40 ON t40.institution_id = t0.id LEFT JOIN `institution_review_summary` t52 ON t52.institution_id = t0.id WHERE t0.id = 12 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.location AS location_2,
  t0.vintage AS vintage_3,
  t0.video AS video_4,
  t0.organic AS organic_5,
  t0.local AS local_6,
  t0.strength AS strength_7,
  t0.sweetness AS sweetness_8,
  t0.tannins AS tannins_9,
  t0.fruity AS fruity_10,
  t0.reduced_price_start AS reduced_price_start_11,
  t0.reduced_price_end AS reduced_price_end_12,
  t0.position AS position_13,
  t0.highlight AS highlight_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.active AS active_17,
  t0.deleted_at AS deleted_at_18,
  t0.wine_category_id AS wine_category_id_19,
  t0.image_id AS image_id_20,
  t0.review_file_id AS review_file_id_21,
  t0.wine_color_id AS wine_color_id_22,
  t0.institution_id AS institution_id_23,
  t0.created_by AS created_by_24,
  t0.updated_by AS updated_by_25,
  t0.deleted_by AS deleted_by_26
FROM
  `wine` t0
WHERE
  t0.institution_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.location AS location_2, t0.vintage AS vintage_3, t0.video AS video_4, t0.organic AS organic_5, t0.local AS local_6, t0.strength AS strength_7, t0.sweetness AS sweetness_8, t0.tannins AS tannins_9, t0.fruity AS fruity_10, t0.reduced_price_start AS reduced_price_start_11, t0.reduced_price_end AS reduced_price_end_12, t0.position AS position_13, t0.highlight AS highlight_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.active AS active_17, t0.deleted_at AS deleted_at_18, t0.wine_category_id AS wine_category_id_19, t0.image_id AS image_id_20, t0.review_file_id AS review_file_id_21, t0.wine_color_id AS wine_color_id_22, t0.institution_id AS institution_id_23, t0.created_by AS created_by_24, t0.updated_by AS updated_by_25, t0.deleted_by AS deleted_by_26 FROM `wine` t0 WHERE t0.institution_id = 12 AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.reduced_price AS reduced_price_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.wine_id AS wine_id_7,
  t0.capacity_id AS capacity_id_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.deleted_by AS deleted_by_11
FROM
  `wine_price` t0
WHERE
  t0.wine_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.price AS price_2, t0.reduced_price AS reduced_price_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.wine_id AS wine_id_7, t0.capacity_id AS capacity_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.deleted_by AS deleted_by_11 FROM `wine_price` t0 WHERE t0.wine_id = 24 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.reduced_price AS reduced_price_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.wine_id AS wine_id_7,
  t0.capacity_id AS capacity_id_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.deleted_by AS deleted_by_11
FROM
  `wine_price` t0
WHERE
  t0.wine_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.price AS price_2, t0.reduced_price AS reduced_price_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.wine_id AS wine_id_7, t0.capacity_id AS capacity_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.deleted_by AS deleted_by_11 FROM `wine_price` t0 WHERE t0.wine_id = 25 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.reduced_price AS reduced_price_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.wine_id AS wine_id_7,
  t0.capacity_id AS capacity_id_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.deleted_by AS deleted_by_11
FROM
  `wine_price` t0
WHERE
  t0.wine_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.price AS price_2, t0.reduced_price AS reduced_price_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.wine_id AS wine_id_7, t0.capacity_id AS capacity_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.deleted_by AS deleted_by_11 FROM `wine_price` t0 WHERE t0.wine_id = 27 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.reduced_price AS reduced_price_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.wine_id AS wine_id_7,
  t0.capacity_id AS capacity_id_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.deleted_by AS deleted_by_11
FROM
  `wine_price` t0
WHERE
  t0.wine_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.price AS price_2, t0.reduced_price AS reduced_price_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.wine_id AS wine_id_7, t0.capacity_id AS capacity_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.deleted_by AS deleted_by_11 FROM `wine_price` t0 WHERE t0.wine_id = 28 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.reduced_price AS reduced_price_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.wine_id AS wine_id_7,
  t0.capacity_id AS capacity_id_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.deleted_by AS deleted_by_11
FROM
  `wine_price` t0
WHERE
  t0.wine_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.price AS price_2, t0.reduced_price AS reduced_price_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.wine_id AS wine_id_7, t0.capacity_id AS capacity_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.deleted_by AS deleted_by_11 FROM `wine_price` t0 WHERE t0.wine_id = 29 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.reduced_price AS reduced_price_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.wine_id AS wine_id_7,
  t0.capacity_id AS capacity_id_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.deleted_by AS deleted_by_11
FROM
  `wine_price` t0
WHERE
  t0.wine_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.price AS price_2, t0.reduced_price AS reduced_price_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.wine_id AS wine_id_7, t0.capacity_id AS capacity_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.deleted_by AS deleted_by_11 FROM `wine_price` t0 WHERE t0.wine_id = 30 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.price AS price_2,
  t0.reduced_price AS reduced_price_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.deleted_at AS deleted_at_6,
  t0.wine_id AS wine_id_7,
  t0.capacity_id AS capacity_id_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.deleted_by AS deleted_by_11
FROM
  `wine_price` t0
WHERE
  t0.wine_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.price AS price_2, t0.reduced_price AS reduced_price_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.deleted_at AS deleted_at_6, t0.wine_id AS wine_id_7, t0.capacity_id AS capacity_id_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.deleted_by AS deleted_by_11 FROM `wine_price` t0 WHERE t0.wine_id = 31 AND ((t0.deleted_at IS NULL));

SELECT
  t0.id AS id_1,
  t0.reduced_price_start AS reduced_price_start_2,
  t0.reduced_price_end AS reduced_price_end_3,
  t0.position AS position_4,
  t0.highlight AS highlight_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.active AS active_8,
  t0.deleted_at AS deleted_at_9,
  t0.beer_category_id AS beer_category_id_10,
  t0.beer_color_id AS beer_color_id_11,
  t0.review_file_id AS review_file_id_12,
  t0.image_id AS image_id_13,
  t0.institution_id AS institution_id_14,
  t0.created_by AS created_by_15,
  t0.updated_by AS updated_by_16,
  t0.deleted_by AS deleted_by_17
FROM
  `beer` t0
WHERE
  t0.institution_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.reduced_price_start AS reduced_price_start_2, t0.reduced_price_end AS reduced_price_end_3, t0.position AS position_4, t0.highlight AS highlight_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.active AS active_8, t0.deleted_at AS deleted_at_9, t0.beer_category_id AS beer_category_id_10, t0.beer_color_id AS beer_color_id_11, t0.review_file_id AS review_file_id_12, t0.image_id AS image_id_13, t0.institution_id AS institution_id_14, t0.created_by AS created_by_15, t0.updated_by AS updated_by_16, t0.deleted_by AS deleted_by_17 FROM `beer` t0 WHERE t0.institution_id = 12 AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC;