Messages Timeline Exceptions Views2 Route Queries7 Models27 Mails Gate Session Request

7.3.33772ms20MBGET cautare

Booting (74.92ms)
Application (696ms)
1 x Application (90.15%)
696.13ms
1 x Booting (9.7%)
74.92ms

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 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-620

7 statements were executed653ms

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` = 'ro') 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` != '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

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

Metadata
Bindings	0. %скрт 45% 1. %скрт 45% 2. %скрт% 3. %45% 4. %скрт% 5. %45% 6. ro 7. %скрт 45% 8. %скрт 45% 9. %скрт% 10. %45% 11. %скрт% 12. %45% 13. ro 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

130ms/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 null440μ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)

650μ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 1290μ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.64ms/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 null20.54ms/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: QERvrAxY2QymzsRQDn1g8Hva9zM9UthUkdkTb3oM
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=%D0%A1%D0%9A%D0%A0%D0%A2%2045" ]
_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:1 [▶
  "for" => "СКРТ 45"
]

request_request

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

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"
  ]
  "cookie" => array:1 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im9NQkZNQzRqVFwvVUdFSEhRNnhkUWR3PT0iLCJ2YWx1ZSI6ImplWGlkR3kxNkFxNDh6OEJOYm1IQXBIbDB1emYyM2tyb2hCMFwvY0oydWg0UnJJalRtNkRtYjVib2NXSXYzWVwvWSIsIm1hYyI6IjMyOWViYTdiMzcxYjkwNzg5NTZiNzZjZjk2MTgzNjEwOGM5ZWJkMTY2NjAzNjRmZTAxZmM0MTZjOGM1ZGRmMDUifQ%3D%3D; agropiesemd_session=eyJpdiI6Im00aXNUOG5LN2hlQUZ3VWRZZWlLR1E9PSIsInZhbHVlIjoiNkNiMFwvMEJxV3NKWVROWlwvcVRaK0RHVmNlWnhTb2x3ZkFUZDA2R0VYRzJOaEQ1RytxVFk5S3VEN0RobUNGOGVYIiwibWFjIjoiNmNjYjczMTNhZmQzMDRmYmQ2OTMzY2NhMzFmN2E3N2U2NzM5MmRhN2EwNjQzY2M5NGMxNzJjNmQ2N2U0OGRjZSJ9 ◀XSRF-TOKEN=eyJpdiI6Im9NQkZNQzRqVFwvVUdFSEhRNnhkUWR3PT0iLCJ2YWx1ZSI6ImplWGlkR3kxNkFxNDh6OEJOYm1IQXBIbDB1emYyM2tyb2hCMFwvY0oydWg0UnJJalRtNkRtYjVib2NXSXYzWVwvWSIsI ▶"
  ]
  "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.144.222.234"
  ]
  "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.144.222.234"
  ]
]

request_server

  0 of 0   
array:53 [▶
  "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_COOKIE" => "XSRF-TOKEN=eyJpdiI6Im9NQkZNQzRqVFwvVUdFSEhRNnhkUWR3PT0iLCJ2YWx1ZSI6ImplWGlkR3kxNkFxNDh6OEJOYm1IQXBIbDB1emYyM2tyb2hCMFwvY0oydWg0UnJJalRtNkRtYjVib2NXSXYzWVwvWSIsIm1hYyI6IjMyOWViYTdiMzcxYjkwNzg5NTZiNzZjZjk2MTgzNjEwOGM5ZWJkMTY2NjAzNjRmZTAxZmM0MTZjOGM1ZGRmMDUifQ%3D%3D; agropiesemd_session=eyJpdiI6Im00aXNUOG5LN2hlQUZ3VWRZZWlLR1E9PSIsInZhbHVlIjoiNkNiMFwvMEJxV3NKWVROWlwvcVRaK0RHVmNlWnhTb2x3ZkFUZDA2R0VYRzJOaEQ1RytxVFk5S3VEN0RobUNGOGVYIiwibWFjIjoiNmNjYjczMTNhZmQzMDRmYmQ2OTMzY2NhMzFmN2E3N2U2NzM5MmRhN2EwNjQzY2M5NGMxNzJjNmQ2N2U0OGRjZSJ9 ◀XSRF-TOKEN=eyJpdiI6Im9NQkZNQzRqVFwvVUdFSEhRNnhkUWR3PT0iLCJ2YWx1ZSI6ImplWGlkR3kxNkFxNDh6OEJOYm1IQXBIbDB1emYyM2tyb2hCMFwvY0oydWg0UnJJalRtNkRtYjVib2NXSXYzWVwvWSIsI ▶"
  "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.144.222.234"
  "HTTP_X_FORWARDED_HOST" => "agropiese.md"
  "HTTP_X_FORWARDED_PROTO" => "https"
  "HTTP_X_FORWARDED_SERVER" => "agropiese.md"
  "HTTP_X_REAL_IP" => "3.144.222.234"
  "PATH" => "/bin:/usr/bin:/usr/local/php/bin"
  "PHPRC" => "/home/agropie"
  "QUERY_STRING" => "for=%D0%A1%D0%9A%D0%A0%D0%A2%2045"
  "REDIRECT_HTTPS" => "on"
  "REDIRECT_QUERY_STRING" => "for=%D0%A1%D0%9A%D0%A0%D0%A2%2045"
  "REDIRECT_STATUS" => "200"
  "REDIRECT_UNIQUE_ID" => "Z9TLkVE7KyQ7jDRYulrG8gAAARM"
  "REDIRECT_URL" => "/cautare"
  "REMOTE_ADDR" => "3.144.222.234"
  "REMOTE_PORT" => "33848"
  "REQUEST_METHOD" => "GET"
  "REQUEST_SCHEME" => "https"
  "REQUEST_URI" => "/cautare?for=%D0%A1%D0%9A%D0%A0%D0%A2%2045"
  "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" => "Z9TLkVE7KyQ7jDRYulrG8gAAARM"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1741998993.9009
  "REQUEST_TIME" => 1741998993
  "argv" => array:1 [▶
    0 => "for=%D0%A1%D0%9A%D0%A0%D0%A2%2045"
  ]
  "argc" => 1
]

request_cookies

  0 of 0   
array:2 [▶
  "XSRF-TOKEN" => "QERvrAxY2QymzsRQDn1g8Hva9zM9UthUkdkTb3oM"
  "agropiesemd_session" => "QLrecjQ0qKeQM9jfJzKUnN9ptk01txBY1Hkux2A9"
]

response_headers

  0 of 0   
array:7 [▶
  "cache-control" => array:1 [▶
    0 => "private, must-revalidate"
  ]
  "date" => array:1 [▶
    0 => "Sat, 15 Mar 2025 00:36:34 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=eyJpdiI6IlFyZnQ4NG5Gb2EyeWM0YWluZ1NyS3c9PSIsInZhbHVlIjoibFJ5SGVhbWpVS29UbzRTeEpuMkdtbTlvTmc2eEFRSElOc3lEXC9KNFJyUUtjS2xJT1JsM1pkenNyU2U2Y2J0RGkiLCJtYWMiOiJlMjU2MmJlMWVhZmE5ZDY1ZmFmMjBiMWZmMzUwZGRlMDY4MzQyOTgxOGFkOTQ3NDYwNGVhZjU3ZjA5MzkxOWY2In0%3D; expires=Sat, 15-Mar-2025 02:36:34 GMT; Max-Age=7200; path=/ ◀XSRF-TOKEN=eyJpdiI6IlFyZnQ4NG5Gb2EyeWM0YWluZ1NyS3c9PSIsInZhbHVlIjoibFJ5SGVhbWpVS29UbzRTeEpuMkdtbTlvTmc2eEFRSElOc3lEXC9KNFJyUUtjS2xJT1JsM1pkenNyU2U2Y2J0RGkiLCJtY ▶"
    1 => "agropiesemd_session=eyJpdiI6Ik5iOTdhbE8xemhQd24wWUxDdTUxeVE9PSIsInZhbHVlIjoiK3FOM2IzUjkzMFBaUitEcUZxKzFSZHpjeThyVjhPSVZGamtwdWJhcEVLQ3JzdzBwSHlPanBCbDhLWEtNbnJpYyIsIm1hYyI6ImJkYWRhZTcwYjg0MjFiOGM0ODUzYTkxZjI5YWU3ZmY0OGJhMTc0YzFlOTUwYmQwN2VlYTdmNmM0Y2NmZGI0MmUifQ%3D%3D; expires=Sat, 15-Mar-2025 02:36:34 GMT; Max-Age=7200; path=/; httponly ◀agropiesemd_session=eyJpdiI6Ik5iOTdhbE8xemhQd24wWUxDdTUxeVE9PSIsInZhbHVlIjoiK3FOM2IzUjkzMFBaUitEcUZxKzFSZHpjeThyVjhPSVZGamtwdWJhcEVLQ3JzdzBwSHlPanBCbDhLWEtNbnJp ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IlFyZnQ4NG5Gb2EyeWM0YWluZ1NyS3c9PSIsInZhbHVlIjoibFJ5SGVhbWpVS29UbzRTeEpuMkdtbTlvTmc2eEFRSElOc3lEXC9KNFJyUUtjS2xJT1JsM1pkenNyU2U2Y2J0RGkiLCJtYWMiOiJlMjU2MmJlMWVhZmE5ZDY1ZmFmMjBiMWZmMzUwZGRlMDY4MzQyOTgxOGFkOTQ3NDYwNGVhZjU3ZjA5MzkxOWY2In0%3D; expires=Sat, 15-Mar-2025 02:36:34 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlFyZnQ4NG5Gb2EyeWM0YWluZ1NyS3c9PSIsInZhbHVlIjoibFJ5SGVhbWpVS29UbzRTeEpuMkdtbTlvTmc2eEFRSElOc3lEXC9KNFJyUUtjS2xJT1JsM1pkenNyU2U2Y2J0RGkiLCJtY ▶"
    1 => "agropiesemd_session=eyJpdiI6Ik5iOTdhbE8xemhQd24wWUxDdTUxeVE9PSIsInZhbHVlIjoiK3FOM2IzUjkzMFBaUitEcUZxKzFSZHpjeThyVjhPSVZGamtwdWJhcEVLQ3JzdzBwSHlPanBCbDhLWEtNbnJpYyIsIm1hYyI6ImJkYWRhZTcwYjg0MjFiOGM0ODUzYTkxZjI5YWU3ZmY0OGJhMTc0YzFlOTUwYmQwN2VlYTdmNmM0Y2NmZGI0MmUifQ%3D%3D; expires=Sat, 15-Mar-2025 02:36:34 GMT; path=/; httponly ◀agropiesemd_session=eyJpdiI6Ik5iOTdhbE8xemhQd24wWUxDdTUxeVE9PSIsInZhbHVlIjoiK3FOM2IzUjkzMFBaUitEcUZxKzFSZHpjeThyVjhPSVZGamtwdWJhcEVLQ3JzdzBwSHlPanBCbDhLWEtNbnJp ▶"
  ]
]

session_attributes

  0 of 0   
array:7 [▶
  "_token" => "QERvrAxY2QymzsRQDn1g8Hva9zM9UthUkdkTb3oM"
  "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=%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 (90.15%)	696.13ms
1 x Booting (9.7%)	74.92ms

Rezultatele căutarii