| 1 |
0.75 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.title AS title_3, t0.slug AS slug_4, t0.seo_title AS seo_title_5, t0.meta_description AS meta_description_6, t0.introduction AS introduction_7, t0.content AS content_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.site_settings_id AS site_settings_id_12 FROM site_page t0 WHERE t0.code = ? AND t0.is_active = ? LIMIT 1
SELECT t0.id AS id_1, t0.code AS code_2, t0.title AS title_3, t0.slug AS slug_4, t0.seo_title AS seo_title_5, t0.meta_description AS meta_description_6, t0.introduction AS introduction_7, t0.content AS content_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.site_settings_id AS site_settings_id_12 FROM site_page t0 WHERE t0.code = 'menu' AND t0.is_active = 1 LIMIT 1;
|
| 2 |
0.75 ms |
SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.slogan AS slogan_3, t0.phone AS phone_4, t0.email AS email_5, t0.whatsapp AS whatsapp_6, t0.full_address AS full_address_7, t0.short_address AS short_address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.logo AS logo_11, t0.hero_image AS hero_image_12, t0.notification_email AS notification_email_13, t0.email_notifications_enabled AS email_notifications_enabled_14, t0.general_notes AS general_notes_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17 FROM site_settings t0 ORDER BY t0.id ASC LIMIT 1
SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.slogan AS slogan_3, t0.phone AS phone_4, t0.email AS email_5, t0.whatsapp AS whatsapp_6, t0.full_address AS full_address_7, t0.short_address AS short_address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.logo AS logo_11, t0.hero_image AS hero_image_12, t0.notification_email AS notification_email_13, t0.email_notifications_enabled AS email_notifications_enabled_14, t0.general_notes AS general_notes_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17 FROM site_settings t0 ORDER BY t0.id ASC LIMIT 1;
|
| 3 |
0.77 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.position AS position_5, t0.is_active AS is_active_6, t0.slug AS slug_7, t0.seo_title AS seo_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM category t0 WHERE t0.is_active = ? ORDER BY t0.position ASC, t0.id ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.position AS position_5, t0.is_active AS is_active_6, t0.slug AS slug_7, t0.seo_title AS seo_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM category t0 WHERE t0.is_active = 1 ORDER BY t0.position ASC, t0.id ASC;
|
| 4 |
0.56 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.position AS position_5, t0.image AS image_6, t0.is_available AS is_available_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.category_id AS category_id_10 FROM product t0 WHERE t0.category_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.position AS position_5, t0.image AS image_6, t0.is_available AS is_available_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.category_id AS category_id_10 FROM product t0 WHERE t0.category_id = 1;
|
| 5 |
0.65 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.position AS position_5, t0.image AS image_6, t0.is_available AS is_available_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.category_id AS category_id_10 FROM product t0 WHERE t0.category_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.position AS position_5, t0.image AS image_6, t0.is_available AS is_available_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.category_id AS category_id_10 FROM product t0 WHERE t0.category_id = 2;
|
| 6 |
0.58 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.position AS position_5, t0.image AS image_6, t0.is_available AS is_available_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.category_id AS category_id_10 FROM product t0 WHERE t0.category_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.position AS position_5, t0.image AS image_6, t0.is_available AS is_available_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.category_id AS category_id_10 FROM product t0 WHERE t0.category_id = 3;
|
| 7 |
0.45 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.position AS position_5, t0.image AS image_6, t0.is_available AS is_available_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.category_id AS category_id_10 FROM product t0 WHERE t0.category_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.position AS position_5, t0.image AS image_6, t0.is_available AS is_available_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.category_id AS category_id_10 FROM product t0 WHERE t0.category_id = 4;
|
| 8 |
0.48 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4, t0.is_active AS is_active_5 FROM allergen t0 INNER JOIN product_allergen ON t0.id = product_allergen.allergen_id WHERE product_allergen.product_id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4, t0.is_active AS is_active_5 FROM allergen t0 INNER JOIN product_allergen ON t0.id = product_allergen.allergen_id WHERE product_allergen.product_id = 1;
|
| 9 |
0.51 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4, t0.is_active AS is_active_5 FROM allergen t0 INNER JOIN product_allergen ON t0.id = product_allergen.allergen_id WHERE product_allergen.product_id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4, t0.is_active AS is_active_5 FROM allergen t0 INNER JOIN product_allergen ON t0.id = product_allergen.allergen_id WHERE product_allergen.product_id = 2;
|
| 10 |
0.48 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4, t0.is_active AS is_active_5 FROM allergen t0 INNER JOIN product_allergen ON t0.id = product_allergen.allergen_id WHERE product_allergen.product_id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4, t0.is_active AS is_active_5 FROM allergen t0 INNER JOIN product_allergen ON t0.id = product_allergen.allergen_id WHERE product_allergen.product_id = 3;
|
| 11 |
0.43 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4, t0.is_active AS is_active_5 FROM allergen t0 INNER JOIN product_allergen ON t0.id = product_allergen.allergen_id WHERE product_allergen.product_id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4, t0.is_active AS is_active_5 FROM allergen t0 INNER JOIN product_allergen ON t0.id = product_allergen.allergen_id WHERE product_allergen.product_id = 4;
|
| 12 |
0.43 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4, t0.is_active AS is_active_5 FROM allergen t0 INNER JOIN product_allergen ON t0.id = product_allergen.allergen_id WHERE product_allergen.product_id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4, t0.is_active AS is_active_5 FROM allergen t0 INNER JOIN product_allergen ON t0.id = product_allergen.allergen_id WHERE product_allergen.product_id = 5;
|
| 13 |
0.42 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4, t0.is_active AS is_active_5 FROM allergen t0 INNER JOIN product_allergen ON t0.id = product_allergen.allergen_id WHERE product_allergen.product_id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4, t0.is_active AS is_active_5 FROM allergen t0 INNER JOIN product_allergen ON t0.id = product_allergen.allergen_id WHERE product_allergen.product_id = 6;
|
| 14 |
0.44 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4, t0.is_active AS is_active_5 FROM allergen t0 INNER JOIN product_allergen ON t0.id = product_allergen.allergen_id WHERE product_allergen.product_id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4, t0.is_active AS is_active_5 FROM allergen t0 INNER JOIN product_allergen ON t0.id = product_allergen.allergen_id WHERE product_allergen.product_id = 7;
|
| 15 |
0.45 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4, t0.is_active AS is_active_5 FROM allergen t0 INNER JOIN product_allergen ON t0.id = product_allergen.allergen_id WHERE product_allergen.product_id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4, t0.is_active AS is_active_5 FROM allergen t0 INNER JOIN product_allergen ON t0.id = product_allergen.allergen_id WHERE product_allergen.product_id = 8;
|
| 16 |
0.44 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4, t0.is_active AS is_active_5 FROM allergen t0 INNER JOIN product_allergen ON t0.id = product_allergen.allergen_id WHERE product_allergen.product_id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4, t0.is_active AS is_active_5 FROM allergen t0 INNER JOIN product_allergen ON t0.id = product_allergen.allergen_id WHERE product_allergen.product_id = 9;
|
| 17 |
0.45 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4, t0.is_active AS is_active_5 FROM allergen t0 INNER JOIN product_allergen ON t0.id = product_allergen.allergen_id WHERE product_allergen.product_id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4, t0.is_active AS is_active_5 FROM allergen t0 INNER JOIN product_allergen ON t0.id = product_allergen.allergen_id WHERE product_allergen.product_id = 10;
|
| 18 |
0.42 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4, t0.is_active AS is_active_5 FROM allergen t0 INNER JOIN product_allergen ON t0.id = product_allergen.allergen_id WHERE product_allergen.product_id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4, t0.is_active AS is_active_5 FROM allergen t0 INNER JOIN product_allergen ON t0.id = product_allergen.allergen_id WHERE product_allergen.product_id = 11;
|
| 19 |
0.46 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4, t0.is_active AS is_active_5 FROM allergen t0 INNER JOIN product_allergen ON t0.id = product_allergen.allergen_id WHERE product_allergen.product_id = ?
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4, t0.is_active AS is_active_5 FROM allergen t0 INNER JOIN product_allergen ON t0.id = product_allergen.allergen_id WHERE product_allergen.product_id = 12;
|