{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1744441827,
                "last": 1744441827,
                "now": 1744441827
            },
            "token": "LkYf7uOp7AQT5MUmlLmv9NzBoqfiTYkP"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [
                "1"
            ],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Time

Memory

Veikti 44 vaicājumi 16.12 ms

1. Query Time: 0.18 ms Query memory: 0.028 MB Memory before query: 0.662 MB Rows returned: 1

   SELECT `data`
   
     FROM `rvt_session`
   
     WHERE `session_id` = 'tpidk5qciu7a0rsnesjgi8pjt7'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	rvt_session	const	PRIMARY	PRIMARY	766	const	1

   Profile

   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
   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.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

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
   13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
   12	JSessionStorageDatabase->read()	Same as call in the line below.
   11	session_start()	JROOT/libraries/joomla/session/handler/native.php:258
   10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
   9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
   8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
   7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
   6	JSession->start()	JROOT/libraries/cms/application/cms.php:748
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:404
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:47

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

2. Query Time: 0.14 ms After last query: 0.18 ms Query memory: 0.004 MB Memory before query: 0.755 MB

   DELETE 
   
     FROM `rvt_session`
   
     WHERE `time` < '1744438227'

   Explain

   EXPLAIN not possible on query: DELETE FROM `rvt_session` WHERE `time` < '1744438227'

   Profile

   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.03 ms
   Updating	0.02 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 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

   Call Stack

   #	Caller	File and line number
   6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:765
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:404
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:47

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

3. Query Time: 0.31 ms After last query: 0.25 ms Query memory: 0.039 MB Memory before query: 0.788 MB Rows returned: 42

   SELECT extension_id AS id, element AS "option", params, enabled
   
     FROM rvt_extensions
   
     WHERE `type` = 'component'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	rvt_extensions	ref	extension	extension	82	const	42	Using index condition

   Profile

   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.12 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

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
   8	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:157
   7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
   6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
   5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
   4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:584
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:50

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

4. Query Time: 0.53 ms After last query: 0.27 ms Query memory: 0.035 MB Memory before query: 0.838 MB Rows returned: 92

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	rvt_extensions	ALL	extension	NO INDEX KEY COULD BE USED	NULL	NULL	254	Using where; Using filesort

   Profile

   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.02 ms
   Statistics	0.03 ms
   Preparing	0.01 ms
   Sorting result	0.01 ms
   Executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	0.31 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

   Call Stack

   #	Caller	File and line number
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
   6	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
   5	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:163
   4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:50

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

5. Query Time: 0.20 ms After last query: 0.33 ms Query memory: 0.028 MB Memory before query: 0.922 MB Rows returned: 2

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	rvt_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where; Using filesort

   Profile

   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.00 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.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.01 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
   8	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
   7	JLanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:61
   6	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
   5	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
   4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:50

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

6. Query Time: 0.20 ms After last query: 0.12 ms Query memory: 0.024 MB Memory before query: 0.935 MB Rows returned: 3

   SELECT element
   
     FROM rvt_extensions
   
     WHERE type = 'language' 
     AND client_id = 0 
     AND enabled = 1

   Explain

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

   Profile

   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.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

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
   8	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:90
   7	JLanguageMultilang::getSiteLangs()	JROOT/plugins/system/languagefilter/languagefilter.php:72
   6	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
   5	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
   4	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/site.php:589
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:50

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

7. Query Time: 1.39 ms After last query: 2.48 ms Query memory: 0.342 MB Memory before query: 1.285 MB Rows returned: 240

   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 rvt_menu AS m
   
     LEFT JOIN rvt_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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	332	Using where; Using filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	old_rvt_lv.m.component_id	1	Using where

   Profile

   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.03 ms
   Preparing	0.02 ms
   Sorting result	0.01 ms
   Executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	1.15 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

   Call Stack

   #	Caller	File and line number
   20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
   19	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
   18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
   17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
   16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:133
   15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:435
   14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
   13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
   12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:196
   11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:531
   10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
   9	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:99
   8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
   5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:663
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:663
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:50

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

8. Query Time: 0.21 ms After last query: 6.09 ms Query memory: 0.026 MB Memory before query: 3.417 MB Rows returned: 1

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

   Explain

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

   Profile

   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.04 ms
   Preparing	0.02 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.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.01 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File and line number
   13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
   12	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/cache/controller/callback.php:157
   11	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
   10	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
   9	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
   8	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
   7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:737
   6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
   5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:991
   4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
   3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:50

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

9. Query Time: 0.18 ms After last query: 0.13 ms Query memory: 0.007 MB Memory before query: 3.411 MB

   UPDATE `rvt_extensions`
   
     SET `params` = '{\"mediaversion\":\"2c957b7bde7362c1dd90d6e1b22bd367\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

   EXPLAIN not possible on query: UPDATE `rvt_extensions` SET `params` = '{\"mediaversion\":\"2c957b7bde7362c1dd90d6e1b22bd367\"}' WHERE `type` = 'library' AND `element` = 'joomla'

   Profile

   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.04 ms
   Updating	0.03 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.01 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

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
   9	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
   8	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
   7	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:737
   6	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
   5	JFactory::getDocument()	JROOT/libraries/joomla/application/web.php:991
   4	JApplicationWeb->loadDocument()	JROOT/libraries/cms/application/site.php:130
   3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
   1	JApplicationCms->execute()	JROOT/index.php:50

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

10. Query Time: 0.27 ms After last query: 0.37 ms Query memory: 0.023 MB Memory before query: 3.483 MB Rows returned: 4

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	old_rvt_lv.s.template,const	1	Using index condition; Using where

    Profile

    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.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.05 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

    Call Stack

    #	Caller	File and line number
    6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
    4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

11. Query Time: 0.20 ms After last query: 3.14 ms Query memory: 0.027 MB Memory before query: 3.904 MB Rows returned: 3

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	4	Using where; Using filesort

    Profile

    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.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.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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_phocagallery/libraries/phocagallery/render/renderfront.php:722
    11	PhocaGalleryRenderFront::renderAllCSS()	JROOT/components/com_phocagallery/views/category/view.html.php:63
    10	PhocaGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:690
    9	JControllerLegacy->display()	JROOT/components/com_phocagallery/controller.php:30
    8	PhocaGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_phocagallery/phocagallery.php:56
    6	require_once JROOT/components/com_phocagallery/phocagallery.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

12. Query Time: 0.19 ms After last query: 0.36 ms Query memory: 0.031 MB Memory before query: 3.931 MB Rows returned: 0

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    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.01 ms
    Preparing	0.01 ms
    Executing	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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
    13	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_phocagallery/libraries/phocagallery/facebook/fbsystem.php:46
    12	PhocaGalleryFbSystem::getFbUserInfo()	JROOT/administrator/components/com_phocagallery/libraries/phocagallery/facebook/fbsystem.php:53
    11	PhocaGalleryFbSystem::getCommentsParams()	JROOT/components/com_phocagallery/views/category/view.html.php:203
    10	PhocaGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:690
    9	JControllerLegacy->display()	JROOT/components/com_phocagallery/controller.php:30
    8	PhocaGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_phocagallery/phocagallery.php:56
    6	require_once JROOT/components/com_phocagallery/phocagallery.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

13. Query Time: 0.22 ms After last query: 0.57 ms Query memory: 0.032 MB Memory before query: 4.021 MB Rows returned: 1

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

    Explain

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

    Profile

    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.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.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
    14	JDatabaseDriver->loadObject()	JROOT/components/com_phocagallery/models/category.php:227
    13	PhocagalleryModelCategory->_loadCategory()	JROOT/components/com_phocagallery/models/category.php:184
    12	PhocagalleryModelCategory->getCategory()	JROOT/libraries/legacy/view/legacy.php:401
    11	JViewLegacy->get()	JROOT/components/com_phocagallery/views/category/view.html.php:374
    10	PhocaGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:690
    9	JControllerLegacy->display()	JROOT/components/com_phocagallery/controller.php:30
    8	PhocaGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_phocagallery/phocagallery.php:56
    6	require_once JROOT/components/com_phocagallery/phocagallery.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

14. Query Time: 0.18 ms After last query: 0.07 ms Query memory: 0.038 MB Memory before query: 4.035 MB Rows returned: 0

    SELECT * 
      FROM rvt_phocagallery_categories AS c 
      WHERE c.id = 0 
      AND c.published = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    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.01 ms
    Preparing	0.00 ms
    Executing	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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_phocagallery/views/category/view.html.php:2109
    11	PhocaGalleryViewCategory->_addBreadCrumbs()	JROOT/components/com_phocagallery/views/category/view.html.php:424
    10	PhocaGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:690
    9	JControllerLegacy->display()	JROOT/components/com_phocagallery/controller.php:30
    8	PhocaGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_phocagallery/phocagallery.php:56
    6	require_once JROOT/components/com_phocagallery/phocagallery.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

15. Query Time: 0.19 ms After last query: 0.42 ms Query memory: 0.029 MB Memory before query: 4.053 MB Rows returned: 0

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    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.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    End of update loop	0.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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1653
    13	JDatabaseDriver->loadObject()	JROOT/components/com_phocagallery/models/category.php:255
    12	PhocagalleryModelCategory->getParentCategory()	JROOT/libraries/legacy/view/legacy.php:401
    11	JViewLegacy->get()	JROOT/components/com_phocagallery/views/category/view.html.php:569
    10	PhocaGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:690
    9	JControllerLegacy->display()	JROOT/components/com_phocagallery/controller.php:30
    8	PhocaGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_phocagallery/phocagallery.php:56
    6	require_once JROOT/components/com_phocagallery/phocagallery.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

16. Query Time: 0.78 ms After last query: 0.06 ms Query memory: 0.030 MB Memory before query: 4.062 MB Rows returned: 0

    SELECT cc.id, cc.title, cc.alias, cc.published, cc.approved, cc.parent_id, cc.deleteuserid, cc.accessuserid, cc.uploaduserid, cc.access, a.filename, a.extm, a.exts, a.extw, a.exth, a.extid 
      FROM rvt_phocagallery_categories AS cc 
      LEFT JOIN rvt_phocagallery AS a 
      ON cc.id = a.catid 
      WHERE cc.parent_id = 256 
      AND cc.published = 1 
      AND cc.approved = 1 
      AND cc.id <> 256 
      AND cc.language IN ('lv-LV','*') 
      GROUP BY cc.id 
      ORDER BY cc.ordering DESC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cc	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	400	Using where; Using temporary; Using filesort
    1	SIMPLE	a	ref	catid	catid	4	old_rvt_lv.cc.id	31

    Profile

    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.03 ms
    Optimizing	0.02 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Creating tmp table	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.42 ms
    Creating sort index	0.03 ms
    Removing tmp table	0.08 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.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_phocagallery/models/category.php:297
    12	PhocagalleryModelCategory->getSubCategory()	JROOT/libraries/legacy/view/legacy.php:401
    11	JViewLegacy->get()	JROOT/components/com_phocagallery/views/category/view.html.php:727
    10	PhocaGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:690
    9	JControllerLegacy->display()	JROOT/components/com_phocagallery/controller.php:30
    8	PhocaGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_phocagallery/phocagallery.php:56
    6	require_once JROOT/components/com_phocagallery/phocagallery.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

17. Query Time: 0.66 ms After last query: 0.07 ms Query memory: 0.052 MB Memory before query: 4.073 MB Rows returned: 15

    SELECT a.*, cc.alias AS catalias, cc.accessuserid AS cataccessuserid, cc.access AS cataccess, 
      CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
      FROM rvt_phocagallery AS a 
      LEFT JOIN rvt_phocagallery_img_votes_statistics AS r 
      ON r.imgid = a.id 
      LEFT JOIN rvt_phocagallery_categories AS cc 
      ON cc.id = a.catid 
      WHERE  a.language IN ('lv-LV','*') 
      AND  a.catid= 256 
      AND a.published = 1 
      AND a.approved = 1 
      ORDER BY a.ordering ASC 
      LIMIT 0, 15

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	r	system	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	0	Const row not found
    1	SIMPLE	a	ref	catid	catid	5	const,const	52	Using where; Using filesort
    1	SIMPLE	cc	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.06 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.04 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.33 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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:312
    12	JModelLegacy->_getList()	JROOT/components/com_phocagallery/models/category.php:67
    11	PhocagalleryModelCategory->getData()	JROOT/components/com_phocagallery/views/category/view.html.php:944
    10	PhocaGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:690
    9	JControllerLegacy->display()	JROOT/components/com_phocagallery/controller.php:30
    8	PhocaGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_phocagallery/phocagallery.php:56
    6	require_once JROOT/components/com_phocagallery/phocagallery.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

18. Query Time: 0.48 ms After last query: 0.14 ms Query memory: 0.030 MB Memory before query: 4.222 MB Rows returned: 53

    SELECT a.id 
      FROM rvt_phocagallery AS a 
      LEFT JOIN rvt_phocagallery_categories AS cc 
      ON cc.id = a.catid 
      WHERE  a.language IN ('lv-LV','*') 
      AND  a.catid= 256 
      AND a.published = 1 
      AND a.approved = 1 
      ORDER BY a.id

    Explain

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

    Profile

    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.03 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.25 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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/legacy/model/legacy.php:354
    13	JModelLegacy->_getListCount()	JROOT/components/com_phocagallery/models/category.php:75
    12	PhocagalleryModelCategory->getTotal()	JROOT/components/com_phocagallery/models/category.php:83
    11	PhocagalleryModelCategory->getPagination()	JROOT/components/com_phocagallery/views/category/view.html.php:946
    10	PhocaGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:690
    9	JControllerLegacy->display()	JROOT/components/com_phocagallery/controller.php:30
    8	PhocaGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_phocagallery/phocagallery.php:56
    6	require_once JROOT/components/com_phocagallery/phocagallery.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

19. Query Time: 0.61 ms After last query: 2.67 ms Query memory: 0.041 MB Memory before query: 4.284 MB Rows returned: 39

    SHOW FULL COLUMNS 
      FROM `rvt_phocagallery_categories`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `rvt_phocagallery_categories`

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.00 ms
    closing tables	0.00 ms
    Opening tables	0.18 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.12 ms
    closing tables	0.01 ms
    Executing	0.00 ms
    Sending data	0.05 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.09 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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    15	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    14	JTable->__construct()	JROOT/administrator/components/com_phocagallery/tables/phocagalleryc.php:16
    13	TablePhocaGalleryc->__construct()	JROOT/libraries/joomla/table/table.php:305
    12	JTable::getInstance()	JROOT/components/com_phocagallery/models/category.php:557
    11	PhocagalleryModelCategory->hit()	JROOT/components/com_phocagallery/views/category/view.html.php:1893
    10	PhocaGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:690
    9	JControllerLegacy->display()	JROOT/components/com_phocagallery/controller.php:30
    8	PhocaGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_phocagallery/phocagallery.php:56
    6	require_once JROOT/components/com_phocagallery/phocagallery.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

20. Query Time: 0.17 ms After last query: 0.21 ms Query memory: 0.009 MB Memory before query: 4.368 MB

    UPDATE rvt_phocagallery_categories
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '256'

    Explain

    EXPLAIN not possible on query: UPDATE rvt_phocagallery_categories SET `hits` = (`hits` + 1) WHERE `id` = '256'

    Profile

    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.03 ms
    Updating	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.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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1249
    12	JTable->hit()	JROOT/components/com_phocagallery/models/category.php:558
    11	PhocagalleryModelCategory->hit()	JROOT/components/com_phocagallery/views/category/view.html.php:1893
    10	PhocaGalleryViewCategory->display()	JROOT/libraries/legacy/controller/legacy.php:690
    9	JControllerLegacy->display()	JROOT/components/com_phocagallery/controller.php:30
    8	PhocaGalleryController->display()	JROOT/libraries/legacy/controller/legacy.php:728
    7	JControllerLegacy->execute()	JROOT/components/com_phocagallery/phocagallery.php:56
    6	require_once JROOT/components/com_phocagallery/phocagallery.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:257
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

21. Query Time: 1.72 ms After last query: 1.46 ms Query memory: 0.149 MB Memory before query: 4.469 MB Rows returned: 232

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM rvt_modules AS m
    
      LEFT JOIN rvt_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN rvt_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-04-12 07:10:27') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-04-12 07:10:27') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 210 OR mm.menuid <= 0) 
      AND m.language IN ('lv-LV','*')
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	PRIMARY,published,newsfeeds,idx_language	NO INDEX KEY COULD BE USED	NULL	NULL	136	Using where; Using filesort
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	old_rvt_lv.m.module,const	1	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	old_rvt_lv.m.id	13	Using where; Using index

    Profile

    Status	Duration
    Starting	0.06 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.03 ms
    Optimizing	0.03 ms
    Statistics	0.09 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	1.33 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.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/module/helper.php:409
    11	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:352
    10	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
    9	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
    8	JDocumentHtml->countModules()	JROOT/templates/rvt6/index.php:60
    7	require JROOT/templates/rvt6/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:635
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1054
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

22. Query Time: 0.19 ms After last query: 8.35 ms Query memory: 0.037 MB Memory before query: 4.704 MB Rows returned: 0
    Duplicate queries: #26  #29  #32  #36  #40

    SELECT *
    
      FROM rvt_banners
    
      WHERE '2025-04-12 07:10:27' >= 'reset' 
      AND `reset` != '0000-00-00 00:00:00' 
      AND `reset`!= NULL 
      AND (`checked_out` = 0 OR `checked_out` = 0)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE

    Profile

    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.03 ms
    Optimizing	0.02 ms
    Executing	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.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
    11	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

23. Query Time: 0.32 ms After last query: 0.26 ms Query memory: 0.029 MB Memory before query: 4.733 MB Rows returned: 1

    SELECT COUNT(*)
    
      FROM rvt_banners as a
    
      LEFT JOIN rvt_banner_clients AS cl 
      ON cl.id = a.cid
    
      WHERE a.state=1 
      AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00') 
      AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00') 
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
      AND a.catid IN (186) 
      AND a.language in ('lv-LV','*')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_banner_catid,idx_language	idx_banner_catid	4	const	1	Using where

    Profile

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.03 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.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
    17	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:341
    16	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:290
    15	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:324
    14	JModelList->getStart()	JROOT/libraries/legacy/model/list.php:185
    13	JModelList->getItems()	JROOT/components/com_banners/models/banners.php:203
    12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:44
    11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

24. Query Time: 0.33 ms After last query: 0.06 ms Query memory: 0.030 MB Memory before query: 4.740 MB Rows returned: 1

    SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
    
      FROM rvt_banners as a
    
      LEFT JOIN rvt_banner_clients AS cl 
      ON cl.id = a.cid
    
      WHERE a.state=1 
      AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00') 
      AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00') 
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
      AND a.catid IN (186) 
      AND a.language in ('lv-LV','*')
    
      ORDER BY a.sticky DESC,a.ordering 
      LIMIT 0, 5

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_banner_catid,idx_language	idx_banner_catid	4	const	1	Using where; Using filesort
    1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	old_rvt_lv.a.cid	1

    Profile

    Status	Duration
    Starting	0.06 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.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.05 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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:312
    14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:185
    13	JModelList->getItems()	JROOT/components/com_banners/models/banners.php:203
    12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:44
    11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

25. Query Time: 0.70 ms After last query: 0.10 ms Query memory: 0.009 MB Memory before query: 4.756 MB

    UPDATE rvt_banners
    
      SET impmade = (impmade + 1)
    
      WHERE id = 14

    Explain

    EXPLAIN not possible on query: UPDATE rvt_banners SET impmade = (impmade + 1) WHERE id = 14

    Profile

    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 for update	0.04 ms
    Updating	0.04 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.51 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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:242
    12	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:45
    11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

26. Query Time: 0.19 ms After last query: 0.31 ms Query memory: 0.037 MB Memory before query: 4.759 MB Rows returned: 0
    Duplicate queries: #22  #29  #32  #36  #40

    SELECT *
    
      FROM rvt_banners
    
      WHERE '2025-04-12 07:10:27' >= 'reset' 
      AND `reset` != '0000-00-00 00:00:00' 
      AND `reset`!= NULL 
      AND (`checked_out` = 0 OR `checked_out` = 0)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE

    Profile

    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.03 ms
    Optimizing	0.02 ms
    Executing	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.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
    11	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

27. Query Time: 0.30 ms After last query: 0.16 ms Query memory: 0.029 MB Memory before query: 4.779 MB Rows returned: 1

    SELECT COUNT(*)
    
      FROM rvt_banners as a
    
      LEFT JOIN rvt_banner_clients AS cl 
      ON cl.id = a.cid
    
      WHERE a.state=1 
      AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00') 
      AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00') 
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
      AND a.catid IN (3) 
      AND a.language in ('lv-LV','*')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_banner_catid,idx_language	idx_banner_catid	4	const	1	Using where

    Profile

    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.02 ms
    Statistics	0.06 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.03 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.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
    17	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:341
    16	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:290
    15	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:324
    14	JModelList->getStart()	JROOT/libraries/legacy/model/list.php:185
    13	JModelList->getItems()	JROOT/components/com_banners/models/banners.php:203
    12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:44
    11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

28. Query Time: 0.31 ms After last query: 0.06 ms Query memory: 0.030 MB Memory before query: 4.786 MB Rows returned: 0

    SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
    
      FROM rvt_banners as a
    
      LEFT JOIN rvt_banner_clients AS cl 
      ON cl.id = a.cid
    
      WHERE a.state=1 
      AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00') 
      AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00') 
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
      AND a.catid IN (3) 
      AND a.language in ('lv-LV','*')
    
      ORDER BY a.sticky DESC,a.ordering 
      LIMIT 0, 5

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_banner_catid,idx_language	idx_banner_catid	4	const	1	Using where; Using filesort
    1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	old_rvt_lv.a.cid	1

    Profile

    Status	Duration
    Starting	0.06 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.03 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.03 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.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:312
    14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:185
    13	JModelList->getItems()	JROOT/components/com_banners/models/banners.php:203
    12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:44
    11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

29. Query Time: 0.17 ms After last query: 0.22 ms Query memory: 0.037 MB Memory before query: 4.794 MB Rows returned: 0
    Duplicate queries: #22  #26  #32  #36  #40

    SELECT *
    
      FROM rvt_banners
    
      WHERE '2025-04-12 07:10:27' >= 'reset' 
      AND `reset` != '0000-00-00 00:00:00' 
      AND `reset`!= NULL 
      AND (`checked_out` = 0 OR `checked_out` = 0)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE

    Profile

    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.03 ms
    Optimizing	0.01 ms
    Executing	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.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
    11	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

30. Query Time: 0.27 ms After last query: 0.15 ms Query memory: 0.029 MB Memory before query: 4.814 MB Rows returned: 1

    SELECT COUNT(*)
    
      FROM rvt_banners as a
    
      LEFT JOIN rvt_banner_clients AS cl 
      ON cl.id = a.cid
    
      WHERE a.state=1 
      AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00') 
      AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00') 
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
      AND a.catid IN (245) 
      AND a.language in ('lv-LV','*')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_banner_catid,idx_language	idx_banner_catid	4	const	1	Using where

    Profile

    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.02 ms
    Statistics	0.05 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.02 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.02 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
    17	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:341
    16	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:290
    15	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:324
    14	JModelList->getStart()	JROOT/libraries/legacy/model/list.php:185
    13	JModelList->getItems()	JROOT/components/com_banners/models/banners.php:203
    12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:44
    11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

31. Query Time: 0.31 ms After last query: 0.06 ms Query memory: 0.030 MB Memory before query: 4.821 MB Rows returned: 0

    SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
    
      FROM rvt_banners as a
    
      LEFT JOIN rvt_banner_clients AS cl 
      ON cl.id = a.cid
    
      WHERE a.state=1 
      AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00') 
      AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00') 
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
      AND a.catid IN (245) 
      AND a.language in ('lv-LV','*')
    
      ORDER BY a.sticky DESC,a.ordering 
      LIMIT 0, 5

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_banner_catid,idx_language	idx_banner_catid	4	const	1	Using where; Using filesort
    1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	old_rvt_lv.a.cid	1

    Profile

    Status	Duration
    Starting	0.06 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.03 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.03 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.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:312
    14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:185
    13	JModelList->getItems()	JROOT/components/com_banners/models/banners.php:203
    12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:44
    11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

32. Query Time: 0.17 ms After last query: 0.20 ms Query memory: 0.037 MB Memory before query: 4.828 MB Rows returned: 0
    Duplicate queries: #22  #26  #29  #36  #40

    SELECT *
    
      FROM rvt_banners
    
      WHERE '2025-04-12 07:10:27' >= 'reset' 
      AND `reset` != '0000-00-00 00:00:00' 
      AND `reset`!= NULL 
      AND (`checked_out` = 0 OR `checked_out` = 0)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE

    Profile

    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.02 ms
    Executing	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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
    11	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

33. Query Time: 0.27 ms After last query: 0.15 ms Query memory: 0.030 MB Memory before query: 4.855 MB Rows returned: 1

    SELECT COUNT(*)
    
      FROM rvt_banners as a
    
      LEFT JOIN rvt_banner_clients AS cl 
      ON cl.id = a.cid
    
      WHERE a.state=1 
      AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00') 
      AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00') 
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
      AND a.catid IN (253) 
      AND a.language in ('lv-LV','*')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_banner_catid,idx_language	idx_banner_catid	4	const	1	Using where

    Profile

    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.02 ms
    Statistics	0.04 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.02 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.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
    17	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:341
    16	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:290
    15	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:324
    14	JModelList->getStart()	JROOT/libraries/legacy/model/list.php:185
    13	JModelList->getItems()	JROOT/components/com_banners/models/banners.php:203
    12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:44
    11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

34. Query Time: 0.33 ms After last query: 0.06 ms Query memory: 0.030 MB Memory before query: 4.863 MB Rows returned: 1

    SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
    
      FROM rvt_banners as a
    
      LEFT JOIN rvt_banner_clients AS cl 
      ON cl.id = a.cid
    
      WHERE a.state=1 
      AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00') 
      AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00') 
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
      AND a.catid IN (253) 
      AND a.language in ('lv-LV','*')
    
      ORDER BY a.sticky DESC,a.ordering 
      LIMIT 0, 5

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_banner_catid,idx_language	idx_banner_catid	4	const	1	Using where; Using filesort
    1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	old_rvt_lv.a.cid	1

    Profile

    Status	Duration
    Starting	0.06 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.03 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	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.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:312
    14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:185
    13	JModelList->getItems()	JROOT/components/com_banners/models/banners.php:203
    12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:44
    11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

35. Query Time: 0.51 ms After last query: 0.08 ms Query memory: 0.009 MB Memory before query: 4.879 MB

    UPDATE rvt_banners
    
      SET impmade = (impmade + 1)
    
      WHERE id = 17

    Explain

    EXPLAIN not possible on query: UPDATE rvt_banners SET impmade = (impmade + 1) WHERE id = 17

    Profile

    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.03 ms
    Updating	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.36 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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:242
    12	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:45
    11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

36. Query Time: 0.16 ms After last query: 0.26 ms Query memory: 0.037 MB Memory before query: 4.879 MB Rows returned: 0
    Duplicate queries: #22  #26  #29  #32  #40

    SELECT *
    
      FROM rvt_banners
    
      WHERE '2025-04-12 07:10:27' >= 'reset' 
      AND `reset` != '0000-00-00 00:00:00' 
      AND `reset`!= NULL 
      AND (`checked_out` = 0 OR `checked_out` = 0)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE

    Profile

    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.03 ms
    Optimizing	0.02 ms
    Executing	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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
    11	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

37. Query Time: 0.27 ms After last query: 0.15 ms Query memory: 0.029 MB Memory before query: 4.899 MB Rows returned: 1

    SELECT COUNT(*)
    
      FROM rvt_banners as a
    
      LEFT JOIN rvt_banner_clients AS cl 
      ON cl.id = a.cid
    
      WHERE a.state=1 
      AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00') 
      AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00') 
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
      AND a.catid IN (160) 
      AND a.language in ('lv-LV','*')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_banner_catid,idx_language	idx_banner_catid	4	const	1	Using where

    Profile

    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.02 ms
    Statistics	0.05 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.02 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.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
    17	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:341
    16	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:290
    15	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:324
    14	JModelList->getStart()	JROOT/libraries/legacy/model/list.php:185
    13	JModelList->getItems()	JROOT/components/com_banners/models/banners.php:203
    12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:44
    11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

38. Query Time: 0.33 ms After last query: 0.06 ms Query memory: 0.030 MB Memory before query: 4.906 MB Rows returned: 1

    SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
    
      FROM rvt_banners as a
    
      LEFT JOIN rvt_banner_clients AS cl 
      ON cl.id = a.cid
    
      WHERE a.state=1 
      AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00') 
      AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00') 
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
      AND a.catid IN (160) 
      AND a.language in ('lv-LV','*')
    
      ORDER BY a.sticky DESC,a.ordering 
      LIMIT 0, 5

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_banner_catid,idx_language	idx_banner_catid	4	const	1	Using where; Using filesort
    1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	old_rvt_lv.a.cid	1

    Profile

    Status	Duration
    Starting	0.06 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.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.03 ms
    Sorting result	0.02 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	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.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:312
    14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:185
    13	JModelList->getItems()	JROOT/components/com_banners/models/banners.php:203
    12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:44
    11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

39. Query Time: 0.51 ms After last query: 0.08 ms Query memory: 0.009 MB Memory before query: 4.922 MB

    UPDATE rvt_banners
    
      SET impmade = (impmade + 1)
    
      WHERE id = 9

    Explain

    EXPLAIN not possible on query: UPDATE rvt_banners SET impmade = (impmade + 1) WHERE id = 9

    Profile

    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.03 ms
    Updating	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.35 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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:242
    12	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:45
    11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

40. Query Time: 0.17 ms After last query: 0.25 ms Query memory: 0.037 MB Memory before query: 4.923 MB Rows returned: 0
    Duplicate queries: #22  #26  #29  #32  #36

    SELECT *
    
      FROM rvt_banners
    
      WHERE '2025-04-12 07:10:27' >= 'reset' 
      AND `reset` != '0000-00-00 00:00:00' 
      AND `reset`!= NULL 
      AND (`checked_out` = 0 OR `checked_out` = 0)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE

    Profile

    Status	Duration
    Starting	0.02 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.02 ms
    Optimizing	0.02 ms
    Executing	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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
    11	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

41. Query Time: 0.27 ms After last query: 0.16 ms Query memory: 0.029 MB Memory before query: 4.943 MB Rows returned: 1

    SELECT COUNT(*)
    
      FROM rvt_banners as a
    
      LEFT JOIN rvt_banner_clients AS cl 
      ON cl.id = a.cid
    
      WHERE a.state=1 
      AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00') 
      AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00') 
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
      AND a.catid IN (170) 
      AND a.language in ('lv-LV','*')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_banner_catid,idx_language	idx_banner_catid	4	const	1	Using where

    Profile

    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.02 ms
    Statistics	0.05 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.02 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.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1731
    17	JDatabaseDriver->loadResult()	JROOT/libraries/legacy/model/legacy.php:341
    16	JModelLegacy->_getListCount()	JROOT/libraries/legacy/model/list.php:290
    15	JModelList->getTotal()	JROOT/libraries/legacy/model/list.php:324
    14	JModelList->getStart()	JROOT/libraries/legacy/model/list.php:185
    13	JModelList->getItems()	JROOT/components/com_banners/models/banners.php:203
    12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:44
    11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

42. Query Time: 0.32 ms After last query: 0.06 ms Query memory: 0.030 MB Memory before query: 4.950 MB Rows returned: 1

    SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
    
      FROM rvt_banners as a
    
      LEFT JOIN rvt_banner_clients AS cl 
      ON cl.id = a.cid
    
      WHERE a.state=1 
      AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00') 
      AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00') 
      AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
      AND a.catid IN (170) 
      AND a.language in ('lv-LV','*')
    
      ORDER BY a.sticky DESC,a.ordering 
      LIMIT 0, 5

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_banner_catid,idx_language	idx_banner_catid	4	const	1	Using where; Using filesort
    1	SIMPLE	cl	eq_ref	PRIMARY	PRIMARY	4	old_rvt_lv.a.cid	1

    Profile

    Status	Duration
    Starting	0.06 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.03 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	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.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:312
    14	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:185
    13	JModelList->getItems()	JROOT/components/com_banners/models/banners.php:203
    12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:44
    11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

43. Query Time: 0.46 ms After last query: 0.09 ms Query memory: 0.009 MB Memory before query: 4.966 MB

    UPDATE rvt_banners
    
      SET impmade = (impmade + 1)
    
      WHERE id = 12

    Explain

    EXPLAIN not possible on query: UPDATE rvt_banners SET impmade = (impmade + 1) WHERE id = 12

    Profile

    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.03 ms
    Updating	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.31 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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:242
    12	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:45
    11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
    10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

44. Query Time: 0.24 ms After last query: 4.28 ms Query memory: 0.027 MB Memory before query: 5.027 MB Rows returned: 0

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `rvt_menu` AS `c`
    
      INNER JOIN `rvt_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item'
    
      INNER JOIN `rvt_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `rvt_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 210

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    Status	Duration
    Starting	0.04 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.02 ms
    Optimizing	0.02 ms
    Statistics	0.05 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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1692
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
    13	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:319
    12	MenusHelper::getAssociations()	JROOT/modules/mod_languages/helper.php:62
    11	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:18
    10	include JROOT/modules/mod_languages/mod_languages.php	JROOT/libraries/cms/module/helper.php:190
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:697
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1068
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:745
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:263
    1	JApplicationCms->execute()	JROOT/index.php:50

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---