Movie Trailers

Joomla! Debug Console

Session

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

Profile Information

Time

Memory

Time: 29.49 ms / 29.49 ms Memory: 1.909 MB / 2.13 MB Application: afterLoad

Time: 139.19 ms / 168.68 ms Memory: 6.078 MB / 8.21 MB Application: afterInitialise

Time: 46.23 ms / 214.91 ms Memory: 2.360 MB / 10.57 MB Application: afterRoute

Time: 12.84 ms / 227.75 ms Memory: 0.517 MB / 11.09 MB Application: beforeRenderComponent com_spmoviedb

Time: 47.78 ms / 275.53 ms Memory: 3.128 MB / 14.22 MB Application: Before Access::preloadComponents (all components)

Time: 2.22 ms / 277.76 ms Memory: 0.098 MB / 14.31 MB Application: After Access::preloadComponents (all components)

Time: 0.11 ms / 277.86 ms Memory: 0.000 MB / 14.31 MB Application: Before Access::getAssetRules (id:261 name:com_spmoviedb)

Time: 1.17 ms / 279.03 ms Memory: 0.046 MB / 14.35 MB Application: After Access::getAssetRules (id:261 name:com_spmoviedb)

Time: 241.45 ms / 520.48 ms Memory: 5.313 MB / 19.67 MB Application: afterRenderComponent com_spmoviedb

Time: 3.22 ms / 523.70 ms Memory: 0.150 MB / 19.82 MB Application: afterDispatch

Time: 95.55 ms / 619.25 ms Memory: 2.347 MB / 22.16 MB Application: beforeRenderModule mod_search (Search)

Time: 2.89 ms / 622.14 ms Memory: 0.057 MB / 22.22 MB Application: afterRenderModule mod_search (Search)

Time: 0.10 ms / 622.24 ms Memory: 0.000 MB / 22.21 MB Application: beforeRenderModule mod_menu (Off Canvas Menu)

Time: 7.69 ms / 629.93 ms Memory: 0.104 MB / 22.32 MB Application: afterRenderModule mod_menu (Off Canvas Menu)

Time: 0.26 ms / 630.18 ms Memory: 0.000 MB / 22.31 MB Application: beforeRenderModule mod_menu (Footer Menu)

Time: 2.17 ms / 632.36 ms Memory: 0.033 MB / 22.34 MB Application: afterRenderModule mod_menu (Footer Menu)

Time: 0.14 ms / 632.50 ms Memory: 0.000 MB / 22.33 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 3.82 ms / 636.32 ms Memory: 0.079 MB / 22.41 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.26 ms / 636.58 ms Memory: 0.000 MB / 22.40 MB Application: beforeRenderModule mod_login (Login (Header))

Time: 5.68 ms / 642.26 ms Memory: 0.154 MB / 22.56 MB Application: afterRenderModule mod_login (Login (Header))

Time: 0.16 ms / 642.42 ms Memory: 0.000 MB / 22.55 MB Application: beforeRenderModule mod_spmoviedb_search (SP Movie Database Search)

Time: 4.84 ms / 647.26 ms Memory: 0.100 MB / 22.65 MB Application: afterRenderModule mod_spmoviedb_search (SP Movie Database Search)

Time: 6.25 ms / 653.51 ms Memory: 0.157 MB / 22.81 MB Application: afterRender

Database queries total: 71.68 ms

Memory Usage

Database Queries

75 Queries Logged 71.68 ms

39 duplicate found!

3 duplicates: #23 #24 #58

20 duplicates: #26 #30 #34 #38 #42 #46 #50 #54 #60 #61 #62 #63 #64 #65 #66 #67 #68 #69 #70 #73

2 duplicates: #27 #29

2 duplicates: #31 #33

2 duplicates: #35 #37

2 duplicates: #39 #41

2 duplicates: #43 #45

6 duplicates: #47 #49 #51 #53 #55 #57

Query Time: 0.73 ms

SELECT `session_id`

  FROM `bfcc_session`

  WHERE `session_id` = '793f32113f0f809bf04ebe4c4a197944' 
  LIMIT 1

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:343
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 10.47 ms After last query: 0.28 ms

INSERT INTO `bfcc_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('793f32113f0f809bf04ebe4c4a197944', 1, '1531874108', 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `bfcc_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('793f32113f0f809bf04ebe4c4a197944', 1, '1531874108', 0, '', 0)

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysql->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:343
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Query Time: 6.34 ms After last query: 6.02 ms

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `bfcc_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bfcc_extensions	ref	extension	extension	82	const	38	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:423
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:431
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:497
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:596
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.59 ms After last query: 6.27 ms

SELECT id, rules

  FROM `bfcc_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bfcc_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1496
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:310
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.50 ms After last query: 0.30 ms

SELECT b.id

  FROM bfcc_usergroups AS a

  LEFT JOIN bfcc_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 13

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

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1540
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:310
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.85 ms After last query: 1.28 ms

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM bfcc_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	bfcc_extensions	ref	extension	extension	82	const	98	Using where; Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:343
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:348
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.67 ms After last query: 12.60 ms

SELECT `path`

  FROM bfcc_rsfirewall_ignored

  WHERE `type`='ignore_folder' OR `type`='ignore_file'

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1540
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:53
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:28
7	plgSystemRSFirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.49 ms After last query: 0.19 ms

SELECT `file`

  FROM bfcc_rsfirewall_hashes

  WHERE `type`='protect'

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1540
11	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:60
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:28
7	plgSystemRSFirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.60 ms After last query: 0.19 ms

SELECT *

  FROM bfcc_rsfirewall_configuration

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bfcc_rsfirewall_configuration	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	52

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:68
10	RSFirewallConfig->load()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:19
9	RSFirewallConfig->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/config.php:161
8	RSFirewallConfig::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:28
7	plgSystemRSFirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 2.21 ms After last query: 12.60 ms

SHOW FULL COLUMNS 
  FROM `bfcc_rsfirewall_logs`

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_rsfirewall/tables/logs.php:36
11	RsfirewallTableLogs->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:23
9	RSFirewallLogger->__construct()	JROOT/administrator/components/com_rsfirewall/helpers/log.php:57
8	RSFirewallLogger::getInstance()	JROOT/plugins/system/rsfirewall/rsfirewall.php:50
7	plgSystemRSFirewall->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:272
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.81 ms After last query: 43.12 ms

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 bfcc_menu AS m

  LEFT JOIN bfcc_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	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	68	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	blackfil_2016.m.component_id	1

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:374
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:488
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:405
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1070
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.64 ms After last query: 33.33 ms

SELECT *

  FROM bfcc_rsfirewall_hashes

  WHERE (`type`='3.8.8' OR `type`='protect') 
  AND `flag`!='C'

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1026
9	plgSystemRSFirewall->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.45 ms After last query: 0.75 ms

SELECT *

  FROM bfcc_rsfirewall_snapshots

  WHERE `type`='protect'

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsfirewall/helpers/snapshot.php:47
10	RSFirewallSnapshot::get()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1049
9	plgSystemRSFirewall->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.47 ms After last query: 0.30 ms

SELECT `ip`,`reason`

  FROM bfcc_rsfirewall_lists

  WHERE (`ip`='54.158.248.112' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='1' 
  AND `published`='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bfcc_rsfirewall_lists	ref	published,type,ip	published	1	const	1	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:169
11	plgSystemRSFirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:148
10	plgSystemRSFirewall->isWhitelisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1085
9	plgSystemRSFirewall->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 0.55 ms

SELECT `ip`,`reason`

  FROM bfcc_rsfirewall_lists

  WHERE (`ip`='54.158.248.112' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') 
  AND `type`='0' 
  AND `published`='1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bfcc_rsfirewall_lists	ref	published,type,ip	published	1	const	1	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:169
11	plgSystemRSFirewall->isListed()	JROOT/plugins/system/rsfirewall/rsfirewall.php:138
10	plgSystemRSFirewall->isBlacklisted()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1089
9	plgSystemRSFirewall->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.44 ms After last query: 1.59 ms

SELECT *

  FROM bfcc_rsfirewall_exceptions

  WHERE `published`='1'

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rsfirewall/rsfirewall.php:682
10	plgSystemRSFirewall->isException()	JROOT/plugins/system/rsfirewall/rsfirewall.php:1142
9	plgSystemRSFirewall->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1080
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.54 ms After last query: 1.16 ms

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `bfcc_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bfcc_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1113
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 3.11 ms After last query: 0.37 ms

UPDATE `bfcc_extensions`

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

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

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysql->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1113
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.56 ms After last query: 3.76 ms

SELECT *

  FROM bfcc_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.64 ms After last query: 0.59 ms

SELECT id, home, template, s.params

  FROM bfcc_template_styles as s

  LEFT JOIN bfcc_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	blackfil_2016.s.template,const	1	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:488
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.34 ms After last query: 50.74 ms

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `bfcc_assets`

  WHERE `name` IN ('root.1','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyblog','com_fields','com_finder','com_imagerecycle','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_rsfirewall','com_search','com_spmoviedb','com_sppagebuilder','com_tags','com_templates','com_users','com_wrapper')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bfcc_assets	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	199	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
21	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
20	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
19	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
18	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
17	Joomla\CMS\User\User->authorise()	JROOT/libraries/fof/integration/joomla/platform.php:584
16	FOFIntegrationJoomlaPlatform->authorise()	JROOT/libraries/fof/view/raw.php:80
15	FOFViewRaw->__construct()	JROOT/libraries/fof/view/html.php:53
14	FOFViewHtml->__construct()	JROOT/libraries/fof/controller/controller.php:2805
13	FOFController->createView()	JROOT/libraries/fof/controller/controller.php:2500
12	FOFController->getView()	JROOT/libraries/fof/controller/controller.php:2402
11	FOFController->getThisView()	JROOT/libraries/fof/controller/controller.php:1025
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.68 ms After last query: 3.94 ms

SHOW TABLES

Explain

EXPLAIN not possible on query: SHOW TABLES

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1540
25	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:487
24	JDatabaseDriverMysqli->getTableList()	JROOT/libraries/fof/database/driver/joomla.php:251
23	FOFDatabaseDriverJoomla->getTableList()	JROOT/libraries/fof/table/table.php:2085
22	FOFTable->getTableFields()	JROOT/libraries/fof/table/table.php:536
21	FOFTable->__construct()	JROOT/libraries/fof/table/table.php:433
20	FOFTable::getAnInstance()	JROOT/libraries/fof/model/model.php:2037
19	FOFModel->_createTable()	JROOT/libraries/fof/model/model.php:1994
18	FOFModel->getTable()	JROOT/libraries/fof/model/behavior/filters.php:30
17	FOFModelBehaviorFilters->onAfterBuildQuery()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/fof/utils/observable/event.php:63
15	FOFUtilsObservableEvent->update()	JROOT/libraries/fof/utils/observable/dispatcher.php:146
14	FOFUtilsObservableDispatcher->trigger()	JROOT/components/com_spmoviedb/models/trailers.php:56
13	SpmoviedbModelTrailers->buildQuery()	JROOT/libraries/fof/model/model.php:1219
12	FOFModel->getItemList()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:18
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.93 ms After last query: 0.49 ms

Duplicate queries: #24 #58

SHOW FULL COLUMNS 
  FROM `bfcc_spmoviedb_movies`

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/fof/database/driver/joomla.php:229
23	FOFDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/fof/table/table.php:2170
22	FOFTable->getTableFields()	JROOT/libraries/fof/table/table.php:536
21	FOFTable->__construct()	JROOT/libraries/fof/table/table.php:433
20	FOFTable::getAnInstance()	JROOT/libraries/fof/model/model.php:2037
19	FOFModel->_createTable()	JROOT/libraries/fof/model/model.php:1994
18	FOFModel->getTable()	JROOT/libraries/fof/model/behavior/filters.php:30
17	FOFModelBehaviorFilters->onAfterBuildQuery()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/fof/utils/observable/event.php:63
15	FOFUtilsObservableEvent->update()	JROOT/libraries/fof/utils/observable/dispatcher.php:146
14	FOFUtilsObservableDispatcher->trigger()	JROOT/components/com_spmoviedb/models/trailers.php:56
13	SpmoviedbModelTrailers->buildQuery()	JROOT/libraries/fof/model/model.php:1219
12	FOFModel->getItemList()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:18
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.81 ms After last query: 3.85 ms

Duplicate queries: #23 #58

SHOW FULL COLUMNS 
  FROM `bfcc_spmoviedb_movies`

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/fof/database/driver/joomla.php:229
19	FOFDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/fof/model/model.php:2129
18	FOFModel->getTableFields()	JROOT/libraries/fof/model/behavior/filters.php:37
17	FOFModelBehaviorFilters->onAfterBuildQuery()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/fof/utils/observable/event.php:63
15	FOFUtilsObservableEvent->update()	JROOT/libraries/fof/utils/observable/dispatcher.php:146
14	FOFUtilsObservableDispatcher->trigger()	JROOT/components/com_spmoviedb/models/trailers.php:56
13	SpmoviedbModelTrailers->buildQuery()	JROOT/libraries/fof/model/model.php:1219
12	FOFModel->getItemList()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:18
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.40 ms After last query: 68.94 ms

SELECT a.*

  FROM `bfcc_spmoviedb_movies` AS `a`

  WHERE `a`.`enabled` = '1' 
  AND `trailer_one`!="" 
  AND a.language in ('en-GB','*') 
  AND `a`.`access` IN (1,1)

  ORDER BY `a`.`release_date` DESC 
  LIMIT 0, 8

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	19	Using where; Using filesort

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/fof/database/driver/joomla.php:321
14	FOFDatabaseDriverJoomla->loadObjectList()	JROOT/libraries/fof/model/model.php:1953
13	FOFModel->_getList()	JROOT/libraries/fof/model/model.php:1225
12	FOFModel->getItemList()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:18
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.85 ms After last query: 6.71 ms

Duplicate queries: #30 #34 #38 #42 #46 #50 #54 #60 #61 #62 #63 #64 #65 #66 #67 #68 #69 #70 #73

SELECT `id`

  FROM `bfcc_menu`

  WHERE `link` LIKE '%option=com_spmoviedb&view=movies%' 
  AND `published` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bfcc_menu	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	110	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
13	JDatabaseDriver->loadResult()	JROOT/components/com_spmoviedb/helpers/helper.php:22
12	SpmoviedbHelper::getItemid()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:24
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.47 ms After last query: 0.59 ms

Duplicate queries: #29

SELECT a.*

  FROM `bfcc_spmoviedb_genres` AS `a`

  WHERE `a`.`spmoviedb_genre_id` IN (6,10)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	PRIMARY	PRIMARY	8	NULL	2	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_spmoviedb/models/movies.php:116
12	SpmoviedbModelMovies::getGenries()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:25
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.61 ms After last query: 0.25 ms

SELECT a.*

  FROM `bfcc_spmoviedb_movies` AS `a`

  WHERE `a`.`spmoviedb_movie_id` = 45

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
13	JDatabaseDriver->loadObject()	JROOT/components/com_spmoviedb/models/movies.php:306
12	SpmoviedbModelMovies::GenerateTrailers()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:26
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.39 ms After last query: 0.36 ms

Duplicate queries: #27

SELECT a.*

  FROM `bfcc_spmoviedb_genres` AS `a`

  WHERE `a`.`spmoviedb_genre_id` IN (6,10)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	PRIMARY	PRIMARY	8	NULL	2	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_spmoviedb/models/movies.php:116
13	SpmoviedbModelMovies::getGenries()	JROOT/components/com_spmoviedb/models/movies.php:396
12	SpmoviedbModelMovies::GenerateTrailers()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:26
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.59 ms After last query: 0.36 ms

Duplicate queries: #26 #34 #38 #42 #46 #50 #54 #60 #61 #62 #63 #64 #65 #66 #67 #68 #69 #70 #73

SELECT `id`

  FROM `bfcc_menu`

  WHERE `link` LIKE '%option=com_spmoviedb&view=movies%' 
  AND `published` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bfcc_menu	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	110	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
13	JDatabaseDriver->loadResult()	JROOT/components/com_spmoviedb/helpers/helper.php:22
12	SpmoviedbHelper::getItemid()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:24
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.50 ms

Duplicate queries: #33

SELECT a.*

  FROM `bfcc_spmoviedb_genres` AS `a`

  WHERE `a`.`spmoviedb_genre_id` IN (10)

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_spmoviedb/models/movies.php:116
12	SpmoviedbModelMovies::getGenries()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:25
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.45 ms After last query: 0.22 ms

SELECT a.*

  FROM `bfcc_spmoviedb_movies` AS `a`

  WHERE `a`.`spmoviedb_movie_id` = 42

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
13	JDatabaseDriver->loadObject()	JROOT/components/com_spmoviedb/models/movies.php:306
12	SpmoviedbModelMovies::GenerateTrailers()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:26
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.37 ms After last query: 0.39 ms

Duplicate queries: #31

SELECT a.*

  FROM `bfcc_spmoviedb_genres` AS `a`

  WHERE `a`.`spmoviedb_genre_id` IN (10)

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_spmoviedb/models/movies.php:116
13	SpmoviedbModelMovies::getGenries()	JROOT/components/com_spmoviedb/models/movies.php:396
12	SpmoviedbModelMovies::GenerateTrailers()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:26
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.54 ms After last query: 0.50 ms

Duplicate queries: #26 #30 #38 #42 #46 #50 #54 #60 #61 #62 #63 #64 #65 #66 #67 #68 #69 #70 #73

SELECT `id`

  FROM `bfcc_menu`

  WHERE `link` LIKE '%option=com_spmoviedb&view=movies%' 
  AND `published` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bfcc_menu	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	110	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
13	JDatabaseDriver->loadResult()	JROOT/components/com_spmoviedb/helpers/helper.php:22
12	SpmoviedbHelper::getItemid()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:24
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.54 ms

Duplicate queries: #37

SELECT a.*

  FROM `bfcc_spmoviedb_genres` AS `a`

  WHERE `a`.`spmoviedb_genre_id` IN (5,8,9)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	PRIMARY	PRIMARY	8	NULL	3	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_spmoviedb/models/movies.php:116
12	SpmoviedbModelMovies::getGenries()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:25
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.46 ms After last query: 0.27 ms

SELECT a.*

  FROM `bfcc_spmoviedb_movies` AS `a`

  WHERE `a`.`spmoviedb_movie_id` = 41

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
13	JDatabaseDriver->loadObject()	JROOT/components/com_spmoviedb/models/movies.php:306
12	SpmoviedbModelMovies::GenerateTrailers()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:26
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.30 ms After last query: 0.36 ms

Duplicate queries: #35

SELECT a.*

  FROM `bfcc_spmoviedb_genres` AS `a`

  WHERE `a`.`spmoviedb_genre_id` IN (5,8,9)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	PRIMARY	PRIMARY	8	NULL	3	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_spmoviedb/models/movies.php:116
13	SpmoviedbModelMovies::getGenries()	JROOT/components/com_spmoviedb/models/movies.php:396
12	SpmoviedbModelMovies::GenerateTrailers()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:26
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.59 ms After last query: 0.42 ms

Duplicate queries: #26 #30 #34 #42 #46 #50 #54 #60 #61 #62 #63 #64 #65 #66 #67 #68 #69 #70 #73

SELECT `id`

  FROM `bfcc_menu`

  WHERE `link` LIKE '%option=com_spmoviedb&view=movies%' 
  AND `published` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bfcc_menu	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	110	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
13	JDatabaseDriver->loadResult()	JROOT/components/com_spmoviedb/helpers/helper.php:22
12	SpmoviedbHelper::getItemid()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:24
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.26 ms After last query: 0.50 ms

Duplicate queries: #41

SELECT a.*

  FROM `bfcc_spmoviedb_genres` AS `a`

  WHERE `a`.`spmoviedb_genre_id` IN (4)

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_spmoviedb/models/movies.php:116
12	SpmoviedbModelMovies::getGenries()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:25
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.48 ms After last query: 0.25 ms

SELECT a.*

  FROM `bfcc_spmoviedb_movies` AS `a`

  WHERE `a`.`spmoviedb_movie_id` = 39

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
13	JDatabaseDriver->loadObject()	JROOT/components/com_spmoviedb/models/movies.php:306
12	SpmoviedbModelMovies::GenerateTrailers()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:26
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 0.37 ms

Duplicate queries: #39

SELECT a.*

  FROM `bfcc_spmoviedb_genres` AS `a`

  WHERE `a`.`spmoviedb_genre_id` IN (4)

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_spmoviedb/models/movies.php:116
13	SpmoviedbModelMovies::getGenries()	JROOT/components/com_spmoviedb/models/movies.php:396
12	SpmoviedbModelMovies::GenerateTrailers()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:26
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.69 ms After last query: 0.36 ms

Duplicate queries: #26 #30 #34 #38 #46 #50 #54 #60 #61 #62 #63 #64 #65 #66 #67 #68 #69 #70 #73

SELECT `id`

  FROM `bfcc_menu`

  WHERE `link` LIKE '%option=com_spmoviedb&view=movies%' 
  AND `published` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bfcc_menu	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	110	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
13	JDatabaseDriver->loadResult()	JROOT/components/com_spmoviedb/helpers/helper.php:22
12	SpmoviedbHelper::getItemid()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:24
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.38 ms After last query: 0.44 ms

Duplicate queries: #45

SELECT a.*

  FROM `bfcc_spmoviedb_genres` AS `a`

  WHERE `a`.`spmoviedb_genre_id` IN (5)

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_spmoviedb/models/movies.php:116
12	SpmoviedbModelMovies::getGenries()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:25
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.40 ms After last query: 0.24 ms

SELECT a.*

  FROM `bfcc_spmoviedb_movies` AS `a`

  WHERE `a`.`spmoviedb_movie_id` = 40

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
13	JDatabaseDriver->loadObject()	JROOT/components/com_spmoviedb/models/movies.php:306
12	SpmoviedbModelMovies::GenerateTrailers()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:26
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.38 ms After last query: 0.37 ms

Duplicate queries: #43

SELECT a.*

  FROM `bfcc_spmoviedb_genres` AS `a`

  WHERE `a`.`spmoviedb_genre_id` IN (5)

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_spmoviedb/models/movies.php:116
13	SpmoviedbModelMovies::getGenries()	JROOT/components/com_spmoviedb/models/movies.php:396
12	SpmoviedbModelMovies::GenerateTrailers()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:26
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.65 ms After last query: 0.31 ms

Duplicate queries: #26 #30 #34 #38 #42 #50 #54 #60 #61 #62 #63 #64 #65 #66 #67 #68 #69 #70 #73

SELECT `id`

  FROM `bfcc_menu`

  WHERE `link` LIKE '%option=com_spmoviedb&view=movies%' 
  AND `published` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bfcc_menu	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	110	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
13	JDatabaseDriver->loadResult()	JROOT/components/com_spmoviedb/helpers/helper.php:22
12	SpmoviedbHelper::getItemid()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:24
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.35 ms After last query: 0.53 ms

Duplicate queries: #49 #51 #53 #55 #57

SELECT a.*

  FROM `bfcc_spmoviedb_genres` AS `a`

  WHERE `a`.`spmoviedb_genre_id` IN (6)

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_spmoviedb/models/movies.php:116
12	SpmoviedbModelMovies::getGenries()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:25
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.49 ms After last query: 0.22 ms

SELECT a.*

  FROM `bfcc_spmoviedb_movies` AS `a`

  WHERE `a`.`spmoviedb_movie_id` = 44

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
13	JDatabaseDriver->loadObject()	JROOT/components/com_spmoviedb/models/movies.php:306
12	SpmoviedbModelMovies::GenerateTrailers()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:26
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.51 ms After last query: 0.34 ms

Duplicate queries: #47 #51 #53 #55 #57

SELECT a.*

  FROM `bfcc_spmoviedb_genres` AS `a`

  WHERE `a`.`spmoviedb_genre_id` IN (6)

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_spmoviedb/models/movies.php:116
13	SpmoviedbModelMovies::getGenries()	JROOT/components/com_spmoviedb/models/movies.php:396
12	SpmoviedbModelMovies::GenerateTrailers()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:26
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.59 ms After last query: 0.36 ms

Duplicate queries: #26 #30 #34 #38 #42 #46 #54 #60 #61 #62 #63 #64 #65 #66 #67 #68 #69 #70 #73

SELECT `id`

  FROM `bfcc_menu`

  WHERE `link` LIKE '%option=com_spmoviedb&view=movies%' 
  AND `published` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bfcc_menu	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	110	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
13	JDatabaseDriver->loadResult()	JROOT/components/com_spmoviedb/helpers/helper.php:22
12	SpmoviedbHelper::getItemid()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:24
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.36 ms After last query: 0.47 ms

Duplicate queries: #47 #49 #53 #55 #57

SELECT a.*

  FROM `bfcc_spmoviedb_genres` AS `a`

  WHERE `a`.`spmoviedb_genre_id` IN (6)

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_spmoviedb/models/movies.php:116
12	SpmoviedbModelMovies::getGenries()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:25
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.50 ms After last query: 0.29 ms

SELECT a.*

  FROM `bfcc_spmoviedb_movies` AS `a`

  WHERE `a`.`spmoviedb_movie_id` = 37

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
13	JDatabaseDriver->loadObject()	JROOT/components/com_spmoviedb/models/movies.php:306
12	SpmoviedbModelMovies::GenerateTrailers()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:26
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.36 ms After last query: 0.39 ms

Duplicate queries: #47 #49 #51 #55 #57

SELECT a.*

  FROM `bfcc_spmoviedb_genres` AS `a`

  WHERE `a`.`spmoviedb_genre_id` IN (6)

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_spmoviedb/models/movies.php:116
13	SpmoviedbModelMovies::getGenries()	JROOT/components/com_spmoviedb/models/movies.php:396
12	SpmoviedbModelMovies::GenerateTrailers()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:26
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.62 ms After last query: 0.33 ms

Duplicate queries: #26 #30 #34 #38 #42 #46 #50 #60 #61 #62 #63 #64 #65 #66 #67 #68 #69 #70 #73

SELECT `id`

  FROM `bfcc_menu`

  WHERE `link` LIKE '%option=com_spmoviedb&view=movies%' 
  AND `published` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	bfcc_menu	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	110	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
13	JDatabaseDriver->loadResult()	JROOT/components/com_spmoviedb/helpers/helper.php:22
12	SpmoviedbHelper::getItemid()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:24
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.31 ms After last query: 0.44 ms

Duplicate queries: #47 #49 #51 #53 #57

SELECT a.*

  FROM `bfcc_spmoviedb_genres` AS `a`

  WHERE `a`.`spmoviedb_genre_id` IN (6)

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
13	JDatabaseDriver->loadObjectList()	JROOT/components/com_spmoviedb/models/movies.php:116
12	SpmoviedbModelMovies::getGenries()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:25
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.58 ms After last query: 0.24 ms

SELECT a.*

  FROM `bfcc_spmoviedb_movies` AS `a`

  WHERE `a`.`spmoviedb_movie_id` = 38

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1652
13	JDatabaseDriver->loadObject()	JROOT/components/com_spmoviedb/models/movies.php:306
12	SpmoviedbModelMovies::GenerateTrailers()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:26
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.51 ms After last query: 0.48 ms

Duplicate queries: #47 #49 #51 #53 #55

SELECT a.*

  FROM `bfcc_spmoviedb_genres` AS `a`

  WHERE `a`.`spmoviedb_genre_id` IN (6)

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_spmoviedb/models/movies.php:116
13	SpmoviedbModelMovies::getGenries()	JROOT/components/com_spmoviedb/models/movies.php:396
12	SpmoviedbModelMovies::GenerateTrailers()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:26
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.84 ms After last query: 2.91 ms

Duplicate queries: #23 #24

SHOW FULL COLUMNS 
  FROM `bfcc_spmoviedb_movies`

Explain

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

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1691
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/fof/database/driver/joomla.php:229
23	FOFDatabaseDriverJoomla->getTableColumns()	JROOT/libraries/fof/model/model.php:2129
22	FOFModel->getTableFields()	JROOT/libraries/fof/model/behavior/filters.php:37
21	FOFModelBehaviorFilters->onAfterBuildQuery()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/fof/utils/observable/event.php:63
19	FOFUtilsObservableEvent->update()	JROOT/libraries/fof/utils/observable/dispatcher.php:146
18	FOFUtilsObservableDispatcher->trigger()	JROOT/components/com_spmoviedb/models/trailers.php:56
17	SpmoviedbModelTrailers->buildQuery()	JROOT/libraries/fof/model/model.php:1814
16	FOFModel->getTotal()	JROOT/libraries/fof/model/model.php:1790
15	FOFModel->getPagination()	JROOT/libraries/fof/view/raw.php:196
14	FOFViewRaw->onDisplay()	JROOT/libraries/fof/view/raw.php:167
13	FOFViewRaw->onBrowse()	JROOT/libraries/fof/view/raw.php:110
12	FOFViewRaw->display()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:29
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 1.71 ms After last query: 61.56 ms

SELECT COUNT(*)

  FROM (
SELECT a.*

  FROM `bfcc_spmoviedb_movies` AS `a`

  WHERE `a`.`enabled` = '1' 
  AND `trailer_one`!="" 
  AND a.language in ('en-GB','*') 
  AND `a`.`access` IN (1,1)) AS a

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Select tables optimized away
2	DERIVED	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	19	Using where

Profile

No SHOW PROFILE (maybe because there are more than 100 queries)

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1730
18	JDatabaseDriver->loadResult()	JROOT/libraries/fof/database/driver/joomla.php:331
17	FOFDatabaseDriverJoomla->loadResult()	JROOT/libraries/fof/model/model.php:1823
16	FOFModel->getTotal()	JROOT/libraries/fof/model/model.php:1790
15	FOFModel->getPagination()	JROOT/libraries/fof/view/raw.php:196
14	FOFViewRaw->onDisplay()	JROOT/libraries/fof/view/raw.php:167
13	FOFViewRaw->onBrowse()	JROOT/libraries/fof/view/raw.php:110
12	FOFViewRaw->display()	JROOT/components/com_spmoviedb/views/trailers/view.html.php:29
11	SpmoviedbViewTrailers->display()	JROOT/libraries/fof/controller/controller.php:1125
10	FOFController->display()	JROOT/libraries/fof/controller/controller.php:1165
9	FOFController->browse()	JROOT/libraries/fof/controller/controller.php:967
8	FOFController->execute()	JROOT/libraries/fof/dispatcher/dispatcher.php:326
7	FOFDispatcher->dispatch()	JROOT/components/com_spmoviedb/spmoviedb.php:28
6	require_once JROOT/components/com_spmoviedb/spmoviedb.php	JROOT/libraries/src/Component/ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.80 ms After last query: 33.42 ms

Trailers

Canal Street (2018) (2018)

Acrimony (2018) (2018)

Black Panther (2018) (2018)

Step Sisters (2018)

Proud Mary (2018) (2018)

BlacK Klansman (2018) (2018)

Mudbone (2017)

Girls Trip (2017)

Search

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

75 Queries Logged 71.68 ms

39 duplicate found!