https://betaerp.laroutedeslangues.com/_fragment?_path=_format%3Dhtml%26_locale%3Dfr%26_controller%3DApp%255CController%255CProductChangeLogController%253A%253Alist

Method
GET
HTTP Status
200
IP
172.68.151.156
Profiled on
Token
93d672

Query Metrics

357 Database Queries
57 Different statements
429.13 ms Query time
5 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
61.83 ms
(14.41%) 		19 
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.slug AS slug_4, t0.creationDate AS creationDate_5, t0.updateDate AS updateDate_6, t0.product_id AS product_id_7, t0.state AS state_8, t0.gender AS gender_9, t0.title_seo AS title_seo_10, t0.description_seo AS description_seo_11, t0.sub_title AS sub_title_12, t0.description AS description_13, t0.witness AS witness_14, t0.benefits_first AS benefits_first_15, t0.benefits_second AS benefits_second_16, t0.benefits_third AS benefits_third_17, t0.min_age AS min_age_18, t0.max_age AS max_age_19, t0.min_level AS min_level_20, t0.max_level AS max_level_21, t0.teaching AS teaching_22, t0.number_hours AS number_hours_23, t0.video AS video_24, t0.content_dates AS content_dates_25, t0.content_cours AS content_cours_26, t0.content_activities AS content_activities_27, t0.content_accommodation AS content_accommodation_28, t0.content_management AS content_management_29, t0.address AS address_30, t0.latitude AS latitude_31, t0.longitude AS longitude_32, t0.brochure_witness AS brochure_witness_33, t0.services_include AS services_include_34, t0.services_exclude AS services_exclude_35, t0.deleted_at AS deleted_at_36, t0.accomodation_included AS accomodation_included_37, t0.transfer_email AS transfer_email_38, t0.transfer_info AS transfer_info_39, t0.transfer_name AS transfer_name_40, t0.register_price AS register_price_41, t0.without_accommodation AS without_accommodation_42, t0.without_transfer AS without_transfer_43, t0.without_insurance AS without_insurance_44, t0.vat_mode AS vat_mode_45, t0.mandate_description AS mandate_description_46, t0.mandate_request_provider AS mandate_request_provider_47, t0.mandate_request_date AS mandate_request_date_48, t0.mandate_step_title AS mandate_step_title_49, t0.mandate_step_description AS mandate_step_description_50, t0.mandate_step_label AS mandate_step_label_51, t0.mandate_info_selected AS mandate_info_selected_52, t0.mandate_message_confirmed AS mandate_message_confirmed_53, t0.mandate_quotation_label AS mandate_quotation_label_54, t0.price_content AS price_content_55, t0.name_it AS name_it_56, t0.title_seo_it AS title_seo_it_57, t0.description_seo_it AS description_seo_it_58, t0.sub_title_it AS sub_title_it_59, t0.description_it AS description_it_60, t0.witness_it AS witness_it_61, t0.benefits_first_it AS benefits_first_it_62, t0.benefits_second_it AS benefits_second_it_63, t0.benefits_third_it AS benefits_third_it_64, t0.content_dates_it AS content_dates_it_65, t0.content_cours_it AS content_cours_it_66, t0.content_activities_it AS content_activities_it_67, t0.content_accommodation_it AS content_accommodation_it_68, t0.content_management_it AS content_management_it_69, t0.brochure_witness_it AS brochure_witness_it_70, t0.price_content_it AS price_content_it_71, t0.first_stage_title AS first_stage_title_72, t0.first_stage_description AS first_stage_description_73, t0.second_stage_title AS second_stage_title_74, t0.second_stage_description AS second_stage_description_75, t0.invoice_to_be_issued_mandatory AS invoice_to_be_issued_mandatory_76, t0.introduction_title AS introduction_title_77, t0.introduction AS introduction_78, t0.classification AS classification_79, t0.product_label AS product_label_80, t0.mandate_mission AS mandate_mission_81, t0.provider_id AS provider_id_82, t0.currency_id AS currency_id_83, t0.country_currency_id AS country_currency_id_84, t0.main_category_id AS main_category_id_85, t0.new_main_category_id AS new_main_category_id_86, t87.id AS id_88, t87.data_to_provider AS data_to_provider_89, t87.docs_to_provider AS docs_to_provider_90, t87.docs_to_customer AS docs_to_customer_91, t87.provider_product_name AS provider_product_name_92, t87.comment AS comment_93, t87.email_subject AS email_subject_94, t87.email_text AS email_text_95, t87.email_recipient_name AS email_recipient_name_96, t87.email_to AS email_to_97, t87.email_comment AS email_comment_98, t87.hubspot_id AS hubspot_id_99, t87.product_id AS product_id_100, t87.local_correspondent_transfer_id AS local_correspondent_transfer_id_101, t87.local_correspondent_visit_id AS local_correspondent_visit_id_102, t87.email_language_id AS email_language_id_103, t0.transfer_language_id AS transfer_language_id_104, t0.followed_by_id AS followed_by_id_105, t0.replaced_by_id AS replaced_by_id_106, t107.id AS id_108, t107.type AS type_109, t107.name AS name_110, t107.slug AS slug_111, t107.creationDate AS creationDate_112, t107.updateDate AS updateDate_113, t107.product_id AS product_id_114, t107.state AS state_115, t107.gender AS gender_116, t107.title_seo AS title_seo_117, t107.description_seo AS description_seo_118, t107.sub_title AS sub_title_119, t107.description AS description_120, t107.witness AS witness_121, t107.benefits_first AS benefits_first_122, t107.benefits_second AS benefits_second_123, t107.benefits_third AS benefits_third_124, t107.min_age AS min_age_125, t107.max_age AS max_age_126, t107.min_level AS min_level_127, t107.max_level AS max_level_128, t107.teaching AS teaching_129, t107.number_hours AS number_hours_130, t107.video AS video_131, t107.content_dates AS content_dates_132, t107.content_cours AS content_cours_133, t107.content_activities AS content_activities_134, t107.content_accommodation AS content_accommodation_135, t107.content_management AS content_management_136, t107.address AS address_137, t107.latitude AS latitude_138, t107.longitude AS longitude_139, t107.brochure_witness AS brochure_witness_140, t107.services_include AS services_include_141, t107.services_exclude AS services_exclude_142, t107.deleted_at AS deleted_at_143, t107.accomodation_included AS accomodation_included_144, t107.transfer_email AS transfer_email_145, t107.transfer_info AS transfer_info_146, t107.transfer_name AS transfer_name_147, t107.register_price AS register_price_148, t107.without_accommodation AS without_accommodation_149, t107.without_transfer AS without_transfer_150, t107.without_insurance AS without_insurance_151, t107.vat_mode AS vat_mode_152, t107.mandate_description AS mandate_description_153, t107.mandate_request_provider AS mandate_request_provider_154, t107.mandate_request_date AS mandate_request_date_155, t107.mandate_step_title AS mandate_step_title_156, t107.mandate_step_description AS mandate_step_description_157, t107.mandate_step_label AS mandate_step_label_158, t107.mandate_info_selected AS mandate_info_selected_159, t107.mandate_message_confirmed AS mandate_message_confirmed_160, t107.mandate_quotation_label AS mandate_quotation_label_161, t107.price_content AS price_content_162, t107.name_it AS name_it_163, t107.title_seo_it AS title_seo_it_164, t107.description_seo_it AS description_seo_it_165, t107.sub_title_it AS sub_title_it_166, t107.description_it AS description_it_167, t107.witness_it AS witness_it_168, t107.benefits_first_it AS benefits_first_it_169, t107.benefits_second_it AS benefits_second_it_170, t107.benefits_third_it AS benefits_third_it_171, t107.content_dates_it AS content_dates_it_172, t107.content_cours_it AS content_cours_it_173, t107.content_activities_it AS content_activities_it_174, t107.content_accommodation_it AS content_accommodation_it_175, t107.content_management_it AS content_management_it_176, t107.brochure_witness_it AS brochure_witness_it_177, t107.price_content_it AS price_content_it_178, t107.first_stage_title AS first_stage_title_179, t107.first_stage_description AS first_stage_description_180, t107.second_stage_title AS second_stage_title_181, t107.second_stage_description AS second_stage_description_182, t107.invoice_to_be_issued_mandatory AS invoice_to_be_issued_mandatory_183, t107.introduction_title AS introduction_title_184, t107.introduction AS introduction_185, t107.classification AS classification_186, t107.product_label AS product_label_187, t107.mandate_mission AS mandate_mission_188, t107.provider_id AS provider_id_189, t107.currency_id AS currency_id_190, t107.country_currency_id AS country_currency_id_191, t107.main_category_id AS main_category_id_192, t107.new_main_category_id AS new_main_category_id_193, t107.transfer_language_id AS transfer_language_id_194, t107.followed_by_id AS followed_by_id_195, t107.replaced_by_id AS replaced_by_id_196, t107.booked_by_id AS booked_by_id_197, t107.replacement_id AS replacement_id_198, t107.introduction_media_id AS introduction_media_id_199, t107.video_poster_id AS video_poster_id_200, t0.booked_by_id AS booked_by_id_201, t0.replacement_id AS replacement_id_202, t0.introduction_media_id AS introduction_media_id_203, t0.video_poster_id AS video_poster_id_204 FROM product t0 LEFT JOIN product_registration_procedure t87 ON t87.product_id = t0.id LEFT JOIN product t107 ON t107.replaced_by_id = t0.id INNER JOIN planning_stay_email_product ON t0.id = planning_stay_email_product.product_id WHERE planning_stay_email_product.planning_stay_email_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
29.92 ms
(6.97%) 		20 
SELECT t0.id AS id_1, t0.type AS type_2, t0.name AS name_3, t0.slug AS slug_4, t0.creationDate AS creationDate_5, t0.updateDate AS updateDate_6, t0.product_id AS product_id_7, t0.state AS state_8, t0.gender AS gender_9, t0.title_seo AS title_seo_10, t0.description_seo AS description_seo_11, t0.sub_title AS sub_title_12, t0.description AS description_13, t0.witness AS witness_14, t0.benefits_first AS benefits_first_15, t0.benefits_second AS benefits_second_16, t0.benefits_third AS benefits_third_17, t0.min_age AS min_age_18, t0.max_age AS max_age_19, t0.min_level AS min_level_20, t0.max_level AS max_level_21, t0.teaching AS teaching_22, t0.number_hours AS number_hours_23, t0.video AS video_24, t0.content_dates AS content_dates_25, t0.content_cours AS content_cours_26, t0.content_activities AS content_activities_27, t0.content_accommodation AS content_accommodation_28, t0.content_management AS content_management_29, t0.address AS address_30, t0.latitude AS latitude_31, t0.longitude AS longitude_32, t0.brochure_witness AS brochure_witness_33, t0.services_include AS services_include_34, t0.services_exclude AS services_exclude_35, t0.deleted_at AS deleted_at_36, t0.accomodation_included AS accomodation_included_37, t0.transfer_email AS transfer_email_38, t0.transfer_info AS transfer_info_39, t0.transfer_name AS transfer_name_40, t0.register_price AS register_price_41, t0.without_accommodation AS without_accommodation_42, t0.without_transfer AS without_transfer_43, t0.without_insurance AS without_insurance_44, t0.vat_mode AS vat_mode_45, t0.mandate_description AS mandate_description_46, t0.mandate_request_provider AS mandate_request_provider_47, t0.mandate_request_date AS mandate_request_date_48, t0.mandate_step_title AS mandate_step_title_49, t0.mandate_step_description AS mandate_step_description_50, t0.mandate_step_label AS mandate_step_label_51, t0.mandate_info_selected AS mandate_info_selected_52, t0.mandate_message_confirmed AS mandate_message_confirmed_53, t0.mandate_quotation_label AS mandate_quotation_label_54, t0.price_content AS price_content_55, t0.name_it AS name_it_56, t0.title_seo_it AS title_seo_it_57, t0.description_seo_it AS description_seo_it_58, t0.sub_title_it AS sub_title_it_59, t0.description_it AS description_it_60, t0.witness_it AS witness_it_61, t0.benefits_first_it AS benefits_first_it_62, t0.benefits_second_it AS benefits_second_it_63, t0.benefits_third_it AS benefits_third_it_64, t0.content_dates_it AS content_dates_it_65, t0.content_cours_it AS content_cours_it_66, t0.content_activities_it AS content_activities_it_67, t0.content_accommodation_it AS content_accommodation_it_68, t0.content_management_it AS content_management_it_69, t0.brochure_witness_it AS brochure_witness_it_70, t0.price_content_it AS price_content_it_71, t0.first_stage_title AS first_stage_title_72, t0.first_stage_description AS first_stage_description_73, t0.second_stage_title AS second_stage_title_74, t0.second_stage_description AS second_stage_description_75, t0.invoice_to_be_issued_mandatory AS invoice_to_be_issued_mandatory_76, t0.introduction_title AS introduction_title_77, t0.introduction AS introduction_78, t0.classification AS classification_79, t0.product_label AS product_label_80, t0.mandate_mission AS mandate_mission_81, t0.provider_id AS provider_id_82, t0.currency_id AS currency_id_83, t0.country_currency_id AS country_currency_id_84, t0.main_category_id AS main_category_id_85, t0.new_main_category_id AS new_main_category_id_86, t87.id AS id_88, t87.data_to_provider AS data_to_provider_89, t87.docs_to_provider AS docs_to_provider_90, t87.docs_to_customer AS docs_to_customer_91, t87.provider_product_name AS provider_product_name_92, t87.comment AS comment_93, t87.email_subject AS email_subject_94, t87.email_text AS email_text_95, t87.email_recipient_name AS email_recipient_name_96, t87.email_to AS email_to_97, t87.email_comment AS email_comment_98, t87.hubspot_id AS hubspot_id_99, t87.product_id AS product_id_100, t87.local_correspondent_transfer_id AS local_correspondent_transfer_id_101, t87.local_correspondent_visit_id AS local_correspondent_visit_id_102, t87.email_language_id AS email_language_id_103, t0.transfer_language_id AS transfer_language_id_104, t0.followed_by_id AS followed_by_id_105, t0.replaced_by_id AS replaced_by_id_106, t107.id AS id_108, t107.type AS type_109, t107.name AS name_110, t107.slug AS slug_111, t107.creationDate AS creationDate_112, t107.updateDate AS updateDate_113, t107.product_id AS product_id_114, t107.state AS state_115, t107.gender AS gender_116, t107.title_seo AS title_seo_117, t107.description_seo AS description_seo_118, t107.sub_title AS sub_title_119, t107.description AS description_120, t107.witness AS witness_121, t107.benefits_first AS benefits_first_122, t107.benefits_second AS benefits_second_123, t107.benefits_third AS benefits_third_124, t107.min_age AS min_age_125, t107.max_age AS max_age_126, t107.min_level AS min_level_127, t107.max_level AS max_level_128, t107.teaching AS teaching_129, t107.number_hours AS number_hours_130, t107.video AS video_131, t107.content_dates AS content_dates_132, t107.content_cours AS content_cours_133, t107.content_activities AS content_activities_134, t107.content_accommodation AS content_accommodation_135, t107.content_management AS content_management_136, t107.address AS address_137, t107.latitude AS latitude_138, t107.longitude AS longitude_139, t107.brochure_witness AS brochure_witness_140, t107.services_include AS services_include_141, t107.services_exclude AS services_exclude_142, t107.deleted_at AS deleted_at_143, t107.accomodation_included AS accomodation_included_144, t107.transfer_email AS transfer_email_145, t107.transfer_info AS transfer_info_146, t107.transfer_name AS transfer_name_147, t107.register_price AS register_price_148, t107.without_accommodation AS without_accommodation_149, t107.without_transfer AS without_transfer_150, t107.without_insurance AS without_insurance_151, t107.vat_mode AS vat_mode_152, t107.mandate_description AS mandate_description_153, t107.mandate_request_provider AS mandate_request_provider_154, t107.mandate_request_date AS mandate_request_date_155, t107.mandate_step_title AS mandate_step_title_156, t107.mandate_step_description AS mandate_step_description_157, t107.mandate_step_label AS mandate_step_label_158, t107.mandate_info_selected AS mandate_info_selected_159, t107.mandate_message_confirmed AS mandate_message_confirmed_160, t107.mandate_quotation_label AS mandate_quotation_label_161, t107.price_content AS price_content_162, t107.name_it AS name_it_163, t107.title_seo_it AS title_seo_it_164, t107.description_seo_it AS description_seo_it_165, t107.sub_title_it AS sub_title_it_166, t107.description_it AS description_it_167, t107.witness_it AS witness_it_168, t107.benefits_first_it AS benefits_first_it_169, t107.benefits_second_it AS benefits_second_it_170, t107.benefits_third_it AS benefits_third_it_171, t107.content_dates_it AS content_dates_it_172, t107.content_cours_it AS content_cours_it_173, t107.content_activities_it AS content_activities_it_174, t107.content_accommodation_it AS content_accommodation_it_175, t107.content_management_it AS content_management_it_176, t107.brochure_witness_it AS brochure_witness_it_177, t107.price_content_it AS price_content_it_178, t107.first_stage_title AS first_stage_title_179, t107.first_stage_description AS first_stage_description_180, t107.second_stage_title AS second_stage_title_181, t107.second_stage_description AS second_stage_description_182, t107.invoice_to_be_issued_mandatory AS invoice_to_be_issued_mandatory_183, t107.introduction_title AS introduction_title_184, t107.introduction AS introduction_185, t107.classification AS classification_186, t107.product_label AS product_label_187, t107.mandate_mission AS mandate_mission_188, t107.provider_id AS provider_id_189, t107.currency_id AS currency_id_190, t107.country_currency_id AS country_currency_id_191, t107.main_category_id AS main_category_id_192, t107.new_main_category_id AS new_main_category_id_193, t107.transfer_language_id AS transfer_language_id_194, t107.followed_by_id AS followed_by_id_195, t107.replaced_by_id AS replaced_by_id_196, t107.booked_by_id AS booked_by_id_197, t107.replacement_id AS replacement_id_198, t107.introduction_media_id AS introduction_media_id_199, t107.video_poster_id AS video_poster_id_200, t0.booked_by_id AS booked_by_id_201, t0.replacement_id AS replacement_id_202, t0.introduction_media_id AS introduction_media_id_203, t0.video_poster_id AS video_poster_id_204 FROM product t0 LEFT JOIN product_registration_procedure t87 ON t87.product_id = t0.id LEFT JOIN product t107 ON t107.replaced_by_id = t0.id WHERE t0.id = ?
Parameters: 
[
  365
]
View formatted query    View runnable query    Explain query
21.10 ms
(4.92%) 		2 
SELECT f0_.id AS id_0, f0_.started_at AS started_at_1, f0_.ended_at AS ended_at_2, f0_.status AS status_3, f0_.created_at AS created_at_4, f0_.updated_at AS updated_at_5, f0_.send_at AS send_at_6, f0_.comment AS comment_7, f0_.sales_comment AS sales_comment_8, f0_.outward_transfer_organized_by_company AS outward_transfer_organized_by_company_9, f0_.return_transfer_organized_by_company AS return_transfer_organized_by_company_10, f0_.outward_as_um AS outward_as_um_11, f0_.return_as_um AS return_as_um_12, f0_.return_correspondent_choices AS return_correspondent_choices_13, f0_.note_outward_transfer AS note_outward_transfer_14, f0_.note_return_transfer AS note_return_transfer_15, f0_.checklist AS checklist_16, f0_.file_id AS file_id_17, f0_.confirmation_date AS confirmation_date_18, f0_.transport_type AS transport_type_19, f0_.type AS type_20, f0_.time_slot_start_arrival AS time_slot_start_arrival_21, f0_.time_slot_end_arrival AS time_slot_end_arrival_22, f0_.time_slot_start_departure AS time_slot_start_departure_23, f0_.time_slot_end_departure AS time_slot_end_departure_24, f0_.reminded_at AS reminded_at_25, f0_.upped_at AS upped_at_26, f0_.view_at AS view_at_27, f0_.customer_stay AS customer_stay_28, f0_.customer_access AS customer_access_29, f0_.accept_registration AS accept_registration_30, f0_.booking_validate_consulting AS booking_validate_consulting_31, f0_.booking_validate_payment AS booking_validate_payment_32, f0_.booking_validate_customer AS booking_validate_customer_33, f0_.booking_validate_participant_required AS booking_validate_participant_required_34, f0_.booking_validate_participant_optional AS booking_validate_participant_optional_35, f0_.booking_validate_mandate AS booking_validate_mandate_36, f0_.validate_participant_data AS validate_participant_data_37, f0_.validate_transport AS validate_transport_38, f0_.document_waiting_validation AS document_waiting_validation_39, f0_.authorize_sharing_transfer_data AS authorize_sharing_transfer_data_40, f0_.request_new_ticket AS request_new_ticket_41, f0_.document_registration_read AS document_registration_read_42, f0_.document_file_departure_read AS document_file_departure_read_43, f0_.mail_status_confirmed_registration_sent_at AS mail_status_confirmed_registration_sent_at_44, f0_.mail_status_available_file_sent_at AS mail_status_available_file_sent_at_45, f0_.mail_document_invalid_sent_at AS mail_document_invalid_sent_at_46, f0_.mail_ticket_invalid_sent_at AS mail_ticket_invalid_sent_at_47, f0_.mail_contact_um_sent_at AS mail_contact_um_sent_at_48, f0_.mail_update_contact_um_sent_at AS mail_update_contact_um_sent_at_49, f0_.survey_start_sent_at AS survey_start_sent_at_50, f0_.survey_end_sent_at AS survey_end_sent_at_51, f0_.pending_family AS pending_family_52, f0_.hubspot_matched AS hubspot_matched_53, f0_.hubspot_id AS hubspot_id_54, f0_.hubspot_customer_association AS hubspot_customer_association_55, f0_.hubspot_participant_association AS hubspot_participant_association_56, f0_.first_payment_at AS first_payment_at_57, f0_.first_recovery_register_at AS first_recovery_register_at_58, f0_.second_recovery_register_at AS second_recovery_register_at_59, f0_.register_diff AS register_diff_60, f0_.registration_procedure_sent_at AS registration_procedure_sent_at_61, f0_.registration_procedure_sent_to AS registration_procedure_sent_to_62, f0_.hubspot_diff_matched AS hubspot_diff_matched_63, f0_.send_transfer_mail_at AS send_transfer_mail_at_64, f0_.cancellation_comment AS cancellation_comment_65, f0_.validate_date_at AS validate_date_at_66, f0_.insurance_email_information AS insurance_email_information_67, f0_.identity_document_type AS identity_document_type_68, f0_.is_scholarship AS is_scholarship_69, f0_.hide_participant_name_for_billing AS hide_participant_name_for_billing_70, f0_.force_commission_compliance AS force_commission_compliance_71, f0_.customer_do_not_want_grouped_travel AS customer_do_not_want_grouped_travel_72, f0_.disabled_transactional_email AS disabled_transactional_email_73, f0_.insurance_email_sent_at AS insurance_email_sent_at_74, f0_.departure_file_read_at AS departure_file_read_at_75, f0_.vat_rate AS vat_rate_76, f0_.vat_type AS vat_type_77, f0_.product_id AS product_id_78, f0_.followed_by_id AS followed_by_id_79, f0_.customer_id AS customer_id_80, f0_.parent2_id AS parent2_id_81, f0_.outward_correspondent_id AS outward_correspondent_id_82, f0_.local_correspondent_visit_id AS local_correspondent_visit_id_83, f0_.routing_id AS routing_id_84, f0_.um_correspondent_id AS um_correspondent_id_85, f0_.return_um_contact_id AS return_um_contact_id_86, f0_.mandate_provider_id AS mandate_provider_id_87, f0_.airport_id AS airport_id_88, f0_.train_station_id AS train_station_id_89, f0_.brand_id AS brand_id_90, f0_.billing_brand_id AS billing_brand_id_91, f0_.parent2_requested_id AS parent2_requested_id_92, f0_.custom_departure_file_id AS custom_departure_file_id_93, f0_.return_correspondent_import_id AS return_correspondent_import_id_94, f0_.um_contact_id AS um_contact_id_95, f0_.outward_contact_id AS outward_contact_id_96, f0_.cancellation_reason_tag_id AS cancellation_reason_tag_id_97, f0_.validate_date_by_id AS validate_date_by_id_98 FROM file f0_ WHERE f0_.brand_id = ? AND f0_.started_at >= ? AND f0_.started_at <= ? AND f0_.status IN (?, ?, ?, ?, ?, ?, ?) AND f0_.insurance_email_sent_at IS NULL
Parameters: 
[
  1
  "2026-06-20 00:00:00"
  "2026-06-26 23:59:59"
  "complete_request"
  "sent_request"
  "confirmed_registration"
  "complete_file"
  "available_file"
  "connection_made"
  "scholarship"
]
View formatted query    View runnable query    Explain query
19.85 ms
(4.63%) 		31 
SELECT t0.amount AS amount_1, t0.created_at AS created_at_2, t0.vat_mode AS vat_mode_3, t0.id AS id_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.duration AS duration_7, t0.cancellation_guarantee AS cancellation_guarantee_8, t0.carbon_offset AS carbon_offset_9, t0.amount_remaning AS amount_remaning_10, t0.amount_currency AS amount_currency_11, t0.amount_remaning_currency AS amount_remaning_currency_12, t0.amount_commission AS amount_commission_13, t0.amount_commission_remaining AS amount_commission_remaining_14, t0.amount_currency_commission AS amount_currency_commission_15, t0.amount_currency_commission_remaining AS amount_currency_commission_remaining_16, t0.margin_with_fee AS margin_with_fee_17, t0.margin_without_fee AS margin_without_fee_18, t0.margin_with_fee_percent AS margin_with_fee_percent_19, t0.margin_without_fee_percent AS margin_without_fee_percent_20, t0.file_id AS file_id_21, t0.tariff_id AS tariff_id_22, t0.date_slot_id AS date_slot_id_23, t0.transfert_option_id AS transfert_option_id_24, t0.accomodation_option_id AS accomodation_option_id_25, t0.accomodation_cart_slot_id AS accomodation_cart_slot_id_26 FROM cart t0 WHERE t0.file_id = ?
Parameters: 
[
  13565
]
View formatted query    View runnable query    Explain query
19.80 ms
(4.61%) 		1 
SELECT COUNT(t0_.id) AS sclr_0 FROM transport_routing t0_ INNER JOIN file f1_ ON t0_.id = f1_.routing_id INNER JOIN brand b2_ ON f1_.brand_id = b2_.id WHERE (t0_.view_at IS NULL AND (t0_.sent_to_partner IS NULL OR t0_.sent_to_partner = ?)) AND f1_.status NOT IN (?, ?) AND f1_.started_at >= NOW() AND (f1_.customer_access = ? OR f1_.validate_transport = ?)
Parameters: 
[
  0
  "canceled"
  "archived"
  0
  1
]
View formatted query    View runnable query    Explain query
17.96 ms
(4.19%) 		31 
SELECT t0.id AS id_1, t0.family_situation AS family_situation_2, t0.last_name AS last_name_3, t0.first_name AS first_name_4, t0.job AS job_5, t0.email AS email_6, t0.same_address AS same_address_7, t0.mobile_phone AS mobile_phone_8, t0.fix_phone AS fix_phone_9, t0.new AS new_10, t0.import AS import_11, t0.file_id AS file_id_12, t0.civility_id AS civility_id_13, t0.family_status_id AS family_status_id_14, t0.main_address_id AS main_address_id_15, t0.selected_id AS selected_id_16 FROM file_booking_parent t0 WHERE t0.file_id = ?
Parameters: 
[
  13565
]
View formatted query    View runnable query    Explain query
17.22 ms
(4.01%) 		1 
SELECT COUNT(DISTINCT f0_.id) AS sclr_0 FROM file f0_ LEFT JOIN cart c1_ ON f0_.id = c1_.file_id LEFT JOIN file_participant f3_ ON f0_.id = f3_.file_id LEFT JOIN participant p2_ ON p2_.id = f3_.participant_id LEFT JOIN customer c4_ ON p2_.customer_id = c4_.id LEFT JOIN customer c5_ ON f0_.customer_id = c5_.id LEFT JOIN brand b6_ ON f0_.brand_id = b6_.id LEFT JOIN customer c7_ ON f0_.parent2_id = c7_.id INNER JOIN product p8_ ON f0_.product_id = p8_.id LEFT JOIN product_translation p9_ ON p8_.id = p9_.translatable_id LEFT JOIN productcategory p10_ ON p8_.new_main_category_id = p10_.id LEFT JOIN provider p11_ ON p8_.provider_id = p11_.id LEFT JOIN currency c12_ ON p11_.currency_id = c12_.id LEFT JOIN country c13_ ON p11_.country_id = c13_.id LEFT JOIN provider p14_ ON f0_.mandate_provider_id = p14_.id LEFT JOIN country c15_ ON p14_.country_id = c15_.id LEFT JOIN product_registration_procedure p16_ ON p8_.id = p16_.product_id LEFT JOIN invoice i17_ ON f0_.id = i17_.file_id LEFT JOIN crm c18_ ON f0_.id = c18_.file_id LEFT JOIN user u19_ ON f0_.followed_by_id = u19_.id LEFT JOIN file_payment f20_ ON f0_.id = f20_.file_id LEFT JOIN currency c21_ ON f20_.currency_id = c21_.id WHERE f0_.status IN (?, ?) AND f0_.started_at <= ? AND ((f0_.validate_transport = 0 AND f0_.routing_id IS NULL)) ORDER BY f0_.id DESC
Parameters: 
[
  "confirmed_registration"
  "connection_made"
  "2026-07-22 23:16:50"
]
View formatted query    View runnable query    Explain query
17.04 ms
(3.97%) 		1 
SELECT COUNT(DISTINCT f0_.id) AS sclr_0 FROM file f0_ LEFT JOIN cart c1_ ON f0_.id = c1_.file_id LEFT JOIN file_participant f3_ ON f0_.id = f3_.file_id LEFT JOIN participant p2_ ON p2_.id = f3_.participant_id LEFT JOIN customer c4_ ON p2_.customer_id = c4_.id LEFT JOIN customer c5_ ON f0_.customer_id = c5_.id LEFT JOIN brand b6_ ON f0_.brand_id = b6_.id LEFT JOIN customer c7_ ON f0_.parent2_id = c7_.id INNER JOIN product p8_ ON f0_.product_id = p8_.id LEFT JOIN product_translation p9_ ON p8_.id = p9_.translatable_id LEFT JOIN productcategory p10_ ON p8_.new_main_category_id = p10_.id LEFT JOIN provider p11_ ON p8_.provider_id = p11_.id LEFT JOIN currency c12_ ON p11_.currency_id = c12_.id LEFT JOIN country c13_ ON p11_.country_id = c13_.id LEFT JOIN provider p14_ ON f0_.mandate_provider_id = p14_.id LEFT JOIN country c15_ ON p14_.country_id = c15_.id LEFT JOIN product_registration_procedure p16_ ON p8_.id = p16_.product_id LEFT JOIN invoice i17_ ON f0_.id = i17_.file_id LEFT JOIN crm c18_ ON f0_.id = c18_.file_id LEFT JOIN user u19_ ON f0_.followed_by_id = u19_.id LEFT JOIN file_payment f20_ ON f0_.id = f20_.file_id LEFT JOIN currency c21_ ON f20_.currency_id = c21_.id WHERE f0_.status IN (?, ?) AND f0_.type <> ? AND f0_.started_at <= ? ORDER BY f0_.id DESC
Parameters: 
[
  "confirmed_registration"
  "complete_file"
  "mandate"
  "2026-07-04 23:16:50"
]
View formatted query    View runnable query    Explain query
16.64 ms
(3.88%) 		31 
SELECT t0.id AS id_1, t0.language_years AS language_years_2, t0.created_at AS created_at_3, t0.lastupdate_at AS lastupdate_at_4, t0.last_validated_at AS last_validated_at_5, t0.file_id AS file_id_6, t0.classe_id AS classe_id_7, t0.school_grade_id AS school_grade_id_8, t0.establishment_id AS establishment_id_9, t0.language_id AS language_id_10, t0.language_level_id AS language_level_id_11, t0.professor_id AS professor_id_12, t0.destination_country_grade_id AS destination_country_grade_id_13 FROM participant_school t0 WHERE t0.file_id = ?
Parameters: 
[
  13565
]
View formatted query    View runnable query    Explain query
16.27 ms
(3.79%) 		30 
SELECT t0.id AS id_1, t0.row1 AS row1_2, t0.row2 AS row2_3, t0.row3 AS row3_4, t0.postal_code AS postal_code_5, t0.city AS city_6, t0.created_at AS created_at_7, t0.place_id AS place_id_8, t0.google_address_components AS google_address_components_9, t0.country_id AS country_id_10, t0.american_state_id AS american_state_id_11 FROM address t0 WHERE t0.id = ?
Parameters: 
[
  49038
]
View formatted query    View runnable query    Explain query
16.27 ms
(3.79%) 		31 
SELECT t0.id AS id_1, t0.number AS number_2, t0.deliver_at AS deliver_at_3, t0.deliver_by AS deliver_by_4, t0.expire_at AS expire_at_5, t0.created_at AS created_at_6, t0.at AS at_7, t0.last_validated_at AS last_validated_at_8, t0.type AS type_9, t0.being_renewed AS being_renewed_10, t0.country_issuing_id AS country_issuing_id_11, t0.participant_id AS participant_id_12, t0.file_id AS file_id_13 FROM participant_identity_document t0 WHERE t0.file_id = ?
Parameters: 
[
  13565
]
View formatted query    View runnable query    Explain query
15.88 ms
(3.70%) 		1 
SELECT DISTINCT COUNT(m0_.id) AS sclr_0 FROM media m0_ INNER JOIN file f1_ ON m0_.file_id = f1_.id INNER JOIN brand b2_ ON f1_.brand_id = b2_.id LEFT JOIN file_required_document f3_ ON m0_.id = f3_.document_id LEFT JOIN document_requirement d4_ ON f3_.requirement_document_id = d4_.id LEFT JOIN participant_identity_document_media p6_ ON m0_.id = p6_.media_id LEFT JOIN participant_identity_document p5_ ON p5_.id = p6_.participant_identity_document_id LEFT JOIN participant_health_media p8_ ON m0_.id = p8_.media_id LEFT JOIN participant_health p7_ ON p7_.id = p8_.participant_health_id WHERE m0_.new_request = ? AND f1_.status IN (?, ?, ?, ?, ?, ?, ?) AND f1_.started_at >= NOW() AND m0_.type <> ? AND d4_.desactivate_at IS NULL AND m0_.file_required_document_id IS NULL AND (f3_.id IS NOT NULL OR p5_.id IS NOT NULL OR p7_.id IS NOT NULL) AND m0_.validate IS NULL
Parameters: 
[
  0
  "incomplete_request"
  "complete_request"
  "sent_request"
  "confirmed_registration"
  "complete_file"
  "available_file"
  "connection_made"
  "participant"
]
View formatted query    View runnable query    Explain query
14.66 ms
(3.42%) 		30 
SELECT t0.id AS id_1, t0.type AS type_2, t0.society_name AS society_name_3, t0.lastname AS lastname_4, t0.firstname AS firstname_5, t0.family_situation AS family_situation_6, t0.mobile_phone_number AS mobile_phone_number_7, t0.fix_phone_number AS fix_phone_number_8, t0.original_how_known AS original_how_known_9, t0.comment AS comment_10, t0.last_update_at AS last_update_at_11, t0.created_at AS created_at_12, t0.email AS email_13, t0.tax_code AS tax_code_14, t0.sdi_code AS sdi_code_15, t0.archived AS archived_16, t0.last_customer_update_at AS last_customer_update_at_17, t0.customer_id AS customer_id_18, t0.vat_number AS vat_number_19, t0.state AS state_20, t0.last_validated_at AS last_validated_at_21, t0.validated AS validated_22, t0.job AS job_23, t0.hubspot_id AS hubspot_id_24, t0.hubspot_matched AS hubspot_matched_25, t0.hubspot_email_added AS hubspot_email_added_26, t0.check_hubspot AS check_hubspot_27, t0.check_tags AS check_tags_28, t0.civility_id AS civility_id_29, t0.family_status_id AS family_status_id_30, t0.main_address_id AS main_address_id_31, t0.billing_address_id AS billing_address_id_32, t0.howknown_id AS howknown_id_33, t0.user_id AS user_id_34, t0.brand_id AS brand_id_35, t0.new_job_id AS new_job_id_36 FROM customer t0 WHERE t0.id = ?
Parameters: 
[
  16808
]
View formatted query    View runnable query    Explain query
13.61 ms
(3.17%) 		18 
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.code_compta4 AS code_compta4_4, t0.deleted_at AS deleted_at_5, t0.exchange_rate AS exchange_rate_6, t0.phone AS phone_7, t0.mobile_phone AS mobile_phone_8, t0.email AS email_9, t0.email2 AS email2_10, t0.website AS website_11, t0.banner_text AS banner_text_12, t0.provider_id AS provider_id_13, t0.grouping AS grouping_14, t0.mandate_registration_procedure AS mandate_registration_procedure_15, t0.label_name AS label_name_16, t0.calendar_type AS calendar_type_17, t0.code_compta_temp4 AS code_compta_temp4_18, t0.code_compta_temp_crm4 AS code_compta_temp_crm4_19, t0.commission_policy AS commission_policy_20, t0.iban AS iban_21, t0.tax_code AS tax_code_22, t0.vat_number AS vat_number_23, t0.email_transport AS email_transport_24, t0.contact_commission_to AS contact_commission_to_25, t0.contact_commission_cc AS contact_commission_cc_26, t0.country_id AS country_id_27, t28.id AS id_29, t28.code AS code_30, t28.alpha2 AS alpha2_31, t28.alpha3 AS alpha3_32, t28.name AS name_33, t28.name_it AS name_it_34, t28.slug AS slug_35, t28.active AS active_36, t28.website AS website_37, t28.`order` AS order_38, t28.crm_value AS crm_value_39, t28.visa_procedure AS visa_procedure_40, t28.essential_document1 AS essential_document1_41, t28.essential_document2 AS essential_document2_42, t28.essential_document3 AS essential_document3_43, t28.essential_document4 AS essential_document4_44, t28.essential_document5 AS essential_document5_45, t28.essential_document6 AS essential_document6_46, t28.nationality_name_fr AS nationality_name_fr_47, t28.nationality_name_en AS nationality_name_en_48, t28.nationality_name_it AS nationality_name_it_49, t28.passport_only AS passport_only_50, t28.hubspot_name AS hubspot_name_51, t28.carbon_offset_amount AS carbon_offset_amount_52, t28.last_confirm AS last_confirm_53, t28.mainland_id AS mainland_id_54, t0.currency_id AS currency_id_55, t0.address_id AS address_id_56, t0.user_id AS user_id_57 FROM provider t0 LEFT JOIN country t28 ON t0.country_id = t28.id WHERE t0.id = ?
Parameters: 
[
  154
]
View formatted query    View runnable query    Explain query
10.45 ms
(2.44%) 		1 
SELECT DISTINCT COUNT(DISTINCT f0_.id) AS sclr_0 FROM file f0_ INNER JOIN brand b1_ ON f0_.brand_id = b1_.id LEFT JOIN file_planning_stay_email_send f2_ ON f0_.id = f2_.file_id AND (f2_.planning_id = ?) LEFT JOIN file_planning_stay_email f4_ ON f0_.id = f4_.file_id LEFT JOIN planning_stay_email p3_ ON p3_.id = f4_.planning_stay_email_id AND (p3_.id = ?) INNER JOIN file_participant f6_ ON f0_.id = f6_.file_id INNER JOIN participant p5_ ON p5_.id = f6_.participant_id AND (p5_.birthday IS NOT NULL) WHERE f0_.confirmation_date IS NOT NULL AND f0_.started_at IS NOT NULL AND f0_.ended_at IS NOT NULL AND DATE(f0_.started_at) >= DATE(f0_.confirmation_date) AND f0_.ended_at >= f0_.started_at AND f0_.register_diff IS NOT NULL AND f0_.disabled_transactional_email = ? AND f2_.id IS NULL AND p3_.id IS NULL AND f0_.brand_id IN (?, ?) AND f0_.started_at >= NOW() AND ((f0_.register_diff >= ? AND f0_.started_at = ?) OR (f0_.register_diff >= ? AND f0_.register_diff <= ? AND f0_.started_at = ?) OR (f0_.register_diff <= ? AND f0_.started_at = ?)) AND p5_.birthday < f0_.started_at AND TIMESTAMPDIFF(YEAR, DATE(p5_.birthday), DATE(f0_.started_at)) < 18 AND f0_.status IN (?, ?, ?, ?)
Parameters: 
[
  4
  4
  0
  1
  2
  28
  "2026-06-29 00:00:00"
  14
  27
  "2026-06-27 00:00:00"
  13
  "2026-06-25 00:00:00"
  "confirmed_registration"
  "complete_file"
  "available_file"
  "connection_made"
]
View formatted query    View runnable query    Explain query
9.75 ms
(2.27%) 		1 
SELECT DISTINCT COUNT(DISTINCT f0_.id) AS sclr_0 FROM file f0_ INNER JOIN brand b1_ ON f0_.brand_id = b1_.id LEFT JOIN file_planning_stay_email_send f2_ ON f0_.id = f2_.file_id AND (f2_.planning_id = ?) LEFT JOIN file_planning_stay_email f4_ ON f0_.id = f4_.file_id LEFT JOIN planning_stay_email p3_ ON p3_.id = f4_.planning_stay_email_id AND (p3_.id = ?) INNER JOIN file_participant f6_ ON f0_.id = f6_.file_id INNER JOIN participant p5_ ON p5_.id = f6_.participant_id AND (p5_.birthday IS NOT NULL) WHERE f0_.confirmation_date IS NOT NULL AND f0_.started_at IS NOT NULL AND f0_.ended_at IS NOT NULL AND DATE(f0_.started_at) >= DATE(f0_.confirmation_date) AND f0_.ended_at >= f0_.started_at AND f0_.register_diff IS NOT NULL AND f0_.disabled_transactional_email = ? AND f2_.id IS NULL AND p3_.id IS NULL AND f0_.brand_id IN (?, ?) AND f0_.started_at >= NOW() AND ((f0_.register_diff >= ? AND f0_.started_at = ?) OR (f0_.register_diff >= ? AND f0_.register_diff <= ? AND f0_.started_at = ?) OR (f0_.register_diff <= ? AND f0_.started_at = ?)) AND p5_.birthday < f0_.started_at AND TIMESTAMPDIFF(YEAR, DATE(p5_.birthday), DATE(f0_.started_at)) < 18 AND f0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND f0_.status IN (?, ?, ?, ?)
Parameters: 
[
  1
  1
  0
  1
  2
  28
  "2026-07-20 00:00:00"
  14
  27
  "2026-07-13 00:00:00"
  13
  "2026-06-29 00:00:00"
  14
  113
  212
  265
  307
  313
  325
  326
  356
  364
  365
  369
  371
  405
  410
  424
  427
  431
  432
  434
  435
  436
  444
  445
  456
  457
  459
  460
  462
  472
  490
  491
  492
  493
  494
  521
  647
  663
  671
  685
  696
  698
  699
  700
  701
  702
  703
  711
  730
  741
  742
  743
  747
  748
  749
  750
  757
  "confirmed_registration"
  "complete_file"
  "available_file"
  "connection_made"
]
View formatted query    View runnable query    Explain query
8.57 ms
(2.00%) 		8 
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.code_compta4 AS code_compta4_3, p0_.deleted_at AS deleted_at_4, p0_.exchange_rate AS exchange_rate_5, p0_.phone AS phone_6, p0_.mobile_phone AS mobile_phone_7, p0_.email AS email_8, p0_.email2 AS email2_9, p0_.website AS website_10, p0_.banner_text AS banner_text_11, p0_.provider_id AS provider_id_12, p0_.grouping AS grouping_13, p0_.mandate_registration_procedure AS mandate_registration_procedure_14, p0_.label_name AS label_name_15, p0_.calendar_type AS calendar_type_16, p0_.code_compta_temp4 AS code_compta_temp4_17, p0_.code_compta_temp_crm4 AS code_compta_temp_crm4_18, p0_.commission_policy AS commission_policy_19, p0_.iban AS iban_20, p0_.tax_code AS tax_code_21, p0_.vat_number AS vat_number_22, p0_.email_transport AS email_transport_23, p0_.contact_commission_to AS contact_commission_to_24, p0_.contact_commission_cc AS contact_commission_cc_25, p0_.country_id AS country_id_26, p0_.currency_id AS currency_id_27, p0_.address_id AS address_id_28, p0_.user_id AS user_id_29 FROM provider p0_ WHERE p0_.deleted_at IS NULL ORDER BY p0_.name ASC
Parameters: 
[]
View formatted query    View runnable query    Explain query
8.45 ms
(1.97%) 		1 
SELECT DISTINCT COUNT(DISTINCT f0_.id) AS sclr_0 FROM file f0_ INNER JOIN brand b1_ ON f0_.brand_id = b1_.id LEFT JOIN file_planning_stay_email_send f2_ ON f0_.id = f2_.file_id AND (f2_.planning_id = ?) LEFT JOIN file_planning_stay_email f4_ ON f0_.id = f4_.file_id LEFT JOIN planning_stay_email p3_ ON p3_.id = f4_.planning_stay_email_id AND (p3_.id = ?) INNER JOIN file_participant f6_ ON f0_.id = f6_.file_id INNER JOIN participant p5_ ON p5_.id = f6_.participant_id AND (p5_.birthday IS NOT NULL) WHERE f0_.confirmation_date IS NOT NULL AND f0_.started_at IS NOT NULL AND f0_.ended_at IS NOT NULL AND DATE(f0_.started_at) >= DATE(f0_.confirmation_date) AND f0_.ended_at >= f0_.started_at AND f0_.register_diff IS NOT NULL AND f0_.disabled_transactional_email = ? AND f2_.id IS NULL AND p3_.id IS NULL AND f0_.brand_id IN (?, ?) AND f0_.started_at >= NOW() AND ((f0_.register_diff >= ? AND f0_.started_at = ?) OR (f0_.register_diff >= ? AND f0_.register_diff <= ? AND f0_.started_at = ?) OR (f0_.register_diff <= ? AND f0_.started_at = ?)) AND p5_.birthday < f0_.started_at AND TIMESTAMPDIFF(YEAR, DATE(p5_.birthday), DATE(f0_.started_at)) < 18 AND f0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND f0_.status IN (?, ?, ?)
Parameters: 
[
  3
  3
  0
  1
  2
  28
  "2026-07-13 00:00:00"
  14
  27
  "2026-07-06 00:00:00"
  13
  "2026-06-27 00:00:00"
  91
  93
  102
  111
  113
  127
  136
  149
  152
  161
  172
  178
  198
  212
  216
  233
  237
  244
  245
  280
  284
  289
  291
  292
  295
  305
  308
  310
  311
  313
  318
  319
  325
  326
  364
  365
  371
  374
  379
  405
  406
  407
  408
  410
  414
  415
  416
  417
  418
  424
  427
  431
  434
  435
  436
  437
  438
  444
  449
  456
  459
  460
  466
  467
  468
  469
  471
  472
  475
  485
  486
  487
  493
  494
  521
  542
  543
  554
  555
  643
  644
  645
  650
  651
  652
  663
  666
  667
  671
  672
  673
  674
  678
  685
  698
  699
  700
  701
  702
  703
  705
  706
  710
  711
  726
  730
  731
  732
  733
  735
  738
  739
  740
  741
  742
  743
  747
  748
  757
  "confirmed_registration"
  "complete_file"
  "available_file"
]
View formatted query    View runnable query    Explain query
8.41 ms
(1.96%) 		1 
SELECT DISTINCT COUNT(DISTINCT f0_.id) AS sclr_0 FROM file f0_ INNER JOIN brand b1_ ON f0_.brand_id = b1_.id LEFT JOIN file_planning_stay_email_send f2_ ON f0_.id = f2_.file_id AND (f2_.planning_id = ?) LEFT JOIN file_planning_stay_email f4_ ON f0_.id = f4_.file_id LEFT JOIN planning_stay_email p3_ ON p3_.id = f4_.planning_stay_email_id AND (p3_.id = ?) INNER JOIN file_participant f6_ ON f0_.id = f6_.file_id INNER JOIN participant p5_ ON p5_.id = f6_.participant_id AND (p5_.birthday IS NOT NULL) WHERE f0_.confirmation_date IS NOT NULL AND f0_.started_at IS NOT NULL AND f0_.ended_at IS NOT NULL AND DATE(f0_.started_at) >= DATE(f0_.confirmation_date) AND f0_.ended_at >= f0_.started_at AND f0_.register_diff IS NOT NULL AND f0_.disabled_transactional_email = ? AND f2_.id IS NULL AND p3_.id IS NULL AND f0_.brand_id IN (?, ?) AND f0_.started_at >= NOW() AND ((f0_.register_diff >= ? AND f0_.started_at = ?) OR (f0_.register_diff >= ? AND f0_.register_diff <= ? AND f0_.started_at = ?) OR (f0_.register_diff <= ? AND f0_.started_at = ?)) AND p5_.birthday < f0_.started_at AND TIMESTAMPDIFF(YEAR, DATE(p5_.birthday), DATE(f0_.started_at)) < 18 AND f0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND f0_.status IN (?, ?, ?, ?)
Parameters: 
[
  2
  2
  0
  1
  2
  28
  "2026-07-20 00:00:00"
  14
  27
  "2026-07-13 00:00:00"
  13
  "2026-06-29 00:00:00"
  91
  93
  102
  111
  125
  127
  131
  136
  149
  172
  178
  198
  216
  233
  237
  244
  245
  280
  284
  289
  290
  291
  292
  295
  305
  308
  310
  311
  318
  319
  374
  379
  406
  407
  416
  417
  418
  437
  449
  467
  468
  471
  475
  487
  542
  543
  554
  555
  644
  645
  666
  667
  672
  673
  674
  690
  705
  706
  710
  726
  731
  732
  733
  735
  738
  739
  740
  "confirmed_registration"
  "complete_file"
  "available_file"
  "connection_made"
]
View formatted query    View runnable query    Explain query
7.72 ms
(1.80%) 		1 
SELECT DISTINCT COUNT(DISTINCT f0_.id) AS sclr_0 FROM file f0_ INNER JOIN brand b1_ ON f0_.brand_id = b1_.id LEFT JOIN file_planning_stay_email_send f2_ ON f0_.id = f2_.file_id AND (f2_.planning_id = ?) LEFT JOIN file_planning_stay_email f4_ ON f0_.id = f4_.file_id LEFT JOIN planning_stay_email p3_ ON p3_.id = f4_.planning_stay_email_id AND (p3_.id = ?) WHERE f0_.confirmation_date IS NOT NULL AND f0_.started_at IS NOT NULL AND f0_.ended_at IS NOT NULL AND DATE(f0_.started_at) >= DATE(f0_.confirmation_date) AND f0_.ended_at >= f0_.started_at AND f0_.register_diff IS NOT NULL AND f0_.disabled_transactional_email = ? AND f2_.id IS NULL AND p3_.id IS NULL AND f0_.brand_id IN (?, ?) AND f0_.started_at >= NOW() AND ((f0_.register_diff >= ? AND f0_.started_at = ?) OR (f0_.register_diff >= ? AND f0_.register_diff <= ? AND f0_.started_at = ?) OR (f0_.register_diff <= ? AND f0_.started_at = ?)) AND f0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND f0_.status IN (?, ?, ?, ?)
Parameters: 
[
  27
  27
  0
  1
  2
  28
  "2026-07-02 00:00:00"
  14
  27
  "2026-07-02 00:00:00"
  13
  "2026-06-30 00:00:00"
  91
  93
  102
  117
  136
  149
  152
  178
  183
  198
  208
  216
  220
  244
  245
  280
  284
  289
  290
  291
  292
  300
  301
  305
  310
  311
  326
  365
  367
  379
  416
  417
  418
  467
  469
  471
  472
  473
  475
  487
  523
  542
  543
  552
  644
  645
  662
  666
  667
  673
  674
  687
  690
  705
  706
  710
  726
  729
  731
  732
  733
  734
  735
  738
  739
  740
  750
  751
  755
  763
  765
  766
  768
  769
  770
  771
  772
  773
  774
  775
  784
  785
  786
  789
  796
  797
  798
  805
  807
  811
  812
  813
  822
  823
  "confirmed_registration"
  "complete_file"
  "available_file"
  "connection_made"
]
View formatted query    View runnable query    Explain query
7.21 ms
(1.68%) 		1 
SELECT DISTINCT COUNT(DISTINCT f0_.id) AS sclr_0 FROM file f0_ INNER JOIN brand b1_ ON f0_.brand_id = b1_.id LEFT JOIN file_planning_stay_email_send f2_ ON f0_.id = f2_.file_id AND (f2_.planning_id = ?) LEFT JOIN file_planning_stay_email f4_ ON f0_.id = f4_.file_id LEFT JOIN planning_stay_email p3_ ON p3_.id = f4_.planning_stay_email_id AND (p3_.id = ?) WHERE f0_.confirmation_date IS NOT NULL AND f0_.started_at IS NOT NULL AND f0_.ended_at IS NOT NULL AND DATE(f0_.started_at) >= DATE(f0_.confirmation_date) AND f0_.ended_at >= f0_.started_at AND f0_.register_diff IS NOT NULL AND f0_.disabled_transactional_email = ? AND f2_.id IS NULL AND p3_.id IS NULL AND f0_.brand_id IN (?, ?) AND f0_.started_at >= NOW() AND ((f0_.register_diff >= ? AND f0_.started_at = ?) OR (f0_.register_diff >= ? AND f0_.register_diff <= ? AND f0_.started_at = ?) OR (f0_.register_diff <= ? AND f0_.started_at = ?)) AND f0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND f0_.status IN (?, ?, ?, ?)
Parameters: 
[
  7
  7
  0
  1
  2
  28
  "2026-07-02 00:00:00"
  14
  27
  "2026-07-02 00:00:00"
  13
  "2026-06-30 00:00:00"
  113
  233
  248
  249
  253
  254
  255
  256
  257
  281
  323
  324
  362
  399
  400
  401
  402
  434
  459
  460
  466
  524
  553
  554
  555
  660
  672
  737
  759
  778
  779
  790
  791
  792
  793
  801
  806
  808
  810
  814
  816
  819
  820
  826
  "available_file"
  "connection_made"
  "confirmed_registration"
  "complete_file"
]
View formatted query    View runnable query    Explain query
5.91 ms
(1.38%) 		1 
SELECT DISTINCT COUNT(f0_.id) AS sclr_0 FROM file f0_ WHERE f0_.view_at IS NULL AND f0_.status IN (?, ?, ?, ?, ?) AND (f0_.started_at >= NOW() OR (f0_.started_at < NOW() AND f0_.ended_at >= NOW()))
Parameters: 
[
  "complete_request"
  "sent_request"
  "confirmed_registration"
  "complete_file"
  "available_file"
]
View formatted query    View runnable query    Explain query
5.83 ms
(1.36%) 		20 
SELECT t0.id AS id_1, t0.status AS status_2, t0.planning_id AS planning_id_3 FROM planning_stay_email_status t0 WHERE t0.planning_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
5.59 ms
(1.30%) 		20 
SELECT t0.id AS id_1, t0.minus AS minus_2, t0.planning_id AS planning_id_3, t0.mapping_route_id AS mapping_route_id_4 FROM planning_stay_email_date t0 WHERE t0.planning_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
5.28 ms
(1.23%) 		20 
SELECT t0.id AS id_1, t0.name AS name_2, t0.email AS email_3, t0.color AS color_4, t0.updated_at AS updated_at_5, t0.prefix AS prefix_6, t0.domain AS domain_7, t0.last_minutes_enabled AS last_minutes_enabled_8, t0.last_minutes_content AS last_minutes_content_9, t0.last_minutes_link AS last_minutes_link_10, t0.has_registration_form AS has_registration_form_11, t0.seller AS seller_12, t0.public_brand AS public_brand_13, t0.logo_id AS logo_id_14, t0.language_id AS language_id_15 FROM brand t0 INNER JOIN planning_stay_email_brand ON t0.id = planning_stay_email_brand.brand_id WHERE planning_stay_email_brand.planning_stay_email_id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
5.00 ms
(1.16%) 		1 
SELECT DISTINCT COUNT(DISTINCT f0_.id) AS sclr_0 FROM file f0_ INNER JOIN brand b1_ ON f0_.brand_id = b1_.id LEFT JOIN file_planning_stay_email_send f2_ ON f0_.id = f2_.file_id AND (f2_.planning_id = ?) LEFT JOIN file_planning_stay_email f4_ ON f0_.id = f4_.file_id LEFT JOIN planning_stay_email p3_ ON p3_.id = f4_.planning_stay_email_id AND (p3_.id = ?) WHERE f0_.confirmation_date IS NOT NULL AND f0_.started_at IS NOT NULL AND f0_.ended_at IS NOT NULL AND DATE(f0_.started_at) >= DATE(f0_.confirmation_date) AND f0_.ended_at >= f0_.started_at AND f0_.register_diff IS NOT NULL AND f0_.disabled_transactional_email = ? AND f2_.id IS NULL AND p3_.id IS NULL AND f0_.brand_id IN (?, ?) AND f0_.started_at >= NOW() AND ((f0_.register_diff >= ? AND f0_.started_at = ?) OR (f0_.register_diff >= ? AND f0_.register_diff <= ? AND f0_.started_at = ?) OR (f0_.register_diff <= ? AND f0_.started_at = ?)) AND f0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND f0_.status IN (?, ?, ?, ?)
Parameters: 
[
  15
  15
  0
  1
  2
  28
  "2026-07-13 00:00:00"
  14
  27
  "2026-07-04 00:00:00"
  13
  "2026-07-02 00:00:00"
  72
  248
  249
  253
  254
  255
  256
  257
  281
  323
  324
  362
  399
  400
  478
  489
  524
  553
  660
  737
  800
  "confirmed_registration"
  "complete_file"
  "available_file"
  "connection_made"
]
View formatted query    View runnable query    Explain query
3.96 ms
(0.92%) 		1 
SELECT DISTINCT COUNT(DISTINCT f0_.id) AS sclr_0 FROM file f0_ INNER JOIN brand b1_ ON f0_.brand_id = b1_.id LEFT JOIN file_planning_stay_email_send f2_ ON f0_.id = f2_.file_id AND (f2_.planning_id = ?) LEFT JOIN file_planning_stay_email f4_ ON f0_.id = f4_.file_id LEFT JOIN planning_stay_email p3_ ON p3_.id = f4_.planning_stay_email_id AND (p3_.id = ?) WHERE f0_.confirmation_date IS NOT NULL AND f0_.started_at IS NOT NULL AND f0_.ended_at IS NOT NULL AND DATE(f0_.started_at) >= DATE(f0_.confirmation_date) AND f0_.ended_at >= f0_.started_at AND f0_.register_diff IS NOT NULL AND f0_.disabled_transactional_email = ? AND f2_.id IS NULL AND p3_.id IS NULL AND f0_.brand_id IN (?, ?) AND f0_.started_at >= NOW() AND ((f0_.register_diff >= ? AND f0_.started_at = ?) OR (f0_.register_diff >= ? AND f0_.register_diff <= ? AND f0_.started_at = ?) OR (f0_.register_diff <= ? AND f0_.started_at = ?)) AND f0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND f0_.status IN (?, ?, ?)
Parameters: 
[
  14
  14
  0
  1
  2
  28
  "2026-08-06 00:00:00"
  14
  27
  "2026-07-06 00:00:00"
  13
  "2026-07-02 00:00:00"
  72
  248
  249
  253
  254
  255
  256
  257
  281
  323
  324
  524
  553
  660
  737
  800
  "confirmed_registration"
  "complete_file"
  "available_file"
]
View formatted query    View runnable query    Explain query
3.56 ms
(0.83%) 		1 
SELECT DISTINCT COUNT(DISTINCT f0_.id) AS sclr_0 FROM file f0_ INNER JOIN brand b1_ ON f0_.brand_id = b1_.id LEFT JOIN file_planning_stay_email_send f2_ ON f0_.id = f2_.file_id AND (f2_.planning_id = ?) LEFT JOIN file_planning_stay_email f4_ ON f0_.id = f4_.file_id LEFT JOIN planning_stay_email p3_ ON p3_.id = f4_.planning_stay_email_id AND (p3_.id = ?) WHERE f0_.confirmation_date IS NOT NULL AND f0_.started_at IS NOT NULL AND f0_.ended_at IS NOT NULL AND DATE(f0_.started_at) >= DATE(f0_.confirmation_date) AND f0_.ended_at >= f0_.started_at AND f0_.register_diff IS NOT NULL AND f0_.disabled_transactional_email = ? AND f2_.id IS NULL AND p3_.id IS NULL AND f0_.brand_id IN (?) AND f0_.started_at >= NOW() AND ((f0_.register_diff >= ? AND f0_.started_at = ?) OR (f0_.register_diff >= ? AND f0_.register_diff <= ? AND f0_.started_at = ?) OR (f0_.register_diff <= ? AND f0_.started_at = ?)) AND f0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND f0_.status IN (?, ?, ?, ?)
Parameters: 
[
  21
  21
  0
  4
  28
  "2026-06-30 00:00:00"
  14
  27
  "2026-06-30 00:00:00"
  13
  "2026-06-30 00:00:00"
  501
  512
  529
  590
  591
  593
  594
  712
  722
  727
  "confirmed_registration"
  "complete_file"
  "available_file"
  "connection_made"
]
View formatted query    View runnable query    Explain query
3.49 ms
(0.81%) 		1 
SELECT DISTINCT COUNT(DISTINCT f0_.id) AS sclr_0 FROM file f0_ INNER JOIN brand b1_ ON f0_.brand_id = b1_.id LEFT JOIN file_planning_stay_email_send f2_ ON f0_.id = f2_.file_id AND (f2_.planning_id = ?) LEFT JOIN file_planning_stay_email f4_ ON f0_.id = f4_.file_id LEFT JOIN planning_stay_email p3_ ON p3_.id = f4_.planning_stay_email_id AND (p3_.id = ?) WHERE f0_.confirmation_date IS NOT NULL AND f0_.started_at IS NOT NULL AND f0_.ended_at IS NOT NULL AND DATE(f0_.started_at) >= DATE(f0_.confirmation_date) AND f0_.ended_at >= f0_.started_at AND f0_.register_diff IS NOT NULL AND f0_.disabled_transactional_email = ? AND f2_.id IS NULL AND p3_.id IS NULL AND f0_.brand_id IN (?, ?) AND f0_.started_at >= NOW() AND ((f0_.register_diff >= ? AND f0_.started_at = ?) OR (f0_.register_diff >= ? AND f0_.register_diff <= ? AND f0_.started_at = ?) OR (f0_.register_diff <= ? AND f0_.started_at = ?)) AND f0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND f0_.status IN (?, ?)
Parameters: 
[
  11
  11
  0
  1
  2
  28
  "2026-06-24 00:00:00"
  14
  27
  "2026-06-24 00:00:00"
  13
  "2026-06-23 00:00:00"
  72
  248
  249
  253
  254
  255
  256
  257
  281
  323
  324
  362
  399
  400
  478
  489
  524
  553
  660
  737
  800
  "available_file"
  "connection_made"
]
View formatted query    View runnable query    Explain query
3.05 ms
(0.71%) 		1 
SELECT DISTINCT COUNT(DISTINCT f0_.id) AS sclr_0 FROM file f0_ INNER JOIN brand b1_ ON f0_.brand_id = b1_.id LEFT JOIN file_planning_stay_email_send f2_ ON f0_.id = f2_.file_id AND (f2_.planning_id = ?) LEFT JOIN file_planning_stay_email f4_ ON f0_.id = f4_.file_id LEFT JOIN planning_stay_email p3_ ON p3_.id = f4_.planning_stay_email_id AND (p3_.id = ?) WHERE f0_.confirmation_date IS NOT NULL AND f0_.started_at IS NOT NULL AND f0_.ended_at IS NOT NULL AND DATE(f0_.started_at) >= DATE(f0_.confirmation_date) AND f0_.ended_at >= f0_.started_at AND f0_.register_diff IS NOT NULL AND f0_.disabled_transactional_email = ? AND f2_.id IS NULL AND p3_.id IS NULL AND f0_.brand_id IN (?, ?) AND f0_.started_at >= NOW() AND ((f0_.register_diff >= ? AND f0_.started_at = ?) OR (f0_.register_diff >= ? AND f0_.register_diff <= ? AND f0_.started_at = ?) OR (f0_.register_diff <= ? AND f0_.started_at = ?)) AND f0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND f0_.status IN (?)
Parameters: 
[
  13
  13
  0
  1
  2
  28
  "2026-07-07 00:00:00"
  14
  27
  "2026-07-07 00:00:00"
  13
  "2026-07-02 00:00:00"
  208
  362
  367
  368
  372
  390
  399
  400
  401
  402
  413
  426
  458
  461
  463
  464
  465
  466
  483
  484
  528
  552
  610
  612
  642
  656
  657
  658
  686
  688
  689
  832
  833
  834
  835
  836
  "connection_made"
]
View formatted query    View runnable query    Explain query
2.92 ms
(0.68%) 		1 
SELECT DISTINCT COUNT(DISTINCT f0_.id) AS sclr_0 FROM file f0_ INNER JOIN brand b1_ ON f0_.brand_id = b1_.id LEFT JOIN file_planning_stay_email_send f2_ ON f0_.id = f2_.file_id AND (f2_.planning_id = ?) LEFT JOIN file_planning_stay_email f4_ ON f0_.id = f4_.file_id LEFT JOIN planning_stay_email p3_ ON p3_.id = f4_.planning_stay_email_id AND (p3_.id = ?) INNER JOIN file_participant f6_ ON f0_.id = f6_.file_id INNER JOIN participant p5_ ON p5_.id = f6_.participant_id AND (p5_.birthday IS NOT NULL) WHERE f0_.confirmation_date IS NOT NULL AND f0_.started_at IS NOT NULL AND f0_.ended_at IS NOT NULL AND DATE(f0_.started_at) >= DATE(f0_.confirmation_date) AND f0_.ended_at >= f0_.started_at AND f0_.register_diff IS NOT NULL AND f0_.disabled_transactional_email = ? AND f2_.id IS NULL AND p3_.id IS NULL AND f0_.brand_id IN (?, ?) AND f0_.started_at >= NOW() AND ((f0_.register_diff >= ? AND f0_.started_at = ?) OR (f0_.register_diff >= ? AND f0_.register_diff <= ? AND f0_.started_at = ?) OR (f0_.register_diff <= ? AND f0_.started_at = ?)) AND p5_.birthday < f0_.started_at AND TIMESTAMPDIFF(YEAR, DATE(p5_.birthday), DATE(f0_.started_at)) < 18 AND f0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND f0_.status IN (?)
Parameters: 
[
  8
  8
  0
  1
  2
  28
  "2026-06-24 00:00:00"
  14
  27
  "2026-06-24 00:00:00"
  13
  "2026-06-23 00:00:00"
  14
  44
  59
  95
  113
  212
  223
  265
  266
  307
  313
  325
  326
  356
  364
  365
  369
  371
  405
  410
  412
  424
  427
  431
  432
  434
  435
  436
  444
  445
  456
  459
  460
  472
  490
  493
  494
  521
  663
  698
  699
  700
  701
  702
  703
  711
  730
  741
  743
  747
  748
  757
  "available_file"
]
View formatted query    View runnable query    Explain query
2.85 ms
(0.66%) 		1 
SELECT DISTINCT COUNT(DISTINCT f0_.id) AS sclr_0 FROM file f0_ INNER JOIN brand b1_ ON f0_.brand_id = b1_.id LEFT JOIN file_planning_stay_email_send f2_ ON f0_.id = f2_.file_id AND (f2_.planning_id = ?) LEFT JOIN file_planning_stay_email f4_ ON f0_.id = f4_.file_id LEFT JOIN planning_stay_email p3_ ON p3_.id = f4_.planning_stay_email_id AND (p3_.id = ?) WHERE f0_.confirmation_date IS NOT NULL AND f0_.started_at IS NOT NULL AND f0_.ended_at IS NOT NULL AND DATE(f0_.started_at) >= DATE(f0_.confirmation_date) AND f0_.ended_at >= f0_.started_at AND f0_.register_diff IS NOT NULL AND f0_.disabled_transactional_email = ? AND f2_.id IS NULL AND p3_.id IS NULL AND f0_.brand_id IN (?, ?) AND f0_.started_at >= NOW() AND ((f0_.register_diff >= ? AND f0_.started_at = ?) OR (f0_.register_diff >= ? AND f0_.register_diff <= ? AND f0_.started_at = ?) OR (f0_.register_diff <= ? AND f0_.started_at = ?)) AND f0_.product_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND f0_.status IN (?)
Parameters: 
[
  6
  6
  0
  1
  2
  28
  "2026-06-24 00:00:00"
  14
  27
  "2026-06-24 00:00:00"
  13
  "2026-06-23 00:00:00"
  91
  93
  102
  111
  127
  136
  149
  152
  161
  172
  178
  198
  216
  233
  237
  244
  245
  280
  284
  289
  290
  291
  292
  295
  305
  308
  310
  311
  318
  319
  374
  379
  406
  407
  416
  417
  418
  437
  449
  467
  468
  469
  471
  475
  487
  542
  543
  554
  555
  644
  645
  666
  667
  672
  673
  674
  690
  705
  706
  710
  726
  731
  732
  733
  735
  738
  739
  740
  755
  765
  766
  769
  770
  771
  772
  773
  774
  775
  778
  779
  781
  782
  783
  787
  788
  789
  791
  792
  793
  794
  795
  796
  797
  799
  801
  802
  803
  806
  810
  815
  821
  826
  "available_file"
]
View formatted query    View runnable query    Explain query
2.67 ms
(0.62%) 		2 
SELECT DISTINCT COUNT(DISTINCT f0_.id) AS sclr_0 FROM file f0_ INNER JOIN brand b1_ ON f0_.brand_id = b1_.id LEFT JOIN file_planning_stay_email_send f2_ ON f0_.id = f2_.file_id AND (f2_.planning_id = ?) LEFT JOIN file_planning_stay_email f4_ ON f0_.id = f4_.file_id LEFT JOIN planning_stay_email p3_ ON p3_.id = f4_.planning_stay_email_id AND (p3_.id = ?) WHERE f0_.confirmation_date IS NOT NULL AND f0_.started_at IS NOT NULL AND f0_.ended_at IS NOT NULL AND DATE(f0_.started_at) >= DATE(f0_.confirmation_date) AND f0_.ended_at >= f0_.started_at AND f0_.register_diff IS NOT NULL AND f0_.disabled_transactional_email = ? AND f2_.id IS NULL AND p3_.id IS NULL AND f0_.brand_id IN (?) AND f0_.started_at >= NOW() AND ((f0_.register_diff >= ? AND f0_.started_at = ?) OR (f0_.register_diff >= ? AND f0_.register_diff <= ? AND f0_.started_at = ?) OR (f0_.register_diff <= ? AND f0_.started_at = ?)) AND f0_.product_id IN (?, ?) AND f0_.status IN (?, ?, ?, ?)
Parameters: 
[
  22
  22
  0
  4
  28
  "2026-06-30 00:00:00"
  14
  27
  "2026-06-30 00:00:00"
  13
  "2026-06-27 00:00:00"
  514
  578
  "confirmed_registration"
  "complete_file"
  "available_file"
  "connection_made"
]
View formatted query    View runnable query    Explain query
2.43 ms
(0.57%) 		1 
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.email AS email_2, b0_.color AS color_3, b0_.updated_at AS updated_at_4, b0_.prefix AS prefix_5, b0_.domain AS domain_6, b0_.last_minutes_enabled AS last_minutes_enabled_7, b0_.last_minutes_content AS last_minutes_content_8, b0_.last_minutes_link AS last_minutes_link_9, b0_.has_registration_form AS has_registration_form_10, b0_.seller AS seller_11, b0_.public_brand AS public_brand_12, b0_.logo_id AS logo_id_13, b0_.language_id AS language_id_14 FROM brand b0_ INNER JOIN parameters p1_ ON b0_.id = p1_.brand_id WHERE p1_.parameter_key LIKE ? AND p1_.parameter_value = ?
Parameters: 
[
  "%enable_insurance_email%"
  "true"
]
View formatted query    View runnable query    Explain query
2.35 ms
(0.55%) 		1 
SELECT DISTINCT COUNT(DISTINCT f0_.id) AS sclr_0 FROM file f0_ INNER JOIN brand b1_ ON f0_.brand_id = b1_.id LEFT JOIN file_planning_stay_email_send f2_ ON f0_.id = f2_.file_id AND (f2_.planning_id = ?) LEFT JOIN file_planning_stay_email f4_ ON f0_.id = f4_.file_id LEFT JOIN planning_stay_email p3_ ON p3_.id = f4_.planning_stay_email_id AND (p3_.id = ?) WHERE f0_.confirmation_date IS NOT NULL AND f0_.started_at IS NOT NULL AND f0_.ended_at IS NOT NULL AND DATE(f0_.started_at) >= DATE(f0_.confirmation_date) AND f0_.ended_at >= f0_.started_at AND f0_.register_diff IS NOT NULL AND f0_.disabled_transactional_email = ? AND f2_.id IS NULL AND p3_.id IS NULL AND f0_.brand_id IN (?) AND f0_.started_at >= NOW() AND ((f0_.register_diff >= ? AND f0_.started_at = ?) OR (f0_.register_diff >= ? AND f0_.register_diff <= ? AND f0_.started_at = ?) OR (f0_.register_diff <= ? AND f0_.started_at = ?)) AND f0_.product_id IN (?, ?, ?, ?, ?, ?) AND f0_.status IN (?, ?, ?, ?)
Parameters: 
[
  23
  23
  0
  4
  28
  "2026-06-30 00:00:00"
  14
  27
  "2026-06-30 00:00:00"
  13
  "2026-06-27 00:00:00"
  513
  530
  561
  575
  576
  581
  "confirmed_registration"
  "complete_file"
  "available_file"
  "connection_made"
]
View formatted query    View runnable query    Explain query
2.17 ms
(0.51%) 		1 
SELECT DISTINCT COUNT(DISTINCT f0_.id) AS sclr_0 FROM file f0_ INNER JOIN brand b1_ ON f0_.brand_id = b1_.id LEFT JOIN file_planning_stay_email_send f2_ ON f0_.id = f2_.file_id AND (f2_.planning_id = ?) LEFT JOIN file_planning_stay_email f4_ ON f0_.id = f4_.file_id LEFT JOIN planning_stay_email p3_ ON p3_.id = f4_.planning_stay_email_id AND (p3_.id = ?) WHERE f0_.confirmation_date IS NOT NULL AND f0_.started_at IS NOT NULL AND f0_.ended_at IS NOT NULL AND DATE(f0_.started_at) >= DATE(f0_.confirmation_date) AND f0_.ended_at >= f0_.started_at AND f0_.register_diff IS NOT NULL AND f0_.disabled_transactional_email = ? AND f2_.id IS NULL AND p3_.id IS NULL AND f0_.brand_id IN (?, ?) AND f0_.started_at >= NOW() AND ((f0_.register_diff >= ? AND f0_.started_at = ?) OR (f0_.register_diff >= ? AND f0_.register_diff <= ? AND f0_.started_at = ?) OR (f0_.register_diff <= ? AND f0_.started_at = ?)) AND f0_.product_id IN (?, ?, ?, ?, ?) AND f0_.status IN (?)
Parameters: 
[
  20
  20
  0
  1
  2
  28
  "2026-08-06 00:00:00"
  14
  27
  "2026-07-06 00:00:00"
  13
  "2026-07-02 00:00:00"
  362
  399
  400
  478
  489
  "connection_made"
]
View formatted query    View runnable query    Explain query
1.99 ms
(0.46%) 		1 
SELECT DISTINCT COUNT(DISTINCT f0_.id) AS sclr_0 FROM file f0_ INNER JOIN brand b1_ ON f0_.brand_id = b1_.id LEFT JOIN file_planning_stay_email_send f2_ ON f0_.id = f2_.file_id AND (f2_.planning_id = ?) LEFT JOIN file_planning_stay_email f4_ ON f0_.id = f4_.file_id LEFT JOIN planning_stay_email p3_ ON p3_.id = f4_.planning_stay_email_id AND (p3_.id = ?) WHERE f0_.confirmation_date IS NOT NULL AND f0_.started_at IS NOT NULL AND f0_.ended_at IS NOT NULL AND DATE(f0_.started_at) >= DATE(f0_.confirmation_date) AND f0_.ended_at >= f0_.started_at AND f0_.register_diff IS NOT NULL AND f0_.disabled_transactional_email = ? AND f2_.id IS NULL AND p3_.id IS NULL AND f0_.brand_id IN (?) AND f0_.started_at >= NOW() AND ((f0_.register_diff >= ? AND f0_.started_at = ?) OR (f0_.register_diff >= ? AND f0_.register_diff <= ? AND f0_.started_at = ?) OR (f0_.register_diff <= ? AND f0_.started_at = ?)) AND f0_.product_id IN (?, ?, ?, ?, ?) AND f0_.status IN (?, ?, ?, ?)
Parameters: 
[
  25
  25
  0
  4
  28
  "2026-06-30 00:00:00"
  14
  27
  "2026-06-30 00:00:00"
  13
  "2026-06-27 00:00:00"
  518
  522
  559
  560
  564
  "confirmed_registration"
  "complete_file"
  "available_file"
  "connection_made"
]
View formatted query    View runnable query    Explain query
1.71 ms
(0.40%) 		1 
SELECT t0.id AS id_1, t0.code AS code_2, t0.alpha2 AS alpha2_3, t0.alpha3 AS alpha3_4, t0.name AS name_5, t0.name_it AS name_it_6, t0.slug AS slug_7, t0.active AS active_8, t0.website AS website_9, t0.`order` AS order_10, t0.crm_value AS crm_value_11, t0.visa_procedure AS visa_procedure_12, t0.essential_document1 AS essential_document1_13, t0.essential_document2 AS essential_document2_14, t0.essential_document3 AS essential_document3_15, t0.essential_document4 AS essential_document4_16, t0.essential_document5 AS essential_document5_17, t0.essential_document6 AS essential_document6_18, t0.nationality_name_fr AS nationality_name_fr_19, t0.nationality_name_en AS nationality_name_en_20, t0.nationality_name_it AS nationality_name_it_21, t0.passport_only AS passport_only_22, t0.hubspot_name AS hubspot_name_23, t0.carbon_offset_amount AS carbon_offset_amount_24, t0.last_confirm AS last_confirm_25, t0.mainland_id AS mainland_id_26 FROM country t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  11
  210
  75
  242
  55
  109
  155
  243
  84
  18
  60
  161
  150
  175
  58
  201
  209
  244
  12
  54
  149
  213
  198
  103
  41
  43
  10
  241
  182
  128
  178
]
View formatted query    View runnable query    Explain query
1.65 ms
(0.38%) 		1 
SELECT DISTINCT COUNT(DISTINCT f0_.id) AS sclr_0 FROM file f0_ INNER JOIN brand b1_ ON f0_.brand_id = b1_.id LEFT JOIN file_planning_stay_email_send f2_ ON f0_.id = f2_.file_id AND (f2_.planning_id = ?) LEFT JOIN file_planning_stay_email f4_ ON f0_.id = f4_.file_id LEFT JOIN planning_stay_email p3_ ON p3_.id = f4_.planning_stay_email_id AND (p3_.id = ?) WHERE f0_.confirmation_date IS NOT NULL AND f0_.started_at IS NOT NULL AND f0_.ended_at IS NOT NULL AND DATE(f0_.started_at) >= DATE(f0_.confirmation_date) AND f0_.ended_at >= f0_.started_at AND f0_.register_diff IS NOT NULL AND f0_.disabled_transactional_email = ? AND f2_.id IS NULL AND p3_.id IS NULL AND f0_.brand_id IN (?) AND f0_.started_at >= NOW() AND ((f0_.register_diff >= ? AND f0_.started_at = ?) OR (f0_.register_diff >= ? AND f0_.register_diff <= ? AND f0_.started_at = ?) OR (f0_.register_diff <= ? AND f0_.started_at = ?)) AND f0_.product_id IN (?, ?, ?) AND f0_.status IN (?, ?, ?, ?)
Parameters: 
[
  26
  26
  0
  4
  28
  "2026-06-30 00:00:00"
  14
  27
  "2026-06-30 00:00:00"
  13
  "2026-06-27 00:00:00"
  556
  745
  746
  "confirmed_registration"
  "complete_file"
  "available_file"
  "connection_made"
]
View formatted query    View runnable query    Explain query
1.37 ms
(0.32%) 		1 
SELECT DISTINCT COUNT(DISTINCT f0_.id) AS sclr_0 FROM file f0_ INNER JOIN brand b1_ ON f0_.brand_id = b1_.id LEFT JOIN file_planning_stay_email_send f2_ ON f0_.id = f2_.file_id AND (f2_.planning_id = ?) LEFT JOIN file_planning_stay_email f4_ ON f0_.id = f4_.file_id LEFT JOIN planning_stay_email p3_ ON p3_.id = f4_.planning_stay_email_id AND (p3_.id = ?) WHERE f0_.confirmation_date IS NOT NULL AND f0_.started_at IS NOT NULL AND f0_.ended_at IS NOT NULL AND DATE(f0_.started_at) >= DATE(f0_.confirmation_date) AND f0_.ended_at >= f0_.started_at AND f0_.register_diff IS NOT NULL AND f0_.disabled_transactional_email = ? AND f2_.id IS NULL AND p3_.id IS NULL AND f0_.brand_id IN (?) AND f0_.started_at >= NOW() AND ((f0_.register_diff >= ? AND f0_.started_at = ?) OR (f0_.register_diff >= ? AND f0_.register_diff <= ? AND f0_.started_at = ?) OR (f0_.register_diff <= ? AND f0_.started_at = ?)) AND f0_.product_id IN (?, ?, ?, ?) AND f0_.status IN (?, ?, ?, ?)
Parameters: 
[
  28
  28
  0
  4
  28
  "2026-06-30 00:00:00"
  14
  27
  "2026-06-30 00:00:00"
  13
  "2026-06-27 00:00:00"
  520
  592
  646
  728
  "confirmed_registration"
  "complete_file"
  "available_file"
  "connection_made"
]
View formatted query    View runnable query    Explain query
1.14 ms
(0.27%) 		3 
SELECT t0.id AS id_1, t0.num AS num_2, t0.min AS min_3, t0.max AS max_4 FROM mapping_route_item t0 WHERE t0.id = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.61 ms
(0.14%) 		1 
SELECT d0_.id AS id_0, d1_.name AS name_1, p2_.date_year AS date_year_2, f3_.id AS id_3, c4_.civility AS civility_4, CONCAT(p5_.firstname, ' ', p5_.lastname) AS sclr_5, b6_.id AS id_6, b6_.prefix AS prefix_7, b6_.color AS color_8, f3_.started_at AS started_at_9, p7_.name AS name_10, p8_.name AS name_11, c9_.name AS name_12 FROM document_requirement d10_ INNER JOIN file f3_ INNER JOIN brand b6_ ON f3_.brand_id = b6_.id INNER JOIN product p7_ ON f3_.product_id = p7_.id LEFT JOIN file_participant f11_ ON f3_.id = f11_.file_id LEFT JOIN participant p5_ ON p5_.id = f11_.participant_id INNER JOIN civility c4_ ON p5_.civility_id = c4_.id INNER JOIN provider p8_ ON p7_.provider_id = p8_.id LEFT JOIN provider p12_ ON f3_.mandate_provider_id = p12_.id INNER JOIN country c9_ ON p8_.country_id = c9_.id INNER JOIN document d0_ ON d10_.document_id = d0_.id LEFT JOIN document_translation d1_ ON d0_.id = d1_.translatable_id LEFT JOIN document_brand d14_ ON d0_.id = d14_.document_id LEFT JOIN brand b13_ ON b13_.id = d14_.brand_id LEFT JOIN file_required_document f15_ ON (f15_.requirement_document_id = d10_.id AND f15_.file_id = f3_.id) LEFT JOIN media m16_ ON f15_.document_id = m16_.id LEFT JOIN document_version d17_ ON f15_.nominative_document_version_id = d17_.id LEFT JOIN quotation q18_ ON f3_.id = q18_.file_id LEFT JOIN pricing p2_ ON q18_.tariff_id = p2_.id AND p2_.discriminator IN ('tariff') WHERE ((d10_.product_id = p7_.id) OR (d10_.provider_id = p8_.id OR (p12_.id IS NOT NULL AND d10_.provider_id = p12_.id)) OR (d10_.country_id = c9_.id)) AND d1_.locale = ? AND f3_.status IN (?, ?, ?, ?, ?, ?) AND ((d10_.validity_start_date IS NULL AND d10_.validity_end_date IS NULL) OR (p8_.calendar_type = ? AND d10_.validity_start_date = CONCAT(p2_.date_year, '-01-01') AND d10_.validity_end_date = CONCAT(p2_.date_year, '-12-31')) OR (p2_.date_year IS NULL AND d10_.validity_start_date <= ? AND ? <= d10_.validity_end_date)) AND d10_.desactivate_at IS NULL AND b6_.id = b13_.id AND (d10_.sender = ? OR (d10_.sender = ? AND d10_.nominative = 1 AND d10_.completion <> ? AND f15_.nominative_document_version_id IS NULL)) AND d10_.required = 1 AND (f15_.id IS NULL OR (f15_.id IS NOT NULL AND m16_.id IS NOT NULL AND m16_.validate = 0) OR (f15_.id IS NOT NULL AND d17_.id IS NOT NULL AND m16_.id IS NULL AND d10_.completion <> ?) OR (f15_.id IS NOT NULL AND d17_.id IS NOT NULL AND m16_.id IS NOT NULL AND m16_.validate = 0)) ORDER BY f3_.id DESC
Parameters: 
[
  "en"
  "complete_request"
  "sent_request"
  "confirmed_registration"
  "complete_file"
  "available_file"
  "connection_made"
  "gregorian"
  "2026-06-22"
  "2026-06-22"
  "provider"
  "customer"
  "to_fill"
  "to_download_only"
]
View formatted query    View runnable query    Explain query
0.49 ms
(0.11%) 		1 
SELECT COUNT(DISTINCT f0_.id) AS sclr_0 FROM file f0_ LEFT JOIN cart c1_ ON f0_.id = c1_.file_id LEFT JOIN file_participant f3_ ON f0_.id = f3_.file_id LEFT JOIN participant p2_ ON p2_.id = f3_.participant_id LEFT JOIN customer c4_ ON p2_.customer_id = c4_.id LEFT JOIN customer c5_ ON f0_.customer_id = c5_.id LEFT JOIN brand b6_ ON f0_.brand_id = b6_.id LEFT JOIN customer c7_ ON f0_.parent2_id = c7_.id INNER JOIN product p8_ ON f0_.product_id = p8_.id LEFT JOIN product_translation p9_ ON p8_.id = p9_.translatable_id LEFT JOIN productcategory p10_ ON p8_.new_main_category_id = p10_.id LEFT JOIN provider p11_ ON p8_.provider_id = p11_.id LEFT JOIN currency c12_ ON p11_.currency_id = c12_.id LEFT JOIN country c13_ ON p11_.country_id = c13_.id LEFT JOIN provider p14_ ON f0_.mandate_provider_id = p14_.id LEFT JOIN country c15_ ON p14_.country_id = c15_.id LEFT JOIN product_registration_procedure p16_ ON p8_.id = p16_.product_id LEFT JOIN invoice i17_ ON f0_.id = i17_.file_id LEFT JOIN crm c18_ ON f0_.id = c18_.file_id LEFT JOIN user u19_ ON f0_.followed_by_id = u19_.id LEFT JOIN file_payment f20_ ON f0_.id = f20_.file_id LEFT JOIN currency c21_ ON f20_.currency_id = c21_.id WHERE f0_.status IN (?) AND f0_.document_file_departure_read = ? AND (f0_.started_at BETWEEN ? AND ?) ORDER BY f0_.id DESC
Parameters: 
[
  "available_file"
  0
  "2026-06-22 00:00:00"
  "2026-06-25 23:59:59"
]
View formatted query    View runnable query    Explain query
0.41 ms
(0.10%) 		1 
SELECT COUNT(DISTINCT f0_.id) AS sclr_0 FROM file f0_ LEFT JOIN cart c1_ ON f0_.id = c1_.file_id LEFT JOIN file_participant f3_ ON f0_.id = f3_.file_id LEFT JOIN participant p2_ ON p2_.id = f3_.participant_id LEFT JOIN customer c4_ ON p2_.customer_id = c4_.id LEFT JOIN customer c5_ ON f0_.customer_id = c5_.id LEFT JOIN brand b6_ ON f0_.brand_id = b6_.id LEFT JOIN customer c7_ ON f0_.parent2_id = c7_.id INNER JOIN product p8_ ON f0_.product_id = p8_.id LEFT JOIN product_translation p9_ ON p8_.id = p9_.translatable_id LEFT JOIN productcategory p10_ ON p8_.new_main_category_id = p10_.id LEFT JOIN provider p11_ ON p8_.provider_id = p11_.id LEFT JOIN currency c12_ ON p11_.currency_id = c12_.id LEFT JOIN country c13_ ON p11_.country_id = c13_.id LEFT JOIN provider p14_ ON f0_.mandate_provider_id = p14_.id LEFT JOIN country c15_ ON p14_.country_id = c15_.id LEFT JOIN product_registration_procedure p16_ ON p8_.id = p16_.product_id LEFT JOIN invoice i17_ ON f0_.id = i17_.file_id LEFT JOIN crm c18_ ON f0_.id = c18_.file_id LEFT JOIN user u19_ ON f0_.followed_by_id = u19_.id LEFT JOIN file_payment f20_ ON f0_.id = f20_.file_id LEFT JOIN currency c21_ ON f20_.currency_id = c21_.id WHERE f0_.status IN (?) AND f0_.type = ? ORDER BY f0_.id DESC
Parameters: 
[
  "complete_request"
  "consulting"
]
View formatted query    View runnable query    Explain query
0.40 ms
(0.09%) 		1 
SELECT COUNT(DISTINCT f0_.id) AS sclr_0 FROM file f0_ LEFT JOIN cart c1_ ON f0_.id = c1_.file_id LEFT JOIN file_participant f3_ ON f0_.id = f3_.file_id LEFT JOIN participant p2_ ON p2_.id = f3_.participant_id LEFT JOIN customer c4_ ON p2_.customer_id = c4_.id LEFT JOIN customer c5_ ON f0_.customer_id = c5_.id LEFT JOIN brand b6_ ON f0_.brand_id = b6_.id LEFT JOIN customer c7_ ON f0_.parent2_id = c7_.id INNER JOIN product p8_ ON f0_.product_id = p8_.id LEFT JOIN product_translation p9_ ON p8_.id = p9_.translatable_id LEFT JOIN productcategory p10_ ON p8_.new_main_category_id = p10_.id LEFT JOIN provider p11_ ON p8_.provider_id = p11_.id LEFT JOIN currency c12_ ON p11_.currency_id = c12_.id LEFT JOIN country c13_ ON p11_.country_id = c13_.id LEFT JOIN provider p14_ ON f0_.mandate_provider_id = p14_.id LEFT JOIN country c15_ ON p14_.country_id = c15_.id LEFT JOIN product_registration_procedure p16_ ON p8_.id = p16_.product_id LEFT JOIN invoice i17_ ON f0_.id = i17_.file_id LEFT JOIN crm c18_ ON f0_.id = c18_.file_id LEFT JOIN user u19_ ON f0_.followed_by_id = u19_.id LEFT JOIN file_payment f20_ ON f0_.id = f20_.file_id LEFT JOIN currency c21_ ON f20_.currency_id = c21_.id WHERE f0_.status IN (?) AND f0_.type <> ? AND f0_.status = ? AND (i17_.toward = ? OR c18_.id IS NOT NULL) AND c1_.id IS NOT NULL AND (c1_.amount > 0 OR c1_.amount_currency > 0) AND (c1_.amount_remaning <= 0 AND c1_.amount_remaning_currency <= 0) AND (f0_.customer_access = ? OR f0_.validate_transport = ?) ORDER BY f0_.id DESC
Parameters: 
[
  "confirmed_registration"
  "mandate"
  "confirmed_registration"
  "cus"
  0
  1
]
View formatted query    View runnable query    Explain query
0.36 ms
(0.08%) 		1 
SELECT COUNT(e0_.id) AS sclr_0 FROM email_log e0_
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.35 ms
(0.08%) 		1 
SELECT COUNT(DISTINCT f0_.id) AS sclr_0 FROM file f0_ LEFT JOIN cart c1_ ON f0_.id = c1_.file_id LEFT JOIN file_participant f3_ ON f0_.id = f3_.file_id LEFT JOIN participant p2_ ON p2_.id = f3_.participant_id LEFT JOIN customer c4_ ON p2_.customer_id = c4_.id LEFT JOIN customer c5_ ON f0_.customer_id = c5_.id LEFT JOIN brand b6_ ON f0_.brand_id = b6_.id LEFT JOIN customer c7_ ON f0_.parent2_id = c7_.id INNER JOIN product p8_ ON f0_.product_id = p8_.id LEFT JOIN product_translation p9_ ON p8_.id = p9_.translatable_id LEFT JOIN productcategory p10_ ON p8_.new_main_category_id = p10_.id LEFT JOIN provider p11_ ON p8_.provider_id = p11_.id LEFT JOIN currency c12_ ON p11_.currency_id = c12_.id LEFT JOIN country c13_ ON p11_.country_id = c13_.id LEFT JOIN provider p14_ ON f0_.mandate_provider_id = p14_.id LEFT JOIN country c15_ ON p14_.country_id = c15_.id LEFT JOIN product_registration_procedure p16_ ON p8_.id = p16_.product_id LEFT JOIN invoice i17_ ON f0_.id = i17_.file_id LEFT JOIN crm c18_ ON f0_.id = c18_.file_id LEFT JOIN user u19_ ON f0_.followed_by_id = u19_.id LEFT JOIN file_payment f20_ ON f0_.id = f20_.file_id LEFT JOIN currency c21_ ON f20_.currency_id = c21_.id WHERE f0_.status IN (?, ?, ?, ?) AND (f0_.outward_as_um = ? AND f0_.um_correspondent_id IS NULL AND f0_.um_contact_id IS NULL) AND (f0_.started_at BETWEEN ? AND ?) ORDER BY f0_.id DESC
Parameters: 
[
  "confirmed_registration"
  "complete_file"
  "available_file"
  "connection_made"
  1
  "2026-06-22 00:00:00"
  "2026-07-02 23:59:59"
]
View formatted query    View runnable query    Explain query
0.35 ms
(0.08%) 		1 
SELECT t0.id AS id_1, t0.email AS email_2, t0.new_email AS new_email_3, t0.roles AS roles_4, t0.password AS password_5, t0.state AS state_6, t0.activate_token AS activate_token_7, t0.reset_password_token AS reset_password_token_8, t0.reset_password_at AS reset_password_at_9, t0.new_email_token AS new_email_token_10, t0.env AS env_11, t0.api_key AS api_key_12, t0.last_name AS last_name_13, t0.first_name AS first_name_14, t0.hide_welcome_message AS hide_welcome_message_15, t0.email_signature AS email_signature_16, t0.email_educator_signature AS email_educator_signature_17, t0.created_at AS created_at_18, t0.last_login_at AS last_login_at_19, t0.google_authenticator_secret AS google_authenticator_secret_20, t0.deleted_at AS deleted_at_21, t0.slug AS slug_22, t0.linked_in_link AS linked_in_link_23, t0.google_id AS google_id_24, t0.facebook_id AS facebook_id_25, t0.linkdin_id AS linkdin_id_26, t27.id AS id_28, t27.type AS type_29, t27.society_name AS society_name_30, t27.lastname AS lastname_31, t27.firstname AS firstname_32, t27.family_situation AS family_situation_33, t27.mobile_phone_number AS mobile_phone_number_34, t27.fix_phone_number AS fix_phone_number_35, t27.original_how_known AS original_how_known_36, t27.comment AS comment_37, t27.last_update_at AS last_update_at_38, t27.created_at AS created_at_39, t27.email AS email_40, t27.tax_code AS tax_code_41, t27.sdi_code AS sdi_code_42, t27.archived AS archived_43, t27.last_customer_update_at AS last_customer_update_at_44, t27.customer_id AS customer_id_45, t27.vat_number AS vat_number_46, t27.state AS state_47, t27.last_validated_at AS last_validated_at_48, t27.validated AS validated_49, t27.job AS job_50, t27.hubspot_id AS hubspot_id_51, t27.hubspot_matched AS hubspot_matched_52, t27.hubspot_email_added AS hubspot_email_added_53, t27.check_hubspot AS check_hubspot_54, t27.check_tags AS check_tags_55, t27.civility_id AS civility_id_56, t27.family_status_id AS family_status_id_57, t27.main_address_id AS main_address_id_58, t27.billing_address_id AS billing_address_id_59, t27.howknown_id AS howknown_id_60, t27.user_id AS user_id_61, t27.brand_id AS brand_id_62, t27.new_job_id AS new_job_id_63, t64.id AS id_65, t64.name AS name_66, t64.slug AS slug_67, t64.code_compta4 AS code_compta4_68, t64.deleted_at AS deleted_at_69, t64.exchange_rate AS exchange_rate_70, t64.phone AS phone_71, t64.mobile_phone AS mobile_phone_72, t64.email AS email_73, t64.email2 AS email2_74, t64.website AS website_75, t64.banner_text AS banner_text_76, t64.provider_id AS provider_id_77, t64.grouping AS grouping_78, t64.mandate_registration_procedure AS mandate_registration_procedure_79, t64.label_name AS label_name_80, t64.calendar_type AS calendar_type_81, t64.code_compta_temp4 AS code_compta_temp4_82, t64.code_compta_temp_crm4 AS code_compta_temp_crm4_83, t64.commission_policy AS commission_policy_84, t64.iban AS iban_85, t64.tax_code AS tax_code_86, t64.vat_number AS vat_number_87, t64.email_transport AS email_transport_88, t64.contact_commission_to AS contact_commission_to_89, t64.contact_commission_cc AS contact_commission_cc_90, t64.country_id AS country_id_91, t64.currency_id AS currency_id_92, t64.address_id AS address_id_93, t64.user_id AS user_id_94, t0.brand_id AS brand_id_95 FROM user t0 LEFT JOIN customer t27 ON t27.user_id = t0.id LEFT JOIN provider t64 ON t64.user_id = t0.id WHERE t0.id = ?
Parameters: 
[
  5
]
View formatted query    View runnable query    Explain query
0.35 ms
(0.08%) 		1 
SELECT COUNT(f0_.id) AS sclr_0 FROM file_planning_stay_email_send f0_ WHERE f0_.send_at IS NULL OR f0_.error IS NOT NULL
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.35 ms
(0.08%) 		1 
SELECT t0.id AS id_1, t0.name AS name_2, t0.minor AS minor_3, t0.all_product AS all_product_4, t0.active AS active_5, t0.end_date AS end_date_6, t0.template_id AS template_id_7 FROM planning_stay_email t0 WHERE t0.active = ?
Parameters: 
[
  1
]
View formatted query    View runnable query    Explain query
0.34 ms
(0.08%) 		1 
SELECT COUNT(DISTINCT f0_.id) AS sclr_0 FROM file f0_ LEFT JOIN cart c1_ ON f0_.id = c1_.file_id LEFT JOIN file_participant f3_ ON f0_.id = f3_.file_id LEFT JOIN participant p2_ ON p2_.id = f3_.participant_id LEFT JOIN customer c4_ ON p2_.customer_id = c4_.id LEFT JOIN customer c5_ ON f0_.customer_id = c5_.id LEFT JOIN brand b6_ ON f0_.brand_id = b6_.id LEFT JOIN customer c7_ ON f0_.parent2_id = c7_.id INNER JOIN product p8_ ON f0_.product_id = p8_.id LEFT JOIN product_translation p9_ ON p8_.id = p9_.translatable_id LEFT JOIN productcategory p10_ ON p8_.new_main_category_id = p10_.id LEFT JOIN provider p11_ ON p8_.provider_id = p11_.id LEFT JOIN currency c12_ ON p11_.currency_id = c12_.id LEFT JOIN country c13_ ON p11_.country_id = c13_.id LEFT JOIN provider p14_ ON f0_.mandate_provider_id = p14_.id LEFT JOIN country c15_ ON p14_.country_id = c15_.id LEFT JOIN product_registration_procedure p16_ ON p8_.id = p16_.product_id LEFT JOIN invoice i17_ ON f0_.id = i17_.file_id LEFT JOIN crm c18_ ON f0_.id = c18_.file_id LEFT JOIN user u19_ ON f0_.followed_by_id = u19_.id LEFT JOIN file_payment f20_ ON f0_.id = f20_.file_id LEFT JOIN currency c21_ ON f20_.currency_id = c21_.id WHERE f0_.status IN (?, ?, ?, ?, ?, ?) AND f0_.started_at <= ? AND f0_.type = ? AND f0_.validate_date_at IS NULL ORDER BY f0_.id DESC
Parameters: 
[
  "complete_request"
  "sent_request"
  "confirmed_registration"
  "complete_file"
  "available_file"
  "connection_made"
  "2026-07-02 00:00:00"
  "mandate"
]
View formatted query    View runnable query    Explain query
0.32 ms
(0.07%) 		1 
SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.email AS email_2, b0_.color AS color_3, b0_.updated_at AS updated_at_4, b0_.prefix AS prefix_5, b0_.domain AS domain_6, b0_.last_minutes_enabled AS last_minutes_enabled_7, b0_.last_minutes_content AS last_minutes_content_8, b0_.last_minutes_link AS last_minutes_link_9, b0_.has_registration_form AS has_registration_form_10, b0_.seller AS seller_11, b0_.public_brand AS public_brand_12, l1_.id AS id_13, l1_.name AS name_14, l1_.name_it AS name_it_15, l1_.slug AS slug_16, l1_.active AS active_17, l1_.priority AS priority_18, l1_.alpha2 AS alpha2_19, p2_.id AS id_20, p2_.parameter_key AS parameter_key_21, p2_.def AS def_22, p2_.parameter_value AS parameter_value_23, p2_.parameter_write_granted AS parameter_write_granted_24, b0_.logo_id AS logo_id_25, b0_.language_id AS language_id_26, p2_.brand_id AS brand_id_27 FROM brand b0_ LEFT JOIN language l1_ ON b0_.language_id = l1_.id LEFT JOIN parameters p2_ ON b0_.id = p2_.brand_id WHERE b0_.domain = ?
Parameters: 
[
  "laroutedeslangues.com"
]
View formatted query    View runnable query    Explain query
0.32 ms
(0.07%) 		1 
SELECT COUNT(DISTINCT f0_.id) AS sclr_0 FROM file f0_ LEFT JOIN cart c1_ ON f0_.id = c1_.file_id LEFT JOIN file_participant f3_ ON f0_.id = f3_.file_id LEFT JOIN participant p2_ ON p2_.id = f3_.participant_id LEFT JOIN customer c4_ ON p2_.customer_id = c4_.id LEFT JOIN customer c5_ ON f0_.customer_id = c5_.id LEFT JOIN brand b6_ ON f0_.brand_id = b6_.id LEFT JOIN customer c7_ ON f0_.parent2_id = c7_.id INNER JOIN product p8_ ON f0_.product_id = p8_.id LEFT JOIN product_translation p9_ ON p8_.id = p9_.translatable_id LEFT JOIN productcategory p10_ ON p8_.new_main_category_id = p10_.id LEFT JOIN provider p11_ ON p8_.provider_id = p11_.id LEFT JOIN currency c12_ ON p11_.currency_id = c12_.id LEFT JOIN country c13_ ON p11_.country_id = c13_.id LEFT JOIN provider p14_ ON f0_.mandate_provider_id = p14_.id LEFT JOIN country c15_ ON p14_.country_id = c15_.id LEFT JOIN product_registration_procedure p16_ ON p8_.id = p16_.product_id LEFT JOIN invoice i17_ ON f0_.id = i17_.file_id LEFT JOIN crm c18_ ON f0_.id = c18_.file_id LEFT JOIN user u19_ ON f0_.followed_by_id = u19_.id LEFT JOIN file_payment f20_ ON f0_.id = f20_.file_id LEFT JOIN currency c21_ ON f20_.currency_id = c21_.id LEFT JOIN quotation q22_ ON f0_.id = q22_.file_id LEFT JOIN pricing_date_slot p23_ ON q22_.date_slot_id = p23_.id LEFT JOIN pricing_date_slot p24_ ON c1_.date_slot_id = p24_.id WHERE (p23_.travel_group_id IS NOT NULL OR p24_.travel_group_id IS NOT NULL) AND (f0_.validate_transport = 0 AND f0_.customer_do_not_want_grouped_travel = 0) AND (SELECT COUNT(*) FROM pnr_participant p25_ WHERE p25_.file_id = f0_.id) = 0 ORDER BY f0_.id DESC
Parameters: 
[]
View formatted query    View runnable query    Explain query
0.28 ms
(0.06%) 		1 
SELECT t0.id AS id_1, t0.parameter_value AS parameter_value_2, t0.locale AS locale_3, t0.translatable_id AS translatable_id_4 FROM parameters_translation t0 WHERE t0.translatable_id = ?
Parameters: 
[
  118
]
View formatted query    View runnable query    Explain query
0.26 ms
(0.06%) 		1 
SELECT COUNT(DISTINCT f0_.id) AS sclr_0 FROM file f0_ INNER JOIN file_payment f1_ ON f0_.id = f1_.file_id WHERE f0_.hubspot_id IS NULL AND f0_.status <> ?
Parameters: 
[
  "canceled"
]
View formatted query    View runnable query    Explain query
0.21 ms
(0.05%) 		1 
SELECT COUNT(p0_.id) AS sclr_0 FROM product_change_log p0_ WHERE p0_.viewed = ?
Parameters: 
[
  0
]
View formatted query    View runnable query    Explain query
0.20 ms
(0.05%) 		1 
SELECT COUNT(DISTINCT f0_.id) AS sclr_0 FROM file f0_ INNER JOIN file_hubspot_diff f1_ ON f0_.id = f1_.file_id
Parameters: 
[]
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\Brand No errors.
App\Entity\Language No errors.
App\Entity\Parameters No errors.
App\Entity\Media No errors.
App\Entity\Billing No errors.
App\Entity\Invoice No errors.
App\Entity\BrandCodeCompta No errors.
App\Entity\ProductCategoryRegistrationForm No errors.
App\Entity\LandingPage No errors.
App\Entity\Article No errors.
App\Entity\Brochure No errors.
App\Entity\Howknown No errors.
App\Entity\GeneralConditionOfSale No errors.
App\Entity\Faq No errors.
App\Entity\Webinar No errors.
App\Entity\DocumentHeaderFooterVersion No errors.
App\Entity\ProductProfile No errors.
App\Entity\CustomerEmailTemplate No errors.
App\Entity\DocumentVersion No errors.
App\Entity\Product No errors.
App\Entity\Test\Question No errors.
App\Entity\Test\Test No errors.
App\Entity\ParametersTranslation No errors.
App\Entity\User No errors.
App\Entity\Customer No errors.
App\Entity\Civility No errors.
App\Entity\FamilyStatus No errors.
App\Entity\Address No errors.
App\Entity\Job No errors.
App\Entity\Provider No errors.
App\Entity\Country No errors.
App\Entity\Currency No errors.
App\Entity\ProductCategory No errors.
App\Entity\UserSignature No errors.
App\Entity\Document No errors.
App\Entity\File No errors.
App\Entity\Correspondent No errors.
App\Entity\TransportRouting No errors.
App\Entity\ReturnUmContact No errors.
App\Entity\TransportAirport No errors.
App\Entity\TransportTrainStation No errors.
App\Entity\Contact No errors.
App\Entity\FileCancellationReasonTag No errors.
App\Entity\Participant No errors.
App\Entity\FileLog No errors.
App\Entity\FileAccommodation No errors.
App\Entity\FileSchool No errors.
App\Entity\FilePayment No errors.
App\Entity\FileTicket No errors.
App\Entity\Cart No errors.
App\Entity\Pricing No errors.
App\Entity\Pricings\Tariff No errors.
App\Entity\PricingDateSlot
  • The field App\Entity\PricingDateSlot#vacantSlots is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\PricingDateSlotVacant#pricingDateSlot does not contain the required 'inversedBy="vacantSlots"' attribute.
App\Entity\Pricings\Option No errors.
App\Entity\BillingLine No errors.
App\Entity\BillingLines\CartLine No errors.
App\Entity\Crm No errors.
App\Entity\Quotation No errors.
App\Entity\FileDocument No errors.
App\Entity\Group\PnrParticipant No errors.
App\Entity\Payment No errors.
App\Entity\FileInvoiceToBeIssued
  • The field 'App\Entity\FileInvoiceToBeIssued#amount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\FileRequiredDocument No errors.
App\Entity\FileBookingParent No errors.
App\Entity\FileAdditionalDocument No errors.
App\Entity\FileTimeline No errors.
App\Entity\ParticipantExtraData No errors.
App\Entity\ParticipantSchool No errors.
App\Entity\Classe No errors.
App\Entity\SchoolGrade No errors.
App\Entity\ParticipantSchoolEstablishment No errors.
App\Entity\LanguageLevel No errors.
App\Entity\Professor No errors.
App\Entity\FilePlanningStayEmailSend No errors.
App\Entity\FileIntermediateStatus No errors.
App\Entity\FileHubspotDiff No errors.
App\Entity\FileDocumentLog No errors.
App\Entity\FileMail No errors.
App\Entity\FilePaymentEvent No errors.
App\Entity\PlanningStayEmail No errors.
App\Entity\File\EmailRegistrationProcedureLog No errors.
App\Entity\ParticipantIdentityDocument No errors.
App\Entity\ProductRegistrationProcedure No errors.
App\Entity\ProductProviderUrl No errors.
App\Entity\City No errors.
App\Entity\AccommodationType No errors.
App\Entity\ProductPeriod No errors.
App\Entity\Option No errors.
App\Entity\Exam No errors.
App\Entity\Infrastructure No errors.
App\Entity\PricingLink No errors.
App\Entity\ProductTransferConstraint No errors.
App\Entity\MandateRate No errors.
App\Entity\ProductBrandAvailability No errors.
App\Entity\ProductServiceLink No errors.
App\Entity\ProductDocumentRequired No errors.
App\Entity\Witness No errors.
App\Entity\ProductPrice No errors.
App\Entity\ProductGeneralConditionOfSale No errors.
App\Entity\GlobalFeeProduct No errors.
App\Entity\ProductData No errors.
App\Entity\ProductIntermediateFileStatus No errors.
App\Entity\ProductDefaultOption No errors.
App\Entity\Pricings\MandateTariff No errors.
App\Entity\Certification No errors.
App\Entity\DocumentRequirement No errors.
App\Entity\ProductSlug No errors.
App\Entity\ProductTranslation No errors.
App\Entity\Mainland No errors.
App\Entity\Accommodation No errors.
App\Entity\School No errors.
App\Entity\ProviderFormula No errors.
App\Entity\Pricings\Fee No errors.
App\Entity\Pricings\Extra No errors.
App\Entity\PricingCategory No errors.
App\Entity\ProviderInvoicePayment No errors.
App\Entity\ProviderInvoice No errors.
App\Entity\Brand\ProviderConfig No errors.
App\Entity\TransportJourney No errors.
App\Entity\Group\Guide No errors.
App\Entity\CountryTranslation No errors.
App\Entity\Tags No errors.
App\Entity\CustomerChange No errors.
App\Entity\AmericanState No errors.
App\Entity\ParticipantHealth No errors.
App\Entity\TransportAirlineCompany No errors.
App\Entity\TransportRailwayCompany No errors.
App\Entity\BillingLines\InvoiceLine
  • The field 'App\Entity\BillingLines\InvoiceLine#totalPrice' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\InvoicePayment No errors.
App\Entity\InvoiceNumber No errors.
App\Entity\ProviderInvoiceAttribution No errors.
App\Entity\StatementMail No errors.
App\Entity\InvoiceNote No errors.
App\Entity\LandingFaq No errors.
App\Entity\Video No errors.
App\Entity\Persona No errors.
App\Entity\LandingPageMedia No errors.
App\Entity\LandingSection No errors.
App\Entity\ArticleProfile No errors.
App\Entity\ArticleCategory No errors.
App\Entity\ArticleTag No errors.
App\Entity\FaqCategory No errors.
App\Entity\FaqGroup No errors.
App\Entity\WebinarSpeaker No errors.
App\Entity\DocumentHeaderFooter No errors.
App\Entity\CustomerEmailTemplateVersion No errors.
App\Entity\Test\Answer No errors.
App\Entity\Group No errors.
App\Entity\Group\Penalty No errors.
App\Entity\GlobalFeeCategory No errors.
App\Entity\ProductCategoryAdvancePayment No errors.
App\Entity\Discount No errors.
App\Entity\ProductCategoryTranslation No errors.
App\Entity\DocumentRequired No errors.
App\Entity\DocumentRequiredFileName No errors.
App\Entity\DocumentTranslation No errors.
App\Entity\TransportSegment No errors.
App\Entity\Group\Pnr No errors.
App\Entity\TransportJourney\Flight No errors.
App\Entity\ParticipantEmergencyContact No errors.
App\Entity\ParticipantSibling No errors.
App\Entity\ParticipantPersonnalData No errors.
App\Entity\SchoolType No errors.
App\Entity\CrmPayment No errors.
App\Entity\PricingMethod No errors.
App\Entity\PricingDate No errors.
App\Entity\PricingPromotion No errors.
App\Entity\BillingLines\QuotationLine No errors.
App\Entity\PricingTranslation No errors.
App\Entity\PricingDateSlotVacant No errors.
App\Entity\BillingLines\CrmLine
  • The field 'App\Entity\BillingLines\CrmLine#totalPrice' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\QuotationNumber No errors.
App\Entity\DiscountCode No errors.
App\Entity\PaymentHistory No errors.
App\Entity\ProductDataRequired No errors.
App\Entity\ProductDataRequiredChoice No errors.
App\Entity\PlanningStayEmailDate No errors.
App\Entity\PlanningStayEmailStatus No errors.
App\Entity\CityTranslation No errors.
App\Entity\MandateRateItemConfig No errors.
App\Entity\ProductService No errors.
App\Entity\GlobalFee
  • The field 'App\Entity\GlobalFee#amount' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
App\Entity\Child No errors.
App\Entity\ProviderFormulaTranslation No errors.
App\Entity\ProviderInvoicePaymentAttribution No errors.
App\Entity\ProviderGroupedTransfer No errors.
App\Entity\ExportLine No errors.
App\Entity\Email\Log No errors.
App\Entity\Passion No errors.
App\Entity\Group\Cancellation No errors.
App\Entity\Activity No errors.
App\Entity\PersonalityTrait No errors.
App\Entity\PricingRate No errors.
App\Entity\MappingRouteItem No errors.
App\Entity\MandateRateItem No errors.
App\Entity\GlobalFeeTranslation No errors.
App\Entity\ProviderGroupedTransferAmount No errors.
App\Entity\Export No errors.
App\Entity\Group\Cancellation\Formula No errors.
App\Entity\MandateRateCategory No errors.
App\Entity\GenericExport No errors.
App\Entity\Group\Cancellation\FormulaStep No errors.
App\Entity\ProductChangeLog No errors.