Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.executed_at AS executed_at_2,
  t0.finished_at AS finished_at_3,
  t0.inspection_description AS inspection_description_4,
  t0.inspection_duration AS inspection_duration_5,
  t0.sent_at AS sent_at_6,
  t0.position AS position_7,
  t0.additional_protocol_fields AS additional_protocol_fields_8,
  t0.odoo_reference AS odoo_reference_9,
  t0.post_process_duration AS post_process_duration_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.deleted_at AS deleted_at_13,
  t0.area_id AS area_id_14,
  t0.inspection_previous_id AS inspection_previous_id_15,
  t0.inspection_executed_by_id AS inspection_executed_by_id_16,
  t0.created_by_user_id AS created_by_user_id_17,
  t0.updated_by_user_id AS updated_by_user_id_18,
  t0.sent_by_user_id AS sent_by_user_id_19
FROM
  inspection t0
WHERE
  t0.area_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.executed_at AS executed_at_2, t0.finished_at AS finished_at_3, t0.inspection_description AS inspection_description_4, t0.inspection_duration AS inspection_duration_5, t0.sent_at AS sent_at_6, t0.position AS position_7, t0.additional_protocol_fields AS additional_protocol_fields_8, t0.odoo_reference AS odoo_reference_9, t0.post_process_duration AS post_process_duration_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.deleted_at AS deleted_at_13, t0.area_id AS area_id_14, t0.inspection_previous_id AS inspection_previous_id_15, t0.inspection_executed_by_id AS inspection_executed_by_id_16, t0.created_by_user_id AS created_by_user_id_17, t0.updated_by_user_id AS updated_by_user_id_18, t0.sent_by_user_id AS sent_by_user_id_19 FROM inspection t0 WHERE t0.area_id = 5745 AND ((t0.deleted_at IS NULL));

SELECT
  a0_.created_at AS created_at_0,
  a0_.deleted_at AS deleted_at_1,
  a0_.id AS id_2,
  a0_.area_title AS area_title_3,
  a0_.area_description AS area_description_4,
  a0_.area_street AS area_street_5,
  a0_.area_streetnumber AS area_streetnumber_6,
  a0_.area_zip AS area_zip_7,
  a0_.area_city AS area_city_8,
  a0_.area_country AS area_country_9,
  st_astext(a0_.area_geocode) AS area_geocode_10,
  a0_.is_deactivated AS is_deactivated_11,
  a0_.area_protocol_mobile AS area_protocol_mobile_12,
  a0_.area_protocol_landline AS area_protocol_landline_13,
  a0_.area_protocol_fax AS area_protocol_fax_14,
  a0_.area_protocol_start_index AS area_protocol_start_index_15,
  a0_.area_protocol_construction_site_title AS area_protocol_construction_site_title_16,
  a0_.area_protocol_area_title AS area_protocol_area_title_17,
  a0_.area_platform_distribution_active AS area_platform_distribution_active_18,
  a0_.area_platform_distribution AS area_platform_distribution_19,
  a0_.area_platform_distribution_link AS area_platform_distribution_link_20,
  a0_.area_platform_distribution_setting AS area_platform_distribution_setting_21,
  a0_.area_platform_distribution_protocol_text AS area_platform_distribution_protocol_text_22,
  a0_.area_controlling_max_days_between_inspections AS area_controlling_max_days_between_inspections_23,
  a0_.area_controlling_inspection_is_public AS area_controlling_inspection_is_public_24,
  a0_.area_controlling_inspection_public_note AS area_controlling_inspection_public_note_25,
  a0_.area_protocol_epilogue AS area_protocol_epilogue_26,
  a0_.is_mailing_enabled AS is_mailing_enabled_27,
  a0_.variant_sending_address AS variant_sending_address_28,
  a0_.variant_sending_name AS variant_sending_name_29,
  a0_.is_link_mailing_enabled AS is_link_mailing_enabled_30,
  a0_.is_geo_links_enabled AS is_geo_links_enabled_31,
  a0_.protocol_file_name_template AS protocol_file_name_template_32,
  a0_.is_show_resolved_defects_in_protocol_enabled AS is_show_resolved_defects_in_protocol_enabled_33,
  a0_.inspection_notes AS inspection_notes_34,
  a0_.starts_at AS starts_at_35,
  a0_.ends_at AS ends_at_36,
  a0_.status AS status_37,
  a0_.keywords AS keywords_38,
  a0_.kilometers_from AS kilometers_from_39,
  a0_.kilometers_to AS kilometers_to_40,
  a0_.custom_datafield1_name AS custom_datafield1_name_41,
  a0_.custom_datafield1_value AS custom_datafield1_value_42,
  a0_.customer_project_number AS customer_project_number_43,
  a0_.odoo_project_id AS odoo_project_id_44,
  a0_.odoo_settings AS odoo_settings_45,
  a0_.updated_at AS updated_at_46,
  p1_.id AS id_47,
  p1_.ecoclient_id AS ecoclient_id_48,
  p1_.project_title AS project_title_49,
  p1_.project_status AS project_status_50,
  p1_.starts_at AS starts_at_51,
  p1_.ends_at AS ends_at_52,
  u2_.id AS id_53,
  u3_.id AS id_54,
  u4_.id AS id_55,
  u5_.id AS id_56,
  a6_.id AS id_57,
  m7_.id AS id_58,
  m7_.name AS name_59,
  a0_.project_id AS project_id_60,
  a0_.created_by_user_id AS created_by_user_id_61,
  a0_.area_responsible_backoffice_id AS area_responsible_backoffice_id_62,
  a0_.area_responsible_inspector_id AS area_responsible_inspector_id_63,
  a0_.area_responsible_sales_id AS area_responsible_sales_id_64,
  a0_.team_assistant_id AS team_assistant_id_65,
  a0_.area_protocol_base_checklist_id AS area_protocol_base_checklist_id_66,
  a0_.protocol_template_id AS protocol_template_id_67,
  a0_.protocol_email_template_id AS protocol_email_template_id_68,
  a0_.risk_matrix_template_id AS risk_matrix_template_id_69,
  a0_.metropolitan_area_id AS metropolitan_area_id_70,
  p1_.company_id AS company_id_71,
  p1_.user_id AS user_id_72,
  a6_.area_id AS area_id_73
FROM
  area a0_
  INNER JOIN project p1_ ON a0_.project_id = p1_.id
  AND (p1_.deleted_at IS NULL)
  LEFT JOIN user u2_ ON a0_.created_by_user_id = u2_.id
  LEFT JOIN user u3_ ON a0_.area_responsible_backoffice_id = u3_.id
  LEFT JOIN user u4_ ON a0_.area_responsible_inspector_id = u4_.id
  LEFT JOIN user u5_ ON a0_.area_responsible_sales_id = u5_.id
  LEFT JOIN area_zone a6_ ON a0_.id = a6_.area_id
  LEFT JOIN metropolitan_area m7_ ON a0_.metropolitan_area_id = m7_.id
WHERE
  (a0_.project_id = ?)
  AND (a0_.deleted_at IS NULL)
ORDER BY
  a0_.area_title ASC

SELECT a0_.created_at AS created_at_0, a0_.deleted_at AS deleted_at_1, a0_.id AS id_2, a0_.area_title AS area_title_3, a0_.area_description AS area_description_4, a0_.area_street AS area_street_5, a0_.area_streetnumber AS area_streetnumber_6, a0_.area_zip AS area_zip_7, a0_.area_city AS area_city_8, a0_.area_country AS area_country_9, st_astext(a0_.area_geocode) AS area_geocode_10, a0_.is_deactivated AS is_deactivated_11, a0_.area_protocol_mobile AS area_protocol_mobile_12, a0_.area_protocol_landline AS area_protocol_landline_13, a0_.area_protocol_fax AS area_protocol_fax_14, a0_.area_protocol_start_index AS area_protocol_start_index_15, a0_.area_protocol_construction_site_title AS area_protocol_construction_site_title_16, a0_.area_protocol_area_title AS area_protocol_area_title_17, a0_.area_platform_distribution_active AS area_platform_distribution_active_18, a0_.area_platform_distribution AS area_platform_distribution_19, a0_.area_platform_distribution_link AS area_platform_distribution_link_20, a0_.area_platform_distribution_setting AS area_platform_distribution_setting_21, a0_.area_platform_distribution_protocol_text AS area_platform_distribution_protocol_text_22, a0_.area_controlling_max_days_between_inspections AS area_controlling_max_days_between_inspections_23, a0_.area_controlling_inspection_is_public AS area_controlling_inspection_is_public_24, a0_.area_controlling_inspection_public_note AS area_controlling_inspection_public_note_25, a0_.area_protocol_epilogue AS area_protocol_epilogue_26, a0_.is_mailing_enabled AS is_mailing_enabled_27, a0_.variant_sending_address AS variant_sending_address_28, a0_.variant_sending_name AS variant_sending_name_29, a0_.is_link_mailing_enabled AS is_link_mailing_enabled_30, a0_.is_geo_links_enabled AS is_geo_links_enabled_31, a0_.protocol_file_name_template AS protocol_file_name_template_32, a0_.is_show_resolved_defects_in_protocol_enabled AS is_show_resolved_defects_in_protocol_enabled_33, a0_.inspection_notes AS inspection_notes_34, a0_.starts_at AS starts_at_35, a0_.ends_at AS ends_at_36, a0_.status AS status_37, a0_.keywords AS keywords_38, a0_.kilometers_from AS kilometers_from_39, a0_.kilometers_to AS kilometers_to_40, a0_.custom_datafield1_name AS custom_datafield1_name_41, a0_.custom_datafield1_value AS custom_datafield1_value_42, a0_.customer_project_number AS customer_project_number_43, a0_.odoo_project_id AS odoo_project_id_44, a0_.odoo_settings AS odoo_settings_45, a0_.updated_at AS updated_at_46, p1_.id AS id_47, p1_.ecoclient_id AS ecoclient_id_48, p1_.project_title AS project_title_49, p1_.project_status AS project_status_50, p1_.starts_at AS starts_at_51, p1_.ends_at AS ends_at_52, u2_.id AS id_53, u3_.id AS id_54, u4_.id AS id_55, u5_.id AS id_56, a6_.id AS id_57, m7_.id AS id_58, m7_.name AS name_59, a0_.project_id AS project_id_60, a0_.created_by_user_id AS created_by_user_id_61, a0_.area_responsible_backoffice_id AS area_responsible_backoffice_id_62, a0_.area_responsible_inspector_id AS area_responsible_inspector_id_63, a0_.area_responsible_sales_id AS area_responsible_sales_id_64, a0_.team_assistant_id AS team_assistant_id_65, a0_.area_protocol_base_checklist_id AS area_protocol_base_checklist_id_66, a0_.protocol_template_id AS protocol_template_id_67, a0_.protocol_email_template_id AS protocol_email_template_id_68, a0_.risk_matrix_template_id AS risk_matrix_template_id_69, a0_.metropolitan_area_id AS metropolitan_area_id_70, p1_.company_id AS company_id_71, p1_.user_id AS user_id_72, a6_.area_id AS area_id_73 FROM area a0_ INNER JOIN project p1_ ON a0_.project_id = p1_.id AND (p1_.deleted_at IS NULL) LEFT JOIN user u2_ ON a0_.created_by_user_id = u2_.id LEFT JOIN user u3_ ON a0_.area_responsible_backoffice_id = u3_.id LEFT JOIN user u4_ ON a0_.area_responsible_inspector_id = u4_.id LEFT JOIN user u5_ ON a0_.area_responsible_sales_id = u5_.id LEFT JOIN area_zone a6_ ON a0_.id = a6_.area_id LEFT JOIN metropolitan_area m7_ ON a0_.metropolitan_area_id = m7_.id WHERE (a0_.project_id = '7194') AND (a0_.deleted_at IS NULL) ORDER BY a0_.area_title ASC;

SELECT
  t0.id AS id_1,
  t0.ecoclient_user_id AS ecoclient_user_id_2,
  t0.username AS username_3,
  t0.firstname AS firstname_4,
  t0.lastname AS lastname_5,
  t0.salutation AS salutation_6,
  t0.email AS email_7,
  t0.password AS password_8,
  t0.user_title AS user_title_9,
  t0.user_mobile AS user_mobile_10,
  t0.user_landline AS user_landline_11,
  t0.enable_ldap_authentication AS enable_ldap_authentication_12,
  t0.image AS image_13,
  t0.marker_image AS marker_image_14,
  t0.small_square_image AS small_square_image_15,
  t0.image_mime_type AS image_mime_type_16,
  t0.is_non_human AS is_non_human_17,
  t0.signature AS signature_18,
  t0.odoo_employee_id AS odoo_employee_id_19,
  t0.odoo_user_id AS odoo_user_id_20,
  t0.disabled_at AS disabled_at_21,
  t0.created_at AS created_at_22,
  t0.updated_at AS updated_at_23,
  t0.deleted_at AS deleted_at_24
FROM
  user t0
WHERE
  t0.username = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.ecoclient_user_id AS ecoclient_user_id_2, t0.username AS username_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.salutation AS salutation_6, t0.email AS email_7, t0.password AS password_8, t0.user_title AS user_title_9, t0.user_mobile AS user_mobile_10, t0.user_landline AS user_landline_11, t0.enable_ldap_authentication AS enable_ldap_authentication_12, t0.image AS image_13, t0.marker_image AS marker_image_14, t0.small_square_image AS small_square_image_15, t0.image_mime_type AS image_mime_type_16, t0.is_non_human AS is_non_human_17, t0.signature AS signature_18, t0.odoo_employee_id AS odoo_employee_id_19, t0.odoo_user_id AS odoo_user_id_20, t0.disabled_at AS disabled_at_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.deleted_at AS deleted_at_24 FROM user t0 WHERE t0.username = 'reuter' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  role t0
  INNER JOIN user_role ON t0.id = user_role.role_id
WHERE
  user_role.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM role t0 INNER JOIN user_role ON t0.id = user_role.role_id WHERE user_role.user_id = 7;