Symfony Profiler

SHOW FULL TABLES
WHERE
  Table_type = 'BASE TABLE'

SHOW FULL TABLES WHERE Table_type = 'BASE TABLE';

SELECT
  r0_.id AS id_0,
  r0_.is_redoubling AS is_redoubling_1,
  r0_.is_diet AS is_diet_2,
  r0_.is_internal AS is_internal_3,
  r0_.is_affected AS is_affected_4,
  r0_.registered_at AS registered_at_5,
  r0_.created_at AS created_at_6,
  r0_.updated_at AS updated_at_7,
  r0_.created_by AS created_by_8,
  r0_.updated_by AS updated_by_9,
  r0_.last_amount_paid AS last_amount_paid_10,
  r0_.last_payment_id AS last_payment_id_11,
  r0_.last_payment_at AS last_payment_at_12,
  r0_.image AS image_13,
  r0_.is_abandonned AS is_abandonned_14,
  r0_.as_food_restrictions AS as_food_restrictions_15,
  r0_.is_meatless_menu AS is_meatless_menu_16,
  r0_.is_menu_without_pork AS is_menu_without_pork_17,
  r0_.is_can_eat_alone AS is_can_eat_alone_18,
  r0_.is_can_do_his_business_alone AS is_can_do_his_business_alone_19,
  r0_.is_falls_sleep_easily AS is_falls_sleep_easily_20,
  r0_.is_new AS is_new_21,
  r0_.portal_login AS portal_login_22,
  r0_.portal_password AS portal_password_23,
  r0_.is_authorized_alone AS is_authorized_alone_24,
  r1_.id AS id_25,
  r1_.code AS code_26,
  r1_.last_name AS last_name_27,
  r1_.first_name AS first_name_28,
  r1_.notification_phone_number AS notification_phone_number_29,
  r1_.notification_name AS notification_name_30,
  r1_.notification_watsapp_number AS notification_watsapp_number_31,
  r1_.observation AS observation_32,
  r1_.location AS location_33,
  r1_.gender AS gender_34,
  r1_.birthday AS birthday_35,
  r1_.birth_location AS birth_location_36,
  r1_.birth_certificate_number AS birth_certificate_number_37,
  r1_.created_at AS created_at_38,
  r1_.updated_at AS updated_at_39,
  r1_.created_by AS created_by_40,
  r1_.updated_by AS updated_by_41,
  r1_.image AS image_42,
  r1_.create_date AS create_date_43,
  r1_.is_affected AS is_affected_44,
  r1_.is_redoubling AS is_redoubling_45,
  r1_.last_school_attended AS last_school_attended_46,
  r1_.last_school_attended_type AS last_school_attended_type_47,
  r1_.registration_number AS registration_number_48,
  r1_.lv1 AS lv1_49,
  r1_.lv2 AS lv2_50,
  r1_.art_or_musique AS art_or_musique_51,
  r1_.nationality AS nationality_52,
  r1_.where_resides AS where_resides_53,
  r1_.parent_status AS parent_status_54,
  r1_.is_parntal_authority_father AS is_parntal_authority_father_55,
  r1_.is_father_call_to_emergency AS is_father_call_to_emergency_56,
  r1_.father_last_name AS father_last_name_57,
  r1_.father_first_name AS father_first_name_58,
  r1_.father_address AS father_address_59,
  r1_.father_phone_number AS father_phone_number_60,
  r1_.father_post AS father_post_61,
  r1_.father_location AS father_location_62,
  r1_.father_email AS father_email_63,
  r1_.is_parntal_authority_mother AS is_parntal_authority_mother_64,
  r1_.is_mother_call_to_emergency AS is_mother_call_to_emergency_65,
  r1_.mother_last_name AS mother_last_name_66,
  r1_.mother_first_name AS mother_first_name_67,
  r1_.mother_address AS mother_address_68,
  r1_.mother_phone_number AS mother_phone_number_69,
  r1_.mother_post AS mother_post_70,
  r1_.mother_location AS mother_location_71,
  r1_.mother_email AS mother_email_72,
  r1_.responsible_of_schooling AS responsible_of_schooling_73,
  r1_.responsible_of_schooling_last_name AS responsible_of_schooling_last_name_74,
  r1_.responsible_of_schooling_first_name AS responsible_of_schooling_first_name_75,
  r1_.responsible_of_schooling_address AS responsible_of_schooling_address_76,
  r1_.responsible_of_schooling_phone_number AS responsible_of_schooling_phone_number_77,
  r1_.responsible_of_schooling_post AS responsible_of_schooling_post_78,
  r1_.responsible_of_schooling_location AS responsible_of_schooling_location_79,
  r1_.accompanying_person_name AS accompanying_person_name_80,
  r1_.accompanying_person_phone_number AS accompanying_person_phone_number_81,
  r1_.accompanying_person_name_2 AS accompanying_person_name_2_82,
  r1_.accompanying_person_phone_number_2 AS accompanying_person_phone_number_2_83,
  r1_.accompanying_person_name_3 AS accompanying_person_name_3_84,
  r1_.accompanying_person_phone_number_3 AS accompanying_person_phone_number_3_85,
  r1_.doctor_name AS doctor_name_86,
  r1_.doctor_phone_number AS doctor_phone_number_87,
  r1_.other_medical_history AS other_medical_history_88,
  r1_.other_learning_difficulty AS other_learning_difficulty_89,
  r1_.teacher_observation AS teacher_observation_90,
  r1_.parent_observation AS parent_observation_91,
  r1_.anterior_balance AS anterior_balance_92,
  r1_.is_archived AS is_archived_93,
  r0_.establishment_id AS establishment_id_94,
  r0_.student_id AS student_id_95,
  r0_.school_year_id AS school_year_id_96,
  r0_.classroom_id AS classroom_id_97,
  r0_.registration_student_pre_registration_id AS registration_student_pre_registration_id_98,
  r1_.establishment_id AS establishment_id_99,
  r1_.entry_level_id AS entry_level_id_100,
  r1_.medical_history_id AS medical_history_id_101,
  r1_.learning_difficulty_id AS learning_difficulty_id_102
FROM
  registration_student_registration r0_
  INNER JOIN registration_student r1_ ON r0_.student_id = r1_.id
WHERE
  r0_.establishment_id = ?
  AND r0_.school_year_id = ?
  AND r0_.is_abandonned = ?
ORDER BY
  r0_.id DESC

SELECT r0_.id AS id_0, r0_.is_redoubling AS is_redoubling_1, r0_.is_diet AS is_diet_2, r0_.is_internal AS is_internal_3, r0_.is_affected AS is_affected_4, r0_.registered_at AS registered_at_5, r0_.created_at AS created_at_6, r0_.updated_at AS updated_at_7, r0_.created_by AS created_by_8, r0_.updated_by AS updated_by_9, r0_.last_amount_paid AS last_amount_paid_10, r0_.last_payment_id AS last_payment_id_11, r0_.last_payment_at AS last_payment_at_12, r0_.image AS image_13, r0_.is_abandonned AS is_abandonned_14, r0_.as_food_restrictions AS as_food_restrictions_15, r0_.is_meatless_menu AS is_meatless_menu_16, r0_.is_menu_without_pork AS is_menu_without_pork_17, r0_.is_can_eat_alone AS is_can_eat_alone_18, r0_.is_can_do_his_business_alone AS is_can_do_his_business_alone_19, r0_.is_falls_sleep_easily AS is_falls_sleep_easily_20, r0_.is_new AS is_new_21, r0_.portal_login AS portal_login_22, r0_.portal_password AS portal_password_23, r0_.is_authorized_alone AS is_authorized_alone_24, r1_.id AS id_25, r1_.code AS code_26, r1_.last_name AS last_name_27, r1_.first_name AS first_name_28, r1_.notification_phone_number AS notification_phone_number_29, r1_.notification_name AS notification_name_30, r1_.notification_watsapp_number AS notification_watsapp_number_31, r1_.observation AS observation_32, r1_.location AS location_33, r1_.gender AS gender_34, r1_.birthday AS birthday_35, r1_.birth_location AS birth_location_36, r1_.birth_certificate_number AS birth_certificate_number_37, r1_.created_at AS created_at_38, r1_.updated_at AS updated_at_39, r1_.created_by AS created_by_40, r1_.updated_by AS updated_by_41, r1_.image AS image_42, r1_.create_date AS create_date_43, r1_.is_affected AS is_affected_44, r1_.is_redoubling AS is_redoubling_45, r1_.last_school_attended AS last_school_attended_46, r1_.last_school_attended_type AS last_school_attended_type_47, r1_.registration_number AS registration_number_48, r1_.lv1 AS lv1_49, r1_.lv2 AS lv2_50, r1_.art_or_musique AS art_or_musique_51, r1_.nationality AS nationality_52, r1_.where_resides AS where_resides_53, r1_.parent_status AS parent_status_54, r1_.is_parntal_authority_father AS is_parntal_authority_father_55, r1_.is_father_call_to_emergency AS is_father_call_to_emergency_56, r1_.father_last_name AS father_last_name_57, r1_.father_first_name AS father_first_name_58, r1_.father_address AS father_address_59, r1_.father_phone_number AS father_phone_number_60, r1_.father_post AS father_post_61, r1_.father_location AS father_location_62, r1_.father_email AS father_email_63, r1_.is_parntal_authority_mother AS is_parntal_authority_mother_64, r1_.is_mother_call_to_emergency AS is_mother_call_to_emergency_65, r1_.mother_last_name AS mother_last_name_66, r1_.mother_first_name AS mother_first_name_67, r1_.mother_address AS mother_address_68, r1_.mother_phone_number AS mother_phone_number_69, r1_.mother_post AS mother_post_70, r1_.mother_location AS mother_location_71, r1_.mother_email AS mother_email_72, r1_.responsible_of_schooling AS responsible_of_schooling_73, r1_.responsible_of_schooling_last_name AS responsible_of_schooling_last_name_74, r1_.responsible_of_schooling_first_name AS responsible_of_schooling_first_name_75, r1_.responsible_of_schooling_address AS responsible_of_schooling_address_76, r1_.responsible_of_schooling_phone_number AS responsible_of_schooling_phone_number_77, r1_.responsible_of_schooling_post AS responsible_of_schooling_post_78, r1_.responsible_of_schooling_location AS responsible_of_schooling_location_79, r1_.accompanying_person_name AS accompanying_person_name_80, r1_.accompanying_person_phone_number AS accompanying_person_phone_number_81, r1_.accompanying_person_name_2 AS accompanying_person_name_2_82, r1_.accompanying_person_phone_number_2 AS accompanying_person_phone_number_2_83, r1_.accompanying_person_name_3 AS accompanying_person_name_3_84, r1_.accompanying_person_phone_number_3 AS accompanying_person_phone_number_3_85, r1_.doctor_name AS doctor_name_86, r1_.doctor_phone_number AS doctor_phone_number_87, r1_.other_medical_history AS other_medical_history_88, r1_.other_learning_difficulty AS other_learning_difficulty_89, r1_.teacher_observation AS teacher_observation_90, r1_.parent_observation AS parent_observation_91, r1_.anterior_balance AS anterior_balance_92, r1_.is_archived AS is_archived_93, r0_.establishment_id AS establishment_id_94, r0_.student_id AS student_id_95, r0_.school_year_id AS school_year_id_96, r0_.classroom_id AS classroom_id_97, r0_.registration_student_pre_registration_id AS registration_student_pre_registration_id_98, r1_.establishment_id AS establishment_id_99, r1_.entry_level_id AS entry_level_id_100, r1_.medical_history_id AS medical_history_id_101, r1_.learning_difficulty_id AS learning_difficulty_id_102 FROM registration_student_registration r0_ INNER JOIN registration_student r1_ ON r0_.student_id = r1_.id WHERE r0_.establishment_id = 20 AND r0_.school_year_id = 4 AND r0_.is_abandonned = 0 ORDER BY r0_.id DESC;

SELECT
  t0.id AS id_1,
  t0.order_num AS order_num_2,
  t0.date_due AS date_due_3,
  t0.amount AS amount_4,
  t0.amount_paid AS amount_paid_5,
  t0.last_amount_paid AS last_amount_paid_6,
  t0.last_payment_id AS last_payment_id_7,
  t0.last_payment_at AS last_payment_at_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t0.created_by AS created_by_11,
  t0.updated_by AS updated_by_12,
  t0.amount_cancel AS amount_cancel_13,
  t0.is_cancel AS is_cancel_14,
  t0.amount_reported AS amount_reported_15,
  t0.is_reported AS is_reported_16,
  t0.establishment_id AS establishment_id_17,
  t0.student_registration_fee_id AS student_registration_fee_id_18
FROM
  accounting_student_registration_fee_shedul t0
WHERE
  t0.student_registration_fee_id = ?
ORDER BY
  t0.date_due ASC

SELECT t0.id AS id_1, t0.order_num AS order_num_2, t0.date_due AS date_due_3, t0.amount AS amount_4, t0.amount_paid AS amount_paid_5, t0.last_amount_paid AS last_amount_paid_6, t0.last_payment_id AS last_payment_id_7, t0.last_payment_at AS last_payment_at_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12, t0.amount_cancel AS amount_cancel_13, t0.is_cancel AS is_cancel_14, t0.amount_reported AS amount_reported_15, t0.is_reported AS is_reported_16, t0.establishment_id AS establishment_id_17, t0.student_registration_fee_id AS student_registration_fee_id_18 FROM accounting_student_registration_fee_shedul t0 WHERE t0.student_registration_fee_id = 150207 ORDER BY t0.date_due ASC;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.label AS label_3,
  t0.amount AS amount_4,
  t0.last_amount_paid AS last_amount_paid_5,
  t0.last_payment_id AS last_payment_id_6,
  t0.last_payment_at AS last_payment_at_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9,
  t0.created_by AS created_by_10,
  t0.updated_by AS updated_by_11,
  t0.amount_cancel AS amount_cancel_12,
  t0.amount_reported AS amount_reported_13,
  t0.is_reported AS is_reported_14,
  t0.is_cancel AS is_cancel_15,
  t0.is_archived AS is_archived_16,
  t0.duration AS duration_17,
  t0.start_at AS start_at_18,
  t0.end_at AS end_at_19,
  t0.establishment_id AS establishment_id_20,
  t0.student_registration_id AS student_registration_id_21,
  t0.fee_id AS fee_id_22
FROM
  accounting_student_registration_fee t0
WHERE
  t0.student_registration_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.amount AS amount_4, t0.last_amount_paid AS last_amount_paid_5, t0.last_payment_id AS last_payment_id_6, t0.last_payment_at AS last_payment_at_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11, t0.amount_cancel AS amount_cancel_12, t0.amount_reported AS amount_reported_13, t0.is_reported AS is_reported_14, t0.is_cancel AS is_cancel_15, t0.is_archived AS is_archived_16, t0.duration AS duration_17, t0.start_at AS start_at_18, t0.end_at AS end_at_19, t0.establishment_id AS establishment_id_20, t0.student_registration_id AS student_registration_id_21, t0.fee_id AS fee_id_22 FROM accounting_student_registration_fee t0 WHERE t0.student_registration_id = 32931;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.capacity AS capacity_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.created_by AS created_by_6,
  t0.updated_by AS updated_by_7,
  t0.is_excellent AS is_excellent_8,
  t0.establishment_id AS establishment_id_9,
  t0.level_id AS level_id_10,
  t0.faculty_id AS faculty_id_11,
  t0.round_id AS round_id_12,
  t0.school_year_id AS school_year_id_13
FROM
  setting_classroom t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.capacity AS capacity_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7, t0.is_excellent AS is_excellent_8, t0.establishment_id AS establishment_id_9, t0.level_id AS level_id_10, t0.faculty_id AS faculty_id_11, t0.round_id AS round_id_12, t0.school_year_id AS school_year_id_13 FROM setting_classroom t0 WHERE t0.id = 1995;

SELECT
  t0.id AS id_1,
  t0.amount AS amount_2,
  t0.code AS code_3,
  t0.label AS label_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.created_by AS created_by_7,
  t0.updated_by AS updated_by_8,
  t0.establishment_id AS establishment_id_9,
  t0.student_registration_fee_id AS student_registration_fee_id_10,
  t0.student_registration_fee_shedul_id AS student_registration_fee_shedul_id_11,
  t0.cash_movement_id AS cash_movement_id_12,
  t0.cash_register_id AS cash_register_id_13,
  t0.accounting_account_id AS accounting_account_id_14,
  t0.student_registration_payment_id AS student_registration_payment_id_15
FROM
  accounting_student_registration_fee_shedul_payment t0
WHERE
  t0.student_registration_payment_id = ?

SELECT t0.id AS id_1, t0.amount AS amount_2, t0.code AS code_3, t0.label AS label_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.establishment_id AS establishment_id_9, t0.student_registration_fee_id AS student_registration_fee_id_10, t0.student_registration_fee_shedul_id AS student_registration_fee_shedul_id_11, t0.cash_movement_id AS cash_movement_id_12, t0.cash_register_id AS cash_register_id_13, t0.accounting_account_id AS accounting_account_id_14, t0.student_registration_payment_id AS student_registration_payment_id_15 FROM accounting_student_registration_fee_shedul_payment t0 WHERE t0.student_registration_payment_id = 126791;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.method AS method_3,
  t0.memo AS memo_4,
  t0.amount AS amount_5,
  t0.create_at AS create_at_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.establishment_id AS establishment_id_11,
  t0.student_registration_id AS student_registration_id_12,
  t0.cash_register_id AS cash_register_id_13,
  t0.school_year_id AS school_year_id_14
FROM
  accounting_student_registration_payment t0
WHERE
  t0.student_registration_id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.method AS method_3, t0.memo AS memo_4, t0.amount AS amount_5, t0.create_at AS create_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.establishment_id AS establishment_id_11, t0.student_registration_id AS student_registration_id_12, t0.cash_register_id AS cash_register_id_13, t0.school_year_id AS school_year_id_14 FROM accounting_student_registration_payment t0 WHERE t0.student_registration_id = 32931;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.last_name AS last_name_3,
  t0.first_name AS first_name_4,
  t0.notification_phone_number AS notification_phone_number_5,
  t0.notification_name AS notification_name_6,
  t0.notification_watsapp_number AS notification_watsapp_number_7,
  t0.observation AS observation_8,
  t0.location AS location_9,
  t0.gender AS gender_10,
  t0.birthday AS birthday_11,
  t0.birth_location AS birth_location_12,
  t0.birth_certificate_number AS birth_certificate_number_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.created_by AS created_by_16,
  t0.updated_by AS updated_by_17,
  t0.image AS image_18,
  t0.create_date AS create_date_19,
  t0.is_affected AS is_affected_20,
  t0.is_redoubling AS is_redoubling_21,
  t0.last_school_attended AS last_school_attended_22,
  t0.last_school_attended_type AS last_school_attended_type_23,
  t0.registration_number AS registration_number_24,
  t0.lv1 AS lv1_25,
  t0.lv2 AS lv2_26,
  t0.art_or_musique AS art_or_musique_27,
  t0.nationality AS nationality_28,
  t0.where_resides AS where_resides_29,
  t0.parent_status AS parent_status_30,
  t0.is_parntal_authority_father AS is_parntal_authority_father_31,
  t0.is_father_call_to_emergency AS is_father_call_to_emergency_32,
  t0.father_last_name AS father_last_name_33,
  t0.father_first_name AS father_first_name_34,
  t0.father_address AS father_address_35,
  t0.father_phone_number AS father_phone_number_36,
  t0.father_post AS father_post_37,
  t0.father_location AS father_location_38,
  t0.father_email AS father_email_39,
  t0.is_parntal_authority_mother AS is_parntal_authority_mother_40,
  t0.is_mother_call_to_emergency AS is_mother_call_to_emergency_41,
  t0.mother_last_name AS mother_last_name_42,
  t0.mother_first_name AS mother_first_name_43,
  t0.mother_address AS mother_address_44,
  t0.mother_phone_number AS mother_phone_number_45,
  t0.mother_post AS mother_post_46,
  t0.mother_location AS mother_location_47,
  t0.mother_email AS mother_email_48,
  t0.responsible_of_schooling AS responsible_of_schooling_49,
  t0.responsible_of_schooling_last_name AS responsible_of_schooling_last_name_50,
  t0.responsible_of_schooling_first_name AS responsible_of_schooling_first_name_51,
  t0.responsible_of_schooling_address AS responsible_of_schooling_address_52,
  t0.responsible_of_schooling_phone_number AS responsible_of_schooling_phone_number_53,
  t0.responsible_of_schooling_post AS responsible_of_schooling_post_54,
  t0.responsible_of_schooling_location AS responsible_of_schooling_location_55,
  t0.accompanying_person_name AS accompanying_person_name_56,
  t0.accompanying_person_phone_number AS accompanying_person_phone_number_57,
  t0.accompanying_person_name_2 AS accompanying_person_name_2_58,
  t0.accompanying_person_phone_number_2 AS accompanying_person_phone_number_2_59,
  t0.accompanying_person_name_3 AS accompanying_person_name_3_60,
  t0.accompanying_person_phone_number_3 AS accompanying_person_phone_number_3_61,
  t0.doctor_name AS doctor_name_62,
  t0.doctor_phone_number AS doctor_phone_number_63,
  t0.other_medical_history AS other_medical_history_64,
  t0.other_learning_difficulty AS other_learning_difficulty_65,
  t0.teacher_observation AS teacher_observation_66,
  t0.parent_observation AS parent_observation_67,
  t0.anterior_balance AS anterior_balance_68,
  t0.is_archived AS is_archived_69,
  t0.establishment_id AS establishment_id_70,
  t0.entry_level_id AS entry_level_id_71,
  t0.medical_history_id AS medical_history_id_72,
  t0.learning_difficulty_id AS learning_difficulty_id_73
FROM
  registration_student t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.code AS code_2, t0.last_name AS last_name_3, t0.first_name AS first_name_4, t0.notification_phone_number AS notification_phone_number_5, t0.notification_name AS notification_name_6, t0.notification_watsapp_number AS notification_watsapp_number_7, t0.observation AS observation_8, t0.location AS location_9, t0.gender AS gender_10, t0.birthday AS birthday_11, t0.birth_location AS birth_location_12, t0.birth_certificate_number AS birth_certificate_number_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17, t0.image AS image_18, t0.create_date AS create_date_19, t0.is_affected AS is_affected_20, t0.is_redoubling AS is_redoubling_21, t0.last_school_attended AS last_school_attended_22, t0.last_school_attended_type AS last_school_attended_type_23, t0.registration_number AS registration_number_24, t0.lv1 AS lv1_25, t0.lv2 AS lv2_26, t0.art_or_musique AS art_or_musique_27, t0.nationality AS nationality_28, t0.where_resides AS where_resides_29, t0.parent_status AS parent_status_30, t0.is_parntal_authority_father AS is_parntal_authority_father_31, t0.is_father_call_to_emergency AS is_father_call_to_emergency_32, t0.father_last_name AS father_last_name_33, t0.father_first_name AS father_first_name_34, t0.father_address AS father_address_35, t0.father_phone_number AS father_phone_number_36, t0.father_post AS father_post_37, t0.father_location AS father_location_38, t0.father_email AS father_email_39, t0.is_parntal_authority_mother AS is_parntal_authority_mother_40, t0.is_mother_call_to_emergency AS is_mother_call_to_emergency_41, t0.mother_last_name AS mother_last_name_42, t0.mother_first_name AS mother_first_name_43, t0.mother_address AS mother_address_44, t0.mother_phone_number AS mother_phone_number_45, t0.mother_post AS mother_post_46, t0.mother_location AS mother_location_47, t0.mother_email AS mother_email_48, t0.responsible_of_schooling AS responsible_of_schooling_49, t0.responsible_of_schooling_last_name AS responsible_of_schooling_last_name_50, t0.responsible_of_schooling_first_name AS responsible_of_schooling_first_name_51, t0.responsible_of_schooling_address AS responsible_of_schooling_address_52, t0.responsible_of_schooling_phone_number AS responsible_of_schooling_phone_number_53, t0.responsible_of_schooling_post AS responsible_of_schooling_post_54, t0.responsible_of_schooling_location AS responsible_of_schooling_location_55, t0.accompanying_person_name AS accompanying_person_name_56, t0.accompanying_person_phone_number AS accompanying_person_phone_number_57, t0.accompanying_person_name_2 AS accompanying_person_name_2_58, t0.accompanying_person_phone_number_2 AS accompanying_person_phone_number_2_59, t0.accompanying_person_name_3 AS accompanying_person_name_3_60, t0.accompanying_person_phone_number_3 AS accompanying_person_phone_number_3_61, t0.doctor_name AS doctor_name_62, t0.doctor_phone_number AS doctor_phone_number_63, t0.other_medical_history AS other_medical_history_64, t0.other_learning_difficulty AS other_learning_difficulty_65, t0.teacher_observation AS teacher_observation_66, t0.parent_observation AS parent_observation_67, t0.anterior_balance AS anterior_balance_68, t0.is_archived AS is_archived_69, t0.establishment_id AS establishment_id_70, t0.entry_level_id AS entry_level_id_71, t0.medical_history_id AS medical_history_id_72, t0.learning_difficulty_id AS learning_difficulty_id_73 FROM registration_student t0 WHERE t0.id = 34400;

SELECT
  COLUMN_NAME AS Field,
  COLUMN_TYPE AS Type,
  IS_NULLABLE AS `Null`,
  COLUMN_KEY AS `Key`,
  COLUMN_DEFAULT AS `Default`,
  EXTRA AS Extra,
  COLUMN_COMMENT AS Comment,
  CHARACTER_SET_NAME AS CharacterSet,
  COLLATION_NAME AS Collation
FROM
  information_schema.COLUMNS
WHERE
  TABLE_SCHEMA = 'db_edu_central_2022'
  AND TABLE_NAME = 'doctrine_migration_versions'
ORDER BY
  ORDINAL_POSITION ASC

SELECT COLUMN_NAME AS Field, COLUMN_TYPE AS Type, IS_NULLABLE AS `Null`, COLUMN_KEY AS `Key`, COLUMN_DEFAULT AS `Default`, EXTRA AS Extra, COLUMN_COMMENT AS Comment, CHARACTER_SET_NAME AS CharacterSet, COLLATION_NAME AS Collation FROM information_schema.COLUMNS WHERE TABLE_SCHEMA = 'db_edu_central_2022' AND TABLE_NAME = 'doctrine_migration_versions' ORDER BY ORDINAL_POSITION ASC;

SELECT
  t0.id AS id_1,
  t0.is_redoubling AS is_redoubling_2,
  t0.is_diet AS is_diet_3,
  t0.is_internal AS is_internal_4,
  t0.is_affected AS is_affected_5,
  t0.registered_at AS registered_at_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.last_amount_paid AS last_amount_paid_11,
  t0.last_payment_id AS last_payment_id_12,
  t0.last_payment_at AS last_payment_at_13,
  t0.image AS image_14,
  t0.is_abandonned AS is_abandonned_15,
  t0.as_food_restrictions AS as_food_restrictions_16,
  t0.is_meatless_menu AS is_meatless_menu_17,
  t0.is_menu_without_pork AS is_menu_without_pork_18,
  t0.is_can_eat_alone AS is_can_eat_alone_19,
  t0.is_can_do_his_business_alone AS is_can_do_his_business_alone_20,
  t0.is_falls_sleep_easily AS is_falls_sleep_easily_21,
  t0.is_new AS is_new_22,
  t0.portal_login AS portal_login_23,
  t0.portal_password AS portal_password_24,
  t0.is_authorized_alone AS is_authorized_alone_25,
  t0.establishment_id AS establishment_id_26,
  t0.student_id AS student_id_27,
  t0.school_year_id AS school_year_id_28,
  t0.classroom_id AS classroom_id_29,
  t0.registration_student_pre_registration_id AS registration_student_pre_registration_id_30
FROM
  registration_student_registration t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.is_redoubling AS is_redoubling_2, t0.is_diet AS is_diet_3, t0.is_internal AS is_internal_4, t0.is_affected AS is_affected_5, t0.registered_at AS registered_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.last_amount_paid AS last_amount_paid_11, t0.last_payment_id AS last_payment_id_12, t0.last_payment_at AS last_payment_at_13, t0.image AS image_14, t0.is_abandonned AS is_abandonned_15, t0.as_food_restrictions AS as_food_restrictions_16, t0.is_meatless_menu AS is_meatless_menu_17, t0.is_menu_without_pork AS is_menu_without_pork_18, t0.is_can_eat_alone AS is_can_eat_alone_19, t0.is_can_do_his_business_alone AS is_can_do_his_business_alone_20, t0.is_falls_sleep_easily AS is_falls_sleep_easily_21, t0.is_new AS is_new_22, t0.portal_login AS portal_login_23, t0.portal_password AS portal_password_24, t0.is_authorized_alone AS is_authorized_alone_25, t0.establishment_id AS establishment_id_26, t0.student_id AS student_id_27, t0.school_year_id AS school_year_id_28, t0.classroom_id AS classroom_id_29, t0.registration_student_pre_registration_id AS registration_student_pre_registration_id_30 FROM registration_student_registration t0 WHERE t0.id = 33988;

SELECT
  t0.id AS id_1,
  t0.code AS code_2,
  t0.method AS method_3,
  t0.memo AS memo_4,
  t0.amount AS amount_5,
  t0.create_at AS create_at_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.created_by AS created_by_9,
  t0.updated_by AS updated_by_10,
  t0.establishment_id AS establishment_id_11,
  t0.student_registration_id AS student_registration_id_12,
  t0.cash_register_id AS cash_register_id_13,
  t0.school_year_id AS school_year_id_14
FROM
  accounting_student_registration_payment t0
WHERE
  t0.cash_register_id = ?
ORDER BY
  t0.id DESC

SELECT t0.id AS id_1, t0.code AS code_2, t0.method AS method_3, t0.memo AS memo_4, t0.amount AS amount_5, t0.create_at AS create_at_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10, t0.establishment_id AS establishment_id_11, t0.student_registration_id AS student_registration_id_12, t0.cash_register_id AS cash_register_id_13, t0.school_year_id AS school_year_id_14 FROM accounting_student_registration_payment t0 WHERE t0.cash_register_id = 5902 ORDER BY t0.id DESC;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  t0.id AS id_1,
  t0.discharge AS discharge_2,
  t0.amount AS amount_3,
  t0.create_at AS create_at_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.created_by AS created_by_7,
  t0.updated_by AS updated_by_8,
  t0.is_founder_valedated AS is_founder_valedated_9,
  t0.is_founder_rejected AS is_founder_rejected_10,
  t0.cash_register_id AS cash_register_id_11,
  t0.establishment_id AS establishment_id_12,
  t0.school_year_id AS school_year_id_13
FROM
  treasury_payment t0
WHERE
  t0.cash_register_id = ?

SELECT t0.id AS id_1, t0.discharge AS discharge_2, t0.amount AS amount_3, t0.create_at AS create_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8, t0.is_founder_valedated AS is_founder_valedated_9, t0.is_founder_rejected AS is_founder_rejected_10, t0.cash_register_id AS cash_register_id_11, t0.establishment_id AS establishment_id_12, t0.school_year_id AS school_year_id_13 FROM treasury_payment t0 WHERE t0.cash_register_id = 5902;

SELECT
  DISTINCT k.`CONSTRAINT_NAME`,
  k.`COLUMN_NAME`,
  k.`REFERENCED_TABLE_NAME`,
  k.`REFERENCED_COLUMN_NAME`
  /*!50116 , c.update_rule, c.delete_rule */
FROM
  information_schema.key_column_usage k
  /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'doctrine_migration_versions' */
WHERE
  k.table_name = 'doctrine_migration_versions'
  AND k.table_schema = 'db_edu_central_2022'
  /*!50116 AND c.constraint_schema = 'db_edu_central_2022' */
  AND k.`REFERENCED_COLUMN_NAME` is not NULL

SELECT DISTINCT k.`CONSTRAINT_NAME`, k.`COLUMN_NAME`, k.`REFERENCED_TABLE_NAME`, k.`REFERENCED_COLUMN_NAME` /*!50116 , c.update_rule, c.delete_rule */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON   c.constraint_name = k.constraint_name AND   c.table_name = 'doctrine_migration_versions' */ WHERE k.table_name = 'doctrine_migration_versions' AND k.table_schema = 'db_edu_central_2022' /*!50116 AND c.constraint_schema = 'db_edu_central_2022' */ AND k.`REFERENCED_COLUMN_NAME` is not NULL;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.description AS description_3,
  t0.amount AS amount_4,
  t0.is_submited AS is_submited_5,
  t0.is_aproved AS is_aproved_6,
  t0.is_canceled AS is_canceled_7,
  t0.is_paid AS is_paid_8,
  t0.create_date AS create_date_9,
  t0.created_at AS created_at_10,
  t0.created_by AS created_by_11,
  t0.updated_at AS updated_at_12,
  t0.updated_by AS updated_by_13,
  t0.aproved_by AS aproved_by_14,
  t0.aproved_at AS aproved_at_15,
  t0.establishment_id AS establishment_id_16,
  t0.salary_id AS salary_id_17,
  t0.cash_register_id AS cash_register_id_18,
  t0.cash_movement_id AS cash_movement_id_19,
  t0.account_id AS account_id_20,
  t0.school_year_id AS school_year_id_21,
  t0.checkout_id AS checkout_id_22,
  t0.accounting_expense_category_id AS accounting_expense_category_id_23
FROM
  accounting_expense t0
WHERE
  t0.cash_register_id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.description AS description_3, t0.amount AS amount_4, t0.is_submited AS is_submited_5, t0.is_aproved AS is_aproved_6, t0.is_canceled AS is_canceled_7, t0.is_paid AS is_paid_8, t0.create_date AS create_date_9, t0.created_at AS created_at_10, t0.created_by AS created_by_11, t0.updated_at AS updated_at_12, t0.updated_by AS updated_by_13, t0.aproved_by AS aproved_by_14, t0.aproved_at AS aproved_at_15, t0.establishment_id AS establishment_id_16, t0.salary_id AS salary_id_17, t0.cash_register_id AS cash_register_id_18, t0.cash_movement_id AS cash_movement_id_19, t0.account_id AS account_id_20, t0.school_year_id AS school_year_id_21, t0.checkout_id AS checkout_id_22, t0.accounting_expense_category_id AS accounting_expense_category_id_23 FROM accounting_expense t0 WHERE t0.cash_register_id = 5902;

SELECT
  ENGINE,
  AUTO_INCREMENT,
  TABLE_COLLATION,
  TABLE_COMMENT,
  CREATE_OPTIONS
FROM
  information_schema.TABLES
WHERE
  TABLE_TYPE = 'BASE TABLE'
  AND TABLE_SCHEMA = DATABASE()
  AND TABLE_NAME = 'doctrine_migration_versions'

SELECT ENGINE, AUTO_INCREMENT, TABLE_COLLATION, TABLE_COMMENT, CREATE_OPTIONS
FROM information_schema.TABLES
WHERE TABLE_TYPE = 'BASE TABLE' AND TABLE_SCHEMA = DATABASE() AND TABLE_NAME = 'doctrine_migration_versions';

SELECT
  NON_UNIQUE AS Non_Unique,
  INDEX_NAME AS Key_name,
  COLUMN_NAME AS Column_Name,
  SUB_PART AS Sub_Part,
  INDEX_TYPE AS Index_Type
FROM
  information_schema.STATISTICS
WHERE
  TABLE_NAME = 'doctrine_migration_versions'
  AND TABLE_SCHEMA = 'db_edu_central_2022'
ORDER BY
  SEQ_IN_INDEX ASC

SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_NAME = 'doctrine_migration_versions' AND TABLE_SCHEMA = 'db_edu_central_2022' ORDER BY SEQ_IN_INDEX ASC;