İlgili Aramalar:

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

Süre

Bellek

96 Sorgu Kaydedildi 1522.05 ms

1. Sorgu Süresi: 0.63 ms Sorgu belleği: 0.007 MB belleği şu sorgudan önce: 3.898 MB Dönen satır: 0

   SELECT `data`
   
     FROM `frm_session`
   
     WHERE `session_id` = X'3934356163636565313534306232613234323131333530333463386664353838'

   Açıkla

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

   Profil

   Status	Duration
   Starting	0.11 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.02 ms
   Optimizing	0.01 ms
   Statistics	0.05 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.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ı
   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

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

   ---

2. Sorgu Süresi: 0.62 ms Son sorgudan sonra: 2.11 ms Sorgu belleği: 0.004 MB belleği şu sorgudan önce: 4.000 MB Dönen satır: 0

   SELECT `session_id`
   
     FROM `frm_session`
   
     WHERE `session_id` = X'3934356163636565313534306232613234323131333530333463386664353838' 
     LIMIT 1

   Açıkla

   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

   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.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.03 ms
   Closing tables	0.01 ms
   Starting cleanup	0.02 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ı
   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

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

   ---

3. Sorgu Süresi: 0.64 ms Son sorgudan sonra: 0.17 ms Sorgu belleği: 0.004 MB belleği şu sorgudan önce: 4.005 MB

   INSERT INTO `frm_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3934356163636565313534306232613234323131333530333463386664353838', 1, 1611490201, 0, '', 0)

   Açıkla

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

   Profil

   Status	Duration
   Starting	0.10 ms
   Checking permissions	0.03 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.02 ms
   Update	0.11 ms
   Waiting for query cache lock	0.02 ms
   Update	0.01 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.03 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ı
   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.]

   ---

4. Sorgu Süresi: 0.58 ms Son sorgudan sonra: 8.68 ms Sorgu belleği: 0.005 MB belleği şu sorgudan önce: 4.634 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.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.02 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Sending data	0.04 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.03 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.]

   ---

5. Sorgu Süresi: 0.71 ms Son sorgudan sonra: 0.14 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.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.02 ms
   Init	0.02 ms
   Optimizing	0.03 ms
   Statistics	0.09 ms
   Preparing	0.01 ms
   Unlocking tables	0.01 ms
   Preparing	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
   Unlocking tables	0.01 ms
   Closing tables	0.01 ms
   Starting cleanup	0.02 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ı
   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.]

   ---

6. Sorgu Süresi: 1.24 ms Son sorgudan sonra: 20.15 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.12 ms
   Checking permissions	0.03 ms
   Closing tables	0.01 ms
   Opening tables	0.32 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Filling schema table	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   Checking permissions	0.06 ms
   Closing tables	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
   Removing tmp table	0.10 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.04 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.]

   ---

7. Sorgu Süresi: 0.94 ms Son sorgudan sonra: 0.73 ms Sorgu belleği: 0.005 MB belleği şu sorgudan önce: 6.333 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.10 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.02 ms
   Optimizing	0.01 ms
   Statistics	0.05 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.05 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ı
   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.]

   ---

8. Sorgu Süresi: 1.08 ms Son sorgudan sonra: 150.12 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 11.759 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.18 ms
   Checking permissions	0.02 ms
   Opening tables	0.03 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   Table lock	0.02 ms
   Init	0.04 ms
   Optimizing	0.03 ms
   Statistics	0.03 ms
   Preparing	0.04 ms
   Executing	0.01 ms
   Sending data	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.03 ms
   Starting cleanup	0.02 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ı
   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.]

   ---

9. Sorgu Süresi: 0.86 ms Son sorgudan sonra: 2.52 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 11.882 MB

   UPDATE `frm_extensions`
   
     SET `params` = '{\"mediaversion\":\"97b0728cfcccc77a9e14d51b14526cf2\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Açıkla

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

   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 for update	0.22 ms
   Updating	0.08 ms
   End of update loop	0.01 ms
   Waiting for query cache lock	0.01 ms
   End of update loop	0.03 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ı
   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.]

   ---

10. Sorgu Süresi: 1.19 ms Son sorgudan sonra: 5.18 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.15 ms
    Checking permissions	0.06 ms
    Opening tables	0.20 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.02 ms
    Init	0.06 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.10 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.03 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.03 ms
    Freeing items	0.11 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ı
    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.]

    ---

11. Sorgu Süresi: 0.79 ms Son sorgudan sonra: 0.10 ms Sorgu belleği: 0.008 MB belleği şu sorgudan önce: 12.154 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.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.08 ms
    Preparing	0.01 ms
    Unlocking tables	0.02 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.02 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.10 ms
    Updating status	0.07 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: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.]

    ---

12. Sorgu Süresi: 0.76 ms Son sorgudan sonra: 2.34 ms Sorgu belleği: 0.008 MB belleği şu sorgudan önce: 12.278 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.15 ms
    Checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.01 ms
    Unlocking tables	0.04 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.07 ms
    Updating status	0.08 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.]

    ---

13. Sorgu Süresi: 0.97 ms Son sorgudan sonra: 0.12 ms Sorgu belleği: 0.008 MB belleği şu sorgudan önce: 12.289 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.17 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.09 ms
    Table lock	0.02 ms
    Init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.15 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.04 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.06 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ı
    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.]

    ---

14. Sorgu Süresi: 0.66 ms Son sorgudan sonra: 0.12 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.16 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.02 ms
    Table lock	0.02 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.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ı
    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.]

    ---

15. Sorgu Süresi: 0.52 ms Son sorgudan sonra: 0.13 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.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.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.07 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ı
    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.]

    ---

16. Sorgu Süresi: 1.24 ms Son sorgudan sonra: 13.00 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.20 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.04 ms
    Statistics	0.15 ms
    Preparing	0.06 ms
    Executing	0.01 ms
    Sending data	0.22 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.04 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.]

    ---

17. Sorgu Süresi: 3.44 ms Son sorgudan sonra: 59.36 ms Sorgu belleği: 0.005 MB belleği şu sorgudan önce: 15.393 MB Dönen satır: 0

    SELECT item_id 
      FROM frm_djcf_items_promotions 
      WHERE date_exp <= '2021-01-24 15:10:01' 
      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.11 ms
    Checking permissions	0.02 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.02 ms
    Table lock	0.01 ms
    Init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.03 ms
    Creating tmp table	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	2.42 ms
    Creating sort index	0.25 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.07 ms
    Updating status	0.08 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.]

    ---

18. Sorgu Süresi: 2.31 ms Son sorgudan sonra: 10.89 ms Sorgu belleği: 0.005 MB belleği şu sorgudan önce: 15.718 MB Dönen satır: 1

    SELECT * 
      FROM frm_djcf_items 
      WHERE id=2484

    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.16 ms
    Checking permissions	0.02 ms
    Opening tables	0.06 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.02 ms
    Init	0.13 ms
    Optimizing	0.03 ms
    Statistics	0.12 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.04 ms
    Executing	0.01 ms
    Sending data	1.08 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.02 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.12 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/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.]

    ---

19. Sorgu Süresi: 2.38 ms Son sorgudan sonra: 0.55 ms Sorgu belleği: 0.005 MB belleği şu sorgudan önce: 15.776 MB

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

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.16 ms
    Checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.08 ms
    System lock	0.07 ms
    Table lock	0.01 ms
    Init for update	0.14 ms
    Updating	0.24 ms
    End of update loop	0.02 ms
    Waiting for query cache lock	0.01 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.03 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.09 ms
    Updating status	0.06 ms
    Reset for next command	0.02 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/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.]

    ---

20. Sorgu Süresi: 2.84 ms Son sorgudan sonra: 11.08 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 15.953 MB Dönen satır: 1
    Sorguları çoğalt: #83

    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 = 2484 
      LIMIT 1

    Açıkla

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    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.30 ms
    Checking permissions	0.02 ms
    Opening tables	0.11 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    Init	0.15 ms
    Optimizing	0.05 ms
    Statistics	0.47 ms
    Preparing	0.02 ms
    Unlocking tables	0.03 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.99 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.02 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.03 ms
    Starting cleanup	0.02 ms
    Freeing items	0.09 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: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.]

    ---

21. Sorgu Süresi: 78.65 ms Son sorgudan sonra: 0.22 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.016 MB Dönen satır: 0
    Sorguları çoğalt: #84

    SELECT c.* 
      FROM frm_djcf_items_categories ic, frm_djcf_categories c 
      WHERE c.id=ic.cat_id 
      AND ic.item_id = 2484  
      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.18 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.03 ms
    Init	0.05 ms
    Optimizing	0.04 ms
    Statistics	0.04 ms
    Preparing	0.23 ms
    Executing	0.09 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.15 ms
    Updating status	0.04 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: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.]

    ---

22. Sorgu Süresi: 9.24 ms Son sorgudan sonra: 0.13 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.022 MB Dönen satır: 1

    SELECT img.* 
      FROM frm_djcf_images img 
      WHERE img.item_id IN (2484) 
      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.20 ms
    Checking permissions	0.02 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.02 ms
    Table lock	0.03 ms
    Init	0.07 ms
    Optimizing	0.05 ms
    Statistics	0.22 ms
    Preparing	0.06 ms
    Sorting result	0.04 ms
    Executing	0.01 ms
    Sending data	0.02 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.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.07 ms
    Updating status	0.06 ms
    Reset for next command	0.02 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_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.]

    ---

23. Sorgu Süresi: 1.23 ms Son sorgudan sonra: 0.16 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.032 MB Dönen satır: 1

    SELECT c.* 
      FROM frm_djcf_categories c 
      WHERE id='16' 
      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.03 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.38 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.29 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.]

    ---

24. Sorgu Süresi: 2.34 ms Son sorgudan sonra: 0.13 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.081 MB Dönen satır: 0
    Sorguları çoğalt: #86

    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=2484) v 
      ON v.field_id=f.id 
      WHERE fx.cat_id IN (SELECT cat_id 
      FROM frm_djcf_items_categories 
      WHERE item_id=2484 UNION SELECT 16) 
      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.16 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.12 ms
    Optimizing	0.04 ms
    Statistics	0.11 ms
    Preparing	0.04 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.09 ms
    Creating sort index	0.03 ms
    Removing tmp table	0.08 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.03 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.07 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.]

    ---

25. Sorgu Süresi: 1.35 ms Son sorgudan sonra: 0.08 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.087 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=2484) 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.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	0.06 ms
    Optimizing	0.03 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Creating tmp table	0.04 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.42 ms
    Creating sort index	0.06 ms
    Removing tmp table	0.10 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
    Removing tmp table	0.02 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: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.]

    ---

26. Sorgu Süresi: 0.56 ms Son sorgudan sonra: 0.08 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.099 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 = 2484

    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.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.02 ms
    Init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Executing	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.07 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: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.]

    ---

27. Sorgu Süresi: 0.54 ms Son sorgudan sonra: 0.06 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.105 MB Dönen satır: 1

    SELECT COUNT(p.id) 
      FROM frm_djcf_payments p 
      WHERE p.price>0 
      AND  p.item_id = 2484 
      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.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.02 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.04 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.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: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.]

    ---

28. Sorgu Süresi: 19.97 ms Son sorgudan sonra: 0.12 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.111 MB Dönen satır: 0

    SELECT f.* 
      FROM frm_djcf_fields_values_sale f 
      WHERE f.item_id =2484 
      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.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.02 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	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.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: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.]

    ---

29. Sorgu Süresi: 0.74 ms Son sorgudan sonra: 0.12 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.117 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=2484 
      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.17 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.02 ms
    Init	0.04 ms
    Optimizing	0.03 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.04 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: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.]

    ---

30. Sorgu Süresi: 70.49 ms Son sorgudan sonra: 0.13 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.124 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:10:01' 
      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.10 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.07 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	55.29 ms
    End of update loop	0.02 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.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ı
    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.]

    ---

31. Sorgu Süresi: 20.23 ms Son sorgudan sonra: 8.12 ms Sorgu belleği: 0.007 MB belleği şu sorgudan önce: 16.130 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	1.84 ms
    Checking permissions	0.29 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.02 ms
    Init	0.05 ms
    Optimizing	0.32 ms
    Statistics	0.06 ms
    Preparing	0.04 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	5.68 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.02 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.08 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ı
    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.]

    ---

32. Sorgu Süresi: 127.85 ms Son sorgudan sonra: 1.11 ms Sorgu belleği: 0.007 MB belleği şu sorgudan önce: 16.857 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.17 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.08 ms
    Preparing	0.05 ms
    Creating tmp table	0.03 ms
    Sorting result	0.01 ms
    Executing	0.02 ms
    Sending data	116.87 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.02 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.02 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/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.]

    ---

33. Sorgu Süresi: 5.49 ms Son sorgudan sonra: 0.32 ms Sorgu belleği: 0.008 MB belleği şu sorgudan önce: 16.905 MB Dönen satır: 0
    Sorguları çoğalt: #68

    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.25 ms
    Checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.02 ms
    Init	0.04 ms
    Optimizing	0.04 ms
    Statistics	0.09 ms
    Preparing	0.02 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.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.11 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ı
    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.]

    ---

34. Sorgu Süresi: 12.85 ms Son sorgudan sonra: 3.10 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.946 MB Dönen satır: 1136
    Sorguları çoğalt: #87

    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.20 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.05 ms
    Optimizing	0.03 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	10.96 ms
    End of update loop	0.03 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.14 ms
    Updating status	0.08 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: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.]

    ---

35. Sorgu Süresi: 2.21 ms Son sorgudan sonra: 24.12 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 18.520 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.21 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.05 ms
    Optimizing	0.04 ms
    Statistics	0.16 ms
    Preparing	0.05 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
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.08 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ı
    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.]

    ---

36. Sorgu Süresi: 10.08 ms Son sorgudan sonra: 0.14 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 18.527 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.17 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.11 ms
    Optimizing	0.06 ms
    Statistics	0.06 ms
    Preparing	0.05 ms
    Creating tmp table	0.07 ms
    Sorting result	0.03 ms
    Executing	0.02 ms
    Sending data	0.61 ms
    Creating sort index	0.05 ms
    Removing tmp table	0.12 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
    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.08 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ı
    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.]

    ---

37. Sorgu Süresi: 1.15 ms Son sorgudan sonra: 0.27 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 18.533 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.31 ms
    Checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0