19.51 ms (90.75%)
|
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.35 ms (1.63%)
|
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 = 83;
|
0.32 ms (1.51%)
|
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: [
"bio-veggie"
]
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 = 'bio-veggie' LIMIT 1;
|
0.24 ms (1.13%)
|
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 = 83;
|
0.21 ms (0.97%)
|
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 = 131;
|
0.20 ms (0.94%)
|
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 = 83 ORDER BY r0_.created_at DESC;
|
0.19 ms (0.88%)
|
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 = 83;
|
0.19 ms (0.86%)
|
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 = 7 LIMIT 3;
|
0.15 ms (0.71%)
|
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 = 131;
|
0.14 ms (0.63%)
|
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 = 83;
|