Ciclul Liceal

Articole ciclul liceal

31 Mai 2023

20 Mai 2023

18 Mai 2023

17 Mai 2023

11 Mai 2023

9 Mai 2023

7 Mai 2023

4 Mai 2023

30 Aprilie 2023

6 Aprilie 2023

3 Aprilie 2023

31 Martie 2023

24 Ianuarie 2023

15 Ianuarie 2023

12 Octombrie 2022

30 Aprilie 2022

Olimpiada Naționala de Religie pentru Seminarii și Licee Teologice Ortodoxe, Botoșani, 2022.

Ziua Internațională a Francofoniei.

22 Martie 2022

8 Martie 2022

15 Ianuarie 2022

“Eminescu n-a existat. A existat numai o ţară frumoasă La o margine de mare…” - spunea Marin Sorescu.

Iar noi spunem că o țară există printr-un poet. Eminescu.

Pentru că, inevitabil, cultura țării noastre poartă amprenta eminescină, limba noastră nu a fost niciodată mai cuprinzătoare, mai expresivă, mai capabilă de a exprima frumusețea folclorului, filosofiei sau mitologiei, dar nici lacurile, râurile, codrii sau potecile din crânguri n-au fost mai pitorești decât în creația lui Eminescu, personalitatea poetului național a fost marcată în Liceul Ortodox “Sf. Nicolae” din Zalău prin recitări de poezii și ascultarea unor cântece pe versurile acestuia, în interpretarea Corului Mixt al școlii, condus cu atâta dăruire de domnul profesor Lazăr Florin, căruia îi și aparține inițiativa pregătirii momentului festiv.

22 Decembrie 2021

Corul "Predania" al Liceului Ortodox ,,Sf. Nicolae" Zalau vă urează:

Sărbători fericite!

<br />

20 Noiembrie

Săptămâna Educației Globale.

În perioada 15 - 20 Noiembrie, elevii Liceului Ortodox ,,Sf. Nicolae" Zalău, au participat intr-un mod aparte, creativ, in cadrul Săptămânii Educației Globale.

Titlul proiectului:

,,Împreună pentru un mediu curat, pentru o lume mai bună" este parte integrantă a temei acestei săptămâni.

,,Lumea e a noastră, să acționăm împreună"

Prof. coordonator, Maria Gordan și diriginte, Pr. Prof. Petru Brisc.

3 Iunie 2021

Festivitatea de absolvire a elevilor clasei a XII- a a Liceului Ortodox „Sf. Nicolae” din Zalău

Joi, 3 Iunie 2021, a avut loc Festivitatea de absolvire a elevilor clasei a XII- a a Liceului Ortodox „Sf. Nicolae” din Zalău.

Felicitări, dragi absolvenţi! Succes la examene! Fiţi binecuvântaţi cu dragoste şi împlinire sufletească!

Ortodoxia noastră

Epicopia Sălajului

Mitropolia Clujului, Maramureșului și Sălajului

Patriarhia Română

Facultatea de Teologie Ortodoxa

Agenția de știri Basilica

Ziarul Lumina

Trinitas TV

Radio Trinitas

Ediția Sinodală a Sfintei Scripturi

Consola de depanare Joomla!

Sesiune

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

Informații profil

Timp

Memorie

Timp: 11.99 ms / 11.99 ms Memorie: 0.416 MB / 0.74 MB Application: afterLoad

Timp: 42.12 ms / 54.12 ms Memorie: 0.989 MB / 1.73 MB Application: afterInitialise

Timp: 6.08 ms / 60.20 ms Memorie: 0.082 MB / 1.81 MB Application: afterRoute

Timp: 7.96 ms / 68.16 ms Memorie: 0.060 MB / 1.87 MB Application: beforeRenderComponent com_content

Timp: 4.43 ms / 72.59 ms Memorie: 0.134 MB / 2.01 MB Application: Before Access::preloadComponents (all components)

Timp: 1.91 ms / 74.50 ms Memorie: 0.059 MB / 2.06 MB Application: After Access::preloadComponents (all components)

Timp: 0.06 ms / 74.56 ms Memorie: -0.002 MB / 2.06 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Timp: 0.42 ms / 74.98 ms Memorie: 0.009 MB / 2.07 MB Application: After Access::getAssetRules (id:8 name:com_content)

Timp: 75.99 ms / 150.96 ms Memorie: 0.740 MB / 2.81 MB Application: afterRenderComponent com_content

Timp: 2.30 ms / 153.27 ms Memorie: 0.008 MB / 2.82 MB Application: afterDispatch

Timp: 7.36 ms / 160.63 ms Memorie: 0.058 MB / 2.88 MB Application: beforeRenderModule mod_custom (Calendar Widget)

Timp: 0.79 ms / 161.42 ms Memorie: 0.005 MB / 2.88 MB Application: afterRenderModule mod_custom (Calendar Widget)

Timp: 0.03 ms / 161.45 ms Memorie: -0.002 MB / 2.88 MB Application: beforeRenderModule mod_custom (Ortodoxia noastră)

Timp: 3.93 ms / 165.37 ms Memorie: 0.018 MB / 2.90 MB Application: afterRenderModule mod_custom (Ortodoxia noastră)

Timp: 0.04 ms / 165.41 ms Memorie: 0.002 MB / 2.90 MB Application: beforeRenderModule mod_menu (User Menu)

Timp: 0.75 ms / 166.16 ms Memorie: 0.009 MB / 2.91 MB Application: afterRenderModule mod_menu (User Menu)

Timp: 0.05 ms / 166.21 ms Memorie: -0.004 MB / 2.91 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Timp: 1.70 ms / 167.91 ms Memorie: 0.017 MB / 2.92 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Timp: 0.07 ms / 167.98 ms Memorie: -0.001 MB / 2.92 MB Application: beforeRenderModule mod_menu (Main Menu)

Timp: 1.75 ms / 169.73 ms Memorie: 0.036 MB / 2.96 MB Application: afterRenderModule mod_menu (Main Menu)

Timp: 0.03 ms / 169.76 ms Memorie: -0.003 MB / 2.95 MB Application: beforeRenderModule mod_menu (Institutia de invatamant)

Timp: 1.71 ms / 171.47 ms Memorie: 0.055 MB / 3.01 MB Application: afterRenderModule mod_menu (Institutia de invatamant)

Timp: 0.05 ms / 171.53 ms Memorie: -0.001 MB / 3.01 MB Application: beforeRenderModule mod_banners (banner_cruci)

Timp: 4.16 ms / 175.69 ms Memorie: 0.032 MB / 3.04 MB Application: afterRenderModule mod_banners (banner_cruci)

Timp: 0.08 ms / 175.77 ms Memorie: 0.004 MB / 3.04 MB Application: beforeRenderModule mod_sigplus (sigplus)

Timp: 43.37 ms / 219.13 ms Memorie: 0.139 MB / 3.18 MB Application: afterRenderModule mod_sigplus (sigplus)

Timp: 2.15 ms / 221.29 ms Memorie: 0.080 MB / 3.26 MB Application: afterRender

Total interogări bază de date: 106.96 ms

Utilizare memorie

Interogări bază de date

41 Interogări înregistrate 106.96 ms

12 duplicate găsite!

2 duplicate: #20 #33

2 duplicate: #23 #36

2 duplicate: #24 #37

2 duplicate: #25 #38

2 duplicate: #26 #27

2 duplicate: #39 #40

Timp interogare: 1.37 ms Interogare memorie: 0.023 MB Memorie înainte de interogare: 1.027 MB Linii returnate: 0

SELECT `data`

  FROM `jos8m_session`

  WHERE `session_id` = X'3536336466386232313439366532623032613964396263623139373666633036'

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos8m_session	const	PRIMARY	PRIMARY	194	const	1

Profil

Status	Duration
Starting	0.17 ms
Checking permissions	0.05 ms
Opening tables	0.06 ms
After opening tables	0.04 ms
System lock	0.05 ms
Table lock	0.04 ms
Init	0.06 ms
Optimizing	0.05 ms
Statistics	0.11 ms
Preparing	0.05 ms
Executing	0.05 ms
End of update loop	0.04 ms
Query end	0.14 ms
Commit	0.05 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.13 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
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

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 1.01 ms După ultima interogare: 0.83 ms Interogare memorie: 0.020 MB Memorie înainte de interogare: 1.041 MB Linii returnate: 0

SELECT `session_id`

  FROM `jos8m_session`

  WHERE `session_id` = X'3536336466386232313439366532623032613964396263623139373666633036' 
  LIMIT 1

Explicație

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

Profil

Status	Duration
Starting	0.08 ms
Checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.05 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.06 ms
Preparing	0.07 ms
Executing	0.04 ms
End of update loop	0.05 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
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

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 1.25 ms După ultima interogare: 0.13 ms Interogare memorie: 0.004 MB Memorie înainte de interogare: 1.046 MB

INSERT INTO `jos8m_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'3536336466386232313439366532623032613964396263623139373666633036', 1, 1696246726, 0, '', 0)

Explicație

EXPLAIN nu este posibil în interogare: INSERT INTO `jos8m_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3536336466386232313439366532623032613964396263623139373666633036', 1, 1696246726, 0, '', 0)

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.04 ms
Init for update	0.05 ms
Update	0.18 ms
Waiting for query cache lock	0.05 ms
Update	0.05 ms
End of update loop	0.04 ms
Query end	0.04 ms
Commit	0.10 ms
Writing to binlog	0.05 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.10 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
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

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 1.50 ms După ultima interogare: 1.08 ms Interogare memorie: 0.024 MB Memorie înainte de interogare: 1.077 MB Linii returnate: 37

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

  FROM `jos8m_extensions`

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

Explicație

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

Profil

Status	Duration
Starting	0.11 ms
Checking permissions	0.05 ms
Opening tables	0.07 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.04 ms
Init	0.06 ms
Optimizing	0.06 ms
Statistics	0.11 ms
Preparing	0.07 ms
Executing	0.04 ms
Sending data	0.27 ms
End of update loop	0.06 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.05 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.06 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
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}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php: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

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 1.15 ms După ultima interogare: 1.18 ms Interogare memorie: 0.021 MB Memorie înainte de interogare: 1.105 MB Linii returnate: 5

SELECT id, rules

  FROM `jos8m_viewlevels`

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos8m_viewlevels	ALL	NULL	NICI O CHEIE INDEX NU A PUTUT FI FOLOSITĂ	NULL	NULL	5

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.04 ms
Opening tables	0.08 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.04 ms
Init	0.05 ms
Optimizing	0.06 ms
Statistics	0.05 ms
Preparing	0.05 ms
Executing	0.04 ms
Sending data	0.09 ms
End of update loop	0.05 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.06 ms
Reset for next command	0.27 ms

Stivă Call

#	Apelant	Număr fișier și linie
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

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 1.34 ms După ultima interogare: 0.13 ms Interogare memorie: 0.021 MB Memorie înainte de interogare: 1.117 MB Linii returnate: 2

SELECT b.id

  FROM jos8m_usergroups AS a

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

  WHERE a.id = 9

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	10	Using where; Using index

Profil

Status	Duration
Starting	0.08 ms
Checking permissions	0.07 ms
Opening tables	0.06 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.04 ms
Init	0.05 ms
Optimizing	0.05 ms
Statistics	0.10 ms
Preparing	0.05 ms
Unlocking tables	0.04 ms
Preparing	0.05 ms
Executing	0.04 ms
Sending data	0.07 ms
End of update loop	0.04 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.06 ms
Closing tables	0.04 ms
Starting cleanup	0.05 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
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

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 1.92 ms După ultima interogare: 0.22 ms Interogare memorie: 0.030 MB Memorie înainte de interogare: 1.138 MB Linii returnate: 91

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

  FROM jos8m_extensions

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

  ORDER BY ordering

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos8m_extensions	ref	extension	extension	82	const	112	Using index condition; Using where; Folosire filesort

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.04 ms
Init	0.06 ms
Optimizing	0.05 ms
Statistics	0.08 ms
Preparing	0.06 ms
Sorting result	0.06 ms
Executing	0.04 ms
Sending data	0.04 ms
Creating sort index	0.70 ms
End of update loop	0.05 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.05 ms
Closing tables	0.05 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.06 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
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}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php: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

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 1.85 ms După ultima interogare: 15.46 ms Interogare memorie: 0.049 MB Memorie înainte de interogare: 1.604 MB Linii returnate: 17

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

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

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	20	Using index condition; Using where; Folosire filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	liceulor_joom422.m.component_id	1	Using where

Profil

Status	Duration
Starting	0.24 ms
Checking permissions	0.05 ms
Opening tables	0.08 ms
After opening tables	0.05 ms
System lock	0.04 ms
Table lock	0.05 ms
Init	0.08 ms
Optimizing	0.06 ms
Statistics	0.11 ms
Preparing	0.08 ms
Sorting result	0.05 ms
Executing	0.05 ms
Sending data	0.06 ms
Creating sort index	0.37 ms
End of update loop	0.05 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.05 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/dropfiles/dropfiles.php:37
8	PlgSystemDropfiles->onAfterInitialise()	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:668
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

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 1.33 ms După ultima interogare: 7.56 ms Interogare memorie: 0.023 MB Memorie înainte de interogare: 1.831 MB Linii returnate: 1

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

  FROM `jos8m_extensions`

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

Explicație

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

Profil

Status	Duration
Starting	0.19 ms
Checking permissions	0.05 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.04 ms
Init	0.05 ms
Optimizing	0.06 ms
Statistics	0.13 ms
Preparing	0.08 ms
Executing	0.04 ms
Sending data	0.10 ms
End of update loop	0.05 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 1.26 ms După ultima interogare: 0.26 ms Interogare memorie: 0.005 MB Memorie înainte de interogare: 1.821 MB

UPDATE `jos8m_extensions`

  SET `params` = '{\"mediaversion\":\"11a50f0e74f7a0cfc0bc9c4ef3f8393b\"}'

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

Explicație

EXPLAIN nu este posibil în interogare: UPDATE `jos8m_extensions` SET `params` = '{\"mediaversion\":\"11a50f0e74f7a0cfc0bc9c4ef3f8393b\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profil

Status	Duration
Starting	0.08 ms
Checking permissions	0.05 ms
Opening tables	0.07 ms
After opening tables	0.05 ms
System lock	0.04 ms
Table lock	0.04 ms
Init for update	0.11 ms
Updating	0.12 ms
End of update loop	0.05 ms
Waiting for query cache lock	0.04 ms
End of update loop	0.05 ms
Query end	0.04 ms
Commit	0.11 ms
Writing to binlog	0.05 ms
Commit	0.05 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.05 ms

Stivă Call

#	Apelant	Număr fișier și linie
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 1.25 ms După ultima interogare: 1.33 ms Interogare memorie: 0.019 MB Memorie înainte de interogare: 1.850 MB Linii returnate: 2

SELECT *

  FROM jos8m_languages

  WHERE published=1

  ORDER BY ordering ASC

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos8m_languages	ALL	NULL	NICI O CHEIE INDEX NU A PUTUT FI FOLOSITĂ	NULL	NULL	2	Using where; Folosire filesort

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.04 ms
Opening tables	0.06 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.04 ms
Init	0.06 ms
Optimizing	0.05 ms
Statistics	0.05 ms
Preparing	0.05 ms
Sorting result	0.06 ms
Executing	0.04 ms
Sending data	0.06 ms
Creating sort index	0.11 ms
End of update loop	0.05 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
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

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 1.21 ms După ultima interogare: 0.37 ms Interogare memorie: 0.019 MB Memorie înainte de interogare: 1.864 MB Linii returnate: 2

SELECT id, home, template, s.params

  FROM jos8m_template_styles as s

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

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	2
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	liceulor_joom422.s.template,const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.05 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.04 ms
Init	0.06 ms
Optimizing	0.06 ms
Statistics	0.10 ms
Preparing	0.07 ms
Executing	0.04 ms
Sending data	0.12 ms
End of update loop	0.05 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.05 ms
Freeing items	0.05 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
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

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 1.64 ms După ultima interogare: 5.12 ms Interogare memorie: 0.028 MB Memorie înainte de interogare: 2.010 MB Linii returnate: 37

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

  FROM `jos8m_assets`

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

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos8m_assets	ALL	idx_asset_name	NICI O CHEIE INDEX NU A PUTUT FI FOLOSITĂ	NULL	NULL	122	Using where

Profil

Status	Duration
Starting	0.11 ms
Checking permissions	0.05 ms
Opening tables	0.06 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.04 ms
Init	0.10 ms
Optimizing	0.05 ms
Statistics	0.23 ms
Preparing	0.06 ms
Executing	0.04 ms
Sending data	0.38 ms
End of update loop	0.05 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:115
14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:45
13	ContentModelFeatured->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 2.98 ms După ultima interogare: 1.64 ms Interogare memorie: 0.056 MB Memorie înainte de interogare: 2.097 MB Linii returnate: 1

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias

  FROM jos8m_content AS a

  LEFT JOIN jos8m_categories AS c 
  ON c.id = a.catid

  LEFT JOIN jos8m_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN jos8m_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN jos8m_categories as parent 
  ON parent.id = c.parent_id

  WHERE a.featured = 1 
  AND a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-10-02 11:38:46') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-10-02 11:38:46') 
  AND a.catid IN (8)

  ORDER BY c.lft,  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC , a.created DESC  
  LIMIT 9

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_featured_catid	idx_featured_catid	5	const,const	1	Using where; Folosire filesort
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	liceulor_joom422.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	liceulor_joom422.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where

Profil

Status	Duration
Starting	0.24 ms
Checking permissions	0.05 ms
Opening tables	0.16 ms
After opening tables	0.05 ms
System lock	0.05 ms
Table lock	0.04 ms
Init	0.12 ms
Optimizing	0.08 ms
Statistics	0.21 ms
Preparing	0.05 ms
Unlocking tables	0.04 ms
Preparing	0.08 ms
Sorting result	0.05 ms
Executing	0.04 ms
Sending data	0.08 ms
Creating sort index	1.19 ms
End of update loop	0.05 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.05 ms
Starting cleanup	0.04 ms
Freeing items	0.05 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
12	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 1.43 ms După ultima interogare: 0.96 ms Interogare memorie: 0.023 MB Memorie înainte de interogare: 2.155 MB Linii returnate: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `jos8m_contentitem_tag_map` AS m 

  INNER JOIN `jos8m_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 12 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	NICI O CHEIE INDEX NU A PUTUT FI FOLOSITĂ	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	liceulor_joom422.m.tag_id	1	Using where

Profil

Status	Duration
Starting	0.09 ms
Checking permissions	0.05 ms
Opening tables	0.08 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.04 ms
Init	0.07 ms
Optimizing	0.07 ms
Statistics	0.09 ms
Preparing	0.06 ms
Executing	0.15 ms
Sending data	0.10 ms
End of update loop	0.05 ms
Query end	0.05 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
12	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 1.44 ms După ultima interogare: 0.69 ms Interogare memorie: 0.023 MB Memorie înainte de interogare: 2.151 MB Linii returnate: 1

SELECT COUNT(*)

  FROM jos8m_content AS a

  LEFT JOIN jos8m_categories AS c 
  ON c.id = a.catid

  LEFT JOIN jos8m_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN jos8m_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN jos8m_categories as parent 
  ON parent.id = c.parent_id

  WHERE a.featured = 1 
  AND a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-10-02 11:38:46') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-10-02 11:38:46') 
  AND a.catid IN (8)

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_featured_catid	idx_featured_catid	5	const,const	1	Using where

Profil

Status	Duration
Starting	0.12 ms
Checking permissions	0.05 ms
Opening tables	0.07 ms
After opening tables	0.04 ms
System lock	0.05 ms
Table lock	0.05 ms
Init	0.07 ms
Optimizing	0.07 ms
Statistics	0.15 ms
Preparing	0.05 ms
Unlocking tables	0.04 ms
Preparing	0.07 ms
Executing	0.04 ms
Sending data	0.08 ms
End of update loop	0.05 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.05 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.08 ms
Reset for next command	0.07 ms

Stivă Call

#	Apelant	Număr fișier și linie
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:354
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:57
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 1.61 ms După ultima interogare: 3.88 ms Interogare memorie: 0.027 MB Memorie înainte de interogare: 2.386 MB Linii returnate: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `jos8m_categories` AS `s`

  INNER JOIN `jos8m_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 8

  ORDER BY c.lft

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NICI O CHEIE INDEX NU A PUTUT FI FOLOSITĂ	NULL	NULL	15	Using where; Folosire filesort

Profil

Status	Duration
Starting	0.15 ms
Checking permissions	0.05 ms
Opening tables	0.06 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.04 ms
Init	0.08 ms
Optimizing	0.07 ms
Statistics	0.15 ms
Preparing	0.05 ms
Unlocking tables	0.04 ms
Preparing	0.06 ms
Sorting result	0.04 ms
Executing	0.04 ms
Sending data	0.06 ms
Creating sort index	0.16 ms
End of update loop	0.05 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.05 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 2.45 ms După ultima interogare: 0.46 ms Interogare memorie: 0.025 MB Memorie înainte de interogare: 2.407 MB Linii returnate: 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 jos8m_fields AS a

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

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

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

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

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

  LEFT JOIN `jos8m_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (8,0)) 
  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

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Folosire filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	liceulor_joom422.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	liceulor_joom422.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	liceulor_joom422.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	liceulor_joom422.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	liceulor_joom422.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	liceulor_joom422.a.id	1	Using where; Using index; Distinct

Profil

Status	Duration
Starting	0.16 ms
Checking permissions	0.05 ms
Opening tables	0.11 ms
After opening tables	0.05 ms
System lock	0.05 ms
Table lock	0.04 ms
Init	0.09 ms
Optimizing	0.07 ms
Statistics	0.14 ms
Preparing	0.09 ms
Creating tmp table	0.15 ms
Sorting result	0.06 ms
Executing	0.04 ms
Sending data	0.51 ms
Creating sort index	0.09 ms
Removing tmp table	0.12 ms
Creating sort index	0.06 ms
End of update loop	0.05 ms
Query end	0.05 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.05 ms
Starting cleanup	0.04 ms
Freeing items	0.05 ms
Updating status	0.06 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 1.64 ms După ultima interogare: 3.33 ms Interogare memorie: 0.025 MB Memorie înainte de interogare: 2.585 MB Linii returnate: 1

SELECT `folderid`, `foldertime`, `entitytag` 
  FROM `jos8m_sigplus_folder` 
  WHERE `folderurl` = '/home/liceulor/public_html/images/2021/absolvire_12'

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos8m_sigplus_folder	const	folderurl	folderurl	769	const	1

Profil

Status	Duration
Starting	0.16 ms
Checking permissions	0.41 ms
Opening tables	0.09 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.04 ms
Init	0.05 ms
Optimizing	0.05 ms
Statistics	0.09 ms
Preparing	0.04 ms
Unlocking tables	0.05 ms
Preparing	0.05 ms
Executing	0.04 ms
Sending data	0.06 ms
End of update loop	0.04 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
20	JDatabaseDriver->loadRow()	JROOT/plugins/content/sigplus/core/core.php:3081
19	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:360
18	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
17	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
16	plgContentSigPlusNovo->{closure}()	Same as call in the line below.
15	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
14	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:128
13	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 0.33 ms După ultima interogare: 0.10 ms Interogare memorie: 0.010 MB Memorie înainte de interogare: 2.595 MB

Interogări duplicate: #33

START TRANSACTION

Explicație

EXPLAIN nu este posibil în interogare: START TRANSACTION

Profil

Status	Duration
Starting	0.05 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:837
21	JDatabaseDriverMysqli->transactionStart()	JROOT/plugins/content/sigplus/core/core.php:1063
20	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:3089
19	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:360
18	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
17	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
16	plgContentSigPlusNovo->{closure}()	Same as call in the line below.
15	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
14	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:128
13	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 1.12 ms După ultima interogare: 0.79 ms Interogare memorie: 0.027 MB Memorie înainte de interogare: 2.607 MB Linii returnate: 1

SELECT viewid

  FROM jos8m_sigplus_view

  WHERE folderid = 2 
  AND hash = 0x33c39fa6772badf53148faa44d4db928

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos8m_sigplus_view	const	hash,jos8m_FK_sigplus_view_folder	hash	16	const	1

Profil

Status	Duration
Starting	0.07 ms
Checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.04 ms
Init	0.05 ms
Optimizing	0.06 ms
Statistics	0.10 ms
Preparing	0.04 ms
Unlocking tables	0.04 ms
Preparing	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
End of update loop	0.04 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
25	JDatabaseDriver->loadResult()	JROOT/plugins/content/sigplus/core/core.php:1211
24	SigPlusNovoGalleryBase->getView()	JROOT/plugins/content/sigplus/core/core.php:1216
23	SigPlusNovoGalleryBase->insertView()	JROOT/plugins/content/sigplus/core/core.php:1891
22	SigPlusNovoLocalGallery->populateFolderViews()	JROOT/plugins/content/sigplus/core/core.php:1945
21	SigPlusNovoLocalGallery->populate()	JROOT/plugins/content/sigplus/core/core.php:1065
20	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:3089
19	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:360
18	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
17	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
16	plgContentSigPlusNovo->{closure}()	Same as call in the line below.
15	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
14	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:128
13	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 1.86 ms După ultima interogare: 0.09 ms Interogare memorie: 0.027 MB Memorie înainte de interogare: 2.618 MB Linii returnate: 0

SELECT
i.`fileurl`,
i.`imageid`

  FROM `jos8m_sigplus_image` AS i

  INNER JOIN `jos8m_sigplus_folder` AS f

  ON i.`folderid` = f.`folderid`

  INNER JOIN `jos8m_sigplus_hierarchy` AS h

  ON f.`folderid` = h.`descendantid`

  WHERE h.`ancestorid` = 2 
  AND NOT EXISTS (SELECT * 
  FROM `jos8m_sigplus_imageview` AS v 
  WHERE i.`imageid` = v.`imageid` 
  AND v.`viewid` = 2) 
  AND depthnum <= 0

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	h	ref	PRIMARY,jos8m_FK_sigplus_hierarchy_descendant,jos8m_IX_sigplus_hierarchy_depthnum	PRIMARY	4	const	1	Using where
1	PRIMARY	f	eq_ref	PRIMARY	PRIMARY	4	liceulor_joom422.h.descendantid	1	Using index
1	PRIMARY	i	ref	jos8m_FK_sigplus_image_folder	jos8m_FK_sigplus_image_folder	5	liceulor_joom422.h.descendantid	6	Using where
2	MATERIALIZED	v	ref	PRIMARY,jos8m_FK_sigplus_imageview_view	jos8m_FK_sigplus_imageview_view	4	const	23	Using index

Profil

Status	Duration
Starting	0.11 ms
Checking permissions	0.05 ms
Opening tables	0.08 ms
After opening tables	0.05 ms
System lock	0.04 ms
Table lock	0.04 ms
Init	0.07 ms
Optimizing	0.07 ms
Statistics	0.09 ms
Preparing	0.06 ms
Optimizing	0.05 ms
Statistics	0.11 ms
Preparing	0.06 ms
Executing	0.04 ms
Sending data	0.12 ms
Executing	0.04 ms
Sending data	0.17 ms
End of update loop	0.05 ms
Query end	0.05 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Removing tmp table	0.04 ms
Freeing items	0.04 ms
Removing tmp table	0.04 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1811
24	JDatabaseDriver->loadRowList()	JROOT/plugins/content/sigplus/core/core.php:1807
23	SigPlusNovoLocalBase->getMissingImageViews()	JROOT/plugins/content/sigplus/core/core.php:1894
22	SigPlusNovoLocalGallery->populateFolderViews()	JROOT/plugins/content/sigplus/core/core.php:1945
21	SigPlusNovoLocalGallery->populate()	JROOT/plugins/content/sigplus/core/core.php:1065
20	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:3089
19	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:360
18	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
17	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
16	plgContentSigPlusNovo->{closure}()	Same as call in the line below.
15	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
14	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:128
13	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 0.39 ms După ultima interogare: 0.07 ms Interogare memorie: 0.010 MB Memorie înainte de interogare: 2.628 MB

Interogări duplicate: #36

COMMIT

Explicație

EXPLAIN nu este posibil în interogare: COMMIT

Profil

Status	Duration
Starting	0.06 ms
Query end	0.06 ms
Commit	0.05 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:777
21	JDatabaseDriverMysqli->transactionCommit()	JROOT/plugins/content/sigplus/core/core.php:1071
20	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:3089
19	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:360
18	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
17	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
16	plgContentSigPlusNovo->{closure}()	Same as call in the line below.
15	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
14	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:128
13	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 1.07 ms După ultima interogare: 0.12 ms Interogare memorie: 0.026 MB Memorie înainte de interogare: 2.638 MB Linii returnate: 1

Interogări duplicate: #37

SELECT
`langid`

  FROM `jos8m_sigplus_language`

  WHERE
`lang` = 'ro'

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos8m_sigplus_language	const	lang	lang	2	const	1	Using index

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.04 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.06 ms
Preparing	0.04 ms
Unlocking tables	0.05 ms
Preparing	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
End of update loop	0.05 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
21	JDatabaseDriver->loadResult()	JROOT/plugins/content/sigplus/core/core.php:317
20	SigPlusNovoDatabase::getLanguageId()	JROOT/plugins/content/sigplus/core/core.php:3167
19	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:360
18	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
17	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
16	plgContentSigPlusNovo->{closure}()	Same as call in the line below.
15	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
14	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:128
13	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 1.09 ms După ultima interogare: 0.08 ms Interogare memorie: 0.026 MB Memorie înainte de interogare: 2.648 MB Linii returnate: 1

Interogări duplicate: #38

SELECT
`countryid`

  FROM `jos8m_sigplus_country`

  WHERE
`country` = 'RO'

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos8m_sigplus_country	const	country	country	2	const	1	Using index

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.04 ms
Init	0.05 ms
Optimizing	0.04 ms
Statistics	0.07 ms
Preparing	0.04 ms
Unlocking tables	0.05 ms
Preparing	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
End of update loop	0.04 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.15 ms

Stivă Call

#	Apelant	Număr fișier și linie
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
21	JDatabaseDriver->loadResult()	JROOT/plugins/content/sigplus/core/core.php:332
20	SigPlusNovoDatabase::getCountryId()	JROOT/plugins/content/sigplus/core/core.php:3168
19	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:360
18	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
17	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
16	plgContentSigPlusNovo->{closure}()	Same as call in the line below.
15	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
14	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:128
13	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 14.66 ms După ultima interogare: 0.36 ms Interogare memorie: 0.033 MB Memorie înainte de interogare: 2.663 MB Linii returnate: 23

Interogări duplicate: #27

SELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT  md.`textvalue`

  FROM `jos8m_sigplus_property` AS mp

  INNER JOIN `jos8m_sigplus_data` AS md

  ON mp.`propertyid` = md.`propertyid`

  WHERE mp.`propertyname` = 'Headline' 
  AND md.`imageid` = i.`imageid`

  LIMIT 1
),
(
SELECT  md.`textvalue`

  FROM `jos8m_sigplus_property` AS mp

  INNER JOIN `jos8m_sigplus_data` AS md

  ON mp.`propertyid` = md.`propertyid`

  WHERE mp.`propertyname` = 'Object Name' 
  AND md.`imageid` = i.`imageid`

  LIMIT 1
),
(
SELECT  p.`title`

  FROM `jos8m_sigplus_foldercaption` AS p

  WHERE
p.`langid` = 135 
  AND 
p.`countryid` = 158 
  AND 
i.`filename` LIKE p.`pattern` 
  AND 
i.`folderid` = p.`folderid`

  ORDER BY p.`priority` 
  LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT  md.`textvalue`

  FROM `jos8m_sigplus_property` AS mp

  INNER JOIN `jos8m_sigplus_data` AS md

  ON mp.`propertyid` = md.`propertyid`

  WHERE mp.`propertyname` = 'Caption-Abstract' 
  AND md.`imageid` = i.`imageid`

  LIMIT 1
),
(
SELECT  p.`summary`

  FROM `jos8m_sigplus_foldercaption` AS p

  WHERE
p.`langid` = 135 
  AND 
p.`countryid` = 158 
  AND 
i.`filename` LIKE p.`pattern` 
  AND 
i.`folderid` = p.`folderid`

  ORDER BY p.`priority` 
  LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`

  FROM `jos8m_sigplus_image` AS i

  INNER JOIN `jos8m_sigplus_folder` AS f

  ON i.`folderid` = f.`folderid`

  INNER JOIN `jos8m_sigplus_hierarchy` AS h

  ON f.`folderid` = h.`descendantid`

  INNER JOIN `jos8m_sigplus_folder` AS a

  ON a.`folderid` = h.`ancestorid`

  INNER JOIN `jos8m_sigplus_imageview` AS v

  ON i.`imageid` = v.`imageid`

  LEFT JOIN `jos8m_sigplus_caption` AS c

  ON
c.`imageid` = i.`imageid` 
  AND 
c.`langid` = 135 
  AND 
c.`countryid` = 158

  WHERE
a.`folderurl` = '/home/liceulor/public_html/images/2021/absolvire_12' 
  AND 
`viewid` = 2

 
  AND `depthnum` <= 0


  ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	const	PRIMARY,folderurl	folderurl	769	const	1	Using index; Using temporary; Folosire filesort
1	PRIMARY	h	ref	PRIMARY,jos8m_FK_sigplus_hierarchy_descendant,jos8m_IX_sigplus_hierarchy_depthnum	PRIMARY	4	const	1	Using where
1	PRIMARY	f	eq_ref	PRIMARY	PRIMARY	4	liceulor_joom422.h.descendantid	1	Using index
1	PRIMARY	i	ref	PRIMARY,jos8m_FK_sigplus_image_folder	jos8m_FK_sigplus_image_folder	5	liceulor_joom422.h.descendantid	6
1	PRIMARY	v	eq_ref	PRIMARY,jos8m_FK_sigplus_imageview_view	PRIMARY	8	liceulor_joom422.i.imageid,const	1
1	PRIMARY	c	eq_ref	PRIMARY,jos8m_FK_sigplus_caption_language,jos8m_FK_sigplus_caption_country	PRIMARY	8	liceulor_joom422.i.imageid,const,const	1
6	DEPENDENT SUBQUERY	p	index	PRIMARY,jos8m_FK_sigplus_foldercaption_language,jos8m_FK_sigplus_foldercaption_country	jos8m_IX_sigplus_foldercaption_priority	2	NULL	1	Using where
5	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
5	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,jos8m_FK_sigplus_data_property	PRIMARY	8	liceulor_joom422.i.imageid,const	1
4	DEPENDENT SUBQUERY	p	index	PRIMARY,jos8m_FK_sigplus_foldercaption_language,jos8m_FK_sigplus_foldercaption_country	jos8m_IX_sigplus_foldercaption_priority	2	NULL	1	Using where
3	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
3	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,jos8m_FK_sigplus_data_property	PRIMARY	8	liceulor_joom422.i.imageid,const	1
2	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
2	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,jos8m_FK_sigplus_data_property	PRIMARY	8	liceulor_joom422.i.imageid,const	1

Profil

Status	Duration
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.05 ms
Sending data	0.06 ms
Executing	0.04 ms
Sending data	0.06 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.06 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.06 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.06 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.06 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.06 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.05 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Creating sort index	0.18 ms
Removing tmp table	0.16 ms
Creating sort index	0.06 ms
End of update loop	0.06 ms
Query end	0.05 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.05 ms
Starting cleanup	0.04 ms
Freeing items	0.06 ms
Updating status	0.06 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
20	JDatabaseDriverMysqli->execute()	JROOT/plugins/content/sigplus/core/core.php:3330
19	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:360
18	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
17	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
16	plgContentSigPlusNovo->{closure}()	Same as call in the line below.
15	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
14	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:128
13	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 13.99 ms După ultima interogare: 0.08 ms Interogare memorie: 0.034 MB Memorie înainte de interogare: 2.674 MB Linii returnate: 23

Interogări duplicate: #26

SELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT  md.`textvalue`

  FROM `jos8m_sigplus_property` AS mp

  INNER JOIN `jos8m_sigplus_data` AS md

  ON mp.`propertyid` = md.`propertyid`

  WHERE mp.`propertyname` = 'Headline' 
  AND md.`imageid` = i.`imageid`

  LIMIT 1
),
(
SELECT  md.`textvalue`

  FROM `jos8m_sigplus_property` AS mp

  INNER JOIN `jos8m_sigplus_data` AS md

  ON mp.`propertyid` = md.`propertyid`

  WHERE mp.`propertyname` = 'Object Name' 
  AND md.`imageid` = i.`imageid`

  LIMIT 1
),
(
SELECT  p.`title`

  FROM `jos8m_sigplus_foldercaption` AS p

  WHERE
p.`langid` = 135 
  AND 
p.`countryid` = 158 
  AND 
i.`filename` LIKE p.`pattern` 
  AND 
i.`folderid` = p.`folderid`

  ORDER BY p.`priority` 
  LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT  md.`textvalue`

  FROM `jos8m_sigplus_property` AS mp

  INNER JOIN `jos8m_sigplus_data` AS md

  ON mp.`propertyid` = md.`propertyid`

  WHERE mp.`propertyname` = 'Caption-Abstract' 
  AND md.`imageid` = i.`imageid`

  LIMIT 1
),
(
SELECT  p.`summary`

  FROM `jos8m_sigplus_foldercaption` AS p

  WHERE
p.`langid` = 135 
  AND 
p.`countryid` = 158 
  AND 
i.`filename` LIKE p.`pattern` 
  AND 
i.`folderid` = p.`folderid`

  ORDER BY p.`priority` 
  LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`

  FROM `jos8m_sigplus_image` AS i

  INNER JOIN `jos8m_sigplus_folder` AS f

  ON i.`folderid` = f.`folderid`

  INNER JOIN `jos8m_sigplus_hierarchy` AS h

  ON f.`folderid` = h.`descendantid`

  INNER JOIN `jos8m_sigplus_folder` AS a

  ON a.`folderid` = h.`ancestorid`

  INNER JOIN `jos8m_sigplus_imageview` AS v

  ON i.`imageid` = v.`imageid`

  LEFT JOIN `jos8m_sigplus_caption` AS c

  ON
c.`imageid` = i.`imageid` 
  AND 
c.`langid` = 135 
  AND 
c.`countryid` = 158

  WHERE
a.`folderurl` = '/home/liceulor/public_html/images/2021/absolvire_12' 
  AND 
`viewid` = 2

 
  AND `depthnum` <= 0


  ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	const	PRIMARY,folderurl	folderurl	769	const	1	Using index; Using temporary; Folosire filesort
1	PRIMARY	h	ref	PRIMARY,jos8m_FK_sigplus_hierarchy_descendant,jos8m_IX_sigplus_hierarchy_depthnum	PRIMARY	4	const	1	Using where
1	PRIMARY	f	eq_ref	PRIMARY	PRIMARY	4	liceulor_joom422.h.descendantid	1	Using index
1	PRIMARY	i	ref	PRIMARY,jos8m_FK_sigplus_image_folder	jos8m_FK_sigplus_image_folder	5	liceulor_joom422.h.descendantid	6
1	PRIMARY	v	eq_ref	PRIMARY,jos8m_FK_sigplus_imageview_view	PRIMARY	8	liceulor_joom422.i.imageid,const	1
1	PRIMARY	c	eq_ref	PRIMARY,jos8m_FK_sigplus_caption_language,jos8m_FK_sigplus_caption_country	PRIMARY	8	liceulor_joom422.i.imageid,const,const	1
6	DEPENDENT SUBQUERY	p	index	PRIMARY,jos8m_FK_sigplus_foldercaption_language,jos8m_FK_sigplus_foldercaption_country	jos8m_IX_sigplus_foldercaption_priority	2	NULL	1	Using where
5	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
5	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,jos8m_FK_sigplus_data_property	PRIMARY	8	liceulor_joom422.i.imageid,const	1
4	DEPENDENT SUBQUERY	p	index	PRIMARY,jos8m_FK_sigplus_foldercaption_language,jos8m_FK_sigplus_foldercaption_country	jos8m_IX_sigplus_foldercaption_priority	2	NULL	1	Using where
3	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
3	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,jos8m_FK_sigplus_data_property	PRIMARY	8	liceulor_joom422.i.imageid,const	1
2	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
2	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,jos8m_FK_sigplus_data_property	PRIMARY	8	liceulor_joom422.i.imageid,const	1

Profil

Status	Duration
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.05 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.06 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.06 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.09 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.06 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.06 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.06 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Creating sort index	0.16 ms
Removing tmp table	0.17 ms
Creating sort index	0.07 ms
End of update loop	0.05 ms
Query end	0.05 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.05 ms
Starting cleanup	0.04 ms
Freeing items	0.06 ms
Updating status	0.06 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1811
20	JDatabaseDriver->loadRowList()	JROOT/plugins/content/sigplus/core/core.php:3337
19	SigPlusNovoCore->getGalleryHTML()	JROOT/plugins/content/sigplus/sigplus.php:360
18	plgContentSigPlusNovo->getGalleryReplacementSingle()	JROOT/plugins/content/sigplus/sigplus.php:267
17	plgContentSigPlusNovo->getReplacements()	JROOT/plugins/content/sigplus/sigplus.php:218
16	plgContentSigPlusNovo->{closure}()	Same as call in the line below.
15	preg_replace_callback()	JROOT/plugins/content/sigplus/sigplus.php:222
14	plgContentSigPlusNovo->parseContent()	JROOT/plugins/content/sigplus/sigplus.php:128
13	plgContentSigPlusNovo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/featured/view.html.php:102
10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.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

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 2.03 ms După ultima interogare: 23.76 ms Interogare memorie: 0.024 MB Memorie înainte de interogare: 2.866 MB Linii returnate: 8

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM jos8m_modules AS m

  LEFT JOIN jos8m_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN jos8m_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-10-02 11:38:46') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-10-02 11:38:46') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 112 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	11	Using index condition; Using where; Folosire filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	liceulor_joom422.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	liceulor_joom422.m.module,const	1	Using index condition; Using where

Profil

Status	Duration
Starting	0.25 ms
Checking permissions	0.05 ms
Opening tables	0.09 ms
After opening tables	0.05 ms
System lock	0.06 ms
Table lock	0.06 ms
Init	0.10 ms
Optimizing	0.09 ms
Statistics	0.14 ms
Preparing	0.10 ms
Sorting result	0.05 ms
Executing	0.04 ms
Sending data	0.05 ms
Creating sort index	0.34 ms
End of update loop	0.05 ms
Query end	0.04 ms
Commit	0.06 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.05 ms
Starting cleanup	0.04 ms
Freeing items	0.05 ms
Updating status	0.06 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/protostar/index.php:91
7	require JROOT/templates/protostar/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 3.13 ms După ultima interogare: 3.10 ms Interogare memorie: 0.026 MB Memorie înainte de interogare: 2.907 MB Linii returnate: 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 jos8m_fields AS a

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

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

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

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

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

  WHERE a.context = 'mod_custom.content' 
  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

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Folosire filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	liceulor_joom422.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	liceulor_joom422.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	liceulor_joom422.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	liceulor_joom422.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	liceulor_joom422.a.group_id	1	Using where

Profil

Status	Duration
Starting	0.17 ms
Checking permissions	0.05 ms
Opening tables	0.10 ms
After opening tables	0.05 ms
System lock	0.04 ms
Table lock	0.06 ms
Init	0.10 ms
Optimizing	0.07 ms
Statistics	0.15 ms
Preparing	0.08 ms
Creating tmp table	0.13 ms
Sorting result	0.06 ms
Executing	0.04 ms
Sending data	1.24 ms
Creating sort index	0.09 ms
Removing tmp table	0.14 ms
Creating sort index	0.06 ms
End of update loop	0.05 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.05 ms
Starting cleanup	0.04 ms
Freeing items	0.05 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 1.36 ms După ultima interogare: 7.10 ms Interogare memorie: 0.022 MB Memorie înainte de interogare: 3.034 MB Linii returnate: 0

SELECT *

  FROM jos8m_banners

  WHERE '2023-10-02 11:38:46' >= 'reset' 
  AND `reset` != '0000-00-00 00:00:00' 
  AND `reset`!= NULL 
  AND (`checked_out` = 0 OR `checked_out` = 0)

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NICI O CHEIE INDEX NU A PUTUT FI FOLOSITĂ	NULL	NULL	NULL	Impossible WHERE

Profil

Status	Duration
Starting	0.11 ms
Checking permissions	0.04 ms
Opening tables	0.06 ms
After opening tables	0.05 ms
System lock	0.05 ms
Table lock	0.04 ms
Init	0.13 ms
Optimizing	0.07 ms
Executing	0.06 ms
End of update loop	0.04 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.22 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.06 ms
Updating status	0.05 ms
Reset for next command	0.06 ms

Stivă Call

#	Apelant	Număr fișier și linie
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
11	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 1.52 ms După ultima interogare: 0.38 ms Interogare memorie: 0.023 MB Memorie înainte de interogare: 3.051 MB Linii returnate: 0

SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions

  FROM jos8m_banners as a

  LEFT JOIN jos8m_banner_clients AS cl 
  ON cl.id = a.cid

  WHERE a.state=1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-10-02 11:38:46') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-10-02 11:38:46') 
  AND (a.imptotal = 0 OR a.impmade < a.imptotal)

  ORDER BY a.sticky DESC,a.ordering 
  LIMIT 1

Explicație

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

Profil

Status	Duration
Starting	0.13 ms
Checking permissions	0.09 ms
Opening tables	0.08 ms
After opening tables	0.05 ms
System lock	0.04 ms
Table lock	0.04 ms
Init	0.08 ms
Optimizing	0.07 ms
Statistics	0.20 ms
Preparing	0.08 ms
Sorting result	0.05 ms
Executing	0.04 ms
Sending data	0.05 ms
Creating sort index	0.09 ms
End of update loop	0.04 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.05 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:222
12	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:48
11	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
10	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 1.23 ms După ultima interogare: 2.13 ms Interogare memorie: 0.022 MB Memorie înainte de interogare: 3.104 MB Linii returnate: 1

SELECT `folderid`, `foldertime`, `entitytag` 
  FROM `jos8m_sigplus_folder` 
  WHERE `folderurl` = '/home/liceulor/public_html/images/poze'

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos8m_sigplus_folder	const	folderurl	folderurl	769	const	1

Profil

Status	Duration
Starting	0.12 ms
Checking permissions	0.05 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.04 ms
Init	0.05 ms
Optimizing	0.05 ms
Statistics	0.08 ms
Preparing	0.04 ms
Unlocking tables	0.05 ms
Preparing	0.05 ms
Executing	0.04 ms
Sending data	0.05 ms
End of update loop	0.04 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.05 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.09 ms
Updating status	0.07 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
12	JDatabaseDriver->loadRow()	JROOT/plugins/content/sigplus/core/core.php:3081
11	SigPlusNovoCore->getGalleryHTML()	JROOT/modules/mod_sigplus/mod_sigplus.php:78
10	include JROOT/modules/mod_sigplus/mod_sigplus.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 0.34 ms După ultima interogare: 0.06 ms Interogare memorie: 0.008 MB Memorie înainte de interogare: 3.117 MB

Interogări duplicate: #20

START TRANSACTION

Explicație

EXPLAIN nu este posibil în interogare: START TRANSACTION

Profil

Status	Duration
Starting	0.05 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:837
13	JDatabaseDriverMysqli->transactionStart()	JROOT/plugins/content/sigplus/core/core.php:1063
12	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:3089
11	SigPlusNovoCore->getGalleryHTML()	JROOT/modules/mod_sigplus/mod_sigplus.php:78
10	include JROOT/modules/mod_sigplus/mod_sigplus.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 1.25 ms După ultima interogare: 0.28 ms Interogare memorie: 0.024 MB Memorie înainte de interogare: 3.127 MB Linii returnate: 1

SELECT viewid

  FROM jos8m_sigplus_view

  WHERE folderid = 1 
  AND hash = 0x5bb37cec3c8cee4567495f3b2d9e502a

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos8m_sigplus_view	const	hash,jos8m_FK_sigplus_view_folder	hash	16	const	1

Profil

Status	Duration
Starting	0.08 ms
Checking permissions	0.05 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.04 ms
Init	0.05 ms
Optimizing	0.05 ms
Statistics	0.10 ms
Preparing	0.05 ms
Unlocking tables	0.04 ms
Preparing	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
End of update loop	0.04 ms
Query end	0.05 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.06 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.06 ms
Reset for next command	0.05 ms

Stivă Call

#	Apelant	Număr fișier și linie
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/plugins/content/sigplus/core/core.php:1211
16	SigPlusNovoGalleryBase->getView()	JROOT/plugins/content/sigplus/core/core.php:1216
15	SigPlusNovoGalleryBase->insertView()	JROOT/plugins/content/sigplus/core/core.php:1891
14	SigPlusNovoLocalGallery->populateFolderViews()	JROOT/plugins/content/sigplus/core/core.php:1945
13	SigPlusNovoLocalGallery->populate()	JROOT/plugins/content/sigplus/core/core.php:1065
12	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:3089
11	SigPlusNovoCore->getGalleryHTML()	JROOT/modules/mod_sigplus/mod_sigplus.php:78
10	include JROOT/modules/mod_sigplus/mod_sigplus.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 1.89 ms După ultima interogare: 0.09 ms Interogare memorie: 0.024 MB Memorie înainte de interogare: 3.134 MB Linii returnate: 0

SELECT
i.`fileurl`,
i.`imageid`

  FROM `jos8m_sigplus_image` AS i

  INNER JOIN `jos8m_sigplus_folder` AS f

  ON i.`folderid` = f.`folderid`

  INNER JOIN `jos8m_sigplus_hierarchy` AS h

  ON f.`folderid` = h.`descendantid`

  WHERE h.`ancestorid` = 1 
  AND NOT EXISTS (SELECT * 
  FROM `jos8m_sigplus_imageview` AS v 
  WHERE i.`imageid` = v.`imageid` 
  AND v.`viewid` = 1) 
  AND depthnum <= 0

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	h	ref	PRIMARY,jos8m_FK_sigplus_hierarchy_descendant,jos8m_IX_sigplus_hierarchy_depthnum	PRIMARY	4	const	1	Using where
1	PRIMARY	f	eq_ref	PRIMARY	PRIMARY	4	liceulor_joom422.h.descendantid	1	Using index
1	PRIMARY	i	ref	jos8m_FK_sigplus_image_folder	jos8m_FK_sigplus_image_folder	5	liceulor_joom422.h.descendantid	6	Using where
2	MATERIALIZED	v	ref	PRIMARY,jos8m_FK_sigplus_imageview_view	jos8m_FK_sigplus_imageview_view	4	const	19	Using index

Profil

Status	Duration
Starting	0.10 ms
Checking permissions	0.04 ms
Opening tables	0.07 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.04 ms
Init	0.07 ms
Optimizing	0.07 ms
Statistics	0.13 ms
Preparing	0.07 ms
Optimizing	0.05 ms
Statistics	0.13 ms
Preparing	0.07 ms
Executing	0.04 ms
Sending data	0.14 ms
Executing	0.05 ms
Sending data	0.12 ms
End of update loop	0.05 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Removing tmp table	0.06 ms
Freeing items	0.05 ms
Removing tmp table	0.04 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1811
16	JDatabaseDriver->loadRowList()	JROOT/plugins/content/sigplus/core/core.php:1807
15	SigPlusNovoLocalBase->getMissingImageViews()	JROOT/plugins/content/sigplus/core/core.php:1894
14	SigPlusNovoLocalGallery->populateFolderViews()	JROOT/plugins/content/sigplus/core/core.php:1945
13	SigPlusNovoLocalGallery->populate()	JROOT/plugins/content/sigplus/core/core.php:1065
12	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:3089
11	SigPlusNovoCore->getGalleryHTML()	JROOT/modules/mod_sigplus/mod_sigplus.php:78
10	include JROOT/modules/mod_sigplus/mod_sigplus.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 0.43 ms După ultima interogare: 0.06 ms Interogare memorie: 0.006 MB Memorie înainte de interogare: 3.142 MB

Interogări duplicate: #23

COMMIT

Explicație

EXPLAIN nu este posibil în interogare: COMMIT

Profil

Status	Duration
Starting	0.07 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:777
13	JDatabaseDriverMysqli->transactionCommit()	JROOT/plugins/content/sigplus/core/core.php:1071
12	SigPlusNovoGalleryBase->update()	JROOT/plugins/content/sigplus/core/core.php:3089
11	SigPlusNovoCore->getGalleryHTML()	JROOT/modules/mod_sigplus/mod_sigplus.php:78
10	include JROOT/modules/mod_sigplus/mod_sigplus.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 1.13 ms După ultima interogare: 0.08 ms Interogare memorie: 0.022 MB Memorie înainte de interogare: 3.148 MB Linii returnate: 1

Interogări duplicate: #24

SELECT
`langid`

  FROM `jos8m_sigplus_language`

  WHERE
`lang` = 'ro'

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos8m_sigplus_language	const	lang	lang	2	const	1	Using index

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.05 ms
Opening tables	0.05 ms
After opening tables	0.05 ms
System lock	0.04 ms
Table lock	0.05 ms
Init	0.05 ms
Optimizing	0.05 ms
Statistics	0.07 ms
Preparing	0.04 ms
Unlocking tables	0.05 ms
Preparing	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
End of update loop	0.04 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.04 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/plugins/content/sigplus/core/core.php:317
12	SigPlusNovoDatabase::getLanguageId()	JROOT/plugins/content/sigplus/core/core.php:3167
11	SigPlusNovoCore->getGalleryHTML()	JROOT/modules/mod_sigplus/mod_sigplus.php:78
10	include JROOT/modules/mod_sigplus/mod_sigplus.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 1.15 ms După ultima interogare: 0.09 ms Interogare memorie: 0.022 MB Memorie înainte de interogare: 3.155 MB Linii returnate: 1

Interogări duplicate: #25

SELECT
`countryid`

  FROM `jos8m_sigplus_country`

  WHERE
`country` = 'RO'

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	jos8m_sigplus_country	const	country	country	2	const	1	Using index

Profil

Status	Duration
Starting	0.06 ms
Checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.04 ms
Init	0.05 ms
Optimizing	0.05 ms
Statistics	0.09 ms
Preparing	0.04 ms
Unlocking tables	0.04 ms
Preparing	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
End of update loop	0.04 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.06 ms
Unlocking tables	0.04 ms
Closing tables	0.04 ms
Starting cleanup	0.05 ms
Freeing items	0.04 ms
Updating status	0.05 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/plugins/content/sigplus/core/core.php:332
12	SigPlusNovoDatabase::getCountryId()	JROOT/plugins/content/sigplus/core/core.php:3168
11	SigPlusNovoCore->getGalleryHTML()	JROOT/modules/mod_sigplus/mod_sigplus.php:78
10	include JROOT/modules/mod_sigplus/mod_sigplus.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 12.63 ms După ultima interogare: 0.18 ms Interogare memorie: 0.030 MB Memorie înainte de interogare: 3.166 MB Linii returnate: 19

Interogări duplicate: #40

SELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT  md.`textvalue`

  FROM `jos8m_sigplus_property` AS mp

  INNER JOIN `jos8m_sigplus_data` AS md

  ON mp.`propertyid` = md.`propertyid`

  WHERE mp.`propertyname` = 'Headline' 
  AND md.`imageid` = i.`imageid`

  LIMIT 1
),
(
SELECT  md.`textvalue`

  FROM `jos8m_sigplus_property` AS mp

  INNER JOIN `jos8m_sigplus_data` AS md

  ON mp.`propertyid` = md.`propertyid`

  WHERE mp.`propertyname` = 'Object Name' 
  AND md.`imageid` = i.`imageid`

  LIMIT 1
),
(
SELECT  p.`title`

  FROM `jos8m_sigplus_foldercaption` AS p

  WHERE
p.`langid` = 135 
  AND 
p.`countryid` = 158 
  AND 
i.`filename` LIKE p.`pattern` 
  AND 
i.`folderid` = p.`folderid`

  ORDER BY p.`priority` 
  LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT  md.`textvalue`

  FROM `jos8m_sigplus_property` AS mp

  INNER JOIN `jos8m_sigplus_data` AS md

  ON mp.`propertyid` = md.`propertyid`

  WHERE mp.`propertyname` = 'Caption-Abstract' 
  AND md.`imageid` = i.`imageid`

  LIMIT 1
),
(
SELECT  p.`summary`

  FROM `jos8m_sigplus_foldercaption` AS p

  WHERE
p.`langid` = 135 
  AND 
p.`countryid` = 158 
  AND 
i.`filename` LIKE p.`pattern` 
  AND 
i.`folderid` = p.`folderid`

  ORDER BY p.`priority` 
  LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`

  FROM `jos8m_sigplus_image` AS i

  INNER JOIN `jos8m_sigplus_folder` AS f

  ON i.`folderid` = f.`folderid`

  INNER JOIN `jos8m_sigplus_hierarchy` AS h

  ON f.`folderid` = h.`descendantid`

  INNER JOIN `jos8m_sigplus_folder` AS a

  ON a.`folderid` = h.`ancestorid`

  INNER JOIN `jos8m_sigplus_imageview` AS v

  ON i.`imageid` = v.`imageid`

  LEFT JOIN `jos8m_sigplus_caption` AS c

  ON
c.`imageid` = i.`imageid` 
  AND 
c.`langid` = 135 
  AND 
c.`countryid` = 158

  WHERE
a.`folderurl` = '/home/liceulor/public_html/images/poze' 
  AND 
`viewid` = 1

 
  AND `depthnum` <= 0


  ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	const	PRIMARY,folderurl	folderurl	769	const	1	Using index; Using temporary; Folosire filesort
1	PRIMARY	h	ref	PRIMARY,jos8m_FK_sigplus_hierarchy_descendant,jos8m_IX_sigplus_hierarchy_depthnum	PRIMARY	4	const	1	Using where
1	PRIMARY	f	eq_ref	PRIMARY	PRIMARY	4	liceulor_joom422.h.descendantid	1	Using index
1	PRIMARY	i	ref	PRIMARY,jos8m_FK_sigplus_image_folder	jos8m_FK_sigplus_image_folder	5	liceulor_joom422.h.descendantid	6
1	PRIMARY	v	eq_ref	PRIMARY,jos8m_FK_sigplus_imageview_view	PRIMARY	8	liceulor_joom422.i.imageid,const	1
1	PRIMARY	c	eq_ref	PRIMARY,jos8m_FK_sigplus_caption_language,jos8m_FK_sigplus_caption_country	PRIMARY	8	liceulor_joom422.i.imageid,const,const	1
6	DEPENDENT SUBQUERY	p	index	PRIMARY,jos8m_FK_sigplus_foldercaption_language,jos8m_FK_sigplus_foldercaption_country	jos8m_IX_sigplus_foldercaption_priority	2	NULL	1	Using where
5	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
5	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,jos8m_FK_sigplus_data_property	PRIMARY	8	liceulor_joom422.i.imageid,const	1
4	DEPENDENT SUBQUERY	p	index	PRIMARY,jos8m_FK_sigplus_foldercaption_language,jos8m_FK_sigplus_foldercaption_country	jos8m_IX_sigplus_foldercaption_priority	2	NULL	1	Using where
3	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
3	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,jos8m_FK_sigplus_data_property	PRIMARY	8	liceulor_joom422.i.imageid,const	1
2	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
2	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,jos8m_FK_sigplus_data_property	PRIMARY	8	liceulor_joom422.i.imageid,const	1

Profil

Status	Duration
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.07 ms
Executing	0.05 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.05 ms
Sending data	0.06 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.05 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.06 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.05 ms
Sending data	0.05 ms
Creating sort index	0.17 ms
Removing tmp table	0.16 ms
Creating sort index	0.07 ms
End of update loop	0.05 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.06 ms
Starting cleanup	0.04 ms
Freeing items	0.06 ms
Updating status	0.06 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
12	JDatabaseDriverMysqli->execute()	JROOT/plugins/content/sigplus/core/core.php:3330
11	SigPlusNovoCore->getGalleryHTML()	JROOT/modules/mod_sigplus/mod_sigplus.php:78
10	include JROOT/modules/mod_sigplus/mod_sigplus.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 13.18 ms După ultima interogare: 0.08 ms Interogare memorie: 0.030 MB Memorie înainte de interogare: 3.174 MB Linii returnate: 19

Interogări duplicate: #39

SELECT
i.`imageid`,
i.`fileurl`,
i.`width`,
i.`height`,
i.`filesize`,
COALESCE(
c.`title`,
(
SELECT  md.`textvalue`

  FROM `jos8m_sigplus_property` AS mp

  INNER JOIN `jos8m_sigplus_data` AS md

  ON mp.`propertyid` = md.`propertyid`

  WHERE mp.`propertyname` = 'Headline' 
  AND md.`imageid` = i.`imageid`

  LIMIT 1
),
(
SELECT  md.`textvalue`

  FROM `jos8m_sigplus_property` AS mp

  INNER JOIN `jos8m_sigplus_data` AS md

  ON mp.`propertyid` = md.`propertyid`

  WHERE mp.`propertyname` = 'Object Name' 
  AND md.`imageid` = i.`imageid`

  LIMIT 1
),
(
SELECT  p.`title`

  FROM `jos8m_sigplus_foldercaption` AS p

  WHERE
p.`langid` = 135 
  AND 
p.`countryid` = 158 
  AND 
i.`filename` LIKE p.`pattern` 
  AND 
i.`folderid` = p.`folderid`

  ORDER BY p.`priority` 
  LIMIT 1
)
) AS `title`,
COALESCE(
c.`summary`,
(
SELECT  md.`textvalue`

  FROM `jos8m_sigplus_property` AS mp

  INNER JOIN `jos8m_sigplus_data` AS md

  ON mp.`propertyid` = md.`propertyid`

  WHERE mp.`propertyname` = 'Caption-Abstract' 
  AND md.`imageid` = i.`imageid`

  LIMIT 1
),
(
SELECT  p.`summary`

  FROM `jos8m_sigplus_foldercaption` AS p

  WHERE
p.`langid` = 135 
  AND 
p.`countryid` = 158 
  AND 
i.`filename` LIKE p.`pattern` 
  AND 
i.`folderid` = p.`folderid`

  ORDER BY p.`priority` 
  LIMIT 1
)
) AS `summary`,
`thumb_fileurl`,
`thumb_width`,
`thumb_height`,
`preview_fileurl`,
`preview_width`,
`preview_height`,
`retina_fileurl`,
`retina_width`,
`retina_height`,
`watermark_fileurl`

  FROM `jos8m_sigplus_image` AS i

  INNER JOIN `jos8m_sigplus_folder` AS f

  ON i.`folderid` = f.`folderid`

  INNER JOIN `jos8m_sigplus_hierarchy` AS h

  ON f.`folderid` = h.`descendantid`

  INNER JOIN `jos8m_sigplus_folder` AS a

  ON a.`folderid` = h.`ancestorid`

  INNER JOIN `jos8m_sigplus_imageview` AS v

  ON i.`imageid` = v.`imageid`

  LEFT JOIN `jos8m_sigplus_caption` AS c

  ON
c.`imageid` = i.`imageid` 
  AND 
c.`langid` = 135 
  AND 
c.`countryid` = 158

  WHERE
a.`folderurl` = '/home/liceulor/public_html/images/poze' 
  AND 
`viewid` = 1

 
  AND `depthnum` <= 0


  ORDER BY `depthnum` ASC, -`ordnum` DESC, `filename` ASC

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	const	PRIMARY,folderurl	folderurl	769	const	1	Using index; Using temporary; Folosire filesort
1	PRIMARY	h	ref	PRIMARY,jos8m_FK_sigplus_hierarchy_descendant,jos8m_IX_sigplus_hierarchy_depthnum	PRIMARY	4	const	1	Using where
1	PRIMARY	f	eq_ref	PRIMARY	PRIMARY	4	liceulor_joom422.h.descendantid	1	Using index
1	PRIMARY	i	ref	PRIMARY,jos8m_FK_sigplus_image_folder	jos8m_FK_sigplus_image_folder	5	liceulor_joom422.h.descendantid	6
1	PRIMARY	v	eq_ref	PRIMARY,jos8m_FK_sigplus_imageview_view	PRIMARY	8	liceulor_joom422.i.imageid,const	1
1	PRIMARY	c	eq_ref	PRIMARY,jos8m_FK_sigplus_caption_language,jos8m_FK_sigplus_caption_country	PRIMARY	8	liceulor_joom422.i.imageid,const,const	1
6	DEPENDENT SUBQUERY	p	index	PRIMARY,jos8m_FK_sigplus_foldercaption_language,jos8m_FK_sigplus_foldercaption_country	jos8m_IX_sigplus_foldercaption_priority	2	NULL	1	Using where
5	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
5	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,jos8m_FK_sigplus_data_property	PRIMARY	8	liceulor_joom422.i.imageid,const	1
4	DEPENDENT SUBQUERY	p	index	PRIMARY,jos8m_FK_sigplus_foldercaption_language,jos8m_FK_sigplus_foldercaption_country	jos8m_IX_sigplus_foldercaption_priority	2	NULL	1	Using where
3	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
3	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,jos8m_FK_sigplus_data_property	PRIMARY	8	liceulor_joom422.i.imageid,const	1
2	DEPENDENT SUBQUERY	mp	const	PRIMARY,propertyname	propertyname	257	const	1	Using index
2	DEPENDENT SUBQUERY	md	eq_ref	PRIMARY,jos8m_FK_sigplus_data_property	PRIMARY	8	liceulor_joom422.i.imageid,const	1

Profil

Status	Duration
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.05 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.05 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.06 ms
Executing	0.04 ms
Sending data	0.05 ms
Executing	0.05 ms
Sending data	0.05 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.04 ms
Executing	0.04 ms
Sending data	0.05 ms
Creating sort index	0.17 ms
Removing tmp table	0.16 ms
Creating sort index	0.07 ms
End of update loop	0.05 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.06 ms
Starting cleanup	0.05 ms
Freeing items	0.07 ms
Updating status	0.06 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1811
12	JDatabaseDriver->loadRowList()	JROOT/plugins/content/sigplus/core/core.php:3337
11	SigPlusNovoCore->getGalleryHTML()	JROOT/modules/mod_sigplus/mod_sigplus.php:78
10	include JROOT/modules/mod_sigplus/mod_sigplus.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

Timp interogare: 1.55 ms După ultima interogare: 0.21 ms Interogare memorie: 0.022 MB Memorie înainte de interogare: 3.220 MB Linii returnate: 1

SELECT
MAX(i.`width`),
MAX(i.`height`),
MAX(`thumb_width`),
MAX(`thumb_height`),
MAX(`preview_width`),
MAX(`preview_height`),
MAX(`retina_width`),
MAX(`retina_height`)

  FROM `jos8m_sigplus_image` AS i

  INNER JOIN `jos8m_sigplus_folder` AS f

  ON i.`folderid` = f.`folderid`

  INNER JOIN `jos8m_sigplus_hierarchy` AS h

  ON f.`folderid` = h.`descendantid`

  INNER JOIN `jos8m_sigplus_folder` AS a

  ON a.`folderid` = h.`ancestorid`

  INNER JOIN `jos8m_sigplus_imageview` AS v

  ON i.`imageid` = v.`imageid`

  WHERE
a.`folderurl` = '/home/liceulor/public_html/images/poze' 
  AND 
`viewid` = 1

 
  AND `depthnum` <= 0

Explicație

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,folderurl	folderurl	769	const	1	Using index
1	SIMPLE	h	ref	PRIMARY,jos8m_FK_sigplus_hierarchy_descendant,jos8m_IX_sigplus_hierarchy_depthnum	PRIMARY	4	const	1	Using where
1	SIMPLE	f	eq_ref	PRIMARY	PRIMARY	4	liceulor_joom422.h.descendantid	1	Using index
1	SIMPLE	i	ref	PRIMARY,jos8m_FK_sigplus_image_folder	jos8m_FK_sigplus_image_folder	5	liceulor_joom422.h.descendantid	6
1	SIMPLE	v	eq_ref	PRIMARY,jos8m_FK_sigplus_imageview_view	PRIMARY	8	liceulor_joom422.i.imageid,const	1

Profil

Status	Duration
Starting	0.14 ms
Checking permissions	0.05 ms
Opening tables	0.06 ms
After opening tables	0.04 ms
System lock	0.04 ms
Table lock	0.04 ms
Init	0.08 ms
Optimizing	0.09 ms
Statistics	0.14 ms
Preparing	0.05 ms
Unlocking tables	0.04 ms
Preparing	0.07 ms
Executing	0.04 ms
Sending data	0.16 ms
End of update loop	0.05 ms
Query end	0.04 ms
Commit	0.04 ms
Closing tables	0.04 ms
Unlocking tables	0.04 ms
Closing tables	0.05 ms
Starting cleanup	0.04 ms
Freeing items	0.05 ms
Updating status	0.07 ms
Reset for next command	0.04 ms

Stivă Call

#	Apelant	Număr fișier și linie
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
12	JDatabaseDriver->loadRow()	JROOT/plugins/content/sigplus/core/core.php:3380
11	SigPlusNovoCore->getGalleryHTML()	JROOT/modules/mod_sigplus/mod_sigplus.php:78
10	include JROOT/modules/mod_sigplus/mod_sigplus.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Adăugați directiva xdebug.file_link_format la fișierul dvs php.ini pentru a avea linkuri pentru fișiere.]

30 Tipuri de Interogări înregistrate, sortate după ocurențe.

Tabele SELECT:

4 × SELECT i.`imageid`, i.`fileurl`, i.`width`, i.`height`, i.`filesize`, COALESCE( c.`title`, ( SELECT  md.`textvalue` 
  FROM `jos8m_sigplus_property` AS mp 
  INNER JOIN `jos8m_sigplus_data` AS md 
  ON mp.`propertyid` = md.`propertyid`

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `jos8m_extensions`

2 × SELECT `folderid`, `foldertime`, `entitytag` 
  FROM `jos8m_sigplus_folder`

2 × SELECT viewid 
  FROM jos8m_sigplus_view

2 × SELECT i.`fileurl`, i.`imageid` 
  FROM `jos8m_sigplus_image` AS i 
  INNER JOIN `jos8m_sigplus_folder` AS f 
  ON i.`folderid` = f.`folderid` 
  INNER JOIN `jos8m_sigplus_hierarchy` AS h 
  ON f.`folderid` = h.`descendantid`

2 × SELECT `langid` 
  FROM `jos8m_sigplus_language`

2 × SELECT `countryid` 
  FROM `jos8m_sigplus_country`

1 × SELECT `data` 
  FROM `jos8m_session`

1 × SELECT `session_id` 
  FROM `jos8m_session`

1 × SELECT id, rules 
  FROM `jos8m_viewlevels

1 × SELECT b.id 
  FROM jos8m_usergroups AS a 
  LEFT JOIN jos8m_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM jos8m_extensions

1 × 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 jos8m_menu AS m 
  LEFT JOIN jos8m_extensions AS e 
  ON m.component_id = e.extension_id

```
1 × SELECT * 
  FROM jos8m_languages
```

1 × SELECT id, home, template, s.params 
  FROM jos8m_template_styles as s 
  LEFT JOIN jos8m_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `jos8m_assets`

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias 
  FROM jos8m_content AS a 
  LEFT JOIN jos8m_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN jos8m_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN jos8m_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN jos8m_categories as parent 
  ON parent.id = c.parent_id

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `jos8m_contentitem_tag_map` AS m  
  INNER JOIN `jos8m_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT COUNT(*) 
  FROM jos8m_content AS a 
  LEFT JOIN jos8m_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN jos8m_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN jos8m_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN jos8m_categories as parent 
  ON parent.id = c.parent_id

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `jos8m_categories` AS `s` 
  INNER JOIN `jos8m_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

1 × 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 jos8m_fields AS a 
  LEFT JOIN `jos8m_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN jos8m_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN jos8m_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN jos8m_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN jos8m_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `jos8m_fields_categories` AS fc 
  ON fc.field_id = a.id

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM jos8m_modules AS m 
  LEFT JOIN jos8m_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN jos8m_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × 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 jos8m_fields AS a 
  LEFT JOIN `jos8m_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN jos8m_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN jos8m_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN jos8m_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN jos8m_fields_groups AS g 
  ON g.id = a.group_id

```
1 × SELECT * 
  FROM jos8m_banners
```

1 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions 
  FROM jos8m_banners as a 
  LEFT JOIN jos8m_banner_clients AS cl 
  ON cl.id = a.cid

1 × SELECT MAX(i.`width`), MAX(i.`height`), MAX(`thumb_width`), MAX(`thumb_height`), MAX(`preview_width`), MAX(`preview_height`), MAX(`retina_width`), MAX(`retina_height`) 
  FROM `jos8m_sigplus_image` AS i 
  INNER JOIN `jos8m_sigplus_folder` AS f 
  ON i.`folderid` = f.`folderid` 
  INNER JOIN `jos8m_sigplus_hierarchy` AS h 
  ON f.`folderid` = h.`descendantid` 
  INNER JOIN `jos8m_sigplus_folder` AS a 
  ON a.`folderid` = h.`ancestorid` 
  INNER JOIN `jos8m_sigplus_imageview` AS v 
  ON i.`imageid` = v.`imageid`

Tabele OTHER:

```
2 × START TRANSACTIO
```
```
2 × COMMI
```

1 × INSERT INTO `jos8m_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3536336466386232313439366532623032613964396263623139373666633036', 1, 1696246726, 0, '', 0

1 × UPDATE `jos8m_extensions` 
  SET `params` = '{\"mediaversion\":\"11a50f0e74f7a0cfc0bc9c4ef3f8393b\"}'