GET https://app-35-preprod.mvue.fr/api/screen/E8-80-88-B8-A2-B0

Query Metrics

3 Database Queries
3 Different statements
2.43 ms Query time
0 Invalid entities
8 Managed entities

Grouped Statements

Show all queries

default connection

Time Count Info
1.61 ms
(66.05%)
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.45 ms
(18.45%)
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.38 ms
(15.49%)
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