0.36 ms (15.58%)
|
1 |
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;
|
0.30 ms (13.10%)
|
1 |
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: [
"cucina-toscana"
]
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 = 'cucina-toscana' LIMIT 1;
|
0.26 ms (11.32%)
|
1 |
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 = 15;
|
0.25 ms (10.87%)
|
1 |
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 = 45;
|
0.25 ms (10.71%)
|
1 |
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 = 15 ORDER BY r0_.created_at DESC;
|
0.22 ms (9.36%)
|
1 |
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 = 1 LIMIT 3;
|
0.21 ms (9.26%)
|
1 |
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 = 15;
|
0.18 ms (7.97%)
|
1 |
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 = 15;
|
0.14 ms (6.22%)
|
1 |
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 = 15;
|
0.13 ms (5.61%)
|
1 |
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 = 45;
|