No post data.
Query | Affected | Num. rows | Took (ms) | Actions |
---|---|---|---|---|
SELECT `School`.`logo` FROM `classera_g2`.`schools` AS `School` WHERE `id` = '' LIMIT 1 | 0 | 0 | 0 | |
SELECT `School`.`id` FROM `classera_g2`.`schools` AS `School` inner JOIN `classera_g2`.`registrations_timeslot` AS `RegistrationTimeslot` ON (`RegistrationTimeslot`.`school_id` = `School`.`id`) inner JOIN `classera_g2`.`registrations_semesters` AS `RegistrationSemester` ON (`RegistrationSemester`.`school_id` = `School`.`id`) inner JOIN `classera_g2`.`semesters` AS `Semester` ON (`Semester`.`id` = `RegistrationSemester`.`semester_id` AND `Semester`.`deleted` = 0) WHERE `School`.`school_group_id` = 6259 AND `School`.`deleted` = '0' AND `RegistrationTimeslot`.`type` = 2 AND `RegistrationTimeslot`.`from` <= '2024-09-18 10:15:44' AND `RegistrationTimeslot`.`to` >= '2024-09-18 10:15:44' GROUP BY `School`.`id` | 5 | 5 | 1 | maybe slow |
SELECT `SchoolsRegistrationForms`.`id` FROM `classera_g2`.`schools_registration_forms` AS `SchoolsRegistrationForms` WHERE `SchoolsRegistrationForms`.`current_active` = '1' AND `SchoolsRegistrationForms`.`type` = 1 AND `SchoolsRegistrationForms`.`school_id` = 1000003 AND `SchoolsRegistrationForms`.`deleted` = '0' LIMIT 1 | 1 | 1 | 1 | |
SELECT `SchoolsRegistrationForms`.`id` FROM `classera_g2`.`schools_registration_forms` AS `SchoolsRegistrationForms` WHERE `SchoolsRegistrationForms`.`current_active` = '1' AND `SchoolsRegistrationForms`.`type` = 1 AND `SchoolsRegistrationForms`.`school_id` = 1000011 AND `SchoolsRegistrationForms`.`deleted` = '0' LIMIT 1 | 1 | 1 | 1 | |
SELECT `SchoolsRegistrationForms`.`id` FROM `classera_g2`.`schools_registration_forms` AS `SchoolsRegistrationForms` WHERE `SchoolsRegistrationForms`.`current_active` = '1' AND `SchoolsRegistrationForms`.`type` = 1 AND `SchoolsRegistrationForms`.`school_id` = 1000014 AND `SchoolsRegistrationForms`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `SchoolsRegistrationForms`.`id` FROM `classera_g2`.`schools_registration_forms` AS `SchoolsRegistrationForms` WHERE `SchoolsRegistrationForms`.`current_active` = '1' AND `SchoolsRegistrationForms`.`type` = 1 AND `SchoolsRegistrationForms`.`school_id` = 1000015 AND `SchoolsRegistrationForms`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `SchoolsRegistrationForms`.`id` FROM `classera_g2`.`schools_registration_forms` AS `SchoolsRegistrationForms` WHERE `SchoolsRegistrationForms`.`current_active` = '1' AND `SchoolsRegistrationForms`.`type` = 1 AND `SchoolsRegistrationForms`.`school_id` = 1000016 AND `SchoolsRegistrationForms`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `School`.`id`, `School`.`parent_id`, `School`.`name`, `School`.`english_name`, `School`.`prefix`, `School`.`city`, `School`.`country_id`, `School`.`city_id`, `School`.`school_group_id`, `School`.`management`, `School`.`number`, `School`.`address`, `School`.`about_school`, `School`.`phone_number`, `School`.`fax_number`, `School`.`email`, `School`.`website`, `School`.`logo`, `School`.`lang`, `School`.`timezone`, `School`.`date_format`, `School`.`type`, `School`.`squigl_sync_history_id`, `School`.`registration_open`, `School`.`parents_registration_open`, `School`.`created`, `School`.`modified`, `School`.`pioneer_id`, `School`.`facebook_account`, `School`.`twitter_account`, `School`.`google_plus_account`, `School`.`instagram_account`, `School`.`linkedin_account`, `School`.`allow_users_open_publicprofile`, `School`.`allow_users_upload_eportfolios`, `School`.`allow_users_upload_posts`, `School`.`publicprofiles_privecy_level_id`, `School`.`allow_students_change_password`, `School`.`allow_teachers_change_password`, `School`.`allow_others_change_password`, `School`.`allow_students_change_login_name`, `School`.`allow_teachers_change_login_name`, `School`.`allow_others_change_login_name`, `School`.`allow_students_change_profile_pic`, `School`.`show_american_question_bank`, `School`.`allow_smart_mate_generation`, `School`.`allow_teacher_to_link_preparation_standards`, `School`.`deleted`, `School`.`id_hash`, `School`.`gpa_base`, `School`.`allow_students_change_phone_number`, `School`.`allow_parents_change_phone_number`, `School`.`sms_sender_name`, `School`.`allow_tsupv_approve_preparation`, `School`.`allow_discussion_board`, `School`.`allow_students_create_discussions`, `School`.`allow_students_create_topics_in_discussions`, `School`.`absences_notification_limit`, `School`.`lectures_absences_notification_limit`, `School`.`absences_notification_excused`, `School`.`lectures_absences_notification_excused`, `School`.`absences_notification`, `School`.`lectures_absences_notification`, `School`.`allow_tsupv_show_messages_between_teachers_and_students`, `School`.`send_to_school_group_staff`, `School`.`is_mawhiba_olympics_exam_school`, `School`.`mawhiba_portal_exam_id`, `School`.`allow_managers_add_announcements`, `School`.`approved_attachments_in_library_only`, `School`.`allow_reset_password_via_sms`, `School`.`allow_school_chat`, `School`.`gender`, `School`.`noor_id`, `School`.`hide_weekends_in_weekly_plan`, `School`.`allow_students_requests`, `School`.`school_pdf_zoom`, `School`.`absences_letter`, `School`.`absences_letter_excused`, `School`.`allow_graduated_students_login`, `School`.`allow_parent_access_to_smart_class`, `School`.`implementation_phase`, `School`.`max_number_of_replies_discussion_rooms`, `School`.`educational_office_id`, `School`.`take_evidences`, `School`.`is_premium`, `School`.`is_lite`, `School`.`students_section_messages`, `School`.`acf_check`, `School`.`enabled`, `School`.`allow_students_change_email`, `School`.`allow_students_change_face`, `School`.`allow_internally_tickets`, `School`.`unit_plan_allow`, `School`.`is_mawhiba_scan_exam_school`, `School`.`show_weekends_in_schedule`, `School`.`working_days`, `School`.`manager_approve_content_publish`, `School`.`starting_day`, `School`.`simultaneous_sessions_limit`, `School`.`graduates_club_allow`, `School`.`allow_hijri_date`, `School`.`registration_age_start`, `School`.`normal_english_curriculum`, `School`.`muqrarrat_english_curriculum`, `School`.`summer_period`, `School`.`is_muqararat_school`, `School`.`clever_id`, `School`.`translation_version`, `School`.`international`, `School`.`automatically_set_full_day_absences`, `School`.`show_late_bills_warning_message`, `School`.`hide_exam_due_date`, `School`.`require_attachments`, `School`.`attachments_description`, `School`.`allow_teacher_hide_exam`, `School`.`is_edumall_school`, `School`.`mawhiba_create_automatic_stages`, `School`.`longitude`, `School`.`latitude`, `School`.`allow_student_register_course`, `School`.`activation_manager_id`, `School`.`show_contact_information_credential`, `School`.`allow_payment`, `School`.`psp_config`, `School`.`share_content`, `School`.`allow_smart_mate_attachment_generation`, `School`.`SecondaryLanguageRestrictMessage`, `School`.`PrimaryLanguageRestrictMessage`, `School`.`face_id_file`, `School`.`iban`, `School`.`payment_method`, `School`.`registration_fees_amount`, `School`.`ending_day`, `School`.`mawhiba_integration`, `School`.`cpay_merchant_id`, `School`.`claim_visible`, `School`.`county_id` FROM `classera_g2`.`schools` AS `School` WHERE `School`.`id` = 1000003 LIMIT 1 | 1 | 1 | 1 | |
SELECT `SchoolsSetting`.`school_id`, `SchoolsSetting`.`settings` FROM `classera_g2`.`schools_settings` AS `SchoolsSetting` WHERE `school_id` IN (1000003, 1000011, 1000014, 1000015, 1000016) | 5 | 5 | 0 | |
SELECT `School`.`id` FROM `classera_g2`.`schools` AS `School` inner JOIN `classera_g2`.`registrations_timeslot` AS `RegistrationTimeslot` ON (`RegistrationTimeslot`.`school_id` = `School`.`id`) inner JOIN `classera_g2`.`registrations_semesters` AS `RegistrationSemester` ON (`RegistrationSemester`.`school_id` = `School`.`id`) inner JOIN `classera_g2`.`semesters` AS `Semester` ON (`Semester`.`id` = `RegistrationSemester`.`semester_id` AND `Semester`.`deleted` = 0) WHERE `School`.`parent_id` = 6259 AND `School`.`school_group_id` = 1133 AND `School`.`deleted` = '0' AND `RegistrationTimeslot`.`type` = 2 AND `RegistrationTimeslot`.`from` <= '2024-09-18 10:15:44' AND `RegistrationTimeslot`.`to` >= '2024-09-18 10:15:44' GROUP BY `School`.`id` | 0 | 0 | 0 | |
SELECT `School`.`id`, `parent_id` AS `parent`, (COALESCE(NULLIF(`School`.`english_name`,"") , `School`.`name`)) AS `School__text` FROM `classera_g2`.`schools` AS `School` inner JOIN `classera_g2`.`registrations_timeslot` AS `RegistrationTimeslot` ON (`RegistrationTimeslot`.`school_id` = `School`.`id`) inner JOIN `classera_g2`.`registrations_semesters` AS `RegistrationSemester` ON (`RegistrationSemester`.`school_id` = `School`.`id`) inner JOIN `classera_g2`.`semesters` AS `Semester` ON (`Semester`.`id` = `RegistrationSemester`.`semester_id` AND `Semester`.`deleted` = 0) WHERE `School`.`school_group_id` = 6259 AND `School`.`deleted` = '0' AND `RegistrationTimeslot`.`type` = 2 AND `RegistrationTimeslot`.`from` <= '2024-09-18 10:15:44' AND `RegistrationTimeslot`.`to` >= '2024-09-18 10:15:44' GROUP BY `School`.`id` | 5 | 5 | 1 | maybe slow |
SELECT `SchoolGroup`.`id`, `SchoolGroup`.`parent_id`, `SchoolGroup`.`title`, `SchoolGroup`.`logo`, `SchoolGroup`.`registration_link`, `SchoolGroup`.`registration_message`, `SchoolGroup`.`user_id`, `SchoolGroup`.`prefix`, `SchoolGroup`.`mawhiba_department_id`, `SchoolGroup`.`created`, `SchoolGroup`.`modified`, `SchoolGroup`.`deleted`, `SchoolGroup`.`send_only_from_template`, `SchoolGroup`.`template_controller_admin`, `SchoolGroup`.`clever_id`, `SchoolGroup`.`vcr_limit`, `SchoolGroup`.`allow_teacher_vcr_meeting`, `SchoolGroup`.`school_has_ad`, `SchoolGroup`.`isolated_group`, `SchoolGroup`.`activation_manager_id`, `SchoolGroup`.`number_of_license`, `SchoolGroup`.`sms_provider`, `SchoolGroup`.`enable_prefix`, `SchoolGroup`.`number_of_additional_license`, `SchoolGroup`.`number_of_free_license`, `SchoolGroup`.`iban`, `SchoolGroup`.`cpay_country`, `SchoolGroup`.`active_cpay`, `SchoolGroup`.`currency_id`, `SchoolGroup`.`language_id`, `SchoolGroup`.`payment_method`, `SchoolGroup`.`active_gift`, `SchoolGroup`.`school_group_financial_system`, `SchoolGroup`.`enable_email_verification_code`, `SchoolGroup`.`allow_partial_payment_erp`, `SchoolGroup`.`from_sales`, `SchoolGroup`.`package_price`, `SchoolGroup`.`package_currency`, `SchoolGroup`.`payment_plan`, `SchoolGroup`.`claim_visible`, `SchoolGroup`.`users_can_skip_email_phone_verification_code` FROM `classera_g2`.`school_groups` AS `SchoolGroup` WHERE `SchoolGroup`.`id` = 6259 LIMIT 1 | 1 | 1 | 0 | |
SELECT `School`.`type` FROM `classera_g2`.`schools` AS `School` WHERE `id` = 1000003 LIMIT 1 | 1 | 1 | 0 | |
SELECT `School`.`type` FROM `classera_g2`.`schools` AS `School` WHERE `id` = '' LIMIT 1 | 0 | 0 | 0 | |
SELECT `School`.`id`, `parent_id` AS `parent`, `name` AS `text` FROM `classera_g2`.`schools` AS `School` WHERE `School`.`id` = 1000010 AND `School`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `School`.`id`, `parent_id` AS `parent`, `name` AS `text` FROM `classera_g2`.`schools` AS `School` WHERE `School`.`id` = 1000020 AND `School`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 | |
SELECT `School`.`id`, `parent_id` AS `parent`, `name` AS `text` FROM `classera_g2`.`schools` AS `School` WHERE `School`.`id` = 1000012 AND `School`.`deleted` = '0' LIMIT 1 | 1 | 1 | 0 |
Peak Memory Use 5.24 MB
Message | Memory use |
---|---|
Component initialization | 1.67 MB |
Component initialization #2 | 3.52 MB |
Controller action start | 3.68 MB |
Controller render start | 3.96 MB |
View render complete | 4.66 MB |
Total Request Time: 77 (ms)
Message | Time in ms | Graph |
---|---|---|
Core Processing (Derived from $_SERVER["REQUEST_TIME"]) | 18.16 | |
Event: Controller.initialize | 7.79 | |
Event: Controller.startup | 0.35 | |
Controller action | 12.24 | |
Event: Controller.beforeRender | 3.36 | |
» Processing toolbar data | 2.30 | |
Rendering View | 27.43 | |
» Event: View.beforeRender | 0.01 | |
» Rendering APP/View/SchoolsRegistration/register_student_step1.ctp | 6.26 | |
» » Rendering APP/View/Elements/school_groups_tree.ctp | 0.82 | |
» » Rendering APP/View/Elements/school_groups_tree.ctp #2 | 0.98 | |
» Event: View.afterRender | 0.01 | |
» Event: View.beforeLayout | 0.01 | |
» Rendering APP/View/Layouts/public.ctp | 20.91 | |
» » Rendering APP/View/Elements/Hotjar.ctp | 0.02 | |
» » Rendering APP/View/Elements/favicons.ctp | 0.03 | |
» » Rendering APP/View/Elements/header_bs.ctp | 0.39 | |
» » » Rendering APP/View/Elements/favicons.ctp #2 | 0.04 | |
» » » Rendering APP/View/Elements/main_style_element.ctp | 0.15 | |
» » » » Rendering APP/View/Elements/animations_theme_bg.ctp | 0.01 | |
» » » Rendering APP/View/Elements/Hotjar.ctp #2 | 0.01 | |
» » Rendering APP/View/Elements/footer.ctp | 19.99 | |
» » » Rendering APP/View/Elements/table_export.ctp | 1.27 | |
» » » Rendering APP/View/Elements/national_days.ctp | 0.03 | |
» » » Rendering APP/View/Elements/edumall_popup_element.ctp | 0.02 | |
» » » Rendering APP/View/Elements/loading_lti_partners_from_automation.ctp | 1.13 | |
» » » Rendering APP/View/Elements/loading_authorized_actions_for_partners.ctp | 0.43 | |
» » » Rendering APP/View/Elements/load_additional_users_SSO.ctp | 0.17 | |
Event: View.afterLayout | 0.00 |
Constant | Value |
---|---|
CONFIG | '/var/www/pk-smile/app/Config/' |
HTMLPURIFIER_PREFIX | '/var/www/pk-smile/app/Vendor/ezyang/htmlpurifier/library' |
ClasseraCardUrl | 'https://cards.classera.com/' |
HOA | true |
SUCCEED | true |
FAILED | false |
… | '__hoa_core_fill' |
PS | ':' |
ROOT_SEPARATOR | ';' |
RS | ';' |
CRLF | '' |
OS_WIN | false |
S_64_BITS | true |
S_32_BITS | false |
π | (float) 3.1415926535898 |
nil | null |
_public | (int) 1 |
_protected | (int) 2 |
_private | (int) 4 |
_static | (int) 8 |
_abstract | (int) 16 |
_pure | (int) 32 |
_final | (int) 64 |
_dynamic | (int) -9 |
_concrete | (int) -17 |
_overridable | (int) -65 |
WITH_COMPOSER | true |
JSON_DECODE_FOURTH_ARG | true |
PHAR_UPDATE_MANIFEST_SCHEMA | '/var/www/pk-smile/app/Vendor/msgraph-sdk-php/vendor/herrera-io/phar-update/src/lib/../../res/schema.json' |
BUCKET | 'classera' |
BUCKET_ABS_URL | 'https://classera.s3.amazonaws.com/' |
Constant | Value |
---|---|
APP | '/var/www/pk-smile/app/' |
APP_DIR | 'app' |
APPLIBS | '/var/www/pk-smile/app/Lib/' |
CACHE | '/var/www/pk-smile/app/tmp/cache/' |
CAKE | '/var/www/pk-smile/lib/Cake/' |
CAKE_CORE_INCLUDE_PATH | '/var/www/pk-smile/lib' |
CORE_PATH | '/var/www/pk-smile/lib/' |
CAKE_VERSION | '2.10.19' |
CSS | '/var/www/pk-smile/app/webroot/css/' |
CSS_URL | 'css/' |
DS | '/' |
FULL_BASE_URL | 'https://pk-smile.classera.com' |
IMAGES | '/var/www/pk-smile/app/webroot/img/' |
IMAGES_URL | 'img/' |
JS | '/var/www/pk-smile/app/webroot/js/' |
JS_URL | 'js/' |
LOGS | '/var/www/pk-smile/app/tmp/logs/' |
ROOT | '/var/www/pk-smile' |
TESTS | '/var/www/pk-smile/app/Test/' |
TMP | '/var/www/pk-smile/app/tmp/' |
VENDORS | '/var/www/pk-smile/vendors/' |
WEBROOT_DIR | 'webroot' |
WWW_ROOT | '/var/www/pk-smile/app/webroot/' |
Environment Variable | Value |
---|---|
Php Version | '7.3.33-14+ubuntu20.04.1+deb.sury.org+1' |
User | 'www-data' |
Home | '/var/www' |
Http Cf Ipcountry | 'US' |
Http True Client Ip | '3.135.208.201' |
Http Cdn Loop | 'cloudflare; loops=1' |
Http Cf Connecting Ip | '3.135.208.201' |
Http User Agent | 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])' |
Http Accept | '*/*' |
Http Cf Visitor | '{"scheme":"https"}' |
Http X Forwarded Proto | 'https' |
Http Cf Ray | '8c4f8becfc2fcf5a-CMH' |
Http X Forwarded For | '3.135.208.201' |
Http Accept Encoding | 'gzip, br' |
Http Connection | 'Keep-Alive' |
Http Host | 'pk-smile.classera.com' |
Application Env | 'ME' |
Redirect Status | '200' |
Server Name | 'pk-smile.classera.com' |
Server Port | '443' |
Server Addr | '192.168.10.36' |
Remote Port | '63842' |
Remote Addr | '172.68.168.209' |
Server Software | 'nginx/1.18.0' |
Gateway Interface | 'CGI/1.1' |
Https | 'on' |
Request Scheme | 'https' |
Server Protocol | 'HTTP/1.1' |
Document Root | '/var/www/pk-smile/app/webroot' |
Document Uri | '/index.php' |
Request Uri | '/SchoolsRegistration/register_student_step1/eDlzOGQ5ODdzODc1ZnZkZmdlcmFzZGZhc2RmYXNkZmFzZGZhc2RmYWRmNTQxMjg2MjU5' |
Script Name | '/index.php' |
Content Length | '' |
Content Type | '' |
Request Method | 'GET' |
Query String | 'url=SchoolsRegistration/register_student_step1/eDlzOGQ5ODdzODc1ZnZkZmdlcmFzZGZhc2RmYXNkZmFzZGZhc2RmYWRmNTQxMjg2MjU5' |
Script Filename | '/var/www/pk-smile/app/webroot/index.php' |
Path Info | '' |
Fcgi Role | 'RESPONDER' |
Php Self | '/index.php' |
Request Time Float | (float) 1726643744.9148 |
Request Time | (int) 1726643744 |