The Freelancer Club

Queries

0.0080

INSERT INTO `bf_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES ('86c6701f96f1f3cab0a138ced5017d04', '0.0.0.0', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 1732363715, '')

0.0005

SELECT * FROM (`bf_settings`)Speed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 70 - Extra:

0.0005

SELECT * FROM (`bf_permissions`)Speed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 147 - Extra:

0.0003

SELECT * FROM (`bf_shop_settings`) WHERE `code` = 'gift_cards'Speed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 39 - Extra: Using where

0.0005

SELECT * FROM (`bf_shop_categories`) WHERE `enabled` = 1 ORDER BY `sequence`, `name` ASCSpeed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 6 - Extra: Using where; Using filesort

0.0003

SELECT * FROM (`bf_banner`) WHERE `tag` = 'nonmem'Speed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 3 - Extra: Using where

0.0006

SELECT * FROM (`bf_portfolio`) WHERE `bf_portfolio`.`public` = 1 AND `bf_portfolio`.`authorised` = 1 AND `bf_portfolio`.`company_id` = 0 GROUP BY `bf_portfolio`.`id` ORDER BY `bf_portfolio`.`id` desc LIMIT 6Speed: 0.0006 - Possible keys: - Key Used: PRIMARY - Type: index - Rows: 6 - Extra: Using where

0.0013

SELECT `bf_blog`.*, `bf_blog_categories`.`hidden` FROM (`bf_blog`) LEFT JOIN `bf_blog_category_link` ON `bf_blog`.`id` = `bf_blog_category_link`.`blog_id` LEFT JOIN `bf_blog_categories` ON `category_id` =`bf_blog_categories`.`id` WHERE `published` = 1 AND `bf_blog_categories`.`hidden` = 0 AND `bf_blog`.`deleted` = 0 ORDER BY `published_on` DESC, `created_on` DESC LIMIT 4Speed: 0.0013 - Possible keys: PRIMARY - Key Used: - Type: ALL - Rows: 14 - Extra: Using where; Using temporary; Using filesort

0.0003

SELECT COUNT(*) AS `numrows` FROM (`bf_meetups`) WHERE `date` > '2024-11-23 00:00:00' AND `authorised` = 1Speed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 33 - Extra: Using where

0.0042

SELECT `bf_users`.*, (select sum(bf_portfolio.views) from bf_portfolio where bf_portfolio.user_id = bf_users.id) as views, `likes`, (select avg(stars) from bf_recommend where bf_recommend.user_Id = bf_users.id and authorised = 1) as stars, `bf_socialstats`.`twitter_followers`, `bf_socialstats`.`facebook_likes`, `bf_socialstats`.`youtube_subscribers`, `bf_socialstats`.`instagram` as instagram_count, `bf_socialstats`.`last_check` FROM (`bf_users`) LEFT OUTER JOIN `bf_socialstats` ON `bf_users`.`id` = `bf_socialstats`.`user_id` WHERE `slug` = 'teststep' AND `bf_users`.`deleted` = 0 AND `bf_users`.`banned` = 0 AND `bf_users`.`active` = 1 GROUP BY `bf_users`.`id`Speed: 0.0042 - Possible keys: - Key Used: - Type: ALL - Rows: 377 - Extra: Using where; Using temporary; Using filesort

0.0004

SELECT COUNT(*) AS `numrows` FROM (`bf_follows`) WHERE `user_id` = '173'Speed: 0.0004 - Possible keys: user_id,user_id_2 - Key Used: user_id - Type: ref - Rows: 1 - Extra: Using index

0.0002

SELECT COUNT(*) AS `numrows` FROM (`bf_follows`) WHERE `is_following` = '173'Speed: 0.0002 - Possible keys: - Key Used: user_id - Type: index - Rows: 88 - Extra: Using where; Using index

0.0005

SELECT * FROM (`bf_community_score_user`) WHERE `user_id` = '173' ORDER BY `created_on` desc LIMIT 1Speed: 0.0005 - Possible keys: user_id - Key Used: user_id - Type: ref - Rows: 1 - Extra: Using where; Using filesort

0.0003

SELECT `bf_recommend`.*, `bf_users`.`display_name` as review_name, `bf_users`.`discipline` FROM (`bf_recommend`) JOIN `bf_users` ON `bf_users`.`id` = `bf_recommend`.`reviewer_id` WHERE `authorised` = 1 AND `user_id` = '173' ORDER BY `id` desc LIMIT 5Speed: 0.0003 - Possible keys: - Key Used: PRIMARY - Type: index - Rows: 5 - Extra: Using where

0.0003

SELECT `bf_recommend`.*, `bf_users`.`display_name` as review_name, `bf_users`.`discipline` FROM (`bf_recommend`) JOIN `bf_users` ON `bf_users`.`id` = `bf_recommend`.`reviewer_id` WHERE `authorised` = 1 AND `user_id` = '173'Speed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 12 - Extra: Using where

0.0003

SELECT COUNT(*) AS `numrows` FROM (`bf_services`) WHERE `user_id` = '173'Speed: 0.0003 - Possible keys: - Key Used: - Type: ALL - Rows: 8 - Extra: Using where

0.0187

Total Query Execution Time

session_id	86c6701f96f1f3cab0a138ced5017d04
ip_address	0.0.0.0
user_agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
last_activity	1732363715
user_data

Files

application.php
/home/dev/application/config/application.php

autoload.php
/home/dev/application/config/autoload.php

constants.php
/home/dev/application/config/constants.php

config.php
/home/dev/application/config/development/config.php

database.php
/home/dev/application/config/development/database.php

events.php
/home/dev/application/config/events.php

mautic.php
/home/dev/application/config/mautic.php

mimes.php
/home/dev/application/config/mimes.php

profiler.php
/home/dev/application/config/profiler.php

routes.php
/home/dev/application/config/routes.php

user_agents.php
/home/dev/application/config/user_agents.php

Base_Controller.php
/home/dev/application/core/Base_Controller.php

Front_Controller.php
/home/dev/application/core/Front_Controller.php

Library_Controller.php
/home/dev/application/core/Library_Controller.php

MY_Lang.php
/home/dev/application/core/MY_Lang.php

MY_Loader.php
/home/dev/application/core/MY_Loader.php

MY_Model.php
/home/dev/application/core/MY_Model.php

MY_Router.php
/home/dev/application/core/MY_Router.php

MY_Security.php
/home/dev/application/core/MY_Security.php

MY_date_helper.php
/home/dev/application/helpers/MY_date_helper.php

MY_form_helper.php
/home/dev/application/helpers/MY_form_helper.php

MY_string_helper.php
/home/dev/application/helpers/MY_string_helper.php

MY_url_helper.php
/home/dev/application/helpers/MY_url_helper.php

connect_helper.php
/home/dev/application/helpers/connect_helper.php

freelancer_helper.php
/home/dev/application/helpers/freelancer_helper.php

application_lang.php
/home/dev/application/language/english/application_lang.php

ImageLib.php
/home/dev/application/libraries/ImageLib.php

MY_Form_validation.php
/home/dev/application/libraries/MY_Form_validation.php

Navmessage.php
/home/dev/application/libraries/Navmessage.php

Notifications.php
/home/dev/application/libraries/Notifications.php

Profiler.php
/home/dev/application/libraries/Profiler.php

Social.php
/home/dev/application/libraries/Social.php

freelancer.php
/home/dev/application/libraries/freelancer.php

stripe_load.php
/home/dev/application/libraries/stripe_load.php

cities_model.php
/home/dev/application/models/cities_model.php

sessions_model.php
/home/dev/application/models/sessions_model.php

banner_model.php
/home/dev/application/modules/banner/models/banner_model.php

billing_credit_model.php
/home/dev/application/modules/billing/models/billing_credit_model.php

billing_model.php
/home/dev/application/modules/billing/models/billing_model.php

renewals_model.php
/home/dev/application/modules/billing/models/renewals_model.php

blog_model.php
/home/dev/application/modules/blog/models/blog_model.php

company_model.php
/home/dev/application/modules/company/models/company_model.php

Device.php
/home/dev/application/modules/device/libraries/Device.php

DisciplinesHelper.php
/home/dev/application/modules/disciplines/helpers/DisciplinesHelper.php

disciplines_model.php
/home/dev/application/modules/disciplines/models/disciplines_model.php

company_follow_model.php
/home/dev/application/modules/follow/models/company_follow_model.php

follow_model.php
/home/dev/application/modules/follow/models/follow_model.php

digital_product_lang.php
/home/dev/application/modules/gocart/language/english/digital_product_lang.php

Go_cart.php
/home/dev/application/modules/gocart/libraries/Go_cart.php

category_model.php
/home/dev/application/modules/gocart/models/category_model.php

coupon_model.php
/home/dev/application/modules/gocart/models/coupon_model.php

digital_product_model.php
/home/dev/application/modules/gocart/models/digital_product_model.php

gift_card_model.php
/home/dev/application/modules/gocart/models/gift_card_model.php

shop_settings_model.php
/home/dev/application/modules/gocart/models/shop_settings_model.php

meetup_model.php
/home/dev/application/modules/meetup/models/meetup_model.php

messages_model.php
/home/dev/application/modules/messages/models/messages_model.php

people.php
/home/dev/application/modules/people/controllers/people.php

people_lang.php
/home/dev/application/modules/people/language/english/people_lang.php

list_item_model.php
/home/dev/application/modules/people/models/list_item_model.php

list_model.php
/home/dev/application/modules/people/models/list_model.php

notifications_model.php
/home/dev/application/modules/people/models/notifications_model.php

portfolio_comments_model.php
/home/dev/application/modules/people/models/portfolio_comments_model.php

portfolio_images_model.php
/home/dev/application/modules/people/models/portfolio_images_model.php

portfolio_likes_model.php
/home/dev/application/modules/people/models/portfolio_likes_model.php

portfolio_model.php
/home/dev/application/modules/people/models/portfolio_model.php

portfolios_model.php
/home/dev/application/modules/people/models/portfolios_model.php

recommend_model.php
/home/dev/application/modules/people/models/recommend_model.php

service_model.php
/home/dev/application/modules/people/models/service_model.php

socialstats_model.php
/home/dev/application/modules/people/models/socialstats_model.php

community_score_info.php
/home/dev/application/modules/people/views/blocks/community_score_info.php

profile_header.php
/home/dev/application/modules/people/views/blocks/profile_header.php

reviews.php
/home/dev/application/modules/people/views/reviews.php

reviews_js.php
/home/dev/application/modules/people/views/reviews_js.php

project_model.php
/home/dev/application/modules/projects/models/project_model.php

SkillsHelper.php
/home/dev/application/modules/skills/helpers/SkillsHelper.php

skill_model.php
/home/dev/application/modules/skills/models/skill_model.php

stripe_customers_model.php
/home/dev/application/modules/stripe/models/stripe_customers_model.php

users_lang.php
/home/dev/application/modules/users/language/english/users_lang.php

Auth.php
/home/dev/application/modules/users/libraries/Auth.php

Status.php
/home/dev/application/modules/users/libraries/Status.php

community_score_user_model.php
/home/dev/application/modules/users/models/community_score_user_model.php

people_model.php
/home/dev/application/modules/users/models/people_model.php

status_change_model.php
/home/dev/application/modules/users/models/status_change_model.php

user_block_model.php
/home/dev/application/modules/users/models/user_block_model.php

user_model.php
/home/dev/application/modules/users/models/user_model.php

Base.php
/home/dev/application/third_party/MX/Base.php

Config.php
/home/dev/application/third_party/MX/Config.php

Controller.php
/home/dev/application/third_party/MX/Controller.php

Lang.php
/home/dev/application/third_party/MX/Lang.php

Loader.php
/home/dev/application/third_party/MX/Loader.php

Modules.php
/home/dev/application/third_party/MX/Modules.php

Router.php
/home/dev/application/third_party/MX/Router.php

Benchmark.php
/home/dev/bonfire/codeigniter/core/Benchmark.php

CodeIgniter.php
/home/dev/bonfire/codeigniter/core/CodeIgniter.php

Common.php
/home/dev/bonfire/codeigniter/core/Common.php

Config.php
/home/dev/bonfire/codeigniter/core/Config.php

Controller.php
/home/dev/bonfire/codeigniter/core/Controller.php

Exceptions.php
/home/dev/bonfire/codeigniter/core/Exceptions.php

Hooks.php
/home/dev/bonfire/codeigniter/core/Hooks.php

Input.php
/home/dev/bonfire/codeigniter/core/Input.php

Lang.php
/home/dev/bonfire/codeigniter/core/Lang.php

Loader.php
/home/dev/bonfire/codeigniter/core/Loader.php

Model.php
/home/dev/bonfire/codeigniter/core/Model.php

Output.php
/home/dev/bonfire/codeigniter/core/Output.php

Router.php
/home/dev/bonfire/codeigniter/core/Router.php

Security.php
/home/dev/bonfire/codeigniter/core/Security.php

URI.php
/home/dev/bonfire/codeigniter/core/URI.php

Utf8.php
/home/dev/bonfire/codeigniter/core/Utf8.php

DB.php
/home/dev/bonfire/codeigniter/database/DB.php

DB_active_rec.php
/home/dev/bonfire/codeigniter/database/DB_active_rec.php

DB_driver.php
/home/dev/bonfire/codeigniter/database/DB_driver.php

DB_result.php
/home/dev/bonfire/codeigniter/database/DB_result.php

mysqli_driver.php
/home/dev/bonfire/codeigniter/database/drivers/mysqli/mysqli_driver.php

mysqli_result.php
/home/dev/bonfire/codeigniter/database/drivers/mysqli/mysqli_result.php

cookie_helper.php
/home/dev/bonfire/codeigniter/helpers/cookie_helper.php

date_helper.php
/home/dev/bonfire/codeigniter/helpers/date_helper.php

directory_helper.php
/home/dev/bonfire/codeigniter/helpers/directory_helper.php

form_helper.php
/home/dev/bonfire/codeigniter/helpers/form_helper.php

language_helper.php
/home/dev/bonfire/codeigniter/helpers/language_helper.php

string_helper.php
/home/dev/bonfire/codeigniter/helpers/string_helper.php

url_helper.php
/home/dev/bonfire/codeigniter/helpers/url_helper.php

profiler_lang.php
/home/dev/bonfire/codeigniter/language/english/profiler_lang.php

Cache.php
/home/dev/bonfire/codeigniter/libraries/Cache/Cache.php

Driver.php
/home/dev/bonfire/codeigniter/libraries/Driver.php

Form_validation.php
/home/dev/bonfire/codeigniter/libraries/Form_validation.php

Pagination.php
/home/dev/bonfire/codeigniter/libraries/Pagination.php

Session.php
/home/dev/bonfire/codeigniter/libraries/Session.php

User_agent.php
/home/dev/bonfire/codeigniter/libraries/User_agent.php

application_helper.php
/home/dev/bonfire/helpers/application_helper.php

config_file_helper.php
/home/dev/bonfire/helpers/config_file_helper.php

Console.php
/home/dev/bonfire/libraries/Console.php

assets.php
/home/dev/bonfire/libraries/assets.php

events.php
/home/dev/bonfire/libraries/events.php

template.php
/home/dev/bonfire/libraries/template.php

permission_model.php
/home/dev/bonfire/modules/permissions/models/permission_model.php

settings_lib.php
/home/dev/bonfire/modules/settings/libraries/settings_lib.php

settings_model.php
/home/dev/bonfire/modules/settings/models/settings_model.php

index.php
index.php

_commonjs.php
themes/school/_commonjs.php

_sitenav.php
themes/school/_sitenav.php

footer.php
themes/school/footer.php

header.php
themes/school/header.php

block_report_user_modal.php
themes/school/partials/block_report_user_modal.php

chat.php
themes/school/partials/chat.php

edit_image_modal.php
themes/school/partials/edit_image_modal.php

enquiry.php
themes/school/partials/enquiry.php

lists.php
themes/school/partials/lists.php

modals.php
themes/school/partials/modals.php

profilebar.php
themes/school/profilebar.php

autoload.php
/home/dev/vendor/autoload.php

ClassLoader.php
/home/dev/vendor/composer/ClassLoader.php

autoload_real.php
/home/dev/vendor/composer/autoload_real.php

autoload_static.php
/home/dev/vendor/composer/autoload_static.php

polyfills.php
/home/dev/vendor/facebook/graph-sdk/src/Facebook/polyfills.php

functions.php
/home/dev/vendor/guzzlehttp/guzzle/src/functions.php

functions_include.php
/home/dev/vendor/guzzlehttp/guzzle/src/functions_include.php

functions.php
/home/dev/vendor/guzzlehttp/promises/src/functions.php

functions_include.php
/home/dev/vendor/guzzlehttp/promises/src/functions_include.php

functions.php
/home/dev/vendor/guzzlehttp/psr7/src/functions.php

functions_include.php
/home/dev/vendor/guzzlehttp/psr7/src/functions_include.php

bootstrap.php
/home/dev/vendor/phpseclib/phpseclib/phpseclib/bootstrap.php

Stripe.php
/home/dev/vendor/stripe/stripe-php/lib/Stripe.php

ApiVersion.php
/home/dev/vendor/stripe/stripe-php/lib/Util/ApiVersion.php

Loading Time: Base Classes	42 ms
Controller Execution Time ( People / Reviews )	44 ms
Total Execution Time	86 ms

HTTP_ACCEPT	/
HTTP_USER_AGENT	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_CONNECTION	close
SERVER_PORT	443
SERVER_NAME	dev.freelancerclub.net
REMOTE_ADDR	18.218.2.191
SERVER_SOFTWARE	Apache
HTTP_ACCEPT_LANGUAGE
SCRIPT_NAME	/index.php
REQUEST_METHOD	GET
HTTP_HOST
REMOTE_HOST
CONTENT_TYPE
SERVER_PROTOCOL	HTTP/1.1
QUERY_STRING
HTTP_ACCEPT_ENCODING	gzip, br, zstd, deflate
HTTP_X_FORWARDED_FOR

modules_locations	Array ( [/home/dev/application/modules/] => ../../application/modules/ [/home/dev/bonfire/modules/] => ../../bonfire/modules/ )
base_url	https://dev.freelancerclub.net/
index_page
uri_protocol	AUTO
url_suffix
language	english
charset	UTF-8
enable_hooks
subclass_prefix	MY_
permitted_uri_chars	a-z 0-9~%.:_\-+
allow_get_array	1
enable_query_strings
controller_trigger	c
function_trigger	m
directory_trigger	d
log_threshold	0
log_path	../application/logs/
log_date_format	Y-m-d H:i:s
cache_path	../application/cache/
encryption_key	42b45bc355fd891e0b408e3ccd47754b
sess_cookie_name	bf_session
sess_expiration	7200
sess_expire_on_close
sess_encrypt_cookie
sess_use_database	1
sess_table_name	sessions
sess_match_ip
sess_match_useragent
sess_time_to_update	1200
cookie_prefix
cookie_domain
cookie_path	/
global_xss_filtering
csrf_protection	1
csrf_token_name	ci_csrf_token
csrf_cookie_name	ci_csrf_token
csrf_expire	7200
compress_output
time_reference	local
rewrite_short_tags
proxy_ips
openai_sk	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
geocode_api_key	AIzaSyDizdt-eCLOamer-CmqdI9Pryihd0z_6vo
site.default_user_timezone	UTC
site.backup_folder	archives/
contexts	Array ( [0] => content [1] => reports [2] => settings [3] => developer )
enable_activity_logging	1
template.site_path	/home/dev/public_html/
template.theme_paths	Array ( [0] => themes )
template.default_layout	index
template.ajax_layout	ajax
template.use_mobile_themes
template.default_theme	school/
template.admin_theme	admin
template.parse_views
template.message_template	<div class="alert alert-block alert-{type} fade in notification"> <a data-dismiss="alert" class="close" href="#">&times;</a> <div>{message}</div> </div>
template.breadcrumb_symbol	:
assets.base_folder	assets
assets.asset_folders	Array ( [css] => css [js] => js [image] => images )
assets.js_opener	$(document).ready(function(){
assets.js_closer	});
assets.js_combine
assets.css_combine
assets.encrypt_name
assets.js_minify
assets.css_minify
assets.encode
ui.current_shortcuts	Array ( [form_save] => Array ( [description] => Save any form in the admin area. [action] => $("input[name=save]").click();return false; ) [create_new] => Array ( [description] => Create a new record in the module. [action] => window.location.href=$("a#create_new").attr("href"); ) [select_all] => Array ( [description] => Select all records in an index page. [action] => $("table input[type=checkbox]").click();return false; ) [delete] => Array ( [description] => Delete the record(s). [action] => $("#delete-me.btn-danger").click(); ) [module_index] => Array ( [description] => Return to the index of the current module. [action] => window.location.href=$("a#list").attr("href"); ) [goto_content] => Array ( [description] => Jump to the Content context. [action] => window.location.href=$("#tb_content").attr("href") ) [goto_reports] => Array ( [description] => Jump to the Reports context. [action] => window.location.href=$("#tb_reports").attr("href") ) [goto_settings] => Array ( [description] => Jump to the Settings context. [action] => window.location.href=$("#tb_settings").attr("href") ) [goto_developer] => Array ( [description] => Jump to the Developer context. [action] => window.location.href=$("#tb_developer").attr("href") ) )
emailer.write_to_file
migrate.auto_core
migrate.auto_app
mautic_user	mautic@thefreelancerclub.co.uk
mautic_password	gad634fjkg$235$$kjgfa34

Test Step

THERE AREN'T ANY REVIEWS YET

Freelancer Club

Console

Memory Usage

Benchmarks

Queries

Session User Data

GET DATA

POST DATA

URI STRING

CLASS/METHOD

HTTP HEADERS

CONFIG VARIABLES

Files