Nouveautés

Dispo	Titre	Auteur Principal	Année	Genre	Vues
Livre 2	Seuls T.10 : La machine à démourir	Gazzotti Bruno	2016	BD Adulte	284
Livre 1	My hero academia T.2 : Déchaîne-toi, maudit nerd ! (My hero academia 2)	Horikoshi Kohei	2016	Manga Jeune	221
Livre 2	Atelier des sorciers (L') T.01 Résumé Atelier des sorciers (L') T.01 Coco a toujours été fascinée par la magie. Hélas, seuls les sorciers peuvent pratiquer cet art et les élus sont choisis dès la naissance. Un jour, Kieffrey, un sorcier, arrive dans le village de la jeune fille. En l’espionnant, Coco comprend alors la véritable nature de la magie et se rappelle d’un livre de magie et d’un encrier qu’elle a achetés à un mystérieux inconnu quand elle était enfant. Elle s’exerce alors en cachette. Mais, dans son ignorance, Coco commet un acte tragique ! Dès lors, elle devient la disciple de Kieffrey et va découvrir un monde dont elle ne soupçonnait pas l’existence !	Shirahama Kamome	2018	Manga Jeune	235
Livre 1	Les Inventions	Beaumont Jacques	0	Documentaire Jeune	14
Livre 1	One Piece Tome 35 (Édition originale) Résumé One Piece Tome 35 Lufy, garçon espiègle, rêve de devenir le roi des pirates en trouvant le One Piece, un fabuleux trésor. Il a avalé par mégarde un fruit démoniaque qui l'a transformé en homme-caoutchouc. Depuis, il est capable de se contorsionner mais ne peut plus nager. Avec l'aide de ses amis, il va devoir affronter de redoutables pirates dans de nombreuses aventures.	Oda Eiichiro	2014	BD Jeune	444
Livre 1	La Dernière tempête Résumé La Dernière tempête La terrible tempête de neige qui s'abat sur l'Islande aurait dû décourager les plus téméraires de s'aventurer à l'extérieur. Ils l'ont pourtant fait. Ce couple n'aurait jamais dû laisser entrer chez eux un inconnu. Il l'a pourtant fait. Un invité indésirable. Un mensonge innommable. Un meurtre. Tous ne survivront pas à cette nuit. Et l'inspectrice Hulda, chargée de l'enquête, continuera d'être hantée par ses fantômes très longtemps encore.	Jonasson Ragnar	2021	Roman Policier	314
Livre 0	Le Petit livre pour dire stop au harcèlement à l'école Résumé Le Petit livre pour dire stop au harcèlement à l'école Un petit livre pour aborder la question du harcèlement sous toutes ses formes : - Les violences verbales (surnoms, moqueries, insultes, menaces, sexisme, racisme...).- Les violences physiques (coups, bousculades, croche-pieds, claques, pincements...).- Les violences relationnelles, l'isolement (interdiction de s'assoir à une table, isolement physique, fausses rumeurs, médisances...) qui visent au rejet et à l'exclusion.- Le cyberharcèlement (principalement au collège).A travers six histoires en BD de victimes ou témoins de harcèlement à l'école, l'enfant va découvrir différentes situations. A la suite de chaque histoire, trois réactions sont proposées avec leurs conséquences explicitées. Des conseils et des solutions sont délivrés pour apprendre à faire face.Permettre à l'enfant de bien comprendre les mécanismes du harcèlement, l'aider à s'affirmer, à se défendre, à dire STOP, tel est le but de cet ouvrage de santé publique à lire en famille.	Larcher Nadège	2020	Documentaire Jeune	261
Livre 1	S'adapter (Roman) Résumé S'adapter C'est l'histoire d'un enfant aux yeux noirs qui flottent, et s'échappent dans le vague, un enfant toujours allongé, aux joues douces et rebondies, aux jambes translucides et veinées de bleu, au filet de voix haut, aux pieds recourbés et au palais creux, un bébé éternel, un enfant inadapté qui trace une frontière invisible entre sa famille et les autres. C'est l'histoire de sa place dans la maison cévenole où il naît, au milieu de la nature puissante et des montagnes protectrices ; de sa place dans la fratrie et dans les enfances bouleversées. Celle de l'aîné qui fusionne avec l'enfant, qui, joue contre joue, attentionné et presque siamois, s'y attache, s'y abandonne et s'y perd. Celle de la cadette, en qui s'implante le dégoût et la colère, le rejet de l'enfant qui aspire la joie de ses parents et l'énergie de l'aîné. Celle du petit dernier qui vit dans l'ombre des fantômes familiaux tout en portant la renaissance d'un présent hors de la mémoire.Comme dans un conte, les pierres de la cour témoignent. Comme dans les contes, la force vient des enfants, de l'amour fou de l'aîné qui protège, de la cadette révoltée qui rejettera le chagrin pour sauver la famille à la dérive. Du dernier qui saura réconcilier les histoires.La naissance d'un enfant handicapé racontée par sa fratrie.Un livre magnifique et lumineux.	Dupont-Monod Clara	2021	Roman Adulte	709
Livre 0	Petite marmotte a la bougeotte	Jolibois Christian	2021	Album	176
Livre 0	Le Lièvre et la tortue (ou presque)	Gouichoux Rene	2021	Roman Jeune	136
Livre 0	Un Indien qui dérange Résumé Un Indien qui dérange Pas une âme à Chinook ne pourrait s'offrir un appartement au Buffalo Mountain Resort, complexe immobilier de luxe au pied des Rocheuses. Même pas le petit studio avec vue sur le parking et le toit du casino. D'ailleurs, personne dans la réserve n'y songe. Tous savent que seuls les riches citadins blancs en mal de nature ou de jeux d'argent pourront se le permettre. Ce projet apporterait du travail aux Autochtones mais, soucieux de préserver leur culture, les activistes des Aigles rouges s'y opposent. DreadfulWater sait tout cela quand le shérif l'appelle pour prendre les photos d'un mort retrouvé dans un appartement-témoin, mais il refuse d'emblée le coupable tout désigné. Il faut dire que si DreadfulWater a abandonné la Californie et son insigne de flic pour une vie solitaire et peinarde, il n'en a pas oublié pour autant les vieux réflexes du métier. D'autant qu'il aime Claire et que, parce qu'elle le lui demande, il est prêt à reprendre du service. Mais à sa manière, un poil iconoclaste et décalée... Au risque de ne pas se faire que des amis et de devenir, aux yeux de beaucoup de monde "un Indien qui dérange".	King Thomas	2021	Roman Policier	133
Livre 1	Enquête à New York Résumé Enquête à New York Cléo, onze ans, est loin de se douter du mystère qui l'attend quand elle débarque à New York. Pour résoudre l'énigme du tableau volé, elle devra apprendre l'anglais... et vite ! Série phare des éditions Chattycat, ‘Cléo Lefort' initie les enfants à l'anglais et leur fait découvrir de grandes villes étrangères. En bonus : lexique à la fin de chaque chapitre, carte de la ville, jeux, version audio téléchargeable gratuitement.	Glay A. de	2020	Roman Jeune	183
Livre 0	La Très grande princesse Résumé	Miura Taro	2014	Album	189
Livre 1	Le Petit livre pour dire stop au harcèlement à l'école Résumé Le Petit livre pour dire stop au harcèlement à l'école Un petit livre pour aborder la question du harcèlement sous toutes ses formes : - Les violences verbales (surnoms, moqueries, insultes, menaces, sexisme, racisme...).- Les violences physiques (coups, bousculades, croche-pieds, claques, pincements...).- Les violences relationnelles, l'isolement (interdiction de s'assoir à une table, isolement physique, fausses rumeurs, médisances...) qui visent au rejet et à l'exclusion.- Le cyberharcèlement (principalement au collège).A travers six histoires en BD de victimes ou témoins de harcèlement à l'école, l'enfant va découvrir différentes situations. A la suite de chaque histoire, trois réactions sont proposées avec leurs conséquences explicitées. Des conseils et des solutions sont délivrés pour apprendre à faire face.Permettre à l'enfant de bien comprendre les mécanismes du harcèlement, l'aider à s'affirmer, à se défendre, à dire STOP, tel est le but de cet ouvrage de santé publique à lire en famille.	Larcher Nadège	2020	Documentaire Jeune	117
Livre 1	Ca m'interesse N° 493 Mars 2022 (VOYAGE AU CENTRE DU CERVEAU)		2022	Periodique Adulte	46
Livre 1	L'Appel des lions	Brissy Pascal	2022	Roman Jeune	64
Livre 0	La Source magique	O'donnell Cassandra	2015	Roman Jeune	68
Livre 1	Les Héritiers	O'donnell Cassandra	2015	Roman Jeune	70
Livre 1	L impeccable anniversaire d hubert falabrak	Boulet Gwenaëlle	2020	Roman Jeune	71
Livre 1	La Compétition	Noël Sophie	2021	Roman Jeune	63

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1653213325,
                "last": 1653213325,
                "now": 1653213325
            },
            "token": "FgXp2xsWPSqiqTMyVif4T3rUkkD6Bvrn"
        },
        "registry": {
            "Com_nglibrary": {
                "Books": {
                    "copies": {
                        "hideperiodique": "1",
                        "statusId": "4"
                    },
                    "filter_order_Dir": "ASC",
                    "_outerGlue": "AND"
                }
            }
        },
        "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: 22.53 ms / 22.53 ms Mémoire: 1.851 MB / 2.24 MB Application: afterLoad

Temps: 60.98 ms / 83.51 ms Mémoire: 4.446 MB / 6.69 MB Application: afterInitialise

Temps: 17.05 ms / 100.56 ms Mémoire: 0.933 MB / 7.62 MB Application: afterRoute

Temps: 3.76 ms / 104.32 ms Mémoire: 0.160 MB / 7.78 MB Application: beforeRenderComponent com_nglibrary

Temps: 144.29 ms / 248.62 ms Mémoire: 4.187 MB / 11.97 MB Application: Before Access::preloadComponents (all components)

Temps: 1.47 ms / 250.08 ms Mémoire: 0.064 MB / 12.03 MB Application: After Access::preloadComponents (all components)

Temps: 0.05 ms / 250.14 ms Mémoire: -0.003 MB / 12.03 MB Application: Before Access::getAssetRules (id:60 name:com_nglibrary)

Temps: 0.67 ms / 250.81 ms Mémoire: 0.027 MB / 12.05 MB Application: After Access::getAssetRules (id:60 name:com_nglibrary)

Temps: 2015.91 ms / 2266.72 ms Mémoire: 5.641 MB / 17.70 MB Application: afterRenderComponent com_nglibrary

Temps: 1.25 ms / 2267.97 ms Mémoire: 0.007 MB / 17.70 MB Application: afterDispatch

Temps: 22.87 ms / 2290.84 ms Mémoire: 0.456 MB / 18.16 MB Application: beforeRenderModule mod_articles_category (Mentions légales)

Temps: 3.71 ms / 2294.55 ms Mémoire: 0.215 MB / 18.37 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Temps: 0.09 ms / 2294.63 ms Mémoire: 0.007 MB / 18.38 MB Application: After Access::getAssetRules (id:8 name:com_content)

Temps: 2.76 ms / 2297.39 ms Mémoire: 0.007 MB / 18.39 MB Application: afterRenderModule mod_articles_category (Mentions légales)

Temps: 0.14 ms / 2297.53 ms Mémoire: -0.005 MB / 18.38 MB Application: beforeRenderModule mod_ngsearch (Recherche)

Temps: 216.95 ms / 2514.48 ms Mémoire: -1.073 MB / 17.31 MB Application: afterRenderModule mod_ngsearch (Recherche)

Temps: 0.14 ms / 2514.62 ms Mémoire: -0.017 MB / 17.29 MB Application: beforeRenderModule mod_menu (Main Menu)

Temps: 6.48 ms / 2521.11 ms Mémoire: 0.146 MB / 17.44 MB Application: afterRenderModule mod_menu (Main Menu)

Temps: 0.14 ms / 2521.25 ms Mémoire: -0.004 MB / 17.43 MB Application: beforeRenderModule mod_custom (Accueil)

Temps: 1.00 ms / 2522.25 ms Mémoire: 0.006 MB / 17.44 MB Application: afterRenderModule mod_custom (Accueil)

Temps: 13.05 ms / 2535.30 ms Mémoire: 0.304 MB / 17.74 MB Application: afterRender

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_session	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:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:854
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:414
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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_session	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:856
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:414
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'6431643533636139633438323835373661626435373361333234623931386234', 1, 1653213325, 0, '', 0)

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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:856
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:414
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 : 1.32 ms Après la dernière requête : 3.25 ms Mémoire de requête : 0.055 MB mémoire avant requête : 4.339 MB Rangées retournées : 39

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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_extensions	ref	extension	extension	82	const	39	100.00	Using index condition; Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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.77 ms Après la dernière requête : 3.45 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.556 MB Rangées retournées : 5

SELECT id, rules

  FROM `nr3zk_viewlevels`

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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.76 ms Après la dernière requête : 0.11 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.568 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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	100.00	Using where; Using index

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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.60 ms Après la dernière requête : 1.18 ms Mémoire de requête : 0.030 MB mémoire avant requête : 4.636 MB Rangées retournées : 81

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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_extensions	ref	extension	extension	82	const	101	100.00	Using index condition; Using where; Utilisation du tri complet de type filesort

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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 : 1.66 ms Après la dernière requête : 24.80 ms Mémoire de requête : 0.048 MB mémoire avant requête : 6.873 MB Rangées retournées : 15

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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	17	100.00	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	pf4175j0_neuilly.m.component_id	1	100.00	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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:445
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:561
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:1169
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 : 1.09 ms Après la dernière requête : 8.66 ms Mémoire de requête : 0.025 MB mémoire avant requête : 7.455 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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using index condition

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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:937
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:1218
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.84 ms Après la dernière requête : 0.19 ms Mémoire de requête : 0.006 MB mémoire avant requête : 7.448 MB

UPDATE `nr3zk_extensions`

  SET `params` = '{\"mediaversion\":\"6c00bb8c741860673117f349a2aac03e\"}'

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

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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:937
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:1218
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 : 2.56 ms Mémoire de requête : 0.019 MB mémoire avant requête : 7.635 MB Rangées retournées : 1

SELECT *

  FROM nr3zk_languages

  WHERE published=1

  ORDER BY ordering ASC

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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 : 1.03 ms Après la dernière requête : 0.26 ms Mémoire de requête : 0.019 MB mémoire avant requête : 7.644 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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	3	100.00	NULL
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	pf4175j0_neuilly.s.template,const	1	100.00	Using index condition; Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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.10 ms Après la dernière requête : 8.38 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.395 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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_extensions	ref	extension	extension	82	const	39	100.00	Using index condition; Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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 : 1.36 ms Après la dernière requête : 6.74 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.789 MB Rangées retournées : 1

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

SELECT `manifest_cache`

  FROM `nr3zk_extensions`

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_extensions	ref	extension	extension	82	const	39	100.00	Using index condition; Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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.86 ms Après la dernière requête : 0.69 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.827 MB Rangées retournées : 1

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

SELECT `manifest_cache`

  FROM `nr3zk_extensions`

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_extensions	ref	extension	extension	82	const	39	100.00	Using index condition; Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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.91 ms Après la dernière requête : 1.40 ms Mémoire de requête : 0.022 MB mémoire avant requête : 8.843 MB Rangées retournées : 1

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

SELECT `manifest_cache`

  FROM `nr3zk_extensions`

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_extensions	ref	extension	extension	82	const	39	100.00	Using index condition; Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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.28 ms Après la dernière requête : 15.89 ms Mémoire de requête : 0.029 MB mémoire avant requête : 9.986 MB Rangées retournées : 104

SHOW TABLES

Explication

EXPLAIN impossible sur la requête : SHOW TABLES

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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 : 25.29 ms Après la dernière requête : 0.10 ms Mémoire de requête : 0.033 MB mémoire avant requête : 10.009 MB Rangées retournées : 40

SHOW FULL COLUMNS 
  FROM `nr3zk_nglibrary_books`

Explication

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

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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 : 26.53 ms Après la dernière requête : 7.09 ms Mémoire de requête : 0.028 MB mémoire avant requête : 10.596 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

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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.94 ms Après la dernière requête : 1.48 ms Mémoire de requête : 0.024 MB mémoire avant requête : 10.631 MB Rangées retournées : 1

SELECT `params`

  FROM `nr3zk_extensions`

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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 : 27.66 ms Après la dernière requête : 13.77 ms Mémoire de requête : 0.027 MB mémoire avant requête : 11.634 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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Utilisation du tri complet de type filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	pf4175j0_neuilly.a.language	1	100.00	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	pf4175j0_neuilly.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	pf4175j0_neuilly.a.access	1	100.00	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	pf4175j0_neuilly.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	pf4175j0_neuilly.a.group_id	1	100.00	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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:189
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 : 1.12 ms Après la dernière requête : 4.35 ms Mémoire de requête : 0.030 MB mémoire avant requête : 11.974 MB Rangées retournées : 37

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_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_gdpr','com_gmapfp','com_installer','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	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_assets	ALL	idx_asset_name	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	104	38.46	Using where

Profil

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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 : 27.67 ms Après la dernière requête : 8.01 ms Mémoire de requête : 0.035 MB mémoire avant requête : 12.368 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

No SHOW PROFILE (peut-être parce qu'il y a plus de 100 requêtes)

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/HasMany.php:122
25	FOF30\Model\DataModel\Relation\HasMany->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 : 26.72 ms Après la dernière requête : 1.93 ms Mémoire de requête : 0.035 MB mémoire avant requête : 12.454 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.18 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	17.50 ms
init	0.05 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.06 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.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	8.10 ms
closing tables	0.11 ms
freeing items	0.14 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
39	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
38	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
37	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/fof30/Model/DataModel.php:788
36	FOF30\Model\DataModel->getTableFields()	JROOT/libraries/fof30/Model/DataModel.php:250
35	FOF30\Model\DataModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
34	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
33	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Model/DataModel/Relation.php:256
32	FOF30\Model\DataModel\Relation->getForeignModel()	JROOT/libraries/fof30/Model/DataModel/Relation/BelongsTo.php:43
31	FOF30\Model\DataModel\Relation\BelongsTo->__construct()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:180
30	FOF30\Model\DataModel\RelationManager->addRelation()	JROOT/libraries/fof30/Model/DataModel.php:457
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/HasMany.php:122
25	FOF30\Model\DataModel\Relation\HasMany->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 : 24.66 ms Après la dernière requête : 0.66 ms Mémoire de requête : 0.034 MB mémoire avant requête : 12.485 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.16 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	16.17 ms
init	0.04 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.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.03 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	7.50 ms
closing tables	0.10 ms
freeing items	0.13 ms
cleaning up	0.04 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/fof30/Model/TreeModel.php:57
35	FOF30\Model\TreeModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
34	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
33	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Model/DataModel/Relation.php:256
32	FOF30\Model\DataModel\Relation->getForeignModel()	JROOT/libraries/fof30/Model/DataModel/Relation/BelongsTo.php:43
31	FOF30\Model\DataModel\Relation\BelongsTo->__construct()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:180
30	FOF30\Model\DataModel\RelationManager->addRelation()	JROOT/libraries/fof30/Model/DataModel.php:457
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/HasMany.php:122
25	FOF30\Model\DataModel\Relation\HasMany->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 : 531.45 ms Après la dernière requête : 1.59 ms Mémoire de requête : 0.057 MB mémoire avant requête : 12.518 MB Rangées retournées : 20

Requêtes dupliquées: #28

SELECT *

  FROM nr3zk_nglibrary_books AS book

  WHERE ((
SELECT COUNT(*)

  FROM `nr3zk_nglibrary_copies` AS `reltbl`

  WHERE `reltbl`.`nglibrary_book_id` = `book`.`nglibrary_book_id` 
  AND `nglibrary_bookstatus_id` = "4" 
  AND `periodique` != "1") >= '1')

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	book	index	NULL	PRIMARY	8	NULL	20	79865.00	Using where
2	DEPENDENT SUBQUERY	reltbl	ref	nglibrary_book_id,nglibrary_bookstatus_id	nglibrary_book_id	8	pf4175j0_neuilly.book.nglibrary_book_id	1	100.00	Using where

Profil

Status	Duration
Sending data	0.03 ms
executing	0.03 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.02 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.02 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.04 ms
Sending data	0.04 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.09 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.05 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.02 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.04 ms
executing	0.01 ms
Sending data	0.04 ms
executing	0.01 ms
Sending data	0.12 ms
executing	0.01 ms
Sending data	0.04 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.12 ms
freeing items	0.17 ms
cleaning up	0.16 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 : 517.76 ms Après la dernière requête : 5.73 ms Mémoire de requête : 0.025 MB mémoire avant requête : 12.679 MB Rangées retournées : 1

SELECT COUNT(*)

  FROM nr3zk_nglibrary_books AS book

  WHERE ((
SELECT COUNT(*)

  FROM `nr3zk_nglibrary_copies` AS `reltbl`

  WHERE `reltbl`.`nglibrary_book_id` = `book`.`nglibrary_book_id` 
  AND `nglibrary_bookstatus_id` = "4" 
  AND `periodique` != "1") >= '1')

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	book	index	NULL	nglibrary_book_id	4	NULL	15973	100.00	Using where; Using index
2	DEPENDENT SUBQUERY	reltbl	ref	nglibrary_book_id,nglibrary_bookstatus_id	nglibrary_book_id	8	pf4175j0_neuilly.book.nglibrary_book_id	1	100.00	Using where

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.05 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.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.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.03 ms
executing	0.02 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.03 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.03 ms
executing	0.03 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.04 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.02 ms
query end	0.02 ms
closing tables	0.12 ms
freeing items	0.20 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 : 608.89 ms Après la dernière requête : 31.56 ms Mémoire de requête : 0.059 MB mémoire avant requête : 14.696 MB Rangées retournées : 20

Requêtes dupliquées: #26

SELECT *

  FROM nr3zk_nglibrary_books AS book

  WHERE ((
SELECT COUNT(*)

  FROM `nr3zk_nglibrary_copies` AS `reltbl`

  WHERE `reltbl`.`nglibrary_book_id` = `book`.`nglibrary_book_id` 
  AND `nglibrary_bookstatus_id` = "4" 
  AND `periodique` != "1") >= '1')

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

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	book	index	NULL	PRIMARY	8	NULL	20	79865.00	Using where
2	DEPENDENT SUBQUERY	reltbl	ref	nglibrary_book_id,nglibrary_bookstatus_id	nglibrary_book_id	8	pf4175j0_neuilly.book.nglibrary_book_id	1	100.00	Using where

Profil

Status	Duration
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.02 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.06 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.02 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.04 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.05 ms
executing	0.02 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.05 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.08 ms
freeing items	0.11 ms
cleaning up	0.09 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.89 ms Après la dernière requête : 4.08 ms Mémoire de requête : 0.032 MB mémoire avant requête : 14.853 MB Rangées retournées : 1

SELECT *

  FROM nr3zk_nglibrary_editors

  WHERE (`nglibrary_editor_id` = '17')

  ORDER BY `nglibrary_editor_id` ASC

Explication

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

Profil

Status	Duration
starting	0.28 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.07 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.06 ms
freeing items	0.10 ms
cleaning up	0.06 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.97 ms Après la dernière requête : 8.05 ms Mémoire de requête : 0.032 MB mémoire avant requête : 15.234 MB Rangées retournées : 9

Requêtes dupliquées: #35 #40 #45 #49 #54 #59 #63 #68 #72 #76 #80 #84 #88 #92 #96 #100 #104 #108 #112

SELECT nglibrary_bookstatus_id AS ID

  FROM `nr3zk_nglibrary_bookstatuses`

  WHERE `is_displayed` != 1

Explication

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

Profil

Status	Duration
starting	0.31 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.03 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.08 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.06 ms
freeing items	0.10 ms
cleaning up	0.11 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 : 1.02 ms Après la dernière requête : 0.64 ms Mémoire de requête : 0.030 MB mémoire avant requête : 15.249 MB Rangées retournées : 2

SELECT *

  FROM nr3zk_nglibrary_copies

  WHERE nglibrary_bookstatus_id NOT IN (2,3,5,6,7,8,9,10,12) 
  AND (`nglibrary_book_id` = '6176')

  ORDER BY `nglibrary_copy_id` ASC

Explication

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

Profil

Status	Duration
starting	0.21 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.17 ms
preparing	0.05 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.10 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.06 ms
freeing items	0.10 ms
cleaning up	0.05 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.67 ms Après la dernière requête : 1.76 ms Mémoire de requête : 0.032 MB mémoire avant requête : 15.280 MB Rangées retournées : 1

Requêtes dupliquées: #37 #42 #51 #56 #65

SELECT *

  FROM nr3zk_nglibrary_bookstatuses

  WHERE (`nglibrary_bookstatus_id` = '1')

  ORDER BY `nglibrary_bookstatus_id` ASC

Explication

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

Profil

Status	Duration
starting	0.18 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.10 ms
cleaning up	0.05 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.63 ms Après la dernière requête : 1.34 ms Mémoire de requête : 0.033 MB mémoire avant requête : 15.313 MB Rangées retournées : 1

Requêtes dupliquées: #38 #43 #47 #52 #57 #61 #66 #70 #74 #78 #82 #86 #90 #94 #98 #102 #106 #110 #114

SELECT *

  FROM nr3zk_nglibrary_bookstatuses

  WHERE (`nglibrary_bookstatus_id` = '4')

  ORDER BY `nglibrary_bookstatus_id` ASC

Explication

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

Profil

Status	Duration
starting	0.17 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.04 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.08 ms
cleaning up	0.04 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.89 ms Après la dernière requête : 2.13 ms Mémoire de requête : 0.032 MB mémoire avant requête : 15.345 MB Rangées retournées : 1

SELECT *

  FROM nr3zk_nglibrary_editors

  WHERE (`nglibrary_editor_id` = '770')

  ORDER BY `nglibrary_editor_id` ASC

Explication

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

Profil

Status	Duration
starting	0.24 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.10 ms
cleaning up	0.06 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.87 ms Après la dernière requête : 6.25 ms Mémoire de requête : 0.032 MB mémoire avant requête : 15.393 MB Rangées retournées : 9

Requêtes dupliquées: #30 #40 #45 #49 #54 #59 #63 #68 #72 #76 #80 #84 #88 #92 #96 #100 #104 #108 #112

SELECT nglibrary_bookstatus_id AS ID

  FROM `nr3zk_nglibrary_bookstatuses`

  WHERE `is_displayed` != 1

Explication

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

Profil

Status	Duration
starting	0.27 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 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.06 ms
freeing items	0.08 ms
cleaning up	0.07 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 : 1.14 ms Après la dernière requête : 0.64 ms Mémoire de requête : 0.030 MB mémoire avant requête : 15.407 MB Rangées retournées : 2

SELECT *

  FROM nr3zk_nglibrary_copies

  WHERE nglibrary_bookstatus_id NOT IN (2,3,5,6,7,8,9,10,12) 
  AND (`nglibrary_book_id` = '6489')

  ORDER BY `nglibrary_copy_id` ASC

Explication

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

Profil

Status	Duration
starting	0.33 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.17 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.09 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.05 ms
freeing items	0.09 ms
cleaning up	0.08 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.61 ms Après la dernière requête : 1.14 ms Mémoire de requête : 0.032 MB mémoire avant requête : 15.438 MB Rangées retournées : 1

Requêtes dupliquées: #32 #42 #51 #56 #65

SELECT *

  FROM nr3zk_nglibrary_bookstatuses

  WHERE (`nglibrary_bookstatus_id` = '1')

  ORDER BY `nglibrary_bookstatus_id` ASC

Explication

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

Profil

Status	Duration
starting	0.16 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.03 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.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.09 ms
cleaning up	0.04 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.50 ms Après la dernière requête : 0.98 ms Mémoire de requête : 0.032 MB mémoire avant requête : 15.465 MB Rangées retournées : 1

Requêtes dupliquées: #33 #43 #47 #52 #57 #61 #66 #70 #74 #78 #82 #86 #90 #94 #98 #102 #106 #110 #114

SELECT *

  FROM nr3zk_nglibrary_bookstatuses

  WHERE (`nglibrary_bookstatus_id` = '4')

  ORDER BY `nglibrary_bookstatus_id` ASC

Explication

id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	nr3zk_nglibrary_bookstatuses	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.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.03 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.56 ms Après la dernière requête : 1.22 ms Mémoire de requête : 0.032 MB mémoire avant requête : 15.491 MB Rangées retournées : 1

SELECT *

  FROM nr3zk_nglibrary_editors

  WHERE (`nglibrary_editor_id` = '969')

  ORDER BY `nglibrary_editor_id` ASC

Explication

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

Profil

Status	Duration
starting	0.14 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 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.08 ms
cleaning up	0.05 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.01 ms Après la dernière requête : 3.45 ms Mémoire de requête : 0.032 MB mémoire avant requête : 15.539 MB Rangées retournées : 9

Requêtes dupliquées: #30 #35 #45 #49 #54 #59 #63 #68 #72 #76 #80 #84 #88 #92 #96 #100 #104 #108 #112

SELECT nglibrary_bookstatus_id AS ID

  FROM `nr3zk_nglibrary_bookstatuses`

  WHERE `is_displayed` != 1

Explication

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

Profil

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

Pile d'appels

164 Nouveautés sur le réseau

Console de débogage Joomla!

Session

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

122 requêtes exécutées 2030.22 ms

58 doubles découverts!