特价尾单-享世界游轮

24小时热线

400-615-9997

您的所在位置：首页 > 特价尾单

限时五折

喜悦号5天4晚鹿儿岛

阳台房特惠3999起!

剩余：0位 0位已抢

活动已经结束！

￥1888.00 ￥2888.00

马上抢

云顶梦号4天3晚普吉岛+普吉岛

限时第一二人优惠

剩余：0位 0位已抢

活动已经结束！

￥1.00 ￥4700.00

马上抢

6天5晚广州-那霸-宫古-广州

提前30天预订立减100元，限时抢购

剩余：0位 26位 已抢

活动已经结束！

￥2888.00 ￥3618.00

马上抢

买一送一

上海杭州三日游

剩余：0位 0位已抢

活动已经结束！

￥588.00 ￥1288.00

马上抢

盛世公主号6天5晚鹿儿岛

盛世公主号6天5晚&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;middot;福冈+鹿儿岛

剩余：0位 0位已抢

活动已经结束！

￥1680.00 ￥2888.00

马上抢

10天9晚深圳-新加坡-苏梅岛-曼谷-胡志明-香港

提前30天预订立减100元，限时抢购

剩余：0位 0位已抢

活动已经结束！

￥15680.00 ￥18990.00

马上抢

注意事项：特价位置有限，所以预定下手要快，预定成功之后请尽快完成付款，如逾期未支付，订单将自动取消，是否抢购成功，以付款时间为准。由于特价产品资源特殊，付款成功后，无法更改、取消和退款，请慎重抢购！

深圳国际旅行社有限公司深圳国旅旅行社官方网站中国国旅深圳总部（www.sztrip.com）业务范围：国内游

公司地址：深圳福田区益田路江苏大厦B座1002 移动电话：18924664555

友情链接：千魁系统吞狼科技深海数据

基本文件流程错误 SQL 调试

/home/wwwroot/youlun/wwwroot/index.php ( 14.05 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/start.php ( 0.73 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/base.php ( 2.66 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/Loader.php ( 19.47 KB )
/home/wwwroot/youlun/wwwroot/vendor/composer/autoload_namespaces.php ( 0.21 KB )
/home/wwwroot/youlun/wwwroot/vendor/composer/autoload_psr4.php ( 0.59 KB )
/home/wwwroot/youlun/wwwroot/vendor/composer/autoload_classmap.php ( 0.14 KB )
/home/wwwroot/youlun/wwwroot/vendor/composer/autoload_files.php ( 0.33 KB )
/home/wwwroot/youlun/wwwroot/vendor/topthink/think-captcha/src/helper.php ( 1.59 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/Route.php ( 59.82 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/Config.php ( 6.03 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/Validate.php ( 40.27 KB )
/home/wwwroot/youlun/wwwroot/vendor/qiniu/php-sdk/src/Qiniu/functions.php ( 7.10 KB )
/home/wwwroot/youlun/wwwroot/vendor/qiniu/php-sdk/src/Qiniu/Config.php ( 0.70 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/Error.php ( 3.59 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/convention.php ( 10.31 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/App.php ( 20.63 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/Request.php ( 49.72 KB )
/home/wwwroot/youlun/wwwroot/app/config.php ( 9.55 KB )
/home/wwwroot/youlun/wwwroot/app/database.php ( 1.44 KB )
/home/wwwroot/youlun/wwwroot/app/extra/ext_config.php ( 0.78 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/Hook.php ( 4.76 KB )
/home/wwwroot/youlun/wwwroot/app/tags.php ( 1.21 KB )
/home/wwwroot/youlun/wwwroot/app/common/behavior/InitBase.php ( 7.56 KB )
/home/wwwroot/youlun/wwwroot/app/common.php ( 51.47 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/Env.php ( 1.25 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/helper.php ( 17.86 KB )
/home/wwwroot/youlun/wwwroot/app/function.php ( 1.01 KB )
/home/wwwroot/youlun/wwwroot/app/extend.php ( 9.44 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/Debug.php ( 7.06 KB )
/home/wwwroot/youlun/wwwroot/app/common/model/Config.php ( 0.74 KB )
/home/wwwroot/youlun/wwwroot/app/common/model/ModelBase.php ( 9.04 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/Model.php ( 64.92 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/Db.php ( 6.54 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/Log.php ( 5.84 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/db/connector/Mysql.php ( 3.94 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/db/Connection.php ( 28.96 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/db/Query.php ( 89.54 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/db/builder/Mysql.php ( 2.16 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/db/Builder.php ( 30.47 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/Cache.php ( 6.17 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/cache/driver/File.php ( 6.98 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/cache/Driver.php ( 5.52 KB )
/home/wwwroot/youlun/wwwroot/app/common/behavior/InitHook.php ( 1.20 KB )
/home/wwwroot/youlun/wwwroot/app/common/model/Hook.php ( 0.74 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/Lang.php ( 6.95 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/lang/zh-cn.php ( 3.85 KB )
/home/wwwroot/youlun/wwwroot/app/route.php ( 0.88 KB )
/home/wwwroot/youlun/wwwroot/app/common/behavior/AppBegin.php ( 0.84 KB )
/home/wwwroot/youlun/wwwroot/app/index/config.php ( 0.95 KB )
/home/wwwroot/youlun/wwwroot/app/index/common.php ( 2.00 KB )
/home/wwwroot/youlun/wwwroot/app/index/controller/Specials.php ( 2.90 KB )
/home/wwwroot/youlun/wwwroot/app/index/controller/IndexBase.php ( 1.57 KB )
/home/wwwroot/youlun/wwwroot/app/common/controller/ControllerBase.php ( 6.86 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/Controller.php ( 5.99 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/traits/controller/Jump.php ( 4.97 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/View.php ( 6.63 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/view/driver/Think.php ( 5.61 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/Template.php ( 45.34 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/template/driver/File.php ( 2.24 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/Session.php ( 11.17 KB )
/home/wwwroot/youlun/wwwroot/app/index/logic/Seo.php ( 22.09 KB )
/home/wwwroot/youlun/wwwroot/app/index/logic/IndexBase.php ( 0.78 KB )
/home/wwwroot/youlun/wwwroot/app/common/logic/LogicBase.php ( 0.79 KB )
/home/wwwroot/youlun/wwwroot/app/common/model/Seo.php ( 0.74 KB )
/home/wwwroot/youlun/wwwroot/app/common/logic/Specials.php ( 7.42 KB )
/home/wwwroot/youlun/wwwroot/app/common/model/Specials.php ( 0.75 KB )
/home/wwwroot/youlun/wwwroot/app/common/logic/Line.php ( 63.03 KB )
/home/wwwroot/youlun/wwwroot/app/common/model/Line.php ( 0.74 KB )
/home/wwwroot/youlun/wwwroot/app/common/model/LinePrices.php ( 0.75 KB )
/home/wwwroot/youlun/wwwroot/app/common/model/LineDestination.php ( 0.76 KB )
/home/wwwroot/youlun/wwwroot/app/common/model/LinePictures.php ( 0.76 KB )
/home/wwwroot/youlun/wwwroot/app/common/model/LineDetail.php ( 0.75 KB )
/home/wwwroot/youlun/wwwroot/runtime/temp/30892b3cb398b67f264e78d608ca1f90.php ( 20.15 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/Url.php ( 12.97 KB )
/home/wwwroot/youlun/wwwroot/app/index/widget/Ad.php ( 1.30 KB )
/home/wwwroot/youlun/wwwroot/app/index/widget/WidgetBase.php ( 1.01 KB )
/home/wwwroot/youlun/wwwroot/app/common/logic/Ad.php ( 1.49 KB )
/home/wwwroot/youlun/wwwroot/app/common/model/AdFiles.php ( 0.75 KB )
/home/wwwroot/youlun/wwwroot/runtime/temp/eeda958a1e8a941a4729286028721f15.php ( 0.36 KB )
/home/wwwroot/youlun/wwwroot/app/index/widget/FriendLink.php ( 1.28 KB )
/home/wwwroot/youlun/wwwroot/app/common/logic/Blogroll.php ( 3.07 KB )
/home/wwwroot/youlun/wwwroot/runtime/temp/0af2a97658bc24769611a0a6813538ef.php ( 0.46 KB )
/home/wwwroot/youlun/wwwroot/runtime/temp/b7338f9889f8d591267fba9468e7a61d.php ( 0.37 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/Response.php ( 8.64 KB )
/home/wwwroot/youlun/wwwroot/app/common/behavior/AppEnd.php ( 0.88 KB )
/home/wwwroot/youlun/wwwroot/thinkphp/library/think/debug/Html.php ( 4.27 KB )

[ DB ] INIT mysql
[ CACHE ] INIT File
[ BEHAVIOR ] Run app\common\behavior\InitBase @app_init [ RunTime:0.035061s ]
[ BEHAVIOR ] Run app\common\behavior\InitHook @app_init [ RunTime:0.008547s ]
[ LANG ] /home/wwwroot/youlun/wwwroot/thinkphp/lang/zh-cn.php
[ ROUTE ] array ( 'type' => 'module', 'module' => array ( 0 => 'index', 1 => 'specials', 2 => 'details', ), )
[ HEADER ] array ( 'host' => 'youlun.qkphp.com', 'user-agent' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'accept' => '*/*', 'remote-host' => '3.22.242.141', 'x-forwarded-for' => '3.22.242.141, 127.0.0.1', 'x-real-ip' => '3.22.242.141', 'accept-encoding' => 'gzip', 'content-type' => '', 'content-length' => '', )
[ PARAM ] array ( 'id' => '1', )
[ BEHAVIOR ] Run app\common\behavior\AppBegin @app_begin [ RunTime:0.000161s ]
[ SESSION ] INIT array ( 'id' => '', 'var_session_id' => '', 'prefix' => 'think', 'type' => '', 'auto_start' => true, )
[ RUN ] app\index\controller\Specials->details[ /home/wwwroot/youlun/wwwroot/app/index/controller/Specials.php ]
[ VIEW ] /home/wwwroot/youlun/wwwroot/app/index/view/specials/details.html [ array ( 0 => 'VIEW_ROOT', 1 => 'loading_icon', 2 => 'pjax_mode', 3 => 'user_info', 4 => 'seo_info', 5 => 'info', 6 => 'specials_models', ) ]
[ RUN ] app\index\widget\Ad->one[ /home/wwwroot/youlun/wwwroot/app/index/widget/Ad.php ]
[ VIEW ] /home/wwwroot/youlun/wwwroot/app/index/view/widget/ad/one.html [ array ( 0 => 'VIEW_ROOT', 1 => 'loading_icon', 2 => 'pjax_mode', 3 => 'user_info', 4 => 'seo_info', 5 => 'info', 6 => 'specials_models', 7 => 'widget_data', ) ]
[ RUN ] app\index\widget\FriendLink->index[ /home/wwwroot/youlun/wwwroot/app/index/widget/FriendLink.php ]
[ VIEW ] /home/wwwroot/youlun/wwwroot/app/index/view/widget/friendlink/img.html [ array ( 0 => 'VIEW_ROOT', 1 => 'loading_icon', 2 => 'pjax_mode', 3 => 'user_info', 4 => 'seo_info', 5 => 'info', 6 => 'specials_models', 7 => 'widget_data', ) ]
[ RUN ] app\index\widget\FriendLink->index[ /home/wwwroot/youlun/wwwroot/app/index/widget/FriendLink.php ]
[ VIEW ] /home/wwwroot/youlun/wwwroot/app/index/view/widget/friendlink/text.html [ array ( 0 => 'VIEW_ROOT', 1 => 'loading_icon', 2 => 'pjax_mode', 3 => 'user_info', 4 => 'seo_info', 5 => 'info', 6 => 'specials_models', 7 => 'widget_data', ) ]
[ BEHAVIOR ] Run app\common\behavior\AppEnd @app_end [ RunTime:0.000169s ]

[ DB ] CONNECT:[ UseTime:0.000646s ] mysql:dbname=youlun;host=127.0.0.1;port=3306;charset=utf8
[ SQL ] SHOW COLUMNS FROM `ob_config` [ RunTime:0.006577s ]
[ SQL ] SELECT * FROM `ob_config` [ RunTime:0.000702s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_config', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 60, 'extra' => NULL, ) ]
[ SQL ] SHOW COLUMNS FROM `ob_hook` [ RunTime:0.006313s ]
[ SQL ] SELECT `id`,`name`,`addon_list` FROM `ob_hook` [ RunTime:0.000333s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_hook', 'type' => 'ALL', 'possible_keys' => NULL, 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 3, 'extra' => NULL, ) ]
[ SQL ] SHOW COLUMNS FROM `ob_seo` [ RunTime:0.006400s ]
[ SQL ] SELECT `id`,`name`,`url`,`seo_title`,`seo_keywords`,`seo_description`,`usable_val`,`sort`,`status`,`create_time`,`update_time` FROM `ob_seo` WHERE `url` = 'index/specials/details' LIMIT 1 [ RunTime:0.000437s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_seo', 'type' => 'const', 'possible_keys' => 'url', 'key' => 'url', 'key_len' => '122', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SHOW COLUMNS FROM `ob_specials` [ RunTime:0.006648s ]
[ SQL ] SELECT * FROM `ob_specials` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000556s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_specials', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `a`.* FROM `ob_specials` `a` WHERE `id` = 1 AND `a`.`status` <> -1 LIMIT 1 [ RunTime:0.000569s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'a', 'type' => 'const', 'possible_keys' => 'PRIMARY,status', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] UPDATE `ob_specials` SET `pv`=333 WHERE `id` = 1 [ RunTime:0.038011s ]
[ SQL ] SHOW COLUMNS FROM `ob_line` [ RunTime:0.007370s ]
[ SQL ] SELECT `l`.*,r.name as cruise_name,s.name as supplier_name,c.name as category_name FROM `ob_line` `l` LEFT JOIN `ob_cruise` `r` ON `r`.`id`=`l`.`cruise_id` LEFT JOIN `ob_category` `c` ON `l`.`category_id`=`c`.`id` LEFT JOIN `ob_supplier` `s` ON `s`.`id`=`l`.`supplier_id` WHERE ( l.status=1 and l.id in (02,3,4) ) ORDER BY l.special_sort asc,l.list_sort asc,l.id desc LIMIT 20 [ RunTime:0.001123s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'l', 'type' => 'range', 'possible_keys' => 'PRIMARY,status', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => NULL, 'rows' => 3, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `ob_line_prices` [ RunTime:0.006380s ]
[ 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.001467s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_prices', 'type' => 'ref', 'possible_keys' => 'search_id,status,line_id,date,search_id2', 'key' => 'line_id', 'key_len' => '5', 'ref' => 'const', 'rows' => 10, 'extra' => 'Using where; Using filesort', ) ]
[ 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.001257s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_prices', 'type' => 'ref', 'possible_keys' => 'search_id,status,line_id,date,search_id2', 'key' => 'line_id', 'key_len' => '5', 'ref' => 'const', 'rows' => 10, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT sum(room_store) as room_store,sum(used_num) as used_num FROM `ob_line_prices` WHERE ( status=1 and line_id='4' and date='2002-05-06' ) LIMIT 1 [ RunTime:0.000447s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_prices', 'type' => 'ref', 'possible_keys' => 'search_id,status,line_id,date,search_id2', 'key' => 'search_id', 'key_len' => '8', 'ref' => 'const,const', 'rows' => 1, 'extra' => 'Using where', ) ]
[ SQL ] SHOW COLUMNS FROM `ob_line_destination` [ RunTime:0.006295s ]
[ 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.000692s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd', 'type' => 'index_merge', 'possible_keys' => 'search_id,line_id,city_id,is_start_did,status', 'key' => 'line_id,is_start_did', 'key_len' => '5,3', 'ref' => NULL, 'rows' => 1, 'extra' => 'Using intersect(line_id,is_start_did); Using where; Using temporary; Using filesort', ) ]
[ 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.000513s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd', 'type' => 'ref', 'possible_keys' => 'search_id,line_id,city_id,status', 'key' => 'search_id', 'key_len' => '5', 'ref' => 'const', 'rows' => 2, 'extra' => 'Using where; Using temporary; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `ob_line_pictures` [ RunTime:0.006193s ]
[ SQL ] SELECT * FROM `ob_line_pictures` WHERE `line_id` = 4 AND `status` = 1 ORDER BY list_sort asc [ RunTime:0.000473s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_pictures', 'type' => 'ref', 'possible_keys' => 'status,line_id', 'key' => 'line_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => 'Using where; Using filesort', ) ]
[ 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.001374s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_prices', 'type' => 'ref', 'possible_keys' => 'search_id,status,line_id,date,search_id2', 'key' => 'line_id', 'key_len' => '5', 'ref' => 'const', 'rows' => 10, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `ob_line_detail` [ RunTime:0.006258s ]
[ SQL ] SELECT `flags` FROM `ob_line_detail` WHERE ( aid='4' ) LIMIT 1 [ RunTime:0.000336s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_detail', 'type' => 'const', 'possible_keys' => 'aid', 'key' => 'aid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ 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.005610s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_prices', 'type' => 'ALL', 'possible_keys' => 'search_id,status,line_id,date,search_id2', 'key' => NULL, 'key_len' => NULL, 'ref' => NULL, 'rows' => 1863, 'extra' => 'Using where; Using filesort', ) ]
[ 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.001122s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_prices', 'type' => 'range', 'possible_keys' => 'search_id,status,line_id,date,search_id2', 'key' => 'date', 'key_len' => '3', 'ref' => NULL, 'rows' => 1863, 'extra' => 'Using where', ) ]
[ SQL ] SELECT sum(room_store) as room_store,sum(used_num) as used_num FROM `ob_line_prices` WHERE ( status=1 and line_id='3' and date='2002-05-06' ) LIMIT 1 [ RunTime:0.000429s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_prices', 'type' => 'ref', 'possible_keys' => 'search_id,status,line_id,date,search_id2', 'key' => 'search_id', 'key_len' => '8', 'ref' => 'const,const', 'rows' => 1, 'extra' => 'Using where', ) ]
[ 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='3' and d.is_start_did=1 ) GROUP BY d.city_id [ RunTime:0.000655s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd', 'type' => 'index_merge', 'possible_keys' => 'search_id,line_id,city_id,is_start_did,status', 'key' => 'line_id,is_start_did', 'key_len' => '5,3', 'ref' => NULL, 'rows' => 1, 'extra' => 'Using intersect(line_id,is_start_did); Using where; Using temporary; Using filesort', ) ]
[ 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='3' ) GROUP BY d.city_id [ RunTime:0.000530s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd', 'type' => 'ref', 'possible_keys' => 'search_id,line_id,city_id,status', 'key' => 'search_id', 'key_len' => '5', 'ref' => 'const', 'rows' => 5, 'extra' => 'Using where; Using temporary; Using filesort', ) ]
[ SQL ] SELECT * FROM `ob_line_pictures` WHERE `line_id` = 3 AND `status` = 1 ORDER BY list_sort asc [ RunTime:0.000463s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_pictures', 'type' => 'ref', 'possible_keys' => 'status,line_id', 'key' => 'line_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 6, 'extra' => 'Using where; Using filesort', ) ]
[ 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 20 [ RunTime:0.001275s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_prices', 'type' => 'range', 'possible_keys' => 'search_id,status,line_id,date,search_id2', 'key' => 'date', 'key_len' => '3', 'ref' => NULL, 'rows' => 1863, 'extra' => 'Using where', ) ]
[ SQL ] SELECT `flags` FROM `ob_line_detail` WHERE ( aid='3' ) LIMIT 1 [ RunTime:0.000296s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_detail', 'type' => 'const', 'possible_keys' => 'aid', 'key' => 'aid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ 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.001258s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_prices', 'type' => 'ref', 'possible_keys' => 'search_id,status,line_id,date,search_id2', 'key' => 'line_id', 'key_len' => '5', 'ref' => 'const', 'rows' => 10, 'extra' => 'Using where; Using filesort', ) ]
[ 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.001233s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_prices', 'type' => 'ref', 'possible_keys' => 'search_id,status,line_id,date,search_id2', 'key' => 'line_id', 'key_len' => '5', 'ref' => 'const', 'rows' => 10, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT sum(room_store) as room_store,sum(used_num) as used_num FROM `ob_line_prices` WHERE ( status=1 and line_id='2' and date='2002-05-06' ) LIMIT 1 [ RunTime:0.000414s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_prices', 'type' => 'ref', 'possible_keys' => 'search_id,status,line_id,date,search_id2', 'key' => 'search_id', 'key_len' => '8', 'ref' => 'const,const', 'rows' => 1, 'extra' => 'Using where', ) ]
[ 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='2' and d.is_start_did=1 ) GROUP BY d.city_id [ RunTime:0.000650s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd', 'type' => 'index_merge', 'possible_keys' => 'search_id,line_id,city_id,is_start_did,status', 'key' => 'line_id,is_start_did', 'key_len' => '5,3', 'ref' => NULL, 'rows' => 2, 'extra' => 'Using intersect(line_id,is_start_did); Using where; Using temporary; Using filesort', ) ]
[ 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='2' ) GROUP BY d.city_id [ RunTime:0.000556s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd', 'type' => 'ref', 'possible_keys' => 'search_id,line_id,city_id,status', 'key' => 'search_id', 'key_len' => '5', 'ref' => 'const', 'rows' => 10, 'extra' => 'Using where; Using temporary; Using filesort', ) ]
[ SQL ] SELECT * FROM `ob_line_pictures` WHERE `line_id` = 2 AND `status` = 1 ORDER BY list_sort asc [ RunTime:0.000467s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_pictures', 'type' => 'ref', 'possible_keys' => 'status,line_id', 'key' => 'line_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 11, 'extra' => 'Using where; Using filesort', ) ]
[ 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 20 [ RunTime:0.001277s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_prices', 'type' => 'ref', 'possible_keys' => 'search_id,status,line_id,date,search_id2', 'key' => 'line_id', 'key_len' => '5', 'ref' => 'const', 'rows' => 10, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `flags` FROM `ob_line_detail` WHERE ( aid='2' ) LIMIT 1 [ RunTime:0.000305s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_detail', 'type' => 'const', 'possible_keys' => 'aid', 'key' => 'aid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SELECT `l`.*,r.name as cruise_name,s.name as supplier_name,c.name as category_name FROM `ob_line` `l` LEFT JOIN `ob_cruise` `r` ON `r`.`id`=`l`.`cruise_id` LEFT JOIN `ob_category` `c` ON `l`.`category_id`=`c`.`id` LEFT JOIN `ob_supplier` `s` ON `s`.`id`=`l`.`supplier_id` WHERE ( l.status=1 and l.id in (05,6,7) ) ORDER BY l.special_sort asc,l.list_sort asc,l.id desc LIMIT 20 [ RunTime:0.001010s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'l', 'type' => 'range', 'possible_keys' => 'PRIMARY,status', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => NULL, 'rows' => 3, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='7' and date>='2002-05-06' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001302s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_prices', 'type' => 'ref', 'possible_keys' => 'search_id,status,line_id,date,search_id2', 'key' => 'line_id', 'key_len' => '5', 'ref' => 'const', 'rows' => 10, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='7' and date>='2002-05-06' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001224s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_prices', 'type' => 'ref', 'possible_keys' => 'search_id,status,line_id,date,search_id2', 'key' => 'line_id', 'key_len' => '5', 'ref' => 'const', 'rows' => 10, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT sum(room_store) as room_store,sum(used_num) as used_num FROM `ob_line_prices` WHERE ( status=1 and line_id='7' and date='2002-05-06' ) LIMIT 1 [ RunTime:0.000427s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_prices', 'type' => 'ref', 'possible_keys' => 'search_id,status,line_id,date,search_id2', 'key' => 'search_id', 'key_len' => '8', 'ref' => 'const,const', 'rows' => 1, 'extra' => 'Using where', ) ]
[ 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='7' and d.is_start_did=1 ) GROUP BY d.city_id [ RunTime:0.000629s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd', 'type' => 'index_merge', 'possible_keys' => 'search_id,line_id,city_id,is_start_did,status', 'key' => 'line_id,is_start_did', 'key_len' => '5,3', 'ref' => NULL, 'rows' => 1, 'extra' => 'Using intersect(line_id,is_start_did); Using where; Using temporary; Using filesort', ) ]
[ 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='7' ) GROUP BY d.city_id [ RunTime:0.000527s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd', 'type' => 'ref', 'possible_keys' => 'search_id,line_id,city_id,status', 'key' => 'search_id', 'key_len' => '5', 'ref' => 'const', 'rows' => 4, 'extra' => 'Using where; Using temporary; Using filesort', ) ]
[ SQL ] SELECT * FROM `ob_line_pictures` WHERE `line_id` = 7 AND `status` = 1 ORDER BY list_sort asc [ RunTime:0.000401s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_pictures', 'type' => 'ref', 'possible_keys' => 'status,line_id', 'key' => 'line_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT * FROM `ob_line_prices` WHERE ( status=1 and line_id='7' and date>='2002-05-06' ) ORDER BY date asc,id asc LIMIT 20 [ RunTime:0.001274s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_prices', 'type' => 'ref', 'possible_keys' => 'search_id,status,line_id,date,search_id2', 'key' => 'line_id', 'key_len' => '5', 'ref' => 'const', 'rows' => 10, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `flags` FROM `ob_line_detail` WHERE ( aid='7' ) LIMIT 1 [ RunTime:0.000298s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_detail', 'type' => 'const', 'possible_keys' => 'aid', 'key' => 'aid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ 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.001219s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_prices', 'type' => 'ref', 'possible_keys' => 'search_id,status,line_id,date,search_id2', 'key' => 'line_id', 'key_len' => '5', 'ref' => 'const', 'rows' => 10, 'extra' => 'Using where; Using filesort', ) ]
[ 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.001206s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_prices', 'type' => 'ref', 'possible_keys' => 'search_id,status,line_id,date,search_id2', 'key' => 'line_id', 'key_len' => '5', 'ref' => 'const', 'rows' => 10, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT sum(room_store) as room_store,sum(used_num) as used_num FROM `ob_line_prices` WHERE ( status=1 and line_id='6' and date='2002-05-06' ) LIMIT 1 [ RunTime:0.000405s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_prices', 'type' => 'ref', 'possible_keys' => 'search_id,status,line_id,date,search_id2', 'key' => 'search_id', 'key_len' => '8', 'ref' => 'const,const', 'rows' => 1, 'extra' => 'Using where', ) ]
[ 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='6' and d.is_start_did=1 ) GROUP BY d.city_id [ RunTime:0.000523s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd', 'type' => 'ref', 'possible_keys' => 'search_id,line_id,city_id,is_start_did,status', 'key' => 'search_id', 'key_len' => '5', 'ref' => 'const', 'rows' => 1, 'extra' => 'Using where; Using temporary; Using filesort', ) ]
[ 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='6' ) GROUP BY d.city_id [ RunTime:0.000488s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd', 'type' => 'ref', 'possible_keys' => 'search_id,line_id,city_id,status', 'key' => 'search_id', 'key_len' => '5', 'ref' => 'const', 'rows' => 1, 'extra' => 'Using where; Using temporary; Using filesort', ) ]
[ SQL ] SELECT * FROM `ob_line_pictures` WHERE `line_id` = 6 AND `status` = 1 ORDER BY list_sort asc [ RunTime:0.000403s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_pictures', 'type' => 'ref', 'possible_keys' => 'status,line_id', 'key' => 'line_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => 'Using where; Using filesort', ) ]
[ 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 20 [ RunTime:0.001250s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_prices', 'type' => 'ref', 'possible_keys' => 'search_id,status,line_id,date,search_id2', 'key' => 'line_id', 'key_len' => '5', 'ref' => 'const', 'rows' => 10, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `flags` FROM `ob_line_detail` WHERE ( aid='6' ) LIMIT 1 [ RunTime:0.000284s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_detail', 'type' => 'const', 'possible_keys' => 'aid', 'key' => 'aid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ 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.001213s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_prices', 'type' => 'ref', 'possible_keys' => 'search_id,status,line_id,date,search_id2', 'key' => 'line_id', 'key_len' => '5', 'ref' => 'const', 'rows' => 10, 'extra' => 'Using where; Using filesort', ) ]
[ 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.001221s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_prices', 'type' => 'ref', 'possible_keys' => 'search_id,status,line_id,date,search_id2', 'key' => 'line_id', 'key_len' => '5', 'ref' => 'const', 'rows' => 10, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT sum(room_store) as room_store,sum(used_num) as used_num FROM `ob_line_prices` WHERE ( status=1 and line_id='5' and date='2002-05-06' ) LIMIT 1 [ RunTime:0.000413s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_prices', 'type' => 'ref', 'possible_keys' => 'search_id,status,line_id,date,search_id2', 'key' => 'search_id', 'key_len' => '8', 'ref' => 'const,const', 'rows' => 1, 'extra' => 'Using where', ) ]
[ 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='5' and d.is_start_did=1 ) GROUP BY d.city_id [ RunTime:0.000633s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd', 'type' => 'index_merge', 'possible_keys' => 'search_id,line_id,city_id,is_start_did,status', 'key' => 'line_id,is_start_did', 'key_len' => '5,3', 'ref' => NULL, 'rows' => 2, 'extra' => 'Using intersect(line_id,is_start_did); Using where; Using temporary; Using filesort', ) ]
[ 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='5' ) GROUP BY d.city_id [ RunTime:0.000513s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'd', 'type' => 'ref', 'possible_keys' => 'search_id,line_id,city_id,status', 'key' => 'search_id', 'key_len' => '5', 'ref' => 'const', 'rows' => 11, 'extra' => 'Using where; Using temporary; Using filesort', ) ]
[ SQL ] SELECT * FROM `ob_line_pictures` WHERE `line_id` = 5 AND `status` = 1 ORDER BY list_sort asc [ RunTime:0.000405s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_pictures', 'type' => 'ref', 'possible_keys' => 'status,line_id', 'key' => 'line_id', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => 'Using where; Using filesort', ) ]
[ 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 20 [ RunTime:0.001259s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_prices', 'type' => 'ref', 'possible_keys' => 'search_id,status,line_id,date,search_id2', 'key' => 'line_id', 'key_len' => '5', 'ref' => 'const', 'rows' => 10, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SELECT `flags` FROM `ob_line_detail` WHERE ( aid='5' ) LIMIT 1 [ RunTime:0.000280s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_line_detail', 'type' => 'const', 'possible_keys' => 'aid', 'key' => 'aid', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SHOW COLUMNS FROM `ob_picture` [ RunTime:0.006372s ]
[ SQL ] SELECT `path`,`url` FROM `ob_picture` WHERE `id` = 261 LIMIT 1 [ RunTime:0.000363s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_picture', 'type' => 'const', 'possible_keys' => 'PRIMARY', 'key' => 'PRIMARY', 'key_len' => '4', 'ref' => 'const', 'rows' => 1, 'extra' => NULL, ) ]
[ SQL ] SHOW COLUMNS FROM `ob_ad_files` [ RunTime:0.006271s ]
[ SQL ] SELECT * FROM `ob_ad_files` WHERE `parent_id` = 10 ORDER BY sort asc,id asc LIMIT 1 [ RunTime:0.000499s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'ob_ad_files', 'type' => 'ref', 'possible_keys' => 'parent_id', 'key' => 'parent_id', 'key_len' => '5', 'ref' => 'const', 'rows' => 1, 'extra' => 'Using where; Using filesort', ) ]
[ SQL ] SHOW COLUMNS FROM `ob_blogroll` [ RunTime:0.006285s ]
[ 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.000632s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'f', 'type' => 'ref', 'possible_keys' => 'status,parent_id', 'key' => 'parent_id', 'key_len' => '5', 'ref' => 'const', 'rows' => 2, 'extra' => 'Using where; Using filesort', ) ]
[ 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.000585s ]
[ EXPLAIN : array ( 'id' => 1, 'select_type' => 'SIMPLE', 'table' => 'f', 'type' => 'ref', 'possible_keys' => 'status,parent_id', 'key' => 'parent_id', 'key_len' => '5', 'ref' => 'const', 'rows' => 3, 'extra' => 'Using where; Using filesort', ) ]

0.319601s