GET https://site.test.permanences.fr/centres-medicaux

Response
200 OK
IP
216.73.216.0
Profiled on
Token
2ca0ea

Query Metrics

3 Database Queries
3 Different statements
22.51 ms Query time
0 Invalid entities
1231 Managed entities

Queries

Group similar statements

#▲ Time Info
1 17.38 ms 
SELECT r0_.id AS id_0, r0_.name AS name_1, r0_.code AS code_2, d1_.id AS id_3, d1_.name AS name_4, d1_.code AS code_5, c2_.id AS id_6, c2_.name AS name_7, c2_.code AS code_8, c3_.id AS id_9, c3_.name AS name_10, c3_.street AS street_11, c3_.street2 AS street2_12, c3_.phone AS phone_13, c3_.fax AS fax_14, c3_.latitude AS latitude_15, c3_.longitude AS longitude_16, c3_.physical AS physical_17, c3_.enabled AS enabled_18, c3_.deleted_at AS deleted_at_19, c3_.slug AS slug_20, c3_.windev_id AS windev_id_21, c3_.google_url AS google_url_22, c3_.description AS description_23, c3_.open_date AS open_date_24, c3_.open_time AS open_time_25, c3_.close_time AS close_time_26, c3_.constructed AS constructed_27, c3_.created_by AS created_by_28, c3_.updated_by AS updated_by_29, c3_.created_at AS created_at_30, c3_.updated_at AS updated_at_31, c3_.alert_message AS alert_message_32, c3_.alert_start_date AS alert_start_date_33, c3_.alert_end_date AS alert_end_date_34, c3_.alert_enabled AS alert_enabled_35, c3_.alert_type AS alert_type_36, d1_.region_id AS region_id_37, c2_.department_id AS department_id_38, c3_.city_id AS city_id_39 FROM region r0_ INNER JOIN department d1_ ON r0_.id = d1_.region_id INNER JOIN city c2_ ON d1_.id = c2_.department_id INNER JOIN centre c3_ ON c2_.id = c3_.city_id AND (c3_.deleted_at IS NULL) WHERE c3_.physical = true AND c3_.enabled = true AND c3_.windev_id IS NOT NULL AND c3_.open_date IS NOT NULL ORDER BY r0_.name ASC, d1_.name ASC, c2_.name ASC, c3_.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
2 3.62 ms 
SELECT t0.id AS id_1, t0.roles AS roles_2, t0.contract_days AS contract_days_3, t0.contract_part_times AS contract_part_times_4, t0.contract_shares_days AS contract_shares_days_5, t0.contract_shares_part_times AS contract_shares_part_times_6, t0.contract_notes AS contract_notes_7, t0.user_id AS user_id_8, t0.centre_id AS centre_id_9 FROM user_centre_role t0 WHERE t0.centre_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  35
  28
  21
  26
  25
  47
  18
  33
  34
  30
  58
  23
  31
  7
  9
  11
  1
  20
  3
  6
  10
  15
  4
  36
  29
  19
  22
  32
  17
  16
  5
  2
  27
  8
  12
  13
  24
]
View formatted query    View runnable query    Explain query
3 1.50 ms 
SELECT t0.id AS id_1, t0.maintenance AS maintenance_2, t0.alert_message AS alert_message_3, t0.alert_start_date AS alert_start_date_4, t0.alert_end_date AS alert_end_date_5, t0.alert_enabled AS alert_enabled_6, t0.alert_type AS alert_type_7 FROM config t0 LIMIT 1
Parameters: 
[]
View formatted query    View runnable query    Explain query

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\UserCentreRole 728
App\Entity\User 415
App\Entity\Centre 37
App\Entity\City 36
App\Entity\Department 9
App\Entity\Region 5
App\Entity\Config 1

Entities Mapping

Class Mapping errors
App\Entity\Region No errors.
App\Entity\Department No errors.
App\Entity\City No errors.
App\Entity\Embed\Alert No errors.
App\Entity\Centre No errors.
App\Entity\Calendar No errors.
App\Entity\Embed\Contract No errors.
App\Entity\UserCentreRole No errors.
App\Entity\Media No errors.
App\Entity\TimetableChange No errors.
App\Entity\User No errors.
App\Entity\Config No errors.