[ DB ] CONNECT:[ UseTime:0.017696s ] mysql:host=123.56.126.100;port=3306;dbname=xmanedu;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_new_state` [ RunTime:0.012584s ]
[ SQL ] SELECT f.id as f_id,f.title as f_title,z.id as z_id,z.title as z_title,c.id as c_id,c.title as c_title,f.is_show as f_is_show FROM `clt_new_state` `z` INNER JOIN `clt_new_city` `c` ON `c`.`state_id`=`z`.`id` INNER JOIN `clt_new_family` `f` ON `f`.`city_id`=`c`.`id` [ RunTime:0.018679s ]
[ SQL ] SHOW COLUMNS FROM `clt_new_family` [ RunTime:0.012464s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `clt_new_family` `f` INNER JOIN `clt_new_city` `c` ON `f`.`city_id`=`c`.`id` INNER JOIN `clt_new_state` `s` ON `c`.`state_id`=`s`.`id` WHERE `s`.`id` = '25' AND `f`.`is_show` = 1 [ RunTime:0.012147s ]
[ SQL ] SELECT `f`.`id`,`f`.`cover_pic`,`f`.`title`,`f`.`city_id`,`f`.`is_show`,`f`.`introduction`,`f`.`add_time`,`f`.`sort`,c.title c_title,s.title s_title FROM `clt_new_family` `f` INNER JOIN `clt_new_city` `c` ON `f`.`city_id`=`c`.`id` INNER JOIN `clt_new_state` `s` ON `c`.`state_id`=`s`.`id` WHERE `s`.`id` = '25' AND `f`.`is_show` = 1 ORDER BY `add_time` DESC,`sort` DESC LIMIT 0,8 [ RunTime:0.012189s ]
[ SQL ] SHOW COLUMNS FROM `clt_new_city` [ RunTime:0.012358s ]
[ SQL ] SELECT `id`,`title` FROM `clt_new_city` [ RunTime:0.018094s ]
[ SQL ] SHOW COLUMNS FROM `clt_new_video` [ RunTime:0.012373s ]
[ SQL ] SELECT * FROM `clt_new_video` WHERE `tui_ids` LIKE 20 ORDER BY `add_time` DESC,`sort` DESC [ RunTime:0.011971s ]
[ SQL ] SELECT `title`,`keyword`,`describe` FROM `clt_new_state` WHERE `id` = 25 LIMIT 1 [ RunTime:0.011740s ]
[ SQL ] SHOW COLUMNS FROM `clt_new_label` [ RunTime:0.012346s ]
[ SQL ] SELECT `title`,`href` FROM `clt_new_label` WHERE `is_hot` = 1 AND `recommend_id` LIKE '%44%' [ RunTime:0.011797s ]
