لوازم یدکی

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1576257113,
                "last": 1576257113,
                "now": 1576257113
            },
            "token": "1vRKmLmWmZWYwlcia3Mk5z0gqW1BHmuh"
        },
        "registry": {
            "com_djcatalog2": {
                "items": {
                    "recent": [
                        66874
                    ]
                }
            }
        },
        "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
        }
    }
}

زمان

حافظه

75 پرس و جو ثبت شده 340.51 ms

1. زمان پرس و جو: 0.21 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 3.789 MB سطرهای بازگشتی: 0

   SELECT `data`
   
     FROM `pgr_session`
   
     WHERE `session_id` = 'vjrjsc1m6vmft5qv05db0mcvum'

   توضیح دادن

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

   مشخصات

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

   فراخوانی بسته

   #	فراخوانده	فایل و شماره خط
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	به نظر می رسد خط زیر فراخونده شده باشد.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

   ---

2. زمان پرس و جو: 0.18 ms پس از آخرین پرس و جو: 0.77 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 3.891 MB سطرهای بازگشتی: 0

   SELECT `session_id`
   
     FROM `pgr_session`
   
     WHERE `session_id` = 'vjrjsc1m6vmft5qv05db0mcvum' 
     LIMIT 1

   توضیح دادن

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

   مشخصات

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

   فراخوانی بسته

   #	فراخوانده	فایل و شماره خط
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   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

   [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

   ---

3. زمان پرس و جو: 6.13 ms پس از آخرین پرس و جو: 0.05 ms حافظه پرس و جو: 0.004 MB حافظه قبل از پرس و جوی: 3.897 MB

   INSERT INTO `pgr_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('vjrjsc1m6vmft5qv05db0mcvum', 1, 1576257113, 0, '', 0)

   توضیح دادن

   توضیحات در جستجو ممکن نیست: INSERT INTO `pgr_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('vjrjsc1m6vmft5qv05db0mcvum', 1, 1576257113, 0, '', 0)

   مشخصات

   Status	Duration
   Starting	0.02 ms
   Checking permissions	0.00 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   Table lock	0.00 ms
   Init for update	0.01 ms
   Update	0.09 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	5.86 ms
   Closing tables	0.01 ms
   Unlocking tables	0.00 ms
   Closing tables	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.01 ms
   Reset for next command	0.00 ms

   فراخوانی بسته

   #	فراخوانده	فایل و شماره خط
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

   ---

4. زمان پرس و جو: 0.29 ms پس از آخرین پرس و جو: 1.62 ms حافظه پرس و جو: 0.043 MB حافظه قبل از پرس و جوی: 4.171 MB سطرهای بازگشتی: 38

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `pgr_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   توضیح دادن

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

   مشخصات

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

   فراخوانی بسته

   #	فراخوانده	فایل و شماره خط
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	به نظر می رسد خط زیر فراخونده شده باشد.
   9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

   ---

5. زمان پرس و جو: 0.18 ms پس از آخرین پرس و جو: 1.34 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 4.389 MB سطرهای بازگشتی: 5

   SELECT id, rules
   
     FROM `pgr_viewlevels`

   توضیح دادن

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	pgr_viewlevels	ALL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	5

   مشخصات

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

   فراخوانی بسته

   #	فراخوانده	فایل و شماره خط
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
   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

   [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

   ---

6. زمان پرس و جو: 0.23 ms پس از آخرین پرس و جو: 0.05 ms حافظه پرس و جو: 0.022 MB حافظه قبل از پرس و جوی: 4.401 MB سطرهای بازگشتی: 1

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

   توضیح دادن

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

   مشخصات

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

   فراخوانی بسته

   #	فراخوانده	فایل و شماره خط
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
   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

   [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

   ---

7. زمان پرس و جو: 0.51 ms پس از آخرین پرس و جو: 0.37 ms حافظه پرس و جو: 0.033 MB حافظه قبل از پرس و جوی: 4.468 MB سطرهای بازگشتی: 78

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM pgr_extensions
   
     WHERE enabled = 1 
     AND type = 'plugin' 
     AND state IN (0,1) 
     AND access IN (1,1)
   
     ORDER BY ordering

   توضیح دادن

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	pgr_extensions	ref	extension	extension	82	const	122	Using index condition; Using where; با استفاده از مرتب سازی فایل

   مشخصات

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

   فراخوانی بسته

   #	فراخوانده	فایل و شماره خط
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	به نظر می رسد خط زیر فراخونده شده باشد.
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

   ---

8. زمان پرس و جو: 0.27 ms پس از آخرین پرس و جو: 17.58 ms حافظه پرس و جو: 0.028 MB حافظه قبل از پرس و جوی: 7.433 MB سطرهای بازگشتی: 1

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `pgr_extensions`
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   توضیح دادن

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

   مشخصات

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

   فراخوانی بسته

   #	فراخوانده	فایل و شماره خط
   21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
   20	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
   19	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	به نظر می رسد خط زیر فراخونده شده باشد.
   18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
   16	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
   15	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
   14	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
   13	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   12	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   11	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/helix/core/helix.php:50
   10	Helix::getDocument()	JROOT/plugins/system/helix/core/helix.php:36
   9	Helix::getInstance()	JROOT/plugins/system/helix/helix.php:21
   8	plgSystemHelix->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

   ---

9. زمان پرس و جو: 0.50 ms پس از آخرین پرس و جو: 0.08 ms حافظه پرس و جو: 0.007 MB حافظه قبل از پرس و جوی: 7.427 MB

   UPDATE `pgr_extensions`
   
     SET `params` = '{\"mediaversion\":\"ab3bab6668796650ca31e70b48e32bd3\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   توضیح دادن

   توضیحات در جستجو ممکن نیست: UPDATE `pgr_extensions` SET `params` = '{\"mediaversion\":\"ab3bab6668796650ca31e70b48e32bd3\"}' WHERE `type` = 'library' AND `element` = 'joomla'

   مشخصات

   Status	Duration
   Starting	0.02 ms
   Checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   Table lock	0.00 ms
   Init for update	0.03 ms
   Updating	0.03 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.33 ms
   Closing tables	0.01 ms
   Unlocking tables	0.00 ms
   Closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.01 ms
   Reset for next command	0.00 ms

   فراخوانی بسته

   #	فراخوانده	فایل و شماره خط
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
   15	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
   14	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
   13	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   12	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   11	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/helix/core/helix.php:50
   10	Helix::getDocument()	JROOT/plugins/system/helix/core/helix.php:36
   9	Helix::getInstance()	JROOT/plugins/system/helix/helix.php:21
   8	plgSystemHelix->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

   ---

10. زمان پرس و جو: 0.43 ms پس از آخرین پرس و جو: 1.42 ms حافظه پرس و جو: 0.059 MB حافظه قبل از پرس و جوی: 7.722 MB سطرهای بازگشتی: 31

    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
      FROM pgr_menu AS m
    
      LEFT JOIN pgr_extensions AS e 
      ON m.component_id = e.extension_id
    
      WHERE m.published = 1 
      AND m.parent_id > 0 
      AND m.client_id = 0
    
      ORDER BY m.lft

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	97	Using index condition; Using where; با استفاده از مرتب سازی فایل
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	payandeh_payandehgroup.m.component_id	1	Using where

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    23	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	به نظر می رسد خط زیر فراخونده شده باشد.
    22	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    21	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    20	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
    19	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    18	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
    17	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
    16	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    15	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:434
    14	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/helix/core/helix.php:65
    13	Helix::themeName()	JROOT/plugins/system/helix/core/helix.php:114
    12	Helix::themePath()	JROOT/plugins/system/helix/core/helix.php:302
    11	Helix::_Import()	JROOT/plugins/system/helix/core/helix.php:290
    10	Helix::Import()	JROOT/plugins/system/helix/core/helix.php:1592
    9	Helix::loadHelixOverwrite()	JROOT/plugins/system/helix/helix.php:22
    8	plgSystemHelix->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

11. زمان پرس و جو: 0.24 ms پس از آخرین پرس و جو: 0.36 ms حافظه پرس و جو: 0.037 MB حافظه قبل از پرس و جوی: 7.848 MB سطرهای بازگشتی: 4

    SELECT id, home, template, s.params
    
      FROM pgr_template_styles as s
    
      LEFT JOIN pgr_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

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using index condition; Using where
    1	SIMPLE	s	ALL	idx_template	کلید شاخصی برای استفاده نیست	NULL	NULL	6	Using where; Using join buffer (flat, BNL join)

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    14	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/helix/core/helix.php:65
    13	Helix::themeName()	JROOT/plugins/system/helix/core/helix.php:114
    12	Helix::themePath()	JROOT/plugins/system/helix/core/helix.php:302
    11	Helix::_Import()	JROOT/plugins/system/helix/core/helix.php:290
    10	Helix::Import()	JROOT/plugins/system/helix/core/helix.php:1592
    9	Helix::loadHelixOverwrite()	JROOT/plugins/system/helix/helix.php:22
    8	plgSystemHelix->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

12. زمان پرس و جو: 0.38 ms پس از آخرین پرس و جو: 10.89 ms حافظه پرس و جو: 0.029 MB حافظه قبل از پرس و جوی: 9.461 MB سطرهای بازگشتی: 2

    SHOW FULL COLUMNS 
      FROM `pgr_komento_configs`

    توضیح دادن

    توضیحات در جستجو ممکن نیست: SHOW FULL COLUMNS FROM `pgr_komento_configs`

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_komento/tables/parent.php:18
    14	KomentoParentTable->__construct()	JROOT/administrator/components/com_komento/tables/configs.php:40
    13	KomentoTableConfigs->__construct()	JROOT/libraries/src/Table/Table.php:312
    12	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_komento/tables/parent.php:49
    11	KomentoParentTable::getInstance()	JROOT/components/com_komento/helpers/helper.php:99
    10	Komento::getTable()	JROOT/components/com_komento/helpers/helper.php:228
    9	Komento::getKonfig()	JROOT/components/com_komento/bootstrap.php:30
    8	require_once JROOT/components/com_komento/bootstrap.php	JROOT/components/com_komento/router.php:16
    7	require_once JROOT/components/com_komento/router.php	JROOT/libraries/src/Router/SiteRouter.php:775
    6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:130
    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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

13. زمان پرس و جو: 0.21 ms پس از آخرین پرس و جو: 0.35 ms حافظه پرس و جو: 0.024 MB حافظه قبل از پرس و جوی: 9.493 MB سطرهای بازگشتی: 1

    SELECT *
    
      FROM pgr_komento_configs
    
      WHERE `component` = 'com_komento'

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pgr_komento_configs	ALL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	6	Using where

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    10	Joomla\CMS\Table\Table->load()	JROOT/components/com_komento/helpers/helper.php:229
    9	Komento::getKonfig()	JROOT/components/com_komento/bootstrap.php:30
    8	require_once JROOT/components/com_komento/bootstrap.php	JROOT/components/com_komento/router.php:16
    7	require_once JROOT/components/com_komento/router.php	JROOT/libraries/src/Router/SiteRouter.php:775
    6	Joomla\CMS\Router\SiteRouter->getComponentRouter()	JROOT/libraries/src/Router/SiteRouter.php:130
    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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

14. زمان پرس و جو: 0.19 ms پس از آخرین پرس و جو: 5.19 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 10.331 MB سطرهای بازگشتی: 1

    SELECT *
    
      FROM pgr_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pgr_languages	ALL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	1	Using where; با استفاده از مرتب سازی فایل

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
    4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

15. زمان پرس و جو: 0.17 ms پس از آخرین پرس و جو: 5.79 ms حافظه پرس و جو: 0.024 MB حافظه قبل از پرس و جوی: 11.395 MB سطرهای بازگشتی: 5

    SELECT a.id
    
      FROM pgr_viewlevels AS a
    
      ORDER BY a.ordering ASC, a.id ASC

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ALL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	5	با استفاده از مرتب سازی فایل

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    14	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:53
    13	Djc2CategoryNode->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:168
    12	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:207
    11	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:68
    10	Djcatalog2Helper::getParams()	JROOT/components/com_djcatalog2/helpers/theme.php:39
    9	DJCatalog2ThemeHelper::setThemeAssets()	JROOT/components/com_djcatalog2/controller.php:59
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

16. زمان پرس و جو: 0.25 ms پس از آخرین پرس و جو: 0.04 ms حافظه پرس و جو: 0.030 MB حافظه قبل از پرس و جوی: 11.401 MB سطرهای بازگشتی: 4

    SELECT c.*  
      FROM pgr_djc2_categories AS c  
      WHERE c.published=1 
      AND c.access IN (1)  
      ORDER BY c.parent_id ASC, c.ordering ASC

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	ref	idx_published,idx_access,idx_published_parent_ordering	idx_published_parent_ordering	4	const	4	Using where

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:298
    13	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:169
    12	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:207
    11	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:68
    10	Djcatalog2Helper::getParams()	JROOT/components/com_djcatalog2/helpers/theme.php:39
    9	DJCatalog2ThemeHelper::setThemeAssets()	JROOT/components/com_djcatalog2/controller.php:59
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

17. زمان پرس و جو: 0.43 ms پس از آخرین پرس و جو: 0.03 ms حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 11.436 MB سطرهای بازگشتی: 4
    پرس و جوی تکراری: #72

    SELECT i.id, img.fullname as item_image, img.caption AS image_caption, img.path AS image_path, img.fullpath AS image_fullpath
    
      FROM pgr_djc2_categories as i
    
      INNER JOIN pgr_djc2_images as img 
      on img.id=(select id 
      from pgr_djc2_images 
      where type='category' 
      and item_id=i.id 
      order by ordering asc 
      limit 1)

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	i	index	NULL	PRIMARY	4	NULL	4	Using index
    1	PRIMARY	img	eq_ref	PRIMARY	PRIMARY	4	func	1	Using where
    2	DEPENDENT SUBQUERY	pgr_djc2_images	ref	idx_type_item,idx_item_type,idx_item_type_ordering	idx_type_item	198	const,payandeh_payandehgroup.i.id	3	Using index condition; Using where; با استفاده از مرتب سازی فایل

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:305
    13	Djc2Categories->getCategories()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:169
    12	Djc2Categories->__construct()	JROOT/administrator/components/com_djcatalog2/lib/categories.php:207
    11	Djc2Categories::getInstance()	JROOT/components/com_djcatalog2/helpers/djcatalog2.php:68
    10	Djcatalog2Helper::getParams()	JROOT/components/com_djcatalog2/helpers/theme.php:39
    9	DJCatalog2ThemeHelper::setThemeAssets()	JROOT/components/com_djcatalog2/controller.php:59
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

18. زمان پرس و جو: 0.18 ms پس از آخرین پرس و جو: 2.95 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 11.897 MB سطرهای بازگشتی: 2

    select alias 
      from pgr_djc2_items_extra_fields 
      where type='checkbox' or type='radio' or type='select'

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pgr_djc2_items_extra_fields	ALL	idx_type	کلید شاخصی برای استفاده نیست	NULL	NULL	2	Using where

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    9	JDatabaseDriver->loadColumn()	JROOT/components/com_djcatalog2/controller.php:98
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

19. زمان پرس و جو: 0.59 ms پس از آخرین پرس و جو: 1.16 ms حافظه پرس و جو: 0.030 MB حافظه قبل از پرس و جوی: 12.089 MB سطرهای بازگشتی: 2

    SELECT f.*, group_concat(fo.id separator '|') as options, g.name as group_name, g.label as group_label, g.id as fgroup_id
    
      FROM pgr_djc2_items_extra_fields as f
    
      LEFT JOIN pgr_djc2_items_extra_fields_options as fo 
      ON fo.field_id=f.id
    
      LEFT JOIN pgr_djc2_items_extra_fields_groups as g 
      ON g.id=f.group_id
    
      WHERE (f.visibility = 1 or f.visibility = 3) 
      and f.published = 1
    
      GROUP BY f.id
    
      ORDER BY IFNULL(g.ordering,0) asc , g.ordering asc, f.ordering asc

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	idx_published	idx_published	4	const	2	Using where; Using temporary; با استفاده از مرتب سازی فایل
    1	SIMPLE	fo	ref	idx_field_id	idx_field_id	4	payandeh_payandehgroup.f.id	17
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	payandeh_payandehgroup.f.group_id	1

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:243
    13	DJCatalog2ModelItem->getAttributes()	JROOT/components/com_djcatalog2/models/item.php:126
    12	DJCatalog2ModelItem->getItem()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
    11	JViewLegacy->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:60
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

20. زمان پرس و جو: 0.38 ms پس از آخرین پرس و جو: 0.05 ms حافظه پرس و جو: 0.039 MB حافظه قبل از پرس و جوی: 12.106 MB سطرهای بازگشتی: 1

    SELECT i.*, 
      CASE WHEN (i.special_price > 0.0 
      AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price,c.id as _category_id, c.name as category, c.published as publish_category, c.alias as category_alias,p.id as _producer_id, p.name as producer, p.published as publish_producer, p.alias as producer_alias,ua.name AS author, ua.email AS author_email,countries.country_name 
    
      FROM pgr_djc2_items as i
    
      LEFT JOIN pgr_djc2_categories AS c 
      ON c.id = i.cat_id
    
      LEFT JOIN pgr_djc2_producers AS p 
      ON p.id = i.producer_id
    
      LEFT JOIN pgr_users AS ua 
      ON ua.id = i.created_by
    
      LEFT JOIN pgr_djc2_countries AS countries 
      ON countries.id = i.country
    
      WHERE i.id =66874 
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2019-12-13 17:11:53') 
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-12-13 17:11:53')
    
      GROUP BY i.id

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	i	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	p	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	ua	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	countries	const	PRIMARY	PRIMARY	2	const	0	Unique row not found

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    13	JDatabaseDriver->loadObject()	JROOT/components/com_djcatalog2/models/item.php:155
    12	DJCatalog2ModelItem->getItem()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
    11	JViewLegacy->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:60
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

21. زمان پرس و جو: 0.25 ms پس از آخرین پرس و جو: 0.04 ms حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 12.136 MB سطرهای بازگشتی: 0
    پرس و جوی تکراری: #24

    SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, fieldoptions.id as option_id, fieldoptions.value
    
      FROM pgr_djc2_items_extra_fields_values_int as fieldvalues
    
      INNER JOIN pgr_djc2_items as items 
      on items.id=fieldvalues.item_id
    
      INNER JOIN pgr_djc2_items_extra_fields as fields 
      ON fields.id = fieldvalues.field_id
    
      LEFT JOIN pgr_djc2_items_extra_fields_options as fieldoptions 
      ON fieldoptions.id = fieldvalues.value 
      AND fieldoptions.field_id = fields.id
    
      WHERE fieldvalues.item_id=66874 
      AND (fields.visibility = 1 OR fields.visibility = 3) 
      AND fields.published = 1
    
      ORDER BY fields.ordering asc, fieldoptions.ordering asc

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	items	const	PRIMARY	PRIMARY	4	const	1	Using index; Using temporary; با استفاده از مرتب سازی فایل
    1	SIMPLE	fieldvalues	ref	idx_item_field	idx_item_field	4	const	1
    1	SIMPLE	fields	eq_ref	PRIMARY,idx_published	PRIMARY	4	payandeh_payandehgroup.fieldvalues.field_id	1	Using where
    1	SIMPLE	fieldoptions	eq_ref	PRIMARY,idx_field_id	PRIMARY	4	payandeh_payandehgroup.fieldvalues.value	1	Using where

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:279
    13	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:174
    12	DJCatalog2ModelItem->getItem()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
    11	JViewLegacy->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:60
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

22. زمان پرس و جو: 0.14 ms پس از آخرین پرس و جو: 0.02 ms حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 12.143 MB سطرهای بازگشتی: 0
    پرس و جوی تکراری: #25

    SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value
    
      FROM pgr_djc2_items_extra_fields_values_text as fieldvalues
    
      INNER JOIN pgr_djc2_items as items 
      on items.id=fieldvalues.item_id
    
      INNER JOIN pgr_djc2_items_extra_fields as fields 
      ON fields.id = fieldvalues.field_id
    
      WHERE fieldvalues.item_id=66874 
      AND (fields.visibility = 1 OR fields.visibility = 3) 
      AND fields.published = 1

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:281
    13	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:174
    12	DJCatalog2ModelItem->getItem()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
    11	JViewLegacy->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:60
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

23. زمان پرس و جو: 0.16 ms پس از آخرین پرس و جو: 0.02 ms حافظه پرس و جو: 0.026 MB حافظه قبل از پرس و جوی: 12.151 MB سطرهای بازگشتی: 0
    پرس و جوی تکراری: #26

    SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value
    
      FROM pgr_djc2_items_extra_fields_values_date as fieldvalues
    
      INNER JOIN pgr_djc2_items as items 
      on items.id=fieldvalues.item_id
    
      INNER JOIN pgr_djc2_items_extra_fields as fields 
      ON fields.id = fieldvalues.field_id
    
      WHERE fieldvalues.item_id=66874 
      AND (fields.visibility = 1 OR fields.visibility = 3) 
      AND fields.published = 1
    
      ORDER BY fields.ordering asc

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:283
    13	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:174
    12	DJCatalog2ModelItem->getItem()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
    11	JViewLegacy->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:60
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

24. زمان پرس و جو: 0.27 ms پس از آخرین پرس و جو: 1.28 ms حافظه پرس و جو: 0.027 MB حافظه قبل از پرس و جوی: 12.331 MB سطرهای بازگشتی: 0
    پرس و جوی تکراری: #21

    SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, fieldoptions.id as option_id, fieldoptions.value
    
      FROM pgr_djc2_items_extra_fields_values_int as fieldvalues
    
      INNER JOIN pgr_djc2_items as items 
      on items.id=fieldvalues.item_id
    
      INNER JOIN pgr_djc2_items_extra_fields as fields 
      ON fields.id = fieldvalues.field_id
    
      LEFT JOIN pgr_djc2_items_extra_fields_options as fieldoptions 
      ON fieldoptions.id = fieldvalues.value 
      AND fieldoptions.field_id = fields.id
    
      WHERE fieldvalues.item_id=66874 
      AND (fields.visibility = 1 OR fields.visibility = 3) 
      AND fields.published = 1
    
      ORDER BY fields.ordering asc, fieldoptions.ordering asc

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	items	const	PRIMARY	PRIMARY	4	const	1	Using index; Using temporary; با استفاده از مرتب سازی فایل
    1	SIMPLE	fieldvalues	ref	idx_item_field	idx_item_field	4	const	1
    1	SIMPLE	fields	eq_ref	PRIMARY,idx_published	PRIMARY	4	payandeh_payandehgroup.fieldvalues.field_id	1	Using where
    1	SIMPLE	fieldoptions	eq_ref	PRIMARY,idx_field_id	PRIMARY	4	payandeh_payandehgroup.fieldvalues.value	1	Using where

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:279
    14	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:174
    13	DJCatalog2ModelItem->getItem()	JROOT/components/com_djcatalog2/models/item.php:73
    12	DJCatalog2ModelItem->getForm()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
    11	JViewLegacy->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:61
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

25. زمان پرس و جو: 0.18 ms پس از آخرین پرس و جو: 0.02 ms حافظه پرس و جو: 0.027 MB حافظه قبل از پرس و جوی: 12.338 MB سطرهای بازگشتی: 0
    پرس و جوی تکراری: #22

    SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value
    
      FROM pgr_djc2_items_extra_fields_values_text as fieldvalues
    
      INNER JOIN pgr_djc2_items as items 
      on items.id=fieldvalues.item_id
    
      INNER JOIN pgr_djc2_items_extra_fields as fields 
      ON fields.id = fieldvalues.field_id
    
      WHERE fieldvalues.item_id=66874 
      AND (fields.visibility = 1 OR fields.visibility = 3) 
      AND fields.published = 1

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:281
    14	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:174
    13	DJCatalog2ModelItem->getItem()	JROOT/components/com_djcatalog2/models/item.php:73
    12	DJCatalog2ModelItem->getForm()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
    11	JViewLegacy->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:61
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

26. زمان پرس و جو: 0.16 ms پس از آخرین پرس و جو: 0.02 ms حافظه پرس و جو: 0.027 MB حافظه قبل از پرس و جوی: 12.346 MB سطرهای بازگشتی: 0
    پرس و جوی تکراری: #23

    SELECT fields.alias, fields.type, fields.ordering, fieldvalues.item_id, fieldvalues.field_id, fieldvalues.id as value_id, 0 as option_id, fieldvalues.value
    
      FROM pgr_djc2_items_extra_fields_values_date as fieldvalues
    
      INNER JOIN pgr_djc2_items as items 
      on items.id=fieldvalues.item_id
    
      INNER JOIN pgr_djc2_items_extra_fields as fields 
      ON fields.id = fieldvalues.field_id
    
      WHERE fieldvalues.item_id=66874 
      AND (fields.visibility = 1 OR fields.visibility = 3) 
      AND fields.published = 1
    
      ORDER BY fields.ordering asc

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/item.php:283
    14	DJCatalog2ModelItem->bindAttributes()	JROOT/components/com_djcatalog2/models/item.php:174
    13	DJCatalog2ModelItem->getItem()	JROOT/components/com_djcatalog2/models/item.php:73
    12	DJCatalog2ModelItem->getForm()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:394
    11	JViewLegacy->get()	JROOT/components/com_djcatalog2/views/item/view.html.php:61
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

27. زمان پرس و جو: 63.27 ms پس از آخرین پرس و جو: 0.49 ms حافظه پرس و جو: 2.087 MB حافظه قبل از پرس و جوی: 12.386 MB سطرهای بازگشتی: 27892

    select id, producer_id 
      from pgr_djc2_items 
      where published=1

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pgr_djc2_items	ref	idx_published	idx_published	4	const	27889

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/helpers/route.php:77
    11	DJCatalogHelperRoute::getItemRoute()	JROOT/components/com_djcatalog2/views/item/view.html.php:101
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

28. زمان پرس و جو: 0.21 ms پس از آخرین پرس و جو: 16.82 ms حافظه پرس و جو: 0.024 MB حافظه قبل از پرس و جوی: 14.157 MB سطرهای بازگشتی: 0

    SELECT related_item
    
      FROM pgr_djc2_items_related
    
      WHERE item_id=66874

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    12	JDatabaseDriver->loadColumn()	JROOT/components/com_djcatalog2/models/item.php:202
    11	DJCatalog2ModelItem->getRelatedItems()	JROOT/components/com_djcatalog2/views/item/view.html.php:160
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

29. زمان پرس و جو: 35.92 ms پس از آخرین پرس و جو: 0.04 ms حافظه پرس و جو: 0.023 MB حافظه قبل از پرس و جوی: 14.164 MB سطرهای بازگشتی: 1

    SELECT subq.position 
      FROM (SELECT k.*, @num := @num + 1 AS position 
      FROM (SELECT @num := 0) AS n, (SELECT DISTINCT i.id, i.name, i.alias, i.cat_id, c.alias as category_alias, 
      CASE WHEN (i.special_price > 0.0 
      AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price 
      FROM pgr_djc2_items AS i  
      LEFT JOIN pgr_djc2_categories as c 
      ON c.id = i.cat_id  
      LEFT JOIN pgr_djc2_producers as p 
      ON p.id = i.producer_id  
      WHERE i.parent_id = 0 
      AND i.published = 1 
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2019-12-13 17:11:53') 
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-12-13 17:11:53') 
      AND c.published = 1  
      AND i.cat_id=20 
      ORDER BY i.featured DESC, c.parent_id asc, c.ordering asc, i.ordering asc) as k) as subq 
      WHERE subq.id = 66874 
      ORDER BY subq.position DESC 
      LIMIT 1

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	<derived2>	ALL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	9042	Using where; با استفاده از مرتب سازی فایل
    2	DERIVED	<derived3>	system	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	1
    2	DERIVED	<derived4>	ALL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	9042
    4	DERIVED	c	const	PRIMARY,idx_published,idx_published_parent_ordering	PRIMARY	4	const	1
    4	DERIVED	i	ref	idx_cat_id,idx_parent_id,idx_published	idx_cat_id	4	const	9042	Using where; با استفاده از مرتب سازی فایل
    3	DERIVED	NULL	NULL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	NULL	No tables used

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    12	JDatabaseDriver->loadResult()	JROOT/components/com_djcatalog2/models/item.php:405
    11	DJCatalog2ModelItem->getNavigation()	JROOT/components/com_djcatalog2/views/item/view.html.php:162
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

30. زمان پرس و جو: 35.76 ms پس از آخرین پرس و جو: 0.03 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 14.172 MB سطرهای بازگشتی: 1

    SELECT subq.* 
      FROM (SELECT k.*, @num := @num + 1 AS position 
      FROM (SELECT @num := 0) AS n, (SELECT DISTINCT i.id, i.name, i.alias, i.cat_id, c.alias as category_alias, 
      CASE WHEN (i.special_price > 0.0 
      AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price 
      FROM pgr_djc2_items AS i  
      LEFT JOIN pgr_djc2_categories as c 
      ON c.id = i.cat_id  
      LEFT JOIN pgr_djc2_producers as p 
      ON p.id = i.producer_id  
      WHERE i.parent_id = 0 
      AND i.published = 1 
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2019-12-13 17:11:53') 
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-12-13 17:11:53') 
      AND c.published = 1  
      AND i.cat_id=20 
      ORDER BY i.featured DESC, c.parent_id asc, c.ordering asc, i.ordering asc) as k) as subq 
      WHERE subq.position < 4150 
      ORDER BY subq.position DESC 
      LIMIT 1

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	<derived2>	ALL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	9042	Using where; با استفاده از مرتب سازی فایل
    2	DERIVED	<derived3>	system	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	1
    2	DERIVED	<derived4>	ALL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	9042
    4	DERIVED	c	const	PRIMARY,idx_published,idx_published_parent_ordering	PRIMARY	4	const	1
    4	DERIVED	i	ref	idx_cat_id,idx_parent_id,idx_published	idx_cat_id	4	const	9042	Using where; با استفاده از مرتب سازی فایل
    3	DERIVED	NULL	NULL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	NULL	No tables used

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    12	JDatabaseDriver->loadObject()	JROOT/components/com_djcatalog2/models/item.php:417
    11	DJCatalog2ModelItem->getNavigation()	JROOT/components/com_djcatalog2/views/item/view.html.php:162
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

31. زمان پرس و جو: 35.17 ms پس از آخرین پرس و جو: 0.03 ms حافظه پرس و جو: 0.025 MB حافظه قبل از پرس و جوی: 14.181 MB سطرهای بازگشتی: 1

    SELECT subq.* 
      FROM (SELECT k.*, @num := @num + 1 AS position 
      FROM (SELECT @num := 0) AS n, (SELECT DISTINCT i.id, i.name, i.alias, i.cat_id, c.alias as category_alias, 
      CASE WHEN (i.special_price > 0.0 
      AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price 
      FROM pgr_djc2_items AS i  
      LEFT JOIN pgr_djc2_categories as c 
      ON c.id = i.cat_id  
      LEFT JOIN pgr_djc2_producers as p 
      ON p.id = i.producer_id  
      WHERE i.parent_id = 0 
      AND i.published = 1 
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2019-12-13 17:11:53') 
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-12-13 17:11:53') 
      AND c.published = 1  
      AND i.cat_id=20 
      ORDER BY i.featured DESC, c.parent_id asc, c.ordering asc, i.ordering asc) as k) as subq 
      WHERE subq.position > 4150 
      ORDER BY subq.position ASC 
      LIMIT 1

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	<derived2>	ALL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	9042	Using where; با استفاده از مرتب سازی فایل
    2	DERIVED	<derived3>	system	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	1
    2	DERIVED	<derived4>	ALL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	9042
    4	DERIVED	c	const	PRIMARY,idx_published,idx_published_parent_ordering	PRIMARY	4	const	1
    4	DERIVED	i	ref	idx_cat_id,idx_parent_id,idx_published	idx_cat_id	4	const	9042	Using where; با استفاده از مرتب سازی فایل
    3	DERIVED	NULL	NULL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	NULL	No tables used

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    12	JDatabaseDriver->loadObject()	JROOT/components/com_djcatalog2/models/item.php:425
    11	DJCatalog2ModelItem->getNavigation()	JROOT/components/com_djcatalog2/views/item/view.html.php:162
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

32. زمان پرس و جو: 0.44 ms پس از آخرین پرس و جو: 1.71 ms حافظه پرس و جو: 0.032 MB حافظه قبل از پرس و جوی: 14.992 MB سطرهای بازگشتی: 38

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `pgr_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djcatalog2','com_djimageslider','com_finder','com_installer','com_jce','com_jmap','com_joomlaupdate','com_komento','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pgr_assets	ALL	idx_asset_name	کلید شاخصی برای استفاده نیست	NULL	NULL	245	Using where

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    21	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    20	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    19	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    18	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    17	Joomla\CMS\User\User->authorise()	JROOT/components/com_djcatalog2/models/items.php:663
    16	DJCatalog2ModelItems->_buildContentWhere()	JROOT/components/com_djcatalog2/models/items.php:258
    15	DJCatalog2ModelItems->buildQuery()	JROOT/components/com_djcatalog2/models/items.php:231
    14	DJCatalog2ModelItems->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
    13	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/components/com_djcatalog2/models/items.php:211
    12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/models/item.php:478
    11	DJCatalog2ModelItem->getChildren()	JROOT/components/com_djcatalog2/views/item/view.html.php:164
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

33. زمان پرس و جو: 0.27 ms پس از آخرین پرس و جو: 0.46 ms حافظه پرس و جو: 0.033 MB حافظه قبل از پرس و جوی: 15.076 MB سطرهای بازگشتی: 2

    SELECT f.*, g.name as group_name, g.label as group_label, g.id as fgroup_id
    
      FROM pgr_djc2_items_extra_fields as f
    
      LEFT JOIN pgr_djc2_items_extra_fields_groups as g 
      ON g.id=f.group_id
    
      WHERE f.published = 1
    
      ORDER BY IFNULL(g.ordering,0) asc, g.ordering asc, f.ordering asc

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	f	ref	idx_published	idx_published	4	const	2	Using temporary; با استفاده از مرتب سازی فایل
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	payandeh_payandehgroup.f.group_id	1

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:824
    16	DJCatalog2ModelItems->getAttributes()	JROOT/components/com_djcatalog2/models/items.php:260
    15	DJCatalog2ModelItems->buildQuery()	JROOT/components/com_djcatalog2/models/items.php:231
    14	DJCatalog2ModelItems->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
    13	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/components/com_djcatalog2/models/items.php:211
    12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/models/item.php:478
    11	DJCatalog2ModelItem->getChildren()	JROOT/components/com_djcatalog2/views/item/view.html.php:164
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

34. زمان پرس و جو: 0.17 ms پس از آخرین پرس و جو: 0.04 ms حافظه پرس و جو: 0.028 MB حافظه قبل از پرس و جوی: 15.094 MB سطرهای بازگشتی: 34

    SELECT o.id, o.field_id
    
      FROM pgr_djc2_items_extra_fields_options AS o
    
      ORDER BY o.field_id asc, o.ordering asc

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	o	ALL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	34	با استفاده از مرتب سازی فایل

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:834
    16	DJCatalog2ModelItems->getAttributes()	JROOT/components/com_djcatalog2/models/items.php:260
    15	DJCatalog2ModelItems->buildQuery()	JROOT/components/com_djcatalog2/models/items.php:231
    14	DJCatalog2ModelItems->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
    13	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/components/com_djcatalog2/models/items.php:211
    12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/models/item.php:478
    11	DJCatalog2ModelItem->getChildren()	JROOT/components/com_djcatalog2/views/item/view.html.php:164
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

35. زمان پرس و جو: 0.79 ms پس از آخرین پرس و جو: 0.08 ms حافظه پرس و جو: 0.038 MB حافظه قبل از پرس و جوی: 15.106 MB سطرهای بازگشتی: 0

    SELECT distinct i.*, 
      CASE WHEN (i.special_price > 0.0 
      AND i.special_price < i.price) THEN i.special_price ELSE i.price END as final_price,c.id as _category_id, c.name as category, c.published as publish_category, c.alias as category_alias,p.id as _producer_id, p.name as producer, p.published as publish_producer, p.alias as producer_alias,ua.name AS author, ua.email AS author_email,countries.country_name,states.name as state_name
    
      FROM pgr_djc2_items as i
    
      LEFT JOIN pgr_djc2_categories AS c 
      ON c.id = i.cat_id
    
      LEFT JOIN pgr_djc2_producers AS p 
      ON p.id = i.producer_id
    
      LEFT JOIN pgr_users AS ua 
      ON ua.id = i.created_by
    
      LEFT JOIN pgr_djc2_countries AS countries 
      ON countries.id = i.country
    
      LEFT JOIN pgr_djc2_countries_states AS states 
      ON states.id = i.state
    
      WHERE c.published = 1 
      AND (i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2019-12-13 17:11:53') 
      AND (i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2019-12-13 17:11:53') 
      AND i.published = 1 
      AND i.access IN (1,1) 
      AND i.parent_id=66874
    
      ORDER BY c.parent_id asc, c.ordering asc, i.ordering asc

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	states	system	PRIMARY	کلید شاخصی برای استفاده نیست	NULL	NULL	0	Const row not found; Using temporary; با استفاده از مرتب سازی فایل
    1	SIMPLE	i	ref	idx_cat_id,idx_parent_id,idx_published,idx_access	idx_parent_id	4	const	1	Using where
    1	SIMPLE	c	eq_ref	PRIMARY,idx_published,idx_published_parent_ordering	PRIMARY	4	payandeh_payandehgroup.i.cat_id	1	Using where
    1	SIMPLE	p	eq_ref	PRIMARY	PRIMARY	4	payandeh_payandehgroup.i.producer_id	1
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	payandeh_payandehgroup.i.created_by	1
    1	SIMPLE	countries	eq_ref	PRIMARY	PRIMARY	2	payandeh_payandehgroup.i.country	1	Using where

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    14	JDatabaseDriver->loadObjectList()	JROOT/components/com_djcatalog2/models/items.php:195
    13	DJCatalog2ModelItems->_getList()	JROOT/components/com_djcatalog2/models/items.php:213
    12	DJCatalog2ModelItems->getItems()	JROOT/components/com_djcatalog2/models/item.php:478
    11	DJCatalog2ModelItem->getChildren()	JROOT/components/com_djcatalog2/views/item/view.html.php:164
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

36. زمان پرس و جو: 0.27 ms پس از آخرین پرس و جو: 0.83 ms حافظه پرس و جو: 0.027 MB حافظه قبل از پرس و جوی: 15.172 MB سطرهای بازگشتی: 0

    SELECT *  
      FROM pgr_djc2_images  
      WHERE item_id=66874 	
      AND type='item' 
      AND exclude=0 
      ORDER BY ordering ASC, name ASC

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pgr_djc2_images	ref	idx_type_item,idx_item_type,idx_item_type_ordering	idx_type_item	198	const,const	1	Using index condition; Using where; با استفاده از مرتب سازی فایل

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/helpers/image.php:91
    12	DJCatalog2ImageHelper::getImages()	JROOT/components/com_djcatalog2/views/item/view.html.php:301
    11	DJCatalog2ViewItem->_prepareDocument()	JROOT/components/com_djcatalog2/views/item/view.html.php:183
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

37. زمان پرس و جو: 0.12 ms پس از آخرین پرس و جو: 0.03 ms حافظه پرس و جو: 0.006 MB حافظه قبل از پرس و جوی: 15.179 MB

    UPDATE pgr_djc2_items 
      SET hits = hits + 1 
      WHERE id = 66874

    توضیح دادن

    توضیحات در جستجو ممکن نیست: UPDATE pgr_djc2_items SET hits = hits + 1 WHERE id = 66874

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    12	JDatabase->query()	JROOT/components/com_djcatalog2/models/item.php:489
    11	DJCatalog2ModelItem->hit()	JROOT/components/com_djcatalog2/views/item/view.html.php:185
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

38. زمان پرس و جو: 0.16 ms پس از آخرین پرس و جو: 2.23 ms حافظه پرس و جو: 0.028 MB حافظه قبل از پرس و جوی: 15.477 MB سطرهای بازگشتی: 0

    SELECT *  
      FROM pgr_djc2_files  
      WHERE item_id=66874 	
      AND type='item' 
      ORDER BY ordering ASC, name ASC

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_djcatalog2/helpers/file.php:81
    14	DJCatalog2FileHelper::getFiles()	JROOT/components/com_djcatalog2/views/item/tmpl/default.php:305
    13	include JROOT/components/com_djcatalog2/views/item/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
    11	JViewLegacy->display()	JROOT/components/com_djcatalog2/views/item/view.html.php:187
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

39. زمان پرس و جو: 0.26 ms پس از آخرین پرس و جو: 3.51 ms حافظه پرس و جو: 0.028 MB حافظه قبل از پرس و جوی: 15.548 MB سطرهای بازگشتی: 1

    SELECT *
    
      FROM pgr_komento_configs
    
      WHERE `component` = 'com_djcatalog2'

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pgr_komento_configs	ALL	NULL	کلید شاخصی برای استفاده نیست	NULL	NULL	6	Using where

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    19	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    18	Joomla\CMS\Table\Table->load()	JROOT/components/com_komento/helpers/helper.php:202
    17	Komento::getConfig()	JROOT/components/com_komento/helpers/helper.php:697
    16	Komento::commentify()	JROOT/components/com_djcatalog2/views/item/tmpl/default_comments.php:89
    15	include JROOT/components/com_djcatalog2/views/item/tmpl/default_comments.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    14	JViewLegacy->loadTemplate()	JROOT/components/com_djcatalog2/views/item/tmpl/default.php:339
    13	include JROOT/components/com_djcatalog2/views/item/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
    11	JViewLegacy->display()	JROOT/components/com_djcatalog2/views/item/view.html.php:187
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

40. زمان پرس و جو: 0.22 ms پس از آخرین پرس و جو: 3.07 ms حافظه پرس و جو: 0.041 MB حافظه قبل از پرس و جوی: 15.590 MB سطرهای بازگشتی: 1

    SELECT a.*, c.alias AS category_alias 
      FROM `pgr_djc2_items` AS a 
      LEFT JOIN `pgr_djc2_categories` AS c 
      ON c.id = a.cat_id 
      WHERE a.id='66874'

    توضیح دادن

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

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    20	JDatabaseDriver->loadObject()	JROOT/components/com_komento/helpers/database.php:151
    19	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
    18	KomentoDatabaseHelper->__call()	JROOT/components/com_djcatalog2/komento_plugin.php:61
    17	KomentoComDjcatalog2->load()	JROOT/components/com_komento/helpers/helper.php:743
    16	Komento::commentify()	JROOT/components/com_djcatalog2/views/item/tmpl/default_comments.php:89
    15	include JROOT/components/com_djcatalog2/views/item/tmpl/default_comments.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    14	JViewLegacy->loadTemplate()	JROOT/components/com_djcatalog2/views/item/tmpl/default.php:339
    13	include JROOT/components/com_djcatalog2/views/item/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
    11	JViewLegacy->display()	JROOT/components/com_djcatalog2/views/item/view.html.php:187
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

41. زمان پرس و جو: 0.23 ms پس از آخرین پرس و جو: 0.55 ms حافظه پرس و جو: 0.028 MB حافظه قبل از پرس و جوی: 15.696 MB سطرهای بازگشتی: 0

    SELECT `id` 
      FROM `pgr_komento_mailq` 
      WHERE `status` = '0' 
      ORDER BY `created` ASC 
      LIMIT 0, 5

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pgr_komento_mailq	ref	komento_mailq_status	komento_mailq_status	1	const	1	Using where; با استفاده از مرتب سازی فایل

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    22	JDatabaseDriver->loadObjectList()	JROOT/components/com_komento/helpers/database.php:151
    21	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
    20	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/classes/sql.php:937
    19	KomentoSql->__call()	JROOT/components/com_komento/classes/mailqueue.php:49
    18	KomentoMailQueue->send()	JROOT/components/com_komento/classes/mailqueue.php:24
    17	KomentoMailQueue->sendOnPageLoad()	JROOT/components/com_komento/helpers/helper.php:848
    16	Komento::commentify()	JROOT/components/com_djcatalog2/views/item/tmpl/default_comments.php:89
    15	include JROOT/components/com_djcatalog2/views/item/tmpl/default_comments.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    14	JViewLegacy->loadTemplate()	JROOT/components/com_djcatalog2/views/item/tmpl/default.php:339
    13	include JROOT/components/com_djcatalog2/views/item/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
    11	JViewLegacy->display()	JROOT/components/com_djcatalog2/views/item/view.html.php:187
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

42. زمان پرس و جو: 0.19 ms پس از آخرین پرس و جو: 0.04 ms حافظه پرس و جو: 0.010 MB حافظه قبل از پرس و جوی: 15.703 MB

    DELETE 
      FROM `pgr_komento_captcha` 
      WHERE `created` <= DATE_SUB(NOW(), INTERVAL 7 DAY)

    توضیح دادن

    توضیحات در جستجو ممکن نیست: DELETE FROM `pgr_komento_captcha` WHERE `created` <= DATE_SUB(NOW(), INTERVAL 7 DAY)

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    20	JDatabase->query()	JROOT/components/com_komento/helpers/database.php:151
    19	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
    18	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/helpers/helper.php:1450
    17	Komento::clearCaptcha()	JROOT/components/com_komento/helpers/helper.php:854
    16	Komento::commentify()	JROOT/components/com_djcatalog2/views/item/tmpl/default_comments.php:89
    15	include JROOT/components/com_djcatalog2/views/item/tmpl/default_comments.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    14	JViewLegacy->loadTemplate()	JROOT/components/com_djcatalog2/views/item/tmpl/default.php:339
    13	include JROOT/components/com_djcatalog2/views/item/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
    11	JViewLegacy->display()	JROOT/components/com_djcatalog2/views/item/view.html.php:187
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

43. زمان پرس و جو: 0.21 ms پس از آخرین پرس و جو: 0.66 ms حافظه پرس و جو: 0.029 MB حافظه قبل از پرس و جوی: 15.777 MB سطرهای بازگشتی: 0

    SELECT `rules` 
      FROM `pgr_komento_acl` 
      WHERE `cid` = '1' 
      AND `type` = 'usergroup' 
      AND `component` = 'com_djcatalog2' 
      ORDER BY `id` ASC

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pgr_komento_acl	ref	komento_acl_content_type	komento_acl_content_type	767	const	9	Using index condition; Using where; با استفاده از مرتب سازی فایل

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    24	JDatabaseDriver->loadResult()	JROOT/components/com_komento/helpers/database.php:151
    23	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
    22	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/classes/sql.php:937
    21	KomentoSql->__call()	JROOT/components/com_komento/models/acl.php:29
    20	KomentoModelAcl->getAclObject()	JROOT/components/com_komento/helpers/acl.php:133
    19	KomentoACLHelper::getRules()	JROOT/components/com_komento/helpers/helper.php:246
    18	Komento::getACL()	JROOT/components/com_komento/helpers/document.php:31
    17	KomentoDocumentHelper::loadHeaders()	JROOT/components/com_komento/helpers/helper.php:858
    16	Komento::commentify()	JROOT/components/com_djcatalog2/views/item/tmpl/default_comments.php:89
    15	include JROOT/components/com_djcatalog2/views/item/tmpl/default_comments.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    14	JViewLegacy->loadTemplate()	JROOT/components/com_djcatalog2/views/item/tmpl/default.php:339
    13	include JROOT/components/com_djcatalog2/views/item/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
    11	JViewLegacy->display()	JROOT/components/com_djcatalog2/views/item/view.html.php:187
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

44. زمان پرس و جو: 0.18 ms پس از آخرین پرس و جو: 0.07 ms حافظه پرس و جو: 0.029 MB حافظه قبل از پرس و جوی: 15.789 MB سطرهای بازگشتی: 0

    SELECT `rules` 
      FROM `pgr_komento_acl` 
      WHERE `cid` = '0' 
      AND `type` = 'user' 
      AND `component` = 'com_djcatalog2' 
      ORDER BY `id` ASC

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pgr_komento_acl	ref	komento_acl_content_type	komento_acl_content_type	767	const	1	Using index condition; Using where; با استفاده از مرتب سازی فایل

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    24	JDatabaseDriver->loadResult()	JROOT/components/com_komento/helpers/database.php:151
    23	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
    22	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/classes/sql.php:937
    21	KomentoSql->__call()	JROOT/components/com_komento/models/acl.php:29
    20	KomentoModelAcl->getAclObject()	JROOT/components/com_komento/helpers/acl.php:137
    19	KomentoACLHelper::getRules()	JROOT/components/com_komento/helpers/helper.php:246
    18	Komento::getACL()	JROOT/components/com_komento/helpers/document.php:31
    17	KomentoDocumentHelper::loadHeaders()	JROOT/components/com_komento/helpers/helper.php:858
    16	Komento::commentify()	JROOT/components/com_djcatalog2/views/item/tmpl/default_comments.php:89
    15	include JROOT/components/com_djcatalog2/views/item/tmpl/default_comments.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    14	JViewLegacy->loadTemplate()	JROOT/components/com_djcatalog2/views/item/tmpl/default.php:339
    13	include JROOT/components/com_djcatalog2/views/item/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
    11	JViewLegacy->display()	JROOT/components/com_djcatalog2/views/item/view.html.php:187
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

45. زمان پرس و جو: 0.22 ms پس از آخرین پرس و جو: 6.81 ms حافظه پرس و جو: 0.028 MB حافظه قبل از پرس و جوی: 17.052 MB سطرهای بازگشتی: 1
    پرس و جوی تکراری: #50

    SELECT COUNT(1) 
      FROM `pgr_komento_comments` 
      WHERE `component` = 'com_djcatalog2' 
      AND `cid` = '66874' 
      AND `published` = '1'

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pgr_komento_comments	ref	komento_threaded,komento_threaded_reverse,komento_module_comments	komento_threaded_reverse	776	const,const,const	1	Using where; Using index

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    20	JDatabaseDriver->loadResult()	JROOT/components/com_komento/helpers/database.php:151
    19	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
    18	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/models/comments.php:73
    17	KomentoModelComments->getCount()	JROOT/components/com_komento/helpers/helper.php:869
    16	Komento::commentify()	JROOT/components/com_djcatalog2/views/item/tmpl/default_comments.php:89
    15	include JROOT/components/com_djcatalog2/views/item/tmpl/default_comments.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    14	JViewLegacy->loadTemplate()	JROOT/components/com_djcatalog2/views/item/tmpl/default.php:339
    13	include JROOT/components/com_djcatalog2/views/item/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
    11	JViewLegacy->display()	JROOT/components/com_djcatalog2/views/item/view.html.php:187
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

46. زمان پرس و جو: 0.22 ms پس از آخرین پرس و جو: 0.06 ms حافظه پرس و جو: 0.028 MB حافظه قبل از پرس و جوی: 17.063 MB سطرهای بازگشتی: 1

    SELECT AVG(`ratings`) as `value`, COUNT(1) AS `total` 
      FROM `pgr_komento_comments` 
      WHERE `component` = 'com_djcatalog2' 
      AND `cid` = '66874' 
      AND `published` = '1' 
      AND `ratings` !='' 
      ORDER BY `created` ASC 
      LIMIT 0,10

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pgr_komento_comments	ref	komento_threaded,komento_threaded_reverse,komento_module_comments	komento_threaded	776	const,const,const	1	Using index condition; Using where

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    20	JDatabaseDriver->loadObject()	JROOT/components/com_komento/helpers/database.php:151
    19	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
    18	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/models/comments.php:108
    17	KomentoModelComments->getOverallRatings()	JROOT/components/com_komento/helpers/helper.php:872
    16	Komento::commentify()	JROOT/components/com_djcatalog2/views/item/tmpl/default_comments.php:89
    15	include JROOT/components/com_djcatalog2/views/item/tmpl/default_comments.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    14	JViewLegacy->loadTemplate()	JROOT/components/com_djcatalog2/views/item/tmpl/default.php:339
    13	include JROOT/components/com_djcatalog2/views/item/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
    11	JViewLegacy->display()	JROOT/components/com_djcatalog2/views/item/view.html.php:187
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

47. زمان پرس و جو: 0.27 ms پس از آخرین پرس و جو: 0.08 ms حافظه پرس و جو: 0.039 MB حافظه قبل از پرس و جوی: 17.074 MB سطرهای بازگشتی: 0

    SELECT * 
      FROM `pgr_komento_comments` 
      WHERE `component` = 'com_djcatalog2' 
      AND `cid` = '66874' 
      AND `published` = '1' 
      ORDER BY `lft` ASC 
      LIMIT 0,10

    توضیح دادن

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pgr_komento_comments	ref	komento_threaded,komento_threaded_reverse,komento_module_comments	komento_threaded	776	const,const,const	1	Using index condition; Using where

    مشخصات

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

    فراخوانی بسته

    #	فراخوانده	فایل و شماره خط
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    20	JDatabaseDriver->loadObjectList()	JROOT/components/com_komento/helpers/database.php:151
    19	KomentoDatabaseJoomla15->__call()	JROOT/components/com_komento/helpers/database.php:40
    18	KomentoDatabaseHelper->__call()	JROOT/components/com_komento/models/comments.php:146
    17	KomentoModelComments->getComments()	JROOT/components/com_komento/helpers/helper.php:957
    16	Komento::commentify()	JROOT/components/com_djcatalog2/views/item/tmpl/default_comments.php:89
    15	include JROOT/components/com_djcatalog2/views/item/tmpl/default_comments.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    14	JViewLegacy->loadTemplate()	JROOT/components/com_djcatalog2/views/item/tmpl/default.php:339
    13	include JROOT/components/com_djcatalog2/views/item/tmpl/default.php	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:661
    12	JViewLegacy->loadTemplate()	JROOT/plugins/system/helix/core/classes/joomla30/viewlegacy.php:207
    11	JViewLegacy->display()	JROOT/components/com_djcatalog2/views/item/view.html.php:187
    10	DJCatalog2ViewItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_djcatalog2/controller.php:108
    8	DJCatalog2Controller->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_djcatalog2/djcatalog2.php:60
    6	require_once JROOT/components/com_djcatalog2/djcatalog2.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

    [بخشنامه xdebug.file_link_format به فایل php.ini برای لینک به فایل ها]

    ---

48. زمان پرس و جو: 0.18 ms پس از آخرین پرس و جو: 0.45 ms حافظه پرس و جو: 0.030 MB حافظه قبل از پرس و جوی: 17.146 MB سطرهای بازگشتی: 1