abdo.onclick-eg.com
Open in
urlscan Pro
2606:4700:3030::6815:4206
Public Scan
URL:
https://abdo.onclick-eg.com/
Submission: On March 20 via api from US — Scanned from US
Submission: On March 20 via api from US — Scanned from US
Form analysis 6 forms found in the DOM
https://abdo.onclick-eg.com/products
<form action="https://abdo.onclick-eg.com/products" type="submit">
<div class="d-flex">
<div class="select-wrap focus-border border border-end-logical-0 d-flex align-items-center">
<div class="border-end">
<div class="dropdown search_dropdown">
<button type="button" class="border-0 px-3 bg-transparent dropdown-toggle text-dark py-0 text-capitalize" data-bs-toggle="dropdown" aria-expanded="false"> All categories </button>
<input type="hidden" name="search_category_value" id="search_category_value" value="all">
<ul class="dropdown-menu">
<li>
<a class="d-flex text-capitalize" data-value="all" href="javascript:">
All categories
</a>
</li>
<li>
<a class="d-flex" data-value="2" href="javascript:">
flower
</a>
</li>
<li>
<a class="d-flex" data-value="5" href="javascript:">
Real Estate
</a>
</li>
<li>
<a class="d-flex" data-value="8" href="javascript:">
Market
</a>
</li>
</ul>
</div>
</div>
<input type="search" class="form-control border-0 focus-input search-bar-input" name="name" id="global-search" placeholder="Search for items...">
</div>
<input name="data_from" value="search" hidden="">
<input name="page" value="1" hidden="">
<button type="submit" class="btn btn-primary">
<i class="bi bi-search"></i>
</button>
</div>
</form>https://abdo.onclick-eg.com/products
<form action="https://abdo.onclick-eg.com/products" class="mb-3">
<div class="search-bar">
<input type="search" name="name" class="form-control search-bar-input-mobile" autocomplete="off" placeholder="Search for items...">
<input name="data_from" value="search" hidden="">
<input name="page" value="1" hidden="">
<button type="submit">
<i class="bi bi-search"></i>
</button>
</div>
<div class="card search-card __inline-13 position-absolute z-99 w-100 bg-white start-0 search-result-box d--none"></div>
</form>POST https://abdo.onclick-eg.com/subscription
<form class="newsletter-form" action="https://abdo.onclick-eg.com/subscription" method="post">
<input type="hidden" name="_token" value="4fHbLrq4LigFyuNLtMaeHIQTtuOooAWmTcQoKKZe" autocomplete="off">
<div class="position-relative">
<label class="position-relative m-0 d-block">
<i class="bi bi-envelope envelop-icon text-muted fs-18"></i>
<input type="text" placeholder="Enter your email" class="form-control" name="subscription_email" required="">
</label>
<button type="submit" class="btn btn-primary">Submit</button>
</div>
</form>POST https://abdo.onclick-eg.com/customer/auth/sign-up
<form action="https://abdo.onclick-eg.com/customer/auth/sign-up" method="POST" id="customer-form" enctype="multipart/form-data">
<input type="hidden" name="_token" value="4fHbLrq4LigFyuNLtMaeHIQTtuOooAWmTcQoKKZe" autocomplete="off">
<div class="custom-scrollbar height-45vh">
<div class="row">
<div class="col-sm-6">
<div class="form-group mb-4">
<label class="text-capitalize" for="f_name"> First name</label>
<input type="text" id="f_name" name="f_name" class="form-control" placeholder="Ex:Jhone" value="" required="">
</div>
</div>
<div class="col-sm-6">
<div class="form-group mb-4">
<label class="text-capitalize" for="l_name">Last name</label>
<input type="text" id="l_name" name="l_name" value="" class="form-control" placeholder="Ex:Doe" required="">
</div>
</div>
<div class="col-sm-6">
<div class="form-group mb-4">
<label for="r_email">Email</label>
<input type="text" id="r_email" value="" name="email" class="form-control" placeholder="Enter email or phone number" autocomplete="off" required="">
</div>
</div>
<div class="col-sm-6">
<div class="form-group mb-4">
<label for="phone">Phone</label>
<input type="number" id="phone" value="" name="phone" class="form-control" placeholder="Enter phone number" required="">
</div>
</div>
<div class="col-sm-6">
<div class="mb-4">
<label for="password">Password</label>
<div class="input-inner-end-ele">
<input type="password" id="password" name="password" class="form-control" placeholder="Minimum 8 characters long" autocomplete="off" required="">
<i class="bi bi-eye-slash-fill togglePassword"></i>
</div>
</div>
</div>
<div class="col-sm-6">
<div class="mb-4">
<label class="text-capitalize" for="confirm_password">Confirm password</label>
<div class="input-inner-end-ele">
<input type="password" id="confirm_password" class="form-control" name="con_password" placeholder="Minimum 8 characters long" autocomplete="off" required="">
<i class="bi bi-eye-slash-fill togglePassword"></i>
</div>
</div>
</div>
</div>
<div class="d-flex gap-3 justify-content-center py-2 mt-4 mb-3">
<div class="">
<input type="text" class="form-control border __h-40" name="default_recaptcha_value_customer_regi" value="" placeholder="Enter captcha value" autocomplete="off">
</div>
<div class="input-icons rounded bg-white">
<a id="re-captcha-customer-register" class="d-flex align-items-center align-items-center">
<img src="https://abdo.onclick-eg.com/customer/auth/code/captcha/1?captcha_session_id=default_recaptcha_id_customer_regi" alt="" class="input-field rounded __h-40" id="customer-regi-recaptcha-id">
<i class="bi bi-arrow-repeat icon cursor-pointer p-2"></i>
</a>
</div>
</div>
<div class="d-flex justify-content-center mt-4">
<label for="agree" class="d-flex gap-1 align-items-center mb-0">
<input type="checkbox" id="input-checked" required=""> I agree with the <a href="https://abdo.onclick-eg.com/terms-and-condition" class="text-info text-capitalize">Terms & Conditions</a>
</label>
</div>
</div>
<div class="d-flex justify-content-center mt-4 mb-3">
<button type="submit" id="sign-up" class="btn btn-primary px-5 text-capitalize" disabled="">Sign up</button>
</div>
</form>POST https://abdo.onclick-eg.com/customer/auth/login
<form action="https://abdo.onclick-eg.com/customer/auth/login" method="post" id="customer-login-modal" autocomplete="off">
<input type="hidden" name="_token" value="4fHbLrq4LigFyuNLtMaeHIQTtuOooAWmTcQoKKZe" autocomplete="off">
<div class="form-group mb-4">
<label for="email">Email / Phone</label>
<input name="user_id" id="si-email" class="form-control" value="" placeholder="Enter email or phone number" required="">
</div>
<div class="mb-4">
<label for="password">Password</label>
<div class="input-inner-end-ele">
<input name="password" type="password" id="si-password" class="form-control" placeholder="Ex::6+ Character" required="">
<i class="bi bi-eye-slash-fill togglePassword"></i>
</div>
</div>
<div class="d-flex justify-content-between gap-3 align-items-center">
<label for="remember" class="d-flex gap-1 align-items-center mb-0">
<input type="checkbox" name="remember" id="remember"> Remember me </label>
<a href="https://abdo.onclick-eg.com/customer/auth/recover-password" class="text-capitalize">Forgot password? </a>
</div>
<div class="d-flex justify-content-center align-items-center gap-3 py-2 mt-4 mb-3">
<div>
<input type="text" class="form-control border __h-40" name="default_recaptcha_id_customer_login" value="" placeholder="Enter captcha value" autocomplete="off">
</div>
<div class="input-icons rounded bg-white">
<a id="re-captcha-customer-login" class="d-flex align-items-center align-items-center">
<img src="https://abdo.onclick-eg.com/customer/auth/code/captcha/1?captcha_session_id=default_recaptcha_id_customer_login" alt="" class="input-field rounded __h-40" id="customer_login_recaptcha_id">
<i class="bi bi-arrow-repeat icon cursor-pointer p-2"></i>
</a>
</div>
</div>
<div class="d-flex justify-content-center mb-3">
<button type="submit" class="fs-16 btn btn-primary px-5">Login</button>
</div>
</form><form><br><b>Filter results</b><br>Method: <select name="method">
<option></option>
<option>GET</option>
<option>POST</option>
<option>PUT</option>
<option>DELETE</option>
</select><br>Uri: <input type="text" name="uri"><br>IP: <input type="text" name="ip"><br><button type="submit">Search</button></form>Text Content
Welcome Donia
01066663850
*
* English
* English
* Arabic
All categories
* All categories
* flower
* Real Estate
* Market
* Categories
* flower
* omar warda
* flowers_white
* Real Estate
* Apartments
* Villas
* Market
* Home
* Brands
* luxury
* Discounted products
Theme mode
Login/Register
Select category
* flower
* omar warda
* flowers_white
* Real Estate
* Apartments
* Villas
* Market
* View all
* Home
* Brands
luxury
View all...
* Discounted products
* Login/Register
*
*
* 0
EMPTY CART
Light
Dark
* flower
* omar warda
* flowers_white
* Real Estate
* Apartments
* Villas
* Market
* View all
FIND WHAT YOU NEED
FLOWER
3 Products
View all
2+ Products
omar warda
REAL ESTATE
0 Products
View all
0 Products
Apartments
0 Products
Villas
FLOWER
3 Products
View all
2+ Products
omar warda
REAL ESTATE
0 Products
View all
0 Products
Apartments
0 Products
Villas
FLOWER
3 Products
View all
2+ Products
omar warda
REAL ESTATE
0 Products
View all
0 Products
Apartments
0 Products
Villas
REAL ESTATE
0 Products
View all
Apartments
Villas
FLOWER
3 Products
View all
omar warda
REAL ESTATE
0 Products
View all
Apartments
Villas
FLOWER
3 Products
View all
omar warda
RECOMMENDED FOR YOU
Featured Products Best selling Latest Products
View all
View all
( 0 )
New App
TEST
EGP250.00
( 0 )
New App
FLOWER
EGP100.00
View all
- 20%
( 0 )
New App
ABO AUF COFFE
EGP100.00 EGP80.00
( 0 )
New App
TEST
EGP250.00
( 0 )
New App
AR
EGP100.00
( 0 )
New App
FLOWER
EGP100.00
TOP RATED PRODUCTS
( 0 )
New App
TEST
EGP250.00
( 0 )
New App
FLOWER
EGP100.00
( 0 )
New App
TEST
EGP250.00
( 0 )
New App
FLOWER
EGP100.00
( 0 )
New App
TEST
EGP250.00
( 0 )
New App
FLOWER
EGP100.00
Don’t miss the chance!
TODAY’S BEST DEAL
ABO AUF COFFE
(0)
EGP100.00 EGP80.00 Save EGP20.00
Buy now
JUST FOR YOU
EGP100.00
EGP100.00
EGP250.00
- 20 %
EGP100.00 EGP80.00
FLOWER
View all
test
EGP250.00
ar
EGP100.00
flower
EGP100.00
test
EGP250.00
ar
EGP100.00
flower
EGP100.00
test
EGP250.00
ar
EGP100.00
flower
EGP100.00
REAL ESTATE
MARKET
View all
- 20%
Abo Auf Coffe
EGP100.00 EGP80.00
- 20%
Abo Auf Coffe
EGP100.00 EGP80.00
- 20%
Abo Auf Coffe
EGP100.00 EGP80.00
FIRST SHIPPING
First shipping all across the country
AUTHENTIC PRODUCTS
100% Authentic products
100%SECURE PAYMENT
We ensure secure transactions
24/7 SUPPORT CENTER
We ensure quality support
*
*
*
*
*
*
HOTLINE
01066663850
Egypt
admin@admin.com
NEWSLETTER
Subscribe our newsletter to get latest updates
Submit
ACCOUNTS
* Open your store
* Profile
* Track Order
* Help & support
QUICK LINKS
* Featured Products
* Top stores
* Latest Products
* FAQ
OTHER
* About Company
* Privacy Policy
* Terms & Conditions
* Refund policy
* Return policy
* Cancellation policy
* Support Ticket
CopyRight OnClick@2024
* Home
*
Wishlist
* 0
Cart
EMPTY CART
*
Compare
SIGN UP
Login to your account. Don’t have account? Login
First name
Last name
Email
Phone
Password
Confirm password
I agree with the Terms & Conditions
Sign up
LOGIN
Login to your account.Don’t have account? Sign up
Email / Phone
Password
Remember me Forgot password?
Login
MessagesTimelineExceptionsViews33RouteQueries113Models84GateSessionRequest
#1 / (12:04:17)8.2.16PHP Version418msRequest Duration36MBMemory UsageGET /Route
* Booting (97.22ms)
* Application (321ms)
* 1 x Application (76.74%)
321.10ms
1 x Booting (23.24%)
97.22ms
33 templates were rendered
* theme-views.home
(resources/themes/theme_aster/theme-views/home.blade.php)23bladefile
Params0
topRated
1
bestSellProduct
2
latest_products
3
featured_products
4
deal_of_the_day
5
top_sellers
6
home_categories
7
main_banner
8
footer_banner
9
random_product
10
decimal_point_settings
11
just_for_you
12
more_seller
13
final_category
14
category_slider
15
order_again
16
sidebar_banner
17
main_section_banner
18
random_coupon
19
top_side_banner
20
featured_deals
21
flash_deals
22
categories
* theme-views.partials._main-banner
(resources/themes/theme_aster/theme-views/partials/_main-banner.blade.php)28bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
* theme-views.partials._find-what-you-need
(resources/themes/theme_aster/theme-views/partials/_find-what-you-need.blade.php)28bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
* theme-views.partials._recommended-product
(resources/themes/theme_aster/theme-views/partials/_recommended-product.blade.php)28bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
* theme-views.partials._product-large-card
(resources/themes/theme_aster/theme-views/partials/_product-large-card.blade.php)32bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
28
__currentLoopData
29
loop
30
order
31
product
* theme-views.partials._product-large-card
(resources/themes/theme_aster/theme-views/partials/_product-large-card.blade.php)32bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
28
__currentLoopData
29
loop
30
order
31
product
* theme-views.partials._product-large-card
(resources/themes/theme_aster/theme-views/partials/_product-large-card.blade.php)32bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
28
__currentLoopData
29
product
30
loop
31
order
* theme-views.partials._product-large-card
(resources/themes/theme_aster/theme-views/partials/_product-large-card.blade.php)32bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
28
__currentLoopData
29
product
30
loop
31
order
* theme-views.partials._product-large-card
(resources/themes/theme_aster/theme-views/partials/_product-large-card.blade.php)32bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
28
__currentLoopData
29
product
30
loop
31
order
* theme-views.partials._product-large-card
(resources/themes/theme_aster/theme-views/partials/_product-large-card.blade.php)32bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
28
__currentLoopData
29
product
30
loop
31
order
* theme-views.partials._top-rated-products
(resources/themes/theme_aster/theme-views/partials/_top-rated-products.blade.php)28bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
* theme-views.partials._product-large-card
(resources/themes/theme_aster/theme-views/partials/_product-large-card.blade.php)32bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
28
__currentLoopData
29
product
30
key
31
loop
* theme-views.partials._product-large-card
(resources/themes/theme_aster/theme-views/partials/_product-large-card.blade.php)32bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
28
__currentLoopData
29
product
30
key
31
loop
* theme-views.partials._best-deal-just-for-you
(resources/themes/theme_aster/theme-views/partials/_best-deal-just-for-you.blade.php)28bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
* theme-views.partials._home-categories
(resources/themes/theme_aster/theme-views/partials/_home-categories.blade.php)28bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
* theme-views.partials._product-category-card
(resources/themes/theme_aster/theme-views/partials/_product-category-card.blade.php)33bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
28
__currentLoopData
29
category
30
loop
31
product
32
key
* theme-views.partials._product-category-card
(resources/themes/theme_aster/theme-views/partials/_product-category-card.blade.php)33bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
28
__currentLoopData
29
category
30
loop
31
product
32
key
* theme-views.partials._product-category-card
(resources/themes/theme_aster/theme-views/partials/_product-category-card.blade.php)33bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
28
__currentLoopData
29
category
30
loop
31
product
32
key
* theme-views.partials._product-category-card
(resources/themes/theme_aster/theme-views/partials/_product-category-card.blade.php)33bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
28
__currentLoopData
29
category
30
loop
31
product
32
key
* theme-views.layouts.app
(resources/themes/theme_aster/theme-views/layouts/app.blade.php)28bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
* theme-views.layouts.partials._header
(resources/themes/theme_aster/theme-views/layouts/partials/_header.blade.php)30bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
28
google_tag_manager_id
29
pixel_analytices_user_code
* theme-views.layouts.partials._cart
(resources/themes/theme_aster/theme-views/layouts/partials/_cart.blade.php)40bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
28
google_tag_manager_id
29
pixel_analytices_user_code
30
brands
31
__currentLoopData
32
key
33
loop
34
local
35
data
36
category
37
subCategory
38
subSubCategory
39
brand
* theme-views.layouts.partials._settings-sidebar
(resources/themes/theme_aster/theme-views/layouts/partials/_settings-sidebar.blade.php)30bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
28
google_tag_manager_id
29
pixel_analytices_user_code
* theme-views.layouts.partials._feature
(resources/themes/theme_aster/theme-views/layouts/partials/_feature.blade.php)30bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
28
google_tag_manager_id
29
pixel_analytices_user_code
* theme-views.layouts.partials._footer
(resources/themes/theme_aster/theme-views/layouts/partials/_footer.blade.php)30bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
28
google_tag_manager_id
29
pixel_analytices_user_code
* theme-views.layouts.partials._app-bar
(resources/themes/theme_aster/theme-views/layouts/partials/_app-bar.blade.php)30bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
28
google_tag_manager_id
29
pixel_analytices_user_code
* theme-views.layouts.partials.modal._register
(resources/themes/theme_aster/theme-views/layouts/partials/modal/_register.blade.php)31bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
28
google_tag_manager_id
29
pixel_analytices_user_code
30
cookie
* theme-views.layouts.partials.modal._login
(resources/themes/theme_aster/theme-views/layouts/partials/modal/_login.blade.php)31bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
28
google_tag_manager_id
29
pixel_analytices_user_code
30
cookie
* theme-views.layouts.partials.modal._quick-view
(resources/themes/theme_aster/theme-views/layouts/partials/modal/_quick-view.blade.php)31bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
28
google_tag_manager_id
29
pixel_analytices_user_code
30
cookie
* theme-views.layouts.partials.modal._initial
(resources/themes/theme_aster/theme-views/layouts/partials/modal/_initial.blade.php)31bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
28
google_tag_manager_id
29
pixel_analytices_user_code
30
cookie
* theme-views.layouts.partials._translate-text-for-js
(resources/themes/theme_aster/theme-views/layouts/partials/_translate-text-for-js.blade.php)32bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
28
google_tag_manager_id
29
pixel_analytices_user_code
30
cookie
31
whatsapp
* theme-views.layouts.partials._route-for-js
(resources/themes/theme_aster/theme-views/layouts/partials/_route-for-js.blade.php)32bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
28
google_tag_manager_id
29
pixel_analytices_user_code
30
cookie
31
whatsapp
* theme-views.layouts.main-script
(resources/themes/theme_aster/theme-views/layouts/main-script.blade.php)32bladefile
Params0
__env
1
app
2
web_config
3
language
4
errors
5
topRated
6
bestSellProduct
7
latest_products
8
featured_products
9
deal_of_the_day
10
top_sellers
11
home_categories
12
main_banner
13
footer_banner
14
random_product
15
decimal_point_settings
16
just_for_you
17
more_seller
18
final_category
19
category_slider
20
order_again
21
sidebar_banner
22
main_section_banner
23
random_coupon
24
top_side_banner
25
featured_deals
26
flash_deals
27
categories
28
google_tag_manager_id
29
pixel_analytices_user_code
30
cookie
31
whatsapp
uriGET /middlewareweb, maintenance_mode,
guestCheckcontrollerApp\Http\Controllers\Web\HomeController@indexnamespaceApp\Http\Controllers\Webprefixwhereashomefileapp/Http/Controllers/Web/HomeController.php:43-53
113 statements were executed, 61 of which were duplicated, 52 unique. Show only
duplicated15.68ms
adboonclick_newapp
* select * from `business_settings` where (`type` = 'maintenance_mode') limit 1
140μs/app/Utils/helpers.php:167adboonclick_newapp
MetadataBindings
* 0. maintenance_mode
Backtrace
* 16. /app/Utils/helpers.php:167
* 17. middleware::maintenance_mode:19
* 18. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180
* 19. middleware::api_lang:22
* 20. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180
* insert into `guest_users` (`ip_address`, `created_at`) values
('172.70.82.54', '2024-03-20 12:04:17')
140μsmiddleware::guestCheck:23adboonclick_newapp
MetadataBindings
* 0. 172.70.82.54
* 1. 2024-03-20 12:04:17
Backtrace
* 16. middleware::guestCheck:23
* 17. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180
* 18. middleware::maintenance_mode:23
* 19. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:180
* 20. middleware::api_lang:22
* select * from `categories` where `home_status` = 1 order by `priority` asc
110μs/app/Http/Controllers/Web/HomeController.php:152adboonclick_newapp
MetadataBindings
* 0. 1
Backtrace
* 15. /app/Http/Controllers/Web/HomeController.php:152
* 16. /app/Http/Controllers/Web/HomeController.php:49
* 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `translations` where `translations`.`translationable_id` in (2,
5, 8) and `translations`.`translationable_type` = 'App\Models\Category' and
`locale` = 'en'
120μs/app/Http/Controllers/Web/HomeController.php:152adboonclick_newapp
MetadataBindings
* 0. App\Models\Category
* 1. en
Backtrace
* 20. /app/Http/Controllers/Web/HomeController.php:152
* 21. /app/Http/Controllers/Web/HomeController.php:49
* 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `business_settings` where (`type` = 'business_mode') limit 1
110μs/app/Utils/settings.php:15adboonclick_newapp
MetadataBindings
* 0. business_mode
Backtrace
* 16. /app/Utils/settings.php:15
* 26. /app/Http/Controllers/Web/HomeController.php:156
* 29. /vendor/laravel/framework/src/Illuminate/Collections/Collection.php:777
* 31. /app/Http/Controllers/Web/HomeController.php:154
* 32. /app/Http/Controllers/Web/HomeController.php:49
* select `products`.*, (select count(*) from `reviews` where `products`.`id` =
`reviews`.`product_id` and `delivery_man_id` is null 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) or (`brand_id`
is null and `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 ('digital',
'physical') and `category_id` = 2 order by RAND() limit 12
500μs/app/Http/Controllers/Web/HomeController.php:167adboonclick_newapp
MetadataBindings
* 0. 1
* 1. admin
* 2. 1
* 3. 1
* 4. 1
* 5. 1
* 6. approved
* 7. admin
* 8. 1
* 9. digital
* 10. physical
* 11. 2
Backtrace
* 15. /app/Http/Controllers/Web/HomeController.php:167
* 18. /vendor/laravel/framework/src/Illuminate/Collections/Collection.php:777
* 20. /app/Http/Controllers/Web/HomeController.php:154
* 21. /app/Http/Controllers/Web/HomeController.php:49
* 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* select * from `flash_deal_products` where `flash_deal_products`.`product_id`
in (1, 2, 4)
100μs/app/Http/Controllers/Web/HomeController.php:167adboonclick_newapp
MetadataBacktrace
* 20. /app/Http/Controllers/Web/HomeController.php:167
* 23. /vendor/laravel/framework/src/Illuminate/Collections/Collection.php:777
* 25. /app/Http/Controllers/Web/HomeController.php:154
* 26. /app/Http/Controllers/Web/HomeController.php:49
* 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* select * from `wishlists` where `wishlists`.`product_id` in (1, 2, 4) and
`customer_id` = 0
90μs/app/Http/Controllers/Web/HomeController.php:167adboonclick_newapp
MetadataBindings
* 0. 0
Backtrace
* 20. /app/Http/Controllers/Web/HomeController.php:167
* 23. /vendor/laravel/framework/src/Illuminate/Collections/Collection.php:777
* 25. /app/Http/Controllers/Web/HomeController.php:154
* 26. /app/Http/Controllers/Web/HomeController.php:49
* 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* select * from `product_compares` where `product_compares`.`product_id` in (1,
2, 4) and `user_id` = 0
90μs/app/Http/Controllers/Web/HomeController.php:167adboonclick_newapp
MetadataBindings
* 0. 0
Backtrace
* 20. /app/Http/Controllers/Web/HomeController.php:167
* 23. /vendor/laravel/framework/src/Illuminate/Collections/Collection.php:777
* 25. /app/Http/Controllers/Web/HomeController.php:154
* 26. /app/Http/Controllers/Web/HomeController.php:49
* 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* select * from `translations` where `translations`.`translationable_id` in (1,
2, 4) and `translations`.`translationable_type` = 'App\Models\Product' and
`locale` = 'en'
110μs/app/Http/Controllers/Web/HomeController.php:167adboonclick_newapp
MetadataBindings
* 0. App\Models\Product
* 1. en
Backtrace
* 20. /app/Http/Controllers/Web/HomeController.php:167
* 23. /vendor/laravel/framework/src/Illuminate/Collections/Collection.php:777
* 25. /app/Http/Controllers/Web/HomeController.php:154
* 26. /app/Http/Controllers/Web/HomeController.php:49
* 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* select * from `reviews` where `reviews`.`product_id` in (1, 2, 4) and
`delivery_man_id` is null and `status` = 1
90μs/app/Http/Controllers/Web/HomeController.php:167adboonclick_newapp
MetadataBindings
* 0. 1
Backtrace
* 20. /app/Http/Controllers/Web/HomeController.php:167
* 23. /vendor/laravel/framework/src/Illuminate/Collections/Collection.php:777
* 25. /app/Http/Controllers/Web/HomeController.php:154
* 26. /app/Http/Controllers/Web/HomeController.php:49
* 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* select * from `flash_deals` where `flash_deals`.`id` = 2 and (`deal_type` =
'flash_deal' and `status` = 1) limit 1
110μs/app/Http/Controllers/Web/HomeController.php:173adboonclick_newapp
MetadataBindings
* 0. 2
* 1. flash_deal
* 2. 1
Backtrace
* 21. /app/Http/Controllers/Web/HomeController.php:173
* 24. /vendor/laravel/framework/src/Illuminate/Collections/Collection.php:777
* 26. /app/Http/Controllers/Web/HomeController.php:170
* 29. /vendor/laravel/framework/src/Illuminate/Collections/Collection.php:777
* 31. /app/Http/Controllers/Web/HomeController.php:154
* select * from `business_settings` where (`type` = 'business_mode') limit 1
100μs/app/Utils/settings.php:15adboonclick_newapp
MetadataBindings
* 0. business_mode
Backtrace
* 16. /app/Utils/settings.php:15
* 26. /app/Http/Controllers/Web/HomeController.php:156
* 29. /vendor/laravel/framework/src/Illuminate/Collections/Collection.php:777
* 31. /app/Http/Controllers/Web/HomeController.php:154
* 32. /app/Http/Controllers/Web/HomeController.php:49
* select `products`.*, (select count(*) from `reviews` where `products`.`id` =
`reviews`.`product_id` and `delivery_man_id` is null 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) or (`brand_id`
is null and `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 ('digital',
'physical') and `category_id` = 5 order by RAND() limit 12
400μs/app/Http/Controllers/Web/HomeController.php:167adboonclick_newapp
MetadataBindings
* 0. 1
* 1. admin
* 2. 1
* 3. 1
* 4. 1
* 5. 1
* 6. approved
* 7. admin
* 8. 1
* 9. digital
* 10. physical
* 11. 5
Backtrace
* 15. /app/Http/Controllers/Web/HomeController.php:167
* 18. /vendor/laravel/framework/src/Illuminate/Collections/Collection.php:777
* 20. /app/Http/Controllers/Web/HomeController.php:154
* 21. /app/Http/Controllers/Web/HomeController.php:49
* 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* select * from `business_settings` where (`type` = 'business_mode') limit 1
120μs/app/Utils/settings.php:15adboonclick_newapp
MetadataBindings
* 0. business_mode
Backtrace
* 16. /app/Utils/settings.php:15
* 26. /app/Http/Controllers/Web/HomeController.php:156
* 29. /vendor/laravel/framework/src/Illuminate/Collections/Collection.php:777
* 31. /app/Http/Controllers/Web/HomeController.php:154
* 32. /app/Http/Controllers/Web/HomeController.php:49
* select `products`.*, (select count(*) from `reviews` where `products`.`id` =
`reviews`.`product_id` and `delivery_man_id` is null 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) or (`brand_id`
is null and `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 ('digital',
'physical') and `category_id` = 8 order by RAND() limit 12
420μs/app/Http/Controllers/Web/HomeController.php:167adboonclick_newapp
MetadataBindings
* 0. 1
* 1. admin
* 2. 1
* 3. 1
* 4. 1
* 5. 1
* 6. approved
* 7. admin
* 8. 1
* 9. digital
* 10. physical
* 11. 8
Backtrace
* 15. /app/Http/Controllers/Web/HomeController.php:167
* 18. /vendor/laravel/framework/src/Illuminate/Collections/Collection.php:777
* 20. /app/Http/Controllers/Web/HomeController.php:154
* 21. /app/Http/Controllers/Web/HomeController.php:49
* 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* select * from `flash_deal_products` where `flash_deal_products`.`product_id`
in (6)
90μs/app/Http/Controllers/Web/HomeController.php:167adboonclick_newapp
MetadataBacktrace
* 20. /app/Http/Controllers/Web/HomeController.php:167
* 23. /vendor/laravel/framework/src/Illuminate/Collections/Collection.php:777
* 25. /app/Http/Controllers/Web/HomeController.php:154
* 26. /app/Http/Controllers/Web/HomeController.php:49
* 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* select * from `wishlists` where `wishlists`.`product_id` in (6) and
`customer_id` = 0
70μs/app/Http/Controllers/Web/HomeController.php:167adboonclick_newapp
MetadataBindings
* 0. 0
Backtrace
* 20. /app/Http/Controllers/Web/HomeController.php:167
* 23. /vendor/laravel/framework/src/Illuminate/Collections/Collection.php:777
* 25. /app/Http/Controllers/Web/HomeController.php:154
* 26. /app/Http/Controllers/Web/HomeController.php:49
* 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* select * from `product_compares` where `product_compares`.`product_id` in (6)
and `user_id` = 0
70μs/app/Http/Controllers/Web/HomeController.php:167adboonclick_newapp
MetadataBindings
* 0. 0
Backtrace
* 20. /app/Http/Controllers/Web/HomeController.php:167
* 23. /vendor/laravel/framework/src/Illuminate/Collections/Collection.php:777
* 25. /app/Http/Controllers/Web/HomeController.php:154
* 26. /app/Http/Controllers/Web/HomeController.php:49
* 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* select * from `translations` where `translations`.`translationable_id` in (6)
and `translations`.`translationable_type` = 'App\Models\Product' and `locale`
= 'en'
100μs/app/Http/Controllers/Web/HomeController.php:167adboonclick_newapp
MetadataBindings
* 0. App\Models\Product
* 1. en
Backtrace
* 20. /app/Http/Controllers/Web/HomeController.php:167
* 23. /vendor/laravel/framework/src/Illuminate/Collections/Collection.php:777
* 25. /app/Http/Controllers/Web/HomeController.php:154
* 26. /app/Http/Controllers/Web/HomeController.php:49
* 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* select * from `reviews` where `reviews`.`product_id` in (6) and
`delivery_man_id` is null and `status` = 1
90μs/app/Http/Controllers/Web/HomeController.php:167adboonclick_newapp
MetadataBindings
* 0. 1
Backtrace
* 20. /app/Http/Controllers/Web/HomeController.php:167
* 23. /vendor/laravel/framework/src/Illuminate/Collections/Collection.php:777
* 25. /app/Http/Controllers/Web/HomeController.php:154
* 26. /app/Http/Controllers/Web/HomeController.php:49
* 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* select * from `flash_deals` where `flash_deals`.`id` = 1 and (`deal_type` =
'flash_deal' and `status` = 1) limit 1
110μs/app/Http/Controllers/Web/HomeController.php:173adboonclick_newapp
MetadataBindings
* 0. 1
* 1. flash_deal
* 2. 1
Backtrace
* 21. /app/Http/Controllers/Web/HomeController.php:173
* 24. /vendor/laravel/framework/src/Illuminate/Collections/Collection.php:777
* 26. /app/Http/Controllers/Web/HomeController.php:170
* 29. /vendor/laravel/framework/src/Illuminate/Collections/Collection.php:777
* 31. /app/Http/Controllers/Web/HomeController.php:154
* select * from `translations` where `translations`.`translationable_id` in (1)
and `translations`.`translationable_type` = 'App\Models\FlashDeal' and
`locale` = 'en'
100μs/app/Http/Controllers/Web/HomeController.php:173adboonclick_newapp
MetadataBindings
* 0. App\Models\FlashDeal
* 1. en
Backtrace
* 26. /app/Http/Controllers/Web/HomeController.php:173
* 29. /vendor/laravel/framework/src/Illuminate/Collections/Collection.php:777
* 31. /app/Http/Controllers/Web/HomeController.php:170
* 34. /vendor/laravel/framework/src/Illuminate/Collections/Collection.php:777
* 36. /app/Http/Controllers/Web/HomeController.php:154
* select * from `business_settings` where (`type` = 'business_mode') limit 1
110μs/app/Utils/settings.php:15adboonclick_newapp
MetadataBindings
* 0. business_mode
Backtrace
* 16. /app/Utils/settings.php:15
* 23. /app/Http/Controllers/Web/HomeController.php:190
* 27. /app/Http/Controllers/Web/HomeController.php:189
* 28. /app/Http/Controllers/Web/HomeController.php:49
* 29. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* select * from `business_settings` where (`type` = 'business_mode') limit 1
100μs/app/Utils/settings.php:15adboonclick_newapp
MetadataBindings
* 0. business_mode
Backtrace
* 16. /app/Utils/settings.php:15
* 23. /app/Http/Controllers/Web/HomeController.php:193
* 28. /app/Http/Controllers/Web/HomeController.php:192
* 29. /app/Http/Controllers/Web/HomeController.php:49
* 30. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* select `sellers`.*, (select count(*) from `products` where (`sellers`.`id` =
`products`.`user_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) or (`brand_id` is null and `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 ('digital', 'physical') and (`added_by`
= 'seller')) as `product_count`, (select count(*) from `orders` where
`sellers`.`id` = `orders`.`seller_id`) as `orders_count` from `sellers` where
(`status` = 'approved') and exists (select *, (select count(*) from `reviews`
where `products`.`id` = `reviews`.`product_id` and `delivery_man_id` is null
and `status` = 1) as `reviews_count` from `products` where (`sellers`.`id` =
`products`.`user_id` and `added_by` = 'seller' 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) or
(`brand_id` is null and `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 ('digital',
'physical') and (`added_by` = 'seller')) order by `orders_count` desc limit
12
460μs/app/Http/Controllers/Web/HomeController.php:195adboonclick_newapp
MetadataBindings
* 0. admin
* 1. 1
* 2. 1
* 3. 1
* 4. 1
* 5. approved
* 6. admin
* 7. 1
* 8. digital
* 9. physical
* 10. seller
* 11. approved
* 12. 1
* 13. seller
* 14. admin
* 15. 1
* 16. 1
* 17. 1
* 18. 1
* 19. approved
* 20. admin
* 21. 1
* 22. digital
* 23. physical
* 24. seller
Backtrace
* 15. /app/Http/Controllers/Web/HomeController.php:195
* 16. /app/Http/Controllers/Web/HomeController.php:49
* 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `flash_deals` where (`deal_type` = 'flash_deal' and `status` =
1) and date(`start_date`) <= '2024-03-20' and date(`end_date`) >=
'2024-03-20' limit 1
120μs/app/Http/Controllers/Web/HomeController.php:230adboonclick_newapp
MetadataBindings
* 0. flash_deal
* 1. 1
* 2. 2024-03-20
* 3. 2024-03-20
Backtrace
* 16. /app/Http/Controllers/Web/HomeController.php:230
* 17. /app/Http/Controllers/Web/HomeController.php:49
* 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `categories` where `parent_id` = 0
80μs/app/Http/Controllers/Web/HomeController.php:242adboonclick_newapp
MetadataBindings
* 0. 0
Backtrace
* 15. /app/Http/Controllers/Web/HomeController.php:242
* 16. /app/Http/Controllers/Web/HomeController.php:49
* 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `categories` where `categories`.`parent_id` in (2, 5, 8) order
by `priority` asc
90μs/app/Http/Controllers/Web/HomeController.php:242adboonclick_newapp
MetadataBacktrace
* 20. /app/Http/Controllers/Web/HomeController.php:242
* 21. /app/Http/Controllers/Web/HomeController.php:49
* 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `business_settings` where (`type` = 'business_mode') limit 1
110μs/app/Utils/settings.php:15adboonclick_newapp
MetadataBindings
* 0. business_mode
Backtrace
* 16. /app/Utils/settings.php:15
* 26. /app/Http/Controllers/Web/HomeController.php:236
* 36. /app/Http/Controllers/Web/HomeController.php:242
* 37. /app/Http/Controllers/Web/HomeController.php:49
* 38. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* select `products`.*, (select count(*) from `reviews` where `products`.`id` =
`reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as
`reviews_count` from `products` where (`products`.`sub_category_id` in (3, 6,
7) 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) or (`brand_id` is null and `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 ('digital', 'physical')
310μs/app/Http/Controllers/Web/HomeController.php:242adboonclick_newapp
MetadataBindings
* 0. 1
* 1. admin
* 2. 1
* 3. 1
* 4. 1
* 5. 1
* 6. approved
* 7. admin
* 8. 1
* 9. digital
* 10. physical
Backtrace
* 25. /app/Http/Controllers/Web/HomeController.php:242
* 26. /app/Http/Controllers/Web/HomeController.php:49
* 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `translations` where `translations`.`translationable_id` in (1,
2, 4) and `translations`.`translationable_type` = 'App\Models\Product' and
`locale` = 'en'
120μs/app/Http/Controllers/Web/HomeController.php:242adboonclick_newapp
MetadataBindings
* 0. App\Models\Product
* 1. en
Backtrace
* 30. /app/Http/Controllers/Web/HomeController.php:242
* 31. /app/Http/Controllers/Web/HomeController.php:49
* 32. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 33. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 34. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `reviews` where `reviews`.`product_id` in (1, 2, 4) and
`delivery_man_id` is null and `status` = 1
90μs/app/Http/Controllers/Web/HomeController.php:242adboonclick_newapp
MetadataBindings
* 0. 1
Backtrace
* 30. /app/Http/Controllers/Web/HomeController.php:242
* 31. /app/Http/Controllers/Web/HomeController.php:49
* 32. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 33. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 34. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `translations` where `translations`.`translationable_id` in (3,
6, 7) and `translations`.`translationable_type` = 'App\Models\Category' and
`locale` = 'en'
100μs/app/Http/Controllers/Web/HomeController.php:242adboonclick_newapp
MetadataBindings
* 0. App\Models\Category
* 1. en
Backtrace
* 25. /app/Http/Controllers/Web/HomeController.php:242
* 26. /app/Http/Controllers/Web/HomeController.php:49
* 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `business_settings` where (`type` = 'business_mode') limit 1
100μs/app/Utils/settings.php:15adboonclick_newapp
MetadataBindings
* 0. business_mode
Backtrace
* 16. /app/Utils/settings.php:15
* 26. /app/Http/Controllers/Web/HomeController.php:240
* 31. /app/Http/Controllers/Web/HomeController.php:242
* 32. /app/Http/Controllers/Web/HomeController.php:49
* 33. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* select `products`.*, (select count(*) from `reviews` where `products`.`id` =
`reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as
`reviews_count` from `products` where (`products`.`category_id` in (2, 5, 8)
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) or (`brand_id` is null and `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 ('digital', 'physical')
310μs/app/Http/Controllers/Web/HomeController.php:242adboonclick_newapp
MetadataBindings
* 0. 1
* 1. admin
* 2. 1
* 3. 1
* 4. 1
* 5. 1
* 6. approved
* 7. admin
* 8. 1
* 9. digital
* 10. physical
Backtrace
* 20. /app/Http/Controllers/Web/HomeController.php:242
* 21. /app/Http/Controllers/Web/HomeController.php:49
* 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `translations` where `translations`.`translationable_id` in (1,
2, 4, 6) and `translations`.`translationable_type` = 'App\Models\Product' and
`locale` = 'en'
120μs/app/Http/Controllers/Web/HomeController.php:242adboonclick_newapp
MetadataBindings
* 0. App\Models\Product
* 1. en
Backtrace
* 25. /app/Http/Controllers/Web/HomeController.php:242
* 26. /app/Http/Controllers/Web/HomeController.php:49
* 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `reviews` where `reviews`.`product_id` in (1, 2, 4, 6) and
`delivery_man_id` is null and `status` = 1
90μs/app/Http/Controllers/Web/HomeController.php:242adboonclick_newapp
MetadataBindings
* 0. 1
Backtrace
* 25. /app/Http/Controllers/Web/HomeController.php:242
* 26. /app/Http/Controllers/Web/HomeController.php:49
* 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `translations` where `translations`.`translationable_id` in (2,
5, 8) and `translations`.`translationable_type` = 'App\Models\Category' and
`locale` = 'en'
100μs/app/Http/Controllers/Web/HomeController.php:242adboonclick_newapp
MetadataBindings
* 0. App\Models\Category
* 1. en
Backtrace
* 20. /app/Http/Controllers/Web/HomeController.php:242
* 21. /app/Http/Controllers/Web/HomeController.php:49
* 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `business_settings` where (`type` = 'business_mode') limit 1
120μs/app/Utils/settings.php:15adboonclick_newapp
MetadataBindings
* 0. business_mode
Backtrace
* 16. /app/Utils/settings.php:15
* 23. /app/Http/Controllers/Web/HomeController.php:274
* 28. /app/Http/Controllers/Web/HomeController.php:273
* 29. /app/Http/Controllers/Web/HomeController.php:49
* 30. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* select `sellers`.*, (select count(*) from `products` where (`sellers`.`id` =
`products`.`user_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) or (`brand_id` is null and `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 ('digital', 'physical') and (`added_by`
= 'seller')) as `product_count` from `sellers` where (`status` = 'approved')
order by RAND() limit 7
310μs/app/Http/Controllers/Web/HomeController.php:277adboonclick_newapp
MetadataBindings
* 0. admin
* 1. 1
* 2. 1
* 3. 1
* 4. 1
* 5. approved
* 6. admin
* 7. 1
* 8. digital
* 9. physical
* 10. seller
* 11. approved
Backtrace
* 15. /app/Http/Controllers/Web/HomeController.php:277
* 16. /app/Http/Controllers/Web/HomeController.php:49
* 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `shops` where `shops`.`seller_id` in (1, 2)
110μs/app/Http/Controllers/Web/HomeController.php:277adboonclick_newapp
MetadataBacktrace
* 20. /app/Http/Controllers/Web/HomeController.php:277
* 21. /app/Http/Controllers/Web/HomeController.php:49
* 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select `products`.*, (select count(*) from `reviews` where `products`.`id` =
`reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as
`reviews_count` from `products` where (`added_by` = 'seller') and
`products`.`user_id` in (1, 2)
200μs/app/Http/Controllers/Web/HomeController.php:277adboonclick_newapp
MetadataBindings
* 0. 1
* 1. seller
Backtrace
* 20. /app/Http/Controllers/Web/HomeController.php:277
* 21. /app/Http/Controllers/Web/HomeController.php:49
* 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `reviews` where `reviews`.`product_id` in (5) and
`delivery_man_id` is null and `status` = 1
90μs/app/Http/Controllers/Web/HomeController.php:277adboonclick_newapp
MetadataBindings
* 0. 1
Backtrace
* 25. /app/Http/Controllers/Web/HomeController.php:277
* 26. /app/Http/Controllers/Web/HomeController.php:49
* 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `translations` where `translations`.`translationable_id` in (5)
and `translations`.`translationable_type` = 'App\Models\Product' and `locale`
= 'en'
100μs/app/Http/Controllers/Web/HomeController.php:277adboonclick_newapp
MetadataBindings
* 0. App\Models\Product
* 1. en
Backtrace
* 25. /app/Http/Controllers/Web/HomeController.php:277
* 26. /app/Http/Controllers/Web/HomeController.php:49
* 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `business_settings` where (`type` = 'business_mode') limit 1
110μs/app/Utils/settings.php:15adboonclick_newapp
MetadataBindings
* 0. business_mode
Backtrace
* 16. /app/Utils/settings.php:15
* 25. /app/Http/Controllers/Web/HomeController.php:281
* 26. /app/Http/Controllers/Web/HomeController.php:49
* 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 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 `delivery_man_id` is null 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) or (`brand_id`
is null and `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 ('digital',
'physical') and `featured` = 1 order by `order_details_count` desc limit 10
410μs/app/Http/Controllers/Web/HomeController.php:294adboonclick_newapp
MetadataBindings
* 0. 1
* 1. admin
* 2. 1
* 3. 1
* 4. 1
* 5. 1
* 6. approved
* 7. admin
* 8. 1
* 9. digital
* 10. physical
* 11. 1
Backtrace
* 15. /app/Http/Controllers/Web/HomeController.php:294
* 16. /app/Http/Controllers/Web/HomeController.php:49
* 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `business_settings` where (`type` = 'business_mode') limit 1
120μs/app/Utils/settings.php:15adboonclick_newapp
MetadataBindings
* 0. business_mode
Backtrace
* 16. /app/Utils/settings.php:15
* 23. /app/Http/Controllers/Web/HomeController.php:324
* 24. /app/Http/Controllers/Web/HomeController.php:49
* 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 26. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* select `products`.*, (select count(*) from `reviews` where `products`.`id` =
`reviews`.`product_id` and `delivery_man_id` is null 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) or (`brand_id`
is null and `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 ('digital',
'physical') order by `id` desc limit 10
320μs/app/Http/Controllers/Web/HomeController.php:326adboonclick_newapp
MetadataBindings
* 0. 1
* 1. admin
* 2. 1
* 3. 1
* 4. 1
* 5. 1
* 6. approved
* 7. admin
* 8. 1
* 9. digital
* 10. physical
Backtrace
* 15. /app/Http/Controllers/Web/HomeController.php:326
* 16. /app/Http/Controllers/Web/HomeController.php:49
* 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `sellers` where `sellers`.`id` in (1)
100μs/app/Http/Controllers/Web/HomeController.php:326adboonclick_newapp
MetadataBacktrace
* 20. /app/Http/Controllers/Web/HomeController.php:326
* 21. /app/Http/Controllers/Web/HomeController.php:49
* 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `shops` where `shops`.`seller_id` in (1)
80μs/app/Http/Controllers/Web/HomeController.php:326adboonclick_newapp
MetadataBacktrace
* 25. /app/Http/Controllers/Web/HomeController.php:326
* 26. /app/Http/Controllers/Web/HomeController.php:49
* 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `flash_deal_products` where `flash_deal_products`.`product_id`
in (1, 2, 4, 6)
70μs/app/Http/Controllers/Web/HomeController.php:326adboonclick_newapp
MetadataBacktrace
* 20. /app/Http/Controllers/Web/HomeController.php:326
* 21. /app/Http/Controllers/Web/HomeController.php:49
* 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `flash_deals` where (`deal_type` = 'flash_deal' and `status` =
1) and `flash_deals`.`id` in (1, 2)
110μs/app/Http/Controllers/Web/HomeController.php:326adboonclick_newapp
MetadataBindings
* 0. flash_deal
* 1. 1
Backtrace
* 25. /app/Http/Controllers/Web/HomeController.php:326
* 26. /app/Http/Controllers/Web/HomeController.php:49
* 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `translations` where `translations`.`translationable_id` in (1)
and `translations`.`translationable_type` = 'App\Models\FlashDeal' and
`locale` = 'en'
100μs/app/Http/Controllers/Web/HomeController.php:326adboonclick_newapp
MetadataBindings
* 0. App\Models\FlashDeal
* 1. en
Backtrace
* 30. /app/Http/Controllers/Web/HomeController.php:326
* 31. /app/Http/Controllers/Web/HomeController.php:49
* 32. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 33. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 34. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `wishlists` where `wishlists`.`product_id` in (1, 2, 4, 6) and
`customer_id` = 0
80μs/app/Http/Controllers/Web/HomeController.php:326adboonclick_newapp
MetadataBindings
* 0. 0
Backtrace
* 20. /app/Http/Controllers/Web/HomeController.php:326
* 21. /app/Http/Controllers/Web/HomeController.php:49
* 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `product_compares` where `product_compares`.`product_id` in (1,
2, 4, 6) and `user_id` = 0
90μs/app/Http/Controllers/Web/HomeController.php:326adboonclick_newapp
MetadataBindings
* 0. 0
Backtrace
* 20. /app/Http/Controllers/Web/HomeController.php:326
* 21. /app/Http/Controllers/Web/HomeController.php:49
* 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `translations` where `translations`.`translationable_id` in (1,
2, 4, 6) and `translations`.`translationable_type` = 'App\Models\Product' and
`locale` = 'en'
150μs/app/Http/Controllers/Web/HomeController.php:326adboonclick_newapp
MetadataBindings
* 0. App\Models\Product
* 1. en
Backtrace
* 20. /app/Http/Controllers/Web/HomeController.php:326
* 21. /app/Http/Controllers/Web/HomeController.php:49
* 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `reviews` where `reviews`.`product_id` in (1, 2, 4, 6) and
`delivery_man_id` is null and `status` = 1
100μs/app/Http/Controllers/Web/HomeController.php:326adboonclick_newapp
MetadataBindings
* 0. 1
Backtrace
* 20. /app/Http/Controllers/Web/HomeController.php:326
* 21. /app/Http/Controllers/Web/HomeController.php:49
* 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `business_settings` where (`type` = 'business_mode') limit 1
110μs/app/Utils/settings.php:15adboonclick_newapp
MetadataBindings
* 0. business_mode
Backtrace
* 16. /app/Utils/settings.php:15
* 26. /app/Http/Controllers/Web/HomeController.php:346
* 27. /app/Http/Controllers/Web/HomeController.php:49
* 28. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 29. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* select `products`.*, (select count(*) from `reviews` where `products`.`id` =
`reviews`.`product_id` and `delivery_man_id` is null 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) or (`brand_id`
is null and `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 ('digital',
'physical') and exists (select * from `flash_deal_products` where
`products`.`id` = `flash_deal_products`.`product_id` and exists (select *
from `flash_deals` where `flash_deal_products`.`flash_deal_id` =
`flash_deals`.`id` and date(`start_date`) <= '2024-03-20' and
date(`end_date`) >= '2024-03-20' and (`deal_type` = 'feature_deal' and
`status` = 1)))
380μs/app/Http/Controllers/Web/HomeController.php:365adboonclick_newapp
MetadataBindings
* 0. 1
* 1. admin
* 2. 1
* 3. 1
* 4. 1
* 5. 1
* 6. approved
* 7. admin
* 8. 1
* 9. digital
* 10. physical
* 11. 2024-03-20
* 12. 2024-03-20
* 13. feature_deal
* 14. 1
Backtrace
* 15. /app/Http/Controllers/Web/HomeController.php:365
* 16. /app/Http/Controllers/Web/HomeController.php:49
* 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `business_settings` where (`type` = 'business_mode') limit 1
120μs/app/Utils/settings.php:15adboonclick_newapp
MetadataBindings
* 0. business_mode
Backtrace
* 16. /app/Utils/settings.php:15
* 23. /app/Http/Controllers/Web/HomeController.php:396
* 27. /app/Http/Controllers/Web/HomeController.php:395
* 28. /app/Http/Controllers/Web/HomeController.php:49
* 29. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* select `product_id`, COUNT(product_id) as count from `order_details` where
exists (select *, (select count(*) from `reviews` where `products`.`id` =
`reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as
`reviews_count` from `products` where (`order_details`.`product_id` =
`products`.`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) or (`brand_id` is null and `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 ('digital', 'physical') and `status` = 1) group by
`product_id` order by `count` desc limit 10
340μs/app/Http/Controllers/Web/HomeController.php:402adboonclick_newapp
MetadataBindings
* 0. 1
* 1. admin
* 2. 1
* 3. 1
* 4. 1
* 5. 1
* 6. approved
* 7. admin
* 8. 1
* 9. digital
* 10. physical
* 11. 1
Backtrace
* 15. /app/Http/Controllers/Web/HomeController.php:402
* 16. /app/Http/Controllers/Web/HomeController.php:49
* 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select `products`.*, (select count(*) from `reviews` where `products`.`id` =
`reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as
`reviews_count` from `products` where `status` = 1 and `products`.`id` in (1,
4)
230μs/app/Http/Controllers/Web/HomeController.php:402adboonclick_newapp
MetadataBindings
* 0. 1
* 1. 1
Backtrace
* 20. /app/Http/Controllers/Web/HomeController.php:402
* 21. /app/Http/Controllers/Web/HomeController.php:49
* 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `reviews` where `reviews`.`product_id` in (1, 4) and
`delivery_man_id` is null and `status` = 1
100μs/app/Http/Controllers/Web/HomeController.php:402adboonclick_newapp
MetadataBindings
* 0. 1
Backtrace
* 25. /app/Http/Controllers/Web/HomeController.php:402
* 26. /app/Http/Controllers/Web/HomeController.php:49
* 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `flash_deal_products` where `flash_deal_products`.`product_id`
in (1, 4)
70μs/app/Http/Controllers/Web/HomeController.php:402adboonclick_newapp
MetadataBacktrace
* 25. /app/Http/Controllers/Web/HomeController.php:402
* 26. /app/Http/Controllers/Web/HomeController.php:49
* 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `sellers` where `sellers`.`id` in (1)
90μs/app/Http/Controllers/Web/HomeController.php:402adboonclick_newapp
MetadataBacktrace
* 25. /app/Http/Controllers/Web/HomeController.php:402
* 26. /app/Http/Controllers/Web/HomeController.php:49
* 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `shops` where `shops`.`seller_id` in (1)
70μs/app/Http/Controllers/Web/HomeController.php:402adboonclick_newapp
MetadataBacktrace
* 30. /app/Http/Controllers/Web/HomeController.php:402
* 31. /app/Http/Controllers/Web/HomeController.php:49
* 32. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 33. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 34. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `wishlists` where `wishlists`.`product_id` in (1, 4) and
`customer_id` = 0
70μs/app/Http/Controllers/Web/HomeController.php:402adboonclick_newapp
MetadataBindings
* 0. 0
Backtrace
* 25. /app/Http/Controllers/Web/HomeController.php:402
* 26. /app/Http/Controllers/Web/HomeController.php:49
* 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `product_compares` where `product_compares`.`product_id` in (1,
4) and `user_id` = 0
80μs/app/Http/Controllers/Web/HomeController.php:402adboonclick_newapp
MetadataBindings
* 0. 0
Backtrace
* 25. /app/Http/Controllers/Web/HomeController.php:402
* 26. /app/Http/Controllers/Web/HomeController.php:49
* 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `translations` where `translations`.`translationable_id` in (1,
4) and `translations`.`translationable_type` = 'App\Models\Product' and
`locale` = 'en'
100μs/app/Http/Controllers/Web/HomeController.php:402adboonclick_newapp
MetadataBindings
* 0. App\Models\Product
* 1. en
Backtrace
* 25. /app/Http/Controllers/Web/HomeController.php:402
* 26. /app/Http/Controllers/Web/HomeController.php:49
* 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `business_settings` where (`type` = 'business_mode') limit 1
110μs/app/Utils/settings.php:15adboonclick_newapp
MetadataBindings
* 0. business_mode
Backtrace
* 16. /app/Utils/settings.php:15
* 23. /app/Http/Controllers/Web/HomeController.php:487
* 24. /app/Http/Controllers/Web/HomeController.php:49
* 25. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 26. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* select `products`.*, (select count(*) from `reviews` where `products`.`id` =
`reviews`.`product_id` and `delivery_man_id` is null 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) or (`brand_id`
is null and `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 ('digital',
'physical') order by RAND() limit 8
410μs/app/Http/Controllers/Web/HomeController.php:487adboonclick_newapp
MetadataBindings
* 0. 1
* 1. admin
* 2. 1
* 3. 1
* 4. 1
* 5. 1
* 6. approved
* 7. admin
* 8. 1
* 9. digital
* 10. physical
Backtrace
* 15. /app/Http/Controllers/Web/HomeController.php:487
* 16. /app/Http/Controllers/Web/HomeController.php:49
* 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `wishlists` where `wishlists`.`product_id` in (1, 2, 4, 6) and
`customer_id` = 0
100μs/app/Http/Controllers/Web/HomeController.php:487adboonclick_newapp
MetadataBindings
* 0. 0
Backtrace
* 20. /app/Http/Controllers/Web/HomeController.php:487
* 21. /app/Http/Controllers/Web/HomeController.php:49
* 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `product_compares` where `product_compares`.`product_id` in (1,
2, 4, 6) and `user_id` = 0
80μs/app/Http/Controllers/Web/HomeController.php:487adboonclick_newapp
MetadataBindings
* 0. 0
Backtrace
* 20. /app/Http/Controllers/Web/HomeController.php:487
* 21. /app/Http/Controllers/Web/HomeController.php:49
* 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `translations` where `translations`.`translationable_id` in (1,
2, 4, 6) and `translations`.`translationable_type` = 'App\Models\Product' and
`locale` = 'en'
100μs/app/Http/Controllers/Web/HomeController.php:487adboonclick_newapp
MetadataBindings
* 0. App\Models\Product
* 1. en
Backtrace
* 20. /app/Http/Controllers/Web/HomeController.php:487
* 21. /app/Http/Controllers/Web/HomeController.php:49
* 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `reviews` where `reviews`.`product_id` in (1, 2, 4, 6) and
`delivery_man_id` is null and `status` = 1
90μs/app/Http/Controllers/Web/HomeController.php:487adboonclick_newapp
MetadataBindings
* 0. 1
Backtrace
* 20. /app/Http/Controllers/Web/HomeController.php:487
* 21. /app/Http/Controllers/Web/HomeController.php:49
* 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `business_settings` where (`type` = 'business_mode') limit 1
100μs/app/Utils/settings.php:15adboonclick_newapp
MetadataBindings
* 0. business_mode
Backtrace
* 16. /app/Utils/settings.php:15
* 23. /app/Http/Controllers/Web/HomeController.php:501
* 27. /app/Http/Controllers/Web/HomeController.php:500
* 28. /app/Http/Controllers/Web/HomeController.php:49
* 29. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* select `product_id`, AVG(rating) as count from `reviews` where exists (select
*, (select count(*) from `reviews` where `products`.`id` =
`reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as
`reviews_count` from `products` where (`reviews`.`product_id` =
`products`.`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) or (`brand_id` is null and `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 ('digital', 'physical')) and `status` = 1 group by
`product_id` order by `count` desc limit 10
300μs/app/Http/Controllers/Web/HomeController.php:507adboonclick_newapp
MetadataBindings
* 0. 1
* 1. admin
* 2. 1
* 3. 1
* 4. 1
* 5. 1
* 6. approved
* 7. admin
* 8. 1
* 9. digital
* 10. physical
* 11. 1
Backtrace
* 15. /app/Http/Controllers/Web/HomeController.php:507
* 16. /app/Http/Controllers/Web/HomeController.php:49
* 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* 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
140μs/app/Http/Controllers/Web/HomeController.php:517adboonclick_newapp
MetadataBindings
* 0. 1
* 1. 1
Backtrace
* 16. /app/Http/Controllers/Web/HomeController.php:517
* 17. /app/Http/Controllers/Web/HomeController.php:49
* 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `translations` where `translations`.`translationable_id` in (1)
and `translations`.`translationable_type` = 'App\Models\DealOfTheDay' and
`locale` = 'en'
110μs/app/Http/Controllers/Web/HomeController.php:517adboonclick_newapp
MetadataBindings
* 0. App\Models\DealOfTheDay
* 1. en
Backtrace
* 21. /app/Http/Controllers/Web/HomeController.php:517
* 22. /app/Http/Controllers/Web/HomeController.php:49
* 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `business_settings` where (`type` = 'business_mode') limit 1
110μs/app/Utils/settings.php:15adboonclick_newapp
MetadataBindings
* 0. business_mode
Backtrace
* 16. /app/Utils/settings.php:15
* 25. /app/Http/Controllers/Web/HomeController.php:518
* 26. /app/Http/Controllers/Web/HomeController.php:49
* 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* select `products`.*, (select count(*) from `reviews` where `products`.`id` =
`reviews`.`product_id` and `delivery_man_id` is null 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) or (`brand_id`
is null and `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 ('digital',
'physical') order by RAND() limit 1
370μs/app/Http/Controllers/Web/HomeController.php:518adboonclick_newapp
MetadataBindings
* 0. 1
* 1. admin
* 2. 1
* 3. 1
* 4. 1
* 5. 1
* 6. approved
* 7. admin
* 8. 1
* 9. digital
* 10. physical
Backtrace
* 16. /app/Http/Controllers/Web/HomeController.php:518
* 17. /app/Http/Controllers/Web/HomeController.php:49
* 18. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `translations` where `translations`.`translationable_id` in (6)
and `translations`.`translationable_type` = 'App\Models\Product' and `locale`
= 'en'
120μs/app/Http/Controllers/Web/HomeController.php:518adboonclick_newapp
MetadataBindings
* 0. App\Models\Product
* 1. en
Backtrace
* 21. /app/Http/Controllers/Web/HomeController.php:518
* 22. /app/Http/Controllers/Web/HomeController.php:49
* 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `reviews` where `reviews`.`product_id` in (6) and
`delivery_man_id` is null and `status` = 1
80μs/app/Http/Controllers/Web/HomeController.php:518adboonclick_newapp
MetadataBindings
* 0. 1
Backtrace
* 21. /app/Http/Controllers/Web/HomeController.php:518
* 22. /app/Http/Controllers/Web/HomeController.php:49
* 23. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `banners` where `banner_type` in ('Main Banner', 'Footer
Banner', 'Sidebar Banner', 'Main Section Banner', 'Top Side Banner') and
(`published` = 1 and `theme` = 'theme_aster') order by `id` desc,
`created_at` desc
120μs/app/Http/Controllers/Web/HomeController.php:521adboonclick_newapp
MetadataBindings
* 0. Main Banner
* 1. Footer Banner
* 2. Sidebar Banner
* 3. Main Section Banner
* 4. Top Side Banner
* 5. 1
* 6. theme_aster
Backtrace
* 15. /app/Http/Controllers/Web/HomeController.php:521
* 16. /app/Http/Controllers/Web/HomeController.php:49
* 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `categories` where (`position` = 0) order by `priority` asc
limit 11
90μs/app/Http/Controllers/Web/HomeController.php:549adboonclick_newapp
MetadataBindings
* 0. 0
Backtrace
* 15. /app/Http/Controllers/Web/HomeController.php:549
* 16. /app/Http/Controllers/Web/HomeController.php:49
* 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `categories` where `categories`.`parent_id` in (2, 5, 8) order
by `priority` asc
80μs/app/Http/Controllers/Web/HomeController.php:549adboonclick_newapp
MetadataBacktrace
* 20. /app/Http/Controllers/Web/HomeController.php:549
* 21. /app/Http/Controllers/Web/HomeController.php:49
* 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `categories` where `categories`.`parent_id` in (3, 6, 7) order
by `priority` asc
70μs/app/Http/Controllers/Web/HomeController.php:549adboonclick_newapp
MetadataBacktrace
* 25. /app/Http/Controllers/Web/HomeController.php:549
* 26. /app/Http/Controllers/Web/HomeController.php:49
* 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `translations` where `translations`.`translationable_id` in (4)
and `translations`.`translationable_type` = 'App\Models\Category' and
`locale` = 'en'
100μs/app/Http/Controllers/Web/HomeController.php:549adboonclick_newapp
MetadataBindings
* 0. App\Models\Category
* 1. en
Backtrace
* 30. /app/Http/Controllers/Web/HomeController.php:549
* 31. /app/Http/Controllers/Web/HomeController.php:49
* 32. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 33. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 34. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `translations` where `translations`.`translationable_id` in (3,
6, 7) and `translations`.`translationable_type` = 'App\Models\Category' and
`locale` = 'en'
100μs/app/Http/Controllers/Web/HomeController.php:549adboonclick_newapp
MetadataBindings
* 0. App\Models\Category
* 1. en
Backtrace
* 25. /app/Http/Controllers/Web/HomeController.php:549
* 26. /app/Http/Controllers/Web/HomeController.php:49
* 27. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 28. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 29. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `translations` where `translations`.`translationable_id` in (2,
5, 8) and `translations`.`translationable_type` = 'App\Models\Category' and
`locale` = 'en'
90μs/app/Http/Controllers/Web/HomeController.php:549adboonclick_newapp
MetadataBindings
* 0. App\Models\Category
* 1. en
Backtrace
* 20. /app/Http/Controllers/Web/HomeController.php:549
* 21. /app/Http/Controllers/Web/HomeController.php:49
* 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `coupons` where (`status` = 1) and date(`start_date`) <=
'2024-03-20' and date(`expire_date`) >= '2024-03-20' order by RAND() limit 3
140μs/app/Http/Controllers/Web/HomeController.php:560adboonclick_newapp
MetadataBindings
* 0. 1
* 1. 2024-03-20
* 2. 2024-03-20
Backtrace
* 15. /app/Http/Controllers/Web/HomeController.php:560
* 16. /app/Http/Controllers/Web/HomeController.php:49
* 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
* 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
* 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:259
* select * from `business_settings` where (`type` = 'currency_symbol_position')
limit 1
150μs/app/Utils/helpers.php:167adboonclick_newapp
MetadataBindings
* 0. currency_symbol_position
Backtrace
* 16. /app/Utils/helpers.php:167
* 17. /app/Utils/helpers.php:967
* 18. /app/Utils/helpers.php:393
* 19. view::theme-views.partials._product-large-card:106
* 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
* select `products`.*, (select count(*) from `reviews` where `products`.`id` =
`reviews`.`product_id` and `delivery_man_id` is null and `status` = 1) as
`reviews_count` from `products` where `products`.`id` = 6 limit 1
230μsview::theme-views.partials._best-deal-just-for-you:5adboonclick_newapp
MetadataBindings
* 0. 1
* 1. 6
Backtrace
* 22. view::theme-views.partials._best-deal-just-for-you:5
* 24. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
* 25. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
* 26. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
* 27. /vendor/laravel/framework/src/Illuminate/View/View.php:207
* select * from `translations` where `translations`.`translationable_id` in (6)
and `translations`.`translationable_type` = 'App\Models\Product' and `locale`
= 'en'
120μsview::theme-views.partials._best-deal-just-for-you:5adboonclick_newapp
MetadataBindings
* 0. App\Models\Product
* 1. en
Backtrace
* 27. view::theme-views.partials._best-deal-just-for-you:5
* 29. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
* 30. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
* 31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
* 32. /vendor/laravel/framework/src/Illuminate/View/View.php:207
* select * from `reviews` where `reviews`.`product_id` in (6) and
`delivery_man_id` is null and `status` = 1
90μsview::theme-views.partials._best-deal-just-for-you:5adboonclick_newapp
MetadataBindings
* 0. 1
Backtrace
* 27. view::theme-views.partials._best-deal-just-for-you:5
* 29. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
* 30. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
* 31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
* 32. /vendor/laravel/framework/src/Illuminate/View/View.php:207
* select * from `business_settings` where (`type` = 'google_tag_manager_id')
limit 1
140μs/app/Utils/settings.php:15adboonclick_newapp
MetadataBindings
* 0. google_tag_manager_id
Backtrace
* 16. /app/Utils/settings.php:15
* 19. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
* 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
120μs/app/Utils/settings.php:15adboonclick_newapp
MetadataBindings
* 0. pixel_analytics
Backtrace
* 16. /app/Utils/settings.php:15
* 19. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
* 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` = 'loader_gif') limit 1
120μs/app/Utils/settings.php:15adboonclick_newapp
MetadataBindings
* 0. loader_gif
Backtrace
* 16. /app/Utils/settings.php:15
* 19. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
* 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 `categories` where (`position` = 0) order by `priority` asc
limit 11
100μsview::theme-views.layouts.partials._header:19adboonclick_newapp
MetadataBindings
* 0. 0
Backtrace
* 15. view::theme-views.layouts.partials._header:19
* 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
* 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
* 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
* 20. /vendor/laravel/framework/src/Illuminate/View/View.php:207
* select * from `categories` where `categories`.`parent_id` in (2, 5, 8) order
by `priority` asc
90μsview::theme-views.layouts.partials._header:19adboonclick_newapp
MetadataBacktrace
* 20. view::theme-views.layouts.partials._header:19
* 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
* 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 `categories` where `categories`.`parent_id` in (3, 6, 7) order
by `priority` asc
70μsview::theme-views.layouts.partials._header:19adboonclick_newapp
MetadataBacktrace
* 25. view::theme-views.layouts.partials._header:19
* 27. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
* 28. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
* 29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
* 30. /vendor/laravel/framework/src/Illuminate/View/View.php:207
* select * from `translations` where `translations`.`translationable_id` in (4)
and `translations`.`translationable_type` = 'App\Models\Category' and
`locale` = 'en'
100μsview::theme-views.layouts.partials._header:19adboonclick_newapp
MetadataBindings
* 0. App\Models\Category
* 1. en
Backtrace
* 30. view::theme-views.layouts.partials._header:19
* 32. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
* 33. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
* 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
* 35. /vendor/laravel/framework/src/Illuminate/View/View.php:207
* select * from `translations` where `translations`.`translationable_id` in (3,
6, 7) and `translations`.`translationable_type` = 'App\Models\Category' and
`locale` = 'en'
100μsview::theme-views.layouts.partials._header:19adboonclick_newapp
MetadataBindings
* 0. App\Models\Category
* 1. en
Backtrace
* 25. view::theme-views.layouts.partials._header:19
* 27. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
* 28. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
* 29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
* 30. /vendor/laravel/framework/src/Illuminate/View/View.php:207
* select * from `translations` where `translations`.`translationable_id` in (2,
5, 8) and `translations`.`translationable_type` = 'App\Models\Category' and
`locale` = 'en'
100μsview::theme-views.layouts.partials._header:19adboonclick_newapp
MetadataBindings
* 0. App\Models\Category
* 1. en
Backtrace
* 20. view::theme-views.layouts.partials._header:19
* 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
* 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 `brands` where `status` = 1 limit 15
70μsview::theme-views.layouts.partials._header:20adboonclick_newapp
MetadataBindings
* 0. 1
Backtrace
* 15. view::theme-views.layouts.partials._header:20
* 17. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
* 18. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
* 19. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
* 20. /vendor/laravel/framework/src/Illuminate/View/View.php:207
* select * from `translations` where `translations`.`translationable_id` in (1)
and `translations`.`translationable_type` = 'App\Models\Brand' and `locale` =
'en'
90μsview::theme-views.layouts.partials._header:20adboonclick_newapp
MetadataBindings
* 0. App\Models\Brand
* 1. en
Backtrace
* 20. view::theme-views.layouts.partials._header:20
* 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
* 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 `cart_group_id` from `carts` where (`customer_id` = 283 and `is_guest`
= 1) group by `cart_group_id`
120μs/app/Utils/cart-manager.php:74adboonclick_newapp
MetadataBindings
* 0. 283
* 1. 1
Backtrace
* 14. /app/Utils/cart-manager.php:74
* 15. /app/Utils/cart-manager.php:43
* 16. view::theme-views.layouts.partials._cart:10
* 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
* 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
* select * from `carts` where 0 = 1
80μs/app/Utils/cart-manager.php:43adboonclick_newapp
MetadataBacktrace
* 15. /app/Utils/cart-manager.php:43
* 16. view::theme-views.layouts.partials._cart:10
* 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
* 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
* 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
* select * from `business_settings` where (`type` = 'shop_address') limit 1
110μs/app/Utils/settings.php:15adboonclick_newapp
MetadataBindings
* 0. shop_address
Backtrace
* 16. /app/Utils/settings.php:15
* 19. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
* 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` = 283 and `is_guest`
= 1) group by `cart_group_id`
100μs/app/Utils/cart-manager.php:74adboonclick_newapp
MetadataBindings
* 0. 283
* 1. 1
Backtrace
* 14. /app/Utils/cart-manager.php:74
* 15. /app/Utils/cart-manager.php:43
* 16. view::theme-views.layouts.partials._app-bar:43
* 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
* 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
* select * from `carts` where 0 = 1
70μs/app/Utils/cart-manager.php:43adboonclick_newapp
MetadataBacktrace
* 15. /app/Utils/cart-manager.php:43
* 16. view::theme-views.layouts.partials._app-bar:43
* 18. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
* 19. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
* 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
* select * from `business_settings` where (`type` = 'whatsapp') limit 1
180μs/app/Utils/settings.php:15adboonclick_newapp
MetadataBindings
* 0. whatsapp
Backtrace
* 16. /app/Utils/settings.php:15
* 19. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:125
* 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\Brand1App\Models\Banner1App\Models\DealOfTheDay1App\Models\OrderDetail2App\Models\Shop4App\Models\Seller4App\Models\FlashDeal2App\Models\FlashDealProduct4App\Models\Product24App\Models\BusinessSetting18App\Models\Category23
decimal_point_settings2product_brand1digital_product1currency_modelsingle_currencylanguagearray:2
[ 0 => array:6 [ "id" => "1" "name" => "english" "direction" => "ltr"
"cod...localendirectionltrsystem_default_currency8system_default_currency_infoApp\Models\Currency
{#3528 #connection: "mysql" #table: "currencies" #primaryKey: "id"
#keyT...currency_codeEGPcurrency_symbolEGPcurrency_exchange_rate1_token4fHbLrq4LigFyuNLtMaeHIQTtuOooAWmTcQoKKZeguest_id283currency_symbol_positionleft_previousarray:1
[ "url" => "https://abdo.onclick-eg.com" ]_flasharray:2 [ "old" => [] "new" =>
[] ]PHPDEBUGBAR_STACK_DATA[]
path_info/status_code
200
status_textOKformathtmlcontent_typetext/html; charset=UTF-8request_query
[]
request_request
[]
request_headers
0 of 0 array:22 [▼
"x-https" => array:1 [▶
0 => "1"
]
"cf-connecting-ip" => array:1 [▶
0 => "2001:550:1d05:1::6"
]
"sec-fetch-dest" => array:1 [▶
0 => "document"
]
"sec-fetch-user" => array:1 [▶
0 => "?1"
]
"sec-fetch-mode" => array:1 [▶
0 => "navigate"
]
"sec-fetch-site" => array:1 [▶
0 => "none"
]
"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-language" => array:1 [▶
0 => "en-US,en;q=0.9"
]
"user-agent" => array:1 [▶
0 => "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.6261.128 Safari/537.36"
]
"upgrade-insecure-requests" => array:1 [▶
0 => "1"
]
"cache-control" => array:1 [▶
0 => "no-cache"
]
"pragma" => array:1 [▶
0 => "no-cache"
]
"cf-visitor" => array:1 [▶
0 => "{"scheme":"https"}"
]
"x-forwarded-proto" => array:1 [▶
0 => "https"
]
"cf-ray" => array:1 [▶
0 => "8674e08bfec85c66-MIA"
]
"x-forwarded-for" => array:1 [▶
0 => "2001:550:1d05:1::6"
]
"accept-encoding" => array:1 [▶
0 => "gzip, br"
]
"cf-ipcountry" => array:1 [▶
0 => "US"
]
"cdn-loop" => array:1 [▶
0 => "cloudflare"
]
"x-remote-ip" => array:1 [▶
0 => "172.70.82.54"
]
"x-real-ip" => array:1 [▶
0 => "2001:550:1d05:1::6"
]
"host" => array:1 [▶
0 => "abdo.onclick-eg.com"
]
]
request_server
0 of 0 array:55 [▼
"USER" => "adboonclick"
"HOME" => "/home/adboonclick"
"SCRIPT_NAME" => "/index.php"
"REQUEST_URI" => "/"
"QUERY_STRING" => ""
"REQUEST_METHOD" => "GET"
"SERVER_PROTOCOL" => "HTTP/1.1"
"GATEWAY_INTERFACE" => "CGI/1.1"
"REMOTE_PORT" => "48884"
"SCRIPT_FILENAME" => "/home/adboonclick/public_html/index.php"
"SERVER_ADMIN" => "webmaster@abdo.onclick-eg.com"
"CONTEXT_DOCUMENT_ROOT" => "/home/adboonclick/public_html"
"CONTEXT_PREFIX" => ""
"REQUEST_SCHEME" => "https"
"DOCUMENT_ROOT" => "/home/adboonclick/public_html"
"REMOTE_ADDR" => "172.70.82.54"
"SERVER_PORT" => "443"
"SERVER_ADDR" => "192.168.8.3"
"SERVER_NAME" => "abdo.onclick-eg.com"
"SERVER_SOFTWARE" => "Apache"
"SERVER_SIGNATURE" => ""
"PATH" => "/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bin:/root/bin:/opt/bin ◀/usr/local/jdk/bin:/usr/kerberos/sbin:/usr/kerberos/bin:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/usr/X11R6/bin:/usr/local/bin:/usr/X11R6/bi ▶"
"HTTP_X_HTTPS" => "1"
"HTTP_CF_CONNECTING_IP" => "2001:550:1d05:1::6"
"HTTP_SEC_FETCH_DEST" => "document"
"HTTP_SEC_FETCH_USER" => "?1"
"HTTP_SEC_FETCH_MODE" => "navigate"
"HTTP_SEC_FETCH_SITE" => "none"
"HTTP_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"
"HTTP_ACCEPT_LANGUAGE" => "en-US,en;q=0.9"
"HTTP_USER_AGENT" => "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.6261.128 Safari/537.36"
"HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
"HTTP_CACHE_CONTROL" => "no-cache"
"HTTP_PRAGMA" => "no-cache"
"HTTP_CF_VISITOR" => "{"scheme":"https"}"
"HTTP_X_FORWARDED_PROTO" => "https"
"HTTP_CF_RAY" => "8674e08bfec85c66-MIA"
"HTTP_X_FORWARDED_FOR" => "2001:550:1d05:1::6"
"HTTP_ACCEPT_ENCODING" => "gzip, br"
"HTTP_CF_IPCOUNTRY" => "US"
"HTTP_CDN_LOOP" => "cloudflare"
"HTTP_X_REMOTE_IP" => "172.70.82.54"
"HTTP_X_REAL_IP" => "2001:550:1d05:1::6"
"HTTP_HOST" => "abdo.onclick-eg.com"
"proxy-nokeepalive" => "1"
"HTTPS" => "on"
"SCRIPT_URI" => "https://abdo.onclick-eg.com/"
"SCRIPT_URL" => "/"
"UNIQUE_ID" => "Zfq0oTML52sEWtIUzcfO6wAAAAI"
"FCGI_ROLE" => "RESPONDER"
"PHP_SELF" => "/index.php"
"REQUEST_TIME_FLOAT" => 1710929057.4973
"REQUEST_TIME" => 1710929057
"argv" => []
"argc" => 0
]
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, 20 Mar 2024 10:04:17 GMT"
]
"set-cookie" => array:3 [▶
0 => "XSRF-TOKEN=eyJpdiI6InNnTi80VUhjditlZHpMRjJ1VTg3cWc9PSIsInZhbHVlIjoib1ZFZ0cwbnhKWllqeml2d2d0dE9BVkZaVDQ2cC81OWpBTmdaOTVNNUdHbFk0VlRma1RNNll6NzZIUm9Yb005MHlXN2pmWnhHQ2p1RXhpbEpyTmkyY0tLVnFNRmVXazIwYmRoc29jQmpucFRGSmMrV1JTVEZlWnMyd0hMa3ltb0EiLCJtYWMiOiJhNDljNTJlYzVlMmEyMDcwM2UzZWI1NGI2YzBmMGNmY2JkN2QxYjlhNjA1NzEyMDM4YTJjZGZkNDMyMzZlNjdiIiwidGFnIjoiIn0%3D; expires=Wed, 20 Mar 2024 11:04:17 GMT; Max-Age=3600; path=/ ◀XSRF-TOKEN=eyJpdiI6InNnTi80VUhjditlZHpMRjJ1VTg3cWc9PSIsInZhbHVlIjoib1ZFZ0cwbnhKWllqeml2d2d0dE9BVkZaVDQ2cC81OWpBTmdaOTVNNUdHbFk0VlRma1RNNll6NzZIUm9Yb005MHlXN2pmW ▶"
1 => "6valley1707390361_session=eyJpdiI6InZUbjRRaUV1SllxdkZqQVZtYWxMTFE9PSIsInZhbHVlIjoiK0pTK1RZUUxrc3VHWFIxUVRkTGR3SjFid0FmWk56cXY4RVh4czZIWDhIa2hJWHU4L1lKb3ZaZ0gyWXdVNWhQM3dvelZtSVJZRDAvM24vRnJhZ2Z2dlBFMlFjdy9yK2gxM1RhT1I0YU45NmZlZHFNcW56SmliUU9rQ3N1d2t6M28iLCJtYWMiOiI1NzMzMGI4NWYwNGEzMTVhNTdkNDBlMmQ4YzljNTc5NjJmYWZhNjU2Yjg5NGYzMTA5MGY2OGY4MjMzN2YwMjNiIiwidGFnIjoiIn0%3D; expires=Wed, 20 Mar 2024 11:04:17 GMT; Max-Age=3600; path=/; httponly ◀6valley1707390361_session=eyJpdiI6InZUbjRRaUV1SllxdkZqQVZtYWxMTFE9PSIsInZhbHVlIjoiK0pTK1RZUUxrc3VHWFIxUVRkTGR3SjFid0FmWk56cXY4RVh4czZIWDhIa2hJWHU4L1lKb3ZaZ0gyWX ▶"
2 => "popup_banner=eyJpdiI6Ikg2V2JUSFZOcWpCaUZWYzdxK0RSMXc9PSIsInZhbHVlIjoidUE0Ymt1dmhsbCsrdXNZczZNWis3T1JsWFJrcW5waGdXSWlYaW5GWWREbFVhQVB6NXVpWXlMMlllWm5GcGN5WiIsIm1hYyI6IjEwNGNlMWI0NGQxZDg5MjJjNzgyN2JmMGU0YzlmMjdjNGVkMjEzMGY1OWViYzBmMzc3NDA1ODJlOTliODU4YWEiLCJ0YWciOiIifQ%3D%3D; expires=Wed, 20 Mar 2024 10:05:17 GMT; Max-Age=60; path=/; httponly ◀popup_banner=eyJpdiI6Ikg2V2JUSFZOcWpCaUZWYzdxK0RSMXc9PSIsInZhbHVlIjoidUE0Ymt1dmhsbCsrdXNZczZNWis3T1JsWFJrcW5waGdXSWlYaW5GWWREbFVhQVB6NXVpWXlMMlllWm5GcGN5WiIsIm1 ▶"
]
"Set-Cookie" => array:3 [▶
0 => "XSRF-TOKEN=eyJpdiI6InNnTi80VUhjditlZHpMRjJ1VTg3cWc9PSIsInZhbHVlIjoib1ZFZ0cwbnhKWllqeml2d2d0dE9BVkZaVDQ2cC81OWpBTmdaOTVNNUdHbFk0VlRma1RNNll6NzZIUm9Yb005MHlXN2pmWnhHQ2p1RXhpbEpyTmkyY0tLVnFNRmVXazIwYmRoc29jQmpucFRGSmMrV1JTVEZlWnMyd0hMa3ltb0EiLCJtYWMiOiJhNDljNTJlYzVlMmEyMDcwM2UzZWI1NGI2YzBmMGNmY2JkN2QxYjlhNjA1NzEyMDM4YTJjZGZkNDMyMzZlNjdiIiwidGFnIjoiIn0%3D; expires=Wed, 20-Mar-2024 11:04:17 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InNnTi80VUhjditlZHpMRjJ1VTg3cWc9PSIsInZhbHVlIjoib1ZFZ0cwbnhKWllqeml2d2d0dE9BVkZaVDQ2cC81OWpBTmdaOTVNNUdHbFk0VlRma1RNNll6NzZIUm9Yb005MHlXN2pmW ▶"
1 => "6valley1707390361_session=eyJpdiI6InZUbjRRaUV1SllxdkZqQVZtYWxMTFE9PSIsInZhbHVlIjoiK0pTK1RZUUxrc3VHWFIxUVRkTGR3SjFid0FmWk56cXY4RVh4czZIWDhIa2hJWHU4L1lKb3ZaZ0gyWXdVNWhQM3dvelZtSVJZRDAvM24vRnJhZ2Z2dlBFMlFjdy9yK2gxM1RhT1I0YU45NmZlZHFNcW56SmliUU9rQ3N1d2t6M28iLCJtYWMiOiI1NzMzMGI4NWYwNGEzMTVhNTdkNDBlMmQ4YzljNTc5NjJmYWZhNjU2Yjg5NGYzMTA5MGY2OGY4MjMzN2YwMjNiIiwidGFnIjoiIn0%3D; expires=Wed, 20-Mar-2024 11:04:17 GMT; path=/; httponly ◀6valley1707390361_session=eyJpdiI6InZUbjRRaUV1SllxdkZqQVZtYWxMTFE9PSIsInZhbHVlIjoiK0pTK1RZUUxrc3VHWFIxUVRkTGR3SjFid0FmWk56cXY4RVh4czZIWDhIa2hJWHU4L1lKb3ZaZ0gyWX ▶"
2 => "popup_banner=eyJpdiI6Ikg2V2JUSFZOcWpCaUZWYzdxK0RSMXc9PSIsInZhbHVlIjoidUE0Ymt1dmhsbCsrdXNZczZNWis3T1JsWFJrcW5waGdXSWlYaW5GWWREbFVhQVB6NXVpWXlMMlllWm5GcGN5WiIsIm1hYyI6IjEwNGNlMWI0NGQxZDg5MjJjNzgyN2JmMGU0YzlmMjdjNGVkMjEzMGY1OWViYzBmMzc3NDA1ODJlOTliODU4YWEiLCJ0YWciOiIifQ%3D%3D; expires=Wed, 20-Mar-2024 10:05:17 GMT; path=/; httponly ◀popup_banner=eyJpdiI6Ikg2V2JUSFZOcWpCaUZWYzdxK0RSMXc9PSIsInZhbHVlIjoidUE0Ymt1dmhsbCsrdXNZczZNWis3T1JsWFJrcW5waGdXSWlYaW5GWWREbFVhQVB6NXVpWXlMMlllWm5GcGN5WiIsIm1 ▶"
]
]
session_attributes
0 of 0 array:18 [▼
"decimal_point_settings" => 2
"product_brand" => 1
"digital_product" => 1
"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" => "sa"
"status" => 1
"default" => false
]
]
"local" => "en"
"direction" => "ltr"
"system_default_currency" => 8
"system_default_currency_info" => App\Models\Currency {#3528 ▶
#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" => "EGP"
"exchange_rate" => "1"
"status" => 1
"created_at" => "2024-02-26 12:05:21"
"updated_at" => "2024-02-26 12:42:43"
]
#original: array:8 [▶
"id" => 8
"name" => "EGP"
"symbol" => "EGP"
"code" => "EGP"
"exchange_rate" => "1"
"status" => 1
"created_at" => "2024-02-26 12:05:21"
"updated_at" => "2024-02-26 12:42:43"
]
#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" => "EGP"
"currency_symbol" => "EGP"
"currency_exchange_rate" => "1"
"_token" => "4fHbLrq4LigFyuNLtMaeHIQTtuOooAWmTcQoKKZe"
"guest_id" => 283
"currency_symbol_position" => "left"
"_previous" => array:1 [▶
"url" => "https://abdo.onclick-eg.com"
]
"_flash" => array:2 [▶
"old" => []
"new" => []
]
"PHPDEBUGBAR_STACK_DATA" => []
]
PHP DebugBar | Open
DateMethodURLIPFilter data
Load moreShow only current URLShow allDelete all
Filter results
Method: GETPOSTPUTDELETE
Uri:
IP:
Search