Jeunesse

Dispo	Titre	Auteur Principal	Année	Genre	Date d'acquisition	Vues
Livre 0	Roi lion (Le) Résumé Roi lion (Le) Simba, fils du Roi Lion Mufasa, est un lionceau plein d’entrain, toujours prêt à faire des bêtises. Mais Scar, le frère du roi, complote dans l’ombre avec les hyènes. L’un de ses plans diaboliques réussit à chasser Simba de la Terre des Lions. Recueilli par Timon et Pumbaa, Simba grandit dans la philosophie du « Hakuna Matata », en vivant chaque moment pleinement, sans se poser de questions. Jusqu’au jour où il tombe nez à nez avec Nala, son amie d’enfance et il retourne sur la terre des lion pour afronter son oncle scar et le viencre Voici le Territoire des Lions, où vient de naître Simba, fils de Mufasa. Avec Scar, les hyènes vont y semer mort, chaos et désolation. Simba, chassé de son royaume, saura-t-il le reconquérir et lui redonner vie?	Disney Wald	2012	Album jeunesse	06 2023	0
Livre 0	Cars Résumé	Disney Wald	2012	Album jeunesse	06 2023	0
Livre 1	The heartstopper collection (En anglais) T.1 Résumé The heartstopper collection (En anglais) T.1 Shy and softhearted Charlie Spring sits next to rugby player Nick Nelson in class one morning. A warm and intimate friendship follows, and that soon develops into something more for Charlie, who doesn't think he has a chance. But Nick is struggling with feelings of his own, and as the two grow closer and take on the ups and downs of high school, they come to understand the surprising and delightful ways in which love works.	Oseman Alice	2019	BD jeune plus - petit format	06 2023	0
Livre 0	Popote Résumé Popote Popote, la petite crotte, se balade dans la maisonà Elle aime se cacher dans un coin du salon, se faire bronzer sous la fenêtre ou encore prendre un bon bain. Mais elle aime moins se faire renifler par le chien! À la fin de son parcours, Popote aime surtout faire dodo au fond de son petit pot. Dans ce tout-carton, Olivier Dutto et Matthieu Maudet donnent vie à Popote, une petite crotte dégourdie, dont les aventures rigolotes feront découvrir aux tout-petits les différentes pièces d’une maison et les joies du petit pot.	Dutto Olivier	2023	Album petite enfance	06 2023	0
Livre 0	Bibi la brebis !	Charlat Benoît	2022	Album petite enfance	06 2023	0
Livre 0	Blanche-Neige et les 7 nains Résumé Blanche-Neige et les 7 nains Pour fuir la reine qui est jalouse de sa beauté, et veut la tuer, la belle Blanche-Neige se réfugie chez les sept nains de la forêt dont elle devient l'amie. Un jour, le Prince charmant dont elle rêve viendra la chercher. Avant d'aller se coucher quoi de mieux qu'un merveilleux conte Disney ? Après la lecture d'un texte court et simple, les tout-petits s'endormiront avec de jolies images plein les yeux.	Disney Wald	2009	Conte jeunesse	06 2023	0
Livre 0	Rebelle Résumé	Disney Wald	2012	Conte jeunesse	06 2023	0
Livre 0	Monde de Némo (Le) Résumé	Walt Disney company	2004	Album jeunesse	06 2023	1
Livre 0	Maison Résumé Maison Le poulpe construit une belle villa en cailloux, l'oiseau jardinier aménage son incroyable pavillon bleu, l'infatigable castor façonne sa hutte et la chevêchette des saguaros se pelotonne au creux d'un cactus. Ces animaux et bien d'autres bâtisseurs vous invitent aux... Portes ouvertes de maisons extraordinaires ! Avec ses illustrations magnétiques, Isabelle Simler nous plonge dans un monde de rêve bien réel qui fascinera petits et grands.	Simler Isabelle	2022	Documentaire jeunesse	05 2023	13
Livre 0	Phoques de la banquise (Les) Résumé Phoques de la banquise (Les) En arrivant sur la banquise, Captain Paul découvre que des chasseurs ont capturé des bébés phoques. Avec son équipe, il est déterminé à les protéger! Un nouveau héros de littérature jeunesse accoste en France ! Paul Watson, le fondateur charismatique de l'ONG Sea Shepherd, est connu pour ses actions contre les baleiniers et les braconniers du monde entier. Son courage pour défendre les animaux marins suscite un tel engouement qu'en France un demi-million de sympathisants et autres donateurs le soutiennent. Aujourd'hui son ONG, implantée dans de nombreux pays du monde, compte des milliers de bénévoles et collabore avec les polices de différents pays pour mettre fin au braconnage et la souffrance animale.	Gropapa	2021	Album jeunesse	05 2023	12
Livre 0	Célestin T.4 Résumé Célestin T.4 Une aventure titanesque.Calvin Crossland est démasqué. Il est officiellement reconnu comme criminel international, mais ne cherche maintenant plus à se dissimuler. Alyphar et ses cerbères sont envoyés aux quatre coins de la planète pour détruire et tuer... Heureusement, les enfants font tout leur possible pour défendre la planète et contrecarrer ses plans machiavéliques. Dans le même temps, au Congo, Célestin travaille avec sa mère à la mine. D'une ingéniosité surprenante, le jeune garçon est capable de comprendre instinctivement le fonctionnement des machines... En cachette, avec des amis, il a patiemment construit un robot monumental qui n'attend plus qu'une dernière pièce pour se réveiller...Sept enfants dotés de capacités naturelles hors normes sont attirés par une force étrange. Répondant à cet appel, ils découvrent des créatures gigantesques et assistent à leurs réveils. Les Géants est une série-concept dans laquelle le destin de la planète se retrouve entre les mains d'enfants extraordinaires liés à d'immenses créatures élémentaires.	Lylian	2021	BD jeunesse	05 2023	16
Livre 0	Bora et Leap T.3 Résumé Bora et Leap T.3 Une aventure titanesque.Le monde connaît désormais l'existence des Géants. En s'affrontant devant les caméras, Alyphar, Adryel et Yrso ont témoigné de leur incommensurable puissance. La population et les institutions planétaires s'émerveillent autant qu'elles s'inquiètent : peut-on vraiment contrôler ces étranges monstruosités ? Colin Crossland veut prouver qu'il est le seul à en être capable et tente de liguer l'opinion publique contre érin et Siegfried. Dans le même temps, au Cambodge, une jeune fille nommée Leap dit pouvoir communiquer avec les pierres. Son frère jumeau, Borah, n'y voit qu'une fable imaginée pour fuir leur difficile quotidien, entre un père alcoolique et la faim qui les tenaille en permanence. Mais un jour, il rencontre lui aussi Kyma, Géante de Pierre et mémoire du monde. La fable devient réalité mais cette découverte, loin de rapprocher les deux jumeaux, risque de cristalliser leurs différences...Originaires des quatre coins de la planète, sept enfants dotés de capacités naturelles hors normes, sont attirés par une force étrange. Répondant à cet appel, ils découvrent des créatures gigantesques et assistent à leurs réveils. Les Géants est une série-concept dans laquelle le destin de la planète se retrouve entre les mains d'enfants extraordinaires liés à d'immenses créatures élémentaires.	Lylian	2021	BD jeunesse	05 2023	19
Livre 0	Luyana T.5 Résumé Luyana T.5 L'espoir se cache là où on ne l'attend pas...Les enfants et leurs géants ont été défaits par Alyphar dans un combat sans merci qui a laissé des traces. Ils sont désormais contrôlés par Alyphar et Calvin Crossland. Seul Célestin réussit à s'échapper de justesse. L'avenir de l'Humanité semble bien compromis tant la puissance d'Alyphar ne peut plus être contestée. Il reste pourtant un infime espoir, et cet espoir habite en pleine nature canadienne au sein de la tribu des Indiens Crie. Une jeune fille prénommée Luyana pourrait reprendre le flambeau avec son géant Wakytshi. Seulement voilà, malgré des rêves qui lui montrent le sombre destin qui attend l'Humanité, elle n'a aucune envie de s'impliquer dans ce combat. Au prix d'un terrible effort, les autres Géants arrivent à entrer en communication avec elle pour lui demander son aide. Pourra-t-elle rester encore longtemps à l'écart de ce combat et refuser son destin de devenir la grande chamane annoncée par la prophétie de son peuple ?	Lylian	2022	BD jeunesse	05 2023	18
Livre 0	Yatho T.6 Résumé Yatho T.6 L'heure du combat final a sonné.Le Géant maléfique Alyphar a réussi à s'emparer de Yatho, le garçon qui l'a sorti de son long sommeil. Désormais, sa puissance semble sans limite ! En continuant d'exercer le contrôle sur le reste des Géants, il sème la terreur aux quatre coins du globe. L'humanité risque de sombrer dans le chaos le plus total si on ne trouve pas un moyen de l'arrêter. Un infime espoir réside encore du côté de Tyrl, le géant de Célestin. Si Célestin arrive à attirer Yatho loin d'Alyphar peut-être que les militaires auraient une chance d'agir. Mais ils vont rapidement s'apercevoir qu'aucune arme humaine n'est en mesure de détruire Alyphar. Pour Célestin, la solution est ailleurs : il faut extraire les enfants de leur géants pollués par le pouvoir d'Alyphar ! Le temps est venu pour les enfants et les géants d'unir leur force pour se lancer dans l'ultime bataille. Parviendront-ils à sauver le monde sans un douloureux sacrifice ? Ce dernier tome clôt en beauté cette série d'aventure chargé d'action et d'émotions, où l'écologie et la force de la nature demeurent des sujets de fond. Mais l'univers des Géants ne s'éteint pas pour autant, puisque d'ores et déjà, les auteurs travaillent sur un deuxième cycle prometteur.	Lylian	2022	BD jeunesse	05 2023	16
Livre 0	Fête de Billy (La) Résumé Fête de Billy (La) C¹est l¹anniversaire de Billy aujourd¹hui ! Ce qui lui ferait plaisir ? Des noisettes bien grillées, et un bal costumé. Les noisettes, son papa s¹en charge. Mais l¹organisation de la fête incombe à Billy. Le voilà parti pour inviter ses amis : Jean-Claude le ver de terre, qui vient d¹avoir un tout petit frère, Didier ! Et Josette la souris ! Et le bison ! Hélas, Jack le vautour menace de gâcher la fête par sa mauvaise humeur et ses menaces ! à moins que Billy ne trouve une idée géniale pour l¹amadouer[xe2][x80][xa6]	Valckx Catharina	2016	Album jeunesse	05 2023	13
Livre 0	Tombé ! Résumé Tombé ! Ce matin Merle glisse sur la rosée et tombe de la branche. BOUM ! Oie arrive : "Oh, Merle, tu as mal ?". "Tu dois avoir très mal ! ajoute Roro. C'est tout bleu !". Pinson se précipite : "Oh là là ! C'est tout rouge ! Ca doit faire vrrraiiiiment trrrèèèès mal... Hein, Merle, hein ?", confirme Pinson. "Euh, ça va", répond Merle qui n'ose plus rien dire.	Dubois Claude K.	2016	Album jeunesse	05 2023	13
Livre 0	Cherche amis Résumé	Poussier Audrey	2005	Album jeunesse	05 2023	16
Livre 0	Cornebidouille contre Cornebidouille Résumé Cornebidouille contre Cornebidouille Dans La vengeance de Cornebidouille, Pierre avait réussi à faire manger sa propre soupe à l’abominable Cornebidouille, ce qui l’avait illico transformée en potironà Mais une sorcière se résigne-t-elle à sortir de la vie de ses victimes ? Non ! Plus tard, quand sa maman coupe en deux un poti ron pour le dîner et qu’aussitôt une odeur épouvantable se répand, Pierre a une intuition : Cornebidouille est de retourà Il ne se trompe que sur un détail. À présent, elles sont deux et elles veulent se venger. Il va encore falloir ruser	Bertrand Pierre	2017	Album jeunesse	05 2023	18
Livre 0	T'as qu'à t'retenir ! T.8 (Précédé de Mon premier mot du monde) Résumé T'as qu'à t'retenir ! T.8 Avant de courir la parfaite aventure, Spirou était petit, et oui ! Déjà vif et débrouillard, le petit Spirou n'est jamais en reste lorsqu'il s'agit d'imaginer les pires bêtises. Enfin, lui ce qu'il veut, c'est seulement comprendre un peu mieux le monde des adultes et un peu les filles aussi... Alors forcément, les grands le trouvent un peu turbulent mais rappelez-vous quand vous étiez petit, vous aviez aussi envie de tout savoir. Et pour ça tous les moyens sont bons. Et puis ses bêtises, on les a déjà faites sauf peut être les vraiment très très grosses. Enfin, on aurait bien aimé les faire parfois.	Janry	1999	BD jeunesse	05 2023	16
Livre 0	Attention ! Cancre Résumé Attention ! Cancre L’Élève Ducobu est un gamin sympathique et farceur, mais un cancre notoire. Une «qualité» qui n’est pas de tout repos. C’est qu’il faut être drôlement débrouillard pour réussir à éviter l’humiliant bonnet d’âne ! Bien sûr, il y a sa voisine Léonie qui sait tout sur tout. Mais, cette chipie déteste les copieurs... Alors, les réponses que ses œillades ne lui ont pas apprises, Ducobu les invente !	Janry	1999	BD jeunesse	05 2023	14

Console de débogage Joomla!

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1686116518,
                "last": 1686116518,
                "now": 1686116518
            },
            "token": "6qGILzdRjyskPLIuQ2Z0DhewAhCzcIZV"
        },
        "registry": {
            "Com_nglibrary": {
                "Books": {
                    "copies": {
                        "hideperiodique": "1",
                        "statusId": "6"
                    },
                    "filter_order": "created_on",
                    "filter_order_Dir": "DESC",
                    "_outerGlue": "AND",
                    "grp_public": "Jeune"
                }
            }
        },
        "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: 19.70 ms / 19.70 ms Mémoire: 2.022 MB / 2.41 MB Application: afterLoad

Temps: 69.68 ms / 89.38 ms Mémoire: 4.697 MB / 7.11 MB Application: afterInitialise

Temps: 18.04 ms / 107.41 ms Mémoire: 1.050 MB / 8.16 MB Application: afterRoute

Temps: 3.17 ms / 110.58 ms Mémoire: 0.160 MB / 8.32 MB Application: beforeRenderComponent com_nglibrary

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

Temps: 2.14 ms / 194.54 ms Mémoire: 0.065 MB / 12.93 MB Application: After Access::preloadComponents (all components)

Temps: 0.05 ms / 194.59 ms Mémoire: -0.003 MB / 12.93 MB Application: Before Access::getAssetRules (id:62 name:com_nglibrary)

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

Temps: 786.51 ms / 981.94 ms Mémoire: 5.542 MB / 18.50 MB Application: afterRenderComponent com_nglibrary

Temps: 1.06 ms / 983.00 ms Mémoire: 0.008 MB / 18.50 MB Application: afterDispatch

Temps: 15.85 ms / 998.85 ms Mémoire: 0.362 MB / 18.87 MB Application: beforeRenderModule mod_articles_category (Pied de page)

Temps: 2.81 ms / 1001.66 ms Mémoire: 0.215 MB / 19.08 MB Application: Before Access::getAssetRules (id:8 name:com_content)

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

Temps: 7.47 ms / 1009.19 ms Mémoire: 0.220 MB / 19.31 MB Application: afterRenderModule mod_articles_category (Pied de page)

Temps: 0.09 ms / 1009.27 ms Mémoire: -0.084 MB / 19.22 MB Application: beforeRenderModule mod_breadcrumbs (Fil d'Ariane)

Temps: 1.90 ms / 1011.17 ms Mémoire: 0.051 MB / 19.27 MB Application: afterRenderModule mod_breadcrumbs (Fil d'Ariane)

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

Temps: 0.67 ms / 1011.90 ms Mémoire: 0.008 MB / 19.28 MB Application: afterRenderModule mod_custom (Suggestions)

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

Temps: 157.02 ms / 1168.98 ms Mémoire: -0.981 MB / 18.30 MB Application: afterRenderModule mod_ngsearch (Recherche)

Temps: 0.09 ms / 1169.07 ms Mémoire: -0.026 MB / 18.27 MB Application: beforeRenderModule mod_custom (Horaires d'ouverture et contact)

Temps: 0.42 ms / 1169.49 ms Mémoire: 0.003 MB / 18.28 MB Application: afterRenderModule mod_custom (Horaires d'ouverture et contact)

Temps: 0.10 ms / 1169.59 ms Mémoire: 0.008 MB / 18.28 MB Application: beforeRenderModule mod_menu (Main Menu)

Temps: 10.18 ms / 1179.77 ms Mémoire: 0.232 MB / 18.52 MB Application: afterRenderModule mod_menu (Main Menu)

Temps: 0.13 ms / 1179.91 ms Mémoire: -0.006 MB / 18.51 MB Application: beforeRenderModule mod_login (Connexion)

Temps: 2.76 ms / 1182.67 ms Mémoire: 0.036 MB / 18.55 MB Application: afterRenderModule mod_login (Connexion)

Temps: 8.23 ms / 1190.90 ms Mémoire: 0.319 MB / 18.86 MB Application: afterRender

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

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

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

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

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

EXPLAIN impossible sur la requête : INSERT INTO `nr3zk_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3263333536353665396634346561356636653037636338353634323263373965', 1, 1686116518, 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:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

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

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

  FROM `nr3zk_extensions`

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

Explication

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

Profil

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

SELECT id, rules

  FROM `nr3zk_viewlevels`

Explication

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

Profil

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.48 ms Après la dernière requête : 0.09 ms Mémoire de requête : 0.021 MB mémoire avant requête : 4.769 MB Rangées retournées : 2

SELECT b.id

  FROM nr3zk_usergroups AS a

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

  WHERE a.id = 9

Explication

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

Profil

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.05 ms Après la dernière requête : 0.68 ms Mémoire de requête : 0.030 MB mémoire avant requête : 4.838 MB Rangées retournées : 97

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

  FROM nr3zk_extensions

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

  ORDER BY ordering

Explication

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

Profil

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 : 0.90 ms Après la dernière requête : 19.65 ms Mémoire de requête : 0.021 MB mémoire avant requête : 6.587 MB Rangées retournées : 1

SELECT `extension`

  FROM `nr3zk_action_logs_extensions`

  WHERE `extension` = 'com_icagenda'

Explication

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

Profil

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/plugins/actionlog/icagenda/icagenda.php:111
10	PlgActionlogIcagenda->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
9	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
8	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/plugins/system/actionlogs/actionlogs.php:64
7	PlgSystemActionLogs->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM nr3zk_menu AS m

  LEFT JOIN nr3zk_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explication

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

Profil

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:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

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

  FROM `nr3zk_extensions`

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

Explication

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

Profil

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:1498
8	plgSystemGdpr->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

UPDATE `nr3zk_extensions`

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

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

Explication

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

Profil

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:1498
8	plgSystemGdpr->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT *

  FROM nr3zk_languages

  WHERE published=1

  ORDER BY ordering ASC

Explication

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

Profil

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 : 0.83 ms Après la dernière requête : 0.23 ms Mémoire de requête : 0.019 MB mémoire avant requête : 8.185 MB Rangées retournées : 3

SELECT id, home, template, s.params

  FROM nr3zk_template_styles as s

  LEFT JOIN nr3zk_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explication

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

Profil

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

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

SELECT `manifest_cache`

  FROM `nr3zk_extensions`

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

Explication

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

Profil

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

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

SELECT `manifest_cache`

  FROM `nr3zk_extensions`

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

Explication

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

Profil

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

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

SELECT `manifest_cache`

  FROM `nr3zk_extensions`

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

Explication

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

Profil

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

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

SELECT `manifest_cache`

  FROM `nr3zk_extensions`

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

Explication

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

Profil

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.30 ms Après la dernière requête : 16.17 ms Mémoire de requête : 0.028 MB mémoire avant requête : 10.565 MB Rangées retournées : 110

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 : 1.57 ms Après la dernière requête : 0.22 ms Mémoire de requête : 0.033 MB mémoire avant requête : 10.588 MB Rangées retournées : 39

SHOW FULL COLUMNS 
  FROM `nr3zk_nglibrary_books`

Explication

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

Profil

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 : 1.15 ms Après la dernière requête : 7.06 ms Mémoire de requête : 0.028 MB mémoire avant requête : 11.111 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.92 ms Après la dernière requête : 1.26 ms Mémoire de requête : 0.024 MB mémoire avant requête : 11.208 MB Rangées retournées : 1

SELECT `params`

  FROM `nr3zk_extensions`

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

Explication

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

Profil

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 : 0.85 ms Après la dernière requête : 20.21 ms Mémoire de requête : 0.026 MB mémoire avant requête : 12.171 MB Rangées retournées : 1

Requêtes dupliquées: #24

SELECT *

  FROM nr3zk_wf_profiles

  WHERE published = 1

  ORDER BY ordering ASC

Explication

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

Profil

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

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

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

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

  FROM nr3zk_fields AS a

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

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

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

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

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

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

  ORDER BY a.ordering ASC

Explication

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

Profil

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:194
21	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
20	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:286
19	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:305
18	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/fof30/Platform/Joomla/Platform.php:559
15	FOF30\Platform\Joomla\Platform->runPlugins()	JROOT/libraries/fof30/Model/DataModel.php:4196
14	FOF30\Model\DataModel->preprocessForm()	JROOT/libraries/fof30/Model/DataModel.php:4139
13	FOF30\Model\DataModel->loadForm()	JROOT/libraries/fof30/Model/DataModel.php:4076
12	FOF30\Model\DataModel->getForm()	JROOT/libraries/fof30/Controller/DataController.php:419
11	FOF30\Controller\DataController->browse()	JROOT/components/com_nglibrary/Controller/Book.php:88
10	Nglibrary\Site\Controller\Book->browse()	JROOT/libraries/fof30/Controller/Controller.php:410
9	FOF30\Controller\Controller->execute()	JROOT/libraries/fof30/Controller/DataController.php:158
8	FOF30\Controller\DataController->execute()	JROOT/libraries/fof30/Dispatcher/Dispatcher.php:175
7	FOF30\Dispatcher\Dispatcher->dispatch()	JROOT/components/com_nglibrary/nglibrary.php:21
6	require_once JROOT/components/com_nglibrary/nglibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

Requêtes dupliquées: #22

SELECT *

  FROM nr3zk_wf_profiles

  WHERE published = 1

  ORDER BY ordering ASC

Explication

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

Profil

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

Pile d'appels

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

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

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

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

  FROM `nr3zk_assets`

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

Explication

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

Profil

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

Pile d'appels

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

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

Temps de requête : 1.59 ms Après la dernière requête : 9.20 ms Mémoire de requête : 0.035 MB mémoire avant requête : 13.204 MB Rangées retournées : 22

SHOW FULL COLUMNS 
  FROM `nr3zk_nglibrary_copies`

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
33	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
32	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
31	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/fof30/Model/DataModel.php:788
30	FOF30\Model\DataModel->getTableFields()	JROOT/libraries/fof30/Model/DataModel.php:250
29	FOF30\Model\DataModel->__construct()	JROOT/libraries/ngfof/Factory/Magic/ModelFactory.php:81
28	Ngfof\Factory\Magic\ModelFactory->make()	JROOT/libraries/ngfof/Factory/MagicFactory.php:40
27	Ngfof\Factory\MagicFactory->model()	JROOT/libraries/fof30/Model/DataModel/Relation.php:256
26	FOF30\Model\DataModel\Relation->getForeignModel()	JROOT/libraries/fof30/Model/DataModel/Relation/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 : 1.07 ms Après la dernière requête : 1.84 ms Mémoire de requête : 0.035 MB mémoire avant requête : 13.290 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.14 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.21 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.10 ms
closing tables	0.05 ms
freeing items	0.10 ms
cleaning up	0.02 ms

Pile d'appels

#	Appel	Fichier et numéro de ligne
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 : 0.88 ms Après la dernière requête : 0.59 ms Mémoire de requête : 0.034 MB mémoire avant requête : 13.322 MB Rangées retournées : 6

SHOW FULL COLUMNS 
  FROM `nr3zk_nglibrary_bookstatuses`

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
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 : 197.13 ms Après la dernière requête : 0.91 ms Mémoire de requête : 0.057 MB mémoire avant requête : 13.355 MB Rangées retournées : 20

Requêtes dupliquées: #31

SELECT *

  FROM nr3zk_nglibrary_books AS book

  WHERE (`book`.`grp_public` LIKE '%Jeune%') 
  AND ((
SELECT COUNT(*)

  FROM `nr3zk_nglibrary_copies` AS `reltbl`

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

  ORDER BY `created_on` DESC,`created_on` DESC 
  LIMIT 20

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	book	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	18382	11.11	Using where; Utilisation du tri complet de type filesort
2	DEPENDENT SUBQUERY	reltbl	NULL	ref	nglibrary_book_id,nglibrary_bookstatus_id	nglibrary_book_id	8	b54bqdde_thones.book.nglibrary_book_id	1	4.68	Using where

Profil

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

Pile d'appels

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

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

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

SELECT COUNT(*)

  FROM nr3zk_nglibrary_books AS book

  WHERE (`book`.`grp_public` LIKE '%Jeune%') 
  AND ((
SELECT COUNT(*)

  FROM `nr3zk_nglibrary_copies` AS `reltbl`

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

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	book	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	18382	11.11	Using where
2	DEPENDENT SUBQUERY	reltbl	NULL	ref	nglibrary_book_id,nglibrary_bookstatus_id	nglibrary_book_id	8	b54bqdde_thones.book.nglibrary_book_id	1	4.68	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.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.07 ms
freeing items	0.12 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 : 199.09 ms Après la dernière requête : 29.24 ms Mémoire de requête : 0.059 MB mémoire avant requête : 15.535 MB Rangées retournées : 20

Requêtes dupliquées: #29

SELECT *

  FROM nr3zk_nglibrary_books AS book

  WHERE (`book`.`grp_public` LIKE '%Jeune%') 
  AND ((
SELECT COUNT(*)

  FROM `nr3zk_nglibrary_copies` AS `reltbl`

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

  ORDER BY `created_on` DESC,`created_on` DESC 
  LIMIT 20

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	book	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	18382	11.11	Using where; Utilisation du tri complet de type filesort
2	DEPENDENT SUBQUERY	reltbl	NULL	ref	nglibrary_book_id,nglibrary_bookstatus_id	nglibrary_book_id	8	b54bqdde_thones.book.nglibrary_book_id	1	4.68	Using where

Profil

Status	Duration
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.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.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.02 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
executing	0.01 ms
Sending data	0.32 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.06 ms
freeing items	0.12 ms
cleaning up	0.03 ms

Pile d'appels

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

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

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

Requêtes dupliquées: #36 #52 #56

SELECT *

  FROM nr3zk_nglibrary_editors

  WHERE (`nglibrary_editor_id` = '117')

  ORDER BY `nglibrary_editor_id` ASC

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
33	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
32	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
31	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
30	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
29	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/Relation/HasOne.php:39
28	FOF30\Model\DataModel\Relation\HasOne->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
27	FOF30\Model\DataModel\RelationManager->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:513
26	FOF30\Model\DataModel\RelationManager->__get()	JROOT/libraries/fof30/Model/DataModel.php:595
25	FOF30\Model\DataModel->__get()	JROOT/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.69 ms Après la dernière requête : 7.95 ms Mémoire de requête : 0.033 MB mémoire avant requête : 16.077 MB Rangées retournées : 6

Requêtes dupliquées: #37 #41 #45 #49 #53 #57 #61 #65 #69 #73 #77 #81 #85 #89 #93 #97 #101 #105 #109

SELECT nglibrary_bookstatus_id AS ID

  FROM `nr3zk_nglibrary_bookstatuses`

  WHERE `is_displayed` != 1

Explication

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

Profil

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

Pile d'appels

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

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

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

SELECT *

  FROM nr3zk_nglibrary_copies

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

  ORDER BY `nglibrary_copy_id` ASC

Explication

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

Profil

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

Pile d'appels

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

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

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

Requêtes dupliquées: #39 #43 #47 #51 #55 #59 #63 #67 #71 #75 #79 #83 #87 #91 #95 #99 #103 #107 #111

SELECT *

  FROM nr3zk_nglibrary_bookstatuses

  WHERE (`nglibrary_bookstatus_id` = '6')

  ORDER BY `nglibrary_bookstatus_id` ASC

Explication

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

Profil

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

Pile d'appels

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

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

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

Requêtes dupliquées: #32 #52 #56

SELECT *

  FROM nr3zk_nglibrary_editors

  WHERE (`nglibrary_editor_id` = '117')

  ORDER BY `nglibrary_editor_id` ASC

Explication

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

Profil

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

Pile d'appels

#	Appel	Fichier et numéro de ligne
34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
33	JDatabaseDriver->loadAssocList()	JROOT/libraries/fof30/Model/DataModel.php:1840
32	FOF30\Model\DataModel->getRawDataArray()	JROOT/libraries/fof30/Model/DataModel.php:1802
31	FOF30\Model\DataModel->getItemsArray()	JROOT/libraries/fof30/Model/DataModel.php:1784
30	FOF30\Model\DataModel->get()	JROOT/libraries/fof30/Model/DataModel/Relation.php:156
29	FOF30\Model\DataModel\Relation->getData()	JROOT/libraries/fof30/Model/DataModel/Relation/HasOne.php:39
28	FOF30\Model\DataModel\Relation\HasOne->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:342
27	FOF30\Model\DataModel\RelationManager->getData()	JROOT/libraries/fof30/Model/DataModel/RelationManager.php:513
26	FOF30\Model\DataModel\RelationManager->__get()	JROOT/libraries/fof30/Model/DataModel.php:595
25	FOF30\Model\DataModel->__get()	JROOT/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.51 ms Après la dernière requête : 2.82 ms Mémoire de requête : 0.032 MB mémoire avant requête : 16.269 MB Rangées retournées : 6

Requêtes dupliquées: #33 #41 #45 #49 #53 #57 #61 #65 #69 #73 #77 #81 #85 #89 #93 #97 #101 #105 #109

SELECT nglibrary_bookstatus_id AS ID

  FROM `nr3zk_nglibrary_bookstatuses`

  WHERE `is_displayed` != 1

Explication

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

Profil

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

Pile d'appels

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

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

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

SELECT *

  FROM nr3zk_nglibrary_copies

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

  ORDER BY `nglibrary_copy_id` ASC

Explication

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

Profil

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

Pile d'appels

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

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

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

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

159 Nouveautés jeunes

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 724.14 ms

59 doubles découverts!