GET https://live.horai-software.com/ical/3b23bc8b3caad5020af0d9dc213d574391b0ba05736db3a91327bb7ed7a13583

Query Metrics

6 Database Queries
6 Different statements
3.40 ms Query time
4 Invalid entities
21 Managed entities

Queries

Group similar statements

# Time Info
1 0.99 ms
SELECT t0.id AS id_1, t0.creation_date AS creation_date_2, t0.statut AS statut_3, t0.title AS title_4, t0.path AS path_5, t0.seen AS seen_6, t0.user_id AS user_id_7, t0.from_user_id AS from_user_id_8 FROM notification t0 WHERE t0.path = ?
Parameters:
[
  "/ical/3b23bc8b3caad5020af0d9dc213d574391b0ba05736db3a91327bb7ed7a13583"
]
2 0.49 ms
SELECT t0.id AS id_1, t0.creation_date AS creation_date_2, t0.statut AS statut_3, t0.title AS title_4, t0.path AS path_5, t0.seen AS seen_6, t0.user_id AS user_id_7, t0.from_user_id AS from_user_id_8 FROM notification t0 WHERE t0.user_id IS NULL AND t0.statut = ?
Parameters:
[
  "unread"
]
3 0.44 ms
SELECT h0_.id AS id_0, h0_.title AS title_1, h0_.route AS route_2, h0_.content AS content_3, h0_.language AS language_4 FROM help_content h0_ WHERE ? LIKE CONCAT('%', h0_.route, '%')
Parameters:
[
  "https://live.horai-software.com/ical/3b23bc8b3caad5020af0d9dc213d574391b0ba05736db3a91327bb7ed7a13583"
]
4 0.35 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM cookie_category t0
Parameters:
[]
5 0.58 ms
SELECT t1.creation_date AS creation_date_2, t1.updated_date AS updated_date_3, t1.is_private AS is_private_4, t1.id AS id_5, t0.name AS name_6, t0.is_tutorial_done AS is_tutorial_done_7, t0.logo_name AS logo_name_8, t0.same_widget_for_all AS same_widget_for_all_9, t0.share_calendar AS share_calendar_10, t0.ical_sync_key AS ical_sync_key_11, t1.created_by_id AS created_by_id_12, t1.modified_by_id AS modified_by_id_13, t1.tenant_id AS tenant_id_14, t1.owner_id AS owner_id_15, t0.location_id AS location_id_16, t1.discr FROM company t0 INNER JOIN commentable t1 ON t0.id = t1.id WHERE t0.ical_sync_key = ? LIMIT 1
Parameters:
[
  "3b23bc8b3caad5020af0d9dc213d574391b0ba05736db3a91327bb7ed7a13583"
]
6 0.55 ms
SELECT a0_.creation_date AS creation_date_0, a0_.updated_date AS updated_date_1, a0_.is_private AS is_private_2, a0_.id AS id_3, a0_.start_date AS start_date_4, a0_.end_date AS end_date_5, a0_.name AS name_6, a0_.description AS description_7, a0_.all_day AS all_day_8, a0_.created_by_id AS created_by_id_9, a0_.modified_by_id AS modified_by_id_10, a0_.tenant_id AS tenant_id_11, a0_.owner_id AS owner_id_12 FROM appointment a0_ WHERE a0_.tenant_id = ? ORDER BY a0_.start_date ASC
Parameters:
[
  16
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
Prolyfix\CrmBundle\Entity\Appointment 18
App\Entity\Commentable 3

Entities Mapping

Class Mapping errors
App\Entity\Notification No errors.
App\Entity\TimeData No errors.
App\Entity\Commentable No errors.
App\Entity\User
  • The association App\Entity\User#timesheets refers to the owning side field Prolyfix\TimesheetBundle\Entity\Timesheet#user which does not exist.
  • The mappings App\Entity\User#commentables and App\Entity\Commentable#createdBy are inconsistent with each other.
  • The target entity 'App\Entity\TimeData' specified on App\Entity\User#timeData is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\HelpContent No errors.
Prolyfix\SymfonyCookieNotificationBundle\Entity\CookieCategory No errors.
App\Entity\Company
  • The association App\Entity\Company#moduleConfigurationValues refers to the owning side field App\Entity\Module\ModuleConfigurationValue#company which does not exist.
  • The target entity 'App\Entity\TimeData' specified on App\Entity\Company#timeData is a mapped superclass. This is not possible since there is no table that a foreign key could refer to.
App\Entity\Location No errors.
App\Entity\Comment
  • The mappings App\Entity\Comment#user and App\Entity\User#comments are inconsistent with each other.
App\Entity\Media No errors.
Prolyfix\TimesheetBundle\Entity\Timesheet
  • The mappings Prolyfix\TimesheetBundle\Entity\Timesheet#timesheets and Prolyfix\TimesheetBundle\Entity\Timesheet#commentable are inconsistent with each other.
App\Entity\Tag No errors.
Prolyfix\ProjectBundle\Entity\Project No errors.
Prolyfix\ProjectBundle\Entity\Task No errors.
Prolyfix\HolidayBundle\Entity\TypeOfAbsence No errors.
App\Entity\Module\ModuleConfigurationValue No errors.
App\Entity\Module\ModuleRight No errors.
App\Entity\WorkingGroup No errors.
Prolyfix\CrmBundle\Entity\Appointment No errors.