[ DB ] CONNECT:[ UseTime:0.000449s ] mysql:dbname=csf_test_1;host=localhost;port=3306;charset=utf8
[ SQL ] SHOW COLUMNS FROM `portal_cate` [ RunTime:0.001121s ]
[ SQL ] SELECT * FROM `portal_cate` WHERE `pid` = 0 AND `disabled` = 0 ORDER BY `sort` asc [ RunTime:0.000359s ]
[ SQL ] SELECT * FROM `portal_cate` WHERE `pid` IN (1,2,3) AND `disabled` = 0 ORDER BY `sort` asc [ RunTime:0.000339s ]
[ 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.000410s ]
[ 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.000307s ]
[ SQL ] SELECT * FROM `portal_cate` WHERE `identify` = 'TEAM' AND `level` = 2 AND `disabled` = 0 ORDER BY `sort` asc [ RunTime:0.000210s ]
[ SQL ] SELECT `id` FROM `portal_cate` WHERE `identify` = 'TEAM' AND `level` = 1 LIMIT 1 [ RunTime:0.000157s ]
[ SQL ] SELECT * FROM `portal_cate` WHERE `id` = 69 LIMIT 1 [ RunTime:0.000136s ]
[ SQL ] SELECT `id` FROM `portal_cate` WHERE `pid` = 69 [ RunTime:0.000132s ]
[ SQL ] SELECT `id` FROM `portal_cate` WHERE ( `pid` IN (89,90,92,93,94,95,96) ) [ RunTime:0.000138s ]
[ SQL ] SHOW COLUMNS FROM `portal_product` [ RunTime:0.000982s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `portal_product` WHERE `publish_status` = 1 AND `cate_id` IN (89,90,92,93,94,95,96,69) AND `top_cate_id` = 3 AND `region_code` = '140524' LIMIT 1 [ RunTime:0.000199s ]
[ SQL ] SHOW COLUMNS FROM `area` [ RunTime:0.000799s ]
[ SQL ] SELECT `id`,`code`,`name` FROM `area` WHERE `level` = 1 [ RunTime:0.025954s ]
[ SQL ] SELECT `id`,`code`,`name` FROM `area` WHERE `parentcode` = 140000 AND `level` = 2 [ RunTime:0.000313s ]
[ SQL ] SELECT `id`,`code`,`name` FROM `area` WHERE `parentcode` = 140500 AND `level` = 3 [ RunTime:0.000177s ]
