GET https://findrfood.be/restaurant/nature-saveurs

Query Metrics

10 Database Queries
10 Different statements
2.97 ms Query time
0 Invalid entities
15 Managed entities

Queries

Group similar statements

# Time Info
1 0.65 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
Parameters:
[]
2 0.32 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:
[
  "nature-saveurs"
]
3 0.22 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
Parameters:
[
  7
]
4 0.33 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
Parameters:
[
  85
]
5 0.17 ms
SELECT AVG(r0_.rating) AS sclr_0 FROM review r0_ WHERE r0_.restaurant_id = ?
Parameters:
[
  85
]
6 0.33 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 = ?
Parameters:
[
  85
]
7 0.20 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 = ?
Parameters:
[
  85
]
8 0.32 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 = ?
Parameters:
[
  133
]
9 0.19 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 = ?
Parameters:
[
  133
]
10 0.23 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 = ?
Parameters:
[
  85
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Category 8
App\Entity\Restaurants 4
App\Entity\MenuSection 1
App\Entity\MenuItems 1
App\Entity\Horaires 1

Entities Mapping

Class Mapping errors
App\Entity\Category No errors.
App\Entity\Restaurants No errors.
App\Entity\MenuSection No errors.
App\Entity\Images No errors.
App\Entity\Horaires No errors.
App\Entity\Review No errors.
App\Entity\User No errors.
App\Entity\MenuItems No errors.
App\Entity\SubMenuSection No errors.