Наверх
К началу
Request history8.3.13PHP Version734msRequest Duration151MBMemory UsageGET {type}/set/{letter}/{slug}Route
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\ManticoreService::$language is dep...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\SerializerService::$gHost is depre...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Repositories\MovieRepository::$cacheService...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\SerializerService::$gHost is depre...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\ManticoreService::$language is dep...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\SerializerService::$gHost is depre...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Repositories\SetRepository::$cacheService i...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\ManticoreService::$language is dep...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\SerializerService::$gHost is depre...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Repositories\MovieRepository::$cacheService...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[08:33:56] LOG.warning: preg_match(): Passing null to parameter #2 ($subject) of type string is depr...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[08:33:56] LOG.warning: preg_match(): Passing null to parameter #2 ($subject) of type string is depr...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[08:33:56] LOG.warning: preg_match(): Passing null to parameter #2 ($subject) of type string is depr...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[08:33:56] LOG.warning: preg_match(): Passing null to parameter #2 ($subject) of type string is depr...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[08:33:56] LOG.warning: preg_match(): Passing null to parameter #2 ($subject) of type string is depr...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[08:33:56] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • Booting (109ms)time
  • Application (625ms)time
  • 1 x Application (85.12%)
    625ms
    1 x Booting (14.88%)
    109ms
    73 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
    • 57x 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 executed74.71ms
    • 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
      680μ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
      190μ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` = 'chlen-pravleniya' limit 1
      3.09mstopkinopro_dbSetController.php#143
      Bindings
      • 0: movie
      • 1: chlen-pravleniya
      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 = 7198 limit 1
      2.04msSetRepository.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 = 7198
      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 = 7198 and MATCH('"Член правления"') order by `rank` desc limit 100 offset 0
      11.15msSetRepository.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 (47237, 12828, 11190, 437410, 195864, 406, 843789, 661022, 28558, 51250, 4098, 6374, 1192747, 4333, 6626, 397672, 21654, 8682, 300871, 2444, 588, 471, 102507, 291654, 402567, 447301, 447289, 447262, 11437, 15271, 11883, 594554, 195608, 607737, 328316, 662359, 328759, 328752, 328744, 328736, 328715, 328716, 655435, 520630, 893603, 1044281, 787825, 977288, 1045373, 906340, 1046438, 915111, 669652, 1009784, 955455, 956189, 1115098) order by FIELD(id, 47237,12828,11190,437410,195864,406,843789,661022,28558,51250,4098,6374,1192747,4333,6626,397672,21654,8682,300871,2444,588,471,102507,291654,402567,447301,447289,447262,11437,15271,11883,594554,195608,607737,328316,662359,328759,328752,328744,328736,328715,328716,655435,520630,893603,1044281,787825,977288,1045373,906340,1046438,915111,669652,1009784,955455,956189,1115098)
      1.57mstopkinopro_dbSetRepository.php#149
      Bindings
      • 0: 47237
      • 1: 12828
      • 2: 11190
      • 3: 437410
      • 4: 195864
      • 5: 406
      • 6: 843789
      • 7: 661022
      • 8: 28558
      • 9: 51250
      • 10: 4098
      • 11: 6374
      • 12: 1192747
      • 13: 4333
      • 14: 6626
      • 15: 397672
      • 16: 21654
      • 17: 8682
      • 18: 300871
      • 19: 2444
      • 20: 588
      • 21: 471
      • 22: 102507
      • 23: 291654
      • 24: 402567
      • 25: 447301
      • 26: 447289
      • 27: 447262
      • 28: 11437
      • 29: 15271
      • 30: 11883
      • 31: 594554
      • 32: 195608
      • 33: 607737
      • 34: 328316
      • 35: 662359
      • 36: 328759
      • 37: 328752
      • 38: 328744
      • 39: 328736
      • 40: 328715
      • 41: 328716
      • 42: 655435
      • 43: 520630
      • 44: 893603
      • 45: 1044281
      • 46: 787825
      • 47: 977288
      • 48: 1045373
      • 49: 906340
      • 50: 1046438
      • 51: 915111
      • 52: 669652
      • 53: 1009784
      • 54: 955455
      • 55: 956189
      • 56: 1115098
      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 (406, 471, 588, 2444, 4098, 4333, 6374, 6626, 8682, 11190, 11437, 11883, 12828, 15271, 21654, 28558, 47237, 51250, 102507, 195608, 195864, 291654, 300871, 328316, 328715, 328716, 328736, 328744, 328752, 328759, 397672, 402567, 437410, 447262, 447289, 447301, 520630, 594554, 607737, 655435, 661022, 662359, 669652, 787825, 843789, 893603, 906340, 915111, 955455, 956189, 977288, 1009784, 1044281, 1045373, 1046438, 1115098, 1192747)
      1.3mstopkinopro_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 (406, 471, 588, 2444, 4098, 4333, 6374, 6626, 8682, 11190, 11437, 11883, 12828, 15271, 21654, 28558, 47237, 51250, 102507, 195608, 195864, 291654, 300871, 328316, 328715, 328716, 328736, 328744, 328752, 328759, 397672, 402567, 437410, 447262, 447289, 447301, 520630, 594554, 607737, 655435, 661022, 662359, 669652, 787825, 843789, 893603, 906340, 915111, 955455, 956189, 977288, 1009784, 1044281, 1045373, 1046438, 1115098, 1192747)
      20.03mstopkinopro_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` = 7198 and `countries`.`type` = 'movie' group by `countries`.`code` having COUNT(movies.id) >= '3'
      17.24mstopkinopro_dbSetRepository.php#197
      Bindings
      • 0: 7198
      • 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` = 7198 and `countries`.`type` = 'movie' group by `genres`.`slug` having COUNT(movies.id) >= '3'
      3.75mstopkinopro_dbSetRepository.php#221
      Bindings
      • 0: 7198
      • 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` = 7198 group by `movies`.`year` having COUNT(movies.id) >= '3' order by `movies`.`year` desc
      1.57mstopkinopro_dbSetRepository.php#247
      Bindings
      • 0: movie
      • 1: 7198
      • 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` = 7198 order by RAND() limit 1
      1.57msMovieRepository.php#319
      Bindings
      • 0: 7198
      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` = 1115098 limit 1
      270μstopkinopro_dbMovieRepository.php#320
      Bindings
      • 0: 1115098
      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` = 1115098
      560μstopkinopro_dbSerializerService.php#125
      Bindings
      • 0: 1115098
      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` = 1115098 and `descriptions`.`movie_id` is not null limit 1
      2.58mstopkinopro_dbSerializerService.php#135
      Bindings
      • 0: 1115098
      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.52msSetRepository.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` = '2604' limit 1
      250μstopkinopro_dbSetRepository.php#259
      Bindings
      • 0: 2604
      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
      140μ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
    161Genre.php#?
    App\Models\Movie
    103Movie.php#?
    App\Models\Description
    45Description.php#?
    App\Models\Sets
    3Sets.php#?
        _token
        Rl3TgoGVoSTuE2kjZwQFIMD3IHJQ4PVx85ejapSa
        _previous
        array:1 [ "url" => "https://topkinopro.com/movies/set/ch/chlen-pravleniya" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        sort
        relevancy
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /movies/set/ch/chlen-pravleniya
        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=eyJpdiI6IlB1N0VrbnRDc3dEMU4xTUNnTkJLb3c9PSIsInZhbHVlIjoicTRVaVU4SU1RQ0FRaFZ4QU1zWXFUSEpRRFB1NTIwbnp5b09QckhHMlJwZlNZUjg5aDRMU05FSmJLRUx4SU51eHBlenFLNU9VUksyeXZoME5LQUtkcUtxT0hhMVJYMkdYY1R6WE9HUzNCU2pBZmR6MW56bURnRU91MGtXT1N3aXIiLCJtYWMiOiJlMjg5NGUxZmUzZTUzM2UwYWQyZWY0ZDgyYTBiODc4YzZkYzI3ZDc4M2VkNjFhYmRlZGEzM2U2Yjg2NTcxMGE2IiwidGFnIjoiIn0%3D; movie_session=eyJpdiI6InZNMkRpYWdxSEU3TjZkNWpnMUdQM0E9PSIsInZhbHVlIjoiV2NFcVNRMjB4MWVYbU4wOTBCM1plbkRjOGpLMGRkSi8xeldmTnFEUVN5cndYbnRFcFM0cnhCQjdtcWVIZVJzaVFMZ2htVzVQTk1EMk9DTkJVaUgzY2RMZTRUZDYrdU5sMkdPRjJNcXNkckY1ZlNqdnltS3YraTRIL0lMeXd0NmkiLCJtYWMiOiJlM2NiZTU1OWFkMDc0ZmQ2OWEzMTdhOTk1NTVlMGM2NDAxYzE0MDg5ZTA3ZDdmMTNiYmJlZmYxMTc1MzNjMDc5IiwidGFnIjoiIn0%3D; viewed_ids=[268482%2C819516%2C277650%2C580719%2C1162978%2C10761%2C556950%2C635503%2C973201%2C91466%2C418991%2C108089]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" ] "cdn-loop" => array:1 [ 0 => "cloudflare; loops=1" ] "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-connecting-ip" => array:1 [ 0 => "18.189.182.32" ] "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" ] "cf-ipcountry" => array:1 [ 0 => "US" ] "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 => "18.189.182.32" ] "cf-ray" => array:1 [ 0 => "92b6ac680eb8dadb-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" => "Rl3TgoGVoSTuE2kjZwQFIMD3IHJQ4PVx85ejapSa" "movie_session" => "tNsLJ7atri7KqWVIX5Ks0LnvVJrUGBPDnwAUPHht" "viewed_ids" => "[268482,819516,277650,580719,1162978,10761,556950,635503,973201,91466,418991,108089]" ]
        response_headers
        0 of 0
        array:6 [ "cache-control" => array:1 [ 0 => "private, must-revalidate" ] "date" => array:1 [ 0 => "Sat, 05 Apr 2025 05:33:56 GMT" ] "last-modified" => array:1 [ 0 => "Sun, 10 Sep 2023 11:12:24 GMT" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkhTRW15T2thWS9FZS95UlFmNlpnOHc9PSIsInZhbHVlIjoieVl4TVlhRmpNT0YrQm5GWjZYaGZWdFdXc205ckN0RVY0VmlWQTRBdEliQm5jZVgxVnpkVWc3bmVzRXAwbkUzdGtNRFkrY1FIRSt2ZkhqcGlVaWJoaWNSYkVDOFNLL1Z5Vy83UFA2SWRnSFV6MHBFL3dTSEhxcmF6TiszWU9Nem8iLCJtYWMiOiJhNTYzODJmNmM0YmEwYmJiMzEyM2EzZDg5MTIxZTUzMTcyOGU5YjU5MTQ0ZmY2ZDdjZmYzY2UwZGNmYmYwZWZkIiwidGFnIjoiIn0%3D; expires=Sat, 05 Apr 2025 07:33:56 GMT; Max-Age=7200; path=/; secureXSRF-TOKEN=eyJpdiI6IkhTRW15T2thWS9FZS95UlFmNlpnOHc9PSIsInZhbHVlIjoieVl4TVlhRmpNT0YrQm5GWjZYaGZWdFdXc205ckN0RVY0VmlWQTRBdEliQm5jZVgxVnpkVWc3bmVzRXAwbkUzdGtNRFkrY" 1 => "movie_session=eyJpdiI6ImNOK2NwZGRoQTBjWElRc1pIV00zanc9PSIsInZhbHVlIjoiVWVhcFpNSGtlRWNaSkhFSS9oUCtWQlRxd2tvRjVmTFpMc2VZVEE5aXIzZHU5bU1xZHNRNmg4U1NHVlU4K29oOHlWNlIzbGlKTDI2ZGN3eVYrY2JTanozOUFWdC9uNTlCV2VlWGlyZ3F0VXpoOTREV21lS2creTdkRGJXWFN4ZU8iLCJtYWMiOiIwNDg5NjhiNTcxZGM0NDEwNzYyYTIyYTA2ZDVhY2VhZjVhMjc0NDMxOTQ1NmZlZDAyMDM3NzZhM2JmYjlhNjM1IiwidGFnIjoiIn0%3D; expires=Sat, 05 Apr 2025 07:33:56 GMT; Max-Age=7200; path=/; httponlymovie_session=eyJpdiI6ImNOK2NwZGRoQTBjWElRc1pIV00zanc9PSIsInZhbHVlIjoiVWVhcFpNSGtlRWNaSkhFSS9oUCtWQlRxd2tvRjVmTFpMc2VZVEE5aXIzZHU5bU1xZHNRNmg4U1NHVlU4K29oOHlWNl" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IkhTRW15T2thWS9FZS95UlFmNlpnOHc9PSIsInZhbHVlIjoieVl4TVlhRmpNT0YrQm5GWjZYaGZWdFdXc205ckN0RVY0VmlWQTRBdEliQm5jZVgxVnpkVWc3bmVzRXAwbkUzdGtNRFkrY1FIRSt2ZkhqcGlVaWJoaWNSYkVDOFNLL1Z5Vy83UFA2SWRnSFV6MHBFL3dTSEhxcmF6TiszWU9Nem8iLCJtYWMiOiJhNTYzODJmNmM0YmEwYmJiMzEyM2EzZDg5MTIxZTUzMTcyOGU5YjU5MTQ0ZmY2ZDdjZmYzY2UwZGNmYmYwZWZkIiwidGFnIjoiIn0%3D; expires=Sat, 05-Apr-2025 07:33:56 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IkhTRW15T2thWS9FZS95UlFmNlpnOHc9PSIsInZhbHVlIjoieVl4TVlhRmpNT0YrQm5GWjZYaGZWdFdXc205ckN0RVY0VmlWQTRBdEliQm5jZVgxVnpkVWc3bmVzRXAwbkUzdGtNRFkrY" 1 => "movie_session=eyJpdiI6ImNOK2NwZGRoQTBjWElRc1pIV00zanc9PSIsInZhbHVlIjoiVWVhcFpNSGtlRWNaSkhFSS9oUCtWQlRxd2tvRjVmTFpMc2VZVEE5aXIzZHU5bU1xZHNRNmg4U1NHVlU4K29oOHlWNlIzbGlKTDI2ZGN3eVYrY2JTanozOUFWdC9uNTlCV2VlWGlyZ3F0VXpoOTREV21lS2creTdkRGJXWFN4ZU8iLCJtYWMiOiIwNDg5NjhiNTcxZGM0NDEwNzYyYTIyYTA2ZDVhY2VhZjVhMjc0NDMxOTQ1NmZlZDAyMDM3NzZhM2JmYjlhNjM1IiwidGFnIjoiIn0%3D; expires=Sat, 05-Apr-2025 07:33:56 GMT; path=/; httponlymovie_session=eyJpdiI6ImNOK2NwZGRoQTBjWElRc1pIV00zanc9PSIsInZhbHVlIjoiVWVhcFpNSGtlRWNaSkhFSS9oUCtWQlRxd2tvRjVmTFpMc2VZVEE5aXIzZHU5bU1xZHNRNmg4U1NHVlU4K29oOHlWNl" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "Rl3TgoGVoSTuE2kjZwQFIMD3IHJQ4PVx85ejapSa" "_previous" => array:1 [ "url" => "https://topkinopro.com/movies/set/ch/chlen-pravleniya" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "sort" => "relevancy" "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-04-05 08:33:56GET/movies/set/ch/chlen-pravleniya1077319312