Query Metrics

4 Database Queries
4 Different statements
5.60 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.07 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.data AS data_2, t0.date AS date_3, t0.project_id AS project_id_4 FROM allegro_data_ads t0 WHERE t0.project_id = ?
Parameters:
[
  483
]
1.23 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:
[
  494
]
0.65 ms
(0.00%)
1
SELECT t0.id AS id_1, t0.date_from AS date_from_2, t0.date_to AS date_to_3, t0.content AS content_4, t0.monthly AS monthly_5, t0.account AS account_6, t0.type_graphic_statistic AS type_graphic_statistic_7, t0.type_statistic AS type_statistic_8, t0.project_id AS project_id_9 FROM raport_ads_new t0 WHERE t0.id = ?
Parameters:
[
  "15037"
]
0.65 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.id = ?
Parameters:
[
  "483"
]

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\OfferPackage No errors.
App\Entity\MaxTimeProject No errors.
App\Entity\RaportAds
  • The mappings App\Entity\RaportAds#raportAdsScreenshots and App\Entity\RaportAdsScreenshot#raportAds are inconsistent with each other.
App\Entity\ProjectOfferPackage No errors.
App\Entity\AllegroDataAds No errors.
App\Entity\RaportAdsNew No errors.
App\Entity\AllegroCostInfo No errors.
App\Entity\OfferPackageTask No errors.
App\Entity\RaportDate No errors.