Query Metrics
3
Database Queries
3
Different statements
2.00 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.76 ms (38.11%) |
1 |
SELECT t0.id AS id_1, t0.daterv AS daterv_2, t0.com AS com_3, t0.duree AS duree_4, t0.address AS address_5, t0.cp AS cp_6, t0.town AS town_7, t0.libre AS libre_8, t0.tempseffectif AS tempseffectif_9, t0.datevoulueclientde AS datevoulueclientde_10, t0.datevoulueclienta AS datevoulueclienta_11, t0.precisionsvouluesclient AS precisionsvouluesclient_12, t0.dispos AS dispos_13, t0.tempsfacture AS tempsfacture_14, t0.statusrv AS statusrv_15, t0.label AS label_16, t0.gps AS gps_17, t0.drive AS drive_18, t0.nb_intervenants AS nb_intervenants_19, t0.nb_intervenants_mandatory AS nb_intervenants_mandatory_20, t0.datervfin AS datervfin_21, t0.allday AS allday_22, t0.sum_rafs AS sum_rafs_23, t0.date_validated_with_client AS date_validated_with_client_24, t0.modified_by_solver AS modified_by_solver_25, t0.date_proposed_to_client AS date_proposed_to_client_26, t0.updated_at AS updated_at_27, t0.created_at AS created_at_28, t0.chantier_id AS chantier_id_29, t0.lieu_id AS lieu_id_30, t0.typeintervention_id AS typeintervention_id_31, t0.control_id AS control_id_32, t0.access_ask_id AS access_ask_id_33, t0.criticity_id AS criticity_id_34, t0.meteo_id AS meteo_id_35, t0.parking_id AS parking_id_36, t0.last_user_modified_id AS last_user_modified_id_37 FROM rvintervention t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"15537"
]
|
|
0.66 ms (33.25%) |
1 |
SELECT t0.numchantier AS numchantier_1, t0.infos_app AS infos_app_2, t0.jours_homme AS jours_homme_3, t0.infos_prepa AS infos_prepa_4, t0.observation AS observation_5, t0.deleted AS deleted_6, t0.adresse AS adresse_7, t0.ville AS ville_8, t0.codepostal AS codepostal_9, t0.gps AS gps_10, t0.drive AS drive_11, t0.access_code AS access_code_12, t0.id AS id_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.client_id AS client_id_16, t0.segmentationchantier_id AS segmentationchantier_id_17, t0.modereglement_id AS modereglement_id_18, t0.user_id AS user_id_19, t0.tech_id AS tech_id_20 FROM chantier t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"5125"
]
|
|
0.57 ms (28.64%) |
1 |
SELECT t0.keysettings AS keysettings_1, t0.valuesettings AS valuesettings_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM setting t0
Parameters:
[] |
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\Setting | No 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\Marchandise | No errors. |
| App\Entity\Rvintervention | No errors. |
| App\Entity\ChantierRaf | No errors. |
| App\Entity\ChantierrafLog | No errors. |
| App\Entity\Lieu | No errors. |
| App\Entity\Typeintervention | No errors. |
| App\Entity\Control | No errors. |
| App\Entity\AccessAsk | No errors. |
| App\Entity\Criticity | No errors. |
| App\Entity\Meteo | No errors. |
| App\Entity\Parking | No errors. |
| App\Entity\RvinterventionLogs | No errors. |
| App\Entity\RvinterventionEquipement | No errors. |
| App\Entity\Material | No errors. |