Query Metrics
174
Database Queries
11
Different statements
2418.51 ms
Query time
0
Invalid entities
130
Managed entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1720.24 ms (71.13%) |
40 |
SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.changed AS changed_2, m1_.name AS name_3, m1_.description AS description_4, m1_.id AS id_5, m2_.style AS style_6, m2_.lft AS lft_7, m2_.rgt AS rgt_8, m2_.depth AS depth_9, m2_.collection_key AS collection_key_10, m2_.id AS id_11, m2_.created AS created_12, m2_.changed AS changed_13, m3_.version AS version_14, m3_.id AS id_15, m3_.created AS created_16, m3_.changed AS changed_17, m4_.name AS name_18, m4_.version AS version_19, m4_.subVersion AS subversion_20, m4_.size AS size_21, m4_.downloadCounter AS downloadcounter_22, m4_.storageOptions AS storageoptions_23, m4_.mimeType AS mimetype_24, m4_.properties AS properties_25, m4_.focusPointX AS focuspointx_26, m4_.focusPointY AS focuspointy_27, m4_.id AS id_28, m4_.created AS created_29, m4_.changed AS changed_30, m5_.crop_x AS crop_x_31, m5_.crop_y AS crop_y_32, m5_.crop_width AS crop_width_33, m5_.crop_height AS crop_height_34, m5_.format_key AS format_key_35, m6_.title AS title_36, m6_.description AS description_37, m6_.copyright AS copyright_38, m6_.credits AS credits_39, m6_.locale AS locale_40, m6_.id AS id_41, m7_.title AS title_42, m7_.description AS description_43, m7_.copyright AS copyright_44, m7_.credits AS credits_45, m7_.locale AS locale_46, m7_.id AS id_47, m8_.locale AS locale_48, m8_.id AS id_49, m9_.locale AS locale_50, m9_.id AS id_51, s10_.username AS username_52, s10_.password AS password_53, s10_.locale AS locale_54, s10_.salt AS salt_55, s10_.locked AS locked_56, s10_.enabled AS enabled_57, s10_.lastLogin AS lastlogin_58, s10_.confirmationKey AS confirmationkey_59, s10_.passwordResetToken AS passwordresettoken_60, s10_.passwordResetTokenExpiresAt AS passwordresettokenexpiresat_61, s10_.passwordResetTokenEmailsSent AS passwordresettokenemailssent_62, s10_.privateKey AS privatekey_63, s10_.apiKey AS apikey_64, s10_.email AS email_65, s10_.id AS id_66, s10_.created AS created_67, s10_.changed AS changed_68, c11_.firstName AS firstname_69, c11_.middleName AS middlename_70, c11_.lastName AS lastname_71, c11_.birthday AS birthday_72, c11_.salutation AS salutation_73, c11_.formOfAddress AS formofaddress_74, c11_.newsletter AS newsletter_75, c11_.gender AS gender_76, c11_.note AS note_77, c11_.mainEmail AS mainemail_78, c11_.mainPhone AS mainphone_79, c11_.mainFax AS mainfax_80, c11_.mainUrl AS mainurl_81, c11_.id AS id_82, c11_.created AS created_83, c11_.changed AS changed_84, s12_.username AS username_85, s12_.password AS password_86, s12_.locale AS locale_87, s12_.salt AS salt_88, s12_.locked AS locked_89, s12_.enabled AS enabled_90, s12_.lastLogin AS lastlogin_91, s12_.confirmationKey AS confirmationkey_92, s12_.passwordResetToken AS passwordresettoken_93, s12_.passwordResetTokenExpiresAt AS passwordresettokenexpiresat_94, s12_.passwordResetTokenEmailsSent AS passwordresettokenemailssent_95, s12_.privateKey AS privatekey_96, s12_.apiKey AS apikey_97, s12_.email AS email_98, s12_.id AS id_99, s12_.created AS created_100, s12_.changed AS changed_101, c13_.firstName AS firstname_102, c13_.middleName AS middlename_103, c13_.lastName AS lastname_104, c13_.birthday AS birthday_105, c13_.salutation AS salutation_106, c13_.formOfAddress AS formofaddress_107, c13_.newsletter AS newsletter_108, c13_.gender AS gender_109, c13_.note AS note_110, c13_.mainEmail AS mainemail_111, c13_.mainPhone AS mainphone_112, c13_.mainFax AS mainfax_113, c13_.mainUrl AS mainurl_114, c13_.id AS id_115, c13_.created AS created_116, c13_.changed AS changed_117, m14_.id AS id_118, m14_.created AS created_119, m14_.changed AS changed_120, m0_.idMediaTypes AS idmediatypes_121, m0_.idPreviewImage AS idpreviewimage_122, m0_.idCollections AS idcollections_123, m0_.idUsersCreator AS iduserscreator_124, m0_.idUsersChanger AS iduserschanger_125, m2_.idCollectionsMetaDefault AS idcollectionsmetadefault_126, m2_.idCollectionTypes AS idcollectiontypes_127, m2_.idCollectionsParent AS idcollectionsparent_128, m2_.idUsersCreator AS iduserscreator_129, m2_.idUsersChanger AS iduserschanger_130, m3_.idMedia AS idmedia_131, m3_.idUsersCreator AS iduserscreator_132, m3_.idUsersChanger AS iduserschanger_133, m4_.idFileVersionsMetaDefault AS idfileversionsmetadefault_134, m4_.idFiles AS idfiles_135, m4_.idUsersCreator AS iduserscreator_136, m4_.idUsersChanger AS iduserschanger_137, m5_.fileVersion AS fileversion_138, m6_.idFileVersions AS idfileversions_139, m7_.idFileVersions AS idfileversions_140, m8_.idFileVersions AS idfileversions_141, m9_.idFileVersions AS idfileversions_142, s10_.idContacts AS idcontacts_143, s10_.idUsersCreator AS iduserscreator_144, s10_.idUsersChanger AS iduserschanger_145, c11_.idTitles AS idtitles_146, c11_.avatar AS avatar_147, c11_.idUsersCreator AS iduserscreator_148, c11_.idUsersChanger AS iduserschanger_149, s12_.idContacts AS idcontacts_150, s12_.idUsersCreator AS iduserscreator_151, s12_.idUsersChanger AS iduserschanger_152, c13_.idTitles AS idtitles_153, c13_.avatar AS avatar_154, c13_.idUsersCreator AS iduserscreator_155, c13_.idUsersChanger AS iduserschanger_156, m14_.idMediaTypes AS idmediatypes_157, m14_.idPreviewImage AS idpreviewimage_158, m14_.idCollections AS idcollections_159, m14_.idUsersCreator AS iduserscreator_160, m14_.idUsersChanger AS iduserschanger_161 FROM me_media m0_ LEFT JOIN me_media_types m1_ ON m0_.idMediaTypes = m1_.id LEFT JOIN me_collections m2_ ON m0_.idCollections = m2_.id LEFT JOIN me_files m3_ ON m0_.id = m3_.idMedia LEFT JOIN me_file_versions m4_ ON m3_.id = m4_.idFiles LEFT JOIN me_format_options m5_ ON m4_.id = m5_.fileVersion LEFT JOIN me_file_version_meta m6_ ON m4_.id = m6_.idFileVersions LEFT JOIN me_file_version_meta m7_ ON m4_.idFileVersionsMetaDefault = m7_.id LEFT JOIN me_file_version_content_languages m8_ ON m4_.id = m8_.idFileVersions LEFT JOIN me_file_version_publish_languages m9_ ON m4_.id = m9_.idFileVersions LEFT JOIN se_users s10_ ON m0_.idUsersCreator = s10_.id LEFT JOIN co_contacts c11_ ON s10_.idContacts = c11_.id LEFT JOIN se_users s12_ ON m0_.idUsersChanger = s12_.id LEFT JOIN co_contacts c13_ ON s12_.idContacts = c13_.id LEFT JOIN me_media m14_ ON m0_.idPreviewImage = m14_.id WHERE m0_.id = ?
Parameters:
[
48
]
|
||||||||||||||||||||||||||||||
|
125.82 ms (5.20%) |
14 |
SELECT t0._glofox_id AS _glofox_id_1, t0._name AS _name_2, t0._namespace AS _namespace_3, t0._type AS _type_4, t0._phone AS _phone_5, t0._email AS _email_6, t0._website AS _website_7, t0._facebook AS _facebook_8, t0._twitter AS _twitter_9, t0._instagram AS _instagram_10, t0._about AS _about_11, t0._image_url AS _image_url_12, t0._working_hours AS _working_hours_13, t0._opening_times AS _opening_times_14, t0._language AS _language_15, t0._corporate_id AS _corporate_id_16, t0._stripe_plan_code AS _stripe_plan_code_17, t0._street AS _street_18, t0._city AS _city_19, t0._state AS _state_20, t0._country AS _country_21, t0._country_code AS _country_code_22, t0._district AS _district_23, t0._postal_code AS _postal_code_24, t0._latitude AS _latitude_25, t0._longitude AS _longitude_26, t0._currency AS _currency_27, t0._continent AS _continent_28, t0._timezone_id AS _timezone_id_29, t0._timezone_name AS _timezone_name_30, t0._strike_system_enabled AS _strike_system_enabled_31, t0._strike_system_max_strikes AS _strike_system_max_strikes_32, t0._auto_booking_enabled AS _auto_booking_enabled_33, t0._booking_open_window AS _booking_open_window_34, t0._booking_cancel_window AS _booking_cancel_window_35, t0._waiting_list_enabled AS _waiting_list_enabled_36, t0._waiting_list_size AS _waiting_list_size_37, t0._limit_booking_enabled AS _limit_booking_enabled_38, t0._limit_booking AS _limit_booking_39, t0._limit_booking_period AS _limit_booking_period_40, t0.id AS id_41, t0.app_created_at AS app_created_at_42, t0.app_updated_at AS app_updated_at_43, t0._location_id AS _location_id_44 FROM app.glofox_location t0 WHERE t0._location_id = ? LIMIT 1
Parameters:
[
"019b11a7-124b-762f-8eac-06fd05608503"
]
|
||||||||||||||||||||||||||||||
|
124.24 ms (5.14%) |
42 |
SELECT mf.* FROM app.membership_feature mf WHERE mf._tiers::jsonb @> ?::jsonb ORDER BY mf._sort_order ASC LIMIT ?
Parameters:
[ "["silver"]" 4 ]
|
||||||||||||||||||||||||||||||
|
83.93 ms (3.47%) |
10 |
SELECT t0.name AS name_1, t0.id AS id_2, t0.created AS created_3, t0.changed AS changed_4, t0.idUsersCreator AS iduserscreator_5, t0.idUsersChanger AS iduserschanger_6 FROM ta_tags t0 INNER JOIN me_file_version_tags ON t0.id = me_file_version_tags.idTags WHERE me_file_version_tags.idFileVersions = ?
Parameters:
[
48
]
|
||||||||||||||||||||||||||||||
|
73.74 ms (3.05%) |
14 |
SELECT t0._type AS _type_1, t0._label AS _label_2, t0._image_id AS _image_id_3, t0._video_id AS _video_id_4, t0._sort_order AS _sort_order_5, t0.id AS id_6, t0.app_created_at AS app_created_at_7, t0.app_updated_at AS app_updated_at_8, t0._location_id AS _location_id_9 FROM app.location_content t0 WHERE t0._location_id = ? ORDER BY t0._sort_order ASC
Parameters:
[
"019b11a7-124b-762f-8eac-06fd05608503"
]
|
||||||||||||||||||||||||||||||
|
73.13 ms (3.02%) |
14 |
SELECT v._tier as tier, MIN(p._monthly_price) as lowest_price FROM app.membership_variant_price p JOIN app.membership_variant v ON v.id = p._variant_id WHERE p._is_active = true AND p._location_id = ? GROUP BY v._tier
Parameters:
[
"019b11a7-124b-762f-8eac-06fd05608503"
]
|
||||||||||||||||||||||||||||||
|
69.89 ms (2.89%) |
14 |
SELECT v._tier as tier, MIN(p._join_fee) as join_fee FROM app.membership_variant_price p JOIN app.membership_variant v ON v.id = p._variant_id WHERE p._is_active = true AND p._location_id = ? GROUP BY v._tier
Parameters:
[
"019b11a7-124b-762f-8eac-06fd05608503"
]
|
||||||||||||||||||||||||||||||
|
62.85 ms (2.60%) |
14 |
SELECT t0._title AS _title_1, t0.id AS id_2, t0.app_created_at AS app_created_at_3, t0.app_updated_at AS app_updated_at_4 FROM app.equipment t0 INNER JOIN app.location_equipment ON t0.id = app.location_equipment.equipment_id WHERE app.location_equipment.location_id = ?
Parameters:
[
"019b11a7-124b-762f-8eac-06fd05608503"
]
|
||||||||||||||||||||||||||||||
|
57.81 ms (2.39%) |
10 |
SELECT t0.category_key AS category_key_1, t0.default_locale AS default_locale_2, t0.lft AS lft_3, t0.rgt AS rgt_4, t0.depth AS depth_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.idCategoriesParent AS idcategoriesparent_9, t0.idUsersCreator AS iduserscreator_10, t0.idUsersChanger AS iduserschanger_11 FROM ca_categories t0 INNER JOIN me_file_version_categories ON t0.id = me_file_version_categories.idCategories WHERE me_file_version_categories.idFileVersions = ?
Parameters:
[
48
]
|
||||||||||||||||||||||||||||||
|
13.91 ms (0.58%) |
1 |
SELECT t0.method AS method_1, t0.options AS options_2, t0.id AS id_3, t0.idUsers AS idusers_4 FROM se_user_two_factors t0 WHERE t0.idUsers = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
|
12.96 ms (0.54%) |
1 |
SELECT l0_._name AS _name_0, l0_._glofox_id AS _glofox_id_1, l0_._key AS _key_2, l0_._is_active AS _is_active_3, l0_._image_id AS _image_id_4, l0_._events_count AS _events_count_5, l0_._special_banner_title AS _special_banner_title_6, l0_._special_banner_description AS _special_banner_description_7, l0_._special_banner_media_id AS _special_banner_media_id_8, l0_._special_banner_button_label AS _special_banner_button_label_9, l0_._special_banner_button_url AS _special_banner_button_url_10, l0_._presale_start_date AS _presale_start_date_11, l0_._presale_end_date AS _presale_end_date_12, l0_._open_sales_start_date AS _open_sales_start_date_13, l0_._open_sales_end_date AS _open_sales_end_date_14, l0_._small_promotion_start_date AS _small_promotion_start_date_15, l0_._small_promotion_end_date AS _small_promotion_end_date_16, l0_._big_promotion_start_date AS _big_promotion_start_date_17, l0_._big_promotion_end_date AS _big_promotion_end_date_18, l0_.id AS id_19, l0_.app_created_at AS app_created_at_20, l0_.app_updated_at AS app_updated_at_21 FROM app.location l0_ WHERE l0_._is_active = ? ORDER BY l0_._name ASC
Parameters:
[
1
]
|
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 |
|---|---|
| App\Entity\LocationContent | 31 |
| App\Entity\Location | 14 |
| App\Entity\Glofox\GlofoxLocation | 14 |
| Sulu\Bundle\MediaBundle\Entity\Media | 10 |
| Sulu\Bundle\MediaBundle\Entity\File | 10 |
| Sulu\Bundle\MediaBundle\Entity\FileVersion | 10 |
| Sulu\Bundle\MediaBundle\Entity\FileVersionMeta | 10 |
| Sulu\Bundle\MediaBundle\Entity\Collection | 9 |
| Sulu\Bundle\MediaBundle\Entity\CollectionMeta | 9 |
| App\Entity\MembershipFeature | 8 |
| Sulu\Bundle\MediaBundle\Entity\MediaType | 2 |
| Sulu\Bundle\MediaBundle\Entity\CollectionType | 1 |
| Sulu\Bundle\SecurityBundle\Entity\User | 1 |
| Sulu\Bundle\ContactBundle\Entity\Contact | 1 |