[ DB ] CONNECT:[ UseTime:0.017887s ] mysql:host=123.56.126.100;port=3306;dbname=xmanedu;charset=utf8
[ SQL ] SHOW COLUMNS FROM `clt_new_state` [ RunTime:0.012773s ]
[ 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.019097s ]
[ SQL ] SHOW COLUMNS FROM `clt_new_family` [ RunTime:0.012863s ]
[ 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` = '24' AND `f`.`is_show` = 1 [ RunTime:0.012362s ]
[ 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` = '24' AND `f`.`is_show` = 1 ORDER BY `add_time` DESC,`sort` DESC LIMIT 0,8 [ RunTime:0.012591s ]
[ SQL ] SHOW COLUMNS FROM `clt_new_city` [ RunTime:0.012645s ]
[ SQL ] SELECT `id`,`title` FROM `clt_new_city` [ RunTime:0.024129s ]
[ SQL ] SHOW COLUMNS FROM `clt_new_video` [ RunTime:0.012620s ]
[ SQL ] SELECT * FROM `clt_new_video` WHERE `tui_ids` LIKE 20 ORDER BY `add_time` DESC,`sort` DESC [ RunTime:0.012436s ]
[ SQL ] SELECT `title`,`keyword`,`describe` FROM `clt_new_state` WHERE `id` = 24 LIMIT 1 [ RunTime:0.011912s ]
[ SQL ] SHOW COLUMNS FROM `clt_new_label` [ RunTime:0.012954s ]
[ SQL ] SELECT `title`,`href` FROM `clt_new_label` WHERE `is_hot` = 1 AND `recommend_id` LIKE '%44%' [ RunTime:0.012087s ]