[ SQL ] SHOW COLUMNS FROM `ob_line_destination` [ RunTime:0.005442s ]
[ SQL ] SELECT `r`.`region_id`,`r`.`region_name` FROM `ob_line_destination` `d` INNER JOIN `ob_line` `l` ON `l`.`id`=`d`.`line_id` INNER JOIN `ob_region` `r` ON `r`.`region_id`=`d`.`country_id` WHERE ( d.status=1 and l.status=1 and (l.pos like '%,5,%' or l.pos like '5,%' or l.pos like '%,5' or l.pos='5') and d.is_start_did=0 ) GROUP BY d.country_id ORDER BY d.id asc LIMIT 32 [ RunTime:0.001438s ]
[ SQL ] SHOW COLUMNS FROM `ob_supplier` [ RunTime:0.005859s ]
[ SQL ] SELECT * FROM `ob_supplier` WHERE ( status=1 and (pos like '%,33,%' or pos like '33,%' or pos like '%,33' or pos='33') ) ORDER BY index_sort asc,list_sort asc,id asc LIMIT 6 [ RunTime:0.000830s ]
[ SQL ] SHOW COLUMNS FROM `ob_line_prices` [ RunTime:0.005491s ]
[ SQL ] SELECT date_format(p.date,'%Y%m%d') as date FROM `ob_line_prices` `p` LEFT JOIN `ob_line` `l` ON `l`.`id`=`p`.`line_id` WHERE ( p.status=1 and l.status=1 and (l.pos like '%,5,%' or l.pos like '5,%' or l.pos like '%,5' or l.pos='5') ) GROUP BY date_format(p.date,'%Y%m') ORDER BY p.date asc LIMIT 48 [ RunTime:0.009636s ]
[ SQL ] SHOW COLUMNS FROM `ob_line_subjects` [ RunTime:0.005342s ]
[ SQL ] SELECT * FROM `ob_line_subjects` `s` INNER JOIN `ob_line` `l` ON `l`.`id`=`s`.`line_id` WHERE ( s.status=1 and l.status=1 and (l.pos like '%,5,%' or l.pos like '5,%' or l.pos like '%,5' or l.pos='5') and s.subject_id='100' ) LIMIT 1 [ RunTime:0.000813s ]
[ SQL ] SELECT * FROM `ob_line_subjects` `s` INNER JOIN `ob_line` `l` ON `l`.`id`=`s`.`line_id` WHERE ( s.status=1 and l.status=1 and (l.pos like '%,5,%' or l.pos like '5,%' or l.pos like '%,5' or l.pos='5') and s.subject_id='101' ) LIMIT 1 [ RunTime:0.000717s ]
[ SQL ] SELECT * FROM `ob_line_subjects` `s` INNER JOIN `ob_line` `l` ON `l`.`id`=`s`.`line_id` WHERE ( s.status=1 and l.status=1 and (l.pos like '%,5,%' or l.pos like '5,%' or l.pos like '%,5' or l.pos='5') and s.subject_id='102' ) LIMIT 1 [ RunTime:0.000696s ]
[ SQL ] SELECT * FROM `ob_line_subjects` `s` INNER JOIN `ob_line` `l` ON `l`.`id`=`s`.`line_id` WHERE ( s.status=1 and l.status=1 and (l.pos like '%,5,%' or l.pos like '5,%' or l.pos like '%,5' or l.pos='5') and s.subject_id='103' ) LIMIT 1 [ RunTime:0.000724s ]
[ SQL ] SHOW COLUMNS FROM `ob_category` [ RunTime:0.005546s ]
[ SQL ] SELECT `id`,`name` FROM `ob_category` WHERE `parent_id` = 7 AND `category_type` = 'line' AND `status` = 1 ORDER BY sort asc,id asc [ RunTime:0.000488s ]
[ SQL ] SELECT r.region_name as name,d.city_id as id FROM `ob_line_destination` `d` LEFT JOIN `ob_region` `r` ON `r`.`region_id`=`d`.`city_id` LEFT JOIN `ob_line` `l` ON `l`.`id`=`d`.`line_id` WHERE ( d.status=1 and r.status=0 and d.is_start_did=1 and l.status=1 and d.city_id!=0 ) AND `l`.`category_id` = 15 GROUP BY d.city_id [ RunTime:0.000568s ]
[ SQL ] SELECT `r`.`region_id`,`r`.`region_name` FROM `ob_line_destination` `d` INNER JOIN `ob_line` `l` ON `l`.`id`=`d`.`line_id` INNER JOIN `ob_region` `r` ON `r`.`region_id`=`d`.`city_id` WHERE ( d.status=1 and l.status=1 and (l.pos like '%,5,%' or l.pos like '5,%' or l.pos like '%,5' or l.pos='5') and d.is_start_did=0 and d.country_id='3255' ) GROUP BY d.city_id ORDER BY d.id asc LIMIT 4 [ RunTime:0.000774s ]
[ SQL ] SELECT `r`.`region_id`,`r`.`region_name` FROM `ob_line_destination` `d` INNER JOIN `ob_line` `l` ON `l`.`id`=`d`.`line_id` INNER JOIN `ob_region` `r` ON `r`.`region_id`=`d`.`city_id` WHERE ( d.status=1 and l.status=1 and (l.pos like '%,5,%' or l.pos like '5,%' or l.pos like '%,5' or l.pos='5') and d.is_start_did=0 and d.country_id='1' ) GROUP BY d.city_id ORDER BY d.id asc LIMIT 4 [ RunTime:0.000768s ]
[ SQL ] SELECT `r`.`region_id`,`r`.`region_name` FROM `ob_line_destination` `d` INNER JOIN `ob_line` `l` ON `l`.`id`=`d`.`line_id` INNER JOIN `ob_region` `r` ON `r`.`region_id`=`d`.`city_id` WHERE ( d.status=1 and l.status=1 and (l.pos like '%,5,%' or l.pos like '5,%' or l.pos like '%,5' or l.pos='5') and d.is_start_did=0 and d.country_id='3584' ) GROUP BY d.city_id ORDER BY d.id asc LIMIT 4 [ RunTime:0.000637s ]
[ SQL ] SELECT `r`.`region_id`,`r`.`region_name` FROM `ob_line_destination` `d` INNER JOIN `ob_line` `l` ON `l`.`id`=`d`.`line_id` INNER JOIN `ob_region` `r` ON `r`.`region_id`=`d`.`city_id` WHERE ( d.status=1 and l.status=1 and (l.pos like '%,5,%' or l.pos like '5,%' or l.pos like '%,5' or l.pos='5') and d.is_start_did=0 and d.country_id='1433' ) GROUP BY d.city_id ORDER BY d.id asc LIMIT 4 [ RunTime:0.000599s ]
[ SQL ] SELECT `r`.`region_id`,`r`.`region_name` FROM `ob_line_destination` `d` INNER JOIN `ob_line` `l` ON `l`.`id`=`d`.`line_id` INNER JOIN `ob_region` `r` ON `r`.`region_id`=`d`.`city_id` WHERE ( d.status=1 and l.status=1 and (l.pos like '%,5,%' or l.pos like '5,%' or l.pos like '%,5' or l.pos='5') and d.is_start_did=0 and d.country_id='4440' ) GROUP BY d.city_id ORDER BY d.id asc LIMIT 4 [ RunTime:0.000561s ]
[ SQL ] SELECT `r`.`region_id`,`r`.`region_name` FROM `ob_line_destination` `d` INNER JOIN `ob_line` `l` ON `l`.`id`=`d`.`line_id` INNER JOIN `ob_region` `r` ON `r`.`region_id`=`d`.`city_id` WHERE ( d.status=1 and l.status=1 and (l.pos like '%,5,%' or l.pos like '5,%' or l.pos like '%,5' or l.pos='5') and d.is_start_did=0 and d.country_id='4084' ) GROUP BY d.city_id ORDER BY d.id asc LIMIT 4 [ RunTime:0.000609s ]
[ SQL ] SELECT `r`.`region_id`,`r`.`region_name` FROM `ob_line_destination` `d` INNER JOIN `ob_line` `l` ON `l`.`id`=`d`.`line_id` INNER JOIN `ob_region` `r` ON `r`.`region_id`=`d`.`city_id` WHERE ( d.status=1 and l.status=1 and (l.pos like '%,5,%' or l.pos like '5,%' or l.pos like '%,5' or l.pos='5') and d.is_start_did=0 and d.country_id='2370' ) GROUP BY d.city_id ORDER BY d.id asc LIMIT 4 [ RunTime:0.000630s ]
[ SQL ] SELECT `r`.`region_id`,`r`.`region_name` FROM `ob_line_destination` `d` INNER JOIN `ob_line` `l` ON `l`.`id`=`d`.`line_id` INNER JOIN `ob_region` `r` ON `r`.`region_id`=`d`.`city_id` WHERE ( d.status=1 and l.status=1 and (l.pos like '%,5,%' or l.pos like '5,%' or l.pos like '%,5' or l.pos='5') and d.is_start_did=0 and d.country_id='4324' ) GROUP BY d.city_id ORDER BY d.id asc LIMIT 4 [ RunTime:0.000548s ]
[ SQL ] SELECT * FROM `ob_supplier` WHERE ( status=1 and (pos like '%,33,%' or pos like '33,%' or pos like '%,33' or pos='33') ) ORDER BY list_sort asc,id asc LIMIT 20 [ RunTime:0.000848s ]
[ SQL ] SELECT * FROM `ob_cruise` WHERE ( status=1 and supplier_id=4 and (pos like '%,34,%' or pos like '34,%' or pos like '%,34' or pos='34') ) ORDER BY list_sort asc,id asc LIMIT 21 [ RunTime:0.000858s ]
[ SQL ] SELECT * FROM `ob_cruise` WHERE ( status=1 and supplier_id=5 and (pos like '%,34,%' or pos like '34,%' or pos like '%,34' or pos='34') ) ORDER BY list_sort asc,id asc LIMIT 21 [ RunTime:0.000606s ]
[ SQL ] SELECT * FROM `ob_cruise` WHERE ( status=1 and supplier_id=6 and (pos like '%,34,%' or pos like '34,%' or pos like '%,34' or pos='34') ) ORDER BY list_sort asc,id asc LIMIT 21 [ RunTime:0.000687s ]
[ SQL ] SELECT * FROM `ob_cruise` WHERE ( status=1 and supplier_id=7 and (pos like '%,34,%' or pos like '34,%' or pos like '%,34' or pos='34') ) ORDER BY list_sort asc,id asc LIMIT 21 [ RunTime:0.000740s ]
[ SQL ] SELECT * FROM `ob_cruise` WHERE ( status=1 and supplier_id=8 and (pos like '%,34,%' or pos like '34,%' or pos like '%,34' or pos='34') ) ORDER BY list_sort asc,id asc LIMIT 21 [ RunTime:0.000806s ]
[ SQL ] SELECT * FROM `ob_cruise` WHERE ( status=1 and supplier_id=9 and (pos like '%,34,%' or pos like '34,%' or pos like '%,34' or pos='34') ) ORDER BY list_sort asc,id asc LIMIT 21 [ RunTime:0.000643s ]
[ SQL ] SELECT * FROM `ob_cruise` WHERE ( status=1 and supplier_id=10 and (pos like '%,34,%' or pos like '34,%' or pos like '%,34' or pos='34') ) ORDER BY list_sort asc,id asc LIMIT 21 [ RunTime:0.000566s ]
[ SQL ] SELECT * FROM `ob_cruise` WHERE ( status=1 and supplier_id=11 and (pos like '%,34,%' or pos like '34,%' or pos like '%,34' or pos='34') ) ORDER BY list_sort asc,id asc LIMIT 21 [ RunTime:0.000733s ]
[ SQL ] SELECT * FROM `ob_cruise` WHERE ( status=1 and supplier_id=12 and (pos like '%,34,%' or pos like '34,%' or pos like '%,34' or pos='34') ) ORDER BY list_sort asc,id asc LIMIT 21 [ RunTime:0.000519s ]
[ SQL ] SELECT * FROM `ob_cruise` WHERE ( status=1 and supplier_id=13 and (pos like '%,34,%' or pos like '34,%' or pos like '%,34' or pos='34') ) ORDER BY list_sort asc,id asc LIMIT 21 [ RunTime:0.000746s ]
[ SQL ] SELECT * FROM `ob_cruise` WHERE ( status=1 and supplier_id=14 and (pos like '%,34,%' or pos like '34,%' or pos like '%,34' or pos='34') ) ORDER BY list_sort asc,id asc LIMIT 21 [ RunTime:0.000789s ]
[ SQL ] SELECT * FROM `ob_cruise` WHERE ( status=1 and supplier_id=15 and (pos like '%,34,%' or pos like '34,%' or pos like '%,34' or pos='34') ) ORDER BY list_sort asc,id asc LIMIT 21 [ RunTime:0.001348s ]
[ SQL ] SELECT * FROM `ob_cruise` WHERE ( status=1 and supplier_id=16 and (pos like '%,34,%' or pos like '34,%' or pos like '%,34' or pos='34') ) ORDER BY list_sort asc,id asc LIMIT 21 [ RunTime:0.000678s ]
[ SQL ] SELECT * FROM `ob_cruise` WHERE ( status=1 and supplier_id=17 and (pos like '%,34,%' or pos like '34,%' or pos like '%,34' or pos='34') ) ORDER BY list_sort asc,id asc LIMIT 21 [ RunTime:0.000859s ]
[ SQL ] SELECT * FROM `ob_cruise` WHERE ( status=1 and supplier_id=18 and (pos like '%,34,%' or pos like '34,%' or pos like '%,34' or pos='34') ) ORDER BY list_sort asc,id asc LIMIT 21 [ RunTime:0.000875s ]
[ SQL ] SELECT * FROM `ob_cruise` WHERE ( status=1 and supplier_id=19 and (pos like '%,34,%' or pos like '34,%' or pos like '%,34' or pos='34') ) ORDER BY list_sort asc,id asc LIMIT 21 [ RunTime:0.000631s ]
[ SQL ] SELECT * FROM `ob_cruise` WHERE ( status=1 and supplier_id=20 and (pos like '%,34,%' or pos like '34,%' or pos like '%,34' or pos='34') ) ORDER BY list_sort asc,id asc LIMIT 21 [ RunTime:0.000674s ]
[ SQL ] SELECT * FROM `ob_cruise` WHERE ( status=1 and supplier_id=21 and (pos like '%,34,%' or pos like '34,%' or pos like '%,34' or pos='34') ) ORDER BY list_sort asc,id asc LIMIT 21 [ RunTime:0.000700s ]
[ SQL ] SELECT * FROM `ob_cruise` WHERE ( status=1 and supplier_id=22 and (pos like '%,34,%' or pos like '34,%' or pos like '%,34' or pos='34') ) ORDER BY list_sort asc,id asc LIMIT 21 [ RunTime:0.000670s ]
[ SQL ] SELECT * FROM `ob_cruise` WHERE ( status=1 and supplier_id=23 and (pos like '%,34,%' or pos like '34,%' or pos like '%,34' or pos='34') ) ORDER BY list_sort asc,id asc LIMIT 21 [ RunTime:0.000707s ]
[ SQL ] SELECT * FROM `ob_line` WHERE ( status=1 and (pos like '%,6,%' or pos like '6,%' or pos like '%,6' or pos='6') ) ORDER BY index_sort asc,id asc LIMIT 4 [ RunTime:0.001034s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='3' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.005657s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='3' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001170s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='3' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.005469s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='4' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001423s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='4' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001263s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='4' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001234s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='5' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001277s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='5' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001260s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='5' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001218s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='6' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001479s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='6' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001492s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='6' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001241s ]
[ SQL ] SELECT * FROM `ob_line` WHERE ( status=1 and (pos like '%,7,%' or pos like '7,%' or pos like '%,7' or pos='7') ) ORDER BY index_sort asc,id asc LIMIT 4 [ RunTime:0.000964s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='4' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001372s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='4' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001261s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='4' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001238s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='5' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001299s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='5' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001231s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='5' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001208s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='6' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001243s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='6' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001223s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='6' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001187s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='10' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001284s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='10' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001235s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='10' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001220s ]
[ SQL ] SELECT * FROM `ob_line` WHERE ( status=1 and (pos like '%,8,%' or pos like '8,%' or pos like '%,8' or pos='8') ) ORDER BY index_sort asc,id asc LIMIT 4 [ RunTime:0.000985s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='3' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.005704s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='3' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001127s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='3' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.005502s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='4' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001358s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='4' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001261s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='4' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001221s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='5' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001252s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='5' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001214s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='5' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001205s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='6' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001236s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='6' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001359s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='6' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001212s ]
[ SQL ] SELECT * FROM `ob_line` WHERE ( status=1 and (pos like '%,9,%' or pos like '9,%' or pos like '%,9' or pos='9') ) ORDER BY index_sort asc,id asc LIMIT 4 [ RunTime:0.001048s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='3' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.005606s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='3' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001129s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='3' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.005494s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='4' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001292s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='4' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001241s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='4' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001228s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='5' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001256s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='5' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001227s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='5' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001206s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='6' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001262s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='6' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001223s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='6' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001204s ]
[ SQL ] SELECT `r`.`region_id`,`r`.`region_name` FROM `ob_line_destination` `d` INNER JOIN `ob_line` `l` ON `l`.`id`=`d`.`line_id` INNER JOIN `ob_region` `r` ON `r`.`region_id`=`d`.`city_id` WHERE ( d.status=1 and l.status=1 and (l.pos like '%,5,%' or l.pos like '5,%' or l.pos like '%,5' or l.pos='5') and d.is_start_did=0 ) GROUP BY d.city_id ORDER BY d.id asc LIMIT 10 [ RunTime:0.001607s ]
[ SQL ] SELECT * FROM `ob_line` WHERE ( status=1 and (pos like '%,5,%' or pos like '5,%' or pos like '%,5' or pos='5') and id in( select line_id from ob_line_destination where status=1 and (country_id in(03257) or province_id in(03257) or city_id in(03257))) ) ORDER BY index_sort asc,id asc LIMIT 8 [ RunTime:0.001291s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='2' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001404s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='2' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001238s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='2' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001204s ]
[ SQL ] SELECT * FROM `ob_line` WHERE ( status=1 and (pos like '%,5,%' or pos like '5,%' or pos like '%,5' or pos='5') and id in( select line_id from ob_line_destination where status=1 and (country_id in(0485) or province_id in(0485) or city_id in(0485))) ) ORDER BY index_sort asc,id asc LIMIT 8 [ RunTime:0.001287s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='2' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001354s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='2' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001246s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='2' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001210s ]
[ SQL ] SELECT * FROM `ob_line` WHERE ( status=1 and (pos like '%,5,%' or pos like '5,%' or pos like '%,5' or pos='5') and id in( select line_id from ob_line_destination where status=1 and (country_id in(03622) or province_id in(03622) or city_id in(03622))) ) ORDER BY index_sort asc,id asc LIMIT 8 [ RunTime:0.001275s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='4' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001376s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='4' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001242s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='4' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001200s ]
[ SQL ] SELECT * FROM `ob_line` WHERE ( status=1 and (pos like '%,5,%' or pos like '5,%' or pos like '%,5' or pos='5') and id in( select line_id from ob_line_destination where status=1 and (country_id in(03586) or province_id in(03586) or city_id in(03586))) ) ORDER BY index_sort asc,id asc LIMIT 8 [ RunTime:0.001275s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='3' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.005591s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='3' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001135s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='3' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.005468s ]
[ SQL ] SELECT * FROM `ob_line` WHERE ( status=1 and (pos like '%,5,%' or pos like '5,%' or pos like '%,5' or pos='5') and id in( select line_id from ob_line_destination where status=1 and (country_id in(01437) or province_id in(01437) or city_id in(01437))) ) ORDER BY index_sort asc,id asc LIMIT 8 [ RunTime:0.001279s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='12' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001387s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='12' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001252s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='12' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001222s ]
[ SQL ] SELECT * FROM `ob_line` WHERE ( status=1 and (pos like '%,5,%' or pos like '5,%' or pos like '%,5' or pos='5') and id in( select line_id from ob_line_destination where status=1 and (country_id in(01436) or province_id in(01436) or city_id in(01436))) ) ORDER BY index_sort asc,id asc LIMIT 8 [ RunTime:0.001276s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='12' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001622s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='12' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001280s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='12' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001251s ]
[ SQL ] SELECT * FROM `ob_line` WHERE ( status=1 and (pos like '%,5,%' or pos like '5,%' or pos like '%,5' or pos='5') and id in( select line_id from ob_line_destination where status=1 and (country_id in(04442) or province_id in(04442) or city_id in(04442))) ) ORDER BY index_sort asc,id asc LIMIT 8 [ RunTime:0.001335s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='13' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001386s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='13' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001256s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='13' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001232s ]
[ SQL ] SELECT * FROM `ob_line` WHERE ( status=1 and (pos like '%,5,%' or pos like '5,%' or pos like '%,5' or pos='5') and id in( select line_id from ob_line_destination where status=1 and (country_id in(03298) or province_id in(03298) or city_id in(03298))) ) ORDER BY index_sort asc,id asc LIMIT 8 [ RunTime:0.001457s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='14' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001396s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='14' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001269s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='14' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001221s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='16' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001264s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='16' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001235s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='16' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001201s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='17' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001266s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='17' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001213s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='17' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001196s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='18' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001269s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='18' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001213s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='18' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001201s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='20' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001250s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='20' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001213s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='20' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001195s ]
[ SQL ] SELECT * FROM `ob_line` WHERE ( status=1 and (pos like '%,5,%' or pos like '5,%' or pos like '%,5' or pos='5') and id in( select line_id from ob_line_destination where status=1 and (country_id in(03296) or province_id in(03296) or city_id in(03296))) ) ORDER BY index_sort asc,id asc LIMIT 8 [ RunTime:0.001454s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='16' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001505s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='16' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001282s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='16' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001232s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='17' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001293s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='17' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001231s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='17' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001210s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='18' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001276s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='18' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001227s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='18' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001196s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='19' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001260s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='19' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001216s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='19' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001218s ]
[ SQL ] SELECT * FROM `ob_line` WHERE ( status=1 and (pos like '%,5,%' or pos like '5,%' or pos like '%,5' or pos='5') and id in( select line_id from ob_line_destination where status=1 and (country_id in(03303) or province_id in(03303) or city_id in(03303))) ) ORDER BY index_sort asc,id asc LIMIT 8 [ RunTime:0.001387s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='21' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001481s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='21' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001544s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='21' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001271s ]
[ SQL ] SELECT * FROM `ob_supplier` WHERE ( status=1 and (pos like '%,19,%' or pos like '19,%' or pos like '%,19' or pos='19') ) ORDER BY list_sort asc,id asc LIMIT 6 [ RunTime:0.000862s ]
[ SQL ] SELECT * FROM `ob_cruise` WHERE ( status=1 and supplier_id=4 and (pos like '%,21,%' or pos like '21,%' or pos like '%,21' or pos='21') ) ORDER BY list_sort asc,id asc LIMIT 6 [ RunTime:0.000798s ]
[ SQL ] SELECT * FROM `ob_cruise` WHERE ( status=1 and supplier_id=5 and (pos like '%,21,%' or pos like '21,%' or pos like '%,21' or pos='21') ) ORDER BY list_sort asc,id asc LIMIT 6 [ RunTime:0.000724s ]
[ SQL ] SELECT * FROM `ob_cruise` WHERE ( status=1 and supplier_id=6 and (pos like '%,21,%' or pos like '21,%' or pos like '%,21' or pos='21') ) ORDER BY list_sort asc,id asc LIMIT 6 [ RunTime:0.000831s ]
[ SQL ] SELECT * FROM `ob_cruise` WHERE ( status=1 and supplier_id=7 and (pos like '%,21,%' or pos like '21,%' or pos like '%,21' or pos='21') ) ORDER BY list_sort asc,id asc LIMIT 6 [ RunTime:0.000771s ]
[ SQL ] SELECT * FROM `ob_cruise` WHERE ( status=1 and supplier_id=8 and (pos like '%,21,%' or pos like '21,%' or pos like '%,21' or pos='21') ) ORDER BY list_sort asc,id asc LIMIT 6 [ RunTime:0.000791s ]
[ SQL ] SELECT * FROM `ob_cruise` WHERE ( status=1 and supplier_id=9 and (pos like '%,21,%' or pos like '21,%' or pos like '%,21' or pos='21') ) ORDER BY list_sort asc,id asc LIMIT 6 [ RunTime:0.000758s ]
[ SQL ] SELECT * FROM `ob_line` WHERE ( status=1 and (pos like '%,24,%' or pos like '24,%' or pos like '%,24' or pos='24') and supplier_id='4' ) ORDER BY index_sort asc,id asc LIMIT 4 [ RunTime:0.000880s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='6' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001417s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='6' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001262s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='6' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001217s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='20' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001272s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='20' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001229s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='20' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001214s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='21' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001272s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='21' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001237s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='21' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001204s ]
[ SQL ] SELECT * FROM `ob_line` WHERE ( status=1 and (pos like '%,24,%' or pos like '24,%' or pos like '%,24' or pos='24') and supplier_id='5' ) ORDER BY index_sort asc,id asc LIMIT 4 [ RunTime:0.000827s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='17' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001347s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='17' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001241s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='17' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001217s ]
[ SQL ] SELECT * FROM `ob_line` WHERE ( status=1 and (pos like '%,24,%' or pos like '24,%' or pos like '%,24' or pos='24') and supplier_id='6' ) ORDER BY index_sort asc,id asc LIMIT 4 [ RunTime:0.000786s ]
[ SQL ] SELECT * FROM `ob_line` WHERE ( status=1 and (pos like '%,24,%' or pos like '24,%' or pos like '%,24' or pos='24') and supplier_id='7' ) ORDER BY index_sort asc,id asc LIMIT 4 [ RunTime:0.000920s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='12' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001378s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='12' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001256s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='12' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001227s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='13' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001313s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='13' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001232s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='13' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001211s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='14' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001765s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='14' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001578s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='14' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001299s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='15' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001302s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='15' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001234s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='15' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001207s ]
[ SQL ] SELECT * FROM `ob_line` WHERE ( status=1 and (pos like '%,24,%' or pos like '24,%' or pos like '%,24' or pos='24') and supplier_id='8' ) ORDER BY index_sort asc,id asc LIMIT 4 [ RunTime:0.000929s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='5' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001380s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='5' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001252s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='5' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001228s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='22' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001265s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='22' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001226s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='22' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001230s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='23' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001251s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='23' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001222s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='23' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001199s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='29' and date>='2002-04-26' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001245s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='29' and date>='2002-04-26' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001214s ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='29' and date>='2002-04-26' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001246s ]
[ SQL ] SELECT * FROM `ob_line` WHERE ( status=1 and (pos like '%,24,%' or pos like '24,%' or pos like '%,24' or pos='24') and supplier_id='9' ) ORDER BY index_sort asc,id asc LIMIT 4 [ RunTime:0.000820s ]
[ SQL ] SHOW COLUMNS FROM `ob_article` [ RunTime:0.007008s ]
[ SQL ] SELECT * FROM `ob_article` WHERE ( status=1 and (pos like '%,10,%' or pos like '10,%' or pos like '%,10' or pos='10') and category_id='17,18,19,2' ) ORDER BY list_sort asc,id asc LIMIT 8 [ RunTime:0.000710s ]
[ SQL ] SELECT * FROM `ob_article` WHERE ( status=1 and (pos like '%,10,%' or pos like '10,%' or pos like '%,10' or pos='10') and category_id='20,21,22,4' ) ORDER BY list_sort asc,id asc LIMIT 6 [ RunTime:0.000590s ]
[ SQL ] SHOW COLUMNS FROM `ob_blogroll` [ RunTime:0.006448s ]
[ 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` = '1' ORDER BY f.sort asc,f.id asc [ RunTime:0.000661s ]
[ 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.000584s ]
[ 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.000577s ]