Query Metrics
5
Database Queries
5
Different statements
2.77 ms
Query time
0
Invalid entities
6
Managed entities
Queries
rw connection
| #▲ | Time | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.88 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.74 ms |
SELECT t0.id AS id_1, t0.operator_extension AS operator_extension_2, t0.started_at AS started_at_3, t0.completed_at AS completed_at_4, t0.call_answered_at AS call_answered_at_5, t0.manual_outcome AS manual_outcome_6, t0.notes AS notes_7, t0.callback_scheduled_at AS callback_scheduled_at_8, t0.threecx_call_id AS threecx_call_id_9, t0.cdr_verified AS cdr_verified_10, t0.cdr_match_status AS cdr_match_status_11, t0.cdr_duration_seconds AS cdr_duration_seconds_12, t0.cdr_disposition AS cdr_disposition_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.target_id AS target_id_16, t0.operator_user_id AS operator_user_id_17, t0.attempted_phone_record_id AS attempted_phone_record_id_18 FROM store_call_attempt t0 WHERE t0.id = ?
Parameters:
[
3686
]
|
||||||||||||||||||||||||||
| 3 | 0.43 ms |
"START TRANSACTION"
Parameters:
[]
|
||||||||||||||||||||||||||
| 4 | 0.54 ms |
UPDATE store_call_attempt SET call_answered_at = ?, updated_at = ? WHERE id = ?
Parameters:
[ "2026-05-08 03:02:46" "2026-05-08 03:02:46" 3686 ]
|
||||||||||||||||||||||||||
| 5 | 0.18 ms |
"COMMIT"
Parameters:
[]
|
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 | 1 |
| App\Entity\UserSettings | 1 |
| App\Entity\RW\WebPhoneMapping | 1 |
| App\Entity\RW\StoreCallAttempt | 1 |
| App\Entity\RW\StoreCallTarget | 1 |
| App\Entity\RW\StoreCallTargetPhone | 1 |
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\StoreCallAttempt | No errors. |
| App\Entity\RW\StoreCallTarget | No errors. |
| App\Entity\RW\StoreCallTargetPhone | No errors. |
| App\Entity\RW\StoreCallAnswer | No errors. |
ro entity manager
No loaded entities.