Sehitlerimiz

Joomla Hata Ayıklama Konsolu

Oturum

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1722071152,
                "last": 1722071152,
                "now": 1722071152
            },
            "token": "jsqDHOnkwV2GXX13XM9CtBH7bY4pJyto"
        },
        "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
        }
    }
}

Profil Bilgisi

Süre

Bellek

Süre: 3.65 ms / 3.65 ms Bellek: 0.397 MB / 0.74 MB Application: afterLoad

Süre: 28.19 ms / 31.84 ms Bellek: 0.527 MB / 1.27 MB Application: afterInitialise

Süre: 4.88 ms / 36.72 ms Bellek: 0.141 MB / 1.41 MB Application: afterRoute

Süre: 4.90 ms / 41.62 ms Bellek: 0.100 MB / 1.51 MB Application: beforeRenderComponent com_phocagallery

Süre: 24.48 ms / 66.11 ms Bellek: 0.759 MB / 2.27 MB Application: afterRenderComponent com_phocagallery

Süre: 0.29 ms / 66.39 ms Bellek: 0.004 MB / 2.27 MB Application: afterDispatch

Süre: 2.50 ms / 68.89 ms Bellek: 0.032 MB / 2.31 MB Application: Before Access::preloadComponents (all components)

Süre: 1.05 ms / 69.94 ms Bellek: 0.047 MB / 2.35 MB Application: After Access::preloadComponents (all components)

Süre: 0.03 ms / 69.96 ms Bellek: -0.002 MB / 2.35 MB Application: Before Access::getAssetRules (id:16 name:com_menus)

Süre: 0.16 ms / 70.13 ms Bellek: 0.016 MB / 2.37 MB Application: After Access::getAssetRules (id:16 name:com_menus)

Süre: 0.07 ms / 70.20 ms Bellek: 0.004 MB / 2.37 MB Application: beforeRenderModule mod_menu (Ana Menu)

Süre: 1.56 ms / 71.76 ms Bellek: 0.060 MB / 2.43 MB Application: afterRenderModule mod_menu (Ana Menu)

Süre: 0.03 ms / 71.78 ms Bellek: -0.003 MB / 2.43 MB Application: beforeRenderModule mod_menu (Dernek Hakkında)

Süre: 0.57 ms / 72.35 ms Bellek: 0.030 MB / 2.46 MB Application: afterRenderModule mod_menu (Dernek Hakkında)

Süre: 0.02 ms / 72.38 ms Bellek: -0.001 MB / 2.46 MB Application: beforeRenderModule mod_menu (Resim Galerisi)

Süre: 0.58 ms / 72.96 ms Bellek: 0.027 MB / 2.48 MB Application: afterRenderModule mod_menu (Resim Galerisi)

Süre: 0.02 ms / 72.98 ms Bellek: -0.002 MB / 2.48 MB Application: beforeRenderModule mod_menu (Aidat Ödeme-2023)

Süre: 0.62 ms / 73.60 ms Bellek: 0.038 MB / 2.52 MB Application: afterRenderModule mod_menu (Aidat Ödeme-2023)

Süre: 0.02 ms / 73.62 ms Bellek: -0.001 MB / 2.52 MB Application: beforeRenderModule mod_menu (İçerik Yönetimi)

Süre: 0.55 ms / 74.17 ms Bellek: 0.036 MB / 2.55 MB Application: afterRenderModule mod_menu (İçerik Yönetimi)

Süre: 0.02 ms / 74.19 ms Bellek: 0.000 MB / 2.55 MB Application: beforeRenderModule mod_login (Login Form)

Süre: 1.20 ms / 75.39 ms Bellek: 0.018 MB / 2.57 MB Application: afterRenderModule mod_login (Login Form)

Süre: 0.07 ms / 75.45 ms Bellek: -0.002 MB / 2.57 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Süre: 0.56 ms / 76.01 ms Bellek: 0.010 MB / 2.58 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Süre: 1.74 ms / 77.76 ms Bellek: 0.131 MB / 2.71 MB Application: afterRender

Veritabanı sorguları toplamı: 23.72 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pbysg_session	const	PRIMARY	PRIMARY	194	const	1

Status	Duration
Starting	0.19 ms
checking permissions	0.05 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.02 ms
Executing	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.07 ms
Starting cleanup	0.03 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

#	Çağırıcı	Dosya ve satır sayısı
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Aşağıdaki satırda bulunan çağrı gibi.
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:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

#	Çağırıcı	Dosya ve satır sayısı
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:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

Şu sorgudaki olamayacakları AÇIKLA: INSERT INTO `pbysg_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6a347470736f386362666d726b7265367361666338766f6e6361', 1, 1722071152, 0, '', 0)

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.03 ms
init for update	0.03 ms
Update	0.07 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.04 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.90 ms Son sorgudan sonra: 0.58 ms Sorgu belleği: 0.022 MB belleği şu sorgudan önce: 0.865 MB Dönen satır: 35

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

  FROM `pbysg_extensions`

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

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pbysg_extensions	ref	extension	extension	82	const	35	Using index condition; Using where

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.04 ms
Executing	0.02 ms
Sending data	0.19 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
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}()	Aşağıdaki satırda bulunan çağrı gibi.
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.70 ms Son sorgudan sonra: 0.66 ms Sorgu belleği: 0.020 MB belleği şu sorgudan önce: 0.876 MB Dönen satır: 5

SELECT id, rules

  FROM `pbysg_viewlevels`

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pbysg_viewlevels	ALL	NULL	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	5

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.06 ms
End of update loop	0.02 ms
Query end	0.03 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
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:318
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.81 ms Son sorgudan sonra: 0.11 ms Sorgu belleği: 0.021 MB belleği şu sorgudan önce: 0.888 MB Dönen satır: 2

SELECT b.id

  FROM pbysg_usergroups AS a

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

  WHERE a.id = 9

Açıkla

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

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.02 ms
Unlocking tables	0.03 ms
Preparing	0.04 ms
Executing	0.02 ms
Sending data	0.04 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
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:318
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 1.17 ms Son sorgudan sonra: 0.21 ms Sorgu belleği: 0.022 MB belleği şu sorgudan önce: 0.909 MB Dönen satır: 84

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

  FROM pbysg_extensions

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

  ORDER BY ordering

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pbysg_extensions	ALL	extension	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	195	Using where; Dosya sıralama kullanılıyor

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.02 ms
Creating sort index	0.44 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Aşağıdaki satırda bulunan çağrı gibi.
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:356
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 1.57 ms Son sorgudan sonra: 15.34 ms Sorgu belleği: 0.040 MB belleği şu sorgudan önce: 1.290 MB Dönen satır: 25

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

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

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	32	Using index condition; Using where; Dosya sıralama kullanılıyor
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	u487941167_kasa.m.component_id	1	Using where

Profil

Status	Duration
Starting	0.22 ms
checking permissions	0.07 ms
Opening tables	0.07 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.04 ms
Sorting result	0.03 ms
Executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.46 ms
End of update loop	0.04 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.04 ms
Query end	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.10 ms
Updating status	0.03 ms
Reset for next command	0.03 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Aşağıdaki satırda bulunan çağrı gibi.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.92 ms Son sorgudan sonra: 2.95 ms Sorgu belleği: 0.023 MB belleği şu sorgudan önce: 1.429 MB Dönen satır: 1

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

  FROM `pbysg_extensions`

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

Açıkla

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

Profil

Status	Duration
Starting	0.16 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.03 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.04 ms
Executing	0.02 ms
Sending data	0.09 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.06 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Aşağıdaki satırda bulunan çağrı gibi.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.66 ms Son sorgudan sonra: 0.14 ms Sorgu belleği: 0.005 MB belleği şu sorgudan önce: 1.419 MB

UPDATE `pbysg_extensions`

  SET `params` = '{\"mediaversion\":\"73d0484615487855200170a1ba86dcf2\"}'

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

Açıkla

Şu sorgudaki olamayacakları AÇIKLA: UPDATE `pbysg_extensions` SET `params` = '{\"mediaversion\":\"73d0484615487855200170a1ba86dcf2\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profil

Status	Duration
Starting	0.09 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init for update	0.07 ms
Updating	0.07 ms
End of update loop	0.02 ms
Query end	0.03 ms
Commit	0.05 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.06 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.80 ms Son sorgudan sonra: 0.33 ms Sorgu belleği: 0.019 MB belleği şu sorgudan önce: 1.428 MB Dönen satır: 2

SELECT *

  FROM pbysg_languages

  WHERE published=1

  ORDER BY ordering ASC

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pbysg_languages	ALL	NULL	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	2	Using where; Dosya sıralama kullanılıyor

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.09 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.03 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
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/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.84 ms Son sorgudan sonra: 0.22 ms Sorgu belleği: 0.019 MB belleği şu sorgudan önce: 1.441 MB Dönen satır: 3

SELECT id, home, template, s.params

  FROM pbysg_template_styles as s

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

Açıkla

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

Profil

Status	Duration
Starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.04 ms
Statistics	0.09 ms
Preparing	0.04 ms
Executing	0.02 ms
Sending data	0.11 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.75 ms Son sorgudan sonra: 4.26 ms Sorgu belleği: 0.022 MB belleği şu sorgudan önce: 1.919 MB Dönen satır: 3

SELECT a.filename as filename, a.type as type, a.menulink as menulink 
  FROM pbysg_phocagallery_styles AS a 
  WHERE a.published = 1 
  ORDER BY a.type, a.ordering ASC

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	3	Using where; Dosya sıralama kullanılıyor

Profil

Status	Duration
Starting	0.10 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.02 ms
Creating sort index	0.07 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_phocagallery/libraries/phocagallery/render/renderfront.php:736
11	PhocaGalleryRenderFront::renderAllCSS()	JROOT/components/com_phocagallery/views/category/view.html.php:65
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:58
6	require_once JROOT/components/com_phocagallery/phocagallery.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.65 ms Son sorgudan sonra: 0.76 ms Sorgu belleği: 0.022 MB belleği şu sorgudan önce: 1.939 MB Dönen satır: 0

SELECT a.* 
  FROM pbysg_phocagallery_fb_users AS a 
  WHERE a.id =0

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.03 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_phocagallery/libraries/phocagallery/facebook/fbsystem.php:46
12	PhocaGalleryFbSystem::getFbUserInfo()	JROOT/administrator/components/com_phocagallery/libraries/phocagallery/facebook/fbsystem.php:53
11	PhocaGalleryFbSystem::getCommentsParams()	JROOT/components/com_phocagallery/views/category/view.html.php:213
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:58
6	require_once JROOT/components/com_phocagallery/phocagallery.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.80 ms Son sorgudan sonra: 1.70 ms Sorgu belleği: 0.023 MB belleği şu sorgudan önce: 1.967 MB Dönen satır: 1

SELECT c.id, c.title, c.alias, c.description, c.published, c.approved, c.parent_id, c.deleteuserid, c.accessuserid, c.uploaduserid, c.owner_id, c.access, c.metakey, c.metadesc, c.latitude, c.longitude, c.zoom, c.geotitle, c.userfolder, c.image_id, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug  
  FROM pbysg_phocagallery_categories AS c 
  WHERE c.id = 1 
  LIMIT 0, 1

Açıkla

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

Profil

Status	Duration
Starting	0.12 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	0.04 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_phocagallery/models/category.php:229
13	PhocagalleryModelCategory->_loadCategory()	JROOT/components/com_phocagallery/models/category.php:184
12	PhocagalleryModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_phocagallery/views/category/view.html.php:389
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:58
6	require_once JROOT/components/com_phocagallery/phocagallery.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.65 ms Son sorgudan sonra: 0.47 ms Sorgu belleği: 0.022 MB belleği şu sorgudan önce: 1.982 MB Dönen satır: 0

SELECT cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.deleteuserid, cc.accessuserid, cc.uploaduserid, cc.access 
  FROM pbysg_phocagallery_categories AS cc 
  WHERE cc.id = 0 
  AND cc.published = 1 
  AND cc.approved = 1 
  AND cc.id <> 1 
  ORDER BY cc.ordering ASC 
  LIMIT 0, 1

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.02 ms
Executing	0.03 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_phocagallery/models/category.php:257
12	PhocagalleryModelCategory->getParentCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_phocagallery/views/category/view.html.php:585
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:58
6	require_once JROOT/components/com_phocagallery/phocagallery.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 1.56 ms Son sorgudan sonra: 0.04 ms Sorgu belleği: 0.023 MB belleği şu sorgudan önce: 1.991 MB Dönen satır: 2

SELECT DISTINCT cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.deleteuserid, cc.accessuserid, cc.uploaduserid, cc.access, cc.image_id, min(a.filename) as filename, min(a.extm) as extm, min(a.exts) as exts, min(a.extw) as extw, min(a.exth) as exth, min(a.extid) as extid 
  FROM pbysg_phocagallery_categories AS cc 
  LEFT JOIN pbysg_phocagallery AS a 
  ON cc.id = a.catid 
  WHERE cc.parent_id = 1 
  AND cc.published = 1 
  AND cc.approved = 1 
  AND cc.id <> 1 
  GROUP BY cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.deleteuserid, cc.accessuserid, cc.uploaduserid, cc.access, cc.image_id 
  ORDER BY cc.ordering ASC

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cc	ALL	PRIMARY	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	13	Using where; Using temporary; Dosya sıralama kullanılıyor
1	SIMPLE	a	ref	catid	catid	4	u487941167_kasa.cc.id	27

Profil

Status	Duration
Starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.04 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.06 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.04 ms
Creating tmp table	0.07 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.53 ms
Creating sort index	0.05 ms
Removing tmp table	0.11 ms
Creating sort index	0.02 ms
End of update loop	0.02 ms
Query end	0.03 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Query end	0.02 ms
Starting cleanup	0.03 ms
Freeing items	0.06 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_phocagallery/models/category.php:307
12	PhocagalleryModelCategory->getSubCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_phocagallery/views/category/view.html.php:749
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:58
6	require_once JROOT/components/com_phocagallery/phocagallery.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.66 ms Son sorgudan sonra: 0.06 ms Sorgu belleği: 0.022 MB belleği şu sorgudan önce: 2.001 MB Dönen satır: 1

Sorguları çoğalt: #19

SELECT COUNT(a.id) 
  FROM pbysg_phocagallery AS a 
  WHERE a.published = 1 
  AND a.approved = 1 
  AND a.catid = 5

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	catid	catid	5	const,const	1	Using where

Profil

Status	Duration
Starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.06 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
12	JDatabase->query()	JROOT/components/com_phocagallery/models/category.php:326
11	PhocagalleryModelCategory->getCountItem()	JROOT/components/com_phocagallery/views/category/view.html.php:780
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:58
6	require_once JROOT/components/com_phocagallery/phocagallery.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.63 ms Son sorgudan sonra: 0.02 ms Sorgu belleği: 0.022 MB belleği şu sorgudan önce: 2.007 MB Dönen satır: 1

Sorguları çoğalt: #18

SELECT COUNT(a.id) 
  FROM pbysg_phocagallery AS a 
  WHERE a.published = 1 
  AND a.approved = 1 
  AND a.catid = 5

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	catid	catid	5	const,const	1	Using where

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.03 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.05 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
12	JDatabaseDriver->loadRow()	JROOT/components/com_phocagallery/models/category.php:330
11	PhocagalleryModelCategory->getCountItem()	JROOT/components/com_phocagallery/views/category/view.html.php:780
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:58
6	require_once JROOT/components/com_phocagallery/phocagallery.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.69 ms Son sorgudan sonra: 0.54 ms Sorgu belleği: 0.022 MB belleği şu sorgudan önce: 2.019 MB Dönen satır: 1

Sorguları çoğalt: #21

SELECT COUNT(a.id) 
  FROM pbysg_phocagallery AS a 
  WHERE a.published = 1 
  AND a.approved = 1 
  AND a.catid = 3

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	catid	catid	5	const,const	17	Using where

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.03 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.09 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
12	JDatabase->query()	JROOT/components/com_phocagallery/models/category.php:326
11	PhocagalleryModelCategory->getCountItem()	JROOT/components/com_phocagallery/views/category/view.html.php:780
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:58
6	require_once JROOT/components/com_phocagallery/phocagallery.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.65 ms Son sorgudan sonra: 0.02 ms Sorgu belleği: 0.022 MB belleği şu sorgudan önce: 2.025 MB Dönen satır: 1

Sorguları çoğalt: #20

SELECT COUNT(a.id) 
  FROM pbysg_phocagallery AS a 
  WHERE a.published = 1 
  AND a.approved = 1 
  AND a.catid = 3

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	catid	catid	5	const,const	17	Using where

Profil

Status	Duration
Starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.08 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
12	JDatabaseDriver->loadRow()	JROOT/components/com_phocagallery/models/category.php:330
11	PhocagalleryModelCategory->getCountItem()	JROOT/components/com_phocagallery/views/category/view.html.php:780
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:58
6	require_once JROOT/components/com_phocagallery/phocagallery.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 1.55 ms Son sorgudan sonra: 0.20 ms Sorgu belleği: 0.022 MB belleği şu sorgudan önce: 2.034 MB Dönen satır: 12

SELECT a.*, cc.alias AS catalias, cc.accessuserid AS cataccessuserid, cc.access AS cataccess, 
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM pbysg_phocagallery AS a 
  LEFT JOIN pbysg_phocagallery_img_votes_statistics AS r 
  ON r.imgid = a.id 
  LEFT JOIN pbysg_phocagallery_categories AS cc 
  ON cc.id = a.catid 
  WHERE  a.catid= 1 
  AND a.published = 1 
  AND a.approved = 1 
  ORDER BY a.ordering ASC 
  LIMIT 0, 20

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	catid	catid	5	const,const	12	Using where; Using temporary; Dosya sıralama kullanılıyor
1	SIMPLE	r	ALL	NULL	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1

Profil

Status	Duration
Starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.07 ms
Preparing	0.04 ms
Creating tmp table	0.09 ms
Sorting result	0.03 ms
Executing	0.02 ms
Sending data	0.44 ms
Creating sort index	0.11 ms
Removing tmp table	0.09 ms
Creating sort index	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.06 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_phocagallery/models/category.php:67
11	PhocagalleryModelCategory->getData()	JROOT/components/com_phocagallery/views/category/view.html.php:994
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:58
6	require_once JROOT/components/com_phocagallery/phocagallery.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.79 ms Son sorgudan sonra: 0.21 ms Sorgu belleği: 0.022 MB belleği şu sorgudan önce: 2.077 MB Dönen satır: 12

SELECT a.id 
  FROM pbysg_phocagallery AS a 
  LEFT JOIN pbysg_phocagallery_categories AS cc 
  ON cc.id = a.catid 
  WHERE  a.catid= 1 
  AND a.published = 1 
  AND a.approved = 1 
  ORDER BY a.id

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	catid	catid	5	const,const	12	Using where

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.09 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:367
13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/components/com_phocagallery/models/category.php:75
12	PhocagalleryModelCategory->getTotal()	JROOT/components/com_phocagallery/models/category.php:83
11	PhocagalleryModelCategory->getPagination()	JROOT/components/com_phocagallery/views/category/view.html.php:996
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:58
6	require_once JROOT/components/com_phocagallery/phocagallery.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 1.28 ms Son sorgudan sonra: 2.52 ms Sorgu belleği: 0.025 MB belleği şu sorgudan önce: 2.174 MB Dönen satır: 42

SHOW FULL COLUMNS 
  FROM `pbysg_phocagallery_categories`

Açıkla

Şu sorgudaki olamayacakları AÇIKLA: SHOW FULL COLUMNS FROM `pbysg_phocagallery_categories`

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.02 ms
closing tables	0.02 ms
checking permissions	0.02 ms
Opening tables	0.21 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.02 ms
Filling schema table	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
checking permissions	0.17 ms
closing tables	0.02 ms
checking permissions	0.03 ms
Executing	0.02 ms
Sending data	0.09 ms
End of update loop	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Removing tmp table	0.09 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
14	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_phocagallery/tables/phocagalleryc.php:17
13	TablePhocaGalleryc->__construct()	JROOT/libraries/src/Table/Table.php:328
12	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_phocagallery/models/category.php:569
11	PhocagalleryModelCategory->hit()	JROOT/components/com_phocagallery/views/category/view.html.php:2097
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:58
6	require_once JROOT/components/com_phocagallery/phocagallery.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.62 ms Son sorgudan sonra: 0.26 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 2.227 MB

UPDATE pbysg_phocagallery_categories

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

  WHERE `id` = '1'

Açıkla

Şu sorgudaki olamayacakları AÇIKLA: UPDATE pbysg_phocagallery_categories SET `hits` = (`hits` + 1) WHERE `id` = '1'

Profil

Status	Duration
Starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init for update	0.06 ms
Updating	0.08 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.05 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
12	Joomla\CMS\Table\Table->hit()	JROOT/components/com_phocagallery/models/category.php:570
11	PhocagalleryModelCategory->hit()	JROOT/components/com_phocagallery/views/category/view.html.php:2097
10	PhocaGalleryViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocagallery/controller.php:30
8	PhocaGalleryController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocagallery/phocagallery.php:58
6	require_once JROOT/components/com_phocagallery/phocagallery.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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 1.10 ms Son sorgudan sonra: 3.51 ms Sorgu belleği: 0.023 MB belleği şu sorgudan önce: 2.315 MB Dönen satır: 7

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

  FROM pbysg_modules AS m

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

  LEFT JOIN pbysg_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 <= '2024-07-27 09:05:52') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-07-27 09:05:52') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 121 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	9	Using index condition; Using where; Dosya sıralama kullanılıyor
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	u487941167_kasa.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	u487941167_kasa.m.module,const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.12 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.05 ms
Optimizing	0.06 ms
Statistics	0.08 ms
Preparing	0.06 ms
Sorting result	0.03 ms
Executing	0.02 ms
Sending data	0.03 ms
Creating sort index	0.22 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.04 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.06 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	Aşağıdaki satırda bulunan çağrı gibi.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/lessallrounder/index.php:57
7	require JROOT/templates/lessallrounder/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

Sorgu Süresi: 0.89 ms Son sorgudan sonra: 1.13 ms Sorgu belleği: 0.022 MB belleği şu sorgudan önce: 2.308 MB Dönen satır: 35

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

  FROM `pbysg_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','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_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pbysg_assets	ALL	idx_asset_name	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	111	Using where

Profil

Status	Duration
Starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.16 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.05 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
12	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
11	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
10	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
9	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
8	Joomla\CMS\User\User->authorise()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:43
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
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:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Dosyalar için bağlantıların olması için php.ini dosyanıza xdebug.file_link_format yönergesini ekleyin.]

23 sorgu türü kayıt altına alındı, yinelemeye göre tersten sıralandı.

Seçili Tablolar:

4 × SELECT COUNT(a.id) 
  FROM pbysg_phocagallery AS a

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

1 × SELECT `data` 
  FROM `pbysg_session`

1 × SELECT `session_id` 
  FROM `pbysg_session`

1 × SELECT id, rules 
  FROM `pbysg_viewlevels

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

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

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

```
1 × SELECT * 
  FROM pbysg_languages
```

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

1 × SELECT a.filename as filename, a.type as type, a.menulink as menulink 
  FROM pbysg_phocagallery_styles AS a

1 × SELECT a.* 
  FROM pbysg_phocagallery_fb_users AS a

1 × SELECT c.id, c.title, c.alias, c.description, c.published, c.approved, c.parent_id, c.deleteuserid, c.accessuserid, c.uploaduserid, c.owner_id, c.access, c.metakey, c.metadesc, c.latitude, c.longitude, c.zoom, c.geotitle, c.userfolder, c.image_id, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug  
  FROM pbysg_phocagallery_categories AS c

1 × SELECT cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.deleteuserid, cc.accessuserid, cc.uploaduserid, cc.access 
  FROM pbysg_phocagallery_categories AS cc

1 × SELECT DISTINCT cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.deleteuserid, cc.accessuserid, cc.uploaduserid, cc.access, cc.image_id, min(a.filename) as filename, min(a.extm) as extm, min(a.exts) as exts, min(a.extw) as extw, min(a.exth) as exth, min(a.extid) as extid 
  FROM pbysg_phocagallery_categories AS cc 
  LEFT JOIN pbysg_phocagallery AS a 
  ON cc.id = a.catid

1 × SELECT a.*, cc.alias AS catalias, cc.accessuserid AS cataccessuserid, cc.access AS cataccess, 
  CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM pbysg_phocagallery AS a 
  LEFT JOIN pbysg_phocagallery_img_votes_statistics AS r 
  ON r.imgid = a.id 
  LEFT JOIN pbysg_phocagallery_categories AS cc 
  ON cc.id = a.catid

1 × SELECT a.id 
  FROM pbysg_phocagallery AS a 
  LEFT JOIN pbysg_phocagallery_categories AS cc 
  ON cc.id = a.catid

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

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `pbysg_assets`

Diğer Tablolar:

1 × INSERT INTO `pbysg_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6a347470736f386362666d726b7265367361666338766f6e6361', 1, 1722071152, 0, '', 0

1 × UPDATE `pbysg_extensions` 
  SET `params` = '{\"mediaversion\":\"73d0484615487855200170a1ba86dcf2\"}'

1 × SHOW FULL COLUMNS 
  FROM `pbysg_phocagallery_categories

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

Ana Menu

Dernek Hakkında

Resim Galerisi

Aidat Ödeme-2023

İçerik Yönetimi

Login Form

Sehitlerimiz - Sehitler

Joomla Hata Ayıklama Konsolu

Oturum

Profil Bilgisi

Süre

Bellek

Bellek Kullanımı

Veritabanı Sorguları

27 Sorgu Kaydedildi 23.72 ms

4 çoğaltma bulundu!

23 sorgu türü kayıt altına alındı, yinelemeye göre tersten sıralandı.

Seçili Tablolar:

Diğer Tablolar: