K-Tec

Measuring CCD Linearity

More
14 years 2 months ago #87893 by ayiomamitis
Replied by ayiomamitis on topic Re: Measuring CCD Linearity

mjc wrote: However, I really don't think that this Intensity value is what you want for the task at hand.

Mark,

It is PRECISELY what we desire since the intensity tells us the behaviour of the 100x100 pixels as a group (or the star if using this route). Now, double the exposure and the individual as well as the collective behaviour of the 100x100 pixels (or star) should also double etc etc etc etc.

Anthony.

Anthony Ayiomamitis
Athens, Greece
www.perseus.gr

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

More
14 years 2 months ago #87894 by ayiomamitis
Replied by ayiomamitis on topic Re: Measuring CCD Linearity
Gents,

It is unfortunate that one cannot upload (attach) Excel spreadsheets or, otherwise, I would have provided you with my linearity testing and results from a few years ago and where everything including data and graphs is laid out when I sought to do the same.

Anthony.

Anthony Ayiomamitis
Athens, Greece
www.perseus.gr

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

  • dmcdona
  • Topic Author
  • Offline
  • Administrator
  • Administrator
More
14 years 2 months ago #88049 by dmcdona
Replied by dmcdona on topic Re: Measuring CCD Linearity
Folks - the last week has been a fairly steep learning curve for me. I still didn't get AIP4Win, but I *did* get a lot of help on another forum.

The technique is easy enough but it can be quite time-consuming. But by generating a Photon transfer curve and a Dark transfer curve, I've gleaned some interesting data about my CCD.



The full well is about 148K e-
Gain is about 2.3 e-/DN
Read noise is about 15.9 e-
Linearity worked out pretty good - the CCD seem very linear between about 10 and 90% full well.

I have to get more data at the lower and upper ends because what I have is too sparse to give clear cut-off points, particularly for full-well.

The data collected has many more uses too - I'm going to figure out what they are and start plotting lots of curves :-)

Cheers
Dave

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

More
14 years 2 months ago #88051 by mjc
Replied by mjc on topic Re: Measuring CCD Linearity
Glad you're getting somewhere.

You might want to revisit your readout noise - that looks a little high.
Do you know what the spec says so that you have a benchmark to compare your results to?

I have an Atik 16IC - a budget CCD. Its spec has readout noise at 7e.
When I tested I got something less - but I'm not happy that I got the gain right so I have to recheck (I'm going to try Janesick's method - which is detailed in the HAIP). Linearity was very good with a very sharp deviation from linearity somewhere near to - but above - 52000 ADU's which is at least 79% of ADU range. I think that's okay for a chip with ABG. I was expecting deviation from linearity to start earlier - but less severe. So I'm quite pleased. However, it is still subjective and I suspect that one would need to perform some mathematical test to quantify the conformance to linearity. The term "least squares fit" seems to apply to such situations - but I think that's for another day.

It was a - what's the word - polava? - to get usable data. It took many attempts.

My dark current measurements where unbelievable - (I don't believe them) - 1/100 of what others have measured.

Thanks for your original post - made me complete what I started back in November (you can tell I don't take out the scope much...)

Mark C.

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

  • dmcdona
  • Topic Author
  • Offline
  • Administrator
  • Administrator
More
14 years 2 months ago #88053 by dmcdona
Replied by dmcdona on topic Re: Measuring CCD Linearity
Mark - the spec from Kodak is actually 15 e- for readout noise. So looks like its within spec, allowing for the fact that my data needs to be refined a little more.

I'm hoping to scrub the PTC tonight if possible, with new data. I'll see if that makes a difference.

I also still need to analyse the data a bit more to construct more of the parameters and then compare them to the spec. But judging by what others have said, the 1001E seems to preforming pretty well.

There are still some question I have out to Finger Lakes about the settings - the 1001E has two amps on board - its unlikely they are user selectable but you can choose (from the camera manufacturer) a full well of about 200K or 500K - its probaly then hardwired when the CCD is put on the board. I got about 150K so I've asked FLI if there is any discrepency. Probably not. Besides, 150K for 16 bits seems a good value to choose (via the gain) - if it was set to 500K, there'd be a loss of resolution - you're squeezing the electron count into the same 65535 ADU's.

Do you have the Janesick book? I was thinking or getting it. (what's the HAIP? is that the Berry book?)

I hear you on linearity - I have a chart but I'd prefer some kind of statistical description. I'm sure its out there somewhere. But as you say, another day...

Glad I helped to get you back on track :-) And I hear you on the polava comment! But now I've done it a few times, its not that hard. I'd recommend others here have a go and characterise their CCD's scientifically, rather then just go on the manufacturer's data...

Cheers
Dave

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

More
14 years 2 months ago #88057 by mjc
Replied by mjc on topic Re: Measuring CCD Linearity
Dave

I don't have either Janesick or S.B. Howell - I've had them in mind for purchase over the past few months.

I know I'd learn a lot of good stuff from Janesick - but I'm not sure that I'd get much from S. B. Howell over an above either what I know or what I can easily find out elsewhere - but it is a classic reference. I get from looking at the table of contents (via amazon) that Janesick looks more like an engineering book rather than one of practical application. Coming from a techie background that appeals.

As you have S.B. Howell can I ask if you feel that you got value out of it?

I don't like to post a reference to stuff that I haven't properly read - but I have quickly skimmed it - and it appears to discuss using two A/D converters to extend dynamic range. I'll try to read this tomorrow (if for no other reason than for my own education). It appears relevant. Looking up the title and authors in ADS I believe it was published in 1998. (Proc. SPIE Vol. 3301, p. 75-79, Solid State Sensor Arrays: Development and Applications II). An Aussie educational site has public access to it.

A Method for Extending the Dynamic Range of CCD Instruments

In case the link doesn't work (no preview) it is
rsaa.anu.edu.au/observing/detectors/ccdl...inearity/wide_dr.pdf

Re my comment about your readout noise. This maybe related to the gain (I'm out of my depth now). Your gain - at about 2.2 e / ADU compared to my approx 0.2 e / ADU (roughly five ADUs per electron - I have a small full-well capacity!). Bottom line - your readout noise maybe really quite acceptable.

I'm on a journey of discovery...

Mark C.

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

Time to create page: 0.123 seconds
Powered by Kunena Forum
9MBMemory Usage174msRequest 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" => "30" ]
$_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" => 1744036178 "last" => 1744036178...
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.5ms)
  • afterInitialise (1.16MB) (13.74ms)
  • afterRoute (187.38KB) (3.14ms)
  • beforeRenderComponent com_kunena (30.34KB) (1.19ms)
  • Before Access::preloadComponents (all components) (1.37MB) (65.59ms)
  • After Access::preloadComponents (all components) (119.01KB) (892μs)
  • Before Access::getAssetRules (id:213 name:com_kunena) (1.16KB) (19μs)
  • After Access::getAssetRules (id:213 name:com_kunena) (6.89KB) (65μs)
  • afterRenderComponent com_kunena (2.04MB) (57.23ms)
  • afterDispatch (18.34KB) (213μs)
  • beforeRenderRawModule mod_cblogin (Login) (76.07KB) (487μs)
  • afterRenderRawModule mod_cblogin (Login) (15.16KB) (201μs)
  • beforeRenderRawModule mod_custom (Network Online!) (7.91KB) (17μs)
  • afterRenderRawModule mod_custom (Network Online!) (13.13KB) (224μs)
  • beforeRenderRawModule mod_jevents_latest (Upcoming Events) (10.03KB) (30μs)
  • Before Access::getAssetRules (id:1882 name:com_jevents) (161.3KB) (1.28ms)
  • After Access::getAssetRules (id:1882 name:com_jevents) (1.28KB) (10μs)
  • afterRenderRawModule mod_jevents_latest (Upcoming Events) (1MB) (6.3ms)
  • beforeRenderRawModule mod_menu (Main Menu) (6.38KB) (44μs)
  • afterRenderRawModule mod_menu (Main Menu) (169.67KB) (1.88ms)
  • beforeRenderRawModule mod_finder (Search) (832B) (26μs)
  • afterRenderRawModule mod_finder (Search) (358.04KB) (3.74ms)
  • beforeRenderRawModule mod_banners (Sponsors) (2.89KB) (26μs)
  • afterRenderRawModule mod_banners (Sponsors) (145.11KB) (3.81ms)
  • beforeRenderRawModule mod_menu (footermenu) (496B) (41μs)
  • afterRenderRawModule mod_menu (footermenu) (61.41KB) (483μs)
  • beforeRenderModule mod_menu (footermenu) (10.27KB) (342μs)
  • afterRenderModule mod_menu (footermenu) (3.43KB) (64μs)
  • beforeRenderModule mod_cblogin (Login) (11.96KB) (112μs)
  • afterRenderModule mod_cblogin (Login) (2.7KB) (54μs)
  • beforeRenderModule mod_custom (Network Online!) (8.96KB) (16μs)
  • afterRenderModule mod_custom (Network Online!) (2.82KB) (25μs)
  • beforeRenderModule mod_jevents_latest (Upcoming Events) (9.77KB) (26μs)
  • afterRenderModule mod_jevents_latest (Upcoming Events) (3.57KB) (21μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (9.41KB) (112μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (37.89KB) (725μs)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (4μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.93KB) (32μs)
  • beforeRenderModule mod_banners (Sponsors) (8.48KB) (54μs)
  • afterRenderModule mod_banners (Sponsors) (2.57KB) (25μs)
  • beforeRenderModule mod_finder (Search) (4.02KB) (44μs)
  • afterRenderModule mod_finder (Search) (2.37KB) (21μs)
  • beforeRenderModule mod_menu (Main Menu) (7.88KB) (42μs)
  • afterRenderModule mod_menu (Main Menu) (2.8KB) (21μs)
  • afterRender (802.01KB) (6.3ms)
  • 1 x Before Access::preloadComponents (all components) (1.37MB) (37.66%)
    65.59ms
    1 x afterRenderComponent com_kunena (2.04MB) (32.85%)
    57.23ms
    1 x afterInitialise (1.16MB) (7.89%)
    13.74ms
    1 x afterRender (802.01KB) (3.62%)
    6.30ms
    1 x afterRenderRawModule mod_jevents_latest (Upcoming Events) (1MB) (3.62%)
    6.30ms
    1 x afterRenderRawModule mod_banners (Sponsors) (145.11KB) (2.18%)
    3.81ms
    1 x afterRenderRawModule mod_finder (Search) (358.04KB) (2.15%)
    3.74ms
    1 x afterRoute (187.38KB) (1.8%)
    3.14ms
    1 x afterRenderRawModule mod_menu (Main Menu) (169.67KB) (1.08%)
    1.88ms
    1 x afterLoad (456.32KB) (0.86%)
    1.50ms
    1 x Before Access::getAssetRules (id:1882 name:com_jevents) (161.3KB) (0.73%)
    1.28ms
    1 x beforeRenderComponent com_kunena (30.34KB) (0.69%)
    1.19ms
    1 x After Access::preloadComponents (all components) (119.01KB) (0.51%)
    892μs
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (37.89KB) (0.42%)
    725μs
    1 x beforeRenderRawModule mod_cblogin (Login) (76.07KB) (0.28%)
    487μs
    1 x afterRenderRawModule mod_menu (footermenu) (61.41KB) (0.28%)
    483μs
    1 x beforeRenderModule mod_menu (footermenu) (10.27KB) (0.2%)
    342μs
    1 x afterRenderRawModule mod_custom (Network Online!) (13.13KB) (0.13%)
    224μs
    1 x afterDispatch (18.34KB) (0.12%)
    213μs
    1 x afterRenderRawModule mod_cblogin (Login) (15.16KB) (0.12%)
    201μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (9.41KB) (0.06%)
    112μs
    1 x beforeRenderModule mod_cblogin (Login) (11.96KB) (0.06%)
    112μs
    1 x After Access::getAssetRules (id:213 name:com_kunena) (6.89KB) (0.04%)
    65μs
    1 x afterRenderModule mod_menu (footermenu) (3.43KB) (0.04%)
    64μs
    1 x afterRenderModule mod_cblogin (Login) (2.7KB) (0.03%)
    54μs
    1 x beforeRenderModule mod_banners (Sponsors) (8.48KB) (0.03%)
    54μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (6.38KB) (0.03%)
    44μs
    1 x beforeRenderModule mod_finder (Search) (4.02KB) (0.03%)
    44μs
    1 x beforeRenderModule mod_menu (Main Menu) (7.88KB) (0.02%)
    42μs
    1 x beforeRenderRawModule mod_menu (footermenu) (496B) (0.02%)
    41μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.93KB) (0.02%)
    32μs
    1 x beforeRenderRawModule mod_jevents_latest (Upcoming Events) (10.03KB) (0.02%)
    30μs
    1 x beforeRenderRawModule mod_finder (Search) (832B) (0.01%)
    26μs
    1 x beforeRenderRawModule mod_banners (Sponsors) (2.89KB) (0.01%)
    26μs
    1 x beforeRenderModule mod_jevents_latest (Upcoming Events) (9.77KB) (0.01%)
    26μs
    1 x afterRenderModule mod_custom (Network Online!) (2.82KB) (0.01%)
    25μs
    1 x afterRenderModule mod_banners (Sponsors) (2.57KB) (0.01%)
    25μs
    1 x afterRenderModule mod_jevents_latest (Upcoming Events) (3.57KB) (0.01%)
    21μs
    1 x afterRenderModule mod_finder (Search) (2.37KB) (0.01%)
    21μs
    1 x afterRenderModule mod_menu (Main Menu) (2.8KB) (0.01%)
    21μs
    1 x Before Access::getAssetRules (id:213 name:com_kunena) (1.16KB) (0.01%)
    19μ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%)
    16μs
    1 x After Access::getAssetRules (id:1882 name:com_jevents) (1.28KB) (0.01%)
    10μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (0%)
    4μs
116 statements were executed, 14 of which were duplicates, 102 unique26.95ms433.6KB
  • SELECT @@SESSION.sql_mode;146μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tifas_session` WHERE `session_id` = ?116μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tifas_session` WHERE `session_id` = :session_id LIMIT 166μ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)655μ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` = 12.01ms33.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` = :guest92μ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`546μs3.96KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `tifas_kunena_configuration` WHERE `id` = 1116μs1.2KB/libraries/kunena/src/Config/KunenaConfig.php:1690Copy
  • SELECT sampleData FROM tifas_kunena_version ORDER BY id DESC LIMIT 188μ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`423μs20.05KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `tifas_kunena_aliases` WHERE `alias` LIKE '29-astro-photography%'118μs704B/libraries/kunena/src/Route/KunenaRoute.php:855Copy
  • SHOW TABLES671μs8.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM `tifas_languages` WHERE `published` = 1 ORDER BY `ordering` ASC108μ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` = 1166μs832B/administrator/components/com_templates/src/Model/StyleModel.php:771Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_sessions`351μs1.34KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_users`398μ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)491μ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)658μ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)744μs584B/plugins/kunena/joomla/KunenaAccessJoomla.php:388Copy
  • SELECT `user_id`,`category_id`,`role` FROM `tifas_kunena_user_categories` WHERE `role` IN (1,2)101μs800B/libraries/kunena/src/Access/KunenaAccess.php:182Copy
  • SELECT * FROM `tifas_kunena_categories` ORDER BY `ordering`,`name`305μs21.27KB/libraries/kunena/src/Forum/Category/KunenaCategoryHelper.php:107Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_categories`374μs1.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '502'133μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '11'124μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '42'111μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '503'128μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '1'107μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '512'106μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '516'139μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '505'108μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '20'280μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '511'107μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '530'108μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '529'104μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '19'105μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '508'106μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '41'113μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '16'125μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '17'106μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '44'108μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '515'106μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '21'108μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '531'103μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '9'104μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '28'106μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '35'106μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '514'105μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '22'116μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '18'114μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '29'132μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '27'119μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '513'115μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '517'114μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '3'114μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '39'113μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '33'119μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '2'131μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '40'109μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '30'111μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '45'110μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '46'114μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '528'135μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_topics`352μs1.7KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_topics` WHERE `id` = '87780'152μs13.81KB/libraries/kunena/src/Tables/TableKunenaTopics.php:223Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_messages`323μ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` = 87780158μ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)193μ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 30, 6184μ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 (87893,87894,88049,88051,88053,88057)207μs2.61KB/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:120Copy
  • SELECT * FROM `tifas_kunena_thankyou` WHERE `postid` IN (87893,87894,88049,88051,88053,88057)90μ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 (152,338,1582)256μs25.03KB/libraries/kunena/src/User/KunenaUserHelper.php:247Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (87893,87894,88049,88051,88053,88057)99μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_user_topics` WHERE (`user_id` = '0') AND (`topic_id` IN (87780))86μs1.27KB/libraries/kunena/src/Forum/Topic/User/KunenaTopicUserHelper.php:159Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_user_topics`308μs1.42KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT `code`,`location` FROM `tifas_kunena_smileys`80μs960B/libraries/kunena/src/BBCode/KunenaBBCode.php:1122Copy
  • UPDATE `tifas_kunena_topics` SET `hits` = (`hits` + 1) WHERE `id` = '87780'527μ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`754μs1.86KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_polls`295μs1.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_ranks`98μ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` > '1744034378' GROUP BY `userid` ORDER BY `time` DESC162μs576B/libraries/kunena/src/User/KunenaUserHelper.php:544Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (87893)121μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (87893)86μ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 (87893) GROUP BY `m`.`id`,`mm`.`hold`252μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (87894)119μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (87894)94μ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 (87894) GROUP BY `m`.`id`,`mm`.`hold`235μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (88049)110μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (88049)97μ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 (88049) GROUP BY `m`.`id`,`mm`.`hold`265μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (88051)106μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (88051)120μ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 (88051) GROUP BY `m`.`id`,`mm`.`hold`256μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (88053)100μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (88053)286μ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 (88053) GROUP BY `m`.`id`,`mm`.`hold`215μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (88057)126μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (88057)103μ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 (88057) GROUP BY `m`.`id`,`mm`.`hold`287μ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 ASC580μ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:29:38') AND (`publish_down` ='1000-01-01 00:00:00' OR `publish_down` >= '2025-04-07 14:29:38') ORDER BY `id` DESC LIMIT 1102μs1.42KB/libraries/kunena/src/Forum/Announcement/KunenaAnnouncementHelper.php:145Copy
  • SHOW FULL COLUMNS FROM `tifas_jev_users`327μ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`258μ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 asc164μ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 asc162μ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 10942μ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 ASC306μs10.33KB/components/com_jevents/libraries/dbmodel.php:3274Copy
  • SELECT `name`,`element` FROM `tifas_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1303μ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)118μ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)185μ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 1413μs2.28KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • UPDATE `tifas_banners` SET `impmade` = `impmade` + 1 WHERE `id` IN (:preparedArray1)686μ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` = :trackDate540μ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` asc179μ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` asc148μs3.18KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy
  • SHOW TABLES670μs8.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy