Query Metrics
5
Database Queries
5
Different statements
1.21 ms
Query time
0
Invalid entities
4
Managed entities
Queries
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.