[ DB ] CONNECT:[ UseTime:0.000418s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `gr_help` [ RunTime:0.000705s ]
[ SQL ] SELECT * FROM `gr_help` [ RunTime:0.000229s ]
[ SQL ] SHOW COLUMNS FROM `gr_help_category` [ RunTime:0.000462s ]
[ SQL ] SELECT * FROM `gr_help_category` WHERE ( position_foot = 1 ) [ RunTime:0.000199s ]
[ DB ] CONNECT:[ UseTime:0.000335s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `gr_friend_link` [ RunTime:0.000489s ]
[ SQL ] SELECT * FROM `gr_friend_link` ORDER BY sort desc [ RunTime:0.000199s ]
[ DB ] CONNECT:[ UseTime:0.000274s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `gr_category` [ RunTime:0.000537s ]
[ SQL ] SELECT `id` FROM `gr_category` WHERE ( name LIKE '%空调%' And visibility = 0 ) [ RunTime:0.000177s ]
[ DB ] CONNECT:[ UseTime:0.000267s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SELECT `id` FROM `gr_category` WHERE ( name LIKE '%空调%' And visibility = 0 ) [ RunTime:0.000170s ]
[ DB ] CONNECT:[ UseTime:0.000243s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `gr_goods` [ RunTime:0.000691s ]
[ SQL ] SELECT `id` FROM `gr_goods` WHERE `is_del` = 0 AND `cat_id` IN (0) [ RunTime:0.001309s ]
[ DB ] CONNECT:[ UseTime:0.000247s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SELECT `id` FROM `gr_goods` WHERE ( name LIKE '%空调%' And is_del =0 ) [ RunTime:0.001326s ]
[ SQL ] SELECT `sell_price` FROM `gr_goods` WHERE `id` IN (4,55,113,192,203,269,271,273,300,301,302,304,370,372,419,420,439,440,445,455,743,745,747) [ RunTime:0.000477s ]
[ SQL ] SELECT `brand_id` FROM `gr_goods` WHERE `id` IN (4,55,113,192,203,269,271,273,300,301,302,304,370,372,419,420,439,440,445,455,743,745,747) AND `brand_id` > 0 [ RunTime:0.000428s ]
[ SQL ] SHOW COLUMNS FROM `gr_brand` [ RunTime:0.000447s ]
[ SQL ] SELECT * FROM `gr_brand` WHERE `id` IN (1,1) LIMIT 30 [ RunTime:0.000254s ]
[ SQL ] select group_concat(`key` separator '_') as `key` from gr_spec_goods_price where goods_id in(4,55,113,192,203,269,271,273,300,301,302,304,370,372,419,420,439,440,445,455,743,745,747) [ RunTime:0.000170s ]
[ SQL ] SHOW COLUMNS FROM `gr_spec` [ RunTime:0.000420s ]
[ SQL ] SELECT `id`,`name` FROM `gr_spec` WHERE `search_index` = 1 [ RunTime:0.000207s ]
[ SQL ] SHOW COLUMNS FROM `gr_spec_item` [ RunTime:0.000382s ]
[ 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.000809s ]
[ SQL ] SHOW COLUMNS FROM `gr_goods_attr` [ RunTime:0.000449s ]
[ SQL ] SELECT * FROM `gr_goods_attr` WHERE `goods_id` IN (4,55,113,192,203,269,271,273,300,301,302,304,370,372,419,420,439,440,445,455,743,745,747) AND `attr_value` <> '' [ RunTime:0.000259s ]
[ SQL ] SHOW COLUMNS FROM `gr_goods_attribute` [ RunTime:0.000425s ]
[ SQL ] SELECT `attr_id`,`attr_name`,`attr_index` FROM `gr_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000130s ]
[ DB ] CONNECT:[ UseTime:0.000295s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SELECT * FROM `gr_goods` WHERE `id` IN (4,55,113,192,203,269,271,273,300,301,302,304,370,372,419,420,439,440,445,455,743,745,747) ORDER BY id asc LIMIT 0,12 [ RunTime:0.000634s ]
[ DB ] CONNECT:[ UseTime:0.000266s ] 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.001472s ]
[ DB ] CONNECT:[ UseTime:0.000246s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SELECT `id`,`name`,`parent_id` FROM `gr_category` [ RunTime:0.000224s ]
[ DB ] CONNECT:[ UseTime:0.000248s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `gr_areas` [ RunTime:0.000435s ]
[ SQL ] SELECT * FROM `gr_areas` WHERE ( parent_id = 340000 ) [ RunTime:0.000185s ]
[ DB ] CONNECT:[ UseTime:0.000263s ] 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.000307s ]
[ DB ] CONNECT:[ UseTime:0.000255s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `gr_navigation` [ RunTime:0.000438s ]
[ SQL ] SELECT * FROM `gr_navigation` WHERE ( is_show = 1 ) ORDER BY sort desc [ RunTime:0.000197s ]
[ DB ] CONNECT:[ UseTime:0.000245s ] 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.001455s ]
[ DB ] CONNECT:[ UseTime:0.000260s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `gr_goods_visit` [ RunTime:0.000464s ]
[ 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,273,459,4,63,348,271,462) ) ORDER BY id desc LIMIT 18 [ RunTime:0.000409s ]
