Query Metrics
582
Database Queries
11
Different statements
596.48 ms
Query time
3
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.88 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.toggl_token AS toggl_token_6, t0.color AS color_7, t0.slack_channel_id AS slack_channel_id_8, t0.g_calendar_id AS g_calendar_id_9, t0.slack_private_channel_id AS slack_private_channel_id_10, t0.phone_number AS phone_number_11, t0.time_multiplier AS time_multiplier_12, t0.deactivated AS deactivated_13, t0.avatar AS avatar_14, t0.position AS position_15, t0.report_work AS report_work_16, t0.type AS type_17 FROM user t0 WHERE t0.email = ? LIMIT 1
Parameters:
[
"oskar@qsell.pl"
]
|
2 | 4.35 ms |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.description AS description_2, p0_.price AS price_3, p0_.description_for_user AS description_for_user_4, p0_.slack_channel_id AS slack_channel_id_5, p0_.number_allegro_account AS number_allegro_account_6, p0_.type AS type_7, p0_.client_slack_channel_id AS client_slack_channel_id_8, p0_.allegro_account AS allegro_account_9, p0_.want_return AS want_return_10, p0_.ads_budget AS ads_budget_11, p0_.category AS category_12, p0_.leader_id AS leader_id_13, p0_.offer_package_id AS offer_package_id_14 FROM project p0_ INNER JOIN project_user p2_ ON p0_.id = p2_.project_id INNER JOIN user u1_ ON u1_.id = p2_.user_id AND (u1_.id = ?) WHERE p0_.category = ? ORDER BY p0_.name ASC
Parameters:
[ 4 1 ] |
3 | 3.90 ms |
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.name AS name_4, u0_.toggl_token AS toggl_token_5, u0_.color AS color_6, u0_.slack_channel_id AS slack_channel_id_7, u0_.g_calendar_id AS g_calendar_id_8, u0_.slack_private_channel_id AS slack_private_channel_id_9, u0_.phone_number AS phone_number_10, u0_.time_multiplier AS time_multiplier_11, u0_.deactivated AS deactivated_12, u0_.avatar AS avatar_13, u0_.position AS position_14, u0_.report_work AS report_work_15, u0_.type AS type_16 FROM user u0_ WHERE u0_.roles LIKE ?
Parameters:
[
"%ROLE_EMPLOYER%"
]
|
4 | 3.23 ms |
SELECT w0_.id AS id_0, w0_.start_time AS start_time_1, w0_.stop_time AS stop_time_2, w0_.viewed AS viewed_3, w0_.user_id AS user_id_4 FROM work w0_ WHERE w0_.user_id = ? AND w0_.start_time >= ? AND w0_.start_time <= ?
Parameters:
[ 4 "2024-09-29 00:00:00" "2024-09-29 23:59:59" ] |
5 | 0.39 ms |
SELECT w0_.id AS id_0, w0_.start_time AS start_time_1, w0_.stop_time AS stop_time_2, w0_.viewed AS viewed_3, w0_.user_id AS user_id_4 FROM work w0_ WHERE w0_.user_id = ? AND w0_.start_time >= ? AND w0_.start_time <= ?
Parameters:
[ 4 "2024-09-29 00:00:00" "2024-09-29 23:59:59" ] |
6 | 0.38 ms |
SELECT w0_.id AS id_0, w0_.start_time AS start_time_1, w0_.stop_time AS stop_time_2, w0_.viewed AS viewed_3, w0_.user_id AS user_id_4 FROM work w0_ WHERE w0_.user_id = ? AND w0_.start_time >= ? AND w0_.start_time <= ?
Parameters:
[ 4 "2024-09-29 00:00:00" "2024-09-29 23:59:59" ] |
7 | 0.45 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.max_excluded_time AS max_excluded_time_5 FROM offer_package t0 WHERE t0.id = ?
Parameters:
[
6
]
|
8 | 2.29 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 217 "2024-09-01 00:00:00" "2024-09-30 20:14:12" ] |
9 | 2.60 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:12" 217 ] |
10 | 3.71 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 217 ] |
11 | 0.38 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 217 ] |
12 | 7.31 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 217 "09" "2024" ] |
13 | 1.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.repeat_in_month AS repeat_in_month_4, t0.basic AS basic_5, t0.disabled AS disabled_6 FROM offer_package_task t0 INNER JOIN offer_package_offer_package_task ON t0.id = offer_package_offer_package_task.offer_package_task_id WHERE offer_package_offer_package_task.offer_package_id = ?
Parameters:
[
6
]
|
14 | 0.34 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.max_excluded_time AS max_excluded_time_5 FROM offer_package t0 WHERE t0.id = ?
Parameters:
[
15
]
|
15 | 1.31 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 97 "2024-09-01 00:00:00" "2024-09-30 20:14:12" ] |
16 | 13.46 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:12" 97 ] |
17 | 6.36 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 97 ] |
18 | 0.41 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 97 ] |
19 | 7.41 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 97 "09" "2024" ] |
20 | 0.70 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.repeat_in_month AS repeat_in_month_4, t0.basic AS basic_5, t0.disabled AS disabled_6 FROM offer_package_task t0 INNER JOIN offer_package_offer_package_task ON t0.id = offer_package_offer_package_task.offer_package_task_id WHERE offer_package_offer_package_task.offer_package_id = ?
Parameters:
[
15
]
|
21 | 0.69 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 534 "2024-09-01 00:00:00" "2024-09-30 20:14:12" ] |
22 | 0.85 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:12" 534 ] |
23 | 1.03 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 534 ] |
24 | 0.29 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 534 ] |
25 | 1.67 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 534 "09" "2024" ] |
26 | 0.37 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.max_excluded_time AS max_excluded_time_5 FROM offer_package t0 WHERE t0.id = ?
Parameters:
[
88
]
|
27 | 0.76 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 470 "2024-09-01 00:00:00" "2024-09-30 20:14:12" ] |
28 | 0.60 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:12" 470 ] |
29 | 1.49 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 470 ] |
30 | 0.28 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 470 ] |
31 | 2.07 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 470 "09" "2024" ] |
32 | 1.18 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.repeat_in_month AS repeat_in_month_4, t0.basic AS basic_5, t0.disabled AS disabled_6 FROM offer_package_task t0 INNER JOIN offer_package_offer_package_task ON t0.id = offer_package_offer_package_task.offer_package_task_id WHERE offer_package_offer_package_task.offer_package_id = ?
Parameters:
[
88
]
|
33 | 0.43 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.max_excluded_time AS max_excluded_time_5 FROM offer_package t0 WHERE t0.id = ?
Parameters:
[
37
]
|
34 | 0.82 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 106 "2024-09-01 00:00:00" "2024-09-30 20:14:12" ] |
35 | 0.80 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:12" 106 ] |
36 | 0.31 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 106 ] |
37 | 0.30 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 106 ] |
38 | 2.75 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 106 "09" "2024" ] |
39 | 0.99 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.repeat_in_month AS repeat_in_month_4, t0.basic AS basic_5, t0.disabled AS disabled_6 FROM offer_package_task t0 INNER JOIN offer_package_offer_package_task ON t0.id = offer_package_offer_package_task.offer_package_task_id WHERE offer_package_offer_package_task.offer_package_id = ?
Parameters:
[
37
]
|
40 | 0.92 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 51 "2024-09-01 00:00:00" "2024-09-30 20:14:12" ] |
41 | 4.58 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:12" 51 ] |
42 | 1.17 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 51 ] |
43 | 0.32 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 51 ] |
44 | 2.45 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 51 "09" "2024" ] |
45 | 1.06 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 173 "2024-09-01 00:00:00" "2024-09-30 20:14:12" ] |
46 | 0.72 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:12" 173 ] |
47 | 1.50 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 173 ] |
48 | 0.45 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 173 ] |
49 | 3.54 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 173 "09" "2024" ] |
50 | 0.48 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.max_excluded_time AS max_excluded_time_5 FROM offer_package t0 WHERE t0.id = ?
Parameters:
[
7
]
|
51 | 1.17 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 77 "2024-09-01 00:00:00" "2024-09-30 20:14:12" ] |
52 | 4.65 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:12" 77 ] |
53 | 2.79 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 77 ] |
54 | 0.34 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 77 ] |
55 | 1.11 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 77 "09" "2024" ] |
56 | 0.32 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.repeat_in_month AS repeat_in_month_4, t0.basic AS basic_5, t0.disabled AS disabled_6 FROM offer_package_task t0 INNER JOIN offer_package_offer_package_task ON t0.id = offer_package_offer_package_task.offer_package_task_id WHERE offer_package_offer_package_task.offer_package_id = ?
Parameters:
[
7
]
|
57 | 0.98 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 160 "2024-09-01 00:00:00" "2024-09-30 20:14:12" ] |
58 | 0.69 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:12" 160 ] |
59 | 1.58 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 160 ] |
60 | 0.26 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 160 ] |
61 | 0.91 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 160 "09" "2024" ] |
62 | 0.77 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 289 "2024-09-01 00:00:00" "2024-09-30 20:14:12" ] |
63 | 1.38 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:12" 289 ] |
64 | 1.08 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 289 ] |
65 | 0.28 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 289 ] |
66 | 4.42 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 289 "09" "2024" ] |
67 | 0.91 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 535 "2024-09-01 00:00:00" "2024-09-30 20:14:12" ] |
68 | 0.59 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:12" 535 ] |
69 | 0.94 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 535 ] |
70 | 0.26 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 535 ] |
71 | 0.73 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 535 "09" "2024" ] |
72 | 0.92 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.max_excluded_time AS max_excluded_time_5 FROM offer_package t0 WHERE t0.id = ?
Parameters:
[
63
]
|
73 | 0.88 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 177 "2024-09-01 00:00:00" "2024-09-30 20:14:12" ] |
74 | 0.72 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:12" 177 ] |
75 | 1.44 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 177 ] |
76 | 0.30 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 177 ] |
77 | 1.09 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 177 "09" "2024" ] |
78 | 1.03 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.repeat_in_month AS repeat_in_month_4, t0.basic AS basic_5, t0.disabled AS disabled_6 FROM offer_package_task t0 INNER JOIN offer_package_offer_package_task ON t0.id = offer_package_offer_package_task.offer_package_task_id WHERE offer_package_offer_package_task.offer_package_id = ?
Parameters:
[
63
]
|
79 | 0.94 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 11 "2024-09-01 00:00:00" "2024-09-30 20:14:12" ] |
80 | 5.63 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:12" 11 ] |
81 | 1.85 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 11 ] |
82 | 0.35 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 11 ] |
83 | 2.81 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 11 "09" "2024" ] |
84 | 1.16 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 234 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
85 | 0.73 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 234 ] |
86 | 1.65 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 234 ] |
87 | 0.51 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 234 ] |
88 | 2.63 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 234 "09" "2024" ] |
89 | 0.74 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.max_excluded_time AS max_excluded_time_5 FROM offer_package t0 WHERE t0.id = ?
Parameters:
[
14
]
|
90 | 0.99 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.toggl_token AS toggl_token_6, t0.color AS color_7, t0.slack_channel_id AS slack_channel_id_8, t0.g_calendar_id AS g_calendar_id_9, t0.slack_private_channel_id AS slack_private_channel_id_10, t0.phone_number AS phone_number_11, t0.time_multiplier AS time_multiplier_12, t0.deactivated AS deactivated_13, t0.avatar AS avatar_14, t0.position AS position_15, t0.report_work AS report_work_16, t0.type AS type_17 FROM user t0 WHERE t0.id = ?
Parameters:
[
3
]
|
91 | 1.05 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 21 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
92 | 1.89 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 21 ] |
93 | 1.36 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 21 ] |
94 | 0.34 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 21 ] |
95 | 1.10 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 21 "09" "2024" ] |
96 | 0.87 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.repeat_in_month AS repeat_in_month_4, t0.basic AS basic_5, t0.disabled AS disabled_6 FROM offer_package_task t0 INNER JOIN offer_package_offer_package_task ON t0.id = offer_package_offer_package_task.offer_package_task_id WHERE offer_package_offer_package_task.offer_package_id = ?
Parameters:
[
14
]
|
97 | 0.99 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 304 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
98 | 0.83 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 304 ] |
99 | 2.69 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 304 ] |
100 | 0.37 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 304 ] |
101 | 1.85 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 304 "09" "2024" ] |
102 | 1.15 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 58 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
103 | 1.52 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 58 ] |
104 | 0.93 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 58 ] |
105 | 0.36 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 58 ] |
106 | 0.94 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 58 "09" "2024" ] |
107 | 0.97 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 18 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
108 | 0.97 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 18 ] |
109 | 0.96 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 9 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
110 | 2.30 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 9 ] |
111 | 1.46 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 9 ] |
112 | 0.41 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 9 ] |
113 | 1.60 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 9 "09" "2024" ] |
114 | 0.99 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 42 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
115 | 1.27 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 42 ] |
116 | 1.19 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 42 ] |
117 | 0.33 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 42 ] |
118 | 0.89 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 42 "09" "2024" ] |
119 | 0.86 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 427 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
120 | 0.68 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 427 ] |
121 | 1.60 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 427 ] |
122 | 1.66 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 427 ] |
123 | 2.29 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 427 "09" "2024" ] |
124 | 0.92 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 467 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
125 | 0.66 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 467 ] |
126 | 0.90 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 467 ] |
127 | 0.32 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 467 ] |
128 | 0.76 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 467 "09" "2024" ] |
129 | 0.87 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 423 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
130 | 0.82 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 423 ] |
131 | 1.90 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 423 ] |
132 | 0.31 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 423 ] |
133 | 0.90 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 423 "09" "2024" ] |
134 | 1.01 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 419 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
135 | 0.79 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 419 ] |
136 | 0.87 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 419 ] |
137 | 0.34 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 419 ] |
138 | 1.13 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 419 "09" "2024" ] |
139 | 1.28 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 291 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
140 | 0.75 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 291 ] |
141 | 1.81 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 291 ] |
142 | 0.34 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 291 ] |
143 | 0.87 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 291 "09" "2024" ] |
144 | 0.92 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 71 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
145 | 0.89 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 71 ] |
146 | 0.83 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 303 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
147 | 0.64 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 303 ] |
148 | 1.64 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 303 ] |
149 | 0.32 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 303 ] |
150 | 1.01 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 303 "09" "2024" ] |
151 | 0.89 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 25 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
152 | 1.21 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 25 ] |
153 | 1.12 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 25 ] |
154 | 0.27 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 25 ] |
155 | 1.21 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 25 "09" "2024" ] |
156 | 0.28 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.max_excluded_time AS max_excluded_time_5 FROM offer_package t0 WHERE t0.id = ?
Parameters:
[
125
]
|
157 | 0.67 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 598 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
158 | 0.59 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 598 ] |
159 | 0.71 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 598 ] |
160 | 0.25 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 598 ] |
161 | 0.58 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 598 "09" "2024" ] |
162 | 1.00 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.repeat_in_month AS repeat_in_month_4, t0.basic AS basic_5, t0.disabled AS disabled_6 FROM offer_package_task t0 INNER JOIN offer_package_offer_package_task ON t0.id = offer_package_offer_package_task.offer_package_task_id WHERE offer_package_offer_package_task.offer_package_id = ?
Parameters:
[
125
]
|
163 | 0.79 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 199 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
164 | 0.51 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 199 ] |
165 | 0.92 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 199 ] |
166 | 0.29 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 199 ] |
167 | 0.72 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 199 "09" "2024" ] |
168 | 0.48 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.max_excluded_time AS max_excluded_time_5 FROM offer_package t0 WHERE t0.id = ?
Parameters:
[
35
]
|
169 | 0.64 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 165 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
170 | 0.54 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 165 ] |
171 | 1.07 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 165 ] |
172 | 0.27 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 165 ] |
173 | 0.72 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 165 "09" "2024" ] |
174 | 0.64 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.repeat_in_month AS repeat_in_month_4, t0.basic AS basic_5, t0.disabled AS disabled_6 FROM offer_package_task t0 INNER JOIN offer_package_offer_package_task ON t0.id = offer_package_offer_package_task.offer_package_task_id WHERE offer_package_offer_package_task.offer_package_id = ?
Parameters:
[
35
]
|
175 | 0.81 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 288 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
176 | 0.60 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 288 ] |
177 | 0.62 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 288 ] |
178 | 0.29 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 288 ] |
179 | 0.73 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 288 "09" "2024" ] |
180 | 0.70 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 69 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
181 | 0.86 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 69 ] |
182 | 0.74 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 69 ] |
183 | 0.27 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 69 ] |
184 | 0.79 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 69 "09" "2024" ] |
185 | 0.70 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 15 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
186 | 1.05 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 15 ] |
187 | 0.79 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 15 ] |
188 | 0.45 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 15 ] |
189 | 0.78 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 15 "09" "2024" ] |
190 | 0.32 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.max_excluded_time AS max_excluded_time_5 FROM offer_package t0 WHERE t0.id = ?
Parameters:
[
30
]
|
191 | 0.73 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 157 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
192 | 0.68 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 157 ] |
193 | 2.95 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 157 ] |
194 | 0.36 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 157 ] |
195 | 0.77 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 157 "09" "2024" ] |
196 | 1.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.repeat_in_month AS repeat_in_month_4, t0.basic AS basic_5, t0.disabled AS disabled_6 FROM offer_package_task t0 INNER JOIN offer_package_offer_package_task ON t0.id = offer_package_offer_package_task.offer_package_task_id WHERE offer_package_offer_package_task.offer_package_id = ?
Parameters:
[
30
]
|
197 | 0.72 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 202 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
198 | 0.62 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 202 ] |
199 | 1.07 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 202 ] |
200 | 0.36 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 202 ] |
201 | 0.95 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 202 "09" "2024" ] |
202 | 0.85 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 253 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
203 | 0.74 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 253 ] |
204 | 3.47 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 253 ] |
205 | 0.37 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 253 ] |
206 | 0.94 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 253 "09" "2024" ] |
207 | 0.87 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 414 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
208 | 0.77 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 414 ] |
209 | 1.12 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 414 ] |
210 | 0.28 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 414 ] |
211 | 0.77 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 414 "09" "2024" ] |
212 | 1.03 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 279 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
213 | 0.74 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 279 ] |
214 | 2.77 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 279 ] |
215 | 0.36 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 279 ] |
216 | 1.08 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 279 "09" "2024" ] |
217 | 0.43 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.max_excluded_time AS max_excluded_time_5 FROM offer_package t0 WHERE t0.id = ?
Parameters:
[
20
]
|
218 | 0.99 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 211 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
219 | 0.78 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 211 ] |
220 | 1.37 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 211 ] |
221 | 0.36 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 211 ] |
222 | 1.02 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 211 "09" "2024" ] |
223 | 0.92 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.repeat_in_month AS repeat_in_month_4, t0.basic AS basic_5, t0.disabled AS disabled_6 FROM offer_package_task t0 INNER JOIN offer_package_offer_package_task ON t0.id = offer_package_offer_package_task.offer_package_task_id WHERE offer_package_offer_package_task.offer_package_id = ?
Parameters:
[
20
]
|
224 | 0.38 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.max_excluded_time AS max_excluded_time_5 FROM offer_package t0 WHERE t0.id = ?
Parameters:
[
75
]
|
225 | 0.86 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 273 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
226 | 3.80 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 273 ] |
227 | 5.47 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 273 ] |
228 | 0.48 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 273 ] |
229 | 1.13 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 273 "09" "2024" ] |
230 | 0.92 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.repeat_in_month AS repeat_in_month_4, t0.basic AS basic_5, t0.disabled AS disabled_6 FROM offer_package_task t0 INNER JOIN offer_package_offer_package_task ON t0.id = offer_package_offer_package_task.offer_package_task_id WHERE offer_package_offer_package_task.offer_package_id = ?
Parameters:
[
75
]
|
231 | 0.43 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.max_excluded_time AS max_excluded_time_5 FROM offer_package t0 WHERE t0.id = ?
Parameters:
[
126
]
|
232 | 1.26 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 525 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
233 | 0.89 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 525 ] |
234 | 1.57 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 525 ] |
235 | 0.34 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 525 ] |
236 | 0.84 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 525 "09" "2024" ] |
237 | 0.83 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.repeat_in_month AS repeat_in_month_4, t0.basic AS basic_5, t0.disabled AS disabled_6 FROM offer_package_task t0 INNER JOIN offer_package_offer_package_task ON t0.id = offer_package_offer_package_task.offer_package_task_id WHERE offer_package_offer_package_task.offer_package_id = ?
Parameters:
[
126
]
|
238 | 0.96 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 35 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
239 | 1.56 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 35 ] |
240 | 1.49 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 35 ] |
241 | 0.34 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 35 ] |
242 | 1.13 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 35 "09" "2024" ] |
243 | 0.89 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 613 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
244 | 0.68 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 613 ] |
245 | 0.90 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 613 ] |
246 | 0.35 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 613 ] |
247 | 1.14 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 613 "09" "2024" ] |
248 | 0.84 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 196 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
249 | 0.78 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 196 ] |
250 | 1.93 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 196 ] |
251 | 0.35 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 196 ] |
252 | 0.90 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 196 "09" "2024" ] |
253 | 0.89 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 522 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
254 | 0.66 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 522 ] |
255 | 0.40 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 522 ] |
256 | 0.43 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 522 ] |
257 | 0.73 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 522 "09" "2024" ] |
258 | 0.94 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 285 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
259 | 0.66 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 285 ] |
260 | 1.65 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 285 ] |
261 | 0.35 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 285 ] |
262 | 0.93 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 285 "09" "2024" ] |
263 | 0.78 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 588 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
264 | 0.66 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 588 ] |
265 | 0.69 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 588 ] |
266 | 0.34 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 588 ] |
267 | 0.62 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 588 "09" "2024" ] |
268 | 0.88 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 68 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
269 | 0.71 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 68 ] |
270 | 0.83 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 148 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
271 | 0.63 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 148 ] |
272 | 1.17 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 148 ] |
273 | 0.35 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 148 ] |
274 | 0.92 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 148 "09" "2024" ] |
275 | 1.36 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 297 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
276 | 1.22 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 297 ] |
277 | 2.01 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 297 ] |
278 | 0.36 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 297 ] |
279 | 0.88 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 297 "09" "2024" ] |
280 | 0.85 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 616 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
281 | 0.64 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 616 ] |
282 | 0.66 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 616 ] |
283 | 0.28 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 616 ] |
284 | 0.61 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 616 "09" "2024" ] |
285 | 0.72 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 7 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
286 | 2.09 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 7 ] |
287 | 1.32 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 7 ] |
288 | 0.36 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 7 ] |
289 | 0.82 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 7 "09" "2024" ] |
290 | 0.72 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 90 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
291 | 0.61 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 90 ] |
292 | 0.65 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 30 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
293 | 1.31 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 30 ] |
294 | 0.70 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 245 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
295 | 0.60 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 245 ] |
296 | 2.42 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 245 ] |
297 | 0.38 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 245 ] |
298 | 1.02 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 245 "09" "2024" ] |
299 | 1.02 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 120 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
300 | 1.22 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 120 ] |
301 | 2.04 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 120 ] |
302 | 0.34 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 120 ] |
303 | 0.91 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 120 "09" "2024" ] |
304 | 0.93 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 596 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
305 | 0.67 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 596 ] |
306 | 0.92 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 596 ] |
307 | 0.33 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 596 ] |
308 | 0.71 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 596 "09" "2024" ] |
309 | 0.98 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 292 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
310 | 0.83 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 292 ] |
311 | 2.32 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 292 ] |
312 | 0.50 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 292 ] |
313 | 1.32 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 292 "09" "2024" ] |
314 | 0.64 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.max_excluded_time AS max_excluded_time_5 FROM offer_package t0 WHERE t0.id = ?
Parameters:
[
92
]
|
315 | 1.29 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 219 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
316 | 0.87 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 219 ] |
317 | 1.74 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 219 ] |
318 | 6.92 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 219 ] |
319 | 1.19 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 219 "09" "2024" ] |
320 | 5.11 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.repeat_in_month AS repeat_in_month_4, t0.basic AS basic_5, t0.disabled AS disabled_6 FROM offer_package_task t0 INNER JOIN offer_package_offer_package_task ON t0.id = offer_package_offer_package_task.offer_package_task_id WHERE offer_package_offer_package_task.offer_package_id = ?
Parameters:
[
92
]
|
321 | 0.96 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 634 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
322 | 0.61 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 634 ] |
323 | 0.57 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 634 ] |
324 | 0.34 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 634 ] |
325 | 0.58 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 634 "09" "2024" ] |
326 | 0.50 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.max_excluded_time AS max_excluded_time_5 FROM offer_package t0 WHERE t0.id = ?
Parameters:
[
50
]
|
327 | 0.71 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 229 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
328 | 0.68 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 229 ] |
329 | 1.00 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 229 ] |
330 | 0.32 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 229 ] |
331 | 0.62 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 229 "09" "2024" ] |
332 | 0.83 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.repeat_in_month AS repeat_in_month_4, t0.basic AS basic_5, t0.disabled AS disabled_6 FROM offer_package_task t0 INNER JOIN offer_package_offer_package_task ON t0.id = offer_package_offer_package_task.offer_package_task_id WHERE offer_package_offer_package_task.offer_package_id = ?
Parameters:
[
50
]
|
333 | 0.60 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 31 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
334 | 0.85 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 31 ] |
335 | 0.76 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 31 ] |
336 | 0.30 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 31 ] |
337 | 0.53 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 31 "09" "2024" ] |
338 | 0.48 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 50 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
339 | 0.51 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 50 ] |
340 | 0.48 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 85 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
341 | 0.48 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 85 ] |
342 | 0.47 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 53 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
343 | 0.59 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 53 ] |
344 | 0.58 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 53 ] |
345 | 0.28 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 53 ] |
346 | 0.56 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 53 "09" "2024" ] |
347 | 0.46 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 298 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
348 | 0.43 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 298 ] |
349 | 0.68 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 298 ] |
350 | 0.28 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 298 ] |
351 | 0.52 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 298 "09" "2024" ] |
352 | 0.54 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 29 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
353 | 0.40 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 29 ] |
354 | 0.41 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.max_excluded_time AS max_excluded_time_5 FROM offer_package t0 WHERE t0.id = ?
Parameters:
[
8
]
|
355 | 0.97 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 429 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
356 | 0.67 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 429 ] |
357 | 1.09 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 429 ] |
358 | 0.33 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 429 ] |
359 | 0.68 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 429 "09" "2024" ] |
360 | 0.90 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.repeat_in_month AS repeat_in_month_4, t0.basic AS basic_5, t0.disabled AS disabled_6 FROM offer_package_task t0 INNER JOIN offer_package_offer_package_task ON t0.id = offer_package_offer_package_task.offer_package_task_id WHERE offer_package_offer_package_task.offer_package_id = ?
Parameters:
[
8
]
|
361 | 0.91 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 484 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
362 | 0.92 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 484 ] |
363 | 2.96 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 484 ] |
364 | 0.42 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 484 ] |
365 | 1.02 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 484 "09" "2024" ] |
366 | 0.89 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 459 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
367 | 0.66 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 459 ] |
368 | 0.94 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 459 ] |
369 | 0.31 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 459 ] |
370 | 0.76 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 459 "09" "2024" ] |
371 | 0.76 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 524 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
372 | 0.66 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 524 ] |
373 | 1.11 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 524 ] |
374 | 0.39 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 524 ] |
375 | 1.00 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 524 "09" "2024" ] |
376 | 1.05 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 551 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
377 | 0.69 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 551 ] |
378 | 0.82 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 551 ] |
379 | 0.35 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 551 ] |
380 | 0.68 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 551 "09" "2024" ] |
381 | 0.83 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 73 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
382 | 0.93 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 73 ] |
383 | 1.13 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 73 ] |
384 | 0.38 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 73 ] |
385 | 1.56 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 73 "09" "2024" ] |
386 | 1.04 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 501 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
387 | 0.67 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 501 ] |
388 | 0.83 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 501 ] |
389 | 0.34 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 501 ] |
390 | 0.76 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 501 "09" "2024" ] |
391 | 0.66 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.max_excluded_time AS max_excluded_time_5 FROM offer_package t0 WHERE t0.id = ?
Parameters:
[
41
]
|
392 | 0.88 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 61 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
393 | 1.20 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 61 ] |
394 | 0.98 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 61 ] |
395 | 0.36 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 61 ] |
396 | 0.87 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 61 "09" "2024" ] |
397 | 0.72 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.repeat_in_month AS repeat_in_month_4, t0.basic AS basic_5, t0.disabled AS disabled_6 FROM offer_package_task t0 INNER JOIN offer_package_offer_package_task ON t0.id = offer_package_offer_package_task.offer_package_task_id WHERE offer_package_offer_package_task.offer_package_id = ?
Parameters:
[
41
]
|
398 | 0.90 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 14 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
399 | 1.17 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 14 ] |
400 | 0.97 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 14 ] |
401 | 0.40 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 14 ] |
402 | 0.95 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 14 "09" "2024" ] |
403 | 0.84 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 301 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
404 | 0.59 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 301 ] |
405 | 1.08 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 301 ] |
406 | 0.32 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 301 ] |
407 | 0.71 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 301 "09" "2024" ] |
408 | 0.82 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 323 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
409 | 0.59 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 323 ] |
410 | 1.77 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 323 ] |
411 | 0.33 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 323 ] |
412 | 1.42 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 323 "09" "2024" ] |
413 | 0.55 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.max_excluded_time AS max_excluded_time_5 FROM offer_package t0 WHERE t0.id = ?
Parameters:
[
9
]
|
414 | 0.76 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 5 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
415 | 3.37 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 5 ] |
416 | 1.63 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 5 ] |
417 | 0.32 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 5 ] |
418 | 0.83 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 5 "09" "2024" ] |
419 | 1.03 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.repeat_in_month AS repeat_in_month_4, t0.basic AS basic_5, t0.disabled AS disabled_6 FROM offer_package_task t0 INNER JOIN offer_package_offer_package_task ON t0.id = offer_package_offer_package_task.offer_package_task_id WHERE offer_package_offer_package_task.offer_package_id = ?
Parameters:
[
9
]
|
420 | 0.68 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 22 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
421 | 0.78 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 22 ] |
422 | 0.59 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 22 ] |
423 | 0.34 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 22 ] |
424 | 0.76 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 22 "09" "2024" ] |
425 | 0.67 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 441 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
426 | 0.58 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 441 ] |
427 | 0.99 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 441 ] |
428 | 0.40 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 441 ] |
429 | 0.62 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 441 "09" "2024" ] |
430 | 0.48 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.max_excluded_time AS max_excluded_time_5 FROM offer_package t0 WHERE t0.id = ?
Parameters:
[
48
]
|
431 | 0.68 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 80 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
432 | 0.84 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 80 ] |
433 | 2.31 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 80 ] |
434 | 0.35 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 80 ] |
435 | 0.84 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 80 "09" "2024" ] |
436 | 0.62 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.repeat_in_month AS repeat_in_month_4, t0.basic AS basic_5, t0.disabled AS disabled_6 FROM offer_package_task t0 INNER JOIN offer_package_offer_package_task ON t0.id = offer_package_offer_package_task.offer_package_task_id WHERE offer_package_offer_package_task.offer_package_id = ?
Parameters:
[
48
]
|
437 | 0.76 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 41 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
438 | 0.67 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 41 ] |
439 | 0.67 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 41 ] |
440 | 0.30 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 41 ] |
441 | 0.92 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 41 "09" "2024" ] |
442 | 0.80 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 212 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
443 | 0.62 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 212 ] |
444 | 1.71 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 212 ] |
445 | 0.31 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 212 ] |
446 | 0.82 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 212 "09" "2024" ] |
447 | 0.79 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 168 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
448 | 0.63 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 168 ] |
449 | 0.90 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 168 ] |
450 | 0.33 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 168 ] |
451 | 0.76 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 168 "09" "2024" ] |
452 | 0.79 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 445 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
453 | 0.61 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 445 ] |
454 | 1.04 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 445 ] |
455 | 0.34 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 445 ] |
456 | 0.65 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 445 "09" "2024" ] |
457 | 0.74 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 302 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
458 | 0.68 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 302 ] |
459 | 1.02 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 302 ] |
460 | 0.37 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 302 ] |
461 | 0.74 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 302 "09" "2024" ] |
462 | 0.33 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.max_excluded_time AS max_excluded_time_5 FROM offer_package t0 WHERE t0.id = ?
Parameters:
[
53
]
|
463 | 0.81 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 231 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
464 | 0.78 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 231 ] |
465 | 1.56 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 231 ] |
466 | 0.36 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 231 ] |
467 | 0.84 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 231 "09" "2024" ] |
468 | 1.04 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.repeat_in_month AS repeat_in_month_4, t0.basic AS basic_5, t0.disabled AS disabled_6 FROM offer_package_task t0 INNER JOIN offer_package_offer_package_task ON t0.id = offer_package_offer_package_task.offer_package_task_id WHERE offer_package_offer_package_task.offer_package_id = ?
Parameters:
[
53
]
|
469 | 0.95 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 547 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
470 | 0.79 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 547 ] |
471 | 0.93 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 547 ] |
472 | 0.38 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 547 ] |
473 | 0.70 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 547 "09" "2024" ] |
474 | 0.91 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 422 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
475 | 0.66 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 422 ] |
476 | 1.03 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 422 ] |
477 | 0.49 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 422 ] |
478 | 0.77 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 422 "09" "2024" ] |
479 | 0.91 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 48 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
480 | 1.00 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 48 ] |
481 | 0.89 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 420 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
482 | 0.83 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 420 ] |
483 | 1.19 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 420 ] |
484 | 0.46 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 420 ] |
485 | 0.89 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 420 "09" "2024" ] |
486 | 0.80 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 300 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
487 | 1.12 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 300 ] |
488 | 1.04 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 300 ] |
489 | 0.42 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 300 ] |
490 | 0.89 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 300 "09" "2024" ] |
491 | 1.06 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 294 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
492 | 0.89 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 294 ] |
493 | 1.23 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 294 ] |
494 | 0.58 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 294 ] |
495 | 1.17 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 294 "09" "2024" ] |
496 | 0.81 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 461 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
497 | 0.65 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 461 ] |
498 | 1.27 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 461 ] |
499 | 0.37 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 461 ] |
500 | 0.90 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 461 "09" "2024" ] |
501 | 0.97 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 398 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
502 | 0.73 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 398 ] |
503 | 1.47 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 398 ] |
504 | 0.34 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 398 ] |
505 | 1.51 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 398 "09" "2024" ] |
506 | 1.22 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 170 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
507 | 0.89 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 170 ] |
508 | 2.56 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 170 ] |
509 | 0.61 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 170 ] |
510 | 1.36 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 170 "09" "2024" ] |
511 | 0.70 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.max_excluded_time AS max_excluded_time_5 FROM offer_package t0 WHERE t0.id = ?
Parameters:
[
87
]
|
512 | 1.34 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 293 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
513 | 0.73 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 293 ] |
514 | 1.29 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 293 ] |
515 | 0.49 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 293 ] |
516 | 0.96 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 293 "09" "2024" ] |
517 | 1.22 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.repeat_in_month AS repeat_in_month_4, t0.basic AS basic_5, t0.disabled AS disabled_6 FROM offer_package_task t0 INNER JOIN offer_package_offer_package_task ON t0.id = offer_package_offer_package_task.offer_package_task_id WHERE offer_package_offer_package_task.offer_package_id = ?
Parameters:
[
87
]
|
518 | 0.99 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 183 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
519 | 0.87 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 183 ] |
520 | 1.68 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 183 ] |
521 | 0.27 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 183 ] |
522 | 1.06 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 183 "09" "2024" ] |
523 | 0.75 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 655 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
524 | 0.63 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 655 ] |
525 | 0.80 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 655 ] |
526 | 0.29 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 655 ] |
527 | 1.23 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 655 "09" "2024" ] |
528 | 0.90 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 299 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
529 | 0.79 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 299 ] |
530 | 1.36 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 299 ] |
531 | 0.37 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 299 ] |
532 | 0.81 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 299 "09" "2024" ] |
533 | 0.81 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 515 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
534 | 0.61 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 515 ] |
535 | 1.32 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 515 ] |
536 | 0.38 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 515 ] |
537 | 0.71 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 515 "09" "2024" ] |
538 | 0.77 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 295 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
539 | 0.64 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 295 ] |
540 | 0.90 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 295 ] |
541 | 0.35 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 295 ] |
542 | 0.83 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 295 "09" "2024" ] |
543 | 0.81 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 110 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
544 | 0.78 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 110 ] |
545 | 1.60 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 110 ] |
546 | 0.43 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 110 ] |
547 | 0.92 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 110 "09" "2024" ] |
548 | 0.96 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 26 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
549 | 7.80 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 26 ] |
550 | 0.40 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 26 ] |
551 | 0.31 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 26 ] |
552 | 0.95 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 26 "09" "2024" ] |
553 | 0.88 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 47 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
554 | 1.16 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 47 ] |
555 | 0.91 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 47 ] |
556 | 0.31 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 47 ] |
557 | 1.03 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 47 "09" "2024" ] |
558 | 0.79 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 431 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
559 | 0.64 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 431 ] |
560 | 0.99 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 431 ] |
561 | 0.47 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 431 ] |
562 | 0.79 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 431 "09" "2024" ] |
563 | 1.17 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 34 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
564 | 1.09 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 34 ] |
565 | 0.65 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 34 ] |
566 | 0.43 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 34 ] |
567 | 0.82 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 34 "09" "2024" ] |
568 | 0.92 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 27 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
569 | 1.24 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 27 ] |
570 | 0.73 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 27 ] |
571 | 0.30 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 27 ] |
572 | 0.85 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 27 "09" "2024" ] |
573 | 0.82 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 574 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
574 | 1.25 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 574 ] |
575 | 1.32 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 574 ] |
576 | 0.45 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 574 ] |
577 | 1.06 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 574 "09" "2024" ] |
578 | 1.20 ms |
SELECT m0_.month_of_limit AS month_of_limit_0, m0_.hour_limit AS hour_limit_1 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.month_of_limit >= ? AND m0_.month_of_limit <= ? GROUP BY m0_.month_of_limit ORDER BY m0_.id DESC
Parameters:
[ 353 "2024-09-01 00:00:00" "2024-09-30 20:14:13" ] |
579 | 0.82 ms |
SELECT SUM(l0_.work_time) AS sclr_0 FROM logged_time l0_ WHERE l0_.created_at >= ? AND l0_.created_at <= ? AND l0_.project_id = ?
Parameters:
[ "2024-09-01 00:00:00" "2024-09-30 20:14:13" 353 ] |
580 | 1.95 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 353 ] |
581 | 0.42 ms |
SELECT count(t0_.id) AS sclr_0 FROM task t0_ WHERE MONTH(t0_.planned_on_day) = ? AND YEAR(t0_.planned_on_day) = ? AND t0_.project_id = ? AND t0_.offer_package_task_id IS NOT NULL LIMIT 1
Parameters:
[ "09" "2024" 353 ] |
582 | 1.65 ms |
SELECT p0_.id AS id_0, p0_.month AS month_1, p0_.data AS data_2, p0_.project_id AS project_id_3, p0_.offer_package_id AS offer_package_id_4 FROM project_offer_package p0_ WHERE p0_.project_id = ? AND MONTH(p0_.month) = ? AND YEAR(p0_.month) = ? LIMIT 1
Parameters:
[ 353 "09" "2024" ] |
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.
Entities Mapping
Class | Mapping errors |
---|---|
App\Entity\User |
|
App\Entity\Project | No errors. |
App\Entity\LoggedTime | No errors. |
App\Entity\Task |
|
App\Entity\Absence | No errors. |
App\Entity\TrainingMaterial | No errors. |
App\Entity\Work | No errors. |
App\Entity\Lead | No errors. |
App\Entity\MaxTimeProject | No errors. |
App\Entity\ProjectOfferPackage | No errors. |
App\Entity\OfferPackageTask | No errors. |
App\Entity\AllegroDataAds | No errors. |
App\Entity\AllegroCostInfo | No errors. |
App\Entity\RaportAds |
|
App\Entity\RaportDate | No errors. |
App\Entity\OfferPackage | No errors. |