Наверх
К началу
Request history8.3.13PHP Version459msRequest Duration151MBMemory UsageGET {type}/set/{letter}/{slug}Route
  • warninglog[20:02:13] LOG.warning: Creation of dynamic property App\Services\ManticoreService::$language is dep...
  • warninglog[20:02:13] LOG.warning: Creation of dynamic property App\Services\SerializerService::$gHost is depre...
  • warninglog[20:02:13] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:13] LOG.warning: Creation of dynamic property App\Repositories\MovieRepository::$cacheService...
  • warninglog[20:02:13] LOG.warning: Creation of dynamic property App\Services\SerializerService::$gHost is depre...
  • warninglog[20:02:13] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\ManticoreService::$language is dep...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\SerializerService::$gHost is depre...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Repositories\SetRepository::$cacheService i...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\ManticoreService::$language is dep...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\SerializerService::$gHost is depre...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Repositories\MovieRepository::$cacheService...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[20:02:14] LOG.warning: preg_match(): Passing null to parameter #2 ($subject) of type string is depr...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[20:02:14] LOG.warning: preg_match(): Passing null to parameter #2 ($subject) of type string is depr...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[20:02:14] LOG.warning: preg_match(): Passing null to parameter #2 ($subject) of type string is depr...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[20:02:14] LOG.warning: preg_match(): Passing null to parameter #2 ($subject) of type string is depr...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[20:02:14] LOG.warning: preg_match(): Passing null to parameter #2 ($subject) of type string is depr...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[20:02:14] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • Booting (102ms)time
  • Application (357ms)time
  • 1 x Application (77.77%)
    357ms
    1 x Booting (22.22%)
    102ms
    71 templates were rendered
    • 1x setMoviessetMovies.blade.php#?blade
    • 1x components.metameta.blade.php#?blade
    • 1x components.breadcrumbsbreadcrumbs.blade.php#?blade
    • 1x components.metascopemetascope.blade.php#?blade
    • 1x components.filterfilter.blade.php#?blade
    • 1x components.sort-blocksort-block.blade.php#?blade
    • 1x components.top-componenttop-component.blade.php#?blade
    • 55x each.moviemovie.blade.php#?blade
    • 1x components.paginationpagination.blade.php#?blade
    • 1x layouts.mainmain.blade.php#?blade
    • 1x adsads.blade.php#?blade
    • 1x components.sidebar.header-menuheader-menu.blade.php#?blade
    • 1x parts.search_blocksearch_block.blade.php#?blade
    • 1x components.sidebar.collection-categoriescollection-categories.blade.php#?blade
    • 1x components.sidebar.alphabetic-categoriesalphabetic-categories.blade.php#?blade
    • 1x components.sidebar.recent-commentsrecent-comments.blade.php#?blade
    • 1x components.sidebar.genresgenres.blade.php#?blade
    uri
    GET {type}/set/{letter}/{slug}
    middleware
    web
    controller
    App\Http\Controllers\SetController@show
    namespace
    App\Http\Controllers
    prefix
    where
    as
    set
    file
    app/Http/Controllers/SetController.php:117-297
    19 statements were executed53.34ms
    • Connection EstablishedManticoreService.php#13
      Backtrace
      • 8. app/Services/ManticoreService.php:13
      • 10. vendor/laravel/framework/src/Illuminate/Container/Container.php:944
      • 11. vendor/laravel/framework/src/Illuminate/Container/Container.php:787
      • 12. vendor/laravel/framework/src/Illuminate/Foundation/Application.php:1041
      • 13. vendor/laravel/framework/src/Illuminate/Container/Container.php:723
    • select * from `movie_comments` where `display` = 1 order by `comment_id` desc limit 12
      530μstopkinopro_dbController.php#168
      Bindings
      • 0: 1
      Backtrace
      • 15. app/Http/Controllers/Controller.php:168
      • 17. vendor/laravel/framework/src/Illuminate/Container/Container.php:944
      • 18. vendor/laravel/framework/src/Illuminate/Container/Container.php:787
      • 19. vendor/laravel/framework/src/Illuminate/Foundation/Application.php:1041
      • 20. vendor/laravel/framework/src/Illuminate/Container/Container.php:723
    • select `id`, `type`, `name`, `slug` from `movies` where 0 = 1
      270μstopkinopro_dbController.php#175
      Backtrace
      • 15. app/Http/Controllers/Controller.php:175
      • 17. vendor/laravel/framework/src/Illuminate/Container/Container.php:944
      • 18. vendor/laravel/framework/src/Illuminate/Container/Container.php:787
      • 19. vendor/laravel/framework/src/Illuminate/Foundation/Application.php:1041
      • 20. vendor/laravel/framework/src/Illuminate/Container/Container.php:723
    • select * from `sets` where `type` = 'movie' and `slug` = '1978-god' limit 1
      1.23mstopkinopro_dbSetController.php#143
      Bindings
      • 0: movie
      • 1: 1978-god
      Backtrace
      • 16. app/Http/Controllers/SetController.php:143
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Route.php:206
    • select max(update_timestamp) as time from `movie_rt` where sets_ids = 4371 limit 1
      2.22msSetRepository.php#103
      Backtrace
      • 14. app/Repositories/SetRepository.php:103
      • 15. app/Http/Controllers/SetController.php:205
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select count(*) as aggregate from `movie_rt` where sets_ids = 4371
      1.21msSetRepository.php#106
      Backtrace
      • 15. app/Repositories/SetRepository.php:106
      • 16. app/Http/Controllers/SetController.php:205
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select *, WEIGHT() as rank from `movie_rt` where sets_ids = 4371 and MATCH('"1978 год"') order by `rank` desc limit 100 offset 0
      10.75msSetRepository.php#142
      Backtrace
      • 13. app/Repositories/SetRepository.php:142
      • 14. app/Http/Controllers/SetController.php:205
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `movies` where `id` in (1235288, 1287542, 8435, 54875, 395773, 1449368, 637, 450204, 3984, 4758, 439917, 1402624, 913483, 15285, 350, 837552, 4079, 992558, 477824, 15943, 14130, 14527, 1238532, 573209, 102838, 820608, 61450, 102284, 94230, 46980, 726805, 1044045, 484771, 463577, 404232, 271751, 959372, 577764, 818981, 794704, 1096140, 596215, 391751, 1183563, 586418, 450345, 279048, 114750, 667970, 1929, 49336, 445637, 499095, 77137, 910240) order by FIELD(id, 1235288,1287542,8435,54875,395773,1449368,637,450204,3984,4758,439917,1402624,913483,15285,350,837552,4079,992558,477824,15943,14130,14527,1238532,573209,102838,820608,61450,102284,94230,46980,726805,1044045,484771,463577,404232,271751,959372,577764,818981,794704,1096140,596215,391751,1183563,586418,450345,279048,114750,667970,1929,49336,445637,499095,77137,910240)
      1.3mstopkinopro_dbSetRepository.php#149
      Bindings
      • 0: 1235288
      • 1: 1287542
      • 2: 8435
      • 3: 54875
      • 4: 395773
      • 5: 1449368
      • 6: 637
      • 7: 450204
      • 8: 3984
      • 9: 4758
      • 10: 439917
      • 11: 1402624
      • 12: 913483
      • 13: 15285
      • 14: 350
      • 15: 837552
      • 16: 4079
      • 17: 992558
      • 18: 477824
      • 19: 15943
      • 20: 14130
      • 21: 14527
      • 22: 1238532
      • 23: 573209
      • 24: 102838
      • 25: 820608
      • 26: 61450
      • 27: 102284
      • 28: 94230
      • 29: 46980
      • 30: 726805
      • 31: 1044045
      • 32: 484771
      • 33: 463577
      • 34: 404232
      • 35: 271751
      • 36: 959372
      • 37: 577764
      • 38: 818981
      • 39: 794704
      • 40: 1096140
      • 41: 596215
      • 42: 391751
      • 43: 1183563
      • 44: 586418
      • 45: 450345
      • 46: 279048
      • 47: 114750
      • 48: 667970
      • 49: 1929
      • 50: 49336
      • 51: 445637
      • 52: 499095
      • 53: 77137
      • 54: 910240
      Backtrace
      • 15. app/Repositories/SetRepository.php:149
      • 16. app/Http/Controllers/SetController.php:205
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `genres`.*, `movie_genres`.`movie_id` as `pivot_movie_id`, `movie_genres`.`genre_id` as `pivot_genre_id` from `genres` inner join `movie_genres` on `genres`.`id` = `movie_genres`.`genre_id` where `movie_genres`.`movie_id` in (350, 637, 1929, 3984, 4079, 4758, 8435, 14130, 14527, 15285, 15943, 46980, 49336, 54875, 61450, 77137, 94230, 102284, 102838, 114750, 271751, 279048, 391751, 395773, 404232, 439917, 445637, 450204, 450345, 463577, 477824, 484771, 499095, 573209, 577764, 586418, 596215, 667970, 726805, 794704, 818981, 820608, 837552, 910240, 913483, 959372, 992558, 1044045, 1096140, 1183563, 1235288, 1238532, 1287542, 1402624, 1449368)
      1.62mstopkinopro_dbSetRepository.php#149
      Backtrace
      • 19. app/Repositories/SetRepository.php:149
      • 20. app/Http/Controllers/SetController.php:205
      • 21. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 22. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `descriptions` where `descriptions`.`movie_id` in (350, 637, 1929, 3984, 4079, 4758, 8435, 14130, 14527, 15285, 15943, 46980, 49336, 54875, 61450, 77137, 94230, 102284, 102838, 114750, 271751, 279048, 391751, 395773, 404232, 439917, 445637, 450204, 450345, 463577, 477824, 484771, 499095, 573209, 577764, 586418, 596215, 667970, 726805, 794704, 818981, 820608, 837552, 910240, 913483, 959372, 992558, 1044045, 1096140, 1183563, 1235288, 1238532, 1287542, 1402624, 1449368)
      10.85mstopkinopro_dbSetRepository.php#149
      Backtrace
      • 20. app/Repositories/SetRepository.php:149
      • 21. app/Http/Controllers/SetController.php:205
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `countries`.`code`, `countries`.`name`, COUNT(movies.id) as movie_count from `movies` inner join `set_movies` on `movies`.`id` = `set_movies`.`movie_id` inner join `sets` on `set_movies`.`set_id` = `sets`.`id` inner join `movie_countries` on `movies`.`id` = `movie_countries`.`movie_id` inner join `countries` on `movie_countries`.`country_id` = `countries`.`id` where `sets`.`id` = 4371 and `countries`.`type` = 'movie' group by `countries`.`code` having COUNT(movies.id) >= '3'
      12.12mstopkinopro_dbSetRepository.php#197
      Bindings
      • 0: 4371
      • 1: movie
      • 2: 3
      Backtrace
      • 15. app/Repositories/SetRepository.php:197
      • 16. app/Http/Controllers/SetController.php:212
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `genres`.`slug`, `genres`.`name`, COUNT(movies.id) as movie_count from `movies` inner join `set_movies` on `movies`.`id` = `set_movies`.`movie_id` inner join `sets` on `set_movies`.`set_id` = `sets`.`id` inner join `movie_countries` on `movies`.`id` = `movie_countries`.`movie_id` inner join `countries` on `movie_countries`.`country_id` = `countries`.`id` inner join `movie_genres` on `movies`.`id` = `movie_genres`.`movie_id` inner join `genres` on `movie_genres`.`genre_id` = `genres`.`id` where `sets`.`id` = 4371 and `countries`.`type` = 'movie' group by `genres`.`slug` having COUNT(movies.id) >= '3'
      1.89mstopkinopro_dbSetRepository.php#221
      Bindings
      • 0: 4371
      • 1: movie
      • 2: 3
      Backtrace
      • 15. app/Repositories/SetRepository.php:221
      • 16. app/Http/Controllers/SetController.php:214
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select movies.year, COUNT(DISTINCT movies.id) as movie_count from `movies` inner join `set_movies` on `movies`.`id` = `set_movies`.`movie_id` inner join `movie_countries` on `movies`.`id` = `movie_countries`.`movie_id` inner join `movie_genres` on `movies`.`id` = `movie_genres`.`movie_id` inner join `sets` on `sets`.`id` = `set_movies`.`set_id` where `sets`.`type` = 'movie' and `set_movies`.`set_id` = 4371 group by `movies`.`year` having COUNT(movies.id) >= '3' order by `movies`.`year` desc
      1.19mstopkinopro_dbSetRepository.php#247
      Bindings
      • 0: movie
      • 1: 4371
      • 2: 3
      Backtrace
      • 15. app/Repositories/SetRepository.php:247
      • 16. app/Http/Controllers/SetController.php:216
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 18. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 19. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `movie_id` from `movie_rt` where `sets_ids` = 4371 order by RAND() limit 1
      1.79msMovieRepository.php#319
      Bindings
      • 0: 4371
      Backtrace
      • 14. app/Repositories/MovieRepository.php:319
      • 15. app/Http/Controllers/SetController.php:230
      • 16. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 17. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 18. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `movies` where `movies`.`id` = 14130 limit 1
      310μstopkinopro_dbMovieRepository.php#320
      Bindings
      • 0: 14130
      Backtrace
      • 20. app/Repositories/MovieRepository.php:320
      • 21. app/Http/Controllers/SetController.php:230
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select `genres`.*, `movie_genres`.`movie_id` as `pivot_movie_id`, `movie_genres`.`genre_id` as `pivot_genre_id` from `genres` inner join `movie_genres` on `genres`.`id` = `movie_genres`.`genre_id` where `movie_genres`.`movie_id` = 14130
      310μstopkinopro_dbSerializerService.php#125
      Bindings
      • 0: 14130
      Backtrace
      • 20. app/Services/SerializerService.php:125
      • 21. app/Repositories/MovieRepository.php:322
      • 22. app/Http/Controllers/SetController.php:230
      • 23. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 24. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select * from `descriptions` where `descriptions`.`movie_id` = 14130 and `descriptions`.`movie_id` is not null limit 1
      230μstopkinopro_dbSerializerService.php#135
      Bindings
      • 0: 14130
      Backtrace
      • 22. app/Services/SerializerService.php:135
      • 23. app/Repositories/MovieRepository.php:322
      • 24. app/Http/Controllers/SetController.php:230
      • 25. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 26. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
    • select `sets_ids` from `movie_rt` where sets_ids > 0 order by RAND()
      5.06msSetRepository.php#254
      Backtrace
      • 13. app/Repositories/SetRepository.php:254
      • 14. app/Http/Controllers/SetController.php:231
      • 15. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 16. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 17. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `sets` where `sets`.`id` = '5581' limit 1
      270μstopkinopro_dbSetRepository.php#259
      Bindings
      • 0: 5581
      Backtrace
      • 20. app/Repositories/SetRepository.php:259
      • 21. app/Http/Controllers/SetController.php:231
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 23. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 24. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    • select * from `sets` limit 1
      190μstopkinopro_dbSetRepository.php#259
      Backtrace
      • 18. app/Repositories/SetRepository.php:259
      • 19. app/Http/Controllers/SetController.php:231
      • 20. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
      • 21. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • 22. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
    App\Models\Genre
    144Genre.php#?
    App\Models\Movie
    105Movie.php#?
    App\Models\Description
    55Description.php#?
    App\Models\Sets
    3Sets.php#?
        _token
        UFEmoQ0Thq9cwtkrRc4Puqrw1CszHcofL5Yc6hGa
        sort
        relevancy
        _previous
        array:1 [ "url" => "https://topkinopro.com/movies/set/sharp/1978-god" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /movies/set/sharp/1978-god
        status_code
        200
        
        status_text
        OK
        format
        html
        content_type
        text/html; charset=UTF-8
        request_query
        []
        
        request_request
        []
        
        request_headers
        0 of 0
        array:23 [ "cookie" => array:1 [ 0 => "filterSave={%22genres%22:[]%2C%22types%22:[]%2C%22countries%22:[]%2C%22age_ratings%22:[]%2C%22first_actor%22:%22%22%2C%22second_actor%22:%22%22%2C%22actor%22:%22%22%2C%22query%22:%22%22%2C%22year_from%22:%22%22%2C%22year_to%22:%22%22%2C%22years%22:[]%2C%22years_type%22:%22tuple%22%2C%22actors_type%22:%22single%22%2C%22sort%22:%22kp_rating%22%2C%22kp_num%22:%22%22%2C%22imdb_num%22:%22%22%2C%22actors_num%22:%22%22%2C%22studios%22:[]%2C%22characters%22:[]%2C%22plot%22:[]%2C%22place%22:[]%2C%22time%22:[]%2C%22style%22:[]%2C%22detailedSearch%22:true}; favourites_ids=[]; XSRF-TOKEN=eyJpdiI6ImxINUEzeWE1ajNtZzRra1ZFWE5JY2c9PSIsInZhbHVlIjoiSXIrTDFkd2J3MFRHRGNhQWZITkh0YkQwVlRWck1lQUZYUEdCSXV6dXNuYUYyMlRoVnZ6ai9peTg5SFlQZGlqSlJLVXVZMGM4YUtYVFhxVllTK2lPUStUcjQ2YXYzQmdEVkxqNk5lSzRrQ2xZZTV5TGdhZk11MHJGT2RuRnhwVlgiLCJtYWMiOiJiNzFiMDg1OWRjMWU2ZjVmNTM3MWVmOGI3NTNkNWFjYWRkMGRiZTE1ZmFkYjhlZTc4MmRkYmFlNTAyYmI1N2EyIiwidGFnIjoiIn0%3D; movie_session=eyJpdiI6Ik83WVgzb3BSSWsvMEkwb1Zlc3BqS0E9PSIsInZhbHVlIjoiN3hMYy9iOU5yRjJaNWhpK244OHJVM2xjZlkxdm1JUmpDN1hzUjJ4ZjRUN2xVNmowdWk4blpMbW5MeFVUL0xodVROOHZtcUlKeTdkaHJoQVBLUjRWYlpyeGZ3dkYyeUNzeFNiTnprOWVqblJ4N0dDWDZDRFJ1djdFNDhnSEwyYmoiLCJtYWMiOiJkNDI1NGY0MjlkMzEzMThmYzQwYzU5ZTA2ZmFjMDc0YjBmMzU3MTY5ZmEyNjI5M2FjZGViNmM4MWM5YmNiZjZjIiwidGFnIjoiIn0%3D; viewed_ids=[18435%2C669597%2C543372%2C992225%2C398929%2C485963%2C1138784%2C339931%2C581154%2C5591%2C108664%2C328495%2C590276%2C675657]filterSave={%22genres%22:[]%2C%22types%22:[]%2C%22countries%22:[]%2C%22age_ratings%22:[]%2C%22first_actor%22:%22%22%2C%22second_actor%22:%22%22%2C%22actor%22:%2" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua" => array:1 [ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [ 0 => "no-cache" ] "pragma" => array:1 [ 0 => "no-cache" ] "accept" => array:1 [ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "sec-fetch-site" => array:1 [ 0 => "none" ] "cf-ipcountry" => array:1 [ 0 => "US" ] "cf-connecting-ip" => array:1 [ 0 => "52.14.176.202" ] "sec-fetch-mode" => array:1 [ 0 => "navigate" ] "sec-fetch-user" => array:1 [ 0 => "?1" ] "cf-visitor" => array:1 [ 0 => "{"scheme":"https"}" ] "sec-fetch-dest" => array:1 [ 0 => "document" ] "priority" => array:1 [ 0 => "u=0, i" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "cdn-loop" => array:1 [ 0 => "cloudflare; loops=1" ] "accept-encoding" => array:1 [ 0 => "gzip, br" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "x-forwarded-for" => array:1 [ 0 => "52.14.176.202" ] "cf-ray" => array:1 [ 0 => "93572ac7fd9aeaf0-ORD" ] "host" => array:1 [ 0 => "topkinopro.com" ] ]
        request_cookies
        0 of 0
        array:5 [ "filterSave" => "{"genres":[],"types":[],"countries":[],"age_ratings":[],"first_actor":"","second_actor":"","actor":"","query":"","year_from":"","year_to":"","years":[],"years_type":"tuple","actors_type":"single","sort":"kp_rating","kp_num":"","imdb_num":"","actors_num":"","studios":[],"characters":[],"plot":[],"place":[],"time":[],"style":[],"detailedSearch":true}{"genres":[],"types":[],"countries":[],"age_ratings":[],"first_actor":"","second_actor":"","actor":"","query":"","year_from":"","year_to":"","years":[],"years_t" "favourites_ids" => "[]" "XSRF-TOKEN" => "UFEmoQ0Thq9cwtkrRc4Puqrw1CszHcofL5Yc6hGa" "movie_session" => "LrjyVX3q61rfkshjNTmQVOywsScxqTXFCTNKkuJt" "viewed_ids" => "[18435,669597,543372,992225,398929,485963,1138784,339931,581154,5591,108664,328495,590276,675657]" ]
        response_headers
        0 of 0
        array:6 [ "cache-control" => array:1 [ 0 => "private, must-revalidate" ] "date" => array:1 [ 0 => "Thu, 24 Apr 2025 17:02:14 GMT" ] "last-modified" => array:1 [ 0 => "Sun, 10 Sep 2023 02:54:26 GMT" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkoxYWRWV1NvSWtYVmZ4Tjc4ekNYYnc9PSIsInZhbHVlIjoiVVpONXN4b2xicjc4MUtDdi9mQmFPTlVaNmF3Y2VNeGxrSVJVcGZuczkyMU1aSjAzUG9aNEhaQTJkZUdjZ0VJWVVTd2FhUnc1WEFnQXN2ZkpyUnR1Y3ROV21qVGg3Sk9GYmg2Mk5oZmFReUhzZ3dGdWdCUlVRUXpvelVrMVpkV04iLCJtYWMiOiI4Mjk5NGFkM2M2MDNjNGFiMGZiMDA3MzM1YzQwNzVmODQ1MDNkMmYyNWQzYmMxMjc3ZWNhNTY3NmFmZDRlMDVkIiwidGFnIjoiIn0%3D; expires=Thu, 24 Apr 2025 19:02:14 GMT; Max-Age=7200; path=/; secureXSRF-TOKEN=eyJpdiI6IkoxYWRWV1NvSWtYVmZ4Tjc4ekNYYnc9PSIsInZhbHVlIjoiVVpONXN4b2xicjc4MUtDdi9mQmFPTlVaNmF3Y2VNeGxrSVJVcGZuczkyMU1aSjAzUG9aNEhaQTJkZUdjZ0VJWVVTd2FhU" 1 => "movie_session=eyJpdiI6InN6QnJLN2JqOTVTMGpJbVNVamxDbEE9PSIsInZhbHVlIjoiZ0lhK3NZdXc5SnFDNHRZM0QzTmNkZld2c3htNnI1WnhjV1FpNXpmU0h4K1AzZVQ3U09ZVTh5QlI0YnVVTWJoUmdtQXdDT2lCMTl6TDlGR1IvcStVRDlLejJlVjdST2crM3NNNG1pcVYwUW5qc3F4OTkvQXZEbFkyUFgzR2hTMUIiLCJtYWMiOiI2OTJiZmZiYWJiYWVjMzk2NmZlMmNhOTZmZWNlMTFlNGI3N2UxZDRjZTlhYWUzMzM5MGRkNWI3OGJiYmJkMzNlIiwidGFnIjoiIn0%3D; expires=Thu, 24 Apr 2025 19:02:14 GMT; Max-Age=7200; path=/; httponlymovie_session=eyJpdiI6InN6QnJLN2JqOTVTMGpJbVNVamxDbEE9PSIsInZhbHVlIjoiZ0lhK3NZdXc5SnFDNHRZM0QzTmNkZld2c3htNnI1WnhjV1FpNXpmU0h4K1AzZVQ3U09ZVTh5QlI0YnVVTWJoUmdtQX" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkoxYWRWV1NvSWtYVmZ4Tjc4ekNYYnc9PSIsInZhbHVlIjoiVVpONXN4b2xicjc4MUtDdi9mQmFPTlVaNmF3Y2VNeGxrSVJVcGZuczkyMU1aSjAzUG9aNEhaQTJkZUdjZ0VJWVVTd2FhUnc1WEFnQXN2ZkpyUnR1Y3ROV21qVGg3Sk9GYmg2Mk5oZmFReUhzZ3dGdWdCUlVRUXpvelVrMVpkV04iLCJtYWMiOiI4Mjk5NGFkM2M2MDNjNGFiMGZiMDA3MzM1YzQwNzVmODQ1MDNkMmYyNWQzYmMxMjc3ZWNhNTY3NmFmZDRlMDVkIiwidGFnIjoiIn0%3D; expires=Thu, 24-Apr-2025 19:02:14 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IkoxYWRWV1NvSWtYVmZ4Tjc4ekNYYnc9PSIsInZhbHVlIjoiVVpONXN4b2xicjc4MUtDdi9mQmFPTlVaNmF3Y2VNeGxrSVJVcGZuczkyMU1aSjAzUG9aNEhaQTJkZUdjZ0VJWVVTd2FhU" 1 => "movie_session=eyJpdiI6InN6QnJLN2JqOTVTMGpJbVNVamxDbEE9PSIsInZhbHVlIjoiZ0lhK3NZdXc5SnFDNHRZM0QzTmNkZld2c3htNnI1WnhjV1FpNXpmU0h4K1AzZVQ3U09ZVTh5QlI0YnVVTWJoUmdtQXdDT2lCMTl6TDlGR1IvcStVRDlLejJlVjdST2crM3NNNG1pcVYwUW5qc3F4OTkvQXZEbFkyUFgzR2hTMUIiLCJtYWMiOiI2OTJiZmZiYWJiYWVjMzk2NmZlMmNhOTZmZWNlMTFlNGI3N2UxZDRjZTlhYWUzMzM5MGRkNWI3OGJiYmJkMzNlIiwidGFnIjoiIn0%3D; expires=Thu, 24-Apr-2025 19:02:14 GMT; path=/; httponlymovie_session=eyJpdiI6InN6QnJLN2JqOTVTMGpJbVNVamxDbEE9PSIsInZhbHVlIjoiZ0lhK3NZdXc5SnFDNHRZM0QzTmNkZld2c3htNnI1WnhjV1FpNXpmU0h4K1AzZVQ3U09ZVTh5QlI0YnVVTWJoUmdtQX" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "UFEmoQ0Thq9cwtkrRc4Puqrw1CszHcofL5Yc6hGa" "sort" => "relevancy" "_previous" => array:1 [ "url" => "https://topkinopro.com/movies/set/sharp/1978-god" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-04-24 20:02:14GET/movies/set/sharp/1978-god1057119307