Symfony Profiler

Query Metrics

8 Database Queries

7 Different statements

18.32 ms Query time

0 Invalid entities

Queries


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 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.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 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, 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, 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 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 = ? OR w1_.domain = ?)) AND (w0_.is_deleted = 0)

#▲	Time	Info
1	0.50 ms	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) Parameters: [`"menu-adella.perspecta.dev" "menu-adella.perspecta.dev"`] View formatted query View runnable query Explain query 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);
2	0.61 ms	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 Parameters: [`"adella"`] View formatted query View runnable query Explain query 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;
3	0.55 ms	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 Parameters: [`18 2`] View formatted query View runnable query Explain query 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;
4	7.60 ms	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 Parameters: [`"ba7faf40-c86e-4844-a694-240f85c79266"`] View formatted query View runnable query Explain query 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;
5	5.32 ms	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') Parameters: ["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"] View formatted query View runnable query Explain query 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');
6	2.33 ms	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') Parameters: ["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"] View formatted query View runnable query Explain query 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');
7	0.62 ms	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) Parameters: [`"menu-adella.perspecta.dev" "menu-adella.perspecta.dev"`] View formatted query View runnable query Explain query 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);
8	0.78 ms	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) Parameters: [`"menu-adella.perspecta.dev" "menu-adella.perspecta.dev"`] View formatted query View runnable query Explain query 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);

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Whitelabel	No errors.
App\Entity\WhitelabelDomain	No errors.
App\Entity\Product	No errors.
App\Entity\Component	No errors.
App\Entity\Menu	No errors.
App\Entity\Property	No errors.
App\Entity\User	No errors.
App\Entity\ProductCategory	No errors.
App\Entity\Allergen	No errors.
App\Entity\City	No errors.
App\Entity\File	No errors.
App\Entity\NotificationHistory	No errors.

Symfony Profiler

GET https://menu-adella.perspecta.dev/bg/restaurants/adella/menus/main

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping