ギャラリー

TOP ギャラリー
376.14msRequest Duration12.5MBMemory UsageGET gallery/index/{groups_id?}/{yyyy?}RouteGuestAuth status
    • Booting (12.28ms)
    • Application (367.95ms)
      5 templates were rendered
      • front.gallery.index (resources/views/front/gallery/index.blade.php)8blade
        Params
        0
        groups_id
        1
        nav_on
        2
        matches
        3
        leagues
        4
        yyyy
        5
        groups
        6
        groupings
        7
        default_period
      • front.parts.side (resources/views/front/parts/side.blade.php)19blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        groups_id
        5
        nav_on
        6
        matches
        7
        leagues
        8
        yyyy
        9
        groups
        10
        groupings
        11
        default_period
        12
        page_title
        13
        year
        14
        __empty_1
        15
        league
        16
        __empty_2
        17
        match
        18
        photo
      • layouts.front (resources/views/layouts/front.blade.php)19blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        groups_id
        5
        nav_on
        6
        matches
        7
        leagues
        8
        yyyy
        9
        groups
        10
        groupings
        11
        default_period
        12
        page_title
        13
        year
        14
        __empty_1
        15
        league
        16
        __empty_2
        17
        match
        18
        photo
      • layouts.front.parts.header (resources/views/layouts/front/parts/header.blade.php)19blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        groups_id
        5
        nav_on
        6
        matches
        7
        leagues
        8
        yyyy
        9
        groups
        10
        groupings
        11
        default_period
        12
        page_title
        13
        year
        14
        __empty_1
        15
        league
        16
        __empty_2
        17
        match
        18
        photo
      • layouts.front.parts.footer (resources/views/layouts/front/parts/footer.blade.php)19blade
        Params
        0
        obLevel
        1
        __env
        2
        app
        3
        errors
        4
        groups_id
        5
        nav_on
        6
        matches
        7
        leagues
        8
        yyyy
        9
        groups
        10
        groupings
        11
        default_period
        12
        page_title
        13
        year
        14
        __empty_1
        15
        league
        16
        __empty_2
        17
        match
        18
        photo
      uri
      GET gallery/index/{groups_id?}/{yyyy?}
      as
      front.gallery.index
      controller
      App\Http\Controllers\Front\GalleryController@index
      namespace
      App\Http\Controllers
      prefix
      null
      where
      file
      app/Http/Controllers/Front/GalleryController.php:24-68
      25 statements were executed, 4 of which were duplicated, 21 unique345.81ms
      • select * from `groups` where `groups`.`id` = '42' limit 1220μs/app/Http/Controllers/Front/GalleryController.php:33greencard12_teamdb
        Metadata
        Bindings
        • 0. 42
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 18. /app/Http/Controllers/Front/GalleryController.php:33
        • 19. /app/Http/Controllers/Front/GalleryController.php:33
        • 68. /public/index.php:54
      • select * from `leagues` where `leagues`.`deleted_at` is null and `year` = '2023' and `group_id` in ('42') and `convention` = '16'130μs/app/Http/Controllers/Front/GalleryController.php:49greencard12_teamdb
        Metadata
        Bindings
        • 0. 2023
        • 1. 42
        • 2. 16
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 11. /app/Http/Controllers/Front/GalleryController.php:49
        • 60. /public/index.php:54
      • select `id` from `leagues` where `leagues`.`deleted_at` is null and `year` = '2023' and `group_id` in ('42') and `convention` = '16'70μs/app/Http/Controllers/Front/GalleryController.php:51greencard12_teamdb
        Metadata
        Bindings
        • 0. 2023
        • 1. 42
        • 2. 16
        Backtrace
        • 11. /app/Http/Controllers/Front/GalleryController.php:51
        • 60. /public/index.php:54
      • select count(*) as aggregate from `matches` where `matches`.`deleted_at` is null and `leagues_id` in ('45') and (select count(*) from `match_photos` where `match_photos`.`match_id` = `matches`.`id`) >= 182.57ms/app/Http/Controllers/Front/GalleryController.php:59greencard12_teamdb
        Metadata
        Bindings
        • 0. 45
        Backtrace
        • 11. /app/Http/Controllers/Front/GalleryController.php:59
        • 60. /public/index.php:54
      • select * from `matches` where `matches`.`deleted_at` is null and `leagues_id` in ('45') and (select count(*) from `match_photos` where `match_photos`.`match_id` = `matches`.`id`) >= 1 order by `match_at` desc limit 10 offset 2089.5ms/app/Http/Controllers/Front/GalleryController.php:59greencard12_teamdb
        Metadata
        Bindings
        • 0. 45
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 12. /app/Http/Controllers/Front/GalleryController.php:59
        • 61. /public/index.php:54
      • select count(*) as aggregate from `matches` where `matches`.`deleted_at` is null and `leagues_id` = '45' and (select count(*) from `match_photos` where `match_photos`.`match_id` = `matches`.`id`) >= 185.02ms/app/Http/Controllers/Front/GalleryController.php:62greencard12_teamdb
        Metadata
        Bindings
        • 0. 45
        Backtrace
        • 11. /app/Http/Controllers/Front/GalleryController.php:62
        • 60. /public/index.php:54
      • select * from `matches` where `matches`.`deleted_at` is null and `leagues_id` = '45' and (select count(*) from `match_photos` where `match_photos`.`match_id` = `matches`.`id`) >= 1 order by `match_at` desc limit 10 offset 2084.98ms/app/Http/Controllers/Front/GalleryController.php:62greencard12_teamdb
        Metadata
        Bindings
        • 0. 45
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 12. /app/Http/Controllers/Front/GalleryController.php:62
        • 61. /public/index.php:54
      • select * from `groups` where `groups`.`id` = '42' and `groups`.`id` is not null limit 1930μsview::front.gallery.index:98greencard12_teamdb
        Metadata
        Bindings
        • 0. 42
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 17. view::front.gallery.index:98
        • 24. /vendor/symfony/http-foundation/Response.php:202
        • 71. /public/index.php:54
      • select * from `teams` where `teams`.`deleted_at` is null and `teams`.`id` = '54' and `teams`.`id` is not null limit 1260μsview::front.gallery.index:104greencard12_teamdb
        Metadata
        Bindings
        • 0. 54
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 17. view::front.gallery.index:104
        • 24. /vendor/symfony/http-foundation/Response.php:202
        • 71. /public/index.php:54
      • select * from `teams` where `teams`.`deleted_at` is null and `teams`.`id` = '290' and `teams`.`id` is not null limit 1200μsview::front.gallery.index:108greencard12_teamdb
        Metadata
        Bindings
        • 0. 290
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 17. view::front.gallery.index:108
        • 24. /vendor/symfony/http-foundation/Response.php:202
        • 71. /public/index.php:54
      • select * from `leagues` where `leagues`.`deleted_at` is null and `leagues`.`id` = '45' and `leagues`.`id` is not null limit 1110μsview::front.gallery.index:110greencard12_teamdb
        Metadata
        Bindings
        • 0. 45
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 17. view::front.gallery.index:110
        • 24. /vendor/symfony/http-foundation/Response.php:202
        • 71. /public/index.php:54
      • select * from `match_photos` where `match_photos`.`match_id` = '1492' and `match_photos`.`match_id` is not null90μsview::front.gallery.index:113greencard12_teamdb
        Metadata
        Bindings
        • 0. 1492
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 16. view::front.gallery.index:113
        • 23. /vendor/symfony/http-foundation/Response.php:202
        • 70. /public/index.php:54
      • select * from `teams` where `teams`.`deleted_at` is null and `teams`.`id` = '62' and `teams`.`id` is not null limit 1210μsview::front.gallery.index:104greencard12_teamdb
        Metadata
        Bindings
        • 0. 62
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 17. view::front.gallery.index:104
        • 24. /vendor/symfony/http-foundation/Response.php:202
        • 71. /public/index.php:54
      • select * from `teams` where `teams`.`deleted_at` is null and `teams`.`id` = '63' and `teams`.`id` is not null limit 1190μsview::front.gallery.index:108greencard12_teamdb
        Metadata
        Bindings
        • 0. 63
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 17. view::front.gallery.index:108
        • 24. /vendor/symfony/http-foundation/Response.php:202
        • 71. /public/index.php:54
      • select * from `leagues` where `leagues`.`deleted_at` is null and `leagues`.`id` = '45' and `leagues`.`id` is not null limit 190μsview::front.gallery.index:110greencard12_teamdb
        Metadata
        Bindings
        • 0. 45
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 17. view::front.gallery.index:110
        • 24. /vendor/symfony/http-foundation/Response.php:202
        • 71. /public/index.php:54
      • select * from `match_photos` where `match_photos`.`match_id` = '1489' and `match_photos`.`match_id` is not null90μsview::front.gallery.index:113greencard12_teamdb
        Metadata
        Bindings
        • 0. 1489
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 16. view::front.gallery.index:113
        • 23. /vendor/symfony/http-foundation/Response.php:202
        • 70. /public/index.php:54
      • select * from `teams` where `teams`.`deleted_at` is null and `teams`.`id` = '56' and `teams`.`id` is not null limit 1190μsview::front.gallery.index:104greencard12_teamdb
        Metadata
        Bindings
        • 0. 56
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 17. view::front.gallery.index:104
        • 24. /vendor/symfony/http-foundation/Response.php:202
        • 71. /public/index.php:54
      • select * from `teams` where `teams`.`deleted_at` is null and `teams`.`id` = '289' and `teams`.`id` is not null limit 1180μsview::front.gallery.index:108greencard12_teamdb
        Metadata
        Bindings
        • 0. 289
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 17. view::front.gallery.index:108
        • 24. /vendor/symfony/http-foundation/Response.php:202
        • 71. /public/index.php:54
      • select * from `leagues` where `leagues`.`deleted_at` is null and `leagues`.`id` = '45' and `leagues`.`id` is not null limit 190μsview::front.gallery.index:110greencard12_teamdb
        Metadata
        Bindings
        • 0. 45
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 17. view::front.gallery.index:110
        • 24. /vendor/symfony/http-foundation/Response.php:202
        • 71. /public/index.php:54
      • select * from `match_photos` where `match_photos`.`match_id` = '1491' and `match_photos`.`match_id` is not null70μsview::front.gallery.index:113greencard12_teamdb
        Metadata
        Bindings
        • 0. 1491
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 16. view::front.gallery.index:113
        • 23. /vendor/symfony/http-foundation/Response.php:202
        • 70. /public/index.php:54
      • select * from `teams` where `teams`.`deleted_at` is null and `teams`.`id` = '292' and `teams`.`id` is not null limit 1190μsview::front.gallery.index:104greencard12_teamdb
        Metadata
        Bindings
        • 0. 292
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 17. view::front.gallery.index:104
        • 24. /vendor/symfony/http-foundation/Response.php:202
        • 71. /public/index.php:54
      • select * from `teams` where `teams`.`deleted_at` is null and `teams`.`id` = '293' and `teams`.`id` is not null limit 1180μsview::front.gallery.index:108greencard12_teamdb
        Metadata
        Bindings
        • 0. 293
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 17. view::front.gallery.index:108
        • 24. /vendor/symfony/http-foundation/Response.php:202
        • 71. /public/index.php:54
      • select * from `leagues` where `leagues`.`deleted_at` is null and `leagues`.`id` = '45' and `leagues`.`id` is not null limit 190μsview::front.gallery.index:110greencard12_teamdb
        Metadata
        Bindings
        • 0. 45
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 17. view::front.gallery.index:110
        • 24. /vendor/symfony/http-foundation/Response.php:202
        • 71. /public/index.php:54
      • select * from `match_photos` where `match_photos`.`match_id` = '1488' and `match_photos`.`match_id` is not null80μsview::front.gallery.index:113greencard12_teamdb
        Metadata
        Bindings
        • 0. 1488
        Hints
        • Use SELECT * only if you need all columns from table
        Backtrace
        • 16. view::front.gallery.index:113
        • 23. /vendor/symfony/http-foundation/Response.php:202
        • 70. /public/index.php:54
      • select * from `groups` where `convention` = '16' limit 180μsview::layouts.front.parts.header:103greencard12_teamdb
        Metadata
        Bindings
        • 0. 16
        Hints
        • Use SELECT * only if you need all columns from table
        • LIMIT without ORDER BY causes non-deterministic results, depending on the query execution plan
        Backtrace
        • 12. view::layouts.front.parts.header:103
        • 18. view::layouts.front:1
        • 24. view::front.gallery.index:148
        • 31. /vendor/symfony/http-foundation/Response.php:202
        • 78. /public/index.php:54
        guest
        true
          _token
          m9jeVF4SbS22sjnCrpQOBpimdPhHqYwKdZdLWU1V
          PHPDEBUGBAR_STACK_DATA
          []
          format
          html
          content_type
          text/html; charset=UTF-8
          status_text
          OK
          status_code
          200
          request_query
          array:1 [ "page" => "3" ]
          request_request
          array:1 [ "page" => "3" ]
          request_headers
          array:27 [ "priority" => array:1 [ 0 => "u=0, i" ] "sec-fetch-dest" => array:1 [ 0 => ...
          request_server
          array:68 [ "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin" "PWD" => "/home/userfas...
          request_cookies
          []
          response_headers
          array:3 [ "cache-control" => array:1 [ 0 => "no-cache" ] "date" => array:1 [ 0 => "Sat...
          path_info
          /gallery/index/85/2023
          session_attributes
          array:2 [ "_token" => "m9jeVF4SbS22sjnCrpQOBpimdPhHqYwKdZdLWU1V" "PHPDEBUGBAR_STACK_DATA" => [] ...