[ DB ] CONNECT:[ UseTime:0.000448s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `gr_help` [ RunTime:0.000627s ]
[ SQL ] SELECT * FROM `gr_help` [ RunTime:0.000268s ]
[ SQL ] SHOW COLUMNS FROM `gr_help_category` [ RunTime:0.000396s ]
[ SQL ] SELECT * FROM `gr_help_category` WHERE ( position_foot = 1 ) [ RunTime:0.000150s ]
[ DB ] CONNECT:[ UseTime:0.000290s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `gr_friend_link` [ RunTime:0.000517s ]
[ SQL ] SELECT * FROM `gr_friend_link` ORDER BY sort desc [ RunTime:0.000206s ]
[ DB ] CONNECT:[ UseTime:0.000270s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `gr_category` [ RunTime:0.000523s ]
[ SQL ] SELECT * FROM `gr_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000230s ]
[ DB ] CONNECT:[ UseTime:0.000271s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SELECT `id`,`parent_id` FROM `gr_category` [ RunTime:0.000254s ]
[ DB ] CONNECT:[ UseTime:0.000263s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SELECT `id` FROM `gr_category` WHERE `parent_id` = 1 [ RunTime:0.000188s ]
[ DB ] CONNECT:[ UseTime:0.000273s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `gr_goods` [ RunTime:0.000678s ]
[ SQL ] SELECT `id` FROM `gr_goods` WHERE `is_del` = 0 AND ( `cat_id` IN (1,4,5) OR `extend_cat_id` IN (1,4,5) ) [ RunTime:0.000223s ]
[ SQL ] SELECT `sell_price` FROM `gr_goods` WHERE `id` IN (4,758,757,55,65,68,113,125,203,262,263,265,269,271,273,274,276,277,278,279,281,300,301,302,303,304,305,306,308,309,310,313,338,345,348,754,368,369,370,372,752,398,399,400,409,412,413,419,420,424,440,444,445,454,455,458,463,741,742,743,745,746,747,760) [ RunTime:0.000338s ]
[ SQL ] SELECT `brand_id` FROM `gr_goods` WHERE `id` IN (4,758,757,55,65,68,113,125,203,262,263,265,269,271,273,274,276,277,278,279,281,300,301,302,303,304,305,306,308,309,310,313,338,345,348,754,368,369,370,372,752,398,399,400,409,412,413,419,420,424,440,444,445,454,455,458,463,741,742,743,745,746,747,760) AND `brand_id` > 0 [ RunTime:0.000305s ]
[ SQL ] SHOW COLUMNS FROM `gr_brand` [ RunTime:0.000416s ]
[ SQL ] SELECT * FROM `gr_brand` WHERE `id` IN (1,1,1,1,1) LIMIT 30 [ RunTime:0.000161s ]
[ SQL ] select group_concat(`key` separator '_') as `key` from gr_spec_goods_price where goods_id in(4,758,757,55,65,68,113,125,203,262,263,265,269,271,273,274,276,277,278,279,281,300,301,302,303,304,305,306,308,309,310,313,338,345,348,754,368,369,370,372,752,398,399,400,409,412,413,419,420,424,440,444,445,454,455,458,463,741,742,743,745,746,747,760) [ RunTime:0.000721s ]
[ SQL ] SHOW COLUMNS FROM `gr_spec` [ RunTime:0.000423s ]
[ SQL ] SELECT `id`,`name` FROM `gr_spec` WHERE `search_index` = 1 [ RunTime:0.000198s ]
[ SQL ] SHOW COLUMNS FROM `gr_spec_item` [ RunTime:0.000456s ]
[ 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.000857s ]
[ SQL ] SHOW COLUMNS FROM `gr_goods_attr` [ RunTime:0.000451s ]
[ SQL ] SELECT * FROM `gr_goods_attr` WHERE `goods_id` IN (4,758,757,55,65,68,113,125,203,262,263,265,269,271,273,274,276,277,278,279,281,300,301,302,303,304,305,306,308,309,310,313,338,345,348,754,368,369,370,372,752,398,399,400,409,412,413,419,420,424,440,444,445,454,455,458,463,741,742,743,745,746,747,760) AND `attr_value` <> '' [ RunTime:0.000429s ]
[ SQL ] SHOW COLUMNS FROM `gr_goods_attribute` [ RunTime:0.000410s ]
[ SQL ] SELECT `attr_id`,`attr_name`,`attr_index` FROM `gr_goods_attribute` WHERE ( attr_index = 1 ) [ RunTime:0.000171s ]
[ DB ] CONNECT:[ UseTime:0.000327s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SELECT * FROM `gr_goods` WHERE `id` IN (4,758,757,55,65,68,113,125,203,262,263,265,269,271,273,274,276,277,278,279,281,300,301,302,303,304,305,306,308,309,310,313,338,345,348,754,368,369,370,372,752,398,399,400,409,412,413,419,420,424,440,444,445,454,455,458,463,741,742,743,745,746,747,760) ORDER BY sell_price asc LIMIT 0,20 [ RunTime:0.000538s ]
[ DB ] CONNECT:[ UseTime:0.000299s ] 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.000322s ]
[ DB ] CONNECT:[ UseTime:0.000240s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SELECT `id`,`name`,`parent_id` FROM `gr_category` [ RunTime:0.000203s ]
[ DB ] CONNECT:[ UseTime:0.000250s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `gr_areas` [ RunTime:0.000497s ]
[ SQL ] SELECT * FROM `gr_areas` WHERE ( parent_id = 340000 ) [ RunTime:0.000200s ]
[ DB ] CONNECT:[ UseTime:0.000280s ] 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.000326s ]
[ DB ] CONNECT:[ UseTime:0.000251s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `gr_navigation` [ RunTime:0.000445s ]
[ SQL ] SELECT * FROM `gr_navigation` WHERE ( is_show = 1 ) ORDER BY sort desc [ RunTime:0.000194s ]
[ DB ] CONNECT:[ UseTime:0.000281s ] 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.000326s ]
[ DB ] CONNECT:[ UseTime:0.000258s ] mysql:dbname=greeshop;host=127.0.0.1;charset=utf8
[ SQL ] SHOW COLUMNS FROM `gr_goods_visit` [ RunTime:0.000473s ]
[ 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.000179s ]
[ 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,459,273,338,4,63,348,271,462) ) ORDER BY id desc LIMIT 18 [ RunTime:0.000202s ]