SHOW COLUMNS FROM `t_mudidi` [ RunTime:0.000874s ]
SELECT * FROM `t_mudidi` WHERE `id` = 23 AND `status` = 99 LIMIT 1 [ RunTime:0.000232s ]
SELECT * FROM `t_mudidi` WHERE `id` = 23 AND `status` = 99 LIMIT 1 [ RunTime:0.000340s ]
SHOW COLUMNS FROM `t_jingdian` [ RunTime:0.000766s ]
SELECT COUNT(*) AS tp_count FROM `t_jingdian` WHERE `mudidi_id` = '23' AND `status` = 99 LIMIT 1 [ RunTime:0.000594s ]
SHOW COLUMNS FROM `t_youji` [ RunTime:0.000583s ]
SELECT COUNT(*) AS tp_count FROM `t_youji` WHERE ( status=99 and FIND_IN_SET('23',`mudidi_id`) ) LIMIT 1 [ RunTime:0.000177s ]
SHOW COLUMNS FROM `t_meishi` [ RunTime:0.000529s ]
SELECT COUNT(*) AS tp_count FROM `t_meishi` WHERE `mudidi_id` = '23' AND `status` = 99 LIMIT 1 [ RunTime:0.000164s ]
SHOW COLUMNS FROM `t_zhusu` [ RunTime:0.000396s ]
SELECT COUNT(*) AS tp_count FROM `t_zhusu` WHERE `mudidi_id` = '23' AND `status` = 99 LIMIT 1 [ RunTime:0.000085s ]
SHOW COLUMNS FROM `t_jiaotong` [ RunTime:0.000526s ]
SELECT COUNT(*) AS tp_count FROM `t_jiaotong` WHERE `mudidi_id` = '23' AND `status` = 99 LIMIT 1 [ RunTime:0.000214s ]
SHOW COLUMNS FROM `t_lvxingshe` [ RunTime:0.000538s ]
SELECT COUNT(*) AS tp_count FROM `t_lvxingshe` WHERE `catid` = 105 AND `mudidi_id` = '23' AND `status` = 99 LIMIT 1 [ RunTime:0.000156s ]
SHOW COLUMNS FROM `t_cache` [ RunTime:0.000447s ]
SELECT * FROM `t_cache` WHERE `key` = 'thbrate' ORDER BY `id` DESC [ RunTime:0.000188s ]
SELECT * FROM `t_cache` WHERE `key` = 'weatherinfo' ORDER BY `id` DESC [ RunTime:0.000190s ]
SHOW COLUMNS FROM `t_category` [ RunTime:0.000570s ]
SELECT * FROM `t_category` WHERE `ismenu` = 1 AND `parentid` = 78 ORDER BY listorder asc [ RunTime:0.000284s ]
SHOW COLUMNS FROM `t_position_data` [ RunTime:0.000496s ]
SELECT * FROM `t_position_data` WHERE `posid` = 8 ORDER BY `listorder` DESC,`id` DESC LIMIT 10 [ RunTime:0.000205s ]
SHOW COLUMNS FROM `t_mudidi` [ RunTime:0.000591s ]
SELECT `url` FROM `t_mudidi` WHERE `id` = 17 LIMIT 1 [ RunTime:0.000128s ]
SELECT `url` FROM `t_mudidi` WHERE `id` = 2 LIMIT 1 [ RunTime:0.000106s ]
SELECT `url` FROM `t_mudidi` WHERE `id` = 23 LIMIT 1 [ RunTime:0.000097s ]
SELECT `url` FROM `t_mudidi` WHERE `id` = 22 LIMIT 1 [ RunTime:0.000086s ]
SELECT `url` FROM `t_mudidi` WHERE `id` = 25 LIMIT 1 [ RunTime:0.000082s ]
SELECT `url` FROM `t_mudidi` WHERE `id` = 14 LIMIT 1 [ RunTime:0.000079s ]
SELECT * FROM `t_category` WHERE `ismenu` = 1 AND `parentid` = 119 ORDER BY listorder asc [ RunTime:0.000285s ]
SHOW COLUMNS FROM `t_jingdian` [ RunTime:0.000682s ]
SELECT COUNT(*) AS tp_count FROM `t_jingdian` WHERE ( `mudidi_id` = 23 ) AND `catid` = 101 AND `status` = 99 LIMIT 1 [ RunTime:0.000714s ]
SELECT * FROM `t_jingdian` WHERE ( `mudidi_id` = 23 ) AND `catid` = 101 AND `status` = 99 ORDER BY listorder asc, updatetime DESC LIMIT 0,9 [ RunTime:0.000834s ]