Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs
• Events
• Routing
• Cache
• Translation
• Security
• Twig
• HTTP Client
• Doctrine
• Messages
• Emails
• Workflow
• Notifications
• Configuration

Query Metrics

SELECT t0.status_mode AS status_mode_1, t0.id AS id_2, t0.title AS title_3, t0.description AS description_4, t0.status AS status_5, t0.country AS country_6, t0.state AS state_7, t0.city AS city_8, t0.street_address AS street_address_9, t0.expiration_date AS expiration_date_10, t0.highlight AS highlight_11, t0.schedule AS schedule_12, t0.start_date AS start_date_13, t0.year_of_experience AS year_of_experience_14, t0.pay_rate AS pay_rate_15, t0.work_type AS work_type_16, t0.need AS need_17, t0.pay_rate_hourly AS pay_rate_hourly_18, t0.pay_rate_daily AS pay_rate_daily_19, t0.annual_salary AS annual_salary_20, t0.monthly_salary AS monthly_salary_21, t0.salary_type AS salary_type_22, t0.blocked AS blocked_23, t0.job_id AS job_id_24, t0.verified AS verified_25, t0.is_mediated AS is_mediated_26, t0.`rank` AS rank_27, t0.archived_at AS archived_at_28, t0.is_archived AS is_archived_29, t0.agency_payout_status AS agency_payout_status_30, t0.agency_payout_amount AS agency_payout_amount_31, t0.agency_payout_date AS agency_payout_date_32, t0.agency_payout_reference AS agency_payout_reference_33, t0.created_at AS created_at_34, t0.updated_at AS updated_at_35, t0.user_id AS user_id_36, t0.employer_id AS employer_id_37, t0.staffing_agency_id AS staffing_agency_id_38, t0.profession_id AS profession_id_39, t0.speciality_id AS speciality_id_40, t0.assigned_recruiter_id AS assigned_recruiter_id_41 FROM b_job t0 WHERE t0.status = ? ORDER BY t0.created_at DESC

[
  "published"
]

SELECT
  t0.status_mode AS status_mode_1,
  t0.id AS id_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.status AS status_5,
  t0.country AS country_6,
  t0.state AS state_7,
  t0.city AS city_8,
  t0.street_address AS street_address_9,
  t0.expiration_date AS expiration_date_10,
  t0.highlight AS highlight_11,
  t0.schedule AS schedule_12,
  t0.start_date AS start_date_13,
  t0.year_of_experience AS year_of_experience_14,
  t0.pay_rate AS pay_rate_15,
  t0.work_type AS work_type_16,
  t0.need AS need_17,
  t0.pay_rate_hourly AS pay_rate_hourly_18,
  t0.pay_rate_daily AS pay_rate_daily_19,
  t0.annual_salary AS annual_salary_20,
  t0.monthly_salary AS monthly_salary_21,
  t0.salary_type AS salary_type_22,
  t0.blocked AS blocked_23,
  t0.job_id AS job_id_24,
  t0.verified AS verified_25,
  t0.is_mediated AS is_mediated_26,
  t0.`rank` AS rank_27,
  t0.archived_at AS archived_at_28,
  t0.is_archived AS is_archived_29,
  t0.agency_payout_status AS agency_payout_status_30,
  t0.agency_payout_amount AS agency_payout_amount_31,
  t0.agency_payout_date AS agency_payout_date_32,
  t0.agency_payout_reference AS agency_payout_reference_33,
  t0.created_at AS created_at_34,
  t0.updated_at AS updated_at_35,
  t0.user_id AS user_id_36,
  t0.employer_id AS employer_id_37,
  t0.staffing_agency_id AS staffing_agency_id_38,
  t0.profession_id AS profession_id_39,
  t0.speciality_id AS speciality_id_40,
  t0.assigned_recruiter_id AS assigned_recruiter_id_41
FROM
  b_job t0
WHERE
  t0.status = ?
ORDER BY
  t0.created_at DESC

SELECT t0.status_mode AS status_mode_1, t0.id AS id_2, t0.title AS title_3, t0.description AS description_4, t0.status AS status_5, t0.country AS country_6, t0.state AS state_7, t0.city AS city_8, t0.street_address AS street_address_9, t0.expiration_date AS expiration_date_10, t0.highlight AS highlight_11, t0.schedule AS schedule_12, t0.start_date AS start_date_13, t0.year_of_experience AS year_of_experience_14, t0.pay_rate AS pay_rate_15, t0.work_type AS work_type_16, t0.need AS need_17, t0.pay_rate_hourly AS pay_rate_hourly_18, t0.pay_rate_daily AS pay_rate_daily_19, t0.annual_salary AS annual_salary_20, t0.monthly_salary AS monthly_salary_21, t0.salary_type AS salary_type_22, t0.blocked AS blocked_23, t0.job_id AS job_id_24, t0.verified AS verified_25, t0.is_mediated AS is_mediated_26, t0.`rank` AS rank_27, t0.archived_at AS archived_at_28, t0.is_archived AS is_archived_29, t0.agency_payout_status AS agency_payout_status_30, t0.agency_payout_amount AS agency_payout_amount_31, t0.agency_payout_date AS agency_payout_date_32, t0.agency_payout_reference AS agency_payout_reference_33, t0.created_at AS created_at_34, t0.updated_at AS updated_at_35, t0.user_id AS user_id_36, t0.employer_id AS employer_id_37, t0.staffing_agency_id AS staffing_agency_id_38, t0.profession_id AS profession_id_39, t0.speciality_id AS speciality_id_40, t0.assigned_recruiter_id AS assigned_recruiter_id_41 FROM b_job t0 WHERE t0.status = 'published' ORDER BY t0.created_at DESC;

SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3 FROM b_profession t0 ORDER BY t0.position ASC

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.position AS position_3
FROM
  b_profession t0
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3 FROM b_profession t0 ORDER BY t0.position ASC;

SELECT t0.id AS id_1, t0.name AS name_2, t0.profession_id AS profession_id_3 FROM b_speciality t0 ORDER BY t0.name ASC

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.profession_id AS profession_id_3
FROM
  b_speciality t0
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.profession_id AS profession_id_3 FROM b_speciality t0 ORDER BY t0.name ASC;

SELECT t0.id AS id_1, t0.config_key AS config_key_2, t0.config_value AS config_value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM b_config t0

[]

SELECT
  t0.id AS id_1,
  t0.config_key AS config_key_2,
  t0.config_value AS config_value_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5
FROM
  b_config t0

SELECT t0.id AS id_1, t0.config_key AS config_key_2, t0.config_value AS config_value_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM b_config t0;

SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3 FROM b_profession t0 ORDER BY t0.position ASC

[]

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.position AS position_3
FROM
  b_profession t0
ORDER BY
  t0.position ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3 FROM b_profession t0 ORDER BY t0.position ASC;