Query Metrics
1896
Database Queries
14
Different statements
700.22 ms
Query time
3
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
424.67 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
]
|
229.78 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
]
|
8.68 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"
]
|
6.35 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:
[
"doshop.business@gmail.com"
]
|
4.28 ms (0.00%) |
1 |
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
]
|
4.27 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-28 00:00:00" ] |
4.09 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_ WHERE (t0_.project_id IN (?) OR (t0_.project_id IN (?) AND t0_.repeat_type IS NOT NULL)) AND t0_.planned_on_day >= ? AND t0_.planned_on_day <= ?
Parameters:
[ [ 647 ] [ 647 ] "2024-09-28 00:00:00" "2024-09-28 23:59:00" ] |
3.96 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:
[] |
3.55 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 INNER JOIN project_user ON t0.id = project_user.user_id WHERE project_user.project_id = ?
Parameters:
[
647
]
|
3.00 ms (0.00%) |
1 |
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:
[ 647 "09" "2024" ] |
2.33 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 INNER JOIN client_project ON t0.id = client_project.project_id WHERE client_project.user_id = ?
Parameters:
[
651
]
|
2.18 ms (0.00%) |
1 |
SELECT r0_.id AS id_0, r0_.date AS date_1 FROM raport_date r0_ WHERE r0_.date >= ? ORDER BY r0_.date ASC LIMIT 1
Parameters:
[
"2024-09-28 00:00:00"
]
|
1.95 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.max_excluded_time AS max_excluded_time_5 FROM offer_package t0 WHERE t0.id = ?
Parameters:
[
88
]
|
1.13 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:
[
285
]
|
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. |