GET https://preprod.hework.fr/api/notifications/list/888/gerance/sys

Query Metrics

5 Database Queries
5 Different statements
1.21 ms Query time
0 Invalid entities
4 Managed entities

Queries

Group similar statements

default connection

# Time Info
1 0.30 ms
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"
]
2 0.25 ms
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:
[
  "888"
  1
]
3 0.21 ms
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:
[
  38
  "SYS"
  1
]

hework888 connection

# Time Info
1 0.25 ms
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:
[
  2
]
2 0.19 ms
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:
[
  2
  0
]

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

hework888 entity manager

Class Amount of managed objects
App\Entity\Hework\HwStaff 1

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

No loaded entities.

hework888 entity manager

Class Mapping errors
App\Entity\Hework\HwStaff No errors.
App\Entity\Hework\HwStaffOptions No errors.
App\Entity\Hework\HwTicket No errors.
App\Entity\Hework\HwSite No errors.
App\Entity\Hework\HwTodo No errors.
App\Entity\Hework\HwTicketAbo No errors.
App\Entity\Hework\HwNotification No errors.
App\Entity\Hework\HwSiteStaff No errors.
App\Entity\Hework\HwContact No errors.
App\Entity\Hework\HwSinistre No errors.
App\Entity\Hework\Schedule\ScMessage No errors.

hework003 entity manager

No loaded entities.