SHOW FULL COLUMNS FROM `wewe_system_config` [ RunTime:0.001563s ]
SELECT * FROM `wewe_system_config` WHERE `is_cache` = 1 ORDER BY `config_tab_code` ASC,`list_order` ASC,`eng_name` ASC [ RunTime:0.000727s ]
SHOW FULL COLUMNS FROM `wewe_module_nav` [ RunTime:0.001144s ]
SHOW FULL COLUMNS FROM `wewe_module_nav_category` [ RunTime:0.000883s ]
SELECT `catid` FROM `wewe_module_nav_category` WHERE `code` = 'top_menu' LIMIT 1 [ RunTime:0.000489s ]
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.000409s ]
SELECT * FROM `wewe_module_nav` WHERE `status` = 1 AND `catid` = 5 ORDER BY `list_order` ASC,`id` ASC LIMIT 20 [ RunTime:0.000456s ]
SELECT `catid` FROM `wewe_module_nav_category` WHERE `code` = 'menu' LIMIT 1 [ RunTime:0.000415s ]
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.000362s ]
SELECT * FROM `wewe_module_nav` WHERE `status` = 1 AND `catid` = 3 ORDER BY `list_order` ASC,`id` ASC LIMIT 20 [ RunTime:0.000451s ]
SELECT `catid` FROM `wewe_module_nav_category` WHERE `code` = 'footer' LIMIT 1 [ RunTime:0.000379s ]
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.000355s ]
SELECT * FROM `wewe_module_nav` WHERE `status` = 1 AND `catid` = 4 ORDER BY `list_order` ASC,`id` ASC LIMIT 20 [ RunTime:0.000479s ]
SHOW FULL COLUMNS FROM `wewe_shop_goods_category` [ RunTime:0.001338s ]
SELECT * FROM `wewe_shop_goods_category` WHERE `id` = 21 LIMIT 1 [ RunTime:0.000555s ]
SHOW FULL COLUMNS FROM `wewe_shop_goods` [ RunTime:0.001489s ]
SHOW FULL COLUMNS FROM `wewe_shop_goods_brand` [ RunTime:0.000974s ]
SELECT name wewe_title,id wewe_value,id wewe_id,parent_id wewe_parent_id FROM wewe_shop_goods_category order by list_order asc,id asc [ RunTime:0.000460s ]
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`,`goodsbrand`.`id` AS `goodsbrand__id`,`goodsbrand`.`name` AS `goodsbrand__name`,`goodsbrand`.`logo_url` AS `goodsbrand__logo_url`,`goodsbrand`.`notice` AS `goodsbrand__notice`,`goodsbrand`.`website` AS `goodsbrand__website`,`goodsbrand`.`list_order` AS `goodsbrand__list_order`,`goodsbrand`.`is_hot` AS `goodsbrand__is_hot` FROM `wewe_shop_goods` `shop_goods_model` LEFT JOIN `wewe_shop_goods_category` `goodscategory` ON `shop_goods_model`.`catid`=`goodscategory`.`id` LEFT JOIN `wewe_shop_goods_brand` `goodsbrand` ON `shop_goods_model`.`goods_brand_id`=`goodsbrand`.`id` WHERE `shop_goods_model`.`is_on_sale` = '1' AND `shop_goods_model`.`catid` = '21' AND `shop_goods_model`.`is_on_sale` = '1' ORDER BY `id` DESC LIMIT 20 [ RunTime:0.001334s ]
SHOW FULL COLUMNS FROM `wewe_shop_goods_spec_goods_price` [ RunTime:0.001273s ]
SELECT `key` FROM `wewe_shop_goods_spec_goods_price` WHERE `goods_id` = 223 AND ( `key`!='' ) [ RunTime:0.000590s ]
SHOW FULL COLUMNS FROM `wewe_shop_goods_spec` [ RunTime:0.000949s ]
SELECT * FROM `wewe_shop_goods_spec` WHERE `goods_type_id` = 47 ORDER BY `list_order` ASC,`goods_spec_id` ASC [ RunTime:0.000441s ]
SHOW FULL COLUMNS FROM `wewe_shop_goods_spec_item` [ RunTime:0.000917s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_id` = 49 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000488s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_item_id` IN (328,331,330,327,321,320,318,319,317,316) AND `goods_spec_id` = 49 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000523s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_id` = 50 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000412s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_item_id` IN (328,331,330,327,321,320,318,319,317,316) AND `goods_spec_id` = 50 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000443s ]
SELECT `key` FROM `wewe_shop_goods_spec_goods_price` WHERE `goods_id` = 222 AND ( `key`!='' ) [ RunTime:0.000496s ]
SELECT * FROM `wewe_shop_goods_spec` WHERE `goods_type_id` = 42 ORDER BY `list_order` ASC,`goods_spec_id` ASC [ RunTime:0.000361s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_id` = 44 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000420s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_item_id` IN (212,301,315,210,263,211,262) AND `goods_spec_id` = 44 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000466s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_id` = 40 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000599s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_item_id` IN (212,301,315,210,263,211,262) AND `goods_spec_id` = 40 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000562s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_id` = 41 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000421s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_item_id` IN (212,301,315,210,263,211,262) AND `goods_spec_id` = 41 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000465s ]
SELECT `key` FROM `wewe_shop_goods_spec_goods_price` WHERE `goods_id` = 221 AND ( `key`!='' ) [ RunTime:0.000491s ]
SELECT * FROM `wewe_shop_goods_spec` WHERE `goods_type_id` = 42 ORDER BY `list_order` ASC,`goods_spec_id` ASC [ RunTime:0.000348s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_id` = 44 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000411s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_item_id` IN (302,305,325,324,313,311,310,314,309,308,307,306) AND `goods_spec_id` = 44 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000481s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_id` = 40 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000584s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_item_id` IN (302,305,325,324,313,311,310,314,309,308,307,306) AND `goods_spec_id` = 40 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000575s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_id` = 41 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000425s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_item_id` IN (302,305,325,324,313,311,310,314,309,308,307,306) AND `goods_spec_id` = 41 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000463s ]
SELECT `key` FROM `wewe_shop_goods_spec_goods_price` WHERE `goods_id` = 193 AND ( `key`!='' ) [ RunTime:0.000505s ]
SELECT * FROM `wewe_shop_goods_spec` WHERE `goods_type_id` = 42 ORDER BY `list_order` ASC,`goods_spec_id` ASC [ RunTime:0.000360s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_id` = 44 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000413s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_item_id` IN (204,212,241,205,206,207,199,211,201,202,323,210,242) AND `goods_spec_id` = 44 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000492s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_id` = 40 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000560s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_item_id` IN (204,212,241,205,206,207,199,211,201,202,323,210,242) AND `goods_spec_id` = 40 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000598s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_id` = 41 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000441s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_item_id` IN (204,212,241,205,206,207,199,211,201,202,323,210,242) AND `goods_spec_id` = 41 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000502s ]
SELECT `id` FROM `wewe_shop_goods` WHERE `catid` = 21 AND `is_on_sale` = 1 [ RunTime:0.000429s ]
SELECT `key` FROM `wewe_shop_goods_spec_goods_price` WHERE `goods_id` IN (193,222,221,223) AND ( `key`!='' ) [ RunTime:0.000605s ]
SELECT `goods_spec_type_id` FROM `wewe_shop_goods` WHERE `catid` = 21 AND `is_on_sale` = 1 [ RunTime:0.000411s ]
SELECT * FROM `wewe_shop_goods_spec` WHERE `goods_type_id` IN (42,47) ORDER BY `list_order` ASC,`goods_spec_id` ASC [ RunTime:0.000359s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_item_id` IN (302,305,325,328,331,330,327,321,320,318,319,324,313,311,310,314,309,308,204,212,241,205,206,207,199,211,201,202,323,210,301,315,263,242,262,307,306,317,316) AND `goods_spec_id` = 44 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000649s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_item_id` IN (302,305,325,328,331,330,327,321,320,318,319,324,313,311,310,314,309,308,204,212,241,205,206,207,199,211,201,202,323,210,301,315,263,242,262,307,306,317,316) AND `goods_spec_id` = 40 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000716s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_item_id` IN (302,305,325,328,331,330,327,321,320,318,319,324,313,311,310,314,309,308,204,212,241,205,206,207,199,211,201,202,323,210,301,315,263,242,262,307,306,317,316) AND `goods_spec_id` = 41 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000624s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_item_id` IN (302,305,325,328,331,330,327,321,320,318,319,324,313,311,310,314,309,308,204,212,241,205,206,207,199,211,201,202,323,210,301,315,263,242,262,307,306,317,316) AND `goods_spec_id` = 49 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000591s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_item_id` IN (302,305,325,328,331,330,327,321,320,318,319,324,313,311,310,314,309,308,204,212,241,205,206,207,199,211,201,202,323,210,301,315,263,242,262,307,306,317,316) AND `goods_spec_id` = 50 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000579s ]
SELECT name wewe_title,id wewe_value,id wewe_id,parent_id wewe_parent_id FROM wewe_shop_goods_category order by list_order asc,id asc [ RunTime:0.000456s ]
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`,`goodsbrand`.`id` AS `goodsbrand__id`,`goodsbrand`.`name` AS `goodsbrand__name`,`goodsbrand`.`logo_url` AS `goodsbrand__logo_url`,`goodsbrand`.`notice` AS `goodsbrand__notice`,`goodsbrand`.`website` AS `goodsbrand__website`,`goodsbrand`.`list_order` AS `goodsbrand__list_order`,`goodsbrand`.`is_hot` AS `goodsbrand__is_hot` FROM `wewe_shop_goods` `shop_goods_model` LEFT JOIN `wewe_shop_goods_category` `goodscategory` ON `shop_goods_model`.`catid`=`goodscategory`.`id` LEFT JOIN `wewe_shop_goods_brand` `goodsbrand` ON `shop_goods_model`.`goods_brand_id`=`goodsbrand`.`id` WHERE `shop_goods_model`.`is_on_sale` = '1' AND `shop_goods_model`.`catid` = '21' AND `shop_goods_model`.`is_on_sale` = '1' ORDER BY `list_order` ASC,`id` DESC LIMIT 100 [ RunTime:0.001168s ]
SELECT `key` FROM `wewe_shop_goods_spec_goods_price` WHERE `goods_id` = 222 AND ( `key`!='' ) [ RunTime:0.000495s ]
SELECT * FROM `wewe_shop_goods_spec` WHERE `goods_type_id` = 42 ORDER BY `list_order` ASC,`goods_spec_id` ASC [ RunTime:0.000359s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_id` = 44 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000420s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_item_id` IN (212,301,315,210,263,211,262) AND `goods_spec_id` = 44 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000478s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_id` = 40 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000582s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_item_id` IN (212,301,315,210,263,211,262) AND `goods_spec_id` = 40 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000546s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_id` = 41 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000417s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_item_id` IN (212,301,315,210,263,211,262) AND `goods_spec_id` = 41 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000444s ]
SELECT `key` FROM `wewe_shop_goods_spec_goods_price` WHERE `goods_id` = 193 AND ( `key`!='' ) [ RunTime:0.000483s ]
SELECT * FROM `wewe_shop_goods_spec` WHERE `goods_type_id` = 42 ORDER BY `list_order` ASC,`goods_spec_id` ASC [ RunTime:0.000339s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_id` = 44 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000397s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_item_id` IN (204,212,241,205,206,207,199,211,201,202,323,210,242) AND `goods_spec_id` = 44 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000452s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_id` = 40 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000547s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_item_id` IN (204,212,241,205,206,207,199,211,201,202,323,210,242) AND `goods_spec_id` = 40 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000547s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_id` = 41 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000395s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_item_id` IN (204,212,241,205,206,207,199,211,201,202,323,210,242) AND `goods_spec_id` = 41 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000446s ]
SELECT `key` FROM `wewe_shop_goods_spec_goods_price` WHERE `goods_id` = 221 AND ( `key`!='' ) [ RunTime:0.000452s ]
SELECT * FROM `wewe_shop_goods_spec` WHERE `goods_type_id` = 42 ORDER BY `list_order` ASC,`goods_spec_id` ASC [ RunTime:0.000336s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_id` = 44 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000390s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_item_id` IN (302,305,325,324,313,311,310,314,309,308,307,306) AND `goods_spec_id` = 44 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000435s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_id` = 40 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000490s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_item_id` IN (302,305,325,324,313,311,310,314,309,308,307,306) AND `goods_spec_id` = 40 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000520s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_id` = 41 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000663s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_item_id` IN (302,305,325,324,313,311,310,314,309,308,307,306) AND `goods_spec_id` = 41 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000423s ]
SELECT `key` FROM `wewe_shop_goods_spec_goods_price` WHERE `goods_id` = 223 AND ( `key`!='' ) [ RunTime:0.000438s ]
SELECT * FROM `wewe_shop_goods_spec` WHERE `goods_type_id` = 47 ORDER BY `list_order` ASC,`goods_spec_id` ASC [ RunTime:0.000337s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_id` = 49 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000359s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_item_id` IN (328,331,330,327,321,320,318,319,317,316) AND `goods_spec_id` = 49 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000408s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_id` = 50 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000350s ]
SELECT * FROM `wewe_shop_goods_spec_item` WHERE `goods_spec_item_id` IN (328,331,330,327,321,320,318,319,317,316) AND `goods_spec_id` = 50 ORDER BY `list_order` ASC,`goods_spec_item_id` ASC [ RunTime:0.000392s ]
SELECT name wewe_title,id wewe_value,id wewe_id,parent_id wewe_parent_id FROM wewe_shop_goods_category order by list_order asc,id asc [ RunTime:0.000352s ]
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`,`goodsbrand`.`id` AS `goodsbrand__id`,`goodsbrand`.`name` AS `goodsbrand__name`,`goodsbrand`.`logo_url` AS `goodsbrand__logo_url`,`goodsbrand`.`notice` AS `goodsbrand__notice`,`goodsbrand`.`website` AS `goodsbrand__website`,`goodsbrand`.`list_order` AS `goodsbrand__list_order`,`goodsbrand`.`is_hot` AS `goodsbrand__is_hot` FROM `wewe_shop_goods` `shop_goods_model` LEFT JOIN `wewe_shop_goods_category` `goodscategory` ON `shop_goods_model`.`catid`=`goodscategory`.`id` LEFT JOIN `wewe_shop_goods_brand` `goodsbrand` ON `shop_goods_model`.`goods_brand_id`=`goodsbrand`.`id` WHERE `shop_goods_model`.`is_on_sale` = '1' AND `shop_goods_model`.`catid` = '20' AND `shop_goods_model`.`is_on_sale` = '1' ORDER BY `id` DESC LIMIT 20 [ RunTime:0.000894s ]