Admailr

Name: Admailr
Rating: 0 (0 reviews)

0.0

Admailr is a proprietary technology that helps publishers earn while sending mails.

Visit Website Request A Site Audit Add Review

Description
Features and Capabilities
Payment Info
Faqs

Admailr Description

Admailr is a proprietary technology that allows publishers to list owners to monetize their list by placing ads on their current publications. It helps publishers constantly mail newsletters with good content while reducing costs. It puts publishers in 100% control of what is displayed on their mails and provides real-time reporting of their income.

Admailr Software Images

Admailr Features and Capabilities

Increased credibility: Helps bring credibility to the newsletter with premium ads.
Increase content value: Helps maximize the value of your content.
Utilize space: Helps use the unused real estate space.
Increase follower value: Maximize the value of your followers.

Admailr Payment Info

Publishers are paid on a net 30-day basis, and their account is paid each month automatically on the 20th of the month.

Want to know more about Admailr

Visit Website

Admailr Alternatives

Paved

View Profile

Passendo

View Profile

Admailr FAQs

Publishers have to fill out the proper forms and select the payment option they decide is best for them. Publishers will get paid once a month, and they can follow this in their panel.

Each ad gets paid differently. They will post the most optimal ad to get you the highest payout possible on each click.

Normally it takes 24 hours to be approved but it might take longer.

Publishers do not necessarily need a site but its a good idea to have your content stored somewhere.

Admailr is currently globally available.

View Profile Apply Now

Messages Timeline Exceptions Views4 Route Queries129 Models354 Mails Gate Session Request

7.4.33236ms10MBGET software/{slug}

Booting (28.45ms)
Application (207ms)
1 x Application (87.92%)
207ms
1 x Booting (12.08%)
28.45ms

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)88blade


__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
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	`t`
84	`userFavourite`
85	`totalOtherRating`
86	`b`
87	`advertisements`

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


__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
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	`t`
87	`userFavourite`
88	`totalOtherRating`
89	`b`
90	`fea_cat`
91	`ad_categories`
92	`host_categories`
93	`marketing_categories`
94	`countries`
95	`body_script`
96	`head_script`
97	`footer_script`
98	`second_body_script`
99	`site_category`
100	`footer_ad`
101	`company_email`
102	`company_address`
103	`company_phone`
104	`twitter_link`
105	`facebook_link`
106	`youtube_link`
107	`header_logo`
108	`footer_logo`
109	`footer_copyright_text`
110	`footer_contact_detail`

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


__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
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	`t`
87	`userFavourite`
88	`totalOtherRating`
89	`b`
90	`fea_cat`
91	`ad_categories`
92	`host_categories`
93	`marketing_categories`
94	`countries`
95	`body_script`
96	`head_script`
97	`footer_script`
98	`second_body_script`
99	`site_category`
100	`footer_ad`
101	`company_email`
102	`company_address`
103	`company_phone`
104	`twitter_link`
105	`facebook_link`
106	`youtube_link`
107	`header_logo`
108	`footer_logo`
109	`footer_copyright_text`
110	`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

129 statements were executed, 41 of which were duplicated, 88 unique137ms

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

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

Metadata
Bindings	0. admailr 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

2.12ms/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 (186) and `reviews`.`deleted_at` is null

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

Metadata
Bindings	0. 186
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 `filters` where `slug` = 'traffic-requirement' and `status` = 1 and `filters`.`deleted_at` is null limit 1

1.64ms/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

1.26ms/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` = 186) and `faq`.`deleted_at` is null

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

Metadata
Bindings	0. 186
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

14.71ms/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` = 1004 limit 1

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

Metadata
Bindings	0. 1004
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` = 186) and `software_images`.`deleted_at` is null order by `id` asc

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

Metadata
Bindings	0. 186
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.16ms/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` = 'admailr' and `status` = '1') and `softwares`.`deleted_at` is null limit 1

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

Metadata
Bindings	0. admailr 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

810μ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 (186) and `reviews`.`deleted_at` is null

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

Metadata
Bindings	0. 186
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.70.127.227' and `software_id` = 186) and `software_view`.`deleted_at` is null limit 1

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

Metadata
Bindings	0. 172.70.127.227 1. 186
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 (186, '172.70.127.227', '2025-05-11 15:44:25', '2025-05-11 15:44:25')

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

Metadata
Bindings	0. 186 1. 172.70.127.227 2. 2025-05-11 15:44:25 3. 2025-05-11 15:44:25
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` = 186) and `software_favourites`.`deleted_at` is null

1.32ms/app/Http/Controllers/Front/SoftwaresController.php:755staging

Metadata
Bindings	0. 186
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` = 186) and `request_softwares`.`deleted_at` is null

1.2ms/app/Http/Controllers/Front/SoftwaresController.php:763staging

Metadata
Bindings	0. 186
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` = 186) and `software_recommendations`.`deleted_at` is null limit 1

1.1ms/app/Http/Controllers/Front/SoftwaresController.php:771staging

Metadata
Bindings	0. 186
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` = 186) and `software_recommendations`.`deleted_at` is null

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

Metadata
Bindings	0. 186
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` = 186 and `status` = '1') and `reviews`.`deleted_at` is null

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

Metadata
Bindings	0. 5 1. 186 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` = 186 and `status` = '1') and `reviews`.`deleted_at` is null

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

Metadata
Bindings	0. 2 1. 186 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` = 186 and `status` = '1') and `reviews`.`deleted_at` is null

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

Metadata
Bindings	0. 1 1. 186 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` = 186 and `status` = '1') and `reviews`.`deleted_at` is null

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

Metadata
Bindings	0. 4 1. 186 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` = 186 and `status` = '1') and `reviews`.`deleted_at` is null

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

Metadata
Bindings	0. 3 1. 186 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` = 186 and `status` = '1' and `review_type` is null) and `reviews`.`deleted_at` is null

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

Metadata
Bindings	0. 186 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 ('beehiv', 'paved', 'passendo') and `status` = '1' and `softwares`.`deleted_at` is null

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

Metadata
Bindings	0. beehiv 1. paved 2. passendo 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) and `admins`.`deleted_at` is null

590μ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` = 183 and `review_type` = '5' and `status` = '1') and `reviews`.`deleted_at` is null

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

Metadata
Bindings	0. 183 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` = 183) and `software_favourites`.`deleted_at` is null

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

Metadata
Bindings	0. 183
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` = 183) and `request_softwares`.`deleted_at` is null

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

Metadata
Bindings	0. 183
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` = 183) and `software_recommendations`.`deleted_at` is null limit 1

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

Metadata
Bindings	0. 183
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` = 183) and `software_recommendations`.`deleted_at` is null

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

Metadata
Bindings	0. 183
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` = 942 limit 1

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

Metadata
Bindings	0. 942
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` = 187 and `review_type` = '5' and `status` = '1') and `reviews`.`deleted_at` is null

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

Metadata
Bindings	0. 187 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` = 187) and `software_favourites`.`deleted_at` is null

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

Metadata
Bindings	0. 187
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` = 187) and `request_softwares`.`deleted_at` is null

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

Metadata
Bindings	0. 187
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` = 187) and `software_recommendations`.`deleted_at` is null limit 1

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

Metadata
Bindings	0. 187
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` = 187) and `software_recommendations`.`deleted_at` is null

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

Metadata
Bindings	0. 187
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` = 1439 limit 1

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

Metadata
Bindings	0. 1439
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` = '2' and `categories`.`deleted_at` is null limit 1

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

Metadata
Bindings	0. 2
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` = '22' and `subcategory`.`deleted_at` is null limit 1

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

Metadata
Bindings	0. 22
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.92ms/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)

420μ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` = '2' and `categories`.`deleted_at` is null limit 1

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

Metadata
Bindings	0. 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` = 2 and `status` = '1') and `subcategory`.`deleted_at` is null order by `subcategory_name` asc

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

Metadata
Bindings	0. 2 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` = 186 and `blog`.`deleted_at` is null order by `created_at` desc limit 4

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

Metadata
Bindings	0. 1 1. 186
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` = 186 and `status` = '1') and `alternatives`.`deleted_at` is null

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

Metadata
Bindings	0. 186 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

450μ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

920μs/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

250μ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

240μ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

240μ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

230μ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

250μ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

260μ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.63ms/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

420μ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

400μ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

270μ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

250μ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

310μ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

260μ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

250μ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

230μ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

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 (`software_id` = 23 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. 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

240μ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

290μ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

300μ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

240μ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

240μ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

210μ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

280μ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

240μ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

220μ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

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` = 48 and `review_type` = '5' and `status` = '1') and `reviews`.`deleted_at` is null

210μ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

210μ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

260μ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

220μ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

230μ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

230μ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

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 (`software_id` = 392 and `review_type` = '5' and `status` = '1') and `reviews`.`deleted_at` is null

220μ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

210μ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

250μ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

230μ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

210μ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

250μ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

220μ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

240μ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

260μ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` = 186 and `status` = '1') and `reviews`.`deleted_at` is null

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

Metadata
Bindings	0. 5 1. 186 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` = 186 and `status` = '1') and `reviews`.`deleted_at` is null

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

Metadata
Bindings	0. 1 1. 186 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` = 186 and `status` = '1') and `reviews`.`deleted_at` is null

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

Metadata
Bindings	0. 4 1. 186 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` = 186 and `status` = '1') and `reviews`.`deleted_at` is null

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

Metadata
Bindings	0. 3 1. 186 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` = 186 and `software_favourites`.`software_id` is not null and `software_favourites`.`deleted_at` is null

230μsview::6042c9820065872ec605a4239418a9b9b9be7fab:1055staging

Metadata
Bindings	0. 186
Backtrace	19. view::6042c9820065872ec605a4239418a9b9b9be7fab:1055 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

240μ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:1526

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

280μ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

310μ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:2221

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

310μ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:2221

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

280μ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:2221

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

1.5ms/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:2221

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

280μ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:2221

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

260μ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:2221

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

250μ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:2221

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

250μ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:2221

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

260μ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:2221

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

250μ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:2221

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

260μ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:2221

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

240μ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:2221

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

250μ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:2221

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

260μ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:2221

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

920μ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:2221

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

270μ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:2221

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

450μ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:2221

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

430μ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:2221

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

310μ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:2221

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

240μ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:2221

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

250μ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:2221

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

250μ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:2221

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

250μ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:2221

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

250μ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:2221

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

250μ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:2221

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

240μ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:2221

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:2221

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

230μ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:2221

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: 18
App\Models\Blog: 9
App\Models\Faq: 5
App\Models\FiltersValues: 12
App\Models\Filters: 2
App\Models\Admin: 13
App\Models\Softwares: 14

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

path_info

/software/admailr

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"
  ]
  "cf-visitor" => array:1 [▶
    0 => "{"scheme":"https"}"
  ]
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "3.133.130.192"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "3.133.130.192"
  ]
  "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 => "93e0e8c63bd6ead8-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"
  ]
  "host" => array:1 [▶
    0 => "staging.publishergrowth.com"
  ]
]

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"
  "HTTP_CONNECTION" => "close"
  "SCRIPT_NAME" => "/index.php"
  "REQUEST_URI" => "/software/admailr"
  "QUERY_STRING" => ""
  "REQUEST_METHOD" => "GET"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "REDIRECT_URL" => "/software/admailr"
  "REMOTE_PORT" => "19764"
  "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.70.127.227"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "192.168.69.69"
  "SERVER_NAME" => "staging.publishergrowth.com"
  "SERVER_SOFTWARE" => "Apache"
  "SERVER_SIGNATURE" => ""
  "HTTP_CF_VISITOR" => "{"scheme":"https"}"
  "HTTP_CF_IPCOUNTRY" => "US"
  "HTTP_CF_CONNECTING_IP" => "3.133.130.192"
  "HTTP_CDN_LOOP" => "cloudflare; loops=1"
  "HTTP_X_FORWARDED_PROTO" => "https"
  "HTTP_X_FORWARDED_FOR" => "3.133.130.192"
  "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" => "93e0e8c63bd6ead8-ORD"
  "HTTP_ACCEPT_ENCODING" => "gzip, br"
  "HTTP_PRIORITY" => "u=0, i"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_HOST" => "staging.publishergrowth.com"
  "SSL_TLS_SNI" => "staging.publishergrowth.com"
  "HTTPS" => "on"
  "SCRIPT_URI" => "https://staging.publishergrowth.com/software/admailr"
  "SCRIPT_URL" => "/software/admailr"
  "REDIRECT_STATUS" => "200"
  "REDIRECT_SSL_TLS_SNI" => "staging.publishergrowth.com"
  "REDIRECT_HTTPS" => "on"
  "REDIRECT_SCRIPT_URI" => "https://staging.publishergrowth.com/software/admailr"
  "REDIRECT_SCRIPT_URL" => "/software/admailr"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1746958465.3197
  "REQUEST_TIME" => 1746958465
]

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 => "Sun, 11 May 2025 10:14:25 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkxLY3ZhY3E5OU5mVTlVVWhQa2N5bXc9PSIsInZhbHVlIjoiT2tSQW1ZZmkzd1A2V2JIMDEvWGUvaTNDQXR6S3lRdXZsaFdvamFaNmQwU01XR3hFWkNEeUkwTm94MlVuazhOTjQzTHMrUWJiT1ZuVVhlY0o0eDRhTktONUY1WERidzFwNE5aZUtsUS9iRGduWFY3Wi91VkVVUGwrTG1PZ3RIYm4iLCJtYWMiOiJjMmFkNGVlMjRkMWU4NWUwMGMzZGQ2MmUzOTk1ZGUyMjAyZjk1MjJjMmFlMjE5MWU4ZWU4ZjZhNmVjNTQ5NDdiIiwidGFnIjoiIn0%3D; expires=Sun, 11-May-2025 12:14:25 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IkxLY3ZhY3E5OU5mVTlVVWhQa2N5bXc9PSIsInZhbHVlIjoiT2tSQW1ZZmkzd1A2V2JIMDEvWGUvaTNDQXR6S3lRdXZsaFdvamFaNmQwU01XR3hFWkNEeUkwTm94MlVuazhOTjQzTHMrU ▶"
    1 => "staging_publisher_growth_session=eyJpdiI6ImNQNGRwMHdtUG9WOWJEZExYa3l3dUE9PSIsInZhbHVlIjoiSUZnVUFhN2xuMFhRUGVaOGlpaGJ0eTM2SDJmcnovaHNFNU9DbE9FaGdVQlNMeVdqVGNTTlh3VEg2d2ZVcmRPRHA3bFpzeWNrR1JxN2FjQlo0ZWs4b2NOMlFIaHNwcUFBUjVPUWFPS2tTdTgvbEVJREtnNmxBY2FrU0RQL2dYMVoiLCJtYWMiOiJkYTdkYjc4NTIwMjE1YzFiYmQ5MjkxNTEzNDEwODExZDI2MDg2YjIyY2FlYWFiZDFmNGE0YjA3NzY3MWUzYmFjIiwidGFnIjoiIn0%3D; expires=Sun, 11-May-2025 12:14:25 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀staging_publisher_growth_session=eyJpdiI6ImNQNGRwMHdtUG9WOWJEZExYa3l3dUE9PSIsInZhbHVlIjoiSUZnVUFhN2xuMFhRUGVaOGlpaGJ0eTM2SDJmcnovaHNFNU9DbE9FaGdVQlNMeVdqVGNTTlh ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkxLY3ZhY3E5OU5mVTlVVWhQa2N5bXc9PSIsInZhbHVlIjoiT2tSQW1ZZmkzd1A2V2JIMDEvWGUvaTNDQXR6S3lRdXZsaFdvamFaNmQwU01XR3hFWkNEeUkwTm94MlVuazhOTjQzTHMrUWJiT1ZuVVhlY0o0eDRhTktONUY1WERidzFwNE5aZUtsUS9iRGduWFY3Wi91VkVVUGwrTG1PZ3RIYm4iLCJtYWMiOiJjMmFkNGVlMjRkMWU4NWUwMGMzZGQ2MmUzOTk1ZGUyMjAyZjk1MjJjMmFlMjE5MWU4ZWU4ZjZhNmVjNTQ5NDdiIiwidGFnIjoiIn0%3D; expires=Sun, 11-May-2025 12:14:25 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkxLY3ZhY3E5OU5mVTlVVWhQa2N5bXc9PSIsInZhbHVlIjoiT2tSQW1ZZmkzd1A2V2JIMDEvWGUvaTNDQXR6S3lRdXZsaFdvamFaNmQwU01XR3hFWkNEeUkwTm94MlVuazhOTjQzTHMrU ▶"
    1 => "staging_publisher_growth_session=eyJpdiI6ImNQNGRwMHdtUG9WOWJEZExYa3l3dUE9PSIsInZhbHVlIjoiSUZnVUFhN2xuMFhRUGVaOGlpaGJ0eTM2SDJmcnovaHNFNU9DbE9FaGdVQlNMeVdqVGNTTlh3VEg2d2ZVcmRPRHA3bFpzeWNrR1JxN2FjQlo0ZWs4b2NOMlFIaHNwcUFBUjVPUWFPS2tTdTgvbEVJREtnNmxBY2FrU0RQL2dYMVoiLCJtYWMiOiJkYTdkYjc4NTIwMjE1YzFiYmQ5MjkxNTEzNDEwODExZDI2MDg2YjIyY2FlYWFiZDFmNGE0YjA3NzY3MWUzYmFjIiwidGFnIjoiIn0%3D; expires=Sun, 11-May-2025 12:14:25 GMT; path=/; httponly ◀staging_publisher_growth_session=eyJpdiI6ImNQNGRwMHdtUG9WOWJEZExYa3l3dUE9PSIsInZhbHVlIjoiSUZnVUFhN2xuMFhRUGVaOGlpaGJ0eTM2SDJmcnovaHNFNU9DbE9FaGdVQlNMeVdqVGNTTlh ▶"
  ]
]

session_attributes

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

1 x Application (87.92%)	207ms
1 x Booting (12.08%)	28.45ms