SHOW FULL COLUMNS FROM `v6_config` [ RunTime:0.042374s ]
SELECT `type`,`name`,`value` FROM `v6_config` WHERE `status` = 1 [ RunTime:0.041696s ]
SHOW FULL COLUMNS FROM `v6_region` [ RunTime:0.039411s ]
SELECT * FROM `v6_region` WHERE `dir` = 'nanchang' LIMIT 1 [ RunTime:0.056950s ]
SHOW FULL COLUMNS FROM `v6_category` [ RunTime:0.021959s ]
SELECT * FROM `v6_category` WHERE `dir` = 'product' LIMIT 1 [ RunTime:0.039010s ]
SELECT COUNT(*) AS think_count FROM `v6_category` WHERE `pid` = 2 [ RunTime:0.049314s ]
SELECT `id`,`type`,`pid`,`pstr`,`name`,`dir`,`setting`,`is_nav`,`allow_publish`,`picurl`,`keywords`,`description`,`linkurl`,`create_time`,`update_time`,`status`,`sort` FROM `v6_category` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.056119s ]
SELECT * FROM `v6_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.036905s ]
SELECT COUNT(*) AS think_count FROM `v6_category` WHERE `pid` = 2 [ RunTime:0.031916s ]
SELECT `id`,`type`,`pid`,`pstr`,`name`,`dir`,`setting`,`is_nav`,`allow_publish`,`picurl`,`keywords`,`description`,`linkurl`,`create_time`,`update_time`,`status`,`sort` FROM `v6_category` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.028657s ]
SELECT * FROM `v6_category` WHERE `pid` = 0 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 0,20 [ RunTime:0.118729s ]
SELECT * FROM `v6_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.017827s ]
SELECT COUNT(*) AS think_count FROM `v6_category` WHERE `pid` = 1 [ RunTime:0.026062s ]
SELECT `id`,`type`,`pid`,`pstr`,`name`,`dir`,`setting`,`is_nav`,`allow_publish`,`picurl`,`keywords`,`description`,`linkurl`,`create_time`,`update_time`,`status`,`sort` FROM `v6_category` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.036434s ]
SELECT * FROM `v6_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.019776s ]
SELECT COUNT(*) AS think_count FROM `v6_category` WHERE `pid` = 3 [ RunTime:0.026277s ]
SELECT `id`,`type`,`pid`,`pstr`,`name`,`dir`,`setting`,`is_nav`,`allow_publish`,`picurl`,`keywords`,`description`,`linkurl`,`create_time`,`update_time`,`status`,`sort` FROM `v6_category` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019658s ]
SELECT * FROM `v6_category` WHERE `id` = 4 LIMIT 1 [ RunTime:0.048233s ]
SELECT COUNT(*) AS think_count FROM `v6_category` WHERE `pid` = 4 [ RunTime:0.020797s ]
SELECT `id`,`type`,`pid`,`pstr`,`name`,`dir`,`setting`,`is_nav`,`allow_publish`,`picurl`,`keywords`,`description`,`linkurl`,`create_time`,`update_time`,`status`,`sort` FROM `v6_category` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.012737s ]
SELECT * FROM `v6_category` WHERE `id` = 5 LIMIT 1 [ RunTime:0.032866s ]
SELECT COUNT(*) AS think_count FROM `v6_category` WHERE `pid` = 5 [ RunTime:0.010793s ]
SELECT `id`,`type`,`pid`,`pstr`,`name`,`dir`,`setting`,`is_nav`,`allow_publish`,`picurl`,`keywords`,`description`,`linkurl`,`create_time`,`update_time`,`status`,`sort` FROM `v6_category` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.053377s ]
SELECT * FROM `v6_category` WHERE `id` = 6 LIMIT 1 [ RunTime:0.027975s ]
SELECT COUNT(*) AS think_count FROM `v6_category` WHERE `pid` = 6 [ RunTime:0.057643s ]
SELECT `id`,`type`,`pid`,`pstr`,`name`,`dir`,`setting`,`is_nav`,`allow_publish`,`picurl`,`keywords`,`description`,`linkurl`,`create_time`,`update_time`,`status`,`sort` FROM `v6_category` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.024248s ]
SELECT * FROM `v6_category` WHERE `id` = 14 LIMIT 1 [ RunTime:0.026798s ]
SELECT COUNT(*) AS think_count FROM `v6_category` WHERE `pid` = 14 [ RunTime:0.051155s ]
SELECT `id`,`type`,`pid`,`pstr`,`name`,`dir`,`setting`,`is_nav`,`allow_publish`,`picurl`,`keywords`,`description`,`linkurl`,`create_time`,`update_time`,`status`,`sort` FROM `v6_category` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.016234s ]
SELECT * FROM `v6_category` WHERE `pid` = 2 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 0,20 [ RunTime:0.031958s ]
SELECT * FROM `v6_category` WHERE `id` = 8 LIMIT 1 [ RunTime:0.010307s ]
SELECT COUNT(*) AS think_count FROM `v6_category` WHERE `pid` = 8 [ RunTime:0.040023s ]
SELECT `id`,`type`,`pid`,`pstr`,`name`,`dir`,`setting`,`is_nav`,`allow_publish`,`picurl`,`keywords`,`description`,`linkurl`,`create_time`,`update_time`,`status`,`sort` FROM `v6_category` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.045569s ]
SELECT * FROM `v6_category` WHERE `id` = 7 LIMIT 1 [ RunTime:0.082677s ]
SELECT COUNT(*) AS think_count FROM `v6_category` WHERE `pid` = 7 [ RunTime:0.066233s ]
SELECT `id`,`type`,`pid`,`pstr`,`name`,`dir`,`setting`,`is_nav`,`allow_publish`,`picurl`,`keywords`,`description`,`linkurl`,`create_time`,`update_time`,`status`,`sort` FROM `v6_category` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.022216s ]
SELECT * FROM `v6_category` WHERE `id` = 9 LIMIT 1 [ RunTime:0.011703s ]
SELECT COUNT(*) AS think_count FROM `v6_category` WHERE `pid` = 9 [ RunTime:0.017913s ]
SELECT `id`,`type`,`pid`,`pstr`,`name`,`dir`,`setting`,`is_nav`,`allow_publish`,`picurl`,`keywords`,`description`,`linkurl`,`create_time`,`update_time`,`status`,`sort` FROM `v6_category` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.015710s ]
SELECT * FROM `v6_category` WHERE `id` = 10 LIMIT 1 [ RunTime:0.017512s ]
SELECT COUNT(*) AS think_count FROM `v6_category` WHERE `pid` = 10 [ RunTime:0.015222s ]
SELECT `id`,`type`,`pid`,`pstr`,`name`,`dir`,`setting`,`is_nav`,`allow_publish`,`picurl`,`keywords`,`description`,`linkurl`,`create_time`,`update_time`,`status`,`sort` FROM `v6_category` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.013351s ]
SELECT * FROM `v6_category` WHERE `id` = 11 LIMIT 1 [ RunTime:0.008837s ]
SELECT COUNT(*) AS think_count FROM `v6_category` WHERE `pid` = 11 [ RunTime:0.019058s ]
SELECT `id`,`type`,`pid`,`pstr`,`name`,`dir`,`setting`,`is_nav`,`allow_publish`,`picurl`,`keywords`,`description`,`linkurl`,`create_time`,`update_time`,`status`,`sort` FROM `v6_category` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.015112s ]
SELECT * FROM `v6_category` WHERE `id` = 13 LIMIT 1 [ RunTime:0.025177s ]
SELECT COUNT(*) AS think_count FROM `v6_category` WHERE `pid` = 13 [ RunTime:0.021167s ]
SELECT `id`,`type`,`pid`,`pstr`,`name`,`dir`,`setting`,`is_nav`,`allow_publish`,`picurl`,`keywords`,`description`,`linkurl`,`create_time`,`update_time`,`status`,`sort` FROM `v6_category` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.013323s ]
SHOW FULL COLUMNS FROM `v6_article` [ RunTime:0.106846s ]
SELECT `id`,`type`,`pid`,`pstr`,`name`,`dir`,`setting`,`is_nav`,`allow_publish`,`picurl`,`keywords`,`description`,`linkurl`,`create_time`,`update_time`,`status`,`sort` FROM `v6_category` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.014932s ]
SELECT COUNT(`id`) AS think_count FROM `v6_article` WHERE `cid` IN (2,8,7,9,10,11,12,13) AND `status` = 1 AND `create_time` < 1740781246 [ RunTime:0.042441s ]
SELECT `id`,`type`,`pid`,`pstr`,`name`,`dir`,`setting`,`is_nav`,`allow_publish`,`picurl`,`keywords`,`description`,`linkurl`,`create_time`,`update_time`,`status`,`sort` FROM `v6_category` ORDER BY `sort` ASC,`id` ASC [ RunTime:0.019358s ]
SELECT * FROM `v6_article` WHERE `cid` IN (2,8,7,9,10,11,12,13) AND `status` = 1 AND `create_time` < 1740781246 ORDER BY `istop` DESC,`sort` DESC,`create_time` DESC,`id` DESC LIMIT 54,9 [ RunTime:0.063294s ]
SELECT * FROM `v6_category` WHERE `pid` = 2 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 0,20 [ RunTime:0.041710s ]
SHOW FULL COLUMNS FROM `v6_adtype` [ RunTime:0.066050s ]
SELECT * FROM `v6_adtype` WHERE `status` = 1 AND `id` = 2 LIMIT 1 [ RunTime:0.069280s ]
SHOW FULL COLUMNS FROM `v6_ads` [ RunTime:0.040589s ]
SELECT * FROM `v6_ads` WHERE `status` = 1 AND `type` = 2 ORDER BY `sort` ASC,`id` ASC LIMIT 1 [ RunTime:0.040352s ]
SELECT * FROM `v6_category` WHERE `pid` = 0 AND `status` = 1 ORDER BY `sort` ASC,`id` ASC LIMIT 0,20 [ RunTime:0.025885s ]