Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 3
• Events
• Routing
• Cache
• Translation 29
• Security
• Twig
• Doctrine
• Emails
• Serializer
• Blocks* 0
• Configuration

Query Metrics

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.id = ?

[
  "48"
]

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.id = ?

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.id = '48';

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

[
  2
]

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

SELECT t0.id AS id_1, t0.label AS label_2 FROM aramco_id_status 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 = ?

[
  227
]

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 = 227;

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.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 = ?

[
  1
]

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 = 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 WHERE t0.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
WHERE
  t0.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 WHERE t0.id = 4;

SELECT a0_.id AS id_0, a0_.label AS label_1 FROM aramco_id_status a0_

[]

SELECT
  a0_.id AS id_0,
  a0_.label AS label_1
FROM
  aramco_id_status a0_

SELECT a0_.id AS id_0, a0_.label AS label_1 FROM aramco_id_status a0_;

SELECT n0_.id AS id_0, n0_.name_en AS name_en_1, n0_.name_fr AS name_fr_2, n0_.name_ar AS name_ar_3, n0_.alpha2 AS alpha2_4, n0_.alpha3 AS alpha3_5 FROM nation n0_

[]

SELECT
  n0_.id AS id_0,
  n0_.name_en AS name_en_1,
  n0_.name_fr AS name_fr_2,
  n0_.name_ar AS name_ar_3,
  n0_.alpha2 AS alpha2_4,
  n0_.alpha3 AS alpha3_5
FROM
  nation n0_

SELECT n0_.id AS id_0, n0_.name_en AS name_en_1, n0_.name_fr AS name_fr_2, n0_.name_ar AS name_ar_3, n0_.alpha2 AS alpha2_4, n0_.alpha3 AS alpha3_5 FROM nation n0_;

SELECT c0_.id AS id_0, c0_.name AS name_1 FROM company c0_

[]

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1
FROM
  company c0_

SELECT c0_.id AS id_0, c0_.name AS name_1 FROM company c0_;

SELECT l0_.id AS id_0, l0_.country_id AS country_id_1 FROM location l0_

[]

SELECT
  l0_.id AS id_0,
  l0_.country_id AS country_id_1
FROM
  location l0_

SELECT l0_.id AS id_0, l0_.country_id AS country_id_1 FROM location l0_;

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.ordering AS ordering_2, p0_.type_id AS type_id_3 FROM position p0_

[]

SELECT
  p0_.id AS id_0,
  p0_.name AS name_1,
  p0_.ordering AS ordering_2,
  p0_.type_id AS type_id_3
FROM
  position p0_

SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.ordering AS ordering_2, p0_.type_id AS type_id_3 FROM position p0_;

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

[
  1
]

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 = 1;

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.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.name AS name_2 FROM position_type 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 = 3;

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

[
  4
]

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 = 4;