Symfony Profiler

SELECT
  p0_.id AS id_0,
  c1_.id AS id_1,
  c1_.name AS name_2,
  c1_.name_en AS name_en_3,
  c1_.create_date AS create_date_4
FROM
  component c1_
  LEFT JOIN product_component p2_ ON c1_.id = p2_.component_id
  LEFT JOIN product p0_ ON p0_.id = p2_.product_id
  AND (
    p0_.whitelabel_id = 'eae3904f-2ad6-4959-87b4-4ff0c00993ab'
  )
WHERE
  (
    p0_.id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?
    )
  )
  AND (
    c1_.whitelabel_id = 'eae3904f-2ad6-4959-87b4-4ff0c00993ab'
  )

SELECT p0_.id AS id_0, c1_.id AS id_1, c1_.name AS name_2, c1_.name_en AS name_en_3, c1_.create_date AS create_date_4 FROM component c1_ LEFT JOIN product_component p2_ ON c1_.id = p2_.component_id LEFT JOIN product p0_ ON p0_.id = p2_.product_id AND (p0_.whitelabel_id='eae3904f-2ad6-4959-87b4-4ff0c00993ab') WHERE (p0_.id IN ('4e0d5471-3f05-4d2b-ba5f-a7d587ff00a4', 'c051feef-4a58-4c48-a81c-32c67cb50181', '0b9996db-67a7-46a7-96b4-44e0644a4433', '9db7ffe9-5082-4ed1-aa44-424b0204bb95', '8bfe9b6c-1379-46b0-b9d4-2a06aab46a92', 'e11e139d-b7a4-4148-8f0e-a39cb44a54ee', 'ab8b3a0b-606c-4273-b879-3a7e66767587', '3dca1d91-779d-4147-a928-13468a86b449', 'e332578a-7b60-4cd4-8224-f1036c76d8c2', '922b49ca-69ac-4ff8-ab73-c8ea8729e328', '0070c0a5-4371-4d71-8879-3fbd277fa9f7', '6c61a5a1-d6ec-418b-80f6-d7abbfccc369', '9ee7b001-f8a1-4348-965f-ca5fb2fa568d', 'a59ad754-9c78-40ab-ba2d-6096b44c1a78', 'e199ead7-1a4b-4445-8d43-acbdfb85c388', '1e2cd95f-d285-482e-a279-fee8d9820526', 'c5f5f1fd-dbd0-4006-87c1-b2fbb5a7a5a9', '00373a7a-f378-4e18-89db-760c2d4cf3f8', '12fe9868-0720-4cbf-9855-b65b8d17c519', '57397086-ba96-4281-9256-e90930d0726f', 'ec10e83e-d6a1-4066-bc84-b87b531d5de9', '4da8501e-bcf4-4a2a-a294-013bd4ee703f', 'a34ce9cf-893d-4446-bfb7-fbc822e6a7a8', 'fb13c3a7-47cc-47ef-be42-0a16f03f22df', 'b2e04d79-cb32-4652-bd85-02b535b70a54', '853bb1e4-16dd-445c-a8f6-2576baa0d1df', '29254eb4-f63f-4b57-ae22-130582eff1ae', '872b45d8-251b-4ca2-8839-559bffffe70b', 'e2710c44-c09e-4669-b11e-36ca62d86eb2', '9125609f-9250-42f3-b5c9-ef5229f48c38', 'e93da066-bca5-4f3d-9e86-dcb35a013bc2', '9fc3fd31-1f2f-493a-ac75-aeba776c3b02', '532b7123-4172-4f98-b746-b435984feb9c', 'bbff6700-4ead-4d3b-8ad3-4ab7779b7d6c', '29d71a93-f218-4860-abbb-83107248e926', '15eed8e0-f6fe-444f-8acf-ba0dc3919daa', 'a998cd15-a014-46f8-9085-a65e24d11ccc', '1f6da6f3-00ca-4aa3-ac11-c2602a2faa48', 'eaa2b407-8ccc-42ed-9e61-18c63c52c069', 'afa7ff8a-4489-45f9-9067-f7874fc63fa3', 'f95ed03c-598d-4674-93ce-ba7aa120c2c0', 'b530f10b-21b1-40d5-9cc1-5dc0374e012c', '8abe9371-94ef-4bdd-8303-215479511727', '86c72d8a-449c-4425-a4e0-96cc5f5a79e2', '5d70c33f-c021-4744-a10a-74bc4a6283eb', '12ae69eb-0449-47f4-96a5-6c36e05c9bd0', '77a5b5b4-cfdc-48cd-8440-6a3fc355df76', '28836998-0537-4acb-a663-3559f60f644a', '572bf28e-d966-46da-acda-ef0c3b4b2e43', 'e675b9c8-6efa-4e70-abaa-af30db736eaf', 'c2182336-893a-457e-9ae2-ecb0f0e51cbd', '047e2ca1-ad34-4b76-bcbc-6f9d1a8b2104', '2880f47d-c5a9-4f59-b537-ec014325f372', '40fd33e9-2999-47d2-9ae9-e895ada68fd2', 'bd2c4d5b-34ea-478e-a2ee-5ca503a637f5', '263ece6a-5ef6-4f10-9af3-91a954aa1bc2', '363dce32-3f5a-4770-a853-57c39d99fdad', 'a1e4a082-676e-4658-bfc0-9e08be29a483', 'c4f3cba6-16a9-4eff-a722-762d1607c689', 'bff1202d-c137-493f-bde4-8e102c75b16b', '8e21af36-3c60-49d6-82bb-6a3d4c408d37', 'c01a9a97-a3a7-44d9-8ff1-26f269d533fb')) AND (c1_.whitelabel_id='eae3904f-2ad6-4959-87b4-4ff0c00993ab');

SELECT
  p0_.id AS id_0,
  a1_.id AS id_1,
  a1_.create_date AS create_date_2,
  a1_.name AS name_3
FROM
  allergen a1_
  LEFT JOIN product_allergen p2_ ON a1_.id = p2_.allergen_id
  LEFT JOIN product p0_ ON p0_.id = p2_.product_id
  AND (
    p0_.whitelabel_id = 'eae3904f-2ad6-4959-87b4-4ff0c00993ab'
  )
WHERE
  (
    p0_.id IN (
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
      ?
    )
  )
  AND (
    a1_.whitelabel_id = 'eae3904f-2ad6-4959-87b4-4ff0c00993ab'
  )

SELECT p0_.id AS id_0, a1_.id AS id_1, a1_.create_date AS create_date_2, a1_.name AS name_3 FROM allergen a1_ LEFT JOIN product_allergen p2_ ON a1_.id = p2_.allergen_id LEFT JOIN product p0_ ON p0_.id = p2_.product_id AND (p0_.whitelabel_id='eae3904f-2ad6-4959-87b4-4ff0c00993ab') WHERE (p0_.id IN ('4e0d5471-3f05-4d2b-ba5f-a7d587ff00a4', 'c051feef-4a58-4c48-a81c-32c67cb50181', '0b9996db-67a7-46a7-96b4-44e0644a4433', '9db7ffe9-5082-4ed1-aa44-424b0204bb95', '8bfe9b6c-1379-46b0-b9d4-2a06aab46a92', 'e11e139d-b7a4-4148-8f0e-a39cb44a54ee', 'ab8b3a0b-606c-4273-b879-3a7e66767587', '3dca1d91-779d-4147-a928-13468a86b449', 'e332578a-7b60-4cd4-8224-f1036c76d8c2', '922b49ca-69ac-4ff8-ab73-c8ea8729e328', '0070c0a5-4371-4d71-8879-3fbd277fa9f7', '6c61a5a1-d6ec-418b-80f6-d7abbfccc369', '9ee7b001-f8a1-4348-965f-ca5fb2fa568d', 'a59ad754-9c78-40ab-ba2d-6096b44c1a78', 'e199ead7-1a4b-4445-8d43-acbdfb85c388', '1e2cd95f-d285-482e-a279-fee8d9820526', 'c5f5f1fd-dbd0-4006-87c1-b2fbb5a7a5a9', '00373a7a-f378-4e18-89db-760c2d4cf3f8', '12fe9868-0720-4cbf-9855-b65b8d17c519', '57397086-ba96-4281-9256-e90930d0726f', 'ec10e83e-d6a1-4066-bc84-b87b531d5de9', '4da8501e-bcf4-4a2a-a294-013bd4ee703f', 'a34ce9cf-893d-4446-bfb7-fbc822e6a7a8', 'fb13c3a7-47cc-47ef-be42-0a16f03f22df', 'b2e04d79-cb32-4652-bd85-02b535b70a54', '853bb1e4-16dd-445c-a8f6-2576baa0d1df', '29254eb4-f63f-4b57-ae22-130582eff1ae', '872b45d8-251b-4ca2-8839-559bffffe70b', 'e2710c44-c09e-4669-b11e-36ca62d86eb2', '9125609f-9250-42f3-b5c9-ef5229f48c38', 'e93da066-bca5-4f3d-9e86-dcb35a013bc2', '9fc3fd31-1f2f-493a-ac75-aeba776c3b02', '532b7123-4172-4f98-b746-b435984feb9c', 'bbff6700-4ead-4d3b-8ad3-4ab7779b7d6c', '29d71a93-f218-4860-abbb-83107248e926', '15eed8e0-f6fe-444f-8acf-ba0dc3919daa', 'a998cd15-a014-46f8-9085-a65e24d11ccc', '1f6da6f3-00ca-4aa3-ac11-c2602a2faa48', 'eaa2b407-8ccc-42ed-9e61-18c63c52c069', 'afa7ff8a-4489-45f9-9067-f7874fc63fa3', 'f95ed03c-598d-4674-93ce-ba7aa120c2c0', 'b530f10b-21b1-40d5-9cc1-5dc0374e012c', '8abe9371-94ef-4bdd-8303-215479511727', '86c72d8a-449c-4425-a4e0-96cc5f5a79e2', '5d70c33f-c021-4744-a10a-74bc4a6283eb', '12ae69eb-0449-47f4-96a5-6c36e05c9bd0', '77a5b5b4-cfdc-48cd-8440-6a3fc355df76', '28836998-0537-4acb-a663-3559f60f644a', '572bf28e-d966-46da-acda-ef0c3b4b2e43', 'e675b9c8-6efa-4e70-abaa-af30db736eaf', 'c2182336-893a-457e-9ae2-ecb0f0e51cbd', '047e2ca1-ad34-4b76-bcbc-6f9d1a8b2104', '2880f47d-c5a9-4f59-b537-ec014325f372', '40fd33e9-2999-47d2-9ae9-e895ada68fd2', 'bd2c4d5b-34ea-478e-a2ee-5ca503a637f5', '263ece6a-5ef6-4f10-9af3-91a954aa1bc2', '363dce32-3f5a-4770-a853-57c39d99fdad', 'a1e4a082-676e-4658-bfc0-9e08be29a483', 'c4f3cba6-16a9-4eff-a722-762d1607c689', 'bff1202d-c137-493f-bde4-8e102c75b16b', '8e21af36-3c60-49d6-82bb-6a3d4c408d37', 'c01a9a97-a3a7-44d9-8ff1-26f269d533fb')) AND (a1_.whitelabel_id='eae3904f-2ad6-4959-87b4-4ff0c00993ab');

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.name_en AS name_en_2,
  p0_.price AS price_3,
  p0_.create_date AS create_date_4,
  p0_.weight AS weight_5,
  p1_.id AS id_6,
  p1_.name AS name_7,
  p1_.create_date AS create_date_8,
  p1_.position AS position_9
FROM
  product p0_
  LEFT JOIN menu_product m3_ ON p0_.id = m3_.product_id
  LEFT JOIN menu m2_ ON m2_.id = m3_.menu_id
  AND (
    m2_.whitelabel_id = 'eae3904f-2ad6-4959-87b4-4ff0c00993ab'
  )
  LEFT JOIN product_category p1_ ON p0_.category_id = p1_.id
  AND (
    p1_.whitelabel_id = 'eae3904f-2ad6-4959-87b4-4ff0c00993ab'
  )
WHERE
  (m2_.id = ?)
  AND (
    p0_.whitelabel_id = 'eae3904f-2ad6-4959-87b4-4ff0c00993ab'
  )
ORDER BY
  p0_.create_date ASC

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.name_en AS name_en_2, p0_.price AS price_3, p0_.create_date AS create_date_4, p0_.weight AS weight_5, p1_.id AS id_6, p1_.name AS name_7, p1_.create_date AS create_date_8, p1_.position AS position_9 FROM product p0_ LEFT JOIN menu_product m3_ ON p0_.id = m3_.product_id LEFT JOIN menu m2_ ON m2_.id = m3_.menu_id AND (m2_.whitelabel_id='eae3904f-2ad6-4959-87b4-4ff0c00993ab') LEFT JOIN product_category p1_ ON p0_.category_id = p1_.id AND (p1_.whitelabel_id='eae3904f-2ad6-4959-87b4-4ff0c00993ab') WHERE (m2_.id = 'ba7faf40-c86e-4844-a694-240f85c79266') AND (p0_.whitelabel_id='eae3904f-2ad6-4959-87b4-4ff0c00993ab') ORDER BY p0_.create_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
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
  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
  t0.id AS id_1,
  t0.name AS name_2,
  t0.template_name AS template_name_3,
  t0.create_date AS create_date_4,
  t0.from_date AS from_date_5,
  t0.to_date AS to_date_6,
  t0.send_notification_date AS send_notification_date_7,
  t0.type AS type_8,
  t0.is_published AS is_published_9,
  t0.whitelabel_id AS whitelabel_id_10,
  t0.creator_user_id AS creator_user_id_11,
  t0.property_id AS property_id_12
FROM
  menu t0
WHERE
  t0.property_id = ?
  AND t0.type = ?
  AND (
    (
      t0.whitelabel_id = 'eae3904f-2ad6-4959-87b4-4ff0c00993ab'
    )
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.template_name AS template_name_3, t0.create_date AS create_date_4, t0.from_date AS from_date_5, t0.to_date AS to_date_6, t0.send_notification_date AS send_notification_date_7, t0.type AS type_8, t0.is_published AS is_published_9, t0.whitelabel_id AS whitelabel_id_10, t0.creator_user_id AS creator_user_id_11, t0.property_id AS property_id_12 FROM menu t0 WHERE t0.property_id = 18 AND t0.type = 2 AND ((t0.whitelabel_id='eae3904f-2ad6-4959-87b4-4ff0c00993ab')) LIMIT 1;

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.slug = ?
  AND (
    (
      t0.whitelabel_id = 'eae3904f-2ad6-4959-87b4-4ff0c00993ab'
    )
  )
LIMIT
  1

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.slug = 'adella' AND ((t0.whitelabel_id='eae3904f-2ad6-4959-87b4-4ff0c00993ab')) LIMIT 1;