K-Tec

Measuring CCD Linearity

More
14 years 1 month ago #88166 by mjc
Replied by mjc on topic Re: Measuring CCD Linearity
My flats were taken as follows:

I made a translucent filter from two layers of the white plastic sheet that separates layers of Serena ham (it might be three - I made it a while ago) and used an empty 1 1/4" filter ring.

Then placed it on the nose of the CCD and placed the CCD on a shelf with the filter ring about 10cm from part of the wall appeared to have uniform shadow.

This is not an ideal solution - nor particularly repeatable as brightness of ambient light can vary over time. I used ambient electric light and avoided daylight hours.

For linearity test concurrently walked exposures up from min to max and also from max to min. Differences between the two curves can reveal that ambient brightness changed.

I did my stats on full frames. This is a weakness of my measurement. Are my flats as flat as they could be and if they are not then doing full frames probably isn't wise.

If I were to examine my flats and find a 100 x 100 pixel (or so) region that I can confirm is flat then measurements based on that ROI would probably give me more accurate data.

Ideally one would use a low-level light source as per the AIP (Berry and Burnell) and still search out flat sub-regions.

The device is described on pg 4 ff in

www.jlab.org/~salgado/notes/CCDReport.pdf

And in case that link doesn't work here it is as just text (I think)
www.jlab.org/~salgado/notes/CCDReport.pdf

CCD is cooled - single stage peltier - brings chip down to about 20 - 25C below ambient.

Dave you said: "but I'd imagine as long as temperature conditions vary by only a small amount over the imaging time that the data is still good"

A very good point. My CCD appears to have very low dark current. and small changes of temperature by 1 - 2 degrees isn't likely to affect things by much. Because I used relatively bright ambient light a lot of my exposures were less than a few seconds.

If I got my physics right you'd have to look at how the temperature changes on the absolute Kelvin scale (so zero Celsius is 273K - one or two degrees kelvin isn't much) - especially when dark current is so low and my exposure time so short.

I think my chip has an overscan but no software/firmware to utilise it.

Its all interesting stuff...

Mark C.

Please Log in or Create an account to join the conversation.

  • dmcdona
  • Topic Author
  • Offline
  • Administrator
  • Administrator
More
14 years 1 month ago #88169 by dmcdona
Replied by dmcdona on topic Re: Measuring CCD Linearity

mjc wrote: ...two layers of the white plastic sheet that separates layers of Serena ham


Presumably without the ham? :)

That sounds like a fairly good process. I've heard tell that incandescent lamps are better than the fluorescent (inlcuding "green") bulbs/tubes can be problematic. I also saw that two folks simply use sheets of white paper - the number of sheets varied until approx a 60 sec exposure gave max ADU's. I also followed the same process with simple laser printer paper.

My ROI was chosen by taking a very long dark (4 hours long!) and then examining the image and avoiding obviously regions containing lots of hot pixels. I narrowed it down to a region of 140 x 140 pixels - it just happened to very close to the center of the chip - though I don't think that mattered too much.

The practicalities were carried out by:

1. I got a cardboard box and lined it with black card
2. Imager went into the box
3. A lint-free cloth was placed tightly over the nosecone of the imager to prevent any paper particles falling onto the CCD window when the shutter was opened
4. Sheets of paper (I think about 15) were placed over the lint free cloth
5. I have a light-box - this was placed over the top of the cardboard box and swithced on. I let it "warm up" for about half an hour
5. Images were taken in my study with all other light sources off

Since my max exposure was about 80 or 90 seconds, it didn't take long to iterate through two exposures at each exposure duration (I started at about 0.1 sec). It took about an hour or so.
Images were taken at -20 deg c.

I took corresponding darks for flat calibration.

The ROI was cropped as well as the corresponding overscan region. The cropped areas and the overscan regions were then analysed and the data thrown into the spreadsaheet. Then I did the pixel-math with the duplicate ROI's - data again thrown into the spreadheet.

That's pretty much the process I wanted to write-up but haven't had the time yet...

Darks were easier but the duration far longer. They were taken at room temp but went up to 4hrs duration (and they are duplicated - so that was the imager out of use for about 16 hours).

Its a shame you have no software facility to overscan - perhaps an email to the manufacturer?

Anyhow - hope the above helps in some way to you and others following this thread...

Dave

Please Log in or Create an account to join the conversation.

More
14 years 1 month ago #88200 by eansbro
Replied by eansbro on topic Re: Measuring CCD Linearity
Mark,

I've read Howell's book and have tried out some of the tests. However, Howell only briefly mentions Janesick method. There is a lack of detailed equations on linearity, gain, readout noise and dark current. Does Janesick book show detailed equations for example for gain and readout noise? Or does he have some published papers that show his methods for the above. I have tried on the internet, but had no luck.

Eamonn A

Please Log in or Create an account to join the conversation.

More
14 years 1 month ago - 14 years 1 month ago #88202 by mjc
Replied by mjc on topic Re: Measuring CCD Linearity
Eamonn

I haven't got the Janesick book yet (next few days) so I can't really answer your question. It is my expectation that it does go detailed and hope that it is covered. I have tried to rationalise this equation in my mind and can't honestly say that I understand how it comes about.

A quick scan of the internet got:
ftp://tesis.bbtk.ull.es/ccppytec/cp163.pdf
And on page 121 indicates that Janesick's method heralds from Janesick,
Evans, & Elliott 1987 - but I can't find that referenced document.

If I find some supporting logic/maths for the method (either in the Jansick book or otherwise) -I will post.

Mark C.
Last edit: 14 years 1 month ago by mjc. Reason: Link didn't work - wasn't visible

Please Log in or Create an account to join the conversation.

  • dmcdona
  • Topic Author
  • Offline
  • Administrator
  • Administrator
More
14 years 1 month ago #88203 by dmcdona
Replied by dmcdona on topic Re: Measuring CCD Linearity
Eamonn - I used Richard Crisp's methodology. It takes a bit of navigating but all the data and a partial methodolgy is on this site:
www.narrowbandimaging.com/home_page.htm

I say partial in as much as I had to contact Richard (and Tim Khan) to expand on a few points I didn't understand. They (and others) can be found on the CCD-Tech Yahoo group. Richard frequently references Janesick.

I have the Howell book and it really is only an overview. I took delivery of the AIP book last week - its seems a lot more comprehensive but I haven't had a chance to read it in detail yet.

Hope that helps.

Please Log in or Create an account to join the conversation.

More
14 years 1 month ago - 14 years 1 month ago #88240 by mjc
Replied by mjc on topic Re: Measuring CCD Linearity
I got the Janesick book yesterday.

In quick response to Eamonn's question (if I got that question correctly)

The equation giving gain as the sum of two flats minus the sum of two bias all over sigma^2 difference in flats minus sigma^2 difference in the two bias does not appear to be in the book.

Janesick seems to favour the PTC as the method of choice for determining gain. There is, however, a reference / description of some method (and maybe related to the PTC) involving histograms but I know nothing, at the moment, of that technique.

The book is basically an aggregation of material published in SPIE papers over the years as well as some lectures at UCLA.

Equations presented are explained but, and I have had limited time looking at it, only to the degree that justifies them without going through tedious intermediate steps. I haven't worked any of these through myself yet.

My first impression was - I'm well out of my depth.

In the preface is the following sentence:-

"This book is written for a wide audience - from the novice to the advanced CCD user."

I'd love to know what Janesick regards as a "novice".

However, from experience, I know that things can look daunting and intimidating but perseverance usually pays off - if its something one really wants. However, it is encyclopedic and there will be stuff that will just have to be parked.

From the back cover:-
"James Janesick has authored more than 75 publications on CCDs, has contributed to 17 NASA Tech Briefs, and holds 12 patents for various CCD innovations. At the Jet Propulsion Laboratory, his work focused on scientific CCDs and support electronics utilised in many CCD NASA spaceborne imaging systems, including the Hubble Space Telescope, and the Galileo and Cassini projects. Janesick received NASA medals for Exceptional Engineering Achievement in 1982 and 1992."

From scanning the book one gets insights into certain technical specs of those missions - such as full well capacity etc. - and these little snippets also have their value. It never dawned on me, for example (a historical reference in the book) that Voyager was pre-CCD roll-out.

Bottom line - I'm glad I bought the book - but it's a book that one studies more than reads - and will take time to measure what net value I get out of it.

Mark C.

[Edit: When I say "encyclopedic" what I mean is it goes to depths and detail that one needs (in my case) to refer to the glossary because it's discussing unfamiliar ground and terminology]
Last edit: 14 years 1 month ago by mjc. Reason: Auto Spell check correction: Inderminate steps -> intermediate steps

Please Log in or Create an account to join the conversation.

Time to create page: 0.113 seconds
Powered by Kunena Forum
9MBMemory Usage164msRequest Duration
Joomla! Version4.3.4
PHP Version8.4.5
Identityguest
Response200
Templatecassiopeia
Database
Server
mysql
Version
10.6.18-MariaDB-0ubuntu0.22.04.1
Collation
utf8mb4_general_ci
Conn Collation
utf8mb4_general_ci
$_GET
array:1 [ "start" => "42" ]
$_POST
[]
$_SESSION
[]
$_COOKIE
[]
$_SERVER
array:42 [ "USER" => "www-data" "HOME" => "/var/www" "HTTP_ACCEPT_ENCODING" => "gzip, deflate,...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1744035446 "last" => 1744035446...
registry
array:3 [ "data" => array:3 [ "com_kunena" => array:2 [ "user0_read" => array:32 [ ...
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (456.32KB) (1.07ms)
  • afterInitialise (1.16MB) (12.7ms)
  • afterRoute (187.38KB) (3.16ms)
  • beforeRenderComponent com_kunena (30.34KB) (1.38ms)
  • Before Access::preloadComponents (all components) (1.37MB) (49.27ms)
  • After Access::preloadComponents (all components) (119.01KB) (798μs)
  • Before Access::getAssetRules (id:213 name:com_kunena) (1.16KB) (22μs)
  • After Access::getAssetRules (id:213 name:com_kunena) (6.89KB) (66μs)
  • afterRenderComponent com_kunena (2.03MB) (63.62ms)
  • afterDispatch (18.34KB) (259μs)
  • beforeRenderRawModule mod_cblogin (Login) (76.07KB) (549μs)
  • afterRenderRawModule mod_cblogin (Login) (15.16KB) (223μs)
  • beforeRenderRawModule mod_custom (Network Online!) (7.91KB) (17μs)
  • afterRenderRawModule mod_custom (Network Online!) (13.13KB) (436μs)
  • beforeRenderRawModule mod_jevents_latest (Upcoming Events) (10.03KB) (29μs)
  • Before Access::getAssetRules (id:1882 name:com_jevents) (161.3KB) (1.26ms)
  • After Access::getAssetRules (id:1882 name:com_jevents) (1.28KB) (9μs)
  • afterRenderRawModule mod_jevents_latest (Upcoming Events) (1MB) (7.37ms)
  • beforeRenderRawModule mod_menu (Main Menu) (6.38KB) (48μs)
  • afterRenderRawModule mod_menu (Main Menu) (169.67KB) (1.57ms)
  • beforeRenderRawModule mod_finder (Search) (832B) (26μs)
  • afterRenderRawModule mod_finder (Search) (357.41KB) (4.07ms)
  • beforeRenderRawModule mod_banners (Sponsors) (2.89KB) (27μs)
  • afterRenderRawModule mod_banners (Sponsors) (145.11KB) (3.38ms)
  • beforeRenderRawModule mod_menu (footermenu) (496B) (43μs)
  • afterRenderRawModule mod_menu (footermenu) (61.41KB) (515μs)
  • beforeRenderModule mod_menu (footermenu) (10.27KB) (177μs)
  • afterRenderModule mod_menu (footermenu) (3.43KB) (288μs)
  • beforeRenderModule mod_cblogin (Login) (11.96KB) (75μs)
  • afterRenderModule mod_cblogin (Login) (2.7KB) (66μs)
  • beforeRenderModule mod_custom (Network Online!) (8.96KB) (15μs)
  • afterRenderModule mod_custom (Network Online!) (2.82KB) (26μs)
  • beforeRenderModule mod_jevents_latest (Upcoming Events) (9.77KB) (26μs)
  • afterRenderModule mod_jevents_latest (Upcoming Events) (3.57KB) (34μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (9.41KB) (100μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (37.89KB) (615μs)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (4μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.93KB) (34μs)
  • beforeRenderModule mod_banners (Sponsors) (8.48KB) (55μs)
  • afterRenderModule mod_banners (Sponsors) (2.57KB) (24μs)
  • beforeRenderModule mod_finder (Search) (4.02KB) (44μs)
  • afterRenderModule mod_finder (Search) (2.37KB) (21μs)
  • beforeRenderModule mod_menu (Main Menu) (7.88KB) (41μs)
  • afterRenderModule mod_menu (Main Menu) (2.8KB) (20μs)
  • afterRender (810.01KB) (6.89ms)
  • 1 x afterRenderComponent com_kunena (2.03MB) (38.72%)
    63.62ms
    1 x Before Access::preloadComponents (all components) (1.37MB) (29.99%)
    49.27ms
    1 x afterInitialise (1.16MB) (7.73%)
    12.70ms
    1 x afterRenderRawModule mod_jevents_latest (Upcoming Events) (1MB) (4.49%)
    7.37ms
    1 x afterRender (810.01KB) (4.19%)
    6.89ms
    1 x afterRenderRawModule mod_finder (Search) (357.41KB) (2.47%)
    4.07ms
    1 x afterRenderRawModule mod_banners (Sponsors) (145.11KB) (2.06%)
    3.38ms
    1 x afterRoute (187.38KB) (1.92%)
    3.16ms
    1 x afterRenderRawModule mod_menu (Main Menu) (169.67KB) (0.96%)
    1.57ms
    1 x beforeRenderComponent com_kunena (30.34KB) (0.84%)
    1.38ms
    1 x Before Access::getAssetRules (id:1882 name:com_jevents) (161.3KB) (0.77%)
    1.26ms
    1 x afterLoad (456.32KB) (0.65%)
    1.07ms
    1 x After Access::preloadComponents (all components) (119.01KB) (0.49%)
    798μs
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (37.89KB) (0.37%)
    615μs
    1 x beforeRenderRawModule mod_cblogin (Login) (76.07KB) (0.33%)
    549μs
    1 x afterRenderRawModule mod_menu (footermenu) (61.41KB) (0.31%)
    515μs
    1 x afterRenderRawModule mod_custom (Network Online!) (13.13KB) (0.27%)
    436μs
    1 x afterRenderModule mod_menu (footermenu) (3.43KB) (0.18%)
    288μs
    1 x afterDispatch (18.34KB) (0.16%)
    259μs
    1 x afterRenderRawModule mod_cblogin (Login) (15.16KB) (0.14%)
    223μs
    1 x beforeRenderModule mod_menu (footermenu) (10.27KB) (0.11%)
    177μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (9.41KB) (0.06%)
    100μs
    1 x beforeRenderModule mod_cblogin (Login) (11.96KB) (0.05%)
    75μs
    1 x After Access::getAssetRules (id:213 name:com_kunena) (6.89KB) (0.04%)
    66μs
    1 x afterRenderModule mod_cblogin (Login) (2.7KB) (0.04%)
    66μs
    1 x beforeRenderModule mod_banners (Sponsors) (8.48KB) (0.03%)
    55μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (6.38KB) (0.03%)
    48μs
    1 x beforeRenderModule mod_finder (Search) (4.02KB) (0.03%)
    44μs
    1 x beforeRenderRawModule mod_menu (footermenu) (496B) (0.03%)
    43μs
    1 x beforeRenderModule mod_menu (Main Menu) (7.88KB) (0.02%)
    41μs
    1 x afterRenderModule mod_jevents_latest (Upcoming Events) (3.57KB) (0.02%)
    34μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.93KB) (0.02%)
    34μs
    1 x beforeRenderRawModule mod_jevents_latest (Upcoming Events) (10.03KB) (0.02%)
    29μs
    1 x beforeRenderRawModule mod_banners (Sponsors) (2.89KB) (0.02%)
    27μs
    1 x beforeRenderRawModule mod_finder (Search) (832B) (0.02%)
    26μs
    1 x afterRenderModule mod_custom (Network Online!) (2.82KB) (0.02%)
    26μs
    1 x beforeRenderModule mod_jevents_latest (Upcoming Events) (9.77KB) (0.02%)
    26μs
    1 x afterRenderModule mod_banners (Sponsors) (2.57KB) (0.01%)
    24μs
    1 x Before Access::getAssetRules (id:213 name:com_kunena) (1.16KB) (0.01%)
    22μs
    1 x afterRenderModule mod_finder (Search) (2.37KB) (0.01%)
    21μs
    1 x afterRenderModule mod_menu (Main Menu) (2.8KB) (0.01%)
    20μs
    1 x beforeRenderRawModule mod_custom (Network Online!) (7.91KB) (0.01%)
    17μs
    1 x beforeRenderModule mod_custom (Network Online!) (8.96KB) (0.01%)
    15μs
    1 x After Access::getAssetRules (id:1882 name:com_jevents) (1.28KB) (0.01%)
    9μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (0%)
    4μs
115 statements were executed, 14 of which were duplicates, 101 unique29.43ms432.79KB
  • SELECT @@SESSION.sql_mode;113μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tifas_session` WHERE `session_id` = ?346μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tifas_session` WHERE `session_id` = :session_id LIMIT 172μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `tifas_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)705μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `tifas_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1281μs33.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tifas_viewlevels`103μs672B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `tifas_usergroups` AS `a` LEFT JOIN `tifas_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest101μs1.3KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `tifas_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1) ORDER BY `ordering`494μs3.96KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `tifas_kunena_configuration` WHERE `id` = 1110μs1.2KB/libraries/kunena/src/Config/KunenaConfig.php:1690Copy
  • SELECT sampleData FROM tifas_kunena_version ORDER BY id DESC LIMIT 196μs536B/libraries/kunena/src/Forum/KunenaForum.php:372Copy
  • 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 `tifas_menu` AS `m` LEFT JOIN `tifas_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`480μs20.05KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `tifas_kunena_aliases` WHERE `alias` LIKE '29-astro-photography%'142μs704B/libraries/kunena/src/Route/KunenaRoute.php:855Copy
  • SHOW TABLES708μs8.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM `tifas_languages` WHERE `published` = 1 ORDER BY `ordering` ASC128μs1.59KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `tifas_template_styles` AS `s` LEFT JOIN `tifas_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` = 1185μs832B/administrator/components/com_templates/src/Model/StyleModel.php:771Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_sessions`330μs1.34KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_users`416μs3.52KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `tifas_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,:preparedArray43,:preparedArray44,:preparedArray45,:preparedArray46)392μs7.69KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT DISTINCT(user_id) FROM `tifas_usergroups` AS `ug1` INNER JOIN `tifas_usergroups` AS `ug2` ON ug2.lft >= ug1.lft AND ug1.rgt >= ug2.rgt INNER JOIN `tifas_user_usergroup_map` AS `m` ON ug2.id = m.group_id WHERE ug1.id IN ( 8)681μs584B/plugins/kunena/joomla/KunenaAccessJoomla.php:388Copy
  • SELECT DISTINCT(user_id) FROM `tifas_usergroups` AS `ug1` INNER JOIN `tifas_usergroups` AS `ug2` ON ug2.lft >= ug1.lft AND ug1.rgt >= ug2.rgt INNER JOIN `tifas_user_usergroup_map` AS `m` ON ug2.id = m.group_id WHERE ug1.id IN ( 7)761μs584B/plugins/kunena/joomla/KunenaAccessJoomla.php:388Copy
  • SELECT `user_id`,`category_id`,`role` FROM `tifas_kunena_user_categories` WHERE `role` IN (1,2)130μs800B/libraries/kunena/src/Access/KunenaAccess.php:182Copy
  • SELECT * FROM `tifas_kunena_categories` ORDER BY `ordering`,`name`341μs21.27KB/libraries/kunena/src/Forum/Category/KunenaCategoryHelper.php:107Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_categories`436μs1.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '502'169μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '11'176μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '42'157μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '503'157μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '1'165μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '512'169μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '516'202μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '505'169μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '20'153μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '511'157μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '530'155μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '529'155μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '19'165μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '508'168μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '41'189μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '16'164μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '17'161μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '44'169μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '515'182μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '21'156μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '531'156μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '9'160μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '28'167μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '35'174μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '514'151μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '22'161μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '18'185μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '29'174μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '27'175μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '513'155μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '517'165μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '3'185μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '39'189μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '33'157μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '2'175μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '40'184μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '30'188μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '45'190μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '46'187μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '528'154μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_topics`366μs1.7KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_topics` WHERE `id` = '87780'165μs13.81KB/libraries/kunena/src/Tables/TableKunenaTopics.php:223Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_messages`410μs1.58KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT m.*,t.message FROM `tifas_kunena_messages` AS `m` INNER JOIN `tifas_kunena_messages_text` AS `t` ON `m`.`id` = `t`.`mesid` WHERE `m`.`id` = 87780169μs2.53KB/libraries/kunena/src/Tables/TableKunenaMessages.php:216Copy
  • SELECT COUNT(*) FROM `tifas_kunena_messages` AS `a` WHERE `thread` = '87780' AND `a`.`hold` IN (0)233μs536B/libraries/kunena/src/Database/Object/KunenaFinder.php:278Copy
  • SELECT a.id FROM `tifas_kunena_messages` AS `a` WHERE `thread` = '87780' AND `a`.`hold` IN (0) ORDER BY a.`time` ASC LIMIT 42, 6263μs616B/libraries/kunena/src/Database/Object/KunenaFinder.php:234Copy
  • SELECT m.*, t.message FROM `tifas_kunena_messages` AS `m` INNER JOIN `tifas_kunena_messages_text` AS `t` ON m.id = t.mesid WHERE `m`.`id` IN (88166,88169,88200,88202,88203,88240)616μs2.61KB/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:120Copy
  • SELECT * FROM `tifas_kunena_thankyou` WHERE `postid` IN (88166,88169,88200,88202,88203,88240)133μs688B/libraries/kunena/src/Forum/Message/Thankyou/KunenaMessageThankyouHelper.php:116Copy
  • SELECT u.name, u.username, u.email, u.block AS blocked, u.registerDate, u.lastvisitDate, ku.*, u.id AS userid FROM `tifas_users` AS `u` LEFT JOIN `tifas_kunena_users` AS `ku` ON `u`.`id` = `ku`.`userid` WHERE `u`.`id` IN (1582,338,87)336μs25.03KB/libraries/kunena/src/User/KunenaUserHelper.php:247Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (88166,88169,88200,88202,88203,88240)153μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_user_topics` WHERE (`user_id` = '0') AND (`topic_id` IN (87780))123μs1.27KB/libraries/kunena/src/Forum/Topic/User/KunenaTopicUserHelper.php:159Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_user_topics`384μs1.42KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT `code`,`location` FROM `tifas_kunena_smileys`116μs960B/libraries/kunena/src/BBCode/KunenaBBCode.php:1122Copy
  • UPDATE `tifas_kunena_topics` SET `hits` = (`hits` + 1) WHERE `id` = '87780'424μs48B/libraries/src/Table/Table.php:1325Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `tifas_modules` AS `m` LEFT JOIN `tifas_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `tifas_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)) 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`674μs1.86KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_polls`338μs1.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_ranks`120μs1.48KB/libraries/kunena/src/User/KunenaUser.php:1629Copy
  • SELECT userid, MAX(time) AS time FROM `tifas_session` WHERE `client_id` = 0 AND `userid` > 0 AND `time` > '1744033646' GROUP BY `userid` ORDER BY `time` DESC193μs576B/libraries/kunena/src/User/KunenaUserHelper.php:544Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (88166)140μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (88166)134μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT m.id, mm.hold, m.catid AS category_id, m.thread AS topic_id, SUM(mm.time<m.time) AS before_count, SUM(mm.time>m.time) AS after_count FROM `tifas_kunena_messages` AS `m` INNER JOIN `tifas_kunena_messages` AS `mm` ON `m`.`thread` = `mm`.`thread` WHERE `m`.`id` IN (88166) GROUP BY `m`.`id`,`mm`.`hold`310μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (88169)130μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (88169)128μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT m.id, mm.hold, m.catid AS category_id, m.thread AS topic_id, SUM(mm.time<m.time) AS before_count, SUM(mm.time>m.time) AS after_count FROM `tifas_kunena_messages` AS `m` INNER JOIN `tifas_kunena_messages` AS `mm` ON `m`.`thread` = `mm`.`thread` WHERE `m`.`id` IN (88169) GROUP BY `m`.`id`,`mm`.`hold`285μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (88200)130μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (88200)131μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT m.id, mm.hold, m.catid AS category_id, m.thread AS topic_id, SUM(mm.time<m.time) AS before_count, SUM(mm.time>m.time) AS after_count FROM `tifas_kunena_messages` AS `m` INNER JOIN `tifas_kunena_messages` AS `mm` ON `m`.`thread` = `mm`.`thread` WHERE `m`.`id` IN (88200) GROUP BY `m`.`id`,`mm`.`hold`292μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (88202)130μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (88202)130μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT m.id, mm.hold, m.catid AS category_id, m.thread AS topic_id, SUM(mm.time<m.time) AS before_count, SUM(mm.time>m.time) AS after_count FROM `tifas_kunena_messages` AS `m` INNER JOIN `tifas_kunena_messages` AS `mm` ON `m`.`thread` = `mm`.`thread` WHERE `m`.`id` IN (88202) GROUP BY `m`.`id`,`mm`.`hold`296μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (88203)128μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (88203)140μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT m.id, mm.hold, m.catid AS category_id, m.thread AS topic_id, SUM(mm.time<m.time) AS before_count, SUM(mm.time>m.time) AS after_count FROM `tifas_kunena_messages` AS `m` INNER JOIN `tifas_kunena_messages` AS `mm` ON `m`.`thread` = `mm`.`thread` WHERE `m`.`id` IN (88203) GROUP BY `m`.`id`,`mm`.`hold`330μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (88240)152μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (88240)136μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • 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 tifas_fields AS a LEFT JOIN `tifas_languages` AS l ON l.lang_code = a.language LEFT JOIN tifas_users AS uc ON uc.id=a.checked_out LEFT JOIN tifas_viewlevels AS ag ON ag.id = a.access LEFT JOIN tifas_users AS ua ON ua.id = a.created_user_id LEFT JOIN tifas_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray2)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC643μs4.03KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT * FROM `tifas_kunena_announcement` WHERE `published` = 1 AND (`publish_up` = '1000-01-01 00:00:00' OR `publish_up` <= '2025-04-07 14:17:26') AND (`publish_down` ='1000-01-01 00:00:00' OR `publish_down` >= '2025-04-07 14:17:26') ORDER BY `id` DESC LIMIT 1130μs1.42KB/libraries/kunena/src/Forum/Announcement/KunenaAnnouncementHelper.php:145Copy
  • SHOW FULL COLUMNS FROM `tifas_jev_users`531μs1.58KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • 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 `tifas_categories` AS `c` WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1) AND `c`.`published` = 1 ORDER BY `c`.`lft`293μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT c.id FROM tifas_categories AS c WHERE c.access IN (1) AND c.published = 1 AND c.language in ('en-GB','*') AND c.extension = 'com_jevents' ORDER BY c.lft asc203μs584B/components/com_jevents/libraries/dbmodel.php:547Copy
  • SELECT c.id FROM tifas_categories AS c WHERE c.access IN (1) AND c.published = 1 AND c.language in ('en-GB','*') AND c.extension = 'com_jevents' AND ((c.lft>=87 AND c.rgt<=88 )) ORDER BY c.lft asc217μs536B/components/com_jevents/libraries/dbmodel.php:547Copy
  • SELECT ev.ev_id FROM tifas_jevents_repetition as rpt INNER JOIN tifas_jevents_vevent as ev ON rpt.eventid = ev.ev_id INNER JOIN tifas_jevents_icsfile as icsf ON icsf.ics_id=ev.icsid INNER JOIN tifas_jevents_vevdetail as det ON det.evdet_id = rpt.eventdetail_id LEFT JOIN tifas_jevents_rrule as rr ON rr.eventid = rpt.eventid WHERE ev.catid IN(-1,68) AND ev.created >= '2024-10-09 00:00:00' AND ev.created <= '2025-10-04 23:59:59' AND ev.state=1 AND ev.access IN (1) AND icsf.state=1 AND icsf.access IN (1) GROUP BY ev.ev_id ORDER BY ev.created DESC LIMIT 101.03ms520B/components/com_jevents/libraries/dbmodel.php:271Copy
  • SELECT rpt.*, ev.*, rr.*, det.*, ev.state as published, ev.created as created , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup , YEAR(rpt.endrepeat ) as ydn, MONTH(rpt.endrepeat ) as mdn, DAYOFMONTH(rpt.endrepeat ) as ddn , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup , HOUR(rpt.endrepeat ) as hdn, MINUTE(rpt.endrepeat ) as mindn, SECOND(rpt.endrepeat ) as sdn FROM tifas_jevents_repetition as rpt INNER JOIN tifas_jevents_vevent as ev ON rpt.eventid = ev.ev_id INNER JOIN tifas_jevents_icsfile as icsf ON icsf.ics_id=ev.icsid INNER JOIN tifas_jevents_vevdetail as det ON det.evdet_id = rpt.eventdetail_id LEFT JOIN tifas_jevents_rrule as rr ON rr.eventid = rpt.eventid WHERE ev.catid IN(-1,68) AND ev.created >= '2024-10-09 00:00:00' AND ev.created <= '2025-10-04 23:59:59' AND ev.state=1 AND ev.access IN (1) AND icsf.state=1 AND icsf.access IN (1) AND ev.ev_id IN (0) ORDER BY ev.created DESC , rpt.startrepeat ASC318μs10.33KB/components/com_jevents/libraries/dbmodel.php:3274Copy
  • SELECT `name`,`element` FROM `tifas_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1534μs736B/administrator/components/com_finder/src/Helper/LanguageHelper.php:134Copy
  • SELECT `title` FROM `tifas_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1)164μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT * FROM `tifas_banners` WHERE (`reset` <= :date AND `reset` IS NOT NULL) AND (`checked_out` IS NULL OR `checked_out` = :userId)237μs5.39KBParams/administrator/components/com_banners/src/Helper/BannersHelper.php:69Copy
  • SELECT `a`.`id`,`a`.`type`,`a`.`name`,`a`.`clickurl`,`a`.`sticky`,`a`.`cid`,`a`.`description`,`a`.`params`,`a`.`custombannercode`,`a`.`track_impressions`,`cl`.`track_impressions` AS `client_track_impressions` FROM `tifas_banners` AS `a` LEFT JOIN `tifas_banner_clients` AS `cl` ON `cl`.`id` = `a`.`cid` WHERE ( ( (`a`.`state` = 1) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :nowDate1)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :nowDate2)) AND (`a`.`imptotal` = 0 OR `a`.`impmade` < `a`.`imptotal`) AND `a`.`catid` IN (:preparedArray1) ORDER BY `a`.`sticky` DESC, RAND() LIMIT 1503μs2.28KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • UPDATE `tifas_banners` SET `impmade` = `impmade` + 1 WHERE `id` IN (:preparedArray1)440μs856BParams/components/com_banners/src/Model/BannersModel.php:315Copy
  • UPDATE `tifas_banner_tracks` SET `count` = `count` + 1 WHERE `track_type` = 1 AND `banner_id` = :id AND `track_date` = :trackDate374μs832BParams/components/com_banners/src/Model/BannersModel.php:352Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor` FROM `tifas_scheduler_tasks` AS `a` LEFT JOIN `tifas_users` AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE `a`.`state` = :state AND `a`.`next_execution` <= :now ORDER BY `a`.`title` asc220μs3.16KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor` FROM `tifas_scheduler_tasks` AS `a` LEFT JOIN `tifas_users` AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE `a`.`state` = :state AND `a`.`locked` IS NOT NULL ORDER BY `a`.`title` asc203μs3.18KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy
  • SHOW TABLES738μs8.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy