Ristorante Cinese Giapponese Tian Jin

.

Via dei colli, n. 99 35143 Padova (PD) Italy
Tel. 049.624911

Email : andrea_shan@hotmail.it
P.Iva 05190850288

APRILE 2021 SIAMO APERTI TUTTI I GIORNI!!

Siamo aperti da lunedì a domenica con il seguente orario:
Pranzo 11:30 - 15:00
Cena 18:00 - 23:00

Si può prenotare dalle 11:30 su whatsapp al 3778405726 , online, telefonicamente al 049624911.

Si consiglia di prenotare dalle 11:30 - 18:00 per le consegne a domiclio.

Ritiro in negozio o con consegna a domiclio.

Come ordinare

APRILE 2021 SIAMO APERTI TUTTI I GIORNI!!

Orario da Lunedì a Domenica
11:30 - 14:30
18:00 - 22:30

Ordinare dalle 11:30 telefonicamente al 049624911 , online , whatsapp al 3778405726.

Per le ordinazioni con consegna a domicilio si consiglia di ordinare dalle 11:30 - 18:00 per garantire la disponibilità e l'orario della consegna.

.

Ristorante cinese Tian Jin, situato a Padova , utilizza sempre prodotti freschi e di ottima qualità
Prepariamo ogni piatto al momento dell'ordinazione garantendo un prodotto buono e saporito.

Potete prenotare sia in negozio che telefonicamente.

Contatti

RISTORANTE TIAN JIN

Via dei Colli, 99
35143 Padova (PD)

Tel.: 049.624911
email: andrea_shan@hotmail.it

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1679417465,
                "last": 1679417465,
                "now": 1679417465
            }
        },
        "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
        }
    }
}

Informazioni profilo

Tempo

Memoria

Tempo: 33.64 ms / 33.64 ms Memoria: 0.536 MB / 0.66 MB Application: afterLoad

Tempo: 159.24 ms / 192.88 ms Memoria: 3.026 MB / 3.68 MB Application: afterInitialise

Tempo: 13.76 ms / 206.64 ms Memoria: 0.364 MB / 4.05 MB Application: afterRoute

Tempo: 21.54 ms / 228.17 ms Memoria: 0.299 MB / 4.35 MB Application: beforeRenderComponent com_sppagebuilder

Tempo: 60.60 ms / 288.77 ms Memoria: 0.763 MB / 5.11 MB Application: Start JAccess::getAssetRules Old (1)

Tempo: 4.32 ms / 293.09 ms Memoria: 0.041 MB / 5.15 MB Application: Finish JAccess::getAssetRules Old (1)

Tempo: 0.24 ms / 293.33 ms Memoria: 0.000 MB / 5.15 MB Application: Start JAccess::preload(components)

Tempo: 5.57 ms / 298.89 ms Memoria: 0.167 MB / 5.31 MB Application: Finish JAccess::preload(components)

Tempo: 75.95 ms / 374.84 ms Memoria: 0.716 MB / 6.03 MB Application: beforeRenderModule mod_jfslideshow (Slideshow tavolo)

Tempo: 12.66 ms / 387.50 ms Memoria: 0.124 MB / 6.16 MB Application: afterRenderModule mod_jfslideshow (Slideshow tavolo)

Tempo: 2.36 ms / 389.86 ms Memoria: 0.000 MB / 6.13 MB Application: beforeRenderModule mod_custom (Mappa locale)

Tempo: 5.66 ms / 395.52 ms Memoria: 0.006 MB / 6.14 MB Application: afterRenderModule mod_custom (Mappa locale)

Tempo: 0.21 ms / 395.74 ms Memoria: 0.000 MB / 6.05 MB Application: afterRenderComponent com_sppagebuilder

Tempo: 10.68 ms / 406.42 ms Memoria: 0.164 MB / 6.21 MB Application: afterDispatch

Tempo: 107.09 ms / 513.51 ms Memoria: 1.248 MB / 7.46 MB Application: beforeRenderModule mod_menu (Cellulare)

Tempo: 15.32 ms / 528.82 ms Memoria: 0.054 MB / 7.51 MB Application: afterRenderModule mod_menu (Cellulare)

Tempo: 0.26 ms / 529.08 ms Memoria: 0.000 MB / 7.51 MB Application: beforeRenderModule mod_custom (Contatti)

Tempo: 2.88 ms / 531.96 ms Memoria: 0.004 MB / 7.52 MB Application: afterRenderModule mod_custom (Contatti)

Tempo: 0.20 ms / 532.15 ms Memoria: 0.000 MB / 7.51 MB Application: beforeRenderModule mod_custom (DOVE SIAMO)

Tempo: 2.57 ms / 534.72 ms Memoria: 0.004 MB / 7.52 MB Application: afterRenderModule mod_custom (DOVE SIAMO)

Tempo: 0.18 ms / 534.90 ms Memoria: 0.000 MB / 7.52 MB Application: beforeRenderModule mod_menu (footer_menu)

Tempo: 13.56 ms / 548.46 ms Memoria: 0.067 MB / 7.58 MB Application: afterRenderModule mod_menu (footer_menu)

Tempo: 0.24 ms / 548.70 ms Memoria: 0.000 MB / 7.58 MB Application: beforeRenderModule mod_custom (Fotter1)

Tempo: 2.67 ms / 551.37 ms Memoria: 0.004 MB / 7.59 MB Application: afterRenderModule mod_custom (Fotter1)

Tempo: 16.40 ms / 567.77 ms Memoria: 0.152 MB / 7.74 MB Application: afterRender

Query totali del database: 66.32 ms

Utilizzo memoria

Query Database

25 query eseguite 66.32 ms

Tempo della query: 1.04 ms Memoria query: 0.011 MB memoria prima della query: 2.192 MB Righe restituite: 0

SELECT `data`

  FROM `rosjin_session`

  WHERE `session_id` = 'n76nn5urdh33jrjd120u8hr361'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rosjin_session	const	PRIMARY	PRIMARY	766	const	1

Profilo

Status	Duration
starting	0.07 ms
checking permissions	0.03 ms
Opening tables	0.06 ms
System lock	0.05 ms
init	0.04 ms
optimizing	0.06 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.10 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.44 ms
logging slow query	0.03 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT\libraries\joomla\session\storage\database.php:44
12	JSessionStorageDatabase->read()	Chiamata uguale alla linea sottostante.
11	session_start()	JROOT\libraries\joomla\session\handler\native.php:259
10	JSessionHandlerNative->doSessionStart()	JROOT\libraries\joomla\session\handler\native.php:49
9	JSessionHandlerNative->start()	JROOT\libraries\joomla\session\handler\joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT\libraries\joomla\session\session.php:636
7	JSession->_start()	JROOT\libraries\joomla\session\session.php:596
6	JSession->start()	JROOT\libraries\cms\application\cms.php:748
5	JApplicationCms->loadSession()	JROOT\libraries\cms\application\cms.php:131
4	JApplicationCms->__construct()	JROOT\libraries\cms\application\site.php:63
3	JApplicationSite->__construct()	JROOT\libraries\cms\application\cms.php:404
2	JApplicationCms::getInstance()	JROOT\libraries\joomla\factory.php:125
1	JFactory::getApplication()	JROOT\index.php:46

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 2.67 ms Dopo l'ultima query: 7.20 ms Memoria query: 0.005 MB memoria prima della query: 2.346 MB

DELETE 

  FROM `rosjin_session`

  WHERE `time` < '1679416565'

Explain

EXPLAIN non possibile sulla query: DELETE FROM `rosjin_session` WHERE `time` < '1679416565'

Profilo

Status	Duration
starting	0.05 ms
checking permissions	0.04 ms
Opening tables	0.03 ms
System lock	0.04 ms
init	0.09 ms
updating	0.21 ms
end	0.03 ms
Waiting for query cache lock	0.03 ms
end	0.03 ms
query end	1.66 ms
closing tables	0.05 ms
freeing items	0.14 ms
logging slow query	0.03 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
6	JDatabaseDriverMysqli->execute()	JROOT\libraries\cms\application\cms.php:765
5	JApplicationCms->loadSession()	JROOT\libraries\cms\application\cms.php:131
4	JApplicationCms->__construct()	JROOT\libraries\cms\application\site.php:63
3	JApplicationSite->__construct()	JROOT\libraries\cms\application\cms.php:404
2	JApplicationCms::getInstance()	JROOT\libraries\joomla\factory.php:125
1	JFactory::getApplication()	JROOT\index.php:46

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.84 ms Dopo l'ultima query: 0.26 ms Memoria query: 0.007 MB memoria prima della query: 2.354 MB Righe restituite: 0

SELECT `session_id`

  FROM `rosjin_session`

  WHERE `session_id` = 'n76nn5urdh33jrjd120u8hr361' 
  LIMIT 1

Explain

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

Profilo

Status	Duration
starting	0.05 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
System lock	0.03 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.03 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.04 ms
freeing items	0.14 ms
logging slow query	0.03 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
8	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1728
7	JDatabaseDriver->loadResult()	JROOT\libraries\cms\application\cms.php:176
6	JApplicationCms->checkSession()	JROOT\libraries\cms\application\cms.php:774
5	JApplicationCms->loadSession()	JROOT\libraries\cms\application\cms.php:131
4	JApplicationCms->__construct()	JROOT\libraries\cms\application\site.php:63
3	JApplicationSite->__construct()	JROOT\libraries\cms\application\cms.php:404
2	JApplicationCms::getInstance()	JROOT\libraries\joomla\factory.php:125
1	JFactory::getApplication()	JROOT\index.php:46

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 2.23 ms Dopo l'ultima query: 0.29 ms Memoria query: 0.005 MB memoria prima della query: 2.361 MB

INSERT INTO `rosjin_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('n76nn5urdh33jrjd120u8hr361', 0, '1679417465')

Explain

EXPLAIN non possibile sulla query: INSERT INTO `rosjin_session` (`session_id`, `client_id`, `time`) VALUES ('n76nn5urdh33jrjd120u8hr361', 0, '1679417465')

Profilo

Status	Duration
starting	0.05 ms
checking permissions	0.03 ms
Opening tables	0.05 ms
System lock	0.03 ms
init	0.03 ms
update	0.08 ms
Waiting for query cache lock	0.03 ms
update	0.03 ms
end	0.03 ms
query end	1.52 ms
closing tables	0.03 ms
freeing items	0.13 ms
logging slow query	0.03 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
7	JDatabaseDriverMysqli->execute()	JROOT\libraries\cms\application\cms.php:208
6	JApplicationCms->checkSession()	JROOT\libraries\cms\application\cms.php:774
5	JApplicationCms->loadSession()	JROOT\libraries\cms\application\cms.php:131
4	JApplicationCms->__construct()	JROOT\libraries\cms\application\site.php:63
3	JApplicationSite->__construct()	JROOT\libraries\cms\application\cms.php:404
2	JApplicationCms::getInstance()	JROOT\libraries\joomla\factory.php:125
1	JFactory::getApplication()	JROOT\index.php:46

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.34 ms Dopo l'ultima query: 9.33 ms Memoria query: 0.012 MB memoria prima della query: 2.635 MB Righe restituite: 33

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

  FROM rosjin_extensions

  WHERE `type` = 'component'

Explain

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

Profilo

Status	Duration
starting	0.10 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
System lock	0.03 ms
init	0.05 ms
optimizing	0.05 ms
statistics	0.08 ms
preparing	0.05 ms
executing	0.03 ms
Sending data	0.35 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.14 ms
logging slow query	0.03 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1689
9	JDatabaseDriver->loadObjectList()	Chiamata uguale alla linea sottostante.
8	call_user_func_array()	JROOT\libraries\joomla\cache\controller\callback.php:152
7	JCacheControllerCallback->get()	JROOT\libraries\cms\component\helper.php:448
6	JComponentHelper::load()	JROOT\libraries\cms\component\helper.php:43
5	JComponentHelper::getComponent()	JROOT\libraries\cms\component\helper.php:120
4	JComponentHelper::getParams()	JROOT\libraries\cms\application\site.php:584
3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:257
1	JApplicationCms->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.99 ms Dopo l'ultima query: 4.29 ms Memoria query: 0.009 MB memoria prima della query: 2.782 MB Righe restituite: 2

SELECT b.id

  FROM rosjin_usergroups AS a

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

  WHERE a.id = 9

Explain

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	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	3	Using where; Using index

Profilo

Status	Duration
starting	0.09 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
System lock	0.03 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.04 ms
executing	0.03 ms
Sending data	0.07 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.14 ms
logging slow query	0.03 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1538
10	JDatabaseDriver->loadColumn()	JROOT\libraries\joomla\access\access.php:852
9	JAccess::getGroupsByUser()	JROOT\libraries\joomla\access\access.php:921
8	JAccess::getAuthorisedViewLevels()	JROOT\libraries\joomla\user\user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT\libraries\cms\plugin\helper.php:296
6	JPluginHelper::load()	JROOT\libraries\cms\plugin\helper.php:86
5	JPluginHelper::getPlugin()	JROOT\libraries\cms\plugin\helper.php:128
4	JPluginHelper::isEnabled()	JROOT\libraries\cms\application\site.php:594
3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:257
1	JApplicationCms->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.92 ms Dopo l'ultima query: 2.48 ms Memoria query: 0.009 MB memoria prima della query: 2.839 MB Righe restituite: 5

SELECT id, rules

  FROM `rosjin_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rosjin_viewlevels	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	5

Profilo

Status	Duration
starting	0.05 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
System lock	0.03 ms
init	0.04 ms
optimizing	0.04 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.03 ms
Sending data	0.07 ms
end	0.05 ms
query end	0.04 ms
closing tables	0.03 ms
freeing items	0.14 ms
logging slow query	0.03 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1494
9	JDatabaseDriver->loadAssocList()	JROOT\libraries\joomla\access\access.php:938
8	JAccess::getAuthorisedViewLevels()	JROOT\libraries\joomla\user\user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT\libraries\cms\plugin\helper.php:296
6	JPluginHelper::load()	JROOT\libraries\cms\plugin\helper.php:86
5	JPluginHelper::getPlugin()	JROOT\libraries\cms\plugin\helper.php:128
4	JPluginHelper::isEnabled()	JROOT\libraries\cms\application\site.php:594
3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:257
1	JApplicationCms->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.63 ms Dopo l'ultima query: 0.95 ms Memoria query: 0.008 MB memoria prima della query: 2.851 MB Righe restituite: 45

SELECT folder AS type, element AS name, params

  FROM rosjin_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rosjin_extensions	ref	extension	extension	82	const	58	Using where; Using filesort

Profilo

Status	Duration
starting	0.09 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
System lock	0.03 ms
init	0.04 ms
optimizing	0.04 ms
statistics	0.09 ms
preparing	0.04 ms
executing	0.03 ms
Sorting result	0.44 ms
Sending data	0.28 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.14 ms
logging slow query	0.03 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
8	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1689
7	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\plugin\helper.php:310
6	JPluginHelper::load()	JROOT\libraries\cms\plugin\helper.php:86
5	JPluginHelper::getPlugin()	JROOT\libraries\cms\plugin\helper.php:128
4	JPluginHelper::isEnabled()	JROOT\libraries\cms\application\site.php:594
3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:257
1	JApplicationCms->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.60 ms Dopo l'ultima query: 76.84 ms Memoria query: 0.017 MB memoria prima della query: 3.855 MB Righe restituite: 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 rosjin_menu AS m

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

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

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	227	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	sql689332_5.m.component_id	1

Profilo

Status	Duration
starting	0.10 ms
checking permissions	0.03 ms
checking permissions	0.04 ms
Opening tables	0.06 ms
System lock	0.03 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.08 ms
preparing	0.04 ms
executing	0.03 ms
Sorting result	0.27 ms
Sending data	0.37 ms
end	0.04 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.13 ms
logging slow query	0.03 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\menu\site.php:86
14	JMenuSite->load()	JROOT\libraries\cms\menu\menu.php:74
13	JMenu->__construct()	JROOT\libraries\cms\menu\site.php:57
12	JMenuSite->__construct()	JROOT\libraries\cms\menu\menu.php:133
11	JMenu::getInstance()	JROOT\libraries\cms\application\cms.php:435
10	JApplicationCms->getMenu()	JROOT\libraries\cms\application\site.php:272
9	JApplicationSite->getMenu()	JROOT\libraries\cms\router\site.php:57
8	JRouterSite->__construct()	JROOT\libraries\cms\router\router.php:196
7	JRouter::getInstance()	JROOT\libraries\cms\application\cms.php:531
6	JApplicationCms::getRouter()	JROOT\libraries\cms\application\site.php:407
5	JApplicationSite::getRouter()	JROOT\libraries\cms\application\cms.php:1091
4	JApplicationCms->route()	JROOT\libraries\cms\application\site.php:776
3	JApplicationSite->route()	JROOT\libraries\cms\application\site.php:215
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:257
1	JApplicationCms->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.89 ms Dopo l'ultima query: 7.18 ms Memoria query: 0.012 MB memoria prima della query: 4.085 MB Righe restituite: 1

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

  FROM rosjin_extensions

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

Explain

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

Profilo

Status	Duration
starting	0.06 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
System lock	0.03 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.05 ms
executing	0.04 ms
Sending data	0.07 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.16 ms
logging slow query	0.03 ms
cleaning up	0.05 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1650
13	JDatabaseDriver->loadObject()	Chiamata uguale alla linea sottostante.
12	call_user_func_array()	JROOT\libraries\joomla\cache\controller\callback.php:152
11	JCacheControllerCallback->get()	JROOT\libraries\cms\library\helper.php:156
10	JLibraryHelper::_load()	JROOT\libraries\cms\library\helper.php:47
9	JLibraryHelper::getLibrary()	JROOT\libraries\cms\library\helper.php:90
8	JLibraryHelper::getParams()	JROOT\libraries\cms\version\version.php:274
7	JVersion->getMediaVersion()	JROOT\libraries\joomla\factory.php:755
6	JFactory::createDocument()	JROOT\libraries\joomla\factory.php:216
5	JFactory::getDocument()	JROOT\libraries\joomla\application\web.php:991
4	JApplicationWeb->loadDocument()	JROOT\libraries\cms\application\site.php:130
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:257
1	JApplicationCms->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 2.37 ms Dopo l'ultima query: 0.39 ms Memoria query: 0.007 MB memoria prima della query: 4.080 MB

UPDATE `rosjin_extensions`

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

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

Explain

EXPLAIN non possibile sulla query: UPDATE `rosjin_extensions` SET `params` = '{\"mediaversion\":\"e7036c712bf21471b9927bf3ddc55f4d\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profilo

Status	Duration
starting	0.06 ms
checking permissions	0.05 ms
Opening tables	0.05 ms
System lock	0.04 ms
init	0.12 ms
Updating	0.08 ms
end	0.03 ms
Waiting for query cache lock	0.03 ms
end	0.03 ms
query end	1.51 ms
closing tables	0.05 ms
freeing items	0.14 ms
logging slow query	0.03 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
10	JDatabaseDriverMysqli->execute()	JROOT\libraries\cms\library\helper.php:119
9	JLibraryHelper::saveParams()	JROOT\libraries\cms\version\version.php:325
8	JVersion->setMediaVersion()	JROOT\libraries\cms\version\version.php:284
7	JVersion->getMediaVersion()	JROOT\libraries\joomla\factory.php:755
6	JFactory::createDocument()	JROOT\libraries\joomla\factory.php:216
5	JFactory::getDocument()	JROOT\libraries\joomla\application\web.php:991
4	JApplicationWeb->loadDocument()	JROOT\libraries\cms\application\site.php:130
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:257
1	JApplicationCms->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.93 ms Dopo l'ultima query: 7.42 ms Memoria query: 0.009 MB memoria prima della query: 4.260 MB Righe restituite: 2

SELECT *

  FROM rosjin_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rosjin_languages	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	Using where; Using filesort

Profilo

Status	Duration
starting	0.05 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
System lock	0.04 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.03 ms
Sorting result	0.07 ms
Sending data	0.07 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.17 ms
logging slow query	0.03 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File e numero di linea
7	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1689
6	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\language\helper.php:164
5	JLanguageHelper::getLanguages()	JROOT\libraries\cms\application\site.php:329
4	JApplicationSite->getParams()	JROOT\libraries\cms\application\site.php:135
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:257
1	JApplicationCms->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.16 ms Dopo l'ultima query: 1.22 ms Memoria query: 0.014 MB memoria prima della query: 4.276 MB Righe restituite: 4

SELECT id, home, template, s.params

  FROM rosjin_template_styles as s

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	5	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	sql689332_5.s.template,const	1	Using where

Profilo

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

Call Stack

#	Caller	File e numero di linea
6	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1689
5	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\application\site.php:484
4	JApplicationSite->getTemplate()	JROOT\libraries\cms\application\site.php:165
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:257
1	JApplicationCms->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 20.35 ms Dopo l'ultima query: 39.23 ms Memoria query: 0.021 MB memoria prima della query: 5.051 MB Righe restituite: 8

SHOW FULL COLUMNS 
  FROM `rosjin_assets`

Explain

EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `rosjin_assets`

Profilo

Status	Duration
starting	0.07 ms
checking permissions	0.03 ms
Opening tables	17.37 ms
System lock	0.04 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.04 ms
preparing	0.03 ms
executing	0.04 ms
Opening tables	0.06 ms
checking permissions	0.31 ms
checking permissions	0.15 ms
checking permissions	0.14 ms
checking permissions	0.06 ms
checking permissions	0.07 ms
checking permissions	0.14 ms
checking permissions	0.06 ms
checking permissions	0.06 ms
Sending data	0.11 ms
end	0.03 ms
query end	0.04 ms
closing tables	0.04 ms
removing tmp table	0.83 ms
closing tables	0.03 ms
freeing items	0.21 ms
logging slow query	0.04 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
24	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1689
23	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\database\driver\mysqli.php:440
22	JDatabaseDriverMysqli->getTableColumns()	JROOT\libraries\joomla\table\table.php:241
21	JTable->getFields()	JROOT\libraries\joomla\table\table.php:162
20	JTable->__construct()	JROOT\libraries\joomla\table\asset.php:60
19	JTableAsset->__construct()	JROOT\libraries\joomla\table\table.php:304
18	JTable::getInstance()	JROOT\libraries\joomla\access\access.php:714
17	JAccess::getExtensionNameFromAsset()	JROOT\libraries\joomla\access\access.php:576
16	JAccess::getAssetRules()	JROOT\libraries\joomla\user\user.php:385
15	JUser->authorise()	JROOT\components\com_sppagebuilder\models\page.php:29
14	SppagebuilderModelPage->populateState()	JROOT\libraries\legacy\model\legacy.php:439
13	JModelLegacy->getState()	JROOT\components\com_sppagebuilder\models\page.php:41
12	SppagebuilderModelPage->getItem()	JROOT\libraries\legacy\view\legacy.php:408
11	JViewLegacy->get()	JROOT\components\com_sppagebuilder\views\page\view.html.php:20
10	SppagebuilderViewPage->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_sppagebuilder\controller.php:73
8	SppagebuilderController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:16
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:257
1	JApplicationCms->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 2.03 ms Dopo l'ultima query: 4.38 ms Memoria query: 0.017 MB memoria prima della query: 5.098 MB Righe restituite: 1

SELECT *

  FROM rosjin_assets

  WHERE `id` = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rosjin_assets	const	PRIMARY	PRIMARY	4	const	1

Profilo

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

Call Stack

#	Caller	File e numero di linea
20	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1453
19	JDatabaseDriver->loadAssoc()	JROOT\libraries\joomla\table\table.php:715
18	JTable->load()	JROOT\libraries\joomla\access\access.php:715
17	JAccess::getExtensionNameFromAsset()	JROOT\libraries\joomla\access\access.php:576
16	JAccess::getAssetRules()	JROOT\libraries\joomla\user\user.php:385
15	JUser->authorise()	JROOT\components\com_sppagebuilder\models\page.php:29
14	SppagebuilderModelPage->populateState()	JROOT\libraries\legacy\model\legacy.php:439
13	JModelLegacy->getState()	JROOT\components\com_sppagebuilder\models\page.php:41
12	SppagebuilderModelPage->getItem()	JROOT\libraries\legacy\view\legacy.php:408
11	JViewLegacy->get()	JROOT\components\com_sppagebuilder\views\page\view.html.php:20
10	SppagebuilderViewPage->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_sppagebuilder\controller.php:73
8	SppagebuilderController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:16
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:257
1	JApplicationCms->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 0.97 ms Dopo l'ultima query: 0.46 ms Memoria query: 0.015 MB memoria prima della query: 5.111 MB Righe restituite: 1

SELECT a.rules

  FROM rosjin_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	Using union(PRIMARY,idx_asset_name); Using where

Profilo

Status	Duration
starting	0.05 ms
checking permissions	0.04 ms
Opening tables	0.04 ms
System lock	0.03 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.05 ms
preparing	0.04 ms
executing	0.04 ms
Sending data	0.12 ms
end	0.05 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.16 ms
logging slow query	0.03 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1538
17	JDatabaseDriver->loadColumn()	JROOT\libraries\joomla\access\access.php:670
16	JAccess::getAssetRules()	JROOT\libraries\joomla\user\user.php:385
15	JUser->authorise()	JROOT\components\com_sppagebuilder\models\page.php:29
14	SppagebuilderModelPage->populateState()	JROOT\libraries\legacy\model\legacy.php:439
13	JModelLegacy->getState()	JROOT\components\com_sppagebuilder\models\page.php:41
12	SppagebuilderModelPage->getItem()	JROOT\libraries\legacy\view\legacy.php:408
11	JViewLegacy->get()	JROOT\components\com_sppagebuilder\views\page\view.html.php:20
10	SppagebuilderViewPage->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_sppagebuilder\controller.php:73
8	SppagebuilderController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:16
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:257
1	JApplicationCms->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.32 ms Dopo l'ultima query: 3.58 ms Memoria query: 0.016 MB memoria prima della query: 5.149 MB Righe restituite: 33

SELECT element

  FROM rosjin_extensions

  WHERE type = 'component' 
  AND enabled = '1'

Explain

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

Profilo

Status	Duration
starting	0.07 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
System lock	0.03 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.06 ms
executing	0.03 ms
Sending data	0.23 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.04 ms
freeing items	0.23 ms
logging slow query	0.04 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
20	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1538
19	JDatabaseDriver->loadColumn()	JROOT\libraries\joomla\access\access.php:412
18	JAccess::preloadComponents()	JROOT\libraries\joomla\access\access.php:213
17	JAccess::preload()	JROOT\libraries\joomla\access\access.php:168
16	JAccess::check()	JROOT\libraries\joomla\user\user.php:394
15	JUser->authorise()	JROOT\components\com_sppagebuilder\models\page.php:29
14	SppagebuilderModelPage->populateState()	JROOT\libraries\legacy\model\legacy.php:439
13	JModelLegacy->getState()	JROOT\components\com_sppagebuilder\models\page.php:41
12	SppagebuilderModelPage->getItem()	JROOT\libraries\legacy\view\legacy.php:408
11	JViewLegacy->get()	JROOT\components\com_sppagebuilder\views\page\view.html.php:20
10	SppagebuilderViewPage->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_sppagebuilder\controller.php:73
8	SppagebuilderController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:16
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:257
1	JApplicationCms->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.41 ms Dopo l'ultima query: 0.42 ms Memoria query: 0.017 MB memoria prima della query: 5.170 MB Righe restituite: 33

SELECT a.name, a.rules

  FROM rosjin_assets AS a

  WHERE (a.name IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','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_redirect','com_search','com_spidercatalog','com_sppagebuilder','com_tags','com_templates','com_uniterevolution2','com_users','com_wrapper') OR a.name = 'root.1')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	idx_asset_name	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	105	Using where

Profilo

Status	Duration
starting	0.07 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
System lock	0.03 ms
init	0.08 ms
optimizing	0.04 ms
statistics	0.16 ms
preparing	0.04 ms
executing	0.03 ms
Sending data	0.38 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.16 ms
logging slow query	0.04 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File e numero di linea
20	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1494
19	JDatabaseDriver->loadAssocList()	JROOT\libraries\joomla\access\access.php:439
18	JAccess::preloadComponents()	JROOT\libraries\joomla\access\access.php:213
17	JAccess::preload()	JROOT\libraries\joomla\access\access.php:168
16	JAccess::check()	JROOT\libraries\joomla\user\user.php:394
15	JUser->authorise()	JROOT\components\com_sppagebuilder\models\page.php:29
14	SppagebuilderModelPage->populateState()	JROOT\libraries\legacy\model\legacy.php:439
13	JModelLegacy->getState()	JROOT\components\com_sppagebuilder\models\page.php:41
12	SppagebuilderModelPage->getItem()	JROOT\libraries\legacy\view\legacy.php:408
11	JViewLegacy->get()	JROOT\components\com_sppagebuilder\views\page\view.html.php:20
10	SppagebuilderViewPage->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_sppagebuilder\controller.php:73
8	SppagebuilderController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:16
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:257
1	JApplicationCms->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.12 ms Dopo l'ultima query: 3.42 ms Memoria query: 0.015 MB memoria prima della query: 5.328 MB Righe restituite: 1

SELECT a.*,l.title AS language_title,ua.name AS author_name

  FROM rosjin_sppagebuilder as a

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

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

  WHERE a.id = 3 
  AND a.published = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	8	const	1
1	SIMPLE	l	const	idx_langcode	idx_langcode	28	const	0	unique row not found
1	SIMPLE	ua	const	PRIMARY	PRIMARY	4	const	1

Profilo

Status	Duration
starting	0.06 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.04 ms
Opening tables	0.05 ms
System lock	0.03 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.09 ms
preparing	0.04 ms
executing	0.03 ms
Sending data	0.09 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.04 ms
freeing items	0.14 ms
logging slow query	0.03 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1650
13	JDatabaseDriver->loadObject()	JROOT\components\com_sppagebuilder\models\page.php:82
12	SppagebuilderModelPage->getItem()	JROOT\libraries\legacy\view\legacy.php:408
11	JViewLegacy->get()	JROOT\components\com_sppagebuilder\views\page\view.html.php:20
10	SppagebuilderViewPage->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_sppagebuilder\controller.php:73
8	SppagebuilderController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:16
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:257
1	JApplicationCms->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 9.50 ms Dopo l'ultima query: 3.55 ms Memoria query: 0.017 MB memoria prima della query: 5.365 MB Righe restituite: 18

SHOW FULL COLUMNS 
  FROM `rosjin_sppagebuilder`

Explain

EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `rosjin_sppagebuilder`

Profilo

Status	Duration
starting	0.05 ms
checking permissions	0.03 ms
Opening tables	5.85 ms
System lock	0.03 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.04 ms
preparing	0.04 ms
executing	0.04 ms
Opening tables	0.04 ms
checking permissions	0.22 ms
checking permissions	0.16 ms
checking permissions	0.15 ms
checking permissions	0.06 ms
checking permissions	0.07 ms
checking permissions	0.16 ms
checking permissions	0.06 ms
checking permissions	0.06 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.16 ms
checking permissions	0.06 ms
checking permissions	0.06 ms
checking permissions	0.05 ms
checking permissions	0.06 ms
checking permissions	0.07 ms
checking permissions	0.07 ms
checking permissions	0.08 ms
Sending data	0.15 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
removing tmp table	0.93 ms
closing tables	0.03 ms
freeing items	0.20 ms
logging slow query	0.04 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File e numero di linea
18	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\database\driver\mysqli.php:440
16	JDatabaseDriverMysqli->getTableColumns()	JROOT\libraries\joomla\table\table.php:241
15	JTable->getFields()	JROOT\libraries\joomla\table\table.php:162
14	JTable->__construct()	JROOT\administrator\components\com_sppagebuilder\tables\page.php:19
13	SppagebuilderTablePage->__construct()	JROOT\libraries\joomla\table\table.php:304
12	JTable::getInstance()	JROOT\components\com_sppagebuilder\models\page.php:126
11	SppagebuilderModelPage->hit()	JROOT\components\com_sppagebuilder\views\page\view.html.php:35
10	SppagebuilderViewPage->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_sppagebuilder\controller.php:73
8	SppagebuilderController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:16
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:257
1	JApplicationCms->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.02 ms Dopo l'ultima query: 0.61 ms Memoria query: 0.015 MB memoria prima della query: 5.404 MB Righe restituite: 1

SELECT *

  FROM rosjin_sppagebuilder

  WHERE `id` = '3'

Explain

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

Profilo

Status	Duration
starting	0.05 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
System lock	0.03 ms
init	0.05 ms
optimizing	0.05 ms
statistics	0.08 ms
preparing	0.05 ms
executing	0.03 ms
Sending data	0.10 ms
end	0.03 ms
query end	0.03 ms
closing tables	0.03 ms
freeing items	0.15 ms
logging slow query	0.03 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
14	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1453
13	JDatabaseDriver->loadAssoc()	JROOT\libraries\joomla\table\table.php:715
12	JTable->load()	JROOT\components\com_sppagebuilder\models\page.php:127
11	SppagebuilderModelPage->hit()	JROOT\components\com_sppagebuilder\views\page\view.html.php:35
10	SppagebuilderViewPage->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_sppagebuilder\controller.php:73
8	SppagebuilderController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:16
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:257
1	JApplicationCms->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 2.91 ms Dopo l'ultima query: 0.48 ms Memoria query: 0.010 MB memoria prima della query: 5.420 MB

UPDATE rosjin_sppagebuilder

  SET `hits` = (`hits` + 1)

  WHERE `id` = '3'

Explain

EXPLAIN non possibile sulla query: UPDATE rosjin_sppagebuilder SET `hits` = (`hits` + 1) WHERE `id` = '3'

Profilo

Status	Duration
starting	0.06 ms
checking permissions	0.04 ms
Opening tables	0.05 ms
System lock	0.04 ms
init	0.07 ms
Updating	0.09 ms
end	0.03 ms
Waiting for query cache lock	0.03 ms
end	0.03 ms
query end	1.77 ms
closing tables	0.04 ms
freeing items	0.20 ms
logging slow query	0.04 ms
cleaning up	0.04 ms

Call Stack

#	Caller	File e numero di linea
13	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\table\table.php:1224
12	JTable->hit()	JROOT\components\com_sppagebuilder\models\page.php:128
11	SppagebuilderModelPage->hit()	JROOT\components\com_sppagebuilder\views\page\view.html.php:35
10	SppagebuilderViewPage->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_sppagebuilder\controller.php:73
8	SppagebuilderController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:16
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:257
1	JApplicationCms->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.07 ms Dopo l'ultima query: 51.96 ms Memoria query: 0.017 MB memoria prima della query: 5.946 MB Righe restituite: 1

SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params

  FROM rosjin_modules AS m

  WHERE m.published = 1 
  AND m.id = 114 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-03-21 16:51:05') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-21 16:51:05') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	const	PRIMARY,published	PRIMARY	4	const	1

Profilo

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

Call Stack

#	Caller	File e numero di linea
21	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT\components\com_sppagebuilder\addons\module\site.php:69
19	sp_module_addon()	Chiamata uguale alla linea sottostante.
18	call_user_func()	JROOT\components\com_sppagebuilder\parser\addon-parser.php:85
17	AddonParser::doAddonTag()	Chiamata uguale alla linea sottostante.
16	preg_replace_callback()	JROOT\components\com_sppagebuilder\parser\addon-parser.php:33
15	AddonParser::spDoAddon()	JROOT\components\com_sppagebuilder\parser\addon-parser.php:385
14	AddonParser::viewAddons()	JROOT\components\com_sppagebuilder\views\page\tmpl\default.php:57
13	include JROOT\components\com_sppagebuilder\views\page\tmpl\default.php	JROOT\libraries\legacy\view\legacy.php:677
12	JViewLegacy->loadTemplate()	JROOT\libraries\legacy\view\legacy.php:216
11	JViewLegacy->display()	JROOT\components\com_sppagebuilder\views\page\view.html.php:38
10	SppagebuilderViewPage->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_sppagebuilder\controller.php:73
8	SppagebuilderController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:16
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:257
1	JApplicationCms->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 1.13 ms Dopo l'ultima query: 16.13 ms Memoria query: 0.017 MB memoria prima della query: 6.116 MB Righe restituite: 1

SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params

  FROM rosjin_modules AS m

  WHERE m.published = 1 
  AND m.id = 100 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-03-21 16:51:05') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-21 16:51:05') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	const	PRIMARY,published	PRIMARY	4	const	1

Profilo

Status	Duration
starting	0.12 ms
checking permissions	0.05 ms
Opening tables	0.04 ms
System lock	0.03 ms
init	0.07 ms
optimizing	0.04 ms
statistics	0.08 ms
preparing	0.05 ms
executing	0.03 ms
Sending data	0.05 ms
end	0.04 ms
query end	0.04 ms
closing tables	0.04 ms
freeing items	0.16 ms
logging slow query	0.03 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
21	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1689
20	JDatabaseDriver->loadObjectList()	JROOT\components\com_sppagebuilder\addons\module\site.php:69
19	sp_module_addon()	Chiamata uguale alla linea sottostante.
18	call_user_func()	JROOT\components\com_sppagebuilder\parser\addon-parser.php:85
17	AddonParser::doAddonTag()	Chiamata uguale alla linea sottostante.
16	preg_replace_callback()	JROOT\components\com_sppagebuilder\parser\addon-parser.php:33
15	AddonParser::spDoAddon()	JROOT\components\com_sppagebuilder\parser\addon-parser.php:385
14	AddonParser::viewAddons()	JROOT\components\com_sppagebuilder\views\page\tmpl\default.php:57
13	include JROOT\components\com_sppagebuilder\views\page\tmpl\default.php	JROOT\libraries\legacy\view\legacy.php:677
12	JViewLegacy->loadTemplate()	JROOT\libraries\legacy\view\legacy.php:216
11	JViewLegacy->display()	JROOT\components\com_sppagebuilder\views\page\view.html.php:38
10	SppagebuilderViewPage->display()	JROOT\libraries\legacy\controller\legacy.php:664
9	JControllerLegacy->display()	JROOT\components\com_sppagebuilder\controller.php:73
8	SppagebuilderController->display()	JROOT\libraries\legacy\controller\legacy.php:702
7	JControllerLegacy->execute()	JROOT\components\com_sppagebuilder\sppagebuilder.php:16
6	require_once JROOT\components\com_sppagebuilder\sppagebuilder.php	JROOT\libraries\cms\component\helper.php:405
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:380
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:257
1	JApplicationCms->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

Tempo della query: 4.87 ms Dopo l'ultima query: 108.78 ms Memoria query: 0.028 MB memoria prima della query: 7.226 MB Righe restituite: 47

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

  FROM rosjin_modules AS m

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

  LEFT JOIN rosjin_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-03-21 16:51:05') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-21 16:51:05') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 119 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

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

Profilo

Status	Duration
starting	0.12 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
Opening tables	0.06 ms
System lock	0.04 ms
init	0.07 ms
optimizing	0.05 ms
statistics	0.10 ms
preparing	0.07 ms
executing	0.03 ms
Sorting result	0.53 ms
Sending data	3.16 ms
end	0.03 ms
query end	0.04 ms
closing tables	0.04 ms
freeing items	0.14 ms
logging slow query	0.03 ms
cleaning up	0.03 ms

Call Stack

#	Caller	File e numero di linea
16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\module\helper.php:409
14	JModuleHelper::getModuleList()	JROOT\libraries\cms\module\helper.php:352
13	JModuleHelper::load()	JROOT\libraries\cms\module\helper.php:84
12	JModuleHelper::getModules()	JROOT\libraries\joomla\document\html.php:501
11	JDocumentHtml->countModules()	JROOT\plugins\system\helix3\core\helix3.php:593
10	Helix3::countModules()	JROOT\plugins\system\helix3\core\helix3.php:540
9	Helix3::rowColumns()	JROOT\plugins\system\helix3\core\helix3.php:258
8	Helix3::generatelayout()	JROOT\templates\at_marinser\index.php:172
7	require JROOT\templates\at_marinser\index.php	JROOT\libraries\joomla\document\html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT\libraries\joomla\document\html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT\libraries\joomla\document\html.php:455
4	JDocumentHtml->parse()	JROOT\libraries\cms\application\cms.php:1048
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:758
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:263
1	JApplicationCms->execute()	JROOT\index.php:49

[Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

23 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

2 × SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
 
  FROM rosjin_modules AS m

2 × SELECT extension_id AS id, element AS "option", params, enabled
 
  FROM rosjin_extensions

1 × SELECT element
 
  FROM rosjin_extensions

1 × SELECT a.rules
 
  FROM rosjin_assets AS a

1 × SELECT a.name, a.rules
 
  FROM rosjin_assets AS a

1 × SELECT *
 
  FROM rosjin_sppagebuilder

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

```
1 × SELECT *
 
  FROM rosjin_assets
```

1 × SELECT a.*,l.title AS language_title,ua.name AS author_name
 
  FROM rosjin_sppagebuilder as a
 
  LEFT JOIN `rosjin_languages` AS l 
  ON l.lang_code = a.language
 
  LEFT JOIN rosjin_users AS ua 
  ON ua.id = a.created_user_id

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

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

1 × SELECT `session_id`
 
  FROM `rosjin_session`

1 × SELECT id, rules
 
  FROM `rosjin_viewlevels

1 × SELECT folder AS type, element AS name, params
 
  FROM rosjin_extensions

1 × SELECT *
 
  FROM rosjin_languages

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 rosjin_menu AS m
 
  LEFT JOIN rosjin_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT `data`
 
  FROM `rosjin_session`

ALTRE tabelle:

1 × SHOW FULL COLUMNS 
  FROM `rosjin_sppagebuilder

1 × UPDATE rosjin_sppagebuilder
 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `rosjin_assets

1 × UPDATE `rosjin_extensions`
 
  SET `params` = '{\"mediaversion\":\"e7036c712bf21471b9927bf3ddc55f4d\"}'

1 × INSERT INTO `rosjin_session`
 (`session_id`, `client_id`, `time`) 
  VALUES 
 ('n76nn5urdh33jrjd120u8hr361', 0, '1679417465'

```
1 × DELETE 
 
  FROM `rosjin_session`
```