Query Metrics
48
Database Queries
18
Different statements
122.11 ms
Query time
3
Invalid entities
229
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
44.77 ms (36.67%) |
1 |
SELECT s0_.id AS id_0, s0_.username AS username_1, s0_.username_canonical AS username_canonical_2, s0_.email AS email_3, s0_.email_canonical AS email_canonical_4, s0_.password AS password_5, s0_.roles AS roles_6, s0_.enabled AS enabled_7, s0_.last_login AS last_login_8, s0_.password_reset_token AS password_reset_token_9, s0_.password_reset_token_expires_at AS password_reset_token_expires_at_10, s0_.onboarded_at AS onboarded_at_11, s0_.account_valid AS account_valid_12, s0_.mail_sent_at AS mail_sent_at_13, s0_.mail_relance_account_invalid_sent_at AS mail_relance_account_invalid_sent_at_14, s0_.mail_relance_visa_sent_at AS mail_relance_visa_sent_at_15, s0_.mail_relance_bank_sent_at AS mail_relance_bank_sent_at_16, s0_.mail_warning_under_age_sent_at AS mail_warning_under_age_sent_at_17, s0_.email2 AS email2_18, s0_.firstName AS firstName_19, s0_.lastName AS lastName_20, s0_.birthDate AS birthDate_21, s0_.phone AS phone_22, s0_.nationality AS nationality_23, s0_.countryVisaAsked AS countryVisaAsked_24, s0_.cityVisaAsked AS cityVisaAsked_25, s0_.enrollmentProgram AS enrollmentProgram_26, s0_.startFranceCursus AS startFranceCursus_27, s0_.endFranceCursus AS endFranceCursus_28, s0_.flatNumber AS flatNumber_29, s0_.buildingNumber AS buildingNumber_30, s0_.country AS country_31, s0_.delete_at AS delete_at_32, s0_.activated_services AS activated_services_33, s0_.cursus_month AS cursus_month_34, s0_.cursus_year AS cursus_year_35, s0_.show_profile AS show_profile_36, s0_.accept_cnil AS accept_cnil_37, s0_.previous_france_visa_refusal AS previous_france_visa_refusal_38, s0_.need_flat_mate AS need_flat_mate_39, s0_.need_eu_card_health_insurance AS need_eu_card_health_insurance_40, s0_.enable_relance_mail AS enable_relance_mail_41, s0_.delete_reason AS delete_reason_42, s0_.arriving_date AS arriving_date_43, s0_.locale AS locale_44, s0_.spoken_language AS spoken_language_45, s0_.length_of_stay AS length_of_stay_46, s0_.gender AS gender_47, s0_.cgu AS cgu_48, s0_.french_phone_number AS french_phone_number_49, s0_.allow_edit_text AS allow_edit_text_50, s0_.matomo_visitor_id AS matomo_visitor_id_51, s0_.platform_services AS platform_services_52, s0_.use_zendesk_form AS use_zendesk_form_53, s0_.visa_pre_validation AS visa_pre_validation_54, s0_.titre_sejour_validation AS titre_sejour_validation_55, s0_.additional_services AS additional_services_56, s0_.school_free_field AS school_free_field_57, s0_.rating AS rating_58, s0_.rating_comment AS rating_comment_59, s0_.rating_date AS rating_date_60, s0_.relance_unsubscribe_token AS relance_unsubscribe_token_61, s0_.relance_subscribed AS relance_subscribed_62, s0_.delete_token AS delete_token_63, s0_.last_verified_at AS last_verified_at_64, s0_.created_source AS created_source_65, s0_.preferred_communication_method AS preferred_communication_method_66, s0_.password2 AS password2_67, s0_.unlock_cvec AS unlock_cvec_68, s0_.no_appointment AS no_appointment_69, s0_.created_at AS created_at_70, s0_.updated_at AS updated_at_71, s0_.supervisor AS supervisor_72, s0_.thesis_funding AS thesis_funding_73, s0_.thesis_funding_contract_type AS thesis_funding_contract_type_74, s0_.numberAndNameOfStreet AS numberAndNameOfStreet_75, s0_.zipCode AS zipCode_76, s0_.city AS city_77, s0_.payed_at AS payed_at_78, s0_.payment_reference AS payment_reference_79, s0_.payment_id AS payment_id_80, v1_.state AS state_81, v1_.validated_at AS validated_at_82, v1_.invalidated_at AS invalidated_at_83, v1_.message AS message_84, v1_.service_history AS service_history_85, v1_.invalid_history_state AS invalid_history_state_86, v1_.valid_history_state AS valid_history_state_87, v1_.id AS id_88, v1_.created_account_from_etude_france AS created_account_from_etude_france_89, v1_.campus_france_interview AS campus_france_interview_90, v1_.visa_web_site_visited AS visa_web_site_visited_91, v1_.bookedVisaCenter AS bookedVisaCenter_92, v1_.visa_center_appointment_date AS visa_center_appointment_date_93, v1_.visa_expiration_date AS visa_expiration_date_94, v1_.visited_steps AS visited_steps_95, v1_.documents_collected AS documents_collected_96, v1_.current_step AS current_step_97, v1_.cursus_beginning AS cursus_beginning_98, v1_.cursus_ending AS cursus_ending_99, v1_.admin_comment AS admin_comment_100, v1_.document_ref_extra AS document_ref_extra_101, v1_.late_attendance_date AS late_attendance_date_102, v1_.visa_type AS visa_type_103, v1_.campus_message AS campus_message_104, v1_.mjm_enrollment_letter_unlocked_email_sent_at AS mjm_enrollment_letter_unlocked_email_sent_at_105, v1_.created_at AS created_at_106, v1_.updated_at AS updated_at_107, v1_.is_active AS is_active_108, v1_.confidential_message AS confidential_message_109, v1_.became_valid_at AS became_valid_at_110, v1_.deletion_confirmed_at AS deletion_confirmed_at_111, v1_.documents_deleted_at AS documents_deleted_at_112, z2_.id AS id_113, z2_.villes AS villes_114, z2_.pays AS pays_115, z2_.created_account_from_etude_france AS created_account_from_etude_france_116, z2_.created_account_from_campus_france AS created_account_from_campus_france_117, z2_.common_check_list AS common_check_list_118, s0_.school_id AS school_id_119, s0_.school_track_id AS school_track_id_120, s0_.sector_id AS sector_id_121, s0_.accommodation_data_id AS accommodation_data_id_122, s0_.bank_phone_home_insurance_data_id AS bank_phone_home_insurance_data_id_123, s0_.visa_data_id AS visa_data_id_124, s0_.health_insurance_data_id AS health_insurance_data_id_125, s0_.electricity_data_id AS electricity_data_id_126, s0_.metro_data_id AS metro_data_id_127, s0_.caf_data_id AS caf_data_id_128, s0_.visa_ofii_data_id AS visa_ofii_data_id_129, s0_.titre_sejour_data_id AS titre_sejour_data_id_130, s0_.renewal_metro_data_id AS renewal_metro_data_id_131, s0_.certificate_data_id AS certificate_data_id_132, s0_.cvec_data_id AS cvec_data_id_133, s0_.before_leaving_data_id AS before_leaving_data_id_134, s0_.private_health_insurance_data_id AS private_health_insurance_data_id_135, s0_.bank_data_id AS bank_data_id_136, s0_.home_insurance_data_id AS home_insurance_data_id_137, s0_.phone_data_id AS phone_data_id_138, s0_.student_city_id AS student_city_id_139, s0_.school_bto_c_id AS school_bto_c_id_140, s0_.roommate_data_id AS roommate_data_id_141, s0_.translation_data_id AS translation_data_id_142, s0_.welcome_pack_data_id AS welcome_pack_data_id_143, s0_.meet_and_greet_data_id AS meet_and_greet_data_id_144, s0_.student_buddy_data_id AS student_buddy_data_id_145, s0_.school_appointment_data_id AS school_appointment_data_id_146, s0_.welcome_day_data_id AS welcome_day_data_id_147, s0_.private_insurance_data_id AS private_insurance_data_id_148, s0_.french_class_enrollment_data_id AS french_class_enrollment_data_id_149, s0_.composante_id AS composante_id_150, s0_.program_id AS program_id_151, s0_.referent_id AS referent_id_152, s0_.laboratoire_id AS laboratoire_id_153, s0_.doctoral_school_id AS doctoral_school_id_154, v1_.zone_id AS zone_id_155 FROM student s0_ LEFT JOIN visa_data v1_ ON s0_.visa_data_id = v1_.id LEFT JOIN zone z2_ ON v1_.zone_id = z2_.id WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 2 1371 1395 1396 1416 1418 1469 ] |
|
16.47 ms (13.49%) |
3 |
SELECT s0_.id AS id_0, s0_.price AS price_1, s0_.title AS title_2, s0_.slug AS slug_3, s0_.stripe_id AS stripe_id_4, s0_.data_class AS data_class_5, s0_.tracking AS tracking_6, s0_.payment_for AS payment_for_7, s0_.created_at AS created_at_8, s0_.updated_at AS updated_at_9 FROM stripe_payment s0_ WHERE s0_.slug = ?
Parameters:
[
"full-access-platform"
]
|
|
10.27 ms (8.41%) |
7 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.school_services AS school_services_3, t0.studapart_link AS studapart_link_4, t0.registration_code AS registration_code_5, t0.theme_folder AS theme_folder_6, t0.display_community AS display_community_7, t0.certificate_payant AS certificate_payant_8, t0.slug AS slug_9, t0.bank_email AS bank_email_10, t0.video_url AS video_url_11, t0.facebook_url AS facebook_url_12, t0.instagram_url AS instagram_url_13, t0.use_zendesk_form AS use_zendesk_form_14, t0.flatmate_box AS flatmate_box_15, t0.street AS street_16, t0.zip AS zip_17, t0.city AS city_18, t0.latitude AS latitude_19, t0.longitude AS longitude_20, t0.bank2_email AS bank2_email_21, t0.zendesk_tag AS zendesk_tag_22, t0.show_in_profile_bto_c AS show_in_profile_bto_c_23, t0.excluded_documents_ref AS excluded_documents_ref_24, t0.is_customer AS is_customer_25, t0.student_can_delete_account AS student_can_delete_account_26, t0.use_zendesk_form_bto_c AS use_zendesk_form_bto_c_27, t0.need_bphi_visa AS need_bphi_visa_28, t0.auth_type AS auth_type_29, t0.report AS report_30, t0.without_brevo_automation AS without_brevo_automation_31, t0.buddy_code AS buddy_code_32, t0.send_raspail_bank_email AS send_raspail_bank_email_33, t0.display_agent AS display_agent_34, t0.display_rating AS display_rating_35, t0.webinar_url AS webinar_url_36, t0.event_url AS event_url_37, t0.display_webinar AS display_webinar_38, t0.display_event AS display_event_39, t0.has_lcl_bank AS has_lcl_bank_40, t0.contact_for_buddy AS contact_for_buddy_41, t0.display_webinar_video AS display_webinar_video_42, t0.display_translation AS display_translation_43, t0.welcome_pack_delivery_point AS welcome_pack_delivery_point_44, t0.welcome_pack_email_recipient AS welcome_pack_email_recipient_45, t0.meet_and_greet_email_recipient AS meet_and_greet_email_recipient_46, t0.excluded_from_etude_france AS excluded_from_etude_france_47, t0.excluded_from_campus_france AS excluded_from_campus_france_48, t0.service_structure_id AS service_structure_id_49, t0.logo_id AS logo_id_50, t0.learn_french_section AS learn_french_section_51, t0.principal_school_id AS principal_school_id_52, t0.school_city_id AS school_city_id_53, t54.id AS id_55, t54.title AS title_56, t54.site AS site_57, t54.added_to_bto_c AS added_to_bto_c_58, t54.created_at AS created_at_59, t54.updated_at AS updated_at_60, t54.school_id AS school_id_61, t54.student_id AS student_id_62, t0.webinar_photo_en_id AS webinar_photo_en_id_63, t0.webinar_photo_fr_id AS webinar_photo_fr_id_64, t0.event_photo_en_id AS event_photo_en_id_65, t0.event_photo_fr_id AS event_photo_fr_id_66 FROM school t0 LEFT JOIN school_free_field t54 ON t54.school_id = t0.id INNER JOIN student_school ON t0.id = student_school.school_id WHERE student_school.student_id = ? AND ((t0.slug != 'ifa-french-tech'))
Parameters:
[
2
]
|
|
8.88 ms (7.27%) |
7 |
SELECT t0.id AS id_1, t0.validated AS validated_2, t0.active AS active_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.student_id AS student_id_6, t0.buddy_id AS buddy_id_7, t0.school_id AS school_id_8 FROM buddy_student_matching t0 WHERE t0.student_id = ?
Parameters:
[
2
]
|
|
8.77 ms (7.18%) |
7 |
SELECT t0.id AS id_1, t0.nb_personne AS nb_personne_2, t0.age AS age_3, t0.residence_type AS residence_type_4, t0.budget AS budget_5, t0.commentaire AS commentaire_6, t0.length_of_stay AS length_of_stay_7, t0.lease_start AS lease_start_8, t0.with_parent AS with_parent_9, t0.has_roommate AS has_roommate_10, t0.student_id AS student_id_11, t0.city_id AS city_id_12 FROM score_card t0 WHERE t0.student_id = ?
Parameters:
[
2
]
|
|
7.34 ms (6.01%) |
6 |
SELECT v0_.id AS id_0, v0_.countries AS countries_1 FROM visa_short_stay_countries v0_ ORDER BY v0_.id ASC LIMIT 1
Parameters:
[] |
|
5.41 ms (4.43%) |
4 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.school_services AS school_services_3, t0.studapart_link AS studapart_link_4, t0.registration_code AS registration_code_5, t0.theme_folder AS theme_folder_6, t0.display_community AS display_community_7, t0.certificate_payant AS certificate_payant_8, t0.slug AS slug_9, t0.bank_email AS bank_email_10, t0.video_url AS video_url_11, t0.facebook_url AS facebook_url_12, t0.instagram_url AS instagram_url_13, t0.use_zendesk_form AS use_zendesk_form_14, t0.flatmate_box AS flatmate_box_15, t0.street AS street_16, t0.zip AS zip_17, t0.city AS city_18, t0.latitude AS latitude_19, t0.longitude AS longitude_20, t0.bank2_email AS bank2_email_21, t0.zendesk_tag AS zendesk_tag_22, t0.show_in_profile_bto_c AS show_in_profile_bto_c_23, t0.excluded_documents_ref AS excluded_documents_ref_24, t0.is_customer AS is_customer_25, t0.student_can_delete_account AS student_can_delete_account_26, t0.use_zendesk_form_bto_c AS use_zendesk_form_bto_c_27, t0.need_bphi_visa AS need_bphi_visa_28, t0.auth_type AS auth_type_29, t0.report AS report_30, t0.without_brevo_automation AS without_brevo_automation_31, t0.buddy_code AS buddy_code_32, t0.send_raspail_bank_email AS send_raspail_bank_email_33, t0.display_agent AS display_agent_34, t0.display_rating AS display_rating_35, t0.webinar_url AS webinar_url_36, t0.event_url AS event_url_37, t0.display_webinar AS display_webinar_38, t0.display_event AS display_event_39, t0.has_lcl_bank AS has_lcl_bank_40, t0.contact_for_buddy AS contact_for_buddy_41, t0.display_webinar_video AS display_webinar_video_42, t0.display_translation AS display_translation_43, t0.welcome_pack_delivery_point AS welcome_pack_delivery_point_44, t0.welcome_pack_email_recipient AS welcome_pack_email_recipient_45, t0.meet_and_greet_email_recipient AS meet_and_greet_email_recipient_46, t0.excluded_from_etude_france AS excluded_from_etude_france_47, t0.excluded_from_campus_france AS excluded_from_campus_france_48, t0.service_structure_id AS service_structure_id_49, t0.logo_id AS logo_id_50, t0.learn_french_section AS learn_french_section_51, t0.principal_school_id AS principal_school_id_52, t0.school_city_id AS school_city_id_53, t54.id AS id_55, t54.title AS title_56, t54.site AS site_57, t54.added_to_bto_c AS added_to_bto_c_58, t54.created_at AS created_at_59, t54.updated_at AS updated_at_60, t54.school_id AS school_id_61, t54.student_id AS student_id_62, t0.webinar_photo_en_id AS webinar_photo_en_id_63, t0.webinar_photo_fr_id AS webinar_photo_fr_id_64, t0.event_photo_en_id AS event_photo_en_id_65, t0.event_photo_fr_id AS event_photo_fr_id_66 FROM school t0 LEFT JOIN school_free_field t54 ON t54.school_id = t0.id WHERE t0.id = ? AND ((t0.slug != 'ifa-french-tech'))
Parameters:
[
1
]
|
|
4.47 ms (3.66%) |
1 |
SELECT n0_.student_id AS sclr_0, n0_.data_class AS data_class_1, n0_.created_at AS created_at_2 FROM notification n0_ INNER JOIN student s1_ ON n0_.student_id = s1_.id INNER JOIN school s2_ ON s1_.school_id = s2_.id AND (s2_.slug != 'ifa-french-tech') LEFT JOIN accommodation_data a3_ ON s1_.accommodation_data_id = a3_.id LEFT JOIN residence r4_ ON a3_.residence_id = r4_.id LEFT JOIN residence_notification r5_ ON (r5_.residence_id = r4_.id AND r5_.school_id = s2_.id) WHERE n0_.data_class <> ? AND n0_.data_class <> ? AND n0_.data_class <> ? AND n0_.has_been_read = ? AND n0_.notif_to = ? AND (n0_.data_class <> ? OR (n0_.data_class = ? AND ((r5_.residence_id IS NULL AND r5_.school_id IS NULL) OR r5_.notify = 1))) GROUP BY n0_.student_id, n0_.data_class ORDER BY n0_.created_at DESC
Parameters:
[ "FrenchClassEnrollmentData" "RoommateData" "TranslationData" 0 "admin" "AccommodationData" "AccommodationData" ] |
|
3.68 ms (3.02%) |
3 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.icon AS icon_3, t0.slug AS slug_4, t0.hide_for_eu AS hide_for_eu_5, t0.school_can_edit_text AS school_can_edit_text_6, t0.btoc AS btoc_7, t0.display_in_analytic AS display_in_analytic_8, t0.hide_for_non_eu AS hide_for_non_eu_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11 FROM ff_service t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"FFServiceDataBtoC"
]
|
|
2.01 ms (1.64%) |
1 |
SELECT s0_.id AS id_0, s0_.username AS username_1, s0_.username_canonical AS username_canonical_2, s0_.email AS email_3, s0_.email_canonical AS email_canonical_4, s0_.password AS password_5, s0_.roles AS roles_6, s0_.enabled AS enabled_7, s0_.last_login AS last_login_8, s0_.password_reset_token AS password_reset_token_9, s0_.password_reset_token_expires_at AS password_reset_token_expires_at_10, s0_.onboarded_at AS onboarded_at_11, s0_.account_valid AS account_valid_12, s0_.mail_sent_at AS mail_sent_at_13, s0_.mail_relance_account_invalid_sent_at AS mail_relance_account_invalid_sent_at_14, s0_.mail_relance_visa_sent_at AS mail_relance_visa_sent_at_15, s0_.mail_relance_bank_sent_at AS mail_relance_bank_sent_at_16, s0_.mail_warning_under_age_sent_at AS mail_warning_under_age_sent_at_17, s0_.email2 AS email2_18, s0_.firstName AS firstName_19, s0_.lastName AS lastName_20, s0_.birthDate AS birthDate_21, s0_.phone AS phone_22, s0_.nationality AS nationality_23, s0_.countryVisaAsked AS countryVisaAsked_24, s0_.cityVisaAsked AS cityVisaAsked_25, s0_.enrollmentProgram AS enrollmentProgram_26, s0_.startFranceCursus AS startFranceCursus_27, s0_.endFranceCursus AS endFranceCursus_28, s0_.flatNumber AS flatNumber_29, s0_.buildingNumber AS buildingNumber_30, s0_.country AS country_31, s0_.delete_at AS delete_at_32, s0_.activated_services AS activated_services_33, s0_.cursus_month AS cursus_month_34, s0_.cursus_year AS cursus_year_35, s0_.show_profile AS show_profile_36, s0_.accept_cnil AS accept_cnil_37, s0_.previous_france_visa_refusal AS previous_france_visa_refusal_38, s0_.need_flat_mate AS need_flat_mate_39, s0_.need_eu_card_health_insurance AS need_eu_card_health_insurance_40, s0_.enable_relance_mail AS enable_relance_mail_41, s0_.delete_reason AS delete_reason_42, s0_.arriving_date AS arriving_date_43, s0_.locale AS locale_44, s0_.spoken_language AS spoken_language_45, s0_.length_of_stay AS length_of_stay_46, s0_.gender AS gender_47, s0_.cgu AS cgu_48, s0_.french_phone_number AS french_phone_number_49, s0_.allow_edit_text AS allow_edit_text_50, s0_.matomo_visitor_id AS matomo_visitor_id_51, s0_.platform_services AS platform_services_52, s0_.use_zendesk_form AS use_zendesk_form_53, s0_.visa_pre_validation AS visa_pre_validation_54, s0_.titre_sejour_validation AS titre_sejour_validation_55, s0_.additional_services AS additional_services_56, s0_.school_free_field AS school_free_field_57, s0_.rating AS rating_58, s0_.rating_comment AS rating_comment_59, s0_.rating_date AS rating_date_60, s0_.relance_unsubscribe_token AS relance_unsubscribe_token_61, s0_.relance_subscribed AS relance_subscribed_62, s0_.delete_token AS delete_token_63, s0_.last_verified_at AS last_verified_at_64, s0_.created_source AS created_source_65, s0_.preferred_communication_method AS preferred_communication_method_66, s0_.password2 AS password2_67, s0_.unlock_cvec AS unlock_cvec_68, s0_.no_appointment AS no_appointment_69, s0_.created_at AS created_at_70, s0_.updated_at AS updated_at_71, s0_.supervisor AS supervisor_72, s0_.thesis_funding AS thesis_funding_73, s0_.thesis_funding_contract_type AS thesis_funding_contract_type_74, s0_.numberAndNameOfStreet AS numberAndNameOfStreet_75, s0_.zipCode AS zipCode_76, s0_.city AS city_77, s0_.payed_at AS payed_at_78, s0_.payment_reference AS payment_reference_79, s0_.payment_id AS payment_id_80, s1_.id AS id_81, s1_.date_from AS date_from_82, s1_.date_to AS date_to_83, s2_.id AS id_84, s2_.title AS title_85, s2_.has_date_from AS has_date_from_86, s2_.has_date_to AS has_date_to_87, s2_.slug AS slug_88, s2_.matching_step AS matching_step_89, s2_.allow_deletion AS allow_deletion_90, s3_.id AS id_91, s3_.context AS context_92, s3_.title AS title_93, s0_.school_id AS school_id_94, s0_.school_track_id AS school_track_id_95, s0_.sector_id AS sector_id_96, s0_.accommodation_data_id AS accommodation_data_id_97, s0_.bank_phone_home_insurance_data_id AS bank_phone_home_insurance_data_id_98, s0_.visa_data_id AS visa_data_id_99, s0_.health_insurance_data_id AS health_insurance_data_id_100, s0_.electricity_data_id AS electricity_data_id_101, s0_.metro_data_id AS metro_data_id_102, s0_.caf_data_id AS caf_data_id_103, s0_.visa_ofii_data_id AS visa_ofii_data_id_104, s0_.titre_sejour_data_id AS titre_sejour_data_id_105, s0_.renewal_metro_data_id AS renewal_metro_data_id_106, s0_.certificate_data_id AS certificate_data_id_107, s0_.cvec_data_id AS cvec_data_id_108, s0_.before_leaving_data_id AS before_leaving_data_id_109, s0_.private_health_insurance_data_id AS private_health_insurance_data_id_110, s0_.bank_data_id AS bank_data_id_111, s0_.home_insurance_data_id AS home_insurance_data_id_112, s0_.phone_data_id AS phone_data_id_113, s0_.student_city_id AS student_city_id_114, s0_.school_bto_c_id AS school_bto_c_id_115, s0_.roommate_data_id AS roommate_data_id_116, s0_.translation_data_id AS translation_data_id_117, s0_.welcome_pack_data_id AS welcome_pack_data_id_118, s0_.meet_and_greet_data_id AS meet_and_greet_data_id_119, s0_.student_buddy_data_id AS student_buddy_data_id_120, s0_.school_appointment_data_id AS school_appointment_data_id_121, s0_.welcome_day_data_id AS welcome_day_data_id_122, s0_.private_insurance_data_id AS private_insurance_data_id_123, s0_.french_class_enrollment_data_id AS french_class_enrollment_data_id_124, s0_.composante_id AS composante_id_125, s0_.program_id AS program_id_126, s0_.referent_id AS referent_id_127, s0_.laboratoire_id AS laboratoire_id_128, s0_.doctoral_school_id AS doctoral_school_id_129, s1_.student_id AS student_id_130, s1_.service_check_list_item_id AS service_check_list_item_id_131, s2_.service_check_list_id AS service_check_list_id_132 FROM student s0_ LEFT JOIN student_check_list_item s1_ ON s0_.id = s1_.student_id LEFT JOIN service_check_list_item s2_ ON s1_.service_check_list_item_id = s2_.id LEFT JOIN service_check_list s3_ ON s2_.service_check_list_id = s3_.id WHERE s0_.id IN (?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 2 1371 1395 1396 1416 1418 1469 ] |
|
1.52 ms (1.25%) |
1 |
SELECT d0_.student_id AS sclr_0, MAX(d0_.updated_at) AS sclr_1 FROM document_student d0_ WHERE (d0_.student_id IN (?, ?, ?, ?, ?, ?, ?) AND (d0_.context = ? OR d0_.alias IN (?, ?)) AND d0_.delete_at IS NULL) AND (d0_.delete_at IS NULL) GROUP BY d0_.student_id
Parameters:
[ 2 1371 1395 1396 1416 1418 1469 "VisaData" "passport" "enrollment-letter" ] |
|
1.45 ms (1.19%) |
1 |
SELECT d0_.student_id AS sclr_0, d0_.context AS context_1, MAX(d0_.updated_at) AS sclr_2 FROM document_student d0_ WHERE (d0_.student_id IN (?, ?, ?, ?, ?, ?, ?) AND d0_.delete_at IS NULL) AND (d0_.delete_at IS NULL) GROUP BY d0_.student_id, d0_.context
Parameters:
[ 2 1371 1395 1396 1416 1418 1469 ] |
|
1.29 ms (1.05%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.has_date_from AS has_date_from_3, t0.has_date_to AS has_date_to_4, t0.slug AS slug_5, t0.matching_step AS matching_step_6, t0.allow_deletion AS allow_deletion_7, t0.service_check_list_id AS service_check_list_id_8 FROM service_check_list_item t0 WHERE t0.service_check_list_id = ?
Parameters:
[
5
]
|
|
1.22 ms (1.00%) |
1 |
SELECT t0.id AS id_1, t0.context AS context_2, t0.title AS title_3 FROM service_check_list t0 WHERE t0.context = ? LIMIT 1
Parameters:
[
"VisaData"
]
|
|
1.22 ms (1.00%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2 FROM sector t0 INNER JOIN school_track_sector ON t0.id = school_track_sector.sector_id WHERE school_track_sector.school_track_id = ?
Parameters:
[
11
]
|
|
1.21 ms (0.99%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.address AS address_3, t0.latitude AS latitude_4, t0.longitude AS longitude_5, t0.common_title AS common_title_6, t0.school_id AS school_id_7 FROM school_track t0 WHERE t0.id = ?
Parameters:
[
11
]
|
|
1.07 ms (0.87%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.has_date_from AS has_date_from_3, t0.has_date_to AS has_date_to_4, t0.slug AS slug_5, t0.matching_step AS matching_step_6, t0.allow_deletion AS allow_deletion_7, t0.service_check_list_id AS service_check_list_id_8 FROM service_check_list_item t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"eef-file-validated-by-ff"
]
|
|
1.05 ms (0.86%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2 FROM program t0 WHERE t0.id = ?
Parameters:
[
21
]
|
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\StudentCheckListItem | 17 |
| App\Entity\ServiceCheckListItem | 12 |
| App\Entity\Student | 7 |
| App\Entity\Service\AccommodationData | 7 |
| App\Entity\Service\BankPhoneHomeInsuranceData | 7 |
| App\Entity\Service\HealthInsuranceData | 7 |
| App\Entity\Service\ElectricityData | 7 |
| App\Entity\Service\CertificateData | 7 |
| App\Entity\Service\BeforeLeavingData | 7 |
| App\Entity\Service\BankData | 7 |
| App\Entity\Service\RoommateData | 7 |
| App\Entity\Service\WelcomePackData | 7 |
| App\Entity\Service\MeetAndGreetData | 7 |
| App\Entity\Service\StudentBuddyData | 7 |
| App\Entity\Service\SchoolAppointmentData | 7 |
| App\Entity\Service\WelcomeDayData | 7 |
| App\Entity\Service\FrenchClassEnrollmentData | 7 |
| App\Entity\Service\VisaData | 7 |
| App\Entity\Service\TitreSejourData | 6 |
| App\Entity\Service\RenewalMetroData | 6 |
| App\Entity\Service\CvecData | 6 |
| App\Entity\Service\PrivateHealthInsuranceData | 6 |
| App\Entity\Service\PhoneData | 6 |
| App\Entity\Service\PrivateInsuranceData | 6 |
| App\Entity\School | 5 |
| App\Entity\Service\MetroData | 4 |
| App\Entity\Service\CafData | 4 |
| App\Entity\Service\VisaOfiiData | 4 |
| App\Entity\Service\HomeInsuranceData | 4 |
| App\Entity\ServiceCheckList | 4 |
| App\Entity\StripePayment | 3 |
| App\Entity\Buddy\BuddyStudentMatching | 3 |
| App\Entity\Buddy\Buddy | 3 |
| App\Specific\Entity\UnivLorraine\Composante | 2 |
| App\Entity\Zone | 2 |
| App\Entity\ServiceStructure | 2 |
| App\Entity\File | 2 |
| App\FFService\Entity\FFService | 2 |
| App\Entity\TranslationData | 1 |
| App\Entity\ScoreCard | 1 |
| App\Entity\ResidenceCity | 1 |
| App\Entity\Program | 1 |
| App\Specific\Entity\UnivLorraine\Laboratoire | 1 |
| App\Entity\SchoolTrack | 1 |
| App\Entity\LearnFrench\LearnFrenchSection | 1 |
| App\Entity\VisaShortStayCountries | 1 |