Skip to main content

Written By JPV Oliver, Gent   |  Photos PROVIDED

Among Saratoga’s charms are the surprises it holds, even for longtime residents.  For instance, there’s a direct link to the 19th Century Romantic Movement on Phila Street - and it’s likely you’ve visited it more than once.  

It’s called the Lyrical Ballad Bookstore at Number 7 (“Fine Books & Old Prints”) and it’s long been one of the city’s most elegant and quirky gems.

In 1798, William Wordsworth and Samuel Taylor Coleridge published a collection of their poems entitled Lyrical Ballads and it changed the course of English literature because their work in part gave new, vibrant voice to the poor who hitherto were ignored. 

It’s a landmark in the canon and remains the first major element of the Romantic Movement in art, literature, music, and intellectual thought that swept Europe in the 1800s.

Exactly 173 years on, in 1971, Troy native John DeMarco, a newly minted college graduate, snagged 70 boxes of used books at an auction, but he had no place to put them.  Being an enterprising sort, he rented what had been a tack shop on Phila and opened a bookshop.

A fan of Wordsworth and Coleridge, DeMarco chose an elegant name for the new business, Lyrical Ballads Bookshop.  He hired a sign painter who’d done work at Cole’s Woodwind Shop just down the street and the gold leaf lettering was exactly what DeMarco had in mind for his front window.  He gave the painter explicit instructions and motored off for an afternoon of errands.

On his return, John was aggrieved to discover the guy got it wrong – he left the “S” off Ballads and it would be another 50 bucks to correct the mistake.  Thus it was that The Lyrical Ballad Bookshop was born.

It’s the very quintessence of what a perfect bookstore should be; there’s more than a little magic about the place.  

It has more than 200,000 volumes of used and rare books, warrens of rooms – one more charming than the next - and, just when you think you’ve seen it all, you discover yet another hallway to wander down.  Lyrical Ballad is the antithesis of the modern, antiseptic chain bookstore.   To visit it is to delight the senses.

 As you’d expect, such places are themselves on the endangered species list, so Lyrical Ballad has gained an international reputation for its size and collection.  Even now, its social media footprint is slight, the owners preferring word-of-mouth and direct visits from their thousands of loyal customers.

John DeMarco owned and ran the shop for nearly 50 years along with his wife, Jan.  When he died in 2019, Lyrical Ballad was at a crossroads.  Was there somebody with the drive to keep this extraordinary enterprise a going concern, somebody who understood the magic?

Turns out there was.  

Jason Zerrillo loves the idea of bookshops and always has.  In fact, while still a student at Skidmore, he became the inventory manager at Borders in Saratoga, but ultimately found a home at the Lyrical Ballad, where he worked for 17 years before buying the place.

“Keeping the shop going is the best tribute we can possibly make to the memory of John DeMarco,” he says with evident affection.

Not surprisingly, he and co-owner, Charlie Israel, who works in his family's real estate and property restoration firm, are appropriately bookish.  Israel joined Lyrical Ballad in 2021 and found the opportunity irresistible. 

“I’ve just never encountered such a wonderful business anywhere in the world,” he says with a smile.  “Saratoga is so very lucky to have such a perfect specialty shop.”

True, the emphasis at Lyrical Ballad is on used books, but there are rare ones too.  They’re kept in a locked, vaulted room because many are fragile as well.  

One of the store’s most exotic items isn’t even for sale - a signed copy of Bram Stoker’s 1897 novel Dracula.  On learning this, the question naturally arises, “Is the shop haunted?”  It isn’t, most likely.

The store’s connection to the arts isn’t limited to the written word.  

They’ve sold several volumes to production companies, books which have appeared in TV shows such as Succession and The Marvelous Mrs Maisel.  It’s cheaper, easier, and quicker, Israel says, to buy old books to use as props than to reproduce them. 

As you’d expect when it comes to books about horse racing, Lyrical Ballad does not disappoint.  The selection is large, but one of the shop’s most popular volumes addresses the city’s extraordinary architectural history.  “That book’s a consistent performer for us,” Zerrillo notes. 

It may not be widely known, but Saratoga Springs has a vibrant literary scene, and the Lyrical Ballad is a vital part of it.  “Our city has a strong literary itch,” Zerrillo says, “and we play a big role in that.”  It’s key to the plans that he and Israel have for enhancements to their enterprise.

What comes across when you chat with Jason and Charlie is, of course, their evident love of old and rare books, but their affection for the clientele is greater still.

“That’s why our social media footprint is so limited,” Jason says.  “We have a lot more fun meeting our customers in the store.  They always have terrific stories to tell.” 

 

JPV Oliver’s memoir, I Know This Looks Bad, is available in all the usual places and his writing is published at LoucheLife.substack.com.

7.934MBMemory Usage155msRequest Duration
Joomla! Version4.4.13
PHP Version8.3.22
Identityguest
Response200
Templateyootheme
Database
Server
mysql
Version
8.4.5
Collation
utf8mb3_unicode_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
array:3 [ "catid" => "11" "id" => "739" "view" => "article" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:74 [ "USER" => "fivetowers" "HOME" => "/home/fivetowers" "SCRIPT_NAME" => "/index.php" ...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1752167602 "last" => 1752167602...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (444.69KB) (2.83ms)
  • afterInitialise (1.96MB) (30.41ms)
  • afterRoute (375.95KB) (4.73ms)
  • beforeRenderComponent com_content (48.96KB) (858μs)
  • Before Access::preloadComponents (all components) (47.72KB) (1.4ms)
  • After Access::preloadComponents (all components) (116.7KB) (2.11ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (23μs)
  • After Access::preloadPermissions (com_content) (527.41KB) (2.35ms)
  • Before Access::getAssetRules (id:914 name:com_content.article.739) (18.65KB) (32μs)
  • After Access::getAssetRules (id:914 name:com_content.article.739) (7.38KB) (115μs)
  • afterRenderComponent com_content (1.57MB) (77.41ms)
  • afterDispatch (21.42KB) (1.1ms)
  • beforeRenderRawModule mod_finder () (395.44KB) (13.02ms)
  • afterRenderRawModule mod_finder () (1.95MB) (8.48ms)
  • beforeRenderModule mod_finder () (704B) (6μs)
  • afterRenderModule mod_finder () (1.44KB) (143μs)
  • beforeRenderRawModule mod_menu () (1.66KB) (233μs)
  • afterRenderRawModule mod_menu () (56.55KB) (1.13ms)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (3.69KB) (103μs)
  • beforeRenderRawModule mod_custom () (920B) (63μs)
  • afterRenderRawModule mod_custom () (319.79KB) (1.15ms)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (3.15KB) (69μs)
  • beforeRenderRawModule mod_menu () (24B) (70μs)
  • afterRenderRawModule mod_menu () (552B) (418μs)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (2.76KB) (65μs)
  • beforeRenderRawModule mod_custom () (920B) (54μs)
  • afterRenderRawModule mod_custom () (1.03KB) (122μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (1.23KB) (57μs)
  • beforeRenderRawModule mod_menu () (1.8KB) (71μs)
  • afterRenderRawModule mod_menu () (4.45KB) (372μs)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (1.34KB) (80μs)
  • beforeRenderRawModule mod_finder () (96B) (8μs)
  • afterRenderRawModule mod_finder () (7.28KB) (532μs)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (1.34KB) (76μs)
  • beforeRenderRawModule mod_custom () (288B) (9μs)
  • afterRenderRawModule mod_custom () (912B) (140μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (1.23KB) (55μs)
  • beforeRenderRawModule mod_custom () (6.27KB) (152μs)
  • afterRenderRawModule mod_custom () (1008B) (116μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.77KB) (40μs)
  • beforeRenderRawModule mod_custom () (472B) (51μs)
  • afterRenderRawModule mod_custom () (1008B) (96μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.43KB) (37μs)
  • afterRender (290.95KB) (3.19ms)
  • 1 x afterRenderComponent com_content (1.57MB) (49.93%)
    77.41ms
    1 x afterInitialise (1.96MB) (19.62%)
    30.41ms
    1 x beforeRenderRawModule mod_finder () (395.44KB) (8.4%)
    13.02ms
    1 x afterRenderRawModule mod_finder () (1.95MB) (5.47%)
    8.48ms
    1 x afterRoute (375.95KB) (3.05%)
    4.73ms
    1 x afterRender (290.95KB) (2.06%)
    3.19ms
    1 x afterLoad (444.69KB) (1.83%)
    2.83ms
    1 x After Access::preloadPermissions (com_content) (527.41KB) (1.52%)
    2.35ms
    1 x After Access::preloadComponents (all components) (116.7KB) (1.36%)
    2.11ms
    1 x Before Access::preloadComponents (all components) (47.72KB) (0.9%)
    1.40ms
    1 x afterRenderRawModule mod_custom () (319.79KB) (0.74%)
    1.15ms
    1 x afterRenderRawModule mod_menu () (56.55KB) (0.73%)
    1.13ms
    1 x afterDispatch (21.42KB) (0.71%)
    1.10ms
    1 x beforeRenderComponent com_content (48.96KB) (0.55%)
    858μs
    1 x afterRenderRawModule mod_finder () (7.28KB) (0.34%)
    532μs
    1 x afterRenderRawModule mod_menu () (552B) (0.27%)
    418μs
    1 x afterRenderRawModule mod_menu () (4.45KB) (0.24%)
    372μs
    1 x beforeRenderRawModule mod_menu () (1.66KB) (0.15%)
    233μs
    2 x afterRenderRawModule mod_custom () (1008B) (0.14%)
    212μs
    1 x beforeRenderRawModule mod_custom () (6.27KB) (0.1%)
    152μs
    1 x afterRenderModule mod_finder () (1.44KB) (0.09%)
    143μs
    1 x afterRenderRawModule mod_custom () (912B) (0.09%)
    140μs
    1 x afterRenderRawModule mod_custom () (1.03KB) (0.08%)
    122μs
    2 x beforeRenderRawModule mod_custom () (920B) (0.08%)
    117μs
    1 x After Access::getAssetRules (id:914 name:com_content.article.739) (7.38KB) (0.07%)
    115μs
    2 x afterRenderModule mod_custom () (1.23KB) (0.07%)
    112μs
    1 x afterRenderModule mod_menu () (3.69KB) (0.07%)
    103μs
    1 x afterRenderModule mod_menu () (1.34KB) (0.05%)
    80μs
    1 x afterRenderModule mod_finder () (1.34KB) (0.05%)
    76μs
    1 x beforeRenderRawModule mod_menu () (1.8KB) (0.05%)
    71μs
    1 x beforeRenderRawModule mod_menu () (24B) (0.05%)
    70μs
    1 x afterRenderModule mod_custom () (3.15KB) (0.04%)
    69μs
    1 x afterRenderModule mod_menu () (2.76KB) (0.04%)
    65μs
    1 x beforeRenderRawModule mod_custom () (472B) (0.03%)
    51μs
    1 x afterRenderModule mod_custom () (2.77KB) (0.03%)
    40μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.02%)
    37μs
    1 x Before Access::getAssetRules (id:914 name:com_content.article.739) (18.65KB) (0.02%)
    32μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    23μs
    5 x beforeRenderModule mod_custom () (704B) (0.01%)
    14μs
    2 x beforeRenderModule mod_finder () (704B) (0.01%)
    10μs
    3 x beforeRenderModule mod_menu () (696B) (0.01%)
    10μs
    1 x beforeRenderRawModule mod_custom () (288B) (0.01%)
    9μs
    1 x beforeRenderRawModule mod_finder () (96B) (0.01%)
    8μs
54 statements were executed, 5 of which were duplicates, 49 unique36.99ms917.33KB
  • SELECT @@SESSION.sql_mode;93μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?815μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 193μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)786μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`431μs976B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `jos_usergroups` AS `a` LEFT JOIN `jos_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest596μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_k2" AND e.type = "component"659μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_virtuemart" AND e.type = "component"134μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_easyblog" AND e.type = "component"111μs1.13KB/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_jomclassifieds" AND e.type = "component"93μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_hikashop" AND e.type = "component"102μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_rseventspro" AND e.type = "component"94μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_zoo" AND e.type = "component"369μs536B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_jticketing" AND e.type = "component"119μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_icagenda" AND e.type = "component"111μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_eventbooking" AND e.type = "component"107μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_eshop" AND e.type = "component"91μs1.76KB/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_rsblog" AND e.type = "component"110μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_mijovideos" AND e.type = "component"103μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_opencart" AND e.type = "component"105μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_jcart" AND e.type = "component"90μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_djclassifieds" AND e.type = "component"93μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_j2store" AND e.type = "component"91μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_phocacart" AND e.type = "component"95μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_jshopping" AND e.type = "component"115μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_igallery" AND e.type = "component"93μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SELECT e.enabled FROM jos_extensions AS e WHERE e.element = "com_dpcalendar" AND e.type = "component"91μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SHOW FULL COLUMNS FROM `jos_tagz_config`1.39ms1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_tagz_config` WHERE `name` = 'config'136μs592B/libraries/src/Table/Table.php:755Copy
  • SELECT id,template FROM jos_template_styles WHERE client_id=0 AND home=1589μs592B/administrator/components/com_widgetkit/widgetkit.php:28Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system'253μs536B/plugins/system/yooessentials/helper.php:153Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 1134μs536B/plugins/system/yooessentials/modules/platform-joomla/src/Database.php:52Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41)1.61ms9.94KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `jos_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 01.5ms49.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`1.46ms1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '739'1.08ms48B/libraries/src/Table/Table.php:1325Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `jos_content` AS `a` INNER JOIN `jos_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `jos_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `jos_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `jos_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `jos_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)1.35ms54.13KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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 `jos_categories` AS `s` INNER JOIN `jos_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` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`752μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `jos_contentitem_tag_map` AS `m` INNER JOIN `jos_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2)757μs3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • 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 `jos_categories` AS `s` INNER JOIN `jos_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` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`394μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM jos_fields AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id LEFT JOIN jos_fields_groups AS g ON g.id = a.group_id LEFT JOIN `jos_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2)) AND `a`.`access` IN (:preparedArray3,:preparedArray4)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC643μs4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`catid`,`a`.`language`, CASE WHEN CHAR_LENGTH(`a`.`alias`) != 0 THEN CONCAT_WS(':', `a`.`id`, `a`.`alias`) ELSE a.id END AS `slug`, CASE WHEN CHAR_LENGTH(`cc`.`alias`) != 0 THEN CONCAT_WS(':', `cc`.`id`, `cc`.`alias`) ELSE cc.id END AS `catslug` FROM `jos_content` AS `a` LEFT JOIN `jos_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND `a`.`access` IN (:preparedArray1,:preparedArray2) AND (`publish_up` IS NULL OR `publish_up` <= :nowDate1) AND (`publish_down` IS NULL OR `publish_down` >= :nowDate2) ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC11.02ms41.72KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188Copy
  • 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 `jos_categories` AS `s` INNER JOIN `jos_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` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`372μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `jos_modules` AS `m` LEFT JOIN `jos_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `jos_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`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) ORDER BY `m`.`position`,`m`.`ordering`1.93ms19.06KBParams/libraries/src/Cache/Controller/CallbackController.php:120Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 123 AND `component_type` = "menu"1.16ms520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 739 AND `component_type` = "content"173μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `name`,`element` FROM `jos_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1279μs592B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `jos_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)586μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 12.26ms688.52KB/templates/yootheme/packages/platform-joomla/src/Storage.php:30Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM jos_fields AS a LEFT JOIN `jos_languages` AS l ON l.lang_code = a.language LEFT JOIN jos_users AS uc ON uc.id=a.checked_out LEFT JOIN jos_viewlevels AS ag ON ag.id = a.access LEFT JOIN jos_users AS ua ON ua.id = a.created_user_id LEFT JOIN jos_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC343μs4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `title` FROM `jos_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)136μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `jos_scheduler_tasks` AS `a` WHERE `a`.`state` = 1340μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?115μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?449μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy