https://staging.al-kunuz.com/fr/admin/

302 Redirect from
POST @app_login (32f88f)
Method
GET
HTTP Status
200
IP
196.117.76.148
Profiled on
Token
27bd23

Query Metrics

2 Database Queries
2 Different statements
1286.28 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 1.22 ms 
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.phone AS phone_6, t0.registration_date AS registration_date_7, t0.roles AS roles_8, t0.language AS language_9, t0.pole AS pole_10, t0.forum_url AS forum_url_11, t0.agreed_terms_at AS agreed_terms_at_12, t0.stripe_customer_id_for_subscription AS stripe_customer_id_for_subscription_13, t0.stripe_customer_id_for_group_session AS stripe_customer_id_for_group_session_14, t15.id AS id_16, t15.hourly_salary AS hourly_salary_17, t15.is_grader AS is_grader_18, t15.for_children AS for_children_19, t15.hourly_salary_waiting AS hourly_salary_waiting_20, t15.slack_channel AS slack_channel_21, t15.iban AS iban_22, t15.address AS address_23, t15.city AS city_24, t15.zip_code AS zip_code_25, t15.country AS country_26, t15.is_actif AS is_actif_27, t15.is_level_test AS is_level_test_28, t15.is_camera AS is_camera_29, t15.addon_for_arabic AS addon_for_arabic_30, t15.addon_for_quran AS addon_for_quran_31, t15.addon_for_children AS addon_for_children_32, t15.is_beginner AS is_beginner_33, t15.is_intermediate AS is_intermediate_34, t15.is_advanced AS is_advanced_35, t15.currency AS currency_36, t15.group_salary AS group_salary_37, t15.group_waiting_salary AS group_waiting_salary_38, t15.user_id_id AS user_id_id_39, t15.qiraa_id AS qiraa_id_40, t0.gender_id AS gender_id_41 FROM app_users t0 LEFT JOIN teacher t15 ON t15.user_id_id = t0.id WHERE t0.id = ?
Parameters: 
[
  309
]
View formatted query    View runnable query    Explain query
2 1285.06 ms 
SELECT p0_.id AS id_0, p0_.course_date AS course_date_1, p0_.payment_date AS payment_date_2, p0_.is_done AS is_done_3, p0_.is_canceled AS is_canceled_4, p0_.is_catchable AS is_catchable_5, p0_.is_catch_up_date AS is_catch_up_date_6, p0_.is_for_group AS is_for_group_7, p0_.is_waiting AS is_waiting_8, p0_.lost_minutes AS lost_minutes_9, p0_.catch_up_minutes AS catch_up_minutes_10, p0_.comment AS comment_11, p0_.price AS price_12, p0_.penalty AS penalty_13, p0_.is_abandoned AS is_abandoned_14, p0_.is_canceled_by_student AS is_canceled_by_student_15, p0_.is_canceled_by_us AS is_canceled_by_us_16, p0_.update_at AS update_at_17, p0_.update_by AS update_by_18, p0_.is_canceled_for_holiday AS is_canceled_for_holiday_19, p0_.is_test AS is_test_20, t1_.id AS id_21, t1_.free_date AS free_date_22, t1_.is_free AS is_free_23, t1_.occupied_until AS occupied_until_24, t1_.for_catch_up AS for_catch_up_25, t1_.is_blocked AS is_blocked_26, t1_.update_at AS update_at_27, t1_.update_by AS update_by_28, t1_.for_video AS for_video_29, t1_.comments AS comments_30, t1_.for_ramadan AS for_ramadan_31, t1_.is_for_level_test AS is_for_level_test_32, r2_.id AS id_33, r2_.name AS name_34, r2_.url_with_password AS url_with_password_35, r2_.url_without_password AS url_without_password_36, r2_.room_password AS room_password_37, t3_.id AS id_38, t3_.hourly_salary AS hourly_salary_39, t3_.is_grader AS is_grader_40, t3_.for_children AS for_children_41, t3_.hourly_salary_waiting AS hourly_salary_waiting_42, t3_.slack_channel AS slack_channel_43, t3_.iban AS iban_44, t3_.address AS address_45, t3_.city AS city_46, t3_.zip_code AS zip_code_47, t3_.country AS country_48, t3_.is_actif AS is_actif_49, t3_.is_level_test AS is_level_test_50, t3_.is_camera AS is_camera_51, t3_.addon_for_arabic AS addon_for_arabic_52, t3_.addon_for_quran AS addon_for_quran_53, t3_.addon_for_children AS addon_for_children_54, t3_.is_beginner AS is_beginner_55, t3_.is_intermediate AS is_intermediate_56, t3_.is_advanced AS is_advanced_57, t3_.currency AS currency_58, t3_.group_salary AS group_salary_59, t3_.group_waiting_salary AS group_waiting_salary_60, a4_.id AS id_61, a4_.email AS email_62, a4_.password AS password_63, a4_.firstname AS firstname_64, a4_.lastname AS lastname_65, a4_.phone AS phone_66, a4_.registration_date AS registration_date_67, a4_.roles AS roles_68, a4_.language AS language_69, a4_.pole AS pole_70, a4_.forum_url AS forum_url_71, a4_.agreed_terms_at AS agreed_terms_at_72, a4_.stripe_customer_id_for_subscription AS stripe_customer_id_for_subscription_73, a4_.stripe_customer_id_for_group_session AS stripe_customer_id_for_group_session_74, a5_.id AS id_75, a5_.was_caught_up AS was_caught_up_76, a5_.catch_up_date AS catch_up_date_77, a5_.is_canceled AS is_canceled_78, a5_.is_abandoned AS is_abandoned_79, s6_.id AS id_80, s6_.display_name AS display_name_81, s6_.day AS day_82, s6_.day_nb AS day_nb_83, s6_.start_time AS start_time_84, s6_.end_time AS end_time_85, s6_.duration AS duration_86, s6_.display_name_en AS display_name_en_87, s6_.day_en AS day_en_88, s6_.is_night AS is_night_89, s6_.is_standard AS is_standard_90, a7_.id AS id_91, a7_.was_caught_up AS was_caught_up_92, a7_.catch_up_date AS catch_up_date_93, a7_.is_canceled AS is_canceled_94, a7_.is_abandoned AS is_abandoned_95, s8_.id AS id_96, s8_.on_time AS on_time_97, s8_.revision AS revision_98, s8_.oral AS oral_99, s8_.reading AS reading_100, s8_.comprehension AS comprehension_101, s8_.grammar AS grammar_102, s8_.dictation AS dictation_103, s8_.participation AS participation_104, s8_.is_technical_pb AS is_technical_pb_105, s8_.studied_today AS studied_today_106, s8_.homework AS homework_107, s8_.comment AS comment_108, s8_.memorizing AS memorizing_109, s8_.memorizing_level AS memorizing_level_110, s8_.coran_revision AS coran_revision_111, s8_.coran_revision_level AS coran_revision_level_112, s8_.new_sourate AS new_sourate_113, s8_.new_revision AS new_revision_114, s8_.sent_at AS sent_at_115, s8_.edit_at AS edit_at_116, s9_.id AS id_117, s9_.customer_id AS customer_id_118, s9_.purchase_date AS purchase_date_119, s9_.update_at AS update_at_120, s9_.is_actif AS is_actif_121, s9_.courses_start_at AS courses_start_at_122, s9_.catch_up_right AS catch_up_right_123, s9_.next_payment_date AS next_payment_date_124, s9_.card_brand AS card_brand_125, s9_.card_last4 AS card_last4_126, s9_.stripe_subscription_id AS stripe_subscription_id_127, s9_.renew_before AS renew_before_128, s9_.is_cancelled AS is_cancelled_129, s9_.nb_of_schedule_choose AS nb_of_schedule_choose_130, s9_.is_due AS is_due_131, s9_.next_payment_time_stamp AS next_payment_time_stamp_132, s9_.last_paid_course AS last_paid_course_133, s9_.cancellation_date AS cancellation_date_134, s9_.paid_amount AS paid_amount_135, s9_.total_lost_minutes AS total_lost_minutes_136, s9_.have_ramadan_credit AS have_ramadan_credit_137, s9_.ramadan_credit_amount AS ramadan_credit_amount_138, a10_.id AS id_139, a10_.email AS email_140, a10_.password AS password_141, a10_.firstname AS firstname_142, a10_.lastname AS lastname_143, a10_.phone AS phone_144, a10_.registration_date AS registration_date_145, a10_.roles AS roles_146, a10_.language AS language_147, a10_.pole AS pole_148, a10_.forum_url AS forum_url_149, a10_.agreed_terms_at AS agreed_terms_at_150, a10_.stripe_customer_id_for_subscription AS stripe_customer_id_for_subscription_151, a10_.stripe_customer_id_for_group_session AS stripe_customer_id_for_group_session_152, t11_.id AS id_153, t11_.hourly_salary AS hourly_salary_154, t11_.is_grader AS is_grader_155, t11_.for_children AS for_children_156, t11_.hourly_salary_waiting AS hourly_salary_waiting_157, t11_.slack_channel AS slack_channel_158, t11_.iban AS iban_159, t11_.address AS address_160, t11_.city AS city_161, t11_.zip_code AS zip_code_162, t11_.country AS country_163, t11_.is_actif AS is_actif_164, t11_.is_level_test AS is_level_test_165, t11_.is_camera AS is_camera_166, t11_.addon_for_arabic AS addon_for_arabic_167, t11_.addon_for_quran AS addon_for_quran_168, t11_.addon_for_children AS addon_for_children_169, t11_.is_beginner AS is_beginner_170, t11_.is_intermediate AS is_intermediate_171, t11_.is_advanced AS is_advanced_172, t11_.currency AS currency_173, t11_.group_salary AS group_salary_174, t11_.group_waiting_salary AS group_waiting_salary_175, c12_.id AS id_176, c12_.first_name AS first_name_177, c12_.last_name AS last_name_178, c12_.birth_date AS birth_date_179, c12_.forum_url AS forum_url_180, c12_.is_child AS is_child_181, c12_.is_teen AS is_teen_182, c12_.is_adult AS is_adult_183, p0_.teacher_schedule_id AS teacher_schedule_id_184, p0_.subscription_order_id AS subscription_order_id_185, p0_.absence_log_related_id AS absence_log_related_id_186, p0_.session_group_id AS session_group_id_187, p0_.video_registration_id AS video_registration_id_188, p0_.ticket_order_id AS ticket_order_id_189, p0_.user_test_level_id AS user_test_level_id_190, t1_.teacher_id AS teacher_id_191, t1_.schedule_institute_id AS schedule_institute_id_192, t1_.session_course_id AS session_course_id_193, t1_.next_session_course_id AS next_session_course_id_194, t1_.subscription_order_id AS subscription_order_id_195, t1_.room_id AS room_id_196, t3_.user_id_id AS user_id_id_197, t3_.qiraa_id AS qiraa_id_198, a4_.gender_id AS gender_id_199, a5_.course_to_catch_up_id AS course_to_catch_up_id_200, a5_.subscription_id AS subscription_id_201, a5_.group_session_id AS group_session_id_202, a5_.catch_up_schedule_id AS catch_up_schedule_id_203, a7_.course_to_catch_up_id AS course_to_catch_up_id_204, a7_.subscription_id AS subscription_id_205, a7_.group_session_id AS group_session_id_206, a7_.catch_up_schedule_id AS catch_up_schedule_id_207, s8_.course_date_id AS course_date_id_208, s8_.subscription_id AS subscription_id_209, s9_.participant_id AS participant_id_210, s9_.user_id AS user_id_211, s9_.plan_id AS plan_id_212, s9_.teacher_id AS teacher_id_213, s9_.category_id AS category_id_214, s9_.subject_id AS subject_id_215, s9_.subject_level_id AS subject_level_id_216, a10_.gender_id AS gender_id_217, t11_.user_id_id AS user_id_id_218, t11_.qiraa_id AS qiraa_id_219, c12_.parent_id AS parent_id_220, c12_.gender_id AS gender_id_221 FROM paid_course_list p0_ INNER JOIN teacher_schedule t1_ ON p0_.teacher_schedule_id = t1_.id LEFT JOIN room r2_ ON t1_.room_id = r2_.id LEFT JOIN teacher t3_ ON t1_.teacher_id = t3_.id LEFT JOIN app_users a4_ ON t3_.user_id_id = a4_.id LEFT JOIN absence_log a5_ ON t1_.id = a5_.catch_up_schedule_id INNER JOIN schedule_institute s6_ ON t1_.schedule_institute_id = s6_.id LEFT JOIN absence_log a7_ ON p0_.id = a7_.course_to_catch_up_id LEFT JOIN subscription_lesson_report s8_ ON p0_.id = s8_.course_date_id LEFT JOIN subscription_order s9_ ON p0_.subscription_order_id = s9_.id LEFT JOIN app_users a10_ ON s9_.user_id = a10_.id LEFT JOIN teacher t11_ ON a10_.id = t11_.user_id_id LEFT JOIN child c12_ ON s9_.participant_id = c12_.id WHERE p0_.course_date > ? AND p0_.course_date < ? AND p0_.is_abandoned = ? AND p0_.is_canceled_for_holiday = ? ORDER BY s6_.start_time ASC
Parameters: 
[
  "2025-11-01 00:01:00"
  "2025-11-01 23:59:00"
  0
  0
]
View formatted query    View runnable query    Explain query

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 No errors.
App\Entity\Teacher No errors.
App\Entity\Qiraa No errors.
App\Entity\Gender No errors.
App\Entity\Child No errors.
App\Entity\SessionOrder No errors.
App\Entity\SubscriptionOrder No errors.
App\Entity\OldUserEmail No errors.
App\Entity\VideoCoursesRegistration No errors.
App\Entity\Notifications No errors.
App\Entity\TicketOrder No errors.
App\Entity\UserPlacementTest No errors.
App\Entity\Exam No errors.
App\Entity\TrainingReport No errors.
App\Entity\PaidCourseList No errors.
App\Entity\TeacherSchedule No errors.
App\Entity\Room No errors.
App\Entity\AbsenceLog No errors.
App\Entity\ScheduleInstitute No errors.
App\Entity\SubscriptionLessonReport No errors.
App\Entity\Session No errors.
App\Entity\Plan No errors.
App\Entity\Category No errors.
App\Entity\Subject No errors.
App\Entity\SubjectLevel No errors.
App\Entity\TeacherSalary No errors.
App\Entity\GroupCourseLessonReport No errors.
App\Entity\TeacherSubject No errors.
App\Entity\Homework No errors.
App\Entity\VideoProgram No errors.
App\Entity\VideoDividend No errors.
App\Entity\MainTeacherSalary No errors.
App\Entity\TeacherLeveltest No errors.
App\Entity\PlanUpdateLog No errors.
App\Entity\ActiveCampainSubscribeLostLog No errors.
App\Entity\ActiveCampainUnsubscribeLog No errors.