[ DB ] CONNECT:[ UseTime:0.000389s ] mysql:dbname=csf_test_1;host=localhost;port=3306;charset=utf8
[ SQL ] SHOW COLUMNS FROM `portal_cate` [ RunTime:0.001104s ]
[ SQL ] SELECT * FROM `portal_cate` WHERE `pid` = 0 AND `disabled` = 0 ORDER BY `sort` asc [ RunTime:0.000263s ]
[ SQL ] SELECT * FROM `portal_cate` WHERE `pid` IN (1,2,3) AND `disabled` = 0 ORDER BY `sort` asc [ RunTime:0.000218s ]
[ SQL ] SELECT * FROM `portal_cate` WHERE `pid` IN (48,102,97,69,68,53,51,50,49,4,47,44,39,10,9,8,7,5) AND `disabled` = 0 ORDER BY `sort` asc [ RunTime:0.000256s ]
[ SQL ] SELECT * FROM `portal_cate` WHERE `pid` IN (83,45,46,70,71,72,73,74,75,76,77,78,79,80,81,82,43,84,85,86,89,90,91,92,93,94,95,96,98,99,100,101,27,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,11,28,29,30,31,32,33,34,35,36,37,38,40,41,42) AND `disabled` = 0 ORDER BY `sort` asc [ RunTime:0.000289s ]
[ SQL ] SELECT * FROM `portal_cate` WHERE `identify` = 'TEAM' AND `level` = 2 AND `disabled` = 0 ORDER BY `sort` asc [ RunTime:0.000232s ]
[ SQL ] SELECT `id` FROM `portal_cate` WHERE `identify` = 'TEAM' AND `level` = 1 LIMIT 1 [ RunTime:0.000164s ]
[ SQL ] SHOW COLUMNS FROM `portal_product` [ RunTime:0.001068s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `portal_product` WHERE `publish_status` = 1 AND `top_cate_id` = 3 LIMIT 1 [ RunTime:0.000201s ]
[ SQL ] SELECT * FROM `portal_product` WHERE `publish_status` = 1 AND `top_cate_id` = 3 ORDER BY `create_time` desc LIMIT 0,9 [ RunTime:0.000282s ]
[ SQL ] SHOW COLUMNS FROM `portal_album_item` [ RunTime:0.000729s ]
[ SQL ] SELECT `img_id` FROM `portal_album_item` WHERE `album_id` = 26 ORDER BY `sort_order` asc [ RunTime:0.000281s ]
[ SQL ] SELECT * FROM `portal_cate` WHERE `id` = 86 LIMIT 1 [ RunTime:0.000187s ]
[ SQL ] SELECT `pid` FROM `portal_cate` WHERE `id` = 86 LIMIT 1 [ RunTime:0.000176s ]
[ SQL ] SELECT * FROM `portal_cate` WHERE `id` = 68 LIMIT 1 [ RunTime:0.000171s ]
[ SQL ] SHOW COLUMNS FROM `area` [ RunTime:0.000809s ]
[ SQL ] SELECT * FROM `area` WHERE `code` IN (340000,340500,340504) [ RunTime:0.000210s ]
[ SQL ] SELECT `name` FROM `area` WHERE `code` IN (330800) [ RunTime:0.000158s ]
[ SQL ] SELECT `name` FROM `area` WHERE `code` = 0 [ RunTime:0.000130s ]
[ SQL ] SELECT `img_id` FROM `portal_album_item` WHERE `album_id` = 24 ORDER BY `sort_order` asc [ RunTime:0.000138s ]
[ SQL ] SELECT * FROM `portal_cate` WHERE `id` = 102 LIMIT 1 [ RunTime:0.000137s ]
[ SQL ] SELECT `pid` FROM `portal_cate` WHERE `id` = 102 LIMIT 1 [ RunTime:0.000124s ]
[ SQL ] SELECT * FROM `portal_cate` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000118s ]
[ SQL ] SELECT * FROM `area` WHERE `code` IN (130000,131100,131102) [ RunTime:0.000179s ]
[ SQL ] SELECT `name` FROM `area` WHERE `code` IN (469000) [ RunTime:0.000141s ]
[ SQL ] SELECT `name` FROM `area` WHERE `code` = 0 [ RunTime:0.000132s ]
[ SQL ] SELECT `img_id` FROM `portal_album_item` WHERE `album_id` = 8 ORDER BY `sort_order` asc [ RunTime:0.000130s ]
[ SQL ] SELECT * FROM `portal_cate` WHERE `id` = 101 LIMIT 1 [ RunTime:0.000132s ]
[ SQL ] SELECT `pid` FROM `portal_cate` WHERE `id` = 101 LIMIT 1 [ RunTime:0.000107s ]
[ SQL ] SELECT * FROM `portal_cate` WHERE `id` = 97 LIMIT 1 [ RunTime:0.000114s ]
[ SQL ] SELECT * FROM `area` WHERE `code` IN (420000,420100,420102) [ RunTime:0.000204s ]
[ SQL ] SELECT `name` FROM `area` WHERE `code` IN (420100,420200,420300,420500,420600,420700,420800,420900,421000,421100,421200,421300,422800,429014,429015,429011,429016) [ RunTime:0.000266s ]
[ SQL ] SELECT `name` FROM `area` WHERE `code` = 0 [ RunTime:0.000125s ]
[ SQL ] SELECT `img_id` FROM `portal_album_item` WHERE `album_id` = 6 ORDER BY `sort_order` asc [ RunTime:0.000124s ]
[ SQL ] SELECT * FROM `portal_cate` WHERE `id` = 70 LIMIT 1 [ RunTime:0.000142s ]
[ SQL ] SELECT `pid` FROM `portal_cate` WHERE `id` = 70 LIMIT 1 [ RunTime:0.000109s ]
[ SQL ] SELECT * FROM `portal_cate` WHERE `id` = 53 LIMIT 1 [ RunTime:0.000112s ]
[ SQL ] SELECT * FROM `area` WHERE `code` IN (310000,310100,310101) [ RunTime:0.000182s ]
[ SQL ] SELECT `name` FROM `area` WHERE `code` IN (310100) [ RunTime:0.000149s ]
[ SQL ] SELECT `name` FROM `area` WHERE `code` = 0 [ RunTime:0.000123s ]
[ SQL ] SELECT `img_id` FROM `portal_album_item` WHERE `album_id` = 5 ORDER BY `sort_order` asc [ RunTime:0.000124s ]
[ SQL ] SELECT * FROM `portal_cate` WHERE `id` = 79 LIMIT 1 [ RunTime:0.000131s ]
[ SQL ] SELECT `pid` FROM `portal_cate` WHERE `id` = 79 LIMIT 1 [ RunTime:0.000106s ]
[ SQL ] SELECT * FROM `portal_cate` WHERE `id` = 53 LIMIT 1 [ RunTime:0.000113s ]
[ SQL ] SELECT `name` FROM `area` WHERE `code` IN (420200,420100,420300) [ RunTime:0.000164s ]
[ SQL ] SELECT `name` FROM `area` WHERE `code` = 0 [ RunTime:0.000121s ]
[ SQL ] SELECT `img_id` FROM `portal_album_item` WHERE `album_id` = 4 ORDER BY `sort_order` asc [ RunTime:0.000124s ]
[ SQL ] SELECT * FROM `portal_cate` WHERE `id` = 70 LIMIT 1 [ RunTime:0.000129s ]
[ SQL ] SELECT `pid` FROM `portal_cate` WHERE `id` = 70 LIMIT 1 [ RunTime:0.000105s ]
[ SQL ] SELECT * FROM `portal_cate` WHERE `id` = 53 LIMIT 1 [ RunTime:0.000133s ]
[ SQL ] SELECT `name` FROM `area` WHERE `code` IN (420100,420200,420300,420500,420600,420700,420800,420900,421000,421100,421200,421300,422800,429014,429015,429016) [ RunTime:0.000271s ]
[ SQL ] SELECT `name` FROM `area` WHERE `code` = 0 [ RunTime:0.000127s ]
[ SQL ] SELECT `img_id` FROM `portal_album_item` WHERE `album_id` = 3 ORDER BY `sort_order` asc [ RunTime:0.000137s ]
[ SQL ] SELECT * FROM `portal_cate` WHERE `id` = 102 LIMIT 1 [ RunTime:0.000137s ]
[ SQL ] SELECT `pid` FROM `portal_cate` WHERE `id` = 102 LIMIT 1 [ RunTime:0.000129s ]
[ SQL ] SELECT * FROM `portal_cate` WHERE `id` = 3 LIMIT 1 [ RunTime:0.000176s ]
[ SQL ] SELECT * FROM `area` WHERE `code` IN (420000,420600,420602) [ RunTime:0.000219s ]
[ SQL ] SELECT `name` FROM `area` WHERE `code` IN (420100,420200,420300,420500,420600,420700,420800) [ RunTime:0.000222s ]
[ SQL ] SELECT `name` FROM `area` WHERE `code` = 0 [ RunTime:0.000180s ]
[ SQL ] SELECT `img_id` FROM `portal_album_item` WHERE `album_id` = 2 ORDER BY `sort_order` asc [ RunTime:0.000184s ]
[ SQL ] SELECT * FROM `portal_cate` WHERE `id` = 80 LIMIT 1 [ RunTime:0.000186s ]
[ SQL ] SELECT `pid` FROM `portal_cate` WHERE `id` = 80 LIMIT 1 [ RunTime:0.000161s ]
[ SQL ] SELECT * FROM `portal_cate` WHERE `id` = 53 LIMIT 1 [ RunTime:0.000171s ]
[ SQL ] SELECT `name` FROM `area` WHERE `code` IN (420100,420200,421100,420700) [ RunTime:0.000237s ]
[ SQL ] SELECT `name` FROM `area` WHERE `code` = 0 [ RunTime:0.000170s ]
[ SQL ] SELECT `id`,`code`,`name` FROM `area` WHERE `level` = 1 [ RunTime:0.025733s ]