| 1 |
0.29 ms |
SELECT COUNT(c0_.id) AS sclr_0 FROM child_profile c0_ WHERE c0_.visibility_level IN (?, ?)
Parameters: [
"public"
"community"
]
SELECT COUNT(c0_.id) AS sclr_0 FROM child_profile c0_ WHERE c0_.visibility_level IN ('public', 'community');
|
| 2 |
0.17 ms |
SELECT COUNT(f0_.id) AS sclr_0 FROM funding_project f0_ WHERE f0_.status = ?
Parameters: [
"published"
]
SELECT COUNT(f0_.id) AS sclr_0 FROM funding_project f0_ WHERE f0_.status = 'published';
|
| 3 |
0.16 ms |
SELECT COUNT(u0_.id) AS sclr_0 FROM `user` u0_
SELECT COUNT(u0_.id) AS sclr_0 FROM `user` u0_;
|
| 4 |
0.20 ms |
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.display_name AS display_name_2, c0_.birth_date AS birth_date_3, c0_.region AS region_4, c0_.bio AS bio_5, c0_.photo_filename AS photo_filename_6, c0_.hero_filename AS hero_filename_7, c0_.visibility_level AS visibility_level_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10 FROM child_profile c0_ WHERE c0_.visibility_level = ? ORDER BY c0_.created_at DESC LIMIT 3
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.display_name AS display_name_2, c0_.birth_date AS birth_date_3, c0_.region AS region_4, c0_.bio AS bio_5, c0_.photo_filename AS photo_filename_6, c0_.hero_filename AS hero_filename_7, c0_.visibility_level AS visibility_level_8, c0_.created_at AS created_at_9, c0_.updated_at AS updated_at_10 FROM child_profile c0_ WHERE c0_.visibility_level = 'public' ORDER BY c0_.created_at DESC LIMIT 3;
|
| 5 |
0.24 ms |
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.short_summary AS short_summary_2, f0_.description AS description_3, f0_.project_type AS project_type_4, f0_.goal_amount AS goal_amount_5, f0_.collected_amount AS collected_amount_6, f0_.status AS status_7, f0_.visibility_level AS visibility_level_8, f0_.cover_filename AS cover_filename_9, f0_.pinned AS pinned_10, f0_.closing_message AS closing_message_11, f0_.closing_image_filename AS closing_image_filename_12, f0_.provider AS provider_13, f0_.fundraising_mode AS fundraising_mode_14, f0_.embed_url AS embed_url_15, f0_.embed_height AS embed_height_16, f0_.external_url AS external_url_17, f0_.created_at AS created_at_18, f0_.updated_at AS updated_at_19, f0_.child_profile_id AS child_profile_id_20, f0_.created_by_id AS created_by_id_21 FROM funding_project f0_ WHERE f0_.status = ? AND f0_.visibility_level = ? ORDER BY f0_.created_at DESC LIMIT 3
Parameters: [
"published"
"public"
]
SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.short_summary AS short_summary_2, f0_.description AS description_3, f0_.project_type AS project_type_4, f0_.goal_amount AS goal_amount_5, f0_.collected_amount AS collected_amount_6, f0_.status AS status_7, f0_.visibility_level AS visibility_level_8, f0_.cover_filename AS cover_filename_9, f0_.pinned AS pinned_10, f0_.closing_message AS closing_message_11, f0_.closing_image_filename AS closing_image_filename_12, f0_.provider AS provider_13, f0_.fundraising_mode AS fundraising_mode_14, f0_.embed_url AS embed_url_15, f0_.embed_height AS embed_height_16, f0_.external_url AS external_url_17, f0_.created_at AS created_at_18, f0_.updated_at AS updated_at_19, f0_.child_profile_id AS child_profile_id_20, f0_.created_by_id AS created_by_id_21 FROM funding_project f0_ WHERE f0_.status = 'published' AND f0_.visibility_level = 'public' ORDER BY f0_.created_at DESC LIMIT 3;
|
| 6 |
0.20 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 ORDER BY n0_.published_at DESC LIMIT 3
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 ORDER BY n0_.published_at DESC LIMIT 3;
|
| 7 |
0.26 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_ INNER JOIN association a1_ ON a0_.association_id = a1_.id WHERE a0_.status = ? AND a1_.verified_status = ? AND a0_.starts_at IS NOT NULL AND a0_.starts_at >= ? ORDER BY a0_.starts_at ASC LIMIT 3
Parameters: [
"published"
"officielle"
"2026-05-02 10:40:10"
]
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_ INNER JOIN association a1_ ON a0_.association_id = a1_.id WHERE a0_.status = 'published' AND a1_.verified_status = 'officielle' AND a0_.starts_at IS NOT NULL AND a0_.starts_at >= '2026-05-02 10:40:10' ORDER BY a0_.starts_at ASC LIMIT 3;
|
| 8 |
0.31 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_name AS original_name_3, t0.caption AS caption_4, t0.position AS position_5, t0.article_id AS article_id_6 FROM news_article_photo t0 WHERE t0.article_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_name AS original_name_3, t0.caption AS caption_4, t0.position AS position_5, t0.article_id AS article_id_6 FROM news_article_photo t0 WHERE t0.article_id = 2 ORDER BY t0.position ASC;
|
| 9 |
0.18 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_name AS original_name_3, t0.caption AS caption_4, t0.position AS position_5, t0.article_id AS article_id_6 FROM news_article_photo t0 WHERE t0.article_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_name AS original_name_3, t0.caption AS caption_4, t0.position AS position_5, t0.article_id AS article_id_6 FROM news_article_photo t0 WHERE t0.article_id = 3 ORDER BY t0.position ASC;
|
| 10 |
0.17 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_name AS original_name_3, t0.caption AS caption_4, t0.position AS position_5, t0.article_id AS article_id_6 FROM news_article_photo t0 WHERE t0.article_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.original_name AS original_name_3, t0.caption AS caption_4, t0.position AS position_5, t0.article_id AS article_id_6 FROM news_article_photo t0 WHERE t0.article_id = 1 ORDER BY t0.position ASC;
|
| 11 |
0.18 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 = 2;
|
| 12 |
0.17 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 = 4;
|