K-Tec

Comparison of CCD chips

  • michaeloconnell
  • Topic Author
  • Offline
  • Administrator
  • Administrator
More
18 years 2 months ago #39184 by michaeloconnell
Comparison of CCD chips was created by michaeloconnell
Hi,

I'm comparing a couple of CCD chips at the mo and would like some advice please:

* Large, high resolution Kodak KAI4021M CCD chip, with 4,194,304 x 7.4uM square pixels in a 15.15 x 15.15mm array.

* Monochrome

* High sensitivity, 55% QE at peak (green light). 45% at 400nm. 30% at 650nm.

* Anti-blooming


Versus

* Very large, high resolution 'SuperHAD' CCD chip, with 6,000,000 x 7.8uM square pixels in a 23.4 x 15.6mm array. Size equivalent to APS film.

* Single-shot colour, using a Bayer matrix of R, G and B on-chip filters. No filter wheel required.

* High sensitivity, equivalent to 60% QE at peak of green filters. 50% roll-off at 400nM and 650nm

* Anti-blooming


The first one is relatively large, monochrome, but the QE drops off in the red.

The second has a bigger area, higher QE in the red and is colour, which would save on a filter wheel and RGB filters.

What do you think?

Cheers,

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

  • DaveGrennan
  • Offline
  • IFAS Astronomer of the Year 2010
  • IFAS Astronomer of the Year 2010
More
18 years 2 months ago #39187 by DaveGrennan
Replied by DaveGrennan on topic Re: Comparison of CCD chips
The first one has square pixels so no need to go stretching afterwards to get the right aspect ratio. It's monochrome and you would think it should be more sensitive than the colour chip but it doesn't appear to be. If then specs are to be beleived the second one has it beat hands down.

Its a really hard call. On the face of it I'd go for the second because of the better QE, larger pixels and the fact it is colour. What do these pixel sizes relate to in arcseconds per pixel on your scopes?

Regards and Clear Skies,

Dave.
J41 - Raheny Observatory.
www.webtreatz.com
Equipment List here

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

More
18 years 2 months ago #39189 by dmcdona
Replied by dmcdona on topic Re: Comparison of CCD chips
Michael

Try and get more data if you can. For the same chip, the mono version will always perform better.

For the two chips you're looking at, see if you can get any reviews (in any camera body) or try and talk to vendors that offer both types of chip (I think SBIG use only Kodak).

I would need confirmation that a manufacturer can apply a Bayer matrix to a single 7.4 um pixel extremely accurately and reproduce that for the other 5,999,999 pixels :D

Judging by recent advances though, a few of the top-end photographers seem to use single shot colour CCD's - so they can't all be bad. That said, the majority use mono CCD's - but perhaps that's because of Ha imaging.

And on that subject, I don't know how a colour CCD works with filters - if you wanted to do any non-RGB filter work (hydrogen, oxygen, sulphur) perhaps a colour CCD would prevent you.

Its never a smooth path...

Let us know how you get on with the research.

Dave

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

More
18 years 2 months ago #39204 by phoenix
Replied by phoenix on topic Comparison of CCD chips
Michael,

The Kodak chip is the same one that is in my H16 and despite the figures I find it very sensitive.
I have used one shot ccds with higher QE but needed a much greater exposure time which means tracking/guiding needs to be spot on.
I will not be going back to imaging with a one shot ccd.

Kieran

Kieran
16" ODK (incoming), Mesu Mount 200, APM TMB 80mm, SXV H16, SXV H9
J16 An Carraig Observatory
ancarraigobservatory.co.uk/

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

  • michaeloconnell
  • Topic Author
  • Offline
  • Administrator
  • Administrator
More
18 years 2 months ago #39236 by michaeloconnell
Replied by michaeloconnell on topic Re: Comparison of CCD chips
A piece of info re the colour ccd chip:

Most competitive brands of CCD camera require a ‘dark frame’ to be subtracted from your images to achieve the best results. A dark frame is simply a picture which was taken with the same exposure as your ‘light frame’, but with the telescope objective covered, so that no light can enter. It records only the ‘hot pixels’ and thermal gradients of your CCD, so that these defects are largely removed when the dark frame is subtracted from the light frame. The SXV-M25C CCD is quite different from those used in other brands of camera and generates an extremely low level of dark noise. Indeed, it is so low that subtracting a dark frame can actually INCREASE the noise in your images! This is because the statistical noise of the dark frame can exceed the ‘pattern noise’ from warm pixels and hence add to that of the subtracted result. If your test pictures have an exposure time of less than about 30 minutes (as above), then don’t bother with a dark frame, just ‘kill’ any hot pixels with your processing software.

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

  • michaeloconnell
  • Topic Author
  • Offline
  • Administrator
  • Administrator
More
18 years 2 months ago #39237 by michaeloconnell
Replied by michaeloconnell on topic Re: Comparison of CCD chips
In terms of h-alpha imaging with the colour camera, the bumff says:

Would you like a single-shot colour imager, but also need to capture H-alpha images with it? The excellent red light sensitivity of the SXV-M25, combined with our special narrow-band processing software, can give you the best of both worlds!

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

Time to create page: 0.109 seconds
Powered by Kunena Forum
9MBMemory Usage163msRequest 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
[]
$_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" => 1743979533 "last" => 1743979533...
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.27KB) (1.68ms)
  • afterInitialise (1.16MB) (14.04ms)
  • afterRoute (187.07KB) (3.68ms)
  • beforeRenderComponent com_kunena (30.37KB) (1.46ms)
  • Before Access::preloadComponents (all components) (1.37MB) (50.25ms)
  • After Access::preloadComponents (all components) (119.01KB) (792μs)
  • Before Access::getAssetRules (id:213 name:com_kunena) (1.16KB) (21μs)
  • After Access::getAssetRules (id:213 name:com_kunena) (6.89KB) (69μs)
  • afterRenderComponent com_kunena (2.02MB) (58.78ms)
  • afterDispatch (18.34KB) (251μs)
  • beforeRenderRawModule mod_cblogin (Login) (76.07KB) (563μs)
  • afterRenderRawModule mod_cblogin (Login) (15.16KB) (232μs)
  • beforeRenderRawModule mod_custom (Network Online!) (7.91KB) (17μs)
  • afterRenderRawModule mod_custom (Network Online!) (13.13KB) (270μs)
  • beforeRenderRawModule mod_jevents_latest (Upcoming Events) (10.03KB) (30μs)
  • Before Access::getAssetRules (id:1882 name:com_jevents) (161.3KB) (1.12ms)
  • After Access::getAssetRules (id:1882 name:com_jevents) (1.28KB) (11μs)
  • afterRenderRawModule mod_jevents_latest (Upcoming Events) (1MB) (7.01ms)
  • beforeRenderRawModule mod_menu (Main Menu) (6.38KB) (52μs)
  • afterRenderRawModule mod_menu (Main Menu) (169.67KB) (1.76ms)
  • beforeRenderRawModule mod_finder (Search) (832B) (25μs)
  • afterRenderRawModule mod_finder (Search) (357.41KB) (3.01ms)
  • beforeRenderRawModule mod_banners (Sponsors) (2.89KB) (27μs)
  • afterRenderRawModule mod_banners (Sponsors) (145.11KB) (3.09ms)
  • beforeRenderRawModule mod_menu (footermenu) (496B) (45μs)
  • afterRenderRawModule mod_menu (footermenu) (60.16KB) (482μs)
  • beforeRenderModule mod_menu (footermenu) (10.27KB) (178μs)
  • afterRenderModule mod_menu (footermenu) (3.43KB) (76μs)
  • beforeRenderModule mod_cblogin (Login) (11.96KB) (62μs)
  • afterRenderModule mod_cblogin (Login) (2.7KB) (54μs)
  • beforeRenderModule mod_custom (Network Online!) (8.96KB) (15μs)
  • afterRenderModule mod_custom (Network Online!) (2.82KB) (25μs)
  • beforeRenderModule mod_jevents_latest (Upcoming Events) (9.77KB) (27μs)
  • afterRenderModule mod_jevents_latest (Upcoming Events) (3.57KB) (22μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (9.41KB) (99μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (39.14KB) (500μs)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (4μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.93KB) (32μs)
  • beforeRenderModule mod_banners (Sponsors) (8.48KB) (53μ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) (20μs)
  • afterRender (794.01KB) (6.22ms)
  • 1 x afterRenderComponent com_kunena (2.02MB) (36.05%)
    58.78ms
    1 x Before Access::preloadComponents (all components) (1.37MB) (30.82%)
    50.25ms
    1 x afterInitialise (1.16MB) (8.61%)
    14.04ms
    1 x afterRenderRawModule mod_jevents_latest (Upcoming Events) (1MB) (4.3%)
    7.01ms
    1 x afterRender (794.01KB) (3.81%)
    6.22ms
    1 x afterRoute (187.07KB) (2.26%)
    3.68ms
    1 x afterRenderRawModule mod_banners (Sponsors) (145.11KB) (1.89%)
    3.09ms
    1 x afterRenderRawModule mod_finder (Search) (357.41KB) (1.84%)
    3.01ms
    1 x afterRenderRawModule mod_menu (Main Menu) (169.67KB) (1.08%)
    1.76ms
    1 x afterLoad (456.27KB) (1.03%)
    1.68ms
    1 x beforeRenderComponent com_kunena (30.37KB) (0.9%)
    1.46ms
    1 x Before Access::getAssetRules (id:1882 name:com_jevents) (161.3KB) (0.69%)
    1.12ms
    1 x After Access::preloadComponents (all components) (119.01KB) (0.49%)
    792μs
    1 x beforeRenderRawModule mod_cblogin (Login) (76.07KB) (0.35%)
    563μs
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (39.14KB) (0.31%)
    500μs
    1 x afterRenderRawModule mod_menu (footermenu) (60.16KB) (0.3%)
    482μs
    1 x afterRenderRawModule mod_custom (Network Online!) (13.13KB) (0.17%)
    270μs
    1 x afterDispatch (18.34KB) (0.15%)
    251μs
    1 x afterRenderRawModule mod_cblogin (Login) (15.16KB) (0.14%)
    232μs
    1 x beforeRenderModule mod_menu (footermenu) (10.27KB) (0.11%)
    178μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (9.41KB) (0.06%)
    99μs
    1 x afterRenderModule mod_menu (footermenu) (3.43KB) (0.05%)
    76μs
    1 x After Access::getAssetRules (id:213 name:com_kunena) (6.89KB) (0.04%)
    69μs
    1 x beforeRenderModule mod_cblogin (Login) (11.96KB) (0.04%)
    62μs
    1 x afterRenderModule mod_cblogin (Login) (2.7KB) (0.03%)
    54μs
    1 x beforeRenderModule mod_banners (Sponsors) (8.48KB) (0.03%)
    53μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (6.38KB) (0.03%)
    52μs
    1 x beforeRenderRawModule mod_menu (footermenu) (496B) (0.03%)
    45μs
    1 x beforeRenderModule mod_finder (Search) (4.02KB) (0.03%)
    44μs
    1 x beforeRenderModule mod_menu (Main Menu) (7.88KB) (0.03%)
    42μ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_banners (Sponsors) (2.89KB) (0.02%)
    27μs
    1 x beforeRenderModule mod_jevents_latest (Upcoming Events) (9.77KB) (0.02%)
    27μs
    1 x beforeRenderRawModule mod_finder (Search) (832B) (0.02%)
    25μs
    1 x afterRenderModule mod_custom (Network Online!) (2.82KB) (0.02%)
    25μs
    1 x afterRenderModule mod_banners (Sponsors) (2.57KB) (0.02%)
    25μs
    1 x afterRenderModule mod_jevents_latest (Upcoming Events) (3.57KB) (0.01%)
    22μ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%)
    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%)
    11μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (0%)
    4μs
115 statements were executed, 14 of which were duplicates, 101 unique26.26ms432.79KB
  • SELECT @@SESSION.sql_mode;88μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tifas_session` WHERE `session_id` = ?152μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tifas_session` WHERE `session_id` = :session_id LIMIT 170μ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)618μ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` = 1307μs33.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tifas_viewlevels`99μ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` = :guest87μ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`586μs3.96KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `tifas_kunena_configuration` WHERE `id` = 195μs1.2KB/libraries/kunena/src/Config/KunenaConfig.php:1690Copy
  • SELECT sampleData FROM tifas_kunena_version ORDER BY id DESC LIMIT 1170μ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`632μs20.05KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `tifas_kunena_aliases` WHERE `alias` LIKE '29-astro-photography%'119μs704B/libraries/kunena/src/Route/KunenaRoute.php:855Copy
  • SHOW TABLES786μs8.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM `tifas_languages` WHERE `published` = 1 ORDER BY `ordering` ASC122μ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` = 1188μ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`422μ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)407μ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)647μ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)742μs584B/plugins/kunena/joomla/KunenaAccessJoomla.php:388Copy
  • SELECT `user_id`,`category_id`,`role` FROM `tifas_kunena_user_categories` WHERE `role` IN (1,2)143μs800B/libraries/kunena/src/Access/KunenaAccess.php:182Copy
  • SELECT * FROM `tifas_kunena_categories` ORDER BY `ordering`,`name`319μs21.27KB/libraries/kunena/src/Forum/Category/KunenaCategoryHelper.php:107Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_categories`375μs1.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '502'157μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '11'128μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '42'124μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '503'133μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '1'122μ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'153μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '505'144μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '20'161μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '511'124μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '530'138μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '529'124μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '19'142μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '508'150μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '41'152μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '16'143μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '17'127μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '44'132μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '515'139μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '21'132μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '531'127μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '9'131μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '28'141μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '35'131μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '514'127μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '22'129μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '18'140μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '29'137μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '27'134μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '513'344μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '517'131μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '3'158μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '39'141μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '33'146μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '2'133μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '40'130μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '30'130μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '45'129μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '46'131μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '528'148μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_topics`549μs1.7KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_topics` WHERE `id` = '39184'139μs13.81KB/libraries/kunena/src/Tables/TableKunenaTopics.php:223Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_messages`393μ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` = 39184140μs2.53KB/libraries/kunena/src/Tables/TableKunenaMessages.php:216Copy
  • SELECT COUNT(*) FROM `tifas_kunena_messages` AS `a` WHERE `thread` = '39184' AND `a`.`hold` IN (0)232μs536B/libraries/kunena/src/Database/Object/KunenaFinder.php:278Copy
  • SELECT a.id FROM `tifas_kunena_messages` AS `a` WHERE `thread` = '39184' AND `a`.`hold` IN (0) ORDER BY a.`time` ASC LIMIT 6186μ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 (39187,39189,39204,39236,39237)251μs2.59KB/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:120Copy
  • SELECT * FROM `tifas_kunena_thankyou` WHERE `postid` IN (39184,39187,39189,39204,39236,39237)102μ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 (95,386,338,707)276μs25.05KB/libraries/kunena/src/User/KunenaUserHelper.php:247Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (39184,39187,39189,39204,39236,39237)117μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_user_topics` WHERE (`user_id` = '0') AND (`topic_id` IN (39184))100μ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`79μs960B/libraries/kunena/src/BBCode/KunenaBBCode.php:1122Copy
  • UPDATE `tifas_kunena_topics` SET `hits` = (`hits` + 1) WHERE `id` = '39184'530μ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`653μs1.86KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_polls`305μs1.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_ranks`90μ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` > '1743977733' GROUP BY `userid` ORDER BY `time` DESC173μs576B/libraries/kunena/src/User/KunenaUserHelper.php:544Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (39184)109μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (39184)105μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (39187)107μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (39187)95μ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 (39187) GROUP BY `m`.`id`,`mm`.`hold`271μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (39189)109μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (39189)92μ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 (39189) GROUP BY `m`.`id`,`mm`.`hold`237μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (39204)109μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (39204)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 (39204) GROUP BY `m`.`id`,`mm`.`hold`242μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (39236)113μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (39236)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 (39236) GROUP BY `m`.`id`,`mm`.`hold`231μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (39237)111μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (39237)96μ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 (39237) GROUP BY `m`.`id`,`mm`.`hold`261μ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 ASC626μ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-06 22:45:33') AND (`publish_down` ='1000-01-01 00:00:00' OR `publish_down` >= '2025-04-06 22:45:33') ORDER BY `id` DESC LIMIT 197μs1.42KB/libraries/kunena/src/Forum/Announcement/KunenaAnnouncementHelper.php:145Copy
  • SHOW FULL COLUMNS FROM `tifas_jev_users`354μ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`465μ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 asc186μ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 asc172μ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-08 00:00:00' AND ev.created <= '2025-10-03 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 10828μ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-08 00:00:00' AND ev.created <= '2025-10-03 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 ASC302μ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)128μ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)184μ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 1439μs2.28KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • UPDATE `tifas_banners` SET `impmade` = `impmade` + 1 WHERE `id` IN (:preparedArray1)474μ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` = :trackDate360μ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` asc188μ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` asc160μs3.18KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy
  • SHOW TABLES731μs8.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy