| 1 |
3.38 ms |
SELECT t0.status_mode AS status_mode_1, t0.id AS id_2, t0.title AS title_3, t0.description AS description_4, t0.status AS status_5, t0.country AS country_6, t0.state AS state_7, t0.city AS city_8, t0.street_address AS street_address_9, t0.expiration_date AS expiration_date_10, t0.highlight AS highlight_11, t0.schedule AS schedule_12, t0.start_date AS start_date_13, t0.year_of_experience AS year_of_experience_14, t0.pay_rate AS pay_rate_15, t0.work_type AS work_type_16, t0.need AS need_17, t0.pay_rate_hourly AS pay_rate_hourly_18, t0.pay_rate_daily AS pay_rate_daily_19, t0.annual_salary AS annual_salary_20, t0.monthly_salary AS monthly_salary_21, t0.salary_type AS salary_type_22, t0.blocked AS blocked_23, t0.job_id AS job_id_24, t0.verified AS verified_25, t0.is_mediated AS is_mediated_26, t0.`rank` AS rank_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.user_id AS user_id_30, t0.employer_id AS employer_id_31, t0.profession_id AS profession_id_32, t0.speciality_id AS speciality_id_33, t0.assigned_recruiter_id AS assigned_recruiter_id_34 FROM b_job t0 WHERE t0.status = ? ORDER BY t0.created_at DESC
Parameters: [
"published"
]
SELECT t0.status_mode AS status_mode_1, t0.id AS id_2, t0.title AS title_3, t0.description AS description_4, t0.status AS status_5, t0.country AS country_6, t0.state AS state_7, t0.city AS city_8, t0.street_address AS street_address_9, t0.expiration_date AS expiration_date_10, t0.highlight AS highlight_11, t0.schedule AS schedule_12, t0.start_date AS start_date_13, t0.year_of_experience AS year_of_experience_14, t0.pay_rate AS pay_rate_15, t0.work_type AS work_type_16, t0.need AS need_17, t0.pay_rate_hourly AS pay_rate_hourly_18, t0.pay_rate_daily AS pay_rate_daily_19, t0.annual_salary AS annual_salary_20, t0.monthly_salary AS monthly_salary_21, t0.salary_type AS salary_type_22, t0.blocked AS blocked_23, t0.job_id AS job_id_24, t0.verified AS verified_25, t0.is_mediated AS is_mediated_26, t0.`rank` AS rank_27, t0.created_at AS created_at_28, t0.updated_at AS updated_at_29, t0.user_id AS user_id_30, t0.employer_id AS employer_id_31, t0.profession_id AS profession_id_32, t0.speciality_id AS speciality_id_33, t0.assigned_recruiter_id AS assigned_recruiter_id_34 FROM b_job t0 WHERE t0.status = 'published' ORDER BY t0.created_at DESC;
|