Query Metrics
3
Database Queries
3
Different statements
2.72 ms
Query time
0
Invalid entities
8
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
1.70 ms (62.61%) |
1 |
SELECT s0_.id AS id_0, s0_.enabled AS enabled_1, s0_.remote_id AS remote_id_2, s0_.identifier AS identifier_3, s0_.serial_number AS serial_number_4, s0_.ip AS ip_5, s0_.ip_public AS ip_public_6, s0_.mac_address AS mac_address_7, s0_.port AS port_8, s0_.enable_notification AS enable_notification_9, s0_.is_remove_processing AS is_remove_processing_10, s0_.created_at AS created_at_11, s0_.updated_at AS updated_at_12, s1_.id AS id_13, s1_.title AS title_14, s1_.description AS description_15, s1_.created_at AS created_at_16, s1_.updated_at AS updated_at_17, s0_.site_id AS site_id_18, s0_.info_id AS info_id_19, s0_.status_id AS status_id_20, s0_.action_id AS action_id_21, s0_.enabled_diffusion_id AS enabled_diffusion_id_22, s0_.message_defilant_id AS message_defilant_id_23, s0_.stats_id AS stats_id_24, s1_.screen_id AS screen_id_25 FROM screen s0_ LEFT JOIN screen_log s1_ ON s0_.id = s1_.screen_id WHERE s0_.mac_address = ? ORDER BY s1_.created_at DESC, s1_.id DESC
Parameters:
[
"E8-80-88-B8-A2-B0"
]
|
|
0.54 ms (19.85%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_law AS is_law_3, t0.is_law_statistique AS is_law_statistique_4, t0.is_model AS is_model_5, t0.is_notification AS is_notification_6, t0.code AS code_7, t0.api_url AS api_url_8, t0.quota AS quota_9, t0.isialis_code AS isialis_code_10, t0.is_enabled AS is_enabled_11, t0.max_enabled_screen AS max_enabled_screen_12, t0.api_ttl AS api_ttl_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.info_id AS info_id_16 FROM user_company t0 WHERE t0.id = ?
Parameters:
[
211
]
|
|
0.48 ms (17.54%) |
1 |
SELECT t0.id AS id_1, t0.remote_id AS remote_id_2, t0.name AS name_3, t0.public AS public_4, t0.api_ttl AS api_ttl_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.company_id AS company_id_8, t0.info_id AS info_id_9 FROM site t0 WHERE t0.id = ?
Parameters:
[
952
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| old | doctrine.dbal.old_connection |
| pureftpd | doctrine.dbal.pureftpd_connection |
| use_savepoints | doctrine.dbal.use_savepoints_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\Site\Screen | 1 |
| App\Entity\Site\Site | 1 |
| App\Entity\Site\Screen\Info | 1 |
| App\Entity\Site\Screen\Status | 1 |
| App\Entity\Site\Screen\Action | 1 |
| App\Entity\Site\Screen\Diffusion | 1 |
| App\Entity\Site\Screen\Stats | 1 |
| App\Entity\User\Company | 1 |