1 |
1.09 ms |
SELECT c0_.id AS id_0, c0_.version AS version_1, c0_.featured_image AS featured_image_2, c0_.media_url AS media_url_3, c0_.type AS type_4, c0_.template AS template_5, c0_.title AS title_6, c0_.slug AS slug_7, c0_.searchable AS searchable_8, c0_.exclude_from_list AS exclude_from_list_9, c0_.permission AS permission_10, c0_.status AS status_11, c0_.members_only AS members_only_12, c0_.include_author_byline AS include_author_byline_13, c0_.include_author_bio AS include_author_bio_14, c0_.include_customer_call_to_action AS include_customer_call_to_action_15, c0_.include_customer_bio AS include_customer_bio_16, c0_.total_impressions AS total_impressions_17, c0_.total_clicks AS total_clicks_18, c0_.published_at AS published_at_19, c0_.modified_at AS modified_at_20, c0_.created_at AS created_at_21, c0_.content_intro AS content_intro_22, c0_.content_full AS content_full_23, c0_.meta_description AS meta_description_24, c0_.meta_keywords AS meta_keywords_25, c0_.content_builder AS content_builder_26, c0_.show_title AS show_title_27, c0_.old_id AS old_id_28, c0_.featured AS featured_29, c0_.announcement AS announcement_30, c0_.announcement_sites AS announcement_sites_31, c0_.expires_at AS expires_at_32, c0_.hootsuite_content AS hootsuite_content_33, c0_.hootsuite_facebook_content AS hootsuite_facebook_content_34, c0_.hootsuite_twitter_content AS hootsuite_twitter_content_35, c0_.hootsuite_linkedin_content AS hootsuite_linkedin_content_36, c0_.hootsuite_to_publish AS hootsuite_to_publish_37, c0_.hootsuite_use_post_media AS hootsuite_use_post_media_38, c0_.hootsuite_use_post_published_at AS hootsuite_use_post_published_at_39, c0_.hootsuite_published_at AS hootsuite_published_at_40, c0_.prnt_id AS prnt_id_41, c0_.media_id AS media_id_42, c0_.dummy_media_id AS dummy_media_id_43, c0_.video_media_id AS video_media_id_44, c0_.author_id AS author_id_45, c0_.category_id AS category_id_46, c0_.primary_customer_id AS primary_customer_id_47, c0_.form_id AS form_id_48, c0_.popout_ad_id AS popout_ad_id_49, c0_.hootsuite_media_id AS hootsuite_media_id_50 FROM content c0_ INNER JOIN content_site c2_ ON c0_.id = c2_.content_id INNER JOIN site s1_ ON s1_.id = c2_.site_id WHERE c0_.slug = ? AND s1_.id = ?
Parameters: [
"bafkreicyqcbhpicbos7ev4mrxofwqx6hvvge7pahpta6xuspr44crai5by"
1
]
SELECT
c0_.id AS id_0,
c0_.version AS version_1,
c0_.featured_image AS featured_image_2,
c0_.media_url AS media_url_3,
c0_.type AS type_4,
c0_.template AS template_5,
c0_.title AS title_6,
c0_.slug AS slug_7,
c0_.searchable AS searchable_8,
c0_.exclude_from_list AS exclude_from_list_9,
c0_.permission AS permission_10,
c0_.status AS status_11,
c0_.members_only AS members_only_12,
c0_.include_author_byline AS include_author_byline_13,
c0_.include_author_bio AS include_author_bio_14,
c0_.include_customer_call_to_action AS include_customer_call_to_action_15,
c0_.include_customer_bio AS include_customer_bio_16,
c0_.total_impressions AS total_impressions_17,
c0_.total_clicks AS total_clicks_18,
c0_.published_at AS published_at_19,
c0_.modified_at AS modified_at_20,
c0_.created_at AS created_at_21,
c0_.content_intro AS content_intro_22,
c0_.content_full AS content_full_23,
c0_.meta_description AS meta_description_24,
c0_.meta_keywords AS meta_keywords_25,
c0_.content_builder AS content_builder_26,
c0_.show_title AS show_title_27,
c0_.old_id AS old_id_28,
c0_.featured AS featured_29,
c0_.announcement AS announcement_30,
c0_.announcement_sites AS announcement_sites_31,
c0_.expires_at AS expires_at_32,
c0_.hootsuite_content AS hootsuite_content_33,
c0_.hootsuite_facebook_content AS hootsuite_facebook_content_34,
c0_.hootsuite_twitter_content AS hootsuite_twitter_content_35,
c0_.hootsuite_linkedin_content AS hootsuite_linkedin_content_36,
c0_.hootsuite_to_publish AS hootsuite_to_publish_37,
c0_.hootsuite_use_post_media AS hootsuite_use_post_media_38,
c0_.hootsuite_use_post_published_at AS hootsuite_use_post_published_at_39,
c0_.hootsuite_published_at AS hootsuite_published_at_40,
c0_.prnt_id AS prnt_id_41,
c0_.media_id AS media_id_42,
c0_.dummy_media_id AS dummy_media_id_43,
c0_.video_media_id AS video_media_id_44,
c0_.author_id AS author_id_45,
c0_.category_id AS category_id_46,
c0_.primary_customer_id AS primary_customer_id_47,
c0_.form_id AS form_id_48,
c0_.popout_ad_id AS popout_ad_id_49,
c0_.hootsuite_media_id AS hootsuite_media_id_50
FROM
content c0_
INNER JOIN content_site c2_ ON c0_.id = c2_.content_id
INNER JOIN site s1_ ON s1_.id = c2_.site_id
WHERE
c0_.slug = ?
AND s1_.id = ?
SELECT c0_.id AS id_0, c0_.version AS version_1, c0_.featured_image AS featured_image_2, c0_.media_url AS media_url_3, c0_.type AS type_4, c0_.template AS template_5, c0_.title AS title_6, c0_.slug AS slug_7, c0_.searchable AS searchable_8, c0_.exclude_from_list AS exclude_from_list_9, c0_.permission AS permission_10, c0_.status AS status_11, c0_.members_only AS members_only_12, c0_.include_author_byline AS include_author_byline_13, c0_.include_author_bio AS include_author_bio_14, c0_.include_customer_call_to_action AS include_customer_call_to_action_15, c0_.include_customer_bio AS include_customer_bio_16, c0_.total_impressions AS total_impressions_17, c0_.total_clicks AS total_clicks_18, c0_.published_at AS published_at_19, c0_.modified_at AS modified_at_20, c0_.created_at AS created_at_21, c0_.content_intro AS content_intro_22, c0_.content_full AS content_full_23, c0_.meta_description AS meta_description_24, c0_.meta_keywords AS meta_keywords_25, c0_.content_builder AS content_builder_26, c0_.show_title AS show_title_27, c0_.old_id AS old_id_28, c0_.featured AS featured_29, c0_.announcement AS announcement_30, c0_.announcement_sites AS announcement_sites_31, c0_.expires_at AS expires_at_32, c0_.hootsuite_content AS hootsuite_content_33, c0_.hootsuite_facebook_content AS hootsuite_facebook_content_34, c0_.hootsuite_twitter_content AS hootsuite_twitter_content_35, c0_.hootsuite_linkedin_content AS hootsuite_linkedin_content_36, c0_.hootsuite_to_publish AS hootsuite_to_publish_37, c0_.hootsuite_use_post_media AS hootsuite_use_post_media_38, c0_.hootsuite_use_post_published_at AS hootsuite_use_post_published_at_39, c0_.hootsuite_published_at AS hootsuite_published_at_40, c0_.prnt_id AS prnt_id_41, c0_.media_id AS media_id_42, c0_.dummy_media_id AS dummy_media_id_43, c0_.video_media_id AS video_media_id_44, c0_.author_id AS author_id_45, c0_.category_id AS category_id_46, c0_.primary_customer_id AS primary_customer_id_47, c0_.form_id AS form_id_48, c0_.popout_ad_id AS popout_ad_id_49, c0_.hootsuite_media_id AS hootsuite_media_id_50 FROM content c0_ INNER JOIN content_site c2_ ON c0_.id = c2_.content_id INNER JOIN site s1_ ON s1_.id = c2_.site_id WHERE c0_.slug = 'bafkreicyqcbhpicbos7ev4mrxofwqx6hvvge7pahpta6xuspr44crai5by' AND s1_.id = 1;
|
2 |
0.75 ms |
SELECT c0_.id AS id_0, c0_.version AS version_1, c0_.featured_image AS featured_image_2, c0_.media_url AS media_url_3, c0_.type AS type_4, c0_.template AS template_5, c0_.title AS title_6, c0_.slug AS slug_7, c0_.searchable AS searchable_8, c0_.exclude_from_list AS exclude_from_list_9, c0_.permission AS permission_10, c0_.status AS status_11, c0_.members_only AS members_only_12, c0_.include_author_byline AS include_author_byline_13, c0_.include_author_bio AS include_author_bio_14, c0_.include_customer_call_to_action AS include_customer_call_to_action_15, c0_.include_customer_bio AS include_customer_bio_16, c0_.total_impressions AS total_impressions_17, c0_.total_clicks AS total_clicks_18, c0_.published_at AS published_at_19, c0_.modified_at AS modified_at_20, c0_.created_at AS created_at_21, c0_.content_intro AS content_intro_22, c0_.content_full AS content_full_23, c0_.meta_description AS meta_description_24, c0_.meta_keywords AS meta_keywords_25, c0_.content_builder AS content_builder_26, c0_.show_title AS show_title_27, c0_.old_id AS old_id_28, c0_.featured AS featured_29, c0_.announcement AS announcement_30, c0_.announcement_sites AS announcement_sites_31, c0_.expires_at AS expires_at_32, c0_.hootsuite_content AS hootsuite_content_33, c0_.hootsuite_facebook_content AS hootsuite_facebook_content_34, c0_.hootsuite_twitter_content AS hootsuite_twitter_content_35, c0_.hootsuite_linkedin_content AS hootsuite_linkedin_content_36, c0_.hootsuite_to_publish AS hootsuite_to_publish_37, c0_.hootsuite_use_post_media AS hootsuite_use_post_media_38, c0_.hootsuite_use_post_published_at AS hootsuite_use_post_published_at_39, c0_.hootsuite_published_at AS hootsuite_published_at_40, c0_.prnt_id AS prnt_id_41, c0_.media_id AS media_id_42, c0_.dummy_media_id AS dummy_media_id_43, c0_.video_media_id AS video_media_id_44, c0_.author_id AS author_id_45, c0_.category_id AS category_id_46, c0_.primary_customer_id AS primary_customer_id_47, c0_.form_id AS form_id_48, c0_.popout_ad_id AS popout_ad_id_49, c0_.hootsuite_media_id AS hootsuite_media_id_50 FROM content c0_ INNER JOIN content_site c2_ ON c0_.id = c2_.content_id INNER JOIN site s1_ ON s1_.id = c2_.site_id AND (s1_.id = ?) WHERE c0_.slug = ? AND c0_.type = ? AND (c0_.status = 1 OR c0_.status = -5) LIMIT 1
Parameters: [
1
"ipfs"
1
]
SELECT
c0_.id AS id_0,
c0_.version AS version_1,
c0_.featured_image AS featured_image_2,
c0_.media_url AS media_url_3,
c0_.type AS type_4,
c0_.template AS template_5,
c0_.title AS title_6,
c0_.slug AS slug_7,
c0_.searchable AS searchable_8,
c0_.exclude_from_list AS exclude_from_list_9,
c0_.permission AS permission_10,
c0_.status AS status_11,
c0_.members_only AS members_only_12,
c0_.include_author_byline AS include_author_byline_13,
c0_.include_author_bio AS include_author_bio_14,
c0_.include_customer_call_to_action AS include_customer_call_to_action_15,
c0_.include_customer_bio AS include_customer_bio_16,
c0_.total_impressions AS total_impressions_17,
c0_.total_clicks AS total_clicks_18,
c0_.published_at AS published_at_19,
c0_.modified_at AS modified_at_20,
c0_.created_at AS created_at_21,
c0_.content_intro AS content_intro_22,
c0_.content_full AS content_full_23,
c0_.meta_description AS meta_description_24,
c0_.meta_keywords AS meta_keywords_25,
c0_.content_builder AS content_builder_26,
c0_.show_title AS show_title_27,
c0_.old_id AS old_id_28,
c0_.featured AS featured_29,
c0_.announcement AS announcement_30,
c0_.announcement_sites AS announcement_sites_31,
c0_.expires_at AS expires_at_32,
c0_.hootsuite_content AS hootsuite_content_33,
c0_.hootsuite_facebook_content AS hootsuite_facebook_content_34,
c0_.hootsuite_twitter_content AS hootsuite_twitter_content_35,
c0_.hootsuite_linkedin_content AS hootsuite_linkedin_content_36,
c0_.hootsuite_to_publish AS hootsuite_to_publish_37,
c0_.hootsuite_use_post_media AS hootsuite_use_post_media_38,
c0_.hootsuite_use_post_published_at AS hootsuite_use_post_published_at_39,
c0_.hootsuite_published_at AS hootsuite_published_at_40,
c0_.prnt_id AS prnt_id_41,
c0_.media_id AS media_id_42,
c0_.dummy_media_id AS dummy_media_id_43,
c0_.video_media_id AS video_media_id_44,
c0_.author_id AS author_id_45,
c0_.category_id AS category_id_46,
c0_.primary_customer_id AS primary_customer_id_47,
c0_.form_id AS form_id_48,
c0_.popout_ad_id AS popout_ad_id_49,
c0_.hootsuite_media_id AS hootsuite_media_id_50
FROM
content c0_
INNER JOIN content_site c2_ ON c0_.id = c2_.content_id
INNER JOIN site s1_ ON s1_.id = c2_.site_id
AND (s1_.id = ?)
WHERE
c0_.slug = ?
AND c0_.type = ?
AND (
c0_.status = 1
OR c0_.status = -5
)
LIMIT
1
SELECT c0_.id AS id_0, c0_.version AS version_1, c0_.featured_image AS featured_image_2, c0_.media_url AS media_url_3, c0_.type AS type_4, c0_.template AS template_5, c0_.title AS title_6, c0_.slug AS slug_7, c0_.searchable AS searchable_8, c0_.exclude_from_list AS exclude_from_list_9, c0_.permission AS permission_10, c0_.status AS status_11, c0_.members_only AS members_only_12, c0_.include_author_byline AS include_author_byline_13, c0_.include_author_bio AS include_author_bio_14, c0_.include_customer_call_to_action AS include_customer_call_to_action_15, c0_.include_customer_bio AS include_customer_bio_16, c0_.total_impressions AS total_impressions_17, c0_.total_clicks AS total_clicks_18, c0_.published_at AS published_at_19, c0_.modified_at AS modified_at_20, c0_.created_at AS created_at_21, c0_.content_intro AS content_intro_22, c0_.content_full AS content_full_23, c0_.meta_description AS meta_description_24, c0_.meta_keywords AS meta_keywords_25, c0_.content_builder AS content_builder_26, c0_.show_title AS show_title_27, c0_.old_id AS old_id_28, c0_.featured AS featured_29, c0_.announcement AS announcement_30, c0_.announcement_sites AS announcement_sites_31, c0_.expires_at AS expires_at_32, c0_.hootsuite_content AS hootsuite_content_33, c0_.hootsuite_facebook_content AS hootsuite_facebook_content_34, c0_.hootsuite_twitter_content AS hootsuite_twitter_content_35, c0_.hootsuite_linkedin_content AS hootsuite_linkedin_content_36, c0_.hootsuite_to_publish AS hootsuite_to_publish_37, c0_.hootsuite_use_post_media AS hootsuite_use_post_media_38, c0_.hootsuite_use_post_published_at AS hootsuite_use_post_published_at_39, c0_.hootsuite_published_at AS hootsuite_published_at_40, c0_.prnt_id AS prnt_id_41, c0_.media_id AS media_id_42, c0_.dummy_media_id AS dummy_media_id_43, c0_.video_media_id AS video_media_id_44, c0_.author_id AS author_id_45, c0_.category_id AS category_id_46, c0_.primary_customer_id AS primary_customer_id_47, c0_.form_id AS form_id_48, c0_.popout_ad_id AS popout_ad_id_49, c0_.hootsuite_media_id AS hootsuite_media_id_50 FROM content c0_ INNER JOIN content_site c2_ ON c0_.id = c2_.content_id INNER JOIN site s1_ ON s1_.id = c2_.site_id AND (s1_.id = 1) WHERE c0_.slug = 'ipfs' AND c0_.type = 1 AND (c0_.status = 1 OR c0_.status = -5) LIMIT 1;
|
3 |
0.60 ms |
SELECT c0_.id AS id_0, c0_.version AS version_1, c0_.featured_image AS featured_image_2, c0_.media_url AS media_url_3, c0_.type AS type_4, c0_.template AS template_5, c0_.title AS title_6, c0_.slug AS slug_7, c0_.searchable AS searchable_8, c0_.exclude_from_list AS exclude_from_list_9, c0_.permission AS permission_10, c0_.status AS status_11, c0_.members_only AS members_only_12, c0_.include_author_byline AS include_author_byline_13, c0_.include_author_bio AS include_author_bio_14, c0_.include_customer_call_to_action AS include_customer_call_to_action_15, c0_.include_customer_bio AS include_customer_bio_16, c0_.total_impressions AS total_impressions_17, c0_.total_clicks AS total_clicks_18, c0_.published_at AS published_at_19, c0_.modified_at AS modified_at_20, c0_.created_at AS created_at_21, c0_.content_intro AS content_intro_22, c0_.content_full AS content_full_23, c0_.meta_description AS meta_description_24, c0_.meta_keywords AS meta_keywords_25, c0_.content_builder AS content_builder_26, c0_.show_title AS show_title_27, c0_.old_id AS old_id_28, c0_.featured AS featured_29, c0_.announcement AS announcement_30, c0_.announcement_sites AS announcement_sites_31, c0_.expires_at AS expires_at_32, c0_.hootsuite_content AS hootsuite_content_33, c0_.hootsuite_facebook_content AS hootsuite_facebook_content_34, c0_.hootsuite_twitter_content AS hootsuite_twitter_content_35, c0_.hootsuite_linkedin_content AS hootsuite_linkedin_content_36, c0_.hootsuite_to_publish AS hootsuite_to_publish_37, c0_.hootsuite_use_post_media AS hootsuite_use_post_media_38, c0_.hootsuite_use_post_published_at AS hootsuite_use_post_published_at_39, c0_.hootsuite_published_at AS hootsuite_published_at_40, c0_.prnt_id AS prnt_id_41, c0_.media_id AS media_id_42, c0_.dummy_media_id AS dummy_media_id_43, c0_.video_media_id AS video_media_id_44, c0_.author_id AS author_id_45, c0_.category_id AS category_id_46, c0_.primary_customer_id AS primary_customer_id_47, c0_.form_id AS form_id_48, c0_.popout_ad_id AS popout_ad_id_49, c0_.hootsuite_media_id AS hootsuite_media_id_50 FROM content c0_ INNER JOIN content_site c2_ ON c0_.id = c2_.content_id INNER JOIN site s1_ ON s1_.id = c2_.site_id AND (s1_.id = ?) WHERE c0_.slug = ? AND c0_.type = ? AND (c0_.status = 1 OR c0_.status = -5) LIMIT 1
Parameters: [
1
"ipfs"
2
]
SELECT
c0_.id AS id_0,
c0_.version AS version_1,
c0_.featured_image AS featured_image_2,
c0_.media_url AS media_url_3,
c0_.type AS type_4,
c0_.template AS template_5,
c0_.title AS title_6,
c0_.slug AS slug_7,
c0_.searchable AS searchable_8,
c0_.exclude_from_list AS exclude_from_list_9,
c0_.permission AS permission_10,
c0_.status AS status_11,
c0_.members_only AS members_only_12,
c0_.include_author_byline AS include_author_byline_13,
c0_.include_author_bio AS include_author_bio_14,
c0_.include_customer_call_to_action AS include_customer_call_to_action_15,
c0_.include_customer_bio AS include_customer_bio_16,
c0_.total_impressions AS total_impressions_17,
c0_.total_clicks AS total_clicks_18,
c0_.published_at AS published_at_19,
c0_.modified_at AS modified_at_20,
c0_.created_at AS created_at_21,
c0_.content_intro AS content_intro_22,
c0_.content_full AS content_full_23,
c0_.meta_description AS meta_description_24,
c0_.meta_keywords AS meta_keywords_25,
c0_.content_builder AS content_builder_26,
c0_.show_title AS show_title_27,
c0_.old_id AS old_id_28,
c0_.featured AS featured_29,
c0_.announcement AS announcement_30,
c0_.announcement_sites AS announcement_sites_31,
c0_.expires_at AS expires_at_32,
c0_.hootsuite_content AS hootsuite_content_33,
c0_.hootsuite_facebook_content AS hootsuite_facebook_content_34,
c0_.hootsuite_twitter_content AS hootsuite_twitter_content_35,
c0_.hootsuite_linkedin_content AS hootsuite_linkedin_content_36,
c0_.hootsuite_to_publish AS hootsuite_to_publish_37,
c0_.hootsuite_use_post_media AS hootsuite_use_post_media_38,
c0_.hootsuite_use_post_published_at AS hootsuite_use_post_published_at_39,
c0_.hootsuite_published_at AS hootsuite_published_at_40,
c0_.prnt_id AS prnt_id_41,
c0_.media_id AS media_id_42,
c0_.dummy_media_id AS dummy_media_id_43,
c0_.video_media_id AS video_media_id_44,
c0_.author_id AS author_id_45,
c0_.category_id AS category_id_46,
c0_.primary_customer_id AS primary_customer_id_47,
c0_.form_id AS form_id_48,
c0_.popout_ad_id AS popout_ad_id_49,
c0_.hootsuite_media_id AS hootsuite_media_id_50
FROM
content c0_
INNER JOIN content_site c2_ ON c0_.id = c2_.content_id
INNER JOIN site s1_ ON s1_.id = c2_.site_id
AND (s1_.id = ?)
WHERE
c0_.slug = ?
AND c0_.type = ?
AND (
c0_.status = 1
OR c0_.status = -5
)
LIMIT
1
SELECT c0_.id AS id_0, c0_.version AS version_1, c0_.featured_image AS featured_image_2, c0_.media_url AS media_url_3, c0_.type AS type_4, c0_.template AS template_5, c0_.title AS title_6, c0_.slug AS slug_7, c0_.searchable AS searchable_8, c0_.exclude_from_list AS exclude_from_list_9, c0_.permission AS permission_10, c0_.status AS status_11, c0_.members_only AS members_only_12, c0_.include_author_byline AS include_author_byline_13, c0_.include_author_bio AS include_author_bio_14, c0_.include_customer_call_to_action AS include_customer_call_to_action_15, c0_.include_customer_bio AS include_customer_bio_16, c0_.total_impressions AS total_impressions_17, c0_.total_clicks AS total_clicks_18, c0_.published_at AS published_at_19, c0_.modified_at AS modified_at_20, c0_.created_at AS created_at_21, c0_.content_intro AS content_intro_22, c0_.content_full AS content_full_23, c0_.meta_description AS meta_description_24, c0_.meta_keywords AS meta_keywords_25, c0_.content_builder AS content_builder_26, c0_.show_title AS show_title_27, c0_.old_id AS old_id_28, c0_.featured AS featured_29, c0_.announcement AS announcement_30, c0_.announcement_sites AS announcement_sites_31, c0_.expires_at AS expires_at_32, c0_.hootsuite_content AS hootsuite_content_33, c0_.hootsuite_facebook_content AS hootsuite_facebook_content_34, c0_.hootsuite_twitter_content AS hootsuite_twitter_content_35, c0_.hootsuite_linkedin_content AS hootsuite_linkedin_content_36, c0_.hootsuite_to_publish AS hootsuite_to_publish_37, c0_.hootsuite_use_post_media AS hootsuite_use_post_media_38, c0_.hootsuite_use_post_published_at AS hootsuite_use_post_published_at_39, c0_.hootsuite_published_at AS hootsuite_published_at_40, c0_.prnt_id AS prnt_id_41, c0_.media_id AS media_id_42, c0_.dummy_media_id AS dummy_media_id_43, c0_.video_media_id AS video_media_id_44, c0_.author_id AS author_id_45, c0_.category_id AS category_id_46, c0_.primary_customer_id AS primary_customer_id_47, c0_.form_id AS form_id_48, c0_.popout_ad_id AS popout_ad_id_49, c0_.hootsuite_media_id AS hootsuite_media_id_50 FROM content c0_ INNER JOIN content_site c2_ ON c0_.id = c2_.content_id INNER JOIN site s1_ ON s1_.id = c2_.site_id AND (s1_.id = 1) WHERE c0_.slug = 'ipfs' AND c0_.type = 2 AND (c0_.status = 1 OR c0_.status = -5) LIMIT 1;
|