PHP 8.1.339.36.3
FilesystemIterator::__construct(/var/www/vhosts/zarifalan.online/httpdocs/storage/framework/cache/data/22/b2): 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/i-kon-sifonyer
GET
curl "https://zarifalan.online/en/product/i-kon-sifonyer" \
-X GET \
-H 'cookie: XSRF-TOKEN=eyJpdiI6IjNUQTFDb2tzc1A3R1JpZjV0YVRKa2c9PSIsInZhbHVlIjoiNDlPbnlSSEdoVkl2UzJuZ2hBa0NWc0RRK3Rtc3YzeVpYMUNjTUJlM2I0OHRsZmIxd2MwRFBuTWRXcWJ3NVF1dCtHVE1tNG5tcDFHWDk5b0Z6U0pyNDEzRy9DRzIxQ0RHWGVSWDBwSmk4cDcyNU1UUXhwYTNIZUhxMTVhRTRVekgiLCJtYWMiOiI3YjBmM2QyYzhmODExMjY5Y2JkZDNhNzExODgxNTAyZDEyODk1MjA5OWQ2Zjk0YzQ5MmE5YTFlMjYzNGE4NzlkIiwidGFnIjoiIn0%3D; aviva_mobilya_session=eyJpdiI6IlhoUE5MR3hQM3lCSkpVb09oS2lKZlE9PSIsInZhbHVlIjoiejBVbDNZN2tNc0xPSVhXNDV1bVZUWTNtYk5HVkdEMjlLU2lkWnY2QzlVb3pRUHAreFJTbmlmRkhPdXU1MG5iU01FZ3ZpdU5hYmtFakN6eEFCRWpwL0swb1BBRW4rYnVtWHBSRVRSSEtNbERkbWZJbDdDcXpNQVc4ajRkNEZtTlMiLCJtYWMiOiI3NGQ2ZGQ1ODc0OTA2MzM1ZjQ5NjllY2NhZDUzYzAwYWEzNjg5ZThjOTBiZjkxZWQ0YzFiYjUzYzlhNzQyMjA5IiwidGFnIjoiIn0%3D' \
-H 'referer: https://zarifalan.online/en/product/concept-ranza-90x190' \
-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=eyJpdiI6IjNUQTFDb2tzc1A3R1JpZjV0YVRKa2c9PSIsInZhbHVlIjoiNDlPbnlSSEdoVkl2UzJuZ2hBa0NWc0RRK3Rtc3YzeVpYMUNjTUJlM2I0OHRsZmIxd2MwRFBuTWRXcWJ3NVF1dCtHVE1tNG5tcDFHWDk5b0Z6U0pyNDEzRy9DRzIxQ0RHWGVSWDBwSmk4cDcyNU1UUXhwYTNIZUhxMTVhRTRVekgiLCJtYWMiOiI3YjBmM2QyYzhmODExMjY5Y2JkZDNhNzExODgxNTAyZDEyODk1MjA5OWQ2Zjk0YzQ5MmE5YTFlMjYzNGE4NzlkIiwidGFnIjoiIn0%3D; aviva_mobilya_session=eyJpdiI6IlhoUE5MR3hQM3lCSkpVb09oS2lKZlE9PSIsInZhbHVlIjoiejBVbDNZN2tNc0xPSVhXNDV1bVZUWTNtYk5HVkdEMjlLU2lkWnY2QzlVb3pRUHAreFJTbmlmRkhPdXU1MG5iU01FZ3ZpdU5hYmtFakN6eEFCRWpwL0swb1BBRW4rYnVtWHBSRVRSSEtNbERkbWZJbDdDcXpNQVc4ajRkNEZtTlMiLCJtYWMiOiI3NGQ2ZGQ1ODc0OTA2MzM1ZjQ5NjllY2NhZDUzYzAwYWEzNjg5ZThjOTBiZjkxZWQ0YzFiYjUzYzlhNzQyMjA5IiwidGFnIjoiIn0%3D
- referer
https://zarifalan.online/en/product/concept-ranza-90x190
- 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
10:19:46
0.81ms
mysql
select * from information_schema.tables where table_schema = ? and table_name = ? and table_type = 'BASE TABLE'
10:19:46
0.25ms
mysql
select `policy_name`, `model_name` from `data_types`
10:19:46
0.61ms
mysql
select * from `language_lines` where `group` = ?
10:19:46
0.38ms
mysql
select * from `data_types`
10:19:47
0.41ms
mysql
select * from `product_categories` where `product_category_id` is null order by `rank` asc
10:19:47
0.4ms
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` = ?)
10:19:47
0.25ms
mysql
select * from `page_categories`
10:19:47
0.61ms
mysql
select * from `pages` where `pages`.`page_category_id` in (1, 2, 3, 4)
10:19:47
0.28ms
mysql
select `foreign_key` from `translations` where `table_name` = ? and `column_name` = ? and `value` = ? and `locale` in (?)
10:19:47
0.23ms
mysql
select count(*) as aggregate from `products` where `id` in (?)
10:19:47
0.24ms
mysql
select `foreign_key` from `translations` where `table_name` = ? and `column_name` = ? and `value` = ? and `locale` in (?)
10:19:47
0.29ms
mysql
select * from `products` where `id` in (?) limit 1