K-Tec

Problem with Flats

More
11 years 1 month ago #100057 by albertw
Replied by albertw on topic Problem with Flats

CarlightExpress wrote: Sure is an interesting subject, and I still don't know what my optimal ADU is for flats :P

Ah yes, flats, that's where we started!

I can't find anywhere that explains the reasoning behind the '1/3 - 1/2' of total ADU advice.

Flats get divided into the lights so the actual values shouldn't really matter (processing software will handle the details!). They should have high signal to noise so you'd think longer is better; too short (too low ADU) and you'll have noise, but too long and the flat will get saturated. So I'd have thought that ideal flats would be ones where the highest pixel value was near but within the upper linearity limit of the CCD.

That said I just use around 25k ADU :) Seems to work ok!

Albert White MSc FRAS
Chairperson, International Dark Sky Association - Irish Section
www.darksky.ie/

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

  • CarlightExpress
  • Topic Author
  • Offline
  • Main Sequence
  • Main Sequence
More
11 years 1 month ago #100058 by CarlightExpress
Replied by CarlightExpress on topic Problem with Flats
Albert

The subject came about because what the manufacturers say is "Full Well" is not necessarily the full well capacity of the CCD, so doing all this will determine where the full well is of my CCD

I was doing mine at 27k ADU

Simon

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

More
11 years 1 month ago #100068 by mjc
Replied by mjc on topic Problem with Flats
To get "optimal" flats exposure implies going to the highest exposure before hitting the full well capacity.
To be more accurate - it implies the highest exposure before we hit the non-linear region which before we hit full-well.
In the case of CCDs with anti-blooming gates (and I think your CCD, Simon, has ABG) electrons are siphoned off before they over-spill into neighbouring pixels on the same column. This inevitably means there is a range of exposures before FWC where the responsiveness is non-linear. - and no good for flats.
Also - not all pixels are equally responsive and some pixels can reach FWC before others.
To determine the optimum exposure for flats would be very difficult to determine.

I suspect (and I'd like to research this) that in the science community they would start off with the criteria of what signal-to-noise ratio is necessary for the data they wish to capture and then choose flats which are of no less an SNR - for choosing flats of poorer SNR would degrade the quality of the science data and defeat the purpose of using them.

I'd determine where linearity ends (which could be FWC) in a representative region of interest - or whole chip - and cut-back by some conservative safety margin.
But unless one is doing quantitative work where every achievable decimal place should be savoured I'd go something like 1/2 full scale - if you can no longer see a dust doughnut or vignetting after flat-fielding then job done. I'd like to see a purveyor of aesthetic astrophotography contribute any comment on that one.
I think at end of day flat-fielding shouldn't degrade your work regardless of purpose of the image. Cost / benefit sort of thing - more good should be done than harm.

Mark C.

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

More
11 years 1 month ago #100070 by mjc
Replied by mjc on topic Problem with Flats
Reading Janesick (re: PTC) - there's a couple of things that immediately strike me.

I've never been clear on whether it is necessary to do anything special about dark-current (ignoring DTC for now).

Janesick - without talking to me as if I were a 10 year-old (which I need right now) seems to suggest (after several readings) that the exposures taken from zero seconds to that which exposes full well capacity - are all left on the CCD for an equal amount of time (which he calls a "fixed integration period") before downloading - regardless of the actual exposure.

I have not seen a reference to the zero-second exposure being used as a dark-frame for dark-subtraction purposes - esp in the explanatory equations - but it is called a dark-frame in the text (it is zero-second exposure to light - but left on the CCD for the integration period).

Now I can't do that with my CCD as once exposure is complete it is automatically downloaded.

Now Janesick also suggests using a an LED as the light source - of which the switching on and off serves as the timing mechanism of the exposure which is especially better at the very short exposures for which a mechanical shutter (and I assume inter-line and frame transfer CCDs) cannot do as well.

While I've taken this on board - I can't say that I am in full understanding as yet.

Also pointed out, there is (or can be) a region before full well capacity is reached where differences in pixel-to-pixel responsiveness affects the curve and he proposes a technique (possibly reflected in the spreadsheet in earlier part of our discussions) whereby every exposure is duplicated (we have pairs of exposures) and a little bit of pixel arithmetic can be done on each image pair so that we eliminate this artefact that affects the linearity in that part of the PTC from which we estimate the gain (by extrapolating down to the x-axis). I'm still trying to digest the equation explaining this one.

I want to (if I can) understand what Janesick says of PTC's before I revisit the spreadsheet.

Mark C.

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

More
11 years 1 month ago #100116 by mjc
Replied by mjc on topic Problem with Flats
I've produced a PTC curve for my Atik 16IC CCD as best as I understand Janesick.
It appears to be a beautiful classic curve and for which I get a gain only slightly different to when I used simpler methods a few years ago.

One thing that I wanted to do was use the data to numerically calculate the gain and readout noise (through numerically calculating x and y axis intercepts) rather than using "eyeballing" of the visual chart - or placing graphical lines to determine intersects visually.

I've done this with with gain - but not with readout noise - that had to be eyeballed.
What I've done with gain is to use a linear trend line (from equation produced by the spreadsheet graphing feature) - but suspect that this isn't quite right (for a subtle statistical reason best left unsaid for now - but very compelling and I'd say inconsequential).

My gain is very much in the ball park of where I'd expect it to be - but the readout noise is slightly less than half of what I'd expect and so I'm suspicious and want to research more.

Full-well capacity. My Chip has an anti-blooming gate - it came with the device which came at a nice consumer price - given the choice (and budget) I'd choose not to have ABG.
It's easy to select a point below which I should be confident of linearity - using this data. However, when visually inspecting the image in the region of interest (ROI) used to perform my calculations I notice a gradient (downwards in ADUs) near one edge of the frame.
My initial interpretation is that the ABG is affecting read out with relatively high ADU count ROIs - but with mean ADU not yet at what I would have considered full-well capacity.
I need to research that more - but the interpretation of FWC might have to be considered differently for CCDs with ABG (or I have a dicky CCD).

Another thing that I have observed with my CCD (and I saw this when I last attempted characterisation a few years ago) is that the first image (often / always) taken after power on (regardless of time from power-up to exposure and download) has an abnormally high stdev (as observed on bias images).

There is still more that I'd like to do and that is that when determining certain characteristics like gain, readout noise, full well capacity, etc is when we come up with a number - how can we say something to the effect of "confidence is high" (okay that needs clarification) that this is good to 2, 3 - or what ever decimal places or g = 0.222 +/- 0.002.

More to come - but there will be periods of apparent inactivity from me.
It would be nice if we had a documented prescriptive method and guide to analysis with explanations. Maybe something like that will come out of this.

I have learned more than I have documented here - but I also have more questions that I equally have not documented.

Mark C.

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

  • CarlightExpress
  • Topic Author
  • Offline
  • Main Sequence
  • Main Sequence
More
11 years 1 month ago #100117 by CarlightExpress
Replied by CarlightExpress on topic Problem with Flats
Could you share your PTC :-)

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

Time to create page: 0.148 seconds
Powered by Kunena Forum
9MBMemory Usage203msRequest 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" => "78" ]
$_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" => 1743999658 "last" => 1743999658...
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) (663μs)
  • afterInitialise (1.16MB) (17.95ms)
  • afterRoute (187.38KB) (3.72ms)
  • beforeRenderComponent com_kunena (30.41KB) (1.8ms)
  • Before Access::preloadComponents (all components) (1.37MB) (83.69ms)
  • After Access::preloadComponents (all components) (119.01KB) (2.42ms)
  • Before Access::getAssetRules (id:213 name:com_kunena) (1.16KB) (20μs)
  • After Access::getAssetRules (id:213 name:com_kunena) (6.89KB) (70μs)
  • afterRenderComponent com_kunena (2.1MB) (61.84ms)
  • afterDispatch (18.34KB) (196μs)
  • beforeRenderRawModule mod_cblogin (Login) (76.07KB) (459μs)
  • afterRenderRawModule mod_cblogin (Login) (15.16KB) (167μs)
  • beforeRenderRawModule mod_custom (Network Online!) (7.91KB) (17μs)
  • afterRenderRawModule mod_custom (Network Online!) (13.13KB) (245μs)
  • beforeRenderRawModule mod_jevents_latest (Upcoming Events) (10.03KB) (30μs)
  • Before Access::getAssetRules (id:1882 name:com_jevents) (161.3KB) (1.04ms)
  • After Access::getAssetRules (id:1882 name:com_jevents) (1.28KB) (10μs)
  • afterRenderRawModule mod_jevents_latest (Upcoming Events) (1MB) (6.23ms)
  • beforeRenderRawModule mod_menu (Main Menu) (6.38KB) (46μs)
  • afterRenderRawModule mod_menu (Main Menu) (169.67KB) (1.67ms)
  • beforeRenderRawModule mod_finder (Search) (832B) (28μs)
  • afterRenderRawModule mod_finder (Search) (358.45KB) (3.4ms)
  • beforeRenderRawModule mod_banners (Sponsors) (2.89KB) (27μs)
  • afterRenderRawModule mod_banners (Sponsors) (145.11KB) (5.23ms)
  • beforeRenderRawModule mod_menu (footermenu) (496B) (44μs)
  • afterRenderRawModule mod_menu (footermenu) (60.16KB) (515μs)
  • beforeRenderModule mod_menu (footermenu) (10.27KB) (157μs)
  • afterRenderModule mod_menu (footermenu) (3.43KB) (252μs)
  • beforeRenderModule mod_cblogin (Login) (11.96KB) (71μs)
  • afterRenderModule mod_cblogin (Login) (2.7KB) (73μs)
  • beforeRenderModule mod_custom (Network Online!) (8.96KB) (55μs)
  • afterRenderModule mod_custom (Network Online!) (2.82KB) (46μs)
  • beforeRenderModule mod_jevents_latest (Upcoming Events) (9.77KB) (28μs)
  • afterRenderModule mod_jevents_latest (Upcoming Events) (3.57KB) (23μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (9.41KB) (115μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (37.89KB) (840μs)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (4μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.93KB) (37μs)
  • beforeRenderModule mod_banners (Sponsors) (8.48KB) (55μs)
  • afterRenderModule mod_banners (Sponsors) (2.57KB) (23μs)
  • beforeRenderModule mod_finder (Search) (4.02KB) (44μs)
  • afterRenderModule mod_finder (Search) (2.37KB) (21μs)
  • beforeRenderModule mod_menu (Main Menu) (7.88KB) (54μs)
  • afterRenderModule mod_menu (Main Menu) (2.8KB) (30μs)
  • afterRender (818.01KB) (6.51ms)
  • 1 x Before Access::preloadComponents (all components) (1.37MB) (41.19%)
    83.69ms
    1 x afterRenderComponent com_kunena (2.1MB) (30.44%)
    61.84ms
    1 x afterInitialise (1.16MB) (8.84%)
    17.95ms
    1 x afterRender (818.01KB) (3.21%)
    6.51ms
    1 x afterRenderRawModule mod_jevents_latest (Upcoming Events) (1MB) (3.07%)
    6.23ms
    1 x afterRenderRawModule mod_banners (Sponsors) (145.11KB) (2.58%)
    5.23ms
    1 x afterRoute (187.38KB) (1.83%)
    3.72ms
    1 x afterRenderRawModule mod_finder (Search) (358.45KB) (1.67%)
    3.40ms
    1 x After Access::preloadComponents (all components) (119.01KB) (1.19%)
    2.42ms
    1 x beforeRenderComponent com_kunena (30.41KB) (0.89%)
    1.80ms
    1 x afterRenderRawModule mod_menu (Main Menu) (169.67KB) (0.82%)
    1.67ms
    1 x Before Access::getAssetRules (id:1882 name:com_jevents) (161.3KB) (0.51%)
    1.04ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (37.89KB) (0.41%)
    840μs
    1 x afterLoad (456.32KB) (0.33%)
    663μs
    1 x afterRenderRawModule mod_menu (footermenu) (60.16KB) (0.25%)
    515μs
    1 x beforeRenderRawModule mod_cblogin (Login) (76.07KB) (0.23%)
    459μs
    1 x afterRenderModule mod_menu (footermenu) (3.43KB) (0.12%)
    252μs
    1 x afterRenderRawModule mod_custom (Network Online!) (13.13KB) (0.12%)
    245μs
    1 x afterDispatch (18.34KB) (0.1%)
    196μs
    1 x afterRenderRawModule mod_cblogin (Login) (15.16KB) (0.08%)
    167μs
    1 x beforeRenderModule mod_menu (footermenu) (10.27KB) (0.08%)
    157μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (9.41KB) (0.06%)
    115μs
    1 x afterRenderModule mod_cblogin (Login) (2.7KB) (0.04%)
    73μs
    1 x beforeRenderModule mod_cblogin (Login) (11.96KB) (0.03%)
    71μs
    1 x After Access::getAssetRules (id:213 name:com_kunena) (6.89KB) (0.03%)
    70μs
    1 x beforeRenderModule mod_custom (Network Online!) (8.96KB) (0.03%)
    55μs
    1 x beforeRenderModule mod_banners (Sponsors) (8.48KB) (0.03%)
    55μs
    1 x beforeRenderModule mod_menu (Main Menu) (7.88KB) (0.03%)
    54μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (6.38KB) (0.02%)
    46μs
    1 x afterRenderModule mod_custom (Network Online!) (2.82KB) (0.02%)
    46μs
    1 x beforeRenderModule mod_finder (Search) (4.02KB) (0.02%)
    44μs
    1 x beforeRenderRawModule mod_menu (footermenu) (496B) (0.02%)
    44μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.93KB) (0.02%)
    37μs
    1 x beforeRenderRawModule mod_jevents_latest (Upcoming Events) (10.03KB) (0.01%)
    30μs
    1 x afterRenderModule mod_menu (Main Menu) (2.8KB) (0.01%)
    30μs
    1 x beforeRenderRawModule mod_finder (Search) (832B) (0.01%)
    28μs
    1 x beforeRenderModule mod_jevents_latest (Upcoming Events) (9.77KB) (0.01%)
    28μs
    1 x beforeRenderRawModule mod_banners (Sponsors) (2.89KB) (0.01%)
    27μs
    1 x afterRenderModule mod_jevents_latest (Upcoming Events) (3.57KB) (0.01%)
    23μs
    1 x afterRenderModule mod_banners (Sponsors) (2.57KB) (0.01%)
    23μs
    1 x afterRenderModule mod_finder (Search) (2.37KB) (0.01%)
    21μs
    1 x Before Access::getAssetRules (id:213 name:com_kunena) (1.16KB) (0.01%)
    20μs
    1 x beforeRenderRawModule mod_custom (Network Online!) (7.91KB) (0.01%)
    17μs
    1 x After Access::getAssetRules (id:1882 name:com_jevents) (1.28KB) (0%)
    10μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (0%)
    4μs
120 statements were executed, 14 of which were duplicates, 106 unique29.14ms439.48KB
  • SELECT @@SESSION.sql_mode;51μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tifas_session` WHERE `session_id` = ?103μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tifas_session` WHERE `session_id` = :session_id LIMIT 191μ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` = 1461μs33.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tifas_viewlevels`94μ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` = :guest95μ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`524μs3.96KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `tifas_kunena_configuration` WHERE `id` = 1147μs1.2KB/libraries/kunena/src/Config/KunenaConfig.php:1690Copy
  • SELECT sampleData FROM tifas_kunena_version ORDER BY id DESC LIMIT 180μ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`448μs20.05KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `tifas_kunena_aliases` WHERE `alias` LIKE '29-astro-photography%'931μs704B/libraries/kunena/src/Route/KunenaRoute.php:855Copy
  • SHOW TABLES917μs8.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM `tifas_languages` WHERE `published` = 1 ORDER BY `ordering` ASC661μ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` = 1176μs832B/administrator/components/com_templates/src/Model/StyleModel.php:771Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_sessions`355μs1.34KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_users`766μ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)348μ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)615μ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)945μs584B/plugins/kunena/joomla/KunenaAccessJoomla.php:388Copy
  • SELECT `user_id`,`category_id`,`role` FROM `tifas_kunena_user_categories` WHERE `role` IN (1,2)111μs800B/libraries/kunena/src/Access/KunenaAccess.php:182Copy
  • SELECT * FROM `tifas_kunena_categories` ORDER BY `ordering`,`name`351μs21.27KB/libraries/kunena/src/Forum/Category/KunenaCategoryHelper.php:107Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_categories`750μs1.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '502'144μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '11'136μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '42'127μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '503'143μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '1'125μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '512'124μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '516'148μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '505'125μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '20'123μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '511'134μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '530'134μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '529'128μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '19'130μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '508'125μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '41'133μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '16'127μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '17'124μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '44'146μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '515'129μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '21'122μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '531'121μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '9'133μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '28'128μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '35'123μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '514'123μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '22'128μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '18'122μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '29'120μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '27'132μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '513'126μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '517'123μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '3'143μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '39'135μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '33'125μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '2'122μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '40'121μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '30'132μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '45'137μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '46'126μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '528'122μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_topics`333μs1.7KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_topics` WHERE `id` = '99757'135μs13.81KB/libraries/kunena/src/Tables/TableKunenaTopics.php:223Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_messages`373μ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` = 99810124μs2.53KB/libraries/kunena/src/Tables/TableKunenaMessages.php:216Copy
  • SELECT COUNT(*) FROM `tifas_kunena_messages` AS `a` WHERE `thread` = '99757' AND `a`.`hold` IN (0)178μs536B/libraries/kunena/src/Database/Object/KunenaFinder.php:278Copy
  • SELECT a.id FROM `tifas_kunena_messages` AS `a` WHERE `thread` = '99757' AND `a`.`hold` IN (0) ORDER BY a.`time` ASC LIMIT 78, 6197μ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 (100057,100058,100068,100070,100116,100117)210μs2.61KB/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:120Copy
  • SELECT * FROM `tifas_kunena_thankyou` WHERE `postid` IN (100057,100058,100068,100070,100116,100117)99μ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 (69,1908,1582)251μs25.03KB/libraries/kunena/src/User/KunenaUserHelper.php:247Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (100057,100058,100068,100070,100116,100117)104μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_user_topics` WHERE (`user_id` = '0') AND (`topic_id` IN (99757))93μs1.27KB/libraries/kunena/src/Forum/Topic/User/KunenaTopicUserHelper.php:159Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_user_topics`299μs1.42KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (99810)111μs1.48KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_attachments`312μs1.45KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM tifas_kunena_attachments WHERE `id` = '1000'91μs1.47KB/libraries/kunena/src/Tables/KunenaTable.php:111Copy
  • SELECT * FROM tifas_kunena_attachments WHERE `id` = '1001'87μs1.47KB/libraries/kunena/src/Tables/KunenaTable.php:111Copy
  • SELECT `code`,`location` FROM `tifas_kunena_smileys`72μs960B/libraries/kunena/src/BBCode/KunenaBBCode.php:1122Copy
  • UPDATE `tifas_kunena_topics` SET `hits` = (`hits` + 1) WHERE `id` = '99757'464μ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`621μs1.86KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_polls`297μs1.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_ranks`88μ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` > '1743997858' GROUP BY `userid` ORDER BY `time` DESC157μs576B/libraries/kunena/src/User/KunenaUserHelper.php:544Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (100057)99μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (100057)102μ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 (100057) GROUP BY `m`.`id`,`mm`.`hold`259μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (100058)137μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (100058)98μ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 (100058) GROUP BY `m`.`id`,`mm`.`hold`254μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (100068)103μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (100068)160μ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 (100068) GROUP BY `m`.`id`,`mm`.`hold`378μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (100070)113μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (100070)100μ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 (100070) GROUP BY `m`.`id`,`mm`.`hold`261μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (100116)106μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (100116)99μ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 (100116) GROUP BY `m`.`id`,`mm`.`hold`259μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (100117)126μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (100117)99μ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 (100117) GROUP BY `m`.`id`,`mm`.`hold`263μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • 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 ASC586μ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 04:20:58') AND (`publish_down` ='1000-01-01 00:00:00' OR `publish_down` >= '2025-04-07 04:20:58') ORDER BY `id` DESC LIMIT 1120μs1.42KB/libraries/kunena/src/Forum/Announcement/KunenaAnnouncementHelper.php:145Copy
  • SHOW FULL COLUMNS FROM `tifas_jev_users`352μ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`262μ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 asc172μ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 asc169μ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 10844μs520B/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 ASC290μs10.33KB/components/com_jevents/libraries/dbmodel.php:3274Copy
  • SELECT `name`,`element` FROM `tifas_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1293μ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)136μ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)192μ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 1848μs2.28KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • UPDATE `tifas_banners` SET `impmade` = `impmade` + 1 WHERE `id` IN (:preparedArray1)303μ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` = :trackDate916μ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` asc184μ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` asc166μs3.18KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy
  • SHOW TABLES703μs8.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy