Joomla! Debug Console

Profile Information

Time

Memory

Time: 0.0 ms / 0.0 ms Memory: 0.381 MB / 0.38 MB Application: afterLoad

Time: 55.2 ms / 55.2 ms Memory: 2.762 MB / 3.14 MB Application: afterInitialise

Time: 15.8 ms / 70.9 ms Memory: 0.606 MB / 3.75 MB Application: afterRoute

Time: 29.7 ms / 100.6 ms Memory: 0.944 MB / 4.69 MB Application: afterDispatch

Time: 18.1 ms / 118.7 ms Memory: 0.345 MB / 5.04 MB Application: beforeRenderModule mod_custom (Location)

Time: 3.3 ms / 122.1 ms Memory: 0.010 MB / 5.05 MB Application: afterRenderModule mod_custom (Location)

Time: 0.1 ms / 122.2 ms Memory: 0.000 MB / 5.05 MB Application: beforeRenderModule mod_menu (Sitemap)

Time: 3.6 ms / 125.8 ms Memory: 0.049 MB / 5.10 MB Application: afterRenderModule mod_menu (Sitemap)

Time: 0.1 ms / 125.9 ms Memory: 0.000 MB / 5.09 MB Application: beforeRenderModule mod_custom (ติดต่อเรา)

Time: 0.1 ms / 126.0 ms Memory: 0.007 MB / 5.10 MB Application: afterRenderModule mod_custom (ติดต่อเรา)

Time: 0.2 ms / 126.2 ms Memory: 0.016 MB / 5.11 MB Application: beforeRenderModule mod_vvisit_counter (Visitors Counter)

Time: 375.2 ms / 501.4 ms Memory: 0.460 MB / 5.57 MB Application: afterRenderModule mod_vvisit_counter (Visitors Counter)

Time: 0.2 ms / 501.6 ms Memory: 0.000 MB / 5.51 MB Application: beforeRenderModule mod_custom (Social Icon)

Time: 0.7 ms / 502.3 ms Memory: 0.010 MB / 5.52 MB Application: afterRenderModule mod_custom (Social Icon)

Time: 0.1 ms / 502.4 ms Memory: 0.000 MB / 5.52 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 1.5 ms / 503.9 ms Memory: 0.019 MB / 5.54 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.1 ms / 504.1 ms Memory: 0.000 MB / 5.54 MB Application: beforeRenderModule mod_login (Login Form)

Time: 3.8 ms / 507.8 ms Memory: 0.106 MB / 5.64 MB Application: afterRenderModule mod_login (Login Form)

Time: 102.9 ms / 610.7 ms Memory: 1.146 MB / 6.79 MB Application: afterRender

Database queries total: 405.2 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdc25_session	const	PRIMARY	PRIMARY	602	const	1

Status	Duration
Starting	0.1 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Executing	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdc25_extensions	ref	extension	extension	62	const	39	Using index condition

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdc25_extensions	ref	extension	extension	62	const	109	Using index condition; Using where; Using filesort

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	181	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	ubi.m.component_id	1	Using where

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	62	const	4	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where; Using join buffer (flat, BNL join)

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	const	PRIMARY,idx_state,idx_language	PRIMARY	4	const	1
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found
1	PRIMARY	<derived2>	ref	key0	key0	5	const	0
2	LATERAL DERIVED	cat	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
2	LATERAL DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	152	const	38	Using index condition; Using where

Status	Duration
Starting	0.1 ms
Checking permissions	0.0 ms
Opening tables	0.1 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Statistics	0.1 ms
Preparing	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
Executing	0.0 ms
Sending data	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Removing tmp table	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Using filesort
1	PRIMARY	c	range	cat_idx,idx_access,idx_left_right	cat_idx	158	NULL	14	Using index condition; Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	ubi.c.id	2	Using where
2	LATERAL DERIVED	cat	eq_ref	PRIMARY,idx_left_right	PRIMARY	4	ubi.c.id	1
2	LATERAL DERIVED	parent	ref	cat_idx,idx_left_right	cat_idx	152	const	39	Using index condition; Using where

Status	Duration
Starting	0.1 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 ms
Optimizing	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.1 ms
Executing	0.0 ms
Sending data	0.3 ms
Executing	0.0 ms
Sending data	0.1 ms
Creating sort index	0.1 ms
Removing tmp table	0.1 ms
Creating sort index	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Removing tmp table	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index_merge	idx_access,idx_state,idx_catid,idx_language	idx_catid,idx_state	4,1	NULL	1	Using intersect(idx_catid,idx_state); Using where; Using filesort
1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1

Status	Duration
Starting	0.1 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Sorting result	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdc25_content	const	PRIMARY	PRIMARY	4	const	1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdc25_menu	const	PRIMARY	PRIMARY	4	const	1

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

Status	Duration
Starting	0.1 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.1 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 of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

EXPLAIN not possible on query: CREATE TABLE IF NOT EXISTS mdc25_vvisitcounter(id int(11) unsigned NOT NULL auto_increment, tm int not null, ip BINARY(20) not null, ipraw VARCHAR( 40 ) default NULL , userAgent varchar(1024) default NULL, data longtext, PRIMARY KEY (id), INDEX (tm), INDEX (ip) , INDEX iptm (ip,tm) ) ENGINE=MyISAM AUTO_INCREMENT=1

Profile

Status	Duration
Starting	0.0 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
Closing tables	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Commit_implicit	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/modules/mod_vvisit_counter/helper.php:1404

JROOT/modules/mod_vvisit_counter/helper.php:482

JROOT/modules/mod_vvisit_counter/tmpl/default.php:21

JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21

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

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

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

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.36 ms After last query: 0.08 ms Query memory: 0.019 MB Memory before query: 5.433 MB Rows returned: 1

SELECT count( * ) AS records, MAX( id ) AS max 
  FROM mdc25_vvisitcounter

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Select tables optimized away

Profile

Status	Duration
Starting	0.0 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.0 ms
Optimizing	0.0 ms
Executing	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/modules/mod_vvisit_counter/helper.php:1417

JROOT/modules/mod_vvisit_counter/helper.php:482

JROOT/modules/mod_vvisit_counter/tmpl/default.php:21

JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21

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

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

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

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.33 ms After last query: 0.10 ms Query memory: 0.019 MB Memory before query: 5.454 MB

DELETE 
  FROM mdc25_vvisitcounter 
  WHERE id<='58952'

Explain

EXPLAIN not possible on query: DELETE FROM mdc25_vvisitcounter WHERE id<='58952'

Profile

Status	Duration
Starting	0.0 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init for update	0.0 ms
Updating	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/modules/mod_vvisit_counter/helper.php:1560

JROOT/modules/mod_vvisit_counter/helper.php:482

JROOT/modules/mod_vvisit_counter/tmpl/default.php:21

JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21

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

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

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

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 368.41 ms After last query: 0.07 ms Query memory: 0.019 MB Memory before query: 5.474 MB Rows returned: 1

SELECT COUNT(*) 
  FROM mdc25_vvisitcounter 
  WHERE ip=UNHEX(SHA1('10.140.0.140')) 
  AND ( ((unix_timestamp(NOW()) - tm ) / 60 ) < '15' )

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdc25_vvisitcounter	ref	ip,iptm	ip	20	const	52039	Using index condition; Using where

Profile

Status	Duration
Starting	0.0 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	367.8 ms
End of update loop	0.1 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/modules/mod_vvisit_counter/helper.php:1612

JROOT/modules/mod_vvisit_counter/helper.php:482

JROOT/modules/mod_vvisit_counter/tmpl/default.php:21

JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21

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

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

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

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

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

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

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

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

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

JROOT/index.php: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: 0.27 ms Query memory: 0.019 MB Memory before query: 5.493 MB

INSERT INTO mdc25_vvisitcounter ( tm, ip, data ) 
  VALUES ( unix_timestamp(NOW()) , UNHEX(SHA1('10.140.0.140')) , NULL )

Explain

EXPLAIN not possible on query: INSERT INTO mdc25_vvisitcounter ( tm, ip, data ) VALUES ( unix_timestamp(NOW()) , UNHEX(SHA1('10.140.0.140')) , NULL )

Profile

Status	Duration
Starting	0.0 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init for update	0.0 ms
Update	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/modules/mod_vvisit_counter/helper.php:1651

JROOT/modules/mod_vvisit_counter/helper.php:482

JROOT/modules/mod_vvisit_counter/tmpl/default.php:21

JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21

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

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

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

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.42 ms After last query: 0.13 ms Query memory: 0.019 MB Memory before query: 5.516 MB Rows returned: 1

SELECT COUNT(*) 
  FROM mdc25_vvisitcounter 
  WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW())) 
  AND UNIX_TIMESTAMP(DATE(NOW()) + INTERVAL 1 DAY)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdc25_vvisitcounter	range	tm	tm	4	NULL	74	Using where; Using index

Profile

Status	Duration
Starting	0.0 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	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 of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/modules/mod_vvisit_counter/helper.php:1920

JROOT/modules/mod_vvisit_counter/helper.php:763

JROOT/modules/mod_vvisit_counter/tmpl/default.php:26

JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21

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

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

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

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.43 ms After last query: 0.07 ms Query memory: 0.019 MB Memory before query: 5.536 MB Rows returned: 1

SELECT COUNT(*) 
  FROM mdc25_vvisitcounter 
  WHERE tm BETWEEN UNIX_TIMESTAMP(DATE(NOW() - INTERVAL 1 DAY)) 
  AND UNIX_TIMESTAMP(DATE(NOW()))

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdc25_vvisitcounter	range	tm	tm	4	NULL	455	Using where; Using index

Profile

Status	Duration
Starting	0.0 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	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 of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/modules/mod_vvisit_counter/helper.php:1935

JROOT/modules/mod_vvisit_counter/helper.php:774

JROOT/modules/mod_vvisit_counter/tmpl/default.php:26

JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21

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

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

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

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.53 ms After last query: 0.07 ms Query memory: 0.019 MB Memory before query: 5.556 MB Rows returned: 1

SELECT COUNT(*) 
  FROM mdc25_vvisitcounter 
  WHERE tm BETWEEN UNIX_TIMESTAMP(DATE_FORMAT(NOW(), "%Y-%m-01")) 
  AND UNIX_TIMESTAMP(DATE_FORMAT(NOW(), "%Y-%m-01") + INTERVAL 1 MONTH)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdc25_vvisitcounter	range	tm	tm	4	NULL	1461	Using where; Using index

Profile

Status	Duration
Starting	0.0 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.2 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/modules/mod_vvisit_counter/helper.php:1994

JROOT/modules/mod_vvisit_counter/helper.php:808

JROOT/modules/mod_vvisit_counter/tmpl/default.php:26

JROOT/modules/mod_vvisit_counter/mod_vvisit_counter.php:21

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

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

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

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

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

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

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

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

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

JROOT/index.php:40

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

Query Time: 0.57 ms After last query: 16.50 ms Query memory: 0.012 MB Memory before query: 6.188 MB Rows returned: 1

SELECT `FormId`, `FormLayout`, `ScriptDisplay`, `ErrorMessage`, `FormTitle`, `CSS`, `JS`, `CSSClass`, `CSSId`, `CSSName`, `CSSAction`, `CSSAdditionalAttributes`, `AjaxValidation`, `ThemeParams` 
  FROM mdc25_rsform_forms 
  WHERE FormId='3' 
  AND `Published`='1'

Explain

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

Profile

Status	Duration
Starting	0.0 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/plugins/system/rsform/rsform.php:99

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

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

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

JROOT/index.php:40

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

Query Time: 0.39 ms After last query: 0.11 ms Query memory: 0.013 MB Memory before query: 6.227 MB Rows returned: 1

SELECT Published, FormTitle, MetaTitle, MetaDesc, MetaKeywords, ShowThankyou, Access 
  FROM mdc25_rsform_forms 
  WHERE FormId='3'

Explain

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

Profile

Status	Duration
Starting	0.0 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/rsform.php:204

JROOT/plugins/system/rsform/rsform.php:128

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

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

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

JROOT/index.php:40

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

Query Time: 0.36 ms After last query: 0.09 ms Query memory: 0.014 MB Memory before query: 6.242 MB Rows returned: 1

Duplicate queries: #43 #48

SELECT `Lang` 
  FROM mdc25_rsform_forms 
  WHERE FormId='3'

Explain

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

Profile

Status	Duration
Starting	0.0 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/rsform.php:3689

JROOT/administrator/components/com_rsform/helpers/rsform.php:244

JROOT/plugins/system/rsform/rsform.php:128

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

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

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

JROOT/index.php:40

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

Query Time: 0.43 ms After last query: 0.11 ms Query memory: 0.014 MB Memory before query: 6.261 MB Rows returned: 1

SELECT `FormId`, `FormLayoutName`, `FormLayout`, `ScriptDisplay`, `ErrorMessage`, `FormTitle`, `CSS`, `JS`, `CSSClass`, `CSSId`, `CSSName`, `CSSAction`, `CSSAdditionalAttributes`, `AjaxValidation`, `ThemeParams` 
  FROM mdc25_rsform_forms 
  WHERE FormId='3' 
  AND `Published`='1'

Explain

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

Profile

Status	Duration
Starting	0.0 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/rsform.php:1630

JROOT/administrator/components/com_rsform/helpers/rsform.php:299

JROOT/plugins/system/rsform/rsform.php:128

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

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

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

JROOT/index.php:40

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

Query Time: 0.36 ms After last query: 0.12 ms Query memory: 0.015 MB Memory before query: 6.301 MB Rows returned: 1

Duplicate queries: #41 #48

SELECT `Lang` 
  FROM mdc25_rsform_forms 
  WHERE FormId='3'

Explain

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

Profile

Status	Duration
Starting	0.0 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/rsform.php:3689

JROOT/administrator/components/com_rsform/helpers/rsform.php:1633

JROOT/administrator/components/com_rsform/helpers/rsform.php:299

JROOT/plugins/system/rsform/rsform.php:128

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

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

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

JROOT/index.php:40

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

Query Time: 0.37 ms After last query: 0.09 ms Query memory: 0.015 MB Memory before query: 6.317 MB Rows returned: 0

SELECT ComponentId 
  FROM mdc25_rsform_components 
  WHERE ComponentTypeId='6' 
  AND FormId='3' 
  AND Published='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdc25_rsform_components	ref	ComponentTypeId,FormId	ComponentTypeId	4	const	1	Using where

Profile

Status	Duration
Starting	0.0 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	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 of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/rsform.php:1539

JROOT/administrator/components/com_rsform/helpers/rsform.php:1653

JROOT/administrator/components/com_rsform/helpers/rsform.php:299

JROOT/plugins/system/rsform/rsform.php:128

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

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

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

JROOT/index.php:40

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

Query Time: 4.01 ms After last query: 0.07 ms Query memory: 0.014 MB Memory before query: 6.334 MB Rows returned: 88

SELECT p.PropertyValue AS name, c.ComponentId, c.ComponentTypeId, ct.ComponentTypeName, c.
  Order 
  FROM mdc25_rsform_properties p 
  LEFT JOIN mdc25_rsform_components c 
  ON (c.ComponentId=p.ComponentId) 
  LEFT JOIN mdc25_rsform_component_types ct 
  ON (ct.ComponentTypeId=c.ComponentTypeId) 
  WHERE c.FormId='3' 
  AND p.PropertyName='NAME' 
  AND c.Published='1' 
  ORDER BY c.
  Order

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ALL	ComponentId,FormId	NO INDEX KEY COULD BE USED	NULL	NULL	88	Using where; Using filesort
1	SIMPLE	ct	eq_ref	PRIMARY	PRIMARY	4	ubi.c.ComponentTypeId	1
1	SIMPLE	p	ref	ComponentId	ComponentId	4	ubi.c.ComponentId	11	Using where

Profile

Status	Duration
Starting	0.0 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	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	3.5 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/rsform.php:1706

JROOT/administrator/components/com_rsform/helpers/rsform.php:299

JROOT/plugins/system/rsform/rsform.php:128

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

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

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

JROOT/index.php:40

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

Query Time: 0.79 ms After last query: 0.52 ms Query memory: 0.015 MB Memory before query: 6.482 MB Rows returned: 978

SELECT `PropertyName`,`PropertyValue`,`ComponentId`

  FROM `mdc25_rsform_properties`

  WHERE `ComponentId` IN (81,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,82,83,84,85,86,87,88,89,90,91,92,93,94,95,108,96,97,98,99,100,101,102,103,104,105,106,107,109,110)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdc25_rsform_properties	ALL	ComponentId	NO INDEX KEY COULD BE USED	NULL	NULL	978	Using where

Profile

Status	Duration
Starting	0.0 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.0 ms
Optimizing	0.0 ms
Statistics	0.1 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.3 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/rsform.php:524

JROOT/administrator/components/com_rsform/helpers/rsform.php:1731

JROOT/administrator/components/com_rsform/helpers/rsform.php:299

JROOT/plugins/system/rsform/rsform.php:128

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

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

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

JROOT/index.php:40

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

Query Time: 0.37 ms After last query: 2.80 ms Query memory: 0.015 MB Memory before query: 7.552 MB Rows returned: 1

SELECT `FormId`

  FROM `mdc25_rsform_components`

  WHERE `ComponentId`='81'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdc25_rsform_components	const	ComponentId	ComponentId	4	const	1

Profile

Status	Duration
Starting	0.0 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/rsform.php:539

JROOT/administrator/components/com_rsform/helpers/rsform.php:1731

JROOT/administrator/components/com_rsform/helpers/rsform.php:299

JROOT/plugins/system/rsform/rsform.php:128

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

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

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

JROOT/index.php:40

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

Query Time: 0.36 ms After last query: 0.08 ms Query memory: 0.017 MB Memory before query: 7.569 MB Rows returned: 1

Duplicate queries: #41 #43

SELECT `Lang` 
  FROM mdc25_rsform_forms 
  WHERE FormId='3'

Explain

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

Profile

Status	Duration
Starting	0.0 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Unlocking tables	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/rsform.php:3689

JROOT/administrator/components/com_rsform/helpers/rsform.php:543

JROOT/administrator/components/com_rsform/helpers/rsform.php:1731

JROOT/administrator/components/com_rsform/helpers/rsform.php:299

JROOT/plugins/system/rsform/rsform.php:128

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

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

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

JROOT/index.php:40

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

Query Time: 0.41 ms After last query: 9.91 ms Query memory: 0.017 MB Memory before query: 6.941 MB Rows returned: 2

SELECT ComponentId 
  FROM mdc25_rsform_components 
  WHERE ComponentTypeId='41' 
  AND FormId='3' 
  AND Published='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdc25_rsform_components	ref	ComponentTypeId,FormId	ComponentTypeId	4	const	2	Using where

Profile

Status	Duration
Starting	0.0 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	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 of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/rsform.php:1539

JROOT/administrator/components/com_rsform/helpers/rsform.php:3167

JROOT/administrator/components/com_rsform/helpers/rsform.php:1763

JROOT/administrator/components/com_rsform/helpers/rsform.php:299

JROOT/plugins/system/rsform/rsform.php:128

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

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

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

JROOT/index.php:40

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

Query Time: 0.36 ms After last query: 0.13 ms Query memory: 0.020 MB Memory before query: 6.949 MB Rows returned: 13

SELECT *

  FROM mdc25_rsform_config

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdc25_rsform_config	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	13

Profile

Status	Duration
Starting	0.0 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	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 of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/config.php:50

JROOT/administrator/components/com_rsform/helpers/config.php:17

JROOT/administrator/components/com_rsform/helpers/config.php:97

JROOT/administrator/components/com_rsform/helpers/rsform.php:379

JROOT/administrator/components/com_rsform/helpers/rsform.php:2464

JROOT/administrator/components/com_rsform/helpers/rsform.php:1790

JROOT/administrator/components/com_rsform/helpers/rsform.php:299

JROOT/plugins/system/rsform/rsform.php:128

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

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

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

JROOT/index.php:40

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

Query Time: 0.39 ms After last query: 2.32 ms Query memory: 0.015 MB Memory before query: 6.994 MB Rows returned: 0

SELECT ComponentId 
  FROM mdc25_rsform_components 
  WHERE ComponentTypeId='9' 
  AND FormId='3' 
  AND Published='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdc25_rsform_components	ref	ComponentTypeId,FormId	ComponentTypeId	4	const	1	Using where

Profile

Status	Duration
Starting	0.0 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	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 of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/rsform.php:1539

JROOT/administrator/components/com_rsform/helpers/rsform.php:1848

JROOT/administrator/components/com_rsform/helpers/rsform.php:299

JROOT/plugins/system/rsform/rsform.php:128

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

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

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

JROOT/index.php:40

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

Query Time: 1.04 ms After last query: 0.60 ms Query memory: 0.015 MB Memory before query: 7.016 MB Rows returned: 12

SELECT c.*,p.PropertyValue AS ComponentName 
  FROM `mdc25_rsform_conditions` c 
  LEFT JOIN mdc25_rsform_properties p 
  ON (c.component_id = p.ComponentId) 
  LEFT JOIN mdc25_rsform_components comp 
  ON (comp.ComponentId=p.ComponentId) 
  WHERE c.`form_id` = 3 
  AND c.lang_code='en-GB' 
  AND comp.Published = 1 
  AND p.PropertyName='NAME' 
  ORDER BY c.`id` ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ALL	form_id,component_id	NO INDEX KEY COULD BE USED	NULL	NULL	12	Using where; Using filesort
1	SIMPLE	comp	eq_ref	ComponentId	ComponentId	4	ubi.c.component_id	1	Using where
1	SIMPLE	p	ref	ComponentId	ComponentId	4	ubi.c.component_id	11	Using where

Profile

Status	Duration
Starting	0.0 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	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.6 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/rsform.php:1589

JROOT/administrator/components/com_rsform/helpers/rsform.php:1925

JROOT/administrator/components/com_rsform/helpers/rsform.php:299

JROOT/plugins/system/rsform/rsform.php:128

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

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

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

JROOT/index.php:40

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

Query Time: 0.91 ms After last query: 0.19 ms Query memory: 0.016 MB Memory before query: 7.054 MB Rows returned: 12

SELECT d.*,p.PropertyValue AS ComponentName 
  FROM mdc25_rsform_condition_details d 
  LEFT JOIN mdc25_rsform_properties p 
  ON (d.component_id = p.ComponentId) 
  LEFT JOIN mdc25_rsform_components comp 
  ON (comp.ComponentId=p.ComponentId) 
  WHERE d.condition_id IN (1,2,3,4,5,6,7,8,9,10,11,12) 
  AND comp.Published = 1 
  AND p.PropertyName='NAME'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	d	ALL	condition_id,component_id	NO INDEX KEY COULD BE USED	NULL	NULL	12	Using where
1	SIMPLE	comp	eq_ref	ComponentId	ComponentId	4	ubi.d.component_id	1	Using where
1	SIMPLE	p	ref	ComponentId	ComponentId	4	ubi.d.component_id	11	Using where

Profile

Status	Duration
Starting	0.0 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
Sending data	0.5 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/rsform.php:1598

JROOT/administrator/components/com_rsform/helpers/rsform.php:1925

JROOT/administrator/components/com_rsform/helpers/rsform.php:299

JROOT/plugins/system/rsform/rsform.php:128

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

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

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

JROOT/index.php:40

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

Query Time: 0.36 ms After last query: 1.19 ms Query memory: 0.015 MB Memory before query: 7.128 MB Rows returned: 0

SELECT * 
  FROM mdc25_rsform_calculations 
  WHERE formId = 3 
  ORDER BY `ordering`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
Starting	0.0 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	0.0 ms
Optimizing	0.0 ms
Statistics	0.0 ms
Preparing	0.0 ms
Executing	0.0 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/rsform.php:4392

JROOT/administrator/components/com_rsform/helpers/rsform.php:1980

JROOT/administrator/components/com_rsform/helpers/rsform.php:299

JROOT/plugins/system/rsform/rsform.php:128

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

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

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

JROOT/index.php:40

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

Query Time: 0.35 ms After last query: 0.08 ms Query memory: 0.016 MB Memory before query: 7.144 MB Rows returned: 0

SELECT ComponentId 
  FROM mdc25_rsform_components 
  WHERE ComponentTypeId='212' 
  AND FormId='3' 
  AND Published='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdc25_rsform_components	ref	ComponentTypeId,FormId	ComponentTypeId	4	const	1	Using where

Profile

Status	Duration
Starting	0.0 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	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 of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/administrator/components/com_rsform/helpers/rsform.php:1539

JROOT/administrator/components/com_rsform/helpers/rsform.php:1998

JROOT/administrator/components/com_rsform/helpers/rsform.php:299

JROOT/plugins/system/rsform/rsform.php:128

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

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

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

JROOT/index.php:40

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

Query Time: 0.42 ms After last query: 2.59 ms Query memory: 0.013 MB Memory before query: 6.774 MB Rows returned: 1

SELECT template

  FROM mdc25_template_styles

  WHERE home = 1 
  AND client_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	mdc25_template_styles	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	5	Using where

Profile

Status	Duration
Starting	0.0 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init	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 of update loop	0.0 ms
Query end	0.0 ms
Commit	0.0 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	0.0 ms

Call Stack

JROOT/plugins/system/yt/yt.php:280

JROOT/plugins/system/yt/yt.php:161

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

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

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

JROOT/index.php:40

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

Query Time: 1.14 ms After last query: 60.06 ms Query memory: 0.003 MB Memory before query: 6.839 MB

UPDATE `mdc25_session`

  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1747445830;s:18:\"session.timer.last\";i:1747445830;s:17:\"session.timer.now\";i:1747445830;s:24:\"session.client.forwarded\";s:13:\"3.142.133.182\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"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:13:\"session.token\";s:32:\"92fb9d94359cdada54c8e507c37b1736\";}'
	, `time` = '1747445831'

  WHERE `session_id` = '694ci3nt4guusl4re8ne3hpb61'

Explain

EXPLAIN not possible on query: UPDATE `mdc25_session` SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1747445830;s:18:\"session.timer.last\";i:1747445830;s:17:\"session.timer.now\";i:1747445830;s:24:\"session.client.forwarded\";s:13:\"3.142.133.182\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"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:13:\"session.token\";s:32:\"92fb9d94359cdada54c8e507c37b1736\";}' , `time` = '1747445831' WHERE `session_id` = '694ci3nt4guusl4re8ne3hpb61'

Profile

Status	Duration
Starting	0.0 ms
Checking permissions	0.0 ms
Opening tables	0.0 ms
After opening tables	0.0 ms
System lock	0.0 ms
Table lock	0.0 ms
Init for update	0.0 ms
Updating	0.1 ms
End of update loop	0.0 ms
Query end	0.0 ms
Commit	0.7 ms
Closing tables	0.0 ms
Unlocking tables	0.0 ms
Closing tables	0.0 ms
Starting cleanup	0.0 ms
Freeing items	0.0 ms
Updating status	0.0 ms
Reset for next command	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.]

44 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

4 × SELECT ComponentId 
  FROM mdc25_rsform_components

4 × SELECT COUNT(*) 
  FROM mdc25_vvisitcounter

```
4 × SELECT home 
  FROM mdc25_menu
```

3 × SELECT `Lang` 
  FROM mdc25_rsform_forms

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

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

1 × SELECT `FormId`, `FormLayoutName`, `FormLayout`, `ScriptDisplay`, `ErrorMessage`, `FormTitle`, `CSS`, `JS`, `CSSClass`, `CSSId`, `CSSName`, `CSSAction`, `CSSAdditionalAttributes`, `AjaxValidation`, `ThemeParams` 
  FROM mdc25_rsform_forms

1 × SELECT `FormId`, `FormLayout`, `ScriptDisplay`, `ErrorMessage`, `FormTitle`, `CSS`, `JS`, `CSSClass`, `CSSId`, `CSSName`, `CSSAction`, `CSSAdditionalAttributes`, `AjaxValidation`, `ThemeParams` 
  FROM mdc25_rsform_forms

1 × SELECT count( * ) AS records, MAX( id ) AS max 
  FROM mdc25_vvisitcounte

1 × SELECT Published, FormTitle, MetaTitle, MetaDesc, MetaKeywords, ShowThankyou, Access 
  FROM mdc25_rsform_forms

1 × SELECT p.PropertyValue AS name, c.ComponentId, c.ComponentTypeId, ct.ComponentTypeName, c.
  Order 
  FROM mdc25_rsform_properties p 
  LEFT JOIN mdc25_rsform_components c 
  ON (c.ComponentId=p.ComponentId) 
  LEFT JOIN mdc25_rsform_component_types ct 
  ON (ct.ComponentTypeId=c.ComponentTypeId)

1 × SELECT d.*,p.PropertyValue AS ComponentName 
  FROM mdc25_rsform_condition_details d 
  LEFT JOIN mdc25_rsform_properties p 
  ON (d.component_id = p.ComponentId) 
  LEFT JOIN mdc25_rsform_components comp 
  ON (comp.ComponentId=p.ComponentId)

1 × SELECT * 
  FROM mdc25_rsform_calculations

1 × SELECT template 
  FROM mdc25_template_styles

1 × SELECT c.*,p.PropertyValue AS ComponentName 
  FROM `mdc25_rsform_conditions` c 
  LEFT JOIN mdc25_rsform_properties p 
  ON (c.component_id = p.ComponentId) 
  LEFT JOIN mdc25_rsform_components comp 
  ON (comp.ComponentId=p.ComponentId)

1 × SELECT * 
  FROM mdc25_rsform_confi

1 × SELECT `PropertyName`,`PropertyValue`,`ComponentId` 
  FROM `mdc25_rsform_properties`

1 × SELECT `FormId` 
  FROM `mdc25_rsform_components`

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

1 × SELECT template_style_id 
  FROM mdc25_menu

```
1 × SELECT * 
  FROM mdc25_languages
```

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 mdc25_menu AS m 
  LEFT JOIN mdc25_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT id, home, template, s.params 
  FROM mdc25_template_styles as s 
  LEFT JOIN mdc25_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 mdc25_extensions

1 × SELECT id, rules 
  FROM `mdc25_viewlevels

1 × SELECT `session_id` 
  FROM `mdc25_session`

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

1 × SELECT a.rules 
  FROM mdc25_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 mdc25_content AS a 
  LEFT JOIN mdc25_categories AS c 
  on c.id = a.catid 
  LEFT JOIN mdc25_users AS u 
  on u.id = a.created_by 
  LEFT JOIN mdc25_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN mdc25_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM mdc25_categories AS cat JOIN mdc25_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid` 
  FROM `mdc25_content` AS `c` 
  INNER JOIN `mdc25_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item' 
  INNER JOIN `mdc25_associations` AS `a2` 
  ON a.key = a2.key 
  INNER JOIN `mdc25_content` AS `c2` 
  ON a2.id = c2.`id` 
  INNER JOIN `mdc25_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

1 × SELECT `data` 
  FROM `mdc25_session`

```
1 × SELECT * 
  FROM mdc25_content
```

1 × SELECT a.id, a.title, a.catid, a.language, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM mdc25_content AS a 
  LEFT JOIN mdc25_categories AS cc 
  ON cc.id = a.catid

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

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

1 × SELECT id 
  FROM mdc25_template_styles

OTHER Tables:

1 × DELETE 
  FROM mdc25_vvisitcounter

1 × INSERT INTO mdc25_vvisitcounter ( tm, ip, data ) 
  VALUES ( unix_timestamp(NOW()) , UNHEX(SHA1('10.140.0.140')) , NULL

1 × UPDATE `mdc25_session` 
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1747445830;s:18:\"session.timer.last\";i:1747445830;s:17:\"session.timer.now\";i:1747445830;s:24:\"session.client.forwarded\";s:13:\"3.142.133.182\";s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":2:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}s:9:\"separator\";s:1:\".\";}s:4:\"user\";O:5:\"JUser\":26:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"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:13:\"session.token\";s:32:\"92fb9d94359cdada54c8e507c37b1736\";}'  , `time` = '1747445831'

1 × CREATE TABLE IF NOT EXISTS mdc25_vvisitcounter(id int(11) unsigned NOT NULL auto_increment, tm int not null, ip BINARY(20) not null, ipraw VARCHAR( 40 ) default NULL , userAgent varchar(1024) default NULL, data longtext, PRIMARY KEY (id), INDEX (tm), INDEX (ip) , INDEX iptm (ip,tm) ) ENGINE=MyISAM AUTO_INCREMENT=

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

1 × UPDATE `mdc25_extensions` 
  SET `params` = '{\"mediaversion\":\"151e72f13aed05caf3bfee80564adb31\"}'

1 × SHOW FULL COLUMNS 
  FROM `mdc25_content

1 × INSERT INTO `mdc25_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('694ci3nt4guusl4re8ne3hpb61', 0, '1747445830'

	Today	21
	Yesterday	321
	This_Month	1057
	All_Days	158953

สมัครสมาชิก

ติดต่อเรา

Sitemap

Joomla! Debug Console

Session

__default

Profile Information

Time

Memory

Memory Usage

Database Queries

57 Queries Logged 405.2 ms

7 duplicate found!

44 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: