Query Metrics
3
Database Queries
3
Different statements
36.89 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 29.73 ms |
SELECT DISTINCT r0_.id AS id_0, r0_.statusrv AS statusrv_1 FROM rvintervention r0_ ORDER BY r0_.statusrv DESC LIMIT 20 OFFSET 11200
Parameters:
[] |
2 | 1.66 ms |
SELECT r0_.id AS id_0, r0_.daterv AS daterv_1, r0_.com AS com_2, r0_.duree AS duree_3, r0_.address AS address_4, r0_.cp AS cp_5, r0_.town AS town_6, r0_.libre AS libre_7, r0_.tempseffectif AS tempseffectif_8, r0_.datevoulueclientde AS datevoulueclientde_9, r0_.datevoulueclienta AS datevoulueclienta_10, r0_.precisionsvouluesclient AS precisionsvouluesclient_11, r0_.dispos AS dispos_12, r0_.tempsfacture AS tempsfacture_13, r0_.statusrv AS statusrv_14, r0_.label AS label_15, r0_.gps AS gps_16, r0_.drive AS drive_17, r0_.nb_intervenants AS nb_intervenants_18, r0_.nb_intervenants_mandatory AS nb_intervenants_mandatory_19, r0_.datervfin AS datervfin_20, r0_.allday AS allday_21, r0_.sum_rafs AS sum_rafs_22, r0_.date_validated_with_client AS date_validated_with_client_23, r0_.modified_by_solver AS modified_by_solver_24, r0_.date_proposed_to_client AS date_proposed_to_client_25, r0_.updated_at AS updated_at_26, r0_.created_at AS created_at_27, r0_.chantier_id AS chantier_id_28, r0_.lieu_id AS lieu_id_29, r0_.typeintervention_id AS typeintervention_id_30, r0_.control_id AS control_id_31, r0_.access_ask_id AS access_ask_id_32, r0_.criticity_id AS criticity_id_33, r0_.meteo_id AS meteo_id_34, r0_.parking_id AS parking_id_35, r0_.last_user_modified_id AS last_user_modified_id_36 FROM rvintervention r0_ WHERE r0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY r0_.statusrv DESC
Parameters:
[ 14934 14935 14938 14940 14941 14942 14943 14944 14945 14946 14947 14948 14949 14950 14951 14952 14954 14955 14956 14957 ] |
3 | 5.50 ms |
SELECT count(*) AS sclr_0 FROM rvintervention r0_
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\Rvintervention | No errors. |
App\Entity\Chantier | 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\User | No errors. |
App\Entity\RvinterventionLogs | No errors. |
App\Entity\RvinterventionEquipement | No errors. |
App\Entity\Marchandise | No errors. |
App\Entity\ChantierRaf | No errors. |
App\Entity\Material | No errors. |