Symfony Profiler

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.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.postal_code AS postal_code_4,
  t0.location AS location_5,
  t0.waiter_call_sound AS waiter_call_sound_6,
  t0.latitude AS latitude_7,
  t0.longitude AS longitude_8,
  t0.mail AS mail_9,
  t0.phone AS phone_10,
  t0.working_date AS working_date_11,
  t0.logo_file_name AS logo_file_name_12,
  t0.cover_file_name AS cover_file_name_13,
  t0.allow_guest_order AS allow_guest_order_14,
  t0.require_table_selection AS require_table_selection_15,
  t0.kitchen_delayed_minutes AS kitchen_delayed_minutes_16,
  t0.ready_not_served_minutes AS ready_not_served_minutes_17,
  t0.dirty_minutes AS dirty_minutes_18,
  t0.allow_waiter_call AS allow_waiter_call_19,
  t0.service_fee_payer AS service_fee_payer_20,
  t0.service_fee_fixed AS service_fee_fixed_21,
  t0.service_fee_percent AS service_fee_percent_22,
  t0.service_fee_waived AS service_fee_waived_23,
  t0.service_fee_free_until AS service_fee_free_until_24,
  t0.deleted_at AS deleted_at_25,
  t0.is_active AS is_active_26,
  t0.created_at AS created_at_27,
  t0.updated_at AS updated_at_28,
  t0.store_type_id AS store_type_id_29,
  t0.company_id AS company_id_30,
  t0.default_currency AS default_currency_31,
  t0.language_code AS language_code_32
FROM
  store t0
WHERE
  t0.name = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.postal_code AS postal_code_4, t0.location AS location_5, t0.waiter_call_sound AS waiter_call_sound_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.mail AS mail_9, t0.phone AS phone_10, t0.working_date AS working_date_11, t0.logo_file_name AS logo_file_name_12, t0.cover_file_name AS cover_file_name_13, t0.allow_guest_order AS allow_guest_order_14, t0.require_table_selection AS require_table_selection_15, t0.kitchen_delayed_minutes AS kitchen_delayed_minutes_16, t0.ready_not_served_minutes AS ready_not_served_minutes_17, t0.dirty_minutes AS dirty_minutes_18, t0.allow_waiter_call AS allow_waiter_call_19, t0.service_fee_payer AS service_fee_payer_20, t0.service_fee_fixed AS service_fee_fixed_21, t0.service_fee_percent AS service_fee_percent_22, t0.service_fee_waived AS service_fee_waived_23, t0.service_fee_free_until AS service_fee_free_until_24, t0.deleted_at AS deleted_at_25, t0.is_active AS is_active_26, t0.created_at AS created_at_27, t0.updated_at AS updated_at_28, t0.store_type_id AS store_type_id_29, t0.company_id AS company_id_30, t0.default_currency AS default_currency_31, t0.language_code AS language_code_32 FROM store t0 WHERE t0.name = 'bakkal' 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 = ?
  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.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
  AVG(m0_.overall) AS sclr_0,
  COUNT(m0_.id) AS sclr_1
FROM
  member_store_rating m0_
WHERE
  m0_.store_id = ?
  AND m0_.created_at >= ?

SELECT AVG(m0_.overall) AS sclr_0, COUNT(m0_.id) AS sclr_1 FROM member_store_rating m0_ WHERE m0_.store_id = 7 AND m0_.created_at >= '2025-09-20 08:04:36';

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 = 4 AND ((t0.deleted_at IS NULL));

SELECT
  s0_.language_code AS sclr_0
FROM
  store s0_
WHERE
  (s0_.name = ?)
  AND (s0_.deleted_at IS NULL)
LIMIT
  1

SELECT s0_.language_code AS sclr_0 FROM store s0_ WHERE (s0_.name = 'bakkal') AND (s0_.deleted_at IS NULL) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.name_translations AS name_translations_3,
  t0.deleted_at AS deleted_at_4,
  t0.is_active AS is_active_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7
FROM
  sta_store_type t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.name_translations AS name_translations_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM sta_store_type t0 WHERE t0.id = 1 AND ((t0.deleted_at IS NULL));

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.name_translations AS name_translations_2,
  s0_.image_file_name AS image_file_name_3,
  s0_.deleted_at AS deleted_at_4,
  s0_.is_active AS is_active_5,
  s0_.created_at AS created_at_6,
  s0_.updated_at AS updated_at_7,
  s0_.store_id AS store_id_8,
  s0_.income_department_id AS income_department_id_9,
  s0_.station_id AS station_id_10
FROM
  store_product_group s0_
WHERE
  (s0_.store_id = ?)
  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_.image_file_name AS image_file_name_3, s0_.deleted_at AS deleted_at_4, s0_.is_active AS is_active_5, s0_.created_at AS created_at_6, s0_.updated_at AS updated_at_7, s0_.store_id AS store_id_8, s0_.income_department_id AS income_department_id_9, s0_.station_id AS station_id_10 FROM store_product_group s0_ WHERE (s0_.store_id = 7) AND (s0_.deleted_at IS NULL);

SELECT
  s0_.id AS id_0,
  s0_.table_number AS table_number_1,
  s0_.max_capacity AS max_capacity_2,
  s0_.accepts_orders AS accepts_orders_3,
  s0_.status_override AS status_override_4,
  s0_.status_override_at AS status_override_at_5,
  s0_.deleted_at AS deleted_at_6,
  s0_.is_active AS is_active_7,
  s0_.created_at AS created_at_8,
  s0_.updated_at AS updated_at_9,
  s0_.store_id AS store_id_10,
  s0_.table_location_id AS table_location_id_11,
  s0_.shape AS shape_12
FROM
  store_table s0_
WHERE
  (
    s0_.store_id = ?
    AND s0_.is_active = ?
  )
  AND (s0_.deleted_at IS NULL)

SELECT s0_.id AS id_0, s0_.table_number AS table_number_1, s0_.max_capacity AS max_capacity_2, s0_.accepts_orders AS accepts_orders_3, s0_.status_override AS status_override_4, s0_.status_override_at AS status_override_at_5, s0_.deleted_at AS deleted_at_6, s0_.is_active AS is_active_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9, s0_.store_id AS store_id_10, s0_.table_location_id AS table_location_id_11, s0_.shape AS shape_12 FROM store_table s0_ WHERE (s0_.store_id = 7 AND s0_.is_active = 1) AND (s0_.deleted_at IS NULL);

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.deleted_at AS deleted_at_2,
  s0_.is_active AS is_active_3,
  s0_.created_at AS created_at_4,
  s0_.updated_at AS updated_at_5,
  s0_.store_id AS store_id_6
FROM
  store_table_location s0_
WHERE
  (s0_.store_id = ?)
  AND (s0_.deleted_at IS NULL)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.deleted_at AS deleted_at_2, s0_.is_active AS is_active_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.store_id AS store_id_6 FROM store_table_location s0_ WHERE (s0_.store_id = 7) AND (s0_.deleted_at IS NULL);

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

SELECT count(s0_.id) AS sclr_0 FROM store_product_group s0_ WHERE (s0_.store_id = 7) AND (s0_.deleted_at IS NULL);

SELECT
  DISTINCT s0_.table_id AS sclr_0
FROM
  store_bill_table s0_
  INNER JOIN store_bill s1_ ON s0_.bill_id = s1_.id
  AND (s1_.deleted_at IS NULL)
WHERE
  (
    s1_.store_id = ?
    AND s1_.is_closed = ?
  )
  AND (s0_.deleted_at IS NULL)

SELECT DISTINCT s0_.table_id AS sclr_0 FROM store_bill_table s0_ INNER JOIN store_bill s1_ ON s0_.bill_id = s1_.id AND (s1_.deleted_at IS NULL) WHERE (s1_.store_id = 7 AND s1_.is_closed = 0) AND (s0_.deleted_at IS NULL);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.endpoint AS endpoint_3,
  t0.component AS component_4,
  t0.username AS username_5,
  t0.password AS password_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,
  t0.integration_type AS integration_type_11,
  t0.company_id AS company_id_12
FROM
  integration t0
WHERE
  t0.integration_type = ?
  AND t0.company_id = ?
  AND t0.is_active = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.endpoint AS endpoint_3, t0.component AS component_4, t0.username AS username_5, t0.password AS password_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, t0.integration_type AS integration_type_11, t0.company_id AS company_id_12 FROM integration t0 WHERE t0.integration_type = 'PAYTOKEN' AND t0.company_id = 4 AND t0.is_active = 1 AND ((t0.deleted_at IS NULL)) LIMIT 1;

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

SELECT count(s0_.id) AS sclr_0 FROM store_table_location s0_ WHERE (s0_.store_id = 7) AND (s0_.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;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.endpoint AS endpoint_3,
  t0.component AS component_4,
  t0.username AS username_5,
  t0.password AS password_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,
  t0.integration_type AS integration_type_11,
  t0.company_id AS company_id_12
FROM
  integration t0
WHERE
  t0.integration_type = ?
  AND t0.company_id IS NULL
  AND t0.is_active = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.endpoint AS endpoint_3, t0.component AS component_4, t0.username AS username_5, t0.password AS password_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, t0.integration_type AS integration_type_11, t0.company_id AS company_id_12 FROM integration t0 WHERE t0.integration_type = 'PAYTOKEN' AND t0.company_id IS NULL AND t0.is_active = 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 = 7;

SELECT
  t0.id AS id_1,
  t0.setting_key AS setting_key_2,
  t0.setting_value AS setting_value_3,
  t0.deleted_at AS deleted_at_4,
  t0.is_active AS is_active_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.company AS company_8
FROM
  company_settings t0
WHERE
  t0.company = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.deleted_at AS deleted_at_4, t0.is_active AS is_active_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.company AS company_8 FROM company_settings t0 WHERE t0.company = 4 AND ((t0.deleted_at IS NULL));

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

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