[ 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` = 2 AND `a`.`status` <> -1 LIMIT 1 [ RunTime:0.000763s ]
[ SQL ] SHOW COLUMNS FROM `ob_line` [ RunTime:0.007446s ]
[ 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.001259s ]
[ SQL ] SHOW COLUMNS FROM `ob_line_prices` [ RunTime:0.006459s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='3' and date>='2002-05-19' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.005730s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='3' and date>='2002-05-19' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001145s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='3' and date>='2002-05-19' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.005510s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='4' and date>='2002-05-19' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001401s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='4' and date>='2002-05-19' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001259s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='4' and date>='2002-05-19' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001229s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='5' and date>='2002-05-19' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001414s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='5' and date>='2002-05-19' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001123s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='5' and date>='2002-05-19' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001078s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='6' and date>='2002-05-19' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001119s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='6' and date>='2002-05-19' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001087s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='6' and date>='2002-05-19' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001046s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='11' and date>='2002-05-19' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001086s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='11' and date>='2002-05-19' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001064s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='11' and date>='2002-05-19' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001043s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='12' and date>='2002-05-19' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001080s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='12' and date>='2002-05-19' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001062s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='12' and date>='2002-05-19' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001142s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='13' and date>='2002-05-19' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001156s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='13' and date>='2002-05-19' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001082s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='13' and date>='2002-05-19' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001051s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='17' and date>='2002-05-19' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001095s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='17' and date>='2002-05-19' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001102s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='17' and date>='2002-05-19' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001057s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='18' and date>='2002-05-19' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001087s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='18' and date>='2002-05-19' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001068s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='18' and date>='2002-05-19' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001045s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='30' and date>='2002-05-19' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001109s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='30' and date>='2002-05-19' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001082s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='30' and date>='2002-05-19' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001069s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='2' and date>='2002-05-19' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001093s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='2' and date>='2002-05-19' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001051s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='2' and date>='2002-05-19' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001028s ]
[ SQL ] SHOW COLUMNS FROM `ob_blogroll` [ RunTime:0.005400s ]
[ 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.000556s ]
[ 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.000530s ]