Messages Timeline Exceptions Views2 Route Queries52 Models289 Mails Gate Session Request

7.3.331.63s20MBGET catalog/{sublevels?}

Booting (155ms)
Application (1.47s)
1 x Application (90.4%)
1.47s
1 x Booting (9.53%)
155.07ms

2 templates were rendered

front.catalog.subcategory-tree (resources/views/front/catalog/subcategory-tree.blade.php)13blade
Params
0
pageTitle
1
pageMeta
2
h1
3
pageUrl
4
linkUrl
5
switchUrl
6
alternateLang
7
subCategories
8
category
9
products
10
categoryDen
11
tree
12
open

layouts.app (resources/views/layouts/app.blade.php)22blade


obLevel
__env
app
breadCrumbList
breadCrumbHtml
errors
alternateLang
pageTitle
pageMeta
h1
pageUrl
linkUrl
switchUrl
subCategories
category
products
categoryDen
tree
open
localBussiness
rootCategories
seoBlockContent

uri: GET catalog/{sublevels?}
middleware: web, cache.headers:public;max_age=2628000;etag
localized-routes-locale: ro
as: ro.catalog.subcategory
controller: App\Http\Controllers\CategoryController@show
namespace: App\Http\Controllers
prefix
where
file: app/Http/Controllers/CategoryController.php:60-731

52 statements were executed, 7 of which were duplicated, 45 unique1.37s

select * from `category_den` where `url` = 'chervona-zirka-krnv-5-6-153210' and `lang` = 'ro' limit 115.84ms/app/Http/Controllers/CategoryController.php:117agropies_db

Metadata
Bindings	0. chervona-zirka-krnv-5-6-153210 1. ro
Backtrace	15. /app/Http/Controllers/CategoryController.php:117 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `category_den` where `lang` = 'ru' and `category_den`.`category_id` in (153210)260μs/app/Http/Controllers/CategoryController.php:117agropies_db

Metadata
Bindings	0. ru 1. 153210
Backtrace	20. /app/Http/Controllers/CategoryController.php:117 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 26. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `categories` where `categories`.`id` = 153210 limit 11.08ms/app/Http/Controllers/CategoryController.php:144agropies_db

Metadata
Bindings	0. 153210
Backtrace	20. /app/Http/Controllers/CategoryController.php:144 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 26. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (153210)260μs/app/Http/Controllers/CategoryController.php:144agropies_db

Metadata
Bindings	0. ro
Backtrace	25. /app/Http/Controllers/CategoryController.php:144 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 30. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 31. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select *, (select count(1) - 1 from `categories` as `_d` where `categories`.`_lft` between `_d`.`_lft` and `_d`.`_rgt`) as `depth` from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 153210 limit 1) between `categories`.`_lft` and `categories`.`_rgt`) order by `_lft` asc

189ms/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. 153210
Backtrace	14. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 15. /app/Http/Controllers/CategoryController.php:197 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (35, 152726, 152831, 153210)11.53ms/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. ro
Backtrace	19. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 20. /app/Http/Controllers/CategoryController.php:197 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select * from `category_den` where `lang` != 'ro' and `category_den`.`category_id` in (35, 152726, 152831, 153210)620μs/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. ro
Backtrace	19. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 20. /app/Http/Controllers/CategoryController.php:197 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176

select count(*) as aggregate from `pdf_catalogs` where `category_id` = 152726 and `locale` = 'ro' and `pdf_catalogs`.`deleted_at` is null

290μs/app/Http/Controllers/CategoryController.php:228agropies_db

Metadata
Bindings	0. 152726 1. ro
Backtrace	15. /app/Http/Controllers/CategoryController.php:228 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select `_lft`, `_rgt` from `categories` where `id` = 153210 limit 1230μs/vendor/kalnoy/nestedset/src/QueryBuilder.php:39agropies_db

Metadata
Bindings	0. 153210
Backtrace	13. /vendor/kalnoy/nestedset/src/QueryBuilder.php:39 14. /vendor/kalnoy/nestedset/src/QueryBuilder.php:60 15. /vendor/kalnoy/nestedset/src/QueryBuilder.php:224 16. /vendor/kalnoy/nestedset/src/QueryBuilder.php:291 17. /vendor/kalnoy/nestedset/src/QueryBuilder.php:307

select * from `categories` where `categories`.`_lft` between 167534 and 167565260μs/vendor/kalnoy/nestedset/src/QueryBuilder.php:291agropies_db

Metadata
Bindings	0. 167534 1. 167565
Backtrace	14. /vendor/kalnoy/nestedset/src/QueryBuilder.php:291 15. /vendor/kalnoy/nestedset/src/QueryBuilder.php:307 16. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 19. /app/Http/Controllers/CategoryController.php:262 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (153210, 153211, 153212, 153213, 153214, 153215, 153217, 153218, 153221, 153222, 153223, 153224, 153225, 153226, 153227, 153228)

700μs/vendor/kalnoy/nestedset/src/QueryBuilder.php:291agropies_db

Metadata
Bindings	0. ro
Backtrace	19. /vendor/kalnoy/nestedset/src/QueryBuilder.php:291 20. /vendor/kalnoy/nestedset/src/QueryBuilder.php:307 21. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 24. /app/Http/Controllers/CategoryController.php:262 27. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 153210 limit 1) between `categories`.`_lft` and `categories`.`_rgt`) order by `_lft` asc

42.51ms/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. 153210
Backtrace	14. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 15. /app/Models/Categories.php:70 16. /app/Models/Categories.php:93 23. view::front.catalog.subcategory-tree:248 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59

select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (35, 152726, 152831, 153210)450μs/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. ro
Backtrace	19. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 20. /app/Models/Categories.php:70 21. /app/Models/Categories.php:93 28. view::front.catalog.subcategory-tree:248 30. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59

select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 153210 limit 1) between `categories`.`_lft` and `categories`.`_rgt`) order by `_lft` asc

48.73ms/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. 153210
Backtrace	14. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 15. /app/Models/Categories.php:70 16. /app/Models/Categories.php:93 22. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1959 25. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1978

select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (35, 152726, 152831, 153210)440μs/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. ro
Backtrace	19. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 20. /app/Models/Categories.php:70 21. /app/Models/Categories.php:93 27. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1959 30. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1978

select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 153211 limit 1) between `categories`.`_lft` and `categories`.`_rgt`) order by `_lft` asc

48.78ms/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. 153211
Backtrace	14. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 15. /app/Models/Categories.php:70 16. /app/Models/Categories.php:93 21. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 27. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1959

select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (35, 152726, 152831, 153210, 153211)

460μs/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. ro
Backtrace	19. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 20. /app/Models/Categories.php:70 21. /app/Models/Categories.php:93 26. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 32. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1959

select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 153212 limit 1) between `categories`.`_lft` and `categories`.`_rgt`) order by `_lft` asc

49.39ms/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. 153212
Backtrace	14. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 15. /app/Models/Categories.php:70 16. /app/Models/Categories.php:93 21. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 26. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946

select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (35, 152726, 152831, 153210, 153211, 153212)

520μs/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. ro
Backtrace	19. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 20. /app/Models/Categories.php:70 21. /app/Models/Categories.php:93 26. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 31. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946

select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 153213 limit 1) between `categories`.`_lft` and `categories`.`_rgt`) order by `_lft` asc

50.01ms/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. 153213
Backtrace	14. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 15. /app/Models/Categories.php:70 16. /app/Models/Categories.php:93 21. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 26. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946

select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (35, 152726, 152831, 153210, 153211, 153212, 153213)

540μs/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. ro
Backtrace	19. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 20. /app/Models/Categories.php:70 21. /app/Models/Categories.php:93 26. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 31. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946

select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 153214 limit 1) between `categories`.`_lft` and `categories`.`_rgt`) order by `_lft` asc

50.33ms/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. 153214
Backtrace	14. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 15. /app/Models/Categories.php:70 16. /app/Models/Categories.php:93 21. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 26. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946

select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (35, 152726, 152831, 153210, 153211, 153214)

570μs/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. ro
Backtrace	19. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 20. /app/Models/Categories.php:70 21. /app/Models/Categories.php:93 26. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 31. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946

select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 153215 limit 1) between `categories`.`_lft` and `categories`.`_rgt`) order by `_lft` asc

98.43ms/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. 153215
Backtrace	14. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 15. /app/Models/Categories.php:70 16. /app/Models/Categories.php:93 21. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 26. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946

select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (35, 152726, 152831, 153210, 153211, 153214, 153215)

630μs/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. ro
Backtrace	19. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 20. /app/Models/Categories.php:70 21. /app/Models/Categories.php:93 26. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 31. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946

select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 153217 limit 1) between `categories`.`_lft` and `categories`.`_rgt`) order by `_lft` asc

62.14ms/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. 153217
Backtrace	14. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 15. /app/Models/Categories.php:70 16. /app/Models/Categories.php:93 21. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 26. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946

select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (35, 152726, 152831, 153210, 153211, 153214, 153217)

490μs/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. ro
Backtrace	19. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 20. /app/Models/Categories.php:70 21. /app/Models/Categories.php:93 26. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 31. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946

select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 153218 limit 1) between `categories`.`_lft` and `categories`.`_rgt`) order by `_lft` asc

84.19ms/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. 153218
Backtrace	14. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 15. /app/Models/Categories.php:70 16. /app/Models/Categories.php:93 21. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 26. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946

select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (35, 152726, 152831, 153210, 153211, 153214, 153218)

660μs/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. ro
Backtrace	19. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 20. /app/Models/Categories.php:70 21. /app/Models/Categories.php:93 26. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 31. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946

select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 153221 limit 1) between `categories`.`_lft` and `categories`.`_rgt`) order by `_lft` asc

76.94ms/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. 153221
Backtrace	14. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 15. /app/Models/Categories.php:70 16. /app/Models/Categories.php:93 21. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 27. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1959

select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (35, 152726, 152831, 153210, 153221)

580μs/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. ro
Backtrace	19. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 20. /app/Models/Categories.php:70 21. /app/Models/Categories.php:93 26. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 32. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1959

select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 153222 limit 1) between `categories`.`_lft` and `categories`.`_rgt`) order by `_lft` asc

60.8ms/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. 153222
Backtrace	14. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 15. /app/Models/Categories.php:70 16. /app/Models/Categories.php:93 21. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 26. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946

select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (35, 152726, 152831, 153210, 153221, 153222)

14.66ms/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. ro
Backtrace	19. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 20. /app/Models/Categories.php:70 21. /app/Models/Categories.php:93 26. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 31. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946

select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 153223 limit 1) between `categories`.`_lft` and `categories`.`_rgt`) order by `_lft` asc

50.62ms/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. 153223
Backtrace	14. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 15. /app/Models/Categories.php:70 16. /app/Models/Categories.php:93 21. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 26. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946

select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (35, 152726, 152831, 153210, 153221, 153222, 153223)

620μs/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. ro
Backtrace	19. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 20. /app/Models/Categories.php:70 21. /app/Models/Categories.php:93 26. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 31. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946

select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 153224 limit 1) between `categories`.`_lft` and `categories`.`_rgt`) order by `_lft` asc

43.42ms/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. 153224
Backtrace	14. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 15. /app/Models/Categories.php:70 16. /app/Models/Categories.php:93 21. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 26. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946

select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (35, 152726, 152831, 153210, 153221, 153222, 153224)

13.64ms/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. ro
Backtrace	19. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 20. /app/Models/Categories.php:70 21. /app/Models/Categories.php:93 26. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 31. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946

select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 153225 limit 1) between `categories`.`_lft` and `categories`.`_rgt`) order by `_lft` asc

42.5ms/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. 153225
Backtrace	14. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 15. /app/Models/Categories.php:70 16. /app/Models/Categories.php:93 21. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 27. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1959

select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (35, 152726, 152831, 153210, 153225)

13.68ms/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. ro
Backtrace	19. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 20. /app/Models/Categories.php:70 21. /app/Models/Categories.php:93 26. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 32. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1959

select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 153226 limit 1) between `categories`.`_lft` and `categories`.`_rgt`) order by `_lft` asc

43.53ms/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. 153226
Backtrace	14. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 15. /app/Models/Categories.php:70 16. /app/Models/Categories.php:93 21. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 26. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946

select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (35, 152726, 152831, 153210, 153225, 153226)

29.57ms/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. ro
Backtrace	19. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 20. /app/Models/Categories.php:70 21. /app/Models/Categories.php:93 26. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 31. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946

select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 153227 limit 1) between `categories`.`_lft` and `categories`.`_rgt`) order by `_lft` asc

38.06ms/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. 153227
Backtrace	14. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 15. /app/Models/Categories.php:70 16. /app/Models/Categories.php:93 21. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 26. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946

select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (35, 152726, 152831, 153210, 153225, 153226, 153227)

20.4ms/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. ro
Backtrace	19. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 20. /app/Models/Categories.php:70 21. /app/Models/Categories.php:93 26. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 31. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946

select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 153228 limit 1) between `categories`.`_lft` and `categories`.`_rgt`) order by `_lft` asc

48.25ms/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. 153228
Backtrace	14. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 15. /app/Models/Categories.php:70 16. /app/Models/Categories.php:93 21. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 26. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946

select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (35, 152726, 152831, 153210, 153225, 153226, 153228)

710μs/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. ro
Backtrace	19. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 20. /app/Models/Categories.php:70 21. /app/Models/Categories.php:93 26. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946 31. /vendor/laravel/framework/src/Illuminate/Support/Collection.php:1946

select * from `categories` where ((select `_`.`_rgt` from `categories` as `_` where `id` = 153210 limit 1) between `categories`.`_lft` and `categories`.`_rgt`) order by `_lft` asc

49.39ms/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. 153210
Backtrace	14. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 15. /app/Models/Categories.php:70 16. /app/Models/Categories.php:93 23. view::front.catalog.subcategory-tree:262 25. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59

select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (35, 152726, 152831, 153210)530μs/vendor/kalnoy/nestedset/src/QueryBuilder.php:170agropies_db

Metadata
Bindings	0. ro
Backtrace	19. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 20. /app/Models/Categories.php:70 21. /app/Models/Categories.php:93 28. view::front.catalog.subcategory-tree:262 30. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59

select * from `categories` where `parent_id` is null300μs/app/Providers/ComposerServiceProvider.php:36agropies_db

Metadata
Backtrace	14. /app/Providers/ComposerServiceProvider.php:36 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 18. /vendor/laravel/framework/src/Illuminate/View/View.php:123 19. /vendor/laravel/framework/src/Illuminate/View/View.php:90 20. view::front.catalog.subcategory-tree:319

select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (5, 6, 19, 31, 34, 35, 36, 37, 38, 39, 40, 159115, 160195)

630μs/app/Providers/ComposerServiceProvider.php:36agropies_db

Metadata
Bindings	0. ro
Backtrace	19. /app/Providers/ComposerServiceProvider.php:36 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 23. /vendor/laravel/framework/src/Illuminate/View/View.php:123 24. /vendor/laravel/framework/src/Illuminate/View/View.php:90 25. view::front.catalog.subcategory-tree:319

select * from `seo_text` where (`route_name` = 'ro.catalog.subcategory') limit 1250μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23agropies_db

Metadata
Bindings	0. ro.catalog.subcategory
Backtrace	16. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 19. /app/Providers/ComposerServiceProvider.php:45 22. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 23. /vendor/laravel/framework/src/Illuminate/View/View.php:123 24. /vendor/laravel/framework/src/Illuminate/View/View.php:90

select min(`price`) as aggregate from `products` where `stock` > 0 and `products`.`deleted_at` is null21.77ms/app/Providers/ComposerServiceProvider.php:57agropies_db

Metadata
Bindings	0. 0
Backtrace	15. /app/Providers/ComposerServiceProvider.php:57 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 19. /vendor/laravel/framework/src/Illuminate/View/View.php:123 20. /vendor/laravel/framework/src/Illuminate/View/View.php:90 21. view::front.catalog.subcategory-tree:319

select max(`price`) as aggregate from `products` where `stock` > 0 and `products`.`deleted_at` is null44.38ms/app/Providers/ComposerServiceProvider.php:57agropies_db

Metadata
Bindings	0. 0
Backtrace	15. /app/Providers/ComposerServiceProvider.php:57 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 19. /vendor/laravel/framework/src/Illuminate/View/View.php:123 20. /vendor/laravel/framework/src/Illuminate/View/View.php:90 21. view::front.catalog.subcategory-tree:319

App\Models\SeoText: 1
App\Models\Categories: 141
App\Models\CategoryDen: 147

_token: jhave7TO8VNBCt57rQUKkMm8gYomn0RdE5xvFaeh
phone_number_petricani: (022) 81 92 41
phone_number_botanica: 078 644 644
internet_magazin: 078 644 644
_previous: array:1 [ "url" => "https://agropiese.md/catalog/piese-de-schimb-35/piese-tehnica-agricola-152726/...
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/catalog/piese-de-schimb-35/piese-tehnica-agricola-152726/chervona-zirka-elvorti-152831/chervona-zirka-krnv-5-6-153210

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:20 [▶
  "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"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "host" => array:1 [▶
    0 => "agropiese.md"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "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.219.215.35"
  ]
  "x-forwarded-host" => array:1 [▶
    0 => "agropiese.md"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "x-forwarded-server" => array:1 [▶
    0 => "agropiese.md"
  ]
  "x-real-ip" => array:1 [▶
    0 => "18.219.215.35"
  ]
  "if-none-match" => array:1 [▶
    0 => ""
  ]
]

request_server

  0 of 0   
array:51 [▶
  "CONTEXT_DOCUMENT_ROOT" => "/home/agropie/public_html"
  "CONTEXT_PREFIX" => ""
  "DOCUMENT_ROOT" => "/home/agropie/public_html"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "HTTPS" => "on"
  "HTTP_ACCEPT" => "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"
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_CONNECTION" => "close"
  "HTTP_HOST" => "agropiese.md"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_SITE" => "none"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_X_FORWARDED_FOR" => "18.219.215.35"
  "HTTP_X_FORWARDED_HOST" => "agropiese.md"
  "HTTP_X_FORWARDED_PROTO" => "https"
  "HTTP_X_FORWARDED_SERVER" => "agropiese.md"
  "HTTP_X_REAL_IP" => "18.219.215.35"
  "PATH" => "/bin:/usr/bin:/usr/local/php/bin"
  "PHPRC" => "/home/agropie"
  "QUERY_STRING" => ""
  "REDIRECT_HTTPS" => "on"
  "REDIRECT_STATUS" => "200"
  "REDIRECT_UNIQUE_ID" => "aAA5CQFAMoyVlyzUvGKUNwAAAM0"
  "REDIRECT_URL" => "/catalog/piese-de-schimb-35/piese-tehnica-agricola-152726/chervona-zirka-elvorti-152831/chervona-zirka-krnv-5-6-153210"
  "REMOTE_ADDR" => "18.219.215.35"
  "REMOTE_PORT" => "36730"
  "REQUEST_METHOD" => "GET"
  "REQUEST_SCHEME" => "https"
  "REQUEST_URI" => "/catalog/piese-de-schimb-35/piese-tehnica-agricola-152726/chervona-zirka-elvorti-152831/chervona-zirka-krnv-5-6-153210"
  "SCRIPT_FILENAME" => "/home/agropie/public_html/index.php"
  "SCRIPT_NAME" => "/index.php"
  "SERVER_ADDR" => "95.217.22.64"
  "SERVER_ADMIN" => "webmaster@agropiese.md"
  "SERVER_NAME" => "agropiese.md"
  "SERVER_PORT" => "443"
  "SERVER_PROTOCOL" => "HTTP/1.0"
  "SERVER_SIGNATURE" => ""
  "SERVER_SOFTWARE" => "Apache/2.4.57 (Unix) OpenSSL/1.1.1k"
  "UNIQUE_ID" => "aAA5CQFAMoyVlyzUvGKUNwAAAM0"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1744845065.586
  "REQUEST_TIME" => 1744845065
  "argv" => []
  "argc" => 0
]

request_cookies

[]

response_headers

  0 of 0   
array:8 [▶
  "cache-control" => array:1 [▶
    0 => "max-age=2628000, public"
  ]
  "date" => array:1 [▶
    0 => "Wed, 16 Apr 2025 23:11:06 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => -1
  ]
  "etag" => array:1 [▶
    0 => ""c61b9dcf0dd10c73974b402acc815697""
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InNieEJVN0FDNWJOcmpyRTJFZ3lhUlE9PSIsInZhbHVlIjoiS1JnWkhuNTJPR3Y1R2VOUHprbXNmS3I5ZG0zKzVqdnNDXC9YcWJmZW5VSUdRYUZWSW9QTjhMd0k2V1VWa3FvODEiLCJtYWMiOiI3ZWE1OTAxM2U4YWQwMDNlODEyN2NkOGVjZTczNjliOGFhNzI2NTFhYmU0MTA1OTc0ZGMwZGJhYTVhZjFjZTM2In0%3D; expires=Thu, 17-Apr-2025 01:11:07 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6InNieEJVN0FDNWJOcmpyRTJFZ3lhUlE9PSIsInZhbHVlIjoiS1JnWkhuNTJPR3Y1R2VOUHprbXNmS3I5ZG0zKzVqdnNDXC9YcWJmZW5VSUdRYUZWSW9QTjhMd0k2V1VWa3FvODEiLCJtY ▶"
    1 => "agropiesemd_session=eyJpdiI6ImJIV3N5U1RuOHBISkxkaEpmUFJLa2c9PSIsInZhbHVlIjoiVkxTZHg4eFNNbUNBOEF5MVwvOUdkTEFCZVwvRjRLOHVrSkVtcFdxU1lXdnpcL08waGZUTjBRQms4cEhJblBxQ2RRVCIsIm1hYyI6ImUwNzllZTAyZmY4MjkyNzBkNmM3ZjFjOWQ5NWM2NmQzODZhNmY2ZTU1OGI5MDM5YWI2MzJmMzIzYWZmMDBlN2YifQ%3D%3D; expires=Thu, 17-Apr-2025 01:11:07 GMT; Max-Age=7200; path=/; httponly ◀agropiesemd_session=eyJpdiI6ImJIV3N5U1RuOHBISkxkaEpmUFJLa2c9PSIsInZhbHVlIjoiVkxTZHg4eFNNbUNBOEF5MVwvOUdkTEFCZVwvRjRLOHVrSkVtcFdxU1lXdnpcL08waGZUTjBRQms4cEhJblBx ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InNieEJVN0FDNWJOcmpyRTJFZ3lhUlE9PSIsInZhbHVlIjoiS1JnWkhuNTJPR3Y1R2VOUHprbXNmS3I5ZG0zKzVqdnNDXC9YcWJmZW5VSUdRYUZWSW9QTjhMd0k2V1VWa3FvODEiLCJtYWMiOiI3ZWE1OTAxM2U4YWQwMDNlODEyN2NkOGVjZTczNjliOGFhNzI2NTFhYmU0MTA1OTc0ZGMwZGJhYTVhZjFjZTM2In0%3D; expires=Thu, 17-Apr-2025 01:11:07 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InNieEJVN0FDNWJOcmpyRTJFZ3lhUlE9PSIsInZhbHVlIjoiS1JnWkhuNTJPR3Y1R2VOUHprbXNmS3I5ZG0zKzVqdnNDXC9YcWJmZW5VSUdRYUZWSW9QTjhMd0k2V1VWa3FvODEiLCJtY ▶"
    1 => "agropiesemd_session=eyJpdiI6ImJIV3N5U1RuOHBISkxkaEpmUFJLa2c9PSIsInZhbHVlIjoiVkxTZHg4eFNNbUNBOEF5MVwvOUdkTEFCZVwvRjRLOHVrSkVtcFdxU1lXdnpcL08waGZUTjBRQms4cEhJblBxQ2RRVCIsIm1hYyI6ImUwNzllZTAyZmY4MjkyNzBkNmM3ZjFjOWQ5NWM2NmQzODZhNmY2ZTU1OGI5MDM5YWI2MzJmMzIzYWZmMDBlN2YifQ%3D%3D; expires=Thu, 17-Apr-2025 01:11:07 GMT; path=/; httponly ◀agropiesemd_session=eyJpdiI6ImJIV3N5U1RuOHBISkxkaEpmUFJLa2c9PSIsInZhbHVlIjoiVkxTZHg4eFNNbUNBOEF5MVwvOUdkTEFCZVwvRjRLOHVrSkVtcFdxU1lXdnpcL08waGZUTjBRQms4cEhJblBx ▶"
  ]
]

session_attributes

  0 of 0   
array:7 [▶
  "_token" => "jhave7TO8VNBCt57rQUKkMm8gYomn0RdE5xvFaeh"
  "phone_number_petricani" => "(022) 81 92 41"
  "phone_number_botanica" => "078 644 644"
  "internet_magazin" => "078 644 644"
  "_previous" => array:1 [▶
    "url" => "https://agropiese.md/catalog/piese-de-schimb-35/piese-tehnica-agricola-152726/chervona-zirka-elvorti-152831/chervona-zirka-krnv-5-6-153210"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

Params
0	`pageTitle`
1	`pageMeta`
2	`h1`
3	`pageUrl`
4	`linkUrl`
5	`switchUrl`
6	`alternateLang`
7	`subCategories`
8	`category`
9	`products`
10	`categoryDen`
11	`tree`
12	`open`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`breadCrumbList`
4	`breadCrumbHtml`
5	`errors`
6	`alternateLang`
7	`pageTitle`
8	`pageMeta`
9	`h1`
10	`pageUrl`
11	`linkUrl`
12	`switchUrl`
13	`subCategories`
14	`category`
15	`products`
16	`categoryDen`
17	`tree`
18	`open`
19	`localBussiness`
20	`rootCategories`
21	`seoBlockContent`

1 x Application (90.4%)	1.47s
1 x Booting (9.53%)	155.07ms

Chervona Zirka КРНВ-5,6