[ SQL ] SELECT `a`.*,s.name as supplier_name,s.index_thumb as supplier_logo FROM `ob_cruise` `a` LEFT JOIN `ob_admin` `m` ON `a`.`member_id`=`m`.`id` LEFT JOIN `ob_category` `c` ON `a`.`category_id`=`c`.`id` LEFT JOIN `ob_cruise_detail` `d` ON `a`.`id`=`d`.`aid` LEFT JOIN `ob_supplier` `s` ON `s`.`id`=`a`.`supplier_id` WHERE `a`.`id` = 133 AND `a`.`status` <> -1 LIMIT 1 [ RunTime:0.000781s ]
[ SQL ] SHOW COLUMNS FROM `ob_cruise_extend` [ RunTime:0.006418s ]
[ SQL ] SELECT * FROM `ob_cruise_extend` WHERE `cruise_id` = 133 AND `status` = 1 AND `type` = 'room' ORDER BY list_sort asc,id asc [ RunTime:0.000638s ]
[ SQL ] SELECT * FROM `ob_cruise_extend` WHERE `cruise_id` = 133 AND `status` = 1 AND `type` = 'room' ORDER BY list_sort asc,id asc LIMIT 18 [ RunTime:0.000540s ]
[ SQL ] SELECT * FROM `ob_cruise_extend` WHERE `cruise_id` = 133 AND `status` = 1 AND `type` = 'cater' ORDER BY list_sort asc,id asc LIMIT 18 [ RunTime:0.000534s ]
[ SQL ] SELECT * FROM `ob_cruise_extend` WHERE `cruise_id` = 133 AND `status` = 1 AND `type` = 'entertainment' ORDER BY list_sort asc,id asc LIMIT 18 [ RunTime:0.000544s ]
[ SQL ] SELECT * FROM `ob_cruise_extend` WHERE `cruise_id` = 133 AND `status` = 1 AND `type` = 'shopping' ORDER BY list_sort asc,id asc LIMIT 18 [ RunTime:0.000522s ]
[ SQL ] SELECT `a`.*,`d`.`content` FROM `ob_article` `a` INNER JOIN `ob_article_detail` `d` ON `d`.`aid`=`a`.`id` WHERE `a`.`status` = 1 AND `a`.`type` = 'article' AND `a`.`category_id` IN ('17','18','19','2') ORDER BY rand() LIMIT 3 [ RunTime:0.003816s ]
[ SQL ] SELECT * FROM `ob_line` WHERE ( status=1 and (pos like '%,26,%' or pos like '26,%' or pos like '%,26' or pos='26') ) ORDER BY list_sort asc,id asc LIMIT 16 [ RunTime:0.001188s ]
[ SQL ] SHOW COLUMNS FROM `ob_line_prices` [ RunTime:0.006451s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='3' and date>='2002-05-06' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.005655s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='3' and date>='2002-05-06' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001131s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='3' and date>='2002-05-06' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.005455s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='4' and date>='2002-05-06' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001371s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='4' and date>='2002-05-06' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001244s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='4' and date>='2002-05-06' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001213s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='5' and date>='2002-05-06' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001254s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='5' and date>='2002-05-06' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001210s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='5' and date>='2002-05-06' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001227s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='6' and date>='2002-05-06' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001241s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='6' and date>='2002-05-06' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001210s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='6' and date>='2002-05-06' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001184s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='11' and date>='2002-05-06' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001224s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='11' and date>='2002-05-06' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001201s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='11' and date>='2002-05-06' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001180s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='12' and date>='2002-05-06' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001213s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='12' and date>='2002-05-06' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001202s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='12' and date>='2002-05-06' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001186s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='13' and date>='2002-05-06' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001215s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='13' and date>='2002-05-06' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001228s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='13' and date>='2002-05-06' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001184s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='17' and date>='2002-05-06' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001214s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='17' and date>='2002-05-06' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001223s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='17' and date>='2002-05-06' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001199s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='18' and date>='2002-05-06' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001211s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='18' and date>='2002-05-06' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001195s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='18' and date>='2002-05-06' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001174s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='30' and date>='2002-05-06' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001247s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='30' and date>='2002-05-06' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001232s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='30' and date>='2002-05-06' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001204s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='2' and date>='2002-05-06' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001208s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='2' and date>='2002-05-06' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001193s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='2' and date>='2002-05-06' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001175s ]
[ SQL ] SELECT * FROM `ob_article` WHERE ( status=1 and (pos like '%,25,%' or pos like '25,%' or pos like '%,25' or pos='25') ) ORDER BY rand() LIMIT 9 [ RunTime:0.000889s ]
[ SQL ] SHOW COLUMNS FROM `ob_blogroll` [ RunTime:0.006363s ]
[ SQL ] SELECT `f`.*,p.path as file_path,p.name as file_name FROM `ob_blogroll` `f` LEFT JOIN `ob_picture` `p` ON `p`.`id`=`f`.`img_id` WHERE `f`.`status` = 1 AND `f`.`parent_id` = '2' ORDER BY f.sort asc,f.id asc [ RunTime:0.000653s ]
[ SQL ] SELECT `f`.*,p.path as file_path,p.name as file_name FROM `ob_blogroll` `f` LEFT JOIN `ob_picture` `p` ON `p`.`id`=`f`.`img_id` WHERE `f`.`status` = 1 AND `f`.`parent_id` = '0' ORDER BY f.sort asc,f.id asc [ RunTime:0.000614s ]