https://asso-planner.la-lila.org/a-propos/

Query Metrics

8 Database Queries
7 Different statements
9.89 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
4.14 ms
(41.93%)
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
]
1.67 ms
(16.84%)
1
SELECT t0.content AS content_1, t0.id AS id_2, t0.deleted_at AS deleted_at_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.author_id AS author_id_6, t0.creator_id AS creator_id_7, t0.update_by_id AS update_by_id_8 FROM cms_content t0 WHERE t0.id = ?
Parameters:
[
  224
]
1.14 ms
(11.50%)
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:
[
  "/a-propos"
]
0.90 ms
(9.06%)
1
SELECT t0.position AS position_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.base_information_content AS base_information_content_5, t0.base_information_name AS base_information_name_6, t0.base_information_scheduled_published_date AS base_information_scheduled_published_date_7, t0.base_information_published_end AS base_information_published_end_8, t0.base_information_status AS base_information_status_9, t0.base_information_slug AS base_information_slug_10, t0.base_information_source AS base_information_source_11, t0.author_id AS author_id_12, t0.creator_id AS creator_id_13, t0.update_by_id AS update_by_id_14 FROM animation_group t0 INNER JOIN static_page_animation_group ON t0.id = static_page_animation_group.animation_group_id WHERE static_page_animation_group.static_page_id = ?
Parameters:
[
  4
]
0.89 ms
(8.97%)
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.59 ms
(5.96%)
1
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.57 ms
(5.73%)
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
]

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\Common\GlobalSettings No errors.
App\Entity\Company\Season No errors.
App\Entity\BaseInformation 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\Company\UserSeason No 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\Event\WorkshopGroup No errors.
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\Company\Contact 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\Company\UserBrandRole No errors.
App\Entity\CMS\CmsMainBlock No errors.
App\Entity\Image\Images No errors.
App\Entity\Image\ImageEntity No errors.
App\Entity\StaticPage No errors.
App\Entity\Common\AnimationGroup No errors.