Adulte

Dispo	Titre	Auteur Principal	Année	Genre	Vues
Livre 1	L'Ile mystèrieuse	Verne Jules	2002	Roman jeunesse	50
Livre 1	Rayon vert (le)	Verne Jules	1992	Littérature adulte	87
Livre 1	Tour du Monde en 80 jours (Le)	Verne Jules	1991	Roman jeunesse	53
Livre 0	Tour du monde en quatre-vingts jours (Le)	Verne Jules	2005	Album jeunesse	54
Livre 0	Vingt mille lieues sous les mers	Verne Jules	2004	Roman jeunesse	58
Livre 0	Voyage au centre de la terre	Verne Jules	1991	Roman jeune plus	79
Livre 1	Voyage au centre de la terre	Verne Jules	2005	Roman jeunesse	53
Livre 0	Voyage au centre de la Terre	Verne Jules	2001	Littérature adulte	72
Livre 1	Vingt mille lieues sous les mers (Extraits) Résumé Vingt mille lieues sous les mers Le professeur Aronnax, son domestique Conseil et le harponneur Ned Land, qui cherchaient à capturer un fantastique monstre marin, se retrouvent prisonniers du capitaine Némo, à bord de son sous-marin le Nautilus. Quel lourd secret cache Némo pour vouloir les retenir ainsi à jamais ? C’est alors que parallèlement au fabuleux périple maritime qu’ils entament, s’engage une lutte psychologique et culturelle entre Aronnax et Némo. À l’envoûtement créé par les aventures et les découvertes fabuleuses, s’ajoute le piment des joutes scientifiques et historiques auxquelles s’adonnent le professeur et le capitaine.	Verne Jules	2016	Littérature adulte	286

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1685710515,
                "last": 1685710515,
                "now": 1685710515
            },
            "token": "CEcjK5qRVblikfzUK7vdKf1mqDsfpnZ3"
        },
        "registry": {
            "Com_nglibrary": {
                "Books": {
                    "authors": {
                        "id": "4449"
                    }
                }
            }
        },
        "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
        }
    }
}

Profil d'information

Temps

Mémoire

Temps: 23.23 ms / 23.23 ms Mémoire: 2.022 MB / 2.41 MB Application: afterLoad

Temps: 60.93 ms / 84.16 ms Mémoire: 4.694 MB / 7.10 MB Application: afterInitialise

Temps: 17.70 ms / 101.87 ms Mémoire: 1.050 MB / 8.15 MB Application: afterRoute

Temps: 4.16 ms / 106.02 ms Mémoire: 0.160 MB / 8.31 MB Application: beforeRenderComponent com_nglibrary

Temps: 85.61 ms / 191.63 ms Mémoire: 4.542 MB / 12.86 MB Application: Before Access::preloadComponents (all components)

Temps: 1.89 ms / 193.52 ms Mémoire: 0.065 MB / 12.92 MB Application: After Access::preloadComponents (all components)

Temps: 0.03 ms / 193.55 ms Mémoire: -0.003 MB / 12.92 MB Application: Before Access::getAssetRules (id:62 name:com_nglibrary)

Temps: 0.69 ms / 194.24 ms Mémoire: 0.027 MB / 12.95 MB Application: After Access::getAssetRules (id:62 name:com_nglibrary)

Temps: 1540.41 ms / 1734.66 ms Mémoire: 4.174 MB / 17.12 MB Application: afterRenderComponent com_nglibrary

Temps: 1.01 ms / 1735.67 ms Mémoire: 0.008 MB / 17.13 MB Application: afterDispatch

Temps: 18.54 ms / 1754.21 ms Mémoire: 0.426 MB / 17.55 MB Application: beforeRenderModule mod_articles_category (Pied de page)

Temps: 2.72 ms / 1756.94 ms Mémoire: 0.215 MB / 17.77 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Temps: 0.05 ms / 1756.99 ms Mémoire: 0.007 MB / 17.78 MB Application: After Access::getAssetRules (id:8 name:com_content)

Temps: 8.33 ms / 1765.32 ms Mémoire: 0.221 MB / 18.00 MB Application: afterRenderModule mod_articles_category (Pied de page)

Temps: 0.12 ms / 1765.44 ms Mémoire: -0.084 MB / 17.91 MB Application: beforeRenderModule mod_breadcrumbs (Fil d'Ariane)

Temps: 2.16 ms / 1767.59 ms Mémoire: 0.050 MB / 17.96 MB Application: afterRenderModule mod_breadcrumbs (Fil d'Ariane)

Temps: 0.06 ms / 1767.65 ms Mémoire: -0.005 MB / 17.96 MB Application: beforeRenderModule mod_custom (Suggestions)

Temps: 0.57 ms / 1768.22 ms Mémoire: 0.008 MB / 17.97 MB Application: afterRenderModule mod_custom (Suggestions)

Temps: 0.06 ms / 1768.28 ms Mémoire: 0.002 MB / 17.97 MB Application: beforeRenderModule mod_ngsearch (Recherche)

Temps: 149.37 ms / 1917.65 ms Mémoire: -0.365 MB / 17.60 MB Application: afterRenderModule mod_ngsearch (Recherche)

Temps: 0.06 ms / 1917.71 ms Mémoire: -0.026 MB / 17.58 MB Application: beforeRenderModule mod_custom (Horaires d'ouverture et contact)

Temps: 0.29 ms / 1918.00 ms Mémoire: 0.003 MB / 17.58 MB Application: afterRenderModule mod_custom (Horaires d'ouverture et contact)

Temps: 0.07 ms / 1918.07 ms Mémoire: 0.008 MB / 17.59 MB Application: beforeRenderModule mod_menu (Main Menu)

Temps: 6.91 ms / 1924.98 ms Mémoire: 0.169 MB / 17.76 MB Application: afterRenderModule mod_menu (Main Menu)

Temps: 0.08 ms / 1925.06 ms Mémoire: -0.006 MB / 17.75 MB Application: beforeRenderModule mod_login (Connexion)

Temps: 1.78 ms / 1926.84 ms Mémoire: 0.036 MB / 17.79 MB Application: afterRenderModule mod_login (Connexion)

Temps: 3.76 ms / 1930.60 ms Mémoire: 0.269 MB / 18.06 MB Application: afterRender

Total de requêtes base de données : 1508.24 ms

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

#	Appel	Fichier et numéro de ligne
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Même appel que celui de la ligne ci-dessous.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

#	Appel	Fichier et numéro de ligne
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

EXPLAIN impossible sur la requête : INSERT INTO `nr3zk_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3430383136396562333733663665656237323639393764386536633834616236', 1, 1685710516, 0, '', 0)

Profil

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
update	0.09 ms
end	0.01 ms
query end	0.04 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.81 ms Après la dernière requête : 2.85 ms Mémoire de requête : 0.064 MB mémoire avant requête : 4.472 MB Rangées retournées : 41

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

  FROM `nr3zk_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_extensions	NULL	ref	extension	extension	82	const	41	1.00	Using where

Profil

Status	Duration
starting	0.16 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.22 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Même appel que celui de la ligne ci-dessous.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.49 ms Après la dernière requête : 2.90 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.752 MB Rangées retournées : 5

SELECT id, rules

  FROM `nr3zk_viewlevels`

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_viewlevels	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	5	100.00	NULL

Profil

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.47 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.764 MB Rangées retournées : 2

SELECT b.id

  FROM nr3zk_usergroups AS a

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

  WHERE a.id = 9

Explication

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

Profil

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.04 ms Après la dernière requête : 0.70 ms Mémoire de requête : 0.030 MB mémoire avant requête : 4.833 MB Rangées retournées : 97

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

  FROM nr3zk_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_extensions	NULL	ref	extension	extension	82	const	116	0.60	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.49 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Même appel que celui de la ligne ci-dessous.
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:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.63 ms Après la dernière requête : 15.97 ms Mémoire de requête : 0.021 MB mémoire avant requête : 6.583 MB Rangées retournées : 1

SELECT `extension`

  FROM `nr3zk_action_logs_extensions`

  WHERE `extension` = 'com_icagenda'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_action_logs_extensions	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	18	10.00	Using where

Profil

Status	Duration
starting	0.18 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/plugins/actionlog/icagenda/icagenda.php:111
10	PlgActionlogIcagenda->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
9	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
8	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/plugins/system/actionlogs/actionlogs.php:64
7	PlgSystemActionLogs->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
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:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.44 ms Après la dernière requête : 11.64 ms Mémoire de requête : 0.049 MB mémoire avant requête : 7.293 MB Rangées retournées : 23

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

  LEFT JOIN nr3zk_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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	33	3.33	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	b54bqdde_thones.m.component_id	1	100.00	Using where

Profil

Status	Duration
starting	0.31 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.09 ms
preparing	0.04 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.51 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.04 ms
freeing items	0.12 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Même appel que celui de la ligne ci-dessous.
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:78
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:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
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:65
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:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.83 ms Après la dernière requête : 8.41 ms Mémoire de requête : 0.024 MB mémoire avant requête : 7.926 MB Rangées retournées : 1

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

  FROM `nr3zk_extensions`

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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profil

Status	Duration
starting	0.21 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Même appel que celui de la ligne ci-dessous.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/gdpr/gdpr.php:1498
8	plgSystemGdpr->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.80 ms Après la dernière requête : 0.24 ms Mémoire de requête : 0.006 MB mémoire avant requête : 7.919 MB

UPDATE `nr3zk_extensions`

  SET `params` = '{\"mediaversion\":\"781d06a0f1b5c27c4dcc14733e433c94\"}'

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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	nr3zk_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profil

Status	Duration
starting	0.18 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.09 ms
updating	0.13 ms
end	0.02 ms
query end	0.09 ms
closing tables	0.04 ms
freeing items	0.11 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/gdpr/gdpr.php:1498
8	plgSystemGdpr->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.86 ms Après la dernière requête : 3.93 ms Mémoire de requête : 0.019 MB mémoire avant requête : 8.170 MB Rangées retournées : 1

SELECT *

  FROM nr3zk_languages

  WHERE published=1

  ORDER BY ordering ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_languages	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	1	100.00	Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
starting	0.22 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.09 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.06 ms
freeing items	0.11 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.77 ms Après la dernière requête : 0.28 ms Mémoire de requête : 0.019 MB mémoire avant requête : 8.179 MB Rangées retournées : 3

SELECT id, home, template, s.params

  FROM nr3zk_template_styles as s

  LEFT JOIN nr3zk_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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	1.00	Using index condition; Using where
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	b54bqdde_thones.e.element	1	60.00	Using index condition; Using where

Profil

Status	Duration
starting	0.16 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.13 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.23 ms Après la dernière requête : 10.56 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.929 MB Rangées retournées : 1

Requêtes dupliquées: #15 #16 #17

SELECT `manifest_cache`

  FROM `nr3zk_extensions`

  WHERE `type` = 'component' 
  AND `name` = 'com_nglibrary'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_extensions	NULL	ref	extension	extension	82	const	41	10.00	Using where

Profil

Status	Duration
starting	0.32 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.28 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.05 ms
freeing items	0.11 ms
cleaning up	0.04 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
10	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
9	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:159
8	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:133
7	FOF30\Container\Container::getInstance()	JROOT/components/com_nglibrary/nglibrary.php:19
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.90 ms Après la dernière requête : 9.20 ms Mémoire de requête : 0.022 MB mémoire avant requête : 9.260 MB Rangées retournées : 1

Requêtes dupliquées: #14 #16 #17

SELECT `manifest_cache`

  FROM `nr3zk_extensions`

  WHERE `type` = 'component' 
  AND `name` = 'com_nglibrary'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_extensions	NULL	ref	extension	extension	82	const	41	10.00	Using where

Profil

Status	Duration
starting	0.21 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.22 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.11 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
10	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
9	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:290
8	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:133
7	FOF30\Container\Container::getInstance()	JROOT/components/com_nglibrary/nglibrary.php:19
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.73 ms Après la dernière requête : 1.29 ms Mémoire de requête : 0.022 MB mémoire avant requête : 9.333 MB Rangées retournées : 1

Requêtes dupliquées: #14 #15 #17

SELECT `manifest_cache`

  FROM `nr3zk_extensions`

  WHERE `type` = 'component' 
  AND `name` = 'com_nglibrary'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_extensions	NULL	ref	extension	extension	82	const	41	10.00	Using where

Profil

Status	Duration
starting	0.15 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.18 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
10	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
9	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:159
8	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
7	FOF30\Container\Container::getInstance()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.80 ms Après la dernière requête : 1.45 ms Mémoire de requête : 0.022 MB mémoire avant requête : 9.351 MB Rangées retournées : 1

Requêtes dupliquées: #14 #15 #16

SELECT `manifest_cache`

  FROM `nr3zk_extensions`

  WHERE `type` = 'component' 
  AND `name` = 'com_nglibrary'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_extensions	NULL	ref	extension	extension	82	const	41	10.00	Using where

Profil

Status	Duration
starting	0.15 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.21 ms
end	0.03 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.11 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
11	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
10	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
9	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:290
8	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
7	FOF30\Container\Container::getInstance()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.04 ms Après la dernière requête : 16.34 ms Mémoire de requête : 0.028 MB mémoire avant requête : 10.559 MB Rangées retournées : 110

SHOW TABLES

Explication

EXPLAIN impossible sur la requête : SHOW TABLES

Profil

Status	Duration
starting	0.20 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
checking permissions	0.36 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
19	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
18	JDatabaseDriverMysqli->getTableList()	JROOT/libraries/fof30/Model/DataModel.php:736
17	FOF30\Model\DataModel->getTableFields()	JROOT/libraries/fof30/Model/DataModel.php:250
16	FOF30\Model\DataModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
15	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
14	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Controller/Controller.php:612
13	FOF30\Controller\Controller->getModel()	JROOT/libraries/fof30/Controller/DataController.php:1542
12	FOF30\Controller\DataController->getModel()	JROOT/libraries/fof30/Controller/DataController.php:277
11	FOF30\Controller\DataController->checkACL()	JROOT/libraries/fof30/Controller/Controller.php:1049
10	FOF30\Controller\Controller->triggerEvent()	JROOT/libraries/fof30/Controller/Controller.php:378
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.25 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.033 MB mémoire avant requête : 10.582 MB Rangées retournées : 39

SHOW FULL COLUMNS 
  FROM `nr3zk_nglibrary_books`

Explication

EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `nr3zk_nglibrary_books`

Profil

Status	Duration
starting	0.10 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
Opening tables	0.20 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.06 ms
closing tables	0.03 ms
freeing items	0.09 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/fof30/Model/DataModel.php:788
17	FOF30\Model\DataModel->getTableFields()	JROOT/libraries/fof30/Model/DataModel.php:250
16	FOF30\Model\DataModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
15	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
14	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Controller/Controller.php:612
13	FOF30\Controller\Controller->getModel()	JROOT/libraries/fof30/Controller/DataController.php:1542
12	FOF30\Controller\DataController->getModel()	JROOT/libraries/fof30/Controller/DataController.php:277
11	FOF30\Controller\DataController->checkACL()	JROOT/libraries/fof30/Controller/Controller.php:1049
10	FOF30\Controller\Controller->triggerEvent()	JROOT/libraries/fof30/Controller/Controller.php:378
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.12 ms Après la dernière requête : 5.73 ms Mémoire de requête : 0.028 MB mémoire avant requête : 11.105 MB Rangées retournées : 2

SHOW FULL COLUMNS 
  FROM `nr3zk_nglibrary_editors`

Explication

EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `nr3zk_nglibrary_editors`

Profil

Status	Duration
starting	0.21 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.28 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.02 ms
Opening tables	0.03 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.08 ms
closing tables	0.04 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
25	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/fof30/Model/DataModel.php:788
24	FOF30\Model\DataModel->getTableFields()	JROOT/libraries/fof30/Model/DataModel.php:250
23	FOF30\Model\DataModel->__construct()	JROOT/libraries/fof30/Model/TreeModel.php:57
22	FOF30\Model\TreeModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
21	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
20	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Model/DataModel/Relation.php:256
19	FOF30\Model\DataModel\Relation->getForeignModel()	JROOT/libraries/fof30/Model/DataModel/Relation/BelongsTo.php:43
18	FOF30\Model\DataModel\Relation\BelongsTo->__construct()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:180
17	FOF30\Model\DataModel\RelationManager->addRelation()	JROOT/libraries/fof30/Model/DataModel.php:457
16	FOF30\Model\DataModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
15	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
14	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Controller/Controller.php:612
13	FOF30\Controller\Controller->getModel()	JROOT/libraries/fof30/Controller/DataController.php:1542
12	FOF30\Controller\DataController->getModel()	JROOT/libraries/fof30/Controller/DataController.php:277
11	FOF30\Controller\DataController->checkACL()	JROOT/libraries/fof30/Controller/Controller.php:1049
10	FOF30\Controller\Controller->triggerEvent()	JROOT/libraries/fof30/Controller/Controller.php:378
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.75 ms Après la dernière requête : 0.93 ms Mémoire de requête : 0.024 MB mémoire avant requête : 11.202 MB Rangées retournées : 1

SELECT `params`

  FROM `nr3zk_extensions`

  WHERE `type` = 'component' 
  AND `element` = 'com_nglibrary'

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profil

Status	Duration
starting	0.19 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.13 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Params/Params.php:54
15	FOF30\Params\Params->reload()	JROOT/libraries/fof30/Params/Params.php:39
14	FOF30\Params\Params->__construct()	JROOT/libraries/fof30/Container/Container.php:507
13	FOF30\Container\Container->FOF30\Container\{closure}()	JROOT/libraries/fof30/Pimple/Container.php:113
12	FOF30\Pimple\Container->offsetGet()	JROOT/libraries/fof30/Container/ContainerBase.php:27
11	FOF30\Container\ContainerBase->__get()	JROOT/components/com_nglibrary/Controller/Book.php:33
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.86 ms Après la dernière requête : 20.27 ms Mémoire de requête : 0.026 MB mémoire avant requête : 12.164 MB Rangées retournées : 1

Requêtes dupliquées: #24

SELECT *

  FROM nr3zk_wf_profiles

  WHERE published = 1

  ORDER BY ordering ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_wf_profiles	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	5	20.00	Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
starting	0.23 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.11 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/components/com_jce/editor/libraries/classes/application.php:196
21	WFApplication->getProfile()	JROOT/administrator/components/com_jce/helpers/browser.php:72
20	WfBrowserHelper::getMediaFieldOptions()	JROOT/plugins/system/jce/jce.php:45
19	PlgSystemJce->getMediaRedirectUrl()	JROOT/plugins/system/jce/jce.php:183
18	PlgSystemJce->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/fof30/Platform/Joomla/Platform.php:559
15	FOF30\Platform\Joomla\Platform->runPlugins()	JROOT/libraries/fof30/Model/DataModel.php:4196
14	FOF30\Model\DataModel->preprocessForm()	JROOT/libraries/fof30/Model/DataModel.php:4139
13	FOF30\Model\DataModel->loadForm()	JROOT/libraries/fof30/Model/DataModel.php:4076
12	FOF30\Model\DataModel->getForm()	JROOT/libraries/fof30/Controller/DataController.php:419
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.56 ms Après la dernière requête : 4.76 ms Mémoire de requête : 0.027 MB mémoire avant requête : 12.510 MB Rangées retournées : 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM nr3zk_fields AS a

  LEFT JOIN `nr3zk_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN nr3zk_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN nr3zk_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN nr3zk_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN nr3zk_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'com_nglibrary.Books.form.listing' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	b54bqdde_thones.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	b54bqdde_thones.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	b54bqdde_thones.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	b54bqdde_thones.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	b54bqdde_thones.a.group_id	1	100.00	Using where

Profil

Status	Duration
starting	0.33 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.08 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.18 ms
preparing	0.04 ms
Creating tmp table	0.07 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.22 ms
Creating sort index	0.03 ms
end	0.01 ms
query end	0.02 ms
removing tmp table	0.06 ms
query end	0.02 ms
closing tables	0.06 ms
freeing items	0.14 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
23	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
22	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
21	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
20	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:286
19	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:305
18	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/fof30/Platform/Joomla/Platform.php:559
15	FOF30\Platform\Joomla\Platform->runPlugins()	JROOT/libraries/fof30/Model/DataModel.php:4196
14	FOF30\Model\DataModel->preprocessForm()	JROOT/libraries/fof30/Model/DataModel.php:4139
13	FOF30\Model\DataModel->loadForm()	JROOT/libraries/fof30/Model/DataModel.php:4076
12	FOF30\Model\DataModel->getForm()	JROOT/libraries/fof30/Controller/DataController.php:419
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.69 ms Après la dernière requête : 0.66 ms Mémoire de requête : 0.028 MB mémoire avant requête : 12.524 MB Rangées retournées : 1

Requêtes dupliquées: #22

SELECT *

  FROM nr3zk_wf_profiles

  WHERE published = 1

  ORDER BY ordering ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_wf_profiles	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	5	20.00	Using where; Utilisation du tri complet de type filesort

Profil

Status	Duration
starting	0.15 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.09 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/components/com_jce/editor/libraries/classes/application.php:196
26	WFApplication->getProfile()	JROOT/administrator/components/com_jce/helpers/browser.php:72
25	WfBrowserHelper::getMediaFieldOptions()	JROOT/plugins/system/jce/jce.php:45
24	PlgSystemJce->getMediaRedirectUrl()	JROOT/plugins/system/jce/jce.php:183
23	PlgSystemJce->onContentPrepareForm()	JROOT/plugins/system/jce/jce.php:26
22	PlgSystemJce->onPlgSystemJceContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
21	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
20	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
19	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/content/jce/jce.php:19
18	PlgContentJce->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/fof30/Platform/Joomla/Platform.php:559
15	FOF30\Platform\Joomla\Platform->runPlugins()	JROOT/libraries/fof30/Model/DataModel.php:4196
14	FOF30\Model\DataModel->preprocessForm()	JROOT/libraries/fof30/Model/DataModel.php:4139
13	FOF30\Model\DataModel->loadForm()	JROOT/libraries/fof30/Model/DataModel.php:4076
12	FOF30\Model\DataModel->getForm()	JROOT/libraries/fof30/Controller/DataController.php:419
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.58 ms Après la dernière requête : 5.50 ms Mémoire de requête : 0.031 MB mémoire avant requête : 12.862 MB Rangées retournées : 41

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

  FROM `nr3zk_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_carouselck','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_gdpr','com_icagenda','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_ngconfig','com_nglibrary','com_plugin_pdffp','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_assets	NULL	ALL	idx_asset_name	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	116	36.21	Using where

Profil

Status	Duration
starting	0.31 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.09 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.26 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.46 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.05 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
24	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
23	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
22	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
21	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
20	Joomla\CMS\User\User->authorise()	JROOT/libraries/fof30/Platform/Joomla/Platform.php:587
19	FOF30\Platform\Joomla\Platform->authorise()	JROOT/libraries/fof30/View/DataView/Raw.php:109
18	FOF30\View\DataView\Raw->getPermissions()	JROOT/libraries/fof30/View/DataView/Raw.php:57
17	FOF30\View\DataView\Raw->__construct()	JROOT/libraries/fof30/Factory/Magic/ViewFactory.php:66
16	FOF30\Factory\Magic\ViewFactory->make()	JROOT/libraries/fof30/Factory/MagicFactory.php:97
15	FOF30\Factory\MagicFactory->view()	JROOT/libraries/fof30/Controller/DataController.php:384
14	FOF30\Controller\DataController->getView()	JROOT/libraries/fof30/Controller/Controller.php:456
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.92 ms Après la dernière requête : 5.06 ms Mémoire de requête : 0.032 MB mémoire avant requête : 13.186 MB Rangées retournées : 3

SHOW FULL COLUMNS 
  FROM `nr3zk_nglibrary_authors`

Explication

EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `nr3zk_nglibrary_authors`

Profil

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.24 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 ms
Opening tables	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.06 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
33	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
32	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/fof30/Model/DataModel.php:788
31	FOF30\Model\DataModel->getTableFields()	JROOT/libraries/fof30/Model/DataModel.php:250
30	FOF30\Model\DataModel->__construct()	JROOT/libraries/fof30/Model/TreeModel.php:57
29	FOF30\Model\TreeModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
28	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
27	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Model/DataModel/Relation.php:256
26	FOF30\Model\DataModel\Relation->getForeignModel()	JROOT/libraries/fof30/Model/DataModel/Relation/BelongsToMany.php:288
25	FOF30\Model\DataModel\Relation\BelongsToMany->getCountSubquery()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:380
24	FOF30\Model\DataModel\RelationManager->getCountSubquery()	JROOT/libraries/fof30/Model/DataModel/Behaviour/RelationFilters.php:37
23	FOF30\Model\DataModel\Behaviour\RelationFilters->onAfterBuildQuery()	JROOT/libraries/fof30/Event/Dispatcher.php:225
22	FOF30\Event\Dispatcher->trigger()	JROOT/libraries/fof30/Model/Model.php:570
21	FOF30\Model\Model->triggerEvent()	JROOT/libraries/fof30/Model/DataModel.php:1762
20	FOF30\Model\DataModel->buildQuery()	JROOT/libraries/fof30/Model/DataModel.php:1836
19	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
18	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
17	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/View/DataView/Raw.php:269
16	FOF30\View\DataView\Raw->onBeforeBrowse()	JROOT/libraries/fof30/View/View.php:1199
15	FOF30\View\View->triggerEvent()	JROOT/libraries/fof30/View/DataView/Form.php:47
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 492.16 ms Après la dernière requête : 0.83 ms Mémoire de requête : 0.034 MB mémoire avant requête : 13.216 MB Rangées retournées : 9

Requêtes dupliquées: #29

SELECT *

  FROM nr3zk_nglibrary_books AS book

  WHERE ((
SELECT COUNT(*)

  FROM `nr3zk_nglibrary_authors` AS `reltbl`

  INNER JOIN `nr3zk_nglibrary_books_authors` AS `pivotTable` 
  ON(`pivotTable`.`nglibrary_author_id` = `reltbl`.`nglibrary_author_id`)

  WHERE 
(`pivotTable`.`nglibrary_book_id` =`book`.`nglibrary_book_id`) 
  AND 
(`pivotTable`.`nglibrary_author_id` = '4449')) >= '1')

  ORDER BY `nglibrary_book_id` ASC,`nglibrary_book_id` ASC 
  LIMIT 20

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	book	NULL	index	NULL	PRIMARY	8	NULL	20	100.00	Using where
2	DEPENDENT SUBQUERY	reltbl	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	Using index
2	DEPENDENT SUBQUERY	pivotTable	NULL	eq_ref	PRIMARY	PRIMARY	16	b54bqdde_thones.book.nglibrary_book_id,const	1	100.00	Using where; Using index

Profil

Status	Duration
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.07 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
20	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
19	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
18	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
17	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/View/DataView/Raw.php:269
16	FOF30\View\DataView\Raw->onBeforeBrowse()	JROOT/libraries/fof30/View/View.php:1199
15	FOF30\View\View->triggerEvent()	JROOT/libraries/fof30/View/DataView/Form.php:47
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 369.22 ms Après la dernière requête : 4.36 ms Mémoire de requête : 0.025 MB mémoire avant requête : 13.288 MB Rangées retournées : 1

SELECT COUNT(*)

  FROM nr3zk_nglibrary_books AS book

  WHERE ((
SELECT COUNT(*)

  FROM `nr3zk_nglibrary_authors` AS `reltbl`

  INNER JOIN `nr3zk_nglibrary_books_authors` AS `pivotTable` 
  ON(`pivotTable`.`nglibrary_author_id` = `reltbl`.`nglibrary_author_id`)

  WHERE 
(`pivotTable`.`nglibrary_book_id` =`book`.`nglibrary_book_id`) 
  AND 
(`pivotTable`.`nglibrary_author_id` = '4449')) >= '1')

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	book	NULL	index	NULL	nglibrary_book_id	4	NULL	16999	100.00	Using where; Using index
2	DEPENDENT SUBQUERY	reltbl	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	Using index
2	DEPENDENT SUBQUERY	pivotTable	NULL	eq_ref	PRIMARY	PRIMARY	16	b54bqdde_thones.book.nglibrary_book_id,const	1	100.00	Using where; Using index

Profil

Status	Duration
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.07 ms
freeing items	0.14 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Model/DataModel.php:1709
17	FOF30\Model\DataModel->count()	JROOT/libraries/fof30/View/DataView/Raw.php:270
16	FOF30\View\DataView\Raw->onBeforeBrowse()	JROOT/libraries/fof30/View/View.php:1199
15	FOF30\View\View->triggerEvent()	JROOT/libraries/fof30/View/DataView/Form.php:47
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 513.50 ms Après la dernière requête : 34.54 ms Mémoire de requête : 0.036 MB mémoire avant requête : 15.209 MB Rangées retournées : 9

Requêtes dupliquées: #27

SELECT *

  FROM nr3zk_nglibrary_books AS book

  WHERE ((
SELECT COUNT(*)

  FROM `nr3zk_nglibrary_authors` AS `reltbl`

  INNER JOIN `nr3zk_nglibrary_books_authors` AS `pivotTable` 
  ON(`pivotTable`.`nglibrary_author_id` = `reltbl`.`nglibrary_author_id`)

  WHERE 
(`pivotTable`.`nglibrary_book_id` =`book`.`nglibrary_book_id`) 
  AND 
(`pivotTable`.`nglibrary_author_id` = '4449')) >= '1')

  ORDER BY `nglibrary_book_id` ASC,`nglibrary_book_id` ASC 
  LIMIT 20

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	book	NULL	index	NULL	PRIMARY	8	NULL	20	100.00	Using where
2	DEPENDENT SUBQUERY	reltbl	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	Using index
2	DEPENDENT SUBQUERY	pivotTable	NULL	eq_ref	PRIMARY	PRIMARY	16	b54bqdde_thones.book.nglibrary_book_id,const	1	100.00	Using where; Using index

Profil

Status	Duration
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.10 ms
freeing items	0.18 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
26	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
25	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
24	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
23	FOF30\Model\DataModel->get()	JROOT/libraries/ngfof/Render/Listing.php:326
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.74 ms Après la dernière requête : 2.85 ms Mémoire de requête : 0.032 MB mémoire avant requête : 15.364 MB Rangées retournées : 1

Requêtes dupliquées: #64

SELECT *

  FROM nr3zk_nglibrary_editors

  WHERE (`nglibrary_editor_id` = '2009')

  ORDER BY `nglibrary_editor_id` ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_nglibrary_editors	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	NULL

Profil

Status	Duration
starting	0.23 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
33	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
32	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
31	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
30	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
29	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/Relation/HasOne.php:39
28	FOF30\Model\DataModel\Relation\HasOne->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
27	FOF30\Model\DataModel\RelationManager->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:513
26	FOF30\Model\DataModel\RelationManager->__get()	JROOT/libraries/fof30/Model/DataModel.php:595
25	FOF30\Model\DataModel->__get()	JROOT/libraries/fof30/Form/Form.php:1142
24	FOF30\Form\Form->modelToBindSource()	JROOT/libraries/fof30/Form/Form.php:881
23	FOF30\Form\Form->bind()	JROOT/libraries/ngfof/Render/Listing.php:337
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.83 ms Après la dernière requête : 7.90 ms Mémoire de requête : 0.036 MB mémoire avant requête : 15.723 MB Rangées retournées : 22

SHOW FULL COLUMNS 
  FROM `nr3zk_nglibrary_copies`

Explication

EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `nr3zk_nglibrary_copies`

Profil

Status	Duration
starting	0.26 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.35 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.02 ms
Opening tables	0.03 ms
checking permissions	0.05 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.03 ms
removing tmp table	0.21 ms
closing tables	0.04 ms
freeing items	0.11 ms
cleaning up	0.03 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
33	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
32	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/fof30/Model/DataModel.php:788
31	FOF30\Model\DataModel->getTableFields()	JROOT/libraries/fof30/Model/DataModel.php:250
30	FOF30\Model\DataModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
29	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
28	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Model/DataModel/Relation.php:256
27	FOF30\Model\DataModel\Relation->getForeignModel()	JROOT/libraries/fof30/Model/DataModel/Relation.php:139
26	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
25	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/Form/Field/Cover.php:103
24	Nglibrary\Site\Form\Field\Cover->getStatic()	JROOT/components/com_nglibrary/Form/Field/Cover.php:129
23	Nglibrary\Site\Form\Field\Cover->getRepeatable()	JROOT/libraries/ngfof/Render/Listing.php:387
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.17 ms Après la dernière requête : 1.24 ms Mémoire de requête : 0.035 MB mémoire avant requête : 15.795 MB Rangées retournées : 9

SHOW FULL COLUMNS 
  FROM `nr3zk_nglibrary_libraries`

Explication

EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `nr3zk_nglibrary_libraries`

Profil

Status	Duration
starting	0.16 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.26 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.02 ms
Opening tables	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.11 ms
closing tables	0.04 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
40	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
39	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
38	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/fof30/Model/DataModel.php:788
37	FOF30\Model\DataModel->getTableFields()	JROOT/libraries/fof30/Model/DataModel.php:250
36	FOF30\Model\DataModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
35	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
34	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Model/DataModel/Relation.php:256
33	FOF30\Model\DataModel\Relation->getForeignModel()	JROOT/libraries/fof30/Model/DataModel/Relation/BelongsTo.php:43
32	FOF30\Model\DataModel\Relation\BelongsTo->__construct()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:180
31	FOF30\Model\DataModel\RelationManager->addRelation()	JROOT/libraries/fof30/Model/DataModel.php:457
30	FOF30\Model\DataModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
29	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
28	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Model/DataModel/Relation.php:256
27	FOF30\Model\DataModel\Relation->getForeignModel()	JROOT/libraries/fof30/Model/DataModel/Relation.php:139
26	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
25	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/Form/Field/Cover.php:103
24	Nglibrary\Site\Form\Field\Cover->getStatic()	JROOT/components/com_nglibrary/Form/Field/Cover.php:129
23	Nglibrary\Site\Form\Field\Cover->getRepeatable()	JROOT/libraries/ngfof/Render/Listing.php:387
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 1.04 ms Après la dernière requête : 0.60 ms Mémoire de requête : 0.036 MB mémoire avant requête : 15.834 MB Rangées retournées : 6

SHOW FULL COLUMNS 
  FROM `nr3zk_nglibrary_bookstatuses`

Explication

EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `nr3zk_nglibrary_bookstatuses`

Profil

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.22 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.02 ms
Opening tables	0.02 ms
checking permissions	0.03 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.10 ms
closing tables	0.03 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
41	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
40	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
39	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/fof30/Model/DataModel.php:788
38	FOF30\Model\DataModel->getTableFields()	JROOT/libraries/fof30/Model/DataModel.php:250
37	FOF30\Model\DataModel->__construct()	JROOT/libraries/fof30/Model/TreeModel.php:57
36	FOF30\Model\TreeModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
35	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
34	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Model/DataModel/Relation.php:256
33	FOF30\Model\DataModel\Relation->getForeignModel()	JROOT/libraries/fof30/Model/DataModel/Relation/BelongsTo.php:43
32	FOF30\Model\DataModel\Relation\BelongsTo->__construct()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:180
31	FOF30\Model\DataModel\RelationManager->addRelation()	JROOT/libraries/fof30/Model/DataModel.php:457
30	FOF30\Model\DataModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
29	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
28	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Model/DataModel/Relation.php:256
27	FOF30\Model\DataModel\Relation->getForeignModel()	JROOT/libraries/fof30/Model/DataModel/Relation.php:139
26	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
25	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/Form/Field/Cover.php:103
24	Nglibrary\Site\Form\Field\Cover->getStatic()	JROOT/components/com_nglibrary/Form/Field/Cover.php:129
23	Nglibrary\Site\Form\Field\Cover->getRepeatable()	JROOT/libraries/ngfof/Render/Listing.php:387
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.59 ms Après la dernière requête : 0.71 ms Mémoire de requête : 0.032 MB mémoire avant requête : 15.873 MB Rangées retournées : 6

Requêtes dupliquées: #40 #45 #50 #55 #60 #65 #70 #75

SELECT nglibrary_bookstatus_id AS ID

  FROM `nr3zk_nglibrary_bookstatuses`

  WHERE `is_displayed` != 1

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_nglibrary_bookstatuses	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	16	90.00	Using where

Profil

Status	Duration
starting	0.16 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
35	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
34	JDatabaseDriver->loadColumn()	JROOT/components/com_nglibrary/Model/Behaviour/CopiesDisabler.php:32
33	Nglibrary\Site\Model\Behaviour\CopiesDisabler->onBeforeBuildQuery()	JROOT/libraries/fof30/Event/Dispatcher.php:225
32	FOF30\Event\Dispatcher->trigger()	JROOT/libraries/fof30/Model/Model.php:570
31	FOF30\Model\Model->triggerEvent()	JROOT/libraries/fof30/Model/DataModel.php:1730
30	FOF30\Model\DataModel->buildQuery()	JROOT/libraries/fof30/Model/DataModel.php:1836
29	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
28	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
27	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
26	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
25	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/Form/Field/Cover.php:103
24	Nglibrary\Site\Form\Field\Cover->getStatic()	JROOT/components/com_nglibrary/Form/Field/Cover.php:129
23	Nglibrary\Site\Form\Field\Cover->getRepeatable()	JROOT/libraries/ngfof/Render/Listing.php:387
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.85 ms Après la dernière requête : 0.58 ms Mémoire de requête : 0.030 MB mémoire avant requête : 15.895 MB Rangées retournées : 1

SELECT *

  FROM nr3zk_nglibrary_copies

  WHERE nglibrary_bookstatus_id NOT IN (2,3,4,5,7,8) 
  AND (`nglibrary_book_id` = '16535')

  ORDER BY `nglibrary_copy_id` ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_nglibrary_copies	NULL	ref	nglibrary_book_id,nglibrary_bookstatus_id	nglibrary_book_id	8	const	1	63.39	Using index condition; Using where

Profil

Status	Duration
starting	0.16 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.17 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
30	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
29	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
28	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
27	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
26	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
25	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/Form/Field/Cover.php:103
24	Nglibrary\Site\Form\Field\Cover->getStatic()	JROOT/components/com_nglibrary/Form/Field/Cover.php:129
23	Nglibrary\Site\Form\Field\Cover->getRepeatable()	JROOT/libraries/ngfof/Render/Listing.php:387
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.50 ms Après la dernière requête : 1.21 ms Mémoire de requête : 0.032 MB mémoire avant requête : 15.922 MB Rangées retournées : 1

Requêtes dupliquées: #42 #57 #62 #72 #77

SELECT *

  FROM nr3zk_nglibrary_bookstatuses

  WHERE (`nglibrary_bookstatus_id` = '1')

  ORDER BY `nglibrary_bookstatus_id` ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_nglibrary_bookstatuses	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	NULL

Profil

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
33	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
32	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
31	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
30	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
29	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/Relation/HasOne.php:39
28	FOF30\Model\DataModel\Relation\HasOne->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
27	FOF30\Model\DataModel\RelationManager->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:513
26	FOF30\Model\DataModel\RelationManager->__get()	JROOT/libraries/fof30/Model/DataModel.php:595
25	FOF30\Model\DataModel->__get()	JROOT/components/com_nglibrary/Form/Field/Cover.php:109
24	Nglibrary\Site\Form\Field\Cover->getStatic()	JROOT/components/com_nglibrary/Form/Field/Cover.php:129
23	Nglibrary\Site\Form\Field\Cover->getRepeatable()	JROOT/libraries/ngfof/Render/Listing.php:387
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.93 ms Après la dernière requête : 1.01 ms Mémoire de requête : 0.033 MB mémoire avant requête : 15.952 MB Rangées retournées : 8

SHOW FULL COLUMNS 
  FROM `nr3zk_nglibrary_comments`

Explication

EXPLAIN impossible sur la requête : SHOW FULL COLUMNS FROM `nr3zk_nglibrary_comments`

Profil

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.19 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.11 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
32	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
31	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/fof30/Model/DataModel.php:788
30	FOF30\Model\DataModel->getTableFields()	JROOT/libraries/fof30/Model/DataModel.php:250
29	FOF30\Model\DataModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
28	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
27	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Model/DataModel/Relation.php:256
26	FOF30\Model\DataModel\Relation->getForeignModel()	JROOT/libraries/fof30/Model/DataModel/Relation.php:139
25	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
24	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/Form/Field/Rate.php:31
23	Nglibrary\Site\Form\Field\Rate->getRepeatable()	JROOT/libraries/ngfof/Render/Listing.php:387
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.47 ms Après la dernière requête : 1.65 ms Mémoire de requête : 0.029 MB mémoire avant requête : 15.999 MB Rangées retournées : 0

SELECT *

  FROM nr3zk_nglibrary_comments

  WHERE `enabled` = '1' 
  AND (`nglibrary_book_id` = '16535')

  ORDER BY `nglibrary_comment_id` ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_nglibrary_comments	NULL	index	NULL	PRIMARY	8	NULL	1	100.00	Using where

Profil

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
29	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
28	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
27	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
26	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
25	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
24	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/Form/Field/Rate.php:31
23	Nglibrary\Site\Form\Field\Rate->getRepeatable()	JROOT/libraries/ngfof/Render/Listing.php:387
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.59 ms Après la dernière requête : 1.32 ms Mémoire de requête : 0.032 MB mémoire avant requête : 16.025 MB Rangées retournées : 1

SELECT *

  FROM nr3zk_nglibrary_editors

  WHERE (`nglibrary_editor_id` = '2155')

  ORDER BY `nglibrary_editor_id` ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_nglibrary_editors	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	NULL

Profil

Status	Duration
starting	0.17 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
33	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
32	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
31	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
30	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
29	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/Relation/HasOne.php:39
28	FOF30\Model\DataModel\Relation\HasOne->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
27	FOF30\Model\DataModel\RelationManager->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:513
26	FOF30\Model\DataModel\RelationManager->__get()	JROOT/libraries/fof30/Model/DataModel.php:595
25	FOF30\Model\DataModel->__get()	JROOT/libraries/fof30/Form/Form.php:1142
24	FOF30\Form\Form->modelToBindSource()	JROOT/libraries/fof30/Form/Form.php:881
23	FOF30\Form\Form->bind()	JROOT/libraries/ngfof/Render/Listing.php:337
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.68 ms Après la dernière requête : 4.72 ms Mémoire de requête : 0.032 MB mémoire avant requête : 16.073 MB Rangées retournées : 6

Requêtes dupliquées: #34 #45 #50 #55 #60 #65 #70 #75

SELECT nglibrary_bookstatus_id AS ID

  FROM `nr3zk_nglibrary_bookstatuses`

  WHERE `is_displayed` != 1

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_nglibrary_bookstatuses	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	16	90.00	Using where

Profil

Status	Duration
starting	0.16 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.15 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
35	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
34	JDatabaseDriver->loadColumn()	JROOT/components/com_nglibrary/Model/Behaviour/CopiesDisabler.php:32
33	Nglibrary\Site\Model\Behaviour\CopiesDisabler->onBeforeBuildQuery()	JROOT/libraries/fof30/Event/Dispatcher.php:225
32	FOF30\Event\Dispatcher->trigger()	JROOT/libraries/fof30/Model/Model.php:570
31	FOF30\Model\Model->triggerEvent()	JROOT/libraries/fof30/Model/DataModel.php:1730
30	FOF30\Model\DataModel->buildQuery()	JROOT/libraries/fof30/Model/DataModel.php:1836
29	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
28	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
27	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
26	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
25	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/Form/Field/Cover.php:103
24	Nglibrary\Site\Form\Field\Cover->getStatic()	JROOT/components/com_nglibrary/Form/Field/Cover.php:129
23	Nglibrary\Site\Form\Field\Cover->getRepeatable()	JROOT/libraries/ngfof/Render/Listing.php:387
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.69 ms Après la dernière requête : 0.51 ms Mémoire de requête : 0.030 MB mémoire avant requête : 16.088 MB Rangées retournées : 1

SELECT *

  FROM nr3zk_nglibrary_copies

  WHERE nglibrary_bookstatus_id NOT IN (2,3,4,5,7,8) 
  AND (`nglibrary_book_id` = '16538')

  ORDER BY `nglibrary_copy_id` ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_nglibrary_copies	NULL	ref	nglibrary_book_id,nglibrary_bookstatus_id	nglibrary_book_id	8	const	1	63.39	Using index condition; Using where

Profil

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.13 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
30	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
29	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
28	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
27	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
26	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
25	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/Form/Field/Cover.php:103
24	Nglibrary\Site\Form\Field\Cover->getStatic()	JROOT/components/com_nglibrary/Form/Field/Cover.php:129
23	Nglibrary\Site\Form\Field\Cover->getRepeatable()	JROOT/libraries/ngfof/Render/Listing.php:387
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.44 ms Après la dernière requête : 1.02 ms Mémoire de requête : 0.032 MB mémoire avant requête : 16.115 MB Rangées retournées : 1

Requêtes dupliquées: #36 #57 #62 #72 #77

SELECT *

  FROM nr3zk_nglibrary_bookstatuses

  WHERE (`nglibrary_bookstatus_id` = '1')

  ORDER BY `nglibrary_bookstatus_id` ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_nglibrary_bookstatuses	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	NULL

Profil

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
33	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
32	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
31	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
30	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
29	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/Relation/HasOne.php:39
28	FOF30\Model\DataModel\Relation\HasOne->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
27	FOF30\Model\DataModel\RelationManager->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:513
26	FOF30\Model\DataModel\RelationManager->__get()	JROOT/libraries/fof30/Model/DataModel.php:595
25	FOF30\Model\DataModel->__get()	JROOT/components/com_nglibrary/Form/Field/Cover.php:109
24	Nglibrary\Site\Form\Field\Cover->getStatic()	JROOT/components/com_nglibrary/Form/Field/Cover.php:129
23	Nglibrary\Site\Form\Field\Cover->getRepeatable()	JROOT/libraries/ngfof/Render/Listing.php:387
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.61 ms Après la dernière requête : 1.63 ms Mémoire de requête : 0.029 MB mémoire avant requête : 16.146 MB Rangées retournées : 0

SELECT *

  FROM nr3zk_nglibrary_comments

  WHERE `enabled` = '1' 
  AND (`nglibrary_book_id` = '16538')

  ORDER BY `nglibrary_comment_id` ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_nglibrary_comments	NULL	index	NULL	PRIMARY	8	NULL	1	100.00	Using where

Profil

Status	Duration
starting	0.16 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
29	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
28	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
27	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
26	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
25	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
24	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/Form/Field/Rate.php:31
23	Nglibrary\Site\Form\Field\Rate->getRepeatable()	JROOT/libraries/ngfof/Render/Listing.php:387
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.45 ms Après la dernière requête : 1.42 ms Mémoire de requête : 0.032 MB mémoire avant requête : 16.168 MB Rangées retournées : 1

Requêtes dupliquées: #54

SELECT *

  FROM nr3zk_nglibrary_editors

  WHERE (`nglibrary_editor_id` = '1791')

  ORDER BY `nglibrary_editor_id` ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_nglibrary_editors	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	NULL

Profil

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
33	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
32	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
31	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
30	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
29	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/Relation/HasOne.php:39
28	FOF30\Model\DataModel\Relation\HasOne->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
27	FOF30\Model\DataModel\RelationManager->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:513
26	FOF30\Model\DataModel\RelationManager->__get()	JROOT/libraries/fof30/Model/DataModel.php:595
25	FOF30\Model\DataModel->__get()	JROOT/libraries/fof30/Form/Form.php:1142
24	FOF30\Form\Form->modelToBindSource()	JROOT/libraries/fof30/Form/Form.php:881
23	FOF30\Form\Form->bind()	JROOT/libraries/ngfof/Render/Listing.php:337
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.59 ms Après la dernière requête : 4.70 ms Mémoire de requête : 0.032 MB mémoire avant requête : 16.216 MB Rangées retournées : 6

Requêtes dupliquées: #34 #40 #50 #55 #60 #65 #70 #75

SELECT nglibrary_bookstatus_id AS ID

  FROM `nr3zk_nglibrary_bookstatuses`

  WHERE `is_displayed` != 1

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_nglibrary_bookstatuses	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	16	90.00	Using where

Profil

Status	Duration
starting	0.17 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
35	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
34	JDatabaseDriver->loadColumn()	JROOT/components/com_nglibrary/Model/Behaviour/CopiesDisabler.php:32
33	Nglibrary\Site\Model\Behaviour\CopiesDisabler->onBeforeBuildQuery()	JROOT/libraries/fof30/Event/Dispatcher.php:225
32	FOF30\Event\Dispatcher->trigger()	JROOT/libraries/fof30/Model/Model.php:570
31	FOF30\Model\Model->triggerEvent()	JROOT/libraries/fof30/Model/DataModel.php:1730
30	FOF30\Model\DataModel->buildQuery()	JROOT/libraries/fof30/Model/DataModel.php:1836
29	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
28	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
27	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
26	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
25	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/Form/Field/Cover.php:103
24	Nglibrary\Site\Form\Field\Cover->getStatic()	JROOT/components/com_nglibrary/Form/Field/Cover.php:129
23	Nglibrary\Site\Form\Field\Cover->getRepeatable()	JROOT/libraries/ngfof/Render/Listing.php:387
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.70 ms Après la dernière requête : 0.59 ms Mémoire de requête : 0.030 MB mémoire avant requête : 16.231 MB Rangées retournées : 1

SELECT *

  FROM nr3zk_nglibrary_copies

  WHERE nglibrary_bookstatus_id NOT IN (2,3,4,5,7,8) 
  AND (`nglibrary_book_id` = '16539')

  ORDER BY `nglibrary_copy_id` ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_nglibrary_copies	NULL	ref	nglibrary_book_id,nglibrary_bookstatus_id	nglibrary_book_id	8	const	1	63.39	Using index condition; Using where

Profil

Status	Duration
starting	0.15 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.12 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
30	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
29	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
28	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
27	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
26	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
25	FOF30\Model\DataModel\RelationManager->getData()	JROOT/components/com_nglibrary/Form/Field/Cover.php:103
24	Nglibrary\Site\Form\Field\Cover->getStatic()	JROOT/components/com_nglibrary/Form/Field/Cover.php:129
23	Nglibrary\Site\Form\Field\Cover->getRepeatable()	JROOT/libraries/ngfof/Render/Listing.php:387
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.50 ms Après la dernière requête : 1.21 ms Mémoire de requête : 0.032 MB mémoire avant requête : 16.257 MB Rangées retournées : 1

Requêtes dupliquées: #67

SELECT *

  FROM nr3zk_nglibrary_bookstatuses

  WHERE (`nglibrary_bookstatus_id` = '12')

  ORDER BY `nglibrary_bookstatus_id` ASC

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_nglibrary_bookstatuses	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	NULL

Profil

Status	Duration
starting	0.15 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.02 ms
Sending data	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
33	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
32	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
31	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
30	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
29	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/Relation/HasOne.php:39
28	FOF30\Model\DataModel\Relation\HasOne->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
27	FOF30\Model\DataModel\RelationManager->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:513
26	FOF30\Model\DataModel\RelationManager->__get()	JROOT/libraries/fof30/Model/DataModel.php:595
25	FOF30\Model\DataModel->__get()	JROOT/components/com_nglibrary/Form/Field/Cover.php:109
24	Nglibrary\Site\Form\Field\Cover->getStatic()	JROOT/components/com_nglibrary/Form/Field/Cover.php:129
23	Nglibrary\Site\Form\Field\Cover->getRepeatable()	JROOT/libraries/ngfof/Render/Listing.php:387
22	Ngfof\Render\Listing->renderFormBrowse()	JROOT/libraries/fof30/Render/AkeebaStrapper.php:1452
21	FOF30\Render\AkeebaStrapper->renderForm()	JROOT/libraries/fof30/View/DataView/Form.php:108
20	FOF30\View\DataView\Form->getRenderedForm()	JROOT/components/com_nglibrary/View/Books/tmpl/listing.php:91
19	include JROOT/components/com_nglibrary/View/Books/tmpl/listing.php	JROOT/libraries/fof30/View/View.php:1031
18	FOF30\View\View->includeTemplateFile()	JROOT/libraries/fof30/View/View.php:1006
17	FOF30\View\View->processTemplate()	JROOT/libraries/fof30/View/View.php:721
16	FOF30\View\View->loadAnyTemplate()	JROOT/libraries/fof30/View/View.php:658
15	FOF30\View\View->loadTemplate()	JROOT/libraries/fof30/View/DataView/Form.php:61
14	FOF30\View\DataView\Form->display()	JROOT/libraries/fof30/Controller/Controller.php:546
13	FOF30\Controller\Controller->display()	JROOT/administrator/components/com_nglibrary/Controller/DefaultDataController.php:21
12	Nglibrary\Admin\Controller\DefaultDataController->display()	JROOT/libraries/fof30/Controller/DataController.php:432
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.52 ms Après la dernière requête : 1.52 ms Mémoire de requête : 0.029 MB mémoire avant requête : 16.288 MB Rangées retournées : 0
```
SELECT *

  FROM nr3zk_nglibrary_comments

  WHERE `enabled` = '1' 
  AND (`nglibrary_book_id` = '16539')

  ORDER BY `nglibrary_comment_id` ASC
```
Explication
id select_type table partitions type possible_keys key key_len ref rows filtered Extra
1 SIMPLE nr3zk_nglibrary_comments NULL index NULL PRIMARY 8 NULL 1 100.00 Using where

Lundi		13h30-17h30
Mardi	9h-12h
Mercredi	9h-12h	13h30-17h30
Jeudi	9h-12h
Vendredi	9h-12h
Samedi	8h30-13h30

9 Nouveautés adultes

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

89 requêtes exécutées 1508.24 ms

29 doubles découverts!