Query Metrics

3 Database Queries
3 Different statements
36.89 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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