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 = ?
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 = 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
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 <> 3 GROUP BY e0_.form;
|
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
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 = 3 AND t0.deleted_at IS NULL LIMIT 1;
|
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 = ?
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 = 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
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 = 3 ORDER BY t0.position ASC;
|
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
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 = 3 ORDER BY t0.position ASC;
|
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
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;
|
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 = ?
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 = 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
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;
|
0.32 ms (3.19%)
|
1 |
SET TIME ZONE 'Europe/Warsaw'
SET TIME ZONE 'Europe/Warsaw';
|