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

زمان

حافظه

22 پرس و جو ثبت شده 10.2 ms

1. زمان پرس و جو: 0.14 ms

   SELECT `data`
   
     FROM `l8knr_session`
   
     WHERE `session_id` = 'tecrp8s73aq04hnk30u0f9e2d0'

   توضیح دادن

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

   مشخصات

   عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)

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

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

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

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

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

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

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

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

   JROOT/libraries/joomla/factory.php:125

   JROOT/index.php:37

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

   ---

2. زمان پرس و جو: 0.08 ms پس از آخرین پرس و جو: 0.28 ms

   DELETE 
   
     FROM `l8knr_session`
   
     WHERE `time` < '1756050695'

   توضیح دادن

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

   مشخصات

   عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)

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

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

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

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

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

   JROOT/libraries/joomla/factory.php:125

   JROOT/index.php:37

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

   ---

3. زمان پرس و جو: 0.25 ms پس از آخرین پرس و جو: 0.55 ms

   SELECT extension_id AS id, element AS "option", params, enabled
   
     FROM l8knr_extensions
   
     WHERE `type` = 'component'

   توضیح دادن

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

   مشخصات

   عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)

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

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

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

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

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

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

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

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

   JROOT/index.php:40

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

   ---

4. زمان پرس و جو: 0.30 ms پس از آخرین پرس و جو: 0.39 ms

   SELECT folder AS type, element AS name, params
   
     FROM l8knr_extensions
   
     WHERE enabled = 1 
     AND type ='plugin' 
     AND state IN (0,1) 
     AND access IN (1,1)
   
     ORDER BY ordering

   توضیح دادن

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	l8knr_extensions	NULL	ref	extension	extension	62	const	57	0.63	Using index condition; Using where; با استفاده از مرتب سازی فایل

   مشخصات

   عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)

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

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

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

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

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

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

   JROOT/index.php:40

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

   ---

5. زمان پرس و جو: 0.21 ms پس از آخرین پرس و جو: 0.53 ms

   SELECT *
   
     FROM l8knr_languages
   
     WHERE published=1
   
     ORDER BY ordering ASC

   توضیح دادن

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	l8knr_languages	NULL	ALL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	2	50.00	Using where; با استفاده از مرتب سازی فایل

   مشخصات

   عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)

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

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

   JROOT/plugins/system/languagefilter/languagefilter.php:59

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

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

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

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

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

   JROOT/index.php:40

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

   ---

6. زمان پرس و جو: 0.74 ms پس از آخرین پرس و جو: 3.15 ms
   پرس و جوی تکراری: #20

   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 l8knr_menu AS m
   
     LEFT JOIN l8knr_extensions AS e 
     ON m.component_id = e.extension_id
   
     WHERE m.published = 1 
     AND m.parent_id > 0 
     AND m.client_id = 0
   
     ORDER BY m.lft

   توضیح دادن

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

   مشخصات

   عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)

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

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

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

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

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

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

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

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

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

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

   JROOT/plugins/system/languagefilter/languagefilter.php:94

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

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

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

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

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

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

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

   JROOT/index.php:40

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

   ---

7. زمان پرس و جو: 0.18 ms پس از آخرین پرس و جو: 5.82 ms

   SELECT extension_id AS id, element AS "option", params, enabled
   
     FROM l8knr_extensions
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   توضیح دادن

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

   مشخصات

   عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)

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

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

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

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

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

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

   JROOT/libraries/joomla/factory.php:736

   JROOT/libraries/joomla/factory.php:216

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

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

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

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

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

   JROOT/index.php:40

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

   ---

8. زمان پرس و جو: 0.57 ms پس از آخرین پرس و جو: 0.31 ms

   UPDATE `l8knr_extensions`
   
     SET `params` = '{\"mediaversion\":\"496f1aa64ec37f6a0d807c76043770d2\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   توضیح دادن

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

   مشخصات

   عدم نمایش مشخصات (شاید بدلیل وجود بیش از 100 پرس و جوی)

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

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

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

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

   JROOT/libraries/joomla/factory.php:736

   JROOT/libraries/joomla/factory.php:216

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

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

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

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

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

   JROOT/index.php:40

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

   ---

9. زمان پرس و جو: 0.25 ms پس از آخرین پرس و جو: 1.09 ms

   SELECT id, home, template, s.params
   
     FROM l8knr_template_styles as s
   
     LEFT JOIN l8knr_extensions as e 
     ON e.element=s.template 
     AND e.type='template' 
     AND e.client_id=s.client_id
   
     WHERE s.client_id = 0 
     AND e.enabled = 1

   توضیح دادن

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	s	NULL	ALL	idx_template	کلید شاخصی برای استفاده نیست	NULL	NULL	9	11.11	Using where
   1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	shopdive_divepersia.s.template,const	1	4.62	Using index condition; Using where

   مشخصات

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

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

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

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

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

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

   JROOT/index.php:40

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

   ---

10. زمان پرس و جو: 0.27 ms پس از آخرین پرس و جو: 10.22 ms

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

    توضیح دادن

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

    مشخصات

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

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

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

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

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

    JROOT/components/com_content/models/articles.php:107

    JROOT/components/com_content/models/featured.php:42

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

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

    JROOT/components/com_content/views/featured/view.html.php:46

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

    JROOT/components/com_content/controller.php:104

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

    JROOT/components/com_content/content.php:16

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

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

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

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

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

    JROOT/index.php:40

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

    ---

11. زمان پرس و جو: 0.32 ms پس از آخرین پرس و جو: 0.11 ms

    SELECT a.rules
    
      FROM l8knr_assets AS a
    
      WHERE (a.id = 1)
    
      GROUP BY a.id, a.rules, a.lft

    توضیح دادن

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

    مشخصات

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

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

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

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

    JROOT/components/com_content/models/articles.php:107

    JROOT/components/com_content/models/featured.php:42

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

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

    JROOT/components/com_content/views/featured/view.html.php:46

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

    JROOT/components/com_content/controller.php:104

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

    JROOT/components/com_content/content.php:16

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

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

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

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

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

    JROOT/index.php:40

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

    ---

12. زمان پرس و جو: 0.30 ms پس از آخرین پرس و جو: 0.72 ms

    SELECT b.rules
    
      FROM l8knr_assets AS a
    
      LEFT JOIN l8knr_assets AS b 
      ON b.lft <= a.lft 
      AND b.rgt >= a.rgt
    
      WHERE (a.name = 'com_content')
    
      GROUP BY b.id, b.rules, b.lft
    
      ORDER BY b.lft

    توضیح دادن

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	const	idx_asset_name	idx_asset_name	152	const	1	100.00	Using temporary; با استفاده از مرتب سازی فایل
    1	SIMPLE	b	NULL	range	idx_lft_rgt	idx_lft_rgt	4	NULL	14	100.00	Using where

    مشخصات

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

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

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

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

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

    JROOT/components/com_content/models/articles.php:107

    JROOT/components/com_content/models/featured.php:42

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

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

    JROOT/components/com_content/views/featured/view.html.php:46

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

    JROOT/components/com_content/controller.php:104

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

    JROOT/components/com_content/content.php:16

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

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

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

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

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

    JROOT/index.php:40

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

    ---

13. زمان پرس و جو: 1.69 ms پس از آخرین پرس و جو: 0.64 ms

    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 l8knr_content AS a
    
      LEFT JOIN l8knr_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN l8knr_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN l8knr_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN l8knr_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN l8knr_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM l8knr_categories AS cat JOIN l8knr_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id ) AS badcats 
      ON badcats.id = c.id
    
      INNER JOIN l8knr_content_frontpage AS fp 
      ON fp.content_id = a.id
    
      WHERE a.access IN (1,1) 
      AND c.access IN (1,1) 
      AND 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-08-24 16:06:35') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-08-24 16:06:35') 
      AND a.language in ('fa-IR','*')
    
      ORDER BY c.lft,   
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created DESC   
      LIMIT 0, 2

    توضیح دادن

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	fp	NULL	index	PRIMARY	PRIMARY	4	NULL	6	100.00	Using index; Using temporary; با استفاده از مرتب سازی فایل
    1	PRIMARY	a	NULL	eq_ref	PRIMARY,idx_access,idx_catid,idx_language	PRIMARY	4	shopdive_divepersia.fp.content_id	1	12.46	Using where
    1	PRIMARY	c	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	shopdive_divepersia.a.catid	1	100.00	Using where
    1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	shopdive_divepersia.a.created_by	1	100.00	Using where
    1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	shopdive_divepersia.a.modified_by	1	100.00	Using where
    1	PRIMARY	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	shopdive_divepersia.c.parent_id	1	100.00	Using where
    1	PRIMARY	v	NULL	eq_ref	PRIMARY	PRIMARY	4	shopdive_divepersia.a.id	1	100.00	Using where
    1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	shopdive_divepersia.c.id	10	100.00	Using where; Using index
    2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	153	NULL	23	100.00	Using index condition; Using temporary; با استفاده از مرتب سازی فایل
    2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	64	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

    مشخصات

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

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

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

    JROOT/libraries/legacy/model/list.php:169

    JROOT/components/com_content/models/articles.php:537

    JROOT/components/com_content/models/featured.php:90

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

    JROOT/components/com_content/views/featured/view.html.php:47

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

    JROOT/components/com_content/controller.php:104

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

    JROOT/components/com_content/content.php:16

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

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

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

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

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

    JROOT/index.php:40

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

    ---

14. زمان پرس و جو: 0.62 ms پس از آخرین پرس و جو: 1.59 ms

    SELECT COUNT(*)
    
      FROM l8knr_content AS a
    
      LEFT JOIN l8knr_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN l8knr_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN l8knr_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN l8knr_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN l8knr_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT 
      OUTER JOIN (SELECT cat.id as id 
      FROM l8knr_categories AS cat JOIN l8knr_categories AS parent 
      ON cat.lft BETWEEN parent.lft 
      AND parent.rgt 
      WHERE parent.extension = 'com_content' 
      AND parent.published != 1 
      GROUP BY cat.id ) AS badcats 
      ON badcats.id = c.id
    
      INNER JOIN l8knr_content_frontpage AS fp 
      ON fp.content_id = a.id
    
      WHERE a.access IN (1,1) 
      AND c.access IN (1,1) 
      AND 
      CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-08-24 16:06:35') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-08-24 16:06:35') 
      AND a.language in ('fa-IR','*')

    توضیح دادن

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	fp	NULL	index	PRIMARY	PRIMARY	4	NULL	6	100.00	Using index
    1	PRIMARY	a	NULL	eq_ref	PRIMARY,idx_access,idx_catid,idx_language	PRIMARY	4	shopdive_divepersia.fp.content_id	1	12.46	Using where
    1	PRIMARY	c	NULL	eq_ref	PRIMARY,idx_access	PRIMARY	4	shopdive_divepersia.a.catid	1	100.00	Using where
    1	PRIMARY	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	shopdive_divepersia.a.created_by	1	100.00	Using where; Using index
    1	PRIMARY	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	shopdive_divepersia.a.modified_by	1	100.00	Using where; Using index
    1	PRIMARY	parent	NULL	eq_ref	PRIMARY	PRIMARY	4	shopdive_divepersia.c.parent_id	1	100.00	Using where; Using index
    1	PRIMARY	v	NULL	eq_ref	PRIMARY	PRIMARY	4	shopdive_divepersia.a.id	1	100.00	Using where; Using index
    1	PRIMARY	<derived2>	NULL	ref	<auto_key0>	<auto_key0>	4	shopdive_divepersia.c.id	10	100.00	Using where; Using index
    2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	153	NULL	23	100.00	Using index condition; Using temporary; با استفاده از مرتب سازی فایل
    2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	64	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

    مشخصات

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

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

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

    JROOT/libraries/legacy/model/list.php:274

    JROOT/libraries/legacy/model/list.php:219

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

    JROOT/components/com_content/views/featured/view.html.php:48

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

    JROOT/components/com_content/controller.php:104

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

    JROOT/components/com_content/content.php:16

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

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

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

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

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

    JROOT/index.php:40

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

    ---

15. زمان پرس و جو: 0.19 ms پس از آخرین پرس و جو: 8.15 ms

    SELECT * 
      FROM l8knr_template_styles 
      WHERE template = 'bigpicture';

    توضیح دادن

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	l8knr_template_styles	NULL	ref	idx_template	idx_template	152	const	1	100.00	NULL

    مشخصات

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

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

    JROOT/templates/bigpicture/vertex/parameters.php:19

    JROOT/templates/bigpicture/vertex/parameters.php:167

    JROOT/templates/bigpicture/index.php:21

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

16. زمان پرس و جو: 0.16 ms پس از آخرین پرس و جو: 0.09 ms

    SELECT * 
      FROM l8knr_menu 
      WHERE template_style_id IN (12) 
      AND alias = 'home-2'

    توضیح دادن

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	l8knr_menu	NULL	ref	idx_alias	idx_alias	767	const	1	10.00	Using where

    مشخصات

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

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

    JROOT/templates/bigpicture/vertex/parameters.php:40

    JROOT/templates/bigpicture/vertex/parameters.php:167

    JROOT/templates/bigpicture/index.php:21

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

17. زمان پرس و جو: 1.14 ms پس از آخرین پرس و جو: 8.39 ms

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM l8knr_modules AS m
    
      LEFT JOIN l8knr_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN l8knr_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-08-24 16:06:35') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-08-24 16:06:35') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 208 OR mm.menuid <= 0) 
      AND m.language IN ('fa-IR','*')
    
      ORDER BY m.position, m.ordering

    توضیح دادن

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds,idx_language	published	5	NULL	52	1.31	Using index condition; Using where; با استفاده از مرتب سازی فایل
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	303	shopdive_divepersia.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	shopdive_divepersia.m.id	2	40.00	Using where; Using index

    مشخصات

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

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

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

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

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

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

    JROOT/templates/bigpicture/vertex/module_calcs.php:15

    JROOT/templates/bigpicture/index.php:23

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

18. زمان پرس و جو: 0.35 ms پس از آخرین پرس و جو: 6.56 ms
    پرس و جوی تکراری: #19

    SELECT menutype  
      FROM  l8knr_menu 
      WHERE language = 'fa-IR' 
      AND home = 1

    توضیح دادن

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	l8knr_menu	NULL	ref	idx_language	idx_language	21	const	105	10.00	Using where

    مشخصات

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

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

    JROOT/templates/bigpicture/vertex/responsive/responsive_mobile_menu.php:139

    JROOT/templates/bigpicture/vertex/responsive/responsive_mobile_top_bar.php:85

    JROOT/templates/bigpicture/vertex/includes/vertex_includes_top.php:12

    JROOT/templates/bigpicture/index.php:76

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

19. زمان پرس و جو: 0.36 ms پس از آخرین پرس و جو: 6.77 ms
    پرس و جوی تکراری: #18

    SELECT menutype  
      FROM  l8knr_menu 
      WHERE language = 'fa-IR' 
      AND home = 1

    توضیح دادن

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	l8knr_menu	NULL	ref	idx_language	idx_language	21	const	105	10.00	Using where

    مشخصات

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

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

    JROOT/templates/bigpicture/vertex/s5flex_menu/default.php:45

    JROOT/templates/bigpicture/index.php:98

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

20. زمان پرس و جو: 0.72 ms پس از آخرین پرس و جو: 2.41 ms
    پرس و جوی تکراری: #6

    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
      FROM l8knr_menu AS m
    
      LEFT JOIN l8knr_extensions AS e 
      ON m.component_id = e.extension_id
    
      WHERE m.published = 1 
      AND m.parent_id > 0 
      AND m.client_id = 0
    
      ORDER BY m.lft

    توضیح دادن

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

    مشخصات

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

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

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

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

    JROOT/templates/bigpicture/vertex/s5flex_menu/helpers.php:41

    JROOT/templates/bigpicture/vertex/s5flex_menu/helpers.php:141

    JROOT/templates/bigpicture/vertex/s5flex_menu/default.php:54

    JROOT/templates/bigpicture/index.php:98

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

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

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

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

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

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

    JROOT/index.php:40

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

    ---

21. زمان پرس و جو: 0.53 ms پس از آخرین پرس و جو: 49.12 ms

    SELECT m2.language, m2.id
    
      FROM l8knr_menu as m
    
      INNER JOIN l8knr_associations as a 
      ON a.id=m.id 
      AND a.context='com_menus.item'
    
      INNER JOIN l8knr_associations as a2 
      ON a.key=a2.key
    
      INNER JOIN l8knr_menu as m2 
      ON a2.id=m2.id
    
      WHERE m.id=208

    توضیح دادن

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	NULL	NULL	no matching row in const table

    مشخصات

    Status	Duration
    starting	0.1 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
    init	0.0 ms
    System lock	0.0 ms
    optimizing	0.0 ms
    statistics	0.1 ms
    executing	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    cleaning up	0.0 ms

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

    JROOT/administrator/components/com_menus/helpers/menus.php:283

    JROOT/modules/mod_languages/helper.php:62

    JROOT/modules/mod_languages/mod_languages.php:18

    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

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

    ---

22. زمان پرس و جو: 0.83 ms پس از آخرین پرس و جو: 6.83 ms

    UPDATE `l8knr_session`
    
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1756051595;s:18:\"session.timer.last\";i:1756051595;s:17:\"session.timer.now\";i:1756051595;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:\"18c8ad7aa83695e16f28537574bf9313\";}'
    	, `time` = '1756051595'
    
      WHERE `session_id` = 'tecrp8s73aq04hnk30u0f9e2d0'

    توضیح دادن

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

    مشخصات

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

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

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

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

    ---

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

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

1. 2 × SELECT menutype  
     FROM  l8knr_menu

2. 2 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
     FROM l8knr_menu AS m 
     LEFT JOIN l8knr_extensions AS e 
     ON m.component_id = e.extension_id

3. 2 × SELECT extension_id AS id, element AS "option", params, enabled 
     FROM l8knr_extensions

4. 1 × SELECT * 
     FROM l8knr_template_styles

5. 1 × SELECT COUNT(*) 
     FROM l8knr_content AS a 
     LEFT JOIN l8knr_categories AS c 
     ON c.id = a.catid 
     LEFT JOIN l8knr_users AS ua 
     ON ua.id = a.created_by 
     LEFT JOIN l8knr_users AS uam 
     ON uam.id = a.modified_by 
     LEFT JOIN l8knr_categories as parent 
     ON parent.id = c.parent_id 
     LEFT JOIN l8knr_content_rating AS v 
     ON a.id = v.content_id 
     LEFT 
     OUTER JOIN (SELECT cat.id as id 
     FROM l8knr_categories AS cat JOIN l8knr_categories AS parent 
     ON cat.lft BETWEEN parent.lft 
     AND parent.rgt

6. 1 × SELECT * 
     FROM l8knr_menu

7. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
     FROM l8knr_modules AS m 
     LEFT JOIN l8knr_modules_menu AS mm 
     ON mm.moduleid = m.id 
     LEFT JOIN l8knr_extensions AS e 
     ON e.element = m.module 
     AND e.client_id = m.client_id

8. 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 l8knr_content AS a 
     LEFT JOIN l8knr_categories AS c 
     ON c.id = a.catid 
     LEFT JOIN l8knr_users AS ua 
     ON ua.id = a.created_by 
     LEFT JOIN l8knr_users AS uam 
     ON uam.id = a.modified_by 
     LEFT JOIN l8knr_categories as parent 
     ON parent.id = c.parent_id 
     LEFT JOIN l8knr_content_rating AS v 
     ON a.id = v.content_id 
     LEFT 
     OUTER JOIN (SELECT cat.id as id 
     FROM l8knr_categories AS cat JOIN l8knr_categories AS parent 
     ON cat.lft BETWEEN parent.lft 
     AND parent.rgt

9. 1 × SELECT m2.language, m2.id 
     FROM l8knr_menu as m 
     INNER JOIN l8knr_associations as a 
     ON a.id=m.id 
     AND a.context='com_menus.item' 
     INNER JOIN l8knr_associations as a2 
     ON a.key=a2.key 
     INNER JOIN l8knr_menu as m2 
     ON a2.id=m2.id

10. 1 × SELECT a.rules 
      FROM l8knr_assets AS a

11. 1 × SELECT * 
      FROM l8knr_languages

12. 1 × SELECT folder AS type, element AS name, params 
      FROM l8knr_extensions

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

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

15. 1 × SELECT `data` 
      FROM `l8knr_session`

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

سایر جداول:

1. 1 × UPDATE `l8knr_session` 
     SET `data` = '__default|a:8:{s:15:\"session.counter\";i:2;s:19:\"session.timer.start\";i:1756051595;s:18:\"session.timer.last\";i:1756051595;s:17:\"session.timer.now\";i:1756051595;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:\"18c8ad7aa83695e16f28537574bf9313\";}'  , `time` = '1756051595'

2. 1 × UPDATE `l8knr_extensions` 
     SET `params` = '{\"mediaversion\":\"496f1aa64ec37f6a0d807c76043770d2\"}'

3. 1 × DELETE  
     FROM `l8knr_session`