The Freelancer Club

Queries

0.0076

INSERT INTO `bf_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES ('e2329701cd11de4c38d3107c0475e6d2', '0.0.0.0', 'CCBot/2.0 (https://commoncrawl.org/faq/)', 1686398668, '')

0.0005

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

0.0007

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

0.0004

SELECT * FROM (`bf_shop_settings`) WHERE `code` = 'gift_cards'Speed: 0.0004 - 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.0002

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

0.0005

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.0005 - Possible keys: - Key Used: PRIMARY - Type: index - Rows: 6 - Extra: Using where

0.0012

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.0012 - Possible keys: PRIMARY - Key Used: - Type: ALL - Rows: 14 - Extra: Using where; Using temporary; Using filesort

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` = 'davidbradford' 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: 356 - Extra: Using where; Using temporary; Using filesort

0.0003

SELECT COUNT(*) AS `numrows` FROM (`bf_follows`) WHERE `user_id` = '70'Speed: 0.0003 - 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` = '70'Speed: 0.0002 - Possible keys: - Key Used: user_id - Type: index - Rows: 88 - Extra: Using where; Using index

0.0004

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

0.0004

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` = '70' ORDER BY `id` desc LIMIT 5Speed: 0.0004 - Possible keys: - Key Used: PRIMARY - Type: index - Rows: 5 - Extra: Using where

0.0004

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` = '70'Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 12 - Extra: Using where

0.0002

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

0.0175

Total Query Execution Time

session_id	e2329701cd11de4c38d3107c0475e6d2
ip_address	0.0.0.0
user_agent	CCBot/2.0 (https://commoncrawl.org/faq/)
last_activity	1686398668
user_data

Files

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

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

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

constants.php
/home/dev/application/config/constants.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

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

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

platform_check.php
/home/dev/vendor/composer/platform_check.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

Loading Time: Base Classes	40 ms
Controller Execution Time ( People / Reviews )	44 ms
Total Execution Time	85 ms

HTTP_ACCEPT	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
HTTP_USER_AGENT	CCBot/2.0 (https://commoncrawl.org/faq/)
HTTP_CONNECTION	close
SERVER_PORT	443
SERVER_NAME	dev.freelancerclub.net
REMOTE_ADDR	44.192.92.49
SERVER_SOFTWARE	Apache
HTTP_ACCEPT_LANGUAGE	en-US,en;q=0.5
SCRIPT_NAME	/index.php
REQUEST_METHOD	GET
HTTP_HOST
REMOTE_HOST
CONTENT_TYPE
SERVER_PROTOCOL	HTTP/1.1
QUERY_STRING
HTTP_ACCEPT_ENCODING	br,gzip
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
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

David Longham

Mat Nelson (client)

Mat Nelson (client)

Mat Nelson (client)

Mat Nelson (client)

Mat Nelson (client)

Freelancer Club

Console

Memory Usage

Benchmarks

Queries

Session User Data

GET DATA

POST DATA

URI STRING

CLASS/METHOD

HTTP HEADERS

CONFIG VARIABLES

Files