Query Metrics
231
Database Queries
16
Different statements
170.49 ms
Query time
5
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
29.92 ms (17.55%) |
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
]
|
|
21.10 ms (12.37%) |
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" ] |
|
19.85 ms (11.64%) |
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
]
|
|
17.96 ms (10.53%) |
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
]
|
|
16.64 ms (9.76%) |
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
]
|
|
16.27 ms (9.54%) |
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
]
|
|
16.27 ms (9.54%) |
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
]
|
|
14.66 ms (8.60%) |
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
]
|
|
13.61 ms (7.99%) |
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
]
|
|
2.43 ms (1.42%) |
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" ] |
|
0.36 ms (0.21%) |
1 |
SELECT COUNT(e0_.id) AS sclr_0 FROM email_log e0_
Parameters:
[] |
|
0.35 ms (0.21%) |
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
]
|
|
0.32 ms (0.19%) |
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"
]
|
|
0.28 ms (0.16%) |
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
]
|
|
0.26 ms (0.15%) |
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"
]
|
|
0.20 ms (0.12%) |
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:
[] |
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.