SHOW FULL COLUMNS FROM `wewe_system_config` [ RunTime:0.001150s ]
SELECT * FROM `wewe_system_config` WHERE `is_cache` = 1 ORDER BY `config_tab_code` ASC,`list_order` ASC,`eng_name` ASC [ RunTime:0.000635s ]
SHOW FULL COLUMNS FROM `wewe_module_nav` [ RunTime:0.000971s ]
SHOW FULL COLUMNS FROM `wewe_module_nav_category` [ RunTime:0.000872s ]
SELECT `catid` FROM `wewe_module_nav_category` WHERE `code` = 'top_menu' LIMIT 1 [ RunTime:0.000432s ]
SELECT name wewe_title,catid wewe_value,catid wewe_id,parent_id wewe_parent_id FROM wewe_module_nav_category order by list_order asc,catid asc [ RunTime:0.000385s ]
SELECT * FROM `wewe_module_nav` WHERE `status` = 1 AND `catid` = 5 ORDER BY `list_order` ASC,`id` ASC LIMIT 20 [ RunTime:0.000471s ]
SELECT `catid` FROM `wewe_module_nav_category` WHERE `code` = 'menu' LIMIT 1 [ RunTime:0.000389s ]
SELECT name wewe_title,catid wewe_value,catid wewe_id,parent_id wewe_parent_id FROM wewe_module_nav_category order by list_order asc,catid asc [ RunTime:0.000370s ]
SELECT * FROM `wewe_module_nav` WHERE `status` = 1 AND `catid` = 3 ORDER BY `list_order` ASC,`id` ASC LIMIT 20 [ RunTime:0.000481s ]
SELECT `catid` FROM `wewe_module_nav_category` WHERE `code` = 'footer' LIMIT 1 [ RunTime:0.000381s ]
SELECT name wewe_title,catid wewe_value,catid wewe_id,parent_id wewe_parent_id FROM wewe_module_nav_category order by list_order asc,catid asc [ RunTime:0.000356s ]
SELECT * FROM `wewe_module_nav` WHERE `status` = 1 AND `catid` = 4 ORDER BY `list_order` ASC,`id` ASC LIMIT 20 [ RunTime:0.000512s ]
SHOW FULL COLUMNS FROM `wewe_shop_goods` [ RunTime:0.001469s ]
SELECT * FROM `wewe_shop_goods` WHERE `id` = 190 AND `is_out_of_stock` = 1 LIMIT 1 [ RunTime:0.000734s ]
SHOW FULL COLUMNS FROM `wewe_shop_goods_category` [ RunTime:0.001077s ]
SELECT `shop_goods_model`.`id`,`shop_goods_model`.`catid`,`shop_goods_model`.`goods_sn`,`shop_goods_model`.`goods_name`,`shop_goods_model`.`click_count`,`shop_goods_model`.`goods_brand_id`,`shop_goods_model`.`stock_num`,`shop_goods_model`.`comment_count`,`shop_goods_model`.`weight`,`shop_goods_model`.`market_price`,`shop_goods_model`.`shop_price`,`shop_goods_model`.`cost_price`,`shop_goods_model`.`is_promote`,`shop_goods_model`.`promote_price`,`shop_goods_model`.`promote_start_time`,`shop_goods_model`.`promote_end_time`,`shop_goods_model`.`keywords`,`shop_goods_model`.`goods_remark`,`shop_goods_model`.`goods_content`,`shop_goods_model`.`img_url`,`shop_goods_model`.`photo_album`,`shop_goods_model`.`is_real`,`shop_goods_model`.`is_on_sale`,`shop_goods_model`.`is_free_shipping`,`shop_goods_model`.`on_time`,`shop_goods_model`.`list_order`,`shop_goods_model`.`is_recommend`,`shop_goods_model`.`is_new`,`shop_goods_model`.`is_hot`,`shop_goods_model`.`last_update`,`shop_goods_model`.`goods_type_id`,`shop_goods_model`.`goods_spec_type_id`,`shop_goods_model`.`goods_spec_selected_key`,`shop_goods_model`.`give_integral`,`shop_goods_model`.`sales_sum`,`shop_goods_model`.`oa_goods_id`,`shop_goods_model`.`creditcart_name`,`shop_goods_model`.`yahoo_url`,`shop_goods_model`.`amazon_url`,`shop_goods_model`.`tax`,`shop_goods_model`.`hand_price`,`shop_goods_model`.`hand_price_is_mult`,`shop_goods_model`.`ship_price`,`shop_goods_model`.`youhui_price`,`shop_goods_model`.`youhui_price_notice`,`shop_goods_model`.`oa_order_mtype`,`shop_goods_model`.`is_out_of_stock`,`goodscategory`.`id` AS `goodscategory__id`,`goodscategory`.`parent_id` AS `goodscategory__parent_id`,`goodscategory`.`name` AS `goodscategory__name`,`goodscategory`.`mobile_name` AS `goodscategory__mobile_name`,`goodscategory`.`code` AS `goodscategory__code`,`goodscategory`.`img_url` AS `goodscategory__img_url`,`goodscategory`.`seo_keywords` AS `goodscategory__seo_keywords`,`goodscategory`.`seo_description` AS `goodscategory__seo_description`,`goodscategory`.`contents` AS `goodscategory__contents`,`goodscategory`.`tax` AS `goodscategory__tax`,`goodscategory`.`list_tplname` AS `goodscategory__list_tplname`,`goodscategory`.`detail_tplname` AS `goodscategory__detail_tplname`,`goodscategory`.`list_order` AS `goodscategory__list_order`,`goodscategory`.`is_hot` AS `goodscategory__is_hot`,`goodscategory`.`status` AS `goodscategory__status`,`goodscategory`.`oa_order_mtype` AS `goodscategory__oa_order_mtype` FROM `wewe_shop_goods` `shop_goods_model` LEFT JOIN `wewe_shop_goods_category` `goodscategory` ON `shop_goods_model`.`catid`=`goodscategory`.`id` WHERE `shop_goods_model`.`id` = '190' [ RunTime:0.000932s ]
SHOW FULL COLUMNS FROM `wewe_shop_goods_spec_goods_price` [ RunTime:0.001024s ]
SELECT * FROM `wewe_shop_goods_spec_goods_price` WHERE `goods_id` = 190 AND `key` = '191' LIMIT 1 [ RunTime:0.000501s ]
SELECT `catid` FROM `wewe_shop_goods` WHERE `id` = 190 [ RunTime:0.000353s ]
SHOW FULL COLUMNS FROM `wewe_shop_shipping` [ RunTime:0.000979s ]
SELECT ship.*,if(isnull(cate.shipping_desc) or cate.shipping_desc='',ship.shipping_desc,cate.shipping_desc) as shipping_desc FROM `wewe_shop_shipping` `ship` LEFT JOIN `wewe_shop_shipping_goods_cate` `cate` ON `cate`.`shipping_id`=`ship`.`id` WHERE `cate`.`goods_catid` = '7' ORDER BY `cate`.`list_order` ASC,`cate`.`id` ASC [ RunTime:0.000743s ]
SELECT `catid` FROM `wewe_shop_goods` WHERE `id` = 190 [ RunTime:0.000354s ]
SHOW FULL COLUMNS FROM `wewe_shop_payment` [ RunTime:0.001103s ]
SELECT pay.*,
if(isnull(cate.buy_info_content) or cate.buy_info_content='',pay.buy_info_content,cate.buy_info_content) as buy_info_content,
if(isnull(cate.buy_payment_content) or cate.buy_payment_content='',pay.buy_payment_content,cate.buy_payment_content) as buy_payment_content,
if(isnull(cate.pay_info_content) or cate.pay_info_content='',pay.pay_info_content,cate.pay_info_content) as pay_info_content,
if(isnull(cate.pay_payment_content) or cate.pay_payment_content='',pay.pay_payment_content,cate.pay_payment_content) as pay_payment_content,
if(isnull(cate.payok_info_content) or cate.payok_info_content='',pay.payok_info_content,cate.payok_info_content) as payok_info_content,
if(isnull(cate.payok_payment_content) or cate.payok_payment_content='',pay.payok_payment_content,cate.payok_payment_content) as payok_payment_content,
if(isnull(cate.ok_info_content) or cate.ok_info_content='',pay.ok_info_content,cate.ok_info_content) as ok_info_content,
if(isnull(cate.ok_payment_content) or cate.ok_payment_content='',pay.ok_payment_content,cate.ok_payment_content) as ok_payment_content,
if(isnull(cate.email_info_content) or cate.email_info_content='',pay.email_info_content,cate.email_info_content) as email_info_content,
if(isnull(cate.email_payment_content) or cate.email_payment_content='',pay.email_payment_content,cate.email_payment_content) as email_payment_content
FROM `wewe_shop_payment` `pay` LEFT JOIN `wewe_shop_payment_goods_cate` `cate` ON `cate`.`payment_id`=`pay`.`id` WHERE `cate`.`goods_catid` = '7' ORDER BY `cate`.`list_order` ASC,`cate`.`id` ASC [ RunTime:0.001331s ]
SHOW FULL COLUMNS FROM `wewe_shop_payment_log` [ RunTime:0.001024s ]