Query Metrics
16
Database Queries
15
Different statements
20.78 ms
Query time
3
Invalid entities
Queries
| #▲ | 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 |
|
| 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 |
|
| App\Entity\Event\Seminar | No errors. |
| App\Entity\Common\Address | No errors. |
| App\Entity\CMS\CmsContent | No errors. |
| App\Entity\User\ApiBrandUser |
|
| 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. |