[ SQL ] SELECT `a`.*,c.name as category_name,r.name as cruise_name,s.name as supplier_name,`d`.`content`,`d`.`content1`,`d`.`content2`,`d`.`content3`,`d`.`content4`,`d`.`content5`,`d`.`content6`,`d`.`content7` FROM `ob_line` `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` `r` ON `r`.`id`=`a`.`cruise_id` LEFT JOIN `ob_supplier` `s` ON `s`.`id`=`a`.`supplier_id` LEFT JOIN `ob_line_detail` `d` ON `d`.`aid`=`a`.`id` WHERE `a`.`id` = 4 LIMIT 1 [ RunTime:0.000937s ]
[ SQL ] SHOW COLUMNS FROM `ob_line_prices` [ RunTime:0.005532s ]
[ 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.001298s ]
[ 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.001107s ]
[ SQL ] SHOW COLUMNS FROM `ob_line_destination` [ RunTime:0.005431s ]
[ SQL ] SELECT `r`.`region_name`,`d`.`city_id` FROM `ob_line_destination` `d` LEFT JOIN `ob_region` `r` ON `r`.`region_id`=`d`.`city_id` WHERE ( d.status=1 and r.status=0 and d.line_id='4' and d.is_start_did=1 ) GROUP BY d.city_id [ RunTime:0.000635s ]
[ SQL ] SELECT `r`.`region_name`,`d`.`city_id` FROM `ob_line_destination` `d` LEFT JOIN `ob_region` `r` ON `r`.`region_id`=`d`.`city_id` WHERE ( d.status=1 and r.status=0 and d.line_id='4' ) GROUP BY d.city_id [ RunTime:0.000441s ]
[ SQL ] SHOW COLUMNS FROM `ob_cruise_extend` [ RunTime:0.005522s ]
[ SQL ] SELECT * FROM `ob_cruise_extend` WHERE `cruise_id` = 3 AND `status` = 1 AND `type` = 'room' ORDER BY list_sort asc,id asc LIMIT 4 [ RunTime:0.000583s ]
[ SQL ] SELECT * FROM `ob_cruise_extend` WHERE `cruise_id` = 3 AND `status` = 1 AND `type` = 'cater' ORDER BY list_sort asc,id asc LIMIT 4 [ RunTime:0.000458s ]
[ SQL ] SELECT * FROM `ob_cruise_extend` WHERE `cruise_id` = 3 AND `status` = 1 AND `type` = 'entertainment' ORDER BY list_sort asc,id asc LIMIT 4 [ RunTime:0.000461s ]
[ SQL ] SELECT * FROM `ob_cruise_extend` WHERE `cruise_id` = 3 AND `status` = 1 AND `type` = 'shopping' ORDER BY list_sort asc,id asc LIMIT 4 [ RunTime:0.000442s ]
[ 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 20 [ RunTime:0.001226s ]
[ SQL ] SELECT `date` FROM `ob_line_prices` WHERE ( status=1 and line_id='4' and date>='2002-05-06' ) GROUP BY date ORDER BY date asc,id asc [ RunTime:0.000729s ]
[ SQL ] SHOW COLUMNS FROM `ob_article` [ RunTime:0.005864s ]
[ 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 index_sort asc,id asc LIMIT 9 [ RunTime:0.000682s ]
[ SQL ] SELECT * FROM `ob_line` WHERE ( status=1 and (pos like '%,5,%' or pos like '5,%' or pos like '%,5' or pos='5') ) ORDER BY rand() LIMIT 4 [ RunTime:0.001343s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='19' and date>='2002-05-06' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001268s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='19' and date>='2002-05-06' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001096s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='19' and date>='2002-05-06' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001066s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='24' and date>='2002-05-06' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001105s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='24' and date>='2002-05-06' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001161s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='24' and date>='2002-05-06' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001053s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='21' and date>='2002-05-06' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001092s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='21' and date>='2002-05-06' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001058s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='21' and date>='2002-05-06' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001049s ]
[ 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.001076s ]
[ 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.001053s ]
[ 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.001037s ]
[ SQL ] SHOW COLUMNS FROM `ob_blogroll` [ RunTime:0.005552s ]
[ 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.000566s ]
[ 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.000548s ]