Query Metrics
582
Database Queries
11
Different statements
596.48 ms
Query time
3
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
191.57 ms (0.00%) |
206 |
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 ] |
132.28 ms (0.00%) |
112 |
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 ] |
123.99 ms (0.00%) |
103 |
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" ] |
99.93 ms (0.00%) |
112 |
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" ] |
23.26 ms (0.00%) |
21 |
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
]
|
10.34 ms (0.00%) |
21 |
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
]
|
4.35 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_.category = ? ORDER BY p0_.name ASC
Parameters:
[ 4 1 ] |
4.00 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:
[ 4 "2024-09-29 00:00:00" "2024-09-29 23:59:59" ] |
3.90 ms (0.00%) |
1 |
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%"
]
|
1.88 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:
[
"oskar@qsell.pl"
]
|
0.99 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.id = ?
Parameters:
[
3
]
|
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. |