Symfony Profiler

Query Metrics

14 Database Queries
14 Different statements
5.07 ms Query time
1 Invalid entities
Queries


SELECT t0.id AS id_1, t0.username AS username_2, t0.first_name AS first_name_3, t0.name AS name_4, t0.roles AS roles_5, t0.password AS password_6, t0.montee AS montee_7, t0.tel AS tel_8, t0.discord_id AS discord_id_9, t0.birth_date AS birth_date_10, t0.last_activity AS last_activity_11, t0.created_date AS created_date_12, t0.status AS status_13, t0.dispos AS dispos_14, t0.photo AS photo_15, t0.last_dispatch_at AS last_dispatch_at_16, t0.last_montee_at AS last_montee_at_17, t0.genre AS genre_18, t0.commentaire AS commentaire_19, t0.annuaire AS annuaire_20, t0.evaluation AS evaluation_21, t0.evaluation_commentaire AS evaluation_commentaire_22, t0.is_apte_for_evaluation AS is_apte_for_evaluation_23, t0.grade_id AS grade_id_24, t25.id AS id_26, t25.name AS name_27, t25.abrv AS abrv_28, t25.hierarchie AS hierarchie_29, t25.category AS category_30, t25.prime AS prime_31, t32.id AS id_33, t32.matricule AS matricule_34, t32.blocked AS blocked_35, t32.category AS category_36, t32.user_id AS user_id_37, t0.visite_medicale_id AS visite_medicale_id_38, t0.superviseur_id AS superviseur_id_39 FROM user t0 LEFT JOIN grade t25 ON t0.grade_id = t25.id LEFT JOIN matricule t32 ON t32.user_id = t0.id WHERE t0.id = ?
SELECT COUNT(*) FROM civil t0 WHERE t0.cayo = ?
SELECT count(u0_.id) AS sclr_0 FROM user u0_ WHERE u0_.roles LIKE ?
SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.expose AS expose_2, p0_.preuves AS preuves_3, p0_.cloture AS cloture_4, p0_.title AS title_5, p0_.updated_at AS updated_at_6, p0_.numero AS numero_7, p0_.status_int AS status_int_8, p0_.category AS category_9, p0_.access_categories AS access_categories_10, u1_.id AS id_11, u1_.username AS username_12, u1_.first_name AS first_name_13, u1_.name AS name_14, u1_.roles AS roles_15, u1_.password AS password_16, u1_.montee AS montee_17, u1_.tel AS tel_18, u1_.discord_id AS discord_id_19, u1_.birth_date AS birth_date_20, u1_.last_activity AS last_activity_21, u1_.created_date AS created_date_22, u1_.status AS status_23, u1_.dispos AS dispos_24, u1_.photo AS photo_25, u1_.last_dispatch_at AS last_dispatch_at_26, u1_.last_montee_at AS last_montee_at_27, u1_.genre AS genre_28, u1_.commentaire AS commentaire_29, u1_.annuaire AS annuaire_30, u1_.evaluation AS evaluation_31, u1_.evaluation_commentaire AS evaluation_commentaire_32, u1_.is_apte_for_evaluation AS is_apte_for_evaluation_33, g2_.id AS id_34, g2_.name AS name_35, g2_.abrv AS abrv_36, g2_.hierarchie AS hierarchie_37, g2_.category AS category_38, g2_.prime AS prime_39, m3_.id AS id_40, m3_.matricule AS matricule_41, m3_.blocked AS blocked_42, m3_.category AS category_43, u4_.id AS id_44, u4_.username AS username_45, u4_.first_name AS first_name_46, u4_.name AS name_47, u4_.roles AS roles_48, u4_.password AS password_49, u4_.montee AS montee_50, u4_.tel AS tel_51, u4_.discord_id AS discord_id_52, u4_.birth_date AS birth_date_53, u4_.last_activity AS last_activity_54, u4_.created_date AS created_date_55, u4_.status AS status_56, u4_.dispos AS dispos_57, u4_.photo AS photo_58, u4_.last_dispatch_at AS last_dispatch_at_59, u4_.last_montee_at AS last_montee_at_60, u4_.genre AS genre_61, u4_.commentaire AS commentaire_62, u4_.annuaire AS annuaire_63, u4_.evaluation AS evaluation_64, u4_.evaluation_commentaire AS evaluation_commentaire_65, u4_.is_apte_for_evaluation AS is_apte_for_evaluation_66, g5_.id AS id_67, g5_.name AS name_68, g5_.abrv AS abrv_69, g5_.hierarchie AS hierarchie_70, g5_.category AS category_71, g5_.prime AS prime_72, m6_.id AS id_73, m6_.matricule AS matricule_74, m6_.blocked AS blocked_75, m6_.category AS category_76, u7_.id AS id_77, u7_.username AS username_78, u7_.first_name AS first_name_79, u7_.name AS name_80, u7_.roles AS roles_81, u7_.password AS password_82, u7_.montee AS montee_83, u7_.tel AS tel_84, u7_.discord_id AS discord_id_85, u7_.birth_date AS birth_date_86, u7_.last_activity AS last_activity_87, u7_.created_date AS created_date_88, u7_.status AS status_89, u7_.dispos AS dispos_90, u7_.photo AS photo_91, u7_.last_dispatch_at AS last_dispatch_at_92, u7_.last_montee_at AS last_montee_at_93, u7_.genre AS genre_94, u7_.commentaire AS commentaire_95, u7_.annuaire AS annuaire_96, u7_.evaluation AS evaluation_97, u7_.evaluation_commentaire AS evaluation_commentaire_98, u7_.is_apte_for_evaluation AS is_apte_for_evaluation_99, g8_.id AS id_100, g8_.name AS name_101, g8_.abrv AS abrv_102, g8_.hierarchie AS hierarchie_103, g8_.category AS category_104, g8_.prime AS prime_105, m9_.id AS id_106, m9_.matricule AS matricule_107, m9_.blocked AS blocked_108, m9_.category AS category_109, u10_.id AS id_110, u10_.name AS name_111, u10_.abrv AS abrv_112, u10_.icon AS icon_113, u10_.category AS category_114, u11_.id AS id_115, u11_.username AS username_116, u11_.first_name AS first_name_117, u11_.name AS name_118, u11_.roles AS roles_119, u11_.password AS password_120, u11_.montee AS montee_121, u11_.tel AS tel_122, u11_.discord_id AS discord_id_123, u11_.birth_date AS birth_date_124, u11_.last_activity AS last_activity_125, u11_.created_date AS created_date_126, u11_.status AS status_127, u11_.dispos AS dispos_128, u11_.photo AS photo_129, u11_.last_dispatch_at AS last_dispatch_at_130, u11_.last_montee_at AS last_montee_at_131, u11_.genre AS genre_132, u11_.commentaire AS commentaire_133, u11_.annuaire AS annuaire_134, u11_.evaluation AS evaluation_135, u11_.evaluation_commentaire AS evaluation_commentaire_136, u11_.is_apte_for_evaluation AS is_apte_for_evaluation_137, g12_.id AS id_138, g12_.name AS name_139, g12_.abrv AS abrv_140, g12_.hierarchie AS hierarchie_141, g12_.category AS category_142, g12_.prime AS prime_143, m13_.id AS id_144, m13_.matricule AS matricule_145, m13_.blocked AS blocked_146, m13_.category AS category_147, u14_.id AS id_148, u14_.username AS username_149, u14_.first_name AS first_name_150, u14_.name AS name_151, u14_.roles AS roles_152, u14_.password AS password_153, u14_.montee AS montee_154, u14_.tel AS tel_155, u14_.discord_id AS discord_id_156, u14_.birth_date AS birth_date_157, u14_.last_activity AS last_activity_158, u14_.created_date AS created_date_159, u14_.status AS status_160, u14_.dispos AS dispos_161, u14_.photo AS photo_162, u14_.last_dispatch_at AS last_dispatch_at_163, u14_.last_montee_at AS last_montee_at_164, u14_.genre AS genre_165, u14_.commentaire AS commentaire_166, u14_.annuaire AS annuaire_167, u14_.evaluation AS evaluation_168, u14_.evaluation_commentaire AS evaluation_commentaire_169, u14_.is_apte_for_evaluation AS is_apte_for_evaluation_170, g15_.id AS id_171, g15_.name AS name_172, g15_.abrv AS abrv_173, g15_.hierarchie AS hierarchie_174, g15_.category AS category_175, g15_.prime AS prime_176, m16_.id AS id_177, m16_.matricule AS matricule_178, m16_.blocked AS blocked_179, m16_.category AS category_180, p0_.author_id AS author_id_181, p0_.gerant_id AS gerant_id_182, u1_.grade_id AS grade_id_183, u1_.visite_medicale_id AS visite_medicale_id_184, u1_.superviseur_id AS superviseur_id_185, m3_.user_id AS user_id_186, u4_.grade_id AS grade_id_187, u4_.visite_medicale_id AS visite_medicale_id_188, u4_.superviseur_id AS superviseur_id_189, m6_.user_id AS user_id_190, u7_.grade_id AS grade_id_191, u7_.visite_medicale_id AS visite_medicale_id_192, u7_.superviseur_id AS superviseur_id_193, m9_.user_id AS user_id_194, u11_.grade_id AS grade_id_195, u11_.visite_medicale_id AS visite_medicale_id_196, u11_.superviseur_id AS superviseur_id_197, m13_.user_id AS user_id_198, u14_.grade_id AS grade_id_199, u14_.visite_medicale_id AS visite_medicale_id_200, u14_.superviseur_id AS superviseur_id_201, m16_.user_id AS user_id_202 FROM plainte p0_ LEFT JOIN user u1_ ON p0_.author_id = u1_.id LEFT JOIN grade g2_ ON u1_.grade_id = g2_.id LEFT JOIN matricule m3_ ON u1_.id = m3_.user_id LEFT JOIN plainte_user p17_ ON p0_.id = p17_.plainte_id LEFT JOIN user u4_ ON u4_.id = p17_.user_id LEFT JOIN grade g5_ ON u4_.grade_id = g5_.id LEFT JOIN matricule m6_ ON u4_.id = m6_.user_id LEFT JOIN user u7_ ON p0_.gerant_id = u7_.id LEFT JOIN grade g8_ ON u7_.grade_id = g8_.id LEFT JOIN matricule m9_ ON u7_.id = m9_.user_id LEFT JOIN procedures_access_units p18_ ON p0_.id = p18_.plainte_id LEFT JOIN unit u10_ ON u10_.id = p18_.unit_id LEFT JOIN procedures_access_users p19_ ON p0_.id = p19_.plainte_id LEFT JOIN user u11_ ON u11_.id = p19_.user_id LEFT JOIN grade g12_ ON u11_.grade_id = g12_.id LEFT JOIN matricule m13_ ON u11_.id = m13_.user_id LEFT JOIN procedures_access_denied p20_ ON p0_.id = p20_.plainte_id LEFT JOIN user u14_ ON u14_.id = p20_.user_id LEFT JOIN grade g15_ ON u14_.grade_id = g15_.id LEFT JOIN matricule m16_ ON u14_.id = m16_.user_id WHERE p0_.status_int = ? OR p0_.status_int = ? OR p0_.status_int = ? ORDER BY p0_.created_at DESC
SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.expose AS expose_2, p0_.preuves AS preuves_3, p0_.cloture AS cloture_4, p0_.title AS title_5, p0_.updated_at AS updated_at_6, p0_.numero AS numero_7, p0_.status_int AS status_int_8, p0_.category AS category_9, p0_.access_categories AS access_categories_10, u1_.id AS id_11, u1_.username AS username_12, u1_.first_name AS first_name_13, u1_.name AS name_14, u1_.roles AS roles_15, u1_.password AS password_16, u1_.montee AS montee_17, u1_.tel AS tel_18, u1_.discord_id AS discord_id_19, u1_.birth_date AS birth_date_20, u1_.last_activity AS last_activity_21, u1_.created_date AS created_date_22, u1_.status AS status_23, u1_.dispos AS dispos_24, u1_.photo AS photo_25, u1_.last_dispatch_at AS last_dispatch_at_26, u1_.last_montee_at AS last_montee_at_27, u1_.genre AS genre_28, u1_.commentaire AS commentaire_29, u1_.annuaire AS annuaire_30, u1_.evaluation AS evaluation_31, u1_.evaluation_commentaire AS evaluation_commentaire_32, u1_.is_apte_for_evaluation AS is_apte_for_evaluation_33, g2_.id AS id_34, g2_.name AS name_35, g2_.abrv AS abrv_36, g2_.hierarchie AS hierarchie_37, g2_.category AS category_38, g2_.prime AS prime_39, m3_.id AS id_40, m3_.matricule AS matricule_41, m3_.blocked AS blocked_42, m3_.category AS category_43, u4_.id AS id_44, u4_.username AS username_45, u4_.first_name AS first_name_46, u4_.name AS name_47, u4_.roles AS roles_48, u4_.password AS password_49, u4_.montee AS montee_50, u4_.tel AS tel_51, u4_.discord_id AS discord_id_52, u4_.birth_date AS birth_date_53, u4_.last_activity AS last_activity_54, u4_.created_date AS created_date_55, u4_.status AS status_56, u4_.dispos AS dispos_57, u4_.photo AS photo_58, u4_.last_dispatch_at AS last_dispatch_at_59, u4_.last_montee_at AS last_montee_at_60, u4_.genre AS genre_61, u4_.commentaire AS commentaire_62, u4_.annuaire AS annuaire_63, u4_.evaluation AS evaluation_64, u4_.evaluation_commentaire AS evaluation_commentaire_65, u4_.is_apte_for_evaluation AS is_apte_for_evaluation_66, g5_.id AS id_67, g5_.name AS name_68, g5_.abrv AS abrv_69, g5_.hierarchie AS hierarchie_70, g5_.category AS category_71, g5_.prime AS prime_72, m6_.id AS id_73, m6_.matricule AS matricule_74, m6_.blocked AS blocked_75, m6_.category AS category_76, u7_.id AS id_77, u7_.username AS username_78, u7_.first_name AS first_name_79, u7_.name AS name_80, u7_.roles AS roles_81, u7_.password AS password_82, u7_.montee AS montee_83, u7_.tel AS tel_84, u7_.discord_id AS discord_id_85, u7_.birth_date AS birth_date_86, u7_.last_activity AS last_activity_87, u7_.created_date AS created_date_88, u7_.status AS status_89, u7_.dispos AS dispos_90, u7_.photo AS photo_91, u7_.last_dispatch_at AS last_dispatch_at_92, u7_.last_montee_at AS last_montee_at_93, u7_.genre AS genre_94, u7_.commentaire AS commentaire_95, u7_.annuaire AS annuaire_96, u7_.evaluation AS evaluation_97, u7_.evaluation_commentaire AS evaluation_commentaire_98, u7_.is_apte_for_evaluation AS is_apte_for_evaluation_99, g8_.id AS id_100, g8_.name AS name_101, g8_.abrv AS abrv_102, g8_.hierarchie AS hierarchie_103, g8_.category AS category_104, g8_.prime AS prime_105, m9_.id AS id_106, m9_.matricule AS matricule_107, m9_.blocked AS blocked_108, m9_.category AS category_109, u10_.id AS id_110, u10_.name AS name_111, u10_.abrv AS abrv_112, u10_.icon AS icon_113, u10_.category AS category_114, u11_.id AS id_115, u11_.username AS username_116, u11_.first_name AS first_name_117, u11_.name AS name_118, u11_.roles AS roles_119, u11_.password AS password_120, u11_.montee AS montee_121, u11_.tel AS tel_122, u11_.discord_id AS discord_id_123, u11_.birth_date AS birth_date_124, u11_.last_activity AS last_activity_125, u11_.created_date AS created_date_126, u11_.status AS status_127, u11_.dispos AS dispos_128, u11_.photo AS photo_129, u11_.last_dispatch_at AS last_dispatch_at_130, u11_.last_montee_at AS last_montee_at_131, u11_.genre AS genre_132, u11_.commentaire AS commentaire_133, u11_.annuaire AS annuaire_134, u11_.evaluation AS evaluation_135, u11_.evaluation_commentaire AS evaluation_commentaire_136, u11_.is_apte_for_evaluation AS is_apte_for_evaluation_137, g12_.id AS id_138, g12_.name AS name_139, g12_.abrv AS abrv_140, g12_.hierarchie AS hierarchie_141, g12_.category AS category_142, g12_.prime AS prime_143, m13_.id AS id_144, m13_.matricule AS matricule_145, m13_.blocked AS blocked_146, m13_.category AS category_147, u14_.id AS id_148, u14_.username AS username_149, u14_.first_name AS first_name_150, u14_.name AS name_151, u14_.roles AS roles_152, u14_.password AS password_153, u14_.montee AS montee_154, u14_.tel AS tel_155, u14_.discord_id AS discord_id_156, u14_.birth_date AS birth_date_157, u14_.last_activity AS last_activity_158, u14_.created_date AS created_date_159, u14_.status AS status_160, u14_.dispos AS dispos_161, u14_.photo AS photo_162, u14_.last_dispatch_at AS last_dispatch_at_163, u14_.last_montee_at AS last_montee_at_164, u14_.genre AS genre_165, u14_.commentaire AS commentaire_166, u14_.annuaire AS annuaire_167, u14_.evaluation AS evaluation_168, u14_.evaluation_commentaire AS evaluation_commentaire_169, u14_.is_apte_for_evaluation AS is_apte_for_evaluation_170, g15_.id AS id_171, g15_.name AS name_172, g15_.abrv AS abrv_173, g15_.hierarchie AS hierarchie_174, g15_.category AS category_175, g15_.prime AS prime_176, m16_.id AS id_177, m16_.matricule AS matricule_178, m16_.blocked AS blocked_179, m16_.category AS category_180, p0_.author_id AS author_id_181, p0_.gerant_id AS gerant_id_182, u1_.grade_id AS grade_id_183, u1_.visite_medicale_id AS visite_medicale_id_184, u1_.superviseur_id AS superviseur_id_185, m3_.user_id AS user_id_186, u4_.grade_id AS grade_id_187, u4_.visite_medicale_id AS visite_medicale_id_188, u4_.superviseur_id AS superviseur_id_189, m6_.user_id AS user_id_190, u7_.grade_id AS grade_id_191, u7_.visite_medicale_id AS visite_medicale_id_192, u7_.superviseur_id AS superviseur_id_193, m9_.user_id AS user_id_194, u11_.grade_id AS grade_id_195, u11_.visite_medicale_id AS visite_medicale_id_196, u11_.superviseur_id AS superviseur_id_197, m13_.user_id AS user_id_198, u14_.grade_id AS grade_id_199, u14_.visite_medicale_id AS visite_medicale_id_200, u14_.superviseur_id AS superviseur_id_201, m16_.user_id AS user_id_202 FROM plainte p0_ LEFT JOIN user u1_ ON p0_.author_id = u1_.id LEFT JOIN grade g2_ ON u1_.grade_id = g2_.id LEFT JOIN matricule m3_ ON u1_.id = m3_.user_id LEFT JOIN plainte_user p17_ ON p0_.id = p17_.plainte_id LEFT JOIN user u4_ ON u4_.id = p17_.user_id LEFT JOIN grade g5_ ON u4_.grade_id = g5_.id LEFT JOIN matricule m6_ ON u4_.id = m6_.user_id LEFT JOIN user u7_ ON p0_.gerant_id = u7_.id LEFT JOIN grade g8_ ON u7_.grade_id = g8_.id LEFT JOIN matricule m9_ ON u7_.id = m9_.user_id LEFT JOIN procedures_access_units p18_ ON p0_.id = p18_.plainte_id LEFT JOIN unit u10_ ON u10_.id = p18_.unit_id LEFT JOIN procedures_access_users p19_ ON p0_.id = p19_.plainte_id LEFT JOIN user u11_ ON u11_.id = p19_.user_id LEFT JOIN grade g12_ ON u11_.grade_id = g12_.id LEFT JOIN matricule m13_ ON u11_.id = m13_.user_id LEFT JOIN procedures_access_denied p20_ ON p0_.id = p20_.plainte_id LEFT JOIN user u14_ ON u14_.id = p20_.user_id LEFT JOIN grade g15_ ON u14_.grade_id = g15_.id LEFT JOIN matricule m16_ ON u14_.id = m16_.user_id WHERE (p0_.status_int = ? OR p0_.status_int = ? OR p0_.status_int = ?) AND p0_.author_id = ? ORDER BY p0_.created_at DESC
SELECT f0_.id AS id_0, f0_.created_at AS created_at_1, f0_.giveback_at AS giveback_at_2, f0_.description AS description_3, f0_.plaque AS plaque_4, f0_.amende AS amende_5, f0_.note AS note_6, f0_.gived_back AS gived_back_7, f0_.archived AS archived_8, f0_.can_gived_back_at AS can_gived_back_at_9, u1_.id AS id_10, u1_.username AS username_11, u1_.first_name AS first_name_12, u1_.name AS name_13, u1_.roles AS roles_14, u1_.password AS password_15, u1_.montee AS montee_16, u1_.tel AS tel_17, u1_.discord_id AS discord_id_18, u1_.birth_date AS birth_date_19, u1_.last_activity AS last_activity_20, u1_.created_date AS created_date_21, u1_.status AS status_22, u1_.dispos AS dispos_23, u1_.photo AS photo_24, u1_.last_dispatch_at AS last_dispatch_at_25, u1_.last_montee_at AS last_montee_at_26, u1_.genre AS genre_27, u1_.commentaire AS commentaire_28, u1_.annuaire AS annuaire_29, u1_.evaluation AS evaluation_30, u1_.evaluation_commentaire AS evaluation_commentaire_31, u1_.is_apte_for_evaluation AS is_apte_for_evaluation_32, i2_.id AS id_33, i2_.category AS category_34, i2_.name AS name_35, i2_.amende_min AS amende_min_36, i2_.amende_max AS amende_max_37, i2_.tig AS tig_38, i2_.article AS article_39, i2_.quantifiable AS quantifiable_40, i2_.quantifiable_count AS quantifiable_count_41, i2_.commentaires AS commentaires_42, i2_.casier AS casier_43, i2_.impayee AS impayee_44, i2_.impayee_max AS impayee_max_45, i2_.debit_immediat AS debit_immediat_46, i2_.can_complicite AS can_complicite_47, i2_.can_saisie AS can_saisie_48, i2_.version AS version_49, g3_.id AS id_50, g3_.name AS name_51, g3_.abrv AS abrv_52, g3_.hierarchie AS hierarchie_53, g3_.category AS category_54, g3_.prime AS prime_55, m4_.id AS id_56, m4_.matricule AS matricule_57, m4_.blocked AS blocked_58, m4_.category AS category_59, c5_.id AS id_60, c5_.first_name AS first_name_61, c5_.name AS name_62, c5_.birth_date AS birth_date_63, c5_.size AS size_64, c5_.genre AS genre_65, c5_.tel AS tel_66, c5_.observation_fdo AS observation_fdo_67, c5_.observation_ems AS observation_ems_68, c5_.created_at AS created_at_69, c5_.dangerous AS dangerous_70, c5_.photo AS photo_71, c5_.id_old AS id_old_72, c5_.groupe_sanguin AS groupe_sanguin_73, c5_.cayo AS cayo_74, c5_.taser AS taser_75, c5_.taser_ent AS taser_ent_76, f0_.author_id AS author_id_77, f0_.civil_id AS civil_id_78, u1_.grade_id AS grade_id_79, u1_.visite_medicale_id AS visite_medicale_id_80, u1_.superviseur_id AS superviseur_id_81, m4_.user_id AS user_id_82, c5_.groupe_id AS groupe_id_83 FROM fourriere f0_ LEFT JOIN user u1_ ON f0_.author_id = u1_.id LEFT JOIN fourriere_infraction f6_ ON f0_.id = f6_.fourriere_id LEFT JOIN infraction i2_ ON i2_.id = f6_.infraction_id LEFT JOIN grade g3_ ON u1_.grade_id = g3_.id LEFT JOIN matricule m4_ ON u1_.id = m4_.user_id LEFT JOIN civil c5_ ON f0_.civil_id = c5_.id WHERE f0_.archived = 0 AND f0_.gived_back = 0
SELECT v0_.id AS id_0, v0_.plaque AS plaque_1, v0_.commentaire AS commentaire_2, v0_.photo AS photo_3, v0_.status AS status_4, v0_.created_at AS created_at_5, v0_.updated_at AS updated_at_6, i1_.id AS id_7, i1_.category AS category_8, i1_.name AS name_9, i1_.amende_min AS amende_min_10, i1_.amende_max AS amende_max_11, i1_.tig AS tig_12, i1_.article AS article_13, i1_.quantifiable AS quantifiable_14, i1_.quantifiable_count AS quantifiable_count_15, i1_.commentaires AS commentaires_16, i1_.casier AS casier_17, i1_.impayee AS impayee_18, i1_.impayee_max AS impayee_max_19, i1_.debit_immediat AS debit_immediat_20, i1_.can_complicite AS can_complicite_21, i1_.can_saisie AS can_saisie_22, i1_.version AS version_23, c2_.id AS id_24, c2_.first_name AS first_name_25, c2_.name AS name_26, c2_.birth_date AS birth_date_27, c2_.size AS size_28, c2_.genre AS genre_29, c2_.tel AS tel_30, c2_.observation_fdo AS observation_fdo_31, c2_.observation_ems AS observation_ems_32, c2_.created_at AS created_at_33, c2_.dangerous AS dangerous_34, c2_.photo AS photo_35, c2_.id_old AS id_old_36, c2_.groupe_sanguin AS groupe_sanguin_37, c2_.cayo AS cayo_38, c2_.taser AS taser_39, c2_.taser_ent AS taser_ent_40, u3_.id AS id_41, u3_.username AS username_42, u3_.first_name AS first_name_43, u3_.name AS name_44, u3_.roles AS roles_45, u3_.password AS password_46, u3_.montee AS montee_47, u3_.tel AS tel_48, u3_.discord_id AS discord_id_49, u3_.birth_date AS birth_date_50, u3_.last_activity AS last_activity_51, u3_.created_date AS created_date_52, u3_.status AS status_53, u3_.dispos AS dispos_54, u3_.photo AS photo_55, u3_.last_dispatch_at AS last_dispatch_at_56, u3_.last_montee_at AS last_montee_at_57, u3_.genre AS genre_58, u3_.commentaire AS commentaire_59, u3_.annuaire AS annuaire_60, u3_.evaluation AS evaluation_61, u3_.evaluation_commentaire AS evaluation_commentaire_62, u3_.is_apte_for_evaluation AS is_apte_for_evaluation_63, g4_.id AS id_64, g4_.name AS name_65, g4_.abrv AS abrv_66, g4_.hierarchie AS hierarchie_67, g4_.category AS category_68, g4_.prime AS prime_69, m5_.id AS id_70, m5_.matricule AS matricule_71, m5_.blocked AS blocked_72, m5_.category AS category_73, v0_.civil_id AS civil_id_74, v0_.author_id AS author_id_75, c2_.groupe_id AS groupe_id_76, u3_.grade_id AS grade_id_77, u3_.visite_medicale_id AS visite_medicale_id_78, u3_.superviseur_id AS superviseur_id_79, m5_.user_id AS user_id_80 FROM vehicule_recherche v0_ LEFT JOIN vehicule_recherche_infraction v6_ ON v0_.id = v6_.vehicule_recherche_id LEFT JOIN infraction i1_ ON i1_.id = v6_.infraction_id LEFT JOIN civil c2_ ON v0_.civil_id = c2_.id LEFT JOIN user u3_ ON v0_.author_id = u3_.id LEFT JOIN grade g4_ ON u3_.grade_id = g4_.id LEFT JOIN matricule m5_ ON u3_.id = m5_.user_id WHERE v0_.status = ?
SELECT f0_.id AS id_0, f0_.commentaires AS commentaires_1, f0_.created_at AS created_at_2, f0_.archived AS archived_3, f0_.complicites AS complicites_4, f0_.lien_mandat AS lien_mandat_5, f0_.quantites AS quantites_6, f0_.circonstances AS circonstances_7, c1_.id AS id_8, c1_.first_name AS first_name_9, c1_.name AS name_10, c1_.birth_date AS birth_date_11, c1_.size AS size_12, c1_.genre AS genre_13, c1_.tel AS tel_14, c1_.observation_fdo AS observation_fdo_15, c1_.observation_ems AS observation_ems_16, c1_.created_at AS created_at_17, c1_.dangerous AS dangerous_18, c1_.photo AS photo_19, c1_.id_old AS id_old_20, c1_.groupe_sanguin AS groupe_sanguin_21, c1_.cayo AS cayo_22, c1_.taser AS taser_23, c1_.taser_ent AS taser_ent_24, i2_.id AS id_25, i2_.category AS category_26, i2_.name AS name_27, i2_.amende_min AS amende_min_28, i2_.amende_max AS amende_max_29, i2_.tig AS tig_30, i2_.article AS article_31, i2_.quantifiable AS quantifiable_32, i2_.quantifiable_count AS quantifiable_count_33, i2_.commentaires AS commentaires_34, i2_.casier AS casier_35, i2_.impayee AS impayee_36, i2_.impayee_max AS impayee_max_37, i2_.debit_immediat AS debit_immediat_38, i2_.can_complicite AS can_complicite_39, i2_.can_saisie AS can_saisie_40, i2_.version AS version_41, f0_.civil_id AS civil_id_42, f0_.author_id AS author_id_43, c1_.groupe_id AS groupe_id_44 FROM fpr f0_ LEFT JOIN civil c1_ ON f0_.civil_id = c1_.id LEFT JOIN fpr_infraction f3_ ON f0_.id = f3_.fpr_id LEFT JOIN infraction i2_ ON i2_.id = f3_.infraction_id WHERE c1_.cayo = 0
SELECT count(g0_.id) AS sclr_0 FROM groupe g0_ WHERE g0_.actif = ?
SELECT SUM(p0_.amende_min) AS sclr_0, MIN(p0_.must_pay_at) AS sclr_1, c1_.id AS id_2, c1_.first_name AS first_name_3, c1_.name AS name_4, c1_.birth_date AS birth_date_5, c1_.size AS size_6, c1_.genre AS genre_7, c1_.tel AS tel_8, c1_.observation_fdo AS observation_fdo_9, c1_.observation_ems AS observation_ems_10, c1_.created_at AS created_at_11, c1_.dangerous AS dangerous_12, c1_.photo AS photo_13, c1_.id_old AS id_old_14, c1_.groupe_sanguin AS groupe_sanguin_15, c1_.cayo AS cayo_16, c1_.taser AS taser_17, c1_.taser_ent AS taser_ent_18, p0_.id AS id_19, p0_.created_at AS created_at_20, p0_.status_int AS status_int_21, p0_.updated_at AS updated_at_22, p0_.maximal AS maximal_23, p0_.tig AS tig_24, p0_.quantites AS quantites_25, p0_.complicites AS complicites_26, p0_.circonstances AS circonstances_27, p0_.amende_min AS amende_min_28, p0_.amende_max AS amende_max_29, p0_.archived AS archived_30, p0_.complicite AS complicite_31, p0_.custom AS custom_32, p0_.commentaires AS commentaires_33, p0_.must_pay_at AS must_pay_at_34, p0_.facture AS facture_35, p0_.immediat AS immediat_36, c1_.groupe_id AS groupe_id_37, p0_.civil_id AS civil_id_38, p0_.author_id AS author_id_39 FROM civil c1_ LEFT JOIN peine p0_ ON c1_.id = p0_.civil_id WHERE p0_.status_int = ? AND CURRENT_TIMESTAMP > p0_.must_pay_at GROUP BY c1_.id
SELECT MIN(f0_.created_at) AS sclr_0, c1_.id AS id_1, c1_.first_name AS first_name_2, c1_.name AS name_3, c1_.birth_date AS birth_date_4, c1_.size AS size_5, c1_.genre AS genre_6, c1_.tel AS tel_7, c1_.observation_fdo AS observation_fdo_8, c1_.observation_ems AS observation_ems_9, c1_.created_at AS created_at_10, c1_.dangerous AS dangerous_11, c1_.photo AS photo_12, c1_.id_old AS id_old_13, c1_.groupe_sanguin AS groupe_sanguin_14, c1_.cayo AS cayo_15, c1_.taser AS taser_16, c1_.taser_ent AS taser_ent_17, f0_.id AS id_18, f0_.commentaires AS commentaires_19, f0_.created_at AS created_at_20, f0_.archived AS archived_21, f0_.complicites AS complicites_22, f0_.lien_mandat AS lien_mandat_23, f0_.quantites AS quantites_24, f0_.circonstances AS circonstances_25, c1_.groupe_id AS groupe_id_26, f0_.civil_id AS civil_id_27, f0_.author_id AS author_id_28 FROM civil c1_ INNER JOIN fpr f0_ ON c1_.id = f0_.civil_id WHERE c1_.cayo = 0 GROUP BY c1_.id
SELECT t0.id AS id_1, t0.comment AS comment_2, t0.created_at AS created_at_3, t0.status_int AS status_int_4, t0.user_id AS user_id_5, t0.examinateur_id AS examinateur_id_6, t0.class_id AS class_id_7, t8.id AS id_9, t8.name AS name_10, t8.category AS category_11, t8.comment AS comment_12, t8.motivation AS motivation_13, t8.type_int AS type_int_14, t8.template AS template_15, t8.conditions AS conditions_16, t8.presentation AS presentation_17, t8.icon AS icon_18, t8.close AS close_19, t8.grade_min_id AS grade_min_id_20 FROM formation t0 INNER JOIN formation_class t8 ON t0.class_id = t8.id WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.start_at AS start_at_2, t0.end_at AS end_at_3, t0.time AS time_4, t0.user_id AS user_id_5 FROM service t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.discord_id AS discord_id_3, t0.start_at AS start_at_4, t0.end_at AS end_at_5, t0.time AS time_6, t0.channel_id AS channel_id_7, t0.statut AS statut_8, t0.color AS color_9, t0.user_id AS user_id_10 FROM dispatch t0 WHERE t0.user_id = ?
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\User	The field App\Entity\User#primes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Prime#user does not contain the required 'inversedBy="primes"' attribute. The field App\Entity\User#convocations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Convocation#agent does not contain the required 'inversedBy="convocations"' attribute.
App\Entity\Grade	No errors.
App\Entity\Matricule	No errors.
App\Entity\MedicalEntry	No errors.
App\Entity\Unit	No errors.
App\Entity\Plainte	No errors.
App\Entity\Formation	No errors.
App\Entity\Absence	No errors.
App\Entity\Prime	No errors.
App\Entity\Dispatch	No errors.
App\Entity\Service	No errors.
App\Entity\Sanction	No errors.
App\Entity\Moderation	No errors.
App\Entity\InventoryDotation	No errors.
App\Entity\Convocation	No errors.
App\Entity\EvaluationCommentaire	No errors.
App\Entity\Questionnaire	No errors.
App\Entity\Page	No errors.
App\Entity\Civil	No errors.
App\Entity\FichePlainte	No errors.
App\Entity\Fourriere	No errors.
App\Entity\Infraction	No errors.
App\Entity\Groupe	No errors.
App\Entity\VehiculeRecherche	No errors.
App\Entity\Fpr	No errors.
App\Entity\Peine	No errors.
App\Entity\FormationClass	No errors.
App\Entity\EventSlot	No errors.
Symfony Profiler

GET https://intranet-dev.stsi.tech/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping
