Sayure

Messages Timeline Exceptions Views4 Route Queries7 Models23 Mails Gate Session Request

7.2.34763ms20MBGET en/shop/{cat?}

Booting (615ms)
Application (142ms)
1 x Booting (80.58%)
615.18ms
1 x Application (18.64%)
142.33ms

4 templates were rendered

client.products.shop (resources/views/client/products/shop.blade.php)4blade
Params
0
products
1
current_category
2
min
3
max
client.products.filter_form (resources/views/client/products/filter_form.blade.php)15blade
Params
0
obLevel
1
__env
2
app
3
lang
4
brands
5
contact_info
6
categories
7
errors
8
cart
9
products
10
current_category
11
min
12
max
13
page_title
14
first_level_cat
pagination::bootstrap-4 (vendor/laravel/framework/src/Illuminate/Pagination/resources/views/bootstrap-4.blade.php)2blade
Params
0
paginator
1
elements

Params
0	`products`
1	`current_category`
2	`min`
3	`max`

Params
0	`obLevel`
1	`__env`
2	`app`
3	`lang`
4	`brands`
5	`contact_info`
6	`categories`
7	`errors`
8	`cart`
9	`products`
10	`current_category`
11	`min`
12	`max`
13	`page_title`
14	`first_level_cat`

Params
0	`paginator`
1	`elements`

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


obLevel
__env
app
lang
brands
contact_info
categories
errors
cart
products
current_category
min
max
page_title
first_level_cat
__empty_1
__currentLoopData
product
key
loop
discount
s

Params
0	`obLevel`
1	`__env`
2	`app`
3	`lang`
4	`brands`
5	`contact_info`
6	`categories`
7	`errors`
8	`cart`
9	`products`
10	`current_category`
11	`min`
12	`max`
13	`page_title`
14	`first_level_cat`
15	`__empty_1`
16	`__currentLoopData`
17	`product`
18	`key`
19	`loop`
20	`discount`
21	`s`

uri: GET en/shop/{cat?}
middleware: web, localeSessionRedirect, localizationRedirect, localeViewPath
controller: App\Http\Controllers\Front\ProductsController@shop
namespace: App\Http\Controllers
prefix: /en
where
as: shop
file: app/Http/Controllers/Front/ProductsController.php:25-105

7 statements were executed32.13ms

select `product_categories`.*, `product_category_translates`.`title`, `product_category_translates`.`short_description`, `pct`.`title` as `parent_title` from `product_categories` inner join `product_category_translates` on `product_categories`.`id` = `product_category_translates`.`parent_id` left join `product_category_translates` as `pct` on `product_categories`.`parent_id` = `pct`.`parent_id` where (`pct`.`lang` = 'en' or `pct`.`lang` is null) and `product_category_translates`.`lang` = 'en' and `product_categories`.`status` = 1 order by `id` asc

15.39ms/app/Models/ProductCategory.php:244comforti_db

Metadata
Bindings	0. en 1. en 2. 1
Backtrace	14. /app/Models/ProductCategory.php:244 15. /app/Http/Controllers/Controller.php:53 16. /app/Http/Controllers/Front/ProductsController.php:21 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:849 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:691

select `brands`.*, `brands_translates`.`title` from `brands` inner join `brands_translates` on `brands`.`id` = `brands_translates`.`parent_id` where `brands_translates`.`lang` = 'en' and `brands`.`status` = 1 order by `sort` asc

5.46ms/app/Models/Brand.php:196comforti_db

Metadata
Bindings	0. en 1. 1
Backtrace	14. /app/Models/Brand.php:196 15. /app/Http/Controllers/Controller.php:75 16. /app/Http/Controllers/Front/ProductsController.php:21 18. /vendor/laravel/framework/src/Illuminate/Container/Container.php:849 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:691

select `informations`.*, `informations_translates`.`title`, `informations_translates`.`address`, `informations_translates`.`slogan` from `informations` inner join `informations_translates` on `informations`.`id` = `informations_translates`.`parent_id` where `informations`.`id` = 3 and `informations_translates`.`lang` = 'en' limit 1

4.71ms/app/Models/Information.php:136comforti_db

Metadata
Bindings	0. 3 1. en
Backtrace	15. /app/Models/Information.php:136 16. /app/Http/Controllers/Controller.php:76 17. /app/Http/Controllers/Front/ProductsController.php:21 19. /vendor/laravel/framework/src/Illuminate/Container/Container.php:849 20. /vendor/laravel/framework/src/Illuminate/Container/Container.php:691

select `id` from `products` where `category_id` in (10)2.09ms/app/Http/Controllers/Front/ProductsController.php:87comforti_db

Metadata
Bindings	0. 10
Backtrace	13. /app/Http/Controllers/Front/ProductsController.php:87 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196 19. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:685

select count(*) as aggregate from `products` inner join `products_translates` on `products`.`id` = `products_translates`.`parent_id` left join `product_category_translates` as `pct` on `products`.`category_id` = `pct`.`parent_id` where (`pct`.`lang` = 'en' or `pct`.`lang` is null) and `products_translates`.`lang` = 'en' and `products`.`status` = 1 and `products`.`id` in (13)

2.9ms/app/Models/Product.php:342comforti_db

Metadata
Bindings	0. en 1. en 2. 1 3. 13
Backtrace	15. /app/Models/Product.php:342 17. /app/Models/Product.php:343 18. /app/Http/Controllers/Front/ProductsController.php:95 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239

select `products`.*, `products_translates`.`title`, `products_translates`.`alt`, `pct`.`title` as `cat_title` from `products` inner join `products_translates` on `products`.`id` = `products_translates`.`parent_id` left join `product_category_translates` as `pct` on `products`.`category_id` = `pct`.`parent_id` where (`pct`.`lang` = 'en' or `pct`.`lang` is null) and `products_translates`.`lang` = 'en' and `products`.`status` = 1 and `products`.`id` in (13) order by `id` desc limit 9 offset 0

1.06ms/app/Models/Product.php:342comforti_db

Metadata
Bindings	0. en 1. en 2. 1 3. 13
Backtrace	15. /app/Models/Product.php:342 17. /app/Models/Product.php:343 18. /app/Http/Controllers/Front/ProductsController.php:95 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239

select `price` from `products` where `status` = 1 order by `price` asc520μs/app/Http/Controllers/Front/ProductsController.php:99comforti_db

Metadata
Bindings	0. 1
Backtrace	12. /app/Http/Controllers/Front/ProductsController.php:99 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196 18. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:685

App\Models\Product: 2
App\Models\Information: 1
App\Models\Brand: 5
App\Models\ProductCategory: 15

_token: N9s4ozmSIQ8SSG6iPjX0lbWeUesnr0j7DTZddQN5
locale: en
_previous: array:1 [ "url" => "https://comforti.ge/en/shop/10-%E1%83%A1%E1%83%90%E1%83%A7%E1%83%A3%E1%83%A0%E...
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/en/shop/10-%E1%83%A1%E1%83%90%E1%83%A7%E1%83%A3%E1%83%A0%E1%83%94%E1%83%94%E1%83%91%E1%83%98

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:15 [▶
  "x-https" => array:1 [▶
    0 => "1"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "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"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "host" => array:1 [▶
    0 => "comforti.ge"
  ]
]

request_server

  0 of 0   
array:56 [▶
  "USER" => "comforti"
  "HOME" => "/home/comforti"
  "SCRIPT_NAME" => "/index.php"
  "REQUEST_URI" => "/en/shop/10-%E1%83%A1%E1%83%90%E1%83%A7%E1%83%A3%E1%83%A0%E1%83%94%E1%83%94%E1%83%91%E1%83%98"
  "QUERY_STRING" => ""
  "REQUEST_METHOD" => "GET"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "REDIRECT_URL" => "/en/shop/10-საყურეები"
  "REMOTE_PORT" => "41946"
  "SCRIPT_FILENAME" => "/home/comforti/public_html/index.php"
  "SERVER_ADMIN" => "webmaster@comforti.ge"
  "CONTEXT_DOCUMENT_ROOT" => "/home/comforti/public_html"
  "CONTEXT_PREFIX" => ""
  "REQUEST_SCHEME" => "https"
  "DOCUMENT_ROOT" => "/home/comforti/public_html"
  "REMOTE_ADDR" => "18.219.151.245"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "91.239.207.42"
  "SERVER_NAME" => "comforti.ge"
  "SERVER_SOFTWARE" => "Apache"
  "SERVER_SIGNATURE" => ""
  "PATH" => "/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin ◀/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bi ▶"
  "HTTP_X_HTTPS" => "1"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_SITE" => "none"
  "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_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CONNECTION" => "keep-alive"
  "HTTP_HOST" => "comforti.ge"
  "proxy-nokeepalive" => "1"
  "SSL_TLS_SNI" => "comforti.ge"
  "HTTPS" => "on"
  "SCRIPT_URI" => "https://comforti.ge/en/shop/10-საყურეები"
  "SCRIPT_URL" => "/en/shop/10-საყურეები"
  "UNIQUE_ID" => "Z_Xn4Kc2sa865LW-a7E_4AAAAA4"
  "REDIRECT_STATUS" => "200"
  "REDIRECT_SSL_TLS_SNI" => "comforti.ge"
  "REDIRECT_HTTPS" => "on"
  "REDIRECT_SCRIPT_URI" => "https://comforti.ge/en/shop/10-საყურეები"
  "REDIRECT_SCRIPT_URL" => "/en/shop/10-საყურეები"
  "REDIRECT_UNIQUE_ID" => "Z_Xn4Kc2sa865LW-a7E_4AAAAA4"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1744168928.0595
  "REQUEST_TIME" => 1744168928
  "argv" => []
  "argc" => 0
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Wed, 09 Apr 2025 03:22:08 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjdVSFRVTXZKbXVDOTljeWpCbkwxYVE9PSIsInZhbHVlIjoiMDdhV29rWUR6WHJ5N1FRQkxoNk5XNnJ0eGZzL05NcUNtdUZRc1dHT0k5dUgvN3p5TCs1QVZaejFiVlJNeEV2TUVBQWswRm1MUDJQNUdkN0dzbVpGYTlicmphMFdCQzJOajRjUzl3bk5qZmYyNFR6bnIvQjBZRkRwMVRRdmNRQ3oiLCJtYWMiOiJiYTQwNWM5OTFlZGNlMWRjNmNhNzA1ZDMwZTQ0YjA4NjM3MmU4ZmE0NDM5MWQ4ZmE3ZWI5ZTNiZTkwMjI5M2QyIn0%3D; expires=Wed, 09-Apr-2025 05:22:08 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjdVSFRVTXZKbXVDOTljeWpCbkwxYVE9PSIsInZhbHVlIjoiMDdhV29rWUR6WHJ5N1FRQkxoNk5XNnJ0eGZzL05NcUNtdUZRc1dHT0k5dUgvN3p5TCs1QVZaejFiVlJNeEV2TUVBQWswR ▶"
    1 => "vndemo_session=eyJpdiI6IjVIekE0WllMRHVkb0FHN21zS1dBS2c9PSIsInZhbHVlIjoiYnA2Y3l3cGdmUEFXeHViTDdOVkdVdjN3RnREQXp3NVVJZ2xDb05kakdaN3Q3dzdNRXVjdlBWakxUTXRTWjZlTEJLaDh1UjJlVjdNWmtQYzdhNWtCWUREWXVKd0VHYlNITEc3YlpmTDNxYys0UENVUUZHL2J2aG5QRm94V1R3d1AiLCJtYWMiOiI5MjBkOTZmNTk1YTNlNDY1NWZmOWQyMTZkOTIyOTE1ZDU2ZTBkZTQ5NGJhODIwMjBjMjhhYTdjYTUyYzhhYjAzIn0%3D; expires=Wed, 09-Apr-2025 05:22:08 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀vndemo_session=eyJpdiI6IjVIekE0WllMRHVkb0FHN21zS1dBS2c9PSIsInZhbHVlIjoiYnA2Y3l3cGdmUEFXeHViTDdOVkdVdjN3RnREQXp3NVVJZ2xDb05kakdaN3Q3dzdNRXVjdlBWakxUTXRTWjZlTEJLa ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjdVSFRVTXZKbXVDOTljeWpCbkwxYVE9PSIsInZhbHVlIjoiMDdhV29rWUR6WHJ5N1FRQkxoNk5XNnJ0eGZzL05NcUNtdUZRc1dHT0k5dUgvN3p5TCs1QVZaejFiVlJNeEV2TUVBQWswRm1MUDJQNUdkN0dzbVpGYTlicmphMFdCQzJOajRjUzl3bk5qZmYyNFR6bnIvQjBZRkRwMVRRdmNRQ3oiLCJtYWMiOiJiYTQwNWM5OTFlZGNlMWRjNmNhNzA1ZDMwZTQ0YjA4NjM3MmU4ZmE0NDM5MWQ4ZmE3ZWI5ZTNiZTkwMjI5M2QyIn0%3D; expires=Wed, 09-Apr-2025 05:22:08 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjdVSFRVTXZKbXVDOTljeWpCbkwxYVE9PSIsInZhbHVlIjoiMDdhV29rWUR6WHJ5N1FRQkxoNk5XNnJ0eGZzL05NcUNtdUZRc1dHT0k5dUgvN3p5TCs1QVZaejFiVlJNeEV2TUVBQWswR ▶"
    1 => "vndemo_session=eyJpdiI6IjVIekE0WllMRHVkb0FHN21zS1dBS2c9PSIsInZhbHVlIjoiYnA2Y3l3cGdmUEFXeHViTDdOVkdVdjN3RnREQXp3NVVJZ2xDb05kakdaN3Q3dzdNRXVjdlBWakxUTXRTWjZlTEJLaDh1UjJlVjdNWmtQYzdhNWtCWUREWXVKd0VHYlNITEc3YlpmTDNxYys0UENVUUZHL2J2aG5QRm94V1R3d1AiLCJtYWMiOiI5MjBkOTZmNTk1YTNlNDY1NWZmOWQyMTZkOTIyOTE1ZDU2ZTBkZTQ5NGJhODIwMjBjMjhhYTdjYTUyYzhhYjAzIn0%3D; expires=Wed, 09-Apr-2025 05:22:08 GMT; path=/; httponly ◀vndemo_session=eyJpdiI6IjVIekE0WllMRHVkb0FHN21zS1dBS2c9PSIsInZhbHVlIjoiYnA2Y3l3cGdmUEFXeHViTDdOVkdVdjN3RnREQXp3NVVJZ2xDb05kakdaN3Q3dzdNRXVjdlBWakxUTXRTWjZlTEJLa ▶"
  ]
]

session_attributes

  0 of 0   
array:5 [▶
  "_token" => "N9s4ozmSIQ8SSG6iPjX0lbWeUesnr0j7DTZddQN5"
  "locale" => "en"
  "_previous" => array:1 [▶
    "url" => "https://comforti.ge/en/shop/10-%E1%83%A1%E1%83%90%E1%83%A7%E1%83%A3%E1%83%A0%E1%83%94%E1%83%94%E1%83%91%E1%83%98"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

Categopry

Stars

Brand

Price

Circular pendant earrings

1 x Booting (80.58%)	615.18ms
1 x Application (18.64%)	142.33ms