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_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.name AS name_2,
  t0.address AS address_3,
  t0.postal_code AS postal_code_4,
  t0.location AS location_5,
  t0.mail AS mail_6,
  t0.phone AS phone_7,
  t0.working_date AS working_date_8,
  t0.logo_file_name AS logo_file_name_9,
  t0.cover_file_name AS cover_file_name_10,
  t0.deleted_at AS deleted_at_11,
  t0.is_active AS is_active_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.store_type_id AS store_type_id_15,
  t0.company_id AS company_id_16,
  t0.default_currency AS default_currency_17
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.mail AS mail_6, t0.phone AS phone_7, t0.working_date AS working_date_8, t0.logo_file_name AS logo_file_name_9, t0.cover_file_name AS cover_file_name_10, t0.deleted_at AS deleted_at_11, t0.is_active AS is_active_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.store_type_id AS store_type_id_15, t0.company_id AS company_id_16, t0.default_currency AS default_currency_17 FROM store t0 WHERE t0.name = 'mikel' AND ((t0.deleted_at IS NULL)) LIMIT 1;

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.id AS id_1,
  t0.name AS name_2,
  t0.deleted_at AS deleted_at_3,
  t0.is_active AS is_active_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
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.deleted_at AS deleted_at_3, t0.is_active AS is_active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM sta_store_type t0 WHERE t0.id = 1 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 = ?
  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.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 = 2 AND ((t0.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 = 5) AND (s0_.deleted_at IS NULL);

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 = 5) 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_.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,
  s0_.store_id AS store_id_7,
  s0_.table_location_id AS table_location_id_8,
  s0_.shape AS shape_9
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_.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, s0_.store_id AS store_id_7, s0_.table_location_id AS table_location_id_8, s0_.shape AS shape_9 FROM store_table s0_ WHERE (s0_.store_id = 5 AND s0_.is_active = 1) AND (s0_.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 = 5 AND s0_.is_active = 1) AND (s0_.deleted_at IS NULL);

SELECT
  t0.code AS code_1,
  t0.name AS name_2,
  t0.deleted_at AS deleted_at_3,
  t0.is_active AS is_active_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  sta_table_shape t0
WHERE
  t0.code = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.code AS code_1, t0.name AS name_2, t0.deleted_at AS deleted_at_3, t0.is_active AS is_active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM sta_table_shape t0 WHERE t0.code = 'RECT' AND ((t0.deleted_at IS NULL));

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.image_file_name AS image_file_name_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,
  s0_.store_id AS store_id_7,
  s0_.income_department_id AS income_department_id_8,
  s0_.station_id AS station_id_9
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_.image_file_name AS image_file_name_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, s0_.store_id AS store_id_7, s0_.income_department_id AS income_department_id_8, s0_.station_id AS station_id_9 FROM store_product_group s0_ WHERE (s0_.store_id = 5) 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 = 5) AND (s0_.deleted_at IS NULL);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.deleted_at AS deleted_at_3,
  t0.is_active AS is_active_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.store_id AS store_id_7,
  t0.vat_id AS vat_id_8
FROM
  store_income_department t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.deleted_at AS deleted_at_3, t0.is_active AS is_active_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.store_id AS store_id_7, t0.vat_id AS vat_id_8 FROM store_income_department t0 WHERE t0.id = 1 AND ((t0.deleted_at IS NULL));

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.price AS price_2,
  s0_.sale_price AS sale_price_3,
  s0_.in_menu AS in_menu_4,
  s0_.deleted_at AS deleted_at_5,
  s0_.is_active AS is_active_6,
  s0_.created_at AS created_at_7,
  s0_.updated_at AS updated_at_8,
  count(s0_.id) AS sclr_9,
  s0_.product_group_id AS product_group_id_10,
  s0_.store_id AS store_id_11,
  s0_.currency AS currency_12
FROM
  store_product s0_
WHERE
  (
    s0_.store_id = ?
    AND s0_.product_group_id = ?
  )
  AND (s0_.deleted_at IS NULL)

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.price AS price_2, s0_.sale_price AS sale_price_3, s0_.in_menu AS in_menu_4, s0_.deleted_at AS deleted_at_5, s0_.is_active AS is_active_6, s0_.created_at AS created_at_7, s0_.updated_at AS updated_at_8, count(s0_.id) AS sclr_9, s0_.product_group_id AS product_group_id_10, s0_.store_id AS store_id_11, s0_.currency AS currency_12 FROM store_product s0_ WHERE (s0_.store_id = 5 AND s0_.product_group_id = 1) 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 = 5 AND s1_.is_closed = 0) AND (s0_.deleted_at IS NULL);