Symfony Profiler

SELECT
  e.id AS execution_id,
  e.execution_scope AS scope,
  CASE WHEN e.execution_scope = 'internal' THEN e.branch_contact_person_id ELSE e.vendor_contact_person_id END AS contact_person_id,
  t.title AS task_title,
  o.order_nr AS order_nr,
  e.planned_start_at AS planned_start_at,
  e.planned_end_at AS planned_end_at,
  e.cost AS cost,
  b.name AS branch_name,
  v.name AS vendor_name,
  TRIM(
    CONCAT(
      COALESCE(w.name, ''),
      ' ',
      COALESCE(w.surname, '')
    )
  ) AS branch_contact_name,
  TRIM(
    CONCAT(
      COALESCE(vcp.name, ''),
      ' ',
      COALESCE(vcp.surname, '')
    )
  ) AS vendor_contact_name,
  (
    SELECT
      COUNT(*)
    FROM
      project_order_task_fulfillment_messages m
    WHERE
      m.execution_id = e.id
      AND m.sender_side = ?
      AND (
        e.owner_last_read_at IS NULL
        OR m.created_at > e.owner_last_read_at
      )
  ) AS owner_unread
FROM
  project_order_task_fulfillment e
  INNER JOIN project_order_tasks t ON t.id = e.task_id
  INNER JOIN project_orders o ON o.id = t.project_order_id
  LEFT JOIN branches b ON b.id = e.branch_id
  LEFT JOIN vendor v ON v.id = e.vendor_id
  LEFT JOIN worker_activities wa ON wa.id = e.branch_contact_person_id
  LEFT JOIN worker w ON w.id = wa.worker_id
  LEFT JOIN vendor_contact_persons vcp ON vcp.id = e.vendor_contact_person_id
WHERE
  e.published_at IS NOT NULL
  AND (
    o.order_primary_lead_id = ?
    OR o.order_primary_lead_id IN (
      SELECT
        wa.id
      FROM
        worker_activities wa
      WHERE
        wa.worker_id = ?
    )
  )

SELECT
                e.id AS execution_id,
                e.execution_scope AS scope,
                CASE WHEN e.execution_scope = 'internal' THEN e.branch_contact_person_id ELSE e.vendor_contact_person_id END AS contact_person_id,
                t.title AS task_title,
                o.order_nr AS order_nr,
                e.planned_start_at AS planned_start_at,
                e.planned_end_at AS planned_end_at,
                e.cost AS cost,
                b.name AS branch_name,
                v.name AS vendor_name,
                TRIM(CONCAT(COALESCE(w.name, ''), ' ', COALESCE(w.surname, ''))) AS branch_contact_name,
                TRIM(CONCAT(COALESCE(vcp.name, ''), ' ', COALESCE(vcp.surname, ''))) AS vendor_contact_name,
                (SELECT COUNT(*) FROM project_order_task_fulfillment_messages m WHERE m.execution_id = e.id AND m.sender_side = 'executor' AND (e.owner_last_read_at IS NULL OR m.created_at > e.owner_last_read_at)) AS owner_unread
            FROM project_order_task_fulfillment e
            INNER JOIN project_order_tasks t ON t.id = e.task_id
            INNER JOIN project_orders o ON o.id = t.project_order_id
            LEFT JOIN branches b ON b.id = e.branch_id
            LEFT JOIN vendor v ON v.id = e.vendor_id
            LEFT JOIN worker_activities wa ON wa.id = e.branch_contact_person_id
            LEFT JOIN worker w ON w.id = wa.worker_id
            LEFT JOIN vendor_contact_persons vcp ON vcp.id = e.vendor_contact_person_id
            WHERE e.published_at IS NOT NULL
              AND (
                  o.order_primary_lead_id = 91
                  OR o.order_primary_lead_id IN (SELECT wa.id FROM worker_activities wa WHERE wa.worker_id = 115)
              );

SELECT
  t0.id AS id_1,
  t0.module_key AS module_key_2,
  t0.module_display_name AS module_display_name_3,
  t0.manageable_actions AS manageable_actions_4,
  t0.access_module_role AS access_module_role_5
FROM
  access_modules t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.module_key AS module_key_2, t0.module_display_name AS module_display_name_3, t0.manageable_actions AS manageable_actions_4, t0.access_module_role AS access_module_role_5 FROM access_modules t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.name AS name_5,
  t0.surname AS surname_6,
  t0.login_refused AS login_refused_7,
  t0.login_refused_message AS login_refused_message_8,
  t0.invisible_since AS invisible_since_9,
  t0.is_password_updated_at AS is_password_updated_at_10,
  t0.news_last_seen_at AS news_last_seen_at_11,
  t0.idle_timer_timeout AS idle_timer_timeout_12,
  t0.notification_preferences AS notification_preferences_13,
  t0.ui_preferences AS ui_preferences_14,
  t0.email_signature AS email_signature_15,
  t16.id AS id_17,
  t16.name AS name_18,
  t16.surname AS surname_19,
  t16.entry_at AS entry_at_20,
  t16.exit_at AS exit_at_21,
  t16.birthday_at AS birthday_at_22,
  t16.slug AS slug_23,
  t16.daily_work_time AS daily_work_time_24,
  t16.cost_per_hour AS cost_per_hour_25,
  t16.personal_id AS personal_id_26,
  t16.created_at AS created_at_27,
  t16.phone_number AS phone_number_28,
  t16.social_insurance_number AS social_insurance_number_29,
  t16.uiid AS uiid_30,
  t16.profile_image AS profile_image_31,
  t16.email AS email_32,
  t16.default_qualification_id AS default_qualification_id_33,
  t16.user_id AS user_id_34,
  t0.user_position_id AS user_position_id_35
FROM
  user t0
  LEFT JOIN worker t16 ON t16.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.name AS name_5, t0.surname AS surname_6, t0.login_refused AS login_refused_7, t0.login_refused_message AS login_refused_message_8, t0.invisible_since AS invisible_since_9, t0.is_password_updated_at AS is_password_updated_at_10, t0.news_last_seen_at AS news_last_seen_at_11, t0.idle_timer_timeout AS idle_timer_timeout_12, t0.notification_preferences AS notification_preferences_13, t0.ui_preferences AS ui_preferences_14, t0.email_signature AS email_signature_15, t16.id AS id_17, t16.name AS name_18, t16.surname AS surname_19, t16.entry_at AS entry_at_20, t16.exit_at AS exit_at_21, t16.birthday_at AS birthday_at_22, t16.slug AS slug_23, t16.daily_work_time AS daily_work_time_24, t16.cost_per_hour AS cost_per_hour_25, t16.personal_id AS personal_id_26, t16.created_at AS created_at_27, t16.phone_number AS phone_number_28, t16.social_insurance_number AS social_insurance_number_29, t16.uiid AS uiid_30, t16.profile_image AS profile_image_31, t16.email AS email_32, t16.default_qualification_id AS default_qualification_id_33, t16.user_id AS user_id_34, t0.user_position_id AS user_position_id_35 FROM user t0 LEFT JOIN worker t16 ON t16.user_id = t0.id WHERE t0.id = 13;

SELECT
  t0.id AS id_1,
  t0.r AS r_2,
  t0.c AS c_3,
  t0.u AS u_4,
  t0.d AS d_5,
  t0.access_module_id AS access_module_id_6,
  t0.user_id AS user_id_7
FROM
  user_module_permissions t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.r AS r_2, t0.c AS c_3, t0.u AS u_4, t0.d AS d_5, t0.access_module_id AS access_module_id_6, t0.user_id AS user_id_7 FROM user_module_permissions t0 WHERE t0.user_id = 13;

SELECT
  t0.id AS id_1,
  t0.entry_at AS entry_at_2,
  t0.exit_at AS exit_at_3,
  t0.created_at AS created_at_4,
  t0.guest AS guest_5,
  t0.is_kpi_responsible AS is_kpi_responsible_6,
  t0.termination_reason AS termination_reason_7,
  t0.hourly_rate AS hourly_rate_8,
  t0.daily_working_hours AS daily_working_hours_9,
  t0.worker_id AS worker_id_10,
  t0.partner_id AS partner_id_11,
  t0.user_id AS user_id_12
FROM
  worker_activities t0
WHERE
  t0.user_id = ?
ORDER BY
  t0.id ASC

SELECT t0.id AS id_1, t0.entry_at AS entry_at_2, t0.exit_at AS exit_at_3, t0.created_at AS created_at_4, t0.guest AS guest_5, t0.is_kpi_responsible AS is_kpi_responsible_6, t0.termination_reason AS termination_reason_7, t0.hourly_rate AS hourly_rate_8, t0.daily_working_hours AS daily_working_hours_9, t0.worker_id AS worker_id_10, t0.partner_id AS partner_id_11, t0.user_id AS user_id_12 FROM worker_activities t0 WHERE t0.user_id = 13 ORDER BY t0.id ASC;

SELECT
  t0.id AS id_1,
  t0.r AS r_2,
  t0.u AS u_3,
  t0.access_module_section_id AS access_module_section_id_4,
  t0.user_module_permissions_id AS user_module_permissions_id_5
FROM
  user_module_section_permissions t0
WHERE
  t0.user_module_permissions_id = ?

SELECT t0.id AS id_1, t0.r AS r_2, t0.u AS u_3, t0.access_module_section_id AS access_module_section_id_4, t0.user_module_permissions_id AS user_module_permissions_id_5 FROM user_module_section_permissions t0 WHERE t0.user_module_permissions_id = 45;