GET https://preprod-papie.upv.org/admin

Response
200 OK
IP
81.2.151.162
Profiled on
Token
d0977f

Query Metrics

6 Database Queries
6 Different statements
17.58 ms Query time
0 Invalid entities
29 Managed entities

Queries

Group similar statements

#▲ Time Info
1 5.95 ms 
SELECT t0.username AS username_1, t0.password AS password_2, t0.email AS email_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.id AS id_6, t0.active AS active_7, t0.role_id AS role_id_8, t0.zone_id AS zone_id_9 FROM user t0 WHERE t0.id = ?
Parameters: 
[
  51
]
View formatted query    View runnable query    Explain query
2 1.42 ms 
SELECT t0.id AS id_1, t0.identifier AS identifier_2, t0.value AS value_3 FROM role t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
3 3.01 ms 
SELECT COUNT(i0_.id) AS sclr_0 FROM intervention i0_ WHERE i0_.user_id = ?
Parameters: 
[
  51
]
View formatted query    View runnable query    Explain query
4 5.27 ms 
SELECT SUM(HOUR(time) * 3600 + MINUTE(time) * 60 + SECOND(time))
             FROM intervention
             WHERE user_id = ?
Parameters: 
[
  51
]
View formatted query    View runnable query    Explain query
5 0.27 ms 
SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM consultation c0_ LEFT JOIN person p1_ ON c0_.person_id = p1_.id LEFT JOIN gender g2_ ON p1_.gender_id = g2_.id LEFT JOIN marital m3_ ON p1_.marital_id = m3_.id LEFT JOIN person_corporation p4_ ON p1_.person_corporation_id = p4_.id LEFT JOIN contract c5_ ON p4_.contract_id = c5_.id LEFT JOIN occupation o6_ ON p4_.occupation_id = o6_.id LEFT JOIN corporation c7_ ON p4_.corporation_id = c7_.id LEFT JOIN person_flat p8_ ON c0_.person_flat_id = p8_.id LEFT JOIN gender g9_ ON p8_.gender_id = g9_.id LEFT JOIN marital m10_ ON p8_.marital_id = m10_.id LEFT JOIN contract c11_ ON p8_.contract_id = c11_.id LEFT JOIN occupation o12_ ON p8_.occupation_id = o12_.id LEFT JOIN person p13_ ON p8_.person_id = p13_.id LEFT JOIN corporation c14_ ON p8_.corporation_id = c14_.id LEFT JOIN plan p15_ ON c0_.plan_id = p15_.id LEFT JOIN reason_entry r16_ ON c0_.reason_entry_id = r16_.id LEFT JOIN reason r17_ ON r16_.reason_id = r17_.id LEFT JOIN origin o18_ ON c0_.origin_id = o18_.id LEFT JOIN intervention i19_ ON c0_.id = i19_.consultation_id LEFT JOIN intervention_modality i20_ ON i19_.intervention_modality_id = i20_.id LEFT JOIN user u21_ ON i19_.user_id = u21_.id LEFT JOIN role r22_ ON u21_.role_id = r22_.id LEFT JOIN status s23_ ON c0_.status_id = s23_.id LEFT JOIN complete c24_ ON c0_.complete_id = c24_.id LEFT JOIN consultation_user c25_ ON c0_.id = c25_.consultation_id LEFT JOIN user u26_ ON c25_.user_id = u26_.id WHERE c25_.owner = ? AND u26_.id = ? AND (c25_.start_date IS NULL AND c25_.end_date IS NULL) AND c25_.original_owner = ? AND s23_.id = ?
Parameters: 
[
  1
  51
  1
  2
]
View formatted query    View runnable query    Explain query
6 1.67 ms 
SELECT c0_.date AS date_0, c0_.updated_at AS updated_at_1, c0_.dossier AS dossier_2, c0_.aide AS aide_3, c0_.id AS id_4, c0_.remove AS remove_5, p1_.firstname AS firstname_6, p1_.lastname AS lastname_7, p1_.email AS email_8, p1_.phone AS phone_9, p1_.address AS address_10, p1_.address_comp AS address_comp_11, p1_.zip AS zip_12, p1_.city AS city_13, p1_.birth AS birth_14, p1_.allocataire AS allocataire_15, p1_.secu AS secu_16, p1_.nud AS nud_17, p1_.id_pp AS id_pp_18, p1_.id AS id_19, p1_.remove AS remove_20, g2_.id AS id_21, g2_.value AS value_22, g2_.sort_order AS sort_order_23, g2_.active AS active_24, m3_.id AS id_25, m3_.value AS value_26, m3_.sort_order AS sort_order_27, m3_.active AS active_28, p4_.is_executive AS is_executive_29, p4_.id AS id_30, c5_.id AS id_31, c5_.value AS value_32, c5_.sort_order AS sort_order_33, c5_.active AS active_34, o6_.id AS id_35, o6_.value AS value_36, o6_.sort_order AS sort_order_37, o6_.active AS active_38, c7_.name AS name_39, c7_.siret AS siret_40, c7_.address AS address_41, c7_.address_comp AS address_comp_42, c7_.zip AS zip_43, c7_.city AS city_44, c7_.id_pm AS id_pm_45, c7_.id_adh AS id_adh_46, c7_.odoo_id AS odoo_id_47, c7_.last_synced_at AS last_synced_at_48, c7_.nom_commercial AS nom_commercial_49, c7_.forme_juridique AS forme_juridique_50, c7_.naf AS naf_51, c7_.secteur_activite AS secteur_activite_52, c7_.effectif AS effectif_53, c7_.gsc AS gsc_54, c7_.territoire AS territoire_55, c7_.assistante_sociale AS assistante_sociale_56, c7_.telephone AS telephone_57, c7_.mobile AS mobile_58, c7_.email AS email_59, c7_.site_web AS site_web_60, c7_.est_adherent AS est_adherent_61, c7_.est_membre AS est_membre_62, c7_.date_adhesion AS date_adhesion_63, c7_.reducbox AS reducbox_64, c7_.service_social AS service_social_65, c7_.id AS id_66, c7_.remove AS remove_67, p8_.firstname AS firstname_68, p8_.lastname AS lastname_69, p8_.email AS email_70, p8_.phone AS phone_71, p8_.address AS address_72, p8_.address_comp AS address_comp_73, p8_.zip AS zip_74, p8_.city AS city_75, p8_.birth AS birth_76, p8_.allocataire AS allocataire_77, p8_.secu AS secu_78, p8_.nud AS nud_79, p8_.id_pp AS id_pp_80, p8_.is_executive AS is_executive_81, p8_.corp_name AS corp_name_82, p8_.corp_siret AS corp_siret_83, p8_.corp_address AS corp_address_84, p8_.corp_address_comp AS corp_address_comp_85, p8_.corp_zip AS corp_zip_86, p8_.corp_city AS corp_city_87, p8_.corp_id_pm AS corp_id_pm_88, p8_.corp_id_adh AS corp_id_adh_89, p8_.id AS id_90, g9_.id AS id_91, g9_.value AS value_92, g9_.sort_order AS sort_order_93, g9_.active AS active_94, m10_.id AS id_95, m10_.value AS value_96, m10_.sort_order AS sort_order_97, m10_.active AS active_98, c11_.id AS id_99, c11_.value AS value_100, c11_.sort_order AS sort_order_101, c11_.active AS active_102, o12_.id AS id_103, o12_.value AS value_104, o12_.sort_order AS sort_order_105, o12_.active AS active_106, p13_.firstname AS firstname_107, p13_.lastname AS lastname_108, p13_.email AS email_109, p13_.phone AS phone_110, p13_.address AS address_111, p13_.address_comp AS address_comp_112, p13_.zip AS zip_113, p13_.city AS city_114, p13_.birth AS birth_115, p13_.allocataire AS allocataire_116, p13_.secu AS secu_117, p13_.nud AS nud_118, p13_.id_pp AS id_pp_119, p13_.id AS id_120, p13_.remove AS remove_121, c14_.name AS name_122, c14_.siret AS siret_123, c14_.address AS address_124, c14_.address_comp AS address_comp_125, c14_.zip AS zip_126, c14_.city AS city_127, c14_.id_pm AS id_pm_128, c14_.id_adh AS id_adh_129, c14_.odoo_id AS odoo_id_130, c14_.last_synced_at AS last_synced_at_131, c14_.nom_commercial AS nom_commercial_132, c14_.forme_juridique AS forme_juridique_133, c14_.naf AS naf_134, c14_.secteur_activite AS secteur_activite_135, c14_.effectif AS effectif_136, c14_.gsc AS gsc_137, c14_.territoire AS territoire_138, c14_.assistante_sociale AS assistante_sociale_139, c14_.telephone AS telephone_140, c14_.mobile AS mobile_141, c14_.email AS email_142, c14_.site_web AS site_web_143, c14_.est_adherent AS est_adherent_144, c14_.est_membre AS est_membre_145, c14_.date_adhesion AS date_adhesion_146, c14_.reducbox AS reducbox_147, c14_.service_social AS service_social_148, c14_.id AS id_149, c14_.remove AS remove_150, p15_.id AS id_151, p15_.value AS value_152, p15_.sort_order AS sort_order_153, p15_.active AS active_154, p15_.member AS member_155, r16_.id AS id_156, r16_.value AS value_157, r16_.sort_order AS sort_order_158, r16_.active AS active_159, r17_.id AS id_160, r17_.value AS value_161, r17_.sort_order AS sort_order_162, r17_.active AS active_163, o18_.id AS id_164, o18_.value AS value_165, o18_.sort_order AS sort_order_166, o18_.active AS active_167, i19_.time AS time_168, i19_.content AS content_169, i19_.created_at AS created_at_170, i19_.id AS id_171, i20_.id AS id_172, i20_.value AS value_173, i20_.sort_order AS sort_order_174, i20_.active AS active_175, u21_.username AS username_176, u21_.password AS password_177, u21_.email AS email_178, u21_.firstname AS firstname_179, u21_.lastname AS lastname_180, u21_.id AS id_181, u21_.active AS active_182, r22_.id AS id_183, r22_.identifier AS identifier_184, r22_.value AS value_185, s23_.id AS id_186, s23_.value AS value_187, s23_.color AS color_188, s23_.sort_order AS sort_order_189, s23_.active AS active_190, c24_.id AS id_191, c24_.value AS value_192, c24_.sort_order AS sort_order_193, c25_.owner AS owner_194, c25_.original_owner AS original_owner_195, c25_.start_date AS start_date_196, c25_.end_date AS end_date_197, u26_.username AS username_198, u26_.password AS password_199, u26_.email AS email_200, u26_.firstname AS firstname_201, u26_.lastname AS lastname_202, u26_.id AS id_203, u26_.active AS active_204, c0_.plan_id AS plan_id_205, c0_.person_id AS person_id_206, c0_.person_flat_id AS person_flat_id_207, c0_.reason_entry_id AS reason_entry_id_208, c0_.origin_id AS origin_id_209, c0_.status_id AS status_id_210, c0_.complete_id AS complete_id_211, p1_.gender_id AS gender_id_212, p1_.marital_id AS marital_id_213, p1_.person_corporation_id AS person_corporation_id_214, p4_.corporation_id AS corporation_id_215, p4_.contract_id AS contract_id_216, p4_.occupation_id AS occupation_id_217, p8_.person_id AS person_id_218, p8_.gender_id AS gender_id_219, p8_.marital_id AS marital_id_220, p8_.contract_id AS contract_id_221, p8_.occupation_id AS occupation_id_222, p8_.corporation_id AS corporation_id_223, p13_.gender_id AS gender_id_224, p13_.marital_id AS marital_id_225, p13_.person_corporation_id AS person_corporation_id_226, r16_.reason_id AS reason_id_227, i19_.intervention_modality_id AS intervention_modality_id_228, i19_.consultation_id AS consultation_id_229, i19_.user_id AS user_id_230, u21_.role_id AS role_id_231, u21_.zone_id AS zone_id_232, c25_.consultation_id AS consultation_id_233, c25_.user_id AS user_id_234, u26_.role_id AS role_id_235, u26_.zone_id AS zone_id_236 FROM consultation c0_ LEFT JOIN person p1_ ON c0_.person_id = p1_.id LEFT JOIN gender g2_ ON p1_.gender_id = g2_.id LEFT JOIN marital m3_ ON p1_.marital_id = m3_.id LEFT JOIN person_corporation p4_ ON p1_.person_corporation_id = p4_.id LEFT JOIN contract c5_ ON p4_.contract_id = c5_.id LEFT JOIN occupation o6_ ON p4_.occupation_id = o6_.id LEFT JOIN corporation c7_ ON p4_.corporation_id = c7_.id LEFT JOIN person_flat p8_ ON c0_.person_flat_id = p8_.id LEFT JOIN gender g9_ ON p8_.gender_id = g9_.id LEFT JOIN marital m10_ ON p8_.marital_id = m10_.id LEFT JOIN contract c11_ ON p8_.contract_id = c11_.id LEFT JOIN occupation o12_ ON p8_.occupation_id = o12_.id LEFT JOIN person p13_ ON p8_.person_id = p13_.id LEFT JOIN corporation c14_ ON p8_.corporation_id = c14_.id LEFT JOIN plan p15_ ON c0_.plan_id = p15_.id LEFT JOIN reason_entry r16_ ON c0_.reason_entry_id = r16_.id LEFT JOIN reason r17_ ON r16_.reason_id = r17_.id LEFT JOIN origin o18_ ON c0_.origin_id = o18_.id LEFT JOIN intervention i19_ ON c0_.id = i19_.consultation_id LEFT JOIN intervention_modality i20_ ON i19_.intervention_modality_id = i20_.id LEFT JOIN user u21_ ON i19_.user_id = u21_.id LEFT JOIN role r22_ ON u21_.role_id = r22_.id LEFT JOIN status s23_ ON c0_.status_id = s23_.id LEFT JOIN complete c24_ ON c0_.complete_id = c24_.id LEFT JOIN consultation_user c25_ ON c0_.id = c25_.consultation_id LEFT JOIN user u26_ ON c25_.user_id = u26_.id WHERE c25_.owner = ? AND u26_.id = ? AND (c25_.start_date IS NULL AND c25_.end_date IS NULL) AND c25_.original_owner = ? ORDER BY c0_.updated_at DESC, i19_.id DESC LIMIT 3
Parameters: 
[
  1
  51
  1
]
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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\User 2
App\Entity\Role 2
App\Entity\Consultation 2
App\Entity\ReasonEntry 2
App\Entity\Reason 2
App\Entity\Intervention 2
App\Entity\InterventionModality 2
App\Entity\Status 2
App\Entity\ConsultationUser 2
App\Entity\Zone 1
App\Entity\Person 1
App\Entity\Gender 1
App\Entity\Marital 1
App\Entity\PersonCorporation 1
App\Entity\Contract 1
App\Entity\Occupation 1
App\Entity\Corporation 1
App\Entity\Plan 1
App\Entity\Origin 1
App\Entity\PersonFlat 1

Entities Mapping

Class Mapping errors
App\Entity\User No errors.
App\Entity\Role No errors.
App\Entity\Zone No errors.
App\Entity\Preference No errors.
App\Entity\Intervention No errors.
App\Entity\Consultation No errors.
App\Entity\Person No errors.
App\Entity\Gender No errors.
App\Entity\Marital No errors.
App\Entity\PersonCorporation No errors.
App\Entity\Contract No errors.
App\Entity\Occupation No errors.
App\Entity\Corporation No errors.
App\Entity\PersonFlat No errors.
App\Entity\Plan No errors.
App\Entity\ReasonEntry No errors.
App\Entity\Reason No errors.
App\Entity\Origin No errors.
App\Entity\InterventionModality No errors.
App\Entity\Status No errors.
App\Entity\Complete No errors.
App\Entity\ConsultationUser No errors.