基本
文件
流程
错误
SQL
调试
- 请求信息 : 2002-05-19 03:10:27 HTTP/1.1 GET : youlun.qkphp.com/room/details/id/20.html
- 运行时间 : 0.223866s [ 吞吐率:4.47req/s ] 内存消耗:6,096.18kb 文件加载:83
- 查询信息 : 60 queries 0 writes
- 缓存信息 : 0 reads,0 writes
- 配置加载 : 126
- 会话信息 : SESSION_ID=hfpehmced46o47b65ooslblj34
- /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.89 KB )
- /tmp/mysqlsock ( 6.61 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/Room.php ( 1.43 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/Cruise.php ( 17.89 KB )
- /home/wwwroot/youlun/wwwroot/app/common/logic/CruiseExtend.php ( 6.67 KB )
- /home/wwwroot/youlun/wwwroot/app/common/model/Cruise.php ( 0.74 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/thinkphp/library/think/Url.php ( 12.97 KB )
- /home/wwwroot/youlun/wwwroot/app/common/model/LinePrices.php ( 0.75 KB )
- /home/wwwroot/youlun/wwwroot/app/common/model/LineDetail.php ( 0.75 KB )
- /home/wwwroot/youlun/wwwroot/runtime/temp/60e2a686e68d4775c7816567f3798c8a.php ( 17.99 KB )
- /home/wwwroot/youlun/wwwroot/app/index/widget/FriendLink.php ( 1.28 KB )
- /home/wwwroot/youlun/wwwroot/app/index/widget/WidgetBase.php ( 1.01 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.022747s ]
- [ BEHAVIOR ] Run app\common\behavior\InitHook @app_init [ RunTime:0.000552s ]
- [ LANG ] /home/wwwroot/youlun/wwwroot/thinkphp/lang/zh-cn.php
- [ ROUTE ] array (
'type' => 'module',
'module' =>
array (
0 => 'index',
1 => 'room',
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' => '*/*',
'accept-encoding' => 'gzip, br, zstd, deflate',
'cookie' => 'PHPSESSID=hfpehmced46o47b65ooslblj34',
'remote-host' => '18.118.193.7',
'x-forwarded-for' => '18.118.193.7, 127.0.0.1',
'x-real-ip' => '18.118.193.7',
'content-type' => '',
'content-length' => '',
)
- [ PARAM ] array (
'id' => '20',
)
- [ BEHAVIOR ] Run app\common\behavior\AppBegin @app_begin [ RunTime:0.000141s ]
- [ SESSION ] INIT array (
'id' => '',
'var_session_id' => '',
'prefix' => 'think',
'type' => '',
'auto_start' => true,
)
- [ RUN ] app\index\controller\Room->details[ /home/wwwroot/youlun/wwwroot/app/index/controller/Room.php ]
- [ VIEW ] /home/wwwroot/youlun/wwwroot/app/index/view/room/details.html [ array (
0 => 'VIEW_ROOT',
1 => 'loading_icon',
2 => 'pjax_mode',
3 => 'user_info',
4 => 'seo_info',
5 => 'info',
6 => 'line_list',
7 => 'other_list',
8 => 'extend',
) ]
- [ 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 => 'line_list',
7 => 'other_list',
8 => 'extend',
9 => '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 => 'line_list',
7 => 'other_list',
8 => 'extend',
9 => 'widget_data',
) ]
- [ BEHAVIOR ] Run app\common\behavior\AppEnd @app_end [ RunTime:0.000140s ]
- [ DB ] CONNECT:[ UseTime:0.000512s ] mysql:dbname=youlun;host=127.0.0.1;port=3306;charset=utf8
- [ SQL ] SHOW COLUMNS FROM `ob_seo` [ RunTime:0.005659s ]
- [ 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/room/details' LIMIT 1 [ RunTime:0.000458s ]
- [ 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_cruise_extend` [ RunTime:0.005673s ]
- [ SQL ] SELECT * FROM `ob_cruise_extend` WHERE `id` = 20 AND `type` = 'room' LIMIT 1 [ RunTime:0.000506s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'ob_cruise_extend',
'type' => 'const',
'possible_keys' => 'PRIMARY,type',
'key' => 'PRIMARY',
'key_len' => '4',
'ref' => 'const',
'rows' => 1,
'extra' => NULL,
) ]
- [ SQL ] SHOW COLUMNS FROM `ob_cruise` [ RunTime:0.005818s ]
- [ 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` = 5 AND `a`.`status` <> -1 LIMIT 1 [ RunTime:0.000701s ]
- [ 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 ] SHOW COLUMNS FROM `ob_line` [ RunTime:0.006292s ]
- [ 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.001081s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'ob_line',
'type' => 'ref',
'possible_keys' => 'status,pos',
'key' => 'status',
'key_len' => '1',
'ref' => 'const',
'rows' => 27,
'extra' => 'Using where; Using filesort',
) ]
- [ SQL ] SHOW COLUMNS FROM `ob_line_prices` [ RunTime:0.005554s ]
- [ 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.004894s ]
- [ 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-19' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001021s ]
- [ 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 * 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.004721s ]
- [ 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 ] SHOW COLUMNS FROM `ob_line_detail` [ RunTime:0.005470s ]
- [ SQL ] SELECT `flags` FROM `ob_line_detail` WHERE ( aid='3' ) LIMIT 1 [ RunTime:0.000304s ]
- [ 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='4' and date>='2002-05-19' ) 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='4' and date>='2002-05-19' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001092s ]
- [ 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-19' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001057s ]
- [ 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='4' ) LIMIT 1 [ RunTime:0.000251s ]
- [ 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-19' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001099s ]
- [ 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-19' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001066s ]
- [ 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-19' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001039s ]
- [ 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.000245s ]
- [ 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-19' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001081s ]
- [ 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-19' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001053s ]
- [ 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-19' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001039s ]
- [ 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.000259s ]
- [ 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='11' and date>='2002-05-19' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001084s ]
- [ 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='11' and date>='2002-05-19' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001054s ]
- [ 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='11' and date>='2002-05-19' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001055s ]
- [ 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='11' ) LIMIT 1 [ RunTime:0.000241s ]
- [ 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='12' and date>='2002-05-19' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001064s ]
- [ 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='12' and date>='2002-05-19' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001054s ]
- [ 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='12' and date>='2002-05-19' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001035s ]
- [ 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='12' ) LIMIT 1 [ RunTime:0.000235s ]
- [ 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='13' and date>='2002-05-19' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001075s ]
- [ 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='13' and date>='2002-05-19' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001056s ]
- [ 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='13' and date>='2002-05-19' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001036s ]
- [ 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='13' ) LIMIT 1 [ RunTime:0.000235s ]
- [ 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='17' and date>='2002-05-19' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001063s ]
- [ 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='17' and date>='2002-05-19' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001053s ]
- [ 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='17' and date>='2002-05-19' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001054s ]
- [ 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='17' ) LIMIT 1 [ RunTime:0.000243s ]
- [ 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='18' and date>='2002-05-19' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001064s ]
- [ 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='18' and date>='2002-05-19' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001054s ]
- [ 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='18' and date>='2002-05-19' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001036s ]
- [ 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='18' ) LIMIT 1 [ RunTime:0.000240s ]
- [ 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='30' and date>='2002-05-19' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001093s ]
- [ 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='30' and date>='2002-05-19' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001083s ]
- [ 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='30' and date>='2002-05-19' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001068s ]
- [ 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='30' ) LIMIT 1 [ RunTime:0.000241s ]
- [ 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-19' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001076s ]
- [ 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-19' ) ORDER BY date asc,id asc LIMIT 1 [ RunTime:0.001057s ]
- [ 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-19' ) ORDER BY date desc,id asc LIMIT 1 [ RunTime:0.001037s ]
- [ 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.000252s ]
- [ 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_cruise_extend` WHERE `id` <> 20 AND `type` = 'room' AND `cruise_id` = 5 [ RunTime:0.000530s ]
- [ EXPLAIN : array (
'id' => 1,
'select_type' => 'SIMPLE',
'table' => 'ob_cruise_extend',
'type' => 'ref',
'possible_keys' => 'PRIMARY,search_id,type,cruise_id',
'key' => 'search_id',
'key_len' => '98',
'ref' => 'const,const',
'rows' => 4,
'extra' => 'Using index condition',
) ]
- [ SQL ] SHOW COLUMNS FROM `ob_picture` [ RunTime:0.005495s ]
- [ SQL ] SELECT `path`,`url` FROM `ob_picture` WHERE `id` = 261 LIMIT 1 [ RunTime:0.000319s ]
- [ 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_blogroll` [ RunTime:0.005401s ]
- [ 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.000557s ]
- [ 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.000537s ]
- [ 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.225900s