Symfony Profiler

SELECT
  DISTINCT id_1
FROM
  (
    SELECT
      DISTINCT id_1
    FROM
      (
        SELECT
          DISTINCT b0_.status_mode AS status_mode_0,
          b0_.id AS id_1,
          b0_.title AS title_2,
          b0_.description AS description_3,
          b0_.status AS status_4,
          b0_.country AS country_5,
          b0_.state AS state_6,
          b0_.city AS city_7,
          b0_.street_address AS street_address_8,
          b0_.expiration_date AS expiration_date_9,
          b0_.highlight AS highlight_10,
          b0_.schedule AS schedule_11,
          b0_.start_date AS start_date_12,
          b0_.year_of_experience AS year_of_experience_13,
          b0_.pay_rate AS pay_rate_14,
          b0_.work_type AS work_type_15,
          b0_.need AS need_16,
          b0_.pay_rate_hourly AS pay_rate_hourly_17,
          b0_.pay_rate_daily AS pay_rate_daily_18,
          b0_.annual_salary AS annual_salary_19,
          b0_.monthly_salary AS monthly_salary_20,
          b0_.salary_type AS salary_type_21,
          b0_.blocked AS blocked_22,
          b0_.job_id AS job_id_23,
          b0_.verified AS verified_24,
          b0_.is_mediated AS is_mediated_25,
          b0_.`rank` AS rank_26,
          b0_.archived_at AS archived_at_27,
          b0_.is_archived AS is_archived_28,
          b0_.agency_payout_status AS agency_payout_status_29,
          b0_.agency_payout_amount AS agency_payout_amount_30,
          b0_.agency_payout_date AS agency_payout_date_31,
          b0_.agency_payout_reference AS agency_payout_reference_32,
          b0_.created_at AS created_at_33,
          b0_.updated_at AS updated_at_34,
          b1_.id AS id_35,
          b1_.status AS status_36,
          b1_.commission_rate AS commission_rate_37,
          b1_.assigned_at AS assigned_at_38,
          b1_.payout_status AS payout_status_39,
          b1_.payout_amount AS payout_amount_40,
          b1_.payout_date AS payout_date_41,
          b1_.payout_reference AS payout_reference_42,
          b2_.employer_status AS employer_status_43,
          b2_.recruiter_status AS recruiter_status_44,
          b2_.staffing_agency_status AS staffing_agency_status_45,
          b2_.id AS id_46,
          b2_.status AS status_47,
          b2_.applied_at AS applied_at_48,
          b2_.hired_at AS hired_at_49,
          b2_.document_requested_at AS document_requested_at_50,
          b2_.document_provided_at AS document_provided_at_51,
          b2_.one_file_requested_at AS one_file_requested_at_52,
          b2_.one_file_provided_at AS one_file_provided_at_53,
          b2_.contract_sent_at AS contract_sent_at_54,
          b2_.contract_file_name AS contract_file_name_55,
          b2_.contract_url AS contract_url_56,
          b2_.contract_signed_at AS contract_signed_at_57,
          b2_.contract_signed_file_name AS contract_signed_file_name_58,
          b2_.`rank` AS rank_59,
          b2_.archived_at AS archived_at_60,
          b2_.is_rewards_awarded AS is_rewards_awarded_61,
          b2_.is_archived AS is_archived_62,
          b2_.created_at AS created_at_63,
          b2_.updated_at AS updated_at_64
        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
          b0_.archived_at IS NULL
          AND b0_.blocked = ?
          AND b0_.verified = ?
          AND b0_.status = ?
          AND (
            (
              b0_.is_mediated = 0
              OR (
                b0_.is_mediated = 1
                AND (
                  b0_.id IN (NULL)
                  OR b0_.assigned_recruiter_id IS NOT NULL
                  OR EXISTS (
                    SELECT
                      1 AS sclr_65
                    FROM
                      b_job_recruiter b3_
                    WHERE
                      b3_.job_id = b0_.id
                      AND b3_.status IN (?, ?, ?, ?)
                  )
                  OR EXISTS (
                    SELECT
                      2 AS sclr_66
                    FROM
                      b_application b4_
                    WHERE
                      b4_.job_id = b0_.id
                      AND b4_.recruiter_id IS NOT NULL
                      AND b4_.status IN (?, ?, ?)
                  )
                )
              )
            )
          )
      ) dctrn_result_inner
    ORDER BY
      id_1 DESC
  ) dctrn_result
LIMIT
  25

SELECT DISTINCT id_1 FROM (SELECT DISTINCT id_1 FROM (SELECT DISTINCT b0_.status_mode AS status_mode_0, b0_.id AS id_1, b0_.title AS title_2, b0_.description AS description_3, b0_.status AS status_4, b0_.country AS country_5, b0_.state AS state_6, b0_.city AS city_7, b0_.street_address AS street_address_8, b0_.expiration_date AS expiration_date_9, b0_.highlight AS highlight_10, b0_.schedule AS schedule_11, b0_.start_date AS start_date_12, b0_.year_of_experience AS year_of_experience_13, b0_.pay_rate AS pay_rate_14, b0_.work_type AS work_type_15, b0_.need AS need_16, b0_.pay_rate_hourly AS pay_rate_hourly_17, b0_.pay_rate_daily AS pay_rate_daily_18, b0_.annual_salary AS annual_salary_19, b0_.monthly_salary AS monthly_salary_20, b0_.salary_type AS salary_type_21, b0_.blocked AS blocked_22, b0_.job_id AS job_id_23, b0_.verified AS verified_24, b0_.is_mediated AS is_mediated_25, b0_.`rank` AS rank_26, b0_.archived_at AS archived_at_27, b0_.is_archived AS is_archived_28, b0_.agency_payout_status AS agency_payout_status_29, b0_.agency_payout_amount AS agency_payout_amount_30, b0_.agency_payout_date AS agency_payout_date_31, b0_.agency_payout_reference AS agency_payout_reference_32, b0_.created_at AS created_at_33, b0_.updated_at AS updated_at_34, b1_.id AS id_35, b1_.status AS status_36, b1_.commission_rate AS commission_rate_37, b1_.assigned_at AS assigned_at_38, b1_.payout_status AS payout_status_39, b1_.payout_amount AS payout_amount_40, b1_.payout_date AS payout_date_41, b1_.payout_reference AS payout_reference_42, b2_.employer_status AS employer_status_43, b2_.recruiter_status AS recruiter_status_44, b2_.staffing_agency_status AS staffing_agency_status_45, b2_.id AS id_46, b2_.status AS status_47, b2_.applied_at AS applied_at_48, b2_.hired_at AS hired_at_49, b2_.document_requested_at AS document_requested_at_50, b2_.document_provided_at AS document_provided_at_51, b2_.one_file_requested_at AS one_file_requested_at_52, b2_.one_file_provided_at AS one_file_provided_at_53, b2_.contract_sent_at AS contract_sent_at_54, b2_.contract_file_name AS contract_file_name_55, b2_.contract_url AS contract_url_56, b2_.contract_signed_at AS contract_signed_at_57, b2_.contract_signed_file_name AS contract_signed_file_name_58, b2_.`rank` AS rank_59, b2_.archived_at AS archived_at_60, b2_.is_rewards_awarded AS is_rewards_awarded_61, b2_.is_archived AS is_archived_62, b2_.created_at AS created_at_63, b2_.updated_at AS updated_at_64 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 b0_.archived_at IS NULL AND b0_.blocked = 0 AND b0_.verified = 1 AND b0_.status = 'published' AND ((b0_.is_mediated = 0 OR (b0_.is_mediated = 1 AND (b0_.id IN (NULL) OR b0_.assigned_recruiter_id IS NOT NULL OR EXISTS (SELECT 1 AS sclr_65 FROM b_job_recruiter b3_ WHERE b3_.job_id = b0_.id AND b3_.status IN ('Accepted', 'Completed', 'accepted', 'completed')) OR EXISTS (SELECT 2 AS sclr_66 FROM b_application b4_ WHERE b4_.job_id = b0_.id AND b4_.recruiter_id IS NOT NULL AND b4_.status IN ('accepted', 'completed', 'hired'))))))) dctrn_result_inner ORDER BY id_1 DESC) dctrn_result LIMIT 25;

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_1
    FROM
      (
        SELECT
          DISTINCT b0_.status_mode AS status_mode_0,
          b0_.id AS id_1,
          b0_.title AS title_2,
          b0_.description AS description_3,
          b0_.status AS status_4,
          b0_.country AS country_5,
          b0_.state AS state_6,
          b0_.city AS city_7,
          b0_.street_address AS street_address_8,
          b0_.expiration_date AS expiration_date_9,
          b0_.highlight AS highlight_10,
          b0_.schedule AS schedule_11,
          b0_.start_date AS start_date_12,
          b0_.year_of_experience AS year_of_experience_13,
          b0_.pay_rate AS pay_rate_14,
          b0_.work_type AS work_type_15,
          b0_.need AS need_16,
          b0_.pay_rate_hourly AS pay_rate_hourly_17,
          b0_.pay_rate_daily AS pay_rate_daily_18,
          b0_.annual_salary AS annual_salary_19,
          b0_.monthly_salary AS monthly_salary_20,
          b0_.salary_type AS salary_type_21,
          b0_.blocked AS blocked_22,
          b0_.job_id AS job_id_23,
          b0_.verified AS verified_24,
          b0_.is_mediated AS is_mediated_25,
          b0_.`rank` AS rank_26,
          b0_.archived_at AS archived_at_27,
          b0_.is_archived AS is_archived_28,
          b0_.agency_payout_status AS agency_payout_status_29,
          b0_.agency_payout_amount AS agency_payout_amount_30,
          b0_.agency_payout_date AS agency_payout_date_31,
          b0_.agency_payout_reference AS agency_payout_reference_32,
          b0_.created_at AS created_at_33,
          b0_.updated_at AS updated_at_34
        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
          b0_.archived_at IS NULL
          AND b0_.blocked = ?
          AND b0_.verified = ?
          AND b0_.status = ?
          AND (
            (
              b0_.is_mediated = 0
              OR (
                b0_.is_mediated = 1
                AND (
                  b0_.id IN (NULL)
                  OR b0_.assigned_recruiter_id IS NOT NULL
                  OR EXISTS (
                    SELECT
                      1 AS sclr_35
                    FROM
                      b_job_recruiter b3_
                    WHERE
                      b3_.job_id = b0_.id
                      AND b3_.status IN (?, ?, ?, ?)
                  )
                  OR EXISTS (
                    SELECT
                      2 AS sclr_36
                    FROM
                      b_application b4_
                    WHERE
                      b4_.job_id = b0_.id
                      AND b4_.recruiter_id IS NOT NULL
                      AND b4_.status IN (?, ?, ?)
                  )
                )
              )
            )
          )
        ORDER BY
          b0_.id DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_1 FROM (SELECT DISTINCT b0_.status_mode AS status_mode_0, b0_.id AS id_1, b0_.title AS title_2, b0_.description AS description_3, b0_.status AS status_4, b0_.country AS country_5, b0_.state AS state_6, b0_.city AS city_7, b0_.street_address AS street_address_8, b0_.expiration_date AS expiration_date_9, b0_.highlight AS highlight_10, b0_.schedule AS schedule_11, b0_.start_date AS start_date_12, b0_.year_of_experience AS year_of_experience_13, b0_.pay_rate AS pay_rate_14, b0_.work_type AS work_type_15, b0_.need AS need_16, b0_.pay_rate_hourly AS pay_rate_hourly_17, b0_.pay_rate_daily AS pay_rate_daily_18, b0_.annual_salary AS annual_salary_19, b0_.monthly_salary AS monthly_salary_20, b0_.salary_type AS salary_type_21, b0_.blocked AS blocked_22, b0_.job_id AS job_id_23, b0_.verified AS verified_24, b0_.is_mediated AS is_mediated_25, b0_.`rank` AS rank_26, b0_.archived_at AS archived_at_27, b0_.is_archived AS is_archived_28, b0_.agency_payout_status AS agency_payout_status_29, b0_.agency_payout_amount AS agency_payout_amount_30, b0_.agency_payout_date AS agency_payout_date_31, b0_.agency_payout_reference AS agency_payout_reference_32, b0_.created_at AS created_at_33, b0_.updated_at AS updated_at_34 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 b0_.archived_at IS NULL AND b0_.blocked = 0 AND b0_.verified = 1 AND b0_.status = 'published' AND ((b0_.is_mediated = 0 OR (b0_.is_mediated = 1 AND (b0_.id IN (NULL) OR b0_.assigned_recruiter_id IS NOT NULL OR EXISTS (SELECT 1 AS sclr_35 FROM b_job_recruiter b3_ WHERE b3_.job_id = b0_.id AND b3_.status IN ('Accepted', 'Completed', 'accepted', 'completed')) OR EXISTS (SELECT 2 AS sclr_36 FROM b_application b4_ WHERE b4_.job_id = b0_.id AND b4_.recruiter_id IS NOT NULL AND b4_.status IN ('accepted', 'completed', 'hired')))))) ORDER BY b0_.id DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT b0_.status_mode AS status_mode_0,
  b0_.id AS id_1,
  b0_.title AS title_2,
  b0_.description AS description_3,
  b0_.status AS status_4,
  b0_.country AS country_5,
  b0_.state AS state_6,
  b0_.city AS city_7,
  b0_.street_address AS street_address_8,
  b0_.expiration_date AS expiration_date_9,
  b0_.highlight AS highlight_10,
  b0_.schedule AS schedule_11,
  b0_.start_date AS start_date_12,
  b0_.year_of_experience AS year_of_experience_13,
  b0_.pay_rate AS pay_rate_14,
  b0_.work_type AS work_type_15,
  b0_.need AS need_16,
  b0_.pay_rate_hourly AS pay_rate_hourly_17,
  b0_.pay_rate_daily AS pay_rate_daily_18,
  b0_.annual_salary AS annual_salary_19,
  b0_.monthly_salary AS monthly_salary_20,
  b0_.salary_type AS salary_type_21,
  b0_.blocked AS blocked_22,
  b0_.job_id AS job_id_23,
  b0_.verified AS verified_24,
  b0_.is_mediated AS is_mediated_25,
  b0_.`rank` AS rank_26,
  b0_.archived_at AS archived_at_27,
  b0_.is_archived AS is_archived_28,
  b0_.agency_payout_status AS agency_payout_status_29,
  b0_.agency_payout_amount AS agency_payout_amount_30,
  b0_.agency_payout_date AS agency_payout_date_31,
  b0_.agency_payout_reference AS agency_payout_reference_32,
  b0_.created_at AS created_at_33,
  b0_.updated_at AS updated_at_34,
  b0_.user_id AS user_id_35,
  b0_.employer_id AS employer_id_36,
  b0_.staffing_agency_id AS staffing_agency_id_37,
  b0_.profession_id AS profession_id_38,
  b0_.speciality_id AS speciality_id_39,
  b0_.assigned_recruiter_id AS assigned_recruiter_id_40
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
  b0_.archived_at IS NULL
  AND b0_.blocked = ?
  AND b0_.verified = ?
  AND b0_.status = ?
  AND (
    (
      b0_.is_mediated = 0
      OR (
        b0_.is_mediated = 1
        AND (
          b0_.id IN (NULL)
          OR b0_.assigned_recruiter_id IS NOT NULL
          OR EXISTS (
            SELECT
              1 AS sclr_41
            FROM
              b_job_recruiter b3_
            WHERE
              b3_.job_id = b0_.id
              AND b3_.status IN (?, ?, ?, ?)
          )
          OR EXISTS (
            SELECT
              2 AS sclr_42
            FROM
              b_application b4_
            WHERE
              b4_.job_id = b0_.id
              AND b4_.recruiter_id IS NOT NULL
              AND b4_.status IN (?, ?, ?)
          )
        )
      )
    )
  )
  AND b0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  b0_.id DESC

SELECT DISTINCT b0_.status_mode AS status_mode_0, b0_.id AS id_1, b0_.title AS title_2, b0_.description AS description_3, b0_.status AS status_4, b0_.country AS country_5, b0_.state AS state_6, b0_.city AS city_7, b0_.street_address AS street_address_8, b0_.expiration_date AS expiration_date_9, b0_.highlight AS highlight_10, b0_.schedule AS schedule_11, b0_.start_date AS start_date_12, b0_.year_of_experience AS year_of_experience_13, b0_.pay_rate AS pay_rate_14, b0_.work_type AS work_type_15, b0_.need AS need_16, b0_.pay_rate_hourly AS pay_rate_hourly_17, b0_.pay_rate_daily AS pay_rate_daily_18, b0_.annual_salary AS annual_salary_19, b0_.monthly_salary AS monthly_salary_20, b0_.salary_type AS salary_type_21, b0_.blocked AS blocked_22, b0_.job_id AS job_id_23, b0_.verified AS verified_24, b0_.is_mediated AS is_mediated_25, b0_.`rank` AS rank_26, b0_.archived_at AS archived_at_27, b0_.is_archived AS is_archived_28, b0_.agency_payout_status AS agency_payout_status_29, b0_.agency_payout_amount AS agency_payout_amount_30, b0_.agency_payout_date AS agency_payout_date_31, b0_.agency_payout_reference AS agency_payout_reference_32, b0_.created_at AS created_at_33, b0_.updated_at AS updated_at_34, b0_.user_id AS user_id_35, b0_.employer_id AS employer_id_36, b0_.staffing_agency_id AS staffing_agency_id_37, b0_.profession_id AS profession_id_38, b0_.speciality_id AS speciality_id_39, b0_.assigned_recruiter_id AS assigned_recruiter_id_40 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 b0_.archived_at IS NULL AND b0_.blocked = 0 AND b0_.verified = 1 AND b0_.status = 'published' AND ((b0_.is_mediated = 0 OR (b0_.is_mediated = 1 AND (b0_.id IN (NULL) OR b0_.assigned_recruiter_id IS NOT NULL OR EXISTS (SELECT 1 AS sclr_41 FROM b_job_recruiter b3_ WHERE b3_.job_id = b0_.id AND b3_.status IN ('Accepted', 'Completed', 'accepted', 'completed')) OR EXISTS (SELECT 2 AS sclr_42 FROM b_application b4_ WHERE b4_.job_id = b0_.id AND b4_.recruiter_id IS NOT NULL AND b4_.status IN ('accepted', 'completed', 'hired')))))) AND b0_.id IN (0x1F137AB84B3C6E64996D0337E96B9911, 0x1F133B5599A76164A6DEFD5A98F53109, 0x1F1315E99F9E6446BD6185180A7DEFB0, 0x1F1308EF4E6E64F6952B5DA1E51A008B, 0x1F1302A0D5FB64E6AA4077F342B2204F, 0x1F12B0D02CE9601485EF67D0C8D96C27, 0x1F12B097F98269F6A6299D13AB8278B9, 0x1F12AB5DB6E763F6A9D77F3C993272B9, 0x1F125FFB9D31636A8FBC7DF3BE83E0F2, 0x1F124C07306662D8930003924BB034C8, 0x1F1218D064F862EAB25D075849FEB569, 0x1F11EEFA92026592AAB03D95A046A4D3, 0x1F11EDFC96DE6E7AB6462BCD3AD55FF8, 0x1F11DE8944196D3E869A117E9ECEB26C, 0x1F11AD167E806A1281F3E1AEA2EBC505, 0x1F115E0F3AFD6A5C8932C5CFE2C48038) 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;