Query Metrics

37 Database Queries
5 Different statements
15.12 ms Query time
0 Invalid entities
49 Managed entities

Queries

Group similar statements

rw connection

# Time Info
1 1.28 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.last_login AS last_login_6, t0.is_verified AS is_verified_7, t0.enabled AS enabled_8, t9.id AS id_10, t9.theme AS theme_11, t9.color_theme AS color_theme_12, t9.layout AS layout_13, t9.sidebar_type AS sidebar_type_14, t9.boxed_layout AS boxed_layout_15, t9.direction AS direction_16, t9.card_border AS card_border_17, t9.timezone AS timezone_18, t9.dashboard_weeks AS dashboard_weeks_19, t9.kpi_weeks AS kpi_weeks_20, t9.store_report_weeks AS store_report_weeks_21, t9.user_id AS user_id_22, t23.id AS id_24, t23.registrar_server AS registrar_server_25, t23.registrar_port AS registrar_port_26, t23.extension_username AS extension_username_27, t23.encrypted_password AS encrypted_password_28, t23.display_name AS display_name_29, t23.is_active AS is_active_30, t23.created_at AS created_at_31, t23.updated_at AS updated_at_32, t23.user_id AS user_id_33 FROM user t0 LEFT JOIN user_settings t9 ON t9.user_id = t0.id LEFT JOIN webphone_mapping t23 ON t23.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  18
]
2 0.91 ms
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.description AS description_2, s0_.status AS status_3, s0_.priority AS priority_4, s0_.callback_offset_hours AS callback_offset_hours_5, s0_.callback_offset_busy_minutes AS callback_offset_busy_minutes_6, s0_.callback_offset_no_answer_hours AS callback_offset_no_answer_hours_7, s0_.callback_offset_voicemail_minutes AS callback_offset_voicemail_minutes_8, s0_.callback_attempt_limit AS callback_attempt_limit_9, s0_.created_at AS created_at_10, s0_.updated_at AS updated_at_11 FROM store_call_campaign s0_
Parameters:
[]
3 0.84 ms
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.username AS username_2, u0_.roles AS roles_3, u0_.password AS password_4, u0_.last_login AS last_login_5, u0_.is_verified AS is_verified_6, u0_.enabled AS enabled_7 FROM user u0_
Parameters:
[]
4 0.91 ms
SELECT t0.id AS id_1, t0.theme AS theme_2, t0.color_theme AS color_theme_3, t0.layout AS layout_4, t0.sidebar_type AS sidebar_type_5, t0.boxed_layout AS boxed_layout_6, t0.direction AS direction_7, t0.card_border AS card_border_8, t0.timezone AS timezone_9, t0.dashboard_weeks AS dashboard_weeks_10, t0.kpi_weeks AS kpi_weeks_11, t0.store_report_weeks AS store_report_weeks_12, t0.user_id AS user_id_13 FROM user_settings t0 WHERE t0.user_id = ?
Parameters:
[
  9
]
5 0.55 ms
SELECT t0.id AS id_1, t0.registrar_server AS registrar_server_2, t0.registrar_port AS registrar_port_3, t0.extension_username AS extension_username_4, t0.encrypted_password AS encrypted_password_5, t0.display_name AS display_name_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM webphone_mapping t0 WHERE t0.user_id = ?
Parameters:
[
  9
]
6 0.47 ms
SELECT t0.id AS id_1, t0.theme AS theme_2, t0.color_theme AS color_theme_3, t0.layout AS layout_4, t0.sidebar_type AS sidebar_type_5, t0.boxed_layout AS boxed_layout_6, t0.direction AS direction_7, t0.card_border AS card_border_8, t0.timezone AS timezone_9, t0.dashboard_weeks AS dashboard_weeks_10, t0.kpi_weeks AS kpi_weeks_11, t0.store_report_weeks AS store_report_weeks_12, t0.user_id AS user_id_13 FROM user_settings t0 WHERE t0.user_id = ?
Parameters:
[
  10
]
7 0.39 ms
SELECT t0.id AS id_1, t0.registrar_server AS registrar_server_2, t0.registrar_port AS registrar_port_3, t0.extension_username AS extension_username_4, t0.encrypted_password AS encrypted_password_5, t0.display_name AS display_name_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM webphone_mapping t0 WHERE t0.user_id = ?
Parameters:
[
  10
]
8 0.42 ms
SELECT t0.id AS id_1, t0.theme AS theme_2, t0.color_theme AS color_theme_3, t0.layout AS layout_4, t0.sidebar_type AS sidebar_type_5, t0.boxed_layout AS boxed_layout_6, t0.direction AS direction_7, t0.card_border AS card_border_8, t0.timezone AS timezone_9, t0.dashboard_weeks AS dashboard_weeks_10, t0.kpi_weeks AS kpi_weeks_11, t0.store_report_weeks AS store_report_weeks_12, t0.user_id AS user_id_13 FROM user_settings t0 WHERE t0.user_id = ?
Parameters:
[
  20
]
9 0.47 ms
SELECT t0.id AS id_1, t0.registrar_server AS registrar_server_2, t0.registrar_port AS registrar_port_3, t0.extension_username AS extension_username_4, t0.encrypted_password AS encrypted_password_5, t0.display_name AS display_name_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM webphone_mapping t0 WHERE t0.user_id = ?
Parameters:
[
  20
]
10 0.43 ms
SELECT t0.id AS id_1, t0.theme AS theme_2, t0.color_theme AS color_theme_3, t0.layout AS layout_4, t0.sidebar_type AS sidebar_type_5, t0.boxed_layout AS boxed_layout_6, t0.direction AS direction_7, t0.card_border AS card_border_8, t0.timezone AS timezone_9, t0.dashboard_weeks AS dashboard_weeks_10, t0.kpi_weeks AS kpi_weeks_11, t0.store_report_weeks AS store_report_weeks_12, t0.user_id AS user_id_13 FROM user_settings t0 WHERE t0.user_id = ?
Parameters:
[
  21
]
11 0.38 ms
SELECT t0.id AS id_1, t0.registrar_server AS registrar_server_2, t0.registrar_port AS registrar_port_3, t0.extension_username AS extension_username_4, t0.encrypted_password AS encrypted_password_5, t0.display_name AS display_name_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM webphone_mapping t0 WHERE t0.user_id = ?
Parameters:
[
  21
]
12 0.31 ms
SELECT t0.id AS id_1, t0.theme AS theme_2, t0.color_theme AS color_theme_3, t0.layout AS layout_4, t0.sidebar_type AS sidebar_type_5, t0.boxed_layout AS boxed_layout_6, t0.direction AS direction_7, t0.card_border AS card_border_8, t0.timezone AS timezone_9, t0.dashboard_weeks AS dashboard_weeks_10, t0.kpi_weeks AS kpi_weeks_11, t0.store_report_weeks AS store_report_weeks_12, t0.user_id AS user_id_13 FROM user_settings t0 WHERE t0.user_id = ?
Parameters:
[
  22
]
13 0.33 ms
SELECT t0.id AS id_1, t0.registrar_server AS registrar_server_2, t0.registrar_port AS registrar_port_3, t0.extension_username AS extension_username_4, t0.encrypted_password AS encrypted_password_5, t0.display_name AS display_name_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM webphone_mapping t0 WHERE t0.user_id = ?
Parameters:
[
  22
]
14 0.33 ms
SELECT t0.id AS id_1, t0.theme AS theme_2, t0.color_theme AS color_theme_3, t0.layout AS layout_4, t0.sidebar_type AS sidebar_type_5, t0.boxed_layout AS boxed_layout_6, t0.direction AS direction_7, t0.card_border AS card_border_8, t0.timezone AS timezone_9, t0.dashboard_weeks AS dashboard_weeks_10, t0.kpi_weeks AS kpi_weeks_11, t0.store_report_weeks AS store_report_weeks_12, t0.user_id AS user_id_13 FROM user_settings t0 WHERE t0.user_id = ?
Parameters:
[
  23
]
15 0.38 ms
SELECT t0.id AS id_1, t0.registrar_server AS registrar_server_2, t0.registrar_port AS registrar_port_3, t0.extension_username AS extension_username_4, t0.encrypted_password AS encrypted_password_5, t0.display_name AS display_name_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM webphone_mapping t0 WHERE t0.user_id = ?
Parameters:
[
  23
]
16 0.33 ms
SELECT t0.id AS id_1, t0.theme AS theme_2, t0.color_theme AS color_theme_3, t0.layout AS layout_4, t0.sidebar_type AS sidebar_type_5, t0.boxed_layout AS boxed_layout_6, t0.direction AS direction_7, t0.card_border AS card_border_8, t0.timezone AS timezone_9, t0.dashboard_weeks AS dashboard_weeks_10, t0.kpi_weeks AS kpi_weeks_11, t0.store_report_weeks AS store_report_weeks_12, t0.user_id AS user_id_13 FROM user_settings t0 WHERE t0.user_id = ?
Parameters:
[
  26
]
17 0.38 ms
SELECT t0.id AS id_1, t0.registrar_server AS registrar_server_2, t0.registrar_port AS registrar_port_3, t0.extension_username AS extension_username_4, t0.encrypted_password AS encrypted_password_5, t0.display_name AS display_name_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM webphone_mapping t0 WHERE t0.user_id = ?
Parameters:
[
  26
]
18 0.37 ms
SELECT t0.id AS id_1, t0.theme AS theme_2, t0.color_theme AS color_theme_3, t0.layout AS layout_4, t0.sidebar_type AS sidebar_type_5, t0.boxed_layout AS boxed_layout_6, t0.direction AS direction_7, t0.card_border AS card_border_8, t0.timezone AS timezone_9, t0.dashboard_weeks AS dashboard_weeks_10, t0.kpi_weeks AS kpi_weeks_11, t0.store_report_weeks AS store_report_weeks_12, t0.user_id AS user_id_13 FROM user_settings t0 WHERE t0.user_id = ?
Parameters:
[
  29
]
19 0.30 ms
SELECT t0.id AS id_1, t0.registrar_server AS registrar_server_2, t0.registrar_port AS registrar_port_3, t0.extension_username AS extension_username_4, t0.encrypted_password AS encrypted_password_5, t0.display_name AS display_name_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM webphone_mapping t0 WHERE t0.user_id = ?
Parameters:
[
  29
]
20 0.30 ms
SELECT t0.id AS id_1, t0.theme AS theme_2, t0.color_theme AS color_theme_3, t0.layout AS layout_4, t0.sidebar_type AS sidebar_type_5, t0.boxed_layout AS boxed_layout_6, t0.direction AS direction_7, t0.card_border AS card_border_8, t0.timezone AS timezone_9, t0.dashboard_weeks AS dashboard_weeks_10, t0.kpi_weeks AS kpi_weeks_11, t0.store_report_weeks AS store_report_weeks_12, t0.user_id AS user_id_13 FROM user_settings t0 WHERE t0.user_id = ?
Parameters:
[
  30
]
21 0.29 ms
SELECT t0.id AS id_1, t0.registrar_server AS registrar_server_2, t0.registrar_port AS registrar_port_3, t0.extension_username AS extension_username_4, t0.encrypted_password AS encrypted_password_5, t0.display_name AS display_name_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM webphone_mapping t0 WHERE t0.user_id = ?
Parameters:
[
  30
]
22 0.30 ms
SELECT t0.id AS id_1, t0.theme AS theme_2, t0.color_theme AS color_theme_3, t0.layout AS layout_4, t0.sidebar_type AS sidebar_type_5, t0.boxed_layout AS boxed_layout_6, t0.direction AS direction_7, t0.card_border AS card_border_8, t0.timezone AS timezone_9, t0.dashboard_weeks AS dashboard_weeks_10, t0.kpi_weeks AS kpi_weeks_11, t0.store_report_weeks AS store_report_weeks_12, t0.user_id AS user_id_13 FROM user_settings t0 WHERE t0.user_id = ?
Parameters:
[
  32
]
23 0.28 ms
SELECT t0.id AS id_1, t0.registrar_server AS registrar_server_2, t0.registrar_port AS registrar_port_3, t0.extension_username AS extension_username_4, t0.encrypted_password AS encrypted_password_5, t0.display_name AS display_name_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM webphone_mapping t0 WHERE t0.user_id = ?
Parameters:
[
  32
]
24 0.33 ms
SELECT t0.id AS id_1, t0.theme AS theme_2, t0.color_theme AS color_theme_3, t0.layout AS layout_4, t0.sidebar_type AS sidebar_type_5, t0.boxed_layout AS boxed_layout_6, t0.direction AS direction_7, t0.card_border AS card_border_8, t0.timezone AS timezone_9, t0.dashboard_weeks AS dashboard_weeks_10, t0.kpi_weeks AS kpi_weeks_11, t0.store_report_weeks AS store_report_weeks_12, t0.user_id AS user_id_13 FROM user_settings t0 WHERE t0.user_id = ?
Parameters:
[
  34
]
25 0.30 ms
SELECT t0.id AS id_1, t0.registrar_server AS registrar_server_2, t0.registrar_port AS registrar_port_3, t0.extension_username AS extension_username_4, t0.encrypted_password AS encrypted_password_5, t0.display_name AS display_name_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM webphone_mapping t0 WHERE t0.user_id = ?
Parameters:
[
  34
]
26 0.31 ms
SELECT t0.id AS id_1, t0.theme AS theme_2, t0.color_theme AS color_theme_3, t0.layout AS layout_4, t0.sidebar_type AS sidebar_type_5, t0.boxed_layout AS boxed_layout_6, t0.direction AS direction_7, t0.card_border AS card_border_8, t0.timezone AS timezone_9, t0.dashboard_weeks AS dashboard_weeks_10, t0.kpi_weeks AS kpi_weeks_11, t0.store_report_weeks AS store_report_weeks_12, t0.user_id AS user_id_13 FROM user_settings t0 WHERE t0.user_id = ?
Parameters:
[
  36
]
27 0.32 ms
SELECT t0.id AS id_1, t0.registrar_server AS registrar_server_2, t0.registrar_port AS registrar_port_3, t0.extension_username AS extension_username_4, t0.encrypted_password AS encrypted_password_5, t0.display_name AS display_name_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM webphone_mapping t0 WHERE t0.user_id = ?
Parameters:
[
  36
]
28 0.30 ms
SELECT t0.id AS id_1, t0.theme AS theme_2, t0.color_theme AS color_theme_3, t0.layout AS layout_4, t0.sidebar_type AS sidebar_type_5, t0.boxed_layout AS boxed_layout_6, t0.direction AS direction_7, t0.card_border AS card_border_8, t0.timezone AS timezone_9, t0.dashboard_weeks AS dashboard_weeks_10, t0.kpi_weeks AS kpi_weeks_11, t0.store_report_weeks AS store_report_weeks_12, t0.user_id AS user_id_13 FROM user_settings t0 WHERE t0.user_id = ?
Parameters:
[
  38
]
29 0.31 ms
SELECT t0.id AS id_1, t0.registrar_server AS registrar_server_2, t0.registrar_port AS registrar_port_3, t0.extension_username AS extension_username_4, t0.encrypted_password AS encrypted_password_5, t0.display_name AS display_name_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM webphone_mapping t0 WHERE t0.user_id = ?
Parameters:
[
  38
]
30 0.28 ms
SELECT t0.id AS id_1, t0.theme AS theme_2, t0.color_theme AS color_theme_3, t0.layout AS layout_4, t0.sidebar_type AS sidebar_type_5, t0.boxed_layout AS boxed_layout_6, t0.direction AS direction_7, t0.card_border AS card_border_8, t0.timezone AS timezone_9, t0.dashboard_weeks AS dashboard_weeks_10, t0.kpi_weeks AS kpi_weeks_11, t0.store_report_weeks AS store_report_weeks_12, t0.user_id AS user_id_13 FROM user_settings t0 WHERE t0.user_id = ?
Parameters:
[
  40
]
31 0.26 ms
SELECT t0.id AS id_1, t0.registrar_server AS registrar_server_2, t0.registrar_port AS registrar_port_3, t0.extension_username AS extension_username_4, t0.encrypted_password AS encrypted_password_5, t0.display_name AS display_name_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM webphone_mapping t0 WHERE t0.user_id = ?
Parameters:
[
  40
]
32 0.32 ms
SELECT t0.id AS id_1, t0.theme AS theme_2, t0.color_theme AS color_theme_3, t0.layout AS layout_4, t0.sidebar_type AS sidebar_type_5, t0.boxed_layout AS boxed_layout_6, t0.direction AS direction_7, t0.card_border AS card_border_8, t0.timezone AS timezone_9, t0.dashboard_weeks AS dashboard_weeks_10, t0.kpi_weeks AS kpi_weeks_11, t0.store_report_weeks AS store_report_weeks_12, t0.user_id AS user_id_13 FROM user_settings t0 WHERE t0.user_id = ?
Parameters:
[
  42
]
33 0.28 ms
SELECT t0.id AS id_1, t0.registrar_server AS registrar_server_2, t0.registrar_port AS registrar_port_3, t0.extension_username AS extension_username_4, t0.encrypted_password AS encrypted_password_5, t0.display_name AS display_name_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM webphone_mapping t0 WHERE t0.user_id = ?
Parameters:
[
  42
]
34 0.27 ms
SELECT t0.id AS id_1, t0.theme AS theme_2, t0.color_theme AS color_theme_3, t0.layout AS layout_4, t0.sidebar_type AS sidebar_type_5, t0.boxed_layout AS boxed_layout_6, t0.direction AS direction_7, t0.card_border AS card_border_8, t0.timezone AS timezone_9, t0.dashboard_weeks AS dashboard_weeks_10, t0.kpi_weeks AS kpi_weeks_11, t0.store_report_weeks AS store_report_weeks_12, t0.user_id AS user_id_13 FROM user_settings t0 WHERE t0.user_id = ?
Parameters:
[
  44
]
35 0.25 ms
SELECT t0.id AS id_1, t0.registrar_server AS registrar_server_2, t0.registrar_port AS registrar_port_3, t0.extension_username AS extension_username_4, t0.encrypted_password AS encrypted_password_5, t0.display_name AS display_name_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM webphone_mapping t0 WHERE t0.user_id = ?
Parameters:
[
  44
]
36 0.28 ms
SELECT t0.id AS id_1, t0.theme AS theme_2, t0.color_theme AS color_theme_3, t0.layout AS layout_4, t0.sidebar_type AS sidebar_type_5, t0.boxed_layout AS boxed_layout_6, t0.direction AS direction_7, t0.card_border AS card_border_8, t0.timezone AS timezone_9, t0.dashboard_weeks AS dashboard_weeks_10, t0.kpi_weeks AS kpi_weeks_11, t0.store_report_weeks AS store_report_weeks_12, t0.user_id AS user_id_13 FROM user_settings t0 WHERE t0.user_id = ?
Parameters:
[
  46
]
37 0.32 ms
SELECT t0.id AS id_1, t0.registrar_server AS registrar_server_2, t0.registrar_port AS registrar_port_3, t0.extension_username AS extension_username_4, t0.encrypted_password AS encrypted_password_5, t0.display_name AS display_name_6, t0.is_active AS is_active_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.user_id AS user_id_10 FROM webphone_mapping t0 WHERE t0.user_id = ?
Parameters:
[
  46
]

Database Connections

Name Service
rw doctrine.dbal.rw_connection
ro doctrine.dbal.ro_connection

Entity Managers

Name Service
_defaults doctrine.orm._defaults_entity_manager
rw doctrine.orm.rw_entity_manager
ro doctrine.orm.ro_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

_defaults entity manager

Class Amount of managed objects

rw entity manager

Class Amount of managed objects
App\Entity\RW\User 18
App\Entity\UserSettings 14
App\Entity\RW\StoreCallCampaign 10
App\Entity\RW\WebPhoneMapping 7

ro entity manager

Class Amount of managed objects

Entities Mapping

_defaults entity manager

No loaded entities.

rw entity manager

Class Mapping errors
App\Entity\RW\User No errors.
App\Entity\UserSettings No errors.
App\Entity\RW\WebPhoneMapping No errors.
App\Entity\RW\MajusData No errors.
App\Entity\RW\TicketReplies No errors.
App\Entity\RW\Ticket No errors.
App\Entity\RW\StoreNote No errors.
App\Entity\RW\StoreCallCampaignAssignment No errors.
App\Entity\RW\StoreCallCampaign No errors.
App\Entity\RW\StoreCallScript No errors.
App\Entity\RW\StoreCallQuestionnaire No errors.
App\Entity\RW\StoreCallTarget No errors.

ro entity manager

No loaded entities.