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 = 'virtual-qualified-trainer-conference-4' 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.show_photos AS show_photos_26,
  t0.prnt_id AS prnt_id_27,
  t0.literature_id AS literature_id_28,
  t0.photo_gallery_id AS photo_gallery_id_29,
  t0.video_gallery_id AS video_gallery_id_30,
  t0.logo_id AS logo_id_31,
  t0.media_id AS media_id_32,
  t0.dummy_media_id AS dummy_media_id_33,
  t0.blog_id AS blog_id_34,
  t0.branch_locator_id AS branch_locator_id_35,
  t0.external_events_id AS external_events_id_36,
  t0.newsletters_id AS newsletters_id_37,
  t0.partners_reps_id AS partners_reps_id_38,
  t0.rep_lines_id AS rep_lines_id_39,
  t0.directory_content_id AS directory_content_id_40
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.show_photos AS show_photos_26, t0.prnt_id AS prnt_id_27, t0.literature_id AS literature_id_28, t0.photo_gallery_id AS photo_gallery_id_29, t0.video_gallery_id AS video_gallery_id_30, t0.logo_id AS logo_id_31, t0.media_id AS media_id_32, t0.dummy_media_id AS dummy_media_id_33, t0.blog_id AS blog_id_34, t0.branch_locator_id AS branch_locator_id_35, t0.external_events_id AS external_events_id_36, t0.newsletters_id AS newsletters_id_37, t0.partners_reps_id AS partners_reps_id_38, t0.rep_lines_id AS rep_lines_id_39, t0.directory_content_id AS directory_content_id_40 FROM customer t0 WHERE t0.directory_content_id = '110983';

"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 ('9b5539df984c69f4ed7aa20a0e272cda', 'fe38f8d000d0e67fc910907cb2de24e8a79a9decd84c24e0f46e7fee31cb156f', '3.145.73.79', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '/event/virtual-qualified-trainer-conference-4', 'event_master', '{\"slug\":\"virtual-qualified-trainer-conference-4\"}', '', '', '\"\"', '[]', '2024-07-25 08:06:16', 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-25 08:06:16', '9b5539df984c69f4ed7aa20a0e272cda', '110983');

"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 = 'virtual-qualified-trainer-conference-4' AND c0_.type = 7 AND (c0_.status = 1 OR c0_.status = -5) LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.metakey AS metakey_2,
  t0.metavalue AS metavalue_3,
  t0.content_id AS content_id_4
FROM
  content_meta t0
WHERE
  t0.content_id = ?

SELECT t0.id AS id_1, t0.metakey AS metakey_2, t0.metavalue AS metavalue_3, t0.content_id AS content_id_4 FROM content_meta t0 WHERE t0.content_id = '110983';

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_meta c1_ ON c0_.id = c1_.content_id
  AND (
    c1_.metakey = '_EventStartDate'
    AND c1_.metavalue <= ?
  )
  INNER JOIN content_meta c2_ ON c0_.id = c2_.content_id
  AND (c2_.metakey = '_EventEndDate')
  LEFT JOIN content_meta c3_ ON c0_.id = c3_.content_id
  AND (c3_.metakey = '_IsEvent')
WHERE
  (
    c0_.status = 1
    AND (
      c0_.type = 7
      OR c3_.metavalue = 'yes'
    )
    AND c1_.metavalue <> ''
    AND c2_.metavalue <> ''
  )
  AND (
    c1_.metavalue < ?
    OR c0_.title < ?
  )
ORDER BY
  c1_.metavalue DESC,
  c0_.title DESC
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_meta c1_ ON c0_.id = c1_.content_id AND (c1_.metakey = '_EventStartDate' AND c1_.metavalue <= '2021-04-07 08:00:00') INNER JOIN content_meta c2_ ON c0_.id = c2_.content_id AND (c2_.metakey = '_EventEndDate') LEFT JOIN content_meta c3_ ON c0_.id = c3_.content_id AND (c3_.metakey = '_IsEvent') WHERE (c0_.status = 1 AND (c0_.type = 7 OR c3_.metavalue = 'yes') AND c1_.metavalue <> '' AND c2_.metavalue <> '') AND (c1_.metavalue < '2021-04-07 08:00:00' OR c0_.title < 'Virtual Qualified Trainer Conference') ORDER BY c1_.metavalue DESC, c0_.title DESC LIMIT 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.show_photos AS show_photos_26,
  t0.prnt_id AS prnt_id_27,
  t0.literature_id AS literature_id_28,
  t0.photo_gallery_id AS photo_gallery_id_29,
  t0.video_gallery_id AS video_gallery_id_30,
  t0.logo_id AS logo_id_31,
  t0.media_id AS media_id_32,
  t0.dummy_media_id AS dummy_media_id_33,
  t0.blog_id AS blog_id_34,
  t0.branch_locator_id AS branch_locator_id_35,
  t0.external_events_id AS external_events_id_36,
  t0.newsletters_id AS newsletters_id_37,
  t0.partners_reps_id AS partners_reps_id_38,
  t0.rep_lines_id AS rep_lines_id_39,
  t0.directory_content_id AS directory_content_id_40
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.show_photos AS show_photos_26, t0.prnt_id AS prnt_id_27, t0.literature_id AS literature_id_28, t0.photo_gallery_id AS photo_gallery_id_29, t0.video_gallery_id AS video_gallery_id_30, t0.logo_id AS logo_id_31, t0.media_id AS media_id_32, t0.dummy_media_id AS dummy_media_id_33, t0.blog_id AS blog_id_34, t0.branch_locator_id AS branch_locator_id_35, t0.external_events_id AS external_events_id_36, t0.newsletters_id AS newsletters_id_37, t0.partners_reps_id AS partners_reps_id_38, t0.rep_lines_id AS rep_lines_id_39, t0.directory_content_id AS directory_content_id_40 FROM customer t0 WHERE t0.directory_content_id = '111691';

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_meta c1_ ON c0_.id = c1_.content_id
  AND (
    c1_.metakey = '_EventStartDate'
    AND c1_.metavalue >= ?
  )
  INNER JOIN content_meta c2_ ON c0_.id = c2_.content_id
  AND (c2_.metakey = '_EventEndDate')
  LEFT JOIN content_meta c3_ ON c0_.id = c3_.content_id
  AND (c3_.metakey = '_IsEvent')
WHERE
  (
    c0_.status = 1
    AND (
      c0_.type = 7
      OR c3_.metavalue = 'yes'
    )
    AND c1_.metavalue <> ''
    AND c2_.metavalue <> ''
  )
  AND (
    c1_.metavalue > ?
    OR c0_.title > ?
  )
ORDER BY
  c1_.metavalue ASC,
  c0_.title ASC
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_meta c1_ ON c0_.id = c1_.content_id AND (c1_.metakey = '_EventStartDate' AND c1_.metavalue >= '2021-04-07 08:00:00') INNER JOIN content_meta c2_ ON c0_.id = c2_.content_id AND (c2_.metakey = '_EventEndDate') LEFT JOIN content_meta c3_ ON c0_.id = c3_.content_id AND (c3_.metakey = '_IsEvent') WHERE (c0_.status = 1 AND (c0_.type = 7 OR c3_.metavalue = 'yes') AND c1_.metavalue <> '' AND c2_.metavalue <> '') AND (c1_.metavalue > '2021-04-07 08:00:00' OR c0_.title > 'Virtual Qualified Trainer Conference') ORDER BY c1_.metavalue ASC, c0_.title ASC LIMIT 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.show_photos AS show_photos_26,
  t0.prnt_id AS prnt_id_27,
  t0.literature_id AS literature_id_28,
  t0.photo_gallery_id AS photo_gallery_id_29,
  t0.video_gallery_id AS video_gallery_id_30,
  t0.logo_id AS logo_id_31,
  t0.media_id AS media_id_32,
  t0.dummy_media_id AS dummy_media_id_33,
  t0.blog_id AS blog_id_34,
  t0.branch_locator_id AS branch_locator_id_35,
  t0.external_events_id AS external_events_id_36,
  t0.newsletters_id AS newsletters_id_37,
  t0.partners_reps_id AS partners_reps_id_38,
  t0.rep_lines_id AS rep_lines_id_39,
  t0.directory_content_id AS directory_content_id_40
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.show_photos AS show_photos_26, t0.prnt_id AS prnt_id_27, t0.literature_id AS literature_id_28, t0.photo_gallery_id AS photo_gallery_id_29, t0.video_gallery_id AS video_gallery_id_30, t0.logo_id AS logo_id_31, t0.media_id AS media_id_32, t0.dummy_media_id AS dummy_media_id_33, t0.blog_id AS blog_id_34, t0.branch_locator_id AS branch_locator_id_35, t0.external_events_id AS external_events_id_36, t0.newsletters_id AS newsletters_id_37, t0.partners_reps_id AS partners_reps_id_38, t0.rep_lines_id AS rep_lines_id_39, t0.directory_content_id AS directory_content_id_40 FROM customer t0 WHERE t0.directory_content_id = '111660';

"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 ('42a61e3425cfec70a83e3324d37a40e6', 'fe38f8d000d0e67fc910907cb2de24e8a79a9decd84c24e0f46e7fee31cb156f', '3.145.73.79', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '', '/event/virtual-qualified-trainer-conference-4', 'event_master', '{\"slug\":\"virtual-qualified-trainer-conference-4\"}', '', '', '', '[]', '2024-07-25 08:06:17', NULL);