SHOW FULL COLUMNS FROM `ds_cart` [ RunTime:0.002768s ]
SELECT * FROM `ds_cart` WHERE `buyer_id` IS NULL [ RunTime:0.000741s ]
SHOW FULL COLUMNS FROM `ds_adv` [ RunTime:0.002701s ]
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` < 1728547200 AND `adv_enddate` > 1728547200 ORDER BY `adv_sort` ASC,`adv_id` ASC [ RunTime:0.000869s ]
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` < 1728547200 AND `adv_enddate` > 1728547200 ORDER BY `adv_sort` ASC,`adv_id` ASC [ RunTime:0.002580s ]
SHOW FULL COLUMNS FROM `ds_search_adv` [ RunTime:0.000920s ]
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` < 1728547200 AND `adv_enddate` > 1728547200 ORDER BY `adv_id` DESC [ RunTime:0.002472s ]
SHOW FULL COLUMNS FROM `ds_applet` [ RunTime:0.000775s ]
SELECT `app_state` FROM `ds_applet` WHERE `member_id` IS NULL LIMIT 1 [ RunTime:0.002380s ]
SHOW FULL COLUMNS FROM `ds_articlehelpclass` [ RunTime:0.000751s ]
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.002568s ]
SHOW FULL COLUMNS FROM `ds_articlehelp` [ RunTime:0.000748s ]
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.008177s ]
SHOW FULL COLUMNS FROM `ds_link` [ RunTime:0.000867s ]
SELECT * FROM `ds_link` ORDER BY IF(link_sort IS NULL, 1, 0) asc, link_sort asc [ RunTime:0.002545s ]
SHOW FULL COLUMNS FROM `ds_config` [ RunTime:0.000805s ]
SELECT * FROM `ds_config` [ RunTime:0.002544s ]
SHOW FULL COLUMNS FROM `ds_v_purchase` [ RunTime:0.001232s ]
SELECT * FROM `ds_v_purchase` WHERE `buy_id` = 13749 [ RunTime:1.136309s ]
SHOW FULL COLUMNS FROM `ds_buy_data` [ RunTime:0.002696s ]
SELECT `buy_data_id`,`buy_id`,`product_name`,`num`,`purchase_unit`,`remarks`,cls1.gc_name cls1name,cls2.gc_name cls2name,cls3.gc_name cls3name FROM `ds_buy_data` LEFT JOIN `ds_goodsclass` `cls1` ON `ds_buy_data`.`class_1`=`cls1`.`gc_id` LEFT JOIN `ds_goodsclass` `cls2` ON `ds_buy_data`.`class_2`=`cls2`.`gc_id` LEFT JOIN `ds_goodsclass` `cls3` ON `ds_buy_data`.`class_3`=`cls3`.`gc_id` WHERE `buy_id` = 13749 [ RunTime:0.000807s ]
SHOW FULL COLUMNS FROM `ds_quotation` [ RunTime:0.002675s ]
SELECT quotation.quotation_id,date_format(from_unixtime(quotation.createtime),"%Y-%m-%d") createtime,quotation.status,company.shopname,company.company_address FROM `ds_quotation` `quotation` LEFT JOIN `ds_seller` `seller` ON `quotation`.`supplier_id`=`seller`.`member_id` LEFT JOIN `ds_company_introduction` `company` ON `seller`.`store_id`=`company`.`store_id` WHERE `buy_id` = 13749 [ RunTime:0.000841s ]
SHOW FULL COLUMNS FROM `ds_goods` [ RunTime:0.002994s ]
SELECT `goods`.`goods_id`,`goods`.`store_id`,`goods`.`goods_name`,`goods`.`goods_image`,`company`.`shopname` FROM `ds_goods` `goods` LEFT JOIN `ds_company_introduction` `company` ON `goods`.`store_id`=`company`.`store_id` WHERE `goods`.`state` <> '2' AND `goods`.`goods_state` = '1' AND `goods`.`goods_verify` = '1' AND ( `goods`.`goods_name` LIKE '%重瓣红玫瑰花粉%' ) LIMIT 4 [ RunTime:0.137154s ]
SELECT * FROM `ds_v_purchase` WHERE `buy_id` <> 13749 AND ( `title` LIKE '%重瓣红玫瑰花粉%' ) LIMIT 4 [ RunTime:1.185589s ]
SHOW FULL COLUMNS FROM `ds_member` [ RunTime:0.001255s ]
SELECT * FROM `ds_member` WHERE `member_id` = 136698 AND `member_logic` IS NULL LIMIT 1 [ RunTime:0.000975s ]
SELECT `img_thumb_one`,`img_thumb_two`,`img_thumb_three` FROM `ds_goods` WHERE `goods_id` = 82471 LIMIT 1 [ RunTime:0.002408s ]
SELECT `img_thumb_one`,`img_thumb_two`,`img_thumb_three` FROM `ds_goods` WHERE `goods_id` = 99138 LIMIT 1 [ RunTime:0.000630s ]
SELECT `img_thumb_one`,`img_thumb_two`,`img_thumb_three` FROM `ds_goods` WHERE `goods_id` = 99139 LIMIT 1 [ RunTime:0.002334s ]
SELECT `img_thumb_one`,`img_thumb_two`,`img_thumb_three` FROM `ds_goods` WHERE `goods_id` = 99140 LIMIT 1 [ RunTime:0.000658s ]
*0315
沪公网安备 31010402000558号
