[ DB ] CONNECT:[ UseTime:0.000436s ] mysql:host=127.0.0.1;dbname=app;charset=utf8
[ SQL ] SHOW COLUMNS FROM `wt_site_art_class` [ RunTime:0.000865s ]
[ SQL ] SELECT `class_name`,`id`,`keywords`,`description` FROM `wt_site_art_class` WHERE `id` = 642 AND `site_id` = 1047 [ RunTime:0.000206s ]
[ SQL ] SELECT `id`,`class_name`,`keywords`,`description` FROM `wt_site_art_class` WHERE `pclass_id` = 642 AND `site_id` = 1047 [ RunTime:0.000123s ]
[ SQL ] SHOW COLUMNS FROM `wt_site_art` [ RunTime:0.000718s ]
[ SQL ] SELECT `a`.`id`,`a`.`art_name`,`a`.`thumb` FROM `wt_site_art` `a` LEFT JOIN `wt_site_art_class` `ac` ON `a`.`class_id`=`ac`.`id` LEFT JOIN `wt_site_art_class` `acb` ON `ac`.`pclass_id`=`acb`.`id` WHERE `a`.`site_id` = '1047' AND `acb`.`id` = '642' AND `hot` = 1 ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 0,3 [ RunTime:0.050002s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `wt_site_art` `a` LEFT JOIN `wt_site_art_class` `ac` ON `a`.`class_id`=`ac`.`id` LEFT JOIN `wt_site_art_class` `acb` ON `ac`.`pclass_id`=`acb`.`id` WHERE `a`.`site_id` = '1047' AND `acb`.`id` = '642' LIMIT 1 [ RunTime:0.053637s ]
[ SQL ] SELECT `a`.`id`,`a`.`art_name`,`a`.`thumb`,`a`.`add_time`,`a`.`content`,`a`.`type` FROM `wt_site_art` `a` LEFT JOIN `wt_site_art_class` `ac` ON `a`.`class_id`=`ac`.`id` LEFT JOIN `wt_site_art_class` `acb` ON `ac`.`pclass_id`=`acb`.`id` WHERE `a`.`site_id` = '1047' AND `acb`.`id` = '642' ORDER BY `a`.`sort` DESC,`a`.`id` DESC LIMIT 20,10 [ RunTime:0.055956s ]
[ SQL ] SELECT `c`.`id`,`c`.`art_name` FROM wt_site_art_class as a LEFT JOIN `wt_site_art_class` `b` ON `a`.`id`=`b`.`pclass_id` LEFT JOIN `wt_site_art` `c` ON `b`.`id`=c.class_id and c.status >=1 WHERE `a`.`site_id` = '1047' AND `a`.`id` = '642' ORDER BY `c`.`hit` DESC LIMIT 10 [ RunTime:0.206540s ]
