Query Metrics
1954
Database Queries
13
Different statements
713.97 ms
Query time
3
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
407.29 ms (0.00%) |
1256 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.description_for_user AS description_for_user_5, t0.slack_channel_id AS slack_channel_id_6, t0.number_allegro_account AS number_allegro_account_7, t0.type AS type_8, t0.client_slack_channel_id AS client_slack_channel_id_9, t0.allegro_account AS allegro_account_10, t0.want_return AS want_return_11, t0.ads_budget AS ads_budget_12, t0.category AS category_13, t0.leader_id AS leader_id_14, t0.offer_package_id AS offer_package_id_15 FROM project t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
2
]
|
199.67 ms (0.00%) |
628 |
SELECT m0_.hour_limit AS hour_limit_0 FROM project p1_ LEFT JOIN max_time_project m0_ ON p1_.id = m0_.project_id AND (m0_.project_id = ?) WHERE m0_.hour_limit IS NOT NULL ORDER BY m0_.id ASC LIMIT 1
Parameters:
[
2
]
|
49.90 ms (0.00%) |
40 |
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" 39 ] |
35.05 ms (0.00%) |
1 |
SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.content AS content_2, t0_.created_at AS created_at_3, t0_.updated_at AS updated_at_4, t0_.planned_on_day AS planned_on_day_5, t0_.status AS status_6, t0_.repeat_type AS repeat_type_7, t0_.completed_at AS completed_at_8, t0_.info AS info_9, t0_.graphic_url AS graphic_url_10, t0_.is_graphic AS is_graphic_11, t0_.project_id AS project_id_12, t0_.created_by_id AS created_by_id_13, t0_.offer_package_task_id AS offer_package_task_id_14 FROM task t0_ LEFT JOIN task_user t2_ ON t0_.id = t2_.task_id LEFT JOIN user u1_ ON u1_.id = t2_.user_id WHERE u1_.id = ? OR (u1_.id = ? AND t0_.repeat_type IS NOT NULL)
Parameters:
[ 91 91 ] |
4.77 ms (0.00%) |
3 |
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:
[ 91 "2024-09-29 00:00:00" "2024-09-29 23:59:59" ] |
4.43 ms (0.00%) |
15 |
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:
[
31
]
|
3.04 ms (0.00%) |
1 |
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_.type = 1 ORDER BY p0_.name ASC
Parameters:
[
91
]
|
2.66 ms (0.00%) |
1 |
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:
[
"rafal@qsell.pl"
]
|
2.48 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.description_for_user AS description_for_user_5, t0.slack_channel_id AS slack_channel_id_6, t0.number_allegro_account AS number_allegro_account_7, t0.type AS type_8, t0.client_slack_channel_id AS client_slack_channel_id_9, t0.allegro_account AS allegro_account_10, t0.want_return AS want_return_11, t0.ads_budget AS ads_budget_12, t0.category AS category_13, t0.leader_id AS leader_id_14, t0.offer_package_id AS offer_package_id_15 FROM project t0
Parameters:
[] |
1.87 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.price AS price_4, t0.description_for_user AS description_for_user_5, t0.slack_channel_id AS slack_channel_id_6, t0.number_allegro_account AS number_allegro_account_7, t0.type AS type_8, t0.client_slack_channel_id AS client_slack_channel_id_9, t0.allegro_account AS allegro_account_10, t0.want_return AS want_return_11, t0.ads_budget AS ads_budget_12, t0.category AS category_13, t0.leader_id AS leader_id_14, t0.offer_package_id AS offer_package_id_15 FROM project t0 WHERE t0.leader_id = ?
Parameters:
[
91
]
|
1.48 ms (0.00%) |
5 |
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:
[
76
]
|
0.79 ms (0.00%) |
1 |
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_ LEFT JOIN max_time_project m1_ ON p0_.id = m1_.project_id WHERE m1_.month_of_limit LIKE ? GROUP BY p0_.id
Parameters:
[
"2024-09-01"
]
|
0.55 ms (0.00%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM settings t0 WHERE t0.name = ? AND t0.value = ? LIMIT 1
Parameters:
[ "weekly" "2024-09-29 00:00:00" ] |
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\ProjectOfferPackage | No errors. |
App\Entity\OfferPackageTask | No errors. |
App\Entity\Settings | No errors. |
App\Entity\MaxTimeProject | No errors. |
App\Entity\OfferPackage | No errors. |
App\Entity\RaportAds |
|
App\Entity\AllegroDataAds | No errors. |
App\Entity\AllegroCostInfo | No errors. |
App\Entity\RaportDate | No errors. |