PHP 8.1.339.36.3
FilesystemIterator::__construct(/var/www/vhosts/zarifalan.online/httpdocs/storage/framework/cache/data/ae): Failed to open directory: No such file or directory
);
$products = Product::withTranslations([app()->getLocale()])
->where('name', 'LIKE', '%' . $request->q . '%')
->orWhere('description', 'LIKE', '%' . $request->q . '%')
->orWhere('details', 'LIKE', '%' . $request->q . '%')
->orWhere('slug', 'LIKE', '%' . $request->q . '%')
->get();
$q = $request->q;
$meta_description = 'Aviva Mobilya | ';
return view('site.products.search', compact('breadcrumbs', 'q', 'products', 'meta_description'));
}
// Ürün Detay
public function product(Request $request, Product $product, Collection $collection)
{
Artisan::call('cache:clear');
//dd($product,$collection);
$product_model = $product;
$product = $product->translate(app()->getLocale(), config('voyager.multilingual.default'));
$breadcrumbs = $product_model->category->buildParents($product_model->category)->map(function ($category, $index) {
return [
'name' => $category->getTranslatedAttribute('name', app()->getLocale(), config('voyager.multilingual.default')),
'url' => route('site.products.category', $category),
];
});
$breadcrumbs->push([
'name' => $product_model->getTranslatedAttribute('name', app()->getLocale(), config('voyager.multilingual.default')),
'url' => route('site.products.single', $product_model)
]);
Request
https://zarifalan.online/en/product/roma-set-1
GET
curl "https://zarifalan.online/en/product/roma-set-1" \
-X GET \
-H 'cookie: XSRF-TOKEN=eyJpdiI6IlBZVmViK1R1WjRCVFBQMm9tTElYV0E9PSIsInZhbHVlIjoiOEhNdHA3OExHK2FUWkpoekduVENERGFyczJVWFFOK2o0eXJ3ZnhWVzlRN25UOG14eTZGV0gxMHc5alFiUWdvYWJ0WEozSkhyZkxIVW5WdFhFWERuWFVXZ2Y0aDN3MjN6OEpSWDVRQ3RSWGdGeDUyZmJsL0h5OUYvUmUrV3RnTjEiLCJtYWMiOiJmZmI4MGE2YjJjMTM0OGM2ZjMzMmE2MjdkZWMxMzk1NWUwZjAzNmQxMjYwZmNkNzVkZjk0YjZjMTcxZTZkMmQwIiwidGFnIjoiIn0%3D; aviva_mobilya_session=eyJpdiI6Ik5ZS0tCaXZXTGdQaVk4VjZvdnJ1aEE9PSIsInZhbHVlIjoiZUwyQ2xhUW4zTWh2aFBmd0dHbWNvQmtnektjcHZMZ29SelBOMDFpSUk5MXN3Ny9YYjZjQnlrclVvcGZ2REtoOHVWeTMySm5pQzhVdWlvSnRLUDVMU1UzVVR3VmFyek9tR0pRUlZjanFzUHUvSUZLcURTWHJrbWIvVzFqS0NTVUMiLCJtYWMiOiI2ZmFkZTBhOWMzYzQ5MjA2MmQyMDA3ZTNhY2I2ZjNmMDlkNTY3ZTJlYmE2NWMxMDdkNjQ1NWQ1YmI0ODY4OWZkIiwidGFnIjoiIn0%3D' \
-H 'referer: https://zarifalan.online/en/product/milano-set' \
-H 'sec-fetch-user: ?1' \
-H 'sec-fetch-site: none' \
-H 'sec-fetch-mode: navigate' \
-H 'sec-fetch-dest: document' \
-H 'accept-language: en-US,en' \
-H 'accept-encoding: *' \
-H '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' \
-H 'user-agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36' \
-H 'upgrade-insecure-requests: 1' \
-H 'sec-ch-ua-platform: Windows' \
-H 'sec-ch-ua-mobile: ?0' \
-H 'sec-ch-ua: "Not(A:Brand";v="24", "Chromium";v="131"' \
-H 'connection: close' \
-H 'x-accel-internal: /internal-nginx-static-location' \
-H 'x-real-ip: 95.217.109.146' \
-H 'host: zarifalan.online';
Headers
- cookie
XSRF-TOKEN=eyJpdiI6IlBZVmViK1R1WjRCVFBQMm9tTElYV0E9PSIsInZhbHVlIjoiOEhNdHA3OExHK2FUWkpoekduVENERGFyczJVWFFOK2o0eXJ3ZnhWVzlRN25UOG14eTZGV0gxMHc5alFiUWdvYWJ0WEozSkhyZkxIVW5WdFhFWERuWFVXZ2Y0aDN3MjN6OEpSWDVRQ3RSWGdGeDUyZmJsL0h5OUYvUmUrV3RnTjEiLCJtYWMiOiJmZmI4MGE2YjJjMTM0OGM2ZjMzMmE2MjdkZWMxMzk1NWUwZjAzNmQxMjYwZmNkNzVkZjk0YjZjMTcxZTZkMmQwIiwidGFnIjoiIn0%3D; aviva_mobilya_session=eyJpdiI6Ik5ZS0tCaXZXTGdQaVk4VjZvdnJ1aEE9PSIsInZhbHVlIjoiZUwyQ2xhUW4zTWh2aFBmd0dHbWNvQmtnektjcHZMZ29SelBOMDFpSUk5MXN3Ny9YYjZjQnlrclVvcGZ2REtoOHVWeTMySm5pQzhVdWlvSnRLUDVMU1UzVVR3VmFyek9tR0pRUlZjanFzUHUvSUZLcURTWHJrbWIvVzFqS0NTVUMiLCJtYWMiOiI2ZmFkZTBhOWMzYzQ5MjA2MmQyMDA3ZTNhY2I2ZjNmMDlkNTY3ZTJlYmE2NWMxMDdkNjQ1NWQ1YmI0ODY4OWZkIiwidGFnIjoiIn0%3D
- referer
https://zarifalan.online/en/product/milano-set
- sec-fetch-user
?1
- sec-fetch-site
none
- sec-fetch-mode
navigate
- sec-fetch-dest
document
- accept-language
en-US,en
- accept-encoding
*
- 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
- user-agent
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36
- upgrade-insecure-requests
1
- sec-ch-ua-platform
Windows
- sec-ch-ua-mobile
?0
- sec-ch-ua
"Not(A:Brand";v="24", "Chromium";v="131"
- connection
close
- x-accel-internal
/internal-nginx-static-location
- x-real-ip
95.217.109.146
- host
zarifalan.online
App
Context
09:55:40
0.84ms
mysql
select * from information_schema.tables where table_schema = ? and table_name = ? and table_type = 'BASE TABLE'
09:55:40
0.37ms
mysql
select `policy_name`, `model_name` from `data_types`
09:55:40
0.77ms
mysql
select * from `language_lines` where `group` = ?
09:55:40
0.48ms
mysql
select * from `data_types`
09:55:40
0.45ms
mysql
select * from `product_categories` where `product_category_id` is null order by `rank` asc
09:55:40
0.47ms
mysql
select * from `translations` where `table_name` = ? and `locale` in (?, ?) and `translations`.`foreign_key` in (1, 2, 3, 4, 5, 6, 7, 63) and (`locale` in (?) or `locale` = ?)
09:55:40
0.31ms
mysql
select * from `page_categories`
09:55:40
0.8ms
mysql
select * from `pages` where `pages`.`page_category_id` in (1, 2, 3, 4)
09:55:40
0.38ms
mysql
select `foreign_key` from `translations` where `table_name` = ? and `column_name` = ? and `value` = ? and `locale` in (?)
09:55:40
0.27ms
mysql
select count(*) as aggregate from `products` where `id` in (?)
09:55:40
0.32ms
mysql
select `foreign_key` from `translations` where `table_name` = ? and `column_name` = ? and `value` = ? and `locale` in (?)
09:55:40
0.34ms
mysql
select * from `products` where `id` in (?) limit 1