PHP 8.1.339.36.3
FilesystemIterator::__construct(/var/www/vhosts/zarifalan.online/httpdocs/storage/framework/cache/data/e8/a4): Failed to open directory: No such file or directory
$sliders = Slider::where('status', 1)->orderBy('rank', 'asc')->get();
$product_categories = ProductCategory::where('product_category_id', null)->take(5)->get();
$aviva_special = Product::special()->take(4)->get();
$starred = Product::starred()->take(3)->get();
$seasons_color = Product::seasonsColor()->take(3)->get();
$expert_views = ExpertView::all();
$meta_description = setting('site.description-1');
return view('site.home', compact('weekly_product', 'trend_products', 'sliders', 'product_categories', 'aviva_special', 'starred', 'seasons_color', 'expert_views', 'meta_description'));
}
// Ürünler
public function products(ProductCategory $category)
{
Artisan::call('cache:clear');
$breadcrumbs = $category->buildParents($category)->map(function ($category, $index) {
return [
'name' => $category->getTranslatedAttribute('name', app()->getLocale(), config('voyager.multilingual.default')),
'url' => route('site.products.category', $category),
];
});
$category_model = $category;
$category = $category->translate(app()->getLocale(), config('voyager.multilingual.default'));
$subcategories = $category_model->subcategories()->withTranslations([app()->getLocale()])->get();
$products = Product::withTranslations([app()->getLocale()])->where('status', '=', 1)->orderBy('rank', 'ASC')->whereIn('product_category_id', $category_model->children()->pluck('id'))->paginate(12);
$relatedProducts = [];
if ($category_model->category) {
$relatedProducts = Product::withTranslations([app()->getLocale()])->whereIn('product_category_id', $category_model->category->children()->pluck('id'))->limit(12)->get();
}
Request
https://zarifalan.online/tr/urunler/bebek-odasi
GET
curl "https://zarifalan.online/tr/urunler/bebek-odasi" \
-X GET \
-H 'cookie: XSRF-TOKEN=eyJpdiI6IkozZ2xXb0FmV2UyWXc1b2VnZHdPcEE9PSIsInZhbHVlIjoiUHVQR1BYZ3V5OWNyWmU4OEpFUUVNVzUyODlvUTM0bkJaRlZIbXNtUFpFVXFLZVh5UkxhclQ5cjVyMWtCR2ovOStJL01yUnJwMVpNOHlNYXlDdDl4aDNCTUlNTmExNmFXUXNHSDVNMi95dERncGdIWlR5ZVRPQ3BKbHpZMUUzRXYiLCJtYWMiOiJkNjliMDk4YzJkYzlmNDdmYzk3MTMyZTk0OTkwMDZhNzVmZDMxMjM3MzRkNmRmYmRmNzNiMDhjYTJjMTk0OTkxIiwidGFnIjoiIn0%3D; aviva_mobilya_session=eyJpdiI6IkFaSGhuTm5Xa05BRFpDZGc3TDF2WGc9PSIsInZhbHVlIjoiSE9vTFlhYi9MQ0JmRjBLOGxnYjUyV25KZ0Izd2MybXgwd3FBQ1N4T0paUGZUajdmTUJKWW9wZlg0bWxPcDNHWk0zNWI1S3ZWYXZkekFsaUFTTGlUNXFJUXlJaVpzTFBqT0lrb1lmaHBFZlVaK1QraE1uSitnL2xLMWpkWXU4WmIiLCJtYWMiOiI4MzgyY2RmMzg1OTFhZjc3YmFkYTFlMWMyZTZiMTVmYjY5ODZmMDQzYmQ0MmMxZDg5MDZlODlkNTgxOGZiZTA5IiwidGFnIjoiIn0%3D' \
-H 'referer: https://zarifalan.online/tr/urun/daphne-yemek-odasi-takimi' \
-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=eyJpdiI6IkozZ2xXb0FmV2UyWXc1b2VnZHdPcEE9PSIsInZhbHVlIjoiUHVQR1BYZ3V5OWNyWmU4OEpFUUVNVzUyODlvUTM0bkJaRlZIbXNtUFpFVXFLZVh5UkxhclQ5cjVyMWtCR2ovOStJL01yUnJwMVpNOHlNYXlDdDl4aDNCTUlNTmExNmFXUXNHSDVNMi95dERncGdIWlR5ZVRPQ3BKbHpZMUUzRXYiLCJtYWMiOiJkNjliMDk4YzJkYzlmNDdmYzk3MTMyZTk0OTkwMDZhNzVmZDMxMjM3MzRkNmRmYmRmNzNiMDhjYTJjMTk0OTkxIiwidGFnIjoiIn0%3D; aviva_mobilya_session=eyJpdiI6IkFaSGhuTm5Xa05BRFpDZGc3TDF2WGc9PSIsInZhbHVlIjoiSE9vTFlhYi9MQ0JmRjBLOGxnYjUyV25KZ0Izd2MybXgwd3FBQ1N4T0paUGZUajdmTUJKWW9wZlg0bWxPcDNHWk0zNWI1S3ZWYXZkekFsaUFTTGlUNXFJUXlJaVpzTFBqT0lrb1lmaHBFZlVaK1QraE1uSitnL2xLMWpkWXU4WmIiLCJtYWMiOiI4MzgyY2RmMzg1OTFhZjc3YmFkYTFlMWMyZTZiMTVmYjY5ODZmMDQzYmQ0MmMxZDg5MDZlODlkNTgxOGZiZTA5IiwidGFnIjoiIn0%3D
- referer
https://zarifalan.online/tr/urun/daphne-yemek-odasi-takimi
- 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:01:16
0.87ms
mysql
select * from information_schema.tables where table_schema = ? and table_name = ? and table_type = 'BASE TABLE'
10:01:16
0.25ms
mysql
select `policy_name`, `model_name` from `data_types`
10:01:16
0.41ms
mysql
select * from `data_types`
10:01:16
0.41ms
mysql
select * from `product_categories` where `product_category_id` is null order by `rank` asc
10:01:16
0.39ms
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:01:16
0.26ms
mysql
select * from `page_categories`
10:01:16
0.66ms
mysql
select * from `pages` where `pages`.`page_category_id` in (1, 2, 3, 4)
10:01:16
0.27ms
mysql
select `foreign_key` from `translations` where `table_name` = ? and `column_name` = ? and `value` = ? and `locale` in (?)
10:01:16
0.21ms
mysql
select count(*) as aggregate from `product_categories` where 0 = 1
10:01:16
0.25ms
mysql
select * from `product_categories` where `slug` = ? limit 1