Pepperjam

Name: Pepperjam
Rating: 0 (0 reviews)

0.0

Pepperjam, a Partnerize company, is an affiliate marketing solutions provider, powers growth for affiliates who are seeking to earn more from their content.

Visit Website Request A Site Audit Add Review

Description
Features and Capabilities
Key Facts
Ad Formats
Faqs

Pepperjam Description

Pepperjam, a Partnerize company, is an affiliate marketing solutions provider, powers growth for affiliates who are seeking to earn more from their content.

Pepperjam is partner agnostic and makes lasting connections built on trust. Pepperjam offers various optimization tools with monetization features to access various assets to monetize your campaigns. With actionable attribution, they help maximize earnings or commission potential based on time, position in the click path, code use and mo

Quick Facts

Quick Setup
Multiple Formats
Global Fill Rates

Pepperjam Software Images

Pepperjam Features and Capabilities

Leverages advertiser data to identify and recruit high-quality partners. Their discovery engine allows marketers to leverage their supply side data to custom curate their own private affiliate network.
It provides complete transparency and comprehensive access to your data. From standardized dashboards to integrated fully custom reporting, Ascend provides actionable insights that will help you identify winning strategies and optimize your program’s performance.
It enables you to customize your commission strategy to align with your attribution model with full dynamic, fractional, first, preferred, and last click capabilities and incorporate affiliate into your overall cross-channel efforts.

Pepperjam Review: Ad Formats

Affiliates will have access to various creative assets to monetize their content which includes banners, text links, generic links, coupons, and more.

Pepperjam Review: Key Facts

Pepperjam is an integrated and comprehensive lifecycle platform that gives performance marketers access to category-defining discovery, recruitment, attribution, commission, fraud prevention—and payment capabilities—in a single-stack solution.
It provides access to a variety of creative assets to monetize your campaigns including: banners, text links, generic links, coupons, products and more.
It connects advertisers easily via advertiser mail and profile info.

Want to know more about Pepperjam

Visit Website

Pepperjam Alternatives

ShareASale

View Profile

Awin

View Profile

JVZoo

View Profile Apply Now

Pepperjam FAQs

Some of the brands that are working with Pepperjam are Nordstorm, Puma, Bonobos, Aeropostale, and more.

Pepperjam works with all niches and can find you partnerships to promote.

Partners upload available paid placements for purchase or commission increase. Advertisers can review placements and request the purchase of the placement from the partners.

View Profile Apply Now

Messages Timeline Exceptions Views4 Route Queries136 Models358 Mails Gate Session Request

7.4.33221ms10MBGET software/{slug}

Booting (27.55ms)
Application (193ms)
1 x Application (87.53%)
193ms
1 x Booting (12.47%)
27.55ms

4 templates were rendered

front.softwares.details (resources/views/front/softwares/details.blade.php)59blade


cat_slug
subcategory
feature_cat
pg_review
g2_review
trustradius_reviews
capterra_reviews
avg_google_rating
avg_g2_rating
alternatives_exists
traffic_values
software_images
subcat_details
cat_details
likehood_rating
customer_rating
feature_rating
ease_rating
money_rating
review_list
total_recomm
details_recomm
details_recomm_type
details_request
details
seo_content
overall_rating
details_favourite
total_reviews
alternatives
pagination
details_data
reviewss
survey
instagram
google
pinterest
facebook
linkedin
twitter
blogs
recommended
user_id
total_pg_sum
overall_pg_rating
pg_review_count
review_grade
total_g2_sum
overall_g2_rating
g2_review_count
g2_review_grade
total_capterra_sum
overall_capterra_rating
capterra_review_count
capterra_review_grade
total_trustradius_sum
overall_trustradius_rating
trustradius_review_count
trustradius_review_grade

Params
0	`cat_slug`
1	`subcategory`
2	`feature_cat`
3	`pg_review`
4	`g2_review`
5	`trustradius_reviews`
6	`capterra_reviews`
7	`avg_google_rating`
8	`avg_g2_rating`
9	`alternatives_exists`
10	`traffic_values`
11	`software_images`
12	`subcat_details`
13	`cat_details`
14	`likehood_rating`
15	`customer_rating`
16	`feature_rating`
17	`ease_rating`
18	`money_rating`
19	`review_list`
20	`total_recomm`
21	`details_recomm`
22	`details_recomm_type`
23	`details_request`
24	`details`
25	`seo_content`
26	`overall_rating`
27	`details_favourite`
28	`total_reviews`
29	`alternatives`
30	`pagination`
31	`details_data`
32	`reviewss`
33	`survey`
34	`instagram`
35	`google`
36	`pinterest`
37	`facebook`
38	`linkedin`
39	`twitter`
40	`blogs`
41	`recommended`
42	`user_id`
43	`total_pg_sum`
44	`overall_pg_rating`
45	`pg_review_count`
46	`review_grade`
47	`total_g2_sum`
48	`overall_g2_rating`
49	`g2_review_count`
50	`g2_review_grade`
51	`total_capterra_sum`
52	`overall_capterra_rating`
53	`capterra_review_count`
54	`capterra_review_grade`
55	`total_trustradius_sum`
56	`overall_trustradius_rating`
57	`trustradius_review_count`
58	`trustradius_review_grade`

front.includes.advertisement (resources/views/front/includes/advertisement.blade.php)89blade


__env
app
errors
cat_slug
subcategory
feature_cat
pg_review
g2_review
trustradius_reviews
capterra_reviews
avg_google_rating
avg_g2_rating
alternatives_exists
traffic_values
software_images
subcat_details
cat_details
likehood_rating
customer_rating
feature_rating
ease_rating
money_rating
review_list
total_recomm
details_recomm
details_recomm_type
details_request
details
seo_content
overall_rating
details_favourite
total_reviews
alternatives
pagination
details_data
reviewss
survey
instagram
google
pinterest
facebook
linkedin
twitter
blogs
recommended
user_id
total_pg_sum
overall_pg_rating
pg_review_count
review_grade
total_g2_sum
overall_g2_rating
g2_review_count
g2_review_grade
total_capterra_sum
overall_capterra_rating
capterra_review_count
capterra_review_grade
total_trustradius_sum
overall_trustradius_rating
trustradius_review_count
trustradius_review_grade
__currentLoopData
p
key
loop
others_ratings
othersRatingSum
totalCount
maxRating
customerRatingSums
customerRatingSum
ratingSum
OverallRatingSum
rating
fullStars
halfStar
emptyStars
i
section
index
menu_items
menu_target
row
t
userFavourite
totalOtherRating
b
advertisements

Params
0	`__env`
1	`app`
2	`errors`
3	`cat_slug`
4	`subcategory`
5	`feature_cat`
6	`pg_review`
7	`g2_review`
8	`trustradius_reviews`
9	`capterra_reviews`
10	`avg_google_rating`
11	`avg_g2_rating`
12	`alternatives_exists`
13	`traffic_values`
14	`software_images`
15	`subcat_details`
16	`cat_details`
17	`likehood_rating`
18	`customer_rating`
19	`feature_rating`
20	`ease_rating`
21	`money_rating`
22	`review_list`
23	`total_recomm`
24	`details_recomm`
25	`details_recomm_type`
26	`details_request`
27	`details`
28	`seo_content`
29	`overall_rating`
30	`details_favourite`
31	`total_reviews`
32	`alternatives`
33	`pagination`
34	`details_data`
35	`reviewss`
36	`survey`
37	`instagram`
38	`google`
39	`pinterest`
40	`facebook`
41	`linkedin`
42	`twitter`
43	`blogs`
44	`recommended`
45	`user_id`
46	`total_pg_sum`
47	`overall_pg_rating`
48	`pg_review_count`
49	`review_grade`
50	`total_g2_sum`
51	`overall_g2_rating`
52	`g2_review_count`
53	`g2_review_grade`
54	`total_capterra_sum`
55	`overall_capterra_rating`
56	`capterra_review_count`
57	`capterra_review_grade`
58	`total_trustradius_sum`
59	`overall_trustradius_rating`
60	`trustradius_review_count`
61	`trustradius_review_grade`
62	`__currentLoopData`
63	`p`
64	`key`
65	`loop`
66	`others_ratings`
67	`othersRatingSum`
68	`totalCount`
69	`maxRating`
70	`customerRatingSums`
71	`customerRatingSum`
72	`ratingSum`
73	`OverallRatingSum`
74	`rating`
75	`fullStars`
76	`halfStar`
77	`emptyStars`
78	`i`
79	`section`
80	`index`
81	`menu_items`
82	`menu_target`
83	`row`
84	`t`
85	`userFavourite`
86	`totalOtherRating`
87	`b`
88	`advertisements`

front.includes.layout (resources/views/front/includes/layout.blade.php)112blade


__env
app
errors
cat_slug
subcategory
feature_cat
pg_review
g2_review
trustradius_reviews
capterra_reviews
avg_google_rating
avg_g2_rating
alternatives_exists
traffic_values
software_images
subcat_details
cat_details
likehood_rating
customer_rating
feature_rating
ease_rating
money_rating
review_list
total_recomm
details_recomm
details_recomm_type
details_request
details
seo_content
overall_rating
details_favourite
total_reviews
alternatives
pagination
details_data
reviewss
survey
instagram
google
pinterest
facebook
linkedin
twitter
blogs
recommended
user_id
total_pg_sum
overall_pg_rating
pg_review_count
review_grade
total_g2_sum
overall_g2_rating
g2_review_count
g2_review_grade
total_capterra_sum
overall_capterra_rating
capterra_review_count
capterra_review_grade
total_trustradius_sum
overall_trustradius_rating
trustradius_review_count
trustradius_review_grade
__currentLoopData
p
key
loop
others_ratings
othersRatingSum
totalCount
total_others_ratings
total_others_rating_count
r
maxRating
customerRatingSums
customerRatingSum
ratingSum
OverallRatingSum
rating
fullStars
halfStar
emptyStars
i
section
index
menu_items
menu_target
row
t
userFavourite
totalOtherRating
b
fea_cat
ad_categories
host_categories
marketing_categories
countries
body_script
head_script
footer_script
second_body_script
site_category
footer_ad
company_email
company_address
company_phone
twitter_link
facebook_link
youtube_link
header_logo
footer_logo
footer_copyright_text
footer_contact_detail

Params
0	`__env`
1	`app`
2	`errors`
3	`cat_slug`
4	`subcategory`
5	`feature_cat`
6	`pg_review`
7	`g2_review`
8	`trustradius_reviews`
9	`capterra_reviews`
10	`avg_google_rating`
11	`avg_g2_rating`
12	`alternatives_exists`
13	`traffic_values`
14	`software_images`
15	`subcat_details`
16	`cat_details`
17	`likehood_rating`
18	`customer_rating`
19	`feature_rating`
20	`ease_rating`
21	`money_rating`
22	`review_list`
23	`total_recomm`
24	`details_recomm`
25	`details_recomm_type`
26	`details_request`
27	`details`
28	`seo_content`
29	`overall_rating`
30	`details_favourite`
31	`total_reviews`
32	`alternatives`
33	`pagination`
34	`details_data`
35	`reviewss`
36	`survey`
37	`instagram`
38	`google`
39	`pinterest`
40	`facebook`
41	`linkedin`
42	`twitter`
43	`blogs`
44	`recommended`
45	`user_id`
46	`total_pg_sum`
47	`overall_pg_rating`
48	`pg_review_count`
49	`review_grade`
50	`total_g2_sum`
51	`overall_g2_rating`
52	`g2_review_count`
53	`g2_review_grade`
54	`total_capterra_sum`
55	`overall_capterra_rating`
56	`capterra_review_count`
57	`capterra_review_grade`
58	`total_trustradius_sum`
59	`overall_trustradius_rating`
60	`trustradius_review_count`
61	`trustradius_review_grade`
62	`__currentLoopData`
63	`p`
64	`key`
65	`loop`
66	`others_ratings`
67	`othersRatingSum`
68	`totalCount`
69	`total_others_ratings`
70	`total_others_rating_count`
71	`r`
72	`maxRating`
73	`customerRatingSums`
74	`customerRatingSum`
75	`ratingSum`
76	`OverallRatingSum`
77	`rating`
78	`fullStars`
79	`halfStar`
80	`emptyStars`
81	`i`
82	`section`
83	`index`
84	`menu_items`
85	`menu_target`
86	`row`
87	`t`
88	`userFavourite`
89	`totalOtherRating`
90	`b`
91	`fea_cat`
92	`ad_categories`
93	`host_categories`
94	`marketing_categories`
95	`countries`
96	`body_script`
97	`head_script`
98	`footer_script`
99	`second_body_script`
100	`site_category`
101	`footer_ad`
102	`company_email`
103	`company_address`
104	`company_phone`
105	`twitter_link`
106	`facebook_link`
107	`youtube_link`
108	`header_logo`
109	`footer_logo`
110	`footer_copyright_text`
111	`footer_contact_detail`

front.includes.topbar (resources/views/front/includes/topbar.blade.php)112blade


__env
app
errors
cat_slug
subcategory
feature_cat
pg_review
g2_review
trustradius_reviews
capterra_reviews
avg_google_rating
avg_g2_rating
alternatives_exists
traffic_values
software_images
subcat_details
cat_details
likehood_rating
customer_rating
feature_rating
ease_rating
money_rating
review_list
total_recomm
details_recomm
details_recomm_type
details_request
details
seo_content
overall_rating
details_favourite
total_reviews
alternatives
pagination
details_data
reviewss
survey
instagram
google
pinterest
facebook
linkedin
twitter
blogs
recommended
user_id
total_pg_sum
overall_pg_rating
pg_review_count
review_grade
total_g2_sum
overall_g2_rating
g2_review_count
g2_review_grade
total_capterra_sum
overall_capterra_rating
capterra_review_count
capterra_review_grade
total_trustradius_sum
overall_trustradius_rating
trustradius_review_count
trustradius_review_grade
__currentLoopData
p
key
loop
others_ratings
othersRatingSum
totalCount
total_others_ratings
total_others_rating_count
r
maxRating
customerRatingSums
customerRatingSum
ratingSum
OverallRatingSum
rating
fullStars
halfStar
emptyStars
i
section
index
menu_items
menu_target
row
t
userFavourite
totalOtherRating
b
fea_cat
ad_categories
host_categories
marketing_categories
countries
body_script
head_script
footer_script
second_body_script
site_category
footer_ad
company_email
company_address
company_phone
twitter_link
facebook_link
youtube_link
header_logo
footer_logo
footer_copyright_text
footer_contact_detail

Params
0	`__env`
1	`app`
2	`errors`
3	`cat_slug`
4	`subcategory`
5	`feature_cat`
6	`pg_review`
7	`g2_review`
8	`trustradius_reviews`
9	`capterra_reviews`
10	`avg_google_rating`
11	`avg_g2_rating`
12	`alternatives_exists`
13	`traffic_values`
14	`software_images`
15	`subcat_details`
16	`cat_details`
17	`likehood_rating`
18	`customer_rating`
19	`feature_rating`
20	`ease_rating`
21	`money_rating`
22	`review_list`
23	`total_recomm`
24	`details_recomm`
25	`details_recomm_type`
26	`details_request`
27	`details`
28	`seo_content`
29	`overall_rating`
30	`details_favourite`
31	`total_reviews`
32	`alternatives`
33	`pagination`
34	`details_data`
35	`reviewss`
36	`survey`
37	`instagram`
38	`google`
39	`pinterest`
40	`facebook`
41	`linkedin`
42	`twitter`
43	`blogs`
44	`recommended`
45	`user_id`
46	`total_pg_sum`
47	`overall_pg_rating`
48	`pg_review_count`
49	`review_grade`
50	`total_g2_sum`
51	`overall_g2_rating`
52	`g2_review_count`
53	`g2_review_grade`
54	`total_capterra_sum`
55	`overall_capterra_rating`
56	`capterra_review_count`
57	`capterra_review_grade`
58	`total_trustradius_sum`
59	`overall_trustradius_rating`
60	`trustradius_review_count`
61	`trustradius_review_grade`
62	`__currentLoopData`
63	`p`
64	`key`
65	`loop`
66	`others_ratings`
67	`othersRatingSum`
68	`totalCount`
69	`total_others_ratings`
70	`total_others_rating_count`
71	`r`
72	`maxRating`
73	`customerRatingSums`
74	`customerRatingSum`
75	`ratingSum`
76	`OverallRatingSum`
77	`rating`
78	`fullStars`
79	`halfStar`
80	`emptyStars`
81	`i`
82	`section`
83	`index`
84	`menu_items`
85	`menu_target`
86	`row`
87	`t`
88	`userFavourite`
89	`totalOtherRating`
90	`b`
91	`fea_cat`
92	`ad_categories`
93	`host_categories`
94	`marketing_categories`
95	`countries`
96	`body_script`
97	`head_script`
98	`footer_script`
99	`second_body_script`
100	`site_category`
101	`footer_ad`
102	`company_email`
103	`company_address`
104	`company_phone`
105	`twitter_link`
106	`facebook_link`
107	`youtube_link`
108	`header_logo`
109	`footer_logo`
110	`footer_copyright_text`
111	`footer_contact_detail`

uri: GET software/{slug}
middleware: web
controller: App\Http\Controllers\Front\SoftwaresController@details
as: front.software_details
namespace: App\Http\Controllers\Front
prefix
where
file: app/Http/Controllers/Front/SoftwaresController.php:721-1119

136 statements were executed, 38 of which were duplicated, 98 unique121ms

select * from `softwares` where (`slug` = 'pepperjam' and `status` = '1') and `softwares`.`deleted_at` is null limit 1

7.76ms/app/Http/Controllers/Front/SoftwaresController.php:2690staging

Metadata
Bindings	0. pepperjam 1. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:2690 16. /app/Http/Controllers/Front/SoftwaresController.php:723 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `admins` where `admins`.`id` in (14) and `admins`.`deleted_at` is null

1.77ms/app/Http/Controllers/Front/SoftwaresController.php:2690staging

Metadata
Backtrace	20. /app/Http/Controllers/Front/SoftwaresController.php:2690 21. /app/Http/Controllers/Front/SoftwaresController.php:723 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `reviews` where `reviews`.`software_id` in (338) and `reviews`.`deleted_at` is null

1.53ms/app/Http/Controllers/Front/SoftwaresController.php:2690staging

Metadata
Bindings	0. 338
Backtrace	20. /app/Http/Controllers/Front/SoftwaresController.php:2690 21. /app/Http/Controllers/Front/SoftwaresController.php:723 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `adtech_feature` where `id` in ('1', '4', '6') and `status` = '1' and `adtech_feature`.`deleted_at` is null

1.18ms/app/Http/Controllers/Front/SoftwaresController.php:2703staging

Metadata
Bindings	0. 1 1. 4 2. 6 3. 1
Backtrace	14. /app/Http/Controllers/Front/SoftwaresController.php:2703 15. /app/Http/Controllers/Front/SoftwaresController.php:723 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `filters` where `slug` = 'traffic-requirement' and `status` = 1 and `filters`.`deleted_at` is null limit 1

1.04ms/app/Http/Controllers/Front/SoftwaresController.php:2734staging

Metadata
Bindings	0. traffic-requirement 1. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:2734 16. /app/Http/Controllers/Front/SoftwaresController.php:723 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `filter_values` where `filter_id` = 1 and `filter_values`.`deleted_at` is null

870μs/app/Http/Controllers/Front/SoftwaresController.php:2737staging

Metadata
Bindings	0. 1
Backtrace	14. /app/Http/Controllers/Front/SoftwaresController.php:2737 15. /app/Http/Controllers/Front/SoftwaresController.php:723 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `faq` where (`software_id` = 338) and `faq`.`deleted_at` is null

13.16ms/app/Http/Controllers/Front/SoftwaresController.php:2739staging

Metadata
Bindings	0. 338
Backtrace	14. /app/Http/Controllers/Front/SoftwaresController.php:2739 15. /app/Http/Controllers/Front/SoftwaresController.php:723 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `blog` where exists (select * from `blog_category` where `blog`.`cat_id` = `blog_category`.`id` and `status` = '1' and `blog_category`.`deleted_at` is null) and exists (select * from `blog_author` where `blog`.`author_id` = `blog_author`.`id` and `status` = '1' and `blog_author`.`deleted_at` is null) and `status` = '1' and `blog`.`deleted_at` is null order by RAND() limit 5

12.98ms/app/Http/Controllers/Front/SoftwaresController.php:2745staging

Metadata
Bindings	0. 1 1. 1 2. 1
Backtrace	14. /app/Http/Controllers/Front/SoftwaresController.php:2745 15. /app/Http/Controllers/Front/SoftwaresController.php:723 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `thumbnail_images` where `id` = 1440 limit 1

1.76ms/app/Http/Controllers/Front/SoftwaresController.php:2746staging

Metadata
Bindings	0. 1440
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:2746 16. /app/Http/Controllers/Front/SoftwaresController.php:723 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `software_images` where (`software_id` = 338) and `software_images`.`deleted_at` is null order by `id` asc

1.8ms/app/Http/Controllers/Front/SoftwaresController.php:2747staging

Metadata
Bindings	0. 338
Backtrace	14. /app/Http/Controllers/Front/SoftwaresController.php:2747 15. /app/Http/Controllers/Front/SoftwaresController.php:723 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `advertisements` where `title` in ('ADVERTISEMENT_ONE', 'ADVERTISEMENT_TWO', 'SOFTWAREPROFILESIDEBAR_AD3', 'SOFTWAREPROFILESIDEBAR_AD4', 'ADVERTISEMENT_INSTALLATION') and `status` = '1' and `advertisements`.`deleted_at` is null

1.37ms/app/Http/Controllers/Front/SoftwaresController.php:2749staging

Metadata
Bindings	0. ADVERTISEMENT_ONE 1. ADVERTISEMENT_TWO 2. SOFTWAREPROFILESIDEBAR_AD3 3. SOFTWAREPROFILESIDEBAR_AD4 4. ADVERTISEMENT_INSTALLATION 5. 1
Backtrace	14. /app/Http/Controllers/Front/SoftwaresController.php:2749 15. /app/Http/Controllers/Front/SoftwaresController.php:723 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `softwares` where (`slug` = 'pepperjam' and `status` = '1') and `softwares`.`deleted_at` is null limit 1

2.45ms/app/Http/Controllers/Front/SoftwaresController.php:735staging

Metadata
Bindings	0. pepperjam 1. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:735 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `admins` where `admins`.`id` in (14) and `admins`.`deleted_at` is null

540μs/app/Http/Controllers/Front/SoftwaresController.php:735staging

Metadata
Backtrace	20. /app/Http/Controllers/Front/SoftwaresController.php:735 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `reviews` where `reviews`.`software_id` in (338) and `reviews`.`deleted_at` is null

610μs/app/Http/Controllers/Front/SoftwaresController.php:735staging

Metadata
Bindings	0. 338
Backtrace	20. /app/Http/Controllers/Front/SoftwaresController.php:735 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `software_view` where (`ip` = '172.69.58.52' and `software_id` = 338) and `software_view`.`deleted_at` is null limit 1

7.05ms/app/Http/Controllers/Front/SoftwaresController.php:745staging

Metadata
Bindings	0. 172.69.58.52 1. 338
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:745 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

insert into `software_view` (`software_id`, `ip`, `updated_at`, `created_at`) values (338, '172.69.58.52', '2025-09-10 05:55:29', '2025-09-10 05:55:29')

4.82ms/app/Http/Controllers/Front/SoftwaresController.php:750staging

Metadata
Bindings	0. 338 1. 172.69.58.52 2. 2025-09-10 05:55:29 3. 2025-09-10 05:55:29
Backtrace	21. /app/Http/Controllers/Front/SoftwaresController.php:750 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `software_favourites` where (`user_id` is null and `software_id` = 338) and `software_favourites`.`deleted_at` is null

840μs/app/Http/Controllers/Front/SoftwaresController.php:755staging

Metadata
Bindings	0. 338
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:755 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `request_softwares` where (`user_id` is null and `software_id` = 338) and `request_softwares`.`deleted_at` is null

630μs/app/Http/Controllers/Front/SoftwaresController.php:763staging

Metadata
Bindings	0. 338
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:763 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `software_recommendations` where (`user_id` is null and `software_id` = 338) and `software_recommendations`.`deleted_at` is null limit 1

620μs/app/Http/Controllers/Front/SoftwaresController.php:771staging

Metadata
Bindings	0. 338
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:771 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `software_recommendations` where (`user_id` is null and `software_id` = 338) and `software_recommendations`.`deleted_at` is null

220μs/app/Http/Controllers/Front/SoftwaresController.php:772staging

Metadata
Bindings	0. 338
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:772 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `reviews` where (`review_type` = '5' and `software_id` = 338 and `status` = '1') and `reviews`.`deleted_at` is null

340μs/app/Http/Controllers/Front/SoftwaresController.php:782staging

Metadata
Bindings	0. 5 1. 338 2. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:782 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `reviews` where (`review_type` = '2' and `software_id` = 338 and `status` = '1') and `reviews`.`deleted_at` is null

280μs/app/Http/Controllers/Front/SoftwaresController.php:783staging

Metadata
Bindings	0. 2 1. 338 2. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:783 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `reviews` where (`review_type` = '1' and `software_id` = 338 and `status` = '1') and `reviews`.`deleted_at` is null

270μs/app/Http/Controllers/Front/SoftwaresController.php:784staging

Metadata
Bindings	0. 1 1. 338 2. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:784 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `reviews` where (`review_type` = '4' and `software_id` = 338 and `status` = '1') and `reviews`.`deleted_at` is null

260μs/app/Http/Controllers/Front/SoftwaresController.php:785staging

Metadata
Bindings	0. 4 1. 338 2. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:785 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `reviews` where (`review_type` = '3' and `software_id` = 338 and `status` = '1') and `reviews`.`deleted_at` is null

250μs/app/Http/Controllers/Front/SoftwaresController.php:786staging

Metadata
Bindings	0. 3 1. 338 2. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:786 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `reviews` where (`software_id` = 338 and `status` = '1' and `review_type` is null) and `reviews`.`deleted_at` is null

260μs/app/Http/Controllers/Front/SoftwaresController.php:800staging

Metadata
Bindings	0. 338 1. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:800 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `softwares` where `alias_name` in ('jvzoo', 'awin', 'shareasale') and `status` = '1' and `softwares`.`deleted_at` is null

3.68ms/app/Http/Controllers/Front/SoftwaresController.php:840staging

Metadata
Bindings	0. jvzoo 1. awin 2. shareasale 3. 1
Backtrace	14. /app/Http/Controllers/Front/SoftwaresController.php:840 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `admins` where `admins`.`id` in (14, 34) and `admins`.`deleted_at` is null

440μs/app/Http/Controllers/Front/SoftwaresController.php:840staging

Metadata
Backtrace	19. /app/Http/Controllers/Front/SoftwaresController.php:840 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `reviews` where (`software_id` = 96 and `review_type` = '5' and `status` = '1') and `reviews`.`deleted_at` is null

390μs/app/Http/Controllers/Front/SoftwaresController.php:847staging

Metadata
Bindings	0. 96 1. 5 2. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:847 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `software_favourites` where (`user_id` is null and `software_id` = 96) and `software_favourites`.`deleted_at` is null

260μs/app/Http/Controllers/Front/SoftwaresController.php:872staging

Metadata
Bindings	0. 96
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:872 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `request_softwares` where (`user_id` is null and `software_id` = 96) and `request_softwares`.`deleted_at` is null

250μs/app/Http/Controllers/Front/SoftwaresController.php:880staging

Metadata
Bindings	0. 96
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:880 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `software_recommendations` where (`user_id` is null and `software_id` = 96) and `software_recommendations`.`deleted_at` is null limit 1

280μs/app/Http/Controllers/Front/SoftwaresController.php:888staging

Metadata
Bindings	0. 96
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:888 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `software_recommendations` where (`user_id` is null and `software_id` = 96) and `software_recommendations`.`deleted_at` is null

250μs/app/Http/Controllers/Front/SoftwaresController.php:889staging

Metadata
Bindings	0. 96
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:889 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `thumbnail_images` where `id` = 1513 limit 1

360μs/app/Http/Controllers/Front/SoftwaresController.php:897staging

Metadata
Bindings	0. 1513
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:897 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `reviews` where (`software_id` = 100 and `review_type` = '5' and `status` = '1') and `reviews`.`deleted_at` is null

350μs/app/Http/Controllers/Front/SoftwaresController.php:847staging

Metadata
Bindings	0. 100 1. 5 2. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:847 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `software_favourites` where (`user_id` is null and `software_id` = 100) and `software_favourites`.`deleted_at` is null

280μs/app/Http/Controllers/Front/SoftwaresController.php:872staging

Metadata
Bindings	0. 100
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:872 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `request_softwares` where (`user_id` is null and `software_id` = 100) and `request_softwares`.`deleted_at` is null

240μs/app/Http/Controllers/Front/SoftwaresController.php:880staging

Metadata
Bindings	0. 100
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:880 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `software_recommendations` where (`user_id` is null and `software_id` = 100) and `software_recommendations`.`deleted_at` is null limit 1

250μs/app/Http/Controllers/Front/SoftwaresController.php:888staging

Metadata
Bindings	0. 100
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:888 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `software_recommendations` where (`user_id` is null and `software_id` = 100) and `software_recommendations`.`deleted_at` is null

250μs/app/Http/Controllers/Front/SoftwaresController.php:889staging

Metadata
Bindings	0. 100
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:889 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `thumbnail_images` where `id` = 1069 limit 1

340μs/app/Http/Controllers/Front/SoftwaresController.php:897staging

Metadata
Bindings	0. 1069
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:897 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `reviews` where (`software_id` = 339 and `review_type` = '5' and `status` = '1') and `reviews`.`deleted_at` is null

460μs/app/Http/Controllers/Front/SoftwaresController.php:847staging

Metadata
Bindings	0. 339 1. 5 2. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:847 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `software_favourites` where (`user_id` is null and `software_id` = 339) and `software_favourites`.`deleted_at` is null

270μs/app/Http/Controllers/Front/SoftwaresController.php:872staging

Metadata
Bindings	0. 339
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:872 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `request_softwares` where (`user_id` is null and `software_id` = 339) and `request_softwares`.`deleted_at` is null

280μs/app/Http/Controllers/Front/SoftwaresController.php:880staging

Metadata
Bindings	0. 339
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:880 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `software_recommendations` where (`user_id` is null and `software_id` = 339) and `software_recommendations`.`deleted_at` is null limit 1

290μs/app/Http/Controllers/Front/SoftwaresController.php:888staging

Metadata
Bindings	0. 339
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:888 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `software_recommendations` where (`user_id` is null and `software_id` = 339) and `software_recommendations`.`deleted_at` is null

270μs/app/Http/Controllers/Front/SoftwaresController.php:889staging

Metadata
Bindings	0. 339
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:889 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `thumbnail_images` where `id` = 1317 limit 1

360μs/app/Http/Controllers/Front/SoftwaresController.php:897staging

Metadata
Bindings	0. 1317
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:897 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `categories` where `id` = '1' and `categories`.`deleted_at` is null limit 1

1.36ms/app/Http/Controllers/Front/SoftwaresController.php:935staging

Metadata
Bindings	0. 1
Backtrace	16. /app/Http/Controllers/Front/SoftwaresController.php:935 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `subcategory` where `id` = '129' and `subcategory`.`deleted_at` is null limit 1

1.04ms/app/Http/Controllers/Front/SoftwaresController.php:942staging

Metadata
Bindings	0. 129
Backtrace	16. /app/Http/Controllers/Front/SoftwaresController.php:942 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `blog` where `status` = 1 and `blog`.`deleted_at` is null order by `created_at` desc limit 4

1.93ms/app/Http/Controllers/Front/SoftwaresController.php:951staging

Metadata
Bindings	0. 1
Backtrace	14. /app/Http/Controllers/Front/SoftwaresController.php:951 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `thumbnail_images` where `thumbnail_images`.`id` in (2466, 2467, 2468, 2470)

410μs/app/Http/Controllers/Front/SoftwaresController.php:951staging

Metadata
Backtrace	19. /app/Http/Controllers/Front/SoftwaresController.php:951 20. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `categories` where `id` = '1,2' and `categories`.`deleted_at` is null limit 1

360μs/app/Http/Controllers/Front/SoftwaresController.php:952staging

Metadata
Bindings	0. 1,2
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:952 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `subcategory` where (`cat_id` = 1 and `status` = '1') and `subcategory`.`deleted_at` is null order by `subcategory_name` asc

9.34ms/app/Http/Controllers/Front/SoftwaresController.php:953staging

Metadata
Bindings	0. 1 1. 1
Backtrace	14. /app/Http/Controllers/Front/SoftwaresController.php:953 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `blog` where `status` = 1 and `software_id` = 338 and `blog`.`deleted_at` is null order by `created_at` desc limit 4

1.76ms/app/Http/Controllers/Front/SoftwaresController.php:954staging

Metadata
Bindings	0. 1 1. 338
Backtrace	14. /app/Http/Controllers/Front/SoftwaresController.php:954 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `alternatives` where (`software_id` = 338 and `status` = '1') and `alternatives`.`deleted_at` is null

2.25ms/app/Http/Controllers/Front/SoftwaresController.php:955staging

Metadata
Bindings	0. 338 1. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:955 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `reviews` where `status` = 1 and `review_type` is null and `reviews`.`deleted_at` is null order by `created_at` desc

560μs/app/Http/Controllers/Front/SoftwaresController.php:956staging

Metadata
Bindings	0. 1
Backtrace	14. /app/Http/Controllers/Front/SoftwaresController.php:956 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `settings` where `title` = 'SURVEY' and `settings`.`deleted_at` is null limit 1

1.14ms/app/Http/Controllers/Front/SoftwaresController.php:957staging

Metadata
Bindings	0. SURVEY
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:957 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `settings` where `title` = 'INSTAGRAM' and `settings`.`deleted_at` is null limit 1

320μs/app/Http/Controllers/Front/SoftwaresController.php:958staging

Metadata
Bindings	0. INSTAGRAM
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:958 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `settings` where `title` = 'GOOGLE' and `settings`.`deleted_at` is null limit 1

320μs/app/Http/Controllers/Front/SoftwaresController.php:959staging

Metadata
Bindings	0. GOOGLE
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:959 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `settings` where `title` = 'PINTEREST' and `settings`.`deleted_at` is null limit 1

330μs/app/Http/Controllers/Front/SoftwaresController.php:960staging

Metadata
Bindings	0. PINTEREST
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:960 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `settings` where `title` = 'FACEBOOK_LINK' and `settings`.`deleted_at` is null limit 1

410μs/app/Http/Controllers/Front/SoftwaresController.php:961staging

Metadata
Bindings	0. FACEBOOK_LINK
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:961 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `settings` where `title` = 'LINKEDIN' and `settings`.`deleted_at` is null limit 1

380μs/app/Http/Controllers/Front/SoftwaresController.php:962staging

Metadata
Bindings	0. LINKEDIN
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:962 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `settings` where `title` = 'TWITTER_LINK' and `settings`.`deleted_at` is null limit 1

340μs/app/Http/Controllers/Front/SoftwaresController.php:963staging

Metadata
Bindings	0. TWITTER_LINK
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:963 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `softwares` where (`type` = 'ad-tech' and `featured` = '1' and `status` = '1') and `softwares`.`deleted_at` is null order by `id` asc

3.8ms/app/Http/Controllers/Front/SoftwaresController.php:55staging

Metadata
Bindings	0. ad-tech 1. 1 2. 1
Backtrace	14. /app/Http/Controllers/Front/SoftwaresController.php:55 15. /app/Http/Controllers/Front/SoftwaresController.php:968 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `reviews` where `reviews`.`software_id` in (11, 21, 23, 35, 44, 48, 54, 392, 404, 456) and `reviews`.`deleted_at` is null

490μs/app/Http/Controllers/Front/SoftwaresController.php:55staging

Metadata
Backtrace	19. /app/Http/Controllers/Front/SoftwaresController.php:55 20. /app/Http/Controllers/Front/SoftwaresController.php:968 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `software_favourites` where `software_favourites`.`software_id` in (11, 21, 23, 35, 44, 48, 54, 392, 404, 456) and `software_favourites`.`deleted_at` is null

550μs/app/Http/Controllers/Front/SoftwaresController.php:55staging

Metadata
Backtrace	19. /app/Http/Controllers/Front/SoftwaresController.php:55 20. /app/Http/Controllers/Front/SoftwaresController.php:968 21. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 22. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select count(*) as aggregate from `reviews` where (`software_id` = 11 and `review_type` = '5' and `status` = '1') and `reviews`.`deleted_at` is null

300μs/app/Http/Controllers/Front/SoftwaresController.php:62staging

Metadata
Bindings	0. 11 1. 5 2. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:62 16. /app/Http/Controllers/Front/SoftwaresController.php:968 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select
(COALESCE(feature_capability, 0) +
COALESCE(ease_of_use, 0) +
COALESCE(customer_support, 0) +
COALESCE(likelihood, 0) +
COALESCE(money_value, 0)) / 5 as reviews
from `reviews` where (`software_id` = 11 and `review_type` = '5' and `status` = '1') and `reviews`.`deleted_at` is null limit 1

260μs/app/Http/Controllers/Front/SoftwaresController.php:82staging

Metadata
Bindings	0. 11 1. 5 2. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:82 16. /app/Http/Controllers/Front/SoftwaresController.php:968 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `thumbnail_images` where `id` = 1310 limit 1

270μs/app/Http/Controllers/Front/SoftwaresController.php:85staging

Metadata
Bindings	0. 1310
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:85 16. /app/Http/Controllers/Front/SoftwaresController.php:968 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `admins` where `admins`.`id` = 29 and `admins`.`deleted_at` is null limit 1

340μs/app/Http/Controllers/Front/SoftwaresController.php:88staging

Metadata
Bindings	0. 29
Backtrace	20. /app/Http/Controllers/Front/SoftwaresController.php:88 21. /app/Http/Controllers/Front/SoftwaresController.php:968 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select count(*) as aggregate from `reviews` where (`software_id` = 21 and `review_type` = '5' and `status` = '1') and `reviews`.`deleted_at` is null

280μs/app/Http/Controllers/Front/SoftwaresController.php:62staging

Metadata
Bindings	0. 21 1. 5 2. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:62 16. /app/Http/Controllers/Front/SoftwaresController.php:968 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select
(COALESCE(feature_capability, 0) +
COALESCE(ease_of_use, 0) +
COALESCE(customer_support, 0) +
COALESCE(likelihood, 0) +
COALESCE(money_value, 0)) / 5 as reviews
from `reviews` where (`software_id` = 21 and `review_type` = '5' and `status` = '1') and `reviews`.`deleted_at` is null limit 1

290μs/app/Http/Controllers/Front/SoftwaresController.php:82staging

Metadata
Bindings	0. 21 1. 5 2. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:82 16. /app/Http/Controllers/Front/SoftwaresController.php:968 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `thumbnail_images` where `id` = 1019 limit 1

360μs/app/Http/Controllers/Front/SoftwaresController.php:85staging

Metadata
Bindings	0. 1019
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:85 16. /app/Http/Controllers/Front/SoftwaresController.php:968 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `admins` where `admins`.`id` = 34 and `admins`.`deleted_at` is null limit 1

370μs/app/Http/Controllers/Front/SoftwaresController.php:88staging

Metadata
Bindings	0. 34
Backtrace	20. /app/Http/Controllers/Front/SoftwaresController.php:88 21. /app/Http/Controllers/Front/SoftwaresController.php:968 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select count(*) as aggregate from `reviews` where (`software_id` = 23 and `review_type` = '5' and `status` = '1') and `reviews`.`deleted_at` is null

310μs/app/Http/Controllers/Front/SoftwaresController.php:62staging

Metadata
Bindings	0. 23 1. 5 2. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:62 16. /app/Http/Controllers/Front/SoftwaresController.php:968 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select
(COALESCE(feature_capability, 0) +
COALESCE(ease_of_use, 0) +
COALESCE(customer_support, 0) +
COALESCE(likelihood, 0) +
COALESCE(money_value, 0)) / 5 as reviews
from `reviews` where (`software_id` = 23 and `review_type` = '5' and `status` = '1') and `reviews`.`deleted_at` is null limit 1

290μs/app/Http/Controllers/Front/SoftwaresController.php:82staging

Metadata
Bindings	0. 23 1. 5 2. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:82 16. /app/Http/Controllers/Front/SoftwaresController.php:968 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `thumbnail_images` where `id` = 1511 limit 1

260μs/app/Http/Controllers/Front/SoftwaresController.php:85staging

Metadata
Bindings	0. 1511
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:85 16. /app/Http/Controllers/Front/SoftwaresController.php:968 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `admins` where `admins`.`id` = 39 and `admins`.`deleted_at` is null limit 1

310μs/app/Http/Controllers/Front/SoftwaresController.php:88staging

Metadata
Bindings	0. 39
Backtrace	20. /app/Http/Controllers/Front/SoftwaresController.php:88 21. /app/Http/Controllers/Front/SoftwaresController.php:968 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select count(*) as aggregate from `reviews` where (`software_id` = 35 and `review_type` = '5' and `status` = '1') and `reviews`.`deleted_at` is null

270μs/app/Http/Controllers/Front/SoftwaresController.php:62staging

Metadata
Bindings	0. 35 1. 5 2. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:62 16. /app/Http/Controllers/Front/SoftwaresController.php:968 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select
(COALESCE(feature_capability, 0) +
COALESCE(ease_of_use, 0) +
COALESCE(customer_support, 0) +
COALESCE(likelihood, 0) +
COALESCE(money_value, 0)) / 5 as reviews
from `reviews` where (`software_id` = 35 and `review_type` = '5' and `status` = '1') and `reviews`.`deleted_at` is null limit 1

280μs/app/Http/Controllers/Front/SoftwaresController.php:82staging

Metadata
Bindings	0. 35 1. 5 2. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:82 16. /app/Http/Controllers/Front/SoftwaresController.php:968 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `thumbnail_images` where `id` = 1081 limit 1

260μs/app/Http/Controllers/Front/SoftwaresController.php:85staging

Metadata
Bindings	0. 1081
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:85 16. /app/Http/Controllers/Front/SoftwaresController.php:968 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `admins` where `admins`.`id` = 14 and `admins`.`deleted_at` is null limit 1

310μs/app/Http/Controllers/Front/SoftwaresController.php:88staging

Metadata
Bindings	0. 14
Backtrace	20. /app/Http/Controllers/Front/SoftwaresController.php:88 21. /app/Http/Controllers/Front/SoftwaresController.php:968 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select count(*) as aggregate from `reviews` where (`software_id` = 44 and `review_type` = '5' and `status` = '1') and `reviews`.`deleted_at` is null

270μs/app/Http/Controllers/Front/SoftwaresController.php:62staging

Metadata
Bindings	0. 44 1. 5 2. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:62 16. /app/Http/Controllers/Front/SoftwaresController.php:968 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `thumbnail_images` where `id` = 1220 limit 1

270μs/app/Http/Controllers/Front/SoftwaresController.php:85staging

Metadata
Bindings	0. 1220
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:85 16. /app/Http/Controllers/Front/SoftwaresController.php:968 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `admins` where `admins`.`id` = 34 and `admins`.`deleted_at` is null limit 1

310μs/app/Http/Controllers/Front/SoftwaresController.php:88staging

Metadata
Bindings	0. 34
Backtrace	20. /app/Http/Controllers/Front/SoftwaresController.php:88 21. /app/Http/Controllers/Front/SoftwaresController.php:968 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select count(*) as aggregate from `reviews` where (`software_id` = 48 and `review_type` = '5' and `status` = '1') and `reviews`.`deleted_at` is null

270μs/app/Http/Controllers/Front/SoftwaresController.php:62staging

Metadata
Bindings	0. 48 1. 5 2. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:62 16. /app/Http/Controllers/Front/SoftwaresController.php:968 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `thumbnail_images` where `id` = 1219 limit 1

260μs/app/Http/Controllers/Front/SoftwaresController.php:85staging

Metadata
Bindings	0. 1219
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:85 16. /app/Http/Controllers/Front/SoftwaresController.php:968 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `admins` where `admins`.`id` = 34 and `admins`.`deleted_at` is null limit 1

300μs/app/Http/Controllers/Front/SoftwaresController.php:88staging

Metadata
Bindings	0. 34
Backtrace	20. /app/Http/Controllers/Front/SoftwaresController.php:88 21. /app/Http/Controllers/Front/SoftwaresController.php:968 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select count(*) as aggregate from `reviews` where (`software_id` = 54 and `review_type` = '5' and `status` = '1') and `reviews`.`deleted_at` is null

270μs/app/Http/Controllers/Front/SoftwaresController.php:62staging

Metadata
Bindings	0. 54 1. 5 2. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:62 16. /app/Http/Controllers/Front/SoftwaresController.php:968 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select
(COALESCE(feature_capability, 0) +
COALESCE(ease_of_use, 0) +
COALESCE(customer_support, 0) +
COALESCE(likelihood, 0) +
COALESCE(money_value, 0)) / 5 as reviews
from `reviews` where (`software_id` = 54 and `review_type` = '5' and `status` = '1') and `reviews`.`deleted_at` is null limit 1

250μs/app/Http/Controllers/Front/SoftwaresController.php:82staging

Metadata
Bindings	0. 54 1. 5 2. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:82 16. /app/Http/Controllers/Front/SoftwaresController.php:968 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `thumbnail_images` where `id` = 1680 limit 1

330μs/app/Http/Controllers/Front/SoftwaresController.php:85staging

Metadata
Bindings	0. 1680
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:85 16. /app/Http/Controllers/Front/SoftwaresController.php:968 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `admins` where `admins`.`id` = 34 and `admins`.`deleted_at` is null limit 1

280μs/app/Http/Controllers/Front/SoftwaresController.php:88staging

Metadata
Bindings	0. 34
Backtrace	20. /app/Http/Controllers/Front/SoftwaresController.php:88 21. /app/Http/Controllers/Front/SoftwaresController.php:968 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select count(*) as aggregate from `reviews` where (`software_id` = 392 and `review_type` = '5' and `status` = '1') and `reviews`.`deleted_at` is null

240μs/app/Http/Controllers/Front/SoftwaresController.php:62staging

Metadata
Bindings	0. 392 1. 5 2. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:62 16. /app/Http/Controllers/Front/SoftwaresController.php:968 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `thumbnail_images` where `id` = 1436 limit 1

230μs/app/Http/Controllers/Front/SoftwaresController.php:85staging

Metadata
Bindings	0. 1436
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:85 16. /app/Http/Controllers/Front/SoftwaresController.php:968 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `admins` where `admins`.`id` = 31 and `admins`.`deleted_at` is null limit 1

270μs/app/Http/Controllers/Front/SoftwaresController.php:88staging

Metadata
Bindings	0. 31
Backtrace	20. /app/Http/Controllers/Front/SoftwaresController.php:88 21. /app/Http/Controllers/Front/SoftwaresController.php:968 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select count(*) as aggregate from `reviews` where (`software_id` = 404 and `review_type` = '5' and `status` = '1') and `reviews`.`deleted_at` is null

240μs/app/Http/Controllers/Front/SoftwaresController.php:62staging

Metadata
Bindings	0. 404 1. 5 2. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:62 16. /app/Http/Controllers/Front/SoftwaresController.php:968 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `thumbnail_images` where `id` = 1452 limit 1

220μs/app/Http/Controllers/Front/SoftwaresController.php:85staging

Metadata
Bindings	0. 1452
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:85 16. /app/Http/Controllers/Front/SoftwaresController.php:968 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `admins` where `admins`.`id` = 34 and `admins`.`deleted_at` is null limit 1

270μs/app/Http/Controllers/Front/SoftwaresController.php:88staging

Metadata
Bindings	0. 34
Backtrace	20. /app/Http/Controllers/Front/SoftwaresController.php:88 21. /app/Http/Controllers/Front/SoftwaresController.php:968 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select count(*) as aggregate from `reviews` where (`software_id` = 456 and `review_type` = '5' and `status` = '1') and `reviews`.`deleted_at` is null

250μs/app/Http/Controllers/Front/SoftwaresController.php:62staging

Metadata
Bindings	0. 456 1. 5 2. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:62 16. /app/Http/Controllers/Front/SoftwaresController.php:968 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select
(COALESCE(feature_capability, 0) +
COALESCE(ease_of_use, 0) +
COALESCE(customer_support, 0) +
COALESCE(likelihood, 0) +
COALESCE(money_value, 0)) / 5 as reviews
from `reviews` where (`software_id` = 456 and `review_type` = '5' and `status` = '1') and `reviews`.`deleted_at` is null limit 1

260μs/app/Http/Controllers/Front/SoftwaresController.php:82staging

Metadata
Bindings	0. 456 1. 5 2. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:82 16. /app/Http/Controllers/Front/SoftwaresController.php:968 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `thumbnail_images` where `id` = 2065 limit 1

300μs/app/Http/Controllers/Front/SoftwaresController.php:85staging

Metadata
Bindings	0. 2065
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:85 16. /app/Http/Controllers/Front/SoftwaresController.php:968 17. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select * from `admins` where `admins`.`id` = 34 and `admins`.`deleted_at` is null limit 1

290μs/app/Http/Controllers/Front/SoftwaresController.php:88staging

Metadata
Bindings	0. 34
Backtrace	20. /app/Http/Controllers/Front/SoftwaresController.php:88 21. /app/Http/Controllers/Front/SoftwaresController.php:968 22. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 23. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 24. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262

select count(*) as aggregate from `reviews` where (`review_type` = '5' and `software_id` = 338 and `status` = '1') and `reviews`.`deleted_at` is null

350μs/app/Http/Controllers/Front/SoftwaresController.php:970staging

Metadata
Bindings	0. 5 1. 338 2. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:970 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `reviews` where (`review_type` = '1' and `software_id` = 338 and `status` = '1') and `reviews`.`deleted_at` is null

230μs/app/Http/Controllers/Front/SoftwaresController.php:971staging

Metadata
Bindings	0. 1 1. 338 2. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:971 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `reviews` where (`review_type` = '4' and `software_id` = 338 and `status` = '1') and `reviews`.`deleted_at` is null

220μs/app/Http/Controllers/Front/SoftwaresController.php:972staging

Metadata
Bindings	0. 4 1. 338 2. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:972 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select count(*) as aggregate from `reviews` where (`review_type` = '3' and `software_id` = 338 and `status` = '1') and `reviews`.`deleted_at` is null

210μs/app/Http/Controllers/Front/SoftwaresController.php:973staging

Metadata
Bindings	0. 3 1. 338 2. 1
Backtrace	15. /app/Http/Controllers/Front/SoftwaresController.php:973 16. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:262 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

select * from `software_favourites` where `software_favourites`.`software_id` = 338 and `software_favourites`.`software_id` is not null and `software_favourites`.`deleted_at` is null

250μsview::6042c9820065872ec605a4239418a9b9b9be7fab:1109staging

Metadata
Bindings	0. 338
Backtrace	19. view::6042c9820065872ec605a4239418a9b9b9be7fab:1109 21. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 22. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 24. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `advertisements` where `status` = '1' and `advertisements`.`deleted_at` is null

230μs/app/Providers/ViewComposerServiceProvider.php:62staging

Metadata
Bindings	0. 1
Backtrace	14. /app/Providers/ViewComposerServiceProvider.php:62 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 18. /vendor/laravel/framework/src/Illuminate/View/View.php:120 19. /vendor/laravel/framework/src/Illuminate/View/View.php:91 20. view::6042c9820065872ec605a4239418a9b9b9be7fab:1586

select * from `thumbnail_images` where `thumbnail_images`.`id` = 2493 limit 1

230μsview::524dc401edb2f0ef6c82abe3dd878704ca980969:15staging

Metadata
Bindings	0. 2493
Backtrace	20. view::524dc401edb2f0ef6c82abe3dd878704ca980969:15 22. /vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:108 23. /vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:61 25. /vendor/facade/ignition/src/Views/Engines/CompilerEngine.php:37

select * from `categories` where `type_slug` = 'ad-tech' and `status` = '1' and `categories`.`deleted_at` is null

260μs/app/Providers/CustomServiceProvider.php:31staging

Metadata
Bindings	0. ad-tech 1. 1
Backtrace	14. /app/Providers/CustomServiceProvider.php:31 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 18. /vendor/laravel/framework/src/Illuminate/View/View.php:120 19. /vendor/laravel/framework/src/Illuminate/View/View.php:91 20. view::6042c9820065872ec605a4239418a9b9b9be7fab:2281

select * from `categories` where `type_slug` = 'hosting' and `status` = '1' and `categories`.`deleted_at` is null

220μs/app/Providers/CustomServiceProvider.php:32staging

Metadata
Bindings	0. hosting 1. 1
Backtrace	14. /app/Providers/CustomServiceProvider.php:32 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 18. /vendor/laravel/framework/src/Illuminate/View/View.php:120 19. /vendor/laravel/framework/src/Illuminate/View/View.php:91 20. view::6042c9820065872ec605a4239418a9b9b9be7fab:2281

select * from `categories` where `type_slug` = 'publisher-tools-plugins' and `status` = '1' and `categories`.`deleted_at` is null order by `created_at` asc

250μs/app/Providers/CustomServiceProvider.php:33staging

Metadata
Bindings	0. publisher-tools-plugins 1. 1
Backtrace	14. /app/Providers/CustomServiceProvider.php:33 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 18. /vendor/laravel/framework/src/Illuminate/View/View.php:120 19. /vendor/laravel/framework/src/Illuminate/View/View.php:91 20. view::6042c9820065872ec605a4239418a9b9b9be7fab:2281

select * from `country` where `status` = '1' and `country`.`deleted_at` is null order by `country_name` asc

1.37ms/app/Providers/CustomServiceProvider.php:34staging

Metadata
Bindings	0. 1
Backtrace	14. /app/Providers/CustomServiceProvider.php:34 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 18. /vendor/laravel/framework/src/Illuminate/View/View.php:120 19. /vendor/laravel/framework/src/Illuminate/View/View.php:91 20. view::6042c9820065872ec605a4239418a9b9b9be7fab:2281

select * from `settings` where `title` = 'BODY_SCRIPT' and `settings`.`deleted_at` is null limit 1

240μs/app/Providers/CustomServiceProvider.php:35staging

Metadata
Bindings	0. BODY_SCRIPT
Backtrace	15. /app/Providers/CustomServiceProvider.php:35 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 19. /vendor/laravel/framework/src/Illuminate/View/View.php:120 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91 21. view::6042c9820065872ec605a4239418a9b9b9be7fab:2281

select * from `settings` where `title` = 'HEAD_SCRIPT' and `settings`.`deleted_at` is null limit 1

210μs/app/Providers/CustomServiceProvider.php:36staging

Metadata
Bindings	0. HEAD_SCRIPT
Backtrace	15. /app/Providers/CustomServiceProvider.php:36 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 19. /vendor/laravel/framework/src/Illuminate/View/View.php:120 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91 21. view::6042c9820065872ec605a4239418a9b9b9be7fab:2281

select * from `settings` where `title` = 'FOOTER_SCRIPT' and `settings`.`deleted_at` is null limit 1

200μs/app/Providers/CustomServiceProvider.php:37staging

Metadata
Bindings	0. FOOTER_SCRIPT
Backtrace	15. /app/Providers/CustomServiceProvider.php:37 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 19. /vendor/laravel/framework/src/Illuminate/View/View.php:120 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91 21. view::6042c9820065872ec605a4239418a9b9b9be7fab:2281

select * from `settings` where `title` = 'SECOND_BODY_SCRIPT' and `settings`.`deleted_at` is null limit 1

190μs/app/Providers/CustomServiceProvider.php:38staging

Metadata
Bindings	0. SECOND_BODY_SCRIPT
Backtrace	15. /app/Providers/CustomServiceProvider.php:38 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 19. /vendor/laravel/framework/src/Illuminate/View/View.php:120 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91 21. view::6042c9820065872ec605a4239418a9b9b9be7fab:2281

select * from `settings` where `title` = 'FACEBOOK_LINK' and `settings`.`deleted_at` is null limit 1

220μs/app/Providers/CustomServiceProvider.php:39staging

Metadata
Bindings	0. FACEBOOK_LINK
Backtrace	15. /app/Providers/CustomServiceProvider.php:39 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 19. /vendor/laravel/framework/src/Illuminate/View/View.php:120 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91 21. view::6042c9820065872ec605a4239418a9b9b9be7fab:2281

select * from `settings` where `title` = 'LINKEDIN' and `settings`.`deleted_at` is null limit 1

190μs/app/Providers/CustomServiceProvider.php:40staging

Metadata
Bindings	0. LINKEDIN
Backtrace	15. /app/Providers/CustomServiceProvider.php:40 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 19. /vendor/laravel/framework/src/Illuminate/View/View.php:120 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91 21. view::6042c9820065872ec605a4239418a9b9b9be7fab:2281

select * from `settings` where `title` = 'GOOGLE' and `settings`.`deleted_at` is null limit 1

200μs/app/Providers/CustomServiceProvider.php:41staging

Metadata
Bindings	0. GOOGLE
Backtrace	15. /app/Providers/CustomServiceProvider.php:41 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 19. /vendor/laravel/framework/src/Illuminate/View/View.php:120 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91 21. view::6042c9820065872ec605a4239418a9b9b9be7fab:2281

select * from `settings` where `title` = 'TWITTER_LINK' and `settings`.`deleted_at` is null limit 1

190μs/app/Providers/CustomServiceProvider.php:42staging

Metadata
Bindings	0. TWITTER_LINK
Backtrace	15. /app/Providers/CustomServiceProvider.php:42 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 19. /vendor/laravel/framework/src/Illuminate/View/View.php:120 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91 21. view::6042c9820065872ec605a4239418a9b9b9be7fab:2281

select * from `settings` where `title` = 'INSTAGRAM' and `settings`.`deleted_at` is null limit 1

190μs/app/Providers/CustomServiceProvider.php:43staging

Metadata
Bindings	0. INSTAGRAM
Backtrace	15. /app/Providers/CustomServiceProvider.php:43 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 19. /vendor/laravel/framework/src/Illuminate/View/View.php:120 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91 21. view::6042c9820065872ec605a4239418a9b9b9be7fab:2281

select * from `settings` where `title` = 'PINTEREST' and `settings`.`deleted_at` is null limit 1

190μs/app/Providers/CustomServiceProvider.php:44staging

Metadata
Bindings	0. PINTEREST
Backtrace	15. /app/Providers/CustomServiceProvider.php:44 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 19. /vendor/laravel/framework/src/Illuminate/View/View.php:120 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91 21. view::6042c9820065872ec605a4239418a9b9b9be7fab:2281

select * from `site_category` where `status` = '1' and `site_category`.`deleted_at` is null

770μs/app/Providers/CustomServiceProvider.php:45staging

Metadata
Bindings	0. 1
Backtrace	14. /app/Providers/CustomServiceProvider.php:45 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 18. /vendor/laravel/framework/src/Illuminate/View/View.php:120 19. /vendor/laravel/framework/src/Illuminate/View/View.php:91 20. view::6042c9820065872ec605a4239418a9b9b9be7fab:2281

select * from `advertisements` where `title` = 'FOOTER_AD' and `advertisements`.`deleted_at` is null limit 1

210μs/app/Providers/CustomServiceProvider.php:46staging

Metadata
Bindings	0. FOOTER_AD
Backtrace	15. /app/Providers/CustomServiceProvider.php:46 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 19. /vendor/laravel/framework/src/Illuminate/View/View.php:120 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91 21. view::6042c9820065872ec605a4239418a9b9b9be7fab:2281

select * from `filters` where `slug` = 'traffic-requirement' and `status` = 1 and `filters`.`deleted_at` is null limit 1

320μs/app/Providers/CustomServiceProvider.php:49staging

Metadata
Bindings	0. traffic-requirement 1. 1
Backtrace	15. /app/Providers/CustomServiceProvider.php:49 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 19. /vendor/laravel/framework/src/Illuminate/View/View.php:120 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91 21. view::6042c9820065872ec605a4239418a9b9b9be7fab:2281

select * from `filter_values` where `filter_id` = 1 and `filter_values`.`deleted_at` is null

340μs/app/Providers/CustomServiceProvider.php:52staging

Metadata
Bindings	0. 1
Backtrace	14. /app/Providers/CustomServiceProvider.php:52 17. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 18. /vendor/laravel/framework/src/Illuminate/View/View.php:120 19. /vendor/laravel/framework/src/Illuminate/View/View.php:91 20. view::6042c9820065872ec605a4239418a9b9b9be7fab:2281

select * from `settings` where `title` = 'COMPANY_EMAIL' and `settings`.`deleted_at` is null limit 1

210μs/app/Providers/ViewComposerServiceProvider.php:22staging

Metadata
Bindings	0. COMPANY_EMAIL
Backtrace	15. /app/Providers/ViewComposerServiceProvider.php:22 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 19. /vendor/laravel/framework/src/Illuminate/View/View.php:120 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91 21. view::6042c9820065872ec605a4239418a9b9b9be7fab:2281

select * from `settings` where `title` = 'COMPANY_ADDRESS' and `settings`.`deleted_at` is null limit 1

200μs/app/Providers/ViewComposerServiceProvider.php:26staging

Metadata
Bindings	0. COMPANY_ADDRESS
Backtrace	15. /app/Providers/ViewComposerServiceProvider.php:26 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 19. /vendor/laravel/framework/src/Illuminate/View/View.php:120 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91 21. view::6042c9820065872ec605a4239418a9b9b9be7fab:2281

select * from `settings` where `title` = 'COMPANY_PHONE_NUMBER' and `settings`.`deleted_at` is null limit 1

200μs/app/Providers/ViewComposerServiceProvider.php:30staging

Metadata
Bindings	0. COMPANY_PHONE_NUMBER
Backtrace	15. /app/Providers/ViewComposerServiceProvider.php:30 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 19. /vendor/laravel/framework/src/Illuminate/View/View.php:120 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91 21. view::6042c9820065872ec605a4239418a9b9b9be7fab:2281

select * from `settings` where `title` = 'TWITTER_LINK' and `settings`.`deleted_at` is null limit 1

190μs/app/Providers/ViewComposerServiceProvider.php:34staging

Metadata
Bindings	0. TWITTER_LINK
Backtrace	15. /app/Providers/ViewComposerServiceProvider.php:34 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 19. /vendor/laravel/framework/src/Illuminate/View/View.php:120 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91 21. view::6042c9820065872ec605a4239418a9b9b9be7fab:2281

select * from `settings` where `title` = 'FACEBOOK_LINK' and `settings`.`deleted_at` is null limit 1

210μs/app/Providers/ViewComposerServiceProvider.php:38staging

Metadata
Bindings	0. FACEBOOK_LINK
Backtrace	15. /app/Providers/ViewComposerServiceProvider.php:38 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 19. /vendor/laravel/framework/src/Illuminate/View/View.php:120 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91 21. view::6042c9820065872ec605a4239418a9b9b9be7fab:2281

select * from `settings` where `title` = 'YOUTUBE_LINK' and `settings`.`deleted_at` is null limit 1

200μs/app/Providers/ViewComposerServiceProvider.php:42staging

Metadata
Bindings	0. YOUTUBE_LINK
Backtrace	15. /app/Providers/ViewComposerServiceProvider.php:42 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 19. /vendor/laravel/framework/src/Illuminate/View/View.php:120 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91 21. view::6042c9820065872ec605a4239418a9b9b9be7fab:2281

select * from `settings` where `title` = 'HEADER_COMPANY_LOGO' and `settings`.`deleted_at` is null limit 1

210μs/app/Providers/ViewComposerServiceProvider.php:46staging

Metadata
Bindings	0. HEADER_COMPANY_LOGO
Backtrace	15. /app/Providers/ViewComposerServiceProvider.php:46 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 19. /vendor/laravel/framework/src/Illuminate/View/View.php:120 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91 21. view::6042c9820065872ec605a4239418a9b9b9be7fab:2281

select * from `settings` where `title` = 'FOOTER_COMPANY_LOGO' and `settings`.`deleted_at` is null limit 1

190μs/app/Providers/ViewComposerServiceProvider.php:50staging

Metadata
Bindings	0. FOOTER_COMPANY_LOGO
Backtrace	15. /app/Providers/ViewComposerServiceProvider.php:50 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 19. /vendor/laravel/framework/src/Illuminate/View/View.php:120 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91 21. view::6042c9820065872ec605a4239418a9b9b9be7fab:2281

select * from `settings` where `title` = 'FOOTER_COPYRIGHT_TEXT' and `settings`.`deleted_at` is null limit 1

250μs/app/Providers/ViewComposerServiceProvider.php:54staging

Metadata
Bindings	0. FOOTER_COPYRIGHT_TEXT
Backtrace	15. /app/Providers/ViewComposerServiceProvider.php:54 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 19. /vendor/laravel/framework/src/Illuminate/View/View.php:120 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91 21. view::6042c9820065872ec605a4239418a9b9b9be7fab:2281

select * from `settings` where `title` = 'FOOTER_CONTACT_DETAIL' and `settings`.`deleted_at` is null limit 1

200μs/app/Providers/ViewComposerServiceProvider.php:58staging

Metadata
Bindings	0. FOOTER_CONTACT_DETAIL
Backtrace	15. /app/Providers/ViewComposerServiceProvider.php:58 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:177 19. /vendor/laravel/framework/src/Illuminate/View/View.php:120 20. /vendor/laravel/framework/src/Illuminate/View/View.php:91 21. view::6042c9820065872ec605a4239418a9b9b9be7fab:2281

App\Models\SiteCategory: 25
App\Models\Country: 153
App\Models\SoftwareFavourite: 13
App\Models\Reviews: 15
App\Models\Setting: 18
App\Models\SubCategory: 43
App\Models\Category: 11
App\Models\Advertise: 3
App\Models\ThumbnailImage: 19
App\Models\Blog: 9
App\Models\Faq: 3
App\Models\FiltersValues: 12
App\Models\Filters: 2
App\Models\AdtechFeature: 3
App\Models\Admin: 14
App\Models\Softwares: 15

_token: dhhySmV49nOVvmTURYnGo5ehJDlSncjmG0UGI1ZZ
_previous: array:1 [ "url" => "https://staging.publishergrowth.com/software/pepperjam" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/software/pepperjam

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:24 [▼
  "content-length" => array:1 [▶
    0 => "0"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "host" => array:1 [▶
    0 => "staging.publishergrowth.com"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "cf-visitor" => array:1 [▶
    0 => "{"scheme":"https"}"
  ]
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "216.73.216.101"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "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"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "cf-ray" => array:1 [▶
    0 => "97cac9d23d11c959-ORD"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, br"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "216.73.216.101"
  ]
]

request_server

  0 of 0   
array:62 [▼
  "PHP_FCGI_MAX_REQUESTS" => "99999"
  "PHPRC" => "/home/staging/fcgi-bin/../etc/php7.4"
  "PWD" => "/home/staging/fcgi-bin"
  "SHLVL" => "0"
  "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin"
  "CONTENT_LENGTH" => "0"
  "SCRIPT_NAME" => "/index.php"
  "REQUEST_URI" => "/software/pepperjam"
  "QUERY_STRING" => ""
  "REQUEST_METHOD" => "GET"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "REDIRECT_URL" => "/software/pepperjam"
  "REMOTE_PORT" => "22536"
  "SCRIPT_FILENAME" => "/home/staging/public_html/public/index.php"
  "SERVER_ADMIN" => "[no address given]"
  "CONTEXT_DOCUMENT_ROOT" => "/home/staging/public_html/public"
  "CONTEXT_PREFIX" => ""
  "REQUEST_SCHEME" => "https"
  "DOCUMENT_ROOT" => "/home/staging/public_html/public"
  "REMOTE_ADDR" => "172.69.58.52"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "192.168.69.69"
  "SERVER_NAME" => "staging.publishergrowth.com"
  "SERVER_SOFTWARE" => "Apache"
  "SERVER_SIGNATURE" => ""
  "HTTP_CONNECTION" => "close"
  "HTTP_HOST" => "staging.publishergrowth.com"
  "HTTP_X_FORWARDED_PROTO" => "https"
  "HTTP_CF_VISITOR" => "{"scheme":"https"}"
  "HTTP_CF_IPCOUNTRY" => "US"
  "HTTP_CF_CONNECTING_IP" => "216.73.216.101"
  "HTTP_CDN_LOOP" => "cloudflare; loops=1"
  "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_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_CF_RAY" => "97cac9d23d11c959-ORD"
  "HTTP_ACCEPT_ENCODING" => "gzip, br"
  "HTTP_PRIORITY" => "u=0, i"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_X_FORWARDED_FOR" => "216.73.216.101"
  "SSL_TLS_SNI" => "staging.publishergrowth.com"
  "HTTPS" => "on"
  "SCRIPT_URI" => "https://staging.publishergrowth.com/software/pepperjam"
  "SCRIPT_URL" => "/software/pepperjam"
  "REDIRECT_STATUS" => "200"
  "REDIRECT_SSL_TLS_SNI" => "staging.publishergrowth.com"
  "REDIRECT_HTTPS" => "on"
  "REDIRECT_SCRIPT_URI" => "https://staging.publishergrowth.com/software/pepperjam"
  "REDIRECT_SCRIPT_URL" => "/software/pepperjam"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1757463928.9783
  "REQUEST_TIME" => 1757463928
]

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, 10 Sep 2025 00:25:29 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjRiRHpQKzBDOVBiRWxnenBTTXFnOWc9PSIsInZhbHVlIjoibW1WaGhlTTQwemRSOFRVYlRDWWEwTTV2a043N1hvaERncGxZMlpYZEtpczU5UVgyTkNRN0hRM3dzd3h0WkxiY2ZDUVF4d3E0b2xlSm5peU9tb2pqL1ZRQmxJVlE1SFZka3pHdlpwbVRYQVNkK1pWcDFBaTBkRWRRQlFTUmtZSTEiLCJtYWMiOiIwOTQ4ZGFlZWFkMTZjODg0MDc5NWVjZGViZWU0MTM2MjRmYWI3NTQ1NzBhZjVhZWFhZmVlNjcwNzk3NDAyZWI4IiwidGFnIjoiIn0%3D; expires=Wed, 10-Sep-2025 02:25:29 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjRiRHpQKzBDOVBiRWxnenBTTXFnOWc9PSIsInZhbHVlIjoibW1WaGhlTTQwemRSOFRVYlRDWWEwTTV2a043N1hvaERncGxZMlpYZEtpczU5UVgyTkNRN0hRM3dzd3h0WkxiY2ZDUVF4d ▶"
    1 => "staging_publisher_growth_session=eyJpdiI6IkJ3L1h4VnJVZzgxZG94WUVmekZHU1E9PSIsInZhbHVlIjoiZXVJZHZoVzNucEUrZlVBT1NEQzAxWnA4ZUhweXFpN1BRZC9peE85SkJLSnIzbnl6RThMMnI4UkE3RTNSMkVSODdPUWZkTVVuU2VSaG91eEJDYWRFR0d4akNWaExTZTROY3hsRVZqZU12VVNGYnppUk5PR0RVT0FDWUxSa0ozdlUiLCJtYWMiOiJlNTkzZjdkNzZiNWRkYzliZmE5Njk1NTE3MzFjNDc4YThkZmY1ZDM0MmE0MDE2NTg2MDRkNGFkZDZiYzQxZGZjIiwidGFnIjoiIn0%3D; expires=Wed, 10-Sep-2025 02:25:29 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀staging_publisher_growth_session=eyJpdiI6IkJ3L1h4VnJVZzgxZG94WUVmekZHU1E9PSIsInZhbHVlIjoiZXVJZHZoVzNucEUrZlVBT1NEQzAxWnA4ZUhweXFpN1BRZC9peE85SkJLSnIzbnl6RThMMnI ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjRiRHpQKzBDOVBiRWxnenBTTXFnOWc9PSIsInZhbHVlIjoibW1WaGhlTTQwemRSOFRVYlRDWWEwTTV2a043N1hvaERncGxZMlpYZEtpczU5UVgyTkNRN0hRM3dzd3h0WkxiY2ZDUVF4d3E0b2xlSm5peU9tb2pqL1ZRQmxJVlE1SFZka3pHdlpwbVRYQVNkK1pWcDFBaTBkRWRRQlFTUmtZSTEiLCJtYWMiOiIwOTQ4ZGFlZWFkMTZjODg0MDc5NWVjZGViZWU0MTM2MjRmYWI3NTQ1NzBhZjVhZWFhZmVlNjcwNzk3NDAyZWI4IiwidGFnIjoiIn0%3D; expires=Wed, 10-Sep-2025 02:25:29 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjRiRHpQKzBDOVBiRWxnenBTTXFnOWc9PSIsInZhbHVlIjoibW1WaGhlTTQwemRSOFRVYlRDWWEwTTV2a043N1hvaERncGxZMlpYZEtpczU5UVgyTkNRN0hRM3dzd3h0WkxiY2ZDUVF4d ▶"
    1 => "staging_publisher_growth_session=eyJpdiI6IkJ3L1h4VnJVZzgxZG94WUVmekZHU1E9PSIsInZhbHVlIjoiZXVJZHZoVzNucEUrZlVBT1NEQzAxWnA4ZUhweXFpN1BRZC9peE85SkJLSnIzbnl6RThMMnI4UkE3RTNSMkVSODdPUWZkTVVuU2VSaG91eEJDYWRFR0d4akNWaExTZTROY3hsRVZqZU12VVNGYnppUk5PR0RVT0FDWUxSa0ozdlUiLCJtYWMiOiJlNTkzZjdkNzZiNWRkYzliZmE5Njk1NTE3MzFjNDc4YThkZmY1ZDM0MmE0MDE2NTg2MDRkNGFkZDZiYzQxZGZjIiwidGFnIjoiIn0%3D; expires=Wed, 10-Sep-2025 02:25:29 GMT; path=/; httponly ◀staging_publisher_growth_session=eyJpdiI6IkJ3L1h4VnJVZzgxZG94WUVmekZHU1E9PSIsInZhbHVlIjoiZXVJZHZoVzNucEUrZlVBT1NEQzAxWnA4ZUhweXFpN1BRZC9peE85SkJLSnIzbnl6RThMMnI ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "dhhySmV49nOVvmTURYnGo5ehJDlSncjmG0UGI1ZZ"
  "_previous" => array:1 [▶
    "url" => "https://staging.publishergrowth.com/software/pepperjam"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

1 x Application (87.53%)	193ms
1 x Booting (12.47%)	27.55ms