Skip to main content

Written By Gianna Pennacchia, Nutrition & Resource Educator
at Cornell Cooperative Extension Saratoga County

[From the 2025 Home & Garden Magazine]

Springtime brings rejuvenation and ignites creativity in home cooks and bakers alike.

What better time than to explore baking with edible flowers and trying out delicious new botanical recipes!

If you have ever thought about cooking, baking, or infusing liquids such as honey with edible flowers to add a unique flavor and elevation to your culinary dishes… continue reading!

Many wonder, where can edible flowers be sourced? Whether interested in an edible flower salad, candied petals, infused honeys, or decorating a cake with blooms, sourcing edible flowers is easier than one might think!

To begin, always find flowers which are labeled “safe for human consumption,” as not all flowers can be eaten. They must be grown specifically for human consumption or can cause severe illness. Most store-bought flowers are not safe for consumption. The type of flowers used for food should never come in 

contact with pesticides and other chemicals. A simple rule to follow is that the best edible flowers are ones you have grown organically in your own garden. To account for outdoor climates, try an indoor garden system, to grow edible varieties such as lavender and pansies.

A favorite way to grow flowers indoors is utilizing a smart system such as “Click and Grow,” which allows you to grow anything you desire using experimental pods. Common edible flower options for indoors include nasturtiums, pansies, and violas. This system provides automatic watering, perfect lighting, and an app that predicts when your plants may bloom. Ensure your blooms are placed in a bright, indirect light source. Other places to buy fresh flowers for culinary decorating and creations include organic farmers, farmers' markets, and local grocery store during spring, specifically in containers in the produce section labeled “safe for consumption.” Certain online sites are dedicated to selling organic - fresh, dried or pressed flowers - for consumption. Look for USDA certified, organic farms that take pride in growing edible flowers without the use of pesticides or fungicides.

In addition, certain fruit trees produce flowers before they grow fruit, such as apple and citrus blossoms. Herb flowers are another example where petals can be added to certain dishes. Use edible flowers sparingly to avoid digestive disruptions. Be mindful of safety tips; never harvest flowers growing near a roadside, chemically treated lawns, or areas with lots of animals.

Common edible flowers include cornflower, hibiscus, honeysuckle, magnolia, and pansy. Be sure to properly clean your edible flowers by rinsing in a strainer and draining on absorbent paper. To extend shelf life preserve your edible flowers in a sealed container in the refrigerator for between three to seven days. You can also freeze your edible flowers in ice cube trays, and infuse them into honey, milk, and olive oil.

Aside from using fresh edible flowers, you also have the option to use dried flowers which have an extended shelf life and can be incorporated in cake batters, honey, and syrup. Common varieties include lavender, rose buds, and calendula. The possibilities are endless!

Lavender Banana Bread with Cream Cheese Icing

Ingredients

Lavender Banana Bread:

  • 1 1/2 cups all-purpose flour
  • 1 1/4 teaspoons baking soda
  • 1 teaspoon table salt
  • 2 1/2 cups mashed very ripe banana
    (about 5 bananas)
  • 1 cup packed dark brown sugar
  • 2/3 cup butter, melted and cooled
  • 2 large eggs
  • 2 tablespoons dried lavender buds –
    FGO Certified Organic Dried Lavender Flowers,
    Extra Grade Dried Buds (Food grade, culinary,
    herbal supplement.
  • 2 tablespoons granulated sugar

Cream Cheese Icing:

  • 1/2 cup butter softened (1 stick)
  • 8 oz cream cheese (one softened brick)
  • 1 teaspoon vanilla extract
  • 1/4 teaspoon salt
  • 4 1/2 cups powdered sugar

Instructions

Lavender Banana Bread:

1. Adjust oven rack to middle position and heat oven to 350 degrees Prepare an 8 by 4 inch loaf pan with parchment paper and cooking spray

2. Melt your butter while you create a lavender sugar by grinding your dried lavender buds together with your granulated sugar, brown sugar, and vanilla extract. You can do this in small batches in a mortar and pestle or all at once in a food processor or blender. Set aside.

3. Whisk flour, baking soda, and salt together in a small bowl.

4. Mash bananas in a large bowl with a fork or potato masher. Add in your lavender sugar, cooled melted butter and eggs and mix until thoroughly combined.

5. Transfer the batter to the prepared pan.

6. Bake for one hour and 10 minutes, or until a toothpick inserted in the center comes out clean. I like to turn mine at the 45-minute mark.

7. Let bread cool in pan on wire rack for 30 minutes.

8. Once cooled, remove from loaf pan and prepare your icing. (optional)

Cream Cheese Icing:

9. Combine butter and cream cheese in the bowl of a stand mixer (or in a large bowl if you’re using an electric mixer) and beat until creamy.

10. Add vanilla extract and salt and stir well to combine.

11. Slowly add powdered sugar and mix with your mixer setting turned on low until completely combined.

12. Use an icing spatula to frost your banana bread with the cream cheese icing and serve immediately. Also good served chilled, right from the fridge (within five days).

Notes

  • Store in the fridge covered for up to five days.
  • Un-iced cooled lavender bread can be wrapped tightly in plastic wrap and stored at room temperature for up to 5 days or frozen up to 6 months. If you want to freeze, make icing and freeze separately. Do not add icing before freezing, and add it once thawed.
  • Use very ripe, heavily speckled bananas in this recipe.
  • If you use a 9-by-5-inch loaf pan, check for doneness at the one-hour mark.

Nutrition

Calories: 285cal | Carbohydrates: 31g | Protein: 2g Fat: 9g | Monounsaturated Fat: 2g | Trans Fat: 0.4g Potassium: 33mg Fiber: 0.4g | Sugar: 30g | Vitamin A: 327IU Vitamin C: 1mg Calcium: 6mg | Iron: 1mg

8.013MBMemory Usage113msRequest 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" => "9" "id" => "858" "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" => 1751810853 "last" => 1751810853...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (444.69KB) (2.75ms)
  • afterInitialise (1.96MB) (26.45ms)
  • afterRoute (375.95KB) (4.79ms)
  • beforeRenderComponent com_content (48.96KB) (906μs)
  • Before Access::preloadComponents (all components) (47.72KB) (1.61ms)
  • After Access::preloadComponents (all components) (116.7KB) (1.56ms)
  • Before Access::preloadPermissions (com_content) (1.63KB) (12μs)
  • After Access::preloadPermissions (com_content) (527.41KB) (1.7ms)
  • Before Access::getAssetRules (id:1033 name:com_content.article.858) (18.65KB) (25μs)
  • After Access::getAssetRules (id:1033 name:com_content.article.858) (7.38KB) (91μs)
  • afterRenderComponent com_content (1.63MB) (42.36ms)
  • afterDispatch (29.42KB) (1.09ms)
  • beforeRenderRawModule mod_finder () (388KB) (11.22ms)
  • afterRenderRawModule mod_finder () (1.95MB) (8.03ms)
  • beforeRenderModule mod_finder () (704B) (5μs)
  • afterRenderModule mod_finder () (1.44KB) (180μs)
  • beforeRenderRawModule mod_menu () (1.66KB) (203μs)
  • afterRenderRawModule mod_menu () (56.48KB) (1.2ms)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (3.63KB) (123μs)
  • beforeRenderRawModule mod_custom () (920B) (66μs)
  • afterRenderRawModule mod_custom () (319.76KB) (1.09ms)
  • beforeRenderModule mod_custom () (704B) (4μs)
  • afterRenderModule mod_custom () (3.15KB) (58μs)
  • beforeRenderRawModule mod_menu () (24B) (75μs)
  • afterRenderRawModule mod_menu () (552B) (541μs)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (2.76KB) (95μs)
  • beforeRenderRawModule mod_custom () (920B) (92μs)
  • afterRenderRawModule mod_custom () (1.03KB) (154μs)
  • beforeRenderModule mod_custom () (704B) (2μs)
  • afterRenderModule mod_custom () (1.23KB) (65μs)
  • beforeRenderRawModule mod_menu () (1.8KB) (87μs)
  • afterRenderRawModule mod_menu () (4.45KB) (435μs)
  • beforeRenderModule mod_menu () (696B) (4μs)
  • afterRenderModule mod_menu () (1.34KB) (76μs)
  • beforeRenderRawModule mod_finder () (96B) (9μs)
  • afterRenderRawModule mod_finder () (7.28KB) (574μs)
  • beforeRenderModule mod_finder () (704B) (4μs)
  • afterRenderModule mod_finder () (1.34KB) (80μs)
  • beforeRenderRawModule mod_custom () (288B) (15μs)
  • afterRenderRawModule mod_custom () (912B) (130μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (1.23KB) (60μs)
  • beforeRenderRawModule mod_custom () (4.23KB) (151μs)
  • afterRenderRawModule mod_custom () (1008B) (137μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.77KB) (46μs)
  • beforeRenderRawModule mod_custom () (472B) (59μs)
  • afterRenderRawModule mod_custom () (1008B) (111μs)
  • beforeRenderModule mod_custom () (704B) (3μs)
  • afterRenderModule mod_custom () (2.43KB) (44μs)
  • afterRender (298.95KB) (3.18ms)
  • 1 x afterRenderComponent com_content (1.63MB) (37.48%)
    42.36ms
    1 x afterInitialise (1.96MB) (23.4%)
    26.45ms
    1 x beforeRenderRawModule mod_finder () (388KB) (9.92%)
    11.22ms
    1 x afterRenderRawModule mod_finder () (1.95MB) (7.11%)
    8.03ms
    1 x afterRoute (375.95KB) (4.24%)
    4.79ms
    1 x afterRender (298.95KB) (2.81%)
    3.18ms
    1 x afterLoad (444.69KB) (2.44%)
    2.75ms
    1 x After Access::preloadPermissions (com_content) (527.41KB) (1.5%)
    1.70ms
    1 x Before Access::preloadComponents (all components) (47.72KB) (1.42%)
    1.61ms
    1 x After Access::preloadComponents (all components) (116.7KB) (1.38%)
    1.56ms
    1 x afterRenderRawModule mod_menu () (56.48KB) (1.06%)
    1.20ms
    1 x afterDispatch (29.42KB) (0.97%)
    1.09ms
    1 x afterRenderRawModule mod_custom () (319.76KB) (0.96%)
    1.09ms
    1 x beforeRenderComponent com_content (48.96KB) (0.8%)
    906μs
    1 x afterRenderRawModule mod_finder () (7.28KB) (0.51%)
    574μs
    1 x afterRenderRawModule mod_menu () (552B) (0.48%)
    541μs
    1 x afterRenderRawModule mod_menu () (4.45KB) (0.38%)
    435μs
    2 x afterRenderRawModule mod_custom () (1008B) (0.22%)
    248μs
    1 x beforeRenderRawModule mod_menu () (1.66KB) (0.18%)
    203μs
    1 x afterRenderModule mod_finder () (1.44KB) (0.16%)
    180μs
    2 x beforeRenderRawModule mod_custom () (920B) (0.14%)
    158μs
    1 x afterRenderRawModule mod_custom () (1.03KB) (0.14%)
    154μs
    1 x beforeRenderRawModule mod_custom () (4.23KB) (0.13%)
    151μs
    1 x afterRenderRawModule mod_custom () (912B) (0.11%)
    130μs
    2 x afterRenderModule mod_custom () (1.23KB) (0.11%)
    125μs
    1 x afterRenderModule mod_menu () (3.63KB) (0.11%)
    123μs
    1 x afterRenderModule mod_menu () (2.76KB) (0.08%)
    95μs
    1 x After Access::getAssetRules (id:1033 name:com_content.article.858) (7.38KB) (0.08%)
    91μs
    1 x beforeRenderRawModule mod_menu () (1.8KB) (0.08%)
    87μs
    1 x afterRenderModule mod_finder () (1.34KB) (0.07%)
    80μs
    1 x afterRenderModule mod_menu () (1.34KB) (0.07%)
    76μs
    1 x beforeRenderRawModule mod_menu () (24B) (0.07%)
    75μs
    1 x beforeRenderRawModule mod_custom () (472B) (0.05%)
    59μs
    1 x afterRenderModule mod_custom () (3.15KB) (0.05%)
    58μs
    1 x afterRenderModule mod_custom () (2.77KB) (0.04%)
    46μs
    1 x afterRenderModule mod_custom () (2.43KB) (0.04%)
    44μs
    1 x Before Access::getAssetRules (id:1033 name:com_content.article.858) (18.65KB) (0.02%)
    25μs
    5 x beforeRenderModule mod_custom () (704B) (0.01%)
    15μs
    1 x beforeRenderRawModule mod_custom () (288B) (0.01%)
    15μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.01%)
    12μs
    3 x beforeRenderModule mod_menu () (696B) (0.01%)
    12μs
    1 x beforeRenderRawModule mod_finder () (96B) (0.01%)
    9μs
    2 x beforeRenderModule mod_finder () (704B) (0.01%)
    9μs
54 statements were executed, 5 of which were duplicates, 49 unique23.8ms905.33KB
  • SELECT @@SESSION.sql_mode;76μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `jos_session` WHERE `session_id` = ?325μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = :session_id LIMIT 180μ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)531μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `jos_viewlevels`284μ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` = :guest378μ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"424μ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"66μ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"55μ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"62μ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"68μ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"66μ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"191μ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"65μ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"60μ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"65μ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"61μ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"58μ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"55μ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"75μ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"56μ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"56μ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"51μ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"61μ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"54μ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"54μ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"57μs520B/administrator/components/com_tagz/helpers/tagz.php:890Copy
  • SHOW FULL COLUMNS FROM `jos_tagz_config`988μs1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `jos_tagz_config` WHERE `name` = 'config'82μs592B/libraries/src/Table/Table.php:755Copy
  • SELECT id,template FROM jos_template_styles WHERE client_id=0 AND home=1367μs592B/administrator/components/com_widgetkit/widgetkit.php:28Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system'195μs536B/plugins/system/yooessentials/helper.php:153Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yooessentials' AND folder = 'system' LIMIT 198μ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)975μs9.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` = 0913μs49.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `jos_content`899μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `jos_content` SET `hits` = (`hits` + 1) WHERE `id` = '858'695μ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)818μ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`496μ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)470μ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`251μ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 ASC578μ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 DESC5.97ms21.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`280μ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.53ms19.06KBParams/libraries/src/Cache/Controller/CallbackController.php:120Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 122 AND `component_type` = "menu"841μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `params` FROM `jos_tagz` WHERE `component_id` = 858 AND `component_type` = "content"150μs520B/plugins/system/tagz/tagz.php:650Copy
  • SELECT `name`,`element` FROM `jos_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1244μ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)454μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT custom_data FROM jos_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 11.92ms688.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 ASC318μ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)138μ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` = 1277μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `jos_session` WHERE `session_id` = ?90μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `jos_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?325μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy