139.17 ms (74.41%)
|
389 |
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.native_name AS native_name_4, t0.fallback_locale AS fallback_locale_5, t0.is_active AS is_active_6, t0.is_default AS is_default_7, t0.position AS position_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM cms_language t0 WHERE t0.locale = ? AND t0.is_active = ? LIMIT 1
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.name AS name_3, t0.native_name AS native_name_4, t0.fallback_locale AS fallback_locale_5, t0.is_active AS is_active_6, t0.is_default AS is_default_7, t0.position AS position_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM cms_language t0 WHERE t0.locale = 'fr' AND t0.is_active = 1 LIMIT 1;
|
11.27 ms (6.03%)
|
16 |
SELECT t0.id AS id_1, t0.seo_title AS seo_title_2, t0.seo_content AS seo_content_3, t0.no_index AS no_index_4, t0.no_follow AS no_follow_5, t0.fb_active AS fb_active_6, t0.og_type AS og_type_7, t0.og_title AS og_title_8, t0.og_content AS og_content_9, t0.og_image AS og_image_10, t0.og_active AS og_active_11, t0.x_active AS x_active_12, t0.x_type AS x_type_13, t0.x_site AS x_site_14, t0.x_creator AS x_creator_15, t0.fb_app_id AS fb_app_id_16, t0.fb_admins AS fb_admins_17, t0.title_prefix AS title_prefix_18, t0.title_suffix AS title_suffix_19, t0.title_separator AS title_separator_20, t0.reading_time AS reading_time_21, t0.created_at AS created_at_22, t0.last_update AS last_update_23, t24.id AS id_25, t24.site_slug AS site_slug_26, t24.route_name AS route_name_27, t24.site_content AS site_content_28, t24.site_date AS site_date_29, t24.site_excerpt AS site_excerpt_30, t24.site_status AS site_status_31, t24.comment_status AS comment_status_32, t24.site_type AS site_type_33, t24.site_img AS site_img_34, t24.site_user AS site_user_35, t24.site_password AS site_password_36, t24.excerpt_limit AS excerpt_limit_37, t24.extra_css AS extra_css_38, t24.position AS position_39, t24.header AS header_40, t24.footer AS footer_41, t24.custom AS custom_42, t24.builder_active AS builder_active_43, t24.theme_id AS theme_id_44, t24.siteSeo AS siteSeo_45, t24.form_builder_id AS form_builder_id_46, t24.site_category_id AS site_category_id_47, t48.id AS id_49, t48.post_content AS post_content_50, t48.post_date AS post_date_51, t48.post_end_date AS post_end_date_52, t48.post_excerpt AS post_excerpt_53, t48.comment_status AS comment_status_54, t48.site_type AS site_type_55, t48.site_img AS site_img_56, t48.excerpt_limit AS excerpt_limit_57, t48.extra_css AS extra_css_58, t48.position AS position_59, t48.post_status AS post_status_60, t48.sticky AS sticky_61, t48.post_slug AS post_slug_62, t48.header AS header_63, t48.footer AS footer_64, t48.post_gallery AS post_gallery_65, t48.last_update AS last_update_66, t48.form_builder_id AS form_builder_id_67, t48.siteSeo AS siteSeo_68, t48.post_category_id AS post_category_id_69 FROM site_seo t0 LEFT JOIN app_sites t24 ON t24.siteSeo = t0.id LEFT JOIN post_sites t48 ON t48.siteSeo = t0.id WHERE t0.id = ?
SELECT
t0.id AS id_1,
t0.seo_title AS seo_title_2,
t0.seo_content AS seo_content_3,
t0.no_index AS no_index_4,
t0.no_follow AS no_follow_5,
t0.fb_active AS fb_active_6,
t0.og_type AS og_type_7,
t0.og_title AS og_title_8,
t0.og_content AS og_content_9,
t0.og_image AS og_image_10,
t0.og_active AS og_active_11,
t0.x_active AS x_active_12,
t0.x_type AS x_type_13,
t0.x_site AS x_site_14,
t0.x_creator AS x_creator_15,
t0.fb_app_id AS fb_app_id_16,
t0.fb_admins AS fb_admins_17,
t0.title_prefix AS title_prefix_18,
t0.title_suffix AS title_suffix_19,
t0.title_separator AS title_separator_20,
t0.reading_time AS reading_time_21,
t0.created_at AS created_at_22,
t0.last_update AS last_update_23,
t24.id AS id_25,
t24.site_slug AS site_slug_26,
t24.route_name AS route_name_27,
t24.site_content AS site_content_28,
t24.site_date AS site_date_29,
t24.site_excerpt AS site_excerpt_30,
t24.site_status AS site_status_31,
t24.comment_status AS comment_status_32,
t24.site_type AS site_type_33,
t24.site_img AS site_img_34,
t24.site_user AS site_user_35,
t24.site_password AS site_password_36,
t24.excerpt_limit AS excerpt_limit_37,
t24.extra_css AS extra_css_38,
t24.position AS position_39,
t24.header AS header_40,
t24.footer AS footer_41,
t24.custom AS custom_42,
t24.builder_active AS builder_active_43,
t24.theme_id AS theme_id_44,
t24.siteSeo AS siteSeo_45,
t24.form_builder_id AS form_builder_id_46,
t24.site_category_id AS site_category_id_47,
t48.id AS id_49,
t48.post_content AS post_content_50,
t48.post_date AS post_date_51,
t48.post_end_date AS post_end_date_52,
t48.post_excerpt AS post_excerpt_53,
t48.comment_status AS comment_status_54,
t48.site_type AS site_type_55,
t48.site_img AS site_img_56,
t48.excerpt_limit AS excerpt_limit_57,
t48.extra_css AS extra_css_58,
t48.position AS position_59,
t48.post_status AS post_status_60,
t48.sticky AS sticky_61,
t48.post_slug AS post_slug_62,
t48.header AS header_63,
t48.footer AS footer_64,
t48.post_gallery AS post_gallery_65,
t48.last_update AS last_update_66,
t48.form_builder_id AS form_builder_id_67,
t48.siteSeo AS siteSeo_68,
t48.post_category_id AS post_category_id_69
FROM
site_seo t0
LEFT JOIN app_sites t24 ON t24.siteSeo = t0.id
LEFT JOIN post_sites t48 ON t48.siteSeo = t0.id
WHERE
t0.id = ?
SELECT t0.id AS id_1, t0.seo_title AS seo_title_2, t0.seo_content AS seo_content_3, t0.no_index AS no_index_4, t0.no_follow AS no_follow_5, t0.fb_active AS fb_active_6, t0.og_type AS og_type_7, t0.og_title AS og_title_8, t0.og_content AS og_content_9, t0.og_image AS og_image_10, t0.og_active AS og_active_11, t0.x_active AS x_active_12, t0.x_type AS x_type_13, t0.x_site AS x_site_14, t0.x_creator AS x_creator_15, t0.fb_app_id AS fb_app_id_16, t0.fb_admins AS fb_admins_17, t0.title_prefix AS title_prefix_18, t0.title_suffix AS title_suffix_19, t0.title_separator AS title_separator_20, t0.reading_time AS reading_time_21, t0.created_at AS created_at_22, t0.last_update AS last_update_23, t24.id AS id_25, t24.site_slug AS site_slug_26, t24.route_name AS route_name_27, t24.site_content AS site_content_28, t24.site_date AS site_date_29, t24.site_excerpt AS site_excerpt_30, t24.site_status AS site_status_31, t24.comment_status AS comment_status_32, t24.site_type AS site_type_33, t24.site_img AS site_img_34, t24.site_user AS site_user_35, t24.site_password AS site_password_36, t24.excerpt_limit AS excerpt_limit_37, t24.extra_css AS extra_css_38, t24.position AS position_39, t24.header AS header_40, t24.footer AS footer_41, t24.custom AS custom_42, t24.builder_active AS builder_active_43, t24.theme_id AS theme_id_44, t24.siteSeo AS siteSeo_45, t24.form_builder_id AS form_builder_id_46, t24.site_category_id AS site_category_id_47, t48.id AS id_49, t48.post_content AS post_content_50, t48.post_date AS post_date_51, t48.post_end_date AS post_end_date_52, t48.post_excerpt AS post_excerpt_53, t48.comment_status AS comment_status_54, t48.site_type AS site_type_55, t48.site_img AS site_img_56, t48.excerpt_limit AS excerpt_limit_57, t48.extra_css AS extra_css_58, t48.position AS position_59, t48.post_status AS post_status_60, t48.sticky AS sticky_61, t48.post_slug AS post_slug_62, t48.header AS header_63, t48.footer AS footer_64, t48.post_gallery AS post_gallery_65, t48.last_update AS last_update_66, t48.form_builder_id AS form_builder_id_67, t48.siteSeo AS siteSeo_68, t48.post_category_id AS post_category_id_69 FROM site_seo t0 LEFT JOIN app_sites t24 ON t24.siteSeo = t0.id LEFT JOIN post_sites t48 ON t48.siteSeo = t0.id WHERE t0.id = 55;
|
9.71 ms (5.19%)
|
31 |
SELECT t0.id AS id_1, t0.maintenance_mode AS maintenance_mode_2, t0.version AS version_3, t0.installation_id AS installation_id_4, t0.app AS app_5, t0.email AS email_6, t0.oauth AS oauth_7, t0.log AS log_8, t0.register AS register_9 FROM cms_settings t0 LIMIT 1
SELECT t0.id AS id_1, t0.maintenance_mode AS maintenance_mode_2, t0.version AS version_3, t0.installation_id AS installation_id_4, t0.app AS app_5, t0.email AS email_6, t0.oauth AS oauth_7, t0.log AS log_8, t0.register AS register_9 FROM cms_settings t0 LIMIT 1;
|
5.92 ms (3.16%)
|
14 |
SELECT t0.id AS id_1, t0.plugin_name AS plugin_name_2, t0.product AS product_3, t0.license_id AS license_id_4, t0.signed_payload AS signed_payload_5, t0.signature AS signature_6, t0.status AS status_7, t0.features AS features_8, t0.limits AS limits_9, t0.issued_at AS issued_at_10, t0.expires_at AS expires_at_11, t0.refresh_after AS refresh_after_12, t0.grace_until AS grace_until_13, t0.checked_at AS checked_at_14, t0.last_error AS last_error_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17 FROM plugin_license t0 WHERE t0.plugin_name = ? LIMIT 1
Parameters: [
"Analytics"
]
SELECT t0.id AS id_1, t0.plugin_name AS plugin_name_2, t0.product AS product_3, t0.license_id AS license_id_4, t0.signed_payload AS signed_payload_5, t0.signature AS signature_6, t0.status AS status_7, t0.features AS features_8, t0.limits AS limits_9, t0.issued_at AS issued_at_10, t0.expires_at AS expires_at_11, t0.refresh_after AS refresh_after_12, t0.grace_until AS grace_until_13, t0.checked_at AS checked_at_14, t0.last_error AS last_error_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17 FROM plugin_license t0 WHERE t0.plugin_name = 'Analytics' LIMIT 1;
|
5.17 ms (2.77%)
|
15 |
SELECT t0.id AS id_1, t0.register_ip AS register_ip_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.company AS company_5, t0.zip AS zip_6, t0.country AS country_7, t0.street AS street_8, t0.hnr AS hnr_9, t0.phone AS phone_10, t0.mobil AS mobil_11, t0.notiz AS notiz_12, t0.must_validated AS must_validated_13, t0.created_at AS created_at_14, t0.voter AS voter_15, t0.gravatar AS gravatar_16, t0.account_holder_id AS account_holder_id_17 FROM account t0 WHERE t0.account_holder_id IS NULL LIMIT 1
SELECT t0.id AS id_1, t0.register_ip AS register_ip_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.company AS company_5, t0.zip AS zip_6, t0.country AS country_7, t0.street AS street_8, t0.hnr AS hnr_9, t0.phone AS phone_10, t0.mobil AS mobil_11, t0.notiz AS notiz_12, t0.must_validated AS must_validated_13, t0.created_at AS created_at_14, t0.voter AS voter_15, t0.gravatar AS gravatar_16, t0.account_holder_id AS account_holder_id_17 FROM account t0 WHERE t0.account_holder_id IS NULL LIMIT 1;
|
2.68 ms (1.43%)
|
3 |
SELECT c0_.id AS id_0, c0_.scope AS scope_1, c0_.plugin_name AS plugin_name_2, c0_.domain AS domain_3, c0_.messages AS messages_4, c0_.checksum AS checksum_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c1_.id AS id_8, c1_.locale AS locale_9, c1_.name AS name_10, c1_.native_name AS native_name_11, c1_.fallback_locale AS fallback_locale_12, c1_.is_active AS is_active_13, c1_.is_default AS is_default_14, c1_.position AS position_15, c1_.created_at AS created_at_16, c1_.updated_at AS updated_at_17, c0_.language_id AS language_id_18 FROM cms_translation c0_ INNER JOIN cms_language c1_ ON c0_.language_id = c1_.id WHERE c1_.locale = ? AND c1_.is_active = ? ORDER BY c0_.scope ASC, c0_.plugin_name ASC, c0_.domain ASC
SELECT c0_.id AS id_0, c0_.scope AS scope_1, c0_.plugin_name AS plugin_name_2, c0_.domain AS domain_3, c0_.messages AS messages_4, c0_.checksum AS checksum_5, c0_.created_at AS created_at_6, c0_.updated_at AS updated_at_7, c1_.id AS id_8, c1_.locale AS locale_9, c1_.name AS name_10, c1_.native_name AS native_name_11, c1_.fallback_locale AS fallback_locale_12, c1_.is_active AS is_active_13, c1_.is_default AS is_default_14, c1_.position AS position_15, c1_.created_at AS created_at_16, c1_.updated_at AS updated_at_17, c0_.language_id AS language_id_18 FROM cms_translation c0_ INNER JOIN cms_language c1_ ON c0_.language_id = c1_.id WHERE c1_.locale = 'fr' AND c1_.is_active = 1 ORDER BY c0_.scope ASC, c0_.plugin_name ASC, c0_.domain ASC;
|
2.35 ms (1.26%)
|
4 |
SELECT t0.id AS id_1, t0.post_content AS post_content_2, t0.post_date AS post_date_3, t0.post_end_date AS post_end_date_4, t0.post_excerpt AS post_excerpt_5, t0.comment_status AS comment_status_6, t0.site_type AS site_type_7, t0.site_img AS site_img_8, t0.excerpt_limit AS excerpt_limit_9, t0.extra_css AS extra_css_10, t0.position AS position_11, t0.post_status AS post_status_12, t0.sticky AS sticky_13, t0.post_slug AS post_slug_14, t0.header AS header_15, t0.footer AS footer_16, t0.post_gallery AS post_gallery_17, t0.last_update AS last_update_18, t0.form_builder_id AS form_builder_id_19, t0.siteSeo AS siteSeo_20, t0.post_category_id AS post_category_id_21 FROM post_sites t0 WHERE t0.site_type = ? AND t0.post_status = ? ORDER BY t0.position ASC
Parameters: [
"post"
"publish"
]
SELECT t0.id AS id_1, t0.post_content AS post_content_2, t0.post_date AS post_date_3, t0.post_end_date AS post_end_date_4, t0.post_excerpt AS post_excerpt_5, t0.comment_status AS comment_status_6, t0.site_type AS site_type_7, t0.site_img AS site_img_8, t0.excerpt_limit AS excerpt_limit_9, t0.extra_css AS extra_css_10, t0.position AS position_11, t0.post_status AS post_status_12, t0.sticky AS sticky_13, t0.post_slug AS post_slug_14, t0.header AS header_15, t0.footer AS footer_16, t0.post_gallery AS post_gallery_17, t0.last_update AS last_update_18, t0.form_builder_id AS form_builder_id_19, t0.siteSeo AS siteSeo_20, t0.post_category_id AS post_category_id_21 FROM post_sites t0 WHERE t0.site_type = 'post' AND t0.post_status = 'publish' ORDER BY t0.position ASC;
|
1.43 ms (0.77%)
|
4 |
SELECT t0.id AS id_1, t0.settings AS settings_2, t0.designation AS designation_3, t0.type AS type_4, t0.created_at AS created_at_5 FROM page_builder_media t0 WHERE t0.type = ?
Parameters: [
"gallery"
]
SELECT t0.id AS id_1, t0.settings AS settings_2, t0.designation AS designation_3, t0.type AS type_4, t0.created_at AS created_at_5 FROM page_builder_media t0 WHERE t0.type = 'gallery';
|
1.42 ms (0.76%)
|
3 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.position AS position_4, t0.type AS type_5, t0.cat_img AS cat_img_6, t0.slug AS slug_7, t0.created_at AS created_at_8, t0.theme_id AS theme_id_9, t0.category_design_id AS category_design_id_10, t0.post_design_id AS post_design_id_11, t0.post_loop_id AS post_loop_id_12, t0.category_header_id AS category_header_id_13, t0.category_footer_id AS category_footer_id_14, t0.post_header_id AS post_header_id_15, t0.post_footer_id AS post_footer_id_16 FROM post_category t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.position AS position_4, t0.type AS type_5, t0.cat_img AS cat_img_6, t0.slug AS slug_7, t0.created_at AS created_at_8, t0.theme_id AS theme_id_9, t0.category_design_id AS category_design_id_10, t0.post_design_id AS post_design_id_11, t0.post_loop_id AS post_loop_id_12, t0.category_header_id AS category_header_id_13, t0.category_footer_id AS category_footer_id_14, t0.post_header_id AS post_header_id_15, t0.post_footer_id AS post_footer_id_16 FROM post_category t0 WHERE t0.id = 9;
|
1.38 ms (0.74%)
|
4 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.designation AS designation_3, t0.map_data AS map_data_4, t0.created_at AS created_at_5 FROM app_maps t0 WHERE t0.type = ?
Parameters: [
"protection"
]
SELECT t0.id AS id_1, t0.type AS type_2, t0.designation AS designation_3, t0.map_data AS map_data_4, t0.created_at AS created_at_5 FROM app_maps t0 WHERE t0.type = 'protection';
|
1.21 ms (0.65%)
|
2 |
SELECT t0.id AS id_1, t0.site_slug AS site_slug_2, t0.route_name AS route_name_3, t0.site_content AS site_content_4, t0.site_date AS site_date_5, t0.site_excerpt AS site_excerpt_6, t0.site_status AS site_status_7, t0.comment_status AS comment_status_8, t0.site_type AS site_type_9, t0.site_img AS site_img_10, t0.site_user AS site_user_11, t0.site_password AS site_password_12, t0.excerpt_limit AS excerpt_limit_13, t0.extra_css AS extra_css_14, t0.position AS position_15, t0.header AS header_16, t0.footer AS footer_17, t0.custom AS custom_18, t0.builder_active AS builder_active_19, t0.theme_id AS theme_id_20, t0.siteSeo AS siteSeo_21, t0.form_builder_id AS form_builder_id_22, t0.site_category_id AS site_category_id_23 FROM app_sites t0 WHERE t0.site_type = ? AND t0.site_status = ? ORDER BY t0.position ASC
Parameters: [
"page"
"publish"
]
SELECT t0.id AS id_1, t0.site_slug AS site_slug_2, t0.route_name AS route_name_3, t0.site_content AS site_content_4, t0.site_date AS site_date_5, t0.site_excerpt AS site_excerpt_6, t0.site_status AS site_status_7, t0.comment_status AS comment_status_8, t0.site_type AS site_type_9, t0.site_img AS site_img_10, t0.site_user AS site_user_11, t0.site_password AS site_password_12, t0.excerpt_limit AS excerpt_limit_13, t0.extra_css AS extra_css_14, t0.position AS position_15, t0.header AS header_16, t0.footer AS footer_17, t0.custom AS custom_18, t0.builder_active AS builder_active_19, t0.theme_id AS theme_id_20, t0.siteSeo AS siteSeo_21, t0.form_builder_id AS form_builder_id_22, t0.site_category_id AS site_category_id_23 FROM app_sites t0 WHERE t0.site_type = 'page' AND t0.site_status = 'publish' ORDER BY t0.position ASC;
|
0.83 ms (0.44%)
|
1 |
SELECT t0.id AS id_1, t0.site_slug AS site_slug_2, t0.route_name AS route_name_3, t0.site_content AS site_content_4, t0.site_date AS site_date_5, t0.site_excerpt AS site_excerpt_6, t0.site_status AS site_status_7, t0.comment_status AS comment_status_8, t0.site_type AS site_type_9, t0.site_img AS site_img_10, t0.site_user AS site_user_11, t0.site_password AS site_password_12, t0.excerpt_limit AS excerpt_limit_13, t0.extra_css AS extra_css_14, t0.position AS position_15, t0.header AS header_16, t0.footer AS footer_17, t0.custom AS custom_18, t0.builder_active AS builder_active_19, t0.theme_id AS theme_id_20, t0.siteSeo AS siteSeo_21, t0.form_builder_id AS form_builder_id_22, t0.site_category_id AS site_category_id_23 FROM app_sites t0 WHERE t0.theme_id = ? AND t0.site_type = ? AND t0.site_status = ? ORDER BY t0.position ASC
Parameters: [
10
"page"
"publish"
]
SELECT t0.id AS id_1, t0.site_slug AS site_slug_2, t0.route_name AS route_name_3, t0.site_content AS site_content_4, t0.site_date AS site_date_5, t0.site_excerpt AS site_excerpt_6, t0.site_status AS site_status_7, t0.comment_status AS comment_status_8, t0.site_type AS site_type_9, t0.site_img AS site_img_10, t0.site_user AS site_user_11, t0.site_password AS site_password_12, t0.excerpt_limit AS excerpt_limit_13, t0.extra_css AS extra_css_14, t0.position AS position_15, t0.header AS header_16, t0.footer AS footer_17, t0.custom AS custom_18, t0.builder_active AS builder_active_19, t0.theme_id AS theme_id_20, t0.siteSeo AS siteSeo_21, t0.form_builder_id AS form_builder_id_22, t0.site_category_id AS site_category_id_23 FROM app_sites t0 WHERE t0.theme_id = 10 AND t0.site_type = 'page' AND t0.site_status = 'publish' ORDER BY t0.position ASC;
|
0.77 ms (0.41%)
|
1 |
SELECT a0_.id AS id_0, a0_.site_slug AS site_slug_1, a0_.route_name AS route_name_2, a0_.site_content AS site_content_3, a0_.site_date AS site_date_4, a0_.site_excerpt AS site_excerpt_5, a0_.site_status AS site_status_6, a0_.comment_status AS comment_status_7, a0_.site_type AS site_type_8, a0_.site_img AS site_img_9, a0_.site_user AS site_user_10, a0_.site_password AS site_password_11, a0_.excerpt_limit AS excerpt_limit_12, a0_.extra_css AS extra_css_13, a0_.position AS position_14, a0_.header AS header_15, a0_.footer AS footer_16, a0_.custom AS custom_17, a0_.builder_active AS builder_active_18, a0_.theme_id AS theme_id_19, a0_.siteSeo AS siteSeo_20, a0_.form_builder_id AS form_builder_id_21, a0_.site_category_id AS site_category_id_22 FROM app_sites a0_ INNER JOIN site_category s1_ ON a0_.site_category_id = s1_.id WHERE a0_.site_type = ? AND s1_.theme_id = ? ORDER BY a0_.position ASC
Parameters: [
"page"
10
]
SELECT a0_.id AS id_0, a0_.site_slug AS site_slug_1, a0_.route_name AS route_name_2, a0_.site_content AS site_content_3, a0_.site_date AS site_date_4, a0_.site_excerpt AS site_excerpt_5, a0_.site_status AS site_status_6, a0_.comment_status AS comment_status_7, a0_.site_type AS site_type_8, a0_.site_img AS site_img_9, a0_.site_user AS site_user_10, a0_.site_password AS site_password_11, a0_.excerpt_limit AS excerpt_limit_12, a0_.extra_css AS extra_css_13, a0_.position AS position_14, a0_.header AS header_15, a0_.footer AS footer_16, a0_.custom AS custom_17, a0_.builder_active AS builder_active_18, a0_.theme_id AS theme_id_19, a0_.siteSeo AS siteSeo_20, a0_.form_builder_id AS form_builder_id_21, a0_.site_category_id AS site_category_id_22 FROM app_sites a0_ INNER JOIN site_category s1_ ON a0_.site_category_id = s1_.id WHERE a0_.site_type = 'page' AND s1_.theme_id = 10 ORDER BY a0_.position ASC;
|
0.61 ms (0.32%)
|
1 |
SELECT p0_.id AS id_0, p0_.post_content AS post_content_1, p0_.post_date AS post_date_2, p0_.post_end_date AS post_end_date_3, p0_.post_excerpt AS post_excerpt_4, p0_.comment_status AS comment_status_5, p0_.site_type AS site_type_6, p0_.site_img AS site_img_7, p0_.excerpt_limit AS excerpt_limit_8, p0_.extra_css AS extra_css_9, p0_.position AS position_10, p0_.post_status AS post_status_11, p0_.sticky AS sticky_12, p0_.post_slug AS post_slug_13, p0_.header AS header_14, p0_.footer AS footer_15, p0_.post_gallery AS post_gallery_16, p0_.last_update AS last_update_17, p0_.form_builder_id AS form_builder_id_18, p0_.siteSeo AS siteSeo_19, p0_.post_category_id AS post_category_id_20 FROM post_sites p0_ INNER JOIN post_category p1_ ON p0_.post_category_id = p1_.id WHERE p0_.site_type = ? AND p1_.theme_id = ? ORDER BY p0_.position ASC
Parameters: [
"post"
10
]
SELECT p0_.id AS id_0, p0_.post_content AS post_content_1, p0_.post_date AS post_date_2, p0_.post_end_date AS post_end_date_3, p0_.post_excerpt AS post_excerpt_4, p0_.comment_status AS comment_status_5, p0_.site_type AS site_type_6, p0_.site_img AS site_img_7, p0_.excerpt_limit AS excerpt_limit_8, p0_.extra_css AS extra_css_9, p0_.position AS position_10, p0_.post_status AS post_status_11, p0_.sticky AS sticky_12, p0_.post_slug AS post_slug_13, p0_.header AS header_14, p0_.footer AS footer_15, p0_.post_gallery AS post_gallery_16, p0_.last_update AS last_update_17, p0_.form_builder_id AS form_builder_id_18, p0_.siteSeo AS siteSeo_19, p0_.post_category_id AS post_category_id_20 FROM post_sites p0_ INNER JOIN post_category p1_ ON p0_.post_category_id = p1_.id WHERE p0_.site_type = 'post' AND p1_.theme_id = 10 ORDER BY p0_.position ASC;
|
0.56 ms (0.30%)
|
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.position AS position_4, t0.type AS type_5, t0.cat_img AS cat_img_6, t0.slug AS slug_7, t0.created_at AS created_at_8, t0.theme_id AS theme_id_9, t0.category_design_id AS category_design_id_10, t0.post_design_id AS post_design_id_11, t0.post_loop_id AS post_loop_id_12, t0.category_header_id AS category_header_id_13, t0.category_footer_id AS category_footer_id_14, t0.post_header_id AS post_header_id_15, t0.post_footer_id AS post_footer_id_16 FROM post_category t0 WHERE t0.theme_id = ? ORDER BY t0.title ASC
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.position AS position_4, t0.type AS type_5, t0.cat_img AS cat_img_6, t0.slug AS slug_7, t0.created_at AS created_at_8, t0.theme_id AS theme_id_9, t0.category_design_id AS category_design_id_10, t0.post_design_id AS post_design_id_11, t0.post_loop_id AS post_loop_id_12, t0.category_header_id AS category_header_id_13, t0.category_footer_id AS category_footer_id_14, t0.post_header_id AS post_header_id_15, t0.post_footer_id AS post_footer_id_16 FROM post_category t0 WHERE t0.theme_id = 10 ORDER BY t0.title ASC;
|
0.53 ms (0.28%)
|
1 |
SELECT t0.id AS id_1, t0.theme_id AS theme_id_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.version AS version_6, t0.system_theme AS system_theme_7, t0.manifest AS manifest_8, t0.compiler_settings AS compiler_settings_9, t0.source_path AS source_path_10, t0.source_checksum AS source_checksum_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM page_builder_theme t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.theme_id AS theme_id_2, t0.name AS name_3, t0.slug AS slug_4, t0.description AS description_5, t0.version AS version_6, t0.system_theme AS system_theme_7, t0.manifest AS manifest_8, t0.compiler_settings AS compiler_settings_9, t0.source_path AS source_path_10, t0.source_checksum AS source_checksum_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13 FROM page_builder_theme t0 WHERE t0.id = 10;
|
0.48 ms (0.26%)
|
1 |
SELECT t0.id AS id_1, t0.active_theme_id AS active_theme_id_2 FROM page_builder_settings t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.active_theme_id AS active_theme_id_2 FROM page_builder_settings t0 WHERE t0.id = 1;
|
0.46 ms (0.24%)
|
1 |
SELECT t0.id AS id_1, t0.scope_key AS scope_key_2, t0.design AS design_3, t0.scss AS scss_4, t0.created_at AS created_at_5 FROM app_design t0 WHERE t0.scope_key = ? ORDER BY t0.id DESC LIMIT 1
Parameters: [
"6cb81143-bcf1-41e7-a2a9-5ec4ad82678f"
]
SELECT t0.id AS id_1, t0.scope_key AS scope_key_2, t0.design AS design_3, t0.scss AS scss_4, t0.created_at AS created_at_5 FROM app_design t0 WHERE t0.scope_key = '6cb81143-bcf1-41e7-a2a9-5ec4ad82678f' ORDER BY t0.id DESC LIMIT 1;
|
0.38 ms (0.20%)
|
1 |
SELECT theme.theme_id
FROM page_builder_settings settings
INNER JOIN page_builder_theme theme ON theme.id = settings.active_theme_id
WHERE settings.id = 1
SELECT theme.theme_id
FROM page_builder_settings settings
INNER JOIN page_builder_theme theme ON theme.id = settings.active_theme_id
WHERE settings.id = 1;
|
0.35 ms (0.19%)
|
1 |
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.form_id AS form_id_3, t0.type AS type_4, t0.form AS form_5, t0.created_at AS created_at_6 FROM page_builder_forms t0
SELECT t0.id AS id_1, t0.designation AS designation_2, t0.form_id AS form_id_3, t0.type AS type_4, t0.form AS form_5, t0.created_at AS created_at_6 FROM page_builder_forms t0;
|
0.34 ms (0.18%)
|
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.position AS position_4, t0.type AS type_5, t0.cat_img AS cat_img_6, t0.slug AS slug_7, t0.created_at AS created_at_8, t0.theme_id AS theme_id_9, t0.category_design_id AS category_design_id_10, t0.post_design_id AS post_design_id_11, t0.post_loop_id AS post_loop_id_12, t0.category_header_id AS category_header_id_13, t0.category_footer_id AS category_footer_id_14, t0.post_header_id AS post_header_id_15, t0.post_footer_id AS post_footer_id_16 FROM post_category t0 WHERE t0.theme_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.position AS position_4, t0.type AS type_5, t0.cat_img AS cat_img_6, t0.slug AS slug_7, t0.created_at AS created_at_8, t0.theme_id AS theme_id_9, t0.category_design_id AS category_design_id_10, t0.post_design_id AS post_design_id_11, t0.post_loop_id AS post_loop_id_12, t0.category_header_id AS category_header_id_13, t0.category_footer_id AS category_footer_id_14, t0.post_header_id AS post_header_id_15, t0.post_footer_id AS post_footer_id_16 FROM post_category t0 WHERE t0.theme_id = 10 ORDER BY t0.position ASC;
|