[ DB ] CONNECT:[ UseTime:0.000348s ] mysql:host=127.0.0.1;dbname=app;charset=utf8
[ SQL ] SHOW COLUMNS FROM `wt_site_art_class` [ RunTime:0.000600s ]
[ SQL ] SELECT `class_name`,`id`,`keywords`,`description` FROM `wt_site_art_class` WHERE `id` = 642 AND `site_id` = 1047 [ RunTime:0.000164s ]
[ SQL ] SELECT `id`,`class_name`,`keywords`,`description` FROM `wt_site_art_class` WHERE `pclass_id` = 642 AND `site_id` = 1047 [ RunTime:0.000104s ]
[ SQL ] SHOW COLUMNS FROM `wt_site_art` [ RunTime:0.000596s ]
[ 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.050535s ]
[ 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.052974s ]
[ 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 30,10 [ RunTime:0.058142s ]
[ 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.209801s ]
