Third duplicate test 2

25 October 2014 by Mat Nelson (client)

azcasd

Life's too short.

Queries

0.0039	INSERT INTO `bf_sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`, `user_data`) VALUES ('d324f521e34c5c2e0682944315c81b06', '0.0.0.0', 'CCBot/2.0 (https://commoncrawl.org/faq/)', 1696201011, '')
0.0006	SELECT * FROM (`bf_settings`)Speed: 0.0006 - 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: 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.0003	SELECT * FROM (`bf_banner`) WHERE `tag` = 'nonmem'Speed: 0.0003 - 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.0005	SELECT `bf_blog`., `bf_users`.`display_name`, `bf_users`.`slug` as userslug, `hidden`, `category_id` 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` LEFT OUTER JOIN `bf_users` ON `bf_blog`.`user_id` = `bf_users`.`id` WHERE `bf_blog`.`slug` = 'this-is-my-third-blog-post2' AND `bf_blog`.`deleted` = 0 AND `bf_blog`.`published` = 1Speed: 0.0005 - Possible keys: - Key Used: - Type: ALL - Rows: 14 - Extra: Using where
0.0002	SELECT * FROM (`bf_blog_categories`) WHERE `deleted` = 0 AND `hidden` = 0 ORDER BY `category_name` ASCSpeed: 0.0002 - Possible keys: - Key Used: - Type: ALL - Rows: 6 - Extra: Using where; Using filesort
0.0087	Total Query Execution Time

Session User Data

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

GET DATA

No GET data exists

POST DATA

No POST data exists

URI STRING

resources/blog/post/this-is-my-third-blog-post2

CLASS/METHOD

blog/post

HTTP HEADERS

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	3.236.237.61
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

CONFIG VARIABLES

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

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

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

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.php
/home/dev/application/modules/blog/controllers/blog.php

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

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

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

post.php
/home/dev/application/modules/blog/views/post.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

company_follow_model.php
/home/dev/application/modules/follow/models/company_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

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

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

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

Loading Time: Base Classes	29 ms
Controller Execution Time ( Blog / Post )	33 ms
Total Execution Time	62 ms