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
  25

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

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 (0x0196D8BE3858743296E42A957C84E9EB, 0x0196D8BE3858743296E42A957B9AB613, 0x0196D8BE38577EFB950EA8C94898C514, 0x0196D8BE38577EFB950EA8C947BA32B4, 0x0196D8BE38577EFB950EA8C9477CED42, 0x0196D8BE3856796A9ACAB213D2E3F311, 0x0196D8BE3856796A9ACAB213D2451071, 0x0196D8BE384975C4AA33FD004CE572E4, 0x0196D8BE384975C4AA33FD004C04AC9B, 0x0196D8BE384870D7B84B825F6FB5B6F1, 0x0196D8BE384870D7B84B825F6F371FD2, 0x0196D8BE384870D7B84B825F6EE56C61, 0x0196D8BE38477D71B13993F7BC1AA217, 0x0196D8BE38477D71B13993F7BB52A120, 0x0196D8BE38477D71B13993F7BB1C526B, 0x0196D8BE38467325B29705BA2C1C2647, 0x0196D8BE38467325B29705BA2BE1DA4C, 0x0196D8BE3839787782E6B913114877BE, 0x0196D8BE3839787782E6B9131130EA33, 0x0196D8BE3838701285F1A4EE9C8D93B1, 0x0196D8BE3838701285F1A4EE9C89DEFB, 0x0196D8BE3838701285F1A4EE9BA8117B, 0x0196D8BE38377301898E0CD1947B515C, 0x0196D8BE38377301898E0CD193F132E8, 0x0196D8BE38377301898E0CD1936CF21A) 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;