Query Metrics
5
Database Queries
4
Different statements
6.60 ms
Query time
0
Invalid entities
Queries
default connection
| #▲ | Time | Info |
|---|---|---|
| 1 | 3.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.created_at AS created_at_4, t0.email AS email_5, t0.description AS description_6, t0.is_valid AS is_valid_7, t0.full_name AS full_name_8, t0.tel AS tel_9, t0.address AS address_10, t0.city AS city_11, t0.ice AS ice_12, t0.rc AS rc_13, t0.simulate_username AS simulate_username_14, t0.simulate_password AS simulate_password_15, t0.cover_image AS cover_image_16, t0.path_rcimage AS path_rcimage_17, t0.path_ice_image AS path_ice_image_18, t0.path_ifimage AS path_ifimage_19, t0.identifiant_fiscale AS identifiant_fiscale_20, t0.user_id AS user_id_21 FROM vendor t0 WHERE t0.user_id IS NULL LIMIT 1
Parameters:
[] |
| 2 | 0.91 ms |
SELECT DISTINCT l0_.id AS id_0, l0_.logged_at AS logged_at_1 FROM log_history l0_ WHERE l0_.object_class = 'App\\Flexy\\ShopBundle\\Entity\\Order\\Order' AND l0_.action = 'update' AND l0_.object_id = ? GROUP BY l0_.logged_at ORDER BY l0_.logged_at DESC LIMIT 20
Parameters:
[
"11617"
]
|
| 3 | 0.53 ms |
SELECT count(l0_.id) AS sclr_0 FROM log_history l0_ WHERE l0_.object_class = 'App\\Flexy\\ShopBundle\\Entity\\Order\\Order' AND l0_.action = 'update' AND l0_.object_id = ? GROUP BY l0_.logged_at
Parameters:
[
"11617"
]
|
| 4 | 0.96 ms |
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.front_theme_id AS front_theme_id_30 FROM settings t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"main"
]
|
| 5 | 0.84 ms |
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.front_theme_id AS front_theme_id_30 FROM settings t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"main"
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| salle2 | doctrine.dbal.salle2_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\Entity\User | No errors. |
| App\Entity\LogHistory | No errors. |
| App\Entity\Settings | No errors. |
| App\Entity\FrontTheme | No errors. |