DOWNLOAD OUR APP & GET AED 50 OFF X
ANUA Heartleaf Pore Control Cleansing Oil 200ml
(0) 0 Reviews 0 Orders 0 Wish listed
د.إ50.89
Quantity :
Total price :
  (Tax : )
Out of stock
  • Mild ingredients with Heartleaf extract: gently remove blackheads, makeup & sebum without any pore clogging 
  • Non-comedogenic formula: safe to use for acne-prone, sensitive skin 
  • Provide a refreshing finish through emulsification process that dissolves sebum by mixing water & oil

    Product description 

    Coming in a non-comedogenic formula and containing plant-based oils (including jojoba, olive fruit and grape seed oils), this oil cleanser effectively rids skin of impurities while leaving a refreshed and hydrated finish. Heartleaf extract in the lightweight formula helps keep irritations at bay. Suitable for acne-prone skin.

    Important information

    Safety Information

    External Use Only

    Ingredients

    Ethylhexyl Palmitate, Sorbeth-30 Tetraoleate, Sorbitan Sesquioleate, Caprylic/Capric Triglyceride, Butyl Avocadate, Fragrance, Helianthus Annuus (Sunflower) Seed Oil, Macadamia Ternifolia Seed Oil, Olea Europaea (Olive) Fruit Oil, Simmondsia Chinensis (Jojoba) Seed Oil, Vitis Vinifera (Grape) Seed Oil, Caprylyl Glycol, Ethylhexylglycerin, Curcuma Longa (Turmeric) Root Extract, Melia Azadirachta Flower Extract, Tocopherol, Melia Azadirachta Leaf Extract, Houttuynia Cordata Extract, Corallina Officinalis Extract, Melia Azadirachta Bark Extract, Moringa Oleifera Seed Oil, Ocimum Sanctum Leaf Extract

No review given yet!

Fast Delivery all across the country
Safe Payment
7 Days Return Policy
100% Authentic Products
You may also like
Anua PDRN Hyaluronic Acid Capsule 100 Serum
د.إ75.00
Anua Azelaic Acid 10 Hyaluron Redness Soothing Serum 30ml
د.إ95.00
ANUA 10% Niacinamide+ 4% Tranexamic Acid Serum
د.إ75.00
Cosrx Lip Sleep - Balancium Ceramide Lip Butter Sleeping Mask
د.إ55.00
Cosrx Lip Plump - Refresh AHA BHA Vitamin C Lip Plumper
د.إ60.00
Total price :
  (Tax : )
Request history8.1.32PHP Version526msRequest Duration21MBMemory UsageGET product/{slug}Route
    • Booting (335ms)time
    • Application (191ms)time
    • 1 x Booting (63.71%)
      335ms
      1 x Application (36.29%)
      191ms
      31 templates were rendered
      • web-views.products.detailsdetails.blade.php#?blade
      • web-views.partials._productSEOMetaContentData_productSEOMetaContentData.blade.php#?blade
      • web-views.partials._product-reviews_product-reviews.blade.php#?blade
      • web-views.partials._seller-products-product-details_seller-products-product-details.blade.php#?blade
      • web-views.partials._seller-products-product-details_seller-products-product-details.blade.php#?blade
      • web-views.partials._seller-products-product-details_seller-products-product-details.blade.php#?blade
      • web-views.partials._seller-products-product-details_seller-products-product-details.blade.php#?blade
      • web-views.partials._seller-products-product-details_seller-products-product-details.blade.php#?blade
      • web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
      • web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
      • web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
      • web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
      • web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
      • web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
      • web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
      • web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
      • web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
      • web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
      • web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
      • web-views.partials._inline-single-product-without-eye_inline-single-product-without-eye.blade.php#?blade
      • layouts.front-end.partials.modal._chatting_chatting.blade.php#?blade
      • layouts.front-end.appapp.blade.php#?blade
      • web-views.partials._robotsMetaContentData_robotsMetaContentData.blade.php#?blade
      • layouts.front-end.partials._modals_modals.blade.php#?blade
      • layouts.front-end.partials._quick-view-modal_quick-view-modal.blade.php#?blade
      • layouts.front-end.partials.modal._buy-now_buy-now.blade.php#?blade
      • layouts.front-end.partials._header_header.blade.php#?blade
      • layouts.front-end.partials._cart_cart.blade.php#?blade
      • layouts.front-end.partials._alert-message_alert-message.blade.php#?blade
      • layouts.front-end.partials._footer_footer.blade.php#?blade
      • layouts.front-end.partials.modal._dynamic-modals_dynamic-modals.blade.php#?blade
      uri
      GET product/{slug}
      middleware
      web, maintenance_mode, guestCheck
      controller
      App\Http\Controllers\Web\ProductDetailsController@index
      namespace
      App\Http\Controllers\Web
      prefix
      where
      as
      product
      file
      app/Http/Controllers/Web/ProductDetailsController.php:52-62
      69 statements were executed, 6 of which were duplicates, 63 unique. Show only duplicated48.8ms
      • select * from `business_settings` where (`type` = 'maintenance_mode') limit 1
        360μsu525167509_alhyrahelpers.php#167
        Bindings
        • 0: maintenance_mode
        Backtrace
        • 16. app/Utils/helpers.php:167
        • 17. middleware::maintenance_mode:20
        • 18. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • 19. middleware::api_lang:22
        • 20. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
      • insert into `guest_users` (`ip_address`, `updated_at`, `created_at`) values ('18.220.45.179', '2025-05-07 00:41:12', '2025-05-07 00:41:12')
        260μsu525167509_alhyraGuestMiddleware.php#26
        Bindings
        • 0: 18.220.45.179
        • 1: 2025-05-07 00:41:12
        • 2: 2025-05-07 00:41:12
        Backtrace
        • 22. middleware::guestCheck:26
        • 23. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • 24. middleware::maintenance_mode:27
        • 25. vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:183
        • 26. middleware::api_lang:22
      • select * from `products` where (`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 (`slug` = 'anua-heartleaf-pore-control-cleansing-oil-200ml-pIsHlU') limit 1
        1.09msu525167509_alhyraProductRepository.php#76
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: approved
        • 5: admin
        • 6: 1
        • 7: physical
        • 8: anua-heartleaf-pore-control-cleansing-oil-200ml-pIsHlU
        Backtrace
        • 16. app/Repositories/ProductRepository.php:76
        • 17. app/Http/Controllers/Web/ProductDetailsController.php:66
        • 18. app/Http/Controllers/Web/ProductDetailsController.php:57
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select * from `product_seos` where `product_seos`.`product_id` in (97)
        370μsu525167509_alhyraProductRepository.php#76
        Bindings
        • 0: 97
        Backtrace
        • 21. app/Repositories/ProductRepository.php:76
        • 22. app/Http/Controllers/Web/ProductDetailsController.php:66
        • 23. app/Http/Controllers/Web/ProductDetailsController.php:57
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select * from `digital_product_variations` where `digital_product_variations`.`product_id` in (97)
        260μsu525167509_alhyraProductRepository.php#76
        Backtrace
        • 21. app/Repositories/ProductRepository.php:76
        • 22. app/Http/Controllers/Web/ProductDetailsController.php:66
        • 23. app/Http/Controllers/Web/ProductDetailsController.php:57
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select * from `reviews` where `reviews`.`product_id` in (97) and `delivery_man_id` is null and `status` = 1
        280μsu525167509_alhyraProductRepository.php#76
        Bindings
        • 0: 1
        Backtrace
        • 21. app/Repositories/ProductRepository.php:76
        • 22. app/Http/Controllers/Web/ProductDetailsController.php:66
        • 23. app/Http/Controllers/Web/ProductDetailsController.php:57
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select * from `sellers` where `sellers`.`id` in (1)
        240μsu525167509_alhyraProductRepository.php#76
        Backtrace
        • 21. app/Repositories/ProductRepository.php:76
        • 22. app/Http/Controllers/Web/ProductDetailsController.php:66
        • 23. app/Http/Controllers/Web/ProductDetailsController.php:57
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select * from `shops` where `shops`.`seller_id` in (1)
        240μsu525167509_alhyraProductRepository.php#76
        Backtrace
        • 26. app/Repositories/ProductRepository.php:76
        • 27. app/Http/Controllers/Web/ProductDetailsController.php:66
        • 28. app/Http/Controllers/Web/ProductDetailsController.php:57
        • 29. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 30. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select * from `translations` where `translations`.`translationable_id` in (97) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
        270μsu525167509_alhyraProductRepository.php#76
        Bindings
        • 0: App\Models\Product
        • 1: en
        Backtrace
        • 21. app/Repositories/ProductRepository.php:76
        • 22. app/Http/Controllers/Web/ProductDetailsController.php:66
        • 23. app/Http/Controllers/Web/ProductDetailsController.php:57
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select count(*) as aggregate from `wishlists` where (`product_id` = 97)
        210μsu525167509_alhyraWishlistRepository.php#62
        Bindings
        • 0: 97
        Backtrace
        • 16. app/Repositories/WishlistRepository.php:62
        • 17. app/Http/Controllers/Web/ProductDetailsController.php:69
        • 18. app/Http/Controllers/Web/ProductDetailsController.php:57
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select count(*) as aggregate from `reviews` where (`product_id` = 97) and `status` = 1
        240μsu525167509_alhyraReviewRepository.php#70
        Bindings
        • 0: 97
        • 1: 1
        Backtrace
        • 16. app/Repositories/ReviewRepository.php:70
        • 17. app/Http/Controllers/Web/ProductDetailsController.php:74
        • 18. app/Http/Controllers/Web/ProductDetailsController.php:57
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select count(*) as aggregate from `products` where (`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 (`added_by` = 'admin') and `user_id` = 1 and `id` not in (97)
        710μsu525167509_alhyraProductRepository.php#328
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: approved
        • 5: admin
        • 6: 1
        • 7: physical
        • 8: admin
        • 9: 1
        • 10: 97
        Backtrace
        • 16. app/Repositories/ProductRepository.php:328
        • 17. app/Http/Controllers/Web/ProductDetailsController.php:85
        • 18. app/Http/Controllers/Web/ProductDetailsController.php:57
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select * from `products` where (`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 (`added_by` = 'admin') and `user_id` = 1 and `id` not in (97) order by `id` desc limit 5 offset 0
        680μsu525167509_alhyraProductRepository.php#328
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: approved
        • 5: admin
        • 6: 1
        • 7: physical
        • 8: admin
        • 9: 1
        • 10: 97
        Backtrace
        • 16. app/Repositories/ProductRepository.php:328
        • 17. app/Http/Controllers/Web/ProductDetailsController.php:85
        • 18. app/Http/Controllers/Web/ProductDetailsController.php:57
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select * from `translations` where `translations`.`translationable_id` in (304, 305, 306, 307, 308) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
        280μsu525167509_alhyraProductRepository.php#328
        Bindings
        • 0: App\Models\Product
        • 1: en
        Backtrace
        • 21. app/Repositories/ProductRepository.php:328
        • 22. app/Http/Controllers/Web/ProductDetailsController.php:85
        • 23. app/Http/Controllers/Web/ProductDetailsController.php:57
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select * from `reviews` where `reviews`.`product_id` in (304, 305, 306, 307, 308) and `delivery_man_id` is null and `status` = 1
        230μsu525167509_alhyraProductRepository.php#328
        Bindings
        • 0: 1
        Backtrace
        • 21. app/Repositories/ProductRepository.php:328
        • 22. app/Http/Controllers/Web/ProductDetailsController.php:85
        • 23. app/Http/Controllers/Web/ProductDetailsController.php:57
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select count(*) as aggregate from `products` where (`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 (`added_by` = 'admin') and `user_id` = 1
        660μsu525167509_alhyraProductRepository.php#328
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: approved
        • 5: admin
        • 6: 1
        • 7: physical
        • 8: admin
        • 9: 1
        Backtrace
        • 16. app/Repositories/ProductRepository.php:328
        • 17. app/Http/Controllers/Web/ProductDetailsController.php:98
        • 18. app/Http/Controllers/Web/ProductDetailsController.php:57
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select `products`.*, (select count(*) from `reviews` where `products`.`id` = `reviews`.`product_id` and `status` = 1 and `status` = 1) as `reviews_count` from `products` where (`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 (`added_by` = 'admin') and `user_id` = 1 limit 25 offset 0
        1.71msu525167509_alhyraProductRepository.php#328
        Bindings
        • 0: 1
        • 1: 1
        • 2: admin
        • 3: 1
        • 4: 1
        • 5: 1
        • 6: approved
        • 7: admin
        • 8: 1
        • 9: physical
        • 10: admin
        • 11: 1
        Backtrace
        • 16. app/Repositories/ProductRepository.php:328
        • 17. app/Http/Controllers/Web/ProductDetailsController.php:98
        • 18. app/Http/Controllers/Web/ProductDetailsController.php:57
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 5, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
        430μsu525167509_alhyraProductRepository.php#328
        Bindings
        • 0: App\Models\Product
        • 1: en
        Backtrace
        • 21. app/Repositories/ProductRepository.php:328
        • 22. app/Http/Controllers/Web/ProductDetailsController.php:98
        • 23. app/Http/Controllers/Web/ProductDetailsController.php:57
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select * from `reviews` where `reviews`.`product_id` in (1, 2, 3, 4, 5, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29) and `delivery_man_id` is null and `status` = 1
        2.45msu525167509_alhyraProductRepository.php#328
        Bindings
        • 0: 1
        Backtrace
        • 21. app/Repositories/ProductRepository.php:328
        • 22. app/Http/Controllers/Web/ProductDetailsController.php:98
        • 23. app/Http/Controllers/Web/ProductDetailsController.php:57
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select count(*) as aggregate from `order_details` where (`product_id` = 97)
        210μsu525167509_alhyraOrderDetailRepository.php#79
        Bindings
        • 0: 97
        Backtrace
        • 16. app/Repositories/OrderDetailRepository.php:79
        • 17. app/Http/Controllers/Web/ProductDetailsController.php:106
        • 18. app/Http/Controllers/Web/ProductDetailsController.php:57
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select count(*) as aggregate from `wishlists` where (`product_id` = 97)
        170μsu525167509_alhyraWishlistRepository.php#62
        Bindings
        • 0: 97
        Backtrace
        • 16. app/Repositories/WishlistRepository.php:62
        • 17. app/Http/Controllers/Web/ProductDetailsController.php:107
        • 18. app/Http/Controllers/Web/ProductDetailsController.php:57
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select count(*) as aggregate from `products` where (`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 (`category_id` = 2) and `id` not in (97)
        610μsu525167509_alhyraProductRepository.php#328
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: approved
        • 5: admin
        • 6: 1
        • 7: physical
        • 8: 2
        • 9: 97
        Backtrace
        • 16. app/Repositories/ProductRepository.php:328
        • 17. app/Http/Controllers/Web/ProductDetailsController.php:114
        • 18. app/Http/Controllers/Web/ProductDetailsController.php:57
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select * from `products` where (`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 (`category_id` = 2) and `id` not in (97) limit 12 offset 0
        1.27msu525167509_alhyraProductRepository.php#328
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: approved
        • 5: admin
        • 6: 1
        • 7: physical
        • 8: 2
        • 9: 97
        Backtrace
        • 16. app/Repositories/ProductRepository.php:328
        • 17. app/Http/Controllers/Web/ProductDetailsController.php:114
        • 18. app/Http/Controllers/Web/ProductDetailsController.php:57
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select * from `reviews` where `reviews`.`product_id` in (1, 2, 3, 4, 5, 10, 11, 12, 13, 14, 15, 16) and `delivery_man_id` is null and `status` = 1
        210μsu525167509_alhyraProductRepository.php#328
        Bindings
        • 0: 1
        Backtrace
        • 21. app/Repositories/ProductRepository.php:328
        • 22. app/Http/Controllers/Web/ProductDetailsController.php:114
        • 23. app/Http/Controllers/Web/ProductDetailsController.php:57
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 5, 10, 11, 12, 13, 14, 15, 16) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
        230μsu525167509_alhyraProductRepository.php#328
        Bindings
        • 0: App\Models\Product
        • 1: en
        Backtrace
        • 21. app/Repositories/ProductRepository.php:328
        • 22. app/Http/Controllers/Web/ProductDetailsController.php:114
        • 23. app/Http/Controllers/Web/ProductDetailsController.php:57
        • 24. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 25. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select * from `deal_of_the_days` where (`product_id` = 97 and `status` = 1) limit 1
        180μsu525167509_alhyraDealOfTheDayRepository.php#24
        Bindings
        • 0: 97
        • 1: 1
        Backtrace
        • 16. app/Repositories/DealOfTheDayRepository.php:24
        • 17. app/Http/Controllers/Web/ProductDetailsController.php:116
        • 18. app/Http/Controllers/Web/ProductDetailsController.php:57
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
      • select * from `business_settings` where (`type` = 'temporary_close') limit 1
        240μsu525167509_alhyrasettings.php#16
        Bindings
        • 0: temporary_close
        Backtrace
        • 16. app/Utils/settings.php:16
        • 18. app/Http/Controllers/Web/ProductDetailsController.php:57
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `business_settings` where (`type` = 'vacation_add') limit 1
        170μsu525167509_alhyrasettings.php#16
        Bindings
        • 0: vacation_add
        Backtrace
        • 16. app/Utils/settings.php:16
        • 18. app/Http/Controllers/Web/ProductDetailsController.php:57
        • 19. vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
        • 20. vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
        • 21. vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
      • select * from `storages` where `storages`.`data_type` = 'App\Models\ProductSeo' and `storages`.`data_id` = 97 and `storages`.`data_id` is not null
        470μsu525167509_alhyraProductSeo.php#79
        Bindings
        • 0: App\Models\ProductSeo
        • 1: 97
        Backtrace
        • 20. app/Models/ProductSeo.php:79
        • 26. view::web-views.partials._productSEOMetaContentData:34
        • 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 29. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 30. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `business_settings` where (`type` = 'guest_checkout') limit 1
        210μsu525167509_alhyrasettings.php#16
        Bindings
        • 0: guest_checkout
        Backtrace
        • 16. app/Utils/settings.php:16
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'currency_symbol_position') limit 1
        340μsu525167509_alhyrasettings.php#16
        Bindings
        • 0: currency_symbol_position
        Backtrace
        • 16. app/Utils/settings.php:16
        • 22. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 23. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 24. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 25. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'company_reliability') limit 1
        200μsu525167509_alhyrasettings.php#16
        Bindings
        • 0: company_reliability
        Backtrace
        • 16. app/Utils/settings.php:16
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'google_search_console_code') limit 1
        240μsu525167509_alhyrasettings.php#16
        Bindings
        • 0: google_search_console_code
        Backtrace
        • 16. app/Utils/settings.php:16
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'bing_webmaster_code') limit 1
        190μsu525167509_alhyrasettings.php#16
        Bindings
        • 0: bing_webmaster_code
        Backtrace
        • 16. app/Utils/settings.php:16
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'baidu_webmaster_code') limit 1
        220μsu525167509_alhyrasettings.php#16
        Bindings
        • 0: baidu_webmaster_code
        Backtrace
        • 16. app/Utils/settings.php:16
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'yandex_webmaster_code') limit 1
        210μsu525167509_alhyrasettings.php#16
        Bindings
        • 0: yandex_webmaster_code
        Backtrace
        • 16. app/Utils/settings.php:16
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `storages` where `storages`.`data_type` = 'App\Models\RobotsMetaContent' and `storages`.`data_id` = 1 and `storages`.`data_id` is not null
        290μsu525167509_alhyraRobotsMetaContent.php#89
        Bindings
        • 0: App\Models\RobotsMetaContent
        • 1: 1
        Backtrace
        • 20. app/Models/RobotsMetaContent.php:89
        • 26. view::web-views.partials._robotsMetaContentData:39
        • 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 29. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 30. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `business_settings` where (`type` = 'google_tag_manager_id') limit 1
        190μsu525167509_alhyrasettings.php#16
        Bindings
        • 0: google_tag_manager_id
        Backtrace
        • 16. app/Utils/settings.php:16
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'pixel_analytics') limit 1
        220μsu525167509_alhyrasettings.php#16
        Bindings
        • 0: pixel_analytics
        Backtrace
        • 16. app/Utils/settings.php:16
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `storages` where `storages`.`data_type` = 'App\Models\Banner' and `storages`.`data_id` = 3 and `storages`.`data_id` is not null
        240μsu525167509_alhyraBanner.php#61
        Bindings
        • 0: App\Models\Banner
        • 1: 3
        Backtrace
        • 20. app/Models/Banner.php:61
        • 26. view::layouts.front-end.partials._modals:12
        • 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 29. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 30. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `business_settings` where (`type` = 'announcement') limit 1
        340μsu525167509_alhyrasettings.php#16
        Bindings
        • 0: announcement
        Backtrace
        • 16. app/Utils/settings.php:16
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select `cart_group_id` from `carts` where (`customer_id` = 138840 and `is_guest` = 1) group by `cart_group_id`
        400μsu525167509_alhyracart-manager.php#92
        Bindings
        • 0: 138840
        • 1: 1
        Backtrace
        • 14. app/Utils/cart-manager.php:92
        • 15. app/Utils/cart-manager.php:51
        • 16. vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34
        • 17. app/Utils/cart-manager.php:52
        • 18. view::layouts.front-end.partials._cart:5
      • select * from `carts` where 0 = 1
        240μsu525167509_alhyracart-manager.php#59
        Backtrace
        • 15. app/Utils/cart-manager.php:59
        • 16. view::layouts.front-end.partials._cart:5
        • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select `cart_group_id` from `carts` where (`customer_id` = 138840 and `is_guest` = 1) group by `cart_group_id`
        290μsu525167509_alhyracart-manager.php#92
        Bindings
        • 0: 138840
        • 1: 1
        Backtrace
        • 14. app/Utils/cart-manager.php:92
        • 15. app/Utils/cart-manager.php:51
        • 16. vendor/laravel/framework/src/Illuminate/Conditionable/Traits/Conditionable.php:34
        • 17. app/Utils/cart-manager.php:52
        • 18. view::layouts.front-end.partials._cart:14
      • select * from `carts` where 0 = 1
        160μsu525167509_alhyracart-manager.php#59
        Backtrace
        • 15. app/Utils/cart-manager.php:59
        • 16. view::layouts.front-end.partials._cart:14
        • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`category_id` and (`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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')) as `product_count` from `categories` where `position` = 0
        1.36msu525167509_alhyracategory-manager.php#82
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: approved
        • 5: admin
        • 6: 1
        • 7: physical
        • 8: 0
        Backtrace
        • 15. app/Utils/category-manager.php:82
        • 16. view::layouts.front-end.partials._header:235
        • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select `products`.*, (select count(*) from `order_details` where `products`.`id` = `order_details`.`product_id`) as `order_details_count` from `products` where `products`.`category_id` in (1, 2, 3, 5, 6) and (`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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')
        12.23msu525167509_alhyracategory-manager.php#82
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: approved
        • 5: admin
        • 6: 1
        • 7: physical
        Backtrace
        • 20. app/Utils/category-manager.php:82
        • 21. view::layouts.front-end.partials._header:235
        • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 5, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 163, 164, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 255, 256, 257, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287, 288, 289, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308) and `translations`.`translationable_type` = 'App\Models\Product' and `locale` = 'en'
        810μsu525167509_alhyracategory-manager.php#82
        Bindings
        • 0: App\Models\Product
        • 1: en
        Backtrace
        • 25. app/Utils/category-manager.php:82
        • 26. view::layouts.front-end.partials._header:235
        • 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 29. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 30. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `reviews` where `reviews`.`product_id` in (1, 2, 3, 4, 5, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 70, 71, 72, 73, 74, 75, 76, 77, 78, 79, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 110, 111, 112, 113, 114, 115, 116, 117, 118, 119, 120, 121, 122, 123, 124, 125, 126, 127, 128, 129, 130, 131, 132, 133, 134, 135, 136, 137, 138, 139, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 150, 151, 152, 153, 154, 155, 156, 157, 158, 159, 160, 161, 163, 164, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 180, 181, 183, 184, 185, 186, 187, 188, 189, 190, 191, 192, 193, 194, 195, 196, 197, 198, 199, 200, 201, 202, 203, 204, 205, 206, 207, 208, 209, 210, 211, 212, 213, 214, 215, 216, 217, 218, 219, 220, 221, 222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 232, 233, 234, 235, 236, 237, 238, 239, 240, 241, 242, 243, 244, 245, 246, 247, 248, 249, 250, 251, 252, 255, 256, 257, 264, 265, 266, 267, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 279, 280, 281, 282, 283, 284, 285, 286, 287, 288, 289, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308) and `delivery_man_id` is null and `status` = 1
        500μsu525167509_alhyracategory-manager.php#82
        Bindings
        • 0: 1
        Backtrace
        • 25. app/Utils/category-manager.php:82
        • 26. view::layouts.front-end.partials._header:235
        • 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 29. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 30. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_category_id`) as `sub_category_product_count` from `categories` where `categories`.`parent_id` in (1, 2, 3, 5, 6) and `position` = 1 order by `priority` asc
        2.83msu525167509_alhyracategory-manager.php#82
        Bindings
        • 0: 1
        Backtrace
        • 20. app/Utils/category-manager.php:82
        • 21. view::layouts.front-end.partials._header:235
        • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select `categories`.*, (select count(*) from `products` where `categories`.`id` = `products`.`sub_sub_category_id`) as `sub_sub_category_product_count` from `categories` where `categories`.`parent_id` in (8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 20, 30, 44, 47, 60, 63, 64, 65, 66, 67, 68, 69) and `position` = 2 order by `priority` asc
        1.32msu525167509_alhyracategory-manager.php#82
        Bindings
        • 0: 2
        Backtrace
        • 25. app/Utils/category-manager.php:82
        • 26. view::layouts.front-end.partials._header:235
        • 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 29. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 30. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `translations` where `translations`.`translationable_id` in (18, 22, 25, 26, 32, 33, 45, 48, 61, 62) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
        300μsu525167509_alhyracategory-manager.php#82
        Bindings
        • 0: App\Models\Category
        • 1: en
        Backtrace
        • 30. app/Utils/category-manager.php:82
        • 31. view::layouts.front-end.partials._header:235
        • 33. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 34. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 35. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `translations` where `translations`.`translationable_id` in (8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 20, 30, 44, 47, 60, 63, 64, 65, 66, 67, 68, 69) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
        280μsu525167509_alhyracategory-manager.php#82
        Bindings
        • 0: App\Models\Category
        • 1: en
        Backtrace
        • 25. app/Utils/category-manager.php:82
        • 26. view::layouts.front-end.partials._header:235
        • 28. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 29. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 30. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 5, 6) and `translations`.`translationable_type` = 'App\Models\Category' and `locale` = 'en'
        370μsu525167509_alhyracategory-manager.php#82
        Bindings
        • 0: App\Models\Category
        • 1: en
        Backtrace
        • 20. app/Utils/category-manager.php:82
        • 21. view::layouts.front-end.partials._header:235
        • 23. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 24. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 25. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
      • select * from `business_settings` where (`type` = 'category_list_priority') limit 1
        270μsu525167509_alhyrasettings.php#16
        Bindings
        • 0: category_list_priority
        Backtrace
        • 16. app/Utils/settings.php:16
        • 18. app/Utils/category-manager.php:82
        • 19. view::layouts.front-end.partials._header:235
        • 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 22. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • select * from `business_settings` where (`type` = 'brand_list_priority') limit 1
        190μsu525167509_alhyrasettings.php#16
        Bindings
        • 0: brand_list_priority
        Backtrace
        • 16. app/Utils/settings.php:16
        • 18. app/Utils/brand-manager.php:33
        • 19. view::layouts.front-end.partials._header:336
        • 21. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 22. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • select `brands`.*, (select count(*) from `products` where `brands`.`id` = `products`.`brand_id` and (`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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')) as `brand_products_count` from `brands` where `status` = 1 order by `created_at` desc
        6.46msu525167509_alhyrabrand-manager.php#58
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: approved
        • 5: admin
        • 6: 1
        • 7: physical
        • 8: 1
        Backtrace
        • 15. app/Utils/brand-manager.php:58
        • 16. app/Utils/brand-manager.php:33
        • 17. view::layouts.front-end.partials._header:336
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • select * from `translations` where `translations`.`translationable_id` in (1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 40, 41, 42, 43) and `translations`.`translationable_type` = 'App\Models\Brand' and `locale` = 'en'
        470μsu525167509_alhyrabrand-manager.php#58
        Bindings
        • 0: App\Models\Brand
        • 1: en
        Backtrace
        • 20. app/Utils/brand-manager.php:58
        • 21. app/Utils/brand-manager.php:33
        • 22. view::layouts.front-end.partials._header:336
        • 24. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 25. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
      • select count(*) as aggregate from `products` where (`added_by` = 'admin') and exists (select * from `brands` where `products`.`brand_id` = `brands`.`id` 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 `discount` != 0
        580μsu525167509_alhyra_header.blade.php#366
        Bindings
        • 0: admin
        • 1: 1
        • 2: 1
        • 3: 1
        • 4: approved
        • 5: admin
        • 6: 1
        • 7: physical
        • 8: 0
        Backtrace
        • 16. view::layouts.front-end.partials._header:366
        • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 21. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'loader_gif') limit 1
        270μsu525167509_alhyrasettings.php#16
        Bindings
        • 0: loader_gif
        Backtrace
        • 16. app/Utils/settings.php:16
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'country_code') limit 1
        200μsu525167509_alhyrasettings.php#16
        Bindings
        • 0: country_code
        Backtrace
        • 16. app/Utils/settings.php:16
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `flash_deals` where (`status` = 1 and `deal_type` = 'flash_deal') and date(`start_date`) <= '2025-05-07' and date(`end_date`) >= '2025-05-07' limit 1
        320μsu525167509_alhyra_footer.blade.php#109
        Bindings
        • 0: 1
        • 1: flash_deal
        • 2: 2025-05-07
        • 3: 2025-05-07
        Backtrace
        • 16. view::layouts.front-end.partials._footer:109
        • 18. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 19. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 21. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'refund-policy') limit 1
        190μsu525167509_alhyrasettings.php#16
        Bindings
        • 0: refund-policy
        Backtrace
        • 16. app/Utils/settings.php:16
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'return-policy') limit 1
        400μsu525167509_alhyrasettings.php#16
        Bindings
        • 0: return-policy
        Backtrace
        • 16. app/Utils/settings.php:16
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'cancellation-policy') limit 1
        160μsu525167509_alhyrasettings.php#16
        Bindings
        • 0: cancellation-policy
        Backtrace
        • 16. app/Utils/settings.php:16
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'company_phone') limit 1
        140μsu525167509_alhyrasettings.php#16
        Bindings
        • 0: company_phone
        Backtrace
        • 16. app/Utils/settings.php:16
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'company_email') limit 1
        110μsu525167509_alhyrasettings.php#16
        Bindings
        • 0: company_email
        Backtrace
        • 16. app/Utils/settings.php:16
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'shop_address') limit 1
        140μsu525167509_alhyrasettings.php#16
        Bindings
        • 0: shop_address
        Backtrace
        • 16. app/Utils/settings.php:16
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      • select * from `business_settings` where (`type` = 'whatsapp') limit 1
        190μsu525167509_alhyrasettings.php#16
        Bindings
        • 0: whatsapp
        Backtrace
        • 16. app/Utils/settings.php:16
        • 19. vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
        • 20. vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
        • 21. vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
        • 22. vendor/laravel/framework/src/Illuminate/View/View.php:207
      App\Models\Product
      330Product.php#?
      App\Models\Brand
      43Brand.php#?
      App\Models\Category
      37Category.php#?
      App\Models\BusinessSetting
      23BusinessSetting.php#?
      App\Models\Storage
      3Storage.php#?
      App\Models\Review
      3Review.php#?
      App\Models\ProductSeo
      1ProductSeo.php#?
      App\Models\Seller
      1Seller.php#?
      App\Models\Shop
      1Shop.php#?
          storage_connection_type
          public
          company_name
          alhyra
          company_web_logo
          array:3 [ "key" => "2024-09-07-66dc98dcc974d.webp" "path" => "https://alhyra.com/storage/app/pub...
          decimal_point_settings
          2
          product_brand
          1
          digital_product
          0
          business_mode
          single
          currency_model
          single_currency
          language
          array:2 [ 0 => array:6 [ "id" => "1" "name" => "english" "direction" => "ltr" "cod...
          local
          en
          direction
          ltr
          system_default_currency
          8
          system_default_currency_info
          App\Models\Currency {#3620 #connection: "mysql" #table: "currencies" #primaryKey: "id" #keyT...
          currency_code
          AED
          currency_symbol
          د.إ
          currency_exchange_rate
          1
          _token
          FKx57hdRfxXPRJSFHs2YbfvOuZBxrOMHIl3V9OwN
          guest_id
          138840
          currency_symbol_position
          left
          company_email
          info@alhyra.com
          _previous
          array:1 [ "url" => "https://alhyra.com/product/anua-heartleaf-pore-control-cleansing-oil-200ml-pIs...
          _flash
          array:2 [ "old" => [] "new" => [] ]
          PHPDEBUGBAR_STACK_DATA
          []
          path_info
          /product/anua-heartleaf-pore-control-cleansing-oil-200ml-pIsHlU
          status_code
          200
          
          status_text
          OK
          format
          html
          content_type
          text/html; charset=UTF-8
          request_query
          []
          
          request_request
          []
          
          request_headers
          0 of 0
          array:22 [ "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" ] "accept-encoding" => array:1 [ 0 => "br" ] "host" => array:1 [ 0 => "alhyra.com" ] "pragma" => array:1 [ 0 => "no-cache" ] "user-agent" => array:1 [ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "cache-control" => array:1 [ 0 => "no-cache" ] "x-forwarded-for" => array:1 [ 0 => "18.220.45.179" ] "x-forwarded-proto" => array:1 [ 0 => "https" ] "x-real-ip" => array:1 [ 0 => "18.220.45.179" ] "x-real-port" => array:1 [ 0 => "16281" ] "x-forwarded-port" => array:1 [ 0 => "443" ] "x-port" => array:1 [ 0 => "443" ] "x-lscache" => array:1 [ 0 => "1" ] "sec-ch-ua" => array:1 [ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "sec-ch-ua-mobile" => array:1 [ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [ 0 => "1" ] "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" ] "priority" => array:1 [ 0 => "u=0, i" ] ]
          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 => "Wed, 07 May 2025 00:41:12 GMT" ] "set-cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ijl0T1lWQVc1c1gyK0FNZjZpd3QrL0E9PSIsInZhbHVlIjoiV2dYaXhOdWVVYXdWaTB1V2daSnAxQU0wSDU1TGJndi9zckNsdlE0bE8xcnZGaDlJdHcvcTFRK2xCbTREdmEyaWdnTzN4UGJHOUdzbzhJaWdzc1AxckYwZHpQWWhlbWZlQW5UUGl3ZC9NR0xHNXQ2VFp6M1Jway9tTk12WERSTXciLCJtYWMiOiI3YjUxMTJlZGM5ZTJjOGJkYzExNDk2NDNjNDVkYWU5ZTY5ZWEyNzUxMzgyYjQ2ZDhjNTYxNjkwNjVhNTUwYWNhIiwidGFnIjoiIn0%3D; expires=Wed, 07 May 2025 01:41:13 GMT; Max-Age=3600; path=/XSRF-TOKEN=eyJpdiI6Ijl0T1lWQVc1c1gyK0FNZjZpd3QrL0E9PSIsInZhbHVlIjoiV2dYaXhOdWVVYXdWaTB1V2daSnAxQU0wSDU1TGJndi9zckNsdlE0bE8xcnZGaDlJdHcvcTFRK2xCbTREdmEyaWdnTzN4U" 1 => "6valley1725724725_session=eyJpdiI6IlpnUnJwR2VXaFR2STJkOEVlWE1QMkE9PSIsInZhbHVlIjoiWWpVUnlNT3dSOU1HUTB4eGlqazE2MlEwYU1tUXBJTDBrVHZtbjYzWFdwT0ZoVGZZUlc2d2FXSkhmOEhOL3JhRjM3K2FZOVdoQmpGMEhVb0NNS3RwaFdxSUcyNXBKRkZ0cFRwdGZGc0hJcWpnYk04RW9IeTBpYmRZOTB2Y3A2dkIiLCJtYWMiOiI0OTdhYTE0MzE4NmUzNGQwYTMyMGFlODYzMjQ2ZGIxMWQwNzIwNmU2MzAxNmEyN2RlYjI4N2MyZDkyOGFiOGNjIiwidGFnIjoiIn0%3D; expires=Wed, 07 May 2025 01:41:13 GMT; Max-Age=3600; path=/; httponly6valley1725724725_session=eyJpdiI6IlpnUnJwR2VXaFR2STJkOEVlWE1QMkE9PSIsInZhbHVlIjoiWWpVUnlNT3dSOU1HUTB4eGlqazE2MlEwYU1tUXBJTDBrVHZtbjYzWFdwT0ZoVGZZUlc2d2FXSkhmOE" ] "Set-Cookie" => array:2 [ 0 => "XSRF-TOKEN=eyJpdiI6Ijl0T1lWQVc1c1gyK0FNZjZpd3QrL0E9PSIsInZhbHVlIjoiV2dYaXhOdWVVYXdWaTB1V2daSnAxQU0wSDU1TGJndi9zckNsdlE0bE8xcnZGaDlJdHcvcTFRK2xCbTREdmEyaWdnTzN4UGJHOUdzbzhJaWdzc1AxckYwZHpQWWhlbWZlQW5UUGl3ZC9NR0xHNXQ2VFp6M1Jway9tTk12WERSTXciLCJtYWMiOiI3YjUxMTJlZGM5ZTJjOGJkYzExNDk2NDNjNDVkYWU5ZTY5ZWEyNzUxMzgyYjQ2ZDhjNTYxNjkwNjVhNTUwYWNhIiwidGFnIjoiIn0%3D; expires=Wed, 07-May-2025 01:41:13 GMT; path=/XSRF-TOKEN=eyJpdiI6Ijl0T1lWQVc1c1gyK0FNZjZpd3QrL0E9PSIsInZhbHVlIjoiV2dYaXhOdWVVYXdWaTB1V2daSnAxQU0wSDU1TGJndi9zckNsdlE0bE8xcnZGaDlJdHcvcTFRK2xCbTREdmEyaWdnTzN4U" 1 => "6valley1725724725_session=eyJpdiI6IlpnUnJwR2VXaFR2STJkOEVlWE1QMkE9PSIsInZhbHVlIjoiWWpVUnlNT3dSOU1HUTB4eGlqazE2MlEwYU1tUXBJTDBrVHZtbjYzWFdwT0ZoVGZZUlc2d2FXSkhmOEhOL3JhRjM3K2FZOVdoQmpGMEhVb0NNS3RwaFdxSUcyNXBKRkZ0cFRwdGZGc0hJcWpnYk04RW9IeTBpYmRZOTB2Y3A2dkIiLCJtYWMiOiI0OTdhYTE0MzE4NmUzNGQwYTMyMGFlODYzMjQ2ZGIxMWQwNzIwNmU2MzAxNmEyN2RlYjI4N2MyZDkyOGFiOGNjIiwidGFnIjoiIn0%3D; expires=Wed, 07-May-2025 01:41:13 GMT; path=/; httponly6valley1725724725_session=eyJpdiI6IlpnUnJwR2VXaFR2STJkOEVlWE1QMkE9PSIsInZhbHVlIjoiWWpVUnlNT3dSOU1HUTB4eGlqazE2MlEwYU1tUXBJTDBrVHZtbjYzWFdwT0ZoVGZZUlc2d2FXSkhmOE" ] ]
          session_attributes
          0 of 0
          array:23 [ "storage_connection_type" => "public" "company_name" => "alhyra" "company_web_logo" => array:3 [ "key" => "2024-09-07-66dc98dcc974d.webp" "path" => "https://alhyra.com/storage/app/public/company/2024-09-07-66dc98dcc974d.webp" "status" => 200 ] "decimal_point_settings" => 2 "product_brand" => 1 "digital_product" => 0 "business_mode" => "single" "currency_model" => "single_currency" "language" => array:2 [ 0 => array:6 [ "id" => "1" "name" => "english" "direction" => "ltr" "code" => "en" "status" => 1 "default" => true ] 1 => array:6 [ "id" => 2 "name" => "Arabic" "direction" => "rtl" "code" => "ae" "status" => 0 "default" => false ] ] "local" => "en" "direction" => "ltr" "system_default_currency" => 8 "system_default_currency_info" => App\Models\Currency {#3620 #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" => "AED" "symbol" => "د.إ" "code" => "AED" "exchange_rate" => "1" "status" => 1 "created_at" => "2024-09-07 17:44:11" "updated_at" => "2024-09-07 17:44:27" ] #original: array:8 [ "id" => 8 "name" => "AED" "symbol" => "د.إ" "code" => "AED" "exchange_rate" => "1" "status" => 1 "created_at" => "2024-09-07 17:44:11" "updated_at" => "2024-09-07 17:44:27" ] #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" => "AED" "currency_symbol" => "د.إ" "currency_exchange_rate" => "1" "_token" => "FKx57hdRfxXPRJSFHs2YbfvOuZBxrOMHIl3V9OwN" "guest_id" => 138840 "currency_symbol_position" => "left" "company_email" => "info@alhyra.com" "_previous" => array:1 [ "url" => "https://alhyra.com/product/anua-heartleaf-pore-control-cleansing-oil-200ml-pIsHlU" ] "_flash" => array:2 [ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]
          ClearShow all
          Date ↕MethodURLData
          #12025-05-07 00:41:13GET/product/anua-heartleaf-pore-control-cleansing-oil-200ml-pIsHlU3169442