https://asso-planner.la-lila.org/android-chrome-192x192.png/

Query Metrics

11 Database Queries
8 Different statements
6.17 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
1.67 ms
(27.06%)
1
SELECT s0_.relative_url AS relative_url_0, s0_.short_description AS short_description_1, s0_.id AS id_2, s0_.deleted_at AS deleted_at_3, s0_.created_at AS created_at_4, s0_.updated_at AS updated_at_5, s0_.base_information_content AS base_information_content_6, s0_.base_information_name AS base_information_name_7, s0_.base_information_scheduled_published_date AS base_information_scheduled_published_date_8, s0_.base_information_published_end AS base_information_published_end_9, s0_.base_information_status AS base_information_status_10, s0_.base_information_slug AS base_information_slug_11, s0_.base_information_source AS base_information_source_12, s0_.parent_page_id AS parent_page_id_13, s0_.cms_content_id AS cms_content_id_14, s0_.author_id AS author_id_15, s0_.creator_id AS creator_id_16, s0_.update_by_id AS update_by_id_17 FROM static_page s0_ WHERE s0_.relative_url = ?
Parameters:
[
  "/android-chrome-192x192.png"
]
0.93 ms
(15.04%)
2
SELECT t0.roles AS roles_1, t0.id AS id_2, t0.brand_id AS brand_id_3, t0.user_id AS user_id_4 FROM user_brand_role t0 WHERE t0.user_id = ? AND t0.brand_id = ?
Parameters:
[
  174
  5
]
0.88 ms
(14.26%)
2
SELECT t0.name AS name_1, t0.value AS value_2, t0.id AS id_3 FROM global_settings t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "Maintenance"
]
0.78 ms
(12.69%)
2
SELECT s0_.name AS name_0, s0_.start_at AS start_at_1, s0_.end_at AS end_at_2, s0_.id AS id_3, s0_.deleted_at AS deleted_at_4, s0_.created_at AS created_at_5, s0_.updated_at AS updated_at_6, s0_.brand_id AS brand_id_7 FROM season s0_ INNER JOIN brand b1_ ON s0_.brand_id = b1_.id WHERE b1_.base_information_slug = 'defaut' LIMIT 1
Parameters:
[]
0.75 ms
(12.12%)
1
SELECT t0.is_active AS is_active_1, t0.username AS username_2, t0.user_token AS user_token_3, t0.user_token_type AS user_token_type_4, t0.email AS email_5, t0.password AS password_6, t0.roles AS roles_7, t0.surname AS surname_8, t0.short_description AS short_description_9, t0.slug AS slug_10, t0.test_user_type AS test_user_type_11, t0.id AS id_12, t0.deleted_at AS deleted_at_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.image_id AS image_id_16, t0.contact_id AS contact_id_17, t0.current_season_id AS current_season_id_18, t0.author_id AS author_id_19, t0.creator_id AS creator_id_20, t0.update_by_id AS update_by_id_21 FROM user t0 WHERE t0.id = ?
Parameters:
[
  174
]
0.46 ms
(7.46%)
1
SELECT t0.name AS name_1, t0.start_at AS start_at_2, t0.end_at AS end_at_3, t0.id AS id_4, t0.deleted_at AS deleted_at_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.brand_id AS brand_id_8, t9.common_password AS common_password_10, t9.slug AS slug_11, t9.id AS id_12, t9.deleted_at AS deleted_at_13, t9.created_at AS created_at_14, t9.updated_at AS updated_at_15, t9.season_id AS season_id_16, t9.author_id AS author_id_17, t9.creator_id AS creator_id_18, t9.update_by_id AS update_by_id_19 FROM season t0 LEFT JOIN seminar t9 ON t9.season_id = t0.id WHERE t0.id = ?
Parameters:
[
  14
]
0.41 ms
(6.60%)
1
SELECT t0.lang AS lang_1, t0.asso_planner_active AS asso_planner_active_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.base_information_content AS base_information_content_7, t0.base_information_name AS base_information_name_8, t0.base_information_scheduled_published_date AS base_information_scheduled_published_date_9, t0.base_information_published_end AS base_information_published_end_10, t0.base_information_status AS base_information_status_11, t0.base_information_slug AS base_information_slug_12, t0.base_information_source AS base_information_source_13, t0.address_id AS address_id_14, t0.cms_content_id AS cms_content_id_15, t0.author_id AS author_id_16, t0.creator_id AS creator_id_17, t0.update_by_id AS update_by_id_18 FROM brand t0 WHERE t0.id = ?
Parameters:
[
  8
]
0.29 ms
(4.77%)
1
SELECT t0.common_password AS common_password_1, t0.slug AS slug_2, t0.id AS id_3, t0.deleted_at AS deleted_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.season_id AS season_id_7, t0.author_id AS author_id_8, t0.creator_id AS creator_id_9, t0.update_by_id AS update_by_id_10 FROM seminar t0 WHERE t0.season_id = ?
Parameters:
[
  4
]

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 field App\Entity\User#userFinalEventSubscribes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\User\UserFinalEventSubscribe#user does not contain the required 'inversedBy="userFinalEventSubscribes"' attribute.
  • The mappings App\Entity\User#userEventGroupSubscribes and App\Entity\User\UserEventGroupSubscribe#user are inconsistent with each other.
  • The field App\Entity\User#userFinalEventGroupSubscribes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\User\UserFinalEventGroupSubscribe#user does not contain the required 'inversedBy="userFinalEventGroupSubscribes"' attribute.
  • The field App\Entity\User#userFinalWorkshopSubscribes is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\User\UserFinalWorkshopSubscribe#user does not contain the required 'inversedBy="userFinalWorkshopSubscribes"' attribute.
App\Entity\Image\Images No errors.
App\Entity\Image\ImageAvatar No errors.
App\Entity\Company\Contact No errors.
App\Entity\Company\Season No errors.
App\Entity\Company\UserSeason No errors.
App\Entity\Company\UserBrandRole No errors.
App\Entity\User\UserSubscribe No errors.
App\Entity\User\UserEventSubscribe No errors.
App\Entity\User\UserFinalEventSubscribe No errors.
App\Entity\User\UserEventGroupSubscribe No errors.
App\Entity\User\UserFinalEventGroupSubscribe No errors.
App\Entity\User\UserWorkshopSubscribe No errors.
App\Entity\User\UserFinalWorkshopSubscribe No errors.
App\Entity\BaseInformation No errors.
App\Entity\Event\WorkshopGroup No errors.
App\Entity\User\UserNetworkId No errors.
App\Entity\Event\Historic\Member No errors.
App\Entity\Event\Historic\StaffMember No errors.
App\Entity\Event\Historic\TeamMember No errors.
App\Entity\Common\GlobalSettings No errors.
App\Entity\Company\Brand
  • The mappings App\Entity\Company\Brand#apiUsers and App\Entity\User\ApiBrandUser#brand are inconsistent with each other.
App\Entity\Event\Seminar No errors.
App\Entity\Common\Address No errors.
App\Entity\CMS\CmsContent No errors.
App\Entity\User\ApiBrandUser
  • The association App\Entity\User\ApiBrandUser#brand refers to the inverse side field App\Entity\Company\Brand#apiUser which does not exist.
App\Entity\Company\BrandType No errors.
App\Entity\Event\EventSuperClass No errors.
App\Entity\Event\Event No errors.
App\Entity\Event\EventGroup No errors.
App\Entity\Event\Characteristic No errors.
App\Entity\Event\EventCharacteristic No errors.
App\Entity\CMS\CmsMainBlock No errors.
App\Entity\Image\ImageEntity No errors.
App\Entity\StaticPage No errors.