Symfony Profiler

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 = 'roofers-coffee-shop' AND s1_.id = 1;

SELECT
  t0.id AS id_1,
  t0.version AS version_2,
  t0.title AS title_3,
  t0.description AS description_4,
  t0.call_to_action AS call_to_action_5,
  t0.bio AS bio_6,
  t0.modified_at AS modified_at_7,
  t0.created_at AS created_at_8,
  t0.status AS status_9,
  t0.email AS email_10,
  t0.external_request_more AS external_request_more_11,
  t0.website AS website_12,
  t0.facebook AS facebook_13,
  t0.twitter AS twitter_14,
  t0.linkedin AS linkedin_15,
  t0.instagram AS instagram_16,
  t0.tiktok AS tiktok_17,
  t0.youtube AS youtube_18,
  t0.hash_tag AS hash_tag_19,
  t0.location AS location_20,
  t0.state AS state_21,
  t0.keywords AS keywords_22,
  t0.customer_level AS customer_level_23,
  t0.customer_type AS customer_type_24,
  t0.type_work AS type_work_25,
  t0.prnt_id AS prnt_id_26,
  t0.literature_id AS literature_id_27,
  t0.photo_gallery_id AS photo_gallery_id_28,
  t0.video_gallery_id AS video_gallery_id_29,
  t0.logo_id AS logo_id_30,
  t0.media_id AS media_id_31,
  t0.dummy_media_id AS dummy_media_id_32,
  t0.blog_id AS blog_id_33,
  t0.branch_locator_id AS branch_locator_id_34,
  t0.external_events_id AS external_events_id_35,
  t0.newsletters_id AS newsletters_id_36,
  t0.partners_reps_id AS partners_reps_id_37,
  t0.rep_lines_id AS rep_lines_id_38,
  t0.directory_content_id AS directory_content_id_39
FROM
  customer t0
WHERE
  t0.directory_content_id = ?

SELECT t0.id AS id_1, t0.version AS version_2, t0.title AS title_3, t0.description AS description_4, t0.call_to_action AS call_to_action_5, t0.bio AS bio_6, t0.modified_at AS modified_at_7, t0.created_at AS created_at_8, t0.status AS status_9, t0.email AS email_10, t0.external_request_more AS external_request_more_11, t0.website AS website_12, t0.facebook AS facebook_13, t0.twitter AS twitter_14, t0.linkedin AS linkedin_15, t0.instagram AS instagram_16, t0.tiktok AS tiktok_17, t0.youtube AS youtube_18, t0.hash_tag AS hash_tag_19, t0.location AS location_20, t0.state AS state_21, t0.keywords AS keywords_22, t0.customer_level AS customer_level_23, t0.customer_type AS customer_type_24, t0.type_work AS type_work_25, t0.prnt_id AS prnt_id_26, t0.literature_id AS literature_id_27, t0.photo_gallery_id AS photo_gallery_id_28, t0.video_gallery_id AS video_gallery_id_29, t0.logo_id AS logo_id_30, t0.media_id AS media_id_31, t0.dummy_media_id AS dummy_media_id_32, t0.blog_id AS blog_id_33, t0.branch_locator_id AS branch_locator_id_34, t0.external_events_id AS external_events_id_35, t0.newsletters_id AS newsletters_id_36, t0.partners_reps_id AS partners_reps_id_37, t0.rep_lines_id AS rep_lines_id_38, t0.directory_content_id AS directory_content_id_39 FROM customer t0 WHERE t0.directory_content_id = '49038';

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO traffic_data (
  hash, user_token, user_ip, user_ua,
  user_refer, user_this_path, user_this_route,
  user_this_route_params, user_last_path,
  user_last_route, user_last_route_params,
  user_request_data, requested_at,
  user_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO traffic_data (hash, user_token, user_ip, user_ua, user_refer, user_this_path, user_this_route, user_this_route_params, user_last_path, user_last_route, user_last_route_params, user_request_data, requested_at, user_id) VALUES ('54b7332938fc8bea5cd30245645c9551', '83af443ab0b80c6d674194f495dfea7c01351bc3b3dc4b7aa4f5e7b8e914b81c', '3.14.134.62', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '/forum/roofers-coffee-shop', 'forum', '{\"slug\":\"roofers-coffee-shop\",\"page\":1}', '', '', '', '[]', '2024-07-15 17:33:20', NULL);

INSERT INTO content_view (
  site_id, requested_at, hash, content_id
)
VALUES
  (?, ?, ?, ?)

INSERT INTO content_view (site_id, requested_at, hash, content_id) VALUES (1, '2024-07-15 17:33:20', '54b7332938fc8bea5cd30245645c9551', '49038');

"COMMIT"

"COMMIT";

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 = 'roofers-coffee-shop' AND c0_.type = 9 AND (c0_.status = 1 OR c0_.status = -5) LIMIT 1;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  content c0_
WHERE
  c0_.status = 1
  AND c0_.prnt_id = ?

SELECT COUNT(c0_.id) AS sclr_0 FROM content c0_ WHERE c0_.status = 1 AND c0_.prnt_id = '49038';

SELECT
  i.id
FROM
  (
    SELECT
      t.id,
      r.published_at
    FROM
      content r
      JOIN content t ON r.prnt_id = t.id
    WHERE
      r.type = 11
      AND r.status = 1
      AND t.prnt_id = :forumId
    UNION
    SELECT
      t.id,
      t.published_at
    FROM
      content t
    WHERE
      t.type = 10
      AND t.status = 1
      AND t.prnt_id = :forumId
  ) i
GROUP BY
  i.id
ORDER BY
  MAX(i.published_at) DESC
LIMIT
  15 OFFSET 0

SELECT i.id FROM ( SELECT t.id, r.published_at FROM content r JOIN content t  ON r.prnt_id = t.id WHERE r.type = 11 AND r.status = 1 AND t.prnt_id = '49038' UNION SELECT t.id, t.published_at FROM content t WHERE t.type = 10 AND t.status = 1 AND t.prnt_id = '49038' ) i GROUP BY i.id ORDER BY MAX(i.published_at) DESC LIMIT 15 OFFSET 0;

SELECT
  t0.id AS id_1,
  t0.version AS version_2,
  t0.featured_image AS featured_image_3,
  t0.media_url AS media_url_4,
  t0.type AS type_5,
  t0.template AS template_6,
  t0.title AS title_7,
  t0.slug AS slug_8,
  t0.searchable AS searchable_9,
  t0.exclude_from_list AS exclude_from_list_10,
  t0.permission AS permission_11,
  t0.status AS status_12,
  t0.members_only AS members_only_13,
  t0.include_author_byline AS include_author_byline_14,
  t0.include_author_bio AS include_author_bio_15,
  t0.include_customer_call_to_action AS include_customer_call_to_action_16,
  t0.include_customer_bio AS include_customer_bio_17,
  t0.total_impressions AS total_impressions_18,
  t0.total_clicks AS total_clicks_19,
  t0.published_at AS published_at_20,
  t0.modified_at AS modified_at_21,
  t0.created_at AS created_at_22,
  t0.content_intro AS content_intro_23,
  t0.content_full AS content_full_24,
  t0.meta_description AS meta_description_25,
  t0.meta_keywords AS meta_keywords_26,
  t0.content_builder AS content_builder_27,
  t0.show_title AS show_title_28,
  t0.old_id AS old_id_29,
  t0.featured AS featured_30,
  t0.announcement AS announcement_31,
  t0.announcement_sites AS announcement_sites_32,
  t0.expires_at AS expires_at_33,
  t0.hootsuite_content AS hootsuite_content_34,
  t0.hootsuite_facebook_content AS hootsuite_facebook_content_35,
  t0.hootsuite_twitter_content AS hootsuite_twitter_content_36,
  t0.hootsuite_linkedin_content AS hootsuite_linkedin_content_37,
  t0.hootsuite_to_publish AS hootsuite_to_publish_38,
  t0.hootsuite_use_post_media AS hootsuite_use_post_media_39,
  t0.hootsuite_use_post_published_at AS hootsuite_use_post_published_at_40,
  t0.hootsuite_published_at AS hootsuite_published_at_41,
  t0.prnt_id AS prnt_id_42,
  t0.media_id AS media_id_43,
  t0.dummy_media_id AS dummy_media_id_44,
  t0.video_media_id AS video_media_id_45,
  t0.author_id AS author_id_46,
  t0.category_id AS category_id_47,
  t0.primary_customer_id AS primary_customer_id_48,
  t49.id AS id_50,
  t49.version AS version_51,
  t49.title AS title_52,
  t49.description AS description_53,
  t49.call_to_action AS call_to_action_54,
  t49.bio AS bio_55,
  t49.modified_at AS modified_at_56,
  t49.created_at AS created_at_57,
  t49.status AS status_58,
  t49.email AS email_59,
  t49.external_request_more AS external_request_more_60,
  t49.website AS website_61,
  t49.facebook AS facebook_62,
  t49.twitter AS twitter_63,
  t49.linkedin AS linkedin_64,
  t49.instagram AS instagram_65,
  t49.tiktok AS tiktok_66,
  t49.youtube AS youtube_67,
  t49.hash_tag AS hash_tag_68,
  t49.location AS location_69,
  t49.state AS state_70,
  t49.keywords AS keywords_71,
  t49.customer_level AS customer_level_72,
  t49.customer_type AS customer_type_73,
  t49.type_work AS type_work_74,
  t49.prnt_id AS prnt_id_75,
  t49.literature_id AS literature_id_76,
  t49.photo_gallery_id AS photo_gallery_id_77,
  t49.video_gallery_id AS video_gallery_id_78,
  t49.logo_id AS logo_id_79,
  t49.media_id AS media_id_80,
  t49.dummy_media_id AS dummy_media_id_81,
  t49.blog_id AS blog_id_82,
  t49.branch_locator_id AS branch_locator_id_83,
  t49.external_events_id AS external_events_id_84,
  t49.newsletters_id AS newsletters_id_85,
  t49.partners_reps_id AS partners_reps_id_86,
  t49.rep_lines_id AS rep_lines_id_87,
  t49.directory_content_id AS directory_content_id_88,
  t0.form_id AS form_id_89,
  t0.popout_ad_id AS popout_ad_id_90,
  t0.hootsuite_media_id AS hootsuite_media_id_91
FROM
  content t0
  LEFT JOIN customer t49 ON t49.directory_content_id = t0.id
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.version AS version_2, t0.featured_image AS featured_image_3, t0.media_url AS media_url_4, t0.type AS type_5, t0.template AS template_6, t0.title AS title_7, t0.slug AS slug_8, t0.searchable AS searchable_9, t0.exclude_from_list AS exclude_from_list_10, t0.permission AS permission_11, t0.status AS status_12, t0.members_only AS members_only_13, t0.include_author_byline AS include_author_byline_14, t0.include_author_bio AS include_author_bio_15, t0.include_customer_call_to_action AS include_customer_call_to_action_16, t0.include_customer_bio AS include_customer_bio_17, t0.total_impressions AS total_impressions_18, t0.total_clicks AS total_clicks_19, t0.published_at AS published_at_20, t0.modified_at AS modified_at_21, t0.created_at AS created_at_22, t0.content_intro AS content_intro_23, t0.content_full AS content_full_24, t0.meta_description AS meta_description_25, t0.meta_keywords AS meta_keywords_26, t0.content_builder AS content_builder_27, t0.show_title AS show_title_28, t0.old_id AS old_id_29, t0.featured AS featured_30, t0.announcement AS announcement_31, t0.announcement_sites AS announcement_sites_32, t0.expires_at AS expires_at_33, t0.hootsuite_content AS hootsuite_content_34, t0.hootsuite_facebook_content AS hootsuite_facebook_content_35, t0.hootsuite_twitter_content AS hootsuite_twitter_content_36, t0.hootsuite_linkedin_content AS hootsuite_linkedin_content_37, t0.hootsuite_to_publish AS hootsuite_to_publish_38, t0.hootsuite_use_post_media AS hootsuite_use_post_media_39, t0.hootsuite_use_post_published_at AS hootsuite_use_post_published_at_40, t0.hootsuite_published_at AS hootsuite_published_at_41, t0.prnt_id AS prnt_id_42, t0.media_id AS media_id_43, t0.dummy_media_id AS dummy_media_id_44, t0.video_media_id AS video_media_id_45, t0.author_id AS author_id_46, t0.category_id AS category_id_47, t0.primary_customer_id AS primary_customer_id_48, t49.id AS id_50, t49.version AS version_51, t49.title AS title_52, t49.description AS description_53, t49.call_to_action AS call_to_action_54, t49.bio AS bio_55, t49.modified_at AS modified_at_56, t49.created_at AS created_at_57, t49.status AS status_58, t49.email AS email_59, t49.external_request_more AS external_request_more_60, t49.website AS website_61, t49.facebook AS facebook_62, t49.twitter AS twitter_63, t49.linkedin AS linkedin_64, t49.instagram AS instagram_65, t49.tiktok AS tiktok_66, t49.youtube AS youtube_67, t49.hash_tag AS hash_tag_68, t49.location AS location_69, t49.state AS state_70, t49.keywords AS keywords_71, t49.customer_level AS customer_level_72, t49.customer_type AS customer_type_73, t49.type_work AS type_work_74, t49.prnt_id AS prnt_id_75, t49.literature_id AS literature_id_76, t49.photo_gallery_id AS photo_gallery_id_77, t49.video_gallery_id AS video_gallery_id_78, t49.logo_id AS logo_id_79, t49.media_id AS media_id_80, t49.dummy_media_id AS dummy_media_id_81, t49.blog_id AS blog_id_82, t49.branch_locator_id AS branch_locator_id_83, t49.external_events_id AS external_events_id_84, t49.newsletters_id AS newsletters_id_85, t49.partners_reps_id AS partners_reps_id_86, t49.rep_lines_id AS rep_lines_id_87, t49.directory_content_id AS directory_content_id_88, t0.form_id AS form_id_89, t0.popout_ad_id AS popout_ad_id_90, t0.hootsuite_media_id AS hootsuite_media_id_91 FROM content t0 LEFT JOIN customer t49 ON t49.directory_content_id = t0.id WHERE t0.id = 118241 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.version AS version_2,
  t0.featured_image AS featured_image_3,
  t0.media_url AS media_url_4,
  t0.type AS type_5,
  t0.template AS template_6,
  t0.title AS title_7,
  t0.slug AS slug_8,
  t0.searchable AS searchable_9,
  t0.exclude_from_list AS exclude_from_list_10,
  t0.permission AS permission_11,
  t0.status AS status_12,
  t0.members_only AS members_only_13,
  t0.include_author_byline AS include_author_byline_14,
  t0.include_author_bio AS include_author_bio_15,
  t0.include_customer_call_to_action AS include_customer_call_to_action_16,
  t0.include_customer_bio AS include_customer_bio_17,
  t0.total_impressions AS total_impressions_18,
  t0.total_clicks AS total_clicks_19,
  t0.published_at AS published_at_20,
  t0.modified_at AS modified_at_21,
  t0.created_at AS created_at_22,
  t0.content_intro AS content_intro_23,
  t0.content_full AS content_full_24,
  t0.meta_description AS meta_description_25,
  t0.meta_keywords AS meta_keywords_26,
  t0.content_builder AS content_builder_27,
  t0.show_title AS show_title_28,
  t0.old_id AS old_id_29,
  t0.featured AS featured_30,
  t0.announcement AS announcement_31,
  t0.announcement_sites AS announcement_sites_32,
  t0.expires_at AS expires_at_33,
  t0.hootsuite_content AS hootsuite_content_34,
  t0.hootsuite_facebook_content AS hootsuite_facebook_content_35,
  t0.hootsuite_twitter_content AS hootsuite_twitter_content_36,
  t0.hootsuite_linkedin_content AS hootsuite_linkedin_content_37,
  t0.hootsuite_to_publish AS hootsuite_to_publish_38,
  t0.hootsuite_use_post_media AS hootsuite_use_post_media_39,
  t0.hootsuite_use_post_published_at AS hootsuite_use_post_published_at_40,
  t0.hootsuite_published_at AS hootsuite_published_at_41,
  t0.prnt_id AS prnt_id_42,
  t0.media_id AS media_id_43,
  t0.dummy_media_id AS dummy_media_id_44,
  t0.video_media_id AS video_media_id_45,
  t0.author_id AS author_id_46,
  t0.category_id AS category_id_47,
  t0.primary_customer_id AS primary_customer_id_48,
  t49.id AS id_50,
  t49.version AS version_51,
  t49.title AS title_52,
  t49.description AS description_53,
  t49.call_to_action AS call_to_action_54,
  t49.bio AS bio_55,
  t49.modified_at AS modified_at_56,
  t49.created_at AS created_at_57,
  t49.status AS status_58,
  t49.email AS email_59,
  t49.external_request_more AS external_request_more_60,
  t49.website AS website_61,
  t49.facebook AS facebook_62,
  t49.twitter AS twitter_63,
  t49.linkedin AS linkedin_64,
  t49.instagram AS instagram_65,
  t49.tiktok AS tiktok_66,
  t49.youtube AS youtube_67,
  t49.hash_tag AS hash_tag_68,
  t49.location AS location_69,
  t49.state AS state_70,
  t49.keywords AS keywords_71,
  t49.customer_level AS customer_level_72,
  t49.customer_type AS customer_type_73,
  t49.type_work AS type_work_74,
  t49.prnt_id AS prnt_id_75,
  t49.literature_id AS literature_id_76,
  t49.photo_gallery_id AS photo_gallery_id_77,
  t49.video_gallery_id AS video_gallery_id_78,
  t49.logo_id AS logo_id_79,
  t49.media_id AS media_id_80,
  t49.dummy_media_id AS dummy_media_id_81,
  t49.blog_id AS blog_id_82,
  t49.branch_locator_id AS branch_locator_id_83,
  t49.external_events_id AS external_events_id_84,
  t49.newsletters_id AS newsletters_id_85,
  t49.partners_reps_id AS partners_reps_id_86,
  t49.rep_lines_id AS rep_lines_id_87,
  t49.directory_content_id AS directory_content_id_88,
  t0.form_id AS form_id_89,
  t0.popout_ad_id AS popout_ad_id_90,
  t0.hootsuite_media_id AS hootsuite_media_id_91
FROM
  content t0
  LEFT JOIN customer t49 ON t49.directory_content_id = t0.id
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.version AS version_2, t0.featured_image AS featured_image_3, t0.media_url AS media_url_4, t0.type AS type_5, t0.template AS template_6, t0.title AS title_7, t0.slug AS slug_8, t0.searchable AS searchable_9, t0.exclude_from_list AS exclude_from_list_10, t0.permission AS permission_11, t0.status AS status_12, t0.members_only AS members_only_13, t0.include_author_byline AS include_author_byline_14, t0.include_author_bio AS include_author_bio_15, t0.include_customer_call_to_action AS include_customer_call_to_action_16, t0.include_customer_bio AS include_customer_bio_17, t0.total_impressions AS total_impressions_18, t0.total_clicks AS total_clicks_19, t0.published_at AS published_at_20, t0.modified_at AS modified_at_21, t0.created_at AS created_at_22, t0.content_intro AS content_intro_23, t0.content_full AS content_full_24, t0.meta_description AS meta_description_25, t0.meta_keywords AS meta_keywords_26, t0.content_builder AS content_builder_27, t0.show_title AS show_title_28, t0.old_id AS old_id_29, t0.featured AS featured_30, t0.announcement AS announcement_31, t0.announcement_sites AS announcement_sites_32, t0.expires_at AS expires_at_33, t0.hootsuite_content AS hootsuite_content_34, t0.hootsuite_facebook_content AS hootsuite_facebook_content_35, t0.hootsuite_twitter_content AS hootsuite_twitter_content_36, t0.hootsuite_linkedin_content AS hootsuite_linkedin_content_37, t0.hootsuite_to_publish AS hootsuite_to_publish_38, t0.hootsuite_use_post_media AS hootsuite_use_post_media_39, t0.hootsuite_use_post_published_at AS hootsuite_use_post_published_at_40, t0.hootsuite_published_at AS hootsuite_published_at_41, t0.prnt_id AS prnt_id_42, t0.media_id AS media_id_43, t0.dummy_media_id AS dummy_media_id_44, t0.video_media_id AS video_media_id_45, t0.author_id AS author_id_46, t0.category_id AS category_id_47, t0.primary_customer_id AS primary_customer_id_48, t49.id AS id_50, t49.version AS version_51, t49.title AS title_52, t49.description AS description_53, t49.call_to_action AS call_to_action_54, t49.bio AS bio_55, t49.modified_at AS modified_at_56, t49.created_at AS created_at_57, t49.status AS status_58, t49.email AS email_59, t49.external_request_more AS external_request_more_60, t49.website AS website_61, t49.facebook AS facebook_62, t49.twitter AS twitter_63, t49.linkedin AS linkedin_64, t49.instagram AS instagram_65, t49.tiktok AS tiktok_66, t49.youtube AS youtube_67, t49.hash_tag AS hash_tag_68, t49.location AS location_69, t49.state AS state_70, t49.keywords AS keywords_71, t49.customer_level AS customer_level_72, t49.customer_type AS customer_type_73, t49.type_work AS type_work_74, t49.prnt_id AS prnt_id_75, t49.literature_id AS literature_id_76, t49.photo_gallery_id AS photo_gallery_id_77, t49.video_gallery_id AS video_gallery_id_78, t49.logo_id AS logo_id_79, t49.media_id AS media_id_80, t49.dummy_media_id AS dummy_media_id_81, t49.blog_id AS blog_id_82, t49.branch_locator_id AS branch_locator_id_83, t49.external_events_id AS external_events_id_84, t49.newsletters_id AS newsletters_id_85, t49.partners_reps_id AS partners_reps_id_86, t49.rep_lines_id AS rep_lines_id_87, t49.directory_content_id AS directory_content_id_88, t0.form_id AS form_id_89, t0.popout_ad_id AS popout_ad_id_90, t0.hootsuite_media_id AS hootsuite_media_id_91 FROM content t0 LEFT JOIN customer t49 ON t49.directory_content_id = t0.id WHERE t0.id = 118210 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.version AS version_2,
  t0.featured_image AS featured_image_3,
  t0.media_url AS media_url_4,
  t0.type AS type_5,
  t0.template AS template_6,
  t0.title AS title_7,
  t0.slug AS slug_8,
  t0.searchable AS searchable_9,
  t0.exclude_from_list AS exclude_from_list_10,
  t0.permission AS permission_11,
  t0.status AS status_12,
  t0.members_only AS members_only_13,
  t0.include_author_byline AS include_author_byline_14,
  t0.include_author_bio AS include_author_bio_15,
  t0.include_customer_call_to_action AS include_customer_call_to_action_16,
  t0.include_customer_bio AS include_customer_bio_17,
  t0.total_impressions AS total_impressions_18,
  t0.total_clicks AS total_clicks_19,
  t0.published_at AS published_at_20,
  t0.modified_at AS modified_at_21,
  t0.created_at AS created_at_22,
  t0.content_intro AS content_intro_23,
  t0.content_full AS content_full_24,
  t0.meta_description AS meta_description_25,
  t0.meta_keywords AS meta_keywords_26,
  t0.content_builder AS content_builder_27,
  t0.show_title AS show_title_28,
  t0.old_id AS old_id_29,
  t0.featured AS featured_30,
  t0.announcement AS announcement_31,
  t0.announcement_sites AS announcement_sites_32,
  t0.expires_at AS expires_at_33,
  t0.hootsuite_content AS hootsuite_content_34,
  t0.hootsuite_facebook_content AS hootsuite_facebook_content_35,
  t0.hootsuite_twitter_content AS hootsuite_twitter_content_36,
  t0.hootsuite_linkedin_content AS hootsuite_linkedin_content_37,
  t0.hootsuite_to_publish AS hootsuite_to_publish_38,
  t0.hootsuite_use_post_media AS hootsuite_use_post_media_39,
  t0.hootsuite_use_post_published_at AS hootsuite_use_post_published_at_40,
  t0.hootsuite_published_at AS hootsuite_published_at_41,
  t0.prnt_id AS prnt_id_42,
  t0.media_id AS media_id_43,
  t0.dummy_media_id AS dummy_media_id_44,
  t0.video_media_id AS video_media_id_45,
  t0.author_id AS author_id_46,
  t0.category_id AS category_id_47,
  t0.primary_customer_id AS primary_customer_id_48,
  t49.id AS id_50,
  t49.version AS version_51,
  t49.title AS title_52,
  t49.description AS description_53,
  t49.call_to_action AS call_to_action_54,
  t49.bio AS bio_55,
  t49.modified_at AS modified_at_56,
  t49.created_at AS created_at_57,
  t49.status AS status_58,
  t49.email AS email_59,
  t49.external_request_more AS external_request_more_60,
  t49.website AS website_61,
  t49.facebook AS facebook_62,
  t49.twitter AS twitter_63,
  t49.linkedin AS linkedin_64,
  t49.instagram AS instagram_65,
  t49.tiktok AS tiktok_66,
  t49.youtube AS youtube_67,
  t49.hash_tag AS hash_tag_68,
  t49.location AS location_69,
  t49.state AS state_70,
  t49.keywords AS keywords_71,
  t49.customer_level AS customer_level_72,
  t49.customer_type AS customer_type_73,
  t49.type_work AS type_work_74,
  t49.prnt_id AS prnt_id_75,
  t49.literature_id AS literature_id_76,
  t49.photo_gallery_id AS photo_gallery_id_77,
  t49.video_gallery_id AS video_gallery_id_78,
  t49.logo_id AS logo_id_79,
  t49.media_id AS media_id_80,
  t49.dummy_media_id AS dummy_media_id_81,
  t49.blog_id AS blog_id_82,
  t49.branch_locator_id AS branch_locator_id_83,
  t49.external_events_id AS external_events_id_84,
  t49.newsletters_id AS newsletters_id_85,
  t49.partners_reps_id AS partners_reps_id_86,
  t49.rep_lines_id AS rep_lines_id_87,
  t49.directory_content_id AS directory_content_id_88,
  t0.form_id AS form_id_89,
  t0.popout_ad_id AS popout_ad_id_90,
  t0.hootsuite_media_id AS hootsuite_media_id_91
FROM
  content t0
  LEFT JOIN customer t49 ON t49.directory_content_id = t0.id
WHERE
  t0.id = ?
LIMIT
  1