K-Tec

Which CCD Camera Lens to use?

More
17 years 9 months ago #47673 by crouges
Which CCD Camera Lens to use? was created by crouges
I've aquired a monochrome CCD camera (Jai CV-M4+CL) & a frame grabber card.
I thought it might compliment the ETX125 telescope somewhat, at least so as to familiarize myself with what's involved in Astrophotography,

I wonder if you guys cold help me out & give me some heads up as to which CCD Lens in conjunction with the telescope.

As the camera is 1.4Mega Pixel, do I need a high resolution lens?
What's the rule of thumb here, What are the considerartions?

Any help you guys can provide me o this would be very much appeciated.
Cheer & thanks.

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

More
17 years 9 months ago #47679 by Mike
Replied by Mike on topic Re: Which CCD Camera Lens to use?
Hi crouges

It all depends on what you want to do with your camera + additional lens and your ETX telescope. I was in a similar situation recently and I did a little bit of research into the equipment aspects and what could be achieved using a sensitive monochrome video CCD camera in combination with available lens designs and with a telescope.

I decided to purchase two Watec 902DM2S monochrome ½” CCD video cameras which have high S/N ratios and very low lux ratings of 0.0006 which was to be used for automated meteor patrol in conjunction with specialized software.
In order to get the best out of the camera (with extended IR capability) I found the ideal lens to use is a fast f - ratio aspherical type with auto iris capability. These lenses can enhance your camera low light performance by 50%, I therefore purchased two “Computar” Aspherical lenses of 2.6mm F1.0 (144 x 97 degree sky coverage) and a 12mm F0.8 (39 x 24 degree sky coverage), Quality is excellent and they are reasonably priced. You can record directly from the camera onto the PC (with an appropriate frame grabber, I use a K-World USB Frame Grabber) in AVI format real time viewing of the night sky. You can take; for example, 10 second video clips or longer and stack all the frames using RegiStax software to bring out fainter objects into a bitmap / Jpeg image etc.

In summary for your lens question…
1. Use fast f - ratio lens of aspherical type, you must match the lens to the CCD, for example is your CCD chip 1/3”, ½” or 2/3”.
2. You must also find out from the camera specification if there is auto iris control and if so is it DC or Video enabled (if may have an auto detect circuit for use with either one) or you may decide not to use this feature at all.
3. You must also find out from the camera specification if the camera accepts C-mount or CS-mount lens, I think there are spacers available for switching between the two.

If you want to use your telescope with your new camera for planetary and deep field work you will need a T-adapter to match your camera. For example I removed the visual back of my Celestron telescope and fitted a focal reducer with a T-adapter for use with a CS-mount camera (which the Watec 902DM2S is), Celestron provided all the items I needed in order to do this and I am sure Meade can provide the same service.
If you are using your new camera in conjunction with your telescope I would recommend the following piece of software www.coaa.co.uk/astrovideo.htm which has many useful features and is user friendly for video astronomy, best of all, enjoy your new toy.

Some of the other guys and gals here may be able to provide additional information for you as I am only starting out in this area myself.

Clear skies
Mike

I83 Cherryvalley Observatory

After one look at this planet any visitor from outer space would say; "I WANT TO SEE THE MANAGER".

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

More
17 years 9 months ago #47789 by crouges
Replied by crouges on topic Re: Which CCD Camera Lens to use?
Mike,

Thanks alot for taking the time & your advice, I most certinly need it & appreciate it.

I wonder if I could ask you to tell me a little more of, what is termed 'fast f - ratio'. Also rather than getting a 2.6 mm etc, is there any advantage is a varifocal lens>? Also do you have a site than I can review these lens?

In the case of getting magnification, do the same rules apply, 'focal lenght of the telescope / focal lenght of the eyepiece ? I'm wondering as the ETX has a focal lenght of 1900mm & if I use a 2.4mm, I get a magnification of
X 700 or more, which may be too much for my little scope.
Am I on the right track,

Cheers & thanks again,

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

More
17 years 9 months ago #47877 by Mike
Replied by Mike on topic Re: Which CCD Camera Lens to use?
Hi Crouges,
First of, I am not an expert on optics or CCDs, I can only offer what I have learned by myself, there is much more experienced people here on this forum that may correct what I am about to write and pass on their knowledge, I think some people here on the forum own ETXs presently and are doing excellent work with them.
Can you be more specific in what astronomical work you would like to undertake, this is an important point which you must be clear on, I / we may be able to give answers which are more pertinent?
The relatively small aperture (125mm in your case) of the ETX and its long focal length (f15, that’s ~1900mm) mean that ETX range is not a prime choice for deep-sky visual / astrophotography work, especially on faint galaxies. I would also have concerns with tracking and unguided exposures on such objects. All is not lost however, where it does come into its own and excels is planetary work, the Moon, brighter star clusters and double stars (camera requires shorter exposure times on these objects). Here are some pointers to consider for astrophotography work with your current setup.
The telescope’s focal length and pixel size calculation for your ETX125 in combination with your camera (Jai CV-M4+CL) Works out at the following regarding the number of arc seconds covered by each pixel and the result is 0.70 arcsec per pixel and your field of view is approximately 12 x 16 arcmin based on the following information…
Telescope: 125mm F15 (focal length rounded to 1900mm)
Camera: 6.45um x 6.45um pixels with an array of active pixels 1360(H) X 1024(V) ~1.4mp
Typical nights seeing conditions are between 2.5 and 5 arcsecs (from where I live), on occasions of good seeing it can go below 2.5 arcsecs some nights, so your telescope camera combination is well below this, you should really aim to have optimal resolution, which should be just under the seeing conditions, a good figure would be to aim for 2 arcsec per pixel, a good quality focal reducer fitted to the ETX should help in this regard, for example if you fit a f6.3 focal reducer this will bring your resolution to a more useful figure closer to 2 arcsecs per pixel and increase your FOV, if your camera has binning capabilities (in effect clustering existing pixels into effectively a larger pixel) this can help also.
Because of the camera and telescope combination you currently have, it follows that each individual pixel is seeing too little sky, therefore you have to increase the exposure time which would cause me concern regarding the ETXs tracking capabilities for unguided exposures as I stated earlier. Although there maybe software to help with tracking by feeding off the live image from the main CCD and updating the AutoStar tracking system in real time. This can all get complex when considering FWHM, Nyquist theorem etc.
A good website to visit to get the most from your ETX is www.weasner.com/etx/menu.html , lots of really good information in there.

If you want to use this camera with matching lens for stand alone sky patrol, for example, meteor work, you will need the correct type of lens to suit your 2/3” CCD camera, because your CCD is 2/3” (sorry, I thought it was ½” initially) I would recommend a fast (about f1.4) Computar Megapixel lens (fast lens basically cuts down on exposure time), I believe there is a f1.4, 12 – 36mm MegaPixel varifocal C-mount lens available from Computar. Hope this helps!
Clear skies
Mike

I83 Cherryvalley Observatory

After one look at this planet any visitor from outer space would say; "I WANT TO SEE THE MANAGER".

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

More
17 years 9 months ago #48046 by crouges
Replied by crouges on topic Re: Which CCD Camera Lens to use?
thanks again in taking the time to help me out. I can't say I understood all of it, but look forward to the learning curve ahead.

I finally bought a lens from Computar, 12.5mm-75mm, F1.2.
I'll have to wait a few days to get it & I'm eagar to get started.

To kick things off, I thought a some planetary would be pretty interesting.
I'm aware of the limitations of the etx, but hopefully it will lead to bigger
& better scopes in the future.

Good advise all round, appreciate it, & clear skies to you.

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

More
17 years 9 months ago #48053 by Mike
Replied by Mike on topic Re: Which CCD Camera Lens to use?
Hi crouges
Glad I could be of some help. That’s a good quality lens you have purchased. As a suggestion for getting you started in imaging the night sky by video means (initially starting off without a telescope) and practicing with software you will be using for capture and processing, I would offer the following general ideas….


1. Attach your new lens to your camera (set lens to 12mm setting which will give you a wider field of view and set the iris to maximum opening, i.e., f1.2, this will give you an image area of approximately 47x30 degrees of the night sky, as a comparison, the moon has an angular diameter of 0.5 degrees)
2. Place assembled lens + camera on a sturdy tripod and point at a rich star field, include a number of bright stars if possible (a dark site is always preferably)
3. Connect necessary power and signal cables to camera
4. Plug signal cable from camera into PC (Frame Grabber Unit)
5. Initialize whatever software you are using for video capture
6. hopefully you should have a live image on the screen (you may need to adjust focus at this stage, there should be an adjustment ring on the lens (near / far)
7. Using your video capture software, start recording, try a 10 ~ 20 second video clip saved in AVI format (note that a 20 second clip may take up a few hundred meg of memory on your PC, especially if you set it around 720x576 higher resolution).
8. You now have an AVI file which contains many video frames, this is where the processing comes in to integrate those hundreds of frames and bring out finer detail such as fainter stars. You can use a free program called “Registax” in order to help you with this aspect.


You could also try to use the lens set at full 75mm which will give you 8x5 degrees sky coverage, try the same procedure again (try slightly longer exposures) to see what happens, its all about experimentation to see what does and doesn’t work. Once you are familiar with your new camera and gained experience with your video capturing and processing techniques you should find the transition of imaging through the telescope that little bit easier (hopefully).

Recommended software and helpful advice for budding Astro-video astronomers..
Registax: www.astronomie.be/registax/html/download_v4.html (Free)
AstroVideo: www.coaa.co.uk/astrovideo.htm (free trial period applies)
K3CCD video capture: www.pk3.org/Astro/ (free trial period applies)
Helpful advice / ideas: www.qcuiag.co.uk/

Clear skies
Mike

I83 Cherryvalley Observatory

After one look at this planet any visitor from outer space would say; "I WANT TO SEE THE MANAGER".

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

Time to create page: 0.102 seconds
Powered by Kunena Forum
9MBMemory Usage148msRequest 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" => "0" ]
$_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" => 1744057536 "last" => 1744057536...
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.3KB) (1.1ms)
  • afterInitialise (1.16MB) (11.34ms)
  • afterRoute (187.38KB) (2.89ms)
  • beforeRenderComponent com_kunena (30.34KB) (1.17ms)
  • Before Access::preloadComponents (all components) (1.37MB) (48.47ms)
  • After Access::preloadComponents (all components) (119.01KB) (819μs)
  • Before Access::getAssetRules (id:213 name:com_kunena) (1.16KB) (29μs)
  • After Access::getAssetRules (id:213 name:com_kunena) (6.89KB) (81μs)
  • afterRenderComponent com_kunena (2.01MB) (53.55ms)
  • afterDispatch (18.34KB) (194μs)
  • beforeRenderRawModule mod_cblogin (Login) (76.07KB) (451μs)
  • afterRenderRawModule mod_cblogin (Login) (15.16KB) (350μs)
  • beforeRenderRawModule mod_custom (Network Online!) (7.91KB) (40μs)
  • afterRenderRawModule mod_custom (Network Online!) (13.13KB) (218μs)
  • beforeRenderRawModule mod_jevents_latest (Upcoming Events) (10.03KB) (29μs)
  • Before Access::getAssetRules (id:1882 name:com_jevents) (161.3KB) (1.12ms)
  • After Access::getAssetRules (id:1882 name:com_jevents) (1.28KB) (9μs)
  • afterRenderRawModule mod_jevents_latest (Upcoming Events) (1MB) (6.52ms)
  • beforeRenderRawModule mod_menu (Main Menu) (6.38KB) (43μs)
  • afterRenderRawModule mod_menu (Main Menu) (170.3KB) (1.51ms)
  • beforeRenderRawModule mod_finder (Search) (832B) (25μs)
  • afterRenderRawModule mod_finder (Search) (357.41KB) (2.8ms)
  • beforeRenderRawModule mod_banners (Sponsors) (2.89KB) (26μs)
  • afterRenderRawModule mod_banners (Sponsors) (145.11KB) (2.98ms)
  • beforeRenderRawModule mod_menu (footermenu) (496B) (42μs)
  • afterRenderRawModule mod_menu (footermenu) (60.16KB) (517μs)
  • beforeRenderModule mod_menu (footermenu) (10.27KB) (170μs)
  • afterRenderModule mod_menu (footermenu) (3.43KB) (66μs)
  • beforeRenderModule mod_cblogin (Login) (11.96KB) (62μs)
  • afterRenderModule mod_cblogin (Login) (2.7KB) (58μs)
  • beforeRenderModule mod_custom (Network Online!) (8.96KB) (15μs)
  • afterRenderModule mod_custom (Network Online!) (2.82KB) (24μs)
  • beforeRenderModule mod_jevents_latest (Upcoming Events) (9.77KB) (26μs)
  • afterRenderModule mod_jevents_latest (Upcoming Events) (3.57KB) (20μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (9.41KB) (108μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (37.89KB) (716μs)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (4μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.93KB) (33μs)
  • beforeRenderModule mod_banners (Sponsors) (8.48KB) (55μs)
  • afterRenderModule mod_banners (Sponsors) (2.57KB) (24μs)
  • beforeRenderModule mod_finder (Search) (4.02KB) (50μs)
  • afterRenderModule mod_finder (Search) (2.37KB) (22μs)
  • beforeRenderModule mod_menu (Main Menu) (7.88KB) (43μs)
  • afterRenderModule mod_menu (Main Menu) (2.8KB) (20μs)
  • afterRender (794.01KB) (6.55ms)
  • 1 x afterRenderComponent com_kunena (2.01MB) (36.24%)
    53.55ms
    1 x Before Access::preloadComponents (all components) (1.37MB) (32.81%)
    48.47ms
    1 x afterInitialise (1.16MB) (7.68%)
    11.34ms
    1 x afterRender (794.01KB) (4.43%)
    6.55ms
    1 x afterRenderRawModule mod_jevents_latest (Upcoming Events) (1MB) (4.41%)
    6.52ms
    1 x afterRenderRawModule mod_banners (Sponsors) (145.11KB) (2.02%)
    2.98ms
    1 x afterRoute (187.38KB) (1.95%)
    2.89ms
    1 x afterRenderRawModule mod_finder (Search) (357.41KB) (1.89%)
    2.80ms
    1 x afterRenderRawModule mod_menu (Main Menu) (170.3KB) (1.02%)
    1.51ms
    1 x beforeRenderComponent com_kunena (30.34KB) (0.79%)
    1.17ms
    1 x Before Access::getAssetRules (id:1882 name:com_jevents) (161.3KB) (0.76%)
    1.12ms
    1 x afterLoad (456.3KB) (0.74%)
    1.10ms
    1 x After Access::preloadComponents (all components) (119.01KB) (0.55%)
    819μs
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (37.89KB) (0.48%)
    716μs
    1 x afterRenderRawModule mod_menu (footermenu) (60.16KB) (0.35%)
    517μs
    1 x beforeRenderRawModule mod_cblogin (Login) (76.07KB) (0.31%)
    451μs
    1 x afterRenderRawModule mod_cblogin (Login) (15.16KB) (0.24%)
    350μs
    1 x afterRenderRawModule mod_custom (Network Online!) (13.13KB) (0.15%)
    218μs
    1 x afterDispatch (18.34KB) (0.13%)
    194μs
    1 x beforeRenderModule mod_menu (footermenu) (10.27KB) (0.12%)
    170μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (9.41KB) (0.07%)
    108μs
    1 x After Access::getAssetRules (id:213 name:com_kunena) (6.89KB) (0.05%)
    81μs
    1 x afterRenderModule mod_menu (footermenu) (3.43KB) (0.04%)
    66μs
    1 x beforeRenderModule mod_cblogin (Login) (11.96KB) (0.04%)
    62μs
    1 x afterRenderModule mod_cblogin (Login) (2.7KB) (0.04%)
    58μs
    1 x beforeRenderModule mod_banners (Sponsors) (8.48KB) (0.04%)
    55μs
    1 x beforeRenderModule mod_finder (Search) (4.02KB) (0.03%)
    50μs
    1 x beforeRenderModule mod_menu (Main Menu) (7.88KB) (0.03%)
    43μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (6.38KB) (0.03%)
    43μs
    1 x beforeRenderRawModule mod_menu (footermenu) (496B) (0.03%)
    42μs
    1 x beforeRenderRawModule mod_custom (Network Online!) (7.91KB) (0.03%)
    40μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.93KB) (0.02%)
    33μs
    1 x beforeRenderRawModule mod_jevents_latest (Upcoming Events) (10.03KB) (0.02%)
    29μs
    1 x Before Access::getAssetRules (id:213 name:com_kunena) (1.16KB) (0.02%)
    29μs
    1 x beforeRenderRawModule mod_banners (Sponsors) (2.89KB) (0.02%)
    26μs
    1 x beforeRenderModule mod_jevents_latest (Upcoming Events) (9.77KB) (0.02%)
    26μs
    1 x beforeRenderRawModule mod_finder (Search) (832B) (0.02%)
    25μs
    1 x afterRenderModule mod_custom (Network Online!) (2.82KB) (0.02%)
    24μs
    1 x afterRenderModule mod_banners (Sponsors) (2.57KB) (0.02%)
    24μs
    1 x afterRenderModule mod_finder (Search) (2.37KB) (0.01%)
    22μs
    1 x afterRenderModule mod_jevents_latest (Upcoming Events) (3.57KB) (0.01%)
    20μs
    1 x afterRenderModule mod_menu (Main Menu) (2.8KB) (0.01%)
    20μs
    1 x beforeRenderModule mod_custom (Network Online!) (8.96KB) (0.01%)
    15μs
    1 x After Access::getAssetRules (id:1882 name:com_jevents) (1.28KB) (0.01%)
    9μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (0%)
    4μs
115 statements were executed, 14 of which were duplicates, 101 unique25.32ms448.76KB
  • SELECT @@SESSION.sql_mode;69μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tifas_session` WHERE `session_id` = ?169μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tifas_session` WHERE `session_id` = :session_id LIMIT 195μ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)552μ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` = 1460μs33.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tifas_viewlevels`83μ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` = :guest80μ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`656μs3.96KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `tifas_kunena_configuration` WHERE `id` = 194μs1.2KB/libraries/kunena/src/Config/KunenaConfig.php:1690Copy
  • SELECT sampleData FROM tifas_kunena_version ORDER BY id DESC LIMIT 192μ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`549μs20.05KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `tifas_kunena_aliases` WHERE `alias` LIKE '29-astro-photography%'121μs704B/libraries/kunena/src/Route/KunenaRoute.php:855Copy
  • SHOW TABLES708μs8.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM `tifas_languages` WHERE `published` = 1 ORDER BY `ordering` ASC113μ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`331μs1.34KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_users`532μ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)438μ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)652μ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)743μs584B/plugins/kunena/joomla/KunenaAccessJoomla.php:388Copy
  • SELECT `user_id`,`category_id`,`role` FROM `tifas_kunena_user_categories` WHERE `role` IN (1,2)96μs800B/libraries/kunena/src/Access/KunenaAccess.php:182Copy
  • SELECT * FROM `tifas_kunena_categories` ORDER BY `ordering`,`name`306μs21.27KB/libraries/kunena/src/Forum/Category/KunenaCategoryHelper.php:107Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_categories`399μs1.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '502'138μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '11'126μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '42'119μ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'140μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '512'115μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '516'112μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '505'114μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '20'119μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '511'108μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '530'106μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '529'105μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '19'118μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '508'105μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '41'112μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '16'105μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '17'111μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '44'127μ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'158μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '531'111μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '9'107μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '28'102μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '35'120μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '514'104μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '22'103μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '18'109μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '29'102μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '27'126μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '513'103μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '517'137μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '3'104μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '39'102μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '33'107μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '2'124μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '40'106μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '30'102μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '45'109μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '46'102μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '528'102μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_topics`343μs1.7KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_topics` WHERE `id` = '47673'130μs13.81KB/libraries/kunena/src/Tables/TableKunenaTopics.php:223Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_messages`342μ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` = 47673135μs2.53KB/libraries/kunena/src/Tables/TableKunenaMessages.php:216Copy
  • SELECT COUNT(*) FROM `tifas_kunena_messages` AS `a` WHERE `thread` = '47673' AND `a`.`hold` IN (0)183μs536B/libraries/kunena/src/Database/Object/KunenaFinder.php:278Copy
  • SELECT a.id FROM `tifas_kunena_messages` AS `a` WHERE `thread` = '47673' AND `a`.`hold` IN (0) ORDER BY a.`time` ASC LIMIT 6174μ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 (47679,47789,47877,48046,48053)1.5ms18.59KB/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:120Copy
  • SELECT * FROM `tifas_kunena_thankyou` WHERE `postid` IN (47673,47679,47789,47877,48046,48053)98μ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 (1220,1034)243μs25.02KB/libraries/kunena/src/User/KunenaUserHelper.php:247Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (47673,47679,47789,47877,48046,48053)101μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_user_topics` WHERE (`user_id` = '0') AND (`topic_id` IN (47673))93μs1.27KB/libraries/kunena/src/Forum/Topic/User/KunenaTopicUserHelper.php:159Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_user_topics`315μs1.42KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT `code`,`location` FROM `tifas_kunena_smileys`108μs960B/libraries/kunena/src/BBCode/KunenaBBCode.php:1122Copy
  • UPDATE `tifas_kunena_topics` SET `hits` = (`hits` + 1) WHERE `id` = '47673'396μ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`719μs1.86KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_polls`299μs1.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_ranks`100μ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` > '1744055736' GROUP BY `userid` ORDER BY `time` DESC154μs576B/libraries/kunena/src/User/KunenaUserHelper.php:544Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (47673)105μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (47673)98μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (47679)95μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (47679)87μ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 (47679) GROUP BY `m`.`id`,`mm`.`hold`222μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (47789)95μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (47789)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 (47789) GROUP BY `m`.`id`,`mm`.`hold`217μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (47877)104μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (47877)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 (47877) GROUP BY `m`.`id`,`mm`.`hold`238μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (48046)104μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (48046)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 (48046) GROUP BY `m`.`id`,`mm`.`hold`225μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (48053)94μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (48053)81μ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 (48053) GROUP BY `m`.`id`,`mm`.`hold`191μ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 ASC672μ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 20:25:36') AND (`publish_down` ='1000-01-01 00:00:00' OR `publish_down` >= '2025-04-07 20:25:36') ORDER BY `id` DESC LIMIT 1106μs1.42KB/libraries/kunena/src/Forum/Announcement/KunenaAnnouncementHelper.php:145Copy
  • SHOW FULL COLUMNS FROM `tifas_jev_users`339μ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`250μ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 asc179μ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 asc158μ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 10765μ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 ASC273μs10.33KB/components/com_jevents/libraries/dbmodel.php:3274Copy
  • SELECT `name`,`element` FROM `tifas_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1256μ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)141μ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)211μ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 1410μs2.28KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • UPDATE `tifas_banners` SET `impmade` = `impmade` + 1 WHERE `id` IN (:preparedArray1)389μ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` = :trackDate375μ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` asc193μ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` asc163μs3.18KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy
  • SHOW TABLES713μs8.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy