Symfony Profiler

SELECT
  t0.type AS type_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.enabled AS enabled_4,
  t0.deposit_refund_enabled AS deposit_refund_enabled_5,
  t0.deposit_refund_optin AS deposit_refund_optin_6,
  t0.shipping_options_days AS shipping_options_days_7,
  t0.image_name AS image_name_8,
  t0.banner_image_name AS banner_image_name_9,
  t0.website AS website_10,
  t0.telephone AS telephone_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.legal_name AS legal_name_14,
  t0.delivery_perimeter_expression AS delivery_perimeter_expression_15,
  t0.vat_id AS vat_id_16,
  t0.additional_properties AS additional_properties_17,
  t0.rate_limit_range_duration AS rate_limit_range_duration_18,
  t0.rate_limit_amount AS rate_limit_amount_19,
  t0.state AS state_20,
  t0.stripe_connect_roles AS stripe_connect_roles_21,
  t0.mercadopago_connect_roles AS mercadopago_connect_roles_22,
  t0.deleted_at AS deleted_at_23,
  t0.exclusive AS exclusive_24,
  t0.quotes_allowed AS quotes_allowed_25,
  t0.loopeat_enabled AS loopeat_enabled_26,
  t0.loopeat_mandatory AS loopeat_mandatory_27,
  t0.loopeat_access_token AS loopeat_access_token_28,
  t0.loopeat_refresh_token AS loopeat_refresh_token_29,
  t0.featured AS featured_30,
  t0.stripe_payment_methods AS stripe_payment_methods_31,
  t0.edenred_merchant_id AS edenred_merchant_id_32,
  t0.edenred_enabled AS edenred_enabled_33,
  t0.edenred_trcard_enabled AS edenred_trcard_enabled_34,
  t0.edenred_sync_sent AS edenred_sync_sent_35,
  t0.vytal_enabled AS vytal_enabled_36,
  t0.cash_on_delivery_enabled AS cash_on_delivery_enabled_37,
  t0.en_boite_le_plat_enabled AS en_boite_le_plat_enabled_38,
  t0.en_boite_le_plat_platform_fee AS en_boite_le_plat_platform_fee_39,
  t0.auto_accept_orders_enabled AS auto_accept_orders_enabled_40,
  t0.paygreen_shop_id AS paygreen_shop_id_41,
  t0.billing_method AS billing_method_42,
  t0.payment_gateway AS payment_gateway_43,
  t0.pawapay_enabled AS pawapay_enabled_44,
  t0.id AS id_45,
  t0.pledge_id AS pledge_id_46,
  t0.mercadopago_account_id AS mercadopago_account_id_47,
  t0.contract_id AS contract_id_48,
  t0.address_id AS address_id_49,
  t50.name AS name_51,
  t50.description AS description_52,
  ST_AsEWKT(t50.geo) AS geo_53,
  t50.address_country AS address_country_54,
  t50.address_locality AS address_locality_55,
  t50.address_region AS address_region_56,
  t50.postal_code AS postal_code_57,
  t50.post_office_box_number AS post_office_box_number_58,
  t50.street_address AS street_address_59,
  t50.company AS company_60,
  t50.telephone AS telephone_61,
  t50.contact_name AS contact_name_62,
  t50.provider AS provider_63,
  t50.deleted_at AS deleted_at_64,
  t50.id AS id_65,
  t0.business_address_id AS business_address_id_66,
  t0.active_menu_taxon_id AS active_menu_taxon_id_67,
  t0.organization_id AS organization_id_68,
  t0.hub_id AS hub_id_69,
  t0.failure_reason_set_id AS failure_reason_set_id_70
FROM
  restaurant t0
  LEFT JOIN address t50 ON t0.address_id = t50.id
WHERE
  t0.id = ?

SELECT t0.type AS type_1, t0.name AS name_2, t0.description AS description_3, t0.enabled AS enabled_4, t0.deposit_refund_enabled AS deposit_refund_enabled_5, t0.deposit_refund_optin AS deposit_refund_optin_6, t0.shipping_options_days AS shipping_options_days_7, t0.image_name AS image_name_8, t0.banner_image_name AS banner_image_name_9, t0.website AS website_10, t0.telephone AS telephone_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.legal_name AS legal_name_14, t0.delivery_perimeter_expression AS delivery_perimeter_expression_15, t0.vat_id AS vat_id_16, t0.additional_properties AS additional_properties_17, t0.rate_limit_range_duration AS rate_limit_range_duration_18, t0.rate_limit_amount AS rate_limit_amount_19, t0.state AS state_20, t0.stripe_connect_roles AS stripe_connect_roles_21, t0.mercadopago_connect_roles AS mercadopago_connect_roles_22, t0.deleted_at AS deleted_at_23, t0.exclusive AS exclusive_24, t0.quotes_allowed AS quotes_allowed_25, t0.loopeat_enabled AS loopeat_enabled_26, t0.loopeat_mandatory AS loopeat_mandatory_27, t0.loopeat_access_token AS loopeat_access_token_28, t0.loopeat_refresh_token AS loopeat_refresh_token_29, t0.featured AS featured_30, t0.stripe_payment_methods AS stripe_payment_methods_31, t0.edenred_merchant_id AS edenred_merchant_id_32, t0.edenred_enabled AS edenred_enabled_33, t0.edenred_trcard_enabled AS edenred_trcard_enabled_34, t0.edenred_sync_sent AS edenred_sync_sent_35, t0.vytal_enabled AS vytal_enabled_36, t0.cash_on_delivery_enabled AS cash_on_delivery_enabled_37, t0.en_boite_le_plat_enabled AS en_boite_le_plat_enabled_38, t0.en_boite_le_plat_platform_fee AS en_boite_le_plat_platform_fee_39, t0.auto_accept_orders_enabled AS auto_accept_orders_enabled_40, t0.paygreen_shop_id AS paygreen_shop_id_41, t0.billing_method AS billing_method_42, t0.payment_gateway AS payment_gateway_43, t0.pawapay_enabled AS pawapay_enabled_44, t0.id AS id_45, t0.pledge_id AS pledge_id_46, t0.mercadopago_account_id AS mercadopago_account_id_47, t0.contract_id AS contract_id_48, t0.address_id AS address_id_49, t50.name AS name_51, t50.description AS description_52, ST_AsEWKT(t50.geo) AS geo_53, t50.address_country AS address_country_54, t50.address_locality AS address_locality_55, t50.address_region AS address_region_56, t50.postal_code AS postal_code_57, t50.post_office_box_number AS post_office_box_number_58, t50.street_address AS street_address_59, t50.company AS company_60, t50.telephone AS telephone_61, t50.contact_name AS contact_name_62, t50.provider AS provider_63, t50.deleted_at AS deleted_at_64, t50.id AS id_65, t0.business_address_id AS business_address_id_66, t0.active_menu_taxon_id AS active_menu_taxon_id_67, t0.organization_id AS organization_id_68, t0.hub_id AS hub_id_69, t0.failure_reason_set_id AS failure_reason_set_id_70 FROM restaurant t0 LEFT JOIN address t50 ON t0.address_id = t50.id WHERE t0.id = '1';

SELECT
  t0.days_of_week AS days_of_week_1,
  t0.id AS id_2,
  t0.restaurant_id AS restaurant_id_3,
  t0.address_id AS address_id_4
FROM
  restaurant_day_of_week_address t0
WHERE
  t0.restaurant_id = ?

SELECT t0.days_of_week AS days_of_week_1, t0.id AS id_2, t0.restaurant_id AS restaurant_id_3, t0.address_id AS address_id_4 FROM restaurant_day_of_week_address t0 WHERE t0.restaurant_id = 1;

SELECT
  r0_.id AS id_0,
  s1_.id AS id_1
FROM
  restaurant r0_
  INNER JOIN restaurant_taxon r2_ ON r0_.id = r2_.restaurant_id
  INNER JOIN sylius_taxon s1_ ON s1_.id = r2_.taxon_id
WHERE
  (
    r0_.id IN (?)
  )
  AND (r0_.deleted_at IS NULL)

SELECT r0_.id AS id_0, s1_.id AS id_1 FROM restaurant r0_ INNER JOIN restaurant_taxon r2_ ON r0_.id = r2_.restaurant_id INNER JOIN sylius_taxon s1_ ON s1_.id = r2_.taxon_id WHERE (r0_.id IN (1)) AND (r0_.deleted_at IS NULL);

SELECT
  s0_.code AS code_0,
  s0_.tree_left AS tree_left_1,
  s0_.tree_right AS tree_right_2,
  s0_.tree_level AS tree_level_3,
  s0_.position AS position_4,
  s0_.enabled AS enabled_5,
  s0_.id AS id_6,
  s0_.tree_root AS tree_root_7,
  s0_.parent_id AS parent_id_8
FROM
  sylius_taxon s0_
WHERE
  s0_.id IN (?)

SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.tree_root AS tree_root_7, s0_.parent_id AS parent_id_8 FROM sylius_taxon s0_ WHERE s0_.id IN (1);

SELECT
  s0_.code AS code_0,
  s0_.tree_left AS tree_left_1,
  s0_.tree_right AS tree_right_2,
  s0_.tree_level AS tree_level_3,
  s0_.position AS position_4,
  s0_.enabled AS enabled_5,
  s0_.id AS id_6,
  s0_.tree_root AS tree_root_7,
  s0_.parent_id AS parent_id_8
FROM
  sylius_taxon s0_
WHERE
  s0_.parent_id IN (?)
ORDER BY
  s0_.position ASC

SELECT s0_.code AS code_0, s0_.tree_left AS tree_left_1, s0_.tree_right AS tree_right_2, s0_.tree_level AS tree_level_3, s0_.position AS position_4, s0_.enabled AS enabled_5, s0_.id AS id_6, s0_.tree_root AS tree_root_7, s0_.parent_id AS parent_id_8 FROM sylius_taxon s0_ WHERE s0_.parent_id IN (1) ORDER BY s0_.position ASC;

SELECT
  s0_.position AS position_0,
  s0_.id AS id_1,
  s0_.product_id AS product_id_2,
  s0_.taxon_id AS taxon_id_3
FROM
  sylius_product_taxon s0_
WHERE
  s0_.taxon_id IN (?)
ORDER BY
  s0_.position ASC

SELECT s0_.position AS position_0, s0_.id AS id_1, s0_.product_id AS product_id_2, s0_.taxon_id AS taxon_id_3 FROM sylius_product_taxon s0_ WHERE s0_.taxon_id IN (2) ORDER BY s0_.position ASC;

SELECT
  s0_.code AS code_0,
  s0_.created_at AS created_at_1,
  s0_.updated_at AS updated_at_2,
  s0_.enabled AS enabled_3,
  s0_.id AS id_4,
  s0_.deleted_at AS deleted_at_5,
  s0_.reusable_packaging_enabled AS reusable_packaging_enabled_6,
  s0_.alcohol AS alcohol_7,
  s0_.restaurant_id AS restaurant_id_8
FROM
  sylius_product s0_
WHERE
  (
    s0_.id IN (?)
  )
  AND (s0_.deleted_at IS NULL)

SELECT s0_.code AS code_0, s0_.created_at AS created_at_1, s0_.updated_at AS updated_at_2, s0_.enabled AS enabled_3, s0_.id AS id_4, s0_.deleted_at AS deleted_at_5, s0_.reusable_packaging_enabled AS reusable_packaging_enabled_6, s0_.alcohol AS alcohol_7, s0_.restaurant_id AS restaurant_id_8 FROM sylius_product s0_ WHERE (s0_.id IN (2)) AND (s0_.deleted_at IS NULL);

SELECT
  t0.position AS position_1,
  t0.enabled AS enabled_2,
  t0.id AS id_3,
  t0.product_id AS product_id_4,
  t0.option_id AS option_id_5
FROM
  sylius_product_options t0
WHERE
  t0.product_id IN (?)
  AND (
    (t0.enabled = '1')
  )

SELECT t0.position AS position_1, t0.enabled AS enabled_2, t0.id AS id_3, t0.product_id AS product_id_4, t0.option_id AS option_id_5 FROM sylius_product_options t0 WHERE t0.product_id IN (2) AND ((t0.enabled = '1'));

SELECT
  t0.locale_code AS locale_code_1,
  t0.text_value AS text_value_2,
  t0.boolean_value AS boolean_value_3,
  t0.integer_value AS integer_value_4,
  t0.float_value AS float_value_5,
  t0.datetime_value AS datetime_value_6,
  t0.date_value AS date_value_7,
  t0.json_value AS json_value_8,
  t0.id AS id_9,
  t0.product_id AS product_id_10,
  t0.attribute_id AS attribute_id_11
FROM
  sylius_product_attribute_value t0
WHERE
  t0.product_id IN (?)

SELECT t0.locale_code AS locale_code_1, t0.text_value AS text_value_2, t0.boolean_value AS boolean_value_3, t0.integer_value AS integer_value_4, t0.float_value AS float_value_5, t0.datetime_value AS datetime_value_6, t0.date_value AS date_value_7, t0.json_value AS json_value_8, t0.id AS id_9, t0.product_id AS product_id_10, t0.attribute_id AS attribute_id_11 FROM sylius_product_attribute_value t0 WHERE t0.product_id IN (2);

SELECT
  t0.image_name AS image_name_1,
  t0.ratio AS ratio_2,
  t0.updated_at AS updated_at_3,
  t0.id AS id_4,
  t0.product_id AS product_id_5
FROM
  sylius_product_image t0
WHERE
  t0.product_id IN (?)

SELECT t0.image_name AS image_name_1, t0.ratio AS ratio_2, t0.updated_at AS updated_at_3, t0.id AS id_4, t0.product_id AS product_id_5 FROM sylius_product_image t0 WHERE t0.product_id IN (2);

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.color AS color_3,
  t0.description AS description_4,
  t0.enabled AS enabled_5,
  t0.hostname AS hostname_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.id AS id_9
FROM
  sylius_channel t0
WHERE
  t0.code = ?
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.code AS code_1, t0.name AS name_2, t0.color AS color_3, t0.description AS description_4, t0.enabled AS enabled_5, t0.hostname AS hostname_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.id AS id_9 FROM sylius_channel t0 WHERE t0.code = 'web' ORDER BY t0.id ASC LIMIT 1;

SELECT
  t0.type AS type_1,
  t0.opening_hours AS opening_hours_2,
  t0.opening_hours_behavior AS opening_hours_behavior_3,
  t0.options AS options_4,
  t0.minimum_amount AS minimum_amount_5,
  t0.ordering_delay_minutes AS ordering_delay_minutes_6,
  t0.pre_ordering_allowed AS pre_ordering_allowed_7,
  t0.enabled AS enabled_8,
  t0.id AS id_9
FROM
  restaurant_fulfillment_method t0
  INNER JOIN restaurant_fulfillment_methods ON t0.id = restaurant_fulfillment_methods.method_id
WHERE
  restaurant_fulfillment_methods.restaurant_id = ?

SELECT t0.type AS type_1, t0.opening_hours AS opening_hours_2, t0.opening_hours_behavior AS opening_hours_behavior_3, t0.options AS options_4, t0.minimum_amount AS minimum_amount_5, t0.ordering_delay_minutes AS ordering_delay_minutes_6, t0.pre_ordering_allowed AS pre_ordering_allowed_7, t0.enabled AS enabled_8, t0.id AS id_9 FROM restaurant_fulfillment_method t0 INNER JOIN restaurant_fulfillment_methods ON t0.id = restaurant_fulfillment_methods.method_id WHERE restaurant_fulfillment_methods.restaurant_id = 1;

SELECT
  t0.start_date AS start_date_1,
  t0.end_date AS end_date_2,
  t0.reason AS reason_3,
  t0.id AS id_4
FROM
  closing_rule t0
  INNER JOIN restaurant_closing_rule ON t0.id = restaurant_closing_rule.rule_id
WHERE
  restaurant_closing_rule.restaurant_id = ?

SELECT t0.start_date AS start_date_1, t0.end_date AS end_date_2, t0.reason AS reason_3, t0.id AS id_4 FROM closing_rule t0 INNER JOIN restaurant_closing_rule ON t0.id = restaurant_closing_rule.rule_id WHERE restaurant_closing_rule.restaurant_id = 1;

SELECT
  t0.expression AS expression_1,
  t0.position AS position_2,
  t0.time AS time_3,
  t0.id AS id_4,
  t0.restaurant_id AS restaurant_id_5
FROM
  restaurant_preparation_time_rule t0
WHERE
  t0.restaurant_id = ?
ORDER BY
  t0.position ASC

SELECT t0.expression AS expression_1, t0.position AS position_2, t0.time AS time_3, t0.id AS id_4, t0.restaurant_id AS restaurant_id_5 FROM restaurant_preparation_time_rule t0 WHERE t0.restaurant_id = 1 ORDER BY t0.position ASC;

SELECT
  t0.flat_delivery_price AS flat_delivery_price_1,
  t0.variable_delivery_price_enabled AS variable_delivery_price_enabled_2,
  t0.variable_customer_amount_enabled AS variable_customer_amount_enabled_3,
  t0.fee_rate AS fee_rate_4,
  t0.restaurant_pays_stripe AS restaurant_pays_stripe_5,
  t0.customer_amount AS customer_amount_6,
  t0.take_away_fee_rate AS take_away_fee_rate_7,
  t0.id AS id_8,
  t0.variable_delivery_price_id AS variable_delivery_price_id_9,
  t0.variable_customer_amount_id AS variable_customer_amount_id_10
FROM
  contract t0
WHERE
  t0.id = ?

SELECT t0.flat_delivery_price AS flat_delivery_price_1, t0.variable_delivery_price_enabled AS variable_delivery_price_enabled_2, t0.variable_customer_amount_enabled AS variable_customer_amount_enabled_3, t0.fee_rate AS fee_rate_4, t0.restaurant_pays_stripe AS restaurant_pays_stripe_5, t0.customer_amount AS customer_amount_6, t0.take_away_fee_rate AS take_away_fee_rate_7, t0.id AS id_8, t0.variable_delivery_price_id AS variable_delivery_price_id_9, t0.variable_customer_amount_id AS variable_customer_amount_id_10 FROM contract t0 WHERE t0.id = 1;

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.description AS description_3,
  t0.priority AS priority_4,
  t0.exclusive AS exclusive_5,
  t0.usage_limit AS usage_limit_6,
  t0.used AS used_7,
  t0.coupon_based AS coupon_based_8,
  t0.starts_at AS starts_at_9,
  t0.ends_at AS ends_at_10,
  t0.applies_to_discounted AS applies_to_discounted_11,
  t0.archived_at AS archived_at_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.id AS id_15,
  t0.featured AS featured_16
FROM
  sylius_promotion t0
  INNER JOIN restaurant_promotion ON t0.id = restaurant_promotion.promotion_id
WHERE
  restaurant_promotion.restaurant_id = ?

SELECT t0.code AS code_1, t0.name AS name_2, t0.description AS description_3, t0.priority AS priority_4, t0.exclusive AS exclusive_5, t0.usage_limit AS usage_limit_6, t0.used AS used_7, t0.coupon_based AS coupon_based_8, t0.starts_at AS starts_at_9, t0.ends_at AS ends_at_10, t0.applies_to_discounted AS applies_to_discounted_11, t0.archived_at AS archived_at_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.id AS id_15, t0.featured AS featured_16 FROM sylius_promotion t0 INNER JOIN restaurant_promotion ON t0.id = restaurant_promotion.promotion_id WHERE restaurant_promotion.restaurant_id = 1;

SELECT
  t0.name AS name_1,
  t0.slug AS slug_2,
  t0.description AS description_3,
  t0.id AS id_4,
  t0.locale AS locale_5,
  t0.translatable_id AS translatable_id_6
FROM
  sylius_taxon_translation t0
WHERE
  t0.translatable_id = ?
  AND t0.locale = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.slug AS slug_2, t0.description AS description_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM sylius_taxon_translation t0 WHERE t0.translatable_id = 2 AND t0.locale = 'en' LIMIT 1;

SELECT
  t0.code AS code_1,
  t0.type AS type_2,
  t0.storage_type AS storage_type_3,
  t0.configuration AS configuration_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.position AS position_7,
  t0.translatable AS translatable_8,
  t0.id AS id_9
FROM
  sylius_product_attribute t0
WHERE
  t0.id = ?

SELECT t0.code AS code_1, t0.type AS type_2, t0.storage_type AS storage_type_3, t0.configuration AS configuration_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.position AS position_7, t0.translatable AS translatable_8, t0.id AS id_9 FROM sylius_product_attribute t0 WHERE t0.id = 1;