20.59 ms (91.78%)
|
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.29 ms (1.30%)
|
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: [
"le-zinc"
]
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 = 'le-zinc' LIMIT 1;
|
0.28 ms (1.26%)
|
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 = 33;
|
0.20 ms (0.87%)
|
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 = 33;
|
0.19 ms (0.86%)
|
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 = 33;
|
0.19 ms (0.84%)
|
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 = 66;
|
0.19 ms (0.83%)
|
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 = 33 ORDER BY r0_.created_at DESC;
|
0.19 ms (0.82%)
|
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 = 2 LIMIT 3;
|
0.18 ms (0.80%)
|
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 = 33;
|
0.15 ms (0.65%)
|
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 = 66;
|