https://czas.qsell.pl/

Query Metrics

1896 Database Queries
14 Different statements
700.22 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

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
  • The association App\Entity\User#tasks refers to the owning side field App\Entity\Task#user which does not exist.
App\Entity\Project No errors.
App\Entity\LoggedTime No errors.
App\Entity\Task
  • The mappings App\Entity\Task#users and App\Entity\User#tasks are inconsistent with each other.
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
  • The mappings App\Entity\RaportAds#raportAdsScreenshots and App\Entity\RaportAdsScreenshot#raportAds are inconsistent with each other.
App\Entity\AllegroDataAds No errors.
App\Entity\AllegroCostInfo No errors.
App\Entity\RaportDate No errors.