Query Metrics

11 Database Queries
7 Different statements
0.81 ms Query time
0 Invalid entities
22 Managed entities

Queries

Group similar statements

default connection

#▲ Time Info
1 0.06 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.route_name AS route_name_4, t0.slug AS slug_5, t0.url AS url_6 FROM static_page t0 WHERE t0.route_name = ? LIMIT 1
Parameters:
[
  "offer_landing_page"
]
2 0.04 ms
SELECT t0.id AS id_1, t0.meta_title AS meta_title_2, t0.meta_description AS meta_description_3, t0.route_name AS route_name_4, t0.slug AS slug_5, t0.url AS url_6 FROM static_page t0 WHERE t0.route_name = ? LIMIT 1
Parameters:
[
  "offer_landing_page"
]
3 0.04 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.link_href AS link_href_3, t0.link_order AS link_order_4, t0.picto_class AS picto_class_5, t0.status AS status_6 FROM main_menu_item t0 WHERE t0.status = ? ORDER BY t0.link_order ASC
Parameters:
[
  "published"
]
4 0.30 ms
SELECT n0_.id AS id_0, n0_.message AS message_1, n0_.created_at AS created_at_2, n0_.published_at AS published_at_3, n0_.status AS status_4, n0_.title AS title_5 FROM notification n0_ WHERE n0_.published_at <= ? AND n0_.status = ? ORDER BY n0_.published_at DESC
Parameters:
[
  "2026-11-07 11:59:32"
  "published"
]
5 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.link_href AS link_href_3, t0.link_order AS link_order_4, t0.picto_class AS picto_class_5, t0.status AS status_6 FROM main_menu_item t0 WHERE t0.status = ? ORDER BY t0.link_order ASC
Parameters:
[
  "published"
]
6 0.05 ms
SELECT t0.id AS id_1, t0.max_weight AS max_weight_2, t0.price_weight AS price_weight_3 FROM level_rate t0 ORDER BY t0.max_weight ASC
Parameters:
[]
7 0.04 ms
SELECT t0.id AS id_1, t0.country AS country_2, t0.rate AS rate_3 FROM vat_rate t0 WHERE t0.country = ? LIMIT 1
Parameters:
[
  "france"
]
8 0.07 ms
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.background_image AS background_image_2, b0_.background_image_mobile AS background_image_mobile_3, b0_.content AS content_4, b0_.cta_name AS cta_name_5, b0_.cta_url AS cta_url_6, b0_.status AS status_7, b0_.dynamic_pages AS dynamic_pages_8, b0_.created AS created_9, b0_.updated AS updated_10 FROM banner b0_ WHERE b0_.status = ? AND b0_.dynamic_pages LIKE ?
Parameters:
[
  "published"
  "%"offer_landing_page"%"
]
9 0.04 ms
SELECT b0_.id AS id_0, b0_.title AS title_1, b0_.background_image AS background_image_2, b0_.background_image_mobile AS background_image_mobile_3, b0_.content AS content_4, b0_.cta_name AS cta_name_5, b0_.cta_url AS cta_url_6, b0_.status AS status_7, b0_.dynamic_pages AS dynamic_pages_8, b0_.created AS created_9, b0_.updated AS updated_10 FROM banner b0_ WHERE b0_.status = ? AND b0_.dynamic_pages LIKE ?
Parameters:
[
  "published"
  "%"offer_landing_page"%"
]
10 0.04 ms
SELECT t0.id AS id_1, t0.figure AS figure_2, t0.title AS title_3, t0.data_order AS data_order_4, t0.status AS status_5 FROM key_figure t0 WHERE t0.status = ? ORDER BY t0.data_order ASC
Parameters:
[
  "published"
]
11 0.03 ms
SELECT t0.id AS id_1, t0.figure AS figure_2, t0.title AS title_3, t0.data_order AS data_order_4, t0.status AS status_5 FROM key_figure t0 WHERE t0.status = ? ORDER BY t0.data_order ASC
Parameters:
[
  "published"
]

Database Connections

Name Service
default doctrine.dbal.default_connection
historic doctrine.dbal.historic_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\LevelRate 9
App\Entity\MainMenuItem 5
App\Entity\KeyFigure 4
App\Entity\StaticPage 1
App\Entity\Notification 1
App\Entity\VatRate 1
App\Entity\Banner 1

Entities Mapping

Class Mapping errors
App\Entity\StaticPage No errors.
App\Entity\MainMenuItem No errors.
App\Entity\Notification No errors.
App\Entity\LevelRate No errors.
App\Entity\VatRate No errors.
App\Entity\Banner No errors.
App\Entity\CMSPage No errors.
App\Entity\KeyFigure No errors.