GET http://zabal.disc-chantier.com/api/rvinterventions/15532

Response
302 Found
IP
172.30.0.1
Profiled on
Token
602519

Query Metrics

1 Database Queries
1 Different statements
2.51 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 2.51 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, c1_.numchantier AS numchantier_28, c1_.infos_app AS infos_app_29, c1_.jours_homme AS jours_homme_30, c1_.infos_prepa AS infos_prepa_31, c1_.observation AS observation_32, c1_.deleted AS deleted_33, c1_.adresse AS adresse_34, c1_.ville AS ville_35, c1_.codepostal AS codepostal_36, c1_.gps AS gps_37, c1_.drive AS drive_38, c1_.access_code AS access_code_39, c1_.id AS id_40, c1_.created_at AS created_at_41, c1_.updated_at AS updated_at_42, l2_.id AS id_43, l2_.nom AS nom_44, l2_.updated_at AS updated_at_45, l2_.created_at AS created_at_46, u3_.id AS id_47, u3_.email AS email_48, u3_.roles AS roles_49, u3_.password AS password_50, u3_.username AS username_51, u3_.color AS color_52, u3_.tel AS tel_53, u3_.status AS status_54, u3_.ref_tech AS ref_tech_55, u3_.updated_at AS updated_at_56, u3_.created_at AS created_at_57, t4_.nom AS nom_58, t4_.id AS id_59, t4_.created_at AS created_at_60, t4_.updated_at AS updated_at_61, r5_.name AS name_62, r5_.usable_urgence AS usable_urgence_63, r5_.id AS id_64, r5_.created_at AS created_at_65, r5_.updated_at AS updated_at_66, u6_.id AS id_67, u6_.email AS email_68, u6_.roles AS roles_69, u6_.password AS password_70, u6_.username AS username_71, u6_.color AS color_72, u6_.tel AS tel_73, u6_.status AS status_74, u6_.ref_tech AS ref_tech_75, u6_.updated_at AS updated_at_76, u6_.created_at AS created_at_77, t7_.nom AS nom_78, t7_.id AS id_79, t7_.created_at AS created_at_80, t7_.updated_at AS updated_at_81, m8_.quantitenature AS quantitenature_82, m8_.date_arc AS date_arc_83, m8_.commentaire AS commentaire_84, m8_.collisage AS collisage_85, m8_.tempsalloue AS tempsalloue_86, m8_.delaifournisseur AS delaifournisseur_87, m8_.quantitearticle AS quantitearticle_88, m8_.demandestatus AS demandestatus_89, m8_.early AS early_90, m8_.num_arc AS num_arc_91, m8_.id AS id_92, m8_.created_at AS created_at_93, m8_.updated_at AS updated_at_94, c9_.id AS id_95, c9_.status AS status_96, c9_.content AS content_97, c9_.tempsalloue AS tempsalloue_98, t10_.nom AS nom_99, t10_.id AS id_100, t10_.created_at AS created_at_101, t10_.updated_at AS updated_at_102, c11_.id AS id_103, c11_.label AS label_104, a12_.id AS id_105, a12_.label AS label_106, a12_.created_at AS created_at_107, a12_.updated_at AS updated_at_108, c13_.id AS id_109, c13_.created_at AS created_at_110, c13_.updated_at AS updated_at_111, c13_.label AS label_112, m14_.id AS id_113, m14_.label AS label_114, m14_.created_at AS created_at_115, m14_.updated_at AS updated_at_116, p15_.id AS id_117, p15_.label AS label_118, p15_.created_at AS created_at_119, p15_.updated_at AS updated_at_120, u16_.id AS id_121, u16_.email AS email_122, u16_.roles AS roles_123, u16_.password AS password_124, u16_.username AS username_125, u16_.color AS color_126, u16_.tel AS tel_127, u16_.status AS status_128, u16_.ref_tech AS ref_tech_129, u16_.updated_at AS updated_at_130, u16_.created_at AS created_at_131, t17_.nom AS nom_132, t17_.id AS id_133, t17_.created_at AS created_at_134, t17_.updated_at AS updated_at_135, m18_.name AS name_136, m18_.comment AS comment_137, m18_.position AS position_138, m18_.image_name AS image_name_139, m18_.image_size AS image_size_140, m18_.deleted AS deleted_141, m18_.usable_urgence AS usable_urgence_142, m18_.id AS id_143, m18_.created_at AS created_at_144, m18_.updated_at AS updated_at_145, u19_.id AS id_146, u19_.email AS email_147, u19_.roles AS roles_148, u19_.password AS password_149, u19_.username AS username_150, u19_.color AS color_151, u19_.tel AS tel_152, u19_.status AS status_153, u19_.ref_tech AS ref_tech_154, u19_.updated_at AS updated_at_155, u19_.created_at AS created_at_156, t20_.nom AS nom_157, t20_.id AS id_158, t20_.created_at AS created_at_159, t20_.updated_at AS updated_at_160, u21_.id AS id_161, u21_.email AS email_162, u21_.roles AS roles_163, u21_.password AS password_164, u21_.username AS username_165, u21_.color AS color_166, u21_.tel AS tel_167, u21_.status AS status_168, u21_.ref_tech AS ref_tech_169, u21_.updated_at AS updated_at_170, u21_.created_at AS created_at_171, t22_.nom AS nom_172, t22_.id AS id_173, t22_.created_at AS created_at_174, t22_.updated_at AS updated_at_175, r0_.chantier_id AS chantier_id_176, r0_.lieu_id AS lieu_id_177, r0_.typeintervention_id AS typeintervention_id_178, r0_.control_id AS control_id_179, r0_.access_ask_id AS access_ask_id_180, r0_.criticity_id AS criticity_id_181, r0_.meteo_id AS meteo_id_182, r0_.parking_id AS parking_id_183, r0_.last_user_modified_id AS last_user_modified_id_184, c1_.client_id AS client_id_185, c1_.segmentationchantier_id AS segmentationchantier_id_186, c1_.modereglement_id AS modereglement_id_187, c1_.user_id AS user_id_188, c1_.tech_id AS tech_id_189, u3_.typeuser_id AS typeuser_id_190, u6_.typeuser_id AS typeuser_id_191, m8_.chantier_id AS chantier_id_192, m8_.statusmarchandise_id AS statusmarchandise_id_193, m8_.fournisseur_id AS fournisseur_id_194, m8_.article_id AS article_id_195, m8_.statemarchandise_id AS statemarchandise_id_196, m8_.segmentationmarchandise_id AS segmentationmarchandise_id_197, m8_.control_id AS control_id_198, c9_.chantier_id AS chantier_id_199, c9_.user_id AS user_id_200, u16_.typeuser_id AS typeuser_id_201, m18_.user_id AS user_id_202, u19_.typeuser_id AS typeuser_id_203, u21_.typeuser_id AS typeuser_id_204 FROM rvintervention r0_ LEFT JOIN chantier c1_ ON r0_.chantier_id = c1_.id LEFT JOIN lieu l2_ ON r0_.lieu_id = l2_.id LEFT JOIN rvinterventions_recommanded r23_ ON r0_.id = r23_.rvintervention_id LEFT JOIN user u3_ ON u3_.id = r23_.user_id LEFT JOIN typeuser t4_ ON u3_.typeuser_id = t4_.id LEFT JOIN rvintervention_equipement_rvintervention r24_ ON r0_.id = r24_.rvintervention_id LEFT JOIN rvintervention_equipement r5_ ON r5_.id = r24_.rvintervention_equipement_id LEFT JOIN user_rvintervention u25_ ON r0_.id = u25_.rvintervention_id LEFT JOIN user u6_ ON u6_.id = u25_.user_id LEFT JOIN typeuser t7_ ON u6_.typeuser_id = t7_.id LEFT JOIN marchandise_rvintervention m26_ ON r0_.id = m26_.rvintervention_id LEFT JOIN marchandise m8_ ON m8_.id = m26_.marchandise_id LEFT JOIN chantier_raf_rvintervention c27_ ON r0_.id = c27_.rvintervention_id LEFT JOIN chantier_raf c9_ ON c9_.id = c27_.chantier_raf_id LEFT JOIN typeintervention t10_ ON r0_.typeintervention_id = t10_.id LEFT JOIN control c11_ ON r0_.control_id = c11_.id LEFT JOIN access_ask a12_ ON r0_.access_ask_id = a12_.id LEFT JOIN criticity c13_ ON r0_.criticity_id = c13_.id LEFT JOIN meteo m14_ ON r0_.meteo_id = m14_.id LEFT JOIN parking p15_ ON r0_.parking_id = p15_.id LEFT JOIN rvintervention_user r28_ ON r0_.id = r28_.rvintervention_id LEFT JOIN user u16_ ON u16_.id = r28_.user_id LEFT JOIN typeuser t17_ ON u16_.typeuser_id = t17_.id LEFT JOIN material_rvintervention m29_ ON r0_.id = m29_.rvintervention_id LEFT JOIN material m18_ ON m18_.id = m29_.material_id LEFT JOIN user u19_ ON m18_.user_id = u19_.id LEFT JOIN typeuser t20_ ON u19_.typeuser_id = t20_.id LEFT JOIN user u21_ ON r0_.last_user_modified_id = u21_.id LEFT JOIN typeuser t22_ ON u21_.typeuser_id = t22_.id WHERE r0_.id = ?
Parameters: 
[
  15532
]
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.

Entities Mapping

Class Mapping errors
App\Entity\Rvintervention No errors.
App\Entity\Chantier No errors.
App\Entity\User No errors.
App\Entity\Typeuser No errors.
App\Entity\RvinterventionEquipement No errors.
App\Entity\Marchandise No errors.
App\Entity\Typeintervention No errors.
App\Entity\Material No errors.
App\Entity\Lieu No errors.
App\Entity\ChantierRaf 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\Client No errors.
App\Entity\Segmentationchantier No errors.
App\Entity\Modereglement No errors.
App\Entity\Statusmarchandise No errors.
App\Entity\Fournisseur No errors.
App\Entity\Article No errors.
App\Entity\MarchandiseState No errors.
App\Entity\RvinterventionLogs No errors.
App\Entity\Intervenant No errors.
App\Entity\ChantierrafLog No errors.
App\Entity\Logstatusmarchandise No errors.
App\Entity\ClientMessage No errors.
App\Entity\ClientRequest No errors.