Messages Timeline Exceptions Views3 Route Queries21 Models2949 Mails Gate Session Request

7.3.331.27s24MBGET cautare

Booting (115ms)
Application (1.15s)
1 x Application (90.89%)
1.15s
1 x Booting (9.02%)
114.54ms

3 templates were rendered

front.search (resources/views/front/search.blade.php)8blade


products
promotions
total
searchString
pageTitle
alternateLang
switchUrl
pageUrl

pagination::bootstrap-4 (resources/views/vendor/pagination/bootstrap-4.blade.php)2blade
Params
0
paginator
1
elements

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


obLevel
__env
app
breadCrumbList
breadCrumbHtml
errors
alternateLang
products
promotions
total
searchString
pageTitle
switchUrl
pageUrl
__currentLoopData
product
loop
param
localBussiness
rootCategories
seoBlockContent

uri: GET cautare
middleware: web
localized-routes-locale: ro
as: ro.search.index
controller: App\Http\Controllers\SearchController@index
namespace: App\Http\Controllers
prefix
where
file: app/Http/Controllers/SearchController.php:25-568

21 statements were executed, 10 of which were duplicated, 11 unique1.03s

select * from `products` where (exists (select * from `product_data` where `products`.`id` = `product_data`.`product_id` and (`sku` LIKE '%rheinol%' or `name` LIKE '%rheinol%' or (`sku` LIKE '%rheinol%') or (`name` LIKE '%rheinol%')) and `lang` = 'ro') or exists (select * from `product_data` where `products`.`id` = `product_data`.`product_id` and (`sku` LIKE '%rheinol%' or `name` LIKE '%rheinol%' or (`sku` LIKE '%rheinol%') or (`name` LIKE '%rheinol%')) and `lang` != 'ro') and `stock` > 0 and exists (select * from `categories` inner join `product_to_category` on `product_to_category`.`category_id` = `categories`.`id` where `products`.`id` = `product_to_category`.`product_id`)) and `products`.`deleted_at` is null

817ms/app/Http/Controllers/SearchController.php:109agropies_db

Metadata
Bindings	0. %rheinol% 1. %rheinol% 2. %rheinol% 3. %rheinol% 4. ro 5. %rheinol% 6. %rheinol% 7. %rheinol% 8. %rheinol% 9. ro 10. 0
Backtrace	14. /app/Http/Controllers/SearchController.php:109 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `product_data` where `lang` = 'ro' and `product_data`.`product_id` in (99334, 99335, 99337, 99338, 99339, 99340, 99341, 99342, 99343, 99344, 99345, 99346, 99347, 99348, 99349, 99350, 99351, 99352, 99354, 99355, 99356, 99357, 99358, 99359, 99360, 99361, 99362, 99363, 99364, 99365, 99366, 99367, 99663, 99664, 99665, 99666, 99667, 99668, 99670, 99671, 99673, 99674, 99675, 101815, 101816, 101817, 101818, 101819, 101820, 101821, 101822, 101823, 101824, 101825, 101826, 101827, 101828, 101829, 101830, 101831, 101832, 101833, 101835, 101836, 101837, 101838, 101839, 101840, 101841, 101842, 101843, 101844, 103985, 103986, 103988, 103989, 103991, 103992, 103993, 103994, 103995, 105244, 105750, 105751, 105752, 105753, 105754, 105755, 105756, 105757, 105758, 105759, 105760, 105761, 105762, 105763, 105765, 105766, 105767, 105768, 105769, 105770, 105771, 105772, 105773, 105775, 105776, 105777, 105778, 105779, 107004, 107005, 107006, 108896, 117818, 117819, 122098, 124265, 130606, 141401, 141402, 141403, 141404, 148635, 148636, 155426, 184474, 187300, 187301, 193825, 193826, 213394, 213395, 213396, 217413, 218948, 224125, 237690, 252025, 252026, 252027)

1.59ms/app/Http/Controllers/SearchController.php:109agropies_db

Metadata
Bindings	0. ro
Backtrace	19. /app/Http/Controllers/SearchController.php:109 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 25. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `product_data` where `lang` != 'ro' and `product_data`.`product_id` in (99334, 99335, 99337, 99338, 99339, 99340, 99341, 99342, 99343, 99344, 99345, 99346, 99347, 99348, 99349, 99350, 99351, 99352, 99354, 99355, 99356, 99357, 99358, 99359, 99360, 99361, 99362, 99363, 99364, 99365, 99366, 99367, 99663, 99664, 99665, 99666, 99667, 99668, 99670, 99671, 99673, 99674, 99675, 101815, 101816, 101817, 101818, 101819, 101820, 101821, 101822, 101823, 101824, 101825, 101826, 101827, 101828, 101829, 101830, 101831, 101832, 101833, 101835, 101836, 101837, 101838, 101839, 101840, 101841, 101842, 101843, 101844, 103985, 103986, 103988, 103989, 103991, 103992, 103993, 103994, 103995, 105244, 105750, 105751, 105752, 105753, 105754, 105755, 105756, 105757, 105758, 105759, 105760, 105761, 105762, 105763, 105765, 105766, 105767, 105768, 105769, 105770, 105771, 105772, 105773, 105775, 105776, 105777, 105778, 105779, 107004, 107005, 107006, 108896, 117818, 117819, 122098, 124265, 130606, 141401, 141402, 141403, 141404, 148635, 148636, 155426, 184474, 187300, 187301, 193825, 193826, 213394, 213395, 213396, 217413, 218948, 224125, 237690, 252025, 252026, 252027)

4.79ms/app/Http/Controllers/SearchController.php:109agropies_db

Metadata
Bindings	0. ro
Backtrace	19. /app/Http/Controllers/SearchController.php:109 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 25. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `product_params` where `lang` = 'ro' and `product_params`.`product_id` in (99334, 99335, 99337, 99338, 99339, 99340, 99341, 99342, 99343, 99344, 99345, 99346, 99347, 99348, 99349, 99350, 99351, 99352, 99354, 99355, 99356, 99357, 99358, 99359, 99360, 99361, 99362, 99363, 99364, 99365, 99366, 99367, 99663, 99664, 99665, 99666, 99667, 99668, 99670, 99671, 99673, 99674, 99675, 101815, 101816, 101817, 101818, 101819, 101820, 101821, 101822, 101823, 101824, 101825, 101826, 101827, 101828, 101829, 101830, 101831, 101832, 101833, 101835, 101836, 101837, 101838, 101839, 101840, 101841, 101842, 101843, 101844, 103985, 103986, 103988, 103989, 103991, 103992, 103993, 103994, 103995, 105244, 105750, 105751, 105752, 105753, 105754, 105755, 105756, 105757, 105758, 105759, 105760, 105761, 105762, 105763, 105765, 105766, 105767, 105768, 105769, 105770, 105771, 105772, 105773, 105775, 105776, 105777, 105778, 105779, 107004, 107005, 107006, 108896, 117818, 117819, 122098, 124265, 130606, 141401, 141402, 141403, 141404, 148635, 148636, 155426, 184474, 187300, 187301, 193825, 193826, 213394, 213395, 213396, 217413, 218948, 224125, 237690, 252025, 252026, 252027)

5.1ms/app/Http/Controllers/SearchController.php:109agropies_db

Metadata
Bindings	0. ro
Backtrace	19. /app/Http/Controllers/SearchController.php:109 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 25. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `params` where `lang` = 'ro' and `params`.`param_id` in (1, 12, 13, 14, 17, 21, 22, 23, 149, 153, 154, 163, 164, 197)

410μs/app/Http/Controllers/SearchController.php:109agropies_db

Metadata
Bindings	0. ro 1. 1 2. 12 3. 13 4. 14 5. 17 6. 21 7. 22 8. 23 9. 149 10. 153 11. 154 12. 163 13. 164 14. 197
Backtrace	24. /app/Http/Controllers/SearchController.php:109 27. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 30. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `product_params` where `param_id` = 10 and `lang` = 'ro' and `product_params`.`product_id` in (99334, 99335, 99337, 99338, 99339, 99340, 99341, 99342, 99343, 99344, 99345, 99346, 99347, 99348, 99349, 99350, 99351, 99352, 99354, 99355, 99356, 99357, 99358, 99359, 99360, 99361, 99362, 99363, 99364, 99365, 99366, 99367, 99663, 99664, 99665, 99666, 99667, 99668, 99670, 99671, 99673, 99674, 99675, 101815, 101816, 101817, 101818, 101819, 101820, 101821, 101822, 101823, 101824, 101825, 101826, 101827, 101828, 101829, 101830, 101831, 101832, 101833, 101835, 101836, 101837, 101838, 101839, 101840, 101841, 101842, 101843, 101844, 103985, 103986, 103988, 103989, 103991, 103992, 103993, 103994, 103995, 105244, 105750, 105751, 105752, 105753, 105754, 105755, 105756, 105757, 105758, 105759, 105760, 105761, 105762, 105763, 105765, 105766, 105767, 105768, 105769, 105770, 105771, 105772, 105773, 105775, 105776, 105777, 105778, 105779, 107004, 107005, 107006, 108896, 117818, 117819, 122098, 124265, 130606, 141401, 141402, 141403, 141404, 148635, 148636, 155426, 184474, 187300, 187301, 193825, 193826, 213394, 213395, 213396, 217413, 218948, 224125, 237690, 252025, 252026, 252027)

1.56ms/app/Http/Controllers/SearchController.php:109agropies_db

Metadata
Bindings	0. 10 1. ro
Backtrace	19. /app/Http/Controllers/SearchController.php:109 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 25. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `products` where (`search` LIKE '%rheinol%' or `id` = 'rheinol') and `products`.`deleted_at` is null144ms/app/Http/Controllers/SearchController.php:110agropies_db

Metadata
Bindings	0. %rheinol% 1. rheinol
Backtrace	14. /app/Http/Controllers/SearchController.php:110 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `product_data` where `lang` = 'ro' and `product_data`.`product_id` in (99334, 99335, 99337, 99338, 99339, 99340, 99341, 99342, 99343, 99344, 99345, 99346, 99347, 99348, 99349, 99350, 99351, 99352, 99354, 99355, 99356, 99357, 99358, 99359, 99360, 99361, 99362, 99363, 99364, 99365, 99366, 99367, 99663, 99664, 99665, 99666, 99667, 99668, 99670, 99671, 99673, 99674, 99675, 101815, 101816, 101817, 101818, 101819, 101820, 101821, 101822, 101823, 101824, 101825, 101826, 101827, 101828, 101829, 101830, 101831, 101832, 101833, 101835, 101836, 101837, 101838, 101839, 101840, 101841, 101842, 101843, 101844, 103985, 103986, 103988, 103989, 103991, 103992, 103993, 103994, 103995, 105244, 105750, 105751, 105752, 105753, 105754, 105755, 105756, 105757, 105758, 105759, 105760, 105761, 105762, 105763, 105765, 105766, 105767, 105768, 105769, 105770, 105771, 105772, 105773, 105775, 105776, 105777, 105778, 105779, 107004, 107005, 107006, 108896, 117818, 117819, 122098, 124265, 130606, 141401, 141402, 141403, 141404, 148635, 148636, 155426, 184474, 187300, 187301, 193825, 193826, 213394, 213395, 213396, 217413, 218948, 224125, 237690, 252025, 252026, 252027)

1.75ms/app/Http/Controllers/SearchController.php:110agropies_db

Metadata
Bindings	0. ro
Backtrace	19. /app/Http/Controllers/SearchController.php:110 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 25. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `product_data` where `lang` != 'ro' and `product_data`.`product_id` in (99334, 99335, 99337, 99338, 99339, 99340, 99341, 99342, 99343, 99344, 99345, 99346, 99347, 99348, 99349, 99350, 99351, 99352, 99354, 99355, 99356, 99357, 99358, 99359, 99360, 99361, 99362, 99363, 99364, 99365, 99366, 99367, 99663, 99664, 99665, 99666, 99667, 99668, 99670, 99671, 99673, 99674, 99675, 101815, 101816, 101817, 101818, 101819, 101820, 101821, 101822, 101823, 101824, 101825, 101826, 101827, 101828, 101829, 101830, 101831, 101832, 101833, 101835, 101836, 101837, 101838, 101839, 101840, 101841, 101842, 101843, 101844, 103985, 103986, 103988, 103989, 103991, 103992, 103993, 103994, 103995, 105244, 105750, 105751, 105752, 105753, 105754, 105755, 105756, 105757, 105758, 105759, 105760, 105761, 105762, 105763, 105765, 105766, 105767, 105768, 105769, 105770, 105771, 105772, 105773, 105775, 105776, 105777, 105778, 105779, 107004, 107005, 107006, 108896, 117818, 117819, 122098, 124265, 130606, 141401, 141402, 141403, 141404, 148635, 148636, 155426, 184474, 187300, 187301, 193825, 193826, 213394, 213395, 213396, 217413, 218948, 224125, 237690, 252025, 252026, 252027)

5.39ms/app/Http/Controllers/SearchController.php:110agropies_db

Metadata
Bindings	0. ro
Backtrace	19. /app/Http/Controllers/SearchController.php:110 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 25. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `product_params` where `lang` = 'ro' and `product_params`.`product_id` in (99334, 99335, 99337, 99338, 99339, 99340, 99341, 99342, 99343, 99344, 99345, 99346, 99347, 99348, 99349, 99350, 99351, 99352, 99354, 99355, 99356, 99357, 99358, 99359, 99360, 99361, 99362, 99363, 99364, 99365, 99366, 99367, 99663, 99664, 99665, 99666, 99667, 99668, 99670, 99671, 99673, 99674, 99675, 101815, 101816, 101817, 101818, 101819, 101820, 101821, 101822, 101823, 101824, 101825, 101826, 101827, 101828, 101829, 101830, 101831, 101832, 101833, 101835, 101836, 101837, 101838, 101839, 101840, 101841, 101842, 101843, 101844, 103985, 103986, 103988, 103989, 103991, 103992, 103993, 103994, 103995, 105244, 105750, 105751, 105752, 105753, 105754, 105755, 105756, 105757, 105758, 105759, 105760, 105761, 105762, 105763, 105765, 105766, 105767, 105768, 105769, 105770, 105771, 105772, 105773, 105775, 105776, 105777, 105778, 105779, 107004, 107005, 107006, 108896, 117818, 117819, 122098, 124265, 130606, 141401, 141402, 141403, 141404, 148635, 148636, 155426, 184474, 187300, 187301, 193825, 193826, 213394, 213395, 213396, 217413, 218948, 224125, 237690, 252025, 252026, 252027)

5.56ms/app/Http/Controllers/SearchController.php:110agropies_db

Metadata
Bindings	0. ro
Backtrace	19. /app/Http/Controllers/SearchController.php:110 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 25. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `params` where `lang` = 'ro' and `params`.`param_id` in (1, 12, 13, 14, 17, 21, 22, 23, 149, 153, 154, 163, 164, 197)

430μs/app/Http/Controllers/SearchController.php:110agropies_db

Metadata
Bindings	0. ro 1. 1 2. 12 3. 13 4. 14 5. 17 6. 21 7. 22 8. 23 9. 149 10. 153 11. 154 12. 163 13. 164 14. 197
Backtrace	24. /app/Http/Controllers/SearchController.php:110 27. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 28. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 30. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select * from `product_params` where `param_id` = 10 and `lang` = 'ro' and `product_params`.`product_id` in (99334, 99335, 99337, 99338, 99339, 99340, 99341, 99342, 99343, 99344, 99345, 99346, 99347, 99348, 99349, 99350, 99351, 99352, 99354, 99355, 99356, 99357, 99358, 99359, 99360, 99361, 99362, 99363, 99364, 99365, 99366, 99367, 99663, 99664, 99665, 99666, 99667, 99668, 99670, 99671, 99673, 99674, 99675, 101815, 101816, 101817, 101818, 101819, 101820, 101821, 101822, 101823, 101824, 101825, 101826, 101827, 101828, 101829, 101830, 101831, 101832, 101833, 101835, 101836, 101837, 101838, 101839, 101840, 101841, 101842, 101843, 101844, 103985, 103986, 103988, 103989, 103991, 103992, 103993, 103994, 103995, 105244, 105750, 105751, 105752, 105753, 105754, 105755, 105756, 105757, 105758, 105759, 105760, 105761, 105762, 105763, 105765, 105766, 105767, 105768, 105769, 105770, 105771, 105772, 105773, 105775, 105776, 105777, 105778, 105779, 107004, 107005, 107006, 108896, 117818, 117819, 122098, 124265, 130606, 141401, 141402, 141403, 141404, 148635, 148636, 155426, 184474, 187300, 187301, 193825, 193826, 213394, 213395, 213396, 217413, 218948, 224125, 237690, 252025, 252026, 252027)

1.12ms/app/Http/Controllers/SearchController.php:110agropies_db

Metadata
Bindings	0. 10 1. ro
Backtrace	19. /app/Http/Controllers/SearchController.php:110 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 25. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680

select `categories`.*, `product_to_category`.`product_id` as `laravel_through_key` from `categories` inner join `product_to_category` on `product_to_category`.`category_id` = `categories`.`id` where `product_to_category`.`product_id` = 252027 limit 1

570μsview::front.search:52agropies_db

Metadata
Bindings	0. 252027
Backtrace	20. view::front.search:52 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 23. /vendor/laravel/framework/src/Illuminate/View/View.php:142 24. /vendor/laravel/framework/src/Illuminate/View/View.php:125 25. /vendor/laravel/framework/src/Illuminate/View/View.php:90

select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (9)280μsview::front.search:52agropies_db

Metadata
Bindings	0. ro
Backtrace	25. view::front.search:52 27. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 28. /vendor/laravel/framework/src/Illuminate/View/View.php:142 29. /vendor/laravel/framework/src/Illuminate/View/View.php:125 30. /vendor/laravel/framework/src/Illuminate/View/View.php:90

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

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

Metadata
Bindings	0. 9
Backtrace	14. /vendor/kalnoy/nestedset/src/QueryBuilder.php:170 15. /app/Models/Product.php:150 16. view::front.search:54 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 19. /vendor/laravel/framework/src/Illuminate/View/View.php:142

select * from `category_den` where `lang` = 'ro' and `category_den`.`category_id` in (6, 9)320μ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/Product.php:150 21. view::front.search:54 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 24. /vendor/laravel/framework/src/Illuminate/View/View.php:142

select * from `categories` where `parent_id` is null270μ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.search:219

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)

580μ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.search:219

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

Metadata
Bindings	0. ro.search.index
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 null20.04ms/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.search:219

select max(`price`) as aggregate from `products` where `stock` > 0 and `products`.`deleted_at` is null19.3ms/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.search:219

App\Models\SeoText: 1
App\Models\CategoryDen: 16
App\Models\Categories: 16
App\Models\Param: 28
App\Models\ProductParam: 2042
App\Models\ProductData: 564
App\Models\Product: 282

_token: w0LBOUjllkmXFLgWw5EtC65yCEsqWdmDyKyRSLMu
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/cautare?for=Rheinol&page=8" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/cautare

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:2 [▶
  "for" => "Rheinol"
  "page" => "8"
]

request_request

  0 of 0   
array:2 [▶
  "for" => "Rheinol"
  "page" => "8"
]

request_headers

  0 of 0   
array:19 [▶
  "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 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "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.128.212"
  ]
  "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.128.212"
  ]
]

request_server

  0 of 0   
array:52 [▶
  "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" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  "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.128.212"
  "HTTP_X_FORWARDED_HOST" => "agropiese.md"
  "HTTP_X_FORWARDED_PROTO" => "https"
  "HTTP_X_FORWARDED_SERVER" => "agropiese.md"
  "HTTP_X_REAL_IP" => "18.219.128.212"
  "PATH" => "/bin:/usr/bin:/usr/local/php/bin"
  "PHPRC" => "/home/agropie"
  "QUERY_STRING" => "for=Rheinol&page=8"
  "REDIRECT_HTTPS" => "on"
  "REDIRECT_QUERY_STRING" => "for=Rheinol&page=8"
  "REDIRECT_STATUS" => "200"
  "REDIRECT_UNIQUE_ID" => "aBJe0sV6BZYIlU8yz8u5dQAAAM0"
  "REDIRECT_URL" => "/cautare"
  "REMOTE_ADDR" => "18.219.128.212"
  "REMOTE_PORT" => "59282"
  "REQUEST_METHOD" => "GET"
  "REQUEST_SCHEME" => "https"
  "REQUEST_URI" => "/cautare?for=Rheinol&page=8"
  "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" => "aBJe0sV6BZYIlU8yz8u5dQAAAM0"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1746034386.9591
  "REQUEST_TIME" => 1746034386
  "argv" => array:1 [▶
    0 => "for=Rheinol&page=8"
  ]
  "argc" => 1
]

request_cookies

[]

response_headers

  0 of 0   
array:7 [▶
  "cache-control" => array:1 [▶
    0 => "private, must-revalidate"
  ]
  "date" => array:1 [▶
    0 => "Wed, 30 Apr 2025 17:33:08 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => -1
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Imp1dm9PaVNocklMUVlObkdnNzRyNkE9PSIsInZhbHVlIjoiRDBMaHIrazFreTZ2ZDgzUTVsdDE0OFRYUzlRYlkyKyswNFdyaURvU2s5WEoyelU3MnJtWjNFRHJ5WUg1UlFRKyIsIm1hYyI6IjMxOGE1NDFkYjFjN2MzNGE0NTI3YjZjNjg3OGNiODBjOTAzZDRmNzRjNjhhNzcwNGU2NTAzZmQ1ZmE1M2ZhZjcifQ%3D%3D; expires=Wed, 30-Apr-2025 19:33:08 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6Imp1dm9PaVNocklMUVlObkdnNzRyNkE9PSIsInZhbHVlIjoiRDBMaHIrazFreTZ2ZDgzUTVsdDE0OFRYUzlRYlkyKyswNFdyaURvU2s5WEoyelU3MnJtWjNFRHJ5WUg1UlFRKyIsIm1hY ▶"
    1 => "agropiesemd_session=eyJpdiI6ImNkdTJJeTk4SzE5S1c2T0tVbDNUYWc9PSIsInZhbHVlIjoiRGlKbm9YK3lZWDNEN0pFWlNkMXpndThXV1J4WUVsUFM2bDY4bU9ZZUtiM0Z0TW5ZSkVCYXlOQTl4T0ZpMmhZMSIsIm1hYyI6IjBjOTZiMjc0OTAxZTg5MTFiOGRkNmUxYzgwMTkwN2QyNDg1MjJkNDZkNDZlOGQxYzNkYzUxZDM0NjNjZjQ3ZmYifQ%3D%3D; expires=Wed, 30-Apr-2025 19:33:08 GMT; Max-Age=7200; path=/; httponly ◀agropiesemd_session=eyJpdiI6ImNkdTJJeTk4SzE5S1c2T0tVbDNUYWc9PSIsInZhbHVlIjoiRGlKbm9YK3lZWDNEN0pFWlNkMXpndThXV1J4WUVsUFM2bDY4bU9ZZUtiM0Z0TW5ZSkVCYXlOQTl4T0ZpMmhZ ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Imp1dm9PaVNocklMUVlObkdnNzRyNkE9PSIsInZhbHVlIjoiRDBMaHIrazFreTZ2ZDgzUTVsdDE0OFRYUzlRYlkyKyswNFdyaURvU2s5WEoyelU3MnJtWjNFRHJ5WUg1UlFRKyIsIm1hYyI6IjMxOGE1NDFkYjFjN2MzNGE0NTI3YjZjNjg3OGNiODBjOTAzZDRmNzRjNjhhNzcwNGU2NTAzZmQ1ZmE1M2ZhZjcifQ%3D%3D; expires=Wed, 30-Apr-2025 19:33:08 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Imp1dm9PaVNocklMUVlObkdnNzRyNkE9PSIsInZhbHVlIjoiRDBMaHIrazFreTZ2ZDgzUTVsdDE0OFRYUzlRYlkyKyswNFdyaURvU2s5WEoyelU3MnJtWjNFRHJ5WUg1UlFRKyIsIm1hY ▶"
    1 => "agropiesemd_session=eyJpdiI6ImNkdTJJeTk4SzE5S1c2T0tVbDNUYWc9PSIsInZhbHVlIjoiRGlKbm9YK3lZWDNEN0pFWlNkMXpndThXV1J4WUVsUFM2bDY4bU9ZZUtiM0Z0TW5ZSkVCYXlOQTl4T0ZpMmhZMSIsIm1hYyI6IjBjOTZiMjc0OTAxZTg5MTFiOGRkNmUxYzgwMTkwN2QyNDg1MjJkNDZkNDZlOGQxYzNkYzUxZDM0NjNjZjQ3ZmYifQ%3D%3D; expires=Wed, 30-Apr-2025 19:33:08 GMT; path=/; httponly ◀agropiesemd_session=eyJpdiI6ImNkdTJJeTk4SzE5S1c2T0tVbDNUYWc9PSIsInZhbHVlIjoiRGlKbm9YK3lZWDNEN0pFWlNkMXpndThXV1J4WUVsUFM2bDY4bU9ZZUtiM0Z0TW5ZSkVCYXlOQTl4T0ZpMmhZ ▶"
  ]
]

session_attributes

  0 of 0   
array:7 [▶
  "_token" => "w0LBOUjllkmXFLgWw5EtC65yCEsqWdmDyKyRSLMu"
  "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/cautare?for=Rheinol&page=8"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

Params
0	`products`
1	`promotions`
2	`total`
3	`searchString`
4	`pageTitle`
5	`alternateLang`
6	`switchUrl`
7	`pageUrl`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`breadCrumbList`
4	`breadCrumbHtml`
5	`errors`
6	`alternateLang`
7	`products`
8	`promotions`
9	`total`
10	`searchString`
11	`pageTitle`
12	`switchUrl`
13	`pageUrl`
14	`__currentLoopData`
15	`product`
16	`loop`
17	`param`
18	`localBussiness`
19	`rootCategories`
20	`seoBlockContent`

1 x Application (90.89%)	1.15s
1 x Booting (9.02%)	114.54ms

Params
0	`paginator`
1	`elements`

Rezultatele căutarii