| 2 |
0.49 ms |
SELECT p0_.id AS id_0, p0_.title_fr AS title_fr_1, p0_.title_la AS title_la_2, p0_.content_fr AS content_fr_3, p0_.content_la AS content_la_4, p0_.sort_order AS sort_order_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7, p0_.is_prayer AS is_prayer_8, p0_.prayer_tags AS prayer_tags_9, p0_.prayer_name AS prayer_name_10, p0_.prayer_name_la AS prayer_name_la_11 FROM paragraph p0_ WHERE p0_.is_prayer = ? ORDER BY p0_.created_at DESC LIMIT 12
SELECT p0_.id AS id_0, p0_.title_fr AS title_fr_1, p0_.title_la AS title_la_2, p0_.content_fr AS content_fr_3, p0_.content_la AS content_la_4, p0_.sort_order AS sort_order_5, p0_.created_at AS created_at_6, p0_.updated_at AS updated_at_7, p0_.is_prayer AS is_prayer_8, p0_.prayer_tags AS prayer_tags_9, p0_.prayer_name AS prayer_name_10, p0_.prayer_name_la AS prayer_name_la_11 FROM paragraph p0_ WHERE p0_.is_prayer = 1 ORDER BY p0_.created_at DESC LIMIT 12;
|
| 4 |
0.71 ms |
SELECT s0_.id AS id_0, s0_.site_name AS site_name_1, s0_.site_domain AS site_domain_2, s0_.site_slogan AS site_slogan_3, s0_.site_logo AS site_logo_4, s0_.site_favicon AS site_favicon_5, s0_.primary_color AS primary_color_6, s0_.secondary_color AS secondary_color_7, s0_.accent_color AS accent_color_8, s0_.info_color AS info_color_9, s0_.pm_btn_color AS pm_btn_color_10, s0_.sd_btn_color AS sd_btn_color_11, s0_.sc_btn_color AS sc_btn_color_12, s0_.footer_content AS footer_content_13, s0_.home_description AS home_description_14, s0_.matomo_enabled AS matomo_enabled_15, s0_.matomo_url AS matomo_url_16, s0_.matomo_site_id AS matomo_site_id_17, s0_.matomo_custom_snippet AS matomo_custom_snippet_18, s0_.matomo_lock_non_prod AS matomo_lock_non_prod_19, s0_.home_banner_image AS home_banner_image_20, s0_.home_banner_color AS home_banner_color_21, s0_.updated_at AS updated_at_22, s0_.mailer_mode AS mailer_mode_23, s0_.mailer_from_email AS mailer_from_email_24, s0_.mailer_from_name AS mailer_from_name_25, s0_.smtp_host AS smtp_host_26, s0_.smtp_port AS smtp_port_27, s0_.smtp_encryption AS smtp_encryption_28, s0_.smtp_username AS smtp_username_29, s0_.smtp_password AS smtp_password_30, s0_.header_title_color AS header_title_color_31, s0_.header_subtitle_color AS header_subtitle_color_32, s0_.header_background_color AS header_background_color_33, s0_.footer_background_color AS footer_background_color_34 FROM site_settings s0_ ORDER BY s0_.id ASC LIMIT 1
SELECT s0_.id AS id_0, s0_.site_name AS site_name_1, s0_.site_domain AS site_domain_2, s0_.site_slogan AS site_slogan_3, s0_.site_logo AS site_logo_4, s0_.site_favicon AS site_favicon_5, s0_.primary_color AS primary_color_6, s0_.secondary_color AS secondary_color_7, s0_.accent_color AS accent_color_8, s0_.info_color AS info_color_9, s0_.pm_btn_color AS pm_btn_color_10, s0_.sd_btn_color AS sd_btn_color_11, s0_.sc_btn_color AS sc_btn_color_12, s0_.footer_content AS footer_content_13, s0_.home_description AS home_description_14, s0_.matomo_enabled AS matomo_enabled_15, s0_.matomo_url AS matomo_url_16, s0_.matomo_site_id AS matomo_site_id_17, s0_.matomo_custom_snippet AS matomo_custom_snippet_18, s0_.matomo_lock_non_prod AS matomo_lock_non_prod_19, s0_.home_banner_image AS home_banner_image_20, s0_.home_banner_color AS home_banner_color_21, s0_.updated_at AS updated_at_22, s0_.mailer_mode AS mailer_mode_23, s0_.mailer_from_email AS mailer_from_email_24, s0_.mailer_from_name AS mailer_from_name_25, s0_.smtp_host AS smtp_host_26, s0_.smtp_port AS smtp_port_27, s0_.smtp_encryption AS smtp_encryption_28, s0_.smtp_username AS smtp_username_29, s0_.smtp_password AS smtp_password_30, s0_.header_title_color AS header_title_color_31, s0_.header_subtitle_color AS header_subtitle_color_32, s0_.header_background_color AS header_background_color_33, s0_.footer_background_color AS footer_background_color_34 FROM site_settings s0_ ORDER BY s0_.id ASC LIMIT 1;
|
| 5 |
0.64 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.content AS content_3, p0_.type AS type_4, p0_.is_published AS is_published_5, p0_.show_in_footer AS show_in_footer_6, p0_.show_in_menu AS show_in_menu_7, p0_.sort_order AS sort_order_8, p0_.meta_description AS meta_description_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.published_at AS published_at_12 FROM page p0_ WHERE p0_.is_published = ? AND p0_.show_in_menu = ? ORDER BY p0_.sort_order ASC
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.content AS content_3, p0_.type AS type_4, p0_.is_published AS is_published_5, p0_.show_in_footer AS show_in_footer_6, p0_.show_in_menu AS show_in_menu_7, p0_.sort_order AS sort_order_8, p0_.meta_description AS meta_description_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.published_at AS published_at_12 FROM page p0_ WHERE p0_.is_published = 1 AND p0_.show_in_menu = 1 ORDER BY p0_.sort_order ASC;
|
| 6 |
0.70 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.content AS content_3, p0_.type AS type_4, p0_.is_published AS is_published_5, p0_.show_in_footer AS show_in_footer_6, p0_.show_in_menu AS show_in_menu_7, p0_.sort_order AS sort_order_8, p0_.meta_description AS meta_description_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.published_at AS published_at_12 FROM page p0_ WHERE p0_.type = ? AND p0_.is_published = ? ORDER BY p0_.published_at DESC, p0_.created_at DESC LIMIT 5
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.content AS content_3, p0_.type AS type_4, p0_.is_published AS is_published_5, p0_.show_in_footer AS show_in_footer_6, p0_.show_in_menu AS show_in_menu_7, p0_.sort_order AS sort_order_8, p0_.meta_description AS meta_description_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.published_at AS published_at_12 FROM page p0_ WHERE p0_.type = 'news' AND p0_.is_published = 1 ORDER BY p0_.published_at DESC, p0_.created_at DESC LIMIT 5;
|
| 7 |
0.49 ms |
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.content AS content_3, p0_.type AS type_4, p0_.is_published AS is_published_5, p0_.show_in_footer AS show_in_footer_6, p0_.show_in_menu AS show_in_menu_7, p0_.sort_order AS sort_order_8, p0_.meta_description AS meta_description_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.published_at AS published_at_12 FROM page p0_ WHERE p0_.is_published = ? AND p0_.show_in_footer = ? ORDER BY p0_.sort_order ASC
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.slug AS slug_2, p0_.content AS content_3, p0_.type AS type_4, p0_.is_published AS is_published_5, p0_.show_in_footer AS show_in_footer_6, p0_.show_in_menu AS show_in_menu_7, p0_.sort_order AS sort_order_8, p0_.meta_description AS meta_description_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.published_at AS published_at_12 FROM page p0_ WHERE p0_.is_published = 1 AND p0_.show_in_footer = 1 ORDER BY p0_.sort_order ASC;
|