Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.email AS email_3,
  t0.first_name AS first_name_4,
  t0.last_name AS last_name_5,
  t0.phone AS phone_6,
  t0.type AS type_7,
  t0.last_login AS last_login_8,
  t0.failed_login_attempts AS failed_login_attempts_9,
  t0.enabled AS enabled_10,
  t0.locked AS locked_11,
  t0.roles AS roles_12,
  t0.password AS password_13,
  t0.state AS state_14,
  t0.created AS created_15,
  t0.updated AS updated_16,
  t0.picture_id AS picture_id_17,
  t0.userfunction_id AS userfunction_id_18,
  t0.timezone_id AS timezone_id_19,
  t0.locale_id AS locale_id_20,
  t0.employee_id AS employee_id_21,
  t0.organization_id AS organization_id_22,
  t0.created_by AS created_by_23,
  t0.updated_by AS updated_by_24
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.email AS email_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.phone AS phone_6, t0.type AS type_7, t0.last_login AS last_login_8, t0.failed_login_attempts AS failed_login_attempts_9, t0.enabled AS enabled_10, t0.locked AS locked_11, t0.roles AS roles_12, t0.password AS password_13, t0.state AS state_14, t0.created AS created_15, t0.updated AS updated_16, t0.picture_id AS picture_id_17, t0.userfunction_id AS userfunction_id_18, t0.timezone_id AS timezone_id_19, t0.locale_id AS locale_id_20, t0.employee_id AS employee_id_21, t0.organization_id AS organization_id_22, t0.created_by AS created_by_23, t0.updated_by AS updated_by_24 FROM user t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.entity AS entity_2,
  t0.action AS action_3,
  t0.path AS path_4,
  t0.logging AS logging_5,
  t0.found_during_last_run AS found_during_last_run_6,
  t0.execution_action AS execution_action_7,
  t0.state AS state_8,
  t0.created AS created_9,
  t0.updated AS updated_10,
  t0.created_by AS created_by_11,
  t0.updated_by AS updated_by_12
FROM
  security_action t0
WHERE
  t0.entity = ?
  AND t0.action = ?
  AND t0.state = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.entity AS entity_2, t0.action AS action_3, t0.path AS path_4, t0.logging AS logging_5, t0.found_during_last_run AS found_during_last_run_6, t0.execution_action AS execution_action_7, t0.state AS state_8, t0.created AS created_9, t0.updated AS updated_10, t0.created_by AS created_by_11, t0.updated_by AS updated_by_12 FROM security_action t0 WHERE t0.entity = 'Proposal' AND t0.action = 'tabledetails' AND t0.state = 0 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO user_log (
  entity, action, element, state, created,
  updated, authorizationtype_id, created_by,
  updated_by, organization_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO user_log (entity, action, element, state, created, updated, authorizationtype_id, created_by, updated_by, organization_id) VALUES ('Proposal', 'tabledetails', NULL, 0, '2026-09-21 20:27:45', '2026-09-21 20:27:45', NULL, 5, 5, 1);

UPDATE
  security_action
SET
  execution_action = ?,
  updated = ?,
  updated_by = ?
WHERE
  id = ?

UPDATE security_action SET execution_action = 2956, updated = '2026-09-21 20:27:45', updated_by = 5 WHERE id = 459;

"COMMIT"

"COMMIT";

SELECT
  p0_.id AS id_0,
  p0_.externalid AS externalid_1,
  p0_.subject AS subject_2,
  p0_.state AS state_3,
  p0_.contact_person AS contact_person_4,
  p0_.proposed_on AS proposed_on_5,
  p0_.comment AS comment_6,
  p0_.open AS open_7,
  p0_.interview AS interview_8,
  p0_.interview_date AS interview_date_9,
  p0_.interview_comment AS interview_comment_10,
  p0_.created AS created_11,
  p0_.updated AS updated_12,
  p0_.lead_id AS lead_id_13,
  p0_.type_id AS type_id_14,
  p0_.client_id AS client_id_15,
  p0_.end_client_id AS end_client_id_16,
  p0_.owner_id AS owner_id_17,
  p0_.organization_id AS organization_id_18,
  p0_.created_by AS created_by_19,
  p0_.updated_by AS updated_by_20
FROM
  proposal p0_
  LEFT JOIN client c1_ ON p0_.client_id = c1_.id
  LEFT JOIN client c2_ ON p0_.end_client_id = c2_.id
  LEFT JOIN proposal_element p3_ ON p0_.id = p3_.proposal_id
  LEFT JOIN employee e4_ ON p3_.employee_id = e4_.id
WHERE
  (
    (p0_.state = ?)
    AND (p0_.open = ?)
    AND (p0_.owner_id = ?)
    AND (
      (? = 0)
      OR (
        (p0_.organization_id = ?)
        OR (p0_.organization_id IS NULL)
      )
    )
  )
ORDER BY
  p0_.id DESC

SELECT p0_.id AS id_0, p0_.externalid AS externalid_1, p0_.subject AS subject_2, p0_.state AS state_3, p0_.contact_person AS contact_person_4, p0_.proposed_on AS proposed_on_5, p0_.comment AS comment_6, p0_.open AS open_7, p0_.interview AS interview_8, p0_.interview_date AS interview_date_9, p0_.interview_comment AS interview_comment_10, p0_.created AS created_11, p0_.updated AS updated_12, p0_.lead_id AS lead_id_13, p0_.type_id AS type_id_14, p0_.client_id AS client_id_15, p0_.end_client_id AS end_client_id_16, p0_.owner_id AS owner_id_17, p0_.organization_id AS organization_id_18, p0_.created_by AS created_by_19, p0_.updated_by AS updated_by_20 FROM proposal p0_ LEFT JOIN client c1_ ON p0_.client_id = c1_.id LEFT JOIN client c2_ ON p0_.end_client_id = c2_.id LEFT JOIN proposal_element p3_ ON p0_.id = p3_.proposal_id LEFT JOIN employee e4_ ON p3_.employee_id = e4_.id WHERE ((p0_.state = 0) AND (p0_.open = 1) AND (p0_.owner_id = 4) AND ((1 = 0) OR ((p0_.organization_id = 1) OR (p0_.organization_id IS NULL)))) ORDER BY p0_.id DESC;

SELECT
  p0_.id AS id_0,
  p0_.externalid AS externalid_1,
  p0_.subject AS subject_2,
  p0_.state AS state_3,
  p0_.contact_person AS contact_person_4,
  p0_.proposed_on AS proposed_on_5,
  p0_.comment AS comment_6,
  p0_.open AS open_7,
  p0_.interview AS interview_8,
  p0_.interview_date AS interview_date_9,
  p0_.interview_comment AS interview_comment_10,
  p0_.created AS created_11,
  p0_.updated AS updated_12,
  p0_.lead_id AS lead_id_13,
  p0_.type_id AS type_id_14,
  p0_.client_id AS client_id_15,
  p0_.end_client_id AS end_client_id_16,
  p0_.owner_id AS owner_id_17,
  p0_.organization_id AS organization_id_18,
  p0_.created_by AS created_by_19,
  p0_.updated_by AS updated_by_20
FROM
  proposal p0_
  LEFT JOIN client c1_ ON p0_.client_id = c1_.id
  LEFT JOIN client c2_ ON p0_.end_client_id = c2_.id
  LEFT JOIN proposal_element p3_ ON p0_.id = p3_.proposal_id
  LEFT JOIN employee e4_ ON p3_.employee_id = e4_.id
WHERE
  (
    (p0_.state = ?)
    AND (p0_.open = ?)
    AND (p0_.owner_id = ?)
    AND (
      (? = 0)
      OR (
        (p0_.organization_id = ?)
        OR (p0_.organization_id IS NULL)
      )
    )
  )
ORDER BY
  p0_.id DESC
LIMIT
  100

SELECT p0_.id AS id_0, p0_.externalid AS externalid_1, p0_.subject AS subject_2, p0_.state AS state_3, p0_.contact_person AS contact_person_4, p0_.proposed_on AS proposed_on_5, p0_.comment AS comment_6, p0_.open AS open_7, p0_.interview AS interview_8, p0_.interview_date AS interview_date_9, p0_.interview_comment AS interview_comment_10, p0_.created AS created_11, p0_.updated AS updated_12, p0_.lead_id AS lead_id_13, p0_.type_id AS type_id_14, p0_.client_id AS client_id_15, p0_.end_client_id AS end_client_id_16, p0_.owner_id AS owner_id_17, p0_.organization_id AS organization_id_18, p0_.created_by AS created_by_19, p0_.updated_by AS updated_by_20 FROM proposal p0_ LEFT JOIN client c1_ ON p0_.client_id = c1_.id LEFT JOIN client c2_ ON p0_.end_client_id = c2_.id LEFT JOIN proposal_element p3_ ON p0_.id = p3_.proposal_id LEFT JOIN employee e4_ ON p3_.employee_id = e4_.id WHERE ((p0_.state = 0) AND (p0_.open = 1) AND (p0_.owner_id = 4) AND ((1 = 0) OR ((p0_.organization_id = 1) OR (p0_.organization_id IS NULL)))) ORDER BY p0_.id DESC LIMIT 100;

SELECT
  t0.id AS id_1,
  t0.unit_price AS unit_price_2,
  t0.intake_price AS intake_price_3,
  t0.quantity AS quantity_4,
  t0.state AS state_5,
  t0.created AS created_6,
  t0.updated AS updated_7,
  t0.proposal_id AS proposal_id_8,
  t0.employee_id AS employee_id_9,
  t0.product_id AS product_id_10,
  t0.frequency_id AS frequency_id_11,
  t0.created_by AS created_by_12,
  t0.updated_by AS updated_by_13
FROM
  proposal_element t0
WHERE
  t0.proposal_id = ?

SELECT t0.id AS id_1, t0.unit_price AS unit_price_2, t0.intake_price AS intake_price_3, t0.quantity AS quantity_4, t0.state AS state_5, t0.created AS created_6, t0.updated AS updated_7, t0.proposal_id AS proposal_id_8, t0.employee_id AS employee_id_9, t0.product_id AS product_id_10, t0.frequency_id AS frequency_id_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13 FROM proposal_element t0 WHERE t0.proposal_id = 569;

SELECT
  t0.id AS id_1,
  t0.lastname AS lastname_2,
  t0.firstname AS firstname_3,
  t0.external_id AS external_id_4,
  t0.rate AS rate_5,
  t0.available_on AS available_on_6,
  t0.years_experience AS years_experience_7,
  t0.street AS street_8,
  t0.housenumber AS housenumber_9,
  t0.postcode AS postcode_10,
  t0.municipality AS municipality_11,
  t0.sub_municipality AS sub_municipality_12,
  t0.country AS country_13,
  t0.phone AS phone_14,
  t0.phone2 AS phone2_15,
  t0.email AS email_16,
  t0.no_email_until AS no_email_until_17,
  t0.excludefrommailings AS excludefrommailings_18,
  t0.allow_to_process_information_gdpr AS allow_to_process_information_gdpr_19,
  t0.black_list AS black_list_20,
  t0.hot_profile AS hot_profile_21,
  t0.birthday AS birthday_22,
  t0.certifications AS certifications_23,
  t0.description AS description_24,
  t0.yearly_legal_holliday AS yearly_legal_holliday_25,
  t0.yearly_adv AS yearly_adv_26,
  t0.weekly_work_hours AS weekly_work_hours_27,
  t0.work_monday_forenoon AS work_monday_forenoon_28,
  t0.work_monday_afternoon AS work_monday_afternoon_29,
  t0.work_tuesday_forenoon AS work_tuesday_forenoon_30,
  t0.work_tuesday_afternoon AS work_tuesday_afternoon_31,
  t0.work_wednesday_forenoon AS work_wednesday_forenoon_32,
  t0.work_wednesday_afternoon AS work_wednesday_afternoon_33,
  t0.work_thursday_forenoon AS work_thursday_forenoon_34,
  t0.work_thursday_afternoon AS work_thursday_afternoon_35,
  t0.work_friday_forenoon AS work_friday_forenoon_36,
  t0.work_friday_afternoon AS work_friday_afternoon_37,
  t0.work_saturday_forenoon AS work_saturday_forenoon_38,
  t0.work_saturday_afternoon AS work_saturday_afternoon_39,
  t0.work_sunday_forenoon AS work_sunday_forenoon_40,
  t0.work_sunday_afternoon AS work_sunday_afternoon_41,
  t0.start_date AS start_date_42,
  t0.end_date AS end_date_43,
  t0.iban AS iban_44,
  t0.bic AS bic_45,
  t0.state_registration_number AS state_registration_number_46,
  t0.state AS state_47,
  t0.created AS created_48,
  t0.updated AS updated_49,
  t0.image_id AS image_id_50,
  t51.id AS id_52,
  t51.uuid AS uuid_53,
  t51.email AS email_54,
  t51.first_name AS first_name_55,
  t51.last_name AS last_name_56,
  t51.phone AS phone_57,
  t51.type AS type_58,
  t51.last_login AS last_login_59,
  t51.failed_login_attempts AS failed_login_attempts_60,
  t51.enabled AS enabled_61,
  t51.locked AS locked_62,
  t51.roles AS roles_63,
  t51.password AS password_64,
  t51.state AS state_65,
  t51.created AS created_66,
  t51.updated AS updated_67,
  t51.picture_id AS picture_id_68,
  t51.userfunction_id AS userfunction_id_69,
  t51.timezone_id AS timezone_id_70,
  t51.locale_id AS locale_id_71,
  t51.employee_id AS employee_id_72,
  t51.organization_id AS organization_id_73,
  t51.created_by AS created_by_74,
  t51.updated_by AS updated_by_75,
  t0.type_id AS type_id_76,
  t0.gender_id AS gender_id_77,
  t0.language_id AS language_id_78,
  t0.function_id AS function_id_79,
  t0.current_status_id AS current_status_id_80,
  t0.sector_id AS sector_id_81,
  t0.cv_id AS cv_id_82,
  t0.internal_cv_id AS internal_cv_id_83,
  t0.organization_id AS organization_id_84,
  t0.created_by AS created_by_85,
  t0.updated_by AS updated_by_86
FROM
  employee t0
  LEFT JOIN user t51 ON t51.employee_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.lastname AS lastname_2, t0.firstname AS firstname_3, t0.external_id AS external_id_4, t0.rate AS rate_5, t0.available_on AS available_on_6, t0.years_experience AS years_experience_7, t0.street AS street_8, t0.housenumber AS housenumber_9, t0.postcode AS postcode_10, t0.municipality AS municipality_11, t0.sub_municipality AS sub_municipality_12, t0.country AS country_13, t0.phone AS phone_14, t0.phone2 AS phone2_15, t0.email AS email_16, t0.no_email_until AS no_email_until_17, t0.excludefrommailings AS excludefrommailings_18, t0.allow_to_process_information_gdpr AS allow_to_process_information_gdpr_19, t0.black_list AS black_list_20, t0.hot_profile AS hot_profile_21, t0.birthday AS birthday_22, t0.certifications AS certifications_23, t0.description AS description_24, t0.yearly_legal_holliday AS yearly_legal_holliday_25, t0.yearly_adv AS yearly_adv_26, t0.weekly_work_hours AS weekly_work_hours_27, t0.work_monday_forenoon AS work_monday_forenoon_28, t0.work_monday_afternoon AS work_monday_afternoon_29, t0.work_tuesday_forenoon AS work_tuesday_forenoon_30, t0.work_tuesday_afternoon AS work_tuesday_afternoon_31, t0.work_wednesday_forenoon AS work_wednesday_forenoon_32, t0.work_wednesday_afternoon AS work_wednesday_afternoon_33, t0.work_thursday_forenoon AS work_thursday_forenoon_34, t0.work_thursday_afternoon AS work_thursday_afternoon_35, t0.work_friday_forenoon AS work_friday_forenoon_36, t0.work_friday_afternoon AS work_friday_afternoon_37, t0.work_saturday_forenoon AS work_saturday_forenoon_38, t0.work_saturday_afternoon AS work_saturday_afternoon_39, t0.work_sunday_forenoon AS work_sunday_forenoon_40, t0.work_sunday_afternoon AS work_sunday_afternoon_41, t0.start_date AS start_date_42, t0.end_date AS end_date_43, t0.iban AS iban_44, t0.bic AS bic_45, t0.state_registration_number AS state_registration_number_46, t0.state AS state_47, t0.created AS created_48, t0.updated AS updated_49, t0.image_id AS image_id_50, t51.id AS id_52, t51.uuid AS uuid_53, t51.email AS email_54, t51.first_name AS first_name_55, t51.last_name AS last_name_56, t51.phone AS phone_57, t51.type AS type_58, t51.last_login AS last_login_59, t51.failed_login_attempts AS failed_login_attempts_60, t51.enabled AS enabled_61, t51.locked AS locked_62, t51.roles AS roles_63, t51.password AS password_64, t51.state AS state_65, t51.created AS created_66, t51.updated AS updated_67, t51.picture_id AS picture_id_68, t51.userfunction_id AS userfunction_id_69, t51.timezone_id AS timezone_id_70, t51.locale_id AS locale_id_71, t51.employee_id AS employee_id_72, t51.organization_id AS organization_id_73, t51.created_by AS created_by_74, t51.updated_by AS updated_by_75, t0.type_id AS type_id_76, t0.gender_id AS gender_id_77, t0.language_id AS language_id_78, t0.function_id AS function_id_79, t0.current_status_id AS current_status_id_80, t0.sector_id AS sector_id_81, t0.cv_id AS cv_id_82, t0.internal_cv_id AS internal_cv_id_83, t0.organization_id AS organization_id_84, t0.created_by AS created_by_85, t0.updated_by AS updated_by_86 FROM employee t0 LEFT JOIN user t51 ON t51.employee_id = t0.id WHERE t0.id = 5691;

SELECT
  t0.id AS id_1,
  t0.externalid AS externalid_2,
  t0.company AS company_3,
  t0.acronym AS acronym_4,
  t0.tax AS tax_5,
  t0.additional_invoice_text AS additional_invoice_text_6,
  t0.lastname AS lastname_7,
  t0.firstname AS firstname_8,
  t0.street AS street_9,
  t0.housenumber AS housenumber_10,
  t0.postcode AS postcode_11,
  t0.municipality AS municipality_12,
  t0.sub_municipality AS sub_municipality_13,
  t0.country AS country_14,
  t0.phone AS phone_15,
  t0.phone2 AS phone2_16,
  t0.email AS email_17,
  t0.email2 AS email2_18,
  t0.contact_by_email AS contact_by_email_19,
  t0.iban AS iban_20,
  t0.bic AS bic_21,
  t0.website AS website_22,
  t0.emailvalidated AS emailvalidated_23,
  t0.excludefrommailings AS excludefrommailings_24,
  t0.description AS description_25,
  t0.state_registration_number AS state_registration_number_26,
  t0.state AS state_27,
  t0.created AS created_28,
  t0.updated AS updated_29,
  t0.image_id AS image_id_30,
  t0.taxrate_id AS taxrate_id_31,
  t0.gender_id AS gender_id_32,
  t0.language_id AS language_id_33,
  t0.client_type_id AS client_type_id_34,
  t0.owner_id AS owner_id_35,
  t0.organization_id AS organization_id_36,
  t0.created_by AS created_by_37,
  t0.updated_by AS updated_by_38
FROM
  client t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.externalid AS externalid_2, t0.company AS company_3, t0.acronym AS acronym_4, t0.tax AS tax_5, t0.additional_invoice_text AS additional_invoice_text_6, t0.lastname AS lastname_7, t0.firstname AS firstname_8, t0.street AS street_9, t0.housenumber AS housenumber_10, t0.postcode AS postcode_11, t0.municipality AS municipality_12, t0.sub_municipality AS sub_municipality_13, t0.country AS country_14, t0.phone AS phone_15, t0.phone2 AS phone2_16, t0.email AS email_17, t0.email2 AS email2_18, t0.contact_by_email AS contact_by_email_19, t0.iban AS iban_20, t0.bic AS bic_21, t0.website AS website_22, t0.emailvalidated AS emailvalidated_23, t0.excludefrommailings AS excludefrommailings_24, t0.description AS description_25, t0.state_registration_number AS state_registration_number_26, t0.state AS state_27, t0.created AS created_28, t0.updated AS updated_29, t0.image_id AS image_id_30, t0.taxrate_id AS taxrate_id_31, t0.gender_id AS gender_id_32, t0.language_id AS language_id_33, t0.client_type_id AS client_type_id_34, t0.owner_id AS owner_id_35, t0.organization_id AS organization_id_36, t0.created_by AS created_by_37, t0.updated_by AS updated_by_38 FROM client t0 WHERE t0.id = 22;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.email AS email_3,
  t0.first_name AS first_name_4,
  t0.last_name AS last_name_5,
  t0.phone AS phone_6,
  t0.type AS type_7,
  t0.last_login AS last_login_8,
  t0.failed_login_attempts AS failed_login_attempts_9,
  t0.enabled AS enabled_10,
  t0.locked AS locked_11,
  t0.roles AS roles_12,
  t0.password AS password_13,
  t0.state AS state_14,
  t0.created AS created_15,
  t0.updated AS updated_16,
  t0.picture_id AS picture_id_17,
  t0.userfunction_id AS userfunction_id_18,
  t0.timezone_id AS timezone_id_19,
  t0.locale_id AS locale_id_20,
  t0.employee_id AS employee_id_21,
  t0.organization_id AS organization_id_22,
  t0.created_by AS created_by_23,
  t0.updated_by AS updated_by_24
FROM
  user t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.email AS email_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.phone AS phone_6, t0.type AS type_7, t0.last_login AS last_login_8, t0.failed_login_attempts AS failed_login_attempts_9, t0.enabled AS enabled_10, t0.locked AS locked_11, t0.roles AS roles_12, t0.password AS password_13, t0.state AS state_14, t0.created AS created_15, t0.updated AS updated_16, t0.picture_id AS picture_id_17, t0.userfunction_id AS userfunction_id_18, t0.timezone_id AS timezone_id_19, t0.locale_id AS locale_id_20, t0.employee_id AS employee_id_21, t0.organization_id AS organization_id_22, t0.created_by AS created_by_23, t0.updated_by AS updated_by_24 FROM user t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.state AS state_3,
  t0.created AS created_4,
  t0.updated AS updated_5,
  t0.created_by AS created_by_6,
  t0.updated_by AS updated_by_7
FROM
  organization t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.state AS state_3, t0.created AS created_4, t0.updated AS updated_5, t0.created_by AS created_by_6, t0.updated_by AS updated_by_7 FROM organization t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.unit_price AS unit_price_2,
  t0.intake_price AS intake_price_3,
  t0.quantity AS quantity_4,
  t0.state AS state_5,
  t0.created AS created_6,
  t0.updated AS updated_7,
  t0.proposal_id AS proposal_id_8,
  t0.employee_id AS employee_id_9,
  t0.product_id AS product_id_10,
  t0.frequency_id AS frequency_id_11,
  t0.created_by AS created_by_12,
  t0.updated_by AS updated_by_13
FROM
  proposal_element t0
WHERE
  t0.proposal_id = ?

SELECT t0.id AS id_1, t0.unit_price AS unit_price_2, t0.intake_price AS intake_price_3, t0.quantity AS quantity_4, t0.state AS state_5, t0.created AS created_6, t0.updated AS updated_7, t0.proposal_id AS proposal_id_8, t0.employee_id AS employee_id_9, t0.product_id AS product_id_10, t0.frequency_id AS frequency_id_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13 FROM proposal_element t0 WHERE t0.proposal_id = 568;

SELECT
  t0.id AS id_1,
  t0.lastname AS lastname_2,
  t0.firstname AS firstname_3,
  t0.external_id AS external_id_4,
  t0.rate AS rate_5,
  t0.available_on AS available_on_6,
  t0.years_experience AS years_experience_7,
  t0.street AS street_8,
  t0.housenumber AS housenumber_9,
  t0.postcode AS postcode_10,
  t0.municipality AS municipality_11,
  t0.sub_municipality AS sub_municipality_12,
  t0.country AS country_13,
  t0.phone AS phone_14,
  t0.phone2 AS phone2_15,
  t0.email AS email_16,
  t0.no_email_until AS no_email_until_17,
  t0.excludefrommailings AS excludefrommailings_18,
  t0.allow_to_process_information_gdpr AS allow_to_process_information_gdpr_19,
  t0.black_list AS black_list_20,
  t0.hot_profile AS hot_profile_21,
  t0.birthday AS birthday_22,
  t0.certifications AS certifications_23,
  t0.description AS description_24,
  t0.yearly_legal_holliday AS yearly_legal_holliday_25,
  t0.yearly_adv AS yearly_adv_26,
  t0.weekly_work_hours AS weekly_work_hours_27,
  t0.work_monday_forenoon AS work_monday_forenoon_28,
  t0.work_monday_afternoon AS work_monday_afternoon_29,
  t0.work_tuesday_forenoon AS work_tuesday_forenoon_30,
  t0.work_tuesday_afternoon AS work_tuesday_afternoon_31,
  t0.work_wednesday_forenoon AS work_wednesday_forenoon_32,
  t0.work_wednesday_afternoon AS work_wednesday_afternoon_33,
  t0.work_thursday_forenoon AS work_thursday_forenoon_34,
  t0.work_thursday_afternoon AS work_thursday_afternoon_35,
  t0.work_friday_forenoon AS work_friday_forenoon_36,
  t0.work_friday_afternoon AS work_friday_afternoon_37,
  t0.work_saturday_forenoon AS work_saturday_forenoon_38,
  t0.work_saturday_afternoon AS work_saturday_afternoon_39,
  t0.work_sunday_forenoon AS work_sunday_forenoon_40,
  t0.work_sunday_afternoon AS work_sunday_afternoon_41,
  t0.start_date AS start_date_42,
  t0.end_date AS end_date_43,
  t0.iban AS iban_44,
  t0.bic AS bic_45,
  t0.state_registration_number AS state_registration_number_46,
  t0.state AS state_47,
  t0.created AS created_48,
  t0.updated AS updated_49,
  t0.image_id AS image_id_50,
  t51.id AS id_52,
  t51.uuid AS uuid_53,
  t51.email AS email_54,
  t51.first_name AS first_name_55,
  t51.last_name AS last_name_56,
  t51.phone AS phone_57,
  t51.type AS type_58,
  t51.last_login AS last_login_59,
  t51.failed_login_attempts AS failed_login_attempts_60,
  t51.enabled AS enabled_61,
  t51.locked AS locked_62,
  t51.roles AS roles_63,
  t51.password AS password_64,
  t51.state AS state_65,
  t51.created AS created_66,
  t51.updated AS updated_67,
  t51.picture_id AS picture_id_68,
  t51.userfunction_id AS userfunction_id_69,
  t51.timezone_id AS timezone_id_70,
  t51.locale_id AS locale_id_71,
  t51.employee_id AS employee_id_72,
  t51.organization_id AS organization_id_73,
  t51.created_by AS created_by_74,
  t51.updated_by AS updated_by_75,
  t0.type_id AS type_id_76,
  t0.gender_id AS gender_id_77,
  t0.language_id AS language_id_78,
  t0.function_id AS function_id_79,
  t0.current_status_id AS current_status_id_80,
  t0.sector_id AS sector_id_81,
  t0.cv_id AS cv_id_82,
  t0.internal_cv_id AS internal_cv_id_83,
  t0.organization_id AS organization_id_84,
  t0.created_by AS created_by_85,
  t0.updated_by AS updated_by_86
FROM
  employee t0
  LEFT JOIN user t51 ON t51.employee_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.lastname AS lastname_2, t0.firstname AS firstname_3, t0.external_id AS external_id_4, t0.rate AS rate_5, t0.available_on AS available_on_6, t0.years_experience AS years_experience_7, t0.street AS street_8, t0.housenumber AS housenumber_9, t0.postcode AS postcode_10, t0.municipality AS municipality_11, t0.sub_municipality AS sub_municipality_12, t0.country AS country_13, t0.phone AS phone_14, t0.phone2 AS phone2_15, t0.email AS email_16, t0.no_email_until AS no_email_until_17, t0.excludefrommailings AS excludefrommailings_18, t0.allow_to_process_information_gdpr AS allow_to_process_information_gdpr_19, t0.black_list AS black_list_20, t0.hot_profile AS hot_profile_21, t0.birthday AS birthday_22, t0.certifications AS certifications_23, t0.description AS description_24, t0.yearly_legal_holliday AS yearly_legal_holliday_25, t0.yearly_adv AS yearly_adv_26, t0.weekly_work_hours AS weekly_work_hours_27, t0.work_monday_forenoon AS work_monday_forenoon_28, t0.work_monday_afternoon AS work_monday_afternoon_29, t0.work_tuesday_forenoon AS work_tuesday_forenoon_30, t0.work_tuesday_afternoon AS work_tuesday_afternoon_31, t0.work_wednesday_forenoon AS work_wednesday_forenoon_32, t0.work_wednesday_afternoon AS work_wednesday_afternoon_33, t0.work_thursday_forenoon AS work_thursday_forenoon_34, t0.work_thursday_afternoon AS work_thursday_afternoon_35, t0.work_friday_forenoon AS work_friday_forenoon_36, t0.work_friday_afternoon AS work_friday_afternoon_37, t0.work_saturday_forenoon AS work_saturday_forenoon_38, t0.work_saturday_afternoon AS work_saturday_afternoon_39, t0.work_sunday_forenoon AS work_sunday_forenoon_40, t0.work_sunday_afternoon AS work_sunday_afternoon_41, t0.start_date AS start_date_42, t0.end_date AS end_date_43, t0.iban AS iban_44, t0.bic AS bic_45, t0.state_registration_number AS state_registration_number_46, t0.state AS state_47, t0.created AS created_48, t0.updated AS updated_49, t0.image_id AS image_id_50, t51.id AS id_52, t51.uuid AS uuid_53, t51.email AS email_54, t51.first_name AS first_name_55, t51.last_name AS last_name_56, t51.phone AS phone_57, t51.type AS type_58, t51.last_login AS last_login_59, t51.failed_login_attempts AS failed_login_attempts_60, t51.enabled AS enabled_61, t51.locked AS locked_62, t51.roles AS roles_63, t51.password AS password_64, t51.state AS state_65, t51.created AS created_66, t51.updated AS updated_67, t51.picture_id AS picture_id_68, t51.userfunction_id AS userfunction_id_69, t51.timezone_id AS timezone_id_70, t51.locale_id AS locale_id_71, t51.employee_id AS employee_id_72, t51.organization_id AS organization_id_73, t51.created_by AS created_by_74, t51.updated_by AS updated_by_75, t0.type_id AS type_id_76, t0.gender_id AS gender_id_77, t0.language_id AS language_id_78, t0.function_id AS function_id_79, t0.current_status_id AS current_status_id_80, t0.sector_id AS sector_id_81, t0.cv_id AS cv_id_82, t0.internal_cv_id AS internal_cv_id_83, t0.organization_id AS organization_id_84, t0.created_by AS created_by_85, t0.updated_by AS updated_by_86 FROM employee t0 LEFT JOIN user t51 ON t51.employee_id = t0.id WHERE t0.id = 5690;

SELECT
  t0.id AS id_1,
  t0.unit_price AS unit_price_2,
  t0.intake_price AS intake_price_3,
  t0.quantity AS quantity_4,
  t0.state AS state_5,
  t0.created AS created_6,
  t0.updated AS updated_7,
  t0.proposal_id AS proposal_id_8,
  t0.employee_id AS employee_id_9,
  t0.product_id AS product_id_10,
  t0.frequency_id AS frequency_id_11,
  t0.created_by AS created_by_12,
  t0.updated_by AS updated_by_13
FROM
  proposal_element t0
WHERE
  t0.proposal_id = ?