GET https://horeca.jphiweb.be/carte

Query Metrics

19 Database Queries
5 Different statements
9.90 ms Query time
0 Invalid entities
23 Managed entities

Grouped Statements

Show all queries

Time Count Info
5.58 ms
(56.35%)
12
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.position AS position_4, t0.is_active AS is_active_5 FROM allergen t0 INNER JOIN product_allergen ON t0.id = product_allergen.allergen_id WHERE product_allergen.product_id = ?
Parameters:
[
  1
]
2.05 ms
(20.65%)
4
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.position AS position_5, t0.image AS image_6, t0.is_available AS is_available_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.category_id AS category_id_10 FROM product t0 WHERE t0.category_id = ?
Parameters:
[
  1
]
0.89 ms
(8.97%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.image AS image_4, t0.position AS position_5, t0.is_active AS is_active_6, t0.slug AS slug_7, t0.seo_title AS seo_title_8, t0.meta_description AS meta_description_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM category t0 WHERE t0.is_active = ? ORDER BY t0.position ASC, t0.id ASC
Parameters:
[
  1
]
0.70 ms
(7.06%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.title AS title_3, t0.slug AS slug_4, t0.seo_title AS seo_title_5, t0.meta_description AS meta_description_6, t0.introduction AS introduction_7, t0.content AS content_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.site_settings_id AS site_settings_id_12 FROM site_page t0 WHERE t0.code = ? AND t0.is_active = ? LIMIT 1
Parameters:
[
  "menu"
  1
]
0.69 ms
(6.97%)
1
SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.slogan AS slogan_3, t0.phone AS phone_4, t0.email AS email_5, t0.whatsapp AS whatsapp_6, t0.full_address AS full_address_7, t0.short_address AS short_address_8, t0.latitude AS latitude_9, t0.longitude AS longitude_10, t0.logo AS logo_11, t0.hero_image AS hero_image_12, t0.notification_email AS notification_email_13, t0.email_notifications_enabled AS email_notifications_enabled_14, t0.general_notes AS general_notes_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17 FROM site_settings t0 ORDER BY t0.id ASC LIMIT 1
Parameters:
[]

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\Product 12
App\Entity\Allergen 5
App\Entity\Category 4
App\Entity\Page 1
App\Entity\SiteSettings 1

Entities Mapping