[ DB ] CONNECT:[ UseTime:0.000454s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `gr_help` [ RunTime:0.000629s ]
[ SQL ] SELECT * FROM `gr_help` [ RunTime:0.000248s ]
[ SQL ] SHOW COLUMNS FROM `gr_help_category` [ RunTime:0.000451s ]
[ SQL ] SELECT * FROM `gr_help_category` WHERE ( position_foot = 1 ) [ RunTime:0.000166s ]
[ DB ] CONNECT:[ UseTime:0.000293s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `gr_friend_link` [ RunTime:0.000594s ]
[ SQL ] SELECT * FROM `gr_friend_link` ORDER BY sort desc [ RunTime:0.000180s ]
[ DB ] CONNECT:[ UseTime:0.000272s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `gr_category` [ RunTime:0.000492s ]
[ SQL ] SELECT * FROM `gr_category` WHERE `id` = 33 LIMIT 1 [ RunTime:0.000235s ]
[ DB ] CONNECT:[ UseTime:0.000263s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SELECT `id`,`parent_id` FROM `gr_category` [ RunTime:0.000205s ]
[ DB ] CONNECT:[ UseTime:0.000243s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SELECT `id` FROM `gr_category` WHERE `parent_id` = 33 [ RunTime:0.000172s ]
[ DB ] CONNECT:[ UseTime:0.000261s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `gr_goods` [ RunTime:0.000739s ]
[ SQL ] SELECT `id` FROM `gr_goods` WHERE `is_del` = 0 AND ( `cat_id` IN (33) OR `extend_cat_id` IN (33) ) [ RunTime:0.001299s ]
[ SQL ] SELECT `sell_price` FROM `gr_goods` WHERE `id` IN (40,311,375) [ RunTime:0.000257s ]
[ SQL ] SELECT `brand_id` FROM `gr_goods` WHERE `id` IN (40,311,375) AND `brand_id` > 0 [ RunTime:0.000613s ]
[ SQL ] SHOW COLUMNS FROM `gr_brand` [ RunTime:0.000450s ]
[ SQL ] SELECT * FROM `gr_brand` WHERE `id` IN ('') LIMIT 30 [ RunTime:0.000155s ]
[ SQL ] select group_concat(`key` separator '_') as `key` from gr_spec_goods_price where goods_id in(40,311,375) [ RunTime:0.000606s ]
[ SQL ] SHOW COLUMNS FROM `gr_spec` [ RunTime:0.000652s ]
[ SQL ] SELECT `id`,`name` FROM `gr_spec` WHERE `search_index` = 1 [ RunTime:0.000284s ]
[ SQL ] SHOW COLUMNS FROM `gr_spec_item` [ RunTime:0.000392s ]
[ SQL ] SELECT `id`,`spec_id`,`item` FROM `gr_spec_item` WHERE `spec_id` IN (4,5,252,10,251,250,15,16,18,19,20,22,23,24,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,249,56,60,61,248,247,99,104,105,106,107,108,246,110,111,112,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,135,136,137,138,139,140,141,142,244,145,245,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,176,177,178,180,181,182,183,184,185,186,187,188,189,190,191,192,194,255,196,197,198,199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,232,233,234,235,236,237,238,239,240,241,242,253,254) [ RunTime:0.000839s ]
[ SQL ] SHOW COLUMNS FROM `gr_goods_attr` [ RunTime:0.000466s ]
[ SQL ] SELECT * FROM `gr_goods_attr` WHERE `goods_id` IN (40,311,375) AND `attr_value` <> '' [ RunTime:0.000259s ]
[ SQL ] SHOW COLUMNS FROM `gr_goods_attribute` [ RunTime:0.000467s ]
[ SQL ] SELECT `attr_id`,`attr_name`,`attr_index` FROM `gr_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000164s ]
[ DB ] CONNECT:[ UseTime:0.000331s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SELECT * FROM `gr_goods` WHERE `id` IN (40,311,375) ORDER BY sell_price asc LIMIT 0,20 [ RunTime:0.000539s ]
[ DB ] CONNECT:[ UseTime:0.000257s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SELECT * FROM `gr_goods` WHERE ( is_del = 0 And is_recommend = 1 ) ORDER BY up_time desc LIMIT 4 [ RunTime:0.000310s ]
[ DB ] CONNECT:[ UseTime:0.000258s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SELECT `id`,`name`,`parent_id` FROM `gr_category` [ RunTime:0.000206s ]
[ DB ] CONNECT:[ UseTime:0.000279s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `gr_areas` [ RunTime:0.000444s ]
[ SQL ] SELECT * FROM `gr_areas` WHERE ( parent_id = 340000 ) [ RunTime:0.000179s ]
[ DB ] CONNECT:[ UseTime:0.000259s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SELECT * FROM `gr_category` WHERE ( visibility=1 ) ORDER BY parent_id ASC [ RunTime:0.000282s ]
[ DB ] CONNECT:[ UseTime:0.000288s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `gr_navigation` [ RunTime:0.000440s ]
[ SQL ] SELECT * FROM `gr_navigation` WHERE ( is_show = 1 ) ORDER BY sort desc [ RunTime:0.000184s ]
[ DB ] CONNECT:[ UseTime:0.000258s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SELECT * FROM `gr_goods` WHERE ( is_del = 0 And is_hot = 1 ) ORDER BY id desc LIMIT 5 [ RunTime:0.000531s ]
[ DB ] CONNECT:[ UseTime:0.000253s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `gr_goods_visit` [ RunTime:0.000447s ]
[ SQL ] SELECT COUNT(`goods_id`) as c,`goods_id` FROM `gr_goods_visit` GROUP BY `goods_id` ORDER BY c desc LIMIT 20 [ RunTime:0.000173s ]
[ SQL ] SELECT `id`,`name`,`title`,`sell_price`,`market_price`,`img`,`sale` FROM `gr_goods` WHERE ( is_del = 0 And id IN (464,751,303,281,203,302,413,345,304,458,399,269,338,459,273,4,63,348,271,462) ) ORDER BY id desc LIMIT 18 [ RunTime:0.000189s ]