Symfony Profiler

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          DISTINCT b0_.id AS id_0,
          b0_.title AS title_1,
          b0_.description AS description_2,
          b0_.status AS status_3,
          b0_.country AS country_4,
          b0_.state AS state_5,
          b0_.city AS city_6,
          b0_.street_address AS street_address_7,
          b0_.expiration_date AS expiration_date_8,
          b0_.highlight AS highlight_9,
          b0_.schedule AS schedule_10,
          b0_.start_date AS start_date_11,
          b0_.year_of_experience AS year_of_experience_12,
          b0_.pay_rate AS pay_rate_13,
          b0_.work_type AS work_type_14,
          b0_.need AS need_15,
          b0_.pay_rate_hourly AS pay_rate_hourly_16,
          b0_.pay_rate_daily AS pay_rate_daily_17,
          b0_.annual_salary AS annual_salary_18,
          b0_.monthly_salary AS monthly_salary_19,
          b0_.salary_type AS salary_type_20,
          b0_.blocked AS blocked_21,
          b0_.job_id AS job_id_22,
          b0_.verified AS verified_23,
          b0_.is_mediated AS is_mediated_24,
          b0_.`rank` AS rank_25,
          b0_.created_at AS created_at_26,
          b0_.updated_at AS updated_at_27,
          b1_.id AS id_28,
          b1_.status AS status_29,
          b1_.commission_rate AS commission_rate_30,
          b1_.assigned_at AS assigned_at_31,
          b2_.id AS id_32,
          b2_.status AS status_33,
          b2_.applied_at AS applied_at_34,
          b2_.hired_at AS hired_at_35,
          b2_.document_requested_at AS document_requested_at_36,
          b2_.document_provided_at AS document_provided_at_37,
          b2_.one_file_requested_at AS one_file_requested_at_38,
          b2_.one_file_provided_at AS one_file_provided_at_39,
          b2_.contract_sent_at AS contract_sent_at_40,
          b2_.contract_file_name AS contract_file_name_41,
          b2_.contract_signed_at AS contract_signed_at_42,
          b2_.contract_signed_file_name AS contract_signed_file_name_43,
          b2_.`rank` AS rank_44,
          b2_.archived_at AS archived_at_45,
          b2_.is_archived AS is_archived_46,
          b2_.created_at AS created_at_47,
          b2_.updated_at AS updated_at_48
        FROM
          b_job b0_
          LEFT JOIN b_job_recruiter b1_ ON (b1_.job_id = b0_.id)
          LEFT JOIN b_application b2_ ON (b2_.job_id = b0_.id)
        WHERE
          1 = 1
          AND b0_.blocked = ?
          AND b0_.verified = ?
          AND b0_.status = ?
      ) dctrn_result_inner
    ORDER BY
      id_0 DESC
  ) dctrn_result
LIMIT
  25
OFFSET
  100

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT DISTINCT b0_.id AS id_0, b0_.title AS title_1, b0_.description AS description_2, b0_.status AS status_3, b0_.country AS country_4, b0_.state AS state_5, b0_.city AS city_6, b0_.street_address AS street_address_7, b0_.expiration_date AS expiration_date_8, b0_.highlight AS highlight_9, b0_.schedule AS schedule_10, b0_.start_date AS start_date_11, b0_.year_of_experience AS year_of_experience_12, b0_.pay_rate AS pay_rate_13, b0_.work_type AS work_type_14, b0_.need AS need_15, b0_.pay_rate_hourly AS pay_rate_hourly_16, b0_.pay_rate_daily AS pay_rate_daily_17, b0_.annual_salary AS annual_salary_18, b0_.monthly_salary AS monthly_salary_19, b0_.salary_type AS salary_type_20, b0_.blocked AS blocked_21, b0_.job_id AS job_id_22, b0_.verified AS verified_23, b0_.is_mediated AS is_mediated_24, b0_.`rank` AS rank_25, b0_.created_at AS created_at_26, b0_.updated_at AS updated_at_27, b1_.id AS id_28, b1_.status AS status_29, b1_.commission_rate AS commission_rate_30, b1_.assigned_at AS assigned_at_31, b2_.id AS id_32, b2_.status AS status_33, b2_.applied_at AS applied_at_34, b2_.hired_at AS hired_at_35, b2_.document_requested_at AS document_requested_at_36, b2_.document_provided_at AS document_provided_at_37, b2_.one_file_requested_at AS one_file_requested_at_38, b2_.one_file_provided_at AS one_file_provided_at_39, b2_.contract_sent_at AS contract_sent_at_40, b2_.contract_file_name AS contract_file_name_41, b2_.contract_signed_at AS contract_signed_at_42, b2_.contract_signed_file_name AS contract_signed_file_name_43, b2_.`rank` AS rank_44, b2_.archived_at AS archived_at_45, b2_.is_archived AS is_archived_46, b2_.created_at AS created_at_47, b2_.updated_at AS updated_at_48 FROM b_job b0_ LEFT JOIN b_job_recruiter b1_ ON (b1_.job_id = b0_.id) LEFT JOIN b_application b2_ ON (b2_.job_id = b0_.id) WHERE 1 = 1 AND b0_.blocked = 0 AND b0_.verified = 1 AND b0_.status = 'published') dctrn_result_inner ORDER BY id_0 DESC) dctrn_result LIMIT 25 OFFSET 100;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          DISTINCT b0_.id AS id_0,
          b0_.title AS title_1,
          b0_.description AS description_2,
          b0_.status AS status_3,
          b0_.country AS country_4,
          b0_.state AS state_5,
          b0_.city AS city_6,
          b0_.street_address AS street_address_7,
          b0_.expiration_date AS expiration_date_8,
          b0_.highlight AS highlight_9,
          b0_.schedule AS schedule_10,
          b0_.start_date AS start_date_11,
          b0_.year_of_experience AS year_of_experience_12,
          b0_.pay_rate AS pay_rate_13,
          b0_.work_type AS work_type_14,
          b0_.need AS need_15,
          b0_.pay_rate_hourly AS pay_rate_hourly_16,
          b0_.pay_rate_daily AS pay_rate_daily_17,
          b0_.annual_salary AS annual_salary_18,
          b0_.monthly_salary AS monthly_salary_19,
          b0_.salary_type AS salary_type_20,
          b0_.blocked AS blocked_21,
          b0_.job_id AS job_id_22,
          b0_.verified AS verified_23,
          b0_.is_mediated AS is_mediated_24,
          b0_.`rank` AS rank_25,
          b0_.created_at AS created_at_26,
          b0_.updated_at AS updated_at_27
        FROM
          b_job b0_
          LEFT JOIN b_job_recruiter b1_ ON (b1_.job_id = b0_.id)
          LEFT JOIN b_application b2_ ON (b2_.job_id = b0_.id)
        WHERE
          1 = 1
          AND b0_.blocked = ?
          AND b0_.verified = ?
          AND b0_.status = ?
        ORDER BY
          b0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT DISTINCT b0_.id AS id_0, b0_.title AS title_1, b0_.description AS description_2, b0_.status AS status_3, b0_.country AS country_4, b0_.state AS state_5, b0_.city AS city_6, b0_.street_address AS street_address_7, b0_.expiration_date AS expiration_date_8, b0_.highlight AS highlight_9, b0_.schedule AS schedule_10, b0_.start_date AS start_date_11, b0_.year_of_experience AS year_of_experience_12, b0_.pay_rate AS pay_rate_13, b0_.work_type AS work_type_14, b0_.need AS need_15, b0_.pay_rate_hourly AS pay_rate_hourly_16, b0_.pay_rate_daily AS pay_rate_daily_17, b0_.annual_salary AS annual_salary_18, b0_.monthly_salary AS monthly_salary_19, b0_.salary_type AS salary_type_20, b0_.blocked AS blocked_21, b0_.job_id AS job_id_22, b0_.verified AS verified_23, b0_.is_mediated AS is_mediated_24, b0_.`rank` AS rank_25, b0_.created_at AS created_at_26, b0_.updated_at AS updated_at_27 FROM b_job b0_ LEFT JOIN b_job_recruiter b1_ ON (b1_.job_id = b0_.id) LEFT JOIN b_application b2_ ON (b2_.job_id = b0_.id) WHERE 1 = 1 AND b0_.blocked = 0 AND b0_.verified = 1 AND b0_.status = 'published' ORDER BY b0_.id DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT b0_.id AS id_0,
  b0_.title AS title_1,
  b0_.description AS description_2,
  b0_.status AS status_3,
  b0_.country AS country_4,
  b0_.state AS state_5,
  b0_.city AS city_6,
  b0_.street_address AS street_address_7,
  b0_.expiration_date AS expiration_date_8,
  b0_.highlight AS highlight_9,
  b0_.schedule AS schedule_10,
  b0_.start_date AS start_date_11,
  b0_.year_of_experience AS year_of_experience_12,
  b0_.pay_rate AS pay_rate_13,
  b0_.work_type AS work_type_14,
  b0_.need AS need_15,
  b0_.pay_rate_hourly AS pay_rate_hourly_16,
  b0_.pay_rate_daily AS pay_rate_daily_17,
  b0_.annual_salary AS annual_salary_18,
  b0_.monthly_salary AS monthly_salary_19,
  b0_.salary_type AS salary_type_20,
  b0_.blocked AS blocked_21,
  b0_.job_id AS job_id_22,
  b0_.verified AS verified_23,
  b0_.is_mediated AS is_mediated_24,
  b0_.`rank` AS rank_25,
  b0_.created_at AS created_at_26,
  b0_.updated_at AS updated_at_27,
  b0_.user_id AS user_id_28,
  b0_.employer_id AS employer_id_29,
  b0_.profession_id AS profession_id_30,
  b0_.speciality_id AS speciality_id_31,
  b0_.assigned_recruiter_id AS assigned_recruiter_id_32
FROM
  b_job b0_
  LEFT JOIN b_job_recruiter b1_ ON (b1_.job_id = b0_.id)
  LEFT JOIN b_application b2_ ON (b2_.job_id = b0_.id)
WHERE
  1 = 1
  AND b0_.blocked = ?
  AND b0_.verified = ?
  AND b0_.status = ?
  AND b0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  b0_.id DESC

SELECT DISTINCT b0_.id AS id_0, b0_.title AS title_1, b0_.description AS description_2, b0_.status AS status_3, b0_.country AS country_4, b0_.state AS state_5, b0_.city AS city_6, b0_.street_address AS street_address_7, b0_.expiration_date AS expiration_date_8, b0_.highlight AS highlight_9, b0_.schedule AS schedule_10, b0_.start_date AS start_date_11, b0_.year_of_experience AS year_of_experience_12, b0_.pay_rate AS pay_rate_13, b0_.work_type AS work_type_14, b0_.need AS need_15, b0_.pay_rate_hourly AS pay_rate_hourly_16, b0_.pay_rate_daily AS pay_rate_daily_17, b0_.annual_salary AS annual_salary_18, b0_.monthly_salary AS monthly_salary_19, b0_.salary_type AS salary_type_20, b0_.blocked AS blocked_21, b0_.job_id AS job_id_22, b0_.verified AS verified_23, b0_.is_mediated AS is_mediated_24, b0_.`rank` AS rank_25, b0_.created_at AS created_at_26, b0_.updated_at AS updated_at_27, b0_.user_id AS user_id_28, b0_.employer_id AS employer_id_29, b0_.profession_id AS profession_id_30, b0_.speciality_id AS speciality_id_31, b0_.assigned_recruiter_id AS assigned_recruiter_id_32 FROM b_job b0_ LEFT JOIN b_job_recruiter b1_ ON (b1_.job_id = b0_.id) LEFT JOIN b_application b2_ ON (b2_.job_id = b0_.id) WHERE 1 = 1 AND b0_.blocked = 0 AND b0_.verified = 1 AND b0_.status = 'published' AND b0_.id IN (0x0196D8BE37E27FAE8328FE59BB17D5AE, 0x0196D8BE37E1754C8713219988BA7C0E, 0x0196D8BE37E1754C871321998818510C, 0x0196D8BE37E1754C8713219987AB3D8F, 0x0196D8BE37E07BFDB5EDD6F817D9005E, 0x0196D8BE37E07BFDB5EDD6F817A9E619, 0x0196D8BE37DF7FF298C2E0F64D0DE381, 0x0196D8BE37DF7FF298C2E0F64C20E4F9, 0x0196D8BE37DF7FF298C2E0F64B8D4708, 0x0196D8BE37D373D6A69543DFA8F8AAC3) ORDER BY b0_.id DESC;

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.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.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;