GET https://fitko.app/cron/close-schedule

Query Metrics

6 Database Queries
5 Different statements
10.29 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.98 ms
SELECT t0.id AS id_1, t0.google_version AS google_version_2, t0.apple_version AS apple_version_3, t0.huawei_version AS huawei_version_4, t0.lock_update_modal AS lock_update_modal_5, t0.app_reload AS app_reload_6, t0.app_reload_timeout AS app_reload_timeout_7, t0.show_rate_us AS show_rate_us_8, t0.logo AS logo_9, t0.messages_image AS messages_image_10, t0.apple_link AS apple_link_11, t0.google_link AS google_link_12, t0.huawei_link AS huawei_link_13, t0.arrival_allowed AS arrival_allowed_14, t0.use_pin AS use_pin_15, t0.use_address AS use_address_16, t0.use_arrival_counter AS use_arrival_counter_17, t0.schedule_repeat_every_day AS schedule_repeat_every_day_18, t0.tomorrow_training_notification AS tomorrow_training_notification_19, t0.automatic_arrival_count_reduce AS automatic_arrival_count_reduce_20, t0.disable_schedule_view AS disable_schedule_view_21, t0.use_packages AS use_packages_22, t0.show_loyalty_app AS show_loyalty_app_23, t0.currency AS currency_24, t0.holidays_calendar_view AS holidays_calendar_view_25, t0.use_packages_price_list AS use_packages_price_list_26, t0.hide_work_hours AS hide_work_hours_27, t0.use_multiple_packages AS use_multiple_packages_28, t0.no_membership_loyalty_clear AS no_membership_loyalty_clear_29, t0.membership_loyalty_clear AS membership_loyalty_clear_30, t0.reserve_schedule_by_coach AS reserve_schedule_by_coach_31, t0.disable_work_hours_calendar AS disable_work_hours_calendar_32, t0.reservation_notification_available AS reservation_notification_available_33, t0.disable_schedule_reservation AS disable_schedule_reservation_34, t0.disable_tomorrow_schedule_notification AS disable_tomorrow_schedule_notification_35, t0.disable_schedule_calendar AS disable_schedule_calendar_36, t0.hide_calendar_view_app AS hide_calendar_view_app_37, t0.disable_app_screenshot AS disable_app_screenshot_38, t0.hide_schedule_max_users AS hide_schedule_max_users_39, t0.hide_favorites_app AS hide_favorites_app_40, t0.by_pass_package_check AS by_pass_package_check_41, t0.show_max_users_schedule_calendar_title AS show_max_users_schedule_calendar_title_42, t0.show_disabled_schedule_calendar_max_users AS show_disabled_schedule_calendar_max_users_43, t0.enable_calendar_clone AS enable_calendar_clone_44, t0.update_membership_days AS update_membership_days_45, t0.show_disabled_schedule_calendar_reserved_users AS show_disabled_schedule_calendar_reserved_users_46, t0.use_vimeo_video_links AS use_vimeo_video_links_47, t0.use_date_of_birth_app AS use_date_of_birth_app_48, t0.vimeo_access_token AS vimeo_access_token_49, t0.use_corvus_pay AS use_corvus_pay_50, t0.corvus_secret AS corvus_secret_51, t0.corvus_env AS corvus_env_52, t0.corvus_lang AS corvus_lang_53, t0.corvus_store_id AS corvus_store_id_54, t0.corvus_currency AS corvus_currency_55, t0.corvus_product_price AS corvus_product_price_56, t0.corvus_product_title AS corvus_product_title_57, t0.corvus_order_number_start AS corvus_order_number_start_58, t0.hide_request_barcode_button AS hide_request_barcode_button_59, t0.zoom_api_key AS zoom_api_key_60, t0.zoom_secret_key AS zoom_secret_key_61, t0.huawei_app_id AS huawei_app_id_62, t0.huawei_client_secret AS huawei_client_secret_63, t0.disable_membership_date AS disable_membership_date_64, t0.show_schedule_calendar_repeat_day AS show_schedule_calendar_repeat_day_65, t0.corvus_vat AS corvus_vat_66, t0.offer_company_name AS offer_company_name_67, t0.offer_company_iban AS offer_company_iban_68, t0.offer_company_address AS offer_company_address_69, t0.offer_company_postal AS offer_company_postal_70, t0.offer_company_city AS offer_company_city_71, t0.offer_company_pin AS offer_company_pin_72, t0.offer_company_vat_number AS offer_company_vat_number_73, t0.offer_company_due_days AS offer_company_due_days_74, t0.offer_company_logo AS offer_company_logo_75, t0.currency_symbol AS currency_symbol_76, t0.offer_use_vat_calc AS offer_use_vat_calc_77, t0.use_offers_for_packages AS use_offers_for_packages_78, t0.always_show_schedule AS always_show_schedule_79, t0.schedule_calendar_default_view AS schedule_calendar_default_view_80, t0.set_notification_badge AS set_notification_badge_81, t0.use_languages AS use_languages_82, t0.default_language_title AS default_language_title_83, t0.default_language_subtitle AS default_language_subtitle_84, t0.default_language_image AS default_language_image_85, t0.default_language_slug AS default_language_slug_86, t0.default_language_country_code AS default_language_country_code_87, t0.use_regular_users AS use_regular_users_88, t0.use_work_reservation_trainer_colors AS use_work_reservation_trainer_colors_89, t0.use_membership_history AS use_membership_history_90, t0.strings_remote_ip AS strings_remote_ip_91, t0.strings_remote_db_name AS strings_remote_db_name_92, t0.strings_remote_db_pass AS strings_remote_db_pass_93, t0.strings_remote_db_user AS strings_remote_db_user_94, t0.hide_price_list AS hide_price_list_95, t0.work_reservation_confirmation AS work_reservation_confirmation_96, t0.hide_facebook_login AS hide_facebook_login_97, t0.hide_google_login AS hide_google_login_98, t0.hide_apple_login AS hide_apple_login_99, t0.hide_my_users_checkbox AS hide_my_users_checkbox_100, t0.scan_barcode_question AS scan_barcode_question_101, t0.schedule_reservation_confirmation AS schedule_reservation_confirmation_102, t0.tuya_client_id AS tuya_client_id_103, t0.tuya_client_secret AS tuya_client_secret_104, t0.tuya_device_id AS tuya_device_id_105, t0.tuya_device_latitude AS tuya_device_latitude_106, t0.tuya_device_longitude AS tuya_device_longitude_107, t0.tuya_device_radius AS tuya_device_radius_108, t0.gate_max_daily_opening AS gate_max_daily_opening_109, t0.disable_multi_schedule_reservation_daily AS disable_multi_schedule_reservation_daily_110, t0.inactive_web_redirect_url AS inactive_web_redirect_url_111, t0.hide_home_schedule AS hide_home_schedule_112, t0.hide_home_support AS hide_home_support_113, t0.show_home_support_to_active_members AS show_home_support_to_active_members_114, t0.hide_menu_barcode AS hide_menu_barcode_115, t0.show_barcode_only_gate_openers AS show_barcode_only_gate_openers_116, t0.use_tuya_devices AS use_tuya_devices_117, t0.firebase_email AS firebase_email_118, t0.firebase_password AS firebase_password_119, t0.firebase_database_url AS firebase_database_url_120, t0.firebase_service_account_json AS firebase_service_account_json_121, t0.use_firebase_device AS use_firebase_device_122, t0.arduino_ide_program AS arduino_ide_program_123, t0.use_bills AS use_bills_124, t0.use_bills_in_app AS use_bills_in_app_125, t0.bills_sales_point AS bills_sales_point_126, t0.use_bills_fiskal AS use_bills_fiskal_127, t0.bills_fiskal_certificate AS bills_fiskal_certificate_128, t0.bills_operater AS bills_operater_129, t0.bills_notice AS bills_notice_130, t0.bills_payment_record AS bills_payment_record_131, t0.use_minus_in_arrivals AS use_minus_in_arrivals_132, t0.bills_notice2 AS bills_notice2_133, t0.bills_footer AS bills_footer_134, t0.disable_one_day_membership_notification AS disable_one_day_membership_notification_135, t0.disable_two_day_membership_notification AS disable_two_day_membership_notification_136, t0.disable_same_day_membership_notification AS disable_same_day_membership_notification_137, t0.website_url AS website_url_138, t0.hide_info_app_schedule AS hide_info_app_schedule_139, t0.use_user_arrivals AS use_user_arrivals_140, t0.inactive AS inactive_141, t0.fira_secret_key AS fira_secret_key_142 FROM app_settings t0 WHERE t0.id = ?
Parameters:
[
  1
]
2 7.87 ms
UPDATE category_schedule SET closed = 1 WHERE date < ? OR (date = ? AND time_from <= ?)
Parameters:
[
  "2025-07-04 00:00:00"
  "2025-07-04 00:00:00"
  "2025-07-04 23:43:03"
]
3 0.73 ms
UPDATE work_hours_reservations SET active = 0 WHERE date < ? OR (date = ? AND time_from <= ?)
Parameters:
[
  "2025-07-04 00:00:00"
  "2025-07-04 00:00:00"
  "2025-07-04 23:43:03"
]
4 0.25 ms
SELECT w0_.id AS id_0, w0_.created AS created_1, w0_.confirmed AS confirmed_2, w0_.date AS date_3, w0_.time_from AS time_from_4, w0_.time_to AS time_to_5, w0_.payment_file AS payment_file_6, w0_.active AS active_7, w0_.description AS description_8, w0_.user_id AS user_id_9, w0_.category_work_hour_id AS category_work_hour_id_10, w0_.trainer_id AS trainer_id_11 FROM work_hours_reservations w0_ WHERE w0_.date = ? AND w0_.time_from = ?
Parameters:
[
  "2025-07-04"
  "00:43"
]
5 0.34 ms
SELECT s0_.id AS id_0, s0_.created AS created_1, s0_.confirmed AS confirmed_2, s0_.user_id AS user_id_3, s0_.category_schedule_id AS category_schedule_id_4 FROM schedule_reservation s0_ INNER JOIN category_schedule c1_ ON s0_.category_schedule_id = c1_.id WHERE c1_.date = ? AND c1_.time_from = ?
Parameters:
[
  "2025-07-04"
  "00:43"
]
6 0.12 ms
SELECT w0_.id AS id_0, w0_.created AS created_1, w0_.confirmed AS confirmed_2, w0_.date AS date_3, w0_.time_from AS time_from_4, w0_.time_to AS time_to_5, w0_.payment_file AS payment_file_6, w0_.active AS active_7, w0_.description AS description_8, w0_.user_id AS user_id_9, w0_.category_work_hour_id AS category_work_hour_id_10, w0_.trainer_id AS trainer_id_11 FROM work_hours_reservations w0_ WHERE w0_.date = ? AND w0_.time_from = ?
Parameters:
[
  "2025-07-04"
  "01:43"
]

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\AppSettings No errors.
App\Entity\CategorySchedule No errors.
App\Entity\WorkHoursReservations No errors.
App\Entity\User No errors.
App\Entity\CategoryWorkHours No errors.
App\Entity\ScheduleReservation
  • The association App\Entity\ScheduleReservation#repeatScheduleReservations refers to the owning side field App\Entity\RepeatScheduleReservations#scheduleReservation which does not exist.