| 1 |
0.23 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.illustration AS illustration_4 FROM category t0
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.illustration AS illustration_4 FROM category t0;
|
| 2 |
0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.illustration AS illustration_4, t0.address AS address_5, t0.city AS city_6, t0.postcode AS postcode_7, t0.phonenumber AS phonenumber_8, t0.website AS website_9, t0.promote AS promote_10, t0.active AS active_11, t0.category_id AS category_id_12 FROM restaurants t0 WHERE t0.slug = ? LIMIT 1
Parameters: [
"delhi-darbar"
]
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.illustration AS illustration_4, t0.address AS address_5, t0.city AS city_6, t0.postcode AS postcode_7, t0.phonenumber AS phonenumber_8, t0.website AS website_9, t0.promote AS promote_10, t0.active AS active_11, t0.category_id AS category_id_12 FROM restaurants t0 WHERE t0.slug = 'delhi-darbar' LIMIT 1;
|
| 3 |
0.20 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.illustration AS illustration_4, t0.address AS address_5, t0.city AS city_6, t0.postcode AS postcode_7, t0.phonenumber AS phonenumber_8, t0.website AS website_9, t0.promote AS promote_10, t0.active AS active_11, t0.category_id AS category_id_12 FROM restaurants t0 WHERE t0.category_id = ? LIMIT 3
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.illustration AS illustration_4, t0.address AS address_5, t0.city AS city_6, t0.postcode AS postcode_7, t0.phonenumber AS phonenumber_8, t0.website AS website_9, t0.promote AS promote_10, t0.active AS active_11, t0.category_id AS category_id_12 FROM restaurants t0 WHERE t0.category_id = 5 LIMIT 3;
|
| 4 |
0.20 ms |
SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.comment AS comment_2, r0_.created_at AS created_at_3, r0_.user_id AS user_id_4, r0_.restaurant_id AS restaurant_id_5 FROM review r0_ WHERE r0_.restaurant_id = ? ORDER BY r0_.created_at DESC
SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.comment AS comment_2, r0_.created_at AS created_at_3, r0_.user_id AS user_id_4, r0_.restaurant_id AS restaurant_id_5 FROM review r0_ WHERE r0_.restaurant_id = 64 ORDER BY r0_.created_at DESC;
|
| 5 |
0.17 ms |
SELECT AVG(r0_.rating) AS sclr_0 FROM review r0_ WHERE r0_.restaurant_id = ?
SELECT AVG(r0_.rating) AS sclr_0 FROM review r0_ WHERE r0_.restaurant_id = 64;
|
| 6 |
0.24 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.restaurant_id_id AS restaurant_id_id_3 FROM images t0 WHERE t0.restaurant_id_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.restaurant_id_id AS restaurant_id_id_3 FROM images t0 WHERE t0.restaurant_id_id = 64;
|
| 7 |
0.17 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.sub_section AS sub_section_3, t0.relation_id AS relation_id_4 FROM menu_section t0 WHERE t0.relation_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.sub_section AS sub_section_3, t0.relation_id AS relation_id_4 FROM menu_section t0 WHERE t0.relation_id = 64;
|
| 8 |
0.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.description AS description_4, t0.menu_section_id_id AS menu_section_id_id_5, t0.sub_menu_section_id AS sub_menu_section_id_6 FROM menu_items t0 WHERE t0.menu_section_id_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.price AS price_3, t0.description AS description_4, t0.menu_section_id_id AS menu_section_id_id_5, t0.sub_menu_section_id AS sub_menu_section_id_6 FROM menu_items t0 WHERE t0.menu_section_id_id = 108;
|
| 9 |
0.15 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_section_id_id AS menu_section_id_id_3 FROM sub_menu_section t0 WHERE t0.menu_section_id_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.menu_section_id_id AS menu_section_id_id_3 FROM sub_menu_section t0 WHERE t0.menu_section_id_id = 108;
|
| 10 |
0.15 ms |
SELECT t0.id AS id_1, t0.lundi AS lundi_2, t0.mardi AS mardi_3, t0.mercredi AS mercredi_4, t0.jeudi AS jeudi_5, t0.vendredi AS vendredi_6, t0.samedi AS samedi_7, t0.dimanche AS dimanche_8, t0.restaurant_id_id AS restaurant_id_id_9 FROM horaires t0 WHERE t0.restaurant_id_id = ?
SELECT t0.id AS id_1, t0.lundi AS lundi_2, t0.mardi AS mardi_3, t0.mercredi AS mercredi_4, t0.jeudi AS jeudi_5, t0.vendredi AS vendredi_6, t0.samedi AS samedi_7, t0.dimanche AS dimanche_8, t0.restaurant_id_id AS restaurant_id_id_9 FROM horaires t0 WHERE t0.restaurant_id_id = 64;
|