Query Metrics
10
Database Queries
5
Different statements
4.62 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.16 ms (46.76%) |
6 |
SELECT t0.id AS id_1, t0.is_monday AS is_monday_2, t0.is_tuesday AS is_tuesday_3, t0.is_wednesday AS is_wednesday_4, t0.is_thursday AS is_thursday_5, t0.is_friday AS is_friday_6, t0.is_saturday AS is_saturday_7, t0.is_sunday AS is_sunday_8, t0.start_work_at AS start_work_at_9, t0.end_work_at AS end_work_at_10, t0.exclude_days AS exclude_days_11, t0.exclude_dates AS exclude_dates_12, t0.exclude_hours AS exclude_hours_13, t0.logo AS logo_14, t0.logo_base64 AS logo_base64_15, t0.favicon AS favicon_16, t0.email AS email_17, t0.address AS address_18, t0.currency AS currency_19, t0.default_lang AS default_lang_20, t0.project_name AS project_name_21, t0.code AS code_22, t0.asset_folder_name AS asset_folder_name_23, t0.mail_order_created_body AS mail_order_created_body_24, t0.mail_order_created_title AS mail_order_created_title_25, t0.prefix_order AS prefix_order_26, t0.root_url AS root_url_27, t0.description AS description_28, t0.is_mercure_enabled AS is_mercure_enabled_29, t0.mobile_app_scheme AS mobile_app_scheme_30, t0.mobile_app_scheme_dev AS mobile_app_scheme_dev_31, t0.developpement_env AS developpement_env_32, t0.mobile_app_scheme_ios AS mobile_app_scheme_ios_33, t0.mobile_app_scheme_android AS mobile_app_scheme_android_34, t0.front_theme_id AS front_theme_id_35 FROM settings t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"main"
]
|
|
1.31 ms (28.37%) |
1 |
SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.name AS name_2, c0_.code AS code_3 FROM customer_group c0_
Parameters:
[] |
|
0.44 ms (9.50%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.css_classes AS css_classes_3, t0.type AS type_4, t0.route_name AS route_name_5, t0.route_param AS route_param_6, t0.route_param_value AS route_param_value_7, t0.url AS url_8, t0.role AS role_9, t0.anchor AS anchor_10, t0.position AS position_11, t0.attributes AS attributes_12, t0.link_css_classes AS link_css_classes_13, t0.hide_if_role AS hide_if_role_14, t0.deleted_at AS deleted_at_15, t0.menu_id AS menu_id_16, t0.parent_menu_item_id AS parent_menu_item_id_17, t0.link_id AS link_id_18, t0.link_type_id AS link_type_id_19 FROM menu_item t0 WHERE (t0.parent_menu_item_id IS NULL AND t0.menu_id = ?) AND ((t0.deleted_at IS NULL)) ORDER BY t0.position ASC
Parameters:
[
1
]
|
|
0.37 ms (7.92%) |
1 |
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.description AS description_2, n0_.image AS image_3, n0_.date_debut AS date_debut_4, n0_.date_fin AS date_fin_5, n0_.under_title AS under_title_6, n0_.type AS type_7 FROM newshome n0_ WHERE n0_.type = ? AND n0_.date_debut <= ? AND n0_.date_fin >= ?
Parameters:
[ "Offre" "2025-07-31 18:44:41" "2025-07-31 18:44:41" ] |
|
0.34 ms (7.46%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.css_classes AS css_classes_3, t0.created_at AS created_at_4, t0.is_main_menu AS is_main_menu_5 FROM menu t0 WHERE t0.is_main_menu = ? LIMIT 1
Parameters:
[
1
]
|
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.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Flexy\ShopBundle\Entity\Vendor\Vendor | No errors. |
| App\Flexy\ShopBundle\Entity\Customer\Customer | No errors. |
| App\Flexy\ShopBundle\Entity\Customer\CustomerGroup | No errors. |
| App\Flexy\ShopBundle\Entity\Shipping\ShippingMethod | No errors. |
| App\Entity\Settings | No errors. |
| App\Entity\FrontTheme | No errors. |
| App\Flexy\FrontBundle\Entity\Menu | No errors. |
| App\Flexy\FrontBundle\Entity\MenuItem | No errors. |
| App\Entity\Link | No errors. |
| App\Entity\LinkType | No errors. |
| App\Flexy\FrontBundle\Entity\Newshome | No errors. |