Symfony Profiler

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

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;

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 (0x019707F2A7DD7CF2ABC16B7C05B926A3, 0x0196FC850E8770FA901B350112F4F7C3, 0x0196FAB2A23672BC9C743E8A326D2364, 0x0196FA3B43D5789E906B9172853E263B, 0x0196D8BE38787711BAB5F9146F0C496C, 0x0196D8BE38787711BAB5F9146EBB15CC, 0x0196D8BE38787711BAB5F9146DE61587, 0x0196D8BE387776DE8ADCA669646F0DC6, 0x0196D8BE387776DE8ADCA66963A70460, 0x0196D8BE387776DE8ADCA669633FD44A, 0x0196D8BE38767603AC678E9C06BA79EC, 0x0196D8BE38767603AC678E9C0630C066, 0x0196D8BE386A77E3BD5FCDC8AC75CBFD, 0x0196D8BE386A77E3BD5FCDC8ABB01D26, 0x0196D8BE386A77E3BD5FCDC8AB5FD2B8, 0x0196D8BE38697B1DB002860E3A51DF34, 0x0196D8BE38697B1DB002860E39A6EAEE, 0x0196D8BE38697B1DB002860E3951CA2B, 0x0196D8BE38687FE28940DFF0D6900D47, 0x0196D8BE38687FE28940DFF0D5E85BA7, 0x0196D8BE38687FE28940DFF0D52634AB, 0x0196D8BE386772188157256BBB5ACDAB, 0x0196D8BE38597CFF94D9ED5389DD6889, 0x0196D8BE38597CFF94D9ED5389300BB2, 0x0196D8BE3858743296E42A957CBC909E) 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
  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
  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;