Symfony Profiler

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.address AS address_2,
  s0_.postal_code AS postal_code_3,
  s0_.location AS location_4,
  s0_.waiter_call_sound AS waiter_call_sound_5,
  s0_.latitude AS latitude_6,
  s0_.longitude AS longitude_7,
  s0_.mail AS mail_8,
  s0_.phone AS phone_9,
  s0_.working_date AS working_date_10,
  s0_.logo_file_name AS logo_file_name_11,
  s0_.cover_file_name AS cover_file_name_12,
  s0_.allow_guest_order AS allow_guest_order_13,
  s0_.require_table_selection AS require_table_selection_14,
  s0_.kitchen_delayed_minutes AS kitchen_delayed_minutes_15,
  s0_.ready_not_served_minutes AS ready_not_served_minutes_16,
  s0_.dirty_minutes AS dirty_minutes_17,
  s0_.allow_waiter_call AS allow_waiter_call_18,
  s0_.service_fee_payer AS service_fee_payer_19,
  s0_.service_fee_fixed AS service_fee_fixed_20,
  s0_.service_fee_percent AS service_fee_percent_21,
  s0_.service_fee_waived AS service_fee_waived_22,
  s0_.service_fee_free_until AS service_fee_free_until_23,
  s0_.deleted_at AS deleted_at_24,
  s0_.is_active AS is_active_25,
  s0_.created_at AS created_at_26,
  s0_.updated_at AS updated_at_27,
  s0_.store_type_id AS store_type_id_28,
  s0_.company_id AS company_id_29,
  s0_.default_currency AS default_currency_30,
  s0_.language_code AS language_code_31
FROM
  store s0_
WHERE
  (
    s0_.is_active = ?
    AND s0_.store_type_id = ?
  )
  AND (s0_.deleted_at IS NULL)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.address AS address_2, s0_.postal_code AS postal_code_3, s0_.location AS location_4, s0_.waiter_call_sound AS waiter_call_sound_5, s0_.latitude AS latitude_6, s0_.longitude AS longitude_7, s0_.mail AS mail_8, s0_.phone AS phone_9, s0_.working_date AS working_date_10, s0_.logo_file_name AS logo_file_name_11, s0_.cover_file_name AS cover_file_name_12, s0_.allow_guest_order AS allow_guest_order_13, s0_.require_table_selection AS require_table_selection_14, s0_.kitchen_delayed_minutes AS kitchen_delayed_minutes_15, s0_.ready_not_served_minutes AS ready_not_served_minutes_16, s0_.dirty_minutes AS dirty_minutes_17, s0_.allow_waiter_call AS allow_waiter_call_18, s0_.service_fee_payer AS service_fee_payer_19, s0_.service_fee_fixed AS service_fee_fixed_20, s0_.service_fee_percent AS service_fee_percent_21, s0_.service_fee_waived AS service_fee_waived_22, s0_.service_fee_free_until AS service_fee_free_until_23, s0_.deleted_at AS deleted_at_24, s0_.is_active AS is_active_25, s0_.created_at AS created_at_26, s0_.updated_at AS updated_at_27, s0_.store_type_id AS store_type_id_28, s0_.company_id AS company_id_29, s0_.default_currency AS default_currency_30, s0_.language_code AS language_code_31 FROM store s0_ WHERE (s0_.is_active = 1 AND s0_.store_type_id = '1') AND (s0_.deleted_at IS NULL);

SELECT
  m0_.store_id AS sclr_0,
  AVG(m0_.overall) AS sclr_1,
  COUNT(m0_.id) AS sclr_2
FROM
  member_store_rating m0_
WHERE
  m0_.store_id IN (?, ?)
  AND m0_.created_at >= ?
GROUP BY
  m0_.store_id

SELECT m0_.store_id AS sclr_0, AVG(m0_.overall) AS sclr_1, COUNT(m0_.id) AS sclr_2 FROM member_store_rating m0_ WHERE m0_.store_id IN (5, 7) AND m0_.created_at >= '2025-09-20 07:11:14' GROUP BY m0_.store_id;

SELECT
  count(s0_.id) AS sclr_0
FROM
  store s0_
WHERE
  (
    s0_.is_active = ?
    AND s0_.store_type_id = ?
  )
  AND (s0_.deleted_at IS NULL)

SELECT count(s0_.id) AS sclr_0 FROM store s0_ WHERE (s0_.is_active = 1 AND s0_.store_type_id = '1') AND (s0_.deleted_at IS NULL);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.company_name AS company_name_3,
  t0.address AS address_4,
  t0.email AS email_5,
  t0.phone AS phone_6,
  t0.tax_id AS tax_id_7,
  t0.tax_office AS tax_office_8,
  t0.token AS token_9,
  t0.deleted_at AS deleted_at_10,
  t0.is_active AS is_active_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.company_type AS company_type_14
FROM
  company t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.company_name AS company_name_3, t0.address AS address_4, t0.email AS email_5, t0.phone AS phone_6, t0.tax_id AS tax_id_7, t0.tax_office AS tax_office_8, t0.token AS token_9, t0.deleted_at AS deleted_at_10, t0.is_active AS is_active_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.company_type AS company_type_14 FROM company t0 WHERE t0.id = 2 AND ((t0.deleted_at IS NULL));

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.display_name AS display_name_3,
  t0.is_default AS is_default_4,
  t0.deleted_at AS deleted_at_5,
  t0.is_active AS is_active_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  sta_language t0
WHERE
  t0.is_default = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.code AS code_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.is_default AS is_default_4, t0.deleted_at AS deleted_at_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM sta_language t0 WHERE t0.is_default = 1 AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.payment_type_code AS payment_type_code_2,
  t0.store_id AS store_id_3
FROM
  store_payment_type t0
WHERE
  t0.store_id = ?

SELECT t0.id AS id_1, t0.payment_type_code AS payment_type_code_2, t0.store_id AS store_id_3 FROM store_payment_type t0 WHERE t0.store_id = 5;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.name_translations AS name_translations_2,
  s0_.deleted_at AS deleted_at_3,
  s0_.is_active AS is_active_4,
  s0_.created_at AS created_at_5,
  s0_.updated_at AS updated_at_6
FROM
  sta_store_type s0_
WHERE
  (s0_.is_active = ?)
  AND (s0_.deleted_at IS NULL)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.name_translations AS name_translations_2, s0_.deleted_at AS deleted_at_3, s0_.is_active AS is_active_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6 FROM sta_store_type s0_ WHERE (s0_.is_active = 1) AND (s0_.deleted_at IS NULL);

SELECT
  count(s0_.id) AS sclr_0
FROM
  sta_store_type s0_
WHERE
  (s0_.is_active = ?)
  AND (s0_.deleted_at IS NULL)

SELECT count(s0_.id) AS sclr_0 FROM sta_store_type s0_ WHERE (s0_.is_active = 1) AND (s0_.deleted_at IS NULL);

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.iso_number AS iso_number_3,
  t0.unicode_sign AS unicode_sign_4,
  t0.sort_order AS sort_order_5,
  t0.is_default AS is_default_6,
  t0.deleted_at AS deleted_at_7,
  t0.is_active AS is_active_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10
FROM
  sta_currency t0
WHERE
  t0.code = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.code AS code_1, t0.name AS name_2, t0.iso_number AS iso_number_3, t0.unicode_sign AS unicode_sign_4, t0.sort_order AS sort_order_5, t0.is_default AS is_default_6, t0.deleted_at AS deleted_at_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM sta_currency t0 WHERE t0.code = 'EUR' AND ((t0.deleted_at IS NULL));

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.display_name AS display_name_3,
  t0.is_default AS is_default_4,
  t0.deleted_at AS deleted_at_5,
  t0.is_active AS is_active_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  sta_language t0
WHERE
  t0.is_active = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.code AS code_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.is_default AS is_default_4, t0.deleted_at AS deleted_at_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM sta_language t0 WHERE t0.is_active = 1 AND ((t0.deleted_at IS NULL));

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.display_name AS display_name_3,
  t0.is_default AS is_default_4,
  t0.deleted_at AS deleted_at_5,
  t0.is_active AS is_active_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8
FROM
  sta_language t0
WHERE
  t0.is_active = ?
  AND (
    (t0.deleted_at IS NULL)
  )
ORDER BY
  t0.code ASC

SELECT t0.code AS code_1, t0.name AS name_2, t0.display_name AS display_name_3, t0.is_default AS is_default_4, t0.deleted_at AS deleted_at_5, t0.is_active AS is_active_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8 FROM sta_language t0 WHERE t0.is_active = 1 AND ((t0.deleted_at IS NULL)) ORDER BY t0.code ASC;