K-Tec

FFTW

  • albertw
  • Topic Author
  • Offline
  • IFAS Secretary
  • IFAS Secretary
More
18 years 6 months ago #33400 by albertw
FFTW was created by albertw
Hi,

I'm doing a project at the moment to work out the frequency of pulsars. Basically I take the raw data, put it into time bins and run a FFT over that, then look for peaks in the FFT data to get the frequency of the pulsar. Straight forward enough until you implement it.

My problem is with the FFT, in particular the fftw3 libraries. Well that and not knowing too much about fft's!

Anyway, I wrote this little test program just to get the basics right. Create data for a sine wave then get its frequency from the fft.

[code:1]#include <stdio.h>
#include <math.h>
#include <fftw3.h>

int main(){

int N=5000;
double in[N];
double out[6000];
fftw_plan p;
float x=0;
int y=0 ;
int z=0 ;
FILE *fp;

fp = fopen("datasource.data","w");

/*
* Fill in in[N] with a sine wave to simulate a very regular pulsar
*/
while ( x < 100 ){
y=(int)(100*(1+sin(x)));
in[z]=y;
fprintf(fp, "%f\n", in[z]);
x=x+0.02;
z=z++;
}

fclose(fp);

/*
* Perhaps I should be using complex numbers here, but the inputs are real
* and I expect I'm looking for real outputs...
* fftw_plan_r2r_1d and FFTW_DHT seem to be the necessary choice...
*/
p = fftw_plan_r2r_1d(N, in, out, FFTW_DHT, FFTW_ESTIMATE);

fftw_execute(p); /* repeat as needed */


z=0;
while (z !=5500){

printf("%f\n",out[z]);
z++;


}

fftw_destroy_plan(p);
/* fftw_free(in); */

fftw_free(out);

}[/code:1]

The sine wave that we generate looks like this:


And the plot of the fft output looks like:


So in principle this looks ok.

However if I change the amplitude of the sine wave to y=(int)(200*(1+sin(x)));

The fft changes to:


Given that a fft is meant to transform from the time domain to the frequency domain the amplitude of the signal should not matter. So I'm getting someting fairly fundamental wrong here!

Anyone able to help out with some basics on using fftw to get the frequency (ies) of an imput signal?

Cheers,
~Al

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
18 years 6 months ago #33409 by Seanie_Morris
Replied by Seanie_Morris on topic Re: FFTW

[code] while ( x < 100 ){
y=(int)(100*(1+sin(x)));
in[z]=y;
fprintf(fp, "%f\n", in[z]);


Al,
should that second last line not read as int[z]=y and same for last part? Is that denoting an integer of [z]? Could it be this typo that's a problem?

Seanie.

Midlands Astronomy Club.
Radio Presenter (Midlands 103), Space Enthusiast, Astronomy Outreach Co-ordinator.
Former IFAS Chairperson and Secretary.

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

  • albertw
  • Topic Author
  • Offline
  • IFAS Secretary
  • IFAS Secretary
More
18 years 6 months ago #33410 by albertw
Replied by albertw on topic Re: FFTW

[code] while ( x < 100 ){
y=(int)(100*(1+sin(x)));
in[z]=y;
fprintf(fp, "%f\n", in[z]);


Al,
should that second last line not read as int[z]=y and same for last part? Is that denoting an integer of [z]? Could it be this typo that's a problem?

Seanie.


no its an array called 'in'. But thanks for at least reading through the post anyway!

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
18 years 6 months ago #33412 by Seanie_Morris
Replied by Seanie_Morris on topic Re: FFTW
8)

It's the best I could come up with! :D

Is it because you are not getting a 'proper' wave pattern that is wrong? t
The fact you increased 100 to 200 shows that your FFT wave is from almost 50 to almost 100. What (pictorially) are you hoping it would have changed when you 'doubled' it with the y=(int)(200*(1+sin(x)))

Midlands Astronomy Club.
Radio Presenter (Midlands 103), Space Enthusiast, Astronomy Outreach Co-ordinator.
Former IFAS Chairperson and Secretary.

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

  • albertw
  • Topic Author
  • Offline
  • IFAS Secretary
  • IFAS Secretary
More
18 years 6 months ago #33413 by albertw
Replied by albertw on topic Re: FFTW

8)

It's the best I could come up with! :D

Is it because you are not getting a 'proper' wave pattern that is wrong? t
The fact you increased 100 to 200 shows that your FFT wave is from almost 50 to almost 100. What (pictorially) are you hoping it would have changed when you 'doubled' it with the y=(int)(200*(1+sin(x)))


Have a peek at the images here:
www.numerit.com/samples/fft/doc.htm

The 'normal' graph has amplitude on the Y axis and Time on the X axis; thats the normal wave graph.

Applying a fourier transform changes you from the time domain to the frequency domain so you get the frequency on the X axis. (yes I know its on the Y in my plot, thats part of the problem!)

So for figure 3 in that URL we have a wave that is made up of 2 sine waves of different frequency and amplitude.

Figure 4 shows what the frequency of the waves is.

So you feed in a signal and the output from the transform tells you the component wave that make it up. So for my pulsar I feed in the counts and the pulsar frequency should show as a spike in the transform.

I (vaguely) remember Fourier transforms in college being involved with imaginary numbers not real ones so I suspect that my cop out of using the real2real functions is whats causing the problem. More readoing to do; just not at 2am :-)

Cheers,
~Al

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
18 years 6 months ago #33414 by Seanie_Morris
Replied by Seanie_Morris on topic Re: FFTW
Well I think I'm out of my league now! It sounds like an interesting project though.

Midlands Astronomy Club.
Radio Presenter (Midlands 103), Space Enthusiast, Astronomy Outreach Co-ordinator.
Former IFAS Chairperson and Secretary.

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

Time to create page: 0.092 seconds
Powered by Kunena Forum
10MBMemory Usage149msRequest Duration
Joomla! Version4.3.4
PHP Version8.3.20
Identityguest
Response200
Templatecassiopeia
Database
Server
mysql
Version
10.6.21-MariaDB-0ubuntu0.22.04.2
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" => 1744769456 "last" => 1744769456...
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...
plg_system_webauthn
array:1 [ "returnUrl" => "https://www.irishastronomy.org/kunena/28-computers-in-astronomy/33400-ff...
  • afterLoad (455.24KB) (703μs)
  • afterInitialise (1.16MB) (11.85ms)
  • afterRoute (123.34KB) (2.74ms)
  • beforeRenderComponent com_kunena (94.41KB) (1ms)
  • Before Access::preloadComponents (all components) (1.31MB) (43.39ms)
  • After Access::preloadComponents (all components) (121.84KB) (690μs)
  • Before Access::getAssetRules (id:213 name:com_kunena) (1.23KB) (18μs)
  • After Access::getAssetRules (id:213 name:com_kunena) (6.89KB) (41μs)
  • afterRenderComponent com_kunena (2.06MB) (48.43ms)
  • afterDispatch (18.31KB) (200μs)
  • beforeRenderRawModule mod_cblogin (Login) (76.06KB) (433μs)
  • Before Access::getAssetRules (id:1 name:root.1) (690.84KB) (4.89ms)
  • After Access::getAssetRules (id:1 name:root.1) (1.28KB) (7μs)
  • afterRenderRawModule mod_cblogin (Login) (874.48KB) (9.86ms)
  • beforeRenderRawModule mod_custom (Network Online!) (7.91KB) (23μs)
  • afterRenderRawModule mod_custom (Network Online!) (14.29KB) (224μs)
  • beforeRenderRawModule mod_jevents_latest (Upcoming Events) (10.03KB) (29μs)
  • Before Access::getAssetRules (id:1882 name:com_jevents) (164.03KB) (972μs)
  • After Access::getAssetRules (id:1882 name:com_jevents) (1.28KB) (8μs)
  • afterRenderRawModule mod_jevents_latest (Upcoming Events) (1023.9KB) (5.55ms)
  • beforeRenderRawModule mod_menu (Main Menu) (6.38KB) (39μs)
  • afterRenderRawModule mod_menu (Main Menu) (170.91KB) (1.3ms)
  • beforeRenderRawModule mod_finder (Search) (832B) (26μs)
  • afterRenderRawModule mod_finder (Search) (356.95KB) (2.66ms)
  • beforeRenderRawModule mod_banners (Sponsors) (2.89KB) (27μs)
  • afterRenderRawModule mod_banners (Sponsors) (144.72KB) (2.75ms)
  • beforeRenderRawModule mod_menu (footermenu) (496B) (41μs)
  • afterRenderRawModule mod_menu (footermenu) (56.2KB) (505μs)
  • beforeRenderModule mod_menu (footermenu) (10.25KB) (146μs)
  • afterRenderModule mod_menu (footermenu) (3.43KB) (61μs)
  • beforeRenderModule mod_cblogin (Login) (11.95KB) (57μs)
  • afterRenderModule mod_cblogin (Login) (10.51KB) (47μs)
  • beforeRenderModule mod_custom (Network Online!) (8.96KB) (14μs)
  • afterRenderModule mod_custom (Network Online!) (4.07KB) (26μs)
  • beforeRenderModule mod_jevents_latest (Upcoming Events) (12.96KB) (25μs)
  • afterRenderModule mod_jevents_latest (Upcoming Events) (2.32KB) (20μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (8.89KB) (94μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (38.22KB) (505μs)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (4μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.8KB) (33μs)
  • beforeRenderModule mod_banners (Sponsors) (8.47KB) (54μs)
  • afterRenderModule mod_banners (Sponsors) (2.57KB) (24μs)
  • beforeRenderModule mod_finder (Search) (4.02KB) (43μ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 (818.49KB) (6.21ms)
  • 1 x afterRenderComponent com_kunena (2.06MB) (32.54%)
    48.43ms
    1 x Before Access::preloadComponents (all components) (1.31MB) (29.16%)
    43.39ms
    1 x afterInitialise (1.16MB) (7.96%)
    11.85ms
    1 x afterRenderRawModule mod_cblogin (Login) (874.48KB) (6.62%)
    9.86ms
    1 x afterRender (818.49KB) (4.18%)
    6.21ms
    1 x afterRenderRawModule mod_jevents_latest (Upcoming Events) (1023.9KB) (3.73%)
    5.55ms
    1 x Before Access::getAssetRules (id:1 name:root.1) (690.84KB) (3.28%)
    4.89ms
    1 x afterRenderRawModule mod_banners (Sponsors) (144.72KB) (1.85%)
    2.75ms
    1 x afterRoute (123.34KB) (1.84%)
    2.74ms
    1 x afterRenderRawModule mod_finder (Search) (356.95KB) (1.79%)
    2.66ms
    1 x afterRenderRawModule mod_menu (Main Menu) (170.91KB) (0.88%)
    1.30ms
    1 x beforeRenderComponent com_kunena (94.41KB) (0.67%)
    1.00ms
    1 x Before Access::getAssetRules (id:1882 name:com_jevents) (164.03KB) (0.65%)
    972μs
    1 x afterLoad (455.24KB) (0.47%)
    703μs
    1 x After Access::preloadComponents (all components) (121.84KB) (0.46%)
    690μs
    1 x afterRenderRawModule mod_menu (footermenu) (56.2KB) (0.34%)
    505μs
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (38.22KB) (0.34%)
    505μs
    1 x beforeRenderRawModule mod_cblogin (Login) (76.06KB) (0.29%)
    433μs
    1 x afterRenderRawModule mod_custom (Network Online!) (14.29KB) (0.15%)
    224μs
    1 x afterDispatch (18.31KB) (0.13%)
    200μs
    1 x beforeRenderModule mod_menu (footermenu) (10.25KB) (0.1%)
    146μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (8.89KB) (0.06%)
    94μs
    1 x afterRenderModule mod_menu (footermenu) (3.43KB) (0.04%)
    61μs
    1 x beforeRenderModule mod_cblogin (Login) (11.95KB) (0.04%)
    57μs
    1 x beforeRenderModule mod_banners (Sponsors) (8.47KB) (0.04%)
    54μs
    1 x afterRenderModule mod_cblogin (Login) (10.51KB) (0.03%)
    47μs
    1 x beforeRenderModule mod_finder (Search) (4.02KB) (0.03%)
    43μs
    1 x beforeRenderModule mod_menu (Main Menu) (7.88KB) (0.03%)
    42μs
    1 x After Access::getAssetRules (id:213 name:com_kunena) (6.89KB) (0.03%)
    41μs
    1 x beforeRenderRawModule mod_menu (footermenu) (496B) (0.03%)
    41μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (6.38KB) (0.03%)
    39μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.8KB) (0.02%)
    33μs
    1 x beforeRenderRawModule mod_jevents_latest (Upcoming Events) (10.03KB) (0.02%)
    29μs
    1 x beforeRenderRawModule mod_banners (Sponsors) (2.89KB) (0.02%)
    27μs
    1 x beforeRenderRawModule mod_finder (Search) (832B) (0.02%)
    26μs
    1 x afterRenderModule mod_custom (Network Online!) (4.07KB) (0.02%)
    26μs
    1 x beforeRenderModule mod_jevents_latest (Upcoming Events) (12.96KB) (0.02%)
    25μs
    1 x afterRenderModule mod_banners (Sponsors) (2.57KB) (0.02%)
    24μs
    1 x beforeRenderRawModule mod_custom (Network Online!) (7.91KB) (0.02%)
    23μs
    1 x afterRenderModule mod_finder (Search) (2.37KB) (0.01%)
    21μs
    1 x afterRenderModule mod_jevents_latest (Upcoming Events) (2.32KB) (0.01%)
    20μs
    1 x afterRenderModule mod_menu (Main Menu) (2.8KB) (0.01%)
    20μs
    1 x Before Access::getAssetRules (id:213 name:com_kunena) (1.23KB) (0.01%)
    18μs
    1 x beforeRenderModule mod_custom (Network Online!) (8.96KB) (0.01%)
    14μs
    1 x After Access::getAssetRules (id:1882 name:com_jevents) (1.28KB) (0.01%)
    8μs
    1 x After Access::getAssetRules (id:1 name:root.1) (1.28KB) (0%)
    7μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (0%)
    4μs
126 statements were executed, 14 of which were duplicates, 112 unique23.8ms501.66KB
  • SELECT @@SESSION.sql_mode;107μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tifas_session` WHERE `session_id` = ?122μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `tifas_session` WHERE `session_id` = :session_id LIMIT 156μ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)355μ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` = 1222μs33.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tifas_viewlevels`59μ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` = :guest64μ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`415μs3.96KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `tifas_kunena_configuration` WHERE `id` = 177μs1.2KB/libraries/kunena/src/Config/KunenaConfig.php:1709Copy
  • SELECT sampleData FROM tifas_kunena_version ORDER BY id DESC LIMIT 175μs536B/libraries/kunena/src/Forum/KunenaForum.php:374Copy
  • 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`492μs20.05KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `tifas_kunena_aliases` WHERE `alias` LIKE '28-computers-in-astronomy%'127μs704B/libraries/kunena/src/Route/KunenaRoute.php:859Copy
  • SHOW TABLES709μs8.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM `tifas_languages` WHERE `published` = 1 ORDER BY `ordering` ASC92μ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` = 1178μs832B/administrator/components/com_templates/src/Model/StyleModel.php:771Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_sessions`334μs1.34KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_users`381μ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,:preparedArray47)409μs7.81KBParams/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)664μ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)663μs584B/plugins/kunena/joomla/KunenaAccessJoomla.php:388Copy
  • SELECT `user_id`,`category_id`,`role` FROM `tifas_kunena_user_categories` WHERE `role` IN (1,2)81μs800B/libraries/kunena/src/Access/KunenaAccess.php:184Copy
  • SELECT * FROM `tifas_kunena_categories` ORDER BY `ordering`,`name`216μs21.27KB/libraries/kunena/src/Forum/Category/KunenaCategoryHelper.php:109Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_categories`354μs1.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '502'134μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '11'118μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '42'145μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '503'88μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '1'104μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '512'102μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '516'113μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '505'103μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '20'109μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '511'116μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '530'84μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '529'84μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '19'117μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '508'104μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '41'113μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '16'104μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '17'100μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '44'103μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '515'100μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '21'106μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '531'85μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '9'85μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '28'86μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '35'86μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '514'128μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '22'100μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '18'101μ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'109μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '513'107μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '517'104μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '3'102μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '39'103μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '33'103μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '2'104μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '40'104μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '30'104μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '45'105μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '46'105μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '528'155μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_topics`309μs1.7KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_topics` WHERE `id` = '33400'126μs13.81KB/libraries/kunena/src/Tables/TableKunenaTopics.php:223Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_messages`295μ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` = 33400150μs2.53KB/libraries/kunena/src/Tables/TableKunenaMessages.php:216Copy
  • SELECT COUNT(*) FROM `tifas_kunena_messages` AS `a` WHERE `thread` = '33400' AND `a`.`hold` IN (0)184μs536B/libraries/kunena/src/Database/Object/KunenaFinder.php:278Copy
  • SELECT a.id FROM `tifas_kunena_messages` AS `a` WHERE `thread` = '33400' AND `a`.`hold` IN (0) ORDER BY a.`time` ASC LIMIT 6164μ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 (33409,33410,33412,33413,33414)178μs2.59KB/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:120Copy
  • SELECT * FROM `tifas_kunena_thankyou` WHERE `postid` IN (33400,33409,33410,33412,33413,33414)99μs688B/libraries/kunena/src/Forum/Message/Thankyou/KunenaMessageThankyouHelper.php:116Copy
  • SELECT u.name, u.username, u.email, u.block AS blocked, u.registerDate, u.lastvisitDate, ku.*, u.id AS userid FROM `tifas_users` AS `u` LEFT JOIN `tifas_kunena_users` AS `ku` ON `u`.`id` = `ku`.`userid` WHERE `u`.`id` IN (69,75)208μs25.02KB/libraries/kunena/src/User/KunenaUserHelper.php:247Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (33400,33409,33410,33412,33413,33414)99μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_user_topics` WHERE (`user_id` = '0') AND (`topic_id` IN (33400))75μs1.27KB/libraries/kunena/src/Forum/Topic/User/KunenaTopicUserHelper.php:159Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_user_topics`240μs1.42KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT u.name, u.username, u.email, u.block as blocked, u.registerDate, u.lastvisitDate, ku.* FROM `tifas_users` AS `u` LEFT JOIN `tifas_kunena_users` AS `ku` ON `u`.`id` = `ku`.`userid` WHERE `u`.`id` = '576'165μs24.97KB/libraries/kunena/src/Tables/KunenaUsers.php:575Copy
  • SELECT `code`,`location` FROM `tifas_kunena_smileys`63μs960B/libraries/kunena/src/BBCode/KunenaBBCode.php:1122Copy
  • UPDATE `tifas_kunena_topics` SET `hits` = (`hits` + 1) WHERE `id` = '33400'359μ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`570μs1.86KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_polls`274μs1.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_ranks`93μs1.48KB/libraries/kunena/src/User/KunenaUser.php:1636Copy
  • SELECT userid, MAX(time) AS time FROM `tifas_session` WHERE `client_id` = 0 AND `userid` > 0 AND `time` > '1744767656' GROUP BY `userid` ORDER BY `time` DESC148μs576B/libraries/kunena/src/User/KunenaUserHelper.php:544Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (33400)121μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (33400)80μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (33409)126μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (33409)90μ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 (33409) GROUP BY `m`.`id`,`mm`.`hold`203μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (33410)91μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (33410)78μ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 (33410) GROUP BY `m`.`id`,`mm`.`hold`189μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (33412)106μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (33412)75μ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 (33412) GROUP BY `m`.`id`,`mm`.`hold`226μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (33413)94μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (33413)83μ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 (33413) GROUP BY `m`.`id`,`mm`.`hold`183μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (33414)106μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (33414)90μ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 (33414) GROUP BY `m`.`id`,`mm`.`hold`194μ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 ASC440μ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-16 02:10:56') AND (`publish_down` ='1000-01-01 00:00:00' OR `publish_down` >= '2025-04-16 02:10:56') ORDER BY `id` DESC LIMIT 182μs1.42KB/libraries/kunena/src/Forum/Announcement/KunenaAnnouncementHelper.php:145Copy
  • SELECT `params` FROM `tifas_comprofiler_plugin` WHERE `id` = 191μs536BCopy
  • SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup FROM `tifas_comprofiler_plugin` WHERE `published` = 1 AND `viewaccesslevel` IN (1) AND `type` = 'user' ORDER BY `ordering`188μs17.73KBCopy
  • SHOW FULL COLUMNS FROM `tifas_users`308μs1.58KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT f.* FROM tifas_comprofiler_fields f INNER JOIN tifas_comprofiler_tabs AS t ON (f.tabid = t.tabid) WHERE f.published = 1 ORDER BY t.position, t.ordering, f.ordering524μs3.61KBCopy
  • SELECT `id` FROM `tifas_menu` WHERE ( `link` = 'index.php?option=com_comprofiler&view=userprofile' OR `link` = 'index.php?option=com_comprofiler&task=userprofile' OR `link` = 'index.php?option=com_comprofiler' ) AND `published` = 1 AND `access` IN ( 1 ) AND `language` IN ( 'en-GB', '*', '' ) AND `client_id` = 0174μs536BCopy
  • SELECT `id` FROM `tifas_menu` WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=pluginclass&plugin=cbconnect%' OR `link` LIKE 'index.php?option=com_comprofiler&task=pluginclass&plugin=cbconnect%' ) AND `published` = 1 AND `access` IN ( 1 ) AND `language` IN ( 'en-GB', '*', '' ) AND `client_id` = 0165μs520BCopy
  • SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup FROM `tifas_comprofiler_plugin` WHERE `published` = 1 AND `viewaccesslevel` IN (1) ORDER BY `ordering`121μs17.77KBCopy
  • SELECT `id` FROM `tifas_menu` WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=login%' OR `link` LIKE 'index.php?option=com_comprofiler&task=login%' ) AND `published` = 1 AND `access` IN ( 1 ) AND `language` IN ( 'en-GB', '*', '' ) AND `client_id` = 0218μs536BCopy
  • SELECT `id` FROM `tifas_menu` WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=lostpassword%' OR `link` LIKE 'index.php?option=com_comprofiler&task=lostpassword%' ) AND `published` = 1 AND `access` IN ( 1 ) AND `language` IN ( 'en-GB', '*', '' ) AND `client_id` = 0211μs536BCopy
  • SELECT `id` FROM `tifas_menu` WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=registers%' OR `link` LIKE 'index.php?option=com_comprofiler&task=registers%' ) AND `published` = 1 AND `access` IN ( 1 ) AND `language` IN ( 'en-GB', '*', '' ) AND `client_id` = 0192μs536BCopy
  • SHOW FULL COLUMNS FROM `tifas_jev_users`263μ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`242μ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 asc181μs584B/components/com_jevents/libraries/dbmodel.php:558Copy
  • 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 asc177μs536B/components/com_jevents/libraries/dbmodel.php:558Copy
  • 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-18 00:00:00' AND ev.created <= '2025-10-13 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 10757μs520B/components/com_jevents/libraries/dbmodel.php:272Copy
  • 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-18 00:00:00' AND ev.created <= '2025-10-13 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 ASC279μs10.33KB/components/com_jevents/libraries/dbmodel.php:3300Copy
  • SELECT `name`,`element` FROM `tifas_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1280μ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)129μ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)198μ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 1382μs2.28KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • UPDATE `tifas_banners` SET `impmade` = `impmade` + 1 WHERE `id` IN (:preparedArray1)426μ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` = :trackDate339μ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` asc171μ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` asc124μs3.18KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy
  • SHOW TABLES726μs8.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy