https://asso-planner.la-lila.org/evenement/changement-statut Return to referer URL

Query Metrics

16 Database Queries
15 Different statements
20.78 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 0.93 ms
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:
[
  388
]
2 0.89 ms
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"
]
3 0.78 ms
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
]
4 0.78 ms
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:
[
  388
  5
]
5 0.57 ms
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:
[]
6 0.34 ms
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
]
7 0.48 ms
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
]
8 0.53 ms
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:
[]
9 2.08 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.price_list AS price_list_3, t0.booking_link AS booking_link_4, t0.event_date AS event_date_5, t0.event_end_date AS event_end_date_6, t0.gauge_limitation AS gauge_limitation_7, t0.post_intended_show AS post_intended_show_8, t0.post_intended_show_date_start AS post_intended_show_date_start_9, t0.post_intended_show_date_end AS post_intended_show_date_end_10, t0.post_prevision_show AS post_prevision_show_11, t0.post_prevision_show_date_start AS post_prevision_show_date_start_12, t0.post_prevision_show_date_end AS post_prevision_show_date_end_13, t0.id AS id_14, t0.deleted_at AS deleted_at_15, t0.base_information_content AS base_information_content_16, t0.base_information_name AS base_information_name_17, t0.base_information_scheduled_published_date AS base_information_scheduled_published_date_18, t0.base_information_published_end AS base_information_published_end_19, t0.base_information_status AS base_information_status_20, t0.base_information_slug AS base_information_slug_21, t0.base_information_source AS base_information_source_22, t0.auditorium_id AS auditorium_id_23, t0.brand_id AS brand_id_24, t0.characteristic_id AS characteristic_id_25, t0.event_group_id AS event_group_id_26, t0.brand_guest_id AS brand_guest_id_27, t28.admin_token AS admin_token_29, t28.guest_token AS guest_token_30, t28.main_color AS main_color_31, t28.back_color AS back_color_32, t28.font_color AS font_color_33, t28.global_theme AS global_theme_34, t28.square_digit AS square_digit_35, t28.period_number AS period_number_36, t28.period_time AS period_time_37, t28.round_use_chrono AS round_use_chrono_38, t28.caucus_duration AS caucus_duration_39, t28.hymn_title AS hymn_title_40, t28.pause_duration AS pause_duration_41, t28.training_duration AS training_duration_42, t28.vote_title AS vote_title_43, t28.id AS id_44, t28.created_at AS created_at_45, t28.updated_at AS updated_at_46, t28.event_id AS event_id_47, t0.public_content_id AS public_content_id_48, t0.author_id AS author_id_49, t0.creator_id AS creator_id_50, t0.update_by_id AS update_by_id_51, t0.cms_description_id AS cms_description_id_52, t0.cms_organisation_id AS cms_organisation_id_53 FROM event t0 LEFT JOIN historic t28 ON t28.event_id = t0.id WHERE t0.id = ?
Parameters:
[
  "408"
]
10 1.61 ms
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.type AS type_3, t0.validate AS validate_4, t0.id AS id_5, t0.deleted_at AS deleted_at_6, t0.event_id AS event_id_7, t0.proposal_event_date_id AS proposal_event_date_id_8, t0.choice_id AS choice_id_9, t0.user_id AS user_id_10 FROM user_event_subscribe t0 WHERE t0.event_id = ? AND t0.type = ?
Parameters:
[
  408
  "INTENDED"
]
11 3.65 ms
SELECT t0.active AS active_1, t0.parameter_types AS parameter_types_2, t0.choice_types AS choice_types_3, t0.value AS value_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.id AS id_7, t0.deleted_at AS deleted_at_8, t0.brand_id AS brand_id_9 FROM event_parameters t0 WHERE t0.id = ?
Parameters:
[
  3
]
12 4.31 ms
SELECT t0.gauge AS gauge_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.base_information_content AS base_information_content_6, t0.base_information_name AS base_information_name_7, t0.base_information_scheduled_published_date AS base_information_scheduled_published_date_8, t0.base_information_published_end AS base_information_published_end_9, t0.base_information_status AS base_information_status_10, t0.base_information_slug AS base_information_slug_11, t0.base_information_source AS base_information_source_12, t0.brand_id AS brand_id_13, t0.address_id AS address_id_14, t0.cms_description_id AS cms_description_id_15, t0.cms_organisation_id AS cms_organisation_id_16, t0.author_id AS author_id_17, t0.creator_id AS creator_id_18, t0.update_by_id AS update_by_id_19 FROM auditorium t0 WHERE t0.id = ?
Parameters:
[
  14
]
13 1.28 ms
SELECT t0.id AS id_1, t0.event_id AS event_id_2, t0.proposal_event_date_id AS proposal_event_date_id_3, t0.post_id AS post_id_4 FROM post_intended_event t0 WHERE t0.event_id = ?
Parameters:
[
  408
]
14 0.35 ms
"START TRANSACTION"
Parameters:
[]
15 0.46 ms
DELETE FROM user_event_subscribe WHERE id = ?
Parameters:
[
  12726
]
16 1.73 ms
"COMMIT"
Parameters:
[]

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\Event\Auditorium No errors.
App\Entity\Event\Historic\Historic No errors.
App\Entity\Event\PostIntendedEvent No errors.
App\Entity\Event\PostPrevisionEvent No errors.
App\Entity\Parameters\Parameters No errors.
App\Entity\Parameters\BrandParameters No errors.
App\Entity\Event\ProposalEventDate No errors.
App\Entity\Parameters\EventParameters No errors.
App\Entity\Event\Workshop No errors.