Portugal Travel Guide

Search

Thank you for visiting the Portugal Travel Guide, the popular webzine for savvy travellers.
Scroll down for a range of articles about where to go and what to see and do in Europe's sunny south-westernmost country.
We hope you enjoy what you read and wish you a very pleasant stay in Portugal.

Booking.com

Father of the Nation

Details

Published: 17 November 2018

Written by MWH

One of the most legendary and influential figures of Portugal’s long and chequered history is Afonso Henriques, the country’s first king.

Read more: ...

Coast to Coast

Details

Published: 16 November 2018

Written by MWH

Bordering the south-western edge of the Iberian Peninsula, with around half of its periphery surrounded by water, Portugal's shoreline has been a source of attraction as well as a gateway to the rest of the world for hundreds of years.

Read more: ...

The Brides of St Anthony

Details

Published: 06 September 2018

Written by MWH

One of the most joyful expressions of love and happiness can be witnessed in the faces of the Noivas de Santo António (Brides of St Anthony) who take their wedding vows in the hallowed setting of Lisbon’s magnificent Sé Cathedral each June.

Read more: The...

All the Grace of the Guadiana

Details

Published: 01 November 2018

Written by MWH

Running the length of Portugal’s south-eastern border with neighbouring Spain, the River Guadiana rises up from the heart of the Spanish province of Albacete at an altitude of 1,700 metres before meandering its way through some of the most picturesque landscapes in the whole of the Iberian Peninsula, eventually spilling out into the Atlantic Ocean at the border town of Vila Real de Santo António.

Read more: All...

The Intricate Art of Scrimshaw

Details

Published: 03 October 2018

Written by MWH

A very popular form of artistic expression in the 19th century, scrimshaw is largely synonymous with the whaling heritage of the Azores islands, but the tradition has all but disappeared due to the diminishing supply of whale teeth.

Read more: The...

Floral Splendour

Details

Published: 28 October 2018

Written by MWH

With its tilting terrain and subtropical climate, Madeira’s flower power ranges from orchids tottering on three-foot-long stems and bougainvillea in bursting shades of red and purple. Delve deeper and you’ll find frangipani, an icon of the tropics, roses and carnations of all colours, bird-of-paradise flowers (strelitzia reginae), lilies, geraniums and the indigenous blue Madeiran pride.

Read more: ...

Lisbon's Favourite Tipple

Details

Published: 24 October 2018

Written by MWH

One of the more unusual features in the streets around Rossio, Lisbon's bustling central square, are the small bars with their dated interiors selling ginjinha, the local name for morello cherry brandy.

Read more: ...

The Panels of St Vincent

Details

Published: 01 December 2018

Written by MWH

Portugal’s most acclaimed piece of art is the six-panelled painting by Nuno Gonçalves depicting a group of fifty-eight people assembled together as a monumental and somewhat solemn representation of Portugal’s royal family and a vast cross-section of Portuguese society in the 15th century.

Read more: The...

The Highest of Portuguese Flyers

Details

Published: 15 November 2018

Written by MWH

Charles Lindbergh might have received global recognition for his solo air crossing of the Atlantic in 1927, but it was two Portuguese pilots - Gago Coutinho and Sacadura Cabral (pictured left and right, respectively) - who had previously set the pace five years earlier with their historic journey from Portugal to Brazil, the world’s first-ever flight over the South Atlantic.

Read more: The...

Liquid Gold

Details

Published: 25 October 2018

Written by MWH

The Phoenicians first brought olive trees across the Mediterranean to Portugal and the Romans were very successful in cultivating the groves and pressing the olives to attain the precious oil. Today, olive trees are a regular feature of the Portuguese landscape, with the annual harvest taking place midway between the autumnal grape-gathering period and the Christmas festive season.

Read more: ...

The Last Old Place

Details

Published: 09 November 2018

Written by MWH

Latin but not Mediterranean, cosmopolitan but not over-crowded, Portugal is a country where a large percentage of the population lives as people have always lived - in small, peaceful villages far away from noisy traffic and the hustle and bustle of modern life.

Read more: The...

The Flying Man

Details

Published: 30 October 2018

Written by MWH

One of the most inventive characters of the 18th century must surely have been Bartolomeu Lourenço de Gusmão, the Brazilian-born genius who created the earliest known flying machine he christened the Passarola, a fire-powered aircraft which he showcased to Portugal's king and queen in Lisbon's Terreiro do Paço square on the 8th of August 1709.

Read more: The...

Sidebar

Contents

North

Lisbon

Azores

Madeira

South

Centre

Food & Wine

Features

General Info

HOTEL DEALS

Top Stories

Lisbon's Ancient Origins

The Historic Town of Tomar

Gateway to the Azores

The Atlantic City of Funchal

A Piece of Maritime History

We have 186 guests and no members online

Close

Joomla! Debug Console
Session
{ "__default": { "session": { "counter": 2, "timer": { "start": 1553085708, "last": 1553085708, "now": 1553085711 }, "token": "y3hjaLhCt3v3u1WGuOnJL6TchVPQyR0w" }, "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 } } }

Profile Information
Time
Memory
Time: 47.21 ms / 47.21 ms Memory: 2.018 MB / 2.23 MB Application: afterLoad
Time: 249.91 ms / 297.12 ms Memory: 7.539 MB / 9.76 MB Application: afterInitialise
Time: 1107.43 ms / 1404.55 ms Memory: 3.584 MB / 13.35 MB Application: afterRoute
Time: 1.38 ms / 1405.93 ms Memory: 0.029 MB / 13.38 MB Application: beforeRenderComponent com_content
Time: 12.87 ms / 1418.80 ms Memory: 1.110 MB / 14.49 MB Application: afterRenderComponent com_content
Time: 2.44 ms / 1421.23 ms Memory: 0.158 MB / 14.65 MB Application: afterDispatch
Time: 4.44 ms / 1425.67 ms Memory: 0.238 MB / 14.88 MB Application: beforeRenderModule mod_articles_categories (Contents)
Time: 15.13 ms / 1440.80 ms Memory: 0.713 MB / 15.60 MB Application: afterRenderModule mod_articles_categories (Contents)
Time: 0.70 ms / 1441.50 ms Memory: 0.002 MB / 15.60 MB Application: beforeRenderModule mod_whosonline (Who's Online)
Time: 2.59 ms / 1444.09 ms Memory: 0.050 MB / 15.65 MB Application: afterRenderModule mod_whosonline (Who's Online)
Time: 108.78 ms / 1552.87 ms Memory: 0.514 MB / 16.16 MB Application: afterRender

Database queries total: 969.78 ms
Memory Usage
16.61 MB (17,422,072 Bytes)
Database Queries
28 Queries Logged 969.78 ms

Query Time: 0.33 ms Query memory: 0.019 MB Memory before query: 4.473 MB Rows returned: 1
SELECT `data`
  FROM `zrqyl_session`
  WHERE `session_id` = '5537e2de5dd1d6a5ef5c56bf7e02e1db'
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE zrqyl_session const PRIMARY PRIMARY 194 const 1
Profile
Status Duration
starting 0.05 ms
checking permissions 0.01 ms
Opening tables 0.03 ms
System lock 0.01 ms
init 0.02 ms
optimizing 0.01 ms
statistics 0.06 ms
preparing 0.02 ms
executing 0.00 ms
Sending data 0.01 ms
end 0.00 ms
query end 0.00 ms
closing tables 0.01 ms
freeing items 0.02 ms
logging slow query 0.00 ms
cleaning up 0.00 ms
Call Stack
# Caller File and line number
16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734
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:660
9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620
8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498
7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455
6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:758
5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:135
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:344
2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140
1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.22 ms After last query: 21.79 ms Query memory: 0.013 MB Memory before query: 5.412 MB Rows returned: 4
SELECT id, rules
  FROM `zrqyl_viewlevels`
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE zrqyl_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 4
Profile
Status Duration
starting 0.02 ms
checking permissions 0.00 ms
Opening tables 0.01 ms
System lock 0.01 ms
init 0.01 ms
optimizing 0.00 ms
statistics 0.01 ms
preparing 0.00 ms
executing 0.00 ms
Sending data 0.04 ms
end 0.00 ms
query end 0.00 ms
closing tables 0.01 ms
freeing items 0.01 ms
logging slow query 0.00 ms
cleaning up 0.00 ms
Call Stack
# Caller File and line number
10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1500
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:321
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:196
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.30 ms After last query: 0.42 ms Query memory: 0.014 MB Memory before query: 5.437 MB Rows returned: 1
SELECT b.id
  FROM zrqyl_usergroups AS a
  LEFT JOIN zrqyl_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE a.id = 1
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 index idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 8 NULL 10 Using index
Profile
Status Duration
starting 0.04 ms
checking permissions 0.00 ms
checking permissions 0.00 ms
Opening tables 0.01 ms
System lock 0.01 ms
init 0.01 ms
optimizing 0.01 ms
statistics 0.08 ms
preparing 0.01 ms
executing 0.00 ms
Sending data 0.02 ms
end 0.00 ms
query end 0.00 ms
closing tables 0.01 ms
freeing items 0.02 ms
logging slow query 0.00 ms
cleaning up 0.00 ms
Call Stack
# Caller File and line number
11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544
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:321
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:196
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.88 ms After last query: 52.28 ms Query memory: 0.013 MB Memory before query: 7.735 MB Rows returned: 116
SHOW TABLES
Explain
EXPLAIN not possible on query: SHOW TABLES
Profile
Status Duration
starting 0.03 ms
checking permissions 0.01 ms
Opening tables 0.04 ms
System lock 0.01 ms
init 0.01 ms
optimizing 0.00 ms
statistics 0.01 ms
preparing 0.01 ms
executing 0.01 ms
checking permissions 0.55 ms
Sending data 0.07 ms
end 0.00 ms
query end 0.00 ms
closing tables 0.00 ms
removing tmp table 0.01 ms
closing tables 0.00 ms
freeing items 0.02 ms
logging slow query 0.00 ms
cleaning up 0.00 ms
Call Stack
# Caller File and line number
10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544
9 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/database/driver/mysqli.php:502
8 JDatabaseDriverMysqli->getTableList() JROOT/plugins/system/jasocial_feed/jasocial_feed.php:85
7 plgSystemjasocial_feed->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:283
6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182
5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:625
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:196
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 9.03 ms After last query: 89.40 ms Query memory: 0.018 MB Memory before query: 9.232 MB
UPDATE `zrqyl_extensions`
  SET `params` = '{\"mediaversion\":\"9f990d78e444ee7f2da381988c0e1845\"}'
  WHERE `type` = 'library'
  AND `element` = 'joomla'
Explain
EXPLAIN not possible on query: UPDATE `zrqyl_extensions` SET `params` = '{\"mediaversion\":\"9f990d78e444ee7f2da381988c0e1845\"}' WHERE `type` = 'library' AND `element` = 'joomla'
Profile
Status Duration
starting 0.09 ms
checking permissions 0.01 ms
Opening tables 0.03 ms
System lock 0.01 ms
init 0.14 ms
Updating 0.10 ms
end 0.00 ms
Waiting for query cache lock 0.00 ms
end 0.01 ms
query end 8.51 ms
closing tables 0.02 ms
freeing items 0.03 ms
logging slow query 0.00 ms
cleaning up 0.00 ms
Call Stack
# Caller File and line number
15 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117
14 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372
13 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331
12 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778
11 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234
10 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/jasocial_feed/jasocial_feed.php:141
9 plgSystemjasocial_feed->onAfterInitialise() Same as call in the line below.
8 call_user_func_array() 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:626
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:196
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.22 ms After last query: 6.91 ms Query memory: 0.013 MB Memory before query: 9.587 MB Rows returned: 1
SELECT count(*)
  FROM `zrqyl_cwgears_schedule`
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Select tables optimized away
Profile
Status Duration
starting 0.03 ms
checking permissions 0.01 ms
Opening tables 0.02 ms
System lock 0.01 ms
init 0.01 ms
optimizing 0.01 ms
executing 0.01 ms
end 0.00 ms
query end 0.00 ms
closing tables 0.01 ms
freeing items 0.02 ms
logging slow query 0.00 ms
cleaning up 0.00 ms
Call Stack
# Caller File and line number
11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734
10 JDatabaseDriver->loadResult() JROOT/plugins/system/cwgears/cwgears.php:96
9 plgSystemCwgears->onAfterInitialise() Same as call in the line below.
8 call_user_func_array() 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:626
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:196
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.22 ms After last query: 0.29 ms Query memory: 0.013 MB Memory before query: 9.602 MB Rows returned: 1
SELECT count(*)
  FROM `zrqyl_cwgears_schedule`
  WHERE time + '3600'<'1553085712'
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables
Profile
Status Duration
starting 0.03 ms
checking permissions 0.00 ms
Opening tables 0.01 ms
System lock 0.01 ms
init 0.02 ms
optimizing 0.01 ms
statistics 0.02 ms
preparing 0.02 ms
executing 0.01 ms
end 0.00 ms
query end 0.00 ms
closing tables 0.01 ms
freeing items 0.02 ms
logging slow query 0.00 ms
cleaning up 0.00 ms
Call Stack
# Caller File and line number
11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734
10 JDatabaseDriver->loadResult() JROOT/plugins/system/cwgears/cwgears.php:139
9 plgSystemCwgears->onAfterInitialise() Same as call in the line below.
8 call_user_func_array() 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:626
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:196
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.29 ms After last query: 74.79 ms Query memory: 0.013 MB Memory before query: 11.947 MB Rows returned: 0
SELECT ip
  FROM `zrqyl_cwtraffic_knownips`
  WHERE state = 1
  AND count = 0
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables
Profile
Status Duration
starting 0.05 ms
checking permissions 0.01 ms
Opening tables 0.02 ms
System lock 0.01 ms
init 0.02 ms
optimizing 0.01 ms
statistics 0.02 ms
preparing 0.00 ms
executing 0.01 ms
end 0.00 ms
query end 0.01 ms
closing tables 0.01 ms
freeing items 0.02 ms
logging slow query 0.00 ms
cleaning up 0.00 ms
Call Stack
# Caller File and line number
11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544
10 JDatabaseDriver->loadColumn() JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:131
9 plgSystemCwtrafficCount->onAfterRoute() Same as call in the line below.
8 call_user_func_array() 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:1122
4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796
3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.18 ms After last query: 0.30 ms Query memory: 0.013 MB Memory before query: 11.962 MB Rows returned: 0
SELECT botname
  FROM `zrqyl_cwtraffic_knownips`
  WHERE state = 1
  AND count = 0
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables
Profile
Status Duration
starting 0.03 ms
checking permissions 0.01 ms
Opening tables 0.01 ms
System lock 0.01 ms
init 0.01 ms
optimizing 0.01 ms
statistics 0.01 ms
preparing 0.00 ms
executing 0.01 ms
end 0.00 ms
query end 0.00 ms
closing tables 0.01 ms
freeing items 0.02 ms
logging slow query 0.00 ms
cleaning up 0.00 ms
Call Stack
# Caller File and line number
11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1544
10 JDatabaseDriver->loadColumn() JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:161
9 plgSystemCwtrafficCount->onAfterRoute() Same as call in the line below.
8 call_user_func_array() 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:1122
4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796
3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.41 ms After last query: 0.36 ms Query memory: 0.013 MB Memory before query: 11.977 MB Rows returned: 1
SELECT count(*)
  FROM `zrqyl_cwtraffic`
  WHERE iphash = UNHEX(SHA1('193.136.192.159'))
  AND tm + '86400'>'1553085712'
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE zrqyl_cwtraffic ref idx_iphash,idx_iphashtm idx_iphashtm 21 const 5 Using where; Using index
Profile
Status Duration
starting 0.06 ms
checking permissions 0.01 ms
Opening tables 0.01 ms
System lock 0.01 ms
init 0.03 ms
optimizing 0.01 ms
statistics 0.12 ms
preparing 0.03 ms
executing 0.01 ms
Sending data 0.04 ms
end 0.01 ms
query end 0.00 ms
closing tables 0.01 ms
freeing items 0.02 ms
logging slow query 0.00 ms
cleaning up 0.00 ms
Call Stack
# Caller File and line number
11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734
10 JDatabaseDriver->loadResult() JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:217
9 plgSystemCwtrafficCount->onAfterRoute() Same as call in the line below.
8 call_user_func_array() 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:1122
4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796
3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 48.45 ms After last query: 18.43 ms Query memory: 0.014 MB Memory before query: 13.253 MB Rows returned: 602
SELECT id, ip
  FROM `zrqyl_cwtraffic`
  WHERE country_code = "" OR country_code is null
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE zrqyl_cwtraffic ALL NULL NO INDEX KEY COULD BE USED NULL NULL 80914 Using where
Profile
Status Duration
starting 0.03 ms
checking permissions 0.01 ms
Opening tables 0.01 ms
System lock 0.01 ms
init 0.02 ms
optimizing 0.01 ms
statistics 0.01 ms
preparing 0.01 ms
executing 0.00 ms
Sending data 48.06 ms
end 0.01 ms
query end 0.01 ms
closing tables 0.01 ms
freeing items 0.04 ms
logging slow query 0.00 ms
cleaning up 0.00 ms
Call Stack
# Caller File and line number
12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695
11 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_coalawebtraffic/helpers/location.php:64
10 CoalawebtrafficHelperLocation::location_update() JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:288
9 plgSystemCwtrafficCount->onAfterRoute() Same as call in the line below.
8 call_user_func_array() 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:1122
4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796
3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 377.84 ms After last query: 72.87 ms Query memory: 0.013 MB Memory before query: 13.261 MB
UPDATE zrqyl_cwtraffic
  SET city = NULL
  WHERE city = ""
Explain
EXPLAIN not possible on query: UPDATE zrqyl_cwtraffic SET city = NULL WHERE city = ""
Profile
Status Duration
starting 0.08 ms
checking permissions 0.01 ms
Opening tables 0.03 ms
System lock 0.01 ms
init 0.05 ms
Updating 377.53 ms
end 0.01 ms
query end 0.00 ms
closing tables 0.02 ms
freeing items 0.02 ms
logging slow query 0.00 ms
cleaning up 0.00 ms
Call Stack
# Caller File and line number
11 JDatabaseDriverMysqli->execute() JROOT/administrator/components/com_coalawebtraffic/helpers/location.php:105
10 CoalawebtrafficHelperLocation::location_update() JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:288
9 plgSystemCwtrafficCount->onAfterRoute() Same as call in the line below.
8 call_user_func_array() 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:1122
4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796
3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 525.94 ms After last query: 0.92 ms Query memory: 0.013 MB Memory before query: 13.296 MB Rows returned: 0
SELECT id,
  LEFT( tm, 9 ) , ip, count(*)
  FROM `zrqyl_cwtraffic`
  GROUP BY
  LEFT( tm, 9 ) , ip
  HAVING count(*) > 1
  LIMIT 50
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE zrqyl_cwtraffic ALL NULL NO INDEX KEY COULD BE USED NULL NULL 80914 Using temporary; Using filesort
Profile
Status Duration
starting 0.06 ms
checking permissions 0.01 ms
Opening tables 0.02 ms
System lock 0.01 ms
init 0.03 ms
optimizing 0.01 ms
statistics 0.02 ms
preparing 0.01 ms
Creating tmp table 0.04 ms
executing 0.00 ms
Copying to tmp table 516.74 ms
Sorting result 6.93 ms
Sending data 0.03 ms
end 0.00 ms
removing tmp table 1.94 ms
end 0.01 ms
query end 0.00 ms
closing tables 0.01 ms
freeing items 0.02 ms
logging slow query 0.00 ms
cleaning up 0.00 ms
Call Stack
# Caller File and line number
11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695
10 JDatabaseDriver->loadObjectList() JROOT/plugins/system/cwtrafficclean/cwtrafficclean.php:104
9 plgSystemCwtrafficClean->onAfterRoute() Same as call in the line below.
8 call_user_func_array() 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:1122
4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796
3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.18 ms After last query: 0.26 ms Query memory: 0.013 MB Memory before query: 13.308 MB Rows returned: 1
SELECT TCOUNT
  FROM `zrqyl_cwtraffic_total`
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE zrqyl_cwtraffic_total system NULL NO INDEX KEY COULD BE USED NULL NULL 1
Profile
Status Duration
starting 0.04 ms
checking permissions 0.01 ms
Opening tables 0.02 ms
System lock 0.01 ms
init 0.01 ms
optimizing 0.00 ms
statistics 0.02 ms
preparing 0.01 ms
executing 0.00 ms
Sending data 0.01 ms
end 0.00 ms
query end 0.00 ms
closing tables 0.00 ms
freeing items 0.01 ms
logging slow query 0.00 ms
cleaning up 0.00 ms
Call Stack
# Caller File and line number
11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734
10 JDatabaseDriver->loadResult() JROOT/plugins/system/cwtrafficclean/cwtrafficclean.php:144
9 plgSystemCwtrafficClean->onAfterRoute() Same as call in the line below.
8 call_user_func_array() 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:1122
4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796
3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.22 ms After last query: 0.25 ms Query memory: 0.013 MB Memory before query: 13.323 MB Rows returned: 1
SELECT count(*)
  FROM `zrqyl_cwtraffic`
  WHERE tm < '1519862400'
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE zrqyl_cwtraffic range unique_tm_ip,unique_tm_iphash,idx_tm idx_tm 4 NULL 4 Using where; Using index
Profile
Status Duration
starting 0.03 ms
checking permissions 0.00 ms
Opening tables 0.01 ms
System lock 0.01 ms
init 0.01 ms
optimizing 0.01 ms
statistics 0.07 ms
preparing 0.01 ms
executing 0.00 ms
Sending data 0.02 ms
end 0.00 ms
query end 0.00 ms
closing tables 0.01 ms
freeing items 0.01 ms
logging slow query 0.00 ms
cleaning up 0.00 ms
Call Stack
# Caller File and line number
11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734
10 JDatabaseDriver->loadResult() JROOT/plugins/system/cwtrafficclean/cwtrafficclean.php:213
9 plgSystemCwtrafficClean->onAfterRoute() Same as call in the line below.
8 call_user_func_array() 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:1122
4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796
3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.18 ms After last query: 0.26 ms Query memory: 0.014 MB Memory before query: 13.340 MB Rows returned: 1
SELECT count(*)
  FROM `zrqyl_extensions`
  WHERE `element` = 'cwgears'
  AND `extension_id` = ''
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables
Profile
Status Duration
starting 0.02 ms
checking permissions 0.00 ms
Opening tables 0.01 ms
System lock 0.01 ms
init 0.01 ms
optimizing 0.02 ms
statistics 0.04 ms
preparing 0.00 ms
executing 0.01 ms
end 0.00 ms
query end 0.00 ms
closing tables 0.01 ms
freeing items 0.01 ms
logging slow query 0.00 ms
cleaning up 0.00 ms
Call Stack
# Caller File and line number
12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734
11 JDatabaseDriver->loadResult() JROOT/plugins/system/cwgears/cwgears.php:1003
10 plgSystemCwgears->updateDownloadKeySub() JROOT/plugins/system/cwgears/cwgears.php:202
9 plgSystemCwgears->onAfterRoute() Same as call in the line below.
8 call_user_func_array() 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:1122
4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796
3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218
2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:196
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.71 ms After last query: 25.96 ms Query memory: 0.032 MB Memory before query: 15.217 MB Rows returned: 3
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 `zrqyl_categories` AS `s`
  INNER JOIN `zrqyl_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)
  AND c.published = 1
  AND s.id = 90
  ORDER BY c.lft
Explain
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 Using filesort
1 SIMPLE c range cat_idx,idx_access,idx_left_right cat_idx 207 NULL 13 Using where
Profile
Status Duration
starting 0.12 ms
checking permissions 0.01 ms
checking permissions 0.00 ms
Opening tables 0.06 ms
System lock 0.01 ms
init 0.05 ms
optimizing 0.02 ms
statistics 0.12 ms
preparing 0.03 ms
executing 0.00 ms
Sorting result 0.10 ms
Sending data 0.08 ms
end 0.00 ms
query end 0.00 ms
closing tables 0.02 ms
freeing items 0.02 ms
logging slow query 0.00 ms
cleaning up 0.00 ms
Call Stack
# Caller File and line number
26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695
25 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324
24 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184
23 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72
22 ContentRouter->getCategorySegment() Same as call in the line below.
21 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120
20 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
19 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222
18 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:672
17 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266
16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154
15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:102
14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:52
13 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_categories/tmpl/default_items.php:20
12 require JROOT/modules/mod_articles_categories/tmpl/default_items.php JROOT/modules/mod_articles_categories/tmpl/default.php:13
11 require JROOT/modules/mod_articles_categories/tmpl/default.php JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
10 include JROOT/modules/mod_articles_categories/mod_articles_categories.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:491
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.46 ms After last query: 0.84 ms Query memory: 0.031 MB Memory before query: 15.276 MB Rows returned: 3
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 `zrqyl_categories` AS `s`
  INNER JOIN `zrqyl_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)
  AND c.published = 1
  AND s.id = 91
  ORDER BY c.lft
Explain
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 Using filesort
1 SIMPLE c range cat_idx,idx_access,idx_left_right cat_idx 207 NULL 13 Using where
Profile
Status Duration
starting 0.08 ms
checking permissions 0.00 ms
checking permissions 0.00 ms
Opening tables 0.01 ms
System lock 0.01 ms
init 0.04 ms
optimizing 0.01 ms
statistics 0.07 ms
preparing 0.02 ms
executing 0.00 ms
Sorting result 0.06 ms
Sending data 0.06 ms
end 0.01 ms
query end 0.00 ms
closing tables 0.01 ms
freeing items 0.02 ms
logging slow query 0.00 ms
cleaning up 0.00 ms
Call Stack
# Caller File and line number
26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695
25 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324
24 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184
23 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72
22 ContentRouter->getCategorySegment() Same as call in the line below.
21 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120
20 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
19 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222
18 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:672
17 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266
16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154
15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:102
14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:52
13 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_categories/tmpl/default_items.php:20
12 require JROOT/modules/mod_articles_categories/tmpl/default_items.php JROOT/modules/mod_articles_categories/tmpl/default.php:13
11 require JROOT/modules/mod_articles_categories/tmpl/default.php JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
10 include JROOT/modules/mod_articles_categories/mod_articles_categories.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:491
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.45 ms After last query: 0.68 ms Query memory: 0.031 MB Memory before query: 15.318 MB Rows returned: 3
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 `zrqyl_categories` AS `s`
  INNER JOIN `zrqyl_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)
  AND c.published = 1
  AND s.id = 93
  ORDER BY c.lft
Explain
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 Using filesort
1 SIMPLE c range cat_idx,idx_access,idx_left_right cat_idx 207 NULL 13 Using where
Profile
Status Duration
starting 0.07 ms
checking permissions 0.00 ms
checking permissions 0.00 ms
Opening tables 0.01 ms
System lock 0.01 ms
init 0.03 ms
optimizing 0.01 ms
statistics 0.07 ms
preparing 0.02 ms
executing 0.00 ms
Sorting result 0.06 ms
Sending data 0.07 ms
end 0.00 ms
query end 0.00 ms
closing tables 0.01 ms
freeing items 0.02 ms
logging slow query 0.00 ms
cleaning up 0.00 ms
Call Stack
# Caller File and line number
26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695
25 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324
24 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184
23 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72
22 ContentRouter->getCategorySegment() Same as call in the line below.
21 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120
20 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
19 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222
18 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:672
17 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266
16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154
15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:102
14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:52
13 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_categories/tmpl/default_items.php:20
12 require JROOT/modules/mod_articles_categories/tmpl/default_items.php JROOT/modules/mod_articles_categories/tmpl/default.php:13
11 require JROOT/modules/mod_articles_categories/tmpl/default.php JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
10 include JROOT/modules/mod_articles_categories/mod_articles_categories.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:491
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.45 ms After last query: 0.66 ms Query memory: 0.031 MB Memory before query: 15.359 MB Rows returned: 3
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 `zrqyl_categories` AS `s`
  INNER JOIN `zrqyl_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)
  AND c.published = 1
  AND s.id = 96
  ORDER BY c.lft
Explain
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 Using filesort
1 SIMPLE c range cat_idx,idx_access,idx_left_right cat_idx 207 NULL 13 Using where
Profile
Status Duration
starting 0.07 ms
checking permissions 0.00 ms
checking permissions 0.00 ms
Opening tables 0.01 ms
System lock 0.01 ms
init 0.04 ms
optimizing 0.01 ms
statistics 0.07 ms
preparing 0.02 ms
executing 0.00 ms
Sorting result 0.07 ms
Sending data 0.06 ms
end 0.00 ms
query end 0.00 ms
closing tables 0.01 ms
freeing items 0.02 ms
logging slow query 0.00 ms
cleaning up 0.00 ms
Call Stack
# Caller File and line number
26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695
25 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324
24 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184
23 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72
22 ContentRouter->getCategorySegment() Same as call in the line below.
21 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120
20 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
19 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222
18 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:672
17 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266
16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154
15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:102
14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:52
13 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_categories/tmpl/default_items.php:20
12 require JROOT/modules/mod_articles_categories/tmpl/default_items.php JROOT/modules/mod_articles_categories/tmpl/default.php:13
11 require JROOT/modules/mod_articles_categories/tmpl/default.php JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
10 include JROOT/modules/mod_articles_categories/mod_articles_categories.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:491
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.43 ms After last query: 0.66 ms Query memory: 0.031 MB Memory before query: 15.401 MB Rows returned: 3
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 `zrqyl_categories` AS `s`
  INNER JOIN `zrqyl_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)
  AND c.published = 1
  AND s.id = 78
  ORDER BY c.lft
Explain
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 Using filesort
1 SIMPLE c range cat_idx,idx_access,idx_left_right cat_idx 207 NULL 13 Using where
Profile
Status Duration
starting 0.08 ms
checking permissions 0.00 ms
checking permissions 0.00 ms
Opening tables 0.01 ms
System lock 0.00 ms
init 0.03 ms
optimizing 0.01 ms
statistics 0.07 ms
preparing 0.02 ms
executing 0.00 ms
Sorting result 0.06 ms
Sending data 0.06 ms
end 0.00 ms
query end 0.00 ms
closing tables 0.01 ms
freeing items 0.02 ms
logging slow query 0.00 ms
cleaning up 0.00 ms
Call Stack
# Caller File and line number
26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695
25 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324
24 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184
23 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72
22 ContentRouter->getCategorySegment() Same as call in the line below.
21 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120
20 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
19 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222
18 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:672
17 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266
16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154
15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:102
14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:52
13 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_categories/tmpl/default_items.php:20
12 require JROOT/modules/mod_articles_categories/tmpl/default_items.php JROOT/modules/mod_articles_categories/tmpl/default.php:13
11 require JROOT/modules/mod_articles_categories/tmpl/default.php JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
10 include JROOT/modules/mod_articles_categories/mod_articles_categories.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:491
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.43 ms After last query: 0.66 ms Query memory: 0.031 MB Memory before query: 15.443 MB Rows returned: 3
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 `zrqyl_categories` AS `s`
  INNER JOIN `zrqyl_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)
  AND c.published = 1
  AND s.id = 80
  ORDER BY c.lft
Explain
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 Using filesort
1 SIMPLE c range cat_idx,idx_access,idx_left_right cat_idx 207 NULL 13 Using where
Profile
Status Duration
starting 0.07 ms
checking permissions 0.00 ms
checking permissions 0.00 ms
Opening tables 0.01 ms
System lock 0.01 ms
init 0.03 ms
optimizing 0.01 ms
statistics 0.07 ms
preparing 0.02 ms
executing 0.00 ms
Sorting result 0.06 ms
Sending data 0.06 ms
end 0.00 ms
query end 0.00 ms
closing tables 0.01 ms
freeing items 0.02 ms
logging slow query 0.00 ms
cleaning up 0.00 ms
Call Stack
# Caller File and line number
26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695
25 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324
24 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184
23 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72
22 ContentRouter->getCategorySegment() Same as call in the line below.
21 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120
20 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
19 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222
18 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:672
17 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266
16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154
15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:102
14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:52
13 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_categories/tmpl/default_items.php:20
12 require JROOT/modules/mod_articles_categories/tmpl/default_items.php JROOT/modules/mod_articles_categories/tmpl/default.php:13
11 require JROOT/modules/mod_articles_categories/tmpl/default.php JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
10 include JROOT/modules/mod_articles_categories/mod_articles_categories.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:491
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.42 ms After last query: 0.66 ms Query memory: 0.031 MB Memory before query: 15.485 MB Rows returned: 3
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 `zrqyl_categories` AS `s`
  INNER JOIN `zrqyl_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)
  AND c.published = 1
  AND s.id = 110
  ORDER BY c.lft
Explain
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 Using filesort
1 SIMPLE c range cat_idx,idx_access,idx_left_right cat_idx 207 NULL 13 Using where
Profile
Status Duration
starting 0.07 ms
checking permissions 0.00 ms
checking permissions 0.00 ms
Opening tables 0.01 ms
System lock 0.01 ms
init 0.03 ms
optimizing 0.01 ms
statistics 0.07 ms
preparing 0.02 ms
executing 0.00 ms
Sorting result 0.06 ms
Sending data 0.06 ms
end 0.00 ms
query end 0.00 ms
closing tables 0.01 ms
freeing items 0.02 ms
logging slow query 0.00 ms
cleaning up 0.00 ms
Call Stack
# Caller File and line number
26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695
25 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324
24 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184
23 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72
22 ContentRouter->getCategorySegment() Same as call in the line below.
21 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120
20 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
19 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222
18 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:672
17 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266
16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154
15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:102
14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:52
13 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_categories/tmpl/default_items.php:20
12 require JROOT/modules/mod_articles_categories/tmpl/default_items.php JROOT/modules/mod_articles_categories/tmpl/default.php:13
11 require JROOT/modules/mod_articles_categories/tmpl/default.php JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
10 include JROOT/modules/mod_articles_categories/mod_articles_categories.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:491
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.42 ms After last query: 0.66 ms Query memory: 0.031 MB Memory before query: 15.527 MB Rows returned: 3
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 `zrqyl_categories` AS `s`
  INNER JOIN `zrqyl_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)
  AND c.published = 1
  AND s.id = 111
  ORDER BY c.lft
Explain
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 Using filesort
1 SIMPLE c range cat_idx,idx_access,idx_left_right cat_idx 207 NULL 13 Using where
Profile
Status Duration
starting 0.07 ms
checking permissions 0.00 ms
checking permissions 0.00 ms
Opening tables 0.01 ms
System lock 0.01 ms
init 0.03 ms
optimizing 0.01 ms
statistics 0.07 ms
preparing 0.02 ms
executing 0.00 ms
Sorting result 0.06 ms
Sending data 0.06 ms
end 0.00 ms
query end 0.00 ms
closing tables 0.01 ms
freeing items 0.02 ms
logging slow query 0.00 ms
cleaning up 0.00 ms
Call Stack
# Caller File and line number
26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695
25 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324
24 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184
23 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72
22 ContentRouter->getCategorySegment() Same as call in the line below.
21 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120
20 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
19 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222
18 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:672
17 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266
16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154
15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:102
14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:52
13 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_categories/tmpl/default_items.php:20
12 require JROOT/modules/mod_articles_categories/tmpl/default_items.php JROOT/modules/mod_articles_categories/tmpl/default.php:13
11 require JROOT/modules/mod_articles_categories/tmpl/default.php JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
10 include JROOT/modules/mod_articles_categories/mod_articles_categories.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:491
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.42 ms After last query: 0.65 ms Query memory: 0.031 MB Memory before query: 15.568 MB Rows returned: 3
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 `zrqyl_categories` AS `s`
  INNER JOIN `zrqyl_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)
  AND c.published = 1
  AND s.id = 113
  ORDER BY c.lft
Explain
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 Using filesort
1 SIMPLE c range cat_idx,idx_access,idx_left_right cat_idx 207 NULL 13 Using where
Profile
Status Duration
starting 0.07 ms
checking permissions 0.00 ms
checking permissions 0.00 ms
Opening tables 0.01 ms
System lock 0.01 ms
init 0.03 ms
optimizing 0.01 ms
statistics 0.07 ms
preparing 0.02 ms
executing 0.00 ms
Sorting result 0.06 ms
Sending data 0.06 ms
end 0.00 ms
query end 0.00 ms
closing tables 0.01 ms
freeing items 0.02 ms
logging slow query 0.00 ms
cleaning up 0.00 ms
Call Stack
# Caller File and line number
26 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695
25 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324
24 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184
23 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:72
22 ContentRouter->getCategorySegment() Same as call in the line below.
21 call_user_func_array() JROOT/libraries/src/Component/Router/RouterView.php:120
20 Joomla\CMS\Component\Router\RouterView->getPath() JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
19 Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() JROOT/libraries/src/Component/Router/RouterView.php:222
18 Joomla\CMS\Component\Router\RouterView->preprocess() JROOT/libraries/src/Router/SiteRouter.php:672
17 Joomla\CMS\Router\SiteRouter->processBuildRules() JROOT/libraries/src/Router/Router.php:266
16 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154
15 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:102
14 Joomla\CMS\Router\Route::link() JROOT/libraries/src/Router/Route.php:52
13 Joomla\CMS\Router\Route::_() JROOT/modules/mod_articles_categories/tmpl/default_items.php:20
12 require JROOT/modules/mod_articles_categories/tmpl/default_items.php JROOT/modules/mod_articles_categories/tmpl/default.php:13
11 require JROOT/modules/mod_articles_categories/tmpl/default.php JROOT/modules/mod_articles_categories/mod_articles_categories.php:35
10 include JROOT/modules/mod_articles_categories/mod_articles_categories.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:491
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.31 ms After last query: 2.95 ms Query memory: 0.016 MB Memory before query: 15.651 MB Rows returned: 186
SELECT guest, client_id
  FROM zrqyl_session
  WHERE client_id = 0
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE zrqyl_session ALL NULL NO INDEX KEY COULD BE USED NULL NULL 221 Using where
Profile
Status Duration
starting 0.02 ms
checking permissions 0.00 ms
Opening tables 0.01 ms
System lock 0.01 ms
init 0.01 ms
optimizing 0.00 ms
statistics 0.01 ms
preparing 0.01 ms
executing 0.00 ms
Sending data 0.16 ms
end 0.00 ms
query end 0.00 ms
closing tables 0.00 ms
freeing items 0.01 ms
logging slow query 0.00 ms
cleaning up 0.00 ms
Call Stack
# Caller File and line number
13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1695
12 JDatabaseDriver->loadObjectList() JROOT/modules/mod_whosonline/helper.php:45
11 ModWhosonlineHelper::getOnlineCount() JROOT/modules/mod_whosonline/mod_whosonline.php:19
10 include JROOT/modules/mod_whosonline/mod_whosonline.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:491
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.31 ms After last query: 4.14 ms Query memory: 0.019 MB Memory before query: 15.839 MB Rows returned: 0
SELECT uikit
  FROM `zrqyl_cwgears`
  WHERE url = 'https://www.portugaltravelguide.com/index.php?language=1'
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables
Profile
Status Duration
starting 0.02 ms
checking permissions 0.00 ms
Opening tables 0.18 ms
System lock 0.01 ms
init 0.01 ms
optimizing 0.01 ms
statistics 0.01 ms
preparing 0.00 ms
executing 0.01 ms
end 0.00 ms
query end 0.00 ms
closing tables 0.02 ms
freeing items 0.01 ms
logging slow query 0.00 ms
cleaning up 0.00 ms
Call Stack
# Caller File and line number
16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734
15 JDatabaseDriver->loadResult() JROOT/plugins/system/cwgears/helpers/loadcount.php:67
14 CwGearsHelperLoadcount::getCounts() JROOT/plugins/system/cwgears/cwgears.php:418
13 plgSystemCwgears->onBeforeCompileHead() Same as call in the line below.
12 call_user_func_array() JROOT/libraries/joomla/event/event.php:70
11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108
9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.11 ms After last query: 0.26 ms Query memory: 0.019 MB Memory before query: 15.859 MB Rows returned: 0
SELECT uikit_plus
  FROM `zrqyl_cwgears`
  WHERE url = 'https://www.portugaltravelguide.com/index.php?language=1'
Explain
id select_type table type possible_keys key key_len ref rows Extra
1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables
Profile
Status Duration
starting 0.02 ms
checking permissions 0.00 ms
Opening tables 0.01 ms
System lock 0.00 ms
init 0.01 ms
optimizing 0.00 ms
statistics 0.01 ms
preparing 0.00 ms
executing 0.01 ms
end 0.00 ms
query end 0.00 ms
closing tables 0.00 ms
freeing items 0.01 ms
logging slow query 0.00 ms
cleaning up 0.00 ms
Call Stack
# Caller File and line number
16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1734
15 JDatabaseDriver->loadResult() JROOT/plugins/system/cwgears/helpers/loadcount.php:67
14 CwGearsHelperLoadcount::getCounts() JROOT/plugins/system/cwgears/cwgears.php:427
13 plgSystemCwgears->onBeforeCompileHead() Same as call in the line below.
12 call_user_func_array() JROOT/libraries/joomla/event/event.php:70
11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160
10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108
9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491
6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783
5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557
4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
19 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
9 × 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 `zrqyl_categories` AS `s`
  INNER JOIN `zrqyl_categories` AS `c`
  ON (s.lft <= c.lft
  AND c.lft < s.rgt) OR (c.lft < s.lft
  AND s.rgt < c.rgt)
2 × SELECT count(*)
  FROM `zrqyl_cwtraffic`
1 × SELECT count(*)
  FROM `zrqyl_extensions`
1 × SELECT TCOUNT
  FROM `zrqyl_cwtraffic_total
1 × SELECT id, rules
  FROM `zrqyl_viewlevels
1 × SELECT guest, client_id
  FROM zrqyl_session
1 × SELECT uikit_plus
  FROM `zrqyl_cwgears`
1 × SELECT uikit
  FROM `zrqyl_cwgears`
1 × SELECT id,
  LEFT( tm, 9 ) , ip, count(*)
  FROM `zrqyl_cwtraffic`
  GROUP BY
  LEFT( tm, 9 ) , ip
  HAVING count(*) > 1
  LIMIT 5
1 × SELECT id, ip
  FROM `zrqyl_cwtraffic`
1 × SELECT count(*)
  FROM `zrqyl_cwgears_schedule`
1 × SELECT count(*)
  FROM `zrqyl_cwgears_schedule
1 × SELECT ip
  FROM `zrqyl_cwtraffic_knownips`
1 × SELECT botname
  FROM `zrqyl_cwtraffic_knownips`
1 × SELECT `data`
  FROM `zrqyl_session`
1 × SELECT b.id
  FROM zrqyl_usergroups AS a
  LEFT JOIN zrqyl_usergroups AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
OTHER Tables:
1 × UPDATE zrqyl_cwtraffic
  SET city = NULL
1 × UPDATE `zrqyl_extensions`
  SET `params` = '{\"mediaversion\":\"9f990d78e444ee7f2da381988c0e1845\"}'
1 × SHOW TABLE