Symfony Profiler

SELECT
  l0_.id AS id_0,
  l0_.value AS value_1,
  l0_.object_id AS object_id_2,
  l0_.created_at AS created_at_3,
  l0_.entity_id AS entity_id_4,
  l0_.user_id AS user_id_5,
  l0_.log_action_id AS log_action_id_6
FROM
  log_history l0_
WHERE
  l0_.entity_id = ?
  AND l0_.log_action_id = ?
  AND l0_.object_id = ?

SELECT l0_.id AS id_0, l0_.value AS value_1, l0_.object_id AS object_id_2, l0_.created_at AS created_at_3, l0_.entity_id AS entity_id_4, l0_.user_id AS user_id_5, l0_.log_action_id AS log_action_id_6 FROM log_history l0_ WHERE l0_.entity_id = 1 AND l0_.log_action_id = 1 AND l0_.object_id = 18772;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.label AS label_3,
  t0.form_options AS form_options_4,
  t0.is_extra_data AS is_extra_data_5,
  t0.is_object AS is_object_6,
  t0.helper AS helper_7,
  t0.step_id AS step_id_8,
  t0.parent_id AS parent_id_9,
  t0.step_field_form_type_id AS step_field_form_type_id_10
FROM
  step_field t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.form_options AS form_options_4, t0.is_extra_data AS is_extra_data_5, t0.is_object AS is_object_6, t0.helper AS helper_7, t0.step_id AS step_id_8, t0.parent_id AS parent_id_9, t0.step_field_form_type_id AS step_field_form_type_id_10 FROM step_field t0 WHERE t0.id = 236;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.required AS required_3,
  t0.is_active AS is_active_4,
  t0.step_field_id AS step_field_id_5,
  t0.survey_step_id AS survey_step_id_6
FROM
  survey_step_field t0
WHERE
  t0.survey_step_id = ?
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.position AS position_2, t0.required AS required_3, t0.is_active AS is_active_4, t0.step_field_id AS step_field_id_5, t0.survey_step_id AS survey_step_id_6 FROM survey_step_field t0 WHERE t0.survey_step_id = 51 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.entity AS entity_2,
  t0.revenue_type AS revenue_type_3,
  t0.address AS address_4,
  t0.street_number AS street_number_5,
  t0.street AS street_6,
  t0.city AS city_7,
  t0.zipcode AS zipcode_8,
  t0.country AS country_9,
  t0.revenue AS revenue_10,
  t0.date_add AS date_add_11,
  t0.date_update AS date_update_12,
  t0.person_id AS person_id_13
FROM
  user_file_person_revenue t0
WHERE
  t0.person_id = ?

SELECT t0.id AS id_1, t0.entity AS entity_2, t0.revenue_type AS revenue_type_3, t0.address AS address_4, t0.street_number AS street_number_5, t0.street AS street_6, t0.city AS city_7, t0.zipcode AS zipcode_8, t0.country AS country_9, t0.revenue AS revenue_10, t0.date_add AS date_add_11, t0.date_update AS date_update_12, t0.person_id AS person_id_13 FROM user_file_person_revenue t0 WHERE t0.person_id = 115938;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.entity AS entity_4,
  t0.is_collection AS is_collection_5
FROM
  step t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.entity AS entity_4, t0.is_collection AS is_collection_5 FROM step t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.lastname AS lastname_3,
  t0.email AS email_4,
  t0.recovery_password AS recovery_password_5,
  t0.password AS password_6,
  t0.auth_code AS auth_code_7,
  t0.roles AS roles_8,
  t0.civil_state AS civil_state_9,
  t0.has_children AS has_children_10,
  t0.nb_children AS nb_children_11,
  t0.is_owner AS is_owner_12,
  t0.nb_used_estates AS nb_used_estates_13,
  t0.is_used_estates AS is_used_estates_14,
  t0.nb_rented_estates AS nb_rented_estates_15,
  t0.is_rented_estates AS is_rented_estates_16,
  t0.has_renovations AS has_renovations_17,
  t0.is_active AS is_active_18,
  t0.recommandation AS recommandation_19,
  t0.bexio_contact_id AS bexio_contact_id_20,
  t0.ringover_contact_id AS ringover_contact_id_21,
  t0.drive_link AS drive_link_22,
  t0.bad_payer AS bad_payer_23,
  t0.date_add AS date_add_24,
  t0.civilite AS civilite_25,
  t0.is_active_two_fa AS is_active_two_fa_26,
  t0.is_created_on_coteries AS is_created_on_coteries_27,
  t0.source_user_file_id AS source_user_file_id_28,
  t29.id AS id_30,
  t29.phone_number AS phone_number_31,
  t29.user_id AS user_id_32,
  t0.advisor_id AS advisor_id_33
FROM
  user t0
  LEFT JOIN phone t29 ON t29.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.lastname AS lastname_3, t0.email AS email_4, t0.recovery_password AS recovery_password_5, t0.password AS password_6, t0.auth_code AS auth_code_7, t0.roles AS roles_8, t0.civil_state AS civil_state_9, t0.has_children AS has_children_10, t0.nb_children AS nb_children_11, t0.is_owner AS is_owner_12, t0.nb_used_estates AS nb_used_estates_13, t0.is_used_estates AS is_used_estates_14, t0.nb_rented_estates AS nb_rented_estates_15, t0.is_rented_estates AS is_rented_estates_16, t0.has_renovations AS has_renovations_17, t0.is_active AS is_active_18, t0.recommandation AS recommandation_19, t0.bexio_contact_id AS bexio_contact_id_20, t0.ringover_contact_id AS ringover_contact_id_21, t0.drive_link AS drive_link_22, t0.bad_payer AS bad_payer_23, t0.date_add AS date_add_24, t0.civilite AS civilite_25, t0.is_active_two_fa AS is_active_two_fa_26, t0.is_created_on_coteries AS is_created_on_coteries_27, t0.source_user_file_id AS source_user_file_id_28, t29.id AS id_30, t29.phone_number AS phone_number_31, t29.user_id AS user_id_32, t0.advisor_id AS advisor_id_33 FROM user t0 LEFT JOIN phone t29 ON t29.user_id = t0.id WHERE t0.id = 5080;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.badge_color AS badge_color_4,
  t0.graph_color AS graph_color_5,
  t0.is_todo AS is_todo_6
FROM
  user_survey_status t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.badge_color AS badge_color_4, t0.graph_color AS graph_color_5, t0.is_todo AS is_todo_6 FROM user_survey_status t0 WHERE t0.code = 'OFFER_PENDING' LIMIT 1;

SELECT
  t0_.id AS id_0,
  t0_.title AS title_1,
  t0_.code AS code_2
FROM
  tax_rectification_request t0_
WHERE
  t0_.code <> ?

SELECT t0_.id AS id_0, t0_.title AS title_1, t0_.code AS code_2 FROM tax_rectification_request t0_ WHERE t0_.code <> 'PIT_ONLINE_FR';

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.code AS code_3,
  t0.discount AS discount_4,
  t0.discount_type AS discount_type_5,
  t0.is_active AS is_active_6,
  t0.date_create AS date_create_7,
  t0.date_valid AS date_valid_8,
  t0.nb_times_used AS nb_times_used_9,
  t0.nb_counted AS nb_counted_10,
  t0.user_id AS user_id_11
FROM
  discount t0
  INNER JOIN order_discount ON t0.id = order_discount.discount_id
WHERE
  order_discount.order_id = ?

SELECT t0.id AS id_1, t0.type AS type_2, t0.code AS code_3, t0.discount AS discount_4, t0.discount_type AS discount_type_5, t0.is_active AS is_active_6, t0.date_create AS date_create_7, t0.date_valid AS date_valid_8, t0.nb_times_used AS nb_times_used_9, t0.nb_counted AS nb_counted_10, t0.user_id AS user_id_11 FROM discount t0 INNER JOIN order_discount ON t0.id = order_discount.discount_id WHERE order_discount.order_id = 13075;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3
FROM
  log_action t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3 FROM log_action t0 WHERE t0.code = 'STATUS_CHANGE' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.class_name AS class_name_3
FROM
  entities t0
WHERE
  t0.class_name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.class_name AS class_name_3 FROM entities t0 WHERE t0.class_name = 'UserSurvey' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.supplement AS supplement_2,
  t0.related_order_id AS related_order_id_3,
  t0.supplement_type_id AS supplement_type_id_4
FROM
  order_supplement t0
WHERE
  t0.related_order_id = ?

SELECT t0.id AS id_1, t0.supplement AS supplement_2, t0.related_order_id AS related_order_id_3, t0.supplement_type_id AS supplement_type_id_4 FROM order_supplement t0 WHERE t0.related_order_id = 13075;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.user_file_id AS user_file_id_3,
  t0.user_file_person_id AS user_file_person_id_4,
  t0.user_file_person_revenue_id AS user_file_person_revenue_id_5,
  t0.user_file_property_id AS user_file_property_id_6,
  t0.user_file_property_renovation_id AS user_file_property_renovation_id_7,
  t0.user_file_property_credit_id AS user_file_property_credit_id_8,
  t0.user_file_credit_id AS user_file_credit_id_9,
  t0.user_file_investment_id AS user_file_investment_id_10,
  t0.survey_step_field_id AS survey_step_field_id_11,
  t0.step_field_answer_id AS step_field_answer_id_12,
  t0.user_file_bank_account_id AS user_file_bank_account_id_13
FROM
  user_file_answer t0
WHERE
  t0.user_file_person_revenue_id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.user_file_id AS user_file_id_3, t0.user_file_person_id AS user_file_person_id_4, t0.user_file_person_revenue_id AS user_file_person_revenue_id_5, t0.user_file_property_id AS user_file_property_id_6, t0.user_file_property_renovation_id AS user_file_property_renovation_id_7, t0.user_file_property_credit_id AS user_file_property_credit_id_8, t0.user_file_credit_id AS user_file_credit_id_9, t0.user_file_investment_id AS user_file_investment_id_10, t0.survey_step_field_id AS survey_step_field_id_11, t0.step_field_answer_id AS step_field_answer_id_12, t0.user_file_bank_account_id AS user_file_bank_account_id_13 FROM user_file_answer t0 WHERE t0.user_file_person_revenue_id = 68191;

SELECT
  t0.id AS id_1,
  t0.iban AS iban_2,
  t0.civil_state AS civil_state_3,
  t0.residence AS residence_4,
  t0.swiss_residence_type AS swiss_residence_type_5,
  t0.has_children AS has_children_6,
  t0.is_owner AS is_owner_7,
  t0.has_investments AS has_investments_8,
  t0.has_credits AS has_credits_9,
  t0.has_capital_gain AS has_capital_gain_10,
  t0.capital_gain_amount AS capital_gain_amount_11,
  t0.capital_gain_amount_currency AS capital_gain_amount_currency_12,
  t0.date_add AS date_add_13,
  t0.date_update AS date_update_14,
  t0.is_active AS is_active_15,
  t0.is_cloned AS is_cloned_16,
  t0.is_original AS is_original_17,
  t0.original_user_file AS original_user_file_18,
  t0.comment AS comment_19,
  t0.has_appointment_taken AS has_appointment_taken_20,
  t0.appointment_comment AS appointment_comment_21,
  t0.user_id AS user_id_22,
  t23.id AS id_24,
  t23.firstname AS firstname_25,
  t23.lastname AS lastname_26,
  t23.email AS email_27,
  t23.nationality AS nationality_28,
  t23.profession AS profession_29,
  t23.iban AS iban_30,
  t23.birthday_date AS birthday_date_31,
  t23.has_same_address AS has_same_address_32,
  t23.address AS address_33,
  t23.street_number AS street_number_34,
  t23.street AS street_35,
  t23.city AS city_36,
  t23.zipcode AS zipcode_37,
  t23.country AS country_38,
  t23.has_previous_address AS has_previous_address_39,
  t23.previous_address AS previous_address_40,
  t23.previous_street_number AS previous_street_number_41,
  t23.previous_street AS previous_street_42,
  t23.previous_city AS previous_city_43,
  t23.previous_zipcode AS previous_zipcode_44,
  t23.previous_country AS previous_country_45,
  t23.has_rht AS has_rht_46,
  t23.rht_duration AS rht_duration_47,
  t23.has_covid AS has_covid_48,
  t23.has_covid_covered AS has_covid_covered_49,
  t23.covid_cover_duration AS covid_cover_duration_50,
  t23.has_work_at_home AS has_work_at_home_51,
  t23.work_at_home_duration AS work_at_home_duration_52,
  t23.health_care AS health_care_53,
  t23.health_care_amount AS health_care_amount_54,
  t23.health_care_amount_currency AS health_care_amount_currency_55,
  t23.has_complementary_health AS has_complementary_health_56,
  t23.complementary_health_amount AS complementary_health_amount_57,
  t23.complementary_health_amount_currency AS complementary_health_amount_currency_58,
  t23.has_uncovered_medical_care AS has_uncovered_medical_care_59,
  t23.uncovered_medical_careh_amount AS uncovered_medical_careh_amount_60,
  t23.uncovered_medical_careh_amount_currency AS uncovered_medical_careh_amount_currency_61,
  t23.has_swiss_donation AS has_swiss_donation_62,
  t23.swiss_donation_amount AS swiss_donation_amount_63,
  t23.swiss_donation_amount_currency AS swiss_donation_amount_currency_64,
  t23.disability_care AS disability_care_65,
  t23.disability_care_amount AS disability_care_amount_66,
  t23.disability_care_amount_currency AS disability_care_amount_currency_67,
  t23.has_swiss_politic_donation AS has_swiss_politic_donation_68,
  t23.swiss_politic_donation_amount AS swiss_politic_donation_amount_69,
  t23.swiss_politic_donation_amount_currency AS swiss_politic_donation_amount_currency_70,
  t23.relation_type AS relation_type_71,
  t23.relation_current_year AS relation_current_year_72,
  t23.relation_date AS relation_date_73,
  t23.has_alimony AS has_alimony_74,
  t23.is_student AS is_student_75,
  t23.study_duration AS study_duration_76,
  t23.has_revenue AS has_revenue_77,
  t23.revenue_range AS revenue_range_78,
  t23.alimony_way AS alimony_way_79,
  t23.alimony_amount AS alimony_amount_80,
  t23.alimony_amount_currency AS alimony_amount_currency_81,
  t23.nursering_amount AS nursering_amount_82,
  t23.nursering_amount_currency AS nursering_amount_currency_83,
  t23.comment AS comment_84,
  t23.date_add AS date_add_85,
  t23.date_update AS date_update_86,
  t23.has_care_expenses AS has_care_expenses_87,
  t23.has_valid_finance_credentials AS has_valid_finance_credentials_88,
  t23.has_valid_urssaf_credentials AS has_valid_urssaf_credentials_89,
  t23.has_valid_partner_urssaf_credentials AS has_valid_partner_urssaf_credentials_90,
  t23.civilite AS civilite_91,
  t23.owner_id AS owner_id_92,
  t23.partner_id AS partner_id_93,
  t23.child_id AS child_id_94,
  t23.parent_id AS parent_id_95,
  t23.phone_object_id AS phone_object_id_96
FROM
  user_file t0
  LEFT JOIN user_file_person t23 ON t23.owner_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.iban AS iban_2, t0.civil_state AS civil_state_3, t0.residence AS residence_4, t0.swiss_residence_type AS swiss_residence_type_5, t0.has_children AS has_children_6, t0.is_owner AS is_owner_7, t0.has_investments AS has_investments_8, t0.has_credits AS has_credits_9, t0.has_capital_gain AS has_capital_gain_10, t0.capital_gain_amount AS capital_gain_amount_11, t0.capital_gain_amount_currency AS capital_gain_amount_currency_12, t0.date_add AS date_add_13, t0.date_update AS date_update_14, t0.is_active AS is_active_15, t0.is_cloned AS is_cloned_16, t0.is_original AS is_original_17, t0.original_user_file AS original_user_file_18, t0.comment AS comment_19, t0.has_appointment_taken AS has_appointment_taken_20, t0.appointment_comment AS appointment_comment_21, t0.user_id AS user_id_22, t23.id AS id_24, t23.firstname AS firstname_25, t23.lastname AS lastname_26, t23.email AS email_27, t23.nationality AS nationality_28, t23.profession AS profession_29, t23.iban AS iban_30, t23.birthday_date AS birthday_date_31, t23.has_same_address AS has_same_address_32, t23.address AS address_33, t23.street_number AS street_number_34, t23.street AS street_35, t23.city AS city_36, t23.zipcode AS zipcode_37, t23.country AS country_38, t23.has_previous_address AS has_previous_address_39, t23.previous_address AS previous_address_40, t23.previous_street_number AS previous_street_number_41, t23.previous_street AS previous_street_42, t23.previous_city AS previous_city_43, t23.previous_zipcode AS previous_zipcode_44, t23.previous_country AS previous_country_45, t23.has_rht AS has_rht_46, t23.rht_duration AS rht_duration_47, t23.has_covid AS has_covid_48, t23.has_covid_covered AS has_covid_covered_49, t23.covid_cover_duration AS covid_cover_duration_50, t23.has_work_at_home AS has_work_at_home_51, t23.work_at_home_duration AS work_at_home_duration_52, t23.health_care AS health_care_53, t23.health_care_amount AS health_care_amount_54, t23.health_care_amount_currency AS health_care_amount_currency_55, t23.has_complementary_health AS has_complementary_health_56, t23.complementary_health_amount AS complementary_health_amount_57, t23.complementary_health_amount_currency AS complementary_health_amount_currency_58, t23.has_uncovered_medical_care AS has_uncovered_medical_care_59, t23.uncovered_medical_careh_amount AS uncovered_medical_careh_amount_60, t23.uncovered_medical_careh_amount_currency AS uncovered_medical_careh_amount_currency_61, t23.has_swiss_donation AS has_swiss_donation_62, t23.swiss_donation_amount AS swiss_donation_amount_63, t23.swiss_donation_amount_currency AS swiss_donation_amount_currency_64, t23.disability_care AS disability_care_65, t23.disability_care_amount AS disability_care_amount_66, t23.disability_care_amount_currency AS disability_care_amount_currency_67, t23.has_swiss_politic_donation AS has_swiss_politic_donation_68, t23.swiss_politic_donation_amount AS swiss_politic_donation_amount_69, t23.swiss_politic_donation_amount_currency AS swiss_politic_donation_amount_currency_70, t23.relation_type AS relation_type_71, t23.relation_current_year AS relation_current_year_72, t23.relation_date AS relation_date_73, t23.has_alimony AS has_alimony_74, t23.is_student AS is_student_75, t23.study_duration AS study_duration_76, t23.has_revenue AS has_revenue_77, t23.revenue_range AS revenue_range_78, t23.alimony_way AS alimony_way_79, t23.alimony_amount AS alimony_amount_80, t23.alimony_amount_currency AS alimony_amount_currency_81, t23.nursering_amount AS nursering_amount_82, t23.nursering_amount_currency AS nursering_amount_currency_83, t23.comment AS comment_84, t23.date_add AS date_add_85, t23.date_update AS date_update_86, t23.has_care_expenses AS has_care_expenses_87, t23.has_valid_finance_credentials AS has_valid_finance_credentials_88, t23.has_valid_urssaf_credentials AS has_valid_urssaf_credentials_89, t23.has_valid_partner_urssaf_credentials AS has_valid_partner_urssaf_credentials_90, t23.civilite AS civilite_91, t23.owner_id AS owner_id_92, t23.partner_id AS partner_id_93, t23.child_id AS child_id_94, t23.parent_id AS parent_id_95, t23.phone_object_id AS phone_object_id_96 FROM user_file t0 LEFT JOIN user_file_person t23 ON t23.owner_id = t0.id WHERE t0.id = 58572;

SELECT
  t0.id AS id_1,
  t0.date_add AS date_add_2,
  t0.date_update AS date_update_3,
  t0.type AS type_4,
  t0.person AS person_5,
  t0.entity_name AS entity_name_6,
  t0.unique_identifier AS unique_identifier_7,
  t0.open_date AS open_date_8,
  t0.close_date AS close_date_9,
  t0.address AS address_10,
  t0.street_number AS street_number_11,
  t0.street AS street_12,
  t0.zipcode AS zipcode_13,
  t0.city AS city_14,
  t0.country AS country_15,
  t0.user_file_id AS user_file_id_16
FROM
  user_file_bank_account t0
WHERE
  t0.user_file_id = ?

SELECT t0.id AS id_1, t0.date_add AS date_add_2, t0.date_update AS date_update_3, t0.type AS type_4, t0.person AS person_5, t0.entity_name AS entity_name_6, t0.unique_identifier AS unique_identifier_7, t0.open_date AS open_date_8, t0.close_date AS close_date_9, t0.address AS address_10, t0.street_number AS street_number_11, t0.street AS street_12, t0.zipcode AS zipcode_13, t0.city AS city_14, t0.country AS country_15, t0.user_file_id AS user_file_id_16 FROM user_file_bank_account t0 WHERE t0.user_file_id = 58572;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.display_order AS display_order_4,
  t0.validation_group AS validation_group_5,
  t0.survey_id AS survey_id_6,
  t0.step_id AS step_id_7,
  t0.survey_mode_id AS survey_mode_id_8
FROM
  survey_step t0
WHERE
  t0.survey_id = ?
ORDER BY
  t0.display_order ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.display_order AS display_order_4, t0.validation_group AS validation_group_5, t0.survey_id AS survey_id_6, t0.step_id AS step_id_7, t0.survey_mode_id AS survey_mode_id_8 FROM survey_step t0 WHERE t0.survey_id = 4 ORDER BY t0.display_order ASC;

SELECT
  t0.id AS id_1,
  t0.survey_mode AS survey_mode_2,
  t0.date_add AS date_add_3,
  t0.date_update AS date_update_4,
  t0.status_date_update AS status_date_update_5,
  t0.date_finish AS date_finish_6,
  t0.date_afc AS date_afc_7,
  t0.date_limit AS date_limit_8,
  t0.has_afcrequested AS has_afcrequested_9,
  t0.order_reference AS order_reference_10,
  t0.step AS step_11,
  t0.covered_step AS covered_step_12,
  t0.price AS price_13,
  t0.payment_status AS payment_status_14,
  t0.result_code AS result_code_15,
  t0.result_comment AS result_comment_16,
  t0.result_is AS result_is_17,
  t0.result_qr AS result_qr_18,
  t0.result_rs AS result_rs_19,
  t0.result_afc AS result_afc_20,
  t0.result_afccomment AS result_afccomment_21,
  t0.result_presta AS result_presta_22,
  t0.result_presta_comment AS result_presta_comment_23,
  t0.missing_files AS missing_files_24,
  t0.is_clone AS is_clone_25,
  t0.is_edited AS is_edited_26,
  t0.is_third_party AS is_third_party_27,
  t0.is_archived AS is_archived_28,
  t0.display_doc_notif AS display_doc_notif_29,
  t0.internal_alert_date AS internal_alert_date_30,
  t0.no_afcresult AS no_afcresult_31,
  t0.cmu_result_n AS cmu_result_n_32,
  t0.cmu_result_n1 AS cmu_result_n1_33,
  t0.cmu_result_n2 AS cmu_result_n2_34,
  t0.cmu_result_n3 AS cmu_result_n3_35,
  t0.cmu_result_type AS cmu_result_type_36,
  t0.user_id AS user_id_37,
  t0.survey_id AS survey_id_38,
  t39.id AS id_40,
  t39.reference AS reference_41,
  t39.amount AS amount_42,
  t39.amount_no_discount AS amount_no_discount_43,
  t39.currency AS currency_44,
  t39.payment_mode AS payment_mode_45,
  t39.payment_provider AS payment_provider_46,
  t39.payment_status AS payment_status_47,
  t39.state AS state_48,
  t39.is_legal_notice_validated AS is_legal_notice_validated_49,
  t39.date_add AS date_add_50,
  t39.date_update AS date_update_51,
  t39.date_legal_notice_validated AS date_legal_notice_validated_52,
  t39.date_payment AS date_payment_53,
  t39.date_cancel AS date_cancel_54,
  t39.is_completed_once AS is_completed_once_55,
  t39.discount_amount AS discount_amount_56,
  t39.bexio_invoice_id AS bexio_invoice_id_57,
  t39.affiliation_count AS affiliation_count_58,
  t39.bexio_is_paid AS bexio_is_paid_59,
  t39.payment_id AS payment_id_60,
  t39.user_survey_id AS user_survey_id_61,
  t0.admin_status_id AS admin_status_id_62,
  t0.parent_id AS parent_id_63,
  t0.user_file_id AS user_file_id_64,
  t0.tax_rectification_request_id AS tax_rectification_request_id_65,
  t0.user_survey_status_id AS user_survey_status_id_66,
  t0.survey_product_id AS survey_product_id_67,
  t0.survey_step_id AS survey_step_id_68,
  t0.survey_mode_object_id AS survey_mode_object_id_69,
  t0.result_survey_id AS result_survey_id_70,
  t0.creator_id AS creator_id_71
FROM
  user_survey t0
  LEFT JOIN `order` t39 ON t39.user_survey_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.survey_mode AS survey_mode_2, t0.date_add AS date_add_3, t0.date_update AS date_update_4, t0.status_date_update AS status_date_update_5, t0.date_finish AS date_finish_6, t0.date_afc AS date_afc_7, t0.date_limit AS date_limit_8, t0.has_afcrequested AS has_afcrequested_9, t0.order_reference AS order_reference_10, t0.step AS step_11, t0.covered_step AS covered_step_12, t0.price AS price_13, t0.payment_status AS payment_status_14, t0.result_code AS result_code_15, t0.result_comment AS result_comment_16, t0.result_is AS result_is_17, t0.result_qr AS result_qr_18, t0.result_rs AS result_rs_19, t0.result_afc AS result_afc_20, t0.result_afccomment AS result_afccomment_21, t0.result_presta AS result_presta_22, t0.result_presta_comment AS result_presta_comment_23, t0.missing_files AS missing_files_24, t0.is_clone AS is_clone_25, t0.is_edited AS is_edited_26, t0.is_third_party AS is_third_party_27, t0.is_archived AS is_archived_28, t0.display_doc_notif AS display_doc_notif_29, t0.internal_alert_date AS internal_alert_date_30, t0.no_afcresult AS no_afcresult_31, t0.cmu_result_n AS cmu_result_n_32, t0.cmu_result_n1 AS cmu_result_n1_33, t0.cmu_result_n2 AS cmu_result_n2_34, t0.cmu_result_n3 AS cmu_result_n3_35, t0.cmu_result_type AS cmu_result_type_36, t0.user_id AS user_id_37, t0.survey_id AS survey_id_38, t39.id AS id_40, t39.reference AS reference_41, t39.amount AS amount_42, t39.amount_no_discount AS amount_no_discount_43, t39.currency AS currency_44, t39.payment_mode AS payment_mode_45, t39.payment_provider AS payment_provider_46, t39.payment_status AS payment_status_47, t39.state AS state_48, t39.is_legal_notice_validated AS is_legal_notice_validated_49, t39.date_add AS date_add_50, t39.date_update AS date_update_51, t39.date_legal_notice_validated AS date_legal_notice_validated_52, t39.date_payment AS date_payment_53, t39.date_cancel AS date_cancel_54, t39.is_completed_once AS is_completed_once_55, t39.discount_amount AS discount_amount_56, t39.bexio_invoice_id AS bexio_invoice_id_57, t39.affiliation_count AS affiliation_count_58, t39.bexio_is_paid AS bexio_is_paid_59, t39.payment_id AS payment_id_60, t39.user_survey_id AS user_survey_id_61, t0.admin_status_id AS admin_status_id_62, t0.parent_id AS parent_id_63, t0.user_file_id AS user_file_id_64, t0.tax_rectification_request_id AS tax_rectification_request_id_65, t0.user_survey_status_id AS user_survey_status_id_66, t0.survey_product_id AS survey_product_id_67, t0.survey_step_id AS survey_step_id_68, t0.survey_mode_object_id AS survey_mode_object_id_69, t0.result_survey_id AS result_survey_id_70, t0.creator_id AS creator_id_71 FROM user_survey t0 LEFT JOIN `order` t39 ON t39.user_survey_id = t0.id WHERE t0.id = '18772';

SELECT
  t0.id AS id_1,
  t0.year AS year_2,
  t0.rate AS rate_3,
  t0.specific_rate AS specific_rate_4,
  t0.currency_from_id AS currency_from_id_5,
  t0.currency_to_id AS currency_to_id_6
FROM
  `change` t0
WHERE
  t0.year = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.year AS year_2, t0.rate AS rate_3, t0.specific_rate AS specific_rate_4, t0.currency_from_id AS currency_from_id_5, t0.currency_to_id AS currency_to_id_6 FROM `change` t0 WHERE t0.year = 2025 LIMIT 1;

SELECT
  t1.id AS id_2,
  t1.user_file_id AS user_file_id_3,
  t0.user_file_person_id AS user_file_person_id_4,
  t0.user_file_person_revenue_id AS user_file_person_revenue_id_5,
  t0.user_file_property_id AS user_file_property_id_6,
  t0.user_file_property_credit_id AS user_file_property_credit_id_7,
  t0.user_file_investment_id AS user_file_investment_id_8,
  t0.user_file_credit_id AS user_file_credit_id_9,
  t1.discr
FROM
  entity_type_tag t0
  INNER JOIN tag t1 ON t0.id = t1.id
WHERE
  t0.user_file_person_id = ?

SELECT t1.id AS id_2, t1.user_file_id AS user_file_id_3, t0.user_file_person_id AS user_file_person_id_4, t0.user_file_person_revenue_id AS user_file_person_revenue_id_5, t0.user_file_property_id AS user_file_property_id_6, t0.user_file_property_credit_id AS user_file_property_credit_id_7, t0.user_file_investment_id AS user_file_investment_id_8, t0.user_file_credit_id AS user_file_credit_id_9, t1.discr FROM entity_type_tag t0 INNER JOIN tag t1 ON t0.id = t1.id WHERE t0.user_file_person_id = 115938;

SELECT
  t0.id AS id_1,
  t0.mc AS mc_2,
  t0.summable AS summable_3,
  t0.name AS name_4,
  t0.default_value AS default_value_5,
  t0.regroup_information_id AS regroup_information_id_6
FROM
  getax_mc t0

SELECT t0.id AS id_1, t0.mc AS mc_2, t0.summable AS summable_3, t0.name AS name_4, t0.default_value AS default_value_5, t0.regroup_information_id AS regroup_information_id_6 FROM getax_mc t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.code AS code_3,
  t0.badge_color AS badge_color_4,
  t0.graph_color AS graph_color_5,
  t0.is_todo AS is_todo_6
FROM
  user_survey_status t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.badge_color AS badge_color_4, t0.graph_color AS graph_color_5, t0.is_todo AS is_todo_6 FROM user_survey_status t0 WHERE t0.id = 14;

SELECT
  t0.id AS id_1,
  t0.sender AS sender_2,
  t0.sender_alias AS sender_alias_3,
  t0.addressee AS addressee_4,
  t0.subject AS subject_5,
  t0.template AS template_6,
  t0.template_params AS template_params_7,
  t0.attachments AS attachments_8,
  t0.send_at AS send_at_9,
  t0.sent_at AS sent_at_10,
  t0.canceled AS canceled_11,
  t0.type AS type_12,
  t0.error AS error_13,
  t0.user_id AS user_id_14,
  t0.user_survey_id AS user_survey_id_15
FROM
  email t0
WHERE
  t0.user_survey_id = ?

SELECT t0.id AS id_1, t0.sender AS sender_2, t0.sender_alias AS sender_alias_3, t0.addressee AS addressee_4, t0.subject AS subject_5, t0.template AS template_6, t0.template_params AS template_params_7, t0.attachments AS attachments_8, t0.send_at AS send_at_9, t0.sent_at AS sent_at_10, t0.canceled AS canceled_11, t0.type AS type_12, t0.error AS error_13, t0.user_id AS user_id_14, t0.user_survey_id AS user_survey_id_15 FROM email t0 WHERE t0.user_survey_id = 18772;