Skip to main content

Our warm welcome begins on the sidewalk – before we even enter Farmacy, once a 1900s family feedstore, now a chill Restobar in Glens Falls, New York. A large garden cart stands off to one side, showcasing potted ferns in a deep Crayola green surrounded by several pots of colorful flowers. Attached to the building's exterior brick wall, which faces an alley, are tiered shelves carrying more of the same. 

Tables and chairs stand against the weathered masonry, offering privacy to folks who might want to eat outside in a quieter setting. In contrast, several others are arranged on the sidewalk just outside the restaurant's busy front door. Peeking inside, we spot the chef selection counter, where six chairs invite patrons to settle in, get comfy and enjoy a chance to chat with the chefs while they cook in the open-air kitchen. 

Wait - what? Learning we can interact with a chef while they're busy creating a meal for us sounds so cool - we're already planning when we can visit again. And we haven't even sat down yet! 

We're led to a table toward the back of the restaurant. It's near a window where natural light streams in. I think it's perfect – we'll watch the chef cook our meal, the bartenders create our drinks, and people-watch, all at the same time. 

When I look on Farmacy's website, I read their bartenders have over a decade of combined experience in the art of mixing spirits and combining flavors. I take a minute, then choose their craft cocktail named BRAAAIIINSSSS. I love gin, and the bartender mixes this with lite vermouth, curacao, and lemon after an absinthe rinse on my stemmed glass. It's refreshing and goes down easily. Susan nurses a creamy espresso martini, while Chris enjoys a coconut cream ale.   

We try the local broccolini salad adorned with pickled onion, cheddar cheese, and bacon. The flavors are fresh and light and have just the right amount of crunchy textures to complement each other. 

When I ask where the restaurant sources its food, owners A.J. and wife Christina explain how they like to work with farms that make unique, different, or simply 'grown-right' products. "We like to use products in their prime and try just enough manipulation to let the ingredients shine through." Says A.J. If you study their website, you'll see a list of the local farms they partner with to bring the very best foods to our tables. 

We tear pieces off the warm sourdough bread that comes next, spreading softened, burnt rosemary butter with a sprinkle of pink salt over the top. The butter is made on-site, and its character is a little sweet and salty in the same mouthful. 

OK; can we just talk about fine china for a minute? Every plate is different at Farmacy - which we find pretty charming. I love how each selection from the menu is presented on someone's grandma's dinner plate. No two dishes are the same. We wonder aloud who it might have belonged to. Did it adorn the table of the rich and famous? A dignitary? Some noble countrymen? Was it passed down and brought here from another country? "It's going to be hard eating from plain white dishes at other restaurants now," we kid with the general manager, Naomi, when she visits our table.  

"We have boxes and boxes of mismatched china here," she says. "People often give us odd pieces or whole sets when cleaning out a relative's home, or it might be a set they no longer use themselves. We love how they're so different. We feel it sets us apart – having all these little touches, you know?"

We do know – and we love it.

We decide to try a few different dishes, passing them around the table. The half-dozen pink moon oysters present nicely in a china bowl filled with pebbles and come with a dropper bottle of tomato basil mignonette. We've never seen this dropper bottle before. Naomi explains that it's a French term. She shows us how to squeeze a few drops on each oyster before we slurp down the delicacies. "The mignonette sauce really brings out the oyster's natural sweetness." 

The chef cooks our grilled hanger steak exactly how we like it – rare and so tender we don't even use the serrated knives set to the side of our plates. The meat is set atop a green chimichurri sauce, and we can easily taste the flavors of finely chopped parsley, minced garlic, olive oil, oregano, and red wine vinegar. The mashed potatoes remind me of gramma's – they still have little lumps! 

Years ago, before I started writing about food, I fell in love with the sauce on a burger at a fast-food hamburger joint in town. (Admit it, you've been there, done that!) Anyway, Farmacy offers an “elevated” version of that special sauce. Honestly, this house burger is the best I've tasted, and the sauce is – well, a much-nicer version of the one I discovered years ago! This burger is thick, juicy, a mouthful of texture and flavor, smothered in beer cheese, bacon, and pickled onion. The brioche bun is fresh and comes with crispy (not soggy) french fries. 

I ask how they fared during the pandemic. Christina is quick to answer. "We had a dedicated team and such a supportive community. We had opened the restaurant ten months before and celebrated our first anniversary during the pandemic." Their daughter had just been born. They were new parents and owners, navigating the world of COVID-19 that had blind-sighted all of us.

Man, I hear so many stories like this one. Who knew what was coming in the late months of 2019 and early months of 2020? "It was certainly scary and emotional for everyone." A.J. pipes in. "But our team and the community really stood up and supported us. They helped ensure we were still standing when all was said and done. We're very humbled by the outpouring of love we received. It's still so surreal."

Getting back to the good eats, we find out they not only offer dessert, but they also make their own ice cream! "We make ice cream just about every day here," Naomi shares. "We have three ice cream machines imported from Italy." When the three of us try a spoonful of molasses ice cream nestled beside their flourless chocolate torte set atop a generous smear of torched smokey meringue, we look at each other and sigh. The consensus is in; we've just died and gone to heaven.

The other dessert we try is a still-warm donut rolled in cinnamon sugar, with a scoop of peanut butter ice cream plopped in the center. Our first bites are ridiculously good. We all take another.

"This is so creamy!" we say at the same time.

Naomi laughs. "The texture comes from the machines and the precise temperature we store our ice cream. This way, it won't become too hard." When I ask about varieties, she tells us the entire team collaborates on flavors – and that guests of the Restobar even suggest some, writing requests on the back of their bill. Naomi grins, sharing how they offer a flight of ice cream – for serious lovers of the frozen dessert.  

I wonder where the couple sees the restaurant in, say, 3-5 years. Their answer is refreshing. "We hope to see the business exactly where it is right now. We don't want to grow any larger. We aim to keep focusing on fresh, local, seasonal, and constantly changing menus. We have built a team continually working on new ideas to share with our guests. We hope to add more profits to the business and make upgrades for our visitors' convenience, comfort, and enjoyment. At the end of the day, we love our charming historical space and look forward to calling it home for a long time."

As we say goodbye and turn to leave the restaurant, my eye catches a sign on the wall near the entrance. It reads, "Let food be thy medicine and medicine be thy food." Hippocrates wrote it.

It seems Farmacy lives it. 

8.188MBMemory Usage160msRequest Duration
Joomla! Version4.4.13
PHP Version8.3.20
Identityguest
Response200
Templateyootheme
Database
Server
mysql
Version
8.0.42
Collation
utf8mb3_unicode_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
array:3 [ "catid" => "10" "id" => "353" "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" => 1747196951 "last" => 1747196951...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (444.76KB) (4.88ms)
  • afterInitialise (1.95MB) (39.61ms)
  • afterRoute (357.2KB) (12.17ms)
  • beforeRenderComponent com_content (46.91KB) (2.09ms)
  • Before Access::preloadComponents (all components) (44.44KB) (1.56ms)
  • After Access::preloadComponents (all components) (113.48KB) (1.16ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (34μs)
  • After Access::preloadPermissions (com_content) (514.55KB) (1.39ms)
  • Before Access::getAssetRules (id:512 name:com_content.article.353) (18.65KB) (49μs)
  • After Access::getAssetRules (id:512 name:com_content.article.353) (7.38KB) (139μs)
  • afterRenderComponent com_content (1.76MB) (49.09ms)
  • afterDispatch (29.42KB) (1.43ms)
  • beforeRenderRawModule mod_menu () (408.83KB) (26.01ms)
  • afterRenderRawModule mod_menu () (145.83KB) (1.62ms)
  • beforeRenderModule mod_menu () (696B) (5μs)
  • afterRenderModule mod_menu () (3.73KB) (210μs)
  • beforeRenderRawModule mod_finder () (1.45KB) (13μs)
  • afterRenderRawModule mod_finder () (1.95MB) (7.56ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (2.82KB) (88μs)
  • beforeRenderRawModule mod_custom () (16B) (193μs)
  • afterRenderRawModule mod_custom () (318.69KB) (1.38ms)
  • beforeRenderModule mod_custom () (704B) (19μs)
  • afterRenderModule mod_custom () (3.27KB) (70μs)
  • beforeRenderRawModule mod_menu () (24B) (78μs)
  • afterRenderRawModule mod_menu () (552B) (450μs)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (2.76KB) (60μs)
  • beforeRenderRawModule mod_custom () (920B) (58μs)
  • afterRenderRawModule mod_custom () (1.03KB) (136μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (58μs)
  • beforeRenderRawModule mod_menu () (1.65KB) (138μs)
  • afterRenderRawModule mod_menu () (4.45KB) (426μs)
  • beforeRenderModule mod_menu () (696B) (3μs)
  • afterRenderModule mod_menu () (1.34KB) (70μs)
  • beforeRenderRawModule mod_finder () (96B) (7μs)
  • afterRenderRawModule mod_finder () (6.91KB) (633μs)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (1.34KB) (73μs)
  • beforeRenderRawModule mod_custom () (288B) (8μs)
  • afterRenderRawModule mod_custom () (912B) (129μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (1.23KB) (54μs)
  • beforeRenderRawModule mod_custom () (5.95KB) (151μs)
  • afterRenderRawModule mod_custom () (1008B) (120μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.77KB) (44μs)
  • beforeRenderRawModule mod_custom () (8B) (58μs)
  • afterRenderRawModule mod_custom () (1008B) (110μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (2.43KB) (58μs)
  • afterRender (246.8KB) (3.97ms)
  • 1 x afterRenderComponent com_content (1.76MB) (30.76%)
    49.09ms
    1 x afterInitialise (1.95MB) (24.82%)
    39.61ms
    1 x beforeRenderRawModule mod_menu () (408.83KB) (16.3%)
    26.01ms
    1 x afterRoute (357.2KB) (7.62%)
    12.17ms
    1 x afterRenderRawModule mod_finder () (1.95MB) (4.73%)
    7.56ms
    1 x afterLoad (444.76KB) (3.06%)
    4.88ms
    1 x afterRender (246.8KB) (2.49%)
    3.97ms
    1 x beforeRenderComponent com_content (46.91KB) (1.31%)
    2.09ms
    1 x afterRenderRawModule mod_menu () (145.83KB) (1.02%)
    1.62ms
    1 x Before Access::preloadComponents (all components) (44.44KB) (0.98%)
    1.56ms
    1 x afterDispatch (29.42KB) (0.89%)
    1.43ms
    1 x After Access::preloadPermissions (com_content) (514.55KB) (0.87%)
    1.39ms
    1 x afterRenderRawModule mod_custom () (318.69KB) (0.87%)
    1.38ms
    1 x After Access::preloadComponents (all components) (113.48KB) (0.73%)
    1.16ms
    1 x afterRenderRawModule mod_finder () (6.91KB) (0.4%)
    633μs
    1 x afterRenderRawModule mod_menu () (552B) (0.28%)
    450μs
    1 x afterRenderRawModule mod_menu () (4.45KB) (0.27%)
    426μs
    2 x afterRenderRawModule mod_custom () (1008B) (0.14%)
    230μs
    1 x afterRenderModule mod_menu () (3.73KB) (0.13%)
    210μs
    1 x beforeRenderRawModule mod_custom () (16B) (0.12%)
    193μs
    1 x beforeRenderRawModule mod_custom () (5.95KB) (0.09%)
    151μs
    1 x After Access::getAssetRules (id:512 name:com_content.article.353) (7.38KB) (0.09%)
    139μs
    1 x beforeRenderRawModule mod_menu () (1.65KB) (0.09%)
    138μs
    1 x afterRenderRawModule mod_custom () (1.03KB) (0.09%)
    136μs
    1 x afterRenderRawModule mod_custom () (912B) (0.08%)
    129μs
    2 x afterRenderModule mod_custom () (1.23KB) (0.07%)
    112μs
    1 x afterRenderModule mod_finder () (2.82KB) (0.06%)
    88μs
    1 x beforeRenderRawModule mod_menu () (24B) (0.05%)
    78μs
    1 x afterRenderModule mod_finder () (1.34KB) (0.05%)
    73μs
    1 x afterRenderModule mod_custom () (3.27KB) (0.04%)
    70μs
    1 x afterRenderModule mod_menu () (1.34KB) (0.04%)
    70μs
    1 x afterRenderModule mod_menu () (2.76KB) (0.04%)
    60μs
    1 x beforeRenderRawModule mod_custom () (920B) (0.04%)
    58μs
    1 x beforeRenderRawModule mod_custom () (8B) (0.04%)
    58μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.04%)
    58μs
    1 x Before Access::getAssetRules (id:512 name:com_content.article.353) (18.65KB) (0.03%)
    49μs
    1 x afterRenderModule mod_custom () (2.77KB) (0.03%)
    44μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.02%)
    34μs
    5 x beforeRenderModule mod_custom () (704B) (0.02%)
    28μs
    1 x beforeRenderRawModule mod_finder () (1.45KB) (0.01%)
    13μs
    3 x beforeRenderModule mod_menu () (696B) (0.01%)
    12μs
    2 x beforeRenderModule mod_finder () (704B) (0.01%)
    9μs
    1 x beforeRenderRawModule mod_custom () (288B) (0%)
    8μs
    1 x beforeRenderRawModule mod_finder () (96B) (0%)
    7μs
58 statements were executed, 5 of which were duplicates, 53 unique14.1ms910.23KB
  • SELECT @@SESSION.sql_mode;184μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?208μ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)331μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `jos_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1393μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`143μs656B/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` = :guest185μ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"129μ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"81μs1.13KB/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"72μs520B/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"73μ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"71μ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"75μ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"79μ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"169μ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"79μ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"69μs1.76KB/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"67μs520B/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"73μ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"72μ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"65μ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"65μ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"67μ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"70μ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"65μ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"169μ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"67μ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"70μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SHOW FULL COLUMNS FROM `jos_tagz_config`639μs1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_tagz_config` WHERE `name` = 'config'101μs592B/libraries/src/Table/Table.php:755Copy
  • SELECT id,template FROM jos_template_styles WHERE client_id=0 AND home=1163μs592B/administrator/components/com_widgetkit/widgetkit.php:28Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system'167μs536B/plugins/system/yooessentials/helper.php:153Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`m`.`link`,`m`.`type`,`m`.`level`,`m`.`language`,`m`.`browserNav`,`m`.`access`,`m`.`params`,`m`.`home`,`m`.`img`,`m`.`template_style_id`,`m`.`component_id`,`m`.`parent_id`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `jos_menu` AS `m` LEFT JOIN `jos_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`395μs22.17KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `jos_template_styles` AS `s` LEFT JOIN `jos_extensions` AS `e` ON `e`.`element` = `s`.`template` AND `e`.`type` = 'template' AND `e`.`client_id` = `s`.`client_id` WHERE `s`.`client_id` = 0 AND `e`.`enabled` = 1213μs848B/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 1107μs536B/plugins/system/yooessentials/modules/platform-joomla/src/Database.php:52Copy
  • SELECT * FROM `jos_languages` WHERE `published` = 1 ORDER BY `ordering` ASC176μs1.59KB/libraries/src/Language/LanguageHelper.php:142Copy
  • 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)452μs7.44KBParams/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` = 0515μs49.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`873μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '353'349μs48B/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)467μs62.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`294μ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)254μ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`253μ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 ASC361μ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 DESC986μs3.22KBParams/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`322μ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`850μs19.06KBParams/libraries/src/Cache/Controller/CallbackController.php:120Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 121 AND `component_type` = "menu"245μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 353 AND `component_type` = "content"117μs536B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `name`,`element` FROM `jos_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1432μ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)243μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1586μs688.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 ASC432μ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)217μ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` = 1209μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?113μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?284μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy