Osmaniye Havaş

Joomla Hata Ayıklama Konsolu

Oturum

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1611490406,
                "last": 1611490406,
                "now": 1611490406
            },
            "token": "vTvhQDvIMkEk1Gx1agaMwVNboUJLgk7M"
        },
        "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: 31.32 ms / 31.32 ms Bellek: 1.769 MB / 2.15 MB Application: afterLoad

Süre: 166.05 ms / 197.38 ms Bellek: 8.384 MB / 10.54 MB Application: afterInitialise

Süre: 62.45 ms / 259.82 ms Bellek: 2.648 MB / 13.19 MB Application: afterRoute

Süre: 0.78 ms / 260.60 ms Bellek: 0.055 MB / 13.24 MB Application: beforeRenderComponent com_djclassifieds

Süre: 441.02 ms / 701.62 ms Bellek: 7.876 MB / 21.12 MB Application: Before Access::preloadComponents (all components)

Süre: 2.27 ms / 703.89 ms Bellek: 0.088 MB / 21.21 MB Application: After Access::preloadComponents (all components)

Süre: 0.12 ms / 704.01 ms Bellek: 0.000 MB / 21.20 MB Application: Before Access::getAssetRules (id:334 name:com_djreviews)

Süre: 3.19 ms / 707.19 ms Bellek: 0.026 MB / 21.23 MB Application: After Access::getAssetRules (id:334 name:com_djreviews)

Süre: 25.68 ms / 732.87 ms Bellek: 0.504 MB / 21.73 MB Application: beforeRenderModule mod_custom (Custom Banner Top)

Süre: 2.37 ms / 735.24 ms Bellek: 0.035 MB / 21.77 MB Application: afterRenderModule mod_custom (Custom Banner Top)

Süre: 7.99 ms / 743.23 ms Bellek: 0.098 MB / 21.87 MB Application: beforeRenderModule mod_custom (Custom Banner Bottom)

Süre: 0.50 ms / 743.74 ms Bellek: 0.003 MB / 21.87 MB Application: afterRenderModule mod_custom (Custom Banner Bottom)

Süre: 0.56 ms / 744.29 ms Bellek: 0.000 MB / 20.24 MB Application: afterRenderComponent com_djclassifieds

Süre: 60.98 ms / 805.28 ms Bellek: 1.281 MB / 21.52 MB Application: afterDispatch

Süre: 60.68 ms / 865.96 ms Bellek: 1.455 MB / 22.97 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Süre: 3.96 ms / 869.92 ms Bellek: 0.028 MB / 23.00 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Süre: 1.75 ms / 871.68 ms Bellek: 0.033 MB / 23.03 MB Application: beforeRenderModule mod_djmegamenu_button (DJ-MegaMenu - Mobile Menu Button)

Süre: 0.50 ms / 872.17 ms Bellek: 0.007 MB / 23.04 MB Application: afterRenderModule mod_djmegamenu_button (DJ-MegaMenu - Mobile Menu Button)

Süre: 184.15 ms / 1056.32 ms Bellek: 1.614 MB / 24.65 MB Application: Before Access::getAssetRules (id:1 name:root.1)

Süre: 0.15 ms / 1056.48 ms Bellek: 0.007 MB / 24.66 MB Application: After Access::getAssetRules (id:1 name:root.1)

Süre: 690.08 ms / 1746.56 ms Bellek: 1.656 MB / 26.32 MB Application: afterRender

Veritabanı sorguları toplamı: 419.75 ms

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

#	Ç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: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:46

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	frm_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: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:46

Şu sorgudaki olamayacakları AÇIKLA: INSERT INTO `frm_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3461326431666564366632636335303733383963356634343732666430653962', 1, 1611490406, 0, '', 0)

Profil

Status	Duration
Starting	0.13 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.03 ms
Update	0.12 ms
Waiting for query cache lock	0.01 ms
Update	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.04 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.08 ms
Updating status	0.05 ms
Reset for next command	0.01 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: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: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.92 ms Son sorgudan sonra: 11.66 ms Sorgu belleği: 0.005 MB belleği şu sorgudan önce: 4.635 MB Dönen satır: 5

SELECT id, rules

  FROM `frm_viewlevels`

Açıkla

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

Profil

Status	Duration
Starting	0.19 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.07 ms
Updating status	0.06 ms
Reset for next command	0.01 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: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: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.87 ms Son sorgudan sonra: 0.21 ms Sorgu belleği: 0.005 MB belleği şu sorgudan önce: 4.647 MB Dönen satır: 2

SELECT b.id

  FROM frm_usergroups AS a

  LEFT JOIN frm_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	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	9	Using where; Using index

Profil

Status	Duration
Starting	0.16 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.03 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.11 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.06 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.10 ms
Updating status	0.05 ms
Reset for next command	0.01 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: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: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.60 ms Son sorgudan sonra: 29.25 ms Sorgu belleği: 0.007 MB belleği şu sorgudan önce: 6.306 MB Dönen satır: 2

SHOW FULL COLUMNS 
  FROM `frm_gsd_config`

Açıkla

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

Profil

Status	Duration
Starting	0.15 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.49 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
Checking permissions	0.08 ms
Closing tables	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.19 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.10 ms
Updating status	0.06 ms
Reset for next command	0.01 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()	JROOT/libraries/joomla/database/driver/mysqli.php:445
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
11	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_gsd/tables/config.php:26
10	GSDTableConfig->__construct()	JROOT/libraries/src/Table/Table.php:312
9	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_gsd/GSD/Helper.php:407
8	GSD\Helper::getParams()	JROOT/plugins/system/gsd/gsd.php:61
7	plgSystemGSD->__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: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.74 ms Son sorgudan sonra: 1.06 ms Sorgu belleği: 0.005 MB belleği şu sorgudan önce: 6.334 MB Dönen satır: 1

SELECT *

  FROM frm_gsd_config

  WHERE `name` = 'config'

Açıkla

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

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_gsd/GSD/Helper.php:408
8	GSD\Helper::getParams()	JROOT/plugins/system/gsd/gsd.php:61
7	plgSystemGSD->__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: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.71 ms Son sorgudan sonra: 109.37 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 11.760 MB Dönen satır: 7

select id, title, alias 
  from frm_jumi 
  where published = 1

Açıkla

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

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1811
12	JDatabaseDriver->loadRowList()	JROOT/plugins/system/jumirouter/jumirouter.php:57
11	parseJumiRouter()	Aşağıdaki satırda bulunan çağrı gibi.
10	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
9	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:593
8	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:570
7	Joomla\CMS\Router\Router->_processParseRules()	JROOT/libraries/src/Router/Router.php:216
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: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: 2.38 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 11.883 MB

UPDATE `frm_extensions`

  SET `params` = '{\"mediaversion\":\"afff8f1c161a0e634cfaf6431c354ab6\"}'

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

Açıkla

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

Profil

Status	Duration
Starting	0.10 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.27 ms
Updating	0.09 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Waiting for query cache lock	0.01 ms
Unlocking tables	0.02 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.07 ms
Updating status	0.05 ms
Reset for next command	0.01 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/djjquerymonster/djjquerymonster.php:54
8	plgSystemDJjQueryMonster->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: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.68 ms Son sorgudan sonra: 4.69 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 12.131 MB Dönen satır: 6

SELECT s.*

  FROM frm_template_styles as s

  WHERE s.client_id = 0

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	5

Profil

Status	Duration
Starting	0.10 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.04 ms
Reset for next command	0.01 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/plugins/system/advancedtemplates/src/Document.php:193
12	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyles()	JROOT/plugins/system/advancedtemplates/src/Document.php:121
11	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:102
10	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:105
9	PlgSystemAdvancedTemplates->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/Plugin.php:94
8	RegularLabs\Library\Plugin->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: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.11 ms Sorgu belleği: 0.008 MB belleği şu sorgudan önce: 12.155 MB Dönen satır: 1

SELECT a.params

  FROM frm_advancedtemplates AS a

  WHERE a.styleid = 4

Açıkla

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

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedtemplates/src/Document.php:300
15	RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:207
14	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:270
13	RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments()	JROOT/plugins/system/advancedtemplates/src/Document.php:173
12	RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive()	JROOT/plugins/system/advancedtemplates/src/Document.php:127
11	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:102
10	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:105
9	PlgSystemAdvancedTemplates->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/Plugin.php:94
8	RegularLabs\Library\Plugin->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: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.51 ms Son sorgudan sonra: 2.29 ms Sorgu belleği: 0.008 MB belleği şu sorgudan önce: 12.279 MB Dönen satır: 1

SELECT a.params

  FROM frm_advancedtemplates AS a

  WHERE a.styleid = 7

Açıkla

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

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedtemplates/src/Document.php:300
15	RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:207
14	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:270
13	RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments()	JROOT/plugins/system/advancedtemplates/src/Document.php:173
12	RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive()	JROOT/plugins/system/advancedtemplates/src/Document.php:127
11	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:102
10	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:105
9	PlgSystemAdvancedTemplates->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/Plugin.php:94
8	RegularLabs\Library\Plugin->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: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.51 ms Son sorgudan sonra: 0.17 ms Sorgu belleği: 0.008 MB belleği şu sorgudan önce: 12.290 MB Dönen satır: 1

SELECT a.params

  FROM frm_advancedtemplates AS a

  WHERE a.styleid = 14

Açıkla

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

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedtemplates/src/Document.php:300
15	RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:207
14	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:270
13	RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments()	JROOT/plugins/system/advancedtemplates/src/Document.php:173
12	RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive()	JROOT/plugins/system/advancedtemplates/src/Document.php:127
11	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:102
10	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:105
9	PlgSystemAdvancedTemplates->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/Plugin.php:94
8	RegularLabs\Library\Plugin->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: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.48 ms Son sorgudan sonra: 0.10 ms Sorgu belleği: 0.008 MB belleği şu sorgudan önce: 12.297 MB Dönen satır: 1

SELECT a.params

  FROM frm_advancedtemplates AS a

  WHERE a.styleid = 15

Açıkla

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

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedtemplates/src/Document.php:300
15	RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:207
14	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:270
13	RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments()	JROOT/plugins/system/advancedtemplates/src/Document.php:173
12	RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive()	JROOT/plugins/system/advancedtemplates/src/Document.php:127
11	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:102
10	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:105
9	PlgSystemAdvancedTemplates->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/Plugin.php:94
8	RegularLabs\Library\Plugin->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: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.56 ms Son sorgudan sonra: 0.10 ms Sorgu belleği: 0.008 MB belleği şu sorgudan önce: 12.305 MB Dönen satır: 1

SELECT a.params

  FROM frm_advancedtemplates AS a

  WHERE a.styleid = 16

Açıkla

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

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/plugins/system/advancedtemplates/src/Document.php:300
15	RegularLabs\Plugin\System\AdvancedTemplates\Document::getAdvancedParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:207
14	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyleParams()	JROOT/plugins/system/advancedtemplates/src/Document.php:270
13	RegularLabs\Plugin\System\AdvancedTemplates\Document::stylePassesAssignments()	JROOT/plugins/system/advancedtemplates/src/Document.php:173
12	RegularLabs\Plugin\System\AdvancedTemplates\Document::isStyleActive()	JROOT/plugins/system/advancedtemplates/src/Document.php:127
11	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:102
10	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:105
9	PlgSystemAdvancedTemplates->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/Plugin.php:94
8	RegularLabs\Library\Plugin->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: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.41 ms Son sorgudan sonra: 12.44 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 13.087 MB Dönen satır: 6

SELECT id, home, template, s.params

  FROM frm_template_styles as s

  LEFT JOIN frm_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	5
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	u8289662_hbfirma.s.template,const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.16 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.17 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.27 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.05 ms
Reset for next command	0.01 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/plugins/system/ef4_jmframework/includes/libraries/template.php:2182
10	JMFTemplate::getTemplateStyleId()	JROOT/plugins/system/ef4_jmframework/includes/libraries/template.php:136
9	JMFTemplate->__construct()	JROOT/plugins/system/ef4_jmframework/ef4_jmframework.php:296
8	plgSystemEF4_JMFramework->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: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: 3.34 ms Son sorgudan sonra: 26.19 ms Sorgu belleği: 0.005 MB belleği şu sorgudan önce: 15.394 MB Dönen satır: 0

SELECT item_id 
  FROM frm_djcf_items_promotions 
  WHERE date_exp <= '2021-01-24 15:13:26' 
  AND updated=0 
  GROUP BY item_id

Açıkla

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

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
8	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djpayment.php:912
7	DJClassifiedsPayment::updatePromotions()	JROOT/components/com_djclassifieds/djclassifieds.php:108
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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.02 ms Son sorgudan sonra: 4.15 ms Sorgu belleği: 0.005 MB belleği şu sorgudan önce: 15.719 MB Dönen satır: 1

SELECT * 
  FROM frm_djcf_items 
  WHERE id=1265

Açıkla

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

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
9	JDatabaseDriver->loadObject()	JROOT/components/com_djclassifieds/controllers/item.php:57
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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.57 ms Son sorgudan sonra: 0.26 ms Sorgu belleği: 0.005 MB belleği şu sorgudan önce: 15.767 MB

UPDATE `frm_djcf_items` 
  SET display=display+1 
  WHERE id=1265

Açıkla

Şu sorgudaki olamayacakları AÇIKLA: UPDATE `frm_djcf_items` SET display=display+1 WHERE id=1265

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.04 ms
Updating	0.11 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Waiting for query cache lock	0.01 ms
Unlocking tables	0.02 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
9	JDatabase->query()	JROOT/components/com_djclassifieds/controllers/item.php:92
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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.33 ms Son sorgudan sonra: 3.77 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 15.944 MB Dönen satır: 1

Sorguları çoğalt: #67

SELECT i.*,c.name as c_name,c.alias as c_alias, c.access_view as c_access_view, c.access_item_view as c_access_item_view,  c.rev_group_id, r.name as r_name, u.name as username, u.email as u_email, iu.name as unit_name , t.id as t_id, t.name as t_name,t.params as t_params  
  FROM frm_djcf_categories c, frm_djcf_items i 
  LEFT JOIN frm_djcf_types t 
  ON t.id = i.type_id 
  LEFT JOIN frm_users u 
  ON u.id = i.user_id 
  LEFT JOIN frm_djcf_regions r 
  ON r.id = i.region_id 
  LEFT JOIN frm_djcf_items_units iu 
  ON iu.id = i.unit_id 
  WHERE c.id=i.cat_id 
  AND i.id = 1265 
  LIMIT 1

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows
1	SIMPLE	i	const	PRIMARY,cat_id	PRIMARY	4	const	1
1	SIMPLE	t	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	r	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	iu	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_djclassifieds/models/item.php:71
11	DjclassifiedsModelItem->getItem()	JROOT/components/com_djclassifieds/views/item/view.html.php:56
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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.52 ms Son sorgudan sonra: 0.09 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 15.999 MB Dönen satır: 0

Sorguları çoğalt: #68

SELECT c.* 
  FROM frm_djcf_items_categories ic, frm_djcf_categories c 
  WHERE c.id=ic.cat_id 
  AND ic.item_id = 1265  
  ORDER BY ic.item_id,ic.ordering

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.11 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.04 ms
Reset for next command	0.01 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/components/com_djclassifieds/models/item.php:78
11	DjclassifiedsModelItem->getItem()	JROOT/components/com_djclassifieds/views/item/view.html.php:56
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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.10 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.005 MB Dönen satır: 1

SELECT img.* 
  FROM frm_djcf_images img 
  WHERE img.item_id IN (1265) 
  AND img.type='item' 
  ORDER BY img.item_id, img.ordering

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	img	ref	item_id,type	item_id	4	const	1	Using where; Dosya sıralama kullanılıyor

Profil

Status	Duration
Starting	0.10 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 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.01 ms
Creating sort index	0.08 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.04 ms
Reset for next command	0.01 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_djclassifieds/lib/djimage.php:427
11	DJClassifiedsImage::getAdsImages()	JROOT/components/com_djclassifieds/views/item/view.html.php:71
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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.55 ms Son sorgudan sonra: 0.10 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.015 MB Dönen satır: 1

SELECT c.* 
  FROM frm_djcf_categories c 
  WHERE id='60' 
  LIMIT 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.11 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_djclassifieds/models/item.php:90
11	DjclassifiedsModelItem->getCategory()	JROOT/components/com_djclassifieds/views/item/view.html.php:73
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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: 2.75 ms Son sorgudan sonra: 0.10 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.025 MB Dönen satır: 0

Sorguları çoğalt: #70

SELECT f.*, v.value,v.value_date,v.value_date_to 
  FROM frm_djcf_fields f 
  LEFT JOIN frm_djcf_fields_xref fx 
  ON f.id=fx.field_id 
  LEFT JOIN (SELECT * 
  FROM frm_djcf_fields_values 
  WHERE item_id=1265) v 
  ON v.field_id=f.id 
  WHERE fx.cat_id IN (SELECT cat_id 
  FROM frm_djcf_items_categories 
  WHERE item_id=1265 UNION SELECT 60) 
  AND f.published=1 
  AND f.access=0 
  AND f.name!='price' 
  AND f.name!='contact' 
  ORDER BY fx.ordering, f.ordering

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	f	ref	name,published	published	4	const	7	Using where; Using temporary; Dosya sıralama kullanılıyor
1	PRIMARY	fx	ALL	NULL	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	57	Using where
1	PRIMARY	frm_djcf_fields_values	ref	field_id,item_id	item_id	4	const	1	Using where
3	DEPENDENT SUBQUERY	NULL	NULL	NULL	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
4	DEPENDENT UNION	NULL	NULL	NULL	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	NULL	No tables used
NULL	UNION RESULT	<union3,4>	ALL	NULL	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	NULL

Profil

Status	Duration
Starting	0.13 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.11 ms
Optimizing	0.03 ms
Statistics	0.14 ms
Preparing	0.03 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Optimizing	0.02 ms
Creating tmp table	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	1.28 ms
Creating sort index	0.08 ms
Removing tmp table	0.23 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Removing tmp table	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Removing tmp table	0.05 ms
Freeing items	0.10 ms
Updating status	0.04 ms
Reset for next command	0.01 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/components/com_djclassifieds/models/item.php:161
11	DjclassifiedsModelItem->getFields()	JROOT/components/com_djclassifieds/views/item/view.html.php:74
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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: 3.08 ms Son sorgudan sonra: 0.25 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.032 MB Dönen satır: 1

SELECT f.*, v.value,v.value_date,v.value_date_to 
  FROM frm_djcf_fields f 
  LEFT JOIN frm_djcf_fields_xref fx 
  ON f.id=fx.field_id 
  LEFT JOIN (SELECT * 
  FROM frm_djcf_fields_values 
  WHERE item_id=1265) v 
  ON v.field_id=f.id 
  WHERE f.source=1 
  AND f.published=1 
  AND f.access=0 
  AND f.name!='price' 
  GROUP BY f.id 
  ORDER BY fx.ordering, f.ordering

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	f	ref	name,published	published	4	const	7	Using where; Using temporary; Dosya sıralama kullanılıyor
1	SIMPLE	fx	ALL	NULL	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	57	Using where
1	SIMPLE	frm_djcf_fields_values	ref	field_id,item_id	item_id	4	const	1	Using where

Profil

Status	Duration
Starting	0.40 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.03 ms
Init	0.18 ms
Optimizing	0.06 ms
Statistics	0.26 ms
Preparing	0.09 ms
Creating tmp table	0.08 ms
Sorting result	0.04 ms
Executing	0.01 ms
Sending data	0.83 ms
Creating sort index	0.12 ms
Removing tmp table	0.21 ms
Creating sort index	0.03 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.17 ms
Updating status	0.49 ms
Reset for next command	0.07 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/components/com_djclassifieds/models/item.php:177
11	DjclassifiedsModelItem->geContactFields()	JROOT/components/com_djclassifieds/views/item/view.html.php:75
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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.03 ms Son sorgudan sonra: 0.22 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.043 MB Dönen satır: 0

SELECT s.plan_id 
  FROM frm_djcf_plans_subscr_items si, frm_djcf_plans_subscr s 
  WHERE si.subscr_id= s.id 
  AND si.item_id = 1265

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.25 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.13 ms
Updating status	0.38 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:1740
12	JDatabaseDriver->loadResult()	JROOT/components/com_djclassifieds/models/item.php:199
11	DjclassifiedsModelItem->getItemPayment()	JROOT/components/com_djclassifieds/views/item/view.html.php:76
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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: 0.11 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.049 MB Dönen satır: 1

SELECT COUNT(p.id) 
  FROM frm_djcf_payments p 
  WHERE p.price>0 
  AND  p.item_id = 1265 
  AND p.type=0

Açıkla

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

Profil

Status	Duration
Starting	0.26 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.02 ms
Preparing	0.04 ms
Executing	0.01 ms
Sending data	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.11 ms
Updating status	0.31 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:1740
12	JDatabaseDriver->loadResult()	JROOT/components/com_djclassifieds/models/item.php:210
11	DjclassifiedsModelItem->getItemPayment()	JROOT/components/com_djclassifieds/views/item/view.html.php:76
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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.18 ms Son sorgudan sonra: 0.18 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.055 MB Dönen satır: 0

SELECT f.* 
  FROM frm_djcf_fields_values_sale f 
  WHERE f.item_id =1265 
  ORDER BY f.id

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.16 ms
Checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.49 ms
Freeing items	0.12 ms
Updating status	0.25 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/components/com_djclassifieds/models/item.php:309
11	DjclassifiedsModelItem->getItemOptions()	JROOT/components/com_djclassifieds/views/item/view.html.php:77
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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.86 ms Son sorgudan sonra: 0.10 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.062 MB Dönen satır: 0

SELECT a.*, u.name as u_name 
  FROM frm_djcf_auctions a, frm_users u  
  WHERE a.user_id=u.id 
  AND a.item_id=1265 
  ORDER BY a.date DESC 
  LIMIT 3

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.19 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.16 ms
Updating status	0.31 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/components/com_djclassifieds/models/item.php:247
11	DjclassifiedsModelItem->getBids()	JROOT/components/com_djclassifieds/views/item/view.html.php:78
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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: 79.47 ms Son sorgudan sonra: 0.16 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.068 MB Dönen satır: 1

SELECT COUNT(i.id) 
  FROM frm_djcf_items i 
  WHERE i.published=1 
  AND i.date_exp > '2021-01-24 15:13:26' 
  AND i.user_id  = 866

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ref	user_id,published	user_id	4	const	3455	Using where

Profil

Status	Duration
Starting	0.19 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.22 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	78.25 ms
End of update loop	0.05 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.02 ms
Closing tables	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.20 ms
Updating status	0.09 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:1740
12	JDatabaseDriver->loadResult()	JROOT/components/com_djclassifieds/models/item.php:106
11	DjclassifiedsModelItem->getUserItemsCount()	JROOT/components/com_djclassifieds/views/item/view.html.php:80
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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: 9.35 ms Son sorgudan sonra: 0.44 ms Sorgu belleği: 0.007 MB belleği şu sorgudan önce: 16.074 MB Dönen satır: 62

SELECT c.* 
  FROM frm_djcf_categories c 
  WHERE c.published=1  
  AND c.access_view IN (1,1,5) 
  ORDER BY c.parent_id, c.ordering

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ref	published	published	4	const	61	Using where; Dosya sıralama kullanılıyor

Profil

Status	Duration
Starting	0.21 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.08 ms
Optimizing	0.04 ms
Statistics	0.09 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
Creating sort index	8.17 ms
End of update loop	0.04 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.02 ms
Closing tables	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.15 ms
Updating status	0.14 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/administrator/components/com_djclassifieds/lib/djcategory.php:499
12	DJClassifiedsCategory::getCategories()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:276
11	DJClassifiedsCategory::getParentPath()	JROOT/components/com_djclassifieds/views/item/view.html.php:92
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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: 87.88 ms Son sorgudan sonra: 1.58 ms Sorgu belleği: 0.007 MB belleği şu sorgudan önce: 16.801 MB Dönen satır: 61

SELECT i.cat_id, count(i.id) as items_count 
  FROM frm_djcf_items i 
  WHERE i.published=1 
  AND i.blocked=0 
  AND i.date_exp > '2021-01-24 15:00:00'  
  GROUP BY i.cat_id

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ref	published,blocked	published	4	const	3515	Using where; Using temporary; Dosya sıralama kullanılıyor

Profil

Status	Duration
Starting	0.22 ms
Checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.07 ms
Optimizing	0.04 ms
Statistics	0.18 ms
Preparing	0.05 ms
Creating tmp table	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	86.45 ms
Creating sort index	0.11 ms
Removing tmp table	0.07 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.12 ms
Updating status	0.51 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()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:552
13	DJClassifiedsCategory::getItemsCount()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:511
12	DJClassifiedsCategory::getCategories()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:276
11	DJClassifiedsCategory::getParentPath()	JROOT/components/com_djclassifieds/views/item/view.html.php:92
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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.82 ms Son sorgudan sonra: 0.28 ms Sorgu belleği: 0.008 MB belleği şu sorgudan önce: 16.849 MB Dönen satır: 0

SELECT ic.cat_id, count(ic.item_id) as items_count 
  FROM frm_djcf_items_categories ic, frm_djcf_items i 
  WHERE ic.item_id=i.id 
  AND i.published=1 
  AND i.blocked=0 
  AND i.date_exp > '2021-01-24 15:00:00' 
  GROUP BY ic.cat_id

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.18 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.05 ms
Optimizing	0.03 ms
Statistics	0.12 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.02 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.07 ms
Updating status	1.49 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/administrator/components/com_djclassifieds/lib/djcategory.php:518
12	DJClassifiedsCategory::getCategories()	JROOT/administrator/components/com_djclassifieds/lib/djcategory.php:276
11	DJClassifiedsCategory::getParentPath()	JROOT/components/com_djclassifieds/views/item/view.html.php:92
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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: 12.87 ms Son sorgudan sonra: 2.85 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.898 MB Dönen satır: 1136

Sorguları çoğalt: #71

SELECT r.* 
  FROM frm_djcf_regions r 
  WHERE published=1 
  ORDER BY r.parent_id

Açıkla

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

Profil

Status	Duration
Starting	0.19 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.11 ms
Preparing	0.05 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	11.69 ms
End of update loop	0.05 ms
Query end	0.03 ms
Commit	0.01 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.02 ms
Freeing items	0.18 ms
Updating status	0.90 ms
Reset for next command	0.03 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/components/com_djclassifieds/models/item.php:188
11	DjclassifiedsModelItem->getRegions()	JROOT/components/com_djclassifieds/views/item/view.html.php:137
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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.40 ms Son sorgudan sonra: 4.93 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 18.471 MB Dönen satır: 0

SELECT * 
  FROM frm_djcf_images 
  WHERE item_id = 866 
  AND type='profile' 
  LIMIT 1

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	frm_djcf_images	ref	item_id,type	item_id	4	const	1	Using where

Profil

Status	Duration
Starting	0.30 ms
Checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.08 ms
Optimizing	0.06 ms
Statistics	0.26 ms
Preparing	0.06 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.03 ms
Commit	0.01 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.09 ms
Updating status	0.27 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:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_djclassifieds/models/item.php:221
11	DjclassifiedsModelItem->getProfile()	JROOT/components/com_djclassifieds/views/item/view.html.php:173
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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: 2.40 ms Son sorgudan sonra: 0.11 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 18.478 MB Dönen satır: 0

SELECT f.*, v.value, v.value_date 
  FROM frm_djcf_fields f 
  LEFT JOIN (SELECT * 
  FROM frm_djcf_fields_values_profile 
  WHERE user_id=866) v 
  ON v.field_id=f.id 
  WHERE f.published=1 
  AND f.source=2 
  AND f.in_item=1 
  AND f.access=0 
  ORDER BY f.ordering

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	f	ref	published	published	4	const	7	Using where; Using temporary; Dosya sıralama kullanılıyor
1	SIMPLE	frm_djcf_fields_values_profile	ALL	NULL	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	13	Using where

Profil

Status	Duration
Starting	0.19 ms
Checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.13 ms
Optimizing	0.05 ms
Statistics	0.07 ms
Preparing	0.06 ms
Creating tmp table	0.08 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.76 ms
Creating sort index	0.12 ms
Removing tmp table	0.19 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Removing tmp table	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.13 ms
Updating status	0.46 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/components/com_djclassifieds/models/item.php:228
11	DjclassifiedsModelItem->getProfile()	JROOT/components/com_djclassifieds/views/item/view.html.php:173
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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.15 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 18.484 MB Dönen satır: 0

SELECT * 
  FROM frm_djcf_profiles 
  WHERE user_id = 866  
  LIMIT 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.14 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.01 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.02 ms
Freeing items	0.10 ms
Updating status	0.38 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:1662
12	JDatabaseDriver->loadObject()	JROOT/components/com_djclassifieds/models/item.php:232
11	DjclassifiedsModelItem->getProfile()	JROOT/components/com_djclassifieds/views/item/view.html.php:173
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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.99 ms Son sorgudan sonra: 0.24 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 18.490 MB Dönen satır: 0

SELECT f.* 
  FROM frm_djcf_fields f 
  WHERE f.published=1 
  AND f.source=3 
  ORDER BY f.ordering

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	f	ref	published	published	4	const	7	Using where; Dosya sıralama kullanılıyor

Profil

Status	Duration
Starting	0.14 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
Init	0.06 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.04 ms
Creating sort index	0.13 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.09 ms
Updating status	0.79 ms
Reset for next command	0.03 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/components/com_djclassifieds/models/item.php:278
11	DjclassifiedsModelItem->getCustomAskSellerFields()	JROOT/components/com_djclassifieds/views/item/view.html.php:176
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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: 11.45 ms Son sorgudan sonra: 1.39 ms Sorgu belleği: 0.007 MB belleği şu sorgudan önce: 18.526 MB Dönen satır: 1136

SELECT r.* 
  FROM frm_djcf_regions r 
  ORDER BY r.parent_id, r.name COLLATE utf8_polish_ci

Açıkla

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

Profil

Status	Duration
Starting	0.14 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 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	10.70 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.10 ms
Updating status	0.06 ms
Reset for next command	0.01 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()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:433
13	DJClassifiedsRegion::getRegions()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:338
12	DJClassifiedsRegion::getSEOParentPath()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:87
11	DJClassifiedsSEO::getItemRoute()	JROOT/components/com_djclassifieds/views/item/view.html.php:252
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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: 76.52 ms Son sorgudan sonra: 2.94 ms Sorgu belleği: 0.007 MB belleği şu sorgudan önce: 20.081 MB Dönen satır: 762

SELECT i.region_id, count(i.id) as items_count 
  FROM frm_djcf_items i 
  WHERE i.published=1 
  AND i.blocked=0 
  AND i.date_exp > '2021-01-24 15:13:27' 
  GROUP BY i.region_id

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	ref	published,blocked	published	4	const	3515	Using where; Using temporary; Dosya sıralama kullanılıyor

Profil

Status	Duration
Starting	0.24 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.07 ms
Optimizing	0.07 ms
Statistics	0.15 ms
Preparing	0.05 ms
Creating tmp table	0.04 ms
Sorting result	0.04 ms
Executing	0.01 ms
Sending data	74.57 ms
Creating sort index	0.59 ms
Removing tmp table	0.06 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.09 ms
Updating status	0.09 ms
Reset for next command	0.01 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()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:438
13	DJClassifiedsRegion::getRegions()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:338
12	DJClassifiedsRegion::getSEOParentPath()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:87
11	DJClassifiedsSEO::getItemRoute()	JROOT/components/com_djclassifieds/views/item/view.html.php:252
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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: 7.47 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 20.173 MB Dönen satır: 1

SELECT a.id, a.alias, a.catid, c.alias as c_alias 
  FROM frm_content a 
  LEFT JOIN frm_categories c 
  ON c.id=a.catid 
  WHERE a.state=1 
  AND a.id=87

Açıkla

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

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:499
11	DJClassifiedsSEO::getArticleLink()	JROOT/components/com_djclassifieds/views/item/view.html.php:308
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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.19 ms Son sorgudan sonra: 2.21 ms Sorgu belleği: 0.011 MB belleği şu sorgudan önce: 20.232 MB Dönen satır: 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 `frm_categories` AS `s`

  INNER JOIN `frm_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) 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

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	10	Using where; Dosya sıralama kullanılıyor

Profil

Status	Duration
Starting	0.19 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.06 ms
Optimizing	0.04 ms
Statistics	0.22 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.06 ms
Creating sort index	0.11 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.08 ms
Updating status	0.07 ms
Reset for next command	0.01 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
21	ContentRouter->getCategorySegment()	Aşağıdaki satırda bulunan çağrı gibi.
20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:508
11	DJClassifiedsSEO::getArticleLink()	JROOT/components/com_djclassifieds/views/item/view.html.php:308
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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: 2.43 ms Son sorgudan sonra: 2.93 ms Sorgu belleği: 0.009 MB belleği şu sorgudan önce: 20.394 MB Dönen satır: 0

select distinct id 
  from frm_djrevs_reviews 
  where recalculate = 1

Açıkla

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

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/components/com_djreviews/lib/api.php:475
16	DJReviewsAPI::recalculate()	JROOT/components/com_djreviews/lib/api.php:115
15	DJReviewsAPI->__construct()	JROOT/components/com_djreviews/lib/api.php:148
14	DJReviewsAPI::getInstance()	JROOT/plugins/djclassifieds/djreviews/djreviews.php:82
13	plgDjclassifiedsDJReviews->onAfterDJClassifiedsDisplayTitle()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_djclassifieds/views/item/view.html.php:335
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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.02 ms Son sorgudan sonra: 0.13 ms Sorgu belleği: 0.009 MB belleği şu sorgudan önce: 20.403 MB Dönen satır: 0

select distinct object_id 
  from frm_djrevs_reviews 
  where recalculate = 2

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	frm_djrevs_reviews	ALL	NULL	HİÇ BİR DİZİNLEME ANAHTARI KULLANILAMIYOR	NULL	NULL	12	Using where; Using temporary

Profil

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

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
17	JDatabaseDriver->loadColumn()	JROOT/components/com_djreviews/lib/api.php:494
16	DJReviewsAPI::recalculate()	JROOT/components/com_djreviews/lib/api.php:115
15	DJReviewsAPI->__construct()	JROOT/components/com_djreviews/lib/api.php:148
14	DJReviewsAPI::getInstance()	JROOT/plugins/djclassifieds/djreviews/djreviews.php:82
13	plgDjclassifiedsDJReviews->onAfterDJClassifiedsDisplayTitle()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_djclassifieds/views/item/view.html.php:335
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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: 43.82 ms Son sorgudan sonra: 0.15 ms Sorgu belleği: 0.008 MB belleği şu sorgudan önce: 20.412 MB

UPDATE frm_djrevs_objects 
  SET avg_rate=0 
  WHERE id NOT IN (SELECT DISTINCT object_id 
  FROM frm_djrevs_reviews)

Açıkla

Şu sorgudaki olamayacakları AÇIKLA: UPDATE frm_djrevs_objects SET avg_rate=0 WHERE id NOT IN (SELECT DISTINCT object_id FROM frm_djrevs_reviews)

Profil

Status	Duration
Starting	0.11 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.03 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.03 ms
Updating	42.61 ms
End of update loop	0.03 ms
Query end	0.02 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Waiting for query cache lock	0.01 ms
Unlocking tables	0.03 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.07 ms
Updating status	0.07 ms
Reset for next command	0.01 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
17	JDatabase->query()	JROOT/components/com_djreviews/lib/api.php:512
16	DJReviewsAPI::recalculate()	JROOT/components/com_djreviews/lib/api.php:115
15	DJReviewsAPI->__construct()	JROOT/components/com_djreviews/lib/api.php:148
14	DJReviewsAPI::getInstance()	JROOT/plugins/djclassifieds/djreviews/djreviews.php:82
13	plgDjclassifiedsDJReviews->onAfterDJClassifiedsDisplayTitle()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_djclassifieds/views/item/view.html.php:335
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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.12 ms Son sorgudan sonra: 1.74 ms Sorgu belleği: 0.008 MB belleği şu sorgudan önce: 20.428 MB Dönen satır: 1

SELECT *

  FROM frm_djrevs_objects

  WHERE entry_id=1265 
  AND object_type='com_djclassifieds.item' 
  AND rating_group_id=1

Açıkla

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	frm_djrevs_objects	const	idx_group_object_entry,idx_object,idx_entry	idx_group_object_entry	775	const,const,const	1

Profil

Status	Duration
Starting	0.25 ms
Checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.06 ms
Optimizing	0.04 ms
Statistics	0.14 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.02 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.10 ms
Updating status	1.44 ms
Reset for next command	0.03 ms

Yığın Çağır

#	Çağırıcı	Dosya ve satır sayısı
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/components/com_djreviews/lib/api.php:375
15	DJReviewsAPI->initialise()	JROOT/components/com_djreviews/lib/api.php:205
14	DJReviewsAPI->getRatingAvg()	JROOT/plugins/djclassifieds/djreviews/djreviews.php:86
13	plgDjclassifiedsDJReviews->onAfterDJClassifiedsDisplayTitle()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_djclassifieds/views/item/view.html.php:335
10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
6	require_once JROOT/components/com_djclassifieds/djclassifieds.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: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.94 ms Son sorgudan sonra: 1.58 ms Sorgu belleği: 0.009 MB belleği şu sorgudan önce: 20.480 MB Dönen satır: 1

Sorguları çoğalt: #56 #73

SELECT o.*, count(r.id) as r_count, count(rat.id) as rat_count, g.name as group_name, g.description as group_description

  FROM frm_djrevs_objects as o

  INNER JOIN frm_djrevs_rating_groups as g 
  ON g.id = o.rating_group_id

  LEFT JOIN frm_djrevs_reviews as r 
  ON r.object_id = o.id

  LEFT JOIN frm_djrevs_reviews as rat 
  ON rat.object_id = o.id

Ana Menü

En Popüler

Kategoriler

Duyurular

Kişisel Verilerin Korunması Kanunu

Kişisel Verilerin Korunması Kanunu

KVKK Nedir?

Kişisel Verilerin Korunması Kanunu (KVKK) 24.03.2016 'da Türkiye Büyük Millet Meclisi'nde kabul edilmiş ve 07.04.2016 tarihli ve 29677 sayılı Resmi Gazete'de yayınlanarak yürürlüğe girmiştir.

Web Sitesi Hakkında Her şeyi Bilmek İçin En İyi Online Araçlar

Web Sitesi Hakkında Her şeyi Bilmek İçin En İyi Online Araçlar

PDF Belgelerini Web Sayfalarına Gömmenin Daha İyi Bir Yolu

PDF Belgelerini Web Sayfalarına Gömmenin Daha İyi Bir Yolu

Özel Reklamlar

Helin Eczanesi

PROOF OF HEAVEN

Düzen

İçerik

Diğer Sayfalar

Özel Sayfalar

Medya Araçları

İlanlar

Osmaniye Havaş

Firma Hakkinda

Servis Hareket Yerleri

Servis Hareket Yerleri

Yolculuk Süresi

Bilet Fiyatı

Adresi,Haritadaki Yeri

Puan

İletİşİm Bİlgilerİ

Tüm İlanlar,Kişisel Verileri Koruma Kanunu

Bİlgİlendİrme

Joomla Hata Ayıklama Konsolu

Oturum

Profil Bilgisi

Süre

Bellek

Bellek Kullanımı

Veritabanı Sorguları

80 Sorgu Kaydedildi 419.75 ms

18 çoğaltma bulundu!