Query Metrics
1
Database Queries
1
Different statements
0.97 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.97 ms |
SELECT c0_.numchantier AS numchantier_0, c0_.infos_app AS infos_app_1, c0_.jours_homme AS jours_homme_2, c0_.infos_prepa AS infos_prepa_3, c0_.observation AS observation_4, c0_.deleted AS deleted_5, c0_.adresse AS adresse_6, c0_.ville AS ville_7, c0_.codepostal AS codepostal_8, c0_.gps AS gps_9, c0_.drive AS drive_10, c0_.access_code AS access_code_11, c0_.id AS id_12, c0_.created_at AS created_at_13, c0_.updated_at AS updated_at_14, c1_.fullname AS fullname_15, c1_.telfixe AS telfixe_16, c1_.telmobile AS telmobile_17, c1_.email AS email_18, c1_.deleted AS deleted_19, c1_.id AS id_20, c1_.created_at AS created_at_21, c1_.updated_at AS updated_at_22, c2_.id AS id_23, c2_.number AS number_24, c2_.link AS link_25, c2_.sms AS sms_26, c2_.email AS email_27, s3_.nom AS nom_28, s3_.description AS description_29, s3_.id AS id_30, s3_.created_at AS created_at_31, s3_.updated_at AS updated_at_32, m4_.nom AS nom_33, m4_.id AS id_34, m4_.created_at AS created_at_35, m4_.updated_at AS updated_at_36, u5_.id AS id_37, u5_.email AS email_38, u5_.roles AS roles_39, u5_.password AS password_40, u5_.username AS username_41, u5_.color AS color_42, u5_.tel AS tel_43, u5_.status AS status_44, u5_.ref_tech AS ref_tech_45, u5_.updated_at AS updated_at_46, u5_.created_at AS created_at_47, u6_.id AS id_48, u6_.email AS email_49, u6_.roles AS roles_50, u6_.password AS password_51, u6_.username AS username_52, u6_.color AS color_53, u6_.tel AS tel_54, u6_.status AS status_55, u6_.ref_tech AS ref_tech_56, u6_.updated_at AS updated_at_57, u6_.created_at AS created_at_58, i7_.nom AS nom_59, i7_.tel AS tel_60, i7_.email AS email_61, i7_.role AS role_62, i7_.id AS id_63, i7_.created_at AS created_at_64, i7_.updated_at AS updated_at_65, c0_.client_id AS client_id_66, c0_.segmentationchantier_id AS segmentationchantier_id_67, c0_.modereglement_id AS modereglement_id_68, c0_.user_id AS user_id_69, c0_.tech_id AS tech_id_70, c2_.client_id AS client_id_71, u5_.typeuser_id AS typeuser_id_72, u6_.typeuser_id AS typeuser_id_73, i7_.chantier_id AS chantier_id_74 FROM chantier c0_ LEFT JOIN client c1_ ON c0_.client_id = c1_.id LEFT JOIN client_contact c2_ ON c1_.id = c2_.client_id LEFT JOIN segmentationchantier s3_ ON c0_.segmentationchantier_id = s3_.id LEFT JOIN modereglement m4_ ON c0_.modereglement_id = m4_.id LEFT JOIN user u5_ ON c0_.user_id = u5_.id LEFT JOIN user u6_ ON c0_.tech_id = u6_.id LEFT JOIN intervenant i7_ ON c0_.id = i7_.chantier_id WHERE c0_.id = ?
Parameters:
[
170
]
|
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\Entity\Chantier | No errors. |
| App\Entity\Client | No errors. |
| App\Entity\Segmentationchantier | No errors. |
| App\Entity\Modereglement | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Intervenant | No errors. |
| App\Entity\ClientContact | No errors. |
| App\Entity\Typeuser | No errors. |
| App\Entity\Marchandise | No errors. |
| App\Entity\Rvintervention | No errors. |
| App\Entity\ChantierRaf | No errors. |
| App\Entity\ChantierrafLog | No errors. |
| App\Entity\ClientMessage | No errors. |
| App\Entity\Logstatusmarchandise | No errors. |
| App\Entity\RvinterventionLogs | No errors. |
| App\Entity\ClientRequest | No errors. |
| App\Entity\Material | No errors. |