اشکال یابی جوملا

اطلاعات مشخصات

زمان

حافظه

زمان: 0.0 ms / 0.0 ms حافظه: 0.606 MB / 0.61 MB Application: afterLoad

زمان: 81.2 ms / 81.2 ms حافظه: 3.494 MB / 4.10 MB Application: afterInitialise

زمان: 29.9 ms / 111.1 ms حافظه: 1.537 MB / 5.64 MB Application: afterRoute

زمان: 64.9 ms / 175.9 ms حافظه: 2.231 MB / 7.87 MB Application: afterDispatch

زمان: 13.2 ms / 189.1 ms حافظه: 0.415 MB / 8.28 MB Application: beforeRenderModule mod_maximenuck (منوی اصلی)

زمان: 33.1 ms / 222.2 ms حافظه: 0.949 MB / 9.23 MB Application: afterRenderModule mod_maximenuck (منوی اصلی)

زمان: 2.7 ms / 224.9 ms حافظه: 0.000 MB / 9.20 MB Application: beforeRenderModule mod_articles_latest (اخبار و رویدادها)

زمان: 29.6 ms / 254.5 ms حافظه: 1.115 MB / 10.31 MB Application: afterRenderModule mod_articles_latest (اخبار و رویدادها)

زمان: 2.6 ms / 257.1 ms حافظه: 0.000 MB / 9.77 MB Application: beforeRenderModule mod_djimageslider (Products)

زمان: 8.8 ms / 265.9 ms حافظه: 0.173 MB / 9.94 MB Application: afterRenderModule mod_djimageslider (Products)

زمان: 2.5 ms / 268.4 ms حافظه: 0.000 MB / 9.93 MB Application: beforeRenderModule mod_vvisit_counter (بازدید)

زمان: 36.5 ms / 304.9 ms حافظه: 1.271 MB / 11.20 MB Application: afterRenderModule mod_vvisit_counter (بازدید)

زمان: 43.1 ms / 348.1 ms حافظه: 0.133 MB / 11.34 MB Application: beforeRenderModule mod_date (تاریخ شمسی)

زمان: 3.5 ms / 351.6 ms حافظه: 0.141 MB / 11.48 MB Application: afterRenderModule mod_date (تاریخ شمسی)

زمان: 4.1 ms / 355.8 ms حافظه: 0.004 MB / 11.48 MB Application: beforeRenderModule mod_search (Search)

زمان: 6.8 ms / 362.6 ms حافظه: 0.039 MB / 11.52 MB Application: afterRenderModule mod_search (Search)

زمان: 4.4 ms / 367.0 ms حافظه: 0.000 MB / 11.52 MB Application: beforeRenderModule mod_menu (منو اصلی)

زمان: 12.8 ms / 379.8 ms حافظه: 0.120 MB / 11.64 MB Application: afterRenderModule mod_menu (منو اصلی)

زمان: 40.0 ms / 419.8 ms حافظه: 0.236 MB / 11.87 MB Application: afterRender

جمع پرس و جوی بانک اطلاعاتی: 47.8 ms

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

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

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	3	Using where; Using index

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j5xwp_viewlevels	ALL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	4

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	کلید شاخصی برای استفاده نیست	NULL	NULL	170	Using where; با استفاده از مرتب سازی فایل
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	tamin_db.m.component_id	1

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

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; با استفاده از مرتب سازی فایل
1	SIMPLE	b	range	idx_lft_rgt	idx_lft_rgt	4	NULL	24	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Using temporary; با استفاده از مرتب سازی فایل
1	PRIMARY	a	ref	PRIMARY,idx_access,idx_catid	idx_catid	4	const	4	Using where
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	tamin_db.a.created_by	1
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	tamin_db.a.modified_by	1
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	tamin_db.a.id	1
1	PRIMARY	<derived2>	ALL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	1	Using where
1	PRIMARY	fp	eq_ref	PRIMARY	PRIMARY	4	tamin_db.a.id	1	Using where; Using index
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	Using where; Using temporary; با استفاده از مرتب سازی فایل
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	47	Using where; Using index; Using join buffer

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	PRIMARY	a	ref	PRIMARY,idx_access,idx_catid	idx_catid	4	const	4	Using where
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	tamin_db.a.created_by	1	Using index
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	tamin_db.a.modified_by	1	Using index
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using index
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	tamin_db.a.id	1	Using index
1	PRIMARY	<derived2>	ALL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	1	Using where
1	PRIMARY	fp	eq_ref	PRIMARY	PRIMARY	4	tamin_db.a.id	1	Using where; Using index
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	Using where; Using temporary; با استفاده از مرتب سازی فایل
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	47	Using where; Using index; Using join buffer

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	45	Using where; با استفاده از مرتب سازی فایل
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	tamin_db.m.module,const	1	Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	tamin_db.m.id	1	Using where; Using index

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	j5xwp_modules	ref	published	published	1	const	53	Using where; با استفاده از مرتب سازی فایل

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	Using temporary; با استفاده از مرتب سازی فایل
1	PRIMARY	a	ref	idx_access,idx_catid	idx_catid	4	const	4	Using where
1	PRIMARY	fp	eq_ref	PRIMARY	PRIMARY	4	tamin_db.a.id	1	Using index
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	tamin_db.a.created_by	1
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	tamin_db.a.modified_by	1
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	tamin_db.a.id	1
1	PRIMARY	<derived2>	ALL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	1	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	Using where; Using temporary; با استفاده از مرتب سازی فایل
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	47	Using where; Using index; Using join buffer

Status	Duration
starting	0.3 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.1 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
executing	0.0 ms
Copying to tmp table	0.1 ms
Sorting result	0.0 ms
Sending data	0.0 ms
removing tmp table	0.0 ms
Sending data	0.0 ms
init	0.1 ms
optimizing	0.1 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.4 ms
executing	0.0 ms
Copying to tmp table	4.0 ms
Sorting result	0.4 ms
Sending data	1.7 ms
end	0.0 ms
removing tmp table	0.3 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
logging slow query	0.0 ms
cleaning up	0.1 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	کلید شاخصی برای استفاده نیست	NULL	NULL	26	Using where
1	SIMPLE	m	ref	idx_tag_type,idx_tag	idx_tag_type	4	tamin_db.t.id	1	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	کلید شاخصی برای استفاده نیست	NULL	NULL	26	Using where
1	SIMPLE	m	ref	idx_tag_type,idx_tag	idx_tag_type	4	tamin_db.t.id	1	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	کلید شاخصی برای استفاده نیست	NULL	NULL	26	Using where
1	SIMPLE	m	ref	idx_tag_type,idx_tag	idx_tag_type	4	tamin_db.t.id	1	Using where

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	کلید شاخصی برای استفاده نیست	NULL	NULL	26	Using where
1	SIMPLE	m	ref	idx_tag_type,idx_tag	idx_tag_type	4	tamin_db.t.id	1	Using where

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; با استفاده از مرتب سازی فایل
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	کلید شاخصی برای استفاده نیست	NULL	NULL	47	Using where
1	PRIMARY	<derived2>	ALL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	1	Using where; Not exists
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	Using where; Using temporary; با استفاده از مرتب سازی فایل
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	47	Using where; Using index; Using join buffer

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

توضیحات در جستجو ممکن نیست: CREATE TABLE IF NOT EXISTS j5xwp_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

مشخصات

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.2 ms
System lock	0.0 ms
After create	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

فراخوانی بسته

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

JROOT/templates/wt_clean/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92

JROOT/templates/wt_clean/layouts/theme.config.php:72

JROOT/templates/wt_clean/layouts/theme.php:10

JROOT/templates/wt_clean/warp/src/Warp/Helper/TemplateHelper.php:49

JROOT/templates/wt_clean/index.php:16

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

[بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

زمان پرس و جو: 0.31 ms پس از آخرین پرس و جو: 0.16 ms حافظه پرس و جو: 0.048 MB حافظه قبل از پرس و جوی: 11.070 MB سطرهای بازگشتی: 1

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

توضیح دادن

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	NULL	Select tables optimized away

مشخصات

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

فراخوانی بسته

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

JROOT/templates/wt_clean/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92

JROOT/templates/wt_clean/layouts/theme.config.php:72

JROOT/templates/wt_clean/layouts/theme.php:10

JROOT/templates/wt_clean/warp/src/Warp/Helper/TemplateHelper.php:49

JROOT/templates/wt_clean/index.php:16

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

[بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

زمان پرس و جو: 14.37 ms پس از آخرین پرس و جو: 0.22 ms حافظه پرس و جو: 0.048 MB حافظه قبل از پرس و جوی: 11.096 MB سطرهای بازگشتی: 1

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

توضیح دادن

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

مشخصات

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

فراخوانی بسته

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

JROOT/templates/wt_clean/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92

JROOT/templates/wt_clean/layouts/theme.config.php:72

JROOT/templates/wt_clean/layouts/theme.php:10

JROOT/templates/wt_clean/warp/src/Warp/Helper/TemplateHelper.php:49

JROOT/templates/wt_clean/index.php:16

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

[بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

زمان پرس و جو: 0.39 ms پس از آخرین پرس و جو: 0.25 ms حافظه پرس و جو: 0.024 MB حافظه قبل از پرس و جوی: 11.121 MB

INSERT INTO j5xwp_vvisitcounter ( tm, ip, data ) 
  VALUES ( unix_timestamp(NOW()) , UNHEX(SHA1('3.232.96.22')) , NULL )

توضیح دادن

توضیحات در جستجو ممکن نیست: INSERT INTO j5xwp_vvisitcounter ( tm, ip, data ) VALUES ( unix_timestamp(NOW()) , UNHEX(SHA1('3.232.96.22')) , NULL )

مشخصات

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
init	0.0 ms
update	0.1 ms
Waiting for query cache lock	0.0 ms
update	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.1 ms
freeing items	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

فراخوانی بسته

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

JROOT/templates/wt_clean/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92

JROOT/templates/wt_clean/layouts/theme.config.php:72

JROOT/templates/wt_clean/layouts/theme.php:10

JROOT/templates/wt_clean/warp/src/Warp/Helper/TemplateHelper.php:49

JROOT/templates/wt_clean/index.php:16

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

[بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

زمان پرس و جو: 0.36 ms پس از آخرین پرس و جو: 0.19 ms حافظه پرس و جو: 0.048 MB حافظه قبل از پرس و جوی: 11.148 MB سطرهای بازگشتی: 1

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

توضیح دادن

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

مشخصات

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System 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	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

فراخوانی بسته

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

JROOT/templates/wt_clean/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92

JROOT/templates/wt_clean/layouts/theme.config.php:72

JROOT/templates/wt_clean/layouts/theme.php:10

JROOT/templates/wt_clean/warp/src/Warp/Helper/TemplateHelper.php:49

JROOT/templates/wt_clean/index.php:16

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

[بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

زمان پرس و جو: 0.32 ms پس از آخرین پرس و جو: 0.17 ms حافظه پرس و جو: 0.048 MB حافظه قبل از پرس و جوی: 11.174 MB سطرهای بازگشتی: 1

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

توضیح دادن

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

مشخصات

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System 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	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

فراخوانی بسته

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

JROOT/templates/wt_clean/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92

JROOT/templates/wt_clean/layouts/theme.config.php:72

JROOT/templates/wt_clean/layouts/theme.php:10

JROOT/templates/wt_clean/warp/src/Warp/Helper/TemplateHelper.php:49

JROOT/templates/wt_clean/index.php:16

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

[بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

زمان پرس و جو: 0.51 ms پس از آخرین پرس و جو: 0.22 ms حافظه پرس و جو: 0.048 MB حافظه قبل از پرس و جوی: 11.200 MB سطرهای بازگشتی: 1

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

توضیح دادن

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

مشخصات

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System 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	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

فراخوانی بسته

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

JROOT/templates/wt_clean/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92

JROOT/templates/wt_clean/layouts/theme.config.php:72

JROOT/templates/wt_clean/layouts/theme.php:10

JROOT/templates/wt_clean/warp/src/Warp/Helper/TemplateHelper.php:49

JROOT/templates/wt_clean/index.php:16

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

[بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

زمان پرس و جو: 2.85 ms پس از آخرین پرس و جو: 116.11 ms حافظه پرس و جو: 0.003 MB حافظه قبل از پرس و جوی: 11.872 MB

UPDATE `j5xwp_session`

  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1611071389;s:18:\"session.timer.last\";i:1611071389;s:17:\"session.timer.now\";i:1611071389;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"f61037ce3ae51bd89bd5deaca6ef7c58\";}'
	, `time` = '1611071390'

  WHERE `session_id` = 'fddavgnka0vqk9pkdp547rhk76'

توضیح دادن

توضیحات در جستجو ممکن نیست: UPDATE `j5xwp_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1611071389;s:18:\"session.timer.last\";i:1611071389;s:17:\"session.timer.now\";i:1611071389;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"f61037ce3ae51bd89bd5deaca6ef7c58\";}' , `time` = '1611071390' WHERE `session_id` = 'fddavgnka0vqk9pkdp547rhk76'

مشخصات

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
init	0.0 ms
Updating	0.4 ms
end	0.0 ms
Waiting for query cache lock	0.0 ms
end	0.0 ms
query end	2.2 ms
closing tables	0.0 ms
freeing items	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

فراخوانی بسته

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

[بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

23 نوع پرس و جو ثبت شده

انتخاب جداول:

4 × SELECT `m`.`tag_id`,`t`.* 
  FROM `j5xwp_contentitem_tag_map` AS m  
  INNER JOIN `j5xwp_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

4 × SELECT COUNT(*) 
  FROM j5xwp_vvisitcounter

```
1 × SELECT *    
  FROM j5xwp_modules
```

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

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,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,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
  FROM j5xwp_content AS a 
  LEFT JOIN j5xwp_content_frontpage AS fp 
  ON fp.content_id = a.id 
  LEFT JOIN j5xwp_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN j5xwp_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN j5xwp_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN j5xwp_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN j5xwp_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM j5xwp_categories AS cat JOIN j5xwp_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

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

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

1 × SELECT COUNT(*) 
  FROM j5xwp_content AS a 
  LEFT JOIN j5xwp_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN j5xwp_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN j5xwp_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN j5xwp_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN j5xwp_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM j5xwp_categories AS cat JOIN j5xwp_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, 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, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,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,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
  FROM j5xwp_content AS a 
  LEFT JOIN j5xwp_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN j5xwp_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN j5xwp_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN j5xwp_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN j5xwp_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM j5xwp_categories AS cat JOIN j5xwp_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT id, rules 
  FROM `j5xwp_viewlevels

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

1 × SELECT `session_id` 
  FROM `j5xwp_session`

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

1 × SELECT `template_style_id` 
  FROM `j5xwp_menu`

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

1 × SELECT a.rules 
  FROM j5xwp_assets AS a

1 × SELECT `data` 
  FROM `j5xwp_session`

سایر جداول:

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

1 × UPDATE `j5xwp_session` 
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1611071389;s:18:\"session.timer.last\";i:1611071389;s:17:\"session.timer.now\";i:1611071389;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"f61037ce3ae51bd89bd5deaca6ef7c58\";}'  , `time` = '1611071390'

1 × CREATE TABLE IF NOT EXISTS j5xwp_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 `j5xwp_extensions` 
  SET `params` = '{\"mediaversion\":\"37bb76f34fe1f2deb9b47e378d23e936\"}'

1 × INSERT INTO `j5xwp_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('fddavgnka0vqk9pkdp547rhk76', 0, '1611071389'

```
1 × DELETE  
  FROM `j5xwp_session`
```

	بازدیدکنندگان امروز	14
	بازدیدکنندگان دیروز	20
	بازدیدکنندگان این ماه	435
	کل بازدیدها	36840

اخبار و رویدادها

Products

اشکال یابی جوملا

جلسه

__default

اطلاعات مشخصات

زمان

حافظه

حافظه استفاده شده

پرس و جو پایگاه داده

29 پرس و جو ثبت شده 47.8 ms

23 نوع پرس و جو ثبت شده

انتخاب جداول:

سایر جداول: