Jess Carlson’s Protection Spells for New Witches: A Guide to Banishing Negative Energy with Essential Spells and Rituals is one of those books that answers questions many beginners have when starting in the Craft. It is practical and leaves room for engagement by the reader.  It allows the Seeker who is unsure of where to start about the basics. The main title, Protection Spells for New Witches reminds readers of its purpose and primary function immediately.   The cover sets the tone with an combination cutout image of many tools used for protection: candles, satchels, sage bundles, a dropper and jar, plants, crystals, and an eye.  The variety echoes the purpose of using this comprehensive guide while being open to any thoughts that the new practitioner might come across. 

Carlson presents the act of understanding, finding, creating, and using protection spells in an organic manner, that mirrors how ordinary people learn. Carlson’s first recalled spell from childhood to guard against a sadly common occurrence (bullying) reminds the reader that many life situations may call spell work that is simple, yet effective. (p. ix) Carlson demonstrates the versatility of the same spell used as protection while in a car with someone else who was drinking.  Again, both are common scenarios to many people, including new witches who might not think of what to use when they first enter the Craft. 

This very comprehensive guide to spell work comes with clear instructions. While there are nine chapters, the author clearly sets the book up for those who are brand new by urging a read of the entire book from cover to cover.  More experienced practitioners are encouraged to jump to the chapters that interest the individual best. What I enjoyed most about this work is its accessibility to the average person. Materials that can be purchased in the local grocery store or online makes the workings of magic and of protection spells in particular an easier task for those who are just starting out.  

The cutout portions that appear throughout the book remind me of the Pennsylvania Dutch Hex signs I often saw in my childhood on barns and other buildings as a means of protection. The bright colors and unique shapes draw the reader’s eye to each section, thus emphasizing the role of a specific type of protection spell. 
Protection Spells for New Witches: A Guide to Banishing Negative Energy with Essential Spells and Rituals uses the first two chapters as an excellent overview for those who are new to the world of magic, why to listen to your gut, why magic is not a “guaranteed cure-all” (p. 1), and the need to use common sense in general.  Basic steps such as locking your doors as well as using protection spells for your home (p. 1) are good reminders that reflect what Carlson attempts to do in this book: take what you know in ordinary, mundane protection, and learn how to utilize magic at the right time, in the right way, and in the right place. 

Carlson’s teachings include a practical and necessary awareness of the role of ethics in a practitioner’s choices: the role of ethics in magical workings is a common emphasis for a reason. As a new practitioner or one who has done spell work for years, ethics are a guiding compass used by the individual to determine what kinds of spells and what boundaries the person will or will not use. Carlson’s reminder to “keep an open mind when reading and consider how you’ll apply ethics to your work” (p. 1) is beneficial to the reader at any stage of magical working.  

Carlson covers the basics of protection magic including what it is and what it is not, starting with an excellent definition of harm: “Harm can include anything that may cause mental, physical, or spiritual damage to us. Harm is anything that is not in alignment with our highest good. (p. 4) In reality, this definition of harm sets the tone for the rest of the book. In essence, a protection spell helps to keep the individual in alignment with their highest good by helping to deflect or reduce harm on a mental, physical, or spiritual level. This does not excuse the responsibility of the individual to maintain and use good ethical standards or mundane common sense, such as being aware of one’s surroundings, protecting valuables by locking car doors or entrances to one’s home.  By beginning with a clear definition of harm, Carlson reminds the reader what the stakes are when considering or using protection spells. For the new witch, this guidance is needed and helpful in shaping an individual’s start in witchcraft regardless of a particular tradition. By including ethics and protection, Carlson’s introduction works well with a variety of traditions. 

What I liked about this text is the straightforward manner in Carlson emphasizes proactive (charms, amulets, energetic boundaries – p. 4) and reactive (cleansing and banishing spells – p. 4). It is helpful to know which aspect one is able and willing to do in and what the limitations of these aspects of protection magic.  Carlson uses these areas to start a serious discussion on where you can find help using these spells such as with negative energy, psychic vampires, and creating a safe haven at home (pp. 6-7). For new practitioners, knowing what signs to observe to indicate when protection magic might be used is very helpful. 

The strong and early reminder that one needs permission before doing magic for others is a welcome one. To focus on the self-first and others second is primarily due to the aspect of consent. Working for and with yourself, you are giving permission to do acts that help yourself. A desire to help others without their knowing consent or permission, no matter how well intentioned creates a lack of free will on the other person’s part.   Carlson provides a summary at the end of each section in accessible and concise language. This assists the reader in absorbing the material quickly and fully. 

The second chapter looks at the doing of protection spells including a quick background on amulets, candle magic, charm bags, poppets, talismans.  Furthermore, Carlson addresses the use of an altar and the use of circle casting. (pp. 14-18). 

Overall, Carlson works from the inside out in terms of protection spells from their preparation starting with the basics concerning grounding, centering, and circle casting. What makes this third chapter sound is its emphasis the basics plus the tools of intention, will, and desire (p. 35) including defining each one. 

The chapter on “Protecting the Mind” is filled with practical spells. Carlson begins with a protection oil spell, followed by useful everyday spells for addressing negativity, quieting the mind, and several excellent mind protecting spells. These spells help with increased anxiety, tension, and trauma that is now common in everyday post-global pandemic. The “Protect Your Words” is a personal favorite as the need to ensure that “your words are not misconstrued or used against you” (p. 44). In a world where texts, emails, and social media posts are easily misunderstood, this is a practical and effective spell. 

Chapter Five, “Protecting the Body” covers an equally large set of practical spells for the body as Chapter Four does for the mind.  I found the armoring, shielding, protection bath, fatigue buster and cleansing illness spells to be especially useful when dealing with the stresses of everyday work life. Pleasant surprises included spells against sexual harassment, and protection on your life path to use with your shoes.  As promised at the start of the book, all ingredients are easily found in any grocery store or online. For those who live in remote areas, these protection spells are extremely effective. 

I appreciated the sensitivity Carlson demonstrates with Chapter Six, “Protecting Your Loved Ones” by first reminding readers about the introductory warning regarding ethics, then providing spells which address the dangers rather than the person (“Can’t Touch This Spell”- pp. 74-75), helping loved ones who are far away (“Bucket of Light”- pp. 76-77), the positive nature of healing (“Protection Poppet”- pp.78-79), separation anxiety, (“Separation Protection” – pp.80-81), and a variety of spells against bullying and providing protection for pets.  Each of these remains accessible and beneficial for even the most beginning practitioner, while providing options for more advanced practitioners. 

Chapter Seven, “Protecting Your Home” is by far the chapter that draws one’s eye due to its nature: the physical home where one expects to rest, relax, and feel a sense of safety and security often needs a bit of protection. Carlson reminds the reader to use common sense with everyday practices, such as locking one’s home, to contact local law enforcement if problems escalate, and if necessary, to consider moving to a new dwelling.  The spells for Black Salt, a House Blessing, a Witch Bottle, Four Corners Home Protection are excellent for anyone starting the path who wants to begin in the home.  I enjoyed the Reflective Home Protection as the size and types of mirrors used allow for variety in the spell usage. The mirrors also can be recharged, so this is a very practical spell. I found the Protection Wash spell and the Hells Bells Home Spell to be helpful practices.  I grew up in a home with bells on the exterior doors, so it was a delight to see a spell that used bells. 

Carlson expands in Chapter Eight with “Protecting Your Property” for a variety of items that fall into the category of possessions. Interesting spells include “Four Thieves Vinegar” and “Protecting Your Money” which does double duty including a focus on keeping your money coming back to you. For anyone who tends to impulse spend, this is a very effective spell to use. Other intriguing spells include “Mercury Retrograde Computer Protection Bag”, and recalling possessions when it is a deliberate act (“Draw Back a Stolen Item”- p. 124) or when it is not intentional (“Borrowed and Returned -p. 125).

The examination of protection spells for the new witch or practitioner expands outward with Chapter Nine: “Protecting Yourself While Traveling”. For any modern-day traveler, these spells are not only useful, but intriguing. The most effective is not a specific protection spell, but a necessity for any practitioner: “The Traveling Witch Protection Kit” – p. 140). Carlson covers the anxious air traveler with “Worry Beads for Air Travel” – p.141, those nervous on the road with “Map of Protection for Road Trips” – pp. 146-148, and my new favorite travel spell to use before leaving, “Peacefully Safe Travels” (pp.144-145).    

What makes this book so valuable is the acknowledgement of how learning about protection, ethics, while starting on the path as a new witch or practitioner is an absolute necessity. Carlson notes throughout the book critical points in the overall journey for those choosing to incorporate protection practices into their lives.  Carlson presents a work that fits the needs of the beginner and the advanced practitioner and lays out a reasonable argument to consider ethics, common sense, and creativity when using protection spell work. Carlson concludes with a brief, but good resource list and an index for readers.   

My only disappointment in this book was that I fully wanted to see more spells within Chapter Four, “Protecting Your Mind” as this was the closest chapter to emotions and the heart. I found many of Carlson’s practical suggestions, such as journaling and exploring when using “Nullifying the Mind” (pp. 40-41); however, that would be better in a separate book on the topic.

Overall, Carlson’s tone and practical approach leaves the door open for practitioners at all levels of experience to fully delve into this crucial topic. Protection Spells for New Witches is an excellent primer that engages the eyes and prompts the spirit to explore a variety of protection spells in different areas.  This is an excellent supplementary reading for any path or tradition that uses or emphasizes protection at any point in the learning process.  

Author: Jess Carlson
Rockridge Press, 2023
pp. 174, $14.95

32.576MBMemory Usage965msRequest Duration
Joomla! Version4.4.8
PHP Version8.3.21
Identityguest
Response200
Templatert_ambrosia
Database
Server
mysql
Version
10.6.22-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:49 [ "USER" => "facingnorth" "HOME" => "/home/facingnorth" "SCRIPT_NAME" => "/index.php"...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1747878042 "last" => 1747878042...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (458.66KB) (3.23ms)
  • afterInitialise (809.8KB) (17.09ms)
  • afterRoute (544.33KB) (10.41ms)
  • beforeRenderComponent com_content (33.84KB) (1000μs)
  • Before Access::preloadComponents (all components) (33.47KB) (786μs)
  • After Access::preloadComponents (all components) (107.34KB) (1.19ms)
  • Before Access::preloadPermissions (com_content) (1.57KB) (28μs)
  • After Access::preloadPermissions (com_content) (2MB) (8.17ms)
  • Before Access::getAssetRules (id:3735 name:com_content.article.2846) (66.65KB) (225μs)
  • After Access::getAssetRules (id:3735 name:com_content.article.2846) (8.72KB) (102μs)
  • afterRenderComponent com_content (308.85KB) (12.38ms)
  • afterDispatch (2.28KB) (126μs)
  • beforeRenderRawModule mod_finder (Search Module) (1.52MB) (20.98ms)
  • afterRenderRawModule mod_finder (Search Module) (278.92KB) (4.74ms)
  • beforeRenderModule mod_finder (Search Module) (720B) (9μs)
  • afterRenderModule mod_finder (Search Module) (1.28KB) (97μs)
  • afterRender (9.81MB) (883ms)
  • 1 x afterRender (9.81MB) (91.54%)
    882.97ms
    1 x beforeRenderRawModule mod_finder (Search Module) (1.52MB) (2.17%)
    20.98ms
    1 x afterInitialise (809.8KB) (1.77%)
    17.09ms
    1 x afterRenderComponent com_content (308.85KB) (1.28%)
    12.38ms
    1 x afterRoute (544.33KB) (1.08%)
    10.41ms
    1 x After Access::preloadPermissions (com_content) (2MB) (0.85%)
    8.17ms
    1 x afterRenderRawModule mod_finder (Search Module) (278.92KB) (0.49%)
    4.74ms
    1 x afterLoad (458.66KB) (0.33%)
    3.23ms
    1 x After Access::preloadComponents (all components) (107.34KB) (0.12%)
    1.19ms
    1 x beforeRenderComponent com_content (33.84KB) (0.1%)
    1000μs
    1 x Before Access::preloadComponents (all components) (33.47KB) (0.08%)
    786μs
    1 x Before Access::getAssetRules (id:3735 name:com_content.article.2846) (66.65KB) (0.02%)
    225μs
    1 x afterDispatch (2.28KB) (0.01%)
    126μs
    1 x After Access::getAssetRules (id:3735 name:com_content.article.2846) (8.72KB) (0.01%)
    102μs
    1 x afterRenderModule mod_finder (Search Module) (1.28KB) (0.01%)
    97μs
    1 x Before Access::preloadPermissions (com_content) (1.57KB) (0%)
    28μs
    1 x beforeRenderModule mod_finder (Search Module) (720B) (0%)
    9μs
32 statements were executed, 3 of which were duplicates, 29 unique127ms396.05KB
  • SELECT @@SESSION.sql_mode;107μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `facv2_session` WHERE `session_id` = ?141μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `facv2_session` WHERE `session_id` = :session_id LIMIT 1137μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `facv2_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)2.5ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `facv2_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1321μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `facv2_viewlevels`101μs656B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `facv2_usergroups` AS `a` LEFT JOIN `facv2_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest137μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `facv2_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`591μs3.48KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • 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 `facv2_menu` AS `m` LEFT JOIN `facv2_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`876μs133.17KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • 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 `facv2_categories` AS `s` INNER JOIN `facv2_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`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`463μs3.88KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id` FROM `facv2_content` WHERE `alias` = :alias AND `catid` = :catid214μs1.34KBParams/components/com_content/src/Service/Router.php:263Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `facv2_template_styles` AS `s` LEFT JOIN `facv2_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` = 1236μs880B/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT s.id, s.template, s.home, s.title AS long_title, s.params FROM facv2_template_styles AS s WHERE s.client_id = 0 AND s.template = 'rt_ambrosia' ORDER BY s.id172μs800B/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `facv2_languages` WHERE `published` = 1 ORDER BY `ordering` ASC149μs1.59KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `facv2_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)816μs7.44KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `facv2_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 03.78ms181.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `facv2_content`777μs3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `facv2_content` SET `hits` = (`hits` + 1) WHERE `id` = '2846'1.24ms48B/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 `facv2_content` AS `a` INNER JOIN `facv2_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `facv2_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `facv2_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `facv2_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `facv2_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)380μs22.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 `facv2_categories` AS `s` INNER JOIN `facv2_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`478μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `facv2_contentitem_tag_map` AS `m` INNER JOIN `facv2_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)230μ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 `facv2_categories` AS `s` INNER JOIN `facv2_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`562μs3.92KBParams/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 facv2_fields AS a LEFT JOIN `facv2_languages` AS l ON l.lang_code = a.language LEFT JOIN facv2_users AS uc ON uc.id=a.checked_out LEFT JOIN facv2_viewlevels AS ag ON ag.id = a.access LEFT JOIN facv2_users AS ua ON ua.id = a.created_user_id LEFT JOIN facv2_fields_groups AS g ON g.id = a.group_id LEFT JOIN `facv2_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,:preparedArray3)) AND `a`.`access` IN (:preparedArray4,:preparedArray5)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7)) 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 ASC901μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • 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 `facv2_categories` AS `s` INNER JOIN `facv2_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`408μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `a`.`menutype`,`a`.`title` FROM `facv2_menu_types` AS `a` WHERE `a`.`client_id` = 0117μs608B/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:138Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM facv2_menu AS m WHERE m.menutype = 'mainmenu' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft563μs1.98KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `facv2_modules` AS `m` LEFT JOIN `facv2_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `facv2_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`634μs1.83KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `name`,`element` FROM `facv2_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1387μs656B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `facv2_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)213μ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 `facv2_scheduler_tasks` AS `a` WHERE `a`.`state` = 1278μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `facv2_session` WHERE `session_id` = ?187μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `facv2_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?109ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy