Joomla! Debug Console

19 Queries Logged 10.8 ms

Query Time: 0.31 ms
```
SELECT `data`

  FROM `bcyru_session`

  WHERE `session_id` = 'dd39de96avfoiel9f2mvc648n0'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE bcyru_session const PRIMARY PRIMARY 602 const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/session/storage/database.php:46
JROOT/libraries/joomla/session/session.php:664
JROOT/libraries/joomla/session/session.php:602
JROOT/libraries/cms/application/cms.php:668
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:328
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.36 ms After last query: 1.42 ms
```
SELECT `session_id`

  FROM `bcyru_session`

  WHERE `session_id` = 'dd39de96avfoiel9f2mvc648n0' 
  LIMIT 0, 1
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE bcyru_session const PRIMARY PRIMARY 602 const 1 100.00 Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:175
JROOT/libraries/cms/application/cms.php:694
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:328
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.47 ms After last query: 0.13 ms
```
INSERT INTO `bcyru_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('dd39de96avfoiel9f2mvc648n0', 0, '1508417678')
```
Explain
EXPLAIN not possible on query: INSERT INTO `bcyru_session` (`session_id`, `client_id`, `time`) VALUES ('dd39de96avfoiel9f2mvc648n0', 0, '1508417678')
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:207
JROOT/libraries/cms/application/cms.php:694
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:328
JROOT/libraries/joomla/factory.php:124
JROOT/index.php:37
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

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

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

Query Time: 0.10 ms After last query: 4.22 ms

SELECT b.id

  FROM bcyru_usergroups AS a

  LEFT JOIN bcyru_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	10	20.00	Using where; Using index

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

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

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

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.09 ms After last query: 0.54 ms
```
SELECT id, rules

  FROM `bcyru_viewlevels`
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE bcyru_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 4 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:420
JROOT/libraries/joomla/user/user.php:428
JROOT/libraries/cms/plugin/helper.php:298
JROOT/libraries/cms/plugin/helper.php:165
JROOT/libraries/cms/application/site.php:575
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

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

Query Time: 1.19 ms After last query: 20.05 ms

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

  LEFT JOIN bcyru_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	124	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	sjprinti_01.m.component_id	1	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

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

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

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

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

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

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

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

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.47 ms After last query: 10.92 ms
```
UPDATE `bcyru_extensions`

  SET `params` = '{\"mediaversion\":\"40d1c021d255f83de8d90149c15fa6ff\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE bcyru_extensions range element_clientid,element_folder_clientid,extension extension 364 const,const 1 100.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/library/helper.php:119
JROOT/libraries/cms/version/version.php:230
JROOT/libraries/cms/version/version.php:189
JROOT/libraries/joomla/factory.php:734
JROOT/libraries/joomla/factory.php:215
JROOT/libraries/cms/html/behavior.php:320
JROOT/libraries/cms/html/html.php:238
JROOT/libraries/cms/html/html.php:140
JROOT/plugins/system/k2/k2.php:47
JROOT/libraries/joomla/event/event.php:71
JROOT/libraries/joomla/event/dispatcher.php:162
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1027
JROOT/libraries/cms/application/site.php:749
JROOT/libraries/cms/application/site.php:231
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.07 ms After last query: 6.47 ms
```
SELECT a.rules

  FROM bcyru_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
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:248
JROOT/libraries/joomla/user/user.php:364
JROOT/components/com_k2/k2.php:16
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

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

Query Time: 0.08 ms After last query: 0.55 ms

SELECT b.rules

  FROM bcyru_assets AS a

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

  WHERE (a.name = 'com_k2')

  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	322	94.10	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

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

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

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

JROOT/components/com_k2/k2.php:16

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.07 ms After last query: 11.85 ms
```
SELECT id 
  FROM bcyru_k2_categories 
  WHERE published=1 
  AND trash=0 
  AND access IN(1,1)
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE bcyru_k2_categories range category,published,access,trash category 8 NULL 18 100.00 Using where; Using index
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/helpers/permissions.php:261
JROOT/components/com_k2/views/item/view.html.php:36
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:689
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.22 ms After last query: 0.14 ms
```
SELECT * 
  FROM bcyru_k2_items 
  WHERE id=70 
  LIMIT 0, 1
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE bcyru_k2_items const PRIMARY PRIMARY 4 const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:36
JROOT/components/com_k2/views/item/view.html.php:42
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:689
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.54 ms After last query: 0.74 ms
```
SHOW FULL COLUMNS 
  FROM `bcyru_k2_categories`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `bcyru_k2_categories`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:237
JROOT/libraries/joomla/table/table.php:158
JROOT/administrator/components/com_k2/tables/k2category.php:34
JROOT/libraries/joomla/table/table.php:301
JROOT/components/com_k2/models/item.php:74
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:689
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.10 ms After last query: 0.61 ms
```
SELECT * 
  FROM bcyru_k2_categories 
  WHERE id = '17'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE bcyru_k2_categories const PRIMARY PRIMARY 4 const 1 100.00 NULL
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_k2/tables/k2category.php:65
JROOT/components/com_k2/models/item.php:75
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:689
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bcyru_k2_categories	range	category,published,access,trash	category	8	NULL	18	100.00	Using where; Using index

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

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

Query Time: 0.06 ms After last query: 3.08 ms

SELECT tag.*
		
  FROM bcyru_k2_tags AS tag
		JOIN bcyru_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
		
  WHERE tag.published=1
		
  AND xref.itemID = 70 
  ORDER BY xref.id ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	100.00	Using where
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	sjprinti_01.xref.tagID	1	100.00	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/components/com_k2/models/item.php:1353

JROOT/components/com_k2/models/item.php:109

JROOT/components/com_k2/views/item/view.html.php:51

JROOT/libraries/joomla/cache/controller/view.php:98

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

JROOT/components/com_k2/controllers/controller.php:20

JROOT/components/com_k2/controllers/item.php:80

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

JROOT/components/com_k2/k2.php:63

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.07 ms After last query: 0.21 ms
```
SELECT COUNT(*) 
  FROM bcyru_k2_comments 
  WHERE itemID=70 
  AND published=1
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE bcyru_k2_comments ref itemID,published,latestComments itemID 4 const 1 100.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:1688
JROOT/components/com_k2/models/item.php:274
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:689
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 1.20 ms After last query: 7.44 ms
```
SHOW FULL COLUMNS 
  FROM `bcyru_k2_items`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `bcyru_k2_items`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:237
JROOT/libraries/joomla/table/table.php:158
JROOT/administrator/components/com_k2/tables/k2item.php:56
JROOT/libraries/joomla/table/table.php:301
JROOT/components/com_k2/models/item.php:895
JROOT/components/com_k2/views/item/view.html.php:135
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:689
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]
Query Time: 0.34 ms After last query: 0.34 ms
```
UPDATE bcyru_k2_items

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

  WHERE `id` = '70'
```
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE bcyru_k2_items range PRIMARY PRIMARY 4 const 1 100.00 Using where
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:1233
JROOT/components/com_k2/models/item.php:896
JROOT/components/com_k2/views/item/view.html.php:135
JROOT/libraries/joomla/cache/controller/view.php:98
JROOT/libraries/legacy/controller/legacy.php:689
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:730
JROOT/components/com_k2/k2.php:63
JROOT/libraries/cms/component/helper.php:352
JROOT/libraries/cms/component/helper.php:332
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:237
JROOT/libraries/cms/application/cms.php:251
JROOT/index.php:40
[Add xdebug.file_link_format directive to your php.ini file to have links for files]

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bcyru_k2_comments	ref	itemID,published,latestComments	itemID	4	const	1	100.00	Using where

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

Query Time: 1.61 ms After last query: 25.87 ms

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

  FROM bcyru_modules AS m

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

  LEFT JOIN bcyru_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 <= '2017-10-19 12:54:38') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2017-10-19 12:54:38') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 605 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	90	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	sjprinti_01.m.module,const	1	100.00	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	sjprinti_01.m.id	1	100.00	Using where; Using index

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:423

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:102

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

JROOT/plugins/system/t3/includes/core/template.php:608

JROOT/templates/ja_nuevo/tpls/blocks/header.php:30

JROOT/plugins/system/t3/includes/core/template.php:176

JROOT/templates/ja_nuevo/tpls/default.php:39

JROOT/plugins/system/t3/includes/core/template.php:200

JROOT/templates/ja_nuevo/index.php:33

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.44 ms After last query: 40.54 ms

UPDATE `bcyru_session`

  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1508417678;s:18:\"session.timer.last\";i:1508417678;s:17:\"session.timer.now\";i:1508417678;s:22:\"session.client.browser\";s:35:\"CCBot_2.0_http_commoncrawl.org_faq_\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":3:{s:13:\"current_theme\";N;s:17:\"current_direction\";s:3:\"ltr\";s:17:\"current_key_sufix\";s:5:\"__ltr\";}}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:\"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\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}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:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:3:\"gid\";i:1;}s:16:\"com_mailto.links\";a:1:{s:40:\"148448610b62937133ecc9a5154ace6c54f43533\";O:8:\"stdClass\":2:{s:4:\"link\";s:110:\"http://sjdesignstudio.com/services2/photography/videography/item/70-samsung-galaxy-s4-zoom-instructional-video\";s:6:\"expiry\";i:1508417678;}}s:13:\"session.token\";s:32:\"a1931b911f5eac234193e6df26abcaee\";}'
	, `time` = '1508417678'

  WHERE `session_id` = 'dd39de96avfoiel9f2mvc648n0'

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

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

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

19 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1 × SELECT * 
  FROM bcyru_k2_categories

```
1 × SELECT * 
  FROM bcyru_k2_items
```

1 × SELECT tag.*   
  FROM bcyru_k2_tags AS tag   JOIN bcyru_k2_tags_xref AS xref 
  ON tag.id = xref.tagID

1 × SELECT COUNT(*) 
  FROM bcyru_k2_comments

1 × SELECT m.published, m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM bcyru_modules AS m 
  LEFT JOIN bcyru_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN bcyru_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT id 
  FROM bcyru_k2_categories

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

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

1 × SELECT `session_id` 
  FROM `bcyru_session`

1 × SELECT id, rules 
  FROM `bcyru_viewlevels

1 × 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 bcyru_menu AS m 
  LEFT JOIN bcyru_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT a.rules 
  FROM bcyru_assets AS a

1 × SELECT `data` 
  FROM `bcyru_session`

OTHER Tables:

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

1 × UPDATE `bcyru_session` 
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1508417678;s:18:\"session.timer.last\";i:1508417678;s:17:\"session.timer.now\";i:1508417678;s:22:\"session.client.browser\";s:35:\"CCBot_2.0_http_commoncrawl.org_faq_\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":3:{s:13:\"current_theme\";N;s:17:\"current_direction\";s:3:\"ltr\";s:17:\"current_key_sufix\";s:5:\"__ltr\";}}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:\"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\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}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:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:3:\"gid\";i:1;}s:16:\"com_mailto.links\";a:1:{s:40:\"148448610b62937133ecc9a5154ace6c54f43533\";O:8:\"stdClass\":2:{s:4:\"link\";s:110:\"http://sjdesignstudio.com/services2/photography/videography/item/70-samsung-galaxy-s4-zoom-instructional-video\";s:6:\"expiry\";i:1508417678;}}s:13:\"session.token\";s:32:\"a1931b911f5eac234193e6df26abcaee\";}'  , `time` = '1508417678'

1 × SHOW FULL COLUMNS 
  FROM `bcyru_k2_items

1 × SHOW FULL COLUMNS 
  FROM `bcyru_k2_categories

1 × UPDATE `bcyru_extensions` 
  SET `params` = '{\"mediaversion\":\"40d1c021d255f83de8d90149c15fa6ff\"}'

1 × INSERT INTO `bcyru_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('dd39de96avfoiel9f2mvc648n0', 0, '1508417678'

Videography

Samsung Galaxy S4 Zoom Instructional Video

Like Us

About SJ Design Studio

Contact Us

Joomla! Debug Console

Session

__default

Profile Information

Time

Memory

Memory Usage

Database Queries

19 Queries Logged 10.8 ms

19 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: