[ DB ] CONNECT:[ UseTime:0.010027s ] mysql:host=47.103.157.131;port=3306;dbname=shop_news;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tp_goods_category` [ RunTime:0.007520s ]
[ SQL ] SELECT `define_url`,`id` FROM `tp_goods_category` WHERE ( define_url is not null ) [ RunTime:0.006833s ]
[ SQL ] SHOW COLUMNS FROM `tp_goods` [ RunTime:0.007698s ]
[ SQL ] SELECT `define_url`,`goods_id` FROM `tp_goods` WHERE ( define_url is not null ) [ RunTime:0.011641s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=237 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006718s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=245 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006763s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=250 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006694s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=260 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006715s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=261 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006691s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=233 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006651s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=235 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006705s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=236 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006637s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=238 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006708s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=239 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006749s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=234 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006838s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=240 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006660s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=199 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006714s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=244 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006733s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=198 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.007085s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=243 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006672s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=215 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006734s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=216 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006755s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=273 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006733s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=274 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006649s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=255 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006678s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=242 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006682s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=257 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006833s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=157 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006919s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=230 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006771s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=136 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.007022s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=147 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006911s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=262 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006880s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=252 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006718s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=272 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006754s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=189 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006881s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=133 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006913s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=180 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.007074s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=196 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006881s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=141 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006791s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=142 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006771s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=152 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006781s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=225 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006848s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=266 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006770s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=263 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006796s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=229 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.007144s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=217 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.007009s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=267 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006739s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=268 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.007008s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=158 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006747s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=271 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006764s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=253 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006733s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=211 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006904s ]
[ SQL ] SELECT `goods_id`,`goods_sn`,`goods_name`,`shop_price`,`original_img`,`goods_icon`,`good_shorttitle`,`define_url` FROM `tp_goods` WHERE ( is_on_sale=1 and is_nav=1 and cat_id=170 ) ORDER BY sort asc,virtual_sales_sum desc LIMIT 5 [ RunTime:0.006976s ]
[ SQL ] SELECT * FROM `tp_goods_category` WHERE `id` = 260 LIMIT 1 [ RunTime:0.006686s ]
[ SQL ] SELECT `goods_id` FROM `tp_goods` WHERE ( shop_price >= 2400 and shop_price <= 3000 ) [ RunTime:0.011494s ]
[ SQL ] select * from (select *,concat('_',`key`,'_') as key2 from tp_spec_goods_price as a) b where 1=1 and ( key2 like '%\_440\_%' ) [ RunTime:0.009243s ]
[ SQL ] SHOW COLUMNS FROM `tp_spec` [ RunTime:0.007603s ]
[ SQL ] SELECT `id`,`name` FROM `tp_spec` [ RunTime:0.007151s ]
[ SQL ] SHOW COLUMNS FROM `tp_spec_item` [ RunTime:0.007510s ]
[ SQL ] SELECT `id`,`item` FROM `tp_spec_item` [ RunTime:0.010390s ]
[ SQL ] SELECT `brand_id` FROM `tp_goods` WHERE `goods_id` IN (568) AND `brand_id` > 0 [ RunTime:0.006714s ]
[ SQL ] SHOW COLUMNS FROM `tp_brand` [ RunTime:0.007492s ]
[ SQL ] SELECT * FROM `tp_brand` WHERE `id` IN ('') LIMIT 30 [ RunTime:0.006708s ]
[ SQL ] select group_concat(`key` separator '_') as `key` from tp_spec_goods_price where goods_id in(568) [ RunTime:0.008550s ]
[ SQL ] SELECT `id`,`name` FROM `tp_spec` WHERE `search_index` = 1 [ RunTime:0.006901s ]
[ SQL ] SELECT `id`,`spec_id`,`item` FROM `tp_spec_item` WHERE `spec_id` IN (1,2,3,4,5,85,25,26,14,15,16,17,18,19,22,21,48,29,30,31,32,33,34,36,37,38,39,40,41,42,43,84,45,46,47,49,50,51,52,53,54,55,56,64,59,60,61,63,65,66,67,68,69,70,71,72,73,79,75,76,77,80,81,82,83,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,113,114,115,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,135,136,137,138,139,140,141,142,143,144,145,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163) [ RunTime:0.010533s ]
[ SQL ] SHOW COLUMNS FROM `tp_goods_attr` [ RunTime:0.007406s ]
[ SQL ] SELECT * FROM `tp_goods_attr` WHERE `goods_id` IN (568) AND `attr_value` <> '' [ RunTime:0.006816s ]
[ SQL ] SHOW COLUMNS FROM `tp_goods_attribute` [ RunTime:0.007360s ]
[ SQL ] SELECT `attr_id`,`attr_name`,`attr_index` FROM `tp_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.006782s ]
[ SQL ] SELECT * FROM `tp_goods` WHERE `goods_id` IN (568) ORDER BY `sort` asc LIMIT 0,20 [ RunTime:0.006901s ]
[ SQL ] SHOW COLUMNS FROM `tp_config` [ RunTime:0.007453s ]
[ SQL ] SELECT `name`,`value` FROM `tp_config` WHERE `name` IN ('oss_key_id','oss_key_secret','oss_endpoint','oss_bucket') [ RunTime:0.007138s ]
[ SQL ] SHOW COLUMNS FROM `tp_spec_goods_price` [ RunTime:0.007644s ]
[ SQL ] SELECT * FROM `tp_spec_goods_price` WHERE `goods_id` = 568 ORDER BY `item_id` [ RunTime:0.008697s ]
