Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.email AS email_4,
  t0.city AS city_5,
  t0.zip AS zip_6,
  t0.province AS province_7,
  t0.vat_country AS vat_country_8,
  t0.vat AS vat_9,
  t0.fiscal_code AS fiscal_code_10,
  t0.sdi AS sdi_11,
  t0.directory_path AS directory_path_12,
  t0.logo_path AS logo_path_13,
  t0.creation_date AS creation_date_14,
  t0.db_name AS db_name_15,
  t0.code AS code_16,
  t0.slug AS slug_17,
  t0.is_admin_active AS is_admin_active_18,
  t0.type_id AS type_id_19
FROM
  bee_m_company t0
WHERE
  t0.code = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.email AS email_4, t0.city AS city_5, t0.zip AS zip_6, t0.province AS province_7, t0.vat_country AS vat_country_8, t0.vat AS vat_9, t0.fiscal_code AS fiscal_code_10, t0.sdi AS sdi_11, t0.directory_path AS directory_path_12, t0.logo_path AS logo_path_13, t0.creation_date AS creation_date_14, t0.db_name AS db_name_15, t0.code AS code_16, t0.slug AS slug_17, t0.is_admin_active AS is_admin_active_18, t0.type_id AS type_id_19 FROM bee_m_company t0 WHERE t0.code = 'MEFN12' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.address AS address_3,
  t0.email AS email_4,
  t0.city AS city_5,
  t0.zip AS zip_6,
  t0.province AS province_7,
  t0.vat_country AS vat_country_8,
  t0.vat AS vat_9,
  t0.fiscal_code AS fiscal_code_10,
  t0.sdi AS sdi_11,
  t0.directory_path AS directory_path_12,
  t0.logo_path AS logo_path_13,
  t0.creation_date AS creation_date_14,
  t0.db_name AS db_name_15,
  t0.code AS code_16,
  t0.slug AS slug_17,
  t0.is_admin_active AS is_admin_active_18,
  t0.type_id AS type_id_19
FROM
  bee_m_company t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.email AS email_4, t0.city AS city_5, t0.zip AS zip_6, t0.province AS province_7, t0.vat_country AS vat_country_8, t0.vat AS vat_9, t0.fiscal_code AS fiscal_code_10, t0.sdi AS sdi_11, t0.directory_path AS directory_path_12, t0.logo_path AS logo_path_13, t0.creation_date AS creation_date_14, t0.db_name AS db_name_15, t0.code AS code_16, t0.slug AS slug_17, t0.is_admin_active AS is_admin_active_18, t0.type_id AS type_id_19 FROM bee_m_company t0 WHERE t0.id = '12' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.date_invoice AS date_invoice_2,
  t0.date_start AS date_start_3,
  t0.date_expiration AS date_expiration_4,
  t0.is_active AS is_active_5,
  t0.type_id AS type_id_6,
  t0.company_id AS company_id_7
FROM
  bee_m_license t0
WHERE
  t0.company_id = ?

SELECT t0.id AS id_1, t0.date_invoice AS date_invoice_2, t0.date_start AS date_start_3, t0.date_expiration AS date_expiration_4, t0.is_active AS is_active_5, t0.type_id AS type_id_6, t0.company_id AS company_id_7 FROM bee_m_license t0 WHERE t0.company_id = 12;

SELECT
  t0.id AS id_1,
  t0.completed_date AS completed_date_2,
  t0.name AS name_3,
  t0.priority AS priority_4,
  t0.is_completed AS is_completed_5,
  t0.completed_by_staff_id AS completed_by_staff_id_6,
  t0.performance_id AS performance_id_7,
  t0.required_for_performance_phase_id AS required_for_performance_phase_id_8,
  t0.optional_for_performance_phase_id AS optional_for_performance_phase_id_9,
  t0.requirement_id AS requirement_id_10
FROM
  bee_s_performance_requirement t0
WHERE
  t0.optional_for_performance_phase_id = ?

SELECT t0.id AS id_1, t0.completed_date AS completed_date_2, t0.name AS name_3, t0.priority AS priority_4, t0.is_completed AS is_completed_5, t0.completed_by_staff_id AS completed_by_staff_id_6, t0.performance_id AS performance_id_7, t0.required_for_performance_phase_id AS required_for_performance_phase_id_8, t0.optional_for_performance_phase_id AS optional_for_performance_phase_id_9, t0.requirement_id AS requirement_id_10 FROM bee_s_performance_requirement t0 WHERE t0.optional_for_performance_phase_id = 704;

SELECT
  t0.id AS id_1,
  t0.completed_date AS completed_date_2,
  t0.name AS name_3,
  t0.priority AS priority_4,
  t0.is_completed AS is_completed_5,
  t0.completed_by_staff_id AS completed_by_staff_id_6,
  t0.performance_id AS performance_id_7,
  t0.required_for_performance_phase_id AS required_for_performance_phase_id_8,
  t0.optional_for_performance_phase_id AS optional_for_performance_phase_id_9,
  t0.requirement_id AS requirement_id_10
FROM
  bee_s_performance_requirement t0
WHERE
  t0.required_for_performance_phase_id = ?

SELECT t0.id AS id_1, t0.completed_date AS completed_date_2, t0.name AS name_3, t0.priority AS priority_4, t0.is_completed AS is_completed_5, t0.completed_by_staff_id AS completed_by_staff_id_6, t0.performance_id AS performance_id_7, t0.required_for_performance_phase_id AS required_for_performance_phase_id_8, t0.optional_for_performance_phase_id AS optional_for_performance_phase_id_9, t0.requirement_id AS requirement_id_10 FROM bee_s_performance_requirement t0 WHERE t0.required_for_performance_phase_id = 704;

SELECT
  t0.id AS id_1,
  t0.value AS value_2,
  t0.is_completion_date_required AS is_completion_date_required_3,
  t0.is_date_client_visible AS is_date_client_visible_4
FROM
  bee_s_requirement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.value AS value_2, t0.is_completion_date_required AS is_completion_date_required_3, t0.is_date_client_visible AS is_date_client_visible_4 FROM bee_s_requirement t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.priority AS priority_2,
  t0.name AS name_3,
  t0.start_date AS start_date_4,
  t0.completed_date AS completed_date_5,
  t0.is_completed AS is_completed_6,
  t0.is_hidden AS is_hidden_7,
  t0.completed_by_staff_id AS completed_by_staff_id_8,
  t0.performance_id AS performance_id_9
FROM
  bee_s_performance_phase t0
WHERE
  t0.performance_id = ?

SELECT t0.id AS id_1, t0.priority AS priority_2, t0.name AS name_3, t0.start_date AS start_date_4, t0.completed_date AS completed_date_5, t0.is_completed AS is_completed_6, t0.is_hidden AS is_hidden_7, t0.completed_by_staff_id AS completed_by_staff_id_8, t0.performance_id AS performance_id_9 FROM bee_s_performance_phase t0 WHERE t0.performance_id = 33;

SELECT
  t0.id AS id_1,
  t0.priority AS priority_2,
  t0.phase_id AS phase_id_3,
  t0.requirement_id AS requirement_id_4
FROM
  bee_s_jt_phase_required_requirements t0
WHERE
  t0.phase_id = ?

SELECT t0.id AS id_1, t0.priority AS priority_2, t0.phase_id AS phase_id_3, t0.requirement_id AS requirement_id_4 FROM bee_s_jt_phase_required_requirements t0 WHERE t0.phase_id = 66;

SELECT
  t0.id AS id_1,
  t0.business_name AS business_name_2,
  t0.vat AS vat_3,
  t0.fiscal_code AS fiscal_code_4,
  t0.sdi AS sdi_5
FROM
  bee_s_client t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.business_name AS business_name_2, t0.vat AS vat_3, t0.fiscal_code AS fiscal_code_4, t0.sdi AS sdi_5 FROM bee_s_client t0 WHERE t0.id = 11;

SELECT
  t0.id AS id_1,
  t0.priority AS priority_2,
  t0.phase_id AS phase_id_3,
  t0.requirement_id AS requirement_id_4
FROM
  bee_s_jt_phase_optional_requirements t0
WHERE
  t0.phase_id = ?

SELECT t0.id AS id_1, t0.priority AS priority_2, t0.phase_id AS phase_id_3, t0.requirement_id AS requirement_id_4 FROM bee_s_jt_phase_optional_requirements t0 WHERE t0.phase_id = 66;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3
FROM
  bee_s_phase t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM bee_s_phase t0 WHERE t0.id = 66;

SELECT
  t0.id AS id_1,
  t0.priority AS priority_2,
  t0.phase_id AS phase_id_3,
  t0.procedure_id AS procedure_id_4
FROM
  bee_s_jt_phase_procedure t0
WHERE
  t0.procedure_id = ?

SELECT t0.id AS id_1, t0.priority AS priority_2, t0.phase_id AS phase_id_3, t0.procedure_id AS procedure_id_4 FROM bee_s_jt_phase_procedure t0 WHERE t0.procedure_id = 8;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.description AS description_3
FROM
  bee_s_procedure t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3 FROM bee_s_procedure t0 WHERE t0.id = 8;

SELECT
  b0_.id AS id_0,
  b0_.start_date AS start_date_1,
  b0_.end_date AS end_date_2,
  b0_.name AS name_3,
  b0_.amount AS amount_4,
  b0_.completed_percentage AS completed_percentage_5,
  b0_.drive_link AS drive_link_6,
  b0_.client_notes AS client_notes_7,
  b0_.staff_notes AS staff_notes_8,
  b0_.archive_notes AS archive_notes_9,
  b0_.is_archived AS is_archived_10,
  b0_.is_ignore_sync AS is_ignore_sync_11,
  b0_.client_id AS client_id_12,
  b0_.type_id AS type_id_13,
  b0_.procedure_id AS procedure_id_14,
  b0_.marker_id AS marker_id_15
FROM
  bee_s_performance b0_
  LEFT JOIN bee_s_jt_staff_performance b1_ ON b0_.id = b1_.performance_id
  LEFT JOIN bee_s_staff b2_ ON b1_.staff_id = b2_.id
  LEFT JOIN bee_s_marker b3_ ON b0_.marker_id = b3_.id
  LEFT JOIN bee_s_client b4_ ON b0_.client_id = b4_.id
  LEFT JOIN bee_s_performance_type b5_ ON b0_.type_id = b5_.id
  LEFT JOIN bee_s_procedure b6_ ON b0_.procedure_id = b6_.id
WHERE
  b2_.id = ?
  AND b3_.id IS NOT NULL
  AND b3_.is_alarm = 1
ORDER BY
  b3_.priority ASC,
  b0_.completed_percentage ASC

SELECT b0_.id AS id_0, b0_.start_date AS start_date_1, b0_.end_date AS end_date_2, b0_.name AS name_3, b0_.amount AS amount_4, b0_.completed_percentage AS completed_percentage_5, b0_.drive_link AS drive_link_6, b0_.client_notes AS client_notes_7, b0_.staff_notes AS staff_notes_8, b0_.archive_notes AS archive_notes_9, b0_.is_archived AS is_archived_10, b0_.is_ignore_sync AS is_ignore_sync_11, b0_.client_id AS client_id_12, b0_.type_id AS type_id_13, b0_.procedure_id AS procedure_id_14, b0_.marker_id AS marker_id_15 FROM bee_s_performance b0_ LEFT JOIN bee_s_jt_staff_performance b1_ ON b0_.id = b1_.performance_id LEFT JOIN bee_s_staff b2_ ON b1_.staff_id = b2_.id LEFT JOIN bee_s_marker b3_ ON b0_.marker_id = b3_.id LEFT JOIN bee_s_client b4_ ON b0_.client_id = b4_.id LEFT JOIN bee_s_performance_type b5_ ON b0_.type_id = b5_.id LEFT JOIN bee_s_procedure b6_ ON b0_.procedure_id = b6_.id WHERE b2_.id = '1' AND b3_.id IS NOT NULL AND b3_.is_alarm = 1 ORDER BY b3_.priority ASC, b0_.completed_percentage ASC;

SELECT
  t0.id AS id_1,
  t0.priority AS priority_2,
  t0.value AS value_3,
  t0.color AS color_4,
  t0.is_alarm AS is_alarm_5
FROM
  bee_s_marker t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.priority AS priority_2, t0.value AS value_3, t0.color AS color_4, t0.is_alarm AS is_alarm_5 FROM bee_s_marker t0 WHERE t0.id = 2;

SELECT
  b0_.id AS id_0,
  b0_.start_date AS start_date_1,
  b0_.end_date AS end_date_2,
  b0_.name AS name_3,
  b0_.amount AS amount_4,
  b0_.completed_percentage AS completed_percentage_5,
  b0_.drive_link AS drive_link_6,
  b0_.client_notes AS client_notes_7,
  b0_.staff_notes AS staff_notes_8,
  b0_.archive_notes AS archive_notes_9,
  b0_.is_archived AS is_archived_10,
  b0_.is_ignore_sync AS is_ignore_sync_11,
  b0_.client_id AS client_id_12,
  b0_.type_id AS type_id_13,
  b0_.procedure_id AS procedure_id_14,
  b0_.marker_id AS marker_id_15
FROM
  bee_s_performance b0_
  LEFT JOIN bee_s_jt_staff_performance b1_ ON b0_.id = b1_.performance_id
  LEFT JOIN bee_s_staff b2_ ON b1_.staff_id = b2_.id
  LEFT JOIN bee_s_marker b3_ ON b0_.marker_id = b3_.id
  LEFT JOIN bee_s_client b4_ ON b0_.client_id = b4_.id
WHERE
  b2_.id = ?
  AND b0_.is_ignore_sync = 0
ORDER BY
  b0_.start_date DESC,
  b0_.completed_percentage ASC

SELECT b0_.id AS id_0, b0_.start_date AS start_date_1, b0_.end_date AS end_date_2, b0_.name AS name_3, b0_.amount AS amount_4, b0_.completed_percentage AS completed_percentage_5, b0_.drive_link AS drive_link_6, b0_.client_notes AS client_notes_7, b0_.staff_notes AS staff_notes_8, b0_.archive_notes AS archive_notes_9, b0_.is_archived AS is_archived_10, b0_.is_ignore_sync AS is_ignore_sync_11, b0_.client_id AS client_id_12, b0_.type_id AS type_id_13, b0_.procedure_id AS procedure_id_14, b0_.marker_id AS marker_id_15 FROM bee_s_performance b0_ LEFT JOIN bee_s_jt_staff_performance b1_ ON b0_.id = b1_.performance_id LEFT JOIN bee_s_staff b2_ ON b1_.staff_id = b2_.id LEFT JOIN bee_s_marker b3_ ON b0_.marker_id = b3_.id LEFT JOIN bee_s_client b4_ ON b0_.client_id = b4_.id WHERE b2_.id = '1' AND b0_.is_ignore_sync = 0 ORDER BY b0_.start_date DESC, b0_.completed_percentage ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.surname AS surname_3,
  t0.phone AS phone_4,
  t0.email AS email_5,
  t0.password AS password_6,
  t0.directory_path AS directory_path_7,
  t0.role AS role_8,
  t0.emergency_contact_1 AS emergency_contact_1_9,
  t0.emergency_contact_2 AS emergency_contact_2_10,
  t0.is_admin_active AS is_admin_active_11,
  t0.is_active AS is_active_12,
  t0.is_tutorial_active AS is_tutorial_active_13,
  t0.datetime_creation AS datetime_creation_14,
  t0.one_time_code AS one_time_code_15,
  t0.one_time_code_expiration_datetime AS one_time_code_expiration_datetime_16,
  t0.image_path AS image_path_17,
  t0.is_anonimized AS is_anonimized_18,
  t0.is_company_admin AS is_company_admin_19
FROM
  bee_s_staff t0
WHERE
  t0.email = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.phone AS phone_4, t0.email AS email_5, t0.password AS password_6, t0.directory_path AS directory_path_7, t0.role AS role_8, t0.emergency_contact_1 AS emergency_contact_1_9, t0.emergency_contact_2 AS emergency_contact_2_10, t0.is_admin_active AS is_admin_active_11, t0.is_active AS is_active_12, t0.is_tutorial_active AS is_tutorial_active_13, t0.datetime_creation AS datetime_creation_14, t0.one_time_code AS one_time_code_15, t0.one_time_code_expiration_datetime AS one_time_code_expiration_datetime_16, t0.image_path AS image_path_17, t0.is_anonimized AS is_anonimized_18, t0.is_company_admin AS is_company_admin_19 FROM bee_s_staff t0 WHERE t0.email = 'qc@slmmilano.com' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.message AS message_3,
  t0.staff_owner_id AS staff_owner_id_4,
  t0.performance_id AS performance_id_5
FROM
  bee_s_reminder t0
WHERE
  t0.staff_owner_id = ?
ORDER BY
  t0.date ASC

SELECT t0.id AS id_1, t0.date AS date_2, t0.message AS message_3, t0.staff_owner_id AS staff_owner_id_4, t0.performance_id AS performance_id_5 FROM bee_s_reminder t0 WHERE t0.staff_owner_id = '1' ORDER BY t0.date ASC;

SELECT
  b0_.id AS id_0,
  b0_.message_id AS message_id_1,
  b0_.staff_id AS staff_id_2
FROM
  bee_s_jt_performance_message_staff b0_
WHERE
  b0_.staff_id = ?
ORDER BY
  b0_.message_id DESC

SELECT b0_.id AS id_0, b0_.message_id AS message_id_1, b0_.staff_id AS staff_id_2 FROM bee_s_jt_performance_message_staff b0_ WHERE b0_.staff_id = '1' ORDER BY b0_.message_id DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.surname AS surname_3,
  t0.phone AS phone_4,
  t0.email AS email_5,
  t0.password AS password_6,
  t0.directory_path AS directory_path_7,
  t0.role AS role_8,
  t0.emergency_contact_1 AS emergency_contact_1_9,
  t0.emergency_contact_2 AS emergency_contact_2_10,
  t0.is_admin_active AS is_admin_active_11,
  t0.is_active AS is_active_12,
  t0.is_tutorial_active AS is_tutorial_active_13,
  t0.datetime_creation AS datetime_creation_14,
  t0.one_time_code AS one_time_code_15,
  t0.one_time_code_expiration_datetime AS one_time_code_expiration_datetime_16,
  t0.image_path AS image_path_17,
  t0.is_anonimized AS is_anonimized_18,
  t0.is_company_admin AS is_company_admin_19
FROM
  bee_s_staff t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.surname AS surname_3, t0.phone AS phone_4, t0.email AS email_5, t0.password AS password_6, t0.directory_path AS directory_path_7, t0.role AS role_8, t0.emergency_contact_1 AS emergency_contact_1_9, t0.emergency_contact_2 AS emergency_contact_2_10, t0.is_admin_active AS is_admin_active_11, t0.is_active AS is_active_12, t0.is_tutorial_active AS is_tutorial_active_13, t0.datetime_creation AS datetime_creation_14, t0.one_time_code AS one_time_code_15, t0.one_time_code_expiration_datetime AS one_time_code_expiration_datetime_16, t0.image_path AS image_path_17, t0.is_anonimized AS is_anonimized_18, t0.is_company_admin AS is_company_admin_19 FROM bee_s_staff t0 WHERE t0.id = '1' LIMIT 1;