Callcentre Providing quality customer service is imperative in today's competitive business environment. So choosing the right technology to support you is even more important.

CPS Technology Group can partner with you to evaluate, choose and implement the solution with the best fit for your particular operational environment, whether your contact centre has 5 agents or 150. We offer IP standards-based innovative contact management and interactive voice response solutions (IVR) which integrate fully with your information systems and provide a ‘whole of communication’ approach to calls, email, web chats, voicemail and faxes.

These solutions will assist you in improving customer satisfaction and increasing customer retention through self-service options, fax response, and call qualification. In particular, these solutions will help to manage overwhelming call volumes, regulate call distribution to employees in a workgroup, increase employee productivity and automate customer interactions without employee intervention.

This approach ensures a quality of assistance and breadth of service that will set you apart from your competition and also help you secure long-term, profitable relationships with your most important asset, your customers.

NEXT STEP

Solutions

Melbourne

Level 1
59 Whitehorse Road
Deepdene, VIC 3103

1300 65 98 28

This email address is being protected from spambots. You need JavaScript enabled to view it.

Sydney

Suite 129, Level 12
1 Pacific Highway
North Sydney, NSW 2060

1300 65 98 28

This email address is being protected from spambots. You need JavaScript enabled to view it.

Joomla! Debug Console

Session

Profile Information

Time

Memory

Time: 0.0 ms / 0.0 ms Memory: 0.258 MB / 0.26 MB Application: afterLoad

Time: 129.9 ms / 129.9 ms Memory: 1.108 MB / 1.37 MB Application: afterInitialise

Time: 75.2 ms / 205.1 ms Memory: 0.731 MB / 2.10 MB Application: afterRoute

Time: 167.0 ms / 372.0 ms Memory: 0.862 MB / 2.96 MB Application: afterDispatch

Time: 720.7 ms / 1092.7 ms Memory: 0.281 MB / 3.24 MB Application: beforeRenderModule mod_menu (Bottom Menu)

Time: 6.8 ms / 1099.5 ms Memory: 0.027 MB / 3.27 MB Application: afterRenderModule mod_menu (Bottom Menu)

Time: 0.0 ms / 1099.5 ms Memory: 0.000 MB / 3.26 MB Application: beforeRenderModule mod_custom (Sydney Map)

Time: 3.9 ms / 1103.4 ms Memory: 0.008 MB / 3.27 MB Application: afterRenderModule mod_custom (Sydney Map)

Time: 0.0 ms / 1103.4 ms Memory: 0.000 MB / 3.27 MB Application: beforeRenderModule mod_custom (Contact Details Sydney)

Time: 2.9 ms / 1106.4 ms Memory: 0.007 MB / 3.28 MB Application: afterRenderModule mod_custom (Contact Details Sydney)

Time: 0.0 ms / 1106.4 ms Memory: 0.000 MB / 3.28 MB Application: beforeRenderModule mod_custom (Melbourne Map)

Time: 2.0 ms / 1108.3 ms Memory: 0.005 MB / 3.28 MB Application: afterRenderModule mod_custom (Melbourne Map)

Time: 0.0 ms / 1108.3 ms Memory: 0.000 MB / 3.28 MB Application: beforeRenderModule mod_custom (Contact Details Melbourne)

Time: 2.0 ms / 1110.3 ms Memory: 0.005 MB / 3.29 MB Application: afterRenderModule mod_custom (Contact Details Melbourne)

Time: 0.0 ms / 1110.3 ms Memory: 0.000 MB / 3.29 MB Application: beforeRenderModule mod_menu (Solutions)

Time: 4.9 ms / 1115.2 ms Memory: 0.018 MB / 3.31 MB Application: afterRenderModule mod_menu (Solutions)

Time: 0.0 ms / 1115.2 ms Memory: 0.000 MB / 3.30 MB Application: beforeRenderModule mod_search (Search)

Time: 3.9 ms / 1119.1 ms Memory: 0.014 MB / 3.32 MB Application: afterRenderModule mod_search (Search)

Time: 17.6 ms / 1136.6 ms Memory: 0.115 MB / 3.43 MB Application: afterRender

Database queries total: 324.2 ms

Memory Usage

Database Queries

39 Queries Logged 324.2 ms

4 duplicate found!

2 duplicates: #12 #37

2 duplicates: #35 #36

Query Time: 0.00 ms Query memory: 0.009 MB Memory before query: 0.572 MB Rows returned: 0

SELECT `data`

  FROM `biza5_session`

  WHERE `session_id` = '98kcdrmmjt8hsevq9hbt57abf0'

Explain

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

Profile

Status	Duration
starting	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
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT\libraries\joomla\database\driver.php:1356

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: 36.13 ms After last query: 1.95 ms Query memory: 0.005 MB Memory before query: 0.608 MB

DELETE 

  FROM `biza5_session`

  WHERE `time` < '1594567127'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	biza5_session	range	time	time	45	const	1	100.00	Using where

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.1 ms
updating	0.1 ms
end	0.0 ms
query end	35.0 ms
closing tables	0.0 ms
freeing items	0.0 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.00 ms Query memory: 0.007 MB Memory before query: 0.616 MB Rows returned: 0

SELECT `session_id`

  FROM `biza5_session`

  WHERE `session_id` = '98kcdrmmjt8hsevq9hbt57abf0' 
  LIMIT 0, 1

Explain

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

Profile

Status	Duration
starting	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
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT\libraries\joomla\database\driver.php:1356

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: 35.15 ms Query memory: 0.005 MB Memory before query: 0.623 MB

INSERT INTO `biza5_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('98kcdrmmjt8hsevq9hbt57abf0', 0, '1594568027')

Explain

EXPLAIN not possible on query: INSERT INTO `biza5_session` (`session_id`, `client_id`, `time`) VALUES ('98kcdrmmjt8hsevq9hbt57abf0', 0, '1594568027')

Profile

Status	Duration
starting	0.0 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	34.6 ms
closing tables	0.0 ms
freeing items	0.0 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: 0.98 ms After last query: 2.93 ms Query memory: 0.012 MB Memory before query: 0.678 MB Rows returned: 42

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

  FROM biza5_extensions

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	biza5_extensions	ref	extension	extension	62	const	42	100.00	Using index condition

Profile

Status	Duration
starting	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
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\database\driver.php:1317

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: 0.00 ms After last query: 0.98 ms Query memory: 0.009 MB Memory before query: 0.713 MB Rows returned: 1

SELECT b.id

  FROM biza5_usergroups AS a

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

  WHERE a.id = 1

Explain

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

Profile

Status	Duration
starting	0.0 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
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.0 ms
cleaning up	0.0 ms

Call Stack

JROOT\libraries\joomla\database\driver.php:1167

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: 0.00 ms After last query: 0.98 ms Query memory: 0.008 MB Memory before query: 0.725 MB Rows returned: 3

SELECT id, rules

  FROM `biza5_viewlevels`

Explain

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

Profile

Status	Duration
starting	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.0 ms
cleaning up	0.0 ms

Call Stack

JROOT\libraries\joomla\database\driver.php:1123

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: 0.98 ms Query memory: 0.008 MB Memory before query: 0.736 MB Rows returned: 62

SELECT folder AS type, element AS name, params

  FROM biza5_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	biza5_extensions	ref	extension	extension	62	const	87	100.00	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	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.5 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT\libraries\joomla\database\driver.php:1317

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: 0.00 ms After last query: 10.74 ms Query memory: 0.010 MB Memory before query: 0.992 MB Rows returned: 0

SELECT *

  FROM `biza5_admintools_wafexceptions`

  WHERE NOT(`option` LIKE 'com_%')

Explain

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

Profile

Status	Duration
starting	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.0 ms
cleaning up	0.0 ms

Call Stack

JROOT\libraries\joomla\database\driver.php:1123

JROOT\plugins\system\admintools\admintools\main.php:526

JROOT\plugins\system\admintools\admintools\main.php:447

JROOT\plugins\system\admintools\admintools\main.php:90

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.98 ms After last query: 1.95 ms Query memory: 0.011 MB Memory before query: 1.013 MB Rows returned: 1

SELECT `value`

  FROM `biza5_admintools_storage`

  WHERE `key` = 'cparams'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	biza5_admintools_storage	const	PRIMARY	PRIMARY	767	const	1	100.00	NULL

Profile

Status	Duration
starting	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.0 ms
cleaning up	0.0 ms

Call Stack

JROOT\libraries\joomla\database\driver.php:1356

JROOT\administrator\components\com_admintools\models\storage.php:99

JROOT\administrator\components\com_admintools\models\storage.php:49

JROOT\plugins\system\admintools\feature\httpsizer.php:26

JROOT\plugins\system\admintools\admintools\main.php:356

JROOT\plugins\system\admintools\admintools\main.php:93

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.98 ms After last query: 14.65 ms Query memory: 0.012 MB Memory before query: 1.241 MB Rows returned: 1

SHOW VARIABLES LIKE "collation_database"

Explain

EXPLAIN not possible on query: SHOW VARIABLES LIKE "collation_database"

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.3 ms
Sending data	0.0 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.0 ms
cleaning up	0.0 ms

Call Stack

JROOT\libraries\joomla\database\driver.php:1278

JROOT\libraries\joomla\database\driver\mysqli.php:320

JROOT\plugins\system\admintools\feature\utf8mb4.php:28

JROOT\plugins\system\admintools\admintools\main.php:685

JROOT\plugins\system\admintools\admintools\main.php:118

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:654

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.95 ms After last query: 6.84 ms Query memory: 0.020 MB Memory before query: 1.406 MB Rows returned: 65

Duplicate queries: #37

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 biza5_menu AS m

  LEFT JOIN biza5_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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	150	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	localhost_cpstg.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.1 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	1.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\database\driver.php:1317

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\router\site.php:57

JROOT\libraries\cms\router\router.php:196

JROOT\libraries\cms\application\cms.php:520

JROOT\libraries\cms\application\site.php:407

JROOT\libraries\cms\application\cms.php:1088

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: 0.00 ms After last query: 13.67 ms Query memory: 0.011 MB Memory before query: 1.983 MB Rows returned: 1

SELECT a.rules

  FROM biza5_assets AS a

  WHERE (a.id = 1)

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

Explain

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

Profile

Status	Duration
starting	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.0 ms
cleaning up	0.0 ms

Call Stack

JROOT\libraries\joomla\database\driver.php:1167

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

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

JROOT\plugins\system\sourcerer\helper.php:59

JROOT\plugins\system\sourcerer\sourcerer.php:97

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: 2.93 ms After last query: 0.98 ms Query memory: 0.012 MB Memory before query: 2.000 MB Rows returned: 1

SELECT b.rules

  FROM biza5_assets AS a

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

  WHERE (a.id = 1)

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

  ORDER BY b.lft

Explain

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

Profile

Status	Duration
starting	0.0 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
Creating tmp table	0.1 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	1.9 ms
Creating sort index	0.1 ms
end	0.0 ms
removing tmp table	1.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT\libraries\joomla\database\driver.php:1167

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

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

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

JROOT\plugins\system\sourcerer\helper.php:59

JROOT\plugins\system\sourcerer\sourcerer.php:97

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: 0.00 ms After last query: 0.98 ms Query memory: 0.015 MB Memory before query: 2.035 MB Rows returned: 1

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

  FROM biza5_extensions

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	biza5_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using index condition

Profile

Status	Duration
starting	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
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.0 ms
cleaning up	0.0 ms

Call Stack

JROOT\libraries\joomla\database\driver.php:1278

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\plugins\system\sef\sef.php:29

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: 50.78 ms Query memory: 0.011 MB Memory before query: 2.034 MB

UPDATE `biza5_extensions`

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	biza5_extensions	range	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using where

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.1 ms
updating	0.1 ms
end	0.0 ms
query end	49.7 ms
closing tables	0.0 ms
freeing items	3.4 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\plugins\system\sef\sef.php:29

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: 0.00 ms After last query: 2.93 ms Query memory: 0.009 MB Memory before query: 2.114 MB Rows returned: 1

SELECT *

  FROM biza5_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	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
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.9 ms
cleaning up	0.0 ms

Call Stack

JROOT\libraries\joomla\database\driver.php:1317

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: 0.98 ms After last query: 0.98 ms Query memory: 0.007 MB Memory before query: 2.128 MB Rows returned: 6

SELECT id, home, template, s.params

  FROM biza5_template_styles as s

  LEFT JOIN biza5_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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	9	100.00	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	localhost_cpstg.s.template,const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	0.0 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
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	6.9 ms
cleaning up	0.0 ms

Call Stack

JROOT\libraries\joomla\database\driver.php:1317

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

JROOT\libraries\cms\application\site.php:165

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.95 ms After last query: 6.83 ms Query memory: 0.016 MB Memory before query: 2.269 MB Rows returned: 2

SELECT b.rules

  FROM biza5_assets AS a

  LEFT JOIN biza5_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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	idx_asset_name	idx_asset_name	152	const	1	100.00	Using temporary; Using filesort
1	SIMPLE	b	range	idx_lft_rgt	idx_lft_rgt	4	NULL	15	100.00	Using where

Profile

Status	Duration
starting	0.0 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
Creating tmp table	0.1 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	1.2 ms
Creating sort index	0.1 ms
end	0.0 ms
removing tmp table	0.5 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	1.1 ms
cleaning up	0.0 ms

Call Stack

JROOT\libraries\joomla\database\driver.php:1167

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:16

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: 0.98 ms After last query: 0.98 ms Query memory: 0.022 MB Memory before query: 2.295 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 biza5_content AS a

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

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

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

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

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM biza5_categories AS cat JOIN biza5_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 = 66 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-07-12 15:33:48') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-07-12 15:33:48') 
  AND (a.state = 1 OR a.state =2)

Explain

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

Profile

Status	Duration
starting	0.2 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	0.1 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.1 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.1 ms
Creating sort index	0.0 ms
removing tmp table	0.0 ms
Creating sort index	0.0 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	3.1 ms
cleaning up	0.0 ms

Call Stack

JROOT\libraries\joomla\database\driver.php:1278

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:16

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.93 ms After last query: 2.93 ms Query memory: 0.017 MB Memory before query: 2.366 MB Rows returned: 3

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 biza5_categories as c

  LEFT JOIN biza5_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 biza5_categories AS cat JOIN biza5_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) 
  AND c.published = 1 
  AND s.id=37 
  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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Using filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	45	51.11	Using where
1	PRIMARY	<derived2>	ref	<auto_key0>	<auto_key0>	4	localhost_cpstg.c.id	10	100.00	Using where; Not exists; Using index
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	8	100.00	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	45	100.00	Using where; Using index; Using join buffer (Block Nested Loop)

Profile

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
checking permissions	0.0 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
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.1 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.1 ms
Creating sort index	0.0 ms
removing tmp table	0.0 ms
Creating sort index	1.4 ms
Creating sort index	0.1 ms
end	0.0 ms
removing tmp table	0.5 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	2.2 ms
cleaning up	0.0 ms

Call Stack

JROOT\libraries\joomla\database\driver.php:1317

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

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

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

JROOT\components\com_content\views\article\view.html.php:71

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:16

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: 0.00 ms After last query: 2.93 ms Query memory: 0.016 MB Memory before query: 2.410 MB Rows returned: 0

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

  FROM `biza5_contentitem_tag_map` AS m 

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

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

Explain

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

Profile

Status	Duration
starting	0.0 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
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	1.6 ms
cleaning up	0.0 ms

Call Stack

JROOT\libraries\joomla\database\driver.php:1317

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:16

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: 0.00 ms After last query: 22.46 ms Query memory: 0.014 MB Memory before query: 2.637 MB Rows returned: 1

SELECT created_by, catid

  FROM biza5_content

  WHERE id = 66

Explain

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

Profile

Status	Duration
starting	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.0 ms
cleaning up	0.0 ms

Call Stack

JROOT\libraries\joomla\database\driver.php:1317

JROOT\plugins\attachments\attachments_for_content\attachments_for_content.php:809

JROOT\plugins\content\attachments\attachments.php:312

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

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

JROOT\components\com_content\views\article\view.html.php:166

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:16

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.93 ms After last query: 0.98 ms Query memory: 0.018 MB Memory before query: 2.654 MB Rows returned: 5

SELECT b.rules

  FROM biza5_assets AS a

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

  WHERE (a.name = 'com_content.article.66')

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

  ORDER BY b.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	idx_asset_name	idx_asset_name	152	const	1	100.00	Using temporary; Using filesort
1	SIMPLE	b	ALL	idx_lft_rgt	NO INDEX KEY COULD BE USED	NULL	NULL	276	64.13	Using where

Profile

Status	Duration
starting	0.0 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
Creating tmp table	0.6 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	1.5 ms
Creating sort index	0.1 ms
end	0.0 ms
removing tmp table	0.7 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT\libraries\joomla\database\driver.php:1167

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

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

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

JROOT\administrator\components\com_attachments\permissions.php:125

JROOT\plugins\attachments\attachments_for_content\attachments_for_content.php:884

JROOT\plugins\attachments\attachments_plugin_framework\attachments_plugin.php:862

JROOT\plugins\content\attachments\attachments.php:318

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

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

JROOT\components\com_content\views\article\view.html.php:166

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:16

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: 3.91 ms Query memory: 0.018 MB Memory before query: 2.713 MB Rows returned: 2

SELECT b.rules

  FROM biza5_assets AS a

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

  WHERE (a.name = 'com_attachments')

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

  ORDER BY b.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	idx_asset_name	idx_asset_name	152	const	1	100.00	Using temporary; Using filesort
1	SIMPLE	b	ALL	idx_lft_rgt	NO INDEX KEY COULD BE USED	NULL	NULL	276	99.28	Using where

Profile

Status	Duration
starting	0.0 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
Creating tmp table	0.1 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	1.3 ms
Creating sort index	0.1 ms
end	0.0 ms
removing tmp table	0.6 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT\libraries\joomla\database\driver.php:1167

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

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

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

JROOT\components\com_attachments\models\attachments.php:405

JROOT\components\com_attachments\models\attachments.php:514

JROOT\components\com_attachments\controllers\attachments.php:98

JROOT\plugins\attachments\attachments_plugin_framework\attachments_plugin.php:911

JROOT\plugins\content\attachments\attachments.php:318

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

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

JROOT\components\com_content\views\article\view.html.php:166

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:16

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.93 ms After last query: 0.98 ms Query memory: 0.023 MB Memory before query: 2.774 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `biza5_assets`

Explain

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

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	1.7 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.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.9 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT\libraries\joomla\database\driver.php:1317

JROOT\libraries\joomla\database\driver\mysqli.php:397

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

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

JROOT\libraries\joomla\table\asset.php:61

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

JROOT\libraries\joomla\access\access.php:100

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

JROOT\components\com_attachments\models\attachments.php:429

JROOT\components\com_attachments\models\attachments.php:514

JROOT\components\com_attachments\controllers\attachments.php:98

JROOT\plugins\attachments\attachments_plugin_framework\attachments_plugin.php:911

JROOT\plugins\content\attachments\attachments.php:318

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

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

JROOT\components\com_content\views\article\view.html.php:166

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:16

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: 0.98 ms After last query: 0.98 ms Query memory: 0.018 MB Memory before query: 2.812 MB Rows returned: 1

SELECT id

  FROM biza5_assets

  WHERE parent_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	biza5_assets	ref	idx_parent_id	idx_parent_id	4	const	1	100.00	Using index

Profile

Status	Duration
starting	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.0 ms
cleaning up	0.0 ms

Call Stack

JROOT\libraries\joomla\database\driver.php:1167

JROOT\libraries\joomla\table\nested.php:1226

JROOT\libraries\joomla\access\access.php:101

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

JROOT\components\com_attachments\models\attachments.php:429

JROOT\components\com_attachments\models\attachments.php:514

JROOT\components\com_attachments\controllers\attachments.php:98

JROOT\plugins\attachments\attachments_plugin_framework\attachments_plugin.php:911

JROOT\plugins\content\attachments\attachments.php:318

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

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

JROOT\components\com_content\views\article\view.html.php:166

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:16

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: 0.00 ms Query memory: 0.020 MB Memory before query: 2.826 MB Rows returned: 0

SELECT a.*, u.name as creator_name

  FROM biza5_attachments AS a

  LEFT JOIN biza5_users AS u 
  ON u.id = a.created_by

  WHERE a.parent_id=66 
  AND a.state = 1 
  AND a.parent_type='com_content' 
  AND a.parent_entity='article' 
  AND a.access IN (1)

  ORDER BY filename

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	10	100.00	Using where; Using filesort
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	localhost_cpstg.a.created_by	1	100.00	NULL

Profile

Status	Duration
starting	0.0 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
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\libraries\joomla\database\driver.php:1317

JROOT\components\com_attachments\models\attachments.php:436

JROOT\components\com_attachments\models\attachments.php:514

JROOT\components\com_attachments\controllers\attachments.php:98

JROOT\plugins\attachments\attachments_plugin_framework\attachments_plugin.php:911

JROOT\plugins\content\attachments\attachments.php:318

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

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

JROOT\components\com_content\views\article\view.html.php:166

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:16

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.93 ms After last query: 2.93 ms Query memory: 0.017 MB Memory before query: 2.846 MB Rows returned: 30

SHOW FULL COLUMNS 
  FROM `biza5_content`

Explain

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

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	1.9 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.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.1 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	1.1 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

JROOT\libraries\joomla\database\driver.php:1317

JROOT\libraries\joomla\database\driver\mysqli.php:397

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:16

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: 0.00 ms After last query: 2.93 ms Query memory: 0.017 MB Memory before query: 2.920 MB Rows returned: 1

SELECT *

  FROM biza5_content

  WHERE `id` = '66'

Explain

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

Profile

Status	Duration
starting	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\joomla\database\driver.php:1082

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:16

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: 87.88 ms After last query: 0.98 ms Query memory: 0.010 MB Memory before query: 2.933 MB

UPDATE biza5_content

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

  WHERE `id` = '66'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	biza5_content	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profile

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
updating	0.1 ms
end	0.0 ms
query end	87.5 ms
closing tables	0.0 ms
freeing items	0.0 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:16

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: 0.00 ms After last query: 12.70 ms Query memory: 0.011 MB Memory before query: 2.981 MB Rows returned: 1

SELECT * 
  FROM biza5_template_styles 
  WHERE template = 'design_control';

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	biza5_template_styles	ref	idx_template	idx_template	152	const	1	100.00	Using index condition

Profile

Status	Duration
starting	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
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.0 ms
cleaning up	0.0 ms

Call Stack

JROOT\libraries\joomla\database\driver.php:1123

JROOT\templates\design_control\vertex\parameters.php:19

JROOT\templates\design_control\vertex\parameters.php:165

JROOT\templates\design_control\index.php:21

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: 0.98 ms Query memory: 0.014 MB Memory before query: 2.992 MB Rows returned: 0

SELECT * 
  FROM biza5_menu 
  WHERE template_style_id IN (15) 
  AND alias = 'contact-centre'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	biza5_menu	ref	idx_alias	idx_alias	767	const	2	100.00	Using index condition; Using where

Profile

Status	Duration
starting	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.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT\libraries\joomla\database\driver.php:1123

JROOT\templates\design_control\vertex\parameters.php:40

JROOT\templates\design_control\vertex\parameters.php:165

JROOT\templates\design_control\index.php:21

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: 0.98 ms After last query: 13.67 ms Query memory: 0.014 MB Memory before query: 3.118 MB Rows returned: 16

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

  FROM biza5_modules AS m

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

  LEFT JOIN biza5_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 <= '2020-07-12 15:33:48') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-07-12 15:33:48') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 209 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	38	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	localhost_cpstg.m.module,const	1	100.00	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	localhost_cpstg.m.id	2	100.00	Using where; Using index

Profile

Status	Duration
starting	0.1 ms
checking permissions	0.0 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.8 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\database\driver.php:1317

JROOT\libraries\cms\module\helper.php:408

JROOT\libraries\cms\module\helper.php:351

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

JROOT\libraries\joomla\document\html\html.php:501

JROOT\templates\design_control\vertex\module_calcs.php:15

JROOT\templates\design_control\index.php:23

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: 0.00 ms After last query: 5.86 ms Query memory: 0.011 MB Memory before query: 3.153 MB Rows returned: 0

Duplicate queries: #36

SELECT menutype  
  FROM  biza5_menu 
  WHERE language = 'en-GB' 
  AND home = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	biza5_menu	ref	idx_language	idx_language	21	const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	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.0 ms
cleaning up	0.0 ms

Call Stack

JROOT\libraries\joomla\database\driver.php:1356

JROOT\templates\design_control\vertex\responsive\responsive_mobile_menu.php:139

JROOT\templates\design_control\vertex\responsive\responsive_mobile_top_bar.php:75

JROOT\templates\design_control\vertex\includes\vertex_includes_top.php:3

JROOT\templates\design_control\index.php:191

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: 0.98 ms After last query: 17.58 ms Query memory: 0.009 MB Memory before query: 3.233 MB Rows returned: 0

Duplicate queries: #35

SELECT menutype  
  FROM  biza5_menu 
  WHERE language = 'en-GB' 
  AND home = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	biza5_menu	ref	idx_language	idx_language	21	const	1	100.00	Using index condition; Using where

Profile

Status	Duration
starting	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.0 ms
cleaning up	0.0 ms

Call Stack

JROOT\libraries\joomla\database\driver.php:1356

JROOT\templates\design_control\vertex\s5flex_menu\default.php:45

JROOT\templates\design_control\index.php:272

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: 0.98 ms After last query: 0.98 ms Query memory: 0.020 MB Memory before query: 3.255 MB Rows returned: 65

Duplicate queries: #12

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 biza5_menu AS m

  LEFT JOIN biza5_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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	150	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	localhost_cpstg.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.1 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
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	1.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\database\driver.php:1317

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

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

JROOT\templates\design_control\vertex\s5flex_menu\helpers.php:41

JROOT\templates\design_control\vertex\s5flex_menu\helpers.php:141

JROOT\templates\design_control\vertex\s5flex_menu\default.php:54

JROOT\templates\design_control\index.php:272

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: 0.98 ms After last query: 11.72 ms Query memory: 0.015 MB Memory before query: 3.530 MB Rows returned: 16

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

  FROM biza5_modules AS m

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

  WHERE m.published = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2020-07-12 15:33:48') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-07-12 15:33:48') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 209 OR mm.menuid <= 0)

  ORDER BY position, ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published	published	1	const	38	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	localhost_cpstg.m.id	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	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.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\joomla\database\driver.php:1317

JROOT\templates\design_control\vertex\s5flex_menu\module_helper.php:313

JROOT\templates\design_control\vertex\s5flex_menu\module_helper.php:83

JROOT\templates\design_control\vertex\s5flex_menu\helpers.php:579

JROOT\templates\design_control\vertex\s5flex_menu\helpers.php:359

JROOT\templates\design_control\vertex\s5flex_menu\helpers.php:309

JROOT\templates\design_control\vertex\s5flex_menu\default.php:54

JROOT\templates\design_control\index.php:272

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: 80.07 ms After last query: 707.96 ms Query memory: 0.002 MB Memory before query: 3.423 MB

UPDATE `biza5_session`

  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1594568027;s:18:\"session.timer.last\";i:1594568027;s:17:\"session.timer.now\";i:1594568027;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":1:{s:15:\"com_attachments\";O:8:\"stdClass\":1:{s:11:\"current_url\";s:82:\"&return=aHR0cHM6Ly9jcHN0Zy5jb20vaW5kZXgucGhwL3NvbHV0aW9ucy9jb250YWN0LWNlbnRyZT8%3D\";}}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;i:1;}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:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}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:16:\"com_mailto.links\";a:1:{s:40:\"b5fad010b9c2fee1d47f736e5184dac135654b49\";O:8:\"stdClass\":2:{s:4:\"link\";s:52:\"https://cpstg.com/index.php/solutions/contact-centre\";s:6:\"expiry\";i:1594568028;}}}'
	, `time` = '1594568029'

  WHERE `session_id` = '98kcdrmmjt8hsevq9hbt57abf0'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	biza5_session	range	PRIMARY	PRIMARY	602	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.1 ms
end	0.0 ms
query end	78.7 ms
closing tables	0.0 ms
freeing items	0.0 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.]

33 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

4 × SELECT b.rules
 
  FROM biza5_assets AS a
 
  LEFT JOIN biza5_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

2 × 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 biza5_menu AS m
 
  LEFT JOIN biza5_extensions AS e 
  ON m.component_id = e.extension_id

2 × SELECT menutype  
  FROM  biza5_menu

2 × SELECT extension_id AS id, element AS "option", params, enabled
 
  FROM biza5_extensions

1 × SELECT a.*, u.name as creator_name
 
  FROM biza5_attachments AS a
 
  LEFT JOIN biza5_users AS u 
  ON u.id = a.created_by

1 × SELECT `m`.`tag_id`,`t`.*
 
  FROM `biza5_contentitem_tag_map` AS m 
 
  INNER JOIN `biza5_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

```
1 × SELECT id
 
  FROM biza5_assets
```

1 × SELECT created_by, catid
 
  FROM biza5_content

1 × SELECT * 
  FROM biza5_template_styles

1 × SELECT id, title, module, position, content, showtitle, params, mm.menuid
 
  FROM biza5_modules AS m
 
  LEFT JOIN biza5_modules_menu AS mm 
  ON mm.moduleid = m.id

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
 
  FROM biza5_modules AS m
 
  LEFT JOIN biza5_modules_menu AS mm 
  ON mm.moduleid = m.id
 
  LEFT JOIN biza5_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

```
1 × SELECT * 
  FROM biza5_menu
```

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 biza5_categories as c
 
  LEFT JOIN biza5_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 biza5_categories AS cat JOIN biza5_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

```
1 × SELECT *
 
  FROM biza5_content
```

1 × SELECT id, home, template, s.params
 
  FROM biza5_template_styles as s
 
  LEFT JOIN biza5_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT folder AS type, element AS name, params
 
  FROM biza5_extensions

1 × SELECT id, rules
 
  FROM `biza5_viewlevels

1 × SELECT b.id
 
  FROM biza5_usergroups AS a
 
  LEFT JOIN biza5_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT `session_id`
 
  FROM `biza5_session`

1 × SELECT *
 
  FROM `biza5_admintools_wafexceptions`

1 × SELECT `value`
 
  FROM `biza5_admintools_storage`

1 × SELECT `data`
 
  FROM `biza5_session`

```
1 × SELECT *
 
  FROM biza5_languages
```

1 × SELECT a.rules
 
  FROM biza5_assets AS a

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 biza5_content AS a
 
  LEFT JOIN biza5_categories AS c 
  on c.id = a.catid
 
  LEFT JOIN biza5_users AS u 
  on u.id = a.created_by
 
  LEFT JOIN biza5_categories as parent 
  ON parent.id = c.parent_id
 
  LEFT JOIN biza5_content_rating AS v 
  ON a.id = v.content_id
 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM biza5_categories AS cat JOIN biza5_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

OTHER Tables:

1 × SHOW FULL COLUMNS 
  FROM `biza5_content

1 × UPDATE biza5_content
 
  SET `hits` = (`hits` + 1)

1 × UPDATE `biza5_session`
 
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1594568027;s:18:\"session.timer.last\";i:1594568027;s:17:\"session.timer.now\";i:1594568027;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":1:{s:15:\"com_attachments\";O:8:\"stdClass\":1:{s:11:\"current_url\";s:82:\"&return=aHR0cHM6Ly9jcHN0Zy5jb20vaW5kZXgucGhwL3NvbHV0aW9ucy9jb250YWN0LWNlbnRyZT8%3D\";}}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;i:1;}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:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}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:16:\"com_mailto.links\";a:1:{s:40:\"b5fad010b9c2fee1d47f736e5184dac135654b49\";O:8:\"stdClass\":2:{s:4:\"link\";s:52:\"https://cpstg.com/index.php/solutions/contact-centre\";s:6:\"expiry\";i:1594568028;}}}'  , `time` = '1594568029'

1 × SHOW FULL COLUMNS 
  FROM `biza5_assets

1 × UPDATE `biza5_extensions`
 
  SET `params` = '{\"mediaversion\":\"b64f975f52756b09d738ee2252d91e42\"}'

1 × INSERT INTO `biza5_session`
 (`session_id`, `client_id`, `time`) 
  VALUES 
 ('98kcdrmmjt8hsevq9hbt57abf0', 0, '1594568027'

1 × SHOW VARIABLES LIKE "collation_database

```
1 × DELETE 
 
  FROM `biza5_session`
```

Contact Centre Solutions to improve customer service

Solutions

Joomla! Debug Console

Session

__default

Profile Information

Time

Memory

Memory Usage

Database Queries

39 Queries Logged 324.2 ms

4 duplicate found!

33 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: