Project Long Road | The Freelancer Club

Queries

0.0021

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

0.0004

DELETE FROM `bf_sessions` WHERE `last_activity` < 1722056981

0.0007

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

0.0006

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

0.0005

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

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

0.0015

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

0.0009

SELECT `bf_projects`.*, `bf_companies`.`compname`, `bf_companies`.`id` as comp_tag_id, `bf_companies`.`slug` as compslug, `bf_users`.`display_name`, `bf_users`.`slug`, `bf_users`.`image` as profile_image, `bf_users`.`discipline` FROM (`bf_projects`) JOIN `bf_users` ON `bf_users`.`id` = `bf_projects`.`user_id` LEFT OUTER JOIN `bf_companies` ON `bf_companies`.`id` = `bf_projects`.`company_tag_id` WHERE `bf_users`.`deleted` = 0 AND `bf_projects`.`deleted` = 0 AND `bf_projects`.`id` = '231'Speed: 0.0009 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra:

0.0003

SELECT * FROM (`bf_companies`) WHERE `bf_companies`.`id` = '29'Speed: 0.0003 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra:

0.0002

SELECT * FROM (`bf_company_unclaimed`) WHERE `bf_company_unclaimed`.`id` = '0'Speed: 0.0002 - Possible keys: - Key Used: - Type: - Rows: - Extra: Impossible WHERE noticed after reading const tables

0.0003

SELECT `id`, `display_name`, `slug`, `image`, `discipline` FROM (`bf_users`) WHERE `id` IN ('98', '104', '139', '140') AND `bf_users`.`deleted` = 0 AND `active` = 1Speed: 0.0003 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: range - Rows: 4 - Extra: Using index condition; Using where

0.0007

SELECT * FROM (`bf_portfolio`) WHERE `project_id` = '231'Speed: 0.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 214 - Extra: Using where

0.0032

UPDATE `bf_portfolio` SET `views` = 4685, `modified_on` = '2024-07-27 08:09:41' WHERE `id` = '262'

0.0029

UPDATE `bf_portfolio` SET `views` = 2823, `modified_on` = '2024-07-27 08:09:41' WHERE `id` = '287'

0.0032

UPDATE `bf_portfolio` SET `views` = 2755, `modified_on` = '2024-07-27 08:09:41' WHERE `id` = '288'

0.0023

UPDATE `bf_portfolio` SET `views` = 2742, `modified_on` = '2024-07-27 08:09:41' WHERE `id` = '289'

0.0018

UPDATE `bf_sessions` SET `last_activity` = 1722064181, `user_data` = 'a:2:{s:9:\"user_data\";s:0:\"\";s:11:\"project-231\";s:4:\"TRUE\";}' WHERE `session_id` = '829dc70ab9eeba8b6d0172a160bc9722'

0.0007

SELECT `bf_project_comments`.`id` as id, `display_name`, `image`, `comment`, `bf_project_comments`.`created_on` as created_on, `slug` FROM (`bf_project_comments`) JOIN `bf_users` ON `bf_project_comments`.`user_id` = `bf_users`.`id` WHERE `project_id` = '231' ORDER BY `bf_project_comments`.`created_on` DESC LIMIT 25Speed: 0.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 9 - Extra: Using where; Using filesort

0.0237

Total Query Execution Time

session_id	829dc70ab9eeba8b6d0172a160bc9722
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	1722064181
user_data
project-231	TRUE

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

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

EditorParser.php
/home/dev/application/libraries/EditorParser.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

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

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

banner_model.php
/home/dev/application/modules/banner/models/banner_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

company_unclaimed_model.php
/home/dev/application/modules/company/models/company_unclaimed_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

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

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

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

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

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

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

comments.php
/home/dev/application/modules/projects/views/blocks/comments.php

view.php
/home/dev/application/modules/projects/views/view.php

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

skill_model.php
/home/dev/application/modules/skills/models/skill_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

people_model.php
/home/dev/application/modules/users/models/people_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

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

index.php
themes/school/index.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

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

Loading Time: Base Classes	35 ms
Controller Execution Time ( Projects / View )	54 ms
Total Execution Time	88 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	3.149.25.73
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
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

Long Road

To comment please sign in or register.

Freelancer Club

Console

Memory Usage

Benchmarks

Queries

Session User Data

GET DATA

POST DATA

URI STRING

CLASS/METHOD

HTTP HEADERS

CONFIG VARIABLES

Files