Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          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_.blocked AS blocked_18,
          b0_.job_id AS job_id_19,
          b0_.verified AS verified_20,
          b0_.created_at AS created_at_21,
          b0_.updated_at AS updated_at_22
        FROM
          b_job b0_
        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 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_.blocked AS blocked_18, b0_.job_id AS job_id_19, b0_.verified AS verified_20, b0_.created_at AS created_at_21, b0_.updated_at AS updated_at_22 FROM b_job b0_ 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 id_0
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          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_.blocked AS blocked_18,
          b0_.job_id AS job_id_19,
          b0_.verified AS verified_20,
          b0_.created_at AS created_at_21,
          b0_.updated_at AS updated_at_22
        FROM
          b_job b0_
        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
  75

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0 FROM (SELECT 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_.blocked AS blocked_18, b0_.job_id AS job_id_19, b0_.verified AS verified_20, b0_.created_at AS created_at_21, b0_.updated_at AS updated_at_22 FROM b_job b0_ 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 75;

SELECT
  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_.blocked AS blocked_18,
  b0_.job_id AS job_id_19,
  b0_.verified AS verified_20,
  b0_.created_at AS created_at_21,
  b0_.updated_at AS updated_at_22,
  b0_.user_id AS user_id_23,
  b0_.employer_id AS employer_id_24,
  b0_.profession_id AS profession_id_25,
  b0_.speciality_id AS speciality_id_26
FROM
  b_job b0_
WHERE
  1 = 1
  AND b0_.blocked = ?
  AND b0_.verified = ?
  AND b0_.status = ?
  AND b0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  b0_.id DESC

SELECT 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_.blocked AS blocked_18, b0_.job_id AS job_id_19, b0_.verified AS verified_20, b0_.created_at AS created_at_21, b0_.updated_at AS updated_at_22, b0_.user_id AS user_id_23, b0_.employer_id AS employer_id_24, b0_.profession_id AS profession_id_25, b0_.speciality_id AS speciality_id_26 FROM b_job b0_ WHERE 1 = 1 AND b0_.blocked = 0 AND b0_.verified = 1 AND b0_.status = 'published' AND b0_.id IN (0x0196D8BE3807782B97256A9A050C5DF0, 0x0196D8BE3807782B97256A9A05098069, 0x0196D8BE38067B5E942767F07946EEB5, 0x0196D8BE38067B5E942767F078970AB0, 0x0196D8BE38067B5E942767F077CF42AA, 0x0196D8BE38057026A24B091AFD99EF8A, 0x0196D8BE38057026A24B091AFCDCAAF2, 0x0196D8BE37F57127B0814262F2026D70, 0x0196D8BE37F57127B0814262F1B1CBFD, 0x0196D8BE37F47CC8AFCA53C370D448CB, 0x0196D8BE37F47CC8AFCA53C3703A1630, 0x0196D8BE37F47CC8AFCA53C37029F25D, 0x0196D8BE37F37A11A211C80C178F88EE, 0x0196D8BE37F37A11A211C80C172CFC53, 0x0196D8BE37F37A11A211C80C166149C8, 0x0196D8BE37F27C388583FE2730E63078, 0x0196D8BE37F27C388583FE2730818FD9, 0x0196D8BE37E27FAE8328FE59BC00A8B3, 0x0196D8BE37E27FAE8328FE59BB17D5AE, 0x0196D8BE37E1754C8713219988BA7C0E, 0x0196D8BE37E1754C871321998818510C, 0x0196D8BE37E1754C8713219987AB3D8F, 0x0196D8BE37E07BFDB5EDD6F817D9005E, 0x0196D8BE37E07BFDB5EDD6F817A9E619, 0x0196D8BE37DF7FF298C2E0F64D0DE381) ORDER BY b0_.id 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.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;