PHP 8.1.339.36.3
FilesystemIterator::__construct(/var/www/vhosts/zarifalan.online/httpdocs/storage/framework/cache/data/52): 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/tr/urun/mia-kitaplik
GET
curl "https://zarifalan.online/tr/urun/mia-kitaplik" \
-X GET \
-H 'cookie: XSRF-TOKEN=eyJpdiI6Inkvc0RtRVZhZ2ZRczNqWHFzZUNFblE9PSIsInZhbHVlIjoiRlJnd3BKZzh1N3J0Y2ZFVE5OVExhWW10ZXdHbkZqTGVldWp5UXpmaUlHWktxeTJ0RmNiSXJTWERwNDJJYVk4Skd5OTVDL1MxcEVPeVA1OU5NYURtRGtCMG5OTUU5YVo2R3dkTENsMThXejlWWnRuT1E2MW9WY0NadTd5VnNDZ0IiLCJtYWMiOiJkYjc3NTY3OTFjYzM3YTMwM2QxZDExNmQ1ZDQ1YzdiYmUwNjVlZGYwMGQ5YmJkYmM2NWUyYTAyNzdhZDgzZjEyIiwidGFnIjoiIn0%3D; aviva_mobilya_session=eyJpdiI6Im1ELzdFdUwyai8xemlrME5VQkEvNEE9PSIsInZhbHVlIjoiMDVwOWI0Rm9WZExLdnBYVDZKV3hEZ1JSM2Y5dTFjTDE4RlVXRzJHeVZEUDlvTHNwdlZHVGZQRXY0Y0xURnp6ZjgzeHpmMEhEQ0FDZnNBS0luTEZmQmhpem55WW52UnA2cmt3VDZLNFd4NlNodGN0am9QQ2Rnb2RIY3AwU2Zkb2EiLCJtYWMiOiJmZWI0NWYxODQwOTE3Y2VmZDk4NDUxMzhjNjNiZDIxNmM2NWIxMWFkNTZmNDUwZjJhMDE3MDc1OWUwNjYwZjA1IiwidGFnIjoiIn0%3D' \
-H 'referer: https://zarifalan.online/tr/urunler/kitaplik' \
-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=eyJpdiI6Inkvc0RtRVZhZ2ZRczNqWHFzZUNFblE9PSIsInZhbHVlIjoiRlJnd3BKZzh1N3J0Y2ZFVE5OVExhWW10ZXdHbkZqTGVldWp5UXpmaUlHWktxeTJ0RmNiSXJTWERwNDJJYVk4Skd5OTVDL1MxcEVPeVA1OU5NYURtRGtCMG5OTUU5YVo2R3dkTENsMThXejlWWnRuT1E2MW9WY0NadTd5VnNDZ0IiLCJtYWMiOiJkYjc3NTY3OTFjYzM3YTMwM2QxZDExNmQ1ZDQ1YzdiYmUwNjVlZGYwMGQ5YmJkYmM2NWUyYTAyNzdhZDgzZjEyIiwidGFnIjoiIn0%3D; aviva_mobilya_session=eyJpdiI6Im1ELzdFdUwyai8xemlrME5VQkEvNEE9PSIsInZhbHVlIjoiMDVwOWI0Rm9WZExLdnBYVDZKV3hEZ1JSM2Y5dTFjTDE4RlVXRzJHeVZEUDlvTHNwdlZHVGZQRXY0Y0xURnp6ZjgzeHpmMEhEQ0FDZnNBS0luTEZmQmhpem55WW52UnA2cmt3VDZLNFd4NlNodGN0am9QQ2Rnb2RIY3AwU2Zkb2EiLCJtYWMiOiJmZWI0NWYxODQwOTE3Y2VmZDk4NDUxMzhjNjNiZDIxNmM2NWIxMWFkNTZmNDUwZjJhMDE3MDc1OWUwNjYwZjA1IiwidGFnIjoiIn0%3D
- referer
https://zarifalan.online/tr/urunler/kitaplik
- 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:06:45
0.75ms
mysql
select * from information_schema.tables where table_schema = ? and table_name = ? and table_type = 'BASE TABLE'
10:06:45
0.26ms
mysql
select `policy_name`, `model_name` from `data_types`
10:06:45
0.64ms
mysql
select * from `language_lines` where `group` = ?
10:06:45
0.43ms
mysql
select * from `data_types`
10:06:45
0.36ms
mysql
select * from `product_categories` where `product_category_id` is null order by `rank` asc
10:06:45
0.44ms
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:06:45
0.27ms
mysql
select * from `page_categories`
10:06:45
0.67ms
mysql
select * from `pages` where `pages`.`page_category_id` in (1, 2, 3, 4)
10:06:45
0.32ms
mysql
select `foreign_key` from `translations` where `table_name` = ? and `column_name` = ? and `value` = ? and `locale` in (?)
10:06:45
0.24ms
mysql
select count(*) as aggregate from `products` where 0 = 1
10:06:45
0.33ms
mysql
select * from `products` where `slug` = ? limit 1