Doğuş Diyar Birlik Seyahat - Diyarbakır Merkez

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

85 Sorgu Kaydedildi 456.54 ms

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

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

   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.16 ms
   Checking permissions	0.01 ms
   Opening tables	0.04 ms
   After opening tables	0.02 ms
   System lock	0.03 ms
   Table lock	0.02 ms
   Init	0.04 ms
   Optimizing	0.02 ms
   Statistics	0.07 ms
   Preparing	0.02 ms
   Executing	0.03 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.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ı
   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.65 ms Son sorgudan sonra: 2.48 ms Sorgu belleği: 0.004 MB belleği şu sorgudan önce: 4.001 MB Dönen satır: 0

   SELECT `session_id`
   
     FROM `frm_session`
   
     WHERE `session_id` = X'3563393565393664346466316636636135633433646337356433616436306637' 
     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.04 ms
   Preparing	0.01 ms
   Executing	0.03 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.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.87 ms Son sorgudan sonra: 0.24 ms Sorgu belleği: 0.004 MB belleği şu sorgudan önce: 4.006 MB

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

   Açıkla

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

   Profil

   Status	Duration
   Starting	0.14 ms
   Checking permissions	0.02 ms
   Opening tables	0.02 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Init for update	0.03 ms
   Update	0.15 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.05 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.03 ms
   Starting cleanup	0.03 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ı
   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.83 ms Son sorgudan sonra: 10.00 ms Sorgu belleği: 0.005 MB belleği şu sorgudan önce: 4.636 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.17 ms
   Checking permissions	0.01 ms
   Opening tables	0.03 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   Table lock	0.01 ms
   Init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.02 ms
   Preparing	0.03 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.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ı
   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: 1.08 ms Son sorgudan sonra: 0.19 ms Sorgu belleği: 0.005 MB belleği şu sorgudan önce: 4.648 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.15 ms
   Checking permissions	0.01 ms
   Opening tables	0.03 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Init	0.02 ms
   Optimizing	0.02 ms
   Statistics	0.11 ms
   Preparing	0.01 ms
   Unlocking tables	0.01 ms
   Preparing	0.02 ms
   Executing	0.02 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ı
   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: 2.32 ms Son sorgudan sonra: 21.04 ms Sorgu belleği: 0.007 MB belleği şu sorgudan önce: 6.307 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.19 ms
   Checking permissions	0.01 ms
   Closing tables	0.01 ms
   Opening tables	0.47 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   Table lock	0.02 ms
   Init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.03 ms
   Preparing	0.04 ms
   Executing	0.01 ms
   Filling schema table	0.02 ms
   Opening tables	0.03 ms
   After opening tables	0.09 ms
   Checking permissions	0.34 ms
   Closing tables	0.03 ms
   Executing	0.01 ms
   Sending data	0.06 ms
   End of update loop	0.02 ms
   Query end	0.03 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Removing tmp table	0.36 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.10 ms
   Updating status	0.07 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.83 ms Son sorgudan sonra: 0.88 ms Sorgu belleği: 0.005 MB belleği şu sorgudan önce: 6.335 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.15 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.04 ms
   Optimizing	0.02 ms
   Statistics	0.05 ms
   Preparing	0.03 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.02 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.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ı
   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: 0.81 ms Son sorgudan sonra: 1082.82 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 11.761 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.17 ms
   Checking permissions	0.01 ms
   Opening tables	0.04 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.02 ms
   Preparing	0.03 ms
   Executing	0.01 ms
   Sending data	0.10 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.06 ms
   Updating status	0.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: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.93 ms Son sorgudan sonra: 2.31 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 11.884 MB

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

   Açıkla

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

   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 for update	0.23 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.01 ms
   Query end	0.02 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Waiting for query cache lock	0.01 ms
   Unlocking tables	0.02 ms
   Closing tables	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.06 ms
   Updating status	0.05 ms
   Reset for next command	0.01 ms

   Yığın Çağır

   #	Çağırıcı	Dosya ve satır sayısı
   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: 0.67 ms Son sorgudan sonra: 4.88 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 12.133 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.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.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Executing	0.03 ms
    Sending data	0.07 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.05 ms
    Updating status	0.04 ms
    Reset for next command	0.01 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedtemplates/src/Document.php:193
    12	RegularLabs\Plugin\System\AdvancedTemplates\Document::getStyles()	JROOT/plugins/system/advancedtemplates/src/Document.php:121
    11	RegularLabs\Plugin\System\AdvancedTemplates\Document::getActiveStyle()	JROOT/plugins/system/advancedtemplates/src/Document.php:102
    10	RegularLabs\Plugin\System\AdvancedTemplates\Document::setTemplate()	JROOT/plugins/system/advancedtemplates/advancedtemplates.php:105
    9	PlgSystemAdvancedTemplates->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/Plugin.php:94
    8	RegularLabs\Library\Plugin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Sorgu Süresi: 0.50 ms Son sorgudan sonra: 0.11 ms Sorgu belleği: 0.008 MB belleği şu sorgudan önce: 12.156 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.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.05 ms
    Updating status	0.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.]

    ---

12. Sorgu Süresi: 0.62 ms Son sorgudan sonra: 2.12 ms Sorgu belleği: 0.008 MB belleği şu sorgudan önce: 12.343 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.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.02 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.02 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ı
    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.51 ms Son sorgudan sonra: 0.14 ms Sorgu belleği: 0.008 MB belleği şu sorgudan önce: 12.353 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.09 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.03 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.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ı
    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.50 ms Son sorgudan sonra: 0.11 ms Sorgu belleği: 0.008 MB belleği şu sorgudan önce: 12.361 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.10 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.05 ms
    Updating status	0.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.]

    ---

15. Sorgu Süresi: 0.48 ms Son sorgudan sonra: 0.12 ms Sorgu belleği: 0.008 MB belleği şu sorgudan önce: 12.369 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.08 ms
    Checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.05 ms
    Updating status	0.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.80 ms Son sorgudan sonra: 17.38 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 13.089 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.24 ms
    Checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.02 ms
    Init	0.05 ms
    Optimizing	0.06 ms
    Statistics	0.21 ms
    Preparing	0.06 ms
    Executing	0.01 ms
    Sending data	0.30 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.09 ms
    Updating status	0.10 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: 7.52 ms Son sorgudan sonra: 39.87 ms Sorgu belleği: 0.005 MB belleği şu sorgudan önce: 15.395 MB Dönen satır: 0

    SELECT item_id 
      FROM frm_djcf_items_promotions 
      WHERE date_exp <= '2021-01-24 15:12:23' 
      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.24 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.03 ms
    Init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.08 ms
    Preparing	0.04 ms
    Creating tmp table	0.04 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	5.00 ms
    Creating sort index	1.32 ms
    Removing tmp table	0.03 ms
    Creating sort index	0.02 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.02 ms
    Freeing items	0.12 ms
    Updating status	0.11 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: 1.59 ms Son sorgudan sonra: 7.58 ms Sorgu belleği: 0.005 MB belleği şu sorgudan önce: 15.720 MB Dönen satır: 1

    SELECT * 
      FROM frm_djcf_items 
      WHERE id=1827

    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.25 ms
    Checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    Init	0.08 ms
    Optimizing	0.04 ms
    Statistics	0.10 ms
    Preparing	0.01 ms
    Unlocking tables	0.02 ms
    Preparing	0.03 ms
    Executing	0.02 ms
    Sending data	0.42 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.10 ms
    Updating status	0.05 ms
    Reset for next command	0.01 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    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: 0.90 ms Son sorgudan sonra: 0.43 ms Sorgu belleği: 0.005 MB belleği şu sorgudan önce: 15.762 MB

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

    Açıkla

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

    Profil

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

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    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: 1.65 ms Son sorgudan sonra: 3.67 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 15.939 MB Dönen satır: 1
    Sorguları çoğalt: #72

    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 = 1827 
      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.25 ms
    Checking permissions	0.02 ms
    Opening tables	0.07 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.02 ms
    Init	0.09 ms
    Optimizing	0.05 ms
    Statistics	0.29 ms
    Preparing	0.02 ms
    Unlocking tables	0.03 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.36 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.05 ms
    Starting cleanup	0.02 ms
    Freeing items	0.10 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ı
    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: 4.46 ms Son sorgudan sonra: 0.19 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 15.986 MB Dönen satır: 0
    Sorguları çoğalt: #73

    SELECT c.* 
      FROM frm_djcf_items_categories ic, frm_djcf_categories c 
      WHERE c.id=ic.cat_id 
      AND ic.item_id = 1827  
      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.13 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.01 ms
    Init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Executing	0.04 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.02 ms
    Freeing items	0.11 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: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: 1.32 ms Son sorgudan sonra: 0.22 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 15.992 MB Dönen satır: 1

    SELECT img.* 
      FROM frm_djcf_images img 
      WHERE img.item_id IN (1827) 
      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.26 ms
    Checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.03 ms
    System lock	0.01 ms
    Table lock	0.02 ms
    Init	0.06 ms
    Optimizing	0.04 ms
    Statistics	0.18 ms
    Preparing	0.05 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.10 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.10 ms
    Updating status	0.10 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: 0.89 ms Son sorgudan sonra: 0.21 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.003 MB Dönen satır: 1

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

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    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: 3.50 ms Son sorgudan sonra: 0.17 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.015 MB Dönen satır: 0
    Sorguları çoğalt: #75

    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=1827) v 
      ON v.field_id=f.id 
      WHERE fx.cat_id IN (SELECT cat_id 
      FROM frm_djcf_items_categories 
      WHERE item_id=1827 UNION SELECT 63) 
      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.22 ms
    Checking permissions	0.02 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.02 ms
    Init	0.17 ms
    Optimizing	0.09 ms
    Statistics	0.14 ms
    Preparing	0.06 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Optimizing	0.03 ms
    Creating tmp table	0.08 ms
    Sorting result	0.04 ms
    Executing	0.01 ms
    Sending data	1.58 ms
    Creating sort index	0.06 ms
    Removing tmp table	0.14 ms
    Creating sort index	0.02 ms
    End of update loop	0.02 ms
    Removing tmp table	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.02 ms
    Closing tables	0.01 ms
    Removing tmp table	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.03 ms
    Starting cleanup	0.02 ms
    Freeing items	0.02 ms
    Removing tmp table	0.10 ms
    Freeing items	0.12 ms
    Updating status	0.10 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: 2.28 ms Son sorgudan sonra: 0.23 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.021 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=1827) 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.23 ms
    Checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.02 ms
    Init	0.15 ms
    Optimizing	0.06 ms
    Statistics	0.13 ms
    Preparing	0.07 ms
    Creating tmp table	0.08 ms
    Sorting result	0.06 ms
    Executing	0.02 ms
    Sending data	0.68 ms
    Creating sort index	0.10 ms
    Removing tmp table	0.18 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.07 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.70 ms Son sorgudan sonra: 0.20 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.033 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 = 1827

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.14 ms
    Checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.02 ms
    Init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Executing	0.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.02 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.08 ms
    Updating status	0.05 ms
    Reset for next command	0.01 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    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.80 ms Son sorgudan sonra: 0.10 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.039 MB Dönen satır: 1

    SELECT COUNT(p.id) 
      FROM frm_djcf_payments p 
      WHERE p.price>0 
      AND  p.item_id = 1827 
      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.15 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.04 ms
    Optimizing	0.03 ms
    Statistics	0.03 ms
    Preparing	0.04 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.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.11 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: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: 0.72 ms Son sorgudan sonra: 0.17 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.045 MB Dönen satır: 0

    SELECT f.* 
      FROM frm_djcf_fields_values_sale f 
      WHERE f.item_id =1827 
      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.15 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.04 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.09 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: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.77 ms Son sorgudan sonra: 0.10 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.051 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=1827 
      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.15 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.01 ms
    Init	0.05 ms
    Optimizing	0.03 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.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.02 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_djclassifieds/models/item.php:247
    11	DjclassifiedsModelItem->getBids()	JROOT/components/com_djclassifieds/views/item/view.html.php:78
    10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
    8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
    6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

30. Sorgu Süresi: 78.35 ms Son sorgudan sonra: 0.18 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.058 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:12:23' 
      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.14 ms
    Checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.02 ms
    Table lock	0.01 ms
    Init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.10 ms
    Preparing	0.05 ms
    Executing	0.01 ms
    Sending data	77.37 ms
    End of update loop	0.06 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.02 ms
    Closing tables	0.03 ms
    Starting cleanup	0.02 ms
    Freeing items	0.13 ms
    Updating status	0.11 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: 7.61 ms Son sorgudan sonra: 0.39 ms Sorgu belleği: 0.007 MB belleği şu sorgudan önce: 16.064 MB Dönen satır: 62

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

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.15 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.07 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.03 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    Creating sort index	6.06 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.10 ms
    Updating status	0.05 ms
    Reset for next command	0.01 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/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: 87.37 ms Son sorgudan sonra: 1.40 ms Sorgu belleği: 0.007 MB belleği şu sorgudan önce: 16.791 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.46 ms
    Checking permissions	0.04 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.02 ms
    Init	0.06 ms
    Optimizing	0.06 ms
    Statistics	0.14 ms
    Preparing	0.05 ms
    Creating tmp table	0.09 ms
    Sorting result	0.05 ms
    Executing	0.02 ms
    Sending data	85.49 ms
    Creating sort index	0.13 ms
    Removing tmp table	0.06 ms
    Creating sort index	0.02 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.02 ms
    Freeing items	0.14 ms
    Updating status	0.10 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: 0.89 ms Son sorgudan sonra: 0.24 ms Sorgu belleği: 0.008 MB belleği şu sorgudan önce: 16.839 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.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.02 ms
    Init	0.06 ms
    Optimizing	0.04 ms
    Statistics	0.13 ms
    Preparing	0.02 ms
    Executing	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.08 ms
    Updating status	0.05 ms
    Reset for next command	0.01 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    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: 10.78 ms Son sorgudan sonra: 2.50 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 16.887 MB Dönen satır: 1136
    Sorguları çoğalt: #76

    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.23 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.05 ms
    Optimizing	0.04 ms
    Statistics	0.11 ms
    Preparing	0.03 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	9.50 ms
    End of update loop	0.05 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.03 ms
    Closing tables	0.02 ms
    Starting cleanup	0.02 ms
    Freeing items	0.11 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ı
    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: 3.66 ms Son sorgudan sonra: 5.00 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 18.461 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.22 ms
    Checking permissions	0.02 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.02 ms
    Init	0.07 ms
    Optimizing	0.04 ms
    Statistics	0.19 ms
    Preparing	0.06 ms
    Executing	0.01 ms
    Sending data	0.05 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.03 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.10 ms
    Updating status	0.05 ms
    Reset for next command	0.01 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    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: 3.71 ms Son sorgudan sonra: 0.20 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 18.468 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.27 ms
    Checking permissions	0.02 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.06 ms
    Init	0.17 ms
    Optimizing	0.07 ms
    Statistics	0.13 ms
    Preparing	0.15 ms
    Creating tmp table	0.11 ms
    Sorting result	0.04 ms
    Executing	0.01 ms
    Sending data	1.41 ms
    Creating sort index	0.07 ms
    Removing tmp table	0.12 ms
    Creating sort index	0.02 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Removing tmp table	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.11 ms
    Updating status	0.53 ms
    Reset for next command	0.02 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_djclassifieds/models/item.php:228
    11	DjclassifiedsModelItem->getProfile()	JROOT/components/com_djclassifieds/views/item/view.html.php:173
    10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
    8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
    6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

37. Sorgu Süresi: 16.46 ms Son sorgudan sonra: 0.19 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 18.474 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	15.77 ms
    Checking permissions	0.03 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.02 ms
    Table lock	0.01 ms
    Init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.02 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.11 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ı
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/components/com_djclassifieds/models/item.php:232
    11	DjclassifiedsModelItem->getProfile()	JROOT/components/com_djclassifieds/views/item/view.html.php:173
    10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
    8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
    6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

38. Sorgu Süresi: 0.89 ms Son sorgudan sonra: 0.39 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 18.480 MB Dönen satır: 0

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

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.11 ms
    Checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.03 ms
    Init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.05 ms
    Sorting result	0.03 ms
    Executing	0.01 ms
    Sending data	0.05 ms
    Creating sort index	0.09 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.09 ms
    Updating status	0.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:278
    11	DjclassifiedsModelItem->getCustomAskSellerFields()	JROOT/components/com_djclassifieds/views/item/view.html.php:176
    10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
    8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
    6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

39. Sorgu Süresi: 12.44 ms Son sorgudan sonra: 201.34 ms Sorgu belleği: 0.007 MB belleği şu sorgudan önce: 18.516 MB Dönen satır: 1136

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

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.26 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.02 ms
    Init	0.06 ms
    Optimizing	0.03 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	11.37 ms
    End of update loop	0.04 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.09 ms
    Updating status	2.35 ms
    Reset for next command	0.02 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:433
    13	DJClassifiedsRegion::getRegions()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:338
    12	DJClassifiedsRegion::getSEOParentPath()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:87
    11	DJClassifiedsSEO::getItemRoute()	JROOT/components/com_djclassifieds/views/item/view.html.php:252
    10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
    8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
    6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

40. Sorgu Süresi: 92.55 ms Son sorgudan sonra: 3.20 ms Sorgu belleği: 0.007 MB belleği şu sorgudan önce: 20.070 MB Dönen satır: 762

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

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.21 ms
    Checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    Init	0.06 ms
    Optimizing	0.03 ms
    Statistics	0.11 ms
    Preparing	0.04 ms
    Creating tmp table	0.04 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	89.92 ms
    Creating sort index	0.73 ms
    Removing tmp table	0.14 ms
    Creating sort index	0.03 ms
    End of update loop	0.02 ms
    Query end	0.02 ms
    Commit	0.01 ms
    Closing tables	0.02 ms
    Unlocking tables	0.01 ms
    Closing tables	0.04 ms
    Starting cleanup	0.02 ms
    Freeing items	0.72 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ı
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:438
    13	DJClassifiedsRegion::getRegions()	JROOT/administrator/components/com_djclassifieds/lib/djregion.php:338
    12	DJClassifiedsRegion::getSEOParentPath()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:87
    11	DJClassifiedsSEO::getItemRoute()	JROOT/components/com_djclassifieds/views/item/view.html.php:252
    10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
    8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
    6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

41. Sorgu Süresi: 0.68 ms Son sorgudan sonra: 3.93 ms Sorgu belleği: 0.006 MB belleği şu sorgudan önce: 20.163 MB Dönen satır: 1

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

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.13 ms
    Checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.02 ms
    Table lock	0.01 ms
    Init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.10 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	1.48 ms
    Reset for next command	0.01 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:499
    11	DJClassifiedsSEO::getArticleLink()	JROOT/components/com_djclassifieds/views/item/view.html.php:308
    10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
    8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
    6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

42. Sorgu Süresi: 0.95 ms Son sorgudan sonra: 1.36 ms Sorgu belleği: 0.011 MB belleği şu sorgudan önce: 20.221 MB Dönen satır: 2

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `frm_categories` AS `s`
    
      INNER JOIN `frm_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 82
    
      ORDER BY c.lft

    Açıkla

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

    Profil

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

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    21	ContentRouter->getCategorySegment()	Aşağıdaki satırda bulunan çağrı gibi.
    20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    12	Joomla\CMS\Router\Route::_()	JROOT/administrator/components/com_djclassifieds/lib/djseo.php:508
    11	DJClassifiedsSEO::getArticleLink()	JROOT/components/com_djclassifieds/views/item/view.html.php:308
    10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
    8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
    6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

43. Sorgu Süresi: 0.65 ms Son sorgudan sonra: 2.16 ms Sorgu belleği: 0.009 MB belleği şu sorgudan önce: 20.384 MB Dönen satır: 0

    select distinct id 
      from frm_djrevs_reviews 
      where recalculate = 1

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.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.02 ms
    Init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.02 ms
    Sending data	0.07 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.08 ms
    Updating status	0.04 ms
    Reset for next command	0.02 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    17	JDatabaseDriver->loadColumn()	JROOT/components/com_djreviews/lib/api.php:475
    16	DJReviewsAPI::recalculate()	JROOT/components/com_djreviews/lib/api.php:115
    15	DJReviewsAPI->__construct()	JROOT/components/com_djreviews/lib/api.php:148
    14	DJReviewsAPI::getInstance()	JROOT/plugins/djclassifieds/djreviews/djreviews.php:82
    13	plgDjclassifiedsDJReviews->onAfterDJClassifiedsDisplayTitle()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_djclassifieds/views/item/view.html.php:335
    10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
    8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
    6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

44. Sorgu Süresi: 0.66 ms Son sorgudan sonra: 0.06 ms Sorgu belleği: 0.009 MB belleği şu sorgudan önce: 20.393 MB Dönen satır: 0

    select distinct object_id 
      from frm_djrevs_reviews 
      where recalculate = 2

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.08 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.02 ms
    Init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Creating tmp table	0.03 ms
    Executing	0.02 ms
    Sending data	0.05 ms
    Removing tmp table	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.08 ms
    Updating status	0.05 ms
    Reset for next command	0.01 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    17	JDatabaseDriver->loadColumn()	JROOT/components/com_djreviews/lib/api.php:494
    16	DJReviewsAPI::recalculate()	JROOT/components/com_djreviews/lib/api.php:115
    15	DJReviewsAPI->__construct()	JROOT/components/com_djreviews/lib/api.php:148
    14	DJReviewsAPI::getInstance()	JROOT/plugins/djclassifieds/djreviews/djreviews.php:82
    13	plgDjclassifiedsDJReviews->onAfterDJClassifiedsDisplayTitle()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_djclassifieds/views/item/view.html.php:335
    10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
    8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
    6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

45. Sorgu Süresi: 33.75 ms Son sorgudan sonra: 0.08 ms Sorgu belleği: 0.008 MB belleği şu sorgudan önce: 20.401 MB

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

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.10 ms
    Checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.01 ms
    Init for update	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Preparing	0.03 ms
    Updating	33.10 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.02 ms
    Waiting for query cache lock	0.01 ms
    Unlocking tables	0.02 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.07 ms
    Updating status	1.15 ms
    Reset for next command	0.01 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    17	JDatabase->query()	JROOT/components/com_djreviews/lib/api.php:512
    16	DJReviewsAPI::recalculate()	JROOT/components/com_djreviews/lib/api.php:115
    15	DJReviewsAPI->__construct()	JROOT/components/com_djreviews/lib/api.php:148
    14	DJReviewsAPI::getInstance()	JROOT/plugins/djclassifieds/djreviews/djreviews.php:82
    13	plgDjclassifiedsDJReviews->onAfterDJClassifiedsDisplayTitle()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_djclassifieds/views/item/view.html.php:335
    10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
    8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
    6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

46. Sorgu Süresi: 0.79 ms Son sorgudan sonra: 0.98 ms Sorgu belleği: 0.008 MB belleği şu sorgudan önce: 20.418 MB Dönen satır: 1

    SELECT *
    
      FROM frm_djrevs_objects
    
      WHERE entry_id=1827 
      AND object_type='com_djclassifieds.item' 
      AND rating_group_id=1

    Açıkla

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

    Profil

    Status	Duration
    Starting	0.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.17 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.02 ms
    Closing tables	0.01 ms
    Unlocking tables	0.01 ms
    Closing tables	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.07 ms
    Updating status	1.13 ms
    Reset for next command	0.02 ms

    Yığın Çağır

    #	Çağırıcı	Dosya ve satır sayısı
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    16	JDatabaseDriver->loadObject()	JROOT/components/com_djreviews/lib/api.php:375
    15	DJReviewsAPI->initialise()	JROOT/components/com_djreviews/lib/api.php:205
    14	DJReviewsAPI->getRatingAvg()	JROOT/plugins/djclassifieds/djreviews/djreviews.php:86
    13	plgDjclassifiedsDJReviews->onAfterDJClassifiedsDisplayTitle()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_djclassifieds/views/item/view.html.php:335
    10	DJclassifiedsViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djclassifieds/controllers/item.php:98
    8	DJClassifiedsControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djclassifieds/djclassifieds.php:137
    6	require_once JROOT/components/com_djclassifieds/djclassifieds.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

47. Sorgu Süresi: 0.77 ms Son sorgudan sonra: 0.99 ms Sorgu belleği: 0.009 MB belleği şu sorgudan önce: 20.470 MB Dönen satır: 1