22.91 ms
(41.69%)
|
11 |
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.middle_name AS middle_name_3, t0.last_name AS last_name_4, t0.gender AS gender_5, t0.location AS location_6, t0.phone AS phone_7, t0.login AS login_8, t0.password AS password_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.status AS status_12, t0.city_id AS city_id_13, t0.parking_id AS parking_id_14 FROM user t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.middle_name AS middle_name_3, t0.last_name AS last_name_4, t0.gender AS gender_5, t0.location AS location_6, t0.phone AS phone_7, t0.login AS login_8, t0.password AS password_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.status AS status_12, t0.city_id AS city_id_13, t0.parking_id AS parking_id_14 FROM user t0 WHERE t0.id = 12;
|
11.91 ms
(21.68%)
|
1 |
SELECT b0_.created_by_id AS sclr_0, COUNT(b0_.id) AS sclr_1, COALESCE(SUM(b0_.amount), 0) AS sclr_2, COALESCE(b0_.parking_id, t1_.parking_id) AS sclr_3, MAX(COALESCE(p2_.name, p3_.name)) AS sclr_4 FROM billet b0_ INNER JOIN user u4_ ON b0_.created_by_id = u4_.id LEFT JOIN terminal t1_ ON b0_.terminal_id = t1_.id LEFT JOIN parking p2_ ON b0_.parking_id = p2_.id LEFT JOIN parking p3_ ON t1_.parking_id = p3_.id WHERE b0_.created_at >= ? AND b0_.created_at < ? GROUP BY u4_.id, p2_.id, p3_.id
Parameters: [
"2026-07-02 00:00:00"
"2026-07-03 00:00:00"
]
SELECT b0_.created_by_id AS sclr_0, COUNT(b0_.id) AS sclr_1, COALESCE(SUM(b0_.amount), 0) AS sclr_2, COALESCE(b0_.parking_id, t1_.parking_id) AS sclr_3, MAX(COALESCE(p2_.name, p3_.name)) AS sclr_4 FROM billet b0_ INNER JOIN user u4_ ON b0_.created_by_id = u4_.id LEFT JOIN terminal t1_ ON b0_.terminal_id = t1_.id LEFT JOIN parking p2_ ON b0_.parking_id = p2_.id LEFT JOIN parking p3_ ON t1_.parking_id = p3_.id WHERE b0_.created_at >= '2026-07-02 00:00:00' AND b0_.created_at < '2026-07-03 00:00:00' GROUP BY u4_.id, p2_.id, p3_.id;
|
6.64 ms
(12.09%)
|
2 |
SELECT d0_.id AS id_0, d0_.report_date AS report_date_1, d0_.expected_amount AS expected_amount_2, d0_.reported_amount AS reported_amount_3, d0_.difference_amount AS difference_amount_4, d0_.ticket_count AS ticket_count_5, d0_.status AS status_6, d0_.workflow_status AS workflow_status_7, d0_.submitted_at AS submitted_at_8, d0_.notes AS notes_9, d0_.created_at AS created_at_10, d0_.updated_at AS updated_at_11, u1_.id AS id_12, u1_.first_name AS first_name_13, u1_.middle_name AS middle_name_14, u1_.last_name AS last_name_15, u1_.gender AS gender_16, u1_.location AS location_17, u1_.phone AS phone_18, u1_.login AS login_19, u1_.password AS password_20, u1_.roles AS roles_21, u1_.created_at AS created_at_22, u1_.status AS status_23, p2_.id AS id_24, p2_.code AS code_25, p2_.visible_roles AS visible_roles_26, p2_.name AS name_27, p2_.created_at AS created_at_28, d0_.agent_id AS agent_id_29, d0_.parking_id AS parking_id_30, u1_.city_id AS city_id_31, u1_.parking_id AS parking_id_32, p2_.created_by_id AS created_by_id_33, p2_.city_id AS city_id_34 FROM daily_report d0_ LEFT JOIN user u1_ ON d0_.agent_id = u1_.id LEFT JOIN parking p2_ ON d0_.parking_id = p2_.id WHERE d0_.report_date >= ? AND d0_.report_date < ? ORDER BY p2_.name ASC, u1_.first_name ASC, u1_.last_name ASC
Parameters: [
"2026-07-02 00:00:00"
"2026-07-03 00:00:00"
]
SELECT d0_.id AS id_0, d0_.report_date AS report_date_1, d0_.expected_amount AS expected_amount_2, d0_.reported_amount AS reported_amount_3, d0_.difference_amount AS difference_amount_4, d0_.ticket_count AS ticket_count_5, d0_.status AS status_6, d0_.workflow_status AS workflow_status_7, d0_.submitted_at AS submitted_at_8, d0_.notes AS notes_9, d0_.created_at AS created_at_10, d0_.updated_at AS updated_at_11, u1_.id AS id_12, u1_.first_name AS first_name_13, u1_.middle_name AS middle_name_14, u1_.last_name AS last_name_15, u1_.gender AS gender_16, u1_.location AS location_17, u1_.phone AS phone_18, u1_.login AS login_19, u1_.password AS password_20, u1_.roles AS roles_21, u1_.created_at AS created_at_22, u1_.status AS status_23, p2_.id AS id_24, p2_.code AS code_25, p2_.visible_roles AS visible_roles_26, p2_.name AS name_27, p2_.created_at AS created_at_28, d0_.agent_id AS agent_id_29, d0_.parking_id AS parking_id_30, u1_.city_id AS city_id_31, u1_.parking_id AS parking_id_32, p2_.created_by_id AS created_by_id_33, p2_.city_id AS city_id_34 FROM daily_report d0_ LEFT JOIN user u1_ ON d0_.agent_id = u1_.id LEFT JOIN parking p2_ ON d0_.parking_id = p2_.id WHERE d0_.report_date >= '2026-07-02 00:00:00' AND d0_.report_date < '2026-07-03 00:00:00' ORDER BY p2_.name ASC, u1_.first_name ASC, u1_.last_name ASC;
|
2.07 ms
(3.77%)
|
1 |
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.middle_name AS middle_name_3, t0.last_name AS last_name_4, t0.gender AS gender_5, t0.location AS location_6, t0.phone AS phone_7, t0.login AS login_8, t0.password AS password_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.status AS status_12, t0.city_id AS city_id_13, t0.parking_id AS parking_id_14 FROM user t0 WHERE t0.login = ? LIMIT 1
Parameters: [
"0899843151"
]
SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.middle_name AS middle_name_3, t0.last_name AS last_name_4, t0.gender AS gender_5, t0.location AS location_6, t0.phone AS phone_7, t0.login AS login_8, t0.password AS password_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.status AS status_12, t0.city_id AS city_id_13, t0.parking_id AS parking_id_14 FROM user t0 WHERE t0.login = '0899843151' LIMIT 1;
|