Queries

0.0014

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

0.0005

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

0.0007

SELECT * FROM (`bf_permissions`)Speed: 0.0007 - Possible keys: - Key Used: - Type: ALL - Rows: 142 - 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.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.0007

SELECT `bf_jobs`.*, `bf_users`.`image` FROM (`bf_jobs`) JOIN `bf_users` ON `bf_jobs`.`user_id` = `bf_users`.`id` WHERE `bf_jobs`.`deleted` = 0 AND `bf_jobs`.`id` = '380'Speed: 0.0007 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra:

0.0004

SELECT * FROM (`bf_job_files`) WHERE `job_id` = '380'Speed: 0.0004 - Possible keys: - Key Used: - Type: ALL - Rows: 34 - Extra: Using where

0.0015

UPDATE `bf_sessions` SET `last_activity` = 1713617337, `user_data` = 'a:2:{s:9:\"user_data\";s:0:\"\";s:11:\"recent_jobs\";a:1:{i:0;s:3:\"380\";}}' WHERE `session_id` = 'd12f98891210f1dacab978324f311e7b'

0.0004

SELECT * FROM (`bf_jobs`) WHERE `id` = '380'Speed: 0.0004 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra:

0.0004

SELECT COUNT(*) AS `numrows` FROM (`bf_job_applicants`) WHERE `job_id` = '380'Speed: 0.0004 - Possible keys: job_id - Key Used: job_id - Type: ref - Rows: 1 - Extra: Using index

0.0029

SELECT bf_users.*, (select sum(bf_portfolio.views) from bf_portfolio where bf_portfolio.user_id = bf_users.id) as views, (select count(bf_portfolio_likes.id) from bf_portfolio_likes join bf_portfolio on bf_portfolio_likes.portfolio_id = bf_portfolio.id where bf_portfolio.user_id = bf_users.id) as likes, ((select count(bf_portfolio_likes.id) from bf_portfolio_likes join bf_portfolio on bf_portfolio_likes.portfolio_id = bf_portfolio.id where bf_portfolio.user_id = bf_users.id))+((select COALESCE(sum(bf_recommend.stars), 0) from bf_recommend where bf_recommend.user_id = bf_users.id AND authorised = 1 AND stars > 2.5)*5) as rating, (select COALESCE(avg(bf_recommend.stars), 0) from bf_recommend where bf_recommend.user_id = bf_users.id AND authorised = 1) as stars, (select COALESCE(count(bf_recommend.stars), 0) from bf_recommend where bf_recommend.user_id = bf_users.id AND authorised = 1) as reviewcount, bf_socialstats.twitter_followers, bf_socialstats.facebook_likes, bf_socialstats.youtube_subscribers, bf_socialstats.instagram, bf_socialstats.last_check, ( bf_socialstats.twitter_followers + bf_socialstats.facebook_likes + bf_socialstats.youtube_subscribers + bf_socialstats.instagram ) as socialtotal, (select count(bf_sessions.user_id) from bf_sessions where bf_sessions.user_id = bf_users.id AND last_activity >=1713617037) as online FROM (bf_users) LEFT OUTER JOIN bf_socialstats ON bf_socialstats.user_id = bf_users.id WHERE `bf_users`.`id` in (2) AND `banned` = '0' AND `deleted` = '0' AND `active` = '1' AND `role_id` != '8' AND `profile_hidden` = '0' GROUP BY bf_users.id ORDER BY FIELD(account, 'pro', 'starter', 'free'), rating DESCSpeed: 0.0029 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra:

0.0032

SELECT bf_portfolio.*, count(bf_portfolio_likes.portfolio_id ) as likescount FROM (bf_portfolio) LEFT OUTER JOIN bf_portfolio_likes ON bf_portfolio.id = bf_portfolio_likes.portfolio_id WHERE `bf_portfolio`.`user_id` = '2' AND `bf_portfolio`.`company_id` = 0 GROUP BY bf_portfolio.id ORDER BY count(bf_portfolio_likes.portfolio_id) DESC LIMIT 3Speed: 0.0032 - Possible keys: - Key Used: - Type: ALL - Rows: 178 - Extra: Using where; Using temporary; Using filesort

0.0006

SELECT bf_job_applicants.status, bf_users.* FROM (bf_job_applicants) JOIN bf_users ON bf_users.id = bf_job_applicants.user_id WHERE `bf_job_applicants`.`status` = 'successful' AND `job_id` = '380'Speed: 0.0006 - Possible keys: job_id - Key Used: job_id - Type: ref - Rows: 1 - Extra: Using where

0.0003

SELECT * FROM (bf_portfolio) WHERE id IN ('118') AND `id` > 0Speed: 0.0003 - Possible keys: PRIMARY - Key Used: PRIMARY - Type: const - Rows: 1 - Extra:

0.0003

SELECT * FROM (bf_settings) WHERE `name` = 'language'Speed: 0.0003 - Possible keys: - Key Used: - Type: - Rows: - Extra: Impossible WHERE noticed after reading const tables

0.0001

SELECT * FROM (bf_settings) WHERE `name` = 'site.default_user_timezone'Speed: 0.0001 - Possible keys: - Key Used: - Type: - Rows: - Extra: Impossible WHERE noticed after reading const tables

0.0168

Total Query Execution Time

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

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

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

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

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

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

jobs_lang.php
/home/dev/application/modules/jobs/language/english/jobs_lang.php

job_alerts_model.php
/home/dev/application/modules/jobs/models/job_alerts_model.php

job_applicants_model.php
/home/dev/application/modules/jobs/models/job_applicants_model.php

job_files_model.php
/home/dev/application/modules/jobs/models/job_files_model.php

job_flags_model.php
/home/dev/application/modules/jobs/models/job_flags_model.php

job_invites_model.php
/home/dev/application/modules/jobs/models/job_invites_model.php

job_model.php
/home/dev/application/modules/jobs/models/job_model.php

structured.php
/home/dev/application/modules/jobs/views/blocks/structured.php

details_js.php
/home/dev/application/modules/jobs/views/details_js.php

details_test.php
/home/dev/application/modules/jobs/views/details_test.php

moodimages.php
/home/dev/application/modules/jobs/views/post/blocks/moodimages.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_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

service_model.php
/home/dev/application/modules/people/models/service_model.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

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

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

nocontainer.php
themes/school/nocontainer.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	33 ms
Controller Execution Time ( Jobs / Details )	49 ms
Total Execution Time	83 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.137.183.14
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
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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
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

Dancer Needed

Description

Shoot Team

Freelancer Club

Console

Memory Usage

Benchmarks

Queries

Session User Data

GET DATA

POST DATA

URI STRING

CLASS/METHOD

HTTP HEADERS

CONFIG VARIABLES

Files

session_id	d12f98891210f1dacab978324f311e7b
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	1713617337
user_data
recent_jobs	Array ( [0] => 380 )