GET http://zabal.disc-chantier.com/api/rvinterventions?chantier.id=6760

Response
302 Found
IP
172.30.0.1
Profiled on
Token
eb267f

Query Metrics

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

Queries

Group similar statements

#▲ Time Info
1 108.11 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, c2_.fullname AS fullname_43, c2_.telfixe AS telfixe_44, c2_.telmobile AS telmobile_45, c2_.email AS email_46, c2_.deleted AS deleted_47, c2_.id AS id_48, c2_.created_at AS created_at_49, c2_.updated_at AS updated_at_50, c3_.id AS id_51, c3_.number AS number_52, c3_.link AS link_53, c3_.sms AS sms_54, c3_.email AS email_55, c4_.id AS id_56, c4_.status AS status_57, c4_.content AS content_58, c4_.tempsalloue AS tempsalloue_59, u5_.id AS id_60, u5_.email AS email_61, u5_.roles AS roles_62, u5_.password AS password_63, u5_.username AS username_64, u5_.color AS color_65, u5_.tel AS tel_66, u5_.status AS status_67, u5_.ref_tech AS ref_tech_68, u5_.updated_at AS updated_at_69, u5_.created_at AS created_at_70, u6_.id AS id_71, u6_.email AS email_72, u6_.roles AS roles_73, u6_.password AS password_74, u6_.username AS username_75, u6_.color AS color_76, u6_.tel AS tel_77, u6_.status AS status_78, u6_.ref_tech AS ref_tech_79, u6_.updated_at AS updated_at_80, u6_.created_at AS created_at_81, m7_.quantitenature AS quantitenature_82, m7_.date_arc AS date_arc_83, m7_.commentaire AS commentaire_84, m7_.collisage AS collisage_85, m7_.tempsalloue AS tempsalloue_86, m7_.delaifournisseur AS delaifournisseur_87, m7_.quantitearticle AS quantitearticle_88, m7_.demandestatus AS demandestatus_89, m7_.early AS early_90, m7_.num_arc AS num_arc_91, m7_.id AS id_92, m7_.created_at AS created_at_93, m7_.updated_at AS updated_at_94, s8_.nom AS nom_95, s8_.color AS color_96, s8_.css_class AS css_class_97, s8_.place AS place_98, s8_.typemarchandise AS typemarchandise_99, s8_.id AS id_100, s8_.created_at AS created_at_101, s8_.updated_at AS updated_at_102, f9_.nom AS nom_103, f9_.delaifournisseur AS delaifournisseur_104, f9_.id AS id_105, f9_.created_at AS created_at_106, f9_.updated_at AS updated_at_107, a10_.label AS label_108, a10_.stock AS stock_109, a10_.id AS id_110, a10_.created_at AS created_at_111, a10_.updated_at AS updated_at_112, m11_.name AS name_113, m11_.id AS id_114, m11_.created_at AS created_at_115, m11_.updated_at AS updated_at_116, s12_.nom AS nom_117, s12_.description AS description_118, s12_.id AS id_119, s12_.created_at AS created_at_120, s12_.updated_at AS updated_at_121, c13_.id AS id_122, c13_.label AS label_123, t14_.nom AS nom_124, t14_.id AS id_125, t14_.created_at AS created_at_126, t14_.updated_at AS updated_at_127, c15_.id AS id_128, c15_.label AS label_129, a16_.id AS id_130, a16_.label AS label_131, a16_.created_at AS created_at_132, a16_.updated_at AS updated_at_133, c17_.id AS id_134, c17_.created_at AS created_at_135, c17_.updated_at AS updated_at_136, c17_.label AS label_137, m18_.id AS id_138, m18_.label AS label_139, m18_.created_at AS created_at_140, m18_.updated_at AS updated_at_141, p19_.id AS id_142, p19_.label AS label_143, p19_.created_at AS created_at_144, p19_.updated_at AS updated_at_145, u20_.id AS id_146, u20_.email AS email_147, u20_.roles AS roles_148, u20_.password AS password_149, u20_.username AS username_150, u20_.color AS color_151, u20_.tel AS tel_152, u20_.status AS status_153, u20_.ref_tech AS ref_tech_154, u20_.updated_at AS updated_at_155, u20_.created_at AS created_at_156, m21_.name AS name_157, m21_.comment AS comment_158, m21_.position AS position_159, m21_.image_name AS image_name_160, m21_.image_size AS image_size_161, m21_.deleted AS deleted_162, m21_.usable_urgence AS usable_urgence_163, m21_.id AS id_164, m21_.created_at AS created_at_165, m21_.updated_at AS updated_at_166, u22_.id AS id_167, u22_.email AS email_168, u22_.roles AS roles_169, u22_.password AS password_170, u22_.username AS username_171, u22_.color AS color_172, u22_.tel AS tel_173, u22_.status AS status_174, u22_.ref_tech AS ref_tech_175, u22_.updated_at AS updated_at_176, u22_.created_at AS created_at_177, u23_.id AS id_178, u23_.email AS email_179, u23_.roles AS roles_180, u23_.password AS password_181, u23_.username AS username_182, u23_.color AS color_183, u23_.tel AS tel_184, u23_.status AS status_185, u23_.ref_tech AS ref_tech_186, u23_.updated_at AS updated_at_187, u23_.created_at AS created_at_188, r0_.chantier_id AS chantier_id_189, r0_.lieu_id AS lieu_id_190, r0_.typeintervention_id AS typeintervention_id_191, r0_.control_id AS control_id_192, r0_.access_ask_id AS access_ask_id_193, r0_.criticity_id AS criticity_id_194, r0_.meteo_id AS meteo_id_195, r0_.parking_id AS parking_id_196, r0_.last_user_modified_id AS last_user_modified_id_197, c1_.client_id AS client_id_198, c1_.segmentationchantier_id AS segmentationchantier_id_199, c1_.modereglement_id AS modereglement_id_200, c1_.user_id AS user_id_201, c1_.tech_id AS tech_id_202, c3_.client_id AS client_id_203, c4_.chantier_id AS chantier_id_204, c4_.user_id AS user_id_205, u5_.typeuser_id AS typeuser_id_206, u6_.typeuser_id AS typeuser_id_207, m7_.chantier_id AS chantier_id_208, m7_.statusmarchandise_id AS statusmarchandise_id_209, m7_.fournisseur_id AS fournisseur_id_210, m7_.article_id AS article_id_211, m7_.statemarchandise_id AS statemarchandise_id_212, m7_.segmentationmarchandise_id AS segmentationmarchandise_id_213, m7_.control_id AS control_id_214, a10_.category_id AS category_id_215, u20_.typeuser_id AS typeuser_id_216, m21_.user_id AS user_id_217, u22_.typeuser_id AS typeuser_id_218, u23_.typeuser_id AS typeuser_id_219 FROM rvintervention r0_ INNER JOIN chantier c1_ ON r0_.chantier_id = c1_.id LEFT JOIN client c2_ ON c1_.client_id = c2_.id LEFT JOIN client_contact c3_ ON c2_.id = c3_.client_id LEFT JOIN chantier_raf c4_ ON c1_.id = c4_.chantier_id LEFT JOIN rvinterventions_recommanded r24_ ON r0_.id = r24_.rvintervention_id LEFT JOIN user u5_ ON u5_.id = r24_.user_id LEFT JOIN user_rvintervention u25_ ON r0_.id = u25_.rvintervention_id LEFT JOIN user u6_ ON u6_.id = u25_.user_id LEFT JOIN marchandise_rvintervention m26_ ON r0_.id = m26_.rvintervention_id LEFT JOIN marchandise m7_ ON m7_.id = m26_.marchandise_id LEFT JOIN statusmarchandise s8_ ON m7_.statusmarchandise_id = s8_.id LEFT JOIN fournisseur f9_ ON m7_.fournisseur_id = f9_.id LEFT JOIN article a10_ ON m7_.article_id = a10_.id LEFT JOIN marchandise_state m11_ ON m7_.statemarchandise_id = m11_.id LEFT JOIN segmentationchantier s12_ ON m7_.segmentationmarchandise_id = s12_.id LEFT JOIN control c13_ ON m7_.control_id = c13_.id LEFT JOIN typeintervention t14_ ON r0_.typeintervention_id = t14_.id LEFT JOIN control c15_ ON r0_.control_id = c15_.id LEFT JOIN access_ask a16_ ON r0_.access_ask_id = a16_.id LEFT JOIN criticity c17_ ON r0_.criticity_id = c17_.id LEFT JOIN meteo m18_ ON r0_.meteo_id = m18_.id LEFT JOIN parking p19_ ON r0_.parking_id = p19_.id LEFT JOIN rvintervention_user r27_ ON r0_.id = r27_.rvintervention_id LEFT JOIN user u20_ ON u20_.id = r27_.user_id LEFT JOIN material_rvintervention m28_ ON r0_.id = m28_.rvintervention_id LEFT JOIN material m21_ ON m21_.id = m28_.material_id LEFT JOIN user u22_ ON m21_.user_id = u22_.id LEFT JOIN user u23_ ON r0_.last_user_modified_id = u23_.id WHERE r0_.id IN (SELECT r29_.id FROM rvintervention r29_ INNER JOIN chantier c30_ ON r29_.chantier_id = c30_.id WHERE c30_.id = ?) ORDER BY r0_.daterv ASC
Parameters: 
[
  "6760"
]
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\Client No errors.
App\Entity\ChantierRaf No errors.
App\Entity\User No errors.
App\Entity\Marchandise No errors.
App\Entity\Statusmarchandise No errors.
App\Entity\Article No errors.
App\Entity\MarchandiseState No errors.
App\Entity\Segmentationchantier No errors.
App\Entity\Control No errors.
App\Entity\Typeintervention No errors.
App\Entity\Material No errors.
App\Entity\ClientContact No errors.
App\Entity\Fournisseur No errors.
App\Entity\AccessAsk No errors.
App\Entity\Criticity No errors.
App\Entity\Meteo No errors.
App\Entity\Parking No errors.
App\Entity\Lieu No errors.
App\Entity\Modereglement No errors.
App\Entity\Typeuser No errors.
App\Entity\ArticleCategory No errors.
App\Entity\RvinterventionLogs No errors.
App\Entity\RvinterventionEquipement No errors.
App\Entity\Intervenant No errors.
App\Entity\ChantierrafLog No errors.
App\Entity\ClientMessage No errors.
App\Entity\Logstatusmarchandise No errors.
App\Entity\ClientRequest No errors.