Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.name AS name_3,
  t0.description AS description_4,
  t0.price_cents AS price_cents_5,
  t0.vat_rate AS vat_rate_6,
  t0.position AS position_7,
  t0.active AS active_8,
  t0.open_pricing AS open_pricing_9,
  t0.unit_of_measure AS unit_of_measure_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.shop_id AS shop_id_13,
  t0.category_id AS category_id_14
FROM
  products t0
WHERE
  t0.slug = ?
  AND (
    (t0.shop_id = '5')
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.description AS description_4, t0.price_cents AS price_cents_5, t0.vat_rate AS vat_rate_6, t0.position AS position_7, t0.active AS active_8, t0.open_pricing AS open_pricing_9, t0.unit_of_measure AS unit_of_measure_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.shop_id AS shop_id_13, t0.category_id AS category_id_14 FROM products t0 WHERE t0.slug = 'soupe-oignon-gratinee' AND ((t0.shop_id = '5')) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sku AS sku_3,
  t0.price_delta_cents AS price_delta_cents_4,
  t0.position AS position_5,
  t0.active AS active_6,
  t0.production_mode AS production_mode_7,
  t0.daily_quota_default AS daily_quota_default_8,
  t0.daily_quota_by_weekday AS daily_quota_by_weekday_9,
  t0.shelf_life_days AS shelf_life_days_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.shop_id AS shop_id_13,
  t0.product_id AS product_id_14
FROM
  variants t0
WHERE
  t0.product_id = ?
  AND (
    (t0.shop_id = '5')
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.sku AS sku_3, t0.price_delta_cents AS price_delta_cents_4, t0.position AS position_5, t0.active AS active_6, t0.production_mode AS production_mode_7, t0.daily_quota_default AS daily_quota_default_8, t0.daily_quota_by_weekday AS daily_quota_by_weekday_9, t0.shelf_life_days AS shelf_life_days_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.shop_id AS shop_id_13, t0.product_id AS product_id_14 FROM variants t0 WHERE t0.product_id = '17' AND ((t0.shop_id = '5'));

SELECT
  c0_.id AS id_0,
  c0_.slug AS slug_1,
  c0_.title AS title_2,
  c0_.content AS content_3,
  c0_.menu_position AS menu_position_4,
  c0_.published AS published_5,
  c0_.created_at AS created_at_6,
  c0_.updated_at AS updated_at_7,
  c0_.shop_id AS shop_id_8
FROM
  cms_pages c0_
WHERE
  (
    c0_.published = 1
    AND c0_.menu_position IS NOT NULL
  )
  AND (c0_.shop_id = '5')
ORDER BY
  c0_.menu_position ASC

SELECT c0_.id AS id_0, c0_.slug AS slug_1, c0_.title AS title_2, c0_.content AS content_3, c0_.menu_position AS menu_position_4, c0_.published AS published_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c0_.shop_id AS shop_id_8 FROM cms_pages c0_ WHERE (c0_.published = 1 AND c0_.menu_position IS NOT NULL) AND (c0_.shop_id = '5') ORDER BY c0_.menu_position ASC;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.name AS name_3,
  t0.status AS status_4,
  t0.plan AS plan_5,
  t0.commission_rate AS commission_rate_6,
  t0.loyalty_expiration_months AS loyalty_expiration_months_7,
  t0.admin_note AS admin_note_8,
  t0.stripe_account_id AS stripe_account_id_9,
  t0.stripe_customer_id AS stripe_customer_id_10,
  t0.stripe_subscription_id AS stripe_subscription_id_11,
  t0.primary_color AS primary_color_12,
  t0.accent_color AS accent_color_13,
  t0.bg_color AS bg_color_14,
  t0.fg_color AS fg_color_15,
  t0.contact_phone AS contact_phone_16,
  t0.contact_email AS contact_email_17,
  t0.contact_address AS contact_address_18,
  t0.disabled_payment_modes AS disabled_payment_modes_19,
  t0.pickup_instructions AS pickup_instructions_20,
  t0.is_itinerant AS is_itinerant_21,
  t0.legal_representative_phone AS legal_representative_phone_22,
  t0.legal_representative_role AS legal_representative_role_23,
  t0.siret AS siret_24,
  t0.siret_pending AS siret_pending_25,
  t0.vat_number AS vat_number_26,
  t0.logo_filename AS logo_filename_27,
  t0.logo_size AS logo_size_28,
  t0.logo_mime_type AS logo_mime_type_29,
  t0.cover_filename AS cover_filename_30,
  t0.cover_size AS cover_size_31,
  t0.cover_mime_type AS cover_mime_type_32,
  t0.created_at AS created_at_33,
  t0.updated_at AS updated_at_34
FROM
  shops t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3, t0.status AS status_4, t0.plan AS plan_5, t0.commission_rate AS commission_rate_6, t0.loyalty_expiration_months AS loyalty_expiration_months_7, t0.admin_note AS admin_note_8, t0.stripe_account_id AS stripe_account_id_9, t0.stripe_customer_id AS stripe_customer_id_10, t0.stripe_subscription_id AS stripe_subscription_id_11, t0.primary_color AS primary_color_12, t0.accent_color AS accent_color_13, t0.bg_color AS bg_color_14, t0.fg_color AS fg_color_15, t0.contact_phone AS contact_phone_16, t0.contact_email AS contact_email_17, t0.contact_address AS contact_address_18, t0.disabled_payment_modes AS disabled_payment_modes_19, t0.pickup_instructions AS pickup_instructions_20, t0.is_itinerant AS is_itinerant_21, t0.legal_representative_phone AS legal_representative_phone_22, t0.legal_representative_role AS legal_representative_role_23, t0.siret AS siret_24, t0.siret_pending AS siret_pending_25, t0.vat_number AS vat_number_26, t0.logo_filename AS logo_filename_27, t0.logo_size AS logo_size_28, t0.logo_mime_type AS logo_mime_type_29, t0.cover_filename AS cover_filename_30, t0.cover_size AS cover_size_31, t0.cover_mime_type AS cover_mime_type_32, t0.created_at AS created_at_33, t0.updated_at AS updated_at_34 FROM shops t0 WHERE t0.slug = 'popote' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.alt_text AS alt_text_3,
  t0.position AS position_4,
  t0.size AS size_5,
  t0.mime_type AS mime_type_6,
  t0.updated_at AS updated_at_7,
  t0.created_at AS created_at_8,
  t0.shop_id AS shop_id_9,
  t0.product_id AS product_id_10
FROM
  product_photos t0
WHERE
  t0.product_id = ?
  AND (
    (t0.shop_id = '5')
  )
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.alt_text AS alt_text_3, t0.position AS position_4, t0.size AS size_5, t0.mime_type AS mime_type_6, t0.updated_at AS updated_at_7, t0.created_at AS created_at_8, t0.shop_id AS shop_id_9, t0.product_id AS product_id_10 FROM product_photos t0 WHERE t0.product_id = '17' AND ((t0.shop_id = '5')) ORDER BY t0.position ASC;