Messages Timeline Exceptions Views2 Route Queries7 Models27 Mails Gate Session Request

7.3.33882ms20MBGET ru/poisk

Booting (72.78ms)
Application (808ms)
1 x Application (91.6%)
807.62ms
1 x Booting (8.25%)
72.78ms

2 templates were rendered

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


products
promotions
total
searchString
pageTitle
alternateLang
switchUrl
pageUrl

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


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

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

7 statements were executed750ms

select * from `products` where (exists (select * from `product_data` where `products`.`id` = `product_data`.`product_id` and (`sku` LIKE '%скрт 45%' or `name` LIKE '%скрт 45%' or (`sku` LIKE '%скрт%' and `sku` LIKE '%45%') or (`name` LIKE '%скрт%' and `name` LIKE '%45%')) and `lang` = 'ru') or exists (select * from `product_data` where `products`.`id` = `product_data`.`product_id` and (`sku` LIKE '%скрт 45%' or `name` LIKE '%скрт 45%' or (`sku` LIKE '%скрт%' and `sku` LIKE '%45%') or (`name` LIKE '%скрт%' and `name` LIKE '%45%')) and `lang` != 'ru') 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

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

Metadata
Bindings	0. %скрт 45% 1. %скрт 45% 2. %скрт% 3. %45% 4. %скрт% 5. %45% 6. ru 7. %скрт 45% 8. %скрт 45% 9. %скрт% 10. %45% 11. %скрт% 12. %45% 13. ru 14. 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 `products` where (`search` LIKE '%скрт 45%' or `id` = 'скрт 45') and `products`.`deleted_at` is null

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

Metadata
Bindings	0. %скрт 45% 1. скрт 45
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 `categories` where `parent_id` is null520μ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` = 'ru' and `category_den`.`category_id` in (5, 6, 19, 31, 34, 35, 36, 37, 38, 39, 40, 159115, 160195)

1.11ms/app/Providers/ComposerServiceProvider.php:36agropies_db

Metadata
Bindings	0. ru
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` = 'ru.search.index') limit 1350μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23agropies_db

Metadata
Bindings	0. ru.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 null32.56ms/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 null27.15ms/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: 13
App\Models\Categories: 13

_token: u6gfz2U92JEHGQmwU4SIstjPFbTME0oumUrwteSP
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/ru/poisk?for=%D0%A1%D0%9A%D0%A0%D0%A2%2045" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/ru/poisk

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▶
  "for" => "СКРТ 45"
]

request_request

  0 of 0   
array:1 [▶
  "for" => "СКРТ 45"
]

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 => ""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 => "3.17.177.21"
  ]
  "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 => "3.17.177.21"
  ]
]

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" => ""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" => "3.17.177.21"
  "HTTP_X_FORWARDED_HOST" => "agropiese.md"
  "HTTP_X_FORWARDED_PROTO" => "https"
  "HTTP_X_FORWARDED_SERVER" => "agropiese.md"
  "HTTP_X_REAL_IP" => "3.17.177.21"
  "PATH" => "/bin:/usr/bin:/usr/local/php/bin"
  "PHPRC" => "/home/agropie"
  "QUERY_STRING" => "for=%D0%A1%D0%9A%D0%A0%D0%A2+45"
  "REDIRECT_HTTPS" => "on"
  "REDIRECT_QUERY_STRING" => "for=%D0%A1%D0%9A%D0%A0%D0%A2+45"
  "REDIRECT_STATUS" => "200"
  "REDIRECT_UNIQUE_ID" => "Z9Xa_rdQp1oq33NIye89KgAAAJE"
  "REDIRECT_URL" => "/ru/poisk"
  "REMOTE_ADDR" => "3.17.177.21"
  "REMOTE_PORT" => "41134"
  "REQUEST_METHOD" => "GET"
  "REQUEST_SCHEME" => "https"
  "REQUEST_URI" => "/ru/poisk?for=%D0%A1%D0%9A%D0%A0%D0%A2+45"
  "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" => "Z9Xa_rdQp1oq33NIye89KgAAAJE"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1742068478.9362
  "REQUEST_TIME" => 1742068478
  "argv" => array:2 [▶
    0 => "for=%D0%A1%D0%9A%D0%A0%D0%A2"
    1 => "45"
  ]
  "argc" => 2
]

request_cookies

[]

response_headers

  0 of 0   
array:7 [▶
  "cache-control" => array:1 [▶
    0 => "private, must-revalidate"
  ]
  "date" => array:1 [▶
    0 => "Sat, 15 Mar 2025 19:54:39 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=eyJpdiI6ImZOQ3RuQm9IVTZ6ZHcwakJkMGNhSnc9PSIsInZhbHVlIjoicjRMQTNrVURwb1lta0hYNlNxQ1psSWhDeDNBUWM5UktFNWFDOGV6aDF5QWxoUFZuWlBYaHdxSVlcL1VuaG11UWUiLCJtYWMiOiJiYjBjZmIwNjEyZDUwZjU4YjRjZTZkZmVkOTAxZWI2ZWU4YmVlNWEyMzgyNGMyMzUxNDMwODk0YmI5ODRlNjQwIn0%3D; expires=Sat, 15-Mar-2025 21:54:39 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6ImZOQ3RuQm9IVTZ6ZHcwakJkMGNhSnc9PSIsInZhbHVlIjoicjRMQTNrVURwb1lta0hYNlNxQ1psSWhDeDNBUWM5UktFNWFDOGV6aDF5QWxoUFZuWlBYaHdxSVlcL1VuaG11UWUiLCJtY ▶"
    1 => "agropiesemd_session=eyJpdiI6Iko0TDdVdFJyb0pxSDA2Y243ZjRZV2c9PSIsInZhbHVlIjoiVytab3ZNRVJJeXFIS29Tbno1amdNTmFZZ2FFdjRjeStRUkF2NzR6M1BhYTZTcjJNdTBXREhwOVU1UCtYSFwvSjYiLCJtYWMiOiI3NDRlZDZkYzgyNGE4MmZkYTQyYmMwMjk2MTc3ODkyN2I5NTRhYTI2ODdlOGI2NWMyMzQ5Y2UyYzg4NGUzOTc1In0%3D; expires=Sat, 15-Mar-2025 21:54:39 GMT; Max-Age=7200; path=/; httponly ◀agropiesemd_session=eyJpdiI6Iko0TDdVdFJyb0pxSDA2Y243ZjRZV2c9PSIsInZhbHVlIjoiVytab3ZNRVJJeXFIS29Tbno1amdNTmFZZ2FFdjRjeStRUkF2NzR6M1BhYTZTcjJNdTBXREhwOVU1UCtYSFwv ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImZOQ3RuQm9IVTZ6ZHcwakJkMGNhSnc9PSIsInZhbHVlIjoicjRMQTNrVURwb1lta0hYNlNxQ1psSWhDeDNBUWM5UktFNWFDOGV6aDF5QWxoUFZuWlBYaHdxSVlcL1VuaG11UWUiLCJtYWMiOiJiYjBjZmIwNjEyZDUwZjU4YjRjZTZkZmVkOTAxZWI2ZWU4YmVlNWEyMzgyNGMyMzUxNDMwODk0YmI5ODRlNjQwIn0%3D; expires=Sat, 15-Mar-2025 21:54:39 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImZOQ3RuQm9IVTZ6ZHcwakJkMGNhSnc9PSIsInZhbHVlIjoicjRMQTNrVURwb1lta0hYNlNxQ1psSWhDeDNBUWM5UktFNWFDOGV6aDF5QWxoUFZuWlBYaHdxSVlcL1VuaG11UWUiLCJtY ▶"
    1 => "agropiesemd_session=eyJpdiI6Iko0TDdVdFJyb0pxSDA2Y243ZjRZV2c9PSIsInZhbHVlIjoiVytab3ZNRVJJeXFIS29Tbno1amdNTmFZZ2FFdjRjeStRUkF2NzR6M1BhYTZTcjJNdTBXREhwOVU1UCtYSFwvSjYiLCJtYWMiOiI3NDRlZDZkYzgyNGE4MmZkYTQyYmMwMjk2MTc3ODkyN2I5NTRhYTI2ODdlOGI2NWMyMzQ5Y2UyYzg4NGUzOTc1In0%3D; expires=Sat, 15-Mar-2025 21:54:39 GMT; path=/; httponly ◀agropiesemd_session=eyJpdiI6Iko0TDdVdFJyb0pxSDA2Y243ZjRZV2c9PSIsInZhbHVlIjoiVytab3ZNRVJJeXFIS29Tbno1amdNTmFZZ2FFdjRjeStRUkF2NzR6M1BhYTZTcjJNdTBXREhwOVU1UCtYSFwv ▶"
  ]
]

session_attributes

  0 of 0   
array:7 [▶
  "_token" => "u6gfz2U92JEHGQmwU4SIstjPFbTME0oumUrwteSP"
  "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/ru/poisk?for=%D0%A1%D0%9A%D0%A0%D0%A2%2045"
  ]
  "_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	`loop`
16	`localBussiness`
17	`rootCategories`
18	`seoBlockContent`

1 x Application (91.6%)	807.62ms
1 x Booting (8.25%)	72.78ms

Результат поиска