Bootstrap

Dry Eye Disease affects more than 5 million people in the United States, with 3.3 million being women and most of those being age 50 or over. And as people live longer, dry eye will continue to be a growing problem.

Although treatment options for dry eyes have improved recently, one of the most effective treatments is avoidance of dry eye triggers.

For some that might mean protecting your eyes from environmental triggers. To do that experts recommend using a humidifier in your home, especially if you have forced hot-air heat; wearing sunglasses when outside to help protect your eyes from the sun and wind that may make your tears evaporate faster; or being sure to direct any fans  - such as the air vents in your car - from blowing directly on your face. For others, it may mean avoiding medications that can cause dry eyes.

There is one other trigger that may need to be avoided that doesn’t get as much notice: the potentially harmful ingredients in cosmetics.

Cosmetics do not need to prove that they are “safe and effective” like drugs do. The FDA states that cosmetics are supposed to be tested for safety but there is no requirement that companies share their safety data with the FDA. There are also no specific definition requirements for labeling cosmetics as “hypoallergenic,” “dermatologist tested,” “ophthalmologist tested,” “sensitive formula” or the like, making most of those labels more marketing than science.

Things to watch out for in your cosmetics if you have dry eye include:

Preservatives

Preservatives are important to prevent the cosmetics from becoming contaminated but many are known to exacerbate dry eye. Common preservatives in cosmetics that could be adding to your dry eye problems (Periman and O’Dell, Ophthalmology Management August 2016) are: BAK (Benzalkonium chloride); Formaldehyde-donating (yes, Formaldehyde!) preservatives (often listed as DMDM-hydantoin, quaternium-15, imidazolidinyl urea, diazolidinyl urea and 2-bromo-2-nitropropane-1,3-diol); parabens; and Phenoxyethanol.  All of these preservatives in sufficient quantities can cause ocular irritation or inhibit the function of the Meibomian Glands that produce mucous that coats your tear film and keeps it from evaporating too quickly.

Alcohol

Alcohol is used in cosmetics mostly to speed the drying time but the alcohol can also dry the surface of the eye.

Waxes

Waxes can block the opening of the Meibomian Glands along the eyelid margin. If these glands are blocked they will not be able to supply the mucous and lipids necessary to the tear film to prevent it from drying too quickly. If you have trouble with dry eye it would be advisable not to apply eye liner behind the eyelashes along the lid edge where the Meibomian gland openings are.

Anti-aging products

While these may be safe and effective for the skin of the face they should not be used around the eyes. Most of these products contain some form of Retin A. These products have been shown to be toxic to the Meibomian glands and could be contributing to your dry eyes.

These components of cosmetics do not adversely affect everyone. However, if you suffer from dry eye and are not effectively able to keep your eye comfortable and your vision clear, you should investigate your cosmetics as a potential contributor to your problem.

Article contributed by Dr. Brian Wnorowski, M.D.

This blog provides general information and discussion about eye health and related subjects. The words and other content provided in this blog, and in any linked materials, are not intended and should not be construed as medical advice. If the reader or any other person has a medical concern, he or she should consult with an appropriately licensed physician. The content of this blog cannot be reproduced or duplicated without the express written consent of Eye IQ.

Brands We Carry

Eyewear to suit every style and need.

Our diverse range of brands ensures that you'll find the perfect eyewear.

Interactive Video Player Interactive Video Player Interactive Video Player
Bootstrap Themes

Educational Video Library

Our comprehensive video library encompasses an extensive array of topics related to eye health, including detailed explanations of various vision conditions, thorough overviews of optical procedures, and informative guides on routine eye examinations.

link

Lenses & Coatings

When it comes to vision care products, they are not all created equally! Across the eye care industry, there is a large variance in quality and craftsmanship. We take pride in using a wide range of top-quality materials with great product support to provide you with excellent eye care products.

Latest News & Blog Posts

9.594MBMemory Usage386msRequest Duration
Joomla! Version4.4.9
PHP Version8.1.32
Identityguest
Response200
Templateeyemotion
Database
Server
mysql
Version
10.6.20-MariaDB-cll-lve-log
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:69 [ "PATH" => "/usr/local/bin:/usr/bin:/bin" "TEMP" => "/tmp" "TMP" => "/tmp" "TMPDIR...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1748116634 "last" => 1748116634...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
com_rsfirewall
array:1 [ "geoip" => array:1 [ "3.134.109.116" => "US" ] ]
  • afterLoad (861.85KB) (64.18ms)
  • afterInitialise (2.51MB) (136ms)
  • afterRoute (488.56KB) (34.02ms)
  • beforeRenderComponent com_content (197.34KB) (18.82ms)
  • Before Access::preloadComponents (all components) (119.59KB) (4.59ms)
  • After Access::preloadComponents (all components) (121.91KB) (1.45ms)
  • Before Access::preloadPermissions (com_content) (4.04KB) (21μs)
  • After Access::preloadPermissions (com_content) (215.14KB) (1.73ms)
  • Before Access::getAssetRules (id:758 name:com_content.article.455) (18.8KB) (45μs)
  • After Access::getAssetRules (id:758 name:com_content.article.455) (9.59KB) (813μs)
  • afterRenderComponent com_content (546.84KB) (45.01ms)
  • afterDispatch (2.34KB) (272μs)
  • beforeRenderRawModule mod_custom (footer columns) (539.96KB) (45ms)
  • afterRenderRawModule mod_custom (footer columns) (70.14KB) (2.02ms)
  • beforeRenderModule mod_custom (footer columns) (720B) (9μs)
  • afterRenderModule mod_custom (footer columns) (6.67KB) (438μs)
  • beforeRenderRawModule mod_custom (map grom google) (64B) (109μs)
  • afterRenderRawModule mod_custom (map grom google) (2.17KB) (69μs)
  • beforeRenderModule mod_custom (map grom google) (720B) (6μs)
  • afterRenderModule mod_custom (map grom google) (3.9KB) (173μs)
  • beforeRenderRawModule mod_articles_news (Latest News & Blog Posts) (2.5KB) (82μs)
  • afterRenderRawModule mod_articles_news (Latest News & Blog Posts) (44.32KB) (12.29ms)
  • beforeRenderModule mod_articles_news (Latest News & Blog Posts) (720B) (10μs)
  • afterRenderModule mod_articles_news (Latest News & Blog Posts) (4.93KB) (97μs)
  • beforeRenderRawModule mod_custom (Lenses and Coatings Hero) (3.08KB) (79μs)
  • afterRenderRawModule mod_custom (Lenses and Coatings Hero) (960B) (64μs)
  • beforeRenderModule mod_custom (Lenses and Coatings Hero) (736B) (7μs)
  • afterRenderModule mod_custom (Lenses and Coatings Hero) (3.16KB) (102μs)
  • beforeRenderRawModule mod_custom (Educational Videos) (64B) (73μs)
  • afterRenderRawModule mod_custom (Educational Videos) (944B) (62μs)
  • beforeRenderModule mod_custom (Educational Videos) (720B) (7μs)
  • afterRenderModule mod_custom (Educational Videos) (3.41KB) (82μs)
  • beforeRenderRawModule mod_custom (Services We Provide (or three videos)) (80B) (72μs)
  • afterRenderRawModule mod_custom (Services We Provide (or three videos)) (3.44KB) (63μs)
  • beforeRenderModule mod_custom (Services We Provide (or three videos)) (736B) (7μs)
  • afterRenderModule mod_custom (Services We Provide (or three videos)) (9.93KB) (83μs)
  • beforeRenderRawModule mod_custom (Phone and Social Banner) (2.95KB) (277μs)
  • afterRenderRawModule mod_custom (Phone and Social Banner) (960B) (61μs)
  • beforeRenderModule mod_custom (Phone and Social Banner) (720B) (7μs)
  • afterRenderModule mod_custom (Phone and Social Banner) (3.99KB) (397μs)
  • beforeRenderRawModule mod_menu (Main Menu) (1.27KB) (122μs)
  • afterRenderRawModule mod_menu (Main Menu) (246.06KB) (5.97ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (8μs)
  • afterRenderModule mod_menu (Main Menu) (11.57KB) (325μs)
  • beforeRenderRawModule mod_custom (Phone and Social Top Bar) (2.03KB) (76μs)
  • afterRenderRawModule mod_custom (Phone and Social Top Bar) (960B) (64μs)
  • beforeRenderModule mod_custom (Phone and Social Top Bar) (736B) (7μs)
  • afterRenderModule mod_custom (Phone and Social Top Bar) (2.79KB) (75μs)
  • beforeRenderRawModule mod_custom (svg sprites) (1.3KB) (91μs)
  • afterRenderRawModule mod_custom (svg sprites) (944B) (67μs)
  • beforeRenderModule mod_custom (svg sprites) (720B) (7μs)
  • afterRenderModule mod_custom (svg sprites) (13.91KB) (81μs)
  • afterRender (184.55KB) (8.9ms)
  • 1 x afterInitialise (2.51MB) (35.29%)
    136.10ms
    1 x afterLoad (861.85KB) (16.64%)
    64.18ms
    1 x afterRenderComponent com_content (546.84KB) (11.67%)
    45.01ms
    1 x beforeRenderRawModule mod_custom (footer columns) (539.96KB) (11.67%)
    45.00ms
    1 x afterRoute (488.56KB) (8.82%)
    34.02ms
    1 x beforeRenderComponent com_content (197.34KB) (4.88%)
    18.82ms
    1 x afterRenderRawModule mod_articles_news (Latest News & Blog Posts) (44.32KB) (3.19%)
    12.29ms
    1 x afterRender (184.55KB) (2.31%)
    8.90ms
    1 x afterRenderRawModule mod_menu (Main Menu) (246.06KB) (1.55%)
    5.97ms
    1 x Before Access::preloadComponents (all components) (119.59KB) (1.19%)
    4.59ms
    1 x afterRenderRawModule mod_custom (footer columns) (70.14KB) (0.52%)
    2.02ms
    1 x After Access::preloadPermissions (com_content) (215.14KB) (0.45%)
    1.73ms
    1 x After Access::preloadComponents (all components) (121.91KB) (0.38%)
    1.45ms
    1 x After Access::getAssetRules (id:758 name:com_content.article.455) (9.59KB) (0.21%)
    813μs
    1 x afterRenderModule mod_custom (footer columns) (6.67KB) (0.11%)
    438μs
    1 x afterRenderModule mod_custom (Phone and Social Banner) (3.99KB) (0.1%)
    397μs
    1 x afterRenderModule mod_menu (Main Menu) (11.57KB) (0.08%)
    325μs
    1 x beforeRenderRawModule mod_custom (Phone and Social Banner) (2.95KB) (0.07%)
    277μs
    1 x afterDispatch (2.34KB) (0.07%)
    272μs
    1 x afterRenderModule mod_custom (map grom google) (3.9KB) (0.04%)
    173μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (1.27KB) (0.03%)
    122μs
    1 x beforeRenderRawModule mod_custom (map grom google) (64B) (0.03%)
    109μs
    1 x afterRenderModule mod_custom (Lenses and Coatings Hero) (3.16KB) (0.03%)
    102μs
    1 x afterRenderModule mod_articles_news (Latest News & Blog Posts) (4.93KB) (0.03%)
    97μs
    1 x beforeRenderRawModule mod_custom (svg sprites) (1.3KB) (0.02%)
    91μs
    1 x afterRenderModule mod_custom (Services We Provide (or three videos)) (9.93KB) (0.02%)
    83μs
    1 x beforeRenderRawModule mod_articles_news (Latest News & Blog Posts) (2.5KB) (0.02%)
    82μs
    1 x afterRenderModule mod_custom (Educational Videos) (3.41KB) (0.02%)
    82μs
    1 x afterRenderModule mod_custom (svg sprites) (13.91KB) (0.02%)
    81μs
    1 x beforeRenderRawModule mod_custom (Lenses and Coatings Hero) (3.08KB) (0.02%)
    79μs
    1 x beforeRenderRawModule mod_custom (Phone and Social Top Bar) (2.03KB) (0.02%)
    76μs
    1 x afterRenderModule mod_custom (Phone and Social Top Bar) (2.79KB) (0.02%)
    75μs
    1 x beforeRenderRawModule mod_custom (Educational Videos) (64B) (0.02%)
    73μs
    1 x beforeRenderRawModule mod_custom (Services We Provide (or three videos)) (80B) (0.02%)
    72μs
    1 x afterRenderRawModule mod_custom (map grom google) (2.17KB) (0.02%)
    69μs
    1 x afterRenderRawModule mod_custom (svg sprites) (944B) (0.02%)
    67μs
    1 x afterRenderRawModule mod_custom (Lenses and Coatings Hero) (960B) (0.02%)
    64μs
    1 x afterRenderRawModule mod_custom (Phone and Social Top Bar) (960B) (0.02%)
    64μs
    1 x afterRenderRawModule mod_custom (Services We Provide (or three videos)) (3.44KB) (0.02%)
    63μs
    1 x afterRenderRawModule mod_custom (Educational Videos) (944B) (0.02%)
    62μs
    1 x afterRenderRawModule mod_custom (Phone and Social Banner) (960B) (0.02%)
    61μs
    1 x Before Access::getAssetRules (id:758 name:com_content.article.455) (18.8KB) (0.01%)
    45μs
    1 x Before Access::preloadPermissions (com_content) (4.04KB) (0.01%)
    21μs
    1 x beforeRenderModule mod_articles_news (Latest News & Blog Posts) (720B) (0%)
    10μs
    1 x beforeRenderModule mod_custom (footer columns) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
    8μs
    1 x beforeRenderModule mod_custom (Educational Videos) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_custom (svg sprites) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_custom (Lenses and Coatings Hero) (736B) (0%)
    7μs
    1 x beforeRenderModule mod_custom (Services We Provide (or three videos)) (736B) (0%)
    7μs
    1 x beforeRenderModule mod_custom (Phone and Social Banner) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_custom (Phone and Social Top Bar) (736B) (0%)
    7μs
    1 x beforeRenderModule mod_custom (map grom google) (720B) (0%)
    6μs
40 statements were executed, 3 of which were duplicates, 37 unique17.11ms1.05MB
  • SELECT @@SESSION.sql_mode;219μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `xi7s5_session` WHERE `session_id` = ?359μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `xi7s5_session` WHERE `session_id` = :session_id LIMIT 1155μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `xi7s5_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)263μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `xi7s5_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 171μs2.36KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `xi7s5_viewlevels`123μs976B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `xi7s5_usergroups` AS `a` LEFT JOIN `xi7s5_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest60μs1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `xi7s5_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`232μs20.8KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `path` FROM xi7s5_rsfirewall_ignored WHERE `type`='ignore_folder' OR `type`='ignore_file'42μs2.07KB/administrator/components/com_rsfirewall/helpers/config.php:56Copy
  • SELECT `file` FROM xi7s5_rsfirewall_hashes WHERE `type`='protect'75μs840B/administrator/components/com_rsfirewall/helpers/config.php:63Copy
  • SELECT * FROM xi7s5_rsfirewall_configuration89μs1.94KB/administrator/components/com_rsfirewall/helpers/config.php:71Copy
  • SHOW FULL COLUMNS FROM `xi7s5_rsfirewall_logs`396μs2.05KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • 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 `xi7s5_menu` AS `m` LEFT JOIN `xi7s5_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`812μs36.98KBParams/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 `xi7s5_categories` AS `s` INNER JOIN `xi7s5_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`585μs5.11KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id` FROM `xi7s5_content` WHERE `alias` = :alias AND `catid` = :catid242μs1.65KBParams/components/com_content/src/Service/Router.php:263Copy
  • SELECT * FROM xi7s5_rsfirewall_hashes WHERE (`type`='4.4.9' OR `type`='protect') AND (`flag`!='C' OR `flag` IS NULL)274μs1.14KB/plugins/system/rsfirewall/rsfirewall.php:1078Copy
  • SELECT * FROM xi7s5_rsfirewall_snapshots WHERE `type`='protect'122μs3.5KB/administrator/components/com_rsfirewall/helpers/snapshot.php:49Copy
  • SELECT * FROM `xi7s5_users` WHERE `id` = '551'325μs3.63KB/plugins/system/rsfirewall/rsfirewall.php:1116Copy
  • SELECT group_id FROM xi7s5_user_usergroup_map WHERE `user_id`=551124μs856B/administrator/components/com_rsfirewall/helpers/snapshot.php:70Copy
  • SELECT `ip`,`reason` FROM xi7s5_rsfirewall_lists WHERE (`ip`='3.134.109.116' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='1' AND `published`='1'236μs896B/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT `ip`,`reason` FROM xi7s5_rsfirewall_lists WHERE (`ip`='3.134.109.116' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='0' AND `published`='1'190μs896B/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT * FROM xi7s5_rsfirewall_exceptions WHERE `published`='1'242μs2.06KB/plugins/system/rsfirewall/rsfirewall.php:729Copy
  • SELECT * FROM `xi7s5_languages` WHERE `published` = 1 ORDER BY `ordering` ASC287μs2.22KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `xi7s5_template_styles` AS `s` LEFT JOIN `xi7s5_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` = 1101μs33.3KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `xi7s5_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,:preparedArray42)884μs7.88KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `xi7s5_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0782μs25.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `xi7s5_content`549μs2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `xi7s5_content` SET `hits` = (`hits` + 1) WHERE `id` = '455'222μ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 `xi7s5_content` AS `a` INNER JOIN `xi7s5_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `xi7s5_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `xi7s5_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `xi7s5_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `xi7s5_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)623μs24.63KBParams/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 `xi7s5_categories` AS `s` INNER JOIN `xi7s5_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`511μs5.16KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `xi7s5_contentitem_tag_map` AS `m` INNER JOIN `xi7s5_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)388μs5.22KBParams/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 `xi7s5_categories` AS `s` INNER JOIN `xi7s5_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`135μs5.16KBParams/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 xi7s5_fields AS a LEFT JOIN `xi7s5_languages` AS l ON l.lang_code = a.language LEFT JOIN xi7s5_users AS uc ON uc.id=a.checked_out LEFT JOIN xi7s5_viewlevels AS ag ON ag.id = a.access LEFT JOIN xi7s5_users AS ua ON ua.id = a.created_user_id LEFT JOIN xi7s5_fields_groups AS g ON g.id = a.group_id LEFT JOIN `xi7s5_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 ASC989μs17KBParams/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 `xi7s5_categories` AS `s` INNER JOIN `xi7s5_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`155μs5.16KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `xi7s5_modules` AS `m` LEFT JOIN `xi7s5_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `xi7s5_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`3.51ms794.13KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`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` FROM `xi7s5_content` AS `a` LEFT JOIN `xi7s5_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `xi7s5_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `xi7s5_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `xi7s5_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `xi7s5_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`id` <> :articleId AND `a`.`catid` IN (:preparedArray5) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY a.publish_up DESC LIMIT 31.11ms41.48KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • 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 xi7s5_fields AS a LEFT JOIN `xi7s5_languages` AS l ON l.lang_code = a.language LEFT JOIN xi7s5_users AS uc ON uc.id=a.checked_out LEFT JOIN xi7s5_viewlevels AS ag ON ag.id = a.access LEFT JOIN xi7s5_users AS ua ON ua.id = a.created_user_id LEFT JOIN xi7s5_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 ASC859μs5.31KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • 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 `xi7s5_scheduler_tasks` AS `a` WHERE `a`.`state` = 1182μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT `session_id` FROM `xi7s5_session` WHERE `session_id` = ?300μs1.63KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `xi7s5_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?288μs912BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy