Welcome To شيخ العطارين Home

Messages Timeline Exceptions Views65 Route Queries20 Models43 Mails Gate Session Request

Request history8.2.281.35s43MBGET /

Booting (327ms)time
Application (1.02s)time
1 x Application (75.75%)
1.02s
1 x Booting (24.25%)
327ms

65 templates were rendered

1x web-views.homehome.blade.php#?blade
1x web-views.partials._home-top-slider_home-top-slider.blade.php#?blade
12x web-views.partials._feature-product_feature-product.blade.php#?blade
1x web-views.partials._category-section-home_category-section-home.blade.php#?blade
1x web-views.partials._deal-of-the-day_deal-of-the-day.blade.php#?blade
10x web-views.partials._inline-single-product_inline-single-product.blade.php#?blade
8x web-views.partials._product-card-2_product-card-2.blade.php#?blade
1x web-views.partials._best-selling_best-selling.blade.php#?blade
1x web-views.partials._top-rated_top-rated.blade.php#?blade
1x web-views.partials._category-wise-product_category-wise-product.blade.php#?blade
16x web-views.partials._category-single-product_category-single-product.blade.php#?blade
1x web-views.partials._company-reliability_company-reliability.blade.php#?blade
1x layouts.front-end.appapp.blade.php#?blade
1x web-views.partials._robotsMetaContentData_robotsMetaContentData.blade.php#?blade
1x layouts.front-end.partials._modals_modals.blade.php#?blade
1x layouts.front-end.partials._quick-view-modal_quick-view-modal.blade.php#?blade
1x layouts.front-end.partials.modal._buy-now_buy-now.blade.php#?blade
1x layouts.front-end.partials._header_header.blade.php#?blade
1x layouts.front-end.partials._cart_cart.blade.php#?blade
1x layouts.front-end.partials._alert-message_alert-message.blade.php#?blade
1x layouts.front-end.partials._footer_footer.blade.php#?blade
1x layouts.front-end.partials.modal._dynamic-modals_dynamic-modals.blade.php#?blade
1x layouts.front-end.partials._firebase-script_firebase-script.blade.php#?blade

uri: GET /
middleware: web, maintenance_mode, guestCheck
controller: App\Http\Controllers\Web\HomeController@index
namespace: App\Http\Controllers\Web
prefix
where
as: home
file: app/Http/Controllers/Web/HomeController.php:48-58

20 statements were executed (2 duplicates)Show only duplicates50.93ms

insert into `guest_users` (`ip_address`, `updated_at`, `created_at`) values ('52.14.210.44', '2025-04-29 22:43:07', '2025-04-29 22:43:07')
1.49mssheikh_devGuestMiddleware.php#24
Bindings
Backtrace
select * from `products` where (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') order by RAND() limit 1
12.1mssheikh_devCacheManagerTrait.php#301
Bindings
Backtrace
select * from `translations` where `translations`.`translationable_id` in (3322) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'eg'
530μssheikh_devCacheManagerTrait.php#301
Bindings
Backtrace
select * from `reviews` where `reviews`.`product_id` in (3322) and `delivery_man_id` is null and `status` = 1
360μssheikh_devCacheManagerTrait.php#301
Bindings
Backtrace
select `flash_deals`.*, (select count(*) from `flash_deal_products` where `flash_deals`.`id` = `flash_deal_products`.`flash_deal_id`) as `products_count` from `flash_deals` where (`deal_type` = 'flash_deal' and `status` = 1) and date(`start_date`) <= '2025-04-29' and date(`end_date`) >= '2025-04-29' limit 1
720μssheikh_devproduct-manager.php#1479
Bindings
Backtrace
select count(*) as aggregate from `products` where (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and (`featured` = 1)
3.58mssheikh_devproduct-manager.php#993
Bindings
Backtrace
select `products`.*, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and (`featured` = 1) order by `id` desc limit 12 offset 0
1.68mssheikh_devproduct-manager.php#993
Bindings
Backtrace
select * from `translations` where `translations`.`translationable_id` in (3301, 3303, 3304, 3307, 3308, 3312, 3318, 3320, 3321, 3322, 3323, 3324) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'eg'
560μssheikh_devproduct-manager.php#993
Bindings
Backtrace
select * from `reviews` where `reviews`.`product_id` in (3301, 3303, 3304, 3307, 3308, 3312, 3318, 3320, 3321, 3322, 3323, 3324) and `delivery_man_id` is null and `status` = 1
330μssheikh_devproduct-manager.php#993
Bindings
Backtrace
select count(*) as aggregate from `products` where (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical')
5.57mssheikh_devproduct-manager.php#1221
Bindings
Backtrace
select `products`.*, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count`, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_count`, (select count(*) from `wishlists` where `products`.`id` = `wishlists`.`product_id`) as `wish_list_count`, (select avg(`reviews`.`rating`) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1) as `reviews_avg_rating` from `products` where (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') order by `order_details_count` desc limit 8 offset 0
18.93mssheikh_devproduct-manager.php#1221
Bindings
Backtrace
select * from `translations` where `translations`.`translationable_id` in (3296, 3301, 3303, 3304, 3307, 3308, 3312, 3318) and `translations`.`translationable_type` = 'App\\Models\\Product' and `locale` = 'eg'
740μssheikh_devproduct-manager.php#1221
Bindings
Backtrace
select * from `reviews` where `reviews`.`product_id` in (3296, 3301, 3303, 3304, 3307, 3308, 3312, 3318) and `delivery_man_id` is null and `status` = 1
390μssheikh_devproduct-manager.php#1221
Bindings
Backtrace
select `deal_of_the_days`.*, `products`.`unit_price` from `deal_of_the_days` inner join `products` on `products`.`id` = `deal_of_the_days`.`product_id` where `products`.`status` = 1 and `deal_of_the_days`.`status` = 1 limit 1
390μssheikh_devHomeController.php#84
Bindings
Backtrace
select * from `storages` where `storages`.`data_type` = 'App\\Models\\Banner' and `storages`.`data_id` = 1 and `storages`.`data_id` is not null
680μssheikh_devBanner.php#67
Bindings
Backtrace
select `cart_group_id` from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `status` = 1) and (`customer_id` = 519636 and `is_guest` = 1) group by `cart_group_id`
640μssheikh_devcart-manager.php#100
Bindings
Backtrace
select * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `status` = 1) and 0 = 1
470μssheikh_devcart-manager.php#65
Bindings
Backtrace
select `cart_group_id` from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `status` = 1) and (`customer_id` = 519636 and `is_guest` = 1) group by `cart_group_id`
580μssheikh_devcart-manager.php#100
Bindings
Backtrace
select * from `carts` where exists (select * from `products` where `carts`.`product_id` = `products`.`id` and (`added_by` = 'admin') and `brand_id` is null and `status` = 1 and (`status` = 1) and (`request_status` = 1) and (exists (select * from `sellers` where `products`.`user_id` = `sellers`.`id` and (`status` = 'approved')) or ((`added_by` = 'admin' and `status` = 1))) and `product_type` in ('physical') and `status` = 1) and 0 = 1 and (`is_checked` = 1)
450μssheikh_devcart-manager.php#65
Bindings
Backtrace
select * from `flash_deals` where (`status` = 1 and `deal_type` = 'flash_deal') and date(`start_date`) <= '2025-04-29' and date(`end_date`) >= '2025-04-29' limit 1
740μssheikh_dev_footer.blade.php#109
Bindings
Backtrace

App\Models\Product: 21Product.php#?
App\Models\Translation: 21Translation.php#?
App\Models\Storage: 1Storage.php#?

system_default_currency_info: App\Models\Currency {#1983 #connection: "mysql" #table: "currencies" #primaryKey: "id" #keyT...
currency_code: LE
currency_symbol: EGP
currency_exchange_rate: 1
usd: 1
_token: ywn7qsVLynXfXVb87XDYczBUOF9LUdKcqyW2GbU9
guest_id: 519636
local: eg
direction: rtl
_previous: array:1 [ "url" => "https://shiekhattaren.com" ]
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

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

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 => "Tue, 29 Apr 2025 19:43:08 GMT"
  ]
  "set-cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IndRUHVNQzAxc0RvUjlta1pNWldEa2c9PSIsInZhbHVlIjoiOEdZeUJ4Uy9tckZEOVlOSFRaRTg0UG5DMVRJMEdYczkxZzFLY3JBNTZDUlBLeGFNYkFKR3FvQSs3Nk5qdG9ianB2d1FvYndWeFpxTGZNV2IzYTNzTGxWL2NDdE0xQVplZVpOZG1ua2taK21ZMzMvTEE2eUt1SEtLMEc3cEtZaGQiLCJtYWMiOiI5NWE2YzMyZWIxMzc0MTIzZWE0OTdlNGYwMjkxOGQ0MWM4NmZlMDZhYjUxZDE5ODY4NGVlZDBjNDEzNGFhYTFkIiwidGFnIjoiIn0%3D; expires=Tue, 29 Apr 2025 20:43:08 GMT; Max-Age=3600; path=/ ◀XSRF-TOKEN=eyJpdiI6IndRUHVNQzAxc0RvUjlta1pNWldEa2c9PSIsInZhbHVlIjoiOEdZeUJ4Uy9tckZEOVlOSFRaRTg0UG5DMVRJMEdYczkxZzFLY3JBNTZDUlBLeGFNYkFKR3FvQSs3Nk5qdG9ianB2d1FvY ▶"
    1 => "shiekhattaren_session=eyJpdiI6Ijc2Zy9kRVI0bmtScmlXbTN3S21MMGc9PSIsInZhbHVlIjoiRFEzK2hUZUFXR1JxL0ViZHh1YzF3MVBEeUdqbnQ3U2lNbnV1QmhzMWlKckI5UHZOUjE4ZVFzdFgyTVhRWVdjM0NEcWlkajB2NGpEU3pHcTlDV0xoekRsQXVJR0xsL21GUllhQUlpYlo3TUxLUUFyalRyTVhRSStSNGZvMXZyWm0iLCJtYWMiOiJkNmMyNzc4NDg2NTUzMWQ1N2VlNWE1MGFiYThhNDdhYzlmMzZkZWJmZmM1Mzg0YTRiYjUyOTE3YTNlN2RkYWVmIiwidGFnIjoiIn0%3D; expires=Tue, 29 Apr 2025 20:43:08 GMT; Max-Age=3600; path=/; httponly ◀shiekhattaren_session=eyJpdiI6Ijc2Zy9kRVI0bmtScmlXbTN3S21MMGc9PSIsInZhbHVlIjoiRFEzK2hUZUFXR1JxL0ViZHh1YzF3MVBEeUdqbnQ3U2lNbnV1QmhzMWlKckI5UHZOUjE4ZVFzdFgyTVhRWV ▶"
    2 => "popup_banner=eyJpdiI6InZaWDFTa2FneVI0Y3B0K1RJM0dqZnc9PSIsInZhbHVlIjoicGNuSENudVBXZStScDJXbWRwM0tBOW14akRrY21TUUFBZ01LNGxYd1RKa3lTQnRzVm5LT044ZHQ2Y05PakJvWCIsIm1hYyI6IjEwMmMyNDY0OTY0NjE3OTk0ODg0Y2I2NzM2ZWYwMDVmYTEzYjcwMDAwNTU5ODEyNjFhMWI4NTk4YjIyMTdlMjMiLCJ0YWciOiIifQ%3D%3D; expires=Tue, 29 Apr 2025 19:44:08 GMT; Max-Age=60; path=/; httponly ◀popup_banner=eyJpdiI6InZaWDFTa2FneVI0Y3B0K1RJM0dqZnc9PSIsInZhbHVlIjoicGNuSENudVBXZStScDJXbWRwM0tBOW14akRrY21TUUFBZ01LNGxYd1RKa3lTQnRzVm5LT044ZHQ2Y05PakJvWCIsIm1 ▶"
  ]
  "Set-Cookie" => array:3 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IndRUHVNQzAxc0RvUjlta1pNWldEa2c9PSIsInZhbHVlIjoiOEdZeUJ4Uy9tckZEOVlOSFRaRTg0UG5DMVRJMEdYczkxZzFLY3JBNTZDUlBLeGFNYkFKR3FvQSs3Nk5qdG9ianB2d1FvYndWeFpxTGZNV2IzYTNzTGxWL2NDdE0xQVplZVpOZG1ua2taK21ZMzMvTEE2eUt1SEtLMEc3cEtZaGQiLCJtYWMiOiI5NWE2YzMyZWIxMzc0MTIzZWE0OTdlNGYwMjkxOGQ0MWM4NmZlMDZhYjUxZDE5ODY4NGVlZDBjNDEzNGFhYTFkIiwidGFnIjoiIn0%3D; expires=Tue, 29-Apr-2025 20:43:08 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IndRUHVNQzAxc0RvUjlta1pNWldEa2c9PSIsInZhbHVlIjoiOEdZeUJ4Uy9tckZEOVlOSFRaRTg0UG5DMVRJMEdYczkxZzFLY3JBNTZDUlBLeGFNYkFKR3FvQSs3Nk5qdG9ianB2d1FvY ▶"
    1 => "shiekhattaren_session=eyJpdiI6Ijc2Zy9kRVI0bmtScmlXbTN3S21MMGc9PSIsInZhbHVlIjoiRFEzK2hUZUFXR1JxL0ViZHh1YzF3MVBEeUdqbnQ3U2lNbnV1QmhzMWlKckI5UHZOUjE4ZVFzdFgyTVhRWVdjM0NEcWlkajB2NGpEU3pHcTlDV0xoekRsQXVJR0xsL21GUllhQUlpYlo3TUxLUUFyalRyTVhRSStSNGZvMXZyWm0iLCJtYWMiOiJkNmMyNzc4NDg2NTUzMWQ1N2VlNWE1MGFiYThhNDdhYzlmMzZkZWJmZmM1Mzg0YTRiYjUyOTE3YTNlN2RkYWVmIiwidGFnIjoiIn0%3D; expires=Tue, 29-Apr-2025 20:43:08 GMT; path=/; httponly ◀shiekhattaren_session=eyJpdiI6Ijc2Zy9kRVI0bmtScmlXbTN3S21MMGc9PSIsInZhbHVlIjoiRFEzK2hUZUFXR1JxL0ViZHh1YzF3MVBEeUdqbnQ3U2lNbnV1QmhzMWlKckI5UHZOUjE4ZVFzdFgyTVhRWV ▶"
    2 => "popup_banner=eyJpdiI6InZaWDFTa2FneVI0Y3B0K1RJM0dqZnc9PSIsInZhbHVlIjoicGNuSENudVBXZStScDJXbWRwM0tBOW14akRrY21TUUFBZ01LNGxYd1RKa3lTQnRzVm5LT044ZHQ2Y05PakJvWCIsIm1hYyI6IjEwMmMyNDY0OTY0NjE3OTk0ODg0Y2I2NzM2ZWYwMDVmYTEzYjcwMDAwNTU5ODEyNjFhMWI4NTk4YjIyMTdlMjMiLCJ0YWciOiIifQ%3D%3D; expires=Tue, 29-Apr-2025 19:44:08 GMT; path=/; httponly ◀popup_banner=eyJpdiI6InZaWDFTa2FneVI0Y3B0K1RJM0dqZnc9PSIsInZhbHVlIjoicGNuSENudVBXZStScDJXbWRwM0tBOW14akRrY21TUUFBZ01LNGxYd1RKa3lTQnRzVm5LT044ZHQ2Y05PakJvWCIsIm1 ▶"
  ]
]

session_attributes

  0 of 0   
array:11 [▼
  "system_default_currency_info" => App\Models\Currency {#1983 ▶
    #connection: "mysql"
    #table: "currencies"
    #primaryKey: "id"
    #keyType: "int"
    +incrementing: true
    #with: []
    #withCount: []
    +preventsLazyLoading: false
    #perPage: 15
    +exists: true
    +wasRecentlyCreated: false
    #escapeWhenCastingToString: false
    #attributes: array:8 [▶
      "id" => 8
      "name" => "EGP"
      "symbol" => "EGP"
      "code" => "LE"
      "exchange_rate" => "1"
      "status" => 1
      "created_at" => "2024-11-27 15:01:00"
      "updated_at" => "2024-11-27 15:01:33"
    ]
    #original: array:8 [▶
      "id" => 8
      "name" => "EGP"
      "symbol" => "EGP"
      "code" => "LE"
      "exchange_rate" => "1"
      "status" => 1
      "created_at" => "2024-11-27 15:01:00"
      "updated_at" => "2024-11-27 15:01:33"
    ]
    #changes: []
    #casts: array:4 [▶
      "id" => "integer"
      "status" => "boolean"
      "created_at" => "datetime"
      "updated_at" => "datetime"
    ]
    #classCastCache: []
    #attributeCastCache: []
    #dateFormat: null
    #appends: []
    #dispatchesEvents: []
    #observables: []
    #relations: []
    #touches: []
    +timestamps: true
    +usesUniqueIds: false
    #hidden: []
    #visible: []
    #fillable: array:5 [▶
      0 => "name"
      1 => "symbol"
      2 => "code"
      3 => "exchange_rate"
      4 => "status"
    ]
    #guarded: array:1 [▶
      0 => "*"
    ]
  }
  "currency_code" => "LE"
  "currency_symbol" => "EGP"
  "currency_exchange_rate" => "1"
  "usd" => 1
  "_token" => "ywn7qsVLynXfXVb87XDYczBUOF9LUdKcqyW2GbU9"
  "guest_id" => 519636
  "local" => "eg"
  "direction" => "rtl"
  "_previous" => array:1 [▶
    "url" => "https://shiekhattaren.com"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-29 22:43:08	GET	/	65 20 43

test

Recommended product

بن حبشى

بن حبشى محوج

بن حبشى هيل

بن حبشى

بن كولومبي

بن كولومبى محوج

بن برازيلى محوج

بن حبشى محوج

بن حبشى هيل

بن حبشى

بن كولومبي

بن كولومبى محوج

بن برازيلى محوج

Special

Account & shipping info

Newsletter

1 x Application (75.75%)	1.02s
1 x Booting (24.25%)	327ms

Bindings
Backtrace

Bindings
Backtrace

Bindings
Backtrace

Shopping cart

test

Recommended product

بن حبشى

بن حبشى محوج

بن حبشى هيل

بن حبشى

بن كولومبي

بن كولومبى محوج

بن برازيلى محوج

بن حبشى محوج

بن حبشى هيل

بن حبشى

بن كولومبي

بن كولومبى محوج

بن برازيلى محوج

Out of stock

Product added to wishlist

Please Sign in

Delete this address?