1 |
0.62 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.section AS section_3, t0.year AS year_4, t0.number AS number_5, t0.title AS title_6, t0.description AS description_7, t0.headline AS headline_8, t0.in_home AS in_home_9, t0.app_send AS app_send_10, t0.button_label AS button_label_11, t0.button_decree_label AS button_decree_label_12, t0.created_at AS created_at_13, t0.deleted_at AS deleted_at_14, t0.publishing_status AS publishing_status_15, t0.ordering AS ordering_16, t0.document_name AS document_name_17, t0.document_original_name AS document_original_name_18, t0.document_url AS document_url_19, t0.decree_name AS decree_name_20, t0.decree_original_name AS decree_original_name_21, t0.decree_url AS decree_url_22 FROM releases t0 WHERE t0.deleted_at IS NULL AND t0.publishing_status = ? AND t0.in_home = ? ORDER BY t0.created_at DESC LIMIT 20
Parameters: [
"published"
1
]
SELECT t0.id AS id_1, t0.date AS date_2, t0.section AS section_3, t0.year AS year_4, t0.number AS number_5, t0.title AS title_6, t0.description AS description_7, t0.headline AS headline_8, t0.in_home AS in_home_9, t0.app_send AS app_send_10, t0.button_label AS button_label_11, t0.button_decree_label AS button_decree_label_12, t0.created_at AS created_at_13, t0.deleted_at AS deleted_at_14, t0.publishing_status AS publishing_status_15, t0.ordering AS ordering_16, t0.document_name AS document_name_17, t0.document_original_name AS document_original_name_18, t0.document_url AS document_url_19, t0.decree_name AS decree_name_20, t0.decree_original_name AS decree_original_name_21, t0.decree_url AS decree_url_22 FROM releases t0 WHERE t0.deleted_at IS NULL AND t0.publishing_status = 'published' AND t0.in_home = 1 ORDER BY t0.created_at DESC LIMIT 20;
|
2 |
0.18 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.link AS link_4, t0.date AS date_5, t0.created_at AS created_at_6, t0.deleted_at AS deleted_at_7, t0.publishing_status AS publishing_status_8, t0.document_name AS document_name_9, t0.document_original_name AS document_original_name_10, t0.document_url AS document_url_11 FROM event t0 WHERE t0.deleted_at IS NULL AND t0.publishing_status = ? ORDER BY t0.date DESC LIMIT 2
Parameters: [
"published"
]
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.link AS link_4, t0.date AS date_5, t0.created_at AS created_at_6, t0.deleted_at AS deleted_at_7, t0.publishing_status AS publishing_status_8, t0.document_name AS document_name_9, t0.document_original_name AS document_original_name_10, t0.document_url AS document_url_11 FROM event t0 WHERE t0.deleted_at IS NULL AND t0.publishing_status = 'published' ORDER BY t0.date DESC LIMIT 2;
|