SHOW FULL COLUMNS FROM `ds_cart` [ RunTime:0.002858s ]
SELECT * FROM `ds_cart` WHERE `buyer_id` IS NULL [ RunTime:0.000808s ]
SHOW FULL COLUMNS FROM `ds_adv` [ RunTime:0.002597s ]
SELECT * FROM `ds_adv` WHERE `ap_id` = 21 AND `adv_enabled` = 1 AND `adv_startdate` < 1729036800 AND `adv_enddate` > 1729036800 ORDER BY `adv_sort` ASC,`adv_id` ASC [ RunTime:0.000815s ]
SHOW FULL COLUMNS FROM `ds_v_purchase` [ RunTime:0.003074s ]
SELECT * FROM `ds_v_purchase` WHERE `buy_id` = 14538 [ RunTime:1.144669s ]
SHOW FULL COLUMNS FROM `ds_buy_data` [ RunTime:0.002623s ]
SELECT `buy_data_id`,`buy_id`,`product_name`,`num`,`purchase_unit`,`remarks` FROM `ds_buy_data` WHERE `buy_id` = 14538 [ RunTime:0.000670s ]
SHOW FULL COLUMNS FROM `ds_quotation` [ RunTime:0.002651s ]
SELECT quotation.quotation_id,date_format(from_unixtime(quotation.createtime),"%Y-%m-%d") createtime,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` = 14538 [ RunTime:0.001011s ]
SHOW FULL COLUMNS FROM `ds_goods` [ RunTime:0.002933s ]
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`.`status` = '4' AND ( ( `goods`.`goods_name` LIKE '%瓶装咖啡代工厂OEM%' OR `goods`.`goods_advword` LIKE '%瓶装咖啡代工厂OEM%' ) ) LIMIT 4 [ RunTime:0.268804s ]
SELECT * FROM `ds_v_purchase` WHERE `buy_id` <> 14538 AND ( `title` LIKE '%瓶装咖啡代工厂OEM%' ) LIMIT 4 [ RunTime:1.134609s ]
