GET https://smartfactor.test.aspello.pl/panel/e-uslugi/3

Query Metrics

10 Database Queries
10 Different statements
10.09 ms Query time
0 Invalid entities
26 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
1.88 ms
(18.60%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.password_changed_at AS password_changed_at_4, t0.is_active AS is_active_5, t0.last_login_at AS last_login_at_6, t0.is_hidden AS is_hidden_7, t0.deleted_at AS deleted_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.first_name AS first_name_11, t0.last_name AS last_name_12, t0.phone AS phone_13, t0.role_id AS role_id_14, t0.deleted_by_id AS deleted_by_id_15, t0.created_by_id AS created_by_id_16, t0.updated_by_id AS updated_by_id_17 FROM app_user t0 WHERE t0.id = ?
Parameters:
[
  1
]
1.17 ms
(11.59%)
1
SELECT e0_.form AS form_0, COUNT(e0_.id) AS sclr_1 FROM e_service e0_ WHERE e0_.deleted_at IS NULL AND e0_.form IS NOT NULL AND e0_.id <> ? GROUP BY e0_.form
Parameters:
[
  3
]
1.14 ms
(11.30%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.card_number AS card_number_3, t0.summary AS summary_4, t0.description AS description_5, t0.fee AS fee_6, t0.resolution_term AS resolution_term_7, t0.fill_time AS fill_time_8, t0.form AS form_9, t0.published AS published_10, t0.featured AS featured_11, t0.position AS position_12, t0.deleted_at AS deleted_at_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.print_template_path AS print_template_path_16, t0.print_template_name AS print_template_name_17, t0.print_template_size AS print_template_size_18, t0.print_template_uploaded_at AS print_template_uploaded_at_19, t0.print_template_uploaded_by AS print_template_uploaded_by_20, t0.created_by_id AS created_by_id_21, t0.updated_by_id AS updated_by_id_22 FROM e_service t0 WHERE t0.id = ? AND t0.deleted_at IS NULL LIMIT 1
Parameters:
[
  3
]
1.08 ms
(10.69%)
1
SELECT t0.id AS id_1, t0.module AS module_2, t0.action AS action_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.role_id AS role_id_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM app_role_permission t0 WHERE t0.role_id = ?
Parameters:
[
  1
]
1.05 ms
(10.44%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.file_path AS file_path_6, t0.file_name AS file_name_7, t0.file_size AS file_size_8, t0.file_uploaded_at AS file_uploaded_at_9, t0.file_uploaded_by AS file_uploaded_by_10, t0.service_id AS service_id_11, t0.created_by_id AS created_by_id_12, t0.updated_by_id AS updated_by_id_13 FROM e_service_file t0 WHERE t0.service_id = ? ORDER BY t0.position ASC
Parameters:
[
  3
]
1.03 ms
(10.19%)
1
SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.required AS required_4, t0.multiple AS multiple_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.service_id AS service_id_8, t0.fee_id AS fee_id_9, t0.created_by_id AS created_by_id_10, t0.updated_by_id AS updated_by_id_11 FROM e_service_attachment t0 WHERE t0.service_id = ? ORDER BY t0.position ASC
Parameters:
[
  3
]
0.97 ms
(9.58%)
1
SELECT d0_.id AS id_0, d0_.active AS active_1, d0_.created_at AS created_at_2, d0_.updated_at AS updated_at_3, d0_.name AS name_4, d0_.work_name AS work_name_5, d0_.any_amount AS any_amount_6, d0_.amount AS amount_7, d0_.account AS account_8, d0_.multiple AS multiple_9, d0_.extra_field AS extra_field_10, d0_.created_by_id AS created_by_id_11, d0_.updated_by_id AS updated_by_id_12 FROM dict_fee d0_ WHERE d0_.active = true ORDER BY d0_.name ASC
Parameters:
[]
0.74 ms
(7.36%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.is_administrator AS is_administrator_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by_id AS created_by_id_7, t0.updated_by_id AS updated_by_id_8 FROM app_role t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.71 ms
(7.07%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.value AS value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by_id AS created_by_id_6, t0.updated_by_id AS updated_by_id_7 FROM app_setting t0
Parameters:
[]
0.32 ms
(3.19%)
1
SET TIME ZONE 'Europe/Warsaw'
Parameters:
[]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
Aspello\ModularAppBase\Settings\Entity\Setting 16
App\Module\Dictionaries\Entity\Fee 5
App\Module\Users\Entity\User 2
Aspello\ModularAppBase\User\Entity\Role 1
App\Module\EServices\Entity\EService 1
App\Module\EServices\Entity\EServiceAttachment 1