Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.unique_id AS unique_id_2,
  t0.fullname AS fullname_3,
  t0.birth_date AS birth_date_4,
  t0.joined_date AS joined_date_5,
  t0.contract_end AS contract_end_6,
  t0.profile_picture_uploaded AS profile_picture_uploaded_7,
  t0.cv_last_updated_at AS cv_last_updated_at_8,
  t0.email AS email_9,
  t0.existing_aramco_id AS existing_aramco_id_10,
  t0.aramco_id AS aramco_id_11,
  t0.aramco_id_expiry_date AS aramco_id_expiry_date_12,
  t0.status_id AS status_id_13,
  t0.rotation_id AS rotation_id_14,
  t0.nationality_id AS nationality_id_15,
  t0.company_id AS company_id_16,
  t0.location_id AS location_id_17,
  t0.driving_license_id AS driving_license_id_18,
  t0.position_id AS position_id_19,
  t0.grade_id AS grade_id_20,
  t0.aramco_id_status_id AS aramco_id_status_id_21
FROM
  employee t0
WHERE
  t0.unique_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.unique_id AS unique_id_2, t0.fullname AS fullname_3, t0.birth_date AS birth_date_4, t0.joined_date AS joined_date_5, t0.contract_end AS contract_end_6, t0.profile_picture_uploaded AS profile_picture_uploaded_7, t0.cv_last_updated_at AS cv_last_updated_at_8, t0.email AS email_9, t0.existing_aramco_id AS existing_aramco_id_10, t0.aramco_id AS aramco_id_11, t0.aramco_id_expiry_date AS aramco_id_expiry_date_12, t0.status_id AS status_id_13, t0.rotation_id AS rotation_id_14, t0.nationality_id AS nationality_id_15, t0.company_id AS company_id_16, t0.location_id AS location_id_17, t0.driving_license_id AS driving_license_id_18, t0.position_id AS position_id_19, t0.grade_id AS grade_id_20, t0.aramco_id_status_id AS aramco_id_status_id_21 FROM employee t0 WHERE t0.unique_id = '15094' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.orange_period AS orange_period_3,
  t0.red_period AS red_period_4
FROM
  certificate t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.orange_period AS orange_period_3, t0.red_period AS red_period_4 FROM certificate t0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ordering AS ordering_3,
  t0.type_id AS type_id_4
FROM
  position t0
  INNER JOIN certificate_position ON t0.id = certificate_position.position_id
WHERE
  certificate_position.certificate_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ordering AS ordering_3,
  t0.type_id AS type_id_4
FROM
  position t0
  INNER JOIN certificate_position ON t0.id = certificate_position.position_id
WHERE
  certificate_position.certificate_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = 2;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ordering AS ordering_3,
  t0.type_id AS type_id_4
FROM
  position t0
  INNER JOIN certificate_position ON t0.id = certificate_position.position_id
WHERE
  certificate_position.certificate_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.orange_period AS orange_period_3,
  t0.red_period AS red_period_4
FROM
  certificate t0
  INNER JOIN certificate_position ON t0.id = certificate_position.certificate_id
WHERE
  certificate_position.position_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.orange_period AS orange_period_3, t0.red_period AS red_period_4 FROM certificate t0 INNER JOIN certificate_position ON t0.id = certificate_position.certificate_id WHERE certificate_position.position_id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ordering AS ordering_3,
  t0.type_id AS type_id_4
FROM
  position t0
  INNER JOIN certificate_position ON t0.id = certificate_position.position_id
WHERE
  certificate_position.certificate_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ordering AS ordering_3,
  t0.type_id AS type_id_4
FROM
  position t0
  INNER JOIN certificate_position ON t0.id = certificate_position.position_id
WHERE
  certificate_position.certificate_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = 5;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ordering AS ordering_3,
  t0.type_id AS type_id_4
FROM
  position t0
  INNER JOIN certificate_position ON t0.id = certificate_position.position_id
WHERE
  certificate_position.certificate_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = 6;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ordering AS ordering_3,
  t0.type_id AS type_id_4
FROM
  position t0
  INNER JOIN certificate_position ON t0.id = certificate_position.position_id
WHERE
  certificate_position.certificate_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = 7;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ordering AS ordering_3,
  t0.type_id AS type_id_4
FROM
  position t0
  INNER JOIN certificate_position ON t0.id = certificate_position.position_id
WHERE
  certificate_position.certificate_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = 8;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ordering AS ordering_3,
  t0.type_id AS type_id_4
FROM
  position t0
  INNER JOIN certificate_position ON t0.id = certificate_position.position_id
WHERE
  certificate_position.certificate_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = 9;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ordering AS ordering_3,
  t0.type_id AS type_id_4
FROM
  position t0
  INNER JOIN certificate_position ON t0.id = certificate_position.position_id
WHERE
  certificate_position.certificate_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = 10;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.ordering AS ordering_3,
  t0.type_id AS type_id_4
FROM
  position t0
  INNER JOIN certificate_position ON t0.id = certificate_position.position_id
WHERE
  certificate_position.certificate_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.ordering AS ordering_3, t0.type_id AS type_id_4 FROM position t0 INNER JOIN certificate_position ON t0.id = certificate_position.position_id WHERE certificate_position.certificate_id = 11;

SELECT
  t0.id AS id_1,
  t0.name_en AS name_en_2,
  t0.name_fr AS name_fr_3,
  t0.name_ar AS name_ar_4,
  t0.alpha2 AS alpha2_5,
  t0.alpha3 AS alpha3_6
FROM
  nation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name_en AS name_en_2, t0.name_fr AS name_fr_3, t0.name_ar AS name_ar_4, t0.alpha2 AS alpha2_5, t0.alpha3 AS alpha3_6 FROM nation t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  company t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM company t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.country_id AS country_id_2
FROM
  location t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.country_id AS country_id_2 FROM location t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.name_en AS name_en_2,
  t0.name_fr AS name_fr_3,
  t0.name_ar AS name_ar_4,
  t0.alpha2 AS alpha2_5,
  t0.alpha3 AS alpha3_6
FROM
  nation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name_en AS name_en_2, t0.name_fr AS name_fr_3, t0.name_ar AS name_ar_4, t0.alpha2 AS alpha2_5, t0.alpha3 AS alpha3_6 FROM nation t0 WHERE t0.id = 14;

SELECT
  t0.id AS id_1,
  t0.label AS label_2,
  t0.abbr AS abbr_3
FROM
  STATUS t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2, t0.abbr AS abbr_3 FROM STATUS t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.duty AS duty_2,
  t0.rest AS rest_3
FROM
  rotation t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.duty AS duty_2, t0.rest AS rest_3 FROM rotation t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  position_type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM position_type t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.label AS label_2
FROM
  position_grade t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.label AS label_2 FROM position_grade t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.expiry_date AS expiry_date_2,
  t0.certificate_id AS certificate_id_3,
  t0.employee_id AS employee_id_4
FROM
  training t0
WHERE
  t0.employee_id = ?

SELECT t0.id AS id_1, t0.expiry_date AS expiry_date_2, t0.certificate_id AS certificate_id_3, t0.employee_id AS employee_id_4 FROM training t0 WHERE t0.employee_id = 76;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.employee_id AS employee_id_3,
  t0.result_id AS result_id_4
FROM
  medical_check t0
WHERE
  t0.employee_id = ?

SELECT t0.id AS id_1, t0.date AS date_2, t0.employee_id AS employee_id_3, t0.result_id AS result_id_4 FROM medical_check t0 WHERE t0.employee_id = 76;