10.22 ms (26.74%)
1
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . modified_at AS modified_at_4 , t0 . created_at AS created_at_5 , t0 . status AS status_6 , t0 . attributes AS attributes_7 , t0 . sort_type AS sort_type_8 , t0 . display_limit AS display_limit_9 , t0 . position AS position_10 , t0 . type AS type_11 , t12 . id AS id_13 , t12 . version AS version_14 , t12 . title AS title_15 , t12 . description AS description_16 , t12 . call_to_action AS call_to_action_17 , t12 . bio AS bio_18 , t12 . modified_at AS modified_at_19 , t12 . created_at AS created_at_20 , t12 . status AS status_21 , t12 . email AS email_22 , t12 . external_request_more AS external_request_more_23 , t12 . website AS website_24 , t12 . facebook AS facebook_25 , t12 . twitter AS twitter_26 , t12 . linkedin AS linkedin_27 , t12 . instagram AS instagram_28 , t12 . tiktok AS tiktok_29 , t12 . youtube AS youtube_30 , t12 . hash_tag AS hash_tag_31 , t12 . location AS location_32 , t12 . state AS state_33 , t12 . keywords AS keywords_34 , t12 . customer_level AS customer_level_35 , t12 . customer_type AS customer_type_36 , t12 . type_work AS type_work_37 , t12 . show_photos AS show_photos_38 , t12 . prnt_id AS prnt_id_39 , t12 . literature_id AS literature_id_40 , t12 . photo_gallery_id AS photo_gallery_id_41 , t12 . video_gallery_id AS video_gallery_id_42 , t12 . logo_id AS logo_id_43 , t12 . media_id AS media_id_44 , t12 . dummy_media_id AS dummy_media_id_45 , t12 . blog_id AS blog_id_46 , t12 . branch_locator_id AS branch_locator_id_47 , t12 . external_events_id AS external_events_id_48 , t12 . newsletters_id AS newsletters_id_49 , t12 . partners_reps_id AS partners_reps_id_50 , t12 . rep_lines_id AS rep_lines_id_51 , t12 . directory_content_id AS directory_content_id_52 , t53 . id AS id_54 , t53 . version AS version_55 , t53 . title AS title_56 , t53 . description AS description_57 , t53 . call_to_action AS call_to_action_58 , t53 . bio AS bio_59 , t53 . modified_at AS modified_at_60 , t53 . created_at AS created_at_61 , t53 . status AS status_62 , t53 . email AS email_63 , t53 . external_request_more AS external_request_more_64 , t53 . website AS website_65 , t53 . facebook AS facebook_66 , t53 . twitter AS twitter_67 , t53 . linkedin AS linkedin_68 , t53 . instagram AS instagram_69 , t53 . tiktok AS tiktok_70 , t53 . youtube AS youtube_71 , t53 . hash_tag AS hash_tag_72 , t53 . location AS location_73 , t53 . state AS state_74 , t53 . keywords AS keywords_75 , t53 . customer_level AS customer_level_76 , t53 . customer_type AS customer_type_77 , t53 . type_work AS type_work_78 , t53 . show_photos AS show_photos_79 , t53 . prnt_id AS prnt_id_80 , t53 . literature_id AS literature_id_81 , t53 . photo_gallery_id AS photo_gallery_id_82 , t53 . video_gallery_id AS video_gallery_id_83 , t53 . logo_id AS logo_id_84 , t53 . media_id AS media_id_85 , t53 . dummy_media_id AS dummy_media_id_86 , t53 . blog_id AS blog_id_87 , t53 . branch_locator_id AS branch_locator_id_88 , t53 . external_events_id AS external_events_id_89 , t53 . newsletters_id AS newsletters_id_90 , t53 . partners_reps_id AS partners_reps_id_91 , t53 . rep_lines_id AS rep_lines_id_92 , t53 . directory_content_id AS directory_content_id_93 , t94 . id AS id_95 , t94 . version AS version_96 , t94 . title AS title_97 , t94 . description AS description_98 , t94 . call_to_action AS call_to_action_99 , t94 . bio AS bio_100 , t94 . modified_at AS modified_at_101 , t94 . created_at AS created_at_102 , t94 . status AS status_103 , t94 . email AS email_104 , t94 . external_request_more AS external_request_more_105 , t94 . website AS website_106 , t94 . facebook AS facebook_107 , t94 . twitter AS twitter_108 , t94 . linkedin AS linkedin_109 , t94 . instagram AS instagram_110 , t94 . tiktok AS tiktok_111 , t94 . youtube AS youtube_112 , t94 . hash_tag AS hash_tag_113 , t94 . location AS location_114 , t94 . state AS state_115 , t94 . keywords AS keywords_116 , t94 . customer_level AS customer_level_117 , t94 . customer_type AS customer_type_118 , t94 . type_work AS type_work_119 , t94 . show_photos AS show_photos_120 , t94 . prnt_id AS prnt_id_121 , t94 . literature_id AS literature_id_122 , t94 . photo_gallery_id AS photo_gallery_id_123 , t94 . video_gallery_id AS video_gallery_id_124 , t94 . logo_id AS logo_id_125 , t94 . media_id AS media_id_126 , t94 . dummy_media_id AS dummy_media_id_127 , t94 . blog_id AS blog_id_128 , t94 . branch_locator_id AS branch_locator_id_129 , t94 . external_events_id AS external_events_id_130 , t94 . newsletters_id AS newsletters_id_131 , t94 . partners_reps_id AS partners_reps_id_132 , t94 . rep_lines_id AS rep_lines_id_133 , t94 . directory_content_id AS directory_content_id_134 FROM media_group t0 LEFT JOIN customer t12 ON t12 . literature_id = t0 . id LEFT JOIN customer t53 ON t53 . photo_gallery_id = t0 . id LEFT JOIN customer t94 ON t94 . video_gallery_id = t0 . id WHERE t0 . type = ?
SELECT
t0 . id AS id_1 ,
t0 . title AS title_2 ,
t0 . description AS description_3 ,
t0 . modified_at AS modified_at_4 ,
t0 . created_at AS created_at_5 ,
t0 . status AS status_6 ,
t0 . attributes AS attributes_7 ,
t0 . sort_type AS sort_type_8 ,
t0 . display_limit AS display_limit_9 ,
t0 . position AS position_10 ,
t0 . type AS type_11 ,
t12 . id AS id_13 ,
t12 . version AS version_14 ,
t12 . title AS title_15 ,
t12 . description AS description_16 ,
t12 . call_to_action AS call_to_action_17 ,
t12 . bio AS bio_18 ,
t12 . modified_at AS modified_at_19 ,
t12 . created_at AS created_at_20 ,
t12 . status AS status_21 ,
t12 . email AS email_22 ,
t12 . external_request_more AS external_request_more_23 ,
t12 . website AS website_24 ,
t12 . facebook AS facebook_25 ,
t12 . twitter AS twitter_26 ,
t12 . linkedin AS linkedin_27 ,
t12 . instagram AS instagram_28 ,
t12 . tiktok AS tiktok_29 ,
t12 . youtube AS youtube_30 ,
t12 . hash_tag AS hash_tag_31 ,
t12 . location AS location_32 ,
t12 . state AS state_33 ,
t12 . keywords AS keywords_34 ,
t12 . customer_level AS customer_level_35 ,
t12 . customer_type AS customer_type_36 ,
t12 . type_work AS type_work_37 ,
t12 . show_photos AS show_photos_38 ,
t12 . prnt_id AS prnt_id_39 ,
t12 . literature_id AS literature_id_40 ,
t12 . photo_gallery_id AS photo_gallery_id_41 ,
t12 . video_gallery_id AS video_gallery_id_42 ,
t12 . logo_id AS logo_id_43 ,
t12 . media_id AS media_id_44 ,
t12 . dummy_media_id AS dummy_media_id_45 ,
t12 . blog_id AS blog_id_46 ,
t12 . branch_locator_id AS branch_locator_id_47 ,
t12 . external_events_id AS external_events_id_48 ,
t12 . newsletters_id AS newsletters_id_49 ,
t12 . partners_reps_id AS partners_reps_id_50 ,
t12 . rep_lines_id AS rep_lines_id_51 ,
t12 . directory_content_id AS directory_content_id_52 ,
t53 . id AS id_54 ,
t53 . version AS version_55 ,
t53 . title AS title_56 ,
t53 . description AS description_57 ,
t53 . call_to_action AS call_to_action_58 ,
t53 . bio AS bio_59 ,
t53 . modified_at AS modified_at_60 ,
t53 . created_at AS created_at_61 ,
t53 . status AS status_62 ,
t53 . email AS email_63 ,
t53 . external_request_more AS external_request_more_64 ,
t53 . website AS website_65 ,
t53 . facebook AS facebook_66 ,
t53 . twitter AS twitter_67 ,
t53 . linkedin AS linkedin_68 ,
t53 . instagram AS instagram_69 ,
t53 . tiktok AS tiktok_70 ,
t53 . youtube AS youtube_71 ,
t53 . hash_tag AS hash_tag_72 ,
t53 . location AS location_73 ,
t53 . state AS state_74 ,
t53 . keywords AS keywords_75 ,
t53 . customer_level AS customer_level_76 ,
t53 . customer_type AS customer_type_77 ,
t53 . type_work AS type_work_78 ,
t53 . show_photos AS show_photos_79 ,
t53 . prnt_id AS prnt_id_80 ,
t53 . literature_id AS literature_id_81 ,
t53 . photo_gallery_id AS photo_gallery_id_82 ,
t53 . video_gallery_id AS video_gallery_id_83 ,
t53 . logo_id AS logo_id_84 ,
t53 . media_id AS media_id_85 ,
t53 . dummy_media_id AS dummy_media_id_86 ,
t53 . blog_id AS blog_id_87 ,
t53 . branch_locator_id AS branch_locator_id_88 ,
t53 . external_events_id AS external_events_id_89 ,
t53 . newsletters_id AS newsletters_id_90 ,
t53 . partners_reps_id AS partners_reps_id_91 ,
t53 . rep_lines_id AS rep_lines_id_92 ,
t53 . directory_content_id AS directory_content_id_93 ,
t94 . id AS id_95 ,
t94 . version AS version_96 ,
t94 . title AS title_97 ,
t94 . description AS description_98 ,
t94 . call_to_action AS call_to_action_99 ,
t94 . bio AS bio_100 ,
t94 . modified_at AS modified_at_101 ,
t94 . created_at AS created_at_102 ,
t94 . status AS status_103 ,
t94 . email AS email_104 ,
t94 . external_request_more AS external_request_more_105 ,
t94 . website AS website_106 ,
t94 . facebook AS facebook_107 ,
t94 . twitter AS twitter_108 ,
t94 . linkedin AS linkedin_109 ,
t94 . instagram AS instagram_110 ,
t94 . tiktok AS tiktok_111 ,
t94 . youtube AS youtube_112 ,
t94 . hash_tag AS hash_tag_113 ,
t94 . location AS location_114 ,
t94 . state AS state_115 ,
t94 . keywords AS keywords_116 ,
t94 . customer_level AS customer_level_117 ,
t94 . customer_type AS customer_type_118 ,
t94 . type_work AS type_work_119 ,
t94 . show_photos AS show_photos_120 ,
t94 . prnt_id AS prnt_id_121 ,
t94 . literature_id AS literature_id_122 ,
t94 . photo_gallery_id AS photo_gallery_id_123 ,
t94 . video_gallery_id AS video_gallery_id_124 ,
t94 . logo_id AS logo_id_125 ,
t94 . media_id AS media_id_126 ,
t94 . dummy_media_id AS dummy_media_id_127 ,
t94 . blog_id AS blog_id_128 ,
t94 . branch_locator_id AS branch_locator_id_129 ,
t94 . external_events_id AS external_events_id_130 ,
t94 . newsletters_id AS newsletters_id_131 ,
t94 . partners_reps_id AS partners_reps_id_132 ,
t94 . rep_lines_id AS rep_lines_id_133 ,
t94 . directory_content_id AS directory_content_id_134
FROM
media_group t0
LEFT JOIN customer t12 ON t12 . literature_id = t0 . id
LEFT JOIN customer t53 ON t53 . photo_gallery_id = t0 . id
LEFT JOIN customer t94 ON t94 . video_gallery_id = t0 . id
WHERE
t0 . type = ?
Copy
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . modified_at AS modified_at_4 , t0 . created_at AS created_at_5 , t0 . status AS status_6 , t0 . attributes AS attributes_7 , t0 . sort_type AS sort_type_8 , t0 . display_limit AS display_limit_9 , t0 . position AS position_10 , t0 . type AS type_11 , t12 . id AS id_13 , t12 . version AS version_14 , t12 . title AS title_15 , t12 . description AS description_16 , t12 . call_to_action AS call_to_action_17 , t12 . bio AS bio_18 , t12 . modified_at AS modified_at_19 , t12 . created_at AS created_at_20 , t12 . status AS status_21 , t12 . email AS email_22 , t12 . external_request_more AS external_request_more_23 , t12 . website AS website_24 , t12 . facebook AS facebook_25 , t12 . twitter AS twitter_26 , t12 . linkedin AS linkedin_27 , t12 . instagram AS instagram_28 , t12 . tiktok AS tiktok_29 , t12 . youtube AS youtube_30 , t12 . hash_tag AS hash_tag_31 , t12 . location AS location_32 , t12 . state AS state_33 , t12 . keywords AS keywords_34 , t12 . customer_level AS customer_level_35 , t12 . customer_type AS customer_type_36 , t12 . type_work AS type_work_37 , t12 . show_photos AS show_photos_38 , t12 . prnt_id AS prnt_id_39 , t12 . literature_id AS literature_id_40 , t12 . photo_gallery_id AS photo_gallery_id_41 , t12 . video_gallery_id AS video_gallery_id_42 , t12 . logo_id AS logo_id_43 , t12 . media_id AS media_id_44 , t12 . dummy_media_id AS dummy_media_id_45 , t12 . blog_id AS blog_id_46 , t12 . branch_locator_id AS branch_locator_id_47 , t12 . external_events_id AS external_events_id_48 , t12 . newsletters_id AS newsletters_id_49 , t12 . partners_reps_id AS partners_reps_id_50 , t12 . rep_lines_id AS rep_lines_id_51 , t12 . directory_content_id AS directory_content_id_52 , t53 . id AS id_54 , t53 . version AS version_55 , t53 . title AS title_56 , t53 . description AS description_57 , t53 . call_to_action AS call_to_action_58 , t53 . bio AS bio_59 , t53 . modified_at AS modified_at_60 , t53 . created_at AS created_at_61 , t53 . status AS status_62 , t53 . email AS email_63 , t53 . external_request_more AS external_request_more_64 , t53 . website AS website_65 , t53 . facebook AS facebook_66 , t53 . twitter AS twitter_67 , t53 . linkedin AS linkedin_68 , t53 . instagram AS instagram_69 , t53 . tiktok AS tiktok_70 , t53 . youtube AS youtube_71 , t53 . hash_tag AS hash_tag_72 , t53 . location AS location_73 , t53 . state AS state_74 , t53 . keywords AS keywords_75 , t53 . customer_level AS customer_level_76 , t53 . customer_type AS customer_type_77 , t53 . type_work AS type_work_78 , t53 . show_photos AS show_photos_79 , t53 . prnt_id AS prnt_id_80 , t53 . literature_id AS literature_id_81 , t53 . photo_gallery_id AS photo_gallery_id_82 , t53 . video_gallery_id AS video_gallery_id_83 , t53 . logo_id AS logo_id_84 , t53 . media_id AS media_id_85 , t53 . dummy_media_id AS dummy_media_id_86 , t53 . blog_id AS blog_id_87 , t53 . branch_locator_id AS branch_locator_id_88 , t53 . external_events_id AS external_events_id_89 , t53 . newsletters_id AS newsletters_id_90 , t53 . partners_reps_id AS partners_reps_id_91 , t53 . rep_lines_id AS rep_lines_id_92 , t53 . directory_content_id AS directory_content_id_93 , t94 . id AS id_95 , t94 . version AS version_96 , t94 . title AS title_97 , t94 . description AS description_98 , t94 . call_to_action AS call_to_action_99 , t94 . bio AS bio_100 , t94 . modified_at AS modified_at_101 , t94 . created_at AS created_at_102 , t94 . status AS status_103 , t94 . email AS email_104 , t94 . external_request_more AS external_request_more_105 , t94 . website AS website_106 , t94 . facebook AS facebook_107 , t94 . twitter AS twitter_108 , t94 . linkedin AS linkedin_109 , t94 . instagram AS instagram_110 , t94 . tiktok AS tiktok_111 , t94 . youtube AS youtube_112 , t94 . hash_tag AS hash_tag_113 , t94 . location AS location_114 , t94 . state AS state_115 , t94 . keywords AS keywords_116 , t94 . customer_level AS customer_level_117 , t94 . customer_type AS customer_type_118 , t94 . type_work AS type_work_119 , t94 . show_photos AS show_photos_120 , t94 . prnt_id AS prnt_id_121 , t94 . literature_id AS literature_id_122 , t94 . photo_gallery_id AS photo_gallery_id_123 , t94 . video_gallery_id AS video_gallery_id_124 , t94 . logo_id AS logo_id_125 , t94 . media_id AS media_id_126 , t94 . dummy_media_id AS dummy_media_id_127 , t94 . blog_id AS blog_id_128 , t94 . branch_locator_id AS branch_locator_id_129 , t94 . external_events_id AS external_events_id_130 , t94 . newsletters_id AS newsletters_id_131 , t94 . partners_reps_id AS partners_reps_id_132 , t94 . rep_lines_id AS rep_lines_id_133 , t94 . directory_content_id AS directory_content_id_134 FROM media_group t0 LEFT JOIN customer t12 ON t12 . literature_id = t0 . id LEFT JOIN customer t53 ON t53 . photo_gallery_id = t0 . id LEFT JOIN customer t94 ON t94 . video_gallery_id = t0 . id WHERE t0 . type = 3 ;
Copy
6.63 ms (17.34%)
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' ) INNER JOIN content_meta c2_ ON c0_ . id = c2_ . content_id AND (c2_ . metakey = '_EventEndDate' AND c2_ . metavalue > = '2024-08-15 12:36:30' ) LEFT JOIN content_meta c3_ ON c0_ . id = c3_ . content_id AND (c3_ . metakey = '_IsEvent' ) INNER JOIN customer_content c5_ ON c0_ . id = c5_ . content_id INNER JOIN customer c4_ ON c4_ . id = c5_ . customer_id AND (c4_ . id = '167' ) INNER JOIN content_site c7_ ON c0_ . id = c7_ . content_id INNER JOIN site s6_ ON s6_ . id = c7_ . site_id AND (s6_ . id = 1 ) WHERE c0_ . status = 1 AND (c0_ . type = 7 OR c3_ . metavalue = 'yes' ) AND c1_ . metavalue < > '' AND c2_ . metavalue < > '' ORDER BY c1_ . metavalue ASC , c0_ . title ASC LIMIT 10 OFFSET 30
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' )
INNER JOIN content_meta c2_ ON c0_ . id = c2_ . content_id
AND (
c2_ . metakey = '_EventEndDate'
AND c2_ . metavalue > = '2024-08-15 12:36:30'
)
LEFT JOIN content_meta c3_ ON c0_ . id = c3_ . content_id
AND (c3_ . metakey = '_IsEvent' )
INNER JOIN customer_content c5_ ON c0_ . id = c5_ . content_id
INNER JOIN customer c4_ ON c4_ . id = c5_ . customer_id
AND (c4_ . id = '167' )
INNER JOIN content_site c7_ ON c0_ . id = c7_ . content_id
INNER JOIN site s6_ ON s6_ . id = c7_ . site_id
AND (s6_ . id = 1 )
WHERE
c0_ . status = 1
AND (
c0_ . type = 7
OR c3_ . metavalue = 'yes'
)
AND c1_ . metavalue < > ''
AND c2_ . metavalue < > ''
ORDER BY
c1_ . metavalue ASC ,
c0_ . title ASC
LIMIT
10 OFFSET 30
Copy
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' ) INNER JOIN content_meta c2_ ON c0_ . id = c2_ . content_id AND (c2_ . metakey = '_EventEndDate' AND c2_ . metavalue > = '2024-08-15 12:36:30' ) LEFT JOIN content_meta c3_ ON c0_ . id = c3_ . content_id AND (c3_ . metakey = '_IsEvent' ) INNER JOIN customer_content c5_ ON c0_ . id = c5_ . content_id INNER JOIN customer c4_ ON c4_ . id = c5_ . customer_id AND (c4_ . id = '167' ) INNER JOIN content_site c7_ ON c0_ . id = c7_ . content_id INNER JOIN site s6_ ON s6_ . id = c7_ . site_id AND (s6_ . id = 1 ) WHERE c0_ . status = 1 AND (c0_ . type = 7 OR c3_ . metavalue = 'yes' ) AND c1_ . metavalue < > '' AND c2_ . metavalue < > '' ORDER BY c1_ . metavalue ASC , c0_ . title ASC LIMIT 10 OFFSET 30 ;
Copy
5.91 ms (15.46%)
1
SELECT count (c0_ . id ) AS sclr_0 FROM content c0_ INNER JOIN customer_content c2_ ON c0_ . id = c2_ . content_id INNER JOIN customer c1_ ON c1_ . id = c2_ . customer_id AND (c1_ . id = '167' ) INNER JOIN content_site c4_ ON c0_ . id = c4_ . content_id INNER JOIN site s3_ ON s3_ . id = c4_ . site_id AND (s3_ . id = 1 ) WHERE c0_ . type = 7 AND c0_ . status = 1
SELECT count (c0_ . id ) AS sclr_0 FROM content c0_ INNER JOIN customer_content c2_ ON c0_ . id = c2_ . content_id INNER JOIN customer c1_ ON c1_ . id = c2_ . customer_id AND (c1_ . id = '167' ) INNER JOIN content_site c4_ ON c0_ . id = c4_ . content_id INNER JOIN site s3_ ON s3_ . id = c4_ . site_id AND (s3_ . id = 1 ) WHERE c0_ . type = 7 AND c0_ . status = 1 ;
Copy
4.53 ms (11.85%)
10
SELECT t0 . id AS id_1 , t0 . version AS version_2 , t0 . title AS title_3 , t0 . display_title AS display_title_4 , t0 . description AS description_5 , t0 . sort AS sort_6 , t0 . modified_at AS modified_at_7 , t0 . created_at AS created_at_8 , t0 . published_at AS published_at_9 , t0 . expires_at AS expires_at_10 , t0 . status AS status_11 , t0 . total_impressions AS total_impressions_12 , t0 . total_clicks AS total_clicks_13 , t0 . attributes AS attributes_14 , t0 . external_url AS external_url_15 , t0 . youtube_url AS youtube_url_16 , t0 . french_url AS french_url_17 , t0 . spanish_url AS spanish_url_18 , t0 . countdown AS countdown_19 , t0 . question_slider AS question_slider_20 , t0 . site_default AS site_default_21 , t0 . pinned_uuid AS pinned_uuid_22 , t0 . media_id AS media_id_23 , t0 . secondary_media_id AS secondary_media_id_24 , t0 . french_media_id AS french_media_id_25 , t0 . spanish_media_id AS spanish_media_id_26 , t0 . media_group_id AS media_group_id_27 , t0 . gallery_id AS gallery_id_28 , t29 . id AS id_30 , t29 . version AS version_31 , t29 . title AS title_32 , t29 . description AS description_33 , t29 . published_at AS published_at_34 , t29 . modified_at AS modified_at_35 , t29 . created_at AS created_at_36 , t29 . response_close_date AS response_close_date_37 , t29 . expires_at AS expires_at_38 , t29 . status AS status_39 , t29 . info_url AS info_url_40 , t29 . total_impressions AS total_impressions_41 , t29 . requires_login AS requires_login_42 , t29 . type AS type_43 , t29 . media_id AS media_id_44 , t29 . ad_id AS ad_id_45 , t0 . pop_out_poll_id AS pop_out_poll_id_46 FROM media_group_item t0 LEFT JOIN poll t29 ON t29 . ad_id = t0 . id WHERE (t0 . status = ? AND t0 . media_group_id = ? ) ORDER BY t0 . published_at ASC
Parameters :
[
"1 "
"888 "
]
SELECT
t0 . id AS id_1 ,
t0 . version AS version_2 ,
t0 . title AS title_3 ,
t0 . display_title AS display_title_4 ,
t0 . description AS description_5 ,
t0 . sort AS sort_6 ,
t0 . modified_at AS modified_at_7 ,
t0 . created_at AS created_at_8 ,
t0 . published_at AS published_at_9 ,
t0 . expires_at AS expires_at_10 ,
t0 . status AS status_11 ,
t0 . total_impressions AS total_impressions_12 ,
t0 . total_clicks AS total_clicks_13 ,
t0 . attributes AS attributes_14 ,
t0 . external_url AS external_url_15 ,
t0 . youtube_url AS youtube_url_16 ,
t0 . french_url AS french_url_17 ,
t0 . spanish_url AS spanish_url_18 ,
t0 . countdown AS countdown_19 ,
t0 . question_slider AS question_slider_20 ,
t0 . site_default AS site_default_21 ,
t0 . pinned_uuid AS pinned_uuid_22 ,
t0 . media_id AS media_id_23 ,
t0 . secondary_media_id AS secondary_media_id_24 ,
t0 . french_media_id AS french_media_id_25 ,
t0 . spanish_media_id AS spanish_media_id_26 ,
t0 . media_group_id AS media_group_id_27 ,
t0 . gallery_id AS gallery_id_28 ,
t29 . id AS id_30 ,
t29 . version AS version_31 ,
t29 . title AS title_32 ,
t29 . description AS description_33 ,
t29 . published_at AS published_at_34 ,
t29 . modified_at AS modified_at_35 ,
t29 . created_at AS created_at_36 ,
t29 . response_close_date AS response_close_date_37 ,
t29 . expires_at AS expires_at_38 ,
t29 . status AS status_39 ,
t29 . info_url AS info_url_40 ,
t29 . total_impressions AS total_impressions_41 ,
t29 . requires_login AS requires_login_42 ,
t29 . type AS type_43 ,
t29 . media_id AS media_id_44 ,
t29 . ad_id AS ad_id_45 ,
t0 . pop_out_poll_id AS pop_out_poll_id_46
FROM
media_group_item t0
LEFT JOIN poll t29 ON t29 . ad_id = t0 . id
WHERE
(
t0 . status = ?
AND t0 . media_group_id = ?
)
ORDER BY
t0 . published_at ASC
Copy
SELECT t0 . id AS id_1 , t0 . version AS version_2 , t0 . title AS title_3 , t0 . display_title AS display_title_4 , t0 . description AS description_5 , t0 . sort AS sort_6 , t0 . modified_at AS modified_at_7 , t0 . created_at AS created_at_8 , t0 . published_at AS published_at_9 , t0 . expires_at AS expires_at_10 , t0 . status AS status_11 , t0 . total_impressions AS total_impressions_12 , t0 . total_clicks AS total_clicks_13 , t0 . attributes AS attributes_14 , t0 . external_url AS external_url_15 , t0 . youtube_url AS youtube_url_16 , t0 . french_url AS french_url_17 , t0 . spanish_url AS spanish_url_18 , t0 . countdown AS countdown_19 , t0 . question_slider AS question_slider_20 , t0 . site_default AS site_default_21 , t0 . pinned_uuid AS pinned_uuid_22 , t0 . media_id AS media_id_23 , t0 . secondary_media_id AS secondary_media_id_24 , t0 . french_media_id AS french_media_id_25 , t0 . spanish_media_id AS spanish_media_id_26 , t0 . media_group_id AS media_group_id_27 , t0 . gallery_id AS gallery_id_28 , t29 . id AS id_30 , t29 . version AS version_31 , t29 . title AS title_32 , t29 . description AS description_33 , t29 . published_at AS published_at_34 , t29 . modified_at AS modified_at_35 , t29 . created_at AS created_at_36 , t29 . response_close_date AS response_close_date_37 , t29 . expires_at AS expires_at_38 , t29 . status AS status_39 , t29 . info_url AS info_url_40 , t29 . total_impressions AS total_impressions_41 , t29 . requires_login AS requires_login_42 , t29 . type AS type_43 , t29 . media_id AS media_id_44 , t29 . ad_id AS ad_id_45 , t0 . pop_out_poll_id AS pop_out_poll_id_46 FROM media_group_item t0 LEFT JOIN poll t29 ON t29 . ad_id = t0 . id WHERE (t0 . status = '1' AND t0 . media_group_id = '888' ) ORDER BY t0 . published_at ASC ;
Copy
3.47 ms (9.09%)
4
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . modified_at AS modified_at_4 , t0 . created_at AS created_at_5 , t0 . status AS status_6 , t0 . attributes AS attributes_7 , t0 . sort_type AS sort_type_8 , t0 . display_limit AS display_limit_9 , t0 . position AS position_10 , t0 . type AS type_11 , t12 . id AS id_13 , t12 . version AS version_14 , t12 . title AS title_15 , t12 . description AS description_16 , t12 . call_to_action AS call_to_action_17 , t12 . bio AS bio_18 , t12 . modified_at AS modified_at_19 , t12 . created_at AS created_at_20 , t12 . status AS status_21 , t12 . email AS email_22 , t12 . external_request_more AS external_request_more_23 , t12 . website AS website_24 , t12 . facebook AS facebook_25 , t12 . twitter AS twitter_26 , t12 . linkedin AS linkedin_27 , t12 . instagram AS instagram_28 , t12 . tiktok AS tiktok_29 , t12 . youtube AS youtube_30 , t12 . hash_tag AS hash_tag_31 , t12 . location AS location_32 , t12 . state AS state_33 , t12 . keywords AS keywords_34 , t12 . customer_level AS customer_level_35 , t12 . customer_type AS customer_type_36 , t12 . type_work AS type_work_37 , t12 . show_photos AS show_photos_38 , t12 . prnt_id AS prnt_id_39 , t12 . literature_id AS literature_id_40 , t12 . photo_gallery_id AS photo_gallery_id_41 , t12 . video_gallery_id AS video_gallery_id_42 , t12 . logo_id AS logo_id_43 , t12 . media_id AS media_id_44 , t12 . dummy_media_id AS dummy_media_id_45 , t12 . blog_id AS blog_id_46 , t12 . branch_locator_id AS branch_locator_id_47 , t12 . external_events_id AS external_events_id_48 , t12 . newsletters_id AS newsletters_id_49 , t12 . partners_reps_id AS partners_reps_id_50 , t12 . rep_lines_id AS rep_lines_id_51 , t12 . directory_content_id AS directory_content_id_52 , t53 . id AS id_54 , t53 . version AS version_55 , t53 . title AS title_56 , t53 . description AS description_57 , t53 . call_to_action AS call_to_action_58 , t53 . bio AS bio_59 , t53 . modified_at AS modified_at_60 , t53 . created_at AS created_at_61 , t53 . status AS status_62 , t53 . email AS email_63 , t53 . external_request_more AS external_request_more_64 , t53 . website AS website_65 , t53 . facebook AS facebook_66 , t53 . twitter AS twitter_67 , t53 . linkedin AS linkedin_68 , t53 . instagram AS instagram_69 , t53 . tiktok AS tiktok_70 , t53 . youtube AS youtube_71 , t53 . hash_tag AS hash_tag_72 , t53 . location AS location_73 , t53 . state AS state_74 , t53 . keywords AS keywords_75 , t53 . customer_level AS customer_level_76 , t53 . customer_type AS customer_type_77 , t53 . type_work AS type_work_78 , t53 . show_photos AS show_photos_79 , t53 . prnt_id AS prnt_id_80 , t53 . literature_id AS literature_id_81 , t53 . photo_gallery_id AS photo_gallery_id_82 , t53 . video_gallery_id AS video_gallery_id_83 , t53 . logo_id AS logo_id_84 , t53 . media_id AS media_id_85 , t53 . dummy_media_id AS dummy_media_id_86 , t53 . blog_id AS blog_id_87 , t53 . branch_locator_id AS branch_locator_id_88 , t53 . external_events_id AS external_events_id_89 , t53 . newsletters_id AS newsletters_id_90 , t53 . partners_reps_id AS partners_reps_id_91 , t53 . rep_lines_id AS rep_lines_id_92 , t53 . directory_content_id AS directory_content_id_93 , t94 . id AS id_95 , t94 . version AS version_96 , t94 . title AS title_97 , t94 . description AS description_98 , t94 . call_to_action AS call_to_action_99 , t94 . bio AS bio_100 , t94 . modified_at AS modified_at_101 , t94 . created_at AS created_at_102 , t94 . status AS status_103 , t94 . email AS email_104 , t94 . external_request_more AS external_request_more_105 , t94 . website AS website_106 , t94 . facebook AS facebook_107 , t94 . twitter AS twitter_108 , t94 . linkedin AS linkedin_109 , t94 . instagram AS instagram_110 , t94 . tiktok AS tiktok_111 , t94 . youtube AS youtube_112 , t94 . hash_tag AS hash_tag_113 , t94 . location AS location_114 , t94 . state AS state_115 , t94 . keywords AS keywords_116 , t94 . customer_level AS customer_level_117 , t94 . customer_type AS customer_type_118 , t94 . type_work AS type_work_119 , t94 . show_photos AS show_photos_120 , t94 . prnt_id AS prnt_id_121 , t94 . literature_id AS literature_id_122 , t94 . photo_gallery_id AS photo_gallery_id_123 , t94 . video_gallery_id AS video_gallery_id_124 , t94 . logo_id AS logo_id_125 , t94 . media_id AS media_id_126 , t94 . dummy_media_id AS dummy_media_id_127 , t94 . blog_id AS blog_id_128 , t94 . branch_locator_id AS branch_locator_id_129 , t94 . external_events_id AS external_events_id_130 , t94 . newsletters_id AS newsletters_id_131 , t94 . partners_reps_id AS partners_reps_id_132 , t94 . rep_lines_id AS rep_lines_id_133 , t94 . directory_content_id AS directory_content_id_134 FROM media_group t0 LEFT JOIN customer t12 ON t12 . literature_id = t0 . id LEFT JOIN customer t53 ON t53 . photo_gallery_id = t0 . id LEFT JOIN customer t94 ON t94 . video_gallery_id = t0 . id WHERE t0 . position = ? LIMIT 1
Parameters :
[
"ad-video-coffee-cast "
]
SELECT
t0 . id AS id_1 ,
t0 . title AS title_2 ,
t0 . description AS description_3 ,
t0 . modified_at AS modified_at_4 ,
t0 . created_at AS created_at_5 ,
t0 . status AS status_6 ,
t0 . attributes AS attributes_7 ,
t0 . sort_type AS sort_type_8 ,
t0 . display_limit AS display_limit_9 ,
t0 . position AS position_10 ,
t0 . type AS type_11 ,
t12 . id AS id_13 ,
t12 . version AS version_14 ,
t12 . title AS title_15 ,
t12 . description AS description_16 ,
t12 . call_to_action AS call_to_action_17 ,
t12 . bio AS bio_18 ,
t12 . modified_at AS modified_at_19 ,
t12 . created_at AS created_at_20 ,
t12 . status AS status_21 ,
t12 . email AS email_22 ,
t12 . external_request_more AS external_request_more_23 ,
t12 . website AS website_24 ,
t12 . facebook AS facebook_25 ,
t12 . twitter AS twitter_26 ,
t12 . linkedin AS linkedin_27 ,
t12 . instagram AS instagram_28 ,
t12 . tiktok AS tiktok_29 ,
t12 . youtube AS youtube_30 ,
t12 . hash_tag AS hash_tag_31 ,
t12 . location AS location_32 ,
t12 . state AS state_33 ,
t12 . keywords AS keywords_34 ,
t12 . customer_level AS customer_level_35 ,
t12 . customer_type AS customer_type_36 ,
t12 . type_work AS type_work_37 ,
t12 . show_photos AS show_photos_38 ,
t12 . prnt_id AS prnt_id_39 ,
t12 . literature_id AS literature_id_40 ,
t12 . photo_gallery_id AS photo_gallery_id_41 ,
t12 . video_gallery_id AS video_gallery_id_42 ,
t12 . logo_id AS logo_id_43 ,
t12 . media_id AS media_id_44 ,
t12 . dummy_media_id AS dummy_media_id_45 ,
t12 . blog_id AS blog_id_46 ,
t12 . branch_locator_id AS branch_locator_id_47 ,
t12 . external_events_id AS external_events_id_48 ,
t12 . newsletters_id AS newsletters_id_49 ,
t12 . partners_reps_id AS partners_reps_id_50 ,
t12 . rep_lines_id AS rep_lines_id_51 ,
t12 . directory_content_id AS directory_content_id_52 ,
t53 . id AS id_54 ,
t53 . version AS version_55 ,
t53 . title AS title_56 ,
t53 . description AS description_57 ,
t53 . call_to_action AS call_to_action_58 ,
t53 . bio AS bio_59 ,
t53 . modified_at AS modified_at_60 ,
t53 . created_at AS created_at_61 ,
t53 . status AS status_62 ,
t53 . email AS email_63 ,
t53 . external_request_more AS external_request_more_64 ,
t53 . website AS website_65 ,
t53 . facebook AS facebook_66 ,
t53 . twitter AS twitter_67 ,
t53 . linkedin AS linkedin_68 ,
t53 . instagram AS instagram_69 ,
t53 . tiktok AS tiktok_70 ,
t53 . youtube AS youtube_71 ,
t53 . hash_tag AS hash_tag_72 ,
t53 . location AS location_73 ,
t53 . state AS state_74 ,
t53 . keywords AS keywords_75 ,
t53 . customer_level AS customer_level_76 ,
t53 . customer_type AS customer_type_77 ,
t53 . type_work AS type_work_78 ,
t53 . show_photos AS show_photos_79 ,
t53 . prnt_id AS prnt_id_80 ,
t53 . literature_id AS literature_id_81 ,
t53 . photo_gallery_id AS photo_gallery_id_82 ,
t53 . video_gallery_id AS video_gallery_id_83 ,
t53 . logo_id AS logo_id_84 ,
t53 . media_id AS media_id_85 ,
t53 . dummy_media_id AS dummy_media_id_86 ,
t53 . blog_id AS blog_id_87 ,
t53 . branch_locator_id AS branch_locator_id_88 ,
t53 . external_events_id AS external_events_id_89 ,
t53 . newsletters_id AS newsletters_id_90 ,
t53 . partners_reps_id AS partners_reps_id_91 ,
t53 . rep_lines_id AS rep_lines_id_92 ,
t53 . directory_content_id AS directory_content_id_93 ,
t94 . id AS id_95 ,
t94 . version AS version_96 ,
t94 . title AS title_97 ,
t94 . description AS description_98 ,
t94 . call_to_action AS call_to_action_99 ,
t94 . bio AS bio_100 ,
t94 . modified_at AS modified_at_101 ,
t94 . created_at AS created_at_102 ,
t94 . status AS status_103 ,
t94 . email AS email_104 ,
t94 . external_request_more AS external_request_more_105 ,
t94 . website AS website_106 ,
t94 . facebook AS facebook_107 ,
t94 . twitter AS twitter_108 ,
t94 . linkedin AS linkedin_109 ,
t94 . instagram AS instagram_110 ,
t94 . tiktok AS tiktok_111 ,
t94 . youtube AS youtube_112 ,
t94 . hash_tag AS hash_tag_113 ,
t94 . location AS location_114 ,
t94 . state AS state_115 ,
t94 . keywords AS keywords_116 ,
t94 . customer_level AS customer_level_117 ,
t94 . customer_type AS customer_type_118 ,
t94 . type_work AS type_work_119 ,
t94 . show_photos AS show_photos_120 ,
t94 . prnt_id AS prnt_id_121 ,
t94 . literature_id AS literature_id_122 ,
t94 . photo_gallery_id AS photo_gallery_id_123 ,
t94 . video_gallery_id AS video_gallery_id_124 ,
t94 . logo_id AS logo_id_125 ,
t94 . media_id AS media_id_126 ,
t94 . dummy_media_id AS dummy_media_id_127 ,
t94 . blog_id AS blog_id_128 ,
t94 . branch_locator_id AS branch_locator_id_129 ,
t94 . external_events_id AS external_events_id_130 ,
t94 . newsletters_id AS newsletters_id_131 ,
t94 . partners_reps_id AS partners_reps_id_132 ,
t94 . rep_lines_id AS rep_lines_id_133 ,
t94 . directory_content_id AS directory_content_id_134
FROM
media_group t0
LEFT JOIN customer t12 ON t12 . literature_id = t0 . id
LEFT JOIN customer t53 ON t53 . photo_gallery_id = t0 . id
LEFT JOIN customer t94 ON t94 . video_gallery_id = t0 . id
WHERE
t0 . position = ?
LIMIT
1
Copy
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . modified_at AS modified_at_4 , t0 . created_at AS created_at_5 , t0 . status AS status_6 , t0 . attributes AS attributes_7 , t0 . sort_type AS sort_type_8 , t0 . display_limit AS display_limit_9 , t0 . position AS position_10 , t0 . type AS type_11 , t12 . id AS id_13 , t12 . version AS version_14 , t12 . title AS title_15 , t12 . description AS description_16 , t12 . call_to_action AS call_to_action_17 , t12 . bio AS bio_18 , t12 . modified_at AS modified_at_19 , t12 . created_at AS created_at_20 , t12 . status AS status_21 , t12 . email AS email_22 , t12 . external_request_more AS external_request_more_23 , t12 . website AS website_24 , t12 . facebook AS facebook_25 , t12 . twitter AS twitter_26 , t12 . linkedin AS linkedin_27 , t12 . instagram AS instagram_28 , t12 . tiktok AS tiktok_29 , t12 . youtube AS youtube_30 , t12 . hash_tag AS hash_tag_31 , t12 . location AS location_32 , t12 . state AS state_33 , t12 . keywords AS keywords_34 , t12 . customer_level AS customer_level_35 , t12 . customer_type AS customer_type_36 , t12 . type_work AS type_work_37 , t12 . show_photos AS show_photos_38 , t12 . prnt_id AS prnt_id_39 , t12 . literature_id AS literature_id_40 , t12 . photo_gallery_id AS photo_gallery_id_41 , t12 . video_gallery_id AS video_gallery_id_42 , t12 . logo_id AS logo_id_43 , t12 . media_id AS media_id_44 , t12 . dummy_media_id AS dummy_media_id_45 , t12 . blog_id AS blog_id_46 , t12 . branch_locator_id AS branch_locator_id_47 , t12 . external_events_id AS external_events_id_48 , t12 . newsletters_id AS newsletters_id_49 , t12 . partners_reps_id AS partners_reps_id_50 , t12 . rep_lines_id AS rep_lines_id_51 , t12 . directory_content_id AS directory_content_id_52 , t53 . id AS id_54 , t53 . version AS version_55 , t53 . title AS title_56 , t53 . description AS description_57 , t53 . call_to_action AS call_to_action_58 , t53 . bio AS bio_59 , t53 . modified_at AS modified_at_60 , t53 . created_at AS created_at_61 , t53 . status AS status_62 , t53 . email AS email_63 , t53 . external_request_more AS external_request_more_64 , t53 . website AS website_65 , t53 . facebook AS facebook_66 , t53 . twitter AS twitter_67 , t53 . linkedin AS linkedin_68 , t53 . instagram AS instagram_69 , t53 . tiktok AS tiktok_70 , t53 . youtube AS youtube_71 , t53 . hash_tag AS hash_tag_72 , t53 . location AS location_73 , t53 . state AS state_74 , t53 . keywords AS keywords_75 , t53 . customer_level AS customer_level_76 , t53 . customer_type AS customer_type_77 , t53 . type_work AS type_work_78 , t53 . show_photos AS show_photos_79 , t53 . prnt_id AS prnt_id_80 , t53 . literature_id AS literature_id_81 , t53 . photo_gallery_id AS photo_gallery_id_82 , t53 . video_gallery_id AS video_gallery_id_83 , t53 . logo_id AS logo_id_84 , t53 . media_id AS media_id_85 , t53 . dummy_media_id AS dummy_media_id_86 , t53 . blog_id AS blog_id_87 , t53 . branch_locator_id AS branch_locator_id_88 , t53 . external_events_id AS external_events_id_89 , t53 . newsletters_id AS newsletters_id_90 , t53 . partners_reps_id AS partners_reps_id_91 , t53 . rep_lines_id AS rep_lines_id_92 , t53 . directory_content_id AS directory_content_id_93 , t94 . id AS id_95 , t94 . version AS version_96 , t94 . title AS title_97 , t94 . description AS description_98 , t94 . call_to_action AS call_to_action_99 , t94 . bio AS bio_100 , t94 . modified_at AS modified_at_101 , t94 . created_at AS created_at_102 , t94 . status AS status_103 , t94 . email AS email_104 , t94 . external_request_more AS external_request_more_105 , t94 . website AS website_106 , t94 . facebook AS facebook_107 , t94 . twitter AS twitter_108 , t94 . linkedin AS linkedin_109 , t94 . instagram AS instagram_110 , t94 . tiktok AS tiktok_111 , t94 . youtube AS youtube_112 , t94 . hash_tag AS hash_tag_113 , t94 . location AS location_114 , t94 . state AS state_115 , t94 . keywords AS keywords_116 , t94 . customer_level AS customer_level_117 , t94 . customer_type AS customer_type_118 , t94 . type_work AS type_work_119 , t94 . show_photos AS show_photos_120 , t94 . prnt_id AS prnt_id_121 , t94 . literature_id AS literature_id_122 , t94 . photo_gallery_id AS photo_gallery_id_123 , t94 . video_gallery_id AS video_gallery_id_124 , t94 . logo_id AS logo_id_125 , t94 . media_id AS media_id_126 , t94 . dummy_media_id AS dummy_media_id_127 , t94 . blog_id AS blog_id_128 , t94 . branch_locator_id AS branch_locator_id_129 , t94 . external_events_id AS external_events_id_130 , t94 . newsletters_id AS newsletters_id_131 , t94 . partners_reps_id AS partners_reps_id_132 , t94 . rep_lines_id AS rep_lines_id_133 , t94 . directory_content_id AS directory_content_id_134 FROM media_group t0 LEFT JOIN customer t12 ON t12 . literature_id = t0 . id LEFT JOIN customer t53 ON t53 . photo_gallery_id = t0 . id LEFT JOIN customer t94 ON t94 . video_gallery_id = t0 . id WHERE t0 . position = 'ad-video-coffee-cast' LIMIT 1 ;
Copy
2.76 ms (7.21%)
11
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . meta_title AS meta_title_3 FROM site t0 INNER JOIN ad_site ON t0 . id = ad_site . site_id WHERE ad_site . media_group_item_id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . meta_title AS meta_title_3 FROM site t0 INNER JOIN ad_site ON t0 . id = ad_site . site_id WHERE ad_site . media_group_item_id = '7176' ;
Copy
2.44 ms (6.38%)
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_ WHERE c0_ . slug = ? AND c0_ . type = ? AND (c0_ . status = 1 OR c0_ . status = - 5 ) LIMIT 1
Parameters :
[
"iibec-international-institute-of-building-enclosure-consultants "
4
]
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_
WHERE
c0_ . slug = ?
AND c0_ . type = ?
AND (
c0_ . status = 1
OR c0_ . status = - 5
)
LIMIT
1
Copy
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_ WHERE c0_ . slug = 'iibec-international-institute-of-building-enclosure-consultants' AND c0_ . type = 4 AND (c0_ . status = 1 OR c0_ . status = - 5 ) LIMIT 1 ;
Copy
1.47 ms (3.84%)
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 = ?
AND s1_ . id = ?
Copy
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 = '4' AND s1_ . id = 1 ;
Copy
0.56 ms (1.47%)
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 = '103742' ;
Copy
0.24 ms (0.63%)
1
SELECT * FROM mega_menu where mega_menu . site_code = :sitecode and mega_menu . status = 1
Parameters :
[
"sitecode " => 1
]
SELECT * FROM mega_menu where mega_menu . site_code = 1 and mega_menu . status = 1 ;
Copy