| 1 |
0.33 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.description AS description_4, t0.mission AS mission_5, t0.region AS region_6, t0.website AS website_7, t0.logo_filename AS logo_filename_8, t0.membership_available AS membership_available_9, t0.donation_available AS donation_available_10, t0.verified_status AS verified_status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.created_by_id AS created_by_id_14 FROM association t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.description AS description_4, t0.mission AS mission_5, t0.region AS region_6, t0.website AS website_7, t0.logo_filename AS logo_filename_8, t0.membership_available AS membership_available_9, t0.donation_available AS donation_available_10, t0.verified_status AS verified_status_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.created_by_id AS created_by_id_14 FROM association t0 WHERE t0.id = '6';
|
| 2 |
0.27 ms |
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.excerpt AS excerpt_2, n0_.content AS content_3, n0_.category AS category_4, n0_.is_published AS is_published_5, n0_.published_at AS published_at_6, n0_.view_count AS view_count_7, n0_.created_at AS created_at_8, n0_.updated_at AS updated_at_9, n0_.author_id AS author_id_10, n0_.association_id AS association_id_11 FROM news_article n0_ WHERE n0_.is_published = 1 AND n0_.association_id = ? ORDER BY n0_.published_at DESC LIMIT 10
SELECT n0_.id AS id_0, n0_.title AS title_1, n0_.excerpt AS excerpt_2, n0_.content AS content_3, n0_.category AS category_4, n0_.is_published AS is_published_5, n0_.published_at AS published_at_6, n0_.view_count AS view_count_7, n0_.created_at AS created_at_8, n0_.updated_at AS updated_at_9, n0_.author_id AS author_id_10, n0_.association_id AS association_id_11 FROM news_article n0_ WHERE n0_.is_published = 1 AND n0_.association_id = 6 ORDER BY n0_.published_at DESC LIMIT 10;
|
| 3 |
0.23 ms |
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.content AS content_2, a0_.image_urls AS image_urls_3, a0_.video_embeds AS video_embeds_4, a0_.resource_links AS resource_links_5, a0_.location_name AS location_name_6, a0_.address_line1 AS address_line1_7, a0_.postal_code AS postal_code_8, a0_.city AS city_9, a0_.country AS country_10, a0_.map_embed_url AS map_embed_url_11, a0_.starts_at AS starts_at_12, a0_.ends_at AS ends_at_13, a0_.status AS status_14, a0_.view_count AS view_count_15, a0_.participant_count AS participant_count_16, a0_.created_at AS created_at_17, a0_.updated_at AS updated_at_18, a0_.association_id AS association_id_19, a0_.created_by_id AS created_by_id_20 FROM association_event a0_ WHERE a0_.association_id = ? AND a0_.status = ? ORDER BY a0_.created_at DESC LIMIT 3
Parameters: [
6
"published"
]
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.content AS content_2, a0_.image_urls AS image_urls_3, a0_.video_embeds AS video_embeds_4, a0_.resource_links AS resource_links_5, a0_.location_name AS location_name_6, a0_.address_line1 AS address_line1_7, a0_.postal_code AS postal_code_8, a0_.city AS city_9, a0_.country AS country_10, a0_.map_embed_url AS map_embed_url_11, a0_.starts_at AS starts_at_12, a0_.ends_at AS ends_at_13, a0_.status AS status_14, a0_.view_count AS view_count_15, a0_.participant_count AS participant_count_16, a0_.created_at AS created_at_17, a0_.updated_at AS updated_at_18, a0_.association_id AS association_id_19, a0_.created_by_id AS created_by_id_20 FROM association_event a0_ WHERE a0_.association_id = 6 AND a0_.status = 'published' ORDER BY a0_.created_at DESC LIMIT 3;
|