Piwik PRO

Name: Piwik PRO
Rating: 0 (0 reviews)

0.0

Piwik PRO is a software that helps publishers comply with privacy laws, data governance laws, and consent management.

Visit Website Request A Site Audit Add Review

Description
Images
Features and Capabilities
Key Facts
Pricing
Products
Faqs

Piwik PRO Description

Piwik PRO is a privacy-compliant consent management software that helps publishers to better respect their audience's data. Its consent management solution allows website visitors to give and withdraw consent for the collection and use of their personal data. This ensures that publishers are in compliance with privacy laws and that users are fully informed about the data collection and usage on the website. Additionally, Piwik PRO provides advanced data governance features, giving publishers full control over their data and ensuring that they can manage it in a legal manner.

Piwik PRO Software Images

Piwik PRO

Piwik PRO Products

There are several products offered by Piwik Pro. Some of them are-

Consent Manager- Piwik Pro helps publishers remain transparent with their audience. It offers easy and transparent consent collection. You can also customize consent forms to match your website's aesthetic.
Web Analytics- Piwik Pro helps you understand your customer's entire buyer journey using data. This helps you better understand your audience and their experiences on your site.
Tag Manager- Piwik PRO Tag Manager lets publishers control all the details of data collection and activation in a streamlined way.
Customer Data Platform- This product allows you to segment customer data and thus give your audience a personalized experience.

Piwik PRO Features and Capabilities

Piwik Pro has several features and solutions, including-

Analytics- There are several analytical solutions offered by Piwik Pro. These include analytics for web and mobile, analytics for product teams, and SharePoint analytics.
Data Activation- This solution allows publishers like you to collect data regarding their customers to understand their audience better. These insights allow you to make data-driven choices.
Privacy Compliance-This solution helps publishers like you comply with privacy laws like GDPR and CCPA. This helps build trust with your audience and avoid heavy fines.
Tag Management-This solution allows you to create, test and deploy tags from customizable templates with ease. You can coordinate tag behaviour with Analytics, Customer Data Platform and Consent Manager to fit any data collection approach offered by Piwik Pro.

Piwik PRO Review: Key Facts

Here are some key facts about Piwik Pro-

Piwik PRO has been recognized as a leader in the web analytics industry by G2, TrustRadius, and other reputable software review platforms.
The European Commission is one Piwik Pro's clients.
Piwik Pro was awarded the academic Ocean award.

Piwik PRO Pricing

Piwik PRO has two sets of plans, which are the web and product analytics plan and the intranet analytics plan. You can get a custom quote for the intranet analytics plan as well as the enterprise product in the web and product analytics plan. There is, however, a basic plan for web and product analytics, which is free.

Want to know more about Piwik PRO

Visit Website

Piwik PRO Alternatives

Onetrust

View Profile

Datagrail.io

View Profile

Monsido

View Profile

Piwik PRO FAQs

Yes, Piwik PRO is GDPR compliant. GDPR is a law that governs the data of European nationals. It also helps publishers comply with the GDPR.

View Profile Apply Now

View Profile Apply Now

Messages Timeline Exceptions Views4 Route Queries135 Models354 Mails Gate Session Request

7.4.33282ms10MBGET software/{slug}

Booting (24.69ms)
Application (257ms)
1 x Application (91.24%)
257ms
1 x Booting (8.76%)
24.69ms

4 templates were rendered

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


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

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

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


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

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

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


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

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

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


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

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

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

135 statements were executed, 41 of which were duplicated, 94 unique190ms

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

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

Metadata
Bindings	0. piwik-pro 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.02ms/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 (282) and `reviews`.`deleted_at` is null

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

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

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

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

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

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

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

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

10.2ms/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` = 1442 limit 1

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

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

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

Metadata
Bindings	0. 282
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 `thumbnail_images` where `thumbnail_images`.`id` in (703)

830μs/app/Http/Controllers/Front/SoftwaresController.php:2747staging

Metadata
Backtrace	19. /app/Http/Controllers/Front/SoftwaresController.php:2747 20. /app/Http/Controllers/Front/SoftwaresController.php:723 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 `advertisements` where `title` in ('ADVERTISEMENT_ONE', 'ADVERTISEMENT_TWO', 'SOFTWAREPROFILESIDEBAR_AD3', 'SOFTWAREPROFILESIDEBAR_AD4', 'ADVERTISEMENT_INSTALLATION') and `status` = '1' and `advertisements`.`deleted_at` is null

720μs/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` = 'piwik-pro' and `status` = '1') and `softwares`.`deleted_at` is null limit 1

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

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

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

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

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

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

Metadata
Bindings	0. 172.70.126.185 1. 282
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 (282, '172.70.126.185', '2025-05-07 09:45:03', '2025-05-07 09:45:03')

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

Metadata
Bindings	0. 282 1. 172.70.126.185 2. 2025-05-07 09:45:03 3. 2025-05-07 09:45:03
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` = 282) and `software_favourites`.`deleted_at` is null

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Metadata
Bindings	0. 282 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 ('datagrail.io', 'onetrust', 'monsido') and `status` = '1' and `softwares`.`deleted_at` is null

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

Metadata
Bindings	0. datagrail.io 1. onetrust 2. monsido 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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Metadata
Bindings	0. 136
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.52ms/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)

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

320μsview::6042c9820065872ec605a4239418a9b9b9be7fab:1055staging

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

340μ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 `categories` where `type_slug` = 'ad-tech' and `status` = '1' and `categories`.`deleted_at` is null

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

400μ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\SoftwareImage: 1
App\Models\ThumbnailImage: 19
App\Models\Blog: 9
App\Models\Faq: 2
App\Models\FiltersValues: 12
App\Models\Filters: 2
App\Models\Admin: 13
App\Models\Softwares: 15

_token: VbSCZcyCzFPRB6Y6ImiAFtmMhmGBMqQEwMmJOTx8
_previous: array:1 [ "url" => "https://staging.publishergrowth.com/software/piwik-pro" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/software/piwik-pro

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 => "18.224.15.154"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "18.224.15.154"
  ]
  "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 => "93bde4da0e4deacc-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/piwik-pro"
  "QUERY_STRING" => ""
  "REQUEST_METHOD" => "GET"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "REDIRECT_URL" => "/software/piwik-pro"
  "REMOTE_PORT" => "14584"
  "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.126.185"
  "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" => "18.224.15.154"
  "HTTP_CDN_LOOP" => "cloudflare; loops=1"
  "HTTP_X_FORWARDED_PROTO" => "https"
  "HTTP_X_FORWARDED_FOR" => "18.224.15.154"
  "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" => "93bde4da0e4deacc-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/piwik-pro"
  "SCRIPT_URL" => "/software/piwik-pro"
  "REDIRECT_STATUS" => "200"
  "REDIRECT_SSL_TLS_SNI" => "staging.publishergrowth.com"
  "REDIRECT_HTTPS" => "on"
  "REDIRECT_SCRIPT_URI" => "https://staging.publishergrowth.com/software/piwik-pro"
  "REDIRECT_SCRIPT_URL" => "/software/piwik-pro"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1746591303.0301
  "REQUEST_TIME" => 1746591303
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Wed, 07 May 2025 04:15:03 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im55ZE1Ib0JTSUJjbDFzSXJzVzlwZlE9PSIsInZhbHVlIjoiSTNScnN6RVZ5Vlh3NnJ6S0dsK0s1Q0lIaHduRVJLZGlGMkxob1FwVHNET1pUQnJOOUpoc0tydGVOS2NSbTMxR3VlTnV6b0dwR2NFYVhIRlVLSVIvM3hYKytOamg0clR6RmMyTHEyV2dGNUhFRUxGc2tRb1M0Zkdub2t2UlJWbEsiLCJtYWMiOiI4ZTJkNzQ5NDVkYzIwYzlmMThjZmRhOGZmZDk3NDA4MTg0MTkwY2QxODAxOWM0OTQ3ZjBiYTRjZTQ3MDIxYTU4IiwidGFnIjoiIn0%3D; expires=Wed, 07-May-2025 06:15:03 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Im55ZE1Ib0JTSUJjbDFzSXJzVzlwZlE9PSIsInZhbHVlIjoiSTNScnN6RVZ5Vlh3NnJ6S0dsK0s1Q0lIaHduRVJLZGlGMkxob1FwVHNET1pUQnJOOUpoc0tydGVOS2NSbTMxR3VlTnV6b ▶"
    1 => "staging_publisher_growth_session=eyJpdiI6InJSQVFDV0gvdzE4SFhVRVVOaHhReVE9PSIsInZhbHVlIjoiMC9md056ak84dnpqOUpHYXBuMmVxcU5Wd1Nvcmp1bmN0OUdWWm83WnZTZmk5N1RveXRjcnYxUCszN1JPaGpwMjkyeGZ3cGpvNlhXdEpUaFZKQlNjUmloVjdwOUswZmoxUVFmN0RLL2R5SktsL0FDU3BIY2pXRVFSbXdramppWloiLCJtYWMiOiJlOGMzMTYwODJiN2YzM2IzNmFkN2U1NTc2NzhlMzUwZGM1ZjVhYTU2ZTYwNjgwZmMyYjBjNmZiMGEwNTIxODdmIiwidGFnIjoiIn0%3D; expires=Wed, 07-May-2025 06:15:03 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀staging_publisher_growth_session=eyJpdiI6InJSQVFDV0gvdzE4SFhVRVVOaHhReVE9PSIsInZhbHVlIjoiMC9md056ak84dnpqOUpHYXBuMmVxcU5Wd1Nvcmp1bmN0OUdWWm83WnZTZmk5N1RveXRjcnY ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im55ZE1Ib0JTSUJjbDFzSXJzVzlwZlE9PSIsInZhbHVlIjoiSTNScnN6RVZ5Vlh3NnJ6S0dsK0s1Q0lIaHduRVJLZGlGMkxob1FwVHNET1pUQnJOOUpoc0tydGVOS2NSbTMxR3VlTnV6b0dwR2NFYVhIRlVLSVIvM3hYKytOamg0clR6RmMyTHEyV2dGNUhFRUxGc2tRb1M0Zkdub2t2UlJWbEsiLCJtYWMiOiI4ZTJkNzQ5NDVkYzIwYzlmMThjZmRhOGZmZDk3NDA4MTg0MTkwY2QxODAxOWM0OTQ3ZjBiYTRjZTQ3MDIxYTU4IiwidGFnIjoiIn0%3D; expires=Wed, 07-May-2025 06:15:03 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Im55ZE1Ib0JTSUJjbDFzSXJzVzlwZlE9PSIsInZhbHVlIjoiSTNScnN6RVZ5Vlh3NnJ6S0dsK0s1Q0lIaHduRVJLZGlGMkxob1FwVHNET1pUQnJOOUpoc0tydGVOS2NSbTMxR3VlTnV6b ▶"
    1 => "staging_publisher_growth_session=eyJpdiI6InJSQVFDV0gvdzE4SFhVRVVOaHhReVE9PSIsInZhbHVlIjoiMC9md056ak84dnpqOUpHYXBuMmVxcU5Wd1Nvcmp1bmN0OUdWWm83WnZTZmk5N1RveXRjcnYxUCszN1JPaGpwMjkyeGZ3cGpvNlhXdEpUaFZKQlNjUmloVjdwOUswZmoxUVFmN0RLL2R5SktsL0FDU3BIY2pXRVFSbXdramppWloiLCJtYWMiOiJlOGMzMTYwODJiN2YzM2IzNmFkN2U1NTc2NzhlMzUwZGM1ZjVhYTU2ZTYwNjgwZmMyYjBjNmZiMGEwNTIxODdmIiwidGFnIjoiIn0%3D; expires=Wed, 07-May-2025 06:15:03 GMT; path=/; httponly ◀staging_publisher_growth_session=eyJpdiI6InJSQVFDV0gvdzE4SFhVRVVOaHhReVE9PSIsInZhbHVlIjoiMC9md056ak84dnpqOUpHYXBuMmVxcU5Wd1Nvcmp1bmN0OUdWWm83WnZTZmk5N1RveXRjcnY ▶"
  ]
]

session_attributes

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

1 x Application (91.24%)	257ms
1 x Booting (8.76%)	24.69ms