22 ივნ2019

ქობულეთი: ტრენინგი „სამედიცინო პერსონალის როლი ძალადობის პრევენციასა და მსხვერპლთა დაცვაში“

Posted in ტრეინინგ-სემინარები

„ჩვენ ვისაუბრეთ, რა რესურსები აქვთ ექიმებს ძალადობის იდენტიფიცირებისთვის და აუცილებლად დავნერგავთ პრაქტიკაში ამ მეთოდებს“...

„ასე სიღრმისეულად პირველად ვიმსჯელეთ პრობლემის მიზეზებზე, საკუთარი ქცევებიც შევაფასეთ, როდის ვიქცევით სწორად და როდის არასწორად, ეს გაზრდის ექიმების ჩართულობას მსხვერპლთა დახმარების საქმეში“...

ასე აფასებენ ექიმები ტრენინგს.

ეს იყო მეორე ტრენინგი თემაზე „სამედიცინო პერსონალის როლი ძალადობის პრევენციასა და მსხვერპლთა დაცვაში“, რომელიც გაიმართა ქობულეთში 19-22 ივნისს.

ტრენინგში მონაწილეობდა 19 სამედიცინო მუშაკი იმერეთის 5 მუნიციპალიტეტიდან (ბაღდათი, ხონი, ვანი, თერჯოლა, სამტრედია).

პროექტი ხორციელდება ორგანიზაცია HumanDoc foundation

მხარდაჭერით (პოლონეთი)

დაბეჭდვა ელ-ფოსტა

		July 2020

CsoForum.Ge

Gac.Fsokhumi.Ge

სიახლეები

მნახველები: 2
სტატიები: 6116
სტატიების დათვალიერების რაოდენობა: 9048212

Fundsokhumi.ge

Joomla! გამართვის (Debug) კონსოლი

სესია

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1594097923,
                "last": 1594097923,
                "now": 1594097923
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "ka-GE"
        },
        "cronjob_user": true,
        "com_mailto": {
            "links": {
                "65688cbe2582443192b9c07583f32b6281b6d61e": {
                    "link": "http:\/\/www.fsokhumi.ge\/index.php\/ka\/newska\/treining\/5806-2019-06-27-07-29-10",
                    "expiry": 1594097923
                }
            }
        }
    }
}

პროფილის ინფორმაცია

დრო

მეხსიერება

დრო: 20.86 ms / 20.86 ms მეხსიერება: 1.817 MB / 2.22 MB Application: afterLoad

დრო: 114.86 ms / 135.72 ms მეხსიერება: 7.080 MB / 9.30 MB Application: afterInitialise

დრო: 37.05 ms / 172.78 ms მეხსიერება: 2.101 MB / 11.40 MB Application: afterRoute

დრო: 0.33 ms / 173.11 ms მეხსიერება: 0.025 MB / 11.43 MB Application: beforeRenderComponent com_content

დრო: 3.01 ms / 176.12 ms მეხსიერება: 0.186 MB / 11.61 MB Application: Before Access::preloadComponents (all components)

დრო: 1.39 ms / 177.51 ms მეხსიერება: 0.063 MB / 11.68 MB Application: After Access::preloadComponents (all components)

დრო: 0.06 ms / 177.57 ms მეხსიერება: 0.000 MB / 11.67 MB Application: Before Access::preloadPermissions (com_content)

დრო: 22.58 ms / 200.15 ms მეხსიერება: 5.582 MB / 17.26 MB Application: After Access::preloadPermissions (com_content)

დრო: 0.22 ms / 200.37 ms მეხსიერება: 0.000 MB / 17.00 MB Application: Before Access::getAssetRules (id:6010 name:com_content.article.5806)

დრო: 0.80 ms / 201.17 ms მეხსიერება: 0.027 MB / 17.03 MB Application: After Access::getAssetRules (id:6010 name:com_content.article.5806)

დრო: 267.16 ms / 468.34 ms მეხსიერება: 2.977 MB / 20.01 MB Application: afterRenderComponent com_content

დრო: 2.86 ms / 471.20 ms მეხსიერება: 0.047 MB / 20.05 MB Application: Before Access::getAssetRules (id:8 name:com_content)

დრო: 0.03 ms / 471.23 ms მეხსიერება: 0.002 MB / 20.06 MB Application: After Access::getAssetRules (id:8 name:com_content)

დრო: 4.64 ms / 475.87 ms მეხსიერება: 0.068 MB / 20.12 MB Application: afterDispatch

დრო: 4.22 ms / 480.08 ms მეხსიერება: 0.312 MB / 20.43 MB Application: beforeRenderModule mod_sp_smart_slider (SP Smart Slider)

დრო: 2.22 ms / 482.30 ms მეხსიერება: 0.084 MB / 20.52 MB Application: afterRenderModule mod_sp_smart_slider (SP Smart Slider)

დრო: 3.44 ms / 485.74 ms მეხსიერება: 0.072 MB / 20.59 MB Application: beforeRenderModule mod_custom (ლოგო)

დრო: 0.73 ms / 486.46 ms მეხსიერება: 0.008 MB / 20.60 MB Application: afterRenderModule mod_custom (ლოგო)

დრო: 0.04 ms / 486.51 ms მეხსიერება: 0.002 MB / 20.60 MB Application: beforeRenderModule mod_languages (ენის ასარჩევი)

დრო: 3.38 ms / 489.89 ms მეხსიერება: 0.100 MB / 20.70 MB Application: afterRenderModule mod_languages (ენის ასარჩევი)

დრო: 0.86 ms / 490.75 ms მეხსიერება: 0.000 MB / 20.70 MB Application: beforeRenderModule mod_menu (ქართული მენიუ)

დრო: 8.23 ms / 498.98 ms მეხსიერება: 0.274 MB / 20.97 MB Application: afterRenderModule mod_menu (ქართული მენიუ)

დრო: 9.39 ms / 508.37 ms მეხსიერება: 0.231 MB / 21.20 MB Application: beforeRenderModule mod_newscalendar (News Calendar ge)

დრო: 15.50 ms / 523.88 ms მეხსიერება: 0.219 MB / 21.42 MB Application: afterRenderModule mod_newscalendar (News Calendar ge)

დრო: 0.07 ms / 523.95 ms მეხსიერება: 0.000 MB / 21.41 MB Application: beforeRenderModule mod_custom (CsoForum.Ge)

დრო: 0.53 ms / 524.48 ms მეხსიერება: 0.003 MB / 21.42 MB Application: afterRenderModule mod_custom (CsoForum.Ge)

დრო: 0.04 ms / 524.52 ms მეხსიერება: 0.000 MB / 21.42 MB Application: beforeRenderModule mod_custom (Visegradfund.org)

დრო: 0.46 ms / 524.98 ms მეხსიერება: 0.003 MB / 21.42 MB Application: afterRenderModule mod_custom (Visegradfund.org)

დრო: 0.04 ms / 525.02 ms მეხსიერება: 0.000 MB / 21.42 MB Application: beforeRenderModule mod_custom (Gac.Fsokhumi.Ge)

დრო: 0.44 ms / 525.46 ms მეხსიერება: 0.003 MB / 21.42 MB Application: afterRenderModule mod_custom (Gac.Fsokhumi.Ge)

დრო: 0.04 ms / 525.50 ms მეხსიერება: 0.001 MB / 21.42 MB Application: beforeRenderModule mod_articles_latest (სიახლეები)

დრო: 317.66 ms / 843.16 ms მეხსიერება: 0.291 MB / 21.71 MB Application: afterRenderModule mod_articles_latest (სიახლეები)

დრო: 0.10 ms / 843.26 ms მეხსიერება: 0.000 MB / 21.53 MB Application: beforeRenderModule mod_stats (სტატისტიკა)

დრო: 15.62 ms / 858.88 ms მეხსიერება: 0.060 MB / 21.59 MB Application: afterRenderModule mod_stats (სტატისტიკა)

დრო: 0.08 ms / 858.96 ms მეხსიერება: 0.000 MB / 21.58 MB Application: beforeRenderModule mod_custom (Fundsokhumi.ge)

დრო: 0.55 ms / 859.51 ms მეხსიერება: 0.003 MB / 21.59 MB Application: afterRenderModule mod_custom (Fundsokhumi.ge)

დრო: 0.04 ms / 859.55 ms მეხსიერება: 0.000 MB / 21.59 MB Application: beforeRenderModule mod_custom (Facebook Likebox)

დრო: 0.47 ms / 860.02 ms მეხსიერება: 0.003 MB / 21.59 MB Application: afterRenderModule mod_custom (Facebook Likebox)

დრო: 0.04 ms / 860.05 ms მეხსიერება: 0.000 MB / 21.59 MB Application: beforeRenderModule mod_custom (Youtube Chanel)

დრო: 0.44 ms / 860.50 ms მეხსიერება: 0.003 MB / 21.59 MB Application: afterRenderModule mod_custom (Youtube Chanel)

დრო: 0.04 ms / 860.54 ms მეხსიერება: 0.000 MB / 21.59 MB Application: beforeRenderModule mod_custom (top.ge)

დრო: 0.45 ms / 860.99 ms მეხსიერება: 0.003 MB / 21.60 MB Application: afterRenderModule mod_custom (top.ge)

დრო: 23.45 ms / 884.44 ms მეხსიერება: 0.546 MB / 22.14 MB Application: afterRender

სულ SQL-მოთხოვნები: 377.63 ms

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	ისევე, როგორც გამოძახება ქვემოთ სტრიქონში.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:69

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

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:69

EXPLAIN არ არის ხელმისაწვდომი მოთხოვნისთვის: INSERT INTO `bak_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3062396263386130373961643730333165363166623262663461653766313765', 1, 1594097923, 0, '', 0)

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
update	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:69

მოთხოვნის დრო: 0.64 ms ბოლო მოთხოვნის შემდეგ: 3.47 ms მოთხოვნის მეხსიერება: 0.006 MB მოთხოვნამდე მეხსიერება: 4.273 MB არჩეულია სტრიქონები: 40

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

  FROM `bak_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bak_extensions	ref	extension	extension	82	const	41	100.00	Using index condition; Using where

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.27 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	ისევე, როგორც გამოძახება ქვემოთ სტრიქონში.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.35 ms ბოლო მოთხოვნის შემდეგ: 3.14 ms მოთხოვნის მეხსიერება: 0.005 MB მოთხოვნამდე მეხსიერება: 4.541 MB არჩეულია სტრიქონები: 5

SELECT id, rules

  FROM `bak_viewlevels`

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bak_viewlevels	ALL	NULL	ინდექსი არ გამოიყენება	NULL	NULL	5	100.00	NULL

SQL-მოთხოვნის პროფილი

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

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.39 ms ბოლო მოთხოვნის შემდეგ: 0.09 ms მოთხოვნის მეხსიერება: 0.005 MB მოთხოვნამდე მეხსიერება: 4.553 MB არჩეულია სტრიქონები: 2

SELECT b.id

  FROM bak_usergroups AS a

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

  WHERE a.id = 9

SQL-მოთხოვნების გეგმა (Explain)

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

SQL-მოთხოვნის პროფილი

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

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.99 ms ბოლო მოთხოვნის შემდეგ: 0.85 ms მოთხოვნის მეხსიერება: 0.005 MB მოთხოვნამდე მეხსიერება: 4.619 MB არჩეულია სტრიქონები: 95

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM bak_extensions

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

  ORDER BY ordering

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bak_extensions	ref	extension	extension	82	const	122	100.00	Using index condition; Using where; გამოიყენება filesort

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.61 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	ისევე, როგორც გამოძახება ქვემოთ სტრიქონში.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.37 ms ბოლო მოთხოვნის შემდეგ: 1.23 ms მოთხოვნის მეხსიერება: 0.003 MB მოთხოვნამდე მეხსიერება: 4.749 MB არჩეულია სტრიქონები: 3

SELECT *

  FROM bak_languages

  WHERE published=1

  ORDER BY ordering ASC

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bak_languages	ALL	NULL	ინდექსი არ გამოიყენება	NULL	NULL	3	100.00	Using where; გამოიყენება filesort

SQL-მოთხოვნის პროფილი

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

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Language/LanguageHelper.php:67
4	Joomla\CMS\Language\LanguageHelper::detectLanguage()	JROOT/libraries/src/Application/SiteApplication.php:653
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.80 ms ბოლო მოთხოვნის შემდეგ: 15.55 ms მოთხოვნის მეხსიერება: 0.009 MB მოთხოვნამდე მეხსიერება: 6.116 MB არჩეულია სტრიქონები: 1

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

  FROM `bak_extensions`

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

SQL-მოთხოვნების გეგმა (Explain)

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

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
16	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	ისევე, როგორც გამოძახება ქვემოთ სტრიქონში.
15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
13	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
12	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
11	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
10	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
9	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
8	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/ytshortcodes/ytshortcodes.php:36
7	plgSystemYtshortcodes->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.41 ms ბოლო მოთხოვნის შემდეგ: 0.18 ms მოთხოვნის მეხსიერება: 0.006 MB მოთხოვნამდე მეხსიერება: 6.109 MB

UPDATE `bak_extensions`

  SET `params` = '{\"mediaversion\":\"4a19b6bd04b153cef9fbe77fc56fd819\"}'

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

SQL-მოთხოვნების გეგმა (Explain)

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

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.06 ms
updating	0.08 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
12	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
11	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
10	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
9	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
8	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/ytshortcodes/ytshortcodes.php:36
7	plgSystemYtshortcodes->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.41 ms ბოლო მოთხოვნის შემდეგ: 6.65 ms მოთხოვნის მეხსიერება: 0.005 MB მოთხოვნამდე მეხსიერება: 6.591 MB არჩეულია სტრიქონები: 6

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `bak_extensions`

  WHERE `type` = 'language' 
  AND `state` = 0 
  AND `enabled` = 1

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bak_extensions	ref	extension	extension	82	const	6	100.00	Using index condition; Using where

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:209
8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:110
7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.48 ms ბოლო მოთხოვნის შემდეგ: 44.72 ms მოთხოვნის მეხსიერება: 0.005 MB მოთხოვნამდე მეხსიერება: 8.672 MB არჩეულია სტრიქონები: 1

SELECT count(*)

  FROM `bak_cwgears_schedule`

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bak_cwgears_schedule	index	NULL	PRIMARY	4	NULL	1	100.00	Using index

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.16 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.06 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:96
8	plgSystemCwgears->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.31 ms ბოლო მოთხოვნის შემდეგ: 0.07 ms მოთხოვნის მეხსიერება: 0.005 MB მოთხოვნამდე მეხსიერება: 8.677 MB არჩეულია სტრიქონები: 1

SELECT count(*)

  FROM `bak_cwgears_schedule`

  WHERE time + '86400'<'1594097923'

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bak_cwgears_schedule	ALL	NULL	ინდექსი არ გამოიყენება	NULL	NULL	1	100.00	Using where

SQL-მოთხოვნის პროფილი

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

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:139
8	plgSystemCwgears->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 1.30 ms ბოლო მოთხოვნის შემდეგ: 2.68 ms მოთხოვნის მეხსიერება: 0.010 MB მოთხოვნამდე მეხსიერება: 8.863 MB არჩეულია სტრიქონები: 72

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

  LEFT JOIN bak_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

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	76	100.00	Using index condition; Using where; გამოიყენება filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	Fsokhumi.m.component_id	1	100.00	Using where

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.81 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	ისევე, როგორც გამოძახება ქვემოთ სტრიქონში.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:145
8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.73 ms ბოლო მოთხოვნის შემდეგ: 20.05 ms მოთხოვნის მეხსიერება: 0.006 MB მოთხოვნამდე მეხსიერება: 10.245 MB არჩეულია სტრიქონები: 0

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 `bak_categories` AS `s`

  INNER JOIN `bak_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('ka-GE','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 5806

  ORDER BY c.lft

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	ინდექსი არ გამოიყენება	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.26 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.08 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.09 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
12	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
11	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/helpers/legacyrouter.php:350
10	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.32 ms ბოლო მოთხოვნის შემდეგ: 0.07 ms მოთხოვნის მეხსიერება: 0.006 MB მოთხოვნამდე მეხსიერება: 10.250 MB არჩეულია სტრიქონები: 1

SELECT `alias`,`catid`

  FROM `bak_content`

  WHERE `id` = 5806

SQL-მოთხოვნების გეგმა (Explain)

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

SQL-მოთხოვნის პროფილი

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

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
11	JDatabaseDriver->loadObject()	JROOT/components/com_content/helpers/legacyrouter.php:366
10	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.50 ms ბოლო მოთხოვნის შემდეგ: 6.57 ms მოთხოვნის მეხსიერება: 0.010 MB მოთხოვნამდე მეხსიერება: 10.660 MB არჩეულია სტრიქონები: 2

SELECT id, home, template, s.params

  FROM bak_template_styles as s

  LEFT JOIN bak_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

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	2	100.00	NULL
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	Fsokhumi.s.template,const	1	100.00	Using index condition; Using where

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
19	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/HTML/HTMLHelper.php:365
18	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT/libraries/src/HTML/HTMLHelper.php:712
17	Joomla\CMS\HTML\HTMLHelper::script()	ისევე, როგორც გამოძახება ქვემოთ სტრიქონში.
16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/cms/html/jquery.php:52
13	JHtmlJquery::framework()	ისევე, როგორც გამოძახება ქვემოთ სტრიქონში.
12	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:119
9	plgSystemJRealtimeAnalytics->injectApp()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:505
8	plgSystemJRealtimeAnalytics->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.81 ms ბოლო მოთხოვნის შემდეგ: 6.13 ms მოთხოვნის მეხსიერება: 0.008 MB მოთხოვნამდე მეხსიერება: 11.130 MB არჩეულია სტრიქონები: 7

SHOW FULL COLUMNS 
  FROM `bak_session`

SQL-მოთხოვნების გეგმა (Explain)

EXPLAIN არ არის ხელმისაწვდომი მოთხოვნისთვის: SHOW FULL COLUMNS FROM `bak_session`

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.23 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.11 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
14	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jrealtimeanalytics/tables/session.php:163
13	JRealtimeTableSession->__construct()	JROOT/libraries/src/Table/Table.php:312
12	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_jrealtimeanalytics/framework/helpers/users.php:135
11	JRealtimeHelpersUsers::getSessionTable()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:48
10	plgSystemJRealtimeAnalytics->notifyObservers()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:152
9	plgSystemJRealtimeAnalytics->injectApp()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:505
8	plgSystemJRealtimeAnalytics->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.32 ms ბოლო მოთხოვნის შემდეგ: 0.63 ms მოთხოვნის მეხსიერება: 0.006 MB მოთხოვნამდე მეხსიერება: 11.166 MB არჩეულია სტრიქონები: 1

SELECT *

  FROM bak_session

  WHERE `session_id` = '0b9bc8a079ad7031e61fb2bf4ae7f17e'

SQL-მოთხოვნების გეგმა (Explain)

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

SQL-მოთხოვნის პროფილი

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

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
12	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_jrealtimeanalytics/framework/helpers/users.php:136
11	JRealtimeHelpersUsers::getSessionTable()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:48
10	plgSystemJRealtimeAnalytics->notifyObservers()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:152
9	plgSystemJRealtimeAnalytics->injectApp()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:505
8	plgSystemJRealtimeAnalytics->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.34 ms ბოლო მოთხოვნის შემდეგ: 2.14 ms მოთხოვნის მეხსიერება: 0.007 MB მოთხოვნამდე მეხსიერება: 11.385 MB არჩეულია სტრიქონები: 0

SELECT * 
  FROM `bak_realtimeanalytics_eventstats`
 
  WHERE `type` = 'viewurl'
 
  AND `published` = 1

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bak_realtimeanalytics_eventstats	ALL	NULL	ინდექსი არ გამოიყენება	NULL	NULL	1	100.00	Using where

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:388
14	JRealtimeModelEventstatsObsrv::loadEventsFromDB()	JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:181
13	JRealtimeModelEventstatsObsrv->trackEventVisitPage()	JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:413
12	JRealtimeModelEventstatsObsrv->update()	JROOT/administrator/components/com_jrealtimeanalytics/framework/model/observable.php:97
11	JRealtimeModelObservable->notify()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:78
10	plgSystemJRealtimeAnalytics->notifyObservers()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:152
9	plgSystemJRealtimeAnalytics->injectApp()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:505
8	plgSystemJRealtimeAnalytics->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.31 ms ბოლო მოთხოვნის შემდეგ: 0.06 ms მოთხოვნის მეხსიერება: 0.007 MB მოთხოვნამდე მეხსიერება: 11.391 MB არჩეულია სტრიქონები: 0

SELECT * 
  FROM `bak_realtimeanalytics_eventstats`
 
  WHERE `type` = 'minpages'
 
  AND `published` = 1

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bak_realtimeanalytics_eventstats	ALL	NULL	ინდექსი არ გამოიყენება	NULL	NULL	1	100.00	Using where

SQL-მოთხოვნის პროფილი

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

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:388
14	JRealtimeModelEventstatsObsrv::loadEventsFromDB()	JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:231
13	JRealtimeModelEventstatsObsrv->trackEventMinPageVisited()	JROOT/components/com_jrealtimeanalytics/models/eventstatsobsrv.php:416
12	JRealtimeModelEventstatsObsrv->update()	JROOT/administrator/components/com_jrealtimeanalytics/framework/model/observable.php:97
11	JRealtimeModelObservable->notify()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:78
10	plgSystemJRealtimeAnalytics->notifyObservers()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:152
9	plgSystemJRealtimeAnalytics->injectApp()	JROOT/plugins/system/jrealtimeanalytics/jrealtimeanalytics.php:505
8	plgSystemJRealtimeAnalytics->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.28 ms ბოლო მოთხოვნის შემდეგ: 0.11 ms მოთხოვნის მეხსიერება: 0.005 MB მოთხოვნამდე მეხსიერება: 11.400 MB არჩეულია სტრიქონები: 1

SELECT count(*)

  FROM `bak_extensions`

  WHERE `element` = 'cwgears' 
  AND `extension_id` = ''

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	ინდექსი არ გამოიყენება	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:1003
9	plgSystemCwgears->updateDownloadKeySub()	JROOT/plugins/system/cwgears/cwgears.php:202
8	plgSystemCwgears->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 1.09 ms ბოლო მოთხოვნის შემდეგ: 3.51 ms მოთხოვნის მეხსიერება: 0.009 MB მოთხოვნამდე მეხსიერება: 11.620 MB არჩეულია სტრიქონები: 40

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `bak_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_j2xml','com_jce','com_joomlaupdate','com_jrealtimeanalytics','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_ose_firewall','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bak_assets	range	idx_asset_name	idx_asset_name	202	NULL	41	100.00	Using index condition

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.17 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.52 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 11.19 ms ბოლო მოთხოვნის შემდეგ: 0.37 ms მოთხოვნის მეხსიერება: 0.009 MB მოთხოვნამდე მეხსიერება: 11.675 MB არჩეულია სტრიქონები: 6175

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `bak_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bak_assets	ALL	idx_asset_name,idx_parent_id	ინდექსი არ გამოიყენება	NULL	NULL	6108	100.00	Using where

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	10.67 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 1.29 ms ბოლო მოთხოვნის შემდეგ: 13.00 ms მოთხოვნის მეხსიერება: 0.007 MB მოთხოვნამდე მეხსიერება: 17.069 MB არჩეულია სტრიქონები: 31

SHOW FULL COLUMNS 
  FROM `bak_content`

SQL-მოთხოვნების გეგმა (Explain)

EXPLAIN არ არის ხელმისაწვდომი მოთხოვნისთვის: SHOW FULL COLUMNS FROM `bak_content`

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.23 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.11 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.47 ms ბოლო მოთხოვნის შემდეგ: 3.18 ms მოთხოვნის მეხსიერება: 0.006 MB მოთხოვნამდე მეხსიერება: 17.300 MB არჩეულია სტრიქონები: 1

SELECT *

  FROM bak_content

  WHERE `id` = '5806'

SQL-მოთხოვნების გეგმა (Explain)

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

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/components/com_content/models/article.php:254
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.42 ms ბოლო მოთხოვნის შემდეგ: 0.12 ms მოთხოვნის მეხსიერება: 0.005 MB მოთხოვნამდე მეხსიერება: 17.310 MB

UPDATE bak_content

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

  WHERE `id` = '5806'

SQL-მოთხოვნების გეგმა (Explain)

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

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.04 ms
updating	0.08 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1245
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:255
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.79 ms ბოლო მოთხოვნის შემდეგ: 1.86 ms მოთხოვნის მეხსიერება: 0.007 MB მოთხოვნამდე მეხსიერება: 17.434 MB არჩეულია სტრიქონები: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.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 bak_content AS a

  INNER JOIN bak_categories AS c 
  on c.id = a.catid

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

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

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

  WHERE a.id = 5806 
  AND c.published > 0 
  AND a.language in ('ka-GE','*') 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-07-07 04:58:43') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-07-07 04:58:43') 
  AND (a.state = 1 OR a.state =2)

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid,idx_language	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	0.00	unique row not found

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.22 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.08 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.73 ms ბოლო მოთხოვნის შემდეგ: 2.21 ms მოთხოვნის მეხსიერება: 0.011 MB მოთხოვნამდე მეხსიერება: 17.616 MB არჩეულია სტრიქონები: 2

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 `bak_categories` AS `s`

  INNER JOIN `bak_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('ka-GE','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 32

  ORDER BY c.lft

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right,idx_language	idx_left_right	4	NULL	12	100.00	Using index condition; Using where

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.17 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
22	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
21	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
20	ContentRouter->getCategorySegment()	ისევე, როგორც გამოძახება ქვემოთ სტრიქონში.
19	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
18	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
17	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
16	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
15	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
11	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.64 ms ბოლო მოთხოვნის შემდეგ: 1.01 ms მოთხოვნის მეხსიერება: 0.006 MB მოთხოვნამდე მეხსიერება: 17.675 MB არჩეულია სტრიქონები: 0

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

  FROM `bak_contentitem_tag_map` AS m 

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

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

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	ინდექსი არ გამოიყენება	NULL	NULL	30	76.67	Using where
1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	Fsokhumi.t.id	1	100.00	Using index condition; Using where

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.17 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.46 ms ბოლო მოთხოვნის შემდეგ: 1.96 ms მოთხოვნის მეხსიერება: 0.010 MB მოთხოვნამდე მეხსიერება: 17.789 MB არჩეულია სტრიქონები: 1

SELECT `extension_id`,`name`,`enabled`,`params`

  FROM bak_extensions

  WHERE `type` = 'plugin' 
  AND `element` = 'osyoutube' 
  AND `folder` = 'content'

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bak_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:149
19	Alledia\Framework\Joomla\Extension\Generic->getDataFromDatabase()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Generic.php:121
18	Alledia\Framework\Joomla\Extension\Generic->__construct()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/Licensed.php:51
17	Alledia\Framework\Joomla\Extension\Licensed->__construct()	JROOT/libraries/allediaframework/Framework/Factory.php:38
16	Alledia\Framework\Factory::getExtension()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/AbstractPlugin.php:73
15	Alledia\Framework\Joomla\Extension\AbstractPlugin->loadExtension()	JROOT/libraries/allediaframework/Framework/Joomla/Extension/AbstractPlugin.php:44
14	Alledia\Framework\Joomla\Extension\AbstractPlugin->init()	JROOT/plugins/content/osyoutube/library/BasePlugin.php:33
13	Alledia\OSYouTube\BasePlugin->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
12	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
11	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_content/views/article/view.html.php:192
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 1.26 ms ბოლო მოთხოვნის შემდეგ: 13.01 ms მოთხოვნის მეხსიერება: 0.009 MB მოთხოვნამდე მეხსიერება: 19.192 MB არჩეულია სტრიქონები: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM bak_fields AS a

  LEFT JOIN `bak_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN bak_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN bak_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN bak_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN bak_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `bak_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (32,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1) 
  AND a.language in ('*','ka-GE')

  ORDER BY a.ordering ASC

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context,idx_language	idx_state	1	const	1	100.00	Using where; Using temporary; გამოიყენება filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	Fsokhumi.a.language	1	100.00	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	Fsokhumi.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	Fsokhumi.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	Fsokhumi.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	Fsokhumi.a.group_id	1	100.00	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	Fsokhumi.a.id	1	100.00	Using where; Using index; Distinct

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.20 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.05 ms
Creating tmp table	0.06 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.32 ms
Creating sort index	0.03 ms
end	0.01 ms
removing tmp table	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 2.06 ms ბოლო მოთხოვნის შემდეგ: 223.25 ms მოთხოვნის მეხსიერება: 0.008 MB მოთხოვნამდე მეხსიერება: 19.505 MB არჩეულია სტრიქონები: 100

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 bak_content AS a

  LEFT JOIN bak_categories AS cc 
  ON cc.id = a.catid

  WHERE a.catid = 32 
  AND a.state = 1 
  AND a.access IN (1,1,5)  
  AND (a.state = 1 OR a.state = -1) 
  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2020-07-07 04:58:43') 
  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2020-07-07 04:58:43') 
  AND a.language in ('ka-GE','*')

  ORDER BY  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_language	idx_catid	4	const	102	100.00	Using where; გამოიყენება filesort
1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.31 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.10 ms
System lock	0.01 ms
optimizing	0.04 ms
statistics	0.19 ms
preparing	0.05 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/plugins/content/pagenavigation/pagenavigation.php:161
13	PlgContentPagenavigation->onContentBeforeDisplay()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:199
10	ContentViewArticle->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.71 ms ბოლო მოთხოვნის შემდეგ: 11.79 ms მოთხოვნის მეხსიერება: 0.005 MB მოთხოვნამდე მეხსიერება: 20.007 MB არჩეულია სტრიქონები: 4

SELECT language,id

  FROM `bak_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bak_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	77	100.00	Using where

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.19 ms
end	0.16 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.30 ms ბოლო მოთხოვნის შემდეგ: 0.24 ms მოთხოვნის მეხსიერება: 0.009 MB მოთხოვნამდე მეხსიერება: 20.018 MB არჩეულია სტრიქონები: 1

SELECT `alias`

  FROM `bak_content`

  WHERE id = '5806'

SQL-მოთხოვნების გეგმა (Explain)

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

SQL-მოთხოვნის პროფილი

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

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
17	ContentRouter->getArticleSegment()	ისევე, როგორც გამოძახება ქვემოთ სტრიქონში.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/languagefilter/languagefilter.php:763
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.30 ms ბოლო მოთხოვნის შემდეგ: 0.11 ms მოთხოვნის მეხსიერება: 0.008 MB მოთხოვნამდე მეხსიერება: 20.025 MB არჩეულია სტრიქონები: 1

SELECT alias

  FROM bak_content

  WHERE id=5806

SQL-მოთხოვნების გეგმა (Explain)

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

SQL-მოთხოვნის პროფილი

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

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
15	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
14	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:528
13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/languagefilter/languagefilter.php:763
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.91 ms ბოლო მოთხოვნის შემდეგ: 1.63 ms მოთხოვნის მეხსიერება: 0.005 MB მოთხოვნამდე მეხსიერება: 20.077 MB არჩეულია სტრიქონები: 2

SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`

  FROM `bak_content` AS `c`

  INNER JOIN `bak_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item'

  INNER JOIN `bak_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key`

  INNER JOIN `bak_content` AS `c2` 
  ON a2.id = c2.`id`

  INNER JOIN `bak_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

  WHERE c.id = 5806 
  AND c2.access IN (1,1,5) 
  AND c2.language != 'ka-GE' 
  AND (c2.publish_up = '0000-00-00 00:00:00' OR c2.publish_up <= '2020-07-07 04:58:43') 
  AND (c2.publish_down = '0000-00-00 00:00:00' OR c2.publish_down >= '2020-07-07 04:58:43') 
  AND c2.state = 1

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	a	const	PRIMARY,idx_key	PRIMARY	206	const,const	1	100.00	NULL
1	SIMPLE	a2	ref	idx_key	idx_key	128	const	3	100.00	Using index
1	SIMPLE	c2	eq_ref	PRIMARY,idx_access,idx_state,idx_catid,idx_language	PRIMARY	4	Fsokhumi.a2.id	1	100.00	Using where
1	SIMPLE	ca	eq_ref	PRIMARY,cat_idx	PRIMARY	4	Fsokhumi.c2.catid	1	100.00	Using where

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.16 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.30 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.09 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
9	Joomla\CMS\Language\Associations::getAssociations()	JROOT/components/com_content/helpers/association.php:76
8	ContentHelperAssociation::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:783
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 1.02 ms ბოლო მოთხოვნის შემდეგ: 0.31 ms მოთხოვნის მეხსიერება: 0.009 MB მოთხოვნამდე მეხსიერება: 20.088 MB არჩეულია სტრიქონები: 2

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 `bak_categories` AS `s`

  INNER JOIN `bak_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('ka-GE','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 82

  ORDER BY c.lft

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	გამოიყენება filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	ინდექსი არ გამოიყენება	NULL	NULL	49	26.53	Using where

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.21 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.17 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.23 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.09 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
17	ContentRouter->getCategorySegment()	ისევე, როგორც გამოძახება ქვემოთ სტრიქონში.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/languagefilter/languagefilter.php:810
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.98 ms ბოლო მოთხოვნის შემდეგ: 0.40 ms მოთხოვნის მეხსიერება: 0.009 MB მოთხოვნამდე მეხსიერება: 20.106 MB არჩეულია სტრიქონები: 2

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 `bak_categories` AS `s`

  INNER JOIN `bak_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('ka-GE','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 81

  ORDER BY c.lft

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	გამოიყენება filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	ინდექსი არ გამოიყენება	NULL	NULL	49	28.57	Using where

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.21 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.17 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.20 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.10 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
17	ContentRouter->getCategorySegment()	ისევე, როგორც გამოძახება ქვემოთ სტრიქონში.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/languagefilter/languagefilter.php:810
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 1.02 ms ბოლო მოთხოვნის შემდეგ: 3.43 ms მოთხოვნის მეხსიერება: 0.010 MB მოთხოვნამდე მეხსიერება: 20.327 MB არჩეულია სტრიქონები: 15

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

  FROM bak_modules AS m

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

  LEFT JOIN bak_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2020-07-07 04:58:43') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-07-07 04:58:43') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 147 OR mm.menuid <= 0) 
  AND m.language IN ('ka-GE','*')

  ORDER BY m.position, m.ordering

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	27	100.00	Using index condition; Using where; გამოიყენება filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	Fsokhumi.m.id	1	100.00	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	Fsokhumi.m.module,const	1	100.00	Using index condition; Using where

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.17 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.10 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.41 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	ისევე, როგორც გამოძახება ქვემოთ სტრიქონში.
17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54
11	Warp\Joomla\Helper\WidgetsHelper->count()	JROOT/templates/yoo_everest/layouts/theme.config.php:26
10	include JROOT/templates/yoo_everest/layouts/theme.config.php	JROOT/templates/yoo_everest/layouts/theme.php:10
9	include JROOT/templates/yoo_everest/layouts/theme.php	JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_everest/index.php:16
7	require JROOT/templates/yoo_everest/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.49 ms ბოლო მოთხოვნის შემდეგ: 8.32 ms მოთხოვნის მეხსიერება: 0.011 MB მოთხოვნამდე მეხსიერება: 20.697 MB არჩეულია სტრიქონები: 3

SELECT `c2`.`language`,`c2`.`id`

  FROM `bak_menu` AS `c`

  INNER JOIN `bak_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `bak_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key`

  INNER JOIN `bak_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 147

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	a	const	PRIMARY,idx_key	PRIMARY	206	const,const	1	100.00	NULL
1	SIMPLE	a2	ref	idx_key	idx_key	128	const	3	100.00	Using index
1	SIMPLE	c2	eq_ref	PRIMARY	PRIMARY	4	Fsokhumi.a2.id	1	100.00	NULL

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
19	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
18	MenusHelper::getAssociations()	JROOT/modules/mod_languages/helper.php:58
17	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
16	include JROOT/modules/mod_languages/mod_languages.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_everest/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_everest/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_everest/layouts/theme.php:44
9	include JROOT/templates/yoo_everest/layouts/theme.php	JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_everest/index.php:16
7	require JROOT/templates/yoo_everest/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 11.66 ms ბოლო მოთხოვნის შემდეგ: 22.94 ms მოთხოვნის მეხსიერება: 0.011 MB მოთხოვნამდე მეხსიერება: 21.418 MB არჩეულია სტრიქონები: 0

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 c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  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

  FROM bak_content AS a

  LEFT JOIN bak_categories AS c 
  ON c.id = a.catid

  LEFT JOIN bak_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN bak_users AS uam 
  ON uam.id = a.modified_by

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

  WHERE c.published = 1 
  AND a.state = 1 
  AND a.catid IN (32,36,33,40,41,56,43,42,48,35,39,37,38) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-07-07 04:58:43') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-07-07 04:58:43') 
  AND (a.created >= '2020-7-01 00:00:00' 
  AND a.created <= '2020-8-01 00:00:00') 
  AND a.language IN ('ka-GE','*')

  ORDER BY a.created DESC

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	range	idx_state,idx_catid,idx_language	idx_catid	4	NULL	598	75.08	Using index condition; Using where; Using temporary; გამოიყენება filesort
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	Fsokhumi.a.catid	1	100.00	Using where
1	SIMPLE	ua	ALL	PRIMARY	ინდექსი არ გამოიყენება	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	uam	ALL	PRIMARY	ინდექსი არ გამოიყენება	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	Fsokhumi.c.parent_id	1	100.00	Using where

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.24 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.09 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.14 ms
preparing	0.06 ms
Creating tmp table	0.08 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	10.53 ms
Creating sort index	0.04 ms
end	0.02 ms
removing tmp table	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.10 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
19	ContentModelArticles->getItems()	JROOT/modules/mod_newscalendar/helper.php:211
18	modNewsCalendarHelper::getList()	JROOT/modules/mod_newscalendar/helper.php:84
17	modNewsCalendarHelper::getCal()	JROOT/modules/mod_newscalendar/mod_newscalendar.php:19
16	include JROOT/modules/mod_newscalendar/mod_newscalendar.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_everest/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_everest/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_everest/layouts/theme.php:112
9	include JROOT/templates/yoo_everest/layouts/theme.php	JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_everest/index.php:16
7	require JROOT/templates/yoo_everest/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 299.45 ms ბოლო მოთხოვნის შემდეგ: 3.33 ms მოთხოვნის მეხსიერება: 0.011 MB მოთხოვნამდე მეხსიერება: 21.466 MB არჩეულია სტრიქონები: 8

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 c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  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

  FROM bak_content AS a

  LEFT JOIN bak_categories AS c 
  ON c.id = a.catid

  LEFT JOIN bak_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN bak_users AS uam 
  ON uam.id = a.modified_by

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

  WHERE c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-07-07 04:58:43') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-07-07 04:58:43') 
  AND a.language IN ('ka-GE','*')

  ORDER BY a.created DESC 
  LIMIT 8

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	ALL	PRIMARY	ინდექსი არ გამოიყენება	NULL	NULL	49	100.00	Using where; Using temporary; გამოიყენება filesort
1	SIMPLE	a	ref	idx_state,idx_catid,idx_language	idx_catid	4	Fsokhumi.c.id	46	100.00	Using index condition; Using where
1	SIMPLE	ua	ALL	PRIMARY	ინდექსი არ გამოიყენება	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	uam	ALL	PRIMARY	ინდექსი არ გამოიყენება	NULL	NULL	2	100.00	Using where; Using join buffer (Block Nested Loop)
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	Fsokhumi.c.parent_id	1	100.00	Using where

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.25 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.09 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.07 ms
Creating tmp table	0.07 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	215.92 ms
Creating sort index	80.60 ms
end	0.41 ms
removing tmp table	1.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.10 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
18	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:123
17	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
16	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_everest/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_everest/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_everest/layouts/theme.php:112
9	include JROOT/templates/yoo_everest/layouts/theme.php	JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_everest/index.php:16
7	require JROOT/templates/yoo_everest/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 3.49 ms ბოლო მოთხოვნის შემდეგ: 1.36 ms მოთხოვნის მეხსიერება: 0.014 MB მოთხოვნამდე მეხსიერება: 21.669 MB არჩეულია სტრიქონები: 2

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 `bak_categories` AS `s`

  INNER JOIN `bak_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('ka-GE','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 33

  ORDER BY c.lft

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	გამოიყენება filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	ინდექსი არ გამოიყენება	NULL	NULL	49	38.78	Using where

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.19 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.20 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
30	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
29	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
28	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
27	ContentRouter->getCategorySegment()	ისევე, როგორც გამოძახება ქვემოთ სტრიქონში.
26	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
25	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
24	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
23	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
22	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
18	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_latest/helper.php:135
17	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
16	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_everest/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_everest/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_everest/layouts/theme.php:112
9	include JROOT/templates/yoo_everest/layouts/theme.php	JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_everest/index.php:16
7	require JROOT/templates/yoo_everest/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 9.63 ms ბოლო მოთხოვნის შემდეგ: 0.37 ms მოთხოვნის მეხსიერება: 0.014 MB მოთხოვნამდე მეხსიერება: 21.691 MB არჩეულია სტრიქონები: 2

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 `bak_categories` AS `s`

  INNER JOIN `bak_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('ka-GE','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 56

  ORDER BY c.lft

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	გამოიყენება filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	ინდექსი არ გამოიყენება	NULL	NULL	49	57.14	Using where

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.23 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.17 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.12 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
30	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
29	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
28	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
27	ContentRouter->getCategorySegment()	ისევე, როგორც გამოძახება ქვემოთ სტრიქონში.
26	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
25	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
24	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
23	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
22	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
18	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_latest/helper.php:135
17	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
16	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_everest/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_everest/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_everest/layouts/theme.php:112
9	include JROOT/templates/yoo_everest/layouts/theme.php	JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_everest/index.php:16
7	require JROOT/templates/yoo_everest/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.72 ms ბოლო მოთხოვნის შემდეგ: 0.98 ms მოთხოვნის მეხსიერება: 0.014 MB მოთხოვნამდე მეხსიერება: 21.719 MB არჩეულია სტრიქონები: 2

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 `bak_categories` AS `s`

  INNER JOIN `bak_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('ka-GE','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 43

  ORDER BY c.lft

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	გამოიყენება filesort
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right,idx_language	ინდექსი არ გამოიყენება	NULL	NULL	49	63.27	Using where

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.16 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.12 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
30	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
29	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
28	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
27	ContentRouter->getCategorySegment()	ისევე, როგორც გამოძახება ქვემოთ სტრიქონში.
26	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
25	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
24	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
23	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
22	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
21	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
20	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
19	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
18	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_latest/helper.php:135
17	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
16	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_everest/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_everest/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_everest/layouts/theme.php:112
9	include JROOT/templates/yoo_everest/layouts/theme.php	JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_everest/index.php:16
7	require JROOT/templates/yoo_everest/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.33 ms ბოლო მოთხოვნის შემდეგ: 1.64 ms მოთხოვნის მეხსიერება: 0.010 MB მოთხოვნამდე მეხსიერება: 21.572 MB არჩეულია სტრიქონები: 1

SELECT COUNT(id) AS count_users

  FROM bak_users

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bak_users	index	NULL	idx_block	1	NULL	2	100.00	Using index

SQL-მოთხოვნის პროფილი

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

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/modules/mod_stats/helper.php:80
17	ModStatsHelper::getList()	JROOT/modules/mod_stats/mod_stats.php:17
16	include JROOT/modules/mod_stats/mod_stats.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_everest/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_everest/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_everest/layouts/theme.php:112
9	include JROOT/templates/yoo_everest/layouts/theme.php	JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_everest/index.php:16
7	require JROOT/templates/yoo_everest/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 2.02 ms ბოლო მოთხოვნის შემდეგ: 0.06 ms მოთხოვნის მეხსიერება: 0.010 MB მოთხოვნამდე მეხსიერება: 21.582 MB არჩეულია სტრიქონები: 1

SELECT COUNT(id) AS count_items

  FROM bak_content

  WHERE state = 1

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bak_content	ref	idx_state	idx_state	1	const	6115	100.00	Using index

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	1.68 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/modules/mod_stats/helper.php:95
17	ModStatsHelper::getList()	JROOT/modules/mod_stats/mod_stats.php:17
16	include JROOT/modules/mod_stats/mod_stats.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_everest/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_everest/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_everest/layouts/theme.php:112
9	include JROOT/templates/yoo_everest/layouts/theme.php	JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_everest/index.php:16
7	require JROOT/templates/yoo_everest/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 11.94 ms ბოლო მოთხოვნის შემდეგ: 0.07 ms მოთხოვნის მეხსიერება: 0.010 MB მოთხოვნამდე მეხსიერება: 21.593 MB არჩეულია სტრიქონები: 1

SELECT SUM(hits) AS count_hits

  FROM bak_content

  WHERE state = 1

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bak_content	ref	idx_state	idx_state	1	const	6115	100.00	NULL

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	11.54 ms
end	0.03 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.08 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/modules/mod_stats/helper.php:129
17	ModStatsHelper::getList()	JROOT/modules/mod_stats/mod_stats.php:17
16	include JROOT/modules/mod_stats/mod_stats.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/yoo_everest/warp/systems/joomla/layouts/widgets.php:10
12	include JROOT/templates/yoo_everest/warp/systems/joomla/layouts/widgets.php	JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49
11	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_everest/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/yoo_everest/layouts/theme.php:112
9	include JROOT/templates/yoo_everest/layouts/theme.php	JROOT/templates/yoo_everest/warp/src/Warp/Helper/TemplateHelper.php:49
8	Warp\Helper\TemplateHelper->render()	JROOT/templates/yoo_everest/index.php:16
7	require JROOT/templates/yoo_everest/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.50 ms ბოლო მოთხოვნის შემდეგ: 6.28 ms მოთხოვნის მეხსიერება: 0.005 MB მოთხოვნამდე მეხსიერება: 21.528 MB არჩეულია სტრიქონები: 1

SELECT template

  FROM bak_template_styles

  WHERE home = 1 
  AND client_id = 0

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bak_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	2	100.00	Using where

SQL-მოთხოვნის პროფილი

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.01 ms

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
9	JDatabaseDriver->loadResult()	JROOT/plugins/system/yt/yt.php:168
8	plgSystemYt->nameOfSJTemplate()	JROOT/plugins/system/yt/yt.php:85
7	plgSystemYt->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1034
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.40 ms ბოლო მოთხოვნის შემდეგ: 4.81 ms მოთხოვნის მეხსიერება: 0.007 MB მოთხოვნამდე მეხსიერება: 21.828 MB არჩეულია სტრიქონები: 0

SELECT uikit

  FROM `bak_cwgears`

  WHERE url = 'http://www.fsokhumi.ge/index.php/ka/newska/treining/5806-2019-06-27-07-29-10'

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bak_cwgears	ALL	NULL	ინდექსი არ გამოიყენება	NULL	NULL	1	100.00	Using where

SQL-მოთხოვნის პროფილი

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

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:67
13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:418
12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

მოთხოვნის დრო: 0.30 ms ბოლო მოთხოვნის შემდეგ: 0.10 ms მოთხოვნის მეხსიერება: 0.007 MB მოთხოვნამდე მეხსიერება: 21.834 MB არჩეულია სტრიქონები: 0

SELECT uikit_plus

  FROM `bak_cwgears`

  WHERE url = 'http://www.fsokhumi.ge/index.php/ka/newska/treining/5806-2019-06-27-07-29-10'

SQL-მოთხოვნების გეგმა (Explain)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	bak_cwgears	ALL	NULL	ინდექსი არ გამოიყენება	NULL	NULL	1	100.00	Using where

SQL-მოთხოვნის პროფილი

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

გამოძახებების სტეკი

#	გამოძახების ობიექტი	ფააილი და სტრიქონის ნომერი
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:67
13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:427
12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:72

42 მოთხოვნის ტიპია შესული, დალაგებულია მოთხოვნის რაოდენობის მიხედვით DESC.

SELECT ტიპის მოთხოვნები:

7 × 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 `bak_categories` AS `s` 
  INNER JOIN `bak_categories` AS `c` 
  ON (s.lft < c.lft 
  AND c.lft < s.rgt 
  AND c.language IN ('ka-GE','*')) OR (c.lft <= s.lft 
  AND s.rgt <= c.rgt)

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `bak_extensions`

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `bak_assets`

2 × SELECT * 
  FROM `bak_realtimeanalytics_eventstats`

2 × 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 c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  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, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  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 
  FROM bak_content AS a 
  LEFT JOIN bak_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN bak_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN bak_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN bak_categories as parent 
  ON parent.id = c.parent_id

1 × SELECT `data` 
  FROM `bak_session`

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 bak_content AS a 
  LEFT JOIN bak_categories AS cc 
  ON cc.id = a.catid

1 × SELECT language,id 
  FROM `bak_menu`

1 × SELECT `alias` 
  FROM `bak_content`

```
1 × SELECT alias 
  FROM bak_content
```

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

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

1 × SELECT `extension_id`,`name`,`enabled`,`params` 
  FROM bak_extensions

1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `bak_menu` AS `c` 
  INNER JOIN `bak_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `bak_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `bak_menu` AS `c2` 
  ON a2.id = c2.`id`

1 × SELECT COUNT(id) AS count_users 
  FROM bak_user

1 × SELECT COUNT(id) AS count_items 
  FROM bak_content

1 × SELECT SUM(hits) AS count_hits 
  FROM bak_content

1 × SELECT template 
  FROM bak_template_styles

1 × SELECT uikit 
  FROM `bak_cwgears`

1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM bak_fields AS a 
  LEFT JOIN `bak_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN bak_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN bak_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN bak_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN bak_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `bak_fields_categories` AS fc 
  ON fc.field_id = a.id

```
1 × SELECT * 
  FROM bak_content
```

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

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.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 bak_content AS a 
  INNER JOIN bak_categories AS c 
  on c.id = a.catid 
  LEFT JOIN bak_users AS u 
  on u.id = a.created_by 
  LEFT JOIN bak_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN bak_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT `session_id` 
  FROM `bak_session`

1 × SELECT count(*) 
  FROM `bak_extensions`

```
1 × SELECT * 
  FROM bak_session
```

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

1 × SELECT `alias`,`catid` 
  FROM `bak_content`

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

1 × SELECT count(*) 
  FROM `bak_cwgears_schedule`

1 × SELECT count(*) 
  FROM `bak_cwgears_schedule

1 × SELECT `element`,`name`,`client_id`,`extension_id` 
  FROM `bak_extensions`

```
1 × SELECT * 
  FROM bak_languages
```

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM bak_extensions

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

1 × SELECT id, rules 
  FROM `bak_viewlevels

1 × SELECT uikit_plus 
  FROM `bak_cwgears`

სხვა SQL-მოთხოვნები:

1 × INSERT INTO `bak_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3062396263386130373961643730333165363166623262663461653766313765', 1, 1594097923, 0, '', 0

1 × UPDATE `bak_extensions` 
  SET `params` = '{\"mediaversion\":\"4a19b6bd04b153cef9fbe77fc56fd819\"}'

1 × SHOW FULL COLUMNS 
  FROM `bak_session

1 × SHOW FULL COLUMNS 
  FROM `bak_content

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

ქობულეთი: ტრენინგი „სამედიცინო პერსონალის როლი ძალადობის პრევენციასა და მსხვერპლთა დაცვაში“

Joomla! გამართვის (Debug) კონსოლი

სესია

პროფილის ინფორმაცია

დრო

მეხსიერება

მეხსიერების გამოყენება

მოთხოვნები მონაცემთა ბაზაზე

52 შესული SQL-მოთხოვნა 377.63 ms

42 მოთხოვნის ტიპია შესული, დალაგებულია მოთხოვნის რაოდენობის მიხედვით DESC.

SELECT ტიპის მოთხოვნები:

სხვა SQL-მოთხოვნები: