Symfony Profiler

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.domain AS domain_2,
  w0_.create_date AS create_date_3,
  w0_.phone AS phone_4,
  w0_.address AS address_5,
  w0_.template AS template_6,
  w0_.one_signal_api_id AS one_signal_api_id_7,
  w0_.one_signal_api_key AS one_signal_api_key_8,
  w0_.is_deleted AS is_deleted_9,
  w1_.id AS id_10,
  w1_.domain AS domain_11,
  w1_.whitelabel_id AS whitelabel_id_12
FROM
  whitelabel w0_
  LEFT JOIN whitelabel_domain w1_ ON w0_.id = w1_.whitelabel_id
WHERE
  (
    (
      w0_.domain = ?
      OR w1_.domain = ?
    )
  )
  AND (w0_.is_deleted = 0)

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.domain AS domain_2, w0_.create_date AS create_date_3, w0_.phone AS phone_4, w0_.address AS address_5, w0_.template AS template_6, w0_.one_signal_api_id AS one_signal_api_id_7, w0_.one_signal_api_key AS one_signal_api_key_8, w0_.is_deleted AS is_deleted_9, w1_.id AS id_10, w1_.domain AS domain_11, w1_.whitelabel_id AS whitelabel_id_12 FROM whitelabel w0_ LEFT JOIN whitelabel_domain w1_ ON w0_.id = w1_.whitelabel_id WHERE ((w0_.domain = 'menu-adella.perspecta.dev' OR w1_.domain = 'menu-adella.perspecta.dev')) AND (w0_.is_deleted = 0);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.create_date AS create_date_4,
  t0.address AS address_5,
  t0.phone AS phone_6,
  t0.longtitude AS longtitude_7,
  t0.latitude AS latitude_8,
  t0.email AS email_9,
  t0.working_hours AS working_hours_10,
  t0.sort AS sort_11,
  t0.is_deleted AS is_deleted_12,
  t0.whitelabel_id AS whitelabel_id_13,
  t0.creator_user_id AS creator_user_id_14,
  t0.city_id AS city_id_15
FROM
  property t0
WHERE
  (
    (
      t0.whitelabel_id = 'eae3904f-2ad6-4959-87b4-4ff0c00993ab'
    )
  )
ORDER BY
  t0.sort ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.create_date AS create_date_4, t0.address AS address_5, t0.phone AS phone_6, t0.longtitude AS longtitude_7, t0.latitude AS latitude_8, t0.email AS email_9, t0.working_hours AS working_hours_10, t0.sort AS sort_11, t0.is_deleted AS is_deleted_12, t0.whitelabel_id AS whitelabel_id_13, t0.creator_user_id AS creator_user_id_14, t0.city_id AS city_id_15 FROM property t0 WHERE ((t0.whitelabel_id='eae3904f-2ad6-4959-87b4-4ff0c00993ab')) ORDER BY t0.sort ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.path AS path_3,
  t0.size AS size_4,
  t0.md5 AS md5_5,
  t0.mime_type AS mime_type_6,
  t0.create_date AS create_date_7,
  t0.sort AS sort_8,
  t0.is_deleted AS is_deleted_9,
  t0.whitelabel_id AS whitelabel_id_10,
  t0.creator_user_id AS creator_user_id_11
FROM
  file t0
  INNER JOIN property_file ON t0.id = property_file.file_id
WHERE
  property_file.property_id = ?
  AND (
    (
      t0.whitelabel_id = 'eae3904f-2ad6-4959-87b4-4ff0c00993ab'
    )
  )

SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3, t0.size AS size_4, t0.md5 AS md5_5, t0.mime_type AS mime_type_6, t0.create_date AS create_date_7, t0.sort AS sort_8, t0.is_deleted AS is_deleted_9, t0.whitelabel_id AS whitelabel_id_10, t0.creator_user_id AS creator_user_id_11 FROM file t0 INNER JOIN property_file ON t0.id = property_file.file_id WHERE property_file.property_id = 18 AND ((t0.whitelabel_id='eae3904f-2ad6-4959-87b4-4ff0c00993ab'));

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.template_name AS template_name_2,
  m0_.create_date AS create_date_3,
  m0_.from_date AS from_date_4,
  m0_.to_date AS to_date_5,
  m0_.send_notification_date AS send_notification_date_6,
  m0_.type AS type_7,
  m0_.is_published AS is_published_8,
  m0_.whitelabel_id AS whitelabel_id_9,
  m0_.creator_user_id AS creator_user_id_10,
  m0_.property_id AS property_id_11
FROM
  menu m0_
WHERE
  (
    m0_.property_id = ?
    AND m0_.type = ?
  )
  AND (
    m0_.whitelabel_id = 'eae3904f-2ad6-4959-87b4-4ff0c00993ab'
  )
LIMIT
  1

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.template_name AS template_name_2, m0_.create_date AS create_date_3, m0_.from_date AS from_date_4, m0_.to_date AS to_date_5, m0_.send_notification_date AS send_notification_date_6, m0_.type AS type_7, m0_.is_published AS is_published_8, m0_.whitelabel_id AS whitelabel_id_9, m0_.creator_user_id AS creator_user_id_10, m0_.property_id AS property_id_11 FROM menu m0_ WHERE (m0_.property_id = 18 AND m0_.type = 2) AND (m0_.whitelabel_id='eae3904f-2ad6-4959-87b4-4ff0c00993ab') LIMIT 1;

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.template_name AS template_name_2,
  m0_.create_date AS create_date_3,
  m0_.from_date AS from_date_4,
  m0_.to_date AS to_date_5,
  m0_.send_notification_date AS send_notification_date_6,
  m0_.type AS type_7,
  m0_.is_published AS is_published_8,
  m0_.whitelabel_id AS whitelabel_id_9,
  m0_.creator_user_id AS creator_user_id_10,
  m0_.property_id AS property_id_11
FROM
  menu m0_
WHERE
  (
    m0_.property_id = ?
    AND m0_.type = ?
  )
  AND (
    m0_.whitelabel_id = 'eae3904f-2ad6-4959-87b4-4ff0c00993ab'
  )
LIMIT
  1

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.template_name AS template_name_2, m0_.create_date AS create_date_3, m0_.from_date AS from_date_4, m0_.to_date AS to_date_5, m0_.send_notification_date AS send_notification_date_6, m0_.type AS type_7, m0_.is_published AS is_published_8, m0_.whitelabel_id AS whitelabel_id_9, m0_.creator_user_id AS creator_user_id_10, m0_.property_id AS property_id_11 FROM menu m0_ WHERE (m0_.property_id = 18 AND m0_.type = 3) AND (m0_.whitelabel_id='eae3904f-2ad6-4959-87b4-4ff0c00993ab') LIMIT 1;

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.template_name AS template_name_2,
  m0_.create_date AS create_date_3,
  m0_.from_date AS from_date_4,
  m0_.to_date AS to_date_5,
  m0_.send_notification_date AS send_notification_date_6,
  m0_.type AS type_7,
  m0_.is_published AS is_published_8,
  p1_.id AS id_9,
  p1_.name AS name_10,
  p1_.name_en AS name_en_11,
  p1_.price AS price_12,
  p1_.create_date AS create_date_13,
  p1_.weight AS weight_14,
  c2_.id AS id_15,
  c2_.name AS name_16,
  c2_.name_en AS name_en_17,
  c2_.create_date AS create_date_18,
  p3_.id AS id_19,
  p3_.name AS name_20,
  p3_.create_date AS create_date_21,
  p3_.position AS position_22,
  m0_.whitelabel_id AS whitelabel_id_23,
  m0_.creator_user_id AS creator_user_id_24,
  m0_.property_id AS property_id_25,
  p1_.whitelabel_id AS whitelabel_id_26,
  p1_.creator_user_id AS creator_user_id_27,
  p1_.category_id AS category_id_28,
  c2_.whitelabel_id AS whitelabel_id_29,
  c2_.creator_user_id AS creator_user_id_30,
  p3_.creator_user_id AS creator_user_id_31,
  p3_.whitelabel_id AS whitelabel_id_32
FROM
  menu m0_
  LEFT JOIN menu_product m4_ ON m0_.id = m4_.menu_id
  LEFT JOIN product p1_ ON p1_.id = m4_.product_id
  AND (
    p1_.whitelabel_id = 'eae3904f-2ad6-4959-87b4-4ff0c00993ab'
  )
  LEFT JOIN product_component p5_ ON p1_.id = p5_.product_id
  LEFT JOIN component c2_ ON c2_.id = p5_.component_id
  AND (
    c2_.whitelabel_id = 'eae3904f-2ad6-4959-87b4-4ff0c00993ab'
  )
  LEFT JOIN product_category p3_ ON p1_.category_id = p3_.id
  AND (
    p3_.whitelabel_id = 'eae3904f-2ad6-4959-87b4-4ff0c00993ab'
  )
WHERE
  (
    m0_.from_date <= ?
    AND m0_.to_date >= ?
    AND m0_.is_published = ?
    AND m0_.type = ?
    AND m0_.property_id = ?
  )
  AND (
    m0_.whitelabel_id = 'eae3904f-2ad6-4959-87b4-4ff0c00993ab'
  )
ORDER BY
  m0_.from_date ASC

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.template_name AS template_name_2, m0_.create_date AS create_date_3, m0_.from_date AS from_date_4, m0_.to_date AS to_date_5, m0_.send_notification_date AS send_notification_date_6, m0_.type AS type_7, m0_.is_published AS is_published_8, p1_.id AS id_9, p1_.name AS name_10, p1_.name_en AS name_en_11, p1_.price AS price_12, p1_.create_date AS create_date_13, p1_.weight AS weight_14, c2_.id AS id_15, c2_.name AS name_16, c2_.name_en AS name_en_17, c2_.create_date AS create_date_18, p3_.id AS id_19, p3_.name AS name_20, p3_.create_date AS create_date_21, p3_.position AS position_22, m0_.whitelabel_id AS whitelabel_id_23, m0_.creator_user_id AS creator_user_id_24, m0_.property_id AS property_id_25, p1_.whitelabel_id AS whitelabel_id_26, p1_.creator_user_id AS creator_user_id_27, p1_.category_id AS category_id_28, c2_.whitelabel_id AS whitelabel_id_29, c2_.creator_user_id AS creator_user_id_30, p3_.creator_user_id AS creator_user_id_31, p3_.whitelabel_id AS whitelabel_id_32 FROM menu m0_ LEFT JOIN menu_product m4_ ON m0_.id = m4_.menu_id LEFT JOIN product p1_ ON p1_.id = m4_.product_id AND (p1_.whitelabel_id='eae3904f-2ad6-4959-87b4-4ff0c00993ab') LEFT JOIN product_component p5_ ON p1_.id = p5_.product_id LEFT JOIN component c2_ ON c2_.id = p5_.component_id AND (c2_.whitelabel_id='eae3904f-2ad6-4959-87b4-4ff0c00993ab') LEFT JOIN product_category p3_ ON p1_.category_id = p3_.id AND (p3_.whitelabel_id='eae3904f-2ad6-4959-87b4-4ff0c00993ab') WHERE (m0_.from_date <= '2025-12-25 19:14:04' AND m0_.to_date >= '2025-12-25 19:14:04' AND m0_.is_published = 1 AND m0_.type = 1 AND m0_.property_id = 18) AND (m0_.whitelabel_id='eae3904f-2ad6-4959-87b4-4ff0c00993ab') ORDER BY m0_.from_date ASC;

SELECT
  m0_.id AS id_0,
  m0_.name AS name_1,
  m0_.template_name AS template_name_2,
  m0_.create_date AS create_date_3,
  m0_.from_date AS from_date_4,
  m0_.to_date AS to_date_5,
  m0_.send_notification_date AS send_notification_date_6,
  m0_.type AS type_7,
  m0_.is_published AS is_published_8,
  p1_.id AS id_9,
  p1_.name AS name_10,
  p1_.name_en AS name_en_11,
  p1_.price AS price_12,
  p1_.create_date AS create_date_13,
  p1_.weight AS weight_14,
  c2_.id AS id_15,
  c2_.name AS name_16,
  c2_.name_en AS name_en_17,
  c2_.create_date AS create_date_18,
  p3_.id AS id_19,
  p3_.name AS name_20,
  p3_.create_date AS create_date_21,
  p3_.position AS position_22,
  m0_.whitelabel_id AS whitelabel_id_23,
  m0_.creator_user_id AS creator_user_id_24,
  m0_.property_id AS property_id_25,
  p1_.whitelabel_id AS whitelabel_id_26,
  p1_.creator_user_id AS creator_user_id_27,
  p1_.category_id AS category_id_28,
  c2_.whitelabel_id AS whitelabel_id_29,
  c2_.creator_user_id AS creator_user_id_30,
  p3_.creator_user_id AS creator_user_id_31,
  p3_.whitelabel_id AS whitelabel_id_32
FROM
  menu m0_
  LEFT JOIN menu_product m4_ ON m0_.id = m4_.menu_id
  LEFT JOIN product p1_ ON p1_.id = m4_.product_id
  AND (
    p1_.whitelabel_id = 'eae3904f-2ad6-4959-87b4-4ff0c00993ab'
  )
  LEFT JOIN product_component p5_ ON p1_.id = p5_.product_id
  LEFT JOIN component c2_ ON c2_.id = p5_.component_id
  AND (
    c2_.whitelabel_id = 'eae3904f-2ad6-4959-87b4-4ff0c00993ab'
  )
  LEFT JOIN product_category p3_ ON p1_.category_id = p3_.id
  AND (
    p3_.whitelabel_id = 'eae3904f-2ad6-4959-87b4-4ff0c00993ab'
  )
WHERE
  (
    m0_.from_date >= ?
    AND m0_.to_date >= ?
    AND m0_.is_published = ?
    AND m0_.type = ?
    AND m0_.property_id = ?
  )
  AND (
    m0_.whitelabel_id = 'eae3904f-2ad6-4959-87b4-4ff0c00993ab'
  )
ORDER BY
  m0_.from_date ASC

SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.template_name AS template_name_2, m0_.create_date AS create_date_3, m0_.from_date AS from_date_4, m0_.to_date AS to_date_5, m0_.send_notification_date AS send_notification_date_6, m0_.type AS type_7, m0_.is_published AS is_published_8, p1_.id AS id_9, p1_.name AS name_10, p1_.name_en AS name_en_11, p1_.price AS price_12, p1_.create_date AS create_date_13, p1_.weight AS weight_14, c2_.id AS id_15, c2_.name AS name_16, c2_.name_en AS name_en_17, c2_.create_date AS create_date_18, p3_.id AS id_19, p3_.name AS name_20, p3_.create_date AS create_date_21, p3_.position AS position_22, m0_.whitelabel_id AS whitelabel_id_23, m0_.creator_user_id AS creator_user_id_24, m0_.property_id AS property_id_25, p1_.whitelabel_id AS whitelabel_id_26, p1_.creator_user_id AS creator_user_id_27, p1_.category_id AS category_id_28, c2_.whitelabel_id AS whitelabel_id_29, c2_.creator_user_id AS creator_user_id_30, p3_.creator_user_id AS creator_user_id_31, p3_.whitelabel_id AS whitelabel_id_32 FROM menu m0_ LEFT JOIN menu_product m4_ ON m0_.id = m4_.menu_id LEFT JOIN product p1_ ON p1_.id = m4_.product_id AND (p1_.whitelabel_id='eae3904f-2ad6-4959-87b4-4ff0c00993ab') LEFT JOIN product_component p5_ ON p1_.id = p5_.product_id LEFT JOIN component c2_ ON c2_.id = p5_.component_id AND (c2_.whitelabel_id='eae3904f-2ad6-4959-87b4-4ff0c00993ab') LEFT JOIN product_category p3_ ON p1_.category_id = p3_.id AND (p3_.whitelabel_id='eae3904f-2ad6-4959-87b4-4ff0c00993ab') WHERE (m0_.from_date >= '2025-12-25 19:14:04' AND m0_.to_date >= '2025-12-25 19:14:04' AND m0_.is_published = 1 AND m0_.type = 1 AND m0_.property_id = 18) AND (m0_.whitelabel_id='eae3904f-2ad6-4959-87b4-4ff0c00993ab') ORDER BY m0_.from_date ASC;

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.domain AS domain_2,
  w0_.create_date AS create_date_3,
  w0_.phone AS phone_4,
  w0_.address AS address_5,
  w0_.template AS template_6,
  w0_.one_signal_api_id AS one_signal_api_id_7,
  w0_.one_signal_api_key AS one_signal_api_key_8,
  w0_.is_deleted AS is_deleted_9,
  w1_.id AS id_10,
  w1_.domain AS domain_11,
  w1_.whitelabel_id AS whitelabel_id_12
FROM
  whitelabel w0_
  LEFT JOIN whitelabel_domain w1_ ON w0_.id = w1_.whitelabel_id
  AND (
    w1_.whitelabel_id = 'eae3904f-2ad6-4959-87b4-4ff0c00993ab'
  )
WHERE
  (
    (
      w0_.domain = ?
      OR w1_.domain = ?
    )
  )
  AND (w0_.is_deleted = 0)

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.domain AS domain_2, w0_.create_date AS create_date_3, w0_.phone AS phone_4, w0_.address AS address_5, w0_.template AS template_6, w0_.one_signal_api_id AS one_signal_api_id_7, w0_.one_signal_api_key AS one_signal_api_key_8, w0_.is_deleted AS is_deleted_9, w1_.id AS id_10, w1_.domain AS domain_11, w1_.whitelabel_id AS whitelabel_id_12 FROM whitelabel w0_ LEFT JOIN whitelabel_domain w1_ ON w0_.id = w1_.whitelabel_id AND (w1_.whitelabel_id='eae3904f-2ad6-4959-87b4-4ff0c00993ab') WHERE ((w0_.domain = 'menu-adella.perspecta.dev' OR w1_.domain = 'menu-adella.perspecta.dev')) AND (w0_.is_deleted = 0);

SELECT
  w0_.id AS id_0,
  w0_.name AS name_1,
  w0_.domain AS domain_2,
  w0_.create_date AS create_date_3,
  w0_.phone AS phone_4,
  w0_.address AS address_5,
  w0_.template AS template_6,
  w0_.one_signal_api_id AS one_signal_api_id_7,
  w0_.one_signal_api_key AS one_signal_api_key_8,
  w0_.is_deleted AS is_deleted_9,
  w1_.id AS id_10,
  w1_.domain AS domain_11,
  w1_.whitelabel_id AS whitelabel_id_12
FROM
  whitelabel w0_
  LEFT JOIN whitelabel_domain w1_ ON w0_.id = w1_.whitelabel_id
  AND (
    w1_.whitelabel_id = 'eae3904f-2ad6-4959-87b4-4ff0c00993ab'
  )
WHERE
  (
    (
      w0_.domain = ?
      OR w1_.domain = ?
    )
  )
  AND (w0_.is_deleted = 0)

SELECT w0_.id AS id_0, w0_.name AS name_1, w0_.domain AS domain_2, w0_.create_date AS create_date_3, w0_.phone AS phone_4, w0_.address AS address_5, w0_.template AS template_6, w0_.one_signal_api_id AS one_signal_api_id_7, w0_.one_signal_api_key AS one_signal_api_key_8, w0_.is_deleted AS is_deleted_9, w1_.id AS id_10, w1_.domain AS domain_11, w1_.whitelabel_id AS whitelabel_id_12 FROM whitelabel w0_ LEFT JOIN whitelabel_domain w1_ ON w0_.id = w1_.whitelabel_id AND (w1_.whitelabel_id='eae3904f-2ad6-4959-87b4-4ff0c00993ab') WHERE ((w0_.domain = 'menu-adella.perspecta.dev' OR w1_.domain = 'menu-adella.perspecta.dev')) AND (w0_.is_deleted = 0);