[ DB ] CONNECT:[ UseTime:0.000425s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `gr_help` [ RunTime:0.000612s ]
[ SQL ] SELECT * FROM `gr_help` [ RunTime:0.000224s ]
[ SQL ] SHOW COLUMNS FROM `gr_help_category` [ RunTime:0.000422s ]
[ SQL ] SELECT * FROM `gr_help_category` WHERE ( position_foot = 1 ) [ RunTime:0.000151s ]
[ DB ] CONNECT:[ UseTime:0.000283s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `gr_friend_link` [ RunTime:0.000539s ]
[ SQL ] SELECT * FROM `gr_friend_link` ORDER BY sort desc [ RunTime:0.000176s ]
[ DB ] CONNECT:[ UseTime:0.000252s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `gr_category` [ RunTime:0.000484s ]
[ SQL ] SELECT * FROM `gr_category` WHERE `id` = 55 LIMIT 1 [ RunTime:0.000241s ]
[ SQL ] SELECT * FROM `gr_category` WHERE `id` = 46 ORDER BY `sort` desc LIMIT 1 [ RunTime:0.000204s ]
[ DB ] CONNECT:[ UseTime:0.000253s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SELECT `id`,`parent_id` FROM `gr_category` [ RunTime:0.000190s ]
[ DB ] CONNECT:[ UseTime:0.000256s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SELECT `id` FROM `gr_category` WHERE `parent_id` = 55 [ RunTime:0.000278s ]
[ DB ] CONNECT:[ UseTime:0.000304s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `gr_goods` [ RunTime:0.000780s ]
[ SQL ] SELECT `id` FROM `gr_goods` WHERE `is_del` = 0 AND ( `cat_id` IN (55) OR `extend_cat_id` IN (55) ) [ RunTime:0.001382s ]
[ SQL ] SELECT `sell_price` FROM `gr_goods` WHERE `id` IN (259,337) [ RunTime:0.000252s ]
[ SQL ] SELECT `brand_id` FROM `gr_goods` WHERE `id` IN (259,337) AND `brand_id` > 0 [ RunTime:0.000256s ]
[ SQL ] SHOW COLUMNS FROM `gr_brand` [ RunTime:0.000602s ]
[ SQL ] SELECT * FROM `gr_brand` WHERE `id` IN ('') LIMIT 30 [ RunTime:0.000157s ]
[ SQL ] select group_concat(`key` separator '_') as `key` from gr_spec_goods_price where goods_id in(259,337) [ RunTime:0.000156s ]
[ SQL ] SHOW COLUMNS FROM `gr_spec` [ RunTime:0.000371s ]
[ SQL ] SELECT `id`,`name` FROM `gr_spec` WHERE `search_index` = 1 [ RunTime:0.000209s ]
[ SQL ] SHOW COLUMNS FROM `gr_spec_item` [ RunTime:0.000423s ]
[ 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.000944s ]
[ SQL ] SHOW COLUMNS FROM `gr_goods_attr` [ RunTime:0.000435s ]
[ SQL ] SELECT * FROM `gr_goods_attr` WHERE `goods_id` IN (259,337) AND `attr_value` <> '' [ RunTime:0.000206s ]
[ SQL ] SHOW COLUMNS FROM `gr_goods_attribute` [ RunTime:0.000482s ]
[ SQL ] SELECT `attr_id`,`attr_name`,`attr_index` FROM `gr_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000145s ]
[ DB ] CONNECT:[ UseTime:0.000316s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SELECT * FROM `gr_goods` WHERE `id` IN (259,337) ORDER BY sell_price asc LIMIT 0,20 [ RunTime:0.000576s ]
[ DB ] CONNECT:[ UseTime:0.000273s ] 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.000321s ]
[ DB ] CONNECT:[ UseTime:0.000281s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SELECT `id`,`name`,`parent_id` FROM `gr_category` [ RunTime:0.000207s ]
[ DB ] CONNECT:[ UseTime:0.000269s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `gr_areas` [ RunTime:0.000477s ]
[ SQL ] SELECT * FROM `gr_areas` WHERE ( parent_id = 340000 ) [ RunTime:0.000265s ]
[ DB ] CONNECT:[ UseTime:0.000288s ] 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.000285s ]
[ DB ] CONNECT:[ UseTime:0.000266s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `gr_navigation` [ RunTime:0.000432s ]
[ SQL ] SELECT * FROM `gr_navigation` WHERE ( is_show = 1 ) ORDER BY sort desc [ RunTime:0.000188s ]
[ DB ] CONNECT:[ UseTime:0.000264s ] 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.000335s ]
[ DB ] CONNECT:[ UseTime:0.000250s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `gr_goods_visit` [ RunTime:0.000418s ]
[ 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.000189s ]
[ 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.000180s ]
