海景阳台房
楼层:5
容纳:3
消费:免费
海景阳台房
基本
文件
流程
错误
SQL
调试
- 请求信息 : 2002-05-19 03:10:33 HTTP/1.1 GET : youlun.qkphp.com/room/details/id/19.html
- 运行时间 : 0.211725s [ 吞吐率:4.72req/s ] 内存消耗:6,075.94kb 文件加载: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.021831s ]
- [ BEHAVIOR ] Run app\common\behavior\InitHook @app_init [ RunTime:0.000558s ]
- [ 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' => '19',
)
- [ BEHAVIOR ] Run app\common\behavior\AppBegin @app_begin [ RunTime:0.000129s ]
- [ 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.000124s ]
- [ DB ] CONNECT:[ UseTime:0.000482s ] mysql:dbname=youlun;host=127.0.0.1;port=3306;charset=utf8
- [ SQL ] SHOW COLUMNS FROM `ob_seo` [ RunTime:0.005668s ]
- [ 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.000457s ]
- [ 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.005681s ]
- [ SQL ] SELECT * FROM `ob_cruise_extend` WHERE `id` = 19 AND `type` = 'room' LIMIT 1 [ RunTime:0.000486s ]
- [ 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.005844s ]
- [ 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` = 3 AND `a`.`status` <> -1 LIMIT 1 [ RunTime:0.000730s ]
- [ 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.006355s ]
- [ 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.001115s ]
- [ 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.005555s ]
- [ 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.004942s ]
- [ 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.001000s ]
- [ 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.004736s ]
- [ 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.005474s ]
- [ SQL ] SELECT `flags` FROM `ob_line_detail` WHERE ( aid='3' ) 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='4' and date>='2002-05-19' ) ORDER BY price asc,id asc LIMIT 1 [ RunTime:0.001079s ]
- [ 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.000968s ]
- [ 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.000935s ]
- [ 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.000223s ]
- [ 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.000968s ]
- [ 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.000936s ]
- [ 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.000922s ]
- [ 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.000222s ]
- [ 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.000949s ]
- [ 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.000929s ]
- [ 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.000914s ]
- [ 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.000209s ]
- [ 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.000957s ]
- [ 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.000940s ]
- [ 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.000910s ]
- [ 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.000219s ]
- [ 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.000944s ]
- [ 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.000924s ]
- [ 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.000909s ]
- [ 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.000213s ]
- [ 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.000939s ]
- [ 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.000925s ]
- [ 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.000909s ]
- [ 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.000213s ]
- [ 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.000938s ]
- [ 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.000923s ]
- [ 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.000918s ]
- [ 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.000217s ]
- [ 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.000942s ]
- [ 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.000928s ]
- [ 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.000909s ]
- [ 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.000208s ]
- [ 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.000968s ]
- [ 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.000946s ]
- [ 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.000936s ]
- [ 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.000209s ]
- [ 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.000947s ]
- [ 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.000921s ]
- [ 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.000896s ]
- [ 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.000211s ]
- [ 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` <> 19 AND `type` = 'room' AND `cruise_id` = 3 [ RunTime:0.000441s ]
- [ 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' => 1,
'extra' => 'Using index condition',
) ]
- [ SQL ] SHOW COLUMNS FROM `ob_picture` [ RunTime:0.004910s ]
- [ SQL ] SELECT `path`,`url` FROM `ob_picture` WHERE `id` = 261 LIMIT 1 [ RunTime:0.000298s ]
- [ 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.004754s ]
- [ 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.000497s ]
- [ 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.000459s ]
- [ 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.213536s