SHOW FULL COLUMNS FROM `ds_adv` [ RunTime:0.001014s ]
SELECT `adv_id`,`ap_id`,`adv_title`,`adv_link`,`adv_code`,`adv_startdate`,`adv_enddate`,`adv_sort`,`adv_enabled`,`adv_clicknum`,`adv_bgcolor`,`adv_provestatus`,`adv_createtime`,`adv_priority`,`adv_abstract`,`createuser`,`update_user`,`update_time` FROM `ds_adv` WHERE `ap_id` = 1 AND `adv_enabled` = 1 AND `adv_startdate` < 1728532800 AND `adv_enddate` > 1728532800 ORDER BY `adv_sort` ASC,`adv_id` ASC [ RunTime:0.001079s ]
SELECT `adv_id`,`ap_id`,`adv_title`,`adv_link`,`adv_code`,`adv_startdate`,`adv_enddate`,`adv_sort`,`adv_enabled`,`adv_clicknum`,`adv_bgcolor`,`adv_provestatus`,`adv_createtime`,`adv_priority`,`adv_abstract`,`createuser`,`update_user`,`update_time` FROM `ds_adv` WHERE `ap_id` = 90 AND `adv_enabled` = 1 AND `adv_startdate` < 1728532800 AND `adv_enddate` > 1728532800 ORDER BY `adv_sort` ASC,`adv_id` ASC [ RunTime:0.000804s ]
SHOW FULL COLUMNS FROM `ds_search_adv` [ RunTime:0.001098s ]
SELECT `adv_id`,`adv_type`,`keywords`,`adv_title`,`adv_link`,`adv_startdate`,`adv_enddate`,`adv_sort`,`adv_enabled`,`adv_clicknum`,`adv_provestatus`,`adv_createtime`,`goods_id` FROM `ds_search_adv` WHERE `adv_type` = 1 AND `adv_enabled` = 1 AND `adv_startdate` < 1728532800 AND `adv_enddate` > 1728532800 ORDER BY `adv_id` DESC [ RunTime:0.000729s ]
SHOW FULL COLUMNS FROM `ds_applet` [ RunTime:0.001004s ]
SELECT `app_state` FROM `ds_applet` WHERE `member_id` IS NULL LIMIT 1 [ RunTime:0.000527s ]
SHOW FULL COLUMNS FROM `ds_articlehelpclass` [ RunTime:0.000989s ]
SELECT `ac_help_id`,`ac_code`,`ac_name`,`ac_parent_id`,`ac_sort` FROM `ds_articlehelpclass` WHERE `ac_help_id` NOT IN (7,8,9) ORDER BY ac_parent_id ASC, CASE WHEN ac_sort IS NULL THEN 1 ELSE 0 END ASC, ac_sort ASC, ac_help_id ASC [ RunTime:0.000723s ]
SHOW FULL COLUMNS FROM `ds_articlehelp` [ RunTime:0.001054s ]
SELECT `articlehelp_id`,`ac_help_id`,`article_url`,`article_show`,`article_sort`,`article_title`,`article_content`,`article_time`,`article_pic` FROM `ds_articlehelp` WHERE `article_show` = 1 AND `ac_help_id` NOT IN (7,8,9) ORDER BY `article_sort` [ RunTime:0.002074s ]
SHOW FULL COLUMNS FROM `ds_link` [ RunTime:0.001060s ]
SELECT * FROM `ds_link` ORDER BY IF(link_sort IS NULL, 1, 0) asc, link_sort asc [ RunTime:0.000666s ]
SHOW FULL COLUMNS FROM `ds_config` [ RunTime:0.000981s ]
SELECT * FROM `ds_config` [ RunTime:0.000743s ]
SHOW FULL COLUMNS FROM `ds_seo` [ RunTime:0.001087s ]
SELECT * FROM `ds_seo` [ RunTime:0.000625s ]
SELECT * FROM `ds_adv` WHERE `ap_id` = 180 AND `adv_enabled` = 1 AND `adv_startdate` < 1728532800 AND `adv_enddate` > 1728532800 ORDER BY `adv_sort` [ RunTime:0.001119s ]
SELECT * FROM `ds_adv` WHERE `ap_id` = 183 AND `adv_enabled` = 1 ORDER BY `adv_createtime` DESC LIMIT 1 [ RunTime:0.000785s ]
SELECT * FROM `ds_adv` WHERE `ap_id` = 181 AND `adv_enabled` = 1 AND `adv_startdate` < 1728532800 AND `adv_enddate` > 1728532800 ORDER BY `adv_sort` [ RunTime:0.000981s ]
SELECT * FROM `ds_adv` WHERE `ap_id` = 184 AND `adv_enabled` = 1 ORDER BY `adv_createtime` DESC LIMIT 1 [ RunTime:0.000650s ]
SELECT * FROM `ds_adv` WHERE `ap_id` = 182 AND `adv_enabled` = 1 AND `adv_startdate` < 1728532800 AND `adv_enddate` > 1728532800 ORDER BY `adv_sort` [ RunTime:0.000692s ]
SELECT * FROM `ds_adv` WHERE `ap_id` = 185 AND `adv_enabled` = 1 ORDER BY `adv_createtime` DESC LIMIT 1 [ RunTime:0.001024s ]
SHOW FULL COLUMNS FROM `ds_v_hotwords_buy` [ RunTime:0.000885s ]
SELECT * FROM `ds_v_hotwords_buy` LIMIT 4 [ RunTime:0.000649s ]
SHOW FULL COLUMNS FROM `ds_v_show_member` [ RunTime:0.001109s ]
SELECT * FROM `ds_v_show_member` WHERE ( `member_id` = '' AND `gc_id` <> 37 ) OR ( `member_id` = '' ) GROUP BY `gc_id` ORDER BY `sort3` DESC,`sort2`,`sort1` LIMIT 6 [ RunTime:0.016491s ]
SHOW FULL COLUMNS FROM `ds_goodsclass` [ RunTime:0.001149s ]
SELECT `gc_name`,`gc_id` FROM `ds_goodsclass` [ RunTime:0.000703s ]
SELECT `gc_name`,`gc_id` FROM `ds_goodsclass` [ RunTime:0.000955s ]
SHOW FULL COLUMNS FROM `ds_v_home_meeting` [ RunTime:0.001365s ]
SELECT `v`.`ap_id`,`v`.`meeting_id`,`v`.`title`,`v`.`address`,`v`.`filepath`,`v`.`introduce`,`v`.`meetingtime`,`v`.`livedate`,`m`.`newpath` FROM `ds_v_home_meeting` `v` LEFT JOIN `ds_meeting` `m` ON `v`.`meeting_id`=`m`.`meeting_id` WHERE ( `v`.`code` = 'live' AND `v`.`tag_type` = '0' AND `v`.`meetingtag_name` = '广告' ) ORDER BY `v`.`recommand` DESC,`v`.`sort` ASC,`v`.`order_livedate` DESC LIMIT 5 [ RunTime:0.002434s ]
SELECT `v`.`ap_id`,`v`.`meeting_id`,`v`.`title`,`v`.`address`,`v`.`filepath`,`v`.`introduce`,`v`.`meetingtime`,`v`.`livedate`,`m`.`newpath` FROM `ds_v_home_meeting` `v` LEFT JOIN `ds_meeting` `m` ON `v`.`meeting_id`=`m`.`meeting_id` WHERE `v`.`code` = 'live' ORDER BY `v`.`recommand` DESC,`v`.`sort` ASC,`v`.`order_livedate` DESC LIMIT 5 [ RunTime:0.002946s ]
SHOW FULL COLUMNS FROM `ds_v_recommend_meeting` [ RunTime:0.001720s ]
SELECT COUNT(*) AS think_count FROM `ds_v_recommend_meeting` `v` LEFT JOIN `ds_meeting` `m` ON `m`.`meeting_id`=`v`.`meeting_id` WHERE ( v.catid_1=8&&m.oldpath!=""&&(m.livedate<1728489600||(m.livedate=1728489600&&m.liveto<1728536253)) and v.meeting_id <>3540 ) [ RunTime:0.092864s ]
SELECT `v`.*,`m`.`introduce`,`m`.`sponsor`,`m`.`hits`,`m`.`livedate`,`m`.`livefrom`,`m`.`liveto`,`m`.`liveaddress`,`m`.`livestatus`,`m`.`oldpath` FROM `ds_v_recommend_meeting` `v` LEFT JOIN `ds_meeting` `m` ON `m`.`meeting_id`=`v`.`meeting_id` WHERE ( v.catid_1=8&&m.oldpath!=""&&(m.livedate<1728489600||(m.livedate=1728489600&&m.liveto<1728536253)) and v.meeting_id <>3540 ) ORDER BY `v`.`orderlive` DESC,v.orders is null,`v`.`orders`,`v`.`orders` ASC,(case when v.orderlive > 0 then concat(date_format(from_unixtime(`m`.`livedate`), '%Y-%m-%d'), ' ', date_format(from_unixtime(`m`.`livefrom`), '%H:%i:%d')) end) asc,(case when v.orderlive = 0 then concat(date_format(from_unixtime(`m`.`livedate`), '%Y-%m-%d'), ' ', date_format(from_unixtime(`m`.`livefrom`), '%H:%i:%d')) end) desc LIMIT 0,3 [ RunTime:0.094030s ]
SELECT `ap_id`,`meeting_id`,`title`,`address`,`filepath`,`introduce`,`meetingtime`,`livedate`,`indexpath`,`meetingtag_name`,`thumbpath` FROM `ds_v_home_meeting` WHERE ( `code` = 'exhibition' AND `meetingtag_name` = '广告' AND `ordermeeting` = 2 AND ( `indexpath` IS NOT NULL ) ) ORDER BY `ap_id`,`sort` ASC,`ordermeeting` DESC,(case when ordermeeting = 2 then fromtime end) desc,(case when ordermeeting = 1 then fromtime end) asc,(case when ordermeeting = 0 then totime end) desc LIMIT 6 [ RunTime:0.007517s ]
SELECT `ap_id`,`meeting_id`,`title`,`address`,`filepath`,`introduce`,`meetingtime`,`livedate`,`indexpath`,`meetingtag_name`,`thumbpath` FROM `ds_v_home_meeting` WHERE 1 = 1 AND `code` = 'exhibition' AND ( `indexpath` IS NOT NULL ) ORDER BY `ap_id`,`sort` ASC,`ordermeeting` DESC,(case when ordermeeting = 2 then fromtime end) desc,(case when ordermeeting = 1 then fromtime end) asc,(case when ordermeeting = 0 then totime end) desc LIMIT 6 [ RunTime:0.009501s ]
SELECT `ap_id`,`meeting_id`,`title`,`address`,`filepath`,`introduce`,`meetingtime`,`livedate`,`indexpath`,`meetingtag_name`,`thumbpath` FROM `ds_v_home_meeting` WHERE ( `code` = 'activity' AND `tag_type` = 0 AND `meetingtag_name` = '广告' AND `ordermeeting` = 2 AND ( `indexpath` IS NOT NULL ) ) ORDER BY `ordermeeting` DESC,(case when ordermeeting = 2 then fromtime end) desc,(case when ordermeeting = 1 then fromtime end) asc,(case when ordermeeting = 0 then totime end) desc LIMIT 6 [ RunTime:0.001571s ]
SELECT `ap_id`,`meeting_id`,`title`,`address`,`filepath`,`introduce`,`meetingtime`,`livedate`,`indexpath`,`meetingtag_name`,`thumbpath` FROM `ds_v_home_meeting` WHERE 1 = 1 AND `code` = 'activity' AND ( `indexpath` IS NOT NULL ) ORDER BY `ordermeeting` DESC,(case when ordermeeting = 2 then fromtime end) desc,(case when ordermeeting = 1 then fromtime end) asc,(case when ordermeeting = 0 then totime end) desc LIMIT 6 [ RunTime:0.002326s ]
SELECT `v`.`ap_id`,`v`.`meeting_id`,`v`.`title`,`v`.`address`,`v`.`filepath`,`v`.`introduce`,`v`.`meetingtime`,`v`.`livedate`,`m`.`newpath` FROM `ds_v_home_meeting` `v` LEFT JOIN `ds_meeting` `m` ON `v`.`meeting_id`=`m`.`meeting_id` WHERE `v`.`code` = 'news' ORDER BY `v`.`recommand` DESC,`v`.`order_put_time` DESC LIMIT 8 [ RunTime:0.008723s ]
SELECT `v`.`ap_id`,`v`.`meeting_id`,`v`.`title`,`v`.`address`,`v`.`filepath`,`v`.`introduce`,`v`.`meetingtime`,`v`.`livedate`,`m`.`newpath` FROM `ds_v_home_meeting` `v` LEFT JOIN `ds_meeting` `m` ON `v`.`meeting_id`=`m`.`meeting_id` WHERE `v`.`code` = 'report' ORDER BY `v`.`recommand` DESC,`v`.`order_put_time` DESC LIMIT 8 [ RunTime:0.003223s ]
SELECT * FROM `ds_articlehelp` WHERE `ac_help_id` = 7 ORDER BY `article_sort`,`article_time` DESC LIMIT 4 [ RunTime:0.000728s ]
SELECT * FROM `ds_articlehelp` WHERE `ac_help_id` = 8 ORDER BY `article_sort`,`article_time` DESC LIMIT 4 [ RunTime:0.004865s ]
SELECT * FROM `ds_articlehelp` WHERE `ac_help_id` = 9 ORDER BY `article_sort`,`article_time` DESC LIMIT 4 [ RunTime:0.000781s ]
SELECT * FROM `ds_link` WHERE `isshow` = 0 AND `link_class` = 0 AND `show_first` = 0 LIMIT 254 [ RunTime:0.002468s ]
SELECT `ac_help_id`,`ac_code`,`ac_name`,`ac_parent_id`,`ac_sort` FROM `ds_articlehelpclass` WHERE `ac_help_id` NOT IN (7,8,9) ORDER BY ac_parent_id ASC, CASE WHEN ac_sort IS NULL THEN 1 ELSE 0 END ASC, ac_sort ASC, ac_help_id ASC [ RunTime:0.000635s ]
SELECT `articlehelp_id`,`ac_help_id`,`article_url`,`article_show`,`article_sort`,`article_title`,`article_content`,`article_time`,`article_pic` FROM `ds_articlehelp` WHERE `article_show` = 1 AND `ac_help_id` NOT IN (7,8,9) ORDER BY `article_sort` [ RunTime:0.004678s ]
SELECT * FROM `ds_config` [ RunTime:0.000825s ]
SHOW FULL COLUMNS FROM `ds_filter_keyword` [ RunTime:0.002722s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.000688s ]
SHOW FULL COLUMNS FROM `ds_adv_whitelst` [ RunTime:0.002568s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 120822 LIMIT 1 [ RunTime:0.000588s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.000755s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 89072 LIMIT 1 [ RunTime:0.000641s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.000818s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 120849 LIMIT 1 [ RunTime:0.000667s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.000701s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 110115 LIMIT 1 [ RunTime:0.000952s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.000832s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 111394 LIMIT 1 [ RunTime:0.000863s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.000772s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 118958 LIMIT 1 [ RunTime:0.000951s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.000701s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 120822 LIMIT 1 [ RunTime:0.000931s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.000660s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 120265 LIMIT 1 [ RunTime:0.000625s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.000679s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 77833 LIMIT 1 [ RunTime:0.002471s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.002614s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 110115 LIMIT 1 [ RunTime:0.000777s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.002566s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 111394 LIMIT 1 [ RunTime:0.000736s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.000634s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 118857 LIMIT 1 [ RunTime:0.001069s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.000658s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 121213 LIMIT 1 [ RunTime:0.000603s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.000667s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 77684 LIMIT 1 [ RunTime:0.000936s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.000652s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 121004 LIMIT 1 [ RunTime:0.000649s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.000753s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 120546 LIMIT 1 [ RunTime:0.000582s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.000980s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 121032 LIMIT 1 [ RunTime:0.000594s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.000913s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 114488 LIMIT 1 [ RunTime:0.000681s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.000929s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 77833 LIMIT 1 [ RunTime:0.000641s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.000928s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 119521 LIMIT 1 [ RunTime:0.000626s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.000895s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 118872 LIMIT 1 [ RunTime:0.000719s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.000899s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 120862 LIMIT 1 [ RunTime:0.000723s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.000984s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 120631 LIMIT 1 [ RunTime:0.000763s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.000970s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 120273 LIMIT 1 [ RunTime:0.000727s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.000925s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 120989 LIMIT 1 [ RunTime:0.000614s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.001115s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 78084 LIMIT 1 [ RunTime:0.000781s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.000993s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 118889 LIMIT 1 [ RunTime:0.000810s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.000768s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 101052 LIMIT 1 [ RunTime:0.000703s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.000994s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 120980 LIMIT 1 [ RunTime:0.000775s ]
SELECT `keyword` FROM `ds_filter_keyword` WHERE `type` = 'user' [ RunTime:0.000971s ]
SELECT * FROM `ds_adv_whitelst` WHERE `store_id` = 121013 LIMIT 1 [ RunTime:0.000686s ]