K-Tec

what lens for a canon 400d

More
17 years 2 months ago #62137 by JohnMurphy
Replied by JohnMurphy on topic Re: what lens for a canon 400d

for astrophotography, do you want high f values ( smaller apature) or low f Values? I know higher f value means smaller apature and better dof, but less light. what is generally the rule of thumb for astronomy?


Smaller F number means bigger aperature - hence more photons. The same rules apply as for scopes. With lenses get a smaller F number, this will mean shorter exposure time is necessary hence reducing tracking errors.

Clear Skies,
John Murphy
Irish Astronomical Society
Check out My Photos

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

  • fguihen
  • Topic Author
  • Offline
  • Main Sequence
  • Main Sequence
More
17 years 2 months ago #62138 by fguihen
Replied by fguihen on topic Re: what lens for a canon 400d
but what is written on the lens is the 35mm equivalent focal length, so the FLM is taken into account? eg, i currently have a panasonic with a 36 -432mm lens. I know the ccd is only tiny so the actual focal length is 6-72mm, but as they write 36-432 on the side of the lens, the image is the same size as an image from a 35mm with a 36-432mm lens, therefore any crop(magnification) caused by a small sensor is taken into account in this number.

sorry for all the questions,but this is how ive understood this for a few years, so i want to be sure i understand this correctly

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

More
17 years 2 months ago #62142 by albertw
Replied by albertw on topic Re: what lens for a canon 400d

but what is written on the lens is the 35mm equivalent focal length, so the FLM is taken into account? eg, i currently have a panasonic with a 36 -432mm lens. I know the ccd is only tiny so the actual focal length is 6-72mm, but as they write 36-432 on the side of the lens, the image is the same size as an image from a 35mm with a 36-432mm lens, therefore any crop(magnification) caused by a small sensor is taken into account in this number.

sorry for all the questions,but this is how ive understood this for a few years, so i want to be sure i understand this correctly


The panasonic lens might be an exception to the rule. Any lenses I've come across have the focal length stated as they would be for a 35mm slide. You need to do the conversion.

It may seem strange but it makes sense. E.g. the 300D and 400D have different sensor sizes but the same lenses will work with both. So you can't take the sensor size into account in the focal length printed on the lens.

How large a focal length you want depends on what you want to do with it. Though bear in mind if you are going over 500mm you are heading into expensive lenses (especially for low f numbers and decent optics) and might be better off with a small scope.

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

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

More
17 years 2 months ago #62143 by JohnMurphy
Replied by JohnMurphy on topic Re: what lens for a canon 400d
I'm not familiar with the Panasonic you are using (presumably a compact?) but think of it this way, in the SLR world all lenses focal lenghts are written verbatim - i.e. 55mm is 55mm. What you need to take into account is the sensor size. If you are using a full frame sensor like a Canon 1D MkIII, then you will get a true 55mm focal length. If however your SLR has a C sensor (400D et al.) then you need to multiply the focal length by 1.6 to get the true image scale.

Clear Skies,
John Murphy
Irish Astronomical Society
Check out My Photos

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

  • fguihen
  • Topic Author
  • Offline
  • Main Sequence
  • Main Sequence
More
17 years 2 months ago #62144 by fguihen
Replied by fguihen on topic Re: what lens for a canon 400d
cool. thanks guys. my panasonic isnt a dslr, and more of a very fancy point and shoot, and from what i know, most point and shoot cameras give the 35mm equivalent so i had no idea SLR's used a different convention.

so , just to be absolutely sure i understand this, the 400d comes with a standard kit lens thats has 18-55mm written on the side. This means that attaching this lens onto the 400d, with a FLM of 1.6 the lens becomes a 28.8 - 88mm lens. Is this correct?

How does this affect the apature size? I would imagine that a 35mm lens at 2.8f, would be a much larger apature than a digital camera lens at 2.8, as the digital camera has a smaller sensor. is there a formula here to work out the f value?

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

More
17 years 2 months ago #62145 by JohnMurphy
Replied by JohnMurphy on topic Re: what lens for a canon 400d

It may seem strange but it makes sense. E.g. the 300D and 400D have different sensor sizes but the same lenses will work with both. So you can't take the sensor size into account in the focal length printed on the lens.

Not quite correct. The 300D and 400D have the same C size sensor. The only difference is the number of pixels on the sensor - which has no effect on the image size - only the quality.

Clear Skies,
John Murphy
Irish Astronomical Society
Check out My Photos

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

Time to create page: 0.139 seconds
Powered by Kunena Forum
9MBMemory Usage215msRequest 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" => "6" ]
$_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" => 1744327632 "last" => 1744327632...
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) (911μs)
  • afterInitialise (1.16MB) (9.91ms)
  • afterRoute (187.38KB) (2.51ms)
  • beforeRenderComponent com_kunena (30.34KB) (1.01ms)
  • Before Access::preloadComponents (all components) (1.37MB) (49.63ms)
  • After Access::preloadComponents (all components) (119.01KB) (617μs)
  • Before Access::getAssetRules (id:213 name:com_kunena) (1.16KB) (15μs)
  • After Access::getAssetRules (id:213 name:com_kunena) (6.89KB) (38μs)
  • afterRenderComponent com_kunena (2.03MB) (89.15ms)
  • afterDispatch (18.34KB) (159μs)
  • beforeRenderRawModule mod_cblogin (Login) (76.07KB) (435μs)
  • afterRenderRawModule mod_cblogin (Login) (15.16KB) (155μs)
  • beforeRenderRawModule mod_custom (Network Online!) (7.91KB) (16μs)
  • afterRenderRawModule mod_custom (Network Online!) (13.13KB) (218μs)
  • beforeRenderRawModule mod_jevents_latest (Upcoming Events) (10.03KB) (32μs)
  • Before Access::getAssetRules (id:1882 name:com_jevents) (161.3KB) (1.28ms)
  • After Access::getAssetRules (id:1882 name:com_jevents) (1.28KB) (11μs)
  • afterRenderRawModule mod_jevents_latest (Upcoming Events) (1MB) (17.07ms)
  • beforeRenderRawModule mod_menu (Main Menu) (6.38KB) (52μs)
  • afterRenderRawModule mod_menu (Main Menu) (170.3KB) (1.39ms)
  • beforeRenderRawModule mod_finder (Search) (832B) (25μs)
  • afterRenderRawModule mod_finder (Search) (357.41KB) (5.29ms)
  • beforeRenderRawModule mod_banners (Sponsors) (2.89KB) (25μs)
  • afterRenderRawModule mod_banners (Sponsors) (145.11KB) (11.63ms)
  • beforeRenderRawModule mod_menu (footermenu) (496B) (43μs)
  • afterRenderRawModule mod_menu (footermenu) (60.16KB) (655μs)
  • beforeRenderModule mod_menu (footermenu) (10.27KB) (140μs)
  • afterRenderModule mod_menu (footermenu) (3.43KB) (73μs)
  • beforeRenderModule mod_cblogin (Login) (11.96KB) (63μs)
  • afterRenderModule mod_cblogin (Login) (2.7KB) (45μ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) (27μs)
  • afterRenderModule mod_jevents_latest (Upcoming Events) (3.57KB) (48μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (9.41KB) (125μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (39.14KB) (578μs)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (4μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.93KB) (33μs)
  • beforeRenderModule mod_banners (Sponsors) (8.48KB) (54μs)
  • afterRenderModule mod_banners (Sponsors) (2.57KB) (23μs)
  • beforeRenderModule mod_finder (Search) (4.02KB) (44μs)
  • afterRenderModule mod_finder (Search) (2.37KB) (22μs)
  • beforeRenderModule mod_menu (Main Menu) (7.88KB) (41μs)
  • afterRenderModule mod_menu (Main Menu) (2.8KB) (21μs)
  • afterRender (802.01KB) (13.5ms)
  • 1 x afterRenderComponent com_kunena (2.03MB) (41.5%)
    89.15ms
    1 x Before Access::preloadComponents (all components) (1.37MB) (23.11%)
    49.63ms
    1 x afterRenderRawModule mod_jevents_latest (Upcoming Events) (1MB) (7.95%)
    17.07ms
    1 x afterRender (802.01KB) (6.28%)
    13.50ms
    1 x afterRenderRawModule mod_banners (Sponsors) (145.11KB) (5.42%)
    11.63ms
    1 x afterInitialise (1.16MB) (4.61%)
    9.91ms
    1 x afterRenderRawModule mod_finder (Search) (357.41KB) (2.46%)
    5.29ms
    1 x afterRoute (187.38KB) (1.17%)
    2.51ms
    1 x afterRenderRawModule mod_menu (Main Menu) (170.3KB) (0.65%)
    1.39ms
    1 x Before Access::getAssetRules (id:1882 name:com_jevents) (161.3KB) (0.6%)
    1.28ms
    1 x beforeRenderComponent com_kunena (30.34KB) (0.47%)
    1.01ms
    1 x afterLoad (456.3KB) (0.42%)
    911μs
    1 x afterRenderRawModule mod_menu (footermenu) (60.16KB) (0.31%)
    655μs
    1 x After Access::preloadComponents (all components) (119.01KB) (0.29%)
    617μs
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (39.14KB) (0.27%)
    578μs
    1 x beforeRenderRawModule mod_cblogin (Login) (76.07KB) (0.2%)
    435μs
    1 x afterRenderRawModule mod_custom (Network Online!) (13.13KB) (0.1%)
    218μs
    1 x afterDispatch (18.34KB) (0.07%)
    159μs
    1 x afterRenderRawModule mod_cblogin (Login) (15.16KB) (0.07%)
    155μs
    1 x beforeRenderModule mod_menu (footermenu) (10.27KB) (0.07%)
    140μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (9.41KB) (0.06%)
    125μs
    1 x afterRenderModule mod_menu (footermenu) (3.43KB) (0.03%)
    73μs
    1 x beforeRenderModule mod_cblogin (Login) (11.96KB) (0.03%)
    63μs
    1 x beforeRenderModule mod_banners (Sponsors) (8.48KB) (0.03%)
    54μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (6.38KB) (0.02%)
    52μs
    1 x afterRenderModule mod_jevents_latest (Upcoming Events) (3.57KB) (0.02%)
    48μs
    1 x afterRenderModule mod_cblogin (Login) (2.7KB) (0.02%)
    45μs
    1 x beforeRenderModule mod_finder (Search) (4.02KB) (0.02%)
    44μs
    1 x beforeRenderRawModule mod_menu (footermenu) (496B) (0.02%)
    43μs
    1 x beforeRenderModule mod_menu (Main Menu) (7.88KB) (0.02%)
    41μs
    1 x After Access::getAssetRules (id:213 name:com_kunena) (6.89KB) (0.02%)
    38μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.93KB) (0.02%)
    33μs
    1 x beforeRenderRawModule mod_jevents_latest (Upcoming Events) (10.03KB) (0.01%)
    32μs
    1 x beforeRenderModule mod_jevents_latest (Upcoming Events) (9.77KB) (0.01%)
    27μs
    1 x beforeRenderRawModule mod_finder (Search) (832B) (0.01%)
    25μs
    1 x beforeRenderRawModule mod_banners (Sponsors) (2.89KB) (0.01%)
    25μs
    1 x afterRenderModule mod_custom (Network Online!) (2.82KB) (0.01%)
    24μs
    1 x afterRenderModule mod_banners (Sponsors) (2.57KB) (0.01%)
    23μs
    1 x afterRenderModule mod_finder (Search) (2.37KB) (0.01%)
    22μs
    1 x afterRenderModule mod_menu (Main Menu) (2.8KB) (0.01%)
    21μs
    1 x beforeRenderRawModule mod_custom (Network Online!) (7.91KB) (0.01%)
    16μs
    1 x Before Access::getAssetRules (id:213 name:com_kunena) (1.16KB) (0.01%)
    15μ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
116 statements were executed, 14 of which were duplicates, 102 unique47.32ms433.6KB
  • SELECT @@SESSION.sql_mode;70μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tifas_session` WHERE `session_id` = ?120μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tifas_session` WHERE `session_id` = :session_id LIMIT 190μ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)354μ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` = 1270μs33.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tifas_viewlevels`78μ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` = :guest102μ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`461μs3.96KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `tifas_kunena_configuration` WHERE `id` = 192μs1.2KB/libraries/kunena/src/Config/KunenaConfig.php:1690Copy
  • SELECT sampleData FROM tifas_kunena_version ORDER BY id DESC LIMIT 179μ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`396μs20.05KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `tifas_kunena_aliases` WHERE `alias` LIKE '22-observing-equipment%'104μs704B/libraries/kunena/src/Route/KunenaRoute.php:855Copy
  • SHOW TABLES710μs8.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM `tifas_languages` WHERE `published` = 1 ORDER BY `ordering` ASC120μ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` = 1168μs832B/administrator/components/com_templates/src/Model/StyleModel.php:771Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_sessions`300μs1.34KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_users`402μ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)329μ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)591μ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)759μs584B/plugins/kunena/joomla/KunenaAccessJoomla.php:388Copy
  • SELECT `user_id`,`category_id`,`role` FROM `tifas_kunena_user_categories` WHERE `role` IN (1,2)100μs800B/libraries/kunena/src/Access/KunenaAccess.php:182Copy
  • SELECT * FROM `tifas_kunena_categories` ORDER BY `ordering`,`name`292μs21.27KB/libraries/kunena/src/Forum/Category/KunenaCategoryHelper.php:107Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_categories`359μs1.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '502'129μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '11'133μ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'155μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '1'131μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '512'129μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '516'160μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '505'122μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '20'122μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '511'172μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '530'132μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '529'129μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '19'128μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '508'130μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '41'137μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '16'129μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '17'135μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '44'130μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '515'126μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '21'133μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '531'120μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '9'125μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '28'122μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '35'133μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '514'125μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '22'123μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '18'123μ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'150μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '513'127μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '517'124μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '3'126μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '39'122μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '33'130μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '2'152μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '40'125μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '30'131μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '45'122μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '46'125μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '528'129μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_topics`338μs1.7KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_topics` WHERE `id` = '62128'131μs13.81KB/libraries/kunena/src/Tables/TableKunenaTopics.php:223Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_messages`333μ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` = 62128544μs2.53KB/libraries/kunena/src/Tables/TableKunenaMessages.php:216Copy
  • SELECT COUNT(*) FROM `tifas_kunena_messages` AS `a` WHERE `thread` = '62128' AND `a`.`hold` IN (0)201μs536B/libraries/kunena/src/Database/Object/KunenaFinder.php:278Copy
  • SELECT a.id FROM `tifas_kunena_messages` AS `a` WHERE `thread` = '62128' AND `a`.`hold` IN (0) ORDER BY a.`time` ASC LIMIT 6, 6182μ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 (62137,62138,62142,62143,62144,62145)262μs2.61KB/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:120Copy
  • SELECT * FROM `tifas_kunena_thankyou` WHERE `postid` IN (62137,62138,62142,62143,62144,62145)111μ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 (680,569,69)260μs25.03KB/libraries/kunena/src/User/KunenaUserHelper.php:247Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (62137,62138,62142,62143,62144,62145)119μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_user_topics` WHERE (`user_id` = '0') AND (`topic_id` IN (62128))95μs1.27KB/libraries/kunena/src/Forum/Topic/User/KunenaTopicUserHelper.php:159Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_user_topics`305μs1.42KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT `code`,`location` FROM `tifas_kunena_smileys`82μs960B/libraries/kunena/src/BBCode/KunenaBBCode.php:1122Copy
  • UPDATE `tifas_kunena_topics` SET `hits` = (`hits` + 1) WHERE `id` = '62128'384μ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`2.17ms1.86KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_polls`315μs1.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_ranks`2ms1.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` > '1744325832' GROUP BY `userid` ORDER BY `time` DESC1.17ms576B/libraries/kunena/src/User/KunenaUserHelper.php:544Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (62137)110μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (62137)741μ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 (62137) GROUP BY `m`.`id`,`mm`.`hold`214μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (62138)111μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (62138)510μ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 (62138) GROUP BY `m`.`id`,`mm`.`hold`2.52ms832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (62142)341μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (62142)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 (62142) GROUP BY `m`.`id`,`mm`.`hold`1.98ms832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (62143)170μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (62143)110μ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 (62143) GROUP BY `m`.`id`,`mm`.`hold`233μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (62144)117μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (62144)109μ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 (62144) GROUP BY `m`.`id`,`mm`.`hold`563μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (62145)234μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (62145)134μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT m.id, mm.hold, m.catid AS category_id, m.thread AS topic_id, SUM(mm.time<m.time) AS before_count, SUM(mm.time>m.time) AS after_count FROM `tifas_kunena_messages` AS `m` INNER JOIN `tifas_kunena_messages` AS `mm` ON `m`.`thread` = `mm`.`thread` WHERE `m`.`id` IN (62145) GROUP BY `m`.`id`,`mm`.`hold`263μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required, a.only_use_in_subform,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note FROM tifas_fields AS a LEFT JOIN `tifas_languages` AS l ON l.lang_code = a.language LEFT JOIN tifas_users AS uc ON uc.id=a.checked_out LEFT JOIN tifas_viewlevels AS ag ON ag.id = a.access LEFT JOIN tifas_users AS ua ON ua.id = a.created_user_id LEFT JOIN tifas_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray2)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC766μ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-10 23:27:12') AND (`publish_down` ='1000-01-01 00:00:00' OR `publish_down` >= '2025-04-10 23:27:12') ORDER BY `id` DESC LIMIT 1194μs1.42KB/libraries/kunena/src/Forum/Announcement/KunenaAnnouncementHelper.php:145Copy
  • SHOW FULL COLUMNS FROM `tifas_jev_users`536μ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`3.6ms3.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 asc318μ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 asc180μ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-12 00:00:00' AND ev.created <= '2025-10-07 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 10696μ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-12 00:00:00' AND ev.created <= '2025-10-07 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 ASC429μs10.33KB/components/com_jevents/libraries/dbmodel.php:3274Copy
  • SELECT `name`,`element` FROM `tifas_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1485μ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)1.65ms584B/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)189μ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 1437μs2.28KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • UPDATE `tifas_banners` SET `impmade` = `impmade` + 1 WHERE `id` IN (:preparedArray1)4.08ms856BParams/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` = :trackDate3.57ms832BParams/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` asc177μ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` asc195μs3.18KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy
  • SHOW TABLES678μs8.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy