Наверх
К началу
Request history8.3.13PHP Version507msRequest Duration151MBMemory UsageGET {type}/set/{letter}/{slug}Route
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\ManticoreService::$language is dep...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\SerializerService::$gHost is depre...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Repositories\MovieRepository::$cacheService...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\SerializerService::$gHost is depre...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\ManticoreService::$language is dep...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\SerializerService::$gHost is depre...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Repositories\SetRepository::$cacheService i...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\ManticoreService::$language is dep...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\SerializerService::$gHost is depre...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Repositories\MovieRepository::$cacheService...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: Creation of dynamic property App\Services\CacheService::$gHost is deprecated...
  • warninglog[02:26:36] LOG.warning: preg_match(): Passing null to parameter #2 ($subject) of type string is depr...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[02:26:36] LOG.warning: preg_match(): Passing null to parameter #2 ($subject) of type string is depr...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[02:26:36] LOG.warning: preg_match(): Passing null to parameter #2 ($subject) of type string is depr...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[02:26:36] LOG.warning: preg_match(): Passing null to parameter #2 ($subject) of type string is depr...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[02:26:36] LOG.warning: preg_match(): Passing null to parameter #2 ($subject) of type string is depr...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • warninglog[02:26:36] LOG.warning: preg_match_all(): Passing null to parameter #2 ($subject) of type string is ...
  • Booting (108ms)time
  • Application (399ms)time
  • 1 x Application (78.68%)
    399ms
    1 x Booting (21.31%)
    108ms
    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 executed82.52ms
    • 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
      580μ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
      240μ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` = 'tv-series' and `slug` = 'bar' limit 1
      18.64mstopkinopro_dbSetController.php#143
      Bindings
      • 0: tv-series
      • 1: bar
      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 = 38301 limit 1
      3.44msSetRepository.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 = 38301
      2.57msSetRepository.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 = 38301 and MATCH('"Бар"') order by `rank` desc limit 100 offset 0
      14.65msSetRepository.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 (1297212, 957906, 401515, 251582, 596247, 415001, 571335, 1049380, 927245, 647965, 1161756, 248134, 1138454, 79848, 455494, 94588, 94587, 260888, 408336, 229080, 308343, 229326, 541919, 494249, 94997, 178565, 566816, 469563, 412467, 229996, 469685, 438208, 499941, 500600, 580186, 673387, 580577, 231993, 283459, 662539, 79456, 420201, 237259, 392925, 77309, 153012, 277608, 277590, 277535, 631269, 843207, 733419, 696973, 279204, 752882, 714102, 957861) order by FIELD(id, 1297212,957906,401515,251582,596247,415001,571335,1049380,927245,647965,1161756,248134,1138454,79848,455494,94588,94587,260888,408336,229080,308343,229326,541919,494249,94997,178565,566816,469563,412467,229996,469685,438208,499941,500600,580186,673387,580577,231993,283459,662539,79456,420201,237259,392925,77309,153012,277608,277590,277535,631269,843207,733419,696973,279204,752882,714102,957861)
      1.29mstopkinopro_dbSetRepository.php#149
      Bindings
      • 0: 1297212
      • 1: 957906
      • 2: 401515
      • 3: 251582
      • 4: 596247
      • 5: 415001
      • 6: 571335
      • 7: 1049380
      • 8: 927245
      • 9: 647965
      • 10: 1161756
      • 11: 248134
      • 12: 1138454
      • 13: 79848
      • 14: 455494
      • 15: 94588
      • 16: 94587
      • 17: 260888
      • 18: 408336
      • 19: 229080
      • 20: 308343
      • 21: 229326
      • 22: 541919
      • 23: 494249
      • 24: 94997
      • 25: 178565
      • 26: 566816
      • 27: 469563
      • 28: 412467
      • 29: 229996
      • 30: 469685
      • 31: 438208
      • 32: 499941
      • 33: 500600
      • 34: 580186
      • 35: 673387
      • 36: 580577
      • 37: 231993
      • 38: 283459
      • 39: 662539
      • 40: 79456
      • 41: 420201
      • 42: 237259
      • 43: 392925
      • 44: 77309
      • 45: 153012
      • 46: 277608
      • 47: 277590
      • 48: 277535
      • 49: 631269
      • 50: 843207
      • 51: 733419
      • 52: 696973
      • 53: 279204
      • 54: 752882
      • 55: 714102
      • 56: 957861
      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 (77309, 79456, 79848, 94587, 94588, 94997, 153012, 178565, 229080, 229326, 229996, 231993, 237259, 248134, 251582, 260888, 277535, 277590, 277608, 279204, 283459, 308343, 392925, 401515, 408336, 412467, 415001, 420201, 438208, 455494, 469563, 469685, 494249, 499941, 500600, 541919, 566816, 571335, 580186, 580577, 596247, 631269, 647965, 662539, 673387, 696973, 714102, 733419, 752882, 843207, 927245, 957861, 957906, 1049380, 1138454, 1161756, 1297212)
      1.79mstopkinopro_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 (77309, 79456, 79848, 94587, 94588, 94997, 153012, 178565, 229080, 229326, 229996, 231993, 237259, 248134, 251582, 260888, 277535, 277590, 277608, 279204, 283459, 308343, 392925, 401515, 408336, 412467, 415001, 420201, 438208, 455494, 469563, 469685, 494249, 499941, 500600, 541919, 566816, 571335, 580186, 580577, 596247, 631269, 647965, 662539, 673387, 696973, 714102, 733419, 752882, 843207, 927245, 957861, 957906, 1049380, 1138454, 1161756, 1297212)
      11.07mstopkinopro_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` = 38301 and `countries`.`type` = 'tv-series' group by `countries`.`code` having COUNT(movies.id) >= '3'
      12.77mstopkinopro_dbSetRepository.php#197
      Bindings
      • 0: 38301
      • 1: tv-series
      • 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` = 38301 and `countries`.`type` = 'tv-series' group by `genres`.`slug` having COUNT(movies.id) >= '3'
      2.81mstopkinopro_dbSetRepository.php#221
      Bindings
      • 0: 38301
      • 1: tv-series
      • 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` = 'tv-series' and `set_movies`.`set_id` = 38301 group by `movies`.`year` having COUNT(movies.id) >= '3' order by `movies`.`year` desc
      1.99mstopkinopro_dbSetRepository.php#247
      Bindings
      • 0: tv-series
      • 1: 38301
      • 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` = 38301 order by RAND() limit 1
      2.09msMovieRepository.php#319
      Bindings
      • 0: 38301
      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` = 580186 limit 1
      440μstopkinopro_dbMovieRepository.php#320
      Bindings
      • 0: 580186
      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` = 580186
      410μstopkinopro_dbSerializerService.php#125
      Bindings
      • 0: 580186
      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` = 580186 and `descriptions`.`movie_id` is not null limit 1
      380μstopkinopro_dbSerializerService.php#135
      Bindings
      • 0: 580186
      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()
      6.3msSetRepository.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` = '26550' limit 1
      820μstopkinopro_dbSetRepository.php#259
      Bindings
      • 0: 26550
      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
      240μ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
    172Genre.php#?
    App\Models\Movie
    99Movie.php#?
    App\Models\Description
    56Description.php#?
    App\Models\Sets
    3Sets.php#?
        _token
        wfQsTrNInQzeVNO8Gojndv839CqjyRIYZUaUZZ2N
        sort
        relevancy
        _previous
        array:1 [ "url" => "https://topkinopro.com/tv-series/set/b/bar" ]
        _flash
        array:2 [ "old" => [] "new" => [] ]
        PHPDEBUGBAR_STACK_DATA
        []
        path_info
        /tv-series/set/b/bar
        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=[]; viewed_ids=[17477%2C723537%2C332161%2C12227%2C448279%2C121057%2C1295825%2C28618%2C2824%2C696490%2C676947%2C116740%2C151611%2C665320]; XSRF-TOKEN=eyJpdiI6ImhjbGNaQmdrSWJwRmNqUk9aS1FKNnc9PSIsInZhbHVlIjoiZ08xSWJDd24zaVJzQis3MXYvTVFTRXJCUWdSV3NDV3pCTll3aGhOR1BXeS9VS0JHU3llbWFOYzZiYnVVeXhtVkIvL3ZBWHlBVGVPc3h3eGNqYXpvcC8xeGtOOGFtV0NwZ1RVM1lZbE5JbjJuSzlpY3dLclRvNFF4WDVHWHVDNzkiLCJtYWMiOiJjYmNkYmQwYzdiODg2ZTlkNDA1NzU4OWI2NjUxOWJjNjc2YjI3ZmVkNzA2Y2M3MDdkN2E2ZDBjMzI1ZmFiYjAwIiwidGFnIjoiIn0%3D; movie_session=eyJpdiI6InJyVXBIc0VtU1hldE5pQm1QbUF2TUE9PSIsInZhbHVlIjoiUXVBV0FhREMxbTA0cFpHVlNXUXI5a3JCTTVBLzc3Y3hNZGlXT2lldXZ2Vzlza3FuQkI2UnA3YXkrR3orRG5CQk1sYVFEdUFKQW96R2hIMThzV284T0lSRjFYN1RyeUNHbm9JaWZ5eGMxZnF3L1VzazZNSFk0Tk9yYTRPZXZDVGgiLCJtYWMiOiJjNTU2N2U2NmYxMmQ3Njk4YmNmZTE1M2UyN2Y1MDA0YTVkOGY5Y2ZkNTRjZWIyOTZlOTBmN2Y3MjhkYTk3ODI2IiwidGFnIjoiIn0%3DfilterSave={%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 => "18.223.149.135" ] "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 => "18.223.149.135" ] "cf-ray" => array:1 [ 0 => "92ddc5342dd61aeb-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" => "[]" "viewed_ids" => "[17477,723537,332161,12227,448279,121057,1295825,28618,2824,696490,676947,116740,151611,665320]" "XSRF-TOKEN" => "wfQsTrNInQzeVNO8Gojndv839CqjyRIYZUaUZZ2N" "movie_session" => "pJa7fWoLzqXXBLUwFTJD3ZrlBZ7zBRyQ8WUnEYGQ" ]
        response_headers
        0 of 0
        array:6 [ "cache-control" => array:1 [ 0 => "private, must-revalidate" ] "date" => array:1 [ 0 => "Wed, 09 Apr 2025 23:26:36 GMT" ] "last-modified" => array:1 [ 0 => "Sun, 10 Sep 2023 08:55:38 GMT" ] "content-type" => array:1 [ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IktMUStteEJ6WnRuOEdZdmNUaG5LZEE9PSIsInZhbHVlIjoicVFDNUxJMGUwbHB5b3ZjUjFhY0NQL29TT0Q0aW1ES2Z3Umd5NFN5dy9GelNteVZGZUFLODhvb1gwcVR0T1FFYjJ1L2p5R1VQVWlUZTg5aE1xM2o4UnNtUUJtL3FtelprWmhzTDNadHRXekw4bk04Z3ZwVVlKbXB3T0gzbDEvaGQiLCJtYWMiOiI2NGNlMzM2MDc2NzgyOWE1ZjIxMTFjZjkxNGQ3ZTZjOWRkN2NiODYyZjFjMWM0YjhlOWE5M2VhZjJiZmFiODlkIiwidGFnIjoiIn0%3D; expires=Thu, 10 Apr 2025 01:26:36 GMT; Max-Age=7200; path=/; secureXSRF-TOKEN=eyJpdiI6IktMUStteEJ6WnRuOEdZdmNUaG5LZEE9PSIsInZhbHVlIjoicVFDNUxJMGUwbHB5b3ZjUjFhY0NQL29TT0Q0aW1ES2Z3Umd5NFN5dy9GelNteVZGZUFLODhvb1gwcVR0T1FFYjJ1L2p5R" 1 => "movie_session=eyJpdiI6Ikh0NjV5VXpNTEhkZTRhUFpmRjZ6Qmc9PSIsInZhbHVlIjoiT2ZLZCtwbFRpUzFha3FtazFUblBFMm9mMUloOFBYMnBaS0JxWGdBaUJCS2N6L0dzZTBBcDd4OGRVUE1iVVFZYmM2STI5amxEbWVxT05TR2srVExkNERjMGRiMWtXaVpyU29GR2pJT0ZRVGZWZ1FhQUxhR0FBMGFDV0ZKaWw2QVciLCJtYWMiOiJkOWY5OGNkZGYxZTdkODBlYWNlZWFiZmUzNmU3MmM3MDRkMThjNjg3MmI2OGZkYjQ5MjYzM2QwMmQ5NTZkMzExIiwidGFnIjoiIn0%3D; expires=Thu, 10 Apr 2025 01:26:36 GMT; Max-Age=7200; path=/; httponlymovie_session=eyJpdiI6Ikh0NjV5VXpNTEhkZTRhUFpmRjZ6Qmc9PSIsInZhbHVlIjoiT2ZLZCtwbFRpUzFha3FtazFUblBFMm9mMUloOFBYMnBaS0JxWGdBaUJCS2N6L0dzZTBBcDd4OGRVUE1iVVFZYmM2ST" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6IktMUStteEJ6WnRuOEdZdmNUaG5LZEE9PSIsInZhbHVlIjoicVFDNUxJMGUwbHB5b3ZjUjFhY0NQL29TT0Q0aW1ES2Z3Umd5NFN5dy9GelNteVZGZUFLODhvb1gwcVR0T1FFYjJ1L2p5R1VQVWlUZTg5aE1xM2o4UnNtUUJtL3FtelprWmhzTDNadHRXekw4bk04Z3ZwVVlKbXB3T0gzbDEvaGQiLCJtYWMiOiI2NGNlMzM2MDc2NzgyOWE1ZjIxMTFjZjkxNGQ3ZTZjOWRkN2NiODYyZjFjMWM0YjhlOWE5M2VhZjJiZmFiODlkIiwidGFnIjoiIn0%3D; expires=Thu, 10-Apr-2025 01:26:36 GMT; path=/; secureXSRF-TOKEN=eyJpdiI6IktMUStteEJ6WnRuOEdZdmNUaG5LZEE9PSIsInZhbHVlIjoicVFDNUxJMGUwbHB5b3ZjUjFhY0NQL29TT0Q0aW1ES2Z3Umd5NFN5dy9GelNteVZGZUFLODhvb1gwcVR0T1FFYjJ1L2p5R" 1 => "movie_session=eyJpdiI6Ikh0NjV5VXpNTEhkZTRhUFpmRjZ6Qmc9PSIsInZhbHVlIjoiT2ZLZCtwbFRpUzFha3FtazFUblBFMm9mMUloOFBYMnBaS0JxWGdBaUJCS2N6L0dzZTBBcDd4OGRVUE1iVVFZYmM2STI5amxEbWVxT05TR2srVExkNERjMGRiMWtXaVpyU29GR2pJT0ZRVGZWZ1FhQUxhR0FBMGFDV0ZKaWw2QVciLCJtYWMiOiJkOWY5OGNkZGYxZTdkODBlYWNlZWFiZmUzNmU3MmM3MDRkMThjNjg3MmI2OGZkYjQ5MjYzM2QwMmQ5NTZkMzExIiwidGFnIjoiIn0%3D; expires=Thu, 10-Apr-2025 01:26:36 GMT; path=/; httponlymovie_session=eyJpdiI6Ikh0NjV5VXpNTEhkZTRhUFpmRjZ6Qmc9PSIsInZhbHVlIjoiT2ZLZCtwbFRpUzFha3FtazFUblBFMm9mMUloOFBYMnBaS0JxWGdBaUJCS2N6L0dzZTBBcDd4OGRVUE1iVVFZYmM2ST" ] ]
        session_attributes
        0 of 0
        array:5 [ "_token" => "wfQsTrNInQzeVNO8Gojndv839CqjyRIYZUaUZZ2N" "sort" => "relevancy" "_previous" => array:1 [ "url" => "https://topkinopro.com/tv-series/set/b/bar" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
        ClearShow all
        Date ↕MethodURLData
        #12025-04-10 02:26:36GET/tv-series/set/b/bar1077319330