Query Metrics
7
Database Queries
7
Different statements
58.62 ms
Query time
0
Invalid entities
11
Managed entities
Grouped Statements
default connection
| Time▼ | Count | Info |
|---|---|---|
|
1.20 ms (2.04%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.lastname AS lastname_6, t0.firstname AS firstname_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.last_login_at AS last_login_at_10, t0.lost_code AS lost_code_11, t0.lost_at AS lost_at_12, t0.token AS token_13, t0.avatar AS avatar_14, t0.manager AS manager_15, t0.is_blocked AS is_blocked_16, t0.staff_id AS staff_id_17, t0.staff_metier AS staff_metier_18, t0.rg_utl AS rg_utl_19, t0.created_from AS created_from_20, t0.co_fournisseur_uid AS co_fournisseur_uid_21, t0.staff_others AS staff_others_22, t0.staff_abonnes AS staff_abonnes_23, t0.token_help AS token_help_24, t0.token_session AS token_session_25, t0.vision_data AS vision_data_26, t0.staff_team AS staff_team_27, t0.tampon_filename AS tampon_filename_28, t0.default_abos_site AS default_abos_site_29, t0.microsoft_email AS microsoft_email_30, t0.microsoft_oid AS microsoft_oid_31, t0.vision_website AS vision_website_32, t0.society_id AS society_id_33 FROM user t0 WHERE t0.society_id = ? AND t0.rg_utl = ? AND t0.staff_metier = ? LIMIT 1
Parameters:
[ 2 "SYS" 0 ] |
|
0.57 ms (0.97%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.manager AS manager_3, t0.dirname AS dirname_4, t0.code AS code_5, t0.is_activated AS is_activated_6, t0.is_generated AS is_generated_7, t0.is_blocked AS is_blocked_8, t0.logo AS logo_9, t0.bandeau AS bandeau_10, t0.email AS email_11, t0.year_ticket AS year_ticket_12, t0.year_sinistre AS year_sinistre_13, t0.counter_ticket AS counter_ticket_14, t0.counter_sinistre AS counter_sinistre_15, t0.have_logiciel_syndic AS have_logiciel_syndic_16, t0.have_logiciel_gerance AS have_logiciel_gerance_17, t0.have_app_visit AS have_app_visit_18, t0.token_help AS token_help_19, t0.imap_username AS imap_username_20, t0.imap_password AS imap_password_21, t0.pdf_email AS pdf_email_22, t0.pdf_phone AS pdf_phone_23, t0.pdf_address AS pdf_address_24, t0.pdf_complement AS pdf_complement_25, t0.pdf_zipcode AS pdf_zipcode_26, t0.pdf_city AS pdf_city_27, t0.default_user_vision AS default_user_vision_28, t0.visit_email AS visit_email_29, t0.use_domain_for_mail AS use_domain_for_mail_30, t0.legal_data AS legal_data_31 FROM society t0 WHERE t0.code = ? AND t0.is_activated = ? LIMIT 1
Parameters:
[ "998" 1 ] |
|
0.26 ms (0.45%) |
1 |
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.email AS email_5, t0.lastname AS lastname_6, t0.firstname AS firstname_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.last_login_at AS last_login_at_10, t0.lost_code AS lost_code_11, t0.lost_at AS lost_at_12, t0.token AS token_13, t0.avatar AS avatar_14, t0.manager AS manager_15, t0.is_blocked AS is_blocked_16, t0.staff_id AS staff_id_17, t0.staff_metier AS staff_metier_18, t0.rg_utl AS rg_utl_19, t0.created_from AS created_from_20, t0.co_fournisseur_uid AS co_fournisseur_uid_21, t0.staff_others AS staff_others_22, t0.staff_abonnes AS staff_abonnes_23, t0.token_help AS token_help_24, t0.token_session AS token_session_25, t0.vision_data AS vision_data_26, t0.staff_team AS staff_team_27, t0.tampon_filename AS tampon_filename_28, t0.default_abos_site AS default_abos_site_29, t0.microsoft_email AS microsoft_email_30, t0.microsoft_oid AS microsoft_oid_31, t0.vision_website AS vision_website_32, t0.society_id AS society_id_33 FROM user t0 WHERE t0.username = ? LIMIT 1
Parameters:
[
"apilogiciel"
]
|
hework998 connection
| Time▼ | Count | Info |
|---|---|---|
|
41.25 ms (70.37%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.is_seen AS is_seen_4, t0.url AS url_5, t0.is_abo AS is_abo_6, t0.created_at AS created_at_7, t0.to_push AS to_push_8, t0.creator AS creator_9, t0.uid AS uid_10, t0.staff_id AS staff_id_11, t0.ticket_id AS ticket_id_12 FROM hw_notification t0 WHERE t0.staff_id = ? AND t0.is_seen = ? ORDER BY t0.created_at DESC LIMIT 11
Parameters:
[ 32 0 ] |
|
10.96 ms (18.70%) |
1 |
SELECT t0.id AS id_1, t0.old_id AS old_id_2, t0.numero AS numero_3, t0.uid AS uid_4, t0.tab_uid AS tab_uid_5, t0.libelle AS libelle_6, t0.type_metier AS type_metier_7, t0.type_ticket AS type_ticket_8, t0.type_inter AS type_inter_9, t0.status AS status_10, t0.is_close AS is_close_11, t0.description AS description_12, t0.is_urgent AS is_urgent_13, t0.is_for_ag AS is_for_ag_14, t0.is_privatif AS is_privatif_15, t0.declarant_type AS declarant_type_16, t0.declarant_other AS declarant_other_17, t0.declarant_notified AS declarant_notified_18, t0.intervention_at AS intervention_at_19, t0.intervention_start_commentary AS intervention_start_commentary_20, t0.intervention_end_commentary AS intervention_end_commentary_21, t0.cloture_commentary AS cloture_commentary_22, t0.close_commentary AS close_commentary_23, t0.relance_activated AS relance_activated_24, t0.relance_days AS relance_days_25, t0.relance_last_at AS relance_last_at_26, t0.commentary AS commentary_27, t0.infos_extra AS infos_extra_28, t0.contacts_one_shot AS contacts_one_shot_29, t0.actors_one_shot AS actors_one_shot_30, t0.created_by AS created_by_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.token AS token_34, t0.ag_date_at AS ag_date_at_35, t0.idtravaux AS idtravaux_36, t0.ori_type_inter AS ori_type_inter_37, t0.status_before_zeno AS status_before_zeno_38, t0.disable_auto_cloture AS disable_auto_cloture_39, t0.scheduled_at AS scheduled_at_40, t0.old_commentary AS old_commentary_41, t0.intervention_time_at AS intervention_time_at_42, t0.who_pay_type AS who_pay_type_43, t0.who_pay_other AS who_pay_other_44, t0.declarant_contact_id AS declarant_contact_id_45, t46.id AS id_47, t46.type_metier AS type_metier_48, t46.windev_cle AS windev_cle_49, t46.numero AS numero_50, t46.type_contact AS type_contact_51, t46.type_contact_custom AS type_contact_custom_52, t46.civility AS civility_53, t46.civility_custom AS civility_custom_54, t46.lastname AS lastname_55, t46.firstname AS firstname_56, t46.email AS email_57, t46.phone1 AS phone1_58, t46.phone2 AS phone2_59, t46.phone3 AS phone3_60, t46.info_phone1 AS info_phone1_61, t46.info_phone2 AS info_phone2_62, t46.info_phone3 AS info_phone3_63, t46.address AS address_64, t46.complement AS complement_65, t46.zipcode AS zipcode_66, t46.city AS city_67, t46.country AS country_68, t46.created_at AS created_at_69, t46.updated_at AS updated_at_70, t46.is_deleted AS is_deleted_71, t46.is_active AS is_active_72, t46.responsable_contact_id AS responsable_contact_id_73, t0.site_id AS site_id_74, t75.id AS id_76, t75.type_metier AS type_metier_77, t75.numero AS numero_78, t75.name AS name_79, t75.address AS address_80, t75.complement AS complement_81, t75.zipcode AS zipcode_82, t75.city AS city_83, t75.montant_soumettre_to_cs AS montant_soumettre_to_cs_84, t75.montant_authorize_to_cs AS montant_authorize_to_cs_85, t75.montant_concurrence AS montant_concurrence_86, t75.regime AS regime_87, t75.observation_access AS observation_access_88, t75.is_deleted AS is_deleted_89, t75.created_at AS created_at_90, t75.updated_at AS updated_at_91, t75.concierge AS concierge_92, t75.observation AS observation_93, t75.responsable_travaux_id AS responsable_travaux_id_94, t0.structure_id AS structure_id_95, t96.id AS id_97, t96.type_metier AS type_metier_98, t96.old_identifiant AS old_identifiant_99, t96.uid AS uid_100, t96.name AS name_101, t96.num_batiment AS num_batiment_102, t96.escalier AS escalier_103, t96.address AS address_104, t96.complement AS complement_105, t96.zipcode AS zipcode_106, t96.city AS city_107, t96.created_at AS created_at_108, t96.updated_at AS updated_at_109, t96.is_deleted AS is_deleted_110, t96.site_id AS site_id_111, t0.lot_id AS lot_id_112, t113.id AS id_114, t113.type_metier AS type_metier_115, t113.numero AS numero_116, t113.type_lot AS type_lot_117, t113.floor AS floor_118, t113.door AS door_119, t113.situation AS situation_120, t113.surface AS surface_121, t113.created_at AS created_at_122, t113.updated_at AS updated_at_123, t113.is_deleted AS is_deleted_124, t113.site_id AS site_id_125, t113.structure_id AS structure_id_126, t0.responsable_id AS responsable_id_127, t128.id AS id_129, t128.society_code AS society_code_130, t128.type_metier AS type_metier_131, t128.rg_code AS rg_code_132, t128.type_staff AS type_staff_133, t128.name AS name_134, t128.email AS email_135, t128.phone1 AS phone1_136, t128.phone2 AS phone2_137, t128.color AS color_138, t128.canal_alerts AS canal_alerts_139, t128.is_admin AS is_admin_140, t128.is_deleted AS is_deleted_141, t128.created_at AS created_at_142, t128.updated_at AS updated_at_143, t128.created_from AS created_from_144, t0.cle_repartition_id AS cle_repartition_id_145, t146.id AS id_147, t146.numero AS numero_148, t146.type AS type_149, t146.name AS name_150, t146.is_deleted AS is_deleted_151, t146.site_id AS site_id_152, t146.structure_id AS structure_id_153, t0.category_id AS category_id_154, t0.who_pay_contact_id AS who_pay_contact_id_155 FROM hw_ticket t0 LEFT JOIN hw_contact t46 ON t0.declarant_contact_id = t46.id INNER JOIN hw_site t75 ON t0.site_id = t75.id LEFT JOIN hw_structure t96 ON t0.structure_id = t96.id LEFT JOIN hw_lot t113 ON t0.lot_id = t113.id INNER JOIN hw_staff t128 ON t0.responsable_id = t128.id LEFT JOIN hw_cle_repartition t146 ON t0.cle_repartition_id = t146.id WHERE t0.id = ?
Parameters:
[
65
]
|
|
3.84 ms (6.55%) |
1 |
SELECT t0.id AS id_1, t0.society_code AS society_code_2, t0.type_metier AS type_metier_3, t0.rg_code AS rg_code_4, t0.type_staff AS type_staff_5, t0.name AS name_6, t0.email AS email_7, t0.phone1 AS phone1_8, t0.phone2 AS phone2_9, t0.color AS color_10, t0.canal_alerts AS canal_alerts_11, t0.is_admin AS is_admin_12, t0.is_deleted AS is_deleted_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.created_from AS created_from_16, t17.id AS id_18, t17.canal_message AS canal_message_19, t17.canal_devis_received AS canal_devis_received_20, t17.canal_intervention_start AS canal_intervention_start_21, t17.canal_intervention_end AS canal_intervention_end_22, t17.canal_invoice_received AS canal_invoice_received_23, t17.canal_decline AS canal_decline_24, t17.canal_document_deposed AS canal_document_deposed_25, t17.canal_answer_inbox AS canal_answer_inbox_26, t17.canal_mail_error AS canal_mail_error_27, t17.canal_diagnostic_deposed AS canal_diagnostic_deposed_28, t17.canal_demande_accepted AS canal_demande_accepted_29, t17.canal_tache AS canal_tache_30, t17.canal_abo_affected AS canal_abo_affected_31, t17.staff_id AS staff_id_32 FROM hw_staff t0 LEFT JOIN hw_staff_options t17 ON t17.staff_id = t0.id WHERE t0.id IN (?) LIMIT 1
Parameters:
[
32
]
|
|
0.54 ms (0.92%) |
1 |
SELECT t0.id AS id_1, t0.society_code AS society_code_2, t0.type_metier AS type_metier_3, t0.rg_code AS rg_code_4, t0.type_staff AS type_staff_5, t0.name AS name_6, t0.email AS email_7, t0.phone1 AS phone1_8, t0.phone2 AS phone2_9, t0.color AS color_10, t0.canal_alerts AS canal_alerts_11, t0.is_admin AS is_admin_12, t0.is_deleted AS is_deleted_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.created_from AS created_from_16, t17.id AS id_18, t17.canal_message AS canal_message_19, t17.canal_devis_received AS canal_devis_received_20, t17.canal_intervention_start AS canal_intervention_start_21, t17.canal_intervention_end AS canal_intervention_end_22, t17.canal_invoice_received AS canal_invoice_received_23, t17.canal_decline AS canal_decline_24, t17.canal_document_deposed AS canal_document_deposed_25, t17.canal_answer_inbox AS canal_answer_inbox_26, t17.canal_mail_error AS canal_mail_error_27, t17.canal_diagnostic_deposed AS canal_diagnostic_deposed_28, t17.canal_demande_accepted AS canal_demande_accepted_29, t17.canal_tache AS canal_tache_30, t17.canal_abo_affected AS canal_abo_affected_31, t17.staff_id AS staff_id_32 FROM hw_staff t0 LEFT JOIN hw_staff_options t17 ON t17.staff_id = t0.id WHERE t0.id IN (?)
Parameters:
[
7
]
|
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
| hework999 | doctrine.dbal.hework999_connection |
| hework998 | doctrine.dbal.hework998_connection |
| hework888 | doctrine.dbal.hework888_connection |
| hework003 | doctrine.dbal.hework003_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
| hework999 | doctrine.orm.hework999_entity_manager |
| hework998 | doctrine.orm.hework998_entity_manager |
| hework888 | doctrine.orm.hework888_entity_manager |
| hework003 | doctrine.orm.hework003_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Main\User | 2 |
| App\Entity\Main\Society | 1 |
hework999 entity manager
| Class | Amount of managed objects |
|---|
hework998 entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Hework\HwNotification | 4 |
| App\Entity\Hework\HwStaff | 2 |
| App\Entity\Hework\HwTicket | 1 |
| App\Entity\Hework\HwSite | 1 |
hework888 entity manager
| Class | Amount of managed objects |
|---|
hework003 entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
default entity manager
| Class | Mapping errors |
|---|---|
| App\Entity\Main\User | No errors. |
| App\Entity\Main\Society | No errors. |
| App\Entity\Main\Mail | No errors. |
| App\Entity\Main\OAuth\OaAccount | No errors. |
| App\Entity\Main\Commun\CoLinkSocietyFournisseur | No errors. |
hework999 entity manager
No loaded entities.
hework998 entity manager
hework888 entity manager
No loaded entities.
hework003 entity manager
No loaded entities.