Joomla! Debug Console

Session

Profile Information

Time

Memory

Time: 0.0 ms / 0.0 ms Memory: 0.431 MB / 0.43 MB Application: afterLoad

Time: 182.2 ms / 182.2 ms Memory: 1.799 MB / 2.23 MB Application: afterInitialise

Time: 1194.6 ms / 1376.7 ms Memory: 5.403 MB / 7.63 MB Application: afterRoute

Time: 89.1 ms / 1465.8 ms Memory: 0.773 MB / 8.41 MB Application: afterDispatch

Time: 48.4 ms / 1514.2 ms Memory: 0.361 MB / 8.77 MB Application: beforeRenderModule mod_custom (New Products)

Time: 3.5 ms / 1517.7 ms Memory: 0.015 MB / 8.78 MB Application: afterRenderModule mod_custom (New Products)

Time: 0.1 ms / 1517.9 ms Memory: 0.000 MB / 8.78 MB Application: beforeRenderModule mod_custom (Our Brands)

Time: 0.4 ms / 1518.3 ms Memory: 0.007 MB / 8.79 MB Application: afterRenderModule mod_custom (Our Brands)

Time: 0.1 ms / 1518.4 ms Memory: 0.000 MB / 8.78 MB Application: beforeRenderModule mod_custom (Quick Link)

Time: 0.4 ms / 1518.8 ms Memory: 0.007 MB / 8.79 MB Application: afterRenderModule mod_custom (Quick Link)

Time: 0.1 ms / 1518.9 ms Memory: 0.000 MB / 8.79 MB Application: beforeRenderModule mod_s5_mailchimp_signup (Newsletter)

Time: 6.9 ms / 1525.8 ms Memory: 0.011 MB / 8.80 MB Application: afterRenderModule mod_s5_mailchimp_signup (Newsletter)

Time: 0.1 ms / 1525.9 ms Memory: 0.000 MB / 8.80 MB Application: beforeRenderModule mod_flexi_customcode (FP Contact Row)

Time: 2.7 ms / 1528.6 ms Memory: 0.021 MB / 8.82 MB Application: afterRenderModule mod_flexi_customcode (FP Contact Row)

Time: 0.1 ms / 1528.7 ms Memory: 0.000 MB / 8.81 MB Application: beforeRenderModule mod_custom (Testimonials)

Time: 0.8 ms / 1529.5 ms Memory: 0.007 MB / 8.82 MB Application: afterRenderModule mod_custom (Testimonials)

Time: 0.1 ms / 1529.6 ms Memory: 0.000 MB / 8.82 MB Application: beforeRenderModule mod_zt_portfolio (Product Models)

Time: 19.3 ms / 1548.9 ms Memory: 0.166 MB / 8.99 MB Application: afterRenderModule mod_zt_portfolio (Product Models)

Time: 0.3 ms / 1549.2 ms Memory: 0.000 MB / 8.98 MB Application: beforeRenderModule mod_ce_form (Get a Quote)

Time: 97.6 ms / 1646.8 ms Memory: 2.320 MB / 11.30 MB Application: afterRenderModule mod_ce_form (Get a Quote)

Time: 0.2 ms / 1647.0 ms Memory: 0.001 MB / 11.30 MB Application: beforeRenderModule mod_zt_news (Products & Services)

Time: 12.0 ms / 1659.0 ms Memory: 0.174 MB / 11.47 MB Application: afterRenderModule mod_zt_news (Products & Services)

Time: 0.2 ms / 1659.1 ms Memory: 0.000 MB / 11.44 MB Application: beforeRenderModule mod_unite_revolution2 (Unite Revolution Slider 2)

Time: 60.2 ms / 1719.3 ms Memory: 0.782 MB / 12.22 MB Application: afterRenderModule mod_unite_revolution2 (Unite Revolution Slider 2)

Time: 0.3 ms / 1719.6 ms Memory: 0.000 MB / 12.09 MB Application: beforeRenderModule mod_flexi_customcode (Contact Top)

Time: 1.0 ms / 1720.5 ms Memory: 0.009 MB / 12.10 MB Application: afterRenderModule mod_flexi_customcode (Contact Top)

Time: 26.4 ms / 1746.9 ms Memory: 0.715 MB / 12.81 MB Application: afterRender

Database queries total: 139.1 ms

Memory Usage

Database Queries

52 Queries Logged 139.1 ms

8 duplicate found!

2 duplicates: #25 #26

6 duplicates: #46 #47 #48 #49 #50 #51

Query Time: 1.74 ms Query memory: 0.013 MB Memory before query: 0.840 MB Rows returned: 0

SELECT `data`

  FROM `b3blg_session`

  WHERE `session_id` = '2narfa5m3kh3ou58sktb6m02t1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b3blg_session	NULL	const	PRIMARY	PRIMARY	602	const	1	100.00	NULL

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	1.3 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/session/storage/database.php:44

JROOT/libraries/joomla/session/session.php:665

JROOT/libraries/joomla/session/session.php:603

JROOT/libraries/cms/application/cms.php:739

JROOT/libraries/cms/application/cms.php:131

JROOT/libraries/cms/application/site.php:63

JROOT/libraries/cms/application/cms.php:399

JROOT/libraries/joomla/factory.php:125

JROOT/index.php:42

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 58.39 ms After last query: 4.22 ms Query memory: 0.008 MB Memory before query: 0.896 MB

DELETE 

  FROM `b3blg_session`

  WHERE `time` < '1715941713'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	DELETE	b3blg_session	NULL	range	time	time	45	const	1	100.00	Using where

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.1 ms
updating	0.2 ms
end	0.0 ms
query end	57.6 ms
closing tables	0.0 ms
freeing items	0.2 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/cms/application/cms.php:756

JROOT/libraries/cms/application/cms.php:131

JROOT/libraries/cms/application/site.php:63

JROOT/libraries/cms/application/cms.php:399

JROOT/libraries/joomla/factory.php:125

JROOT/index.php:42

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.59 ms After last query: 0.45 ms Query memory: 0.010 MB Memory before query: 0.908 MB Rows returned: 0

SELECT `session_id`

  FROM `b3blg_session`

  WHERE `session_id` = '2narfa5m3kh3ou58sktb6m02t1' 
  LIMIT 0, 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b3blg_session	NULL	const	PRIMARY	PRIMARY	602	const	1	100.00	Using index

Profile

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/cms/application/cms.php:176

JROOT/libraries/cms/application/cms.php:765

JROOT/libraries/cms/application/cms.php:131

JROOT/libraries/cms/application/site.php:63

JROOT/libraries/cms/application/cms.php:399

JROOT/libraries/joomla/factory.php:125

JROOT/index.php:42

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.35 ms After last query: 0.28 ms Query memory: 0.009 MB Memory before query: 0.920 MB

INSERT INTO `b3blg_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('2narfa5m3kh3ou58sktb6m02t1', 0, '1715944413')

Explain

EXPLAIN not possible on query: INSERT INTO `b3blg_session` (`session_id`, `client_id`, `time`) VALUES ('2narfa5m3kh3ou58sktb6m02t1', 0, '1715944413')

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
update	0.1 ms
end	0.0 ms
query end	0.8 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/cms/application/cms.php:208

JROOT/libraries/cms/application/cms.php:765

JROOT/libraries/cms/application/cms.php:131

JROOT/libraries/cms/application/site.php:63

JROOT/libraries/cms/application/cms.php:399

JROOT/libraries/joomla/factory.php:125

JROOT/index.php:42

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.14 ms After last query: 9.61 ms Query memory: 0.012 MB Memory before query: 1.001 MB Rows returned: 33

SELECT extension_id AS id, element AS "option", params, enabled

  FROM b3blg_extensions

  WHERE `type` = 'component'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b3blg_extensions	NULL	ref	extension	extension	62	const	33	100.00	NULL

Profile

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
Opening tables	1.2 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.2 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:157

JROOT/libraries/cms/component/helper.php:435

JROOT/libraries/cms/component/helper.php:43

JROOT/libraries/cms/component/helper.php:120

JROOT/libraries/cms/application/site.php:568

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.58 ms After last query: 3.04 ms Query memory: 0.012 MB Memory before query: 1.063 MB Rows returned: 2

SELECT b.id

  FROM b3blg_usergroups AS a

  LEFT JOIN b3blg_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	NULL	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	100.00	Using where; Using index

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	1.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/access/access.php:332

JROOT/libraries/joomla/access/access.php:401

JROOT/libraries/joomla/user/user.php:453

JROOT/libraries/cms/plugin/helper.php:296

JROOT/libraries/cms/plugin/helper.php:163

JROOT/libraries/cms/application/site.php:573

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.01 ms After last query: 1.17 ms Query memory: 0.011 MB Memory before query: 1.082 MB Rows returned: 5

SELECT id, rules

  FROM `b3blg_viewlevels`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b3blg_viewlevels	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5	100.00	NULL

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.6 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/access/access.php:418

JROOT/libraries/joomla/user/user.php:453

JROOT/libraries/cms/plugin/helper.php:296

JROOT/libraries/cms/plugin/helper.php:163

JROOT/libraries/cms/application/site.php:573

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.00 ms After last query: 0.20 ms Query memory: 0.009 MB Memory before query: 1.101 MB Rows returned: 49

SELECT folder AS type, element AS name, params

  FROM b3blg_extensions

  WHERE enabled = 1 
  AND type ='plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b3blg_extensions	NULL	ref	extension	extension	62	const	69	0.60	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.5 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/cms/plugin/helper.php:310

JROOT/libraries/cms/plugin/helper.php:163

JROOT/libraries/cms/application/site.php:573

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.27 ms After last query: 15.01 ms Query memory: 0.023 MB Memory before query: 1.353 MB Rows returned: 6

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM b3blg_menu AS m

  LEFT JOIN b3blg_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	7	10.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	copiers1_copiersp_db.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	1.2 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.2 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/cms/menu/site.php:45

JROOT/libraries/cms/menu/menu.php:64

JROOT/libraries/cms/menu/menu.php:118

JROOT/libraries/cms/application/cms.php:424

JROOT/libraries/cms/application/site.php:272

JROOT/libraries/cms/application/site.php:438

JROOT/plugins/system/zooframework/core/includes/extensions.php:117

JROOT/plugins/system/zooframework/core/includes/extensions.php:77

JROOT/plugins/system/zooframework/core/includes/framework.php:32

JROOT/plugins/system/zooframework/core/bootstrap.php:19

JROOT/plugins/system/zooframework/zooframework.php:23

JROOT/libraries/cms/plugin/helper.php:255

JROOT/libraries/cms/plugin/helper.php:170

JROOT/libraries/cms/application/cms.php:653

JROOT/libraries/cms/application/site.php:647

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.90 ms After last query: 3.03 ms Query memory: 0.017 MB Memory before query: 1.465 MB Rows returned: 3

SELECT id, home, template, s.params

  FROM b3blg_template_styles as s

  LEFT JOIN b3blg_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	3	33.33	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	copiers1_copiersp_db.s.template,const	1	4.62	Using index condition; Using where

Profile

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.8 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.4 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/cms/application/site.php:484

JROOT/plugins/system/zooframework/core/includes/extensions.php:117

JROOT/plugins/system/zooframework/core/includes/extensions.php:77

JROOT/plugins/system/zooframework/core/includes/framework.php:32

JROOT/plugins/system/zooframework/core/bootstrap.php:19

JROOT/plugins/system/zooframework/zooframework.php:23

JROOT/libraries/cms/plugin/helper.php:255

JROOT/libraries/cms/plugin/helper.php:170

JROOT/libraries/cms/application/cms.php:653

JROOT/libraries/cms/application/site.php:647

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.67 ms After last query: 7.08 ms Query memory: 0.033 MB Memory before query: 1.760 MB Rows returned: 1

SELECT extension_id AS id, element AS "option", params, enabled

  FROM b3blg_extensions

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b3blg_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	NULL

Profile

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:157

JROOT/libraries/cms/library/helper.php:156

JROOT/libraries/cms/library/helper.php:47

JROOT/libraries/cms/library/helper.php:90

JROOT/libraries/cms/version/version.php:189

JROOT/libraries/joomla/factory.php:736

JROOT/libraries/joomla/factory.php:216

JROOT/libraries/cms/html/html.php:701

JROOT/libraries/cms/html/html.php:236

JROOT/libraries/cms/html/html.php:138

JROOT/libraries/cms/html/jquery.php:53

JROOT/libraries/cms/html/html.php:236

JROOT/libraries/cms/html/html.php:138

JROOT/libraries/cms/html/bootstrap.php:230

JROOT/libraries/cms/html/html.php:236

JROOT/libraries/cms/html/html.php:138

JROOT/plugins/system/zooframework/core/bootstrap.php:24

JROOT/plugins/system/zooframework/zooframework.php:23

JROOT/libraries/cms/plugin/helper.php:255

JROOT/libraries/cms/plugin/helper.php:170

JROOT/libraries/cms/application/cms.php:653

JROOT/libraries/cms/application/site.php:647

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.45 ms After last query: 3.69 ms Query memory: 0.029 MB Memory before query: 1.794 MB

UPDATE `b3blg_extensions`

  SET `params` = '{\"mediaversion\":\"c207519192062574d47349cf11ffff37\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	b3blg_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using where

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.1 ms
updating	0.2 ms
end	0.0 ms
query end	0.8 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/cms/library/helper.php:119

JROOT/libraries/cms/version/version.php:240

JROOT/libraries/cms/version/version.php:199

JROOT/libraries/joomla/factory.php:736

JROOT/libraries/joomla/factory.php:216

JROOT/libraries/cms/html/html.php:701

JROOT/libraries/cms/html/html.php:236

JROOT/libraries/cms/html/html.php:138

JROOT/libraries/cms/html/jquery.php:53

JROOT/libraries/cms/html/html.php:236

JROOT/libraries/cms/html/html.php:138

JROOT/libraries/cms/html/bootstrap.php:230

JROOT/libraries/cms/html/html.php:236

JROOT/libraries/cms/html/html.php:138

JROOT/plugins/system/zooframework/core/bootstrap.php:24

JROOT/plugins/system/zooframework/zooframework.php:23

JROOT/libraries/cms/plugin/helper.php:255

JROOT/libraries/cms/plugin/helper.php:170

JROOT/libraries/cms/application/cms.php:653

JROOT/libraries/cms/application/site.php:647

JROOT/libraries/cms/application/site.php:209

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.52 ms After last query: 38.00 ms Query memory: 0.016 MB Memory before query: 2.368 MB Rows returned: 1

SELECT `template_style_id` 
  FROM `b3blg_menu` 
  WHERE `id` = 101

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b3blg_menu	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.6 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.3 ms
cleaning up	0.0 ms

Call Stack

JROOT/plugins/system/zo2/framework/includes/factory.php:103

JROOT/plugins/system/zo2/framework/includes/framework.php:96

JROOT/plugins/system/zo2/zo2.php:38

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:1098

JROOT/libraries/cms/application/site.php:747

JROOT/libraries/cms/application/site.php:215

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.83 ms After last query: 1170.05 ms Query memory: 0.020 MB Memory before query: 7.534 MB Rows returned: 1

SELECT alias

  FROM b3blg_content

  WHERE id=1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b3blg_content	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
Opening tables	1.2 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_content/router.php:112

JROOT/libraries/cms/router/site.php:483

JROOT/libraries/cms/router/site.php:452

JROOT/libraries/cms/router/router.php:280

JROOT/libraries/cms/router/site.php:134

JROOT/libraries/joomla/application/route.php:62

JROOT/plugins/system/sef/sef.php:46

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:1098

JROOT/libraries/cms/application/site.php:747

JROOT/libraries/cms/application/site.php:215

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 3.00 ms After last query: 3.48 ms Query memory: 0.022 MB Memory before query: 7.602 MB Rows returned: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM b3blg_categories as c

  LEFT JOIN b3blg_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM b3blg_categories AS cat JOIN b3blg_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=2 
  AND badcats.id is null

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	PRIMARY	c	NULL	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	8	34.72	Using where
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	copiers1_copiersp_db.c.id	2	100.00	Using where; Not exists; Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	8	12.50	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

Status	Duration
starting	0.4 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	1.3 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.1 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.2 ms
Creating sort index	0.1 ms
end	0.0 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/legacy/categories/categories.php:292

JROOT/libraries/legacy/categories/categories.php:184

JROOT/components/com_content/router.php:145

JROOT/libraries/cms/router/site.php:483

JROOT/libraries/cms/router/site.php:452

JROOT/libraries/cms/router/router.php:280

JROOT/libraries/cms/router/site.php:134

JROOT/libraries/joomla/application/route.php:62

JROOT/plugins/system/sef/sef.php:46

JROOT/libraries/joomla/event/event.php:69

JROOT/libraries/joomla/event/dispatcher.php:160

JROOT/libraries/joomla/application/base.php:83

JROOT/libraries/cms/application/cms.php:1098

JROOT/libraries/cms/application/site.php:747

JROOT/libraries/cms/application/site.php:215

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.39 ms After last query: 4.11 ms Query memory: 0.009 MB Memory before query: 7.653 MB Rows returned: 1

SELECT *

  FROM b3blg_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b3blg_languages	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using filesort

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.8 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.1 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/language/helper.php:164

JROOT/libraries/cms/application/site.php:329

JROOT/libraries/cms/application/site.php:135

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.85 ms After last query: 18.30 ms Query memory: 0.022 MB Memory before query: 7.878 MB Rows returned: 1

SELECT a.rules

  FROM b3blg_assets AS a

  WHERE (a.id = 1)

  GROUP BY a.id, a.rules, a.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
Opening tables	0.8 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.1 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/access/access.php:246

JROOT/libraries/joomla/user/user.php:384

JROOT/components/com_content/models/article.php:55

JROOT/libraries/legacy/model/legacy.php:431

JROOT/components/com_content/models/article.php:75

JROOT/libraries/legacy/view/legacy.php:401

JROOT/components/com_content/views/article/view.html.php:42

JROOT/libraries/legacy/controller/legacy.php:690

JROOT/components/com_content/controller.php:104

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_content/content.php:38

JROOT/libraries/cms/component/helper.php:392

JROOT/libraries/cms/component/helper.php:372

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.00 ms After last query: 4.21 ms Query memory: 0.023 MB Memory before query: 7.912 MB Rows returned: 2

SELECT b.rules

  FROM b3blg_assets AS a

  LEFT JOIN b3blg_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE (a.name = 'com_content')

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	idx_asset_name	idx_asset_name	152	const	1	100.00	Using temporary; Using filesort
1	SIMPLE	b	NULL	range	idx_lft_rgt	idx_lft_rgt	4	NULL	11	100.00	Using where

Profile

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.2 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
Creating sort index	0.0 ms
end	0.0 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/access/access.php:246

JROOT/libraries/joomla/access/access.php:107

JROOT/libraries/joomla/user/user.php:393

JROOT/components/com_content/models/article.php:55

JROOT/libraries/legacy/model/legacy.php:431

JROOT/components/com_content/models/article.php:75

JROOT/libraries/legacy/view/legacy.php:401

JROOT/components/com_content/views/article/view.html.php:42

JROOT/libraries/legacy/controller/legacy.php:690

JROOT/components/com_content/controller.php:104

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_content/content.php:38

JROOT/libraries/cms/component/helper.php:392

JROOT/libraries/cms/component/helper.php:372

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.35 ms After last query: 1.28 ms Query memory: 0.017 MB Memory before query: 7.949 MB Rows returned: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM b3blg_content AS a

  LEFT JOIN b3blg_categories AS c 
  on c.id = a.catid

  LEFT JOIN b3blg_users AS u 
  on u.id = a.created_by

  LEFT JOIN b3blg_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN b3blg_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM b3blg_categories AS cat JOIN b3blg_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published <= 0 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE a.id = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-17 11:13:35') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-17 11:13:35') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	a	NULL	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	u	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	v	NULL	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	const	1	100.00	Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	153	NULL	1	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	8	12.50	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

Status	Duration
starting	0.3 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	1.2 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.1 ms
end	0.0 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_content/models/article.php:159

JROOT/libraries/legacy/view/legacy.php:401

JROOT/components/com_content/views/article/view.html.php:42

JROOT/libraries/legacy/controller/legacy.php:690

JROOT/components/com_content/controller.php:104

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_content/content.php:38

JROOT/libraries/cms/component/helper.php:392

JROOT/libraries/cms/component/helper.php:372

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 4.65 ms After last query: 10.50 ms Query memory: 0.016 MB Memory before query: 8.035 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `b3blg_contentitem_tag_map` AS m 

  INNER JOIN `b3blg_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	copiers1_copiersp_db.m.tag_id	1	100.00	Using where

Profile

Status	Duration
starting	0.4 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	3.2 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.2 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.1 ms
freeing items	0.3 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/cms/helper/tags.php:426

JROOT/components/com_content/views/article/view.html.php:155

JROOT/libraries/legacy/controller/legacy.php:690

JROOT/components/com_content/controller.php:104

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_content/content.php:38

JROOT/libraries/cms/component/helper.php:392

JROOT/libraries/cms/component/helper.php:372

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.11 ms After last query: 21.49 ms Query memory: 0.022 MB Memory before query: 8.194 MB Rows returned: 30

SHOW FULL COLUMNS 
  FROM `b3blg_content`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `b3blg_content`

Profile

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.2 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Opening tables	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:241

JROOT/libraries/joomla/table/table.php:162

JROOT/libraries/legacy/table/content.php:31

JROOT/libraries/joomla/table/table.php:305

JROOT/components/com_content/models/article.php:264

JROOT/components/com_content/views/article/view.html.php:176

JROOT/libraries/legacy/controller/legacy.php:690

JROOT/components/com_content/controller.php:104

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_content/content.php:38

JROOT/libraries/cms/component/helper.php:392

JROOT/libraries/cms/component/helper.php:372

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.22 ms After last query: 4.45 ms Query memory: 0.017 MB Memory before query: 8.326 MB Rows returned: 1

SELECT *

  FROM b3blg_content

  WHERE `id` = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b3blg_content	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.3 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.4 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:728

JROOT/components/com_content/models/article.php:265

JROOT/components/com_content/views/article/view.html.php:176

JROOT/libraries/legacy/controller/legacy.php:690

JROOT/components/com_content/controller.php:104

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_content/content.php:38

JROOT/libraries/cms/component/helper.php:392

JROOT/libraries/cms/component/helper.php:372

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.37 ms After last query: 0.28 ms Query memory: 0.016 MB Memory before query: 8.344 MB

UPDATE b3blg_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	b3blg_content	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profile

Status	Duration
starting	0.3 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
init	0.0 ms
System lock	0.1 ms
updating	0.2 ms
end	0.0 ms
query end	1.2 ms
closing tables	0.0 ms
freeing items	0.3 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:1239

JROOT/components/com_content/models/article.php:266

JROOT/components/com_content/views/article/view.html.php:176

JROOT/libraries/legacy/controller/legacy.php:690

JROOT/components/com_content/controller.php:104

JROOT/libraries/legacy/controller/legacy.php:728

JROOT/components/com_content/content.php:38

JROOT/libraries/cms/component/helper.php:392

JROOT/libraries/cms/component/helper.php:372

JROOT/libraries/cms/application/site.php:191

JROOT/libraries/cms/application/site.php:230

JROOT/libraries/cms/application/cms.php:252

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 6.05 ms After last query: 17.23 ms Query memory: 0.024 MB Memory before query: 8.501 MB Rows returned: 14

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM b3blg_modules AS m

  LEFT JOIN b3blg_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN b3blg_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-05-17 11:13:35') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-17 11:13:35') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 101 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY,published,newsfeeds	published	1	const	21	2.38	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	303	copiers1_copiersp_db.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	copiers1_copiersp_db.m.id	1	40.00	Using where; Using index

Profile

Status	Duration
starting	0.7 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	3.0 ms
init	0.2 ms
System lock	0.0 ms
optimizing	0.1 ms
statistics	0.2 ms
preparing	0.1 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	1.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.1 ms
freeing items	0.3 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/cms/module/helper.php:417

JROOT/libraries/cms/module/helper.php:360

JROOT/libraries/cms/module/helper.php:84

JROOT/plugins/system/zo2/framework/layout.php:322

JROOT/plugins/system/zo2/framework/layout.php:123

JROOT/plugins/system/zo2/framework/layout.php:142

JROOT/plugins/system/zo2/framework/layout.php:96

JROOT/plugins/system/zo2/framework/layout.php:61

JROOT/plugins/system/zo2/framework/cache.php:128

JROOT/plugins/system/zo2/framework/layout.php:42

JROOT/templates/zo2_contruct/index.php:59

JROOT/libraries/joomla/document/html/html.php:578

JROOT/libraries/joomla/document/html/html.php:635

JROOT/libraries/joomla/document/html/html.php:455

JROOT/libraries/cms/application/cms.php:1045

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.77 ms After last query: 9.66 ms Query memory: 0.025 MB Memory before query: 8.625 MB Rows returned: 6

Duplicate queries: #26

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM b3blg_menu AS m

  LEFT JOIN b3blg_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0 
  AND m.access IN ( 1,1,5 ) 
  AND m.menutype = 'mainmenu'

  ORDER BY m.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language,idx_menutype	idx_menutype	74	const	7	2.70	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	copiers1_copiersp_db.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.8 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.1 ms
statistics	0.2 ms
preparing	0.1 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.5 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.1 ms
freeing items	0.5 ms
cleaning up	0.0 ms

Call Stack

JROOT/plugins/system/zo2/framework/model/joomla.php:79

JROOT/plugins/system/zo2/framework/megamenu.php:51

JROOT/plugins/system/zo2/framework/megamenu.php:43

JROOT/plugins/system/zo2/framework/includes/framework.php:543

JROOT/plugins/system/zo2/framework/layout.php:453

JROOT/plugins/system/zo2/framework/layout.php:98

JROOT/plugins/system/zo2/framework/layout.php:249

JROOT/plugins/system/zo2/framework/layout.php:96

JROOT/plugins/system/zo2/framework/layout.php:61

JROOT/plugins/system/zo2/framework/cache.php:128

JROOT/plugins/system/zo2/framework/layout.php:42

JROOT/templates/zo2_contruct/index.php:59

JROOT/libraries/joomla/document/html/html.php:578

JROOT/libraries/joomla/document/html/html.php:635

JROOT/libraries/joomla/document/html/html.php:455

JROOT/libraries/cms/application/cms.php:1045

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.34 ms After last query: 15.13 ms Query memory: 0.021 MB Memory before query: 8.705 MB Rows returned: 6

Duplicate queries: #25

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM b3blg_menu AS m

  LEFT JOIN b3blg_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0 
  AND m.access IN ( 1,1,5 ) 
  AND m.menutype = 'mainmenu'

  ORDER BY m.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language,idx_menutype	idx_menutype	74	const	7	2.70	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	copiers1_copiersp_db.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.7 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.2 ms
preparing	0.1 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.3 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.4 ms
cleaning up	0.0 ms

Call Stack

JROOT/plugins/system/zo2/framework/model/joomla.php:79

JROOT/plugins/system/zo2/framework/megamenu.php:51

JROOT/plugins/system/zo2/framework/megamenu.php:43

JROOT/plugins/system/zo2/framework/includes/framework.php:564

JROOT/plugins/system/zo2/framework/layout.php:66

JROOT/plugins/system/zo2/framework/cache.php:128

JROOT/plugins/system/zo2/framework/layout.php:42

JROOT/templates/zo2_contruct/index.php:59

JROOT/libraries/joomla/document/html/html.php:578

JROOT/libraries/joomla/document/html/html.php:635

JROOT/libraries/joomla/document/html/html.php:455

JROOT/libraries/cms/application/cms.php:1045

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.40 ms After last query: 21.08 ms Query memory: 0.016 MB Memory before query: 8.843 MB Rows returned: 14

SELECT * 
  FROM `b3blg_content`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b3blg_content	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	7	100.00	NULL

Profile

Status	Duration
starting	0.3 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.5 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.2 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_zt_portfolio/helper.php:23

JROOT/modules/mod_zt_portfolio/mod_zt_portfolio.php:21

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/libraries/joomla/document/html/renderer/modules.php:43

JROOT/libraries/joomla/document/html/html.php:411

JROOT/libraries/joomla/document/html/html.php:697

JROOT/libraries/joomla/document/html/html.php:477

JROOT/libraries/cms/application/cms.php:1059

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.58 ms After last query: 0.74 ms Query memory: 0.020 MB Memory before query: 8.976 MB Rows returned: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM b3blg_categories as c

  LEFT JOIN b3blg_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM b3blg_categories AS cat JOIN b3blg_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=9 
  AND badcats.id is null

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	PRIMARY	c	NULL	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	8	34.72	Using where
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	copiers1_copiersp_db.c.id	2	100.00	Using where; Not exists; Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	8	12.50	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

Status	Duration
starting	0.5 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.2 ms
System lock	0.0 ms
optimizing	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
statistics	0.2 ms
preparing	0.1 ms
Creating tmp table	0.1 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.4 ms
Creating sort index	0.1 ms
end	0.0 ms
query end	0.0 ms
removing tmp table	0.1 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.2 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/legacy/categories/categories.php:292

JROOT/libraries/legacy/categories/categories.php:184

JROOT/components/com_content/helpers/route.php:44

JROOT/modules/mod_zt_portfolio/helper.php:33

JROOT/modules/mod_zt_portfolio/mod_zt_portfolio.php:21

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/libraries/joomla/document/html/renderer/modules.php:43

JROOT/libraries/joomla/document/html/html.php:411

JROOT/libraries/joomla/document/html/html.php:697

JROOT/libraries/joomla/document/html/html.php:477

JROOT/libraries/cms/application/cms.php:1059

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.95 ms After last query: 4.38 ms Query memory: 0.020 MB Memory before query: 9.018 MB Rows returned: 1

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM b3blg_categories as c

  LEFT JOIN b3blg_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM b3blg_categories AS cat JOIN b3blg_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=5 
  AND badcats.id is null

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	PRIMARY	c	NULL	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	8	34.72	Using where
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	copiers1_copiersp_db.c.id	2	100.00	Using where; Not exists; Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	8	12.50	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

Status	Duration
starting	0.4 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.1 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.3 ms
Creating sort index	0.0 ms
end	0.0 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.2 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/legacy/categories/categories.php:292

JROOT/libraries/legacy/categories/categories.php:184

JROOT/components/com_content/helpers/route.php:44

JROOT/modules/mod_zt_portfolio/helper.php:33

JROOT/modules/mod_zt_portfolio/mod_zt_portfolio.php:21

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/libraries/joomla/document/html/renderer/modules.php:43

JROOT/libraries/joomla/document/html/html.php:411

JROOT/libraries/joomla/document/html/html.php:697

JROOT/libraries/joomla/document/html/html.php:477

JROOT/libraries/cms/application/cms.php:1059

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.69 ms After last query: 1.42 ms Query memory: 0.020 MB Memory before query: 9.043 MB Rows returned: 1

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM b3blg_categories as c

  LEFT JOIN b3blg_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM b3blg_categories AS cat JOIN b3blg_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=3 
  AND badcats.id is null

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	PRIMARY	c	NULL	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	8	34.72	Using where
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	copiers1_copiersp_db.c.id	2	100.00	Using where; Not exists; Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	8	12.50	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

Status	Duration
starting	0.3 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.2 ms
Creating sort index	0.1 ms
end	0.0 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.2 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/legacy/categories/categories.php:292

JROOT/libraries/legacy/categories/categories.php:184

JROOT/components/com_content/helpers/route.php:44

JROOT/modules/mod_zt_portfolio/helper.php:33

JROOT/modules/mod_zt_portfolio/mod_zt_portfolio.php:21

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/libraries/joomla/document/html/renderer/modules.php:43

JROOT/libraries/joomla/document/html/html.php:411

JROOT/libraries/joomla/document/html/html.php:697

JROOT/libraries/joomla/document/html/html.php:477

JROOT/libraries/cms/application/cms.php:1059

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.05 ms After last query: 0.94 ms Query memory: 0.020 MB Memory before query: 9.067 MB Rows returned: 0

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM b3blg_categories as c

  LEFT JOIN b3blg_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM b3blg_categories AS cat JOIN b3blg_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=6 
  AND badcats.id is null

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	8	12.50	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

Status	Duration
starting	0.3 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
statistics	0.1 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.2 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/legacy/categories/categories.php:292

JROOT/libraries/legacy/categories/categories.php:184

JROOT/components/com_content/helpers/route.php:44

JROOT/modules/mod_zt_portfolio/helper.php:33

JROOT/modules/mod_zt_portfolio/mod_zt_portfolio.php:21

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/libraries/joomla/document/html/renderer/modules.php:43

JROOT/libraries/joomla/document/html/html.php:411

JROOT/libraries/joomla/document/html/html.php:697

JROOT/libraries/joomla/document/html/html.php:477

JROOT/libraries/cms/application/cms.php:1059

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.96 ms After last query: 45.30 ms Query memory: 0.017 MB Memory before query: 10.028 MB Rows returned: 1

SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias

  FROM b3blg_ce_details AS a

  LEFT JOIN b3blg_categories AS c 
  on c.id = a.catid

  LEFT JOIN b3blg_categories as parent 
  ON parent.id = c.parent_id

  WHERE a.id = 2

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.3 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	1.9 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.1 ms
freeing items	0.2 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_contactenhanced/models/contact.php:129

JROOT/modules/mod_ce_form/helper.php:63

JROOT/modules/mod_ce_form/mod_ce_form.php:19

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/libraries/joomla/document/html/renderer/modules.php:43

JROOT/libraries/joomla/document/html/html.php:411

JROOT/libraries/joomla/document/html/html.php:697

JROOT/libraries/joomla/document/html/html.php:477

JROOT/libraries/cms/application/cms.php:1059

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.63 ms After last query: 1.52 ms Query memory: 0.019 MB Memory before query: 10.111 MB Rows returned: 0

SELECT `t`.`id`

  FROM `b3blg_tags` AS t 

  INNER JOIN `b3blg_contentitem_tag_map` AS m 
  ON `m`.`tag_id` = `t`.`id` 
  AND `m`.`type_alias` = 'com_contactenhanced.contact' 
  AND `m`.`content_item_id` IN ( 2)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	NULL	index	PRIMARY	idx_access	4	NULL	1	100.00	Using index
1	SIMPLE	m	NULL	ref	idx_tag_type,idx_tag	idx_tag_type	4	copiers1_copiersp_db.t.id	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/cms/helper/tags.php:478

JROOT/components/com_contactenhanced/models/contact.php:158

JROOT/modules/mod_ce_form/helper.php:63

JROOT/modules/mod_ce_form/mod_ce_form.php:19

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/libraries/joomla/document/html/renderer/modules.php:43

JROOT/libraries/joomla/document/html/html.php:411

JROOT/libraries/joomla/document/html/html.php:697

JROOT/libraries/joomla/document/html/html.php:477

JROOT/libraries/cms/application/cms.php:1059

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.80 ms After last query: 0.40 ms Query memory: 0.019 MB Memory before query: 10.134 MB Rows returned: 1

SELECT a.*, cc.access as category_access, cc.title as category_name,  
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug

  FROM b3blg_ce_details AS a

  INNER JOIN b3blg_categories AS cc 
  on cc.id = a.catid

  WHERE a.id = 2

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY,idx_catid	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	cc	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_contactenhanced/models/contact.php:253

JROOT/components/com_contactenhanced/models/contact.php:191

JROOT/modules/mod_ce_form/helper.php:63

JROOT/modules/mod_ce_form/mod_ce_form.php:19

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/libraries/joomla/document/html/renderer/modules.php:43

JROOT/libraries/joomla/document/html/html.php:411

JROOT/libraries/joomla/document/html/html.php:697

JROOT/libraries/joomla/document/html/html.php:477

JROOT/libraries/cms/application/cms.php:1059

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.55 ms After last query: 0.45 ms Query memory: 0.019 MB Memory before query: 10.170 MB Rows returned: 8

SELECT a.id,a.title,a.state,a.access,a.catid,a.created,a.language, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug

  FROM b3blg_content as a

  LEFT JOIN b3blg_categories as c 
  on a.catid=c.id

  WHERE a.created_by = 845

  ORDER BY a.state DESC, a.created DESC 
  LIMIT 0, 10

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_createdby	idx_createdby	4	const	8	100.00	Using index condition; Using filesort
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	copiers1_copiersp_db.a.catid	1	100.00	Using where

Profile

Status	Duration
starting	0.3 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.2 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.2 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_contactenhanced/models/contact.php:329

JROOT/components/com_contactenhanced/models/contact.php:191

JROOT/modules/mod_ce_form/helper.php:63

JROOT/modules/mod_ce_form/mod_ce_form.php:19

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/libraries/joomla/document/html/renderer/modules.php:43

JROOT/libraries/joomla/document/html/html.php:411

JROOT/libraries/joomla/document/html/html.php:697

JROOT/libraries/joomla/document/html/html.php:477

JROOT/libraries/cms/application/cms.php:1059

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.16 ms After last query: 11.95 ms Query memory: 0.029 MB Memory before query: 10.306 MB Rows returned: 16

SHOW FULL COLUMNS 
  FROM `b3blg_users`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `b3blg_users`

Profile

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.2 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Opening tables	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:241

JROOT/libraries/joomla/table/table.php:162

JROOT/libraries/joomla/table/user.php:39

JROOT/libraries/joomla/table/table.php:305

JROOT/administrator/components/com_users/models/user.php:62

JROOT/libraries/legacy/model/admin.php:856

JROOT/administrator/components/com_users/models/user.php:78

JROOT/components/com_contactenhanced/models/contact.php:335

JROOT/components/com_contactenhanced/models/contact.php:191

JROOT/modules/mod_ce_form/helper.php:63

JROOT/modules/mod_ce_form/mod_ce_form.php:19

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/libraries/joomla/document/html/renderer/modules.php:43

JROOT/libraries/joomla/document/html/html.php:411

JROOT/libraries/joomla/document/html/html.php:697

JROOT/libraries/joomla/document/html/html.php:477

JROOT/libraries/cms/application/cms.php:1059

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.55 ms After last query: 0.32 ms Query memory: 0.022 MB Memory before query: 10.372 MB Rows returned: 1

SELECT *

  FROM `b3blg_users`

  WHERE `id` = 845

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b3blg_users	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/user.php:85

JROOT/libraries/legacy/model/admin.php:861

JROOT/administrator/components/com_users/models/user.php:78

JROOT/components/com_contactenhanced/models/contact.php:335

JROOT/components/com_contactenhanced/models/contact.php:191

JROOT/modules/mod_ce_form/helper.php:63

JROOT/modules/mod_ce_form/mod_ce_form.php:19

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/libraries/joomla/document/html/renderer/modules.php:43

JROOT/libraries/joomla/document/html/html.php:411

JROOT/libraries/joomla/document/html/html.php:697

JROOT/libraries/joomla/document/html/html.php:477

JROOT/libraries/cms/application/cms.php:1059

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.60 ms After last query: 9.89 ms Query memory: 0.022 MB Memory before query: 11.133 MB Rows returned: 1

SELECT `g`.`id`,`g`.`title`

  FROM `b3blg_usergroups` AS g

  INNER JOIN `b3blg_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 845

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	copiers1_copiersp_db.m.group_id	1	100.00	NULL

Profile

Status	Duration
starting	0.3 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.7 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.2 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/user.php:110

JROOT/libraries/legacy/model/admin.php:861

JROOT/administrator/components/com_users/models/user.php:78

JROOT/components/com_contactenhanced/models/contact.php:335

JROOT/components/com_contactenhanced/models/contact.php:191

JROOT/modules/mod_ce_form/helper.php:63

JROOT/modules/mod_ce_form/mod_ce_form.php:19

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/libraries/joomla/document/html/renderer/modules.php:43

JROOT/libraries/joomla/document/html/html.php:411

JROOT/libraries/joomla/document/html/html.php:697

JROOT/libraries/joomla/document/html/html.php:477

JROOT/libraries/cms/application/cms.php:1059

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.60 ms After last query: 0.36 ms Query memory: 0.021 MB Memory before query: 11.153 MB Rows returned: 0

SELECT `t`.`id`

  FROM `b3blg_tags` AS t 

  INNER JOIN `b3blg_contentitem_tag_map` AS m 
  ON `m`.`tag_id` = `t`.`id` 
  AND `m`.`type_alias` = 'com_users.user' 
  AND `m`.`content_item_id` IN ( 845)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	NULL	index	PRIMARY	idx_access	4	NULL	1	100.00	Using index
1	SIMPLE	m	NULL	ref	idx_tag_type,idx_tag	idx_tag_type	4	copiers1_copiersp_db.t.id	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/cms/helper/tags.php:478

JROOT/administrator/components/com_users/models/user.php:83

JROOT/components/com_contactenhanced/models/contact.php:335

JROOT/components/com_contactenhanced/models/contact.php:191

JROOT/modules/mod_ce_form/helper.php:63

JROOT/modules/mod_ce_form/mod_ce_form.php:19

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/libraries/joomla/document/html/renderer/modules.php:43

JROOT/libraries/joomla/document/html/html.php:411

JROOT/libraries/joomla/document/html/html.php:697

JROOT/libraries/joomla/document/html/html.php:477

JROOT/libraries/cms/application/cms.php:1059

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.75 ms After last query: 6.45 ms Query memory: 0.022 MB Memory before query: 11.210 MB Rows returned: 6

SELECT cf.*

  FROM b3blg_ce_cf AS cf

  WHERE cf.access IN (1,1,5) 
  AND (cf.catid = '8' OR cf.catid = 0) 
  AND (cf.published > 0 OR (cf.published = 0 
  AND cf.iscore = 1) ) 
  AND cf.language IN ('en-GB','*')

  ORDER BY cf.catid, cf.ordering ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cf	NULL	ALL	idx_ce_cf_language,idx_ce_cf_published,idx_ce_cf_access	NO INDEX KEY COULD BE USED	NULL	NULL	6	30.56	Using where; Using filesort

Profile

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
Opening tables	0.9 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_contactenhanced/models/customfields.php:163

JROOT/components/com_contactenhanced/models/customfields.php:58

JROOT/components/com_contactenhanced/helpers/helper.php:668

JROOT/components/com_contactenhanced/models/contact.php:201

JROOT/modules/mod_ce_form/helper.php:69

JROOT/modules/mod_ce_form/mod_ce_form.php:19

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/libraries/joomla/document/html/renderer/modules.php:43

JROOT/libraries/joomla/document/html/html.php:411

JROOT/libraries/joomla/document/html/html.php:697

JROOT/libraries/joomla/document/html/html.php:477

JROOT/libraries/cms/application/cms.php:1059

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.76 ms After last query: 7.82 ms Query memory: 0.029 MB Memory before query: 11.337 MB Rows returned: 1

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM b3blg_categories as c

  LEFT JOIN b3blg_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  LEFT JOIN  (SELECT cat.id as id 
  FROM b3blg_categories AS cat JOIN b3blg_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_contactenhanced' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE (c.extension='com_contactenhanced' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=2 
  AND badcats.id is null

  GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			 c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			 c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			 c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version

  ORDER BY c.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	PRIMARY	c	NULL	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	8	27.78	Using where
1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	copiers1_copiersp_db.c.id	2	100.00	Using where; Not exists; Using index
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	8	12.50	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

Status	Duration
starting	0.3 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
statistics	0.2 ms
preparing	0.0 ms
Creating tmp table	0.1 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.3 ms
Creating sort index	0.1 ms
end	0.0 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.2 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/legacy/categories/categories.php:292

JROOT/libraries/legacy/categories/categories.php:184

JROOT/components/com_contactenhanced/router.php:77

JROOT/libraries/cms/component/router/legacy.php:68

JROOT/libraries/cms/router/site.php:483

JROOT/libraries/cms/router/site.php:452

JROOT/libraries/cms/router/router.php:280

JROOT/libraries/cms/router/site.php:134

JROOT/libraries/joomla/application/route.php:62

JROOT/components/com_contactenhanced/helpers/helper.php:258

JROOT/modules/mod_ce_form/helper.php:138

JROOT/modules/mod_ce_form/mod_ce_form.php:19

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/libraries/joomla/document/html/renderer/modules.php:43

JROOT/libraries/joomla/document/html/html.php:411

JROOT/libraries/joomla/document/html/html.php:697

JROOT/libraries/joomla/document/html/html.php:477

JROOT/libraries/cms/application/cms.php:1059

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.58 ms After last query: 6.23 ms Query memory: 0.024 MB Memory before query: 11.357 MB Rows returned: 0

SELECT id  
  FROM b3blg_categories  
  WHERE parent_id IN ( 9 )  
  AND published = 1  
  AND parent_id != 0  
  ORDER BY id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b3blg_categories	NULL	index	NULL	PRIMARY	4	NULL	8	12.50	Using where

Profile

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_zt_news/libraries/source/content.php:96

JROOT/modules/mod_zt_news/libraries/source/abstract.php:72

JROOT/modules/mod_zt_news/libraries/source/abstract.php:153

JROOT/modules/mod_zt_news/libraries/source/abstract.php:122

JROOT/modules/mod_zt_news/libraries/source/abstract.php:91

JROOT/modules/mod_zt_news/helper.php:50

JROOT/templates/zo2_contruct/html/mod_zt_news/horizontal/default.php:26

JROOT/modules/mod_zt_news/mod_zt_news.php:42

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/libraries/joomla/document/html/renderer/modules.php:43

JROOT/libraries/joomla/document/html/html.php:411

JROOT/libraries/joomla/document/html/html.php:697

JROOT/libraries/joomla/document/html/html.php:477

JROOT/libraries/cms/application/cms.php:1059

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.86 ms After last query: 0.15 ms Query memory: 0.019 MB Memory before query: 11.383 MB Rows returned: 2

SELECT a.*, cc.title as cat_title, 
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM b3blg_content AS a 
  INNER JOIN b3blg_categories AS cc 
  ON cc.id = a.catid 
  WHERE  `a`.`state` = 1 
  AND( a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-05-17 11:13:35' )  
  AND( a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-05-17 11:13:35' )  
  AND `a`.`catid` IN  ( 9 )  
  AND cc.published = 1 
  ORDER BY a.id DESC 
  LIMIT 2

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	cc	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	a	NULL	ref	idx_state,idx_catid	idx_state	1	const	5	14.29	Using where

Profile

Status	Duration
starting	0.3 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/modules/mod_zt_news/libraries/source/abstract.php:93

JROOT/modules/mod_zt_news/helper.php:50

JROOT/templates/zo2_contruct/html/mod_zt_news/horizontal/default.php:26

JROOT/modules/mod_zt_news/mod_zt_news.php:42

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/libraries/joomla/document/html/renderer/modules.php:43

JROOT/libraries/joomla/document/html/html.php:411

JROOT/libraries/joomla/document/html/html.php:697

JROOT/libraries/joomla/document/html/html.php:477

JROOT/libraries/cms/application/cms.php:1059

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.15 ms After last query: 58.57 ms Query memory: 0.023 MB Memory before query: 11.901 MB Rows returned: 1

select * 
  from b3blg_revslider_sliders 
  where id=1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b3blg_revslider_sliders	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

Profile

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
Opening tables	0.5 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:223

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:76

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:119

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:1909

JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:75

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/libraries/joomla/document/html/renderer/modules.php:43

JROOT/libraries/joomla/document/html/html.php:411

JROOT/libraries/joomla/document/html/html.php:697

JROOT/libraries/joomla/document/html/html.php:477

JROOT/libraries/cms/application/cms.php:1059

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.04 ms After last query: 0.51 ms Query memory: 0.024 MB Memory before query: 11.952 MB Rows returned: 3

select * 
  from b3blg_revslider_slides 
  where slider_id=1 
  order by slide_order

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	b3blg_revslider_slides	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	33.33	Using where; Using filesort

Profile

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
Opening tables	0.3 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.1 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:1452

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:1345

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_slider.class.php:1531

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:260

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162

JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:75

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/libraries/joomla/document/html/renderer/modules.php:43

JROOT/libraries/joomla/document/html/html.php:411

JROOT/libraries/joomla/document/html/html.php:697

JROOT/libraries/joomla/document/html/html.php:477

JROOT/libraries/cms/application/cms.php:1059

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.84 ms After last query: 0.71 ms Query memory: 0.023 MB Memory before query: 12.089 MB Rows returned: 0

Duplicate queries: #47 #48 #49 #50 #51

select * 
  from b3blg_revslider_layer_animations

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
Opening tables	0.4 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:686

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:654

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162

JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:75

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/libraries/joomla/document/html/renderer/modules.php:43

JROOT/libraries/joomla/document/html/html.php:411

JROOT/libraries/joomla/document/html/html.php:697

JROOT/libraries/joomla/document/html/html.php:477

JROOT/libraries/cms/application/cms.php:1059

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.42 ms After last query: 0.10 ms Query memory: 0.023 MB Memory before query: 12.113 MB Rows returned: 0

Duplicate queries: #46 #48 #49 #50 #51

select * 
  from b3blg_revslider_layer_animations

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:687

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:654

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162

JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:75

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/libraries/joomla/document/html/renderer/modules.php:43

JROOT/libraries/joomla/document/html/html.php:411

JROOT/libraries/joomla/document/html/html.php:697

JROOT/libraries/joomla/document/html/html.php:477

JROOT/libraries/cms/application/cms.php:1059

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.43 ms After last query: 0.31 ms Query memory: 0.023 MB Memory before query: 12.137 MB Rows returned: 0

Duplicate queries: #46 #47 #49 #50 #51

select * 
  from b3blg_revslider_layer_animations

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:686

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:654

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162

JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:75

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/libraries/joomla/document/html/renderer/modules.php:43

JROOT/libraries/joomla/document/html/html.php:411

JROOT/libraries/joomla/document/html/html.php:697

JROOT/libraries/joomla/document/html/html.php:477

JROOT/libraries/cms/application/cms.php:1059

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.39 ms After last query: 0.11 ms Query memory: 0.023 MB Memory before query: 12.160 MB Rows returned: 0

Duplicate queries: #46 #47 #48 #50 #51

select * 
  from b3blg_revslider_layer_animations

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:687

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:654

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162

JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:75

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/libraries/joomla/document/html/renderer/modules.php:43

JROOT/libraries/joomla/document/html/html.php:411

JROOT/libraries/joomla/document/html/html.php:697

JROOT/libraries/joomla/document/html/html.php:477

JROOT/libraries/cms/application/cms.php:1059

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.44 ms After last query: 0.23 ms Query memory: 0.022 MB Memory before query: 12.183 MB Rows returned: 0

Duplicate queries: #46 #47 #48 #49 #51

select * 
  from b3blg_revslider_layer_animations

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:686

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:654

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162

JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:75

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/libraries/joomla/document/html/renderer/modules.php:43

JROOT/libraries/joomla/document/html/html.php:411

JROOT/libraries/joomla/document/html/html.php:697

JROOT/libraries/joomla/document/html/html.php:477

JROOT/libraries/cms/application/cms.php:1059

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.40 ms After last query: 0.08 ms Query memory: 0.022 MB Memory before query: 12.206 MB Rows returned: 0

Duplicate queries: #46 #47 #48 #49 #50

select * 
  from b3blg_revslider_layer_animations

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:178

JROOT/administrator/components/com_uniterevolution2/inc_php/framework/db.class.php:213

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_operations.class.php:533

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:687

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:654

JROOT/administrator/components/com_uniterevolution2/inc_php/revslider_output.class.php:2162

JROOT/modules/mod_unite_revolution2/mod_unite_revolution2.php:75

JROOT/libraries/cms/module/helper.php:190

JROOT/libraries/joomla/document/html/renderer/module.php:103

JROOT/libraries/joomla/document/html/renderer/modules.php:43

JROOT/libraries/joomla/document/html/html.php:411

JROOT/libraries/joomla/document/html/html.php:697

JROOT/libraries/joomla/document/html/html.php:477

JROOT/libraries/cms/application/cms.php:1059

JROOT/libraries/cms/application/site.php:729

JROOT/libraries/cms/application/cms.php:258

JROOT/index.php:45

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.01 ms After last query: 28.34 ms Query memory: 0.003 MB Memory before query: 12.822 MB

UPDATE `b3blg_session`

  SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1715944413;s:18:\"session.timer.last\";i:1715944413;s:17:\"session.timer.now\";i:1715944413;s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"e23aac6d031ba7635ecc0b9743d8c7db\";s:16:\"mailchimp_apikey\";s:0:\"\";s:16:\"mailchimp_listid\";s:0:\"\";s:16:\"session.honeypot\";s:32:\"d9b7aaf086e6282d4b463c34f25bc75c\";}__Zt|a:1:{s:10:\"extensions\";a:1:{s:2:\"Zt\";O:8:\"stdClass\":5:{s:4:\"name\";s:13:\"Zoo Framework\";s:9:\"extension\";O:8:\"stdClass\":3:{s:4:\"type\";s:6:\"plugin\";s:5:\"
  group\";s:6:\"system\";s:4:\"name\";s:12:\"zooframework\";}s:9:\"namespace\";s:2:\"Zt\";s:5:\"admin\";i:0;s:5:\"paths\";a:3:{i:0;s:59:\"/home/copiers1/public_html/plugins/system/zooframework/core\";i:1;s:60:\"/home/copiers1/public_html/plugins/system/zooframework/local\";i:2;s:82:\"/home/copiers1/public_html/plugins/system/zooframework/templates/zo2_contruct/html\";}}}}'
	, `time` = '1715944415'

  WHERE `session_id` = '2narfa5m3kh3ou58sktb6m02t1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	b3blg_session	NULL	range	PRIMARY	PRIMARY	602	const	1	100.00	Using where

Profile

Status	Duration
starting	0.3 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.1 ms
updating	0.2 ms
end	0.0 ms
query end	1.1 ms
closing tables	0.0 ms
freeing items	0.2 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/session/storage/database.php:84

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

39 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

6 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM b3blg_categories as c 
  LEFT JOIN b3blg_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt) 
  LEFT JOIN  (SELECT cat.id as id 
  FROM b3blg_categories AS cat JOIN b3blg_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

6 × select * 
  from b3blg_revslider_layer_animation

3 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM b3blg_menu AS m 
  LEFT JOIN b3blg_extensions AS e 
  ON m.component_id = e.extension_id

2 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM b3blg_extensions

```
1 × SELECT * 
  FROM `b3blg_users`
```

1 × SELECT `g`.`id`,`g`.`title` 
  FROM `b3blg_usergroups` AS g 
  INNER JOIN `b3blg_user_usergroup_map` AS m 
  ON m.group_id = g.id

1 × SELECT a.id,a.title,a.state,a.access,a.catid,a.created,a.language, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug 
  FROM b3blg_content as a 
  LEFT JOIN b3blg_categories as c 
  on a.catid=c.id

1 × SELECT `t`.`id` 
  FROM `b3blg_tags` AS t  
  INNER JOIN `b3blg_contentitem_tag_map` AS m 
  ON `m`.`tag_id` = `t`.`id` 
  AND `m`.`type_alias` = 'com_contactenhanced.contact' 
  AND `m`.`content_item_id` IN ( 2

1 × SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias 
  FROM b3blg_ce_details AS a 
  LEFT JOIN b3blg_categories AS c 
  on c.id = a.catid 
  LEFT JOIN b3blg_categories as parent 
  ON parent.id = c.parent_id

1 × SELECT a.*, cc.access as category_access, cc.title as category_name,  
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM b3blg_ce_details AS a 
  INNER JOIN b3blg_categories AS cc 
  on cc.id = a.catid

1 × SELECT cf.* 
  FROM b3blg_ce_cf AS cf

1 × select * 
  from b3blg_revslider_sliders

1 × select * 
  from b3blg_revslider_slides

1 × SELECT a.*, cc.title as cat_title, 
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM b3blg_content AS a 
  INNER JOIN b3blg_categories AS cc 
  ON cc.id = a.catid

1 × SELECT id  
  FROM b3blg_categories

```
1 × SELECT * 
  FROM `b3blg_content
```

1 × SELECT `t`.`id` 
  FROM `b3blg_tags` AS t  
  INNER JOIN `b3blg_contentitem_tag_map` AS m 
  ON `m`.`tag_id` = `t`.`id` 
  AND `m`.`type_alias` = 'com_users.user' 
  AND `m`.`content_item_id` IN ( 845

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `b3blg_contentitem_tag_map` AS m  
  INNER JOIN `b3blg_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT id, home, template, s.params 
  FROM b3blg_template_styles as s 
  LEFT JOIN b3blg_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT `template_style_id` 
  FROM `b3blg_menu`

1 × SELECT folder AS type, element AS name, params 
  FROM b3blg_extensions

1 × SELECT id, rules 
  FROM `b3blg_viewlevels

1 × SELECT `session_id` 
  FROM `b3blg_session`

1 × SELECT b.id 
  FROM b3blg_usergroups AS a 
  LEFT JOIN b3blg_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT alias 
  FROM b3blg_content

```
1 × SELECT * 
  FROM b3blg_languages
```

1 × SELECT `data` 
  FROM `b3blg_session`

```
1 × SELECT * 
  FROM b3blg_content
```

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM b3blg_content AS a 
  LEFT JOIN b3blg_categories AS c 
  on c.id = a.catid 
  LEFT JOIN b3blg_users AS u 
  on u.id = a.created_by 
  LEFT JOIN b3blg_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN b3blg_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM b3blg_categories AS cat JOIN b3blg_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT b.rules 
  FROM b3blg_assets AS a 
  LEFT JOIN b3blg_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT a.rules 
  FROM b3blg_assets AS a

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM b3blg_modules AS m 
  LEFT JOIN b3blg_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN b3blg_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

OTHER Tables:

1 × SHOW FULL COLUMNS 
  FROM `b3blg_users

1 × UPDATE `b3blg_session` 
  SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1715944413;s:18:\"session.timer.last\";i:1715944413;s:17:\"session.timer.now\";i:1715944413;s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"e23aac6d031ba7635ecc0b9743d8c7db\";s:16:\"mailchimp_apikey\";s:0:\"\";s:16:\"mailchimp_listid\";s:0:\"\";s:16:\"session.honeypot\";s:32:\"d9b7aaf086e6282d4b463c34f25bc75c\";}__Zt|a:1:{s:10:\"extensions\";a:1:{s:2:\"Zt\";O:8:\"stdClass\":5:{s:4:\"name\";s:13:\"Zoo Framework\";s:9:\"extension\";O:8:\"stdClass\":3:{s:4:\"type\";s:6:\"plugin\";s:5:\"
  group\";s:6:\"system\";s:4:\"name\";s:12:\"zooframework\";}s:9:\"namespace\";s:2:\"Zt\";s:5:\"admin\";i:0;s:5:\"paths\";a:3:{i:0;s:59:\"/home/copiers1/public_html/plugins/system/zooframework/core\";i:1;s:60:\"/home/copiers1/public_html/plugins/system/zooframework/local\";i:2;s:82:\"/home/copiers1/public_html/plugins/system/zooframework/templates/zo2_contruct/html\";}}}}'  , `time` = '1715944415'

1 × UPDATE b3blg_content 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `b3blg_content

1 × INSERT INTO `b3blg_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('2narfa5m3kh3ou58sktb6m02t1', 0, '1715944413'

1 × UPDATE `b3blg_extensions` 
  SET `params` = '{\"mediaversion\":\"c207519192062574d47349cf11ffff37\"}'

```
1 × DELETE  
  FROM `b3blg_session`
```

Products & Services

Copier Sales

Copier Rental

Get a Quote

Product Models

Ricoh Alficio MP C5501

Fuji Xerox C5570

Canon C5035

Canon IR C2030

Fuji Xerox C4470

Ricoh Alficio MP C4501

Product Models

27 Years Of Industry Experience

Reputable And Recognized

Authorized Brands Distributor

Excellent After Sales Service

Testimonials

Newsletter

Quick Link

Our Brands

New Products

Joomla! Debug Console

Session

__default

__Zt

Profile Information

Time

Memory

Memory Usage

Database Queries

52 Queries Logged 139.1 ms

8 duplicate found!

39 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: