Symfony Profiler

SELECT
  r0_.id AS id_0,
  r0_.name AS name_1,
  r0_.image_name AS image_name_2,
  r0_.video_name AS video_name_3,
  r0_.video_size AS video_size_4,
  r0_.image_size AS image_size_5,
  r0_.updated_at AS updated_at_6,
  r0_.created_at AS created_at_7,
  r0_.description AS description_8,
  r0_.paying_info AS paying_info_9,
  r0_.general_info AS general_info_10,
  r0_.menu_push_info AS menu_push_info_11,
  r0_.enabled AS enabled_12,
  r0_.short_code_visible AS short_code_visible_13,
  r0_.filter_hide AS filter_hide_14,
  r0_.filters_enabled AS filters_enabled_15,
  r0_.manager AS manager_16,
  r0_.phone AS phone_17,
  r0_.email AS email_18,
  r0_.address AS address_19,
  r0_.day1 AS day1_20,
  r0_.day2 AS day2_21,
  r0_.day3 AS day3_22,
  r0_.day4 AS day4_23,
  r0_.day5 AS day5_24,
  r0_.day6 AS day6_25,
  r0_.day7 AS day7_26,
  r0_.service_fee AS service_fee_27
FROM
  restaurant r0_
  LEFT JOIN menu m1_ ON r0_.id = m1_.restaurant_id
  AND (m1_.enabled = 1)
WHERE
  r0_.enabled = 1

SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.image_name AS image_name_2, r0_.video_name AS video_name_3, r0_.video_size AS video_size_4, r0_.image_size AS image_size_5, r0_.updated_at AS updated_at_6, r0_.created_at AS created_at_7, r0_.description AS description_8, r0_.paying_info AS paying_info_9, r0_.general_info AS general_info_10, r0_.menu_push_info AS menu_push_info_11, r0_.enabled AS enabled_12, r0_.short_code_visible AS short_code_visible_13, r0_.filter_hide AS filter_hide_14, r0_.filters_enabled AS filters_enabled_15, r0_.manager AS manager_16, r0_.phone AS phone_17, r0_.email AS email_18, r0_.address AS address_19, r0_.day1 AS day1_20, r0_.day2 AS day2_21, r0_.day3 AS day3_22, r0_.day4 AS day4_23, r0_.day5 AS day5_24, r0_.day6 AS day6_25, r0_.day7 AS day7_26, r0_.service_fee AS service_fee_27 FROM restaurant r0_ LEFT JOIN menu m1_ ON r0_.id = m1_.restaurant_id AND (m1_.enabled = 1) WHERE r0_.enabled = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.image_name AS image_name_4,
  t0.image_size AS image_size_5,
  t0.updated_at AS updated_at_6,
  t0.description AS description_7,
  t0.enabled AS enabled_8,
  t0.position AS position_9,
  t0.counter_mode AS counter_mode_10,
  t0.restaurant_id AS restaurant_id_11,
  t0.parent_id AS parent_id_12
FROM
  menu t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.image_name AS image_name_4, t0.image_size AS image_size_5, t0.updated_at AS updated_at_6, t0.description AS description_7, t0.enabled AS enabled_8, t0.position AS position_9, t0.counter_mode AS counter_mode_10, t0.restaurant_id AS restaurant_id_11, t0.parent_id AS parent_id_12 FROM menu t0 WHERE t0.id = '3';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.image_name AS image_name_4,
  t0.image_size AS image_size_5,
  t0.updated_at AS updated_at_6,
  t0.description AS description_7,
  t0.enabled AS enabled_8,
  t0.position AS position_9,
  t0.counter_mode AS counter_mode_10,
  t0.restaurant_id AS restaurant_id_11,
  t0.parent_id AS parent_id_12
FROM
  menu t0
WHERE
  t0.restaurant_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.image_name AS image_name_4, t0.image_size AS image_size_5, t0.updated_at AS updated_at_6, t0.description AS description_7, t0.enabled AS enabled_8, t0.position AS position_9, t0.counter_mode AS counter_mode_10, t0.restaurant_id AS restaurant_id_11, t0.parent_id AS parent_id_12 FROM menu t0 WHERE t0.restaurant_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.language_id AS language_id_6,
  t0.menu_id AS menu_id_7
FROM
  menu_translation t0
WHERE
  t0.menu_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.language_id AS language_id_6, t0.menu_id AS menu_id_7 FROM menu_translation t0 WHERE t0.menu_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.iso_code AS iso_code_3,
  t0.updated_at AS updated_at_4,
  t0.created_at AS created_at_5,
  t0.default_lang AS default_lang_6
FROM
  language t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.updated_at AS updated_at_4, t0.created_at AS created_at_5, t0.default_lang AS default_lang_6 FROM language t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.iso_code AS iso_code_3,
  t0.updated_at AS updated_at_4,
  t0.created_at AS created_at_5,
  t0.default_lang AS default_lang_6
FROM
  language t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.updated_at AS updated_at_4, t0.created_at AS created_at_5, t0.default_lang AS default_lang_6 FROM language t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.iso_code AS iso_code_3,
  t0.updated_at AS updated_at_4,
  t0.created_at AS created_at_5,
  t0.default_lang AS default_lang_6
FROM
  language t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.updated_at AS updated_at_4, t0.created_at AS created_at_5, t0.default_lang AS default_lang_6 FROM language t0 WHERE t0.id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.language_id AS language_id_6,
  t0.menu_id AS menu_id_7
FROM
  menu_translation t0
WHERE
  t0.menu_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.language_id AS language_id_6, t0.menu_id AS menu_id_7 FROM menu_translation t0 WHERE t0.menu_id = 19;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.language_id AS language_id_6,
  t0.menu_id AS menu_id_7
FROM
  menu_translation t0
WHERE
  t0.menu_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.language_id AS language_id_6, t0.menu_id AS menu_id_7 FROM menu_translation t0 WHERE t0.menu_id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.language_id AS language_id_6,
  t0.menu_id AS menu_id_7
FROM
  menu_translation t0
WHERE
  t0.menu_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.language_id AS language_id_6, t0.menu_id AS menu_id_7 FROM menu_translation t0 WHERE t0.menu_id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.enabled AS enabled_4,
  t0.position AS position_5,
  t0.image_name AS image_name_6,
  t0.image_size AS image_size_7,
  t0.updated_at AS updated_at_8,
  t0.created_at AS created_at_9,
  t0.menu_id AS menu_id_10
FROM
  category t0
WHERE
  t0.menu_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.enabled AS enabled_4, t0.position AS position_5, t0.image_name AS image_name_6, t0.image_size AS image_size_7, t0.updated_at AS updated_at_8, t0.created_at AS created_at_9, t0.menu_id AS menu_id_10 FROM category t0 WHERE t0.menu_id = 3 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.category_id AS category_id_3,
  t0.meal_id AS meal_id_4
FROM
  category_meal t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.category_id AS category_id_3, t0.meal_id AS meal_id_4 FROM category_meal t0 WHERE t0.category_id = 23;

SELECT
  t0.id AS id_1,
  t0.remote_id AS remote_id_2,
  t0.name AS name_3,
  t0.short_code AS short_code_4,
  t0.description AS description_5,
  t0.enabled AS enabled_6,
  t0.position AS position_7,
  t0.image_name AS image_name_8,
  t0.image_size AS image_size_9,
  t0.image_width AS image_width_10,
  t0.image_height AS image_height_11,
  t0.updated_at AS updated_at_12,
  t0.created_at AS created_at_13,
  t0.price_huf AS price_huf_14,
  t0.price_eur AS price_eur_15,
  t0.drink AS drink_16,
  t0.meal_type AS meal_type_17,
  t0.packaging_qty AS packaging_qty_18,
  t0.side_dish AS side_dish_19,
  t0.side_dish_required AS side_dish_required_20,
  t0.auto_side_dish AS auto_side_dish_21,
  t0.side_dish_selectable AS side_dish_selectable_22,
  t0.surcharge_side_dish AS surcharge_side_dish_23,
  t0.archived AS archived_24,
  t0.parent_id AS parent_id_25,
  t0.vat_local_id AS vat_local_id_26,
  t0.vat_delivery_id AS vat_delivery_id_27,
  t0.packaging_unit_id AS packaging_unit_id_28,
  t0.ntak_main_category_id AS ntak_main_category_id_29,
  t0.ntak_sub_category_id AS ntak_sub_category_id_30,
  t31.id AS id_32,
  t31.title AS title_33,
  t31.created_at AS created_at_34,
  t31.updated_at AS updated_at_35,
  t31.archived AS archived_36,
  t31.description AS description_37,
  t31.meal_id AS meal_id_38,
  t0.default_side_dish_id AS default_side_dish_id_39,
  t0.meal_group_id AS meal_group_id_40
FROM
  meal t0
  LEFT JOIN recipe t31 ON t31.meal_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.name AS name_3, t0.short_code AS short_code_4, t0.description AS description_5, t0.enabled AS enabled_6, t0.position AS position_7, t0.image_name AS image_name_8, t0.image_size AS image_size_9, t0.image_width AS image_width_10, t0.image_height AS image_height_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.price_huf AS price_huf_14, t0.price_eur AS price_eur_15, t0.drink AS drink_16, t0.meal_type AS meal_type_17, t0.packaging_qty AS packaging_qty_18, t0.side_dish AS side_dish_19, t0.side_dish_required AS side_dish_required_20, t0.auto_side_dish AS auto_side_dish_21, t0.side_dish_selectable AS side_dish_selectable_22, t0.surcharge_side_dish AS surcharge_side_dish_23, t0.archived AS archived_24, t0.parent_id AS parent_id_25, t0.vat_local_id AS vat_local_id_26, t0.vat_delivery_id AS vat_delivery_id_27, t0.packaging_unit_id AS packaging_unit_id_28, t0.ntak_main_category_id AS ntak_main_category_id_29, t0.ntak_sub_category_id AS ntak_sub_category_id_30, t31.id AS id_32, t31.title AS title_33, t31.created_at AS created_at_34, t31.updated_at AS updated_at_35, t31.archived AS archived_36, t31.description AS description_37, t31.meal_id AS meal_id_38, t0.default_side_dish_id AS default_side_dish_id_39, t0.meal_group_id AS meal_group_id_40 FROM meal t0 LEFT JOIN recipe t31 ON t31.meal_id = t0.id WHERE t0.id = 56;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.language_id AS language_id_6,
  t0.category_id AS category_id_7
FROM
  category_translation t0
WHERE
  t0.category_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.language_id AS language_id_6, t0.category_id AS category_id_7 FROM category_translation t0 WHERE t0.category_id = 23;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  allergen t0
  INNER JOIN meal_allergen ON t0.id = meal_allergen.allergen_id
WHERE
  meal_allergen.meal_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM allergen t0 INNER JOIN meal_allergen ON t0.id = meal_allergen.allergen_id WHERE meal_allergen.meal_id = 56;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.language_id AS language_id_6,
  t0.meal_id AS meal_id_7
FROM
  meal_translation t0
WHERE
  t0.meal_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.language_id AS language_id_6, t0.meal_id AS meal_id_7 FROM meal_translation t0 WHERE t0.meal_id = 56;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.language_id AS language_id_3,
  t0.allergen_id AS allergen_id_4
FROM
  allergen_translation t0
WHERE
  t0.allergen_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.language_id AS language_id_3, t0.allergen_id AS allergen_id_4 FROM allergen_translation t0 WHERE t0.allergen_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.language_id AS language_id_3,
  t0.allergen_id AS allergen_id_4
FROM
  allergen_translation t0
WHERE
  t0.allergen_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.language_id AS language_id_3, t0.allergen_id AS allergen_id_4 FROM allergen_translation t0 WHERE t0.allergen_id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.language_id AS language_id_3,
  t0.allergen_id AS allergen_id_4
FROM
  allergen_translation t0
WHERE
  t0.allergen_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.language_id AS language_id_3, t0.allergen_id AS allergen_id_4 FROM allergen_translation t0 WHERE t0.allergen_id = 3;

SELECT
  t0.id AS id_1,
  t0.remote_id AS remote_id_2,
  t0.name AS name_3,
  t0.short_code AS short_code_4,
  t0.description AS description_5,
  t0.enabled AS enabled_6,
  t0.position AS position_7,
  t0.image_name AS image_name_8,
  t0.image_size AS image_size_9,
  t0.image_width AS image_width_10,
  t0.image_height AS image_height_11,
  t0.updated_at AS updated_at_12,
  t0.created_at AS created_at_13,
  t0.price_huf AS price_huf_14,
  t0.price_eur AS price_eur_15,
  t0.drink AS drink_16,
  t0.meal_type AS meal_type_17,
  t0.packaging_qty AS packaging_qty_18,
  t0.side_dish AS side_dish_19,
  t0.side_dish_required AS side_dish_required_20,
  t0.auto_side_dish AS auto_side_dish_21,
  t0.side_dish_selectable AS side_dish_selectable_22,
  t0.surcharge_side_dish AS surcharge_side_dish_23,
  t0.archived AS archived_24,
  t0.parent_id AS parent_id_25,
  t0.vat_local_id AS vat_local_id_26,
  t0.vat_delivery_id AS vat_delivery_id_27,
  t0.packaging_unit_id AS packaging_unit_id_28,
  t0.ntak_main_category_id AS ntak_main_category_id_29,
  t0.ntak_sub_category_id AS ntak_sub_category_id_30,
  t31.id AS id_32,
  t31.title AS title_33,
  t31.created_at AS created_at_34,
  t31.updated_at AS updated_at_35,
  t31.archived AS archived_36,
  t31.description AS description_37,
  t31.meal_id AS meal_id_38,
  t0.default_side_dish_id AS default_side_dish_id_39,
  t0.meal_group_id AS meal_group_id_40
FROM
  meal t0
  LEFT JOIN recipe t31 ON t31.meal_id = t0.id
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.name AS name_3, t0.short_code AS short_code_4, t0.description AS description_5, t0.enabled AS enabled_6, t0.position AS position_7, t0.image_name AS image_name_8, t0.image_size AS image_size_9, t0.image_width AS image_width_10, t0.image_height AS image_height_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.price_huf AS price_huf_14, t0.price_eur AS price_eur_15, t0.drink AS drink_16, t0.meal_type AS meal_type_17, t0.packaging_qty AS packaging_qty_18, t0.side_dish AS side_dish_19, t0.side_dish_required AS side_dish_required_20, t0.auto_side_dish AS auto_side_dish_21, t0.side_dish_selectable AS side_dish_selectable_22, t0.surcharge_side_dish AS surcharge_side_dish_23, t0.archived AS archived_24, t0.parent_id AS parent_id_25, t0.vat_local_id AS vat_local_id_26, t0.vat_delivery_id AS vat_delivery_id_27, t0.packaging_unit_id AS packaging_unit_id_28, t0.ntak_main_category_id AS ntak_main_category_id_29, t0.ntak_sub_category_id AS ntak_sub_category_id_30, t31.id AS id_32, t31.title AS title_33, t31.created_at AS created_at_34, t31.updated_at AS updated_at_35, t31.archived AS archived_36, t31.description AS description_37, t31.meal_id AS meal_id_38, t0.default_side_dish_id AS default_side_dish_id_39, t0.meal_group_id AS meal_group_id_40 FROM meal t0 LEFT JOIN recipe t31 ON t31.meal_id = t0.id WHERE t0.parent_id = 56;

SELECT
  t0.id AS id_1,
  t0.remote_id AS remote_id_2,
  t0.name AS name_3,
  t0.short_code AS short_code_4,
  t0.description AS description_5,
  t0.enabled AS enabled_6,
  t0.position AS position_7,
  t0.image_name AS image_name_8,
  t0.image_size AS image_size_9,
  t0.image_width AS image_width_10,
  t0.image_height AS image_height_11,
  t0.updated_at AS updated_at_12,
  t0.created_at AS created_at_13,
  t0.price_huf AS price_huf_14,
  t0.price_eur AS price_eur_15,
  t0.drink AS drink_16,
  t0.meal_type AS meal_type_17,
  t0.packaging_qty AS packaging_qty_18,
  t0.side_dish AS side_dish_19,
  t0.side_dish_required AS side_dish_required_20,
  t0.auto_side_dish AS auto_side_dish_21,
  t0.side_dish_selectable AS side_dish_selectable_22,
  t0.surcharge_side_dish AS surcharge_side_dish_23,
  t0.archived AS archived_24,
  t0.parent_id AS parent_id_25,
  t0.vat_local_id AS vat_local_id_26,
  t0.vat_delivery_id AS vat_delivery_id_27,
  t0.packaging_unit_id AS packaging_unit_id_28,
  t0.ntak_main_category_id AS ntak_main_category_id_29,
  t0.ntak_sub_category_id AS ntak_sub_category_id_30,
  t31.id AS id_32,
  t31.title AS title_33,
  t31.created_at AS created_at_34,
  t31.updated_at AS updated_at_35,
  t31.archived AS archived_36,
  t31.description AS description_37,
  t31.meal_id AS meal_id_38,
  t0.default_side_dish_id AS default_side_dish_id_39,
  t0.meal_group_id AS meal_group_id_40
FROM
  meal t0
  LEFT JOIN recipe t31 ON t31.meal_id = t0.id
  INNER JOIN meal_recommendation ON t0.id = meal_recommendation.meal_target
WHERE
  meal_recommendation.meal_source = ?

SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.name AS name_3, t0.short_code AS short_code_4, t0.description AS description_5, t0.enabled AS enabled_6, t0.position AS position_7, t0.image_name AS image_name_8, t0.image_size AS image_size_9, t0.image_width AS image_width_10, t0.image_height AS image_height_11, t0.updated_at AS updated_at_12, t0.created_at AS created_at_13, t0.price_huf AS price_huf_14, t0.price_eur AS price_eur_15, t0.drink AS drink_16, t0.meal_type AS meal_type_17, t0.packaging_qty AS packaging_qty_18, t0.side_dish AS side_dish_19, t0.side_dish_required AS side_dish_required_20, t0.auto_side_dish AS auto_side_dish_21, t0.side_dish_selectable AS side_dish_selectable_22, t0.surcharge_side_dish AS surcharge_side_dish_23, t0.archived AS archived_24, t0.parent_id AS parent_id_25, t0.vat_local_id AS vat_local_id_26, t0.vat_delivery_id AS vat_delivery_id_27, t0.packaging_unit_id AS packaging_unit_id_28, t0.ntak_main_category_id AS ntak_main_category_id_29, t0.ntak_sub_category_id AS ntak_sub_category_id_30, t31.id AS id_32, t31.title AS title_33, t31.created_at AS created_at_34, t31.updated_at AS updated_at_35, t31.archived AS archived_36, t31.description AS description_37, t31.meal_id AS meal_id_38, t0.default_side_dish_id AS default_side_dish_id_39, t0.meal_group_id AS meal_group_id_40 FROM meal t0 LEFT JOIN recipe t31 ON t31.meal_id = t0.id INNER JOIN meal_recommendation ON t0.id = meal_recommendation.meal_target WHERE meal_recommendation.meal_source = 56;

SELECT
  t0.id AS id_1,
  t0.description AS description_2,
  t0.paying_info AS paying_info_3,
  t0.general_info AS general_info_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.menu_push_info AS menu_push_info_7,
  t0.language_id AS language_id_8,
  t0.restaurant_id AS restaurant_id_9
FROM
  restaurant_translation t0
WHERE
  t0.restaurant_id = ?

SELECT t0.id AS id_1, t0.description AS description_2, t0.paying_info AS paying_info_3, t0.general_info AS general_info_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.menu_push_info AS menu_push_info_7, t0.language_id AS language_id_8, t0.restaurant_id AS restaurant_id_9 FROM restaurant_translation t0 WHERE t0.restaurant_id = 1;