K-Tec

.xls microsoft spreadsheets cannot be uploaded.

More
19 years 6 months ago #17001 by michaeloconnell
Replied by michaeloconnell on topic Re: .xls microsoft spreadsheets cannot be uploaded.
FWIW, I have tried using Staroffice in the past. I used it to produce the Messier Handbook. I tried it for two reasons:
1) I wanted to create a document which I could export to pdf so that it would print consistently for everyone.
2) I was a little curiuos about this open source stuff.
However, after using it, I have to be honest and say that I though that MS Word was far easier to work with than the word processor in SO. Simple things like not having headers and footers on the first page or keeping the document's structure intact. So many times I had to redo work simply because it would open the document differently to the way it saved it. And the headers and footers issue was painful. However exporting to pdf was really neat.

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

More
19 years 6 months ago #17002 by albertw

One question Al, what's the difference between Openoffice and Staroffice or are they much-of-a-muchness??


The official answer from sun.com:
StarSuite 8 software is a commercial product built on OpenOffice.org’s open source code to provide the best value, multi-platform Microsoft compatible office suite aimed at organizations and consumers. OpenOffice.org 2.0 is the leading open-source project aimed at users of free software, independent developers and the open source community. StarSuite includes licensed-in, third-party technology such as:

* Spellchecker and thesaurus
* Mail Merge Wizard does not have the ability to send mail merge documents as emails.
* Select fonts including Windows metrically equivalent fonts and Asian language fonts
* Select filters, including Asian word processor filters
* Integration of additional templates and extensive clipart gallery
* Migration Tools and Macro Migration Wizard. The converted macros does not run in OpenOffice.org
* Sun Java System Configuration Manager for Solaris, Linux and Windows In addition to product differences, StarSuite offers:
o Updates/upgrades on CD
o Sun installation and user documentation
o 24x7 Web based support for enterprises and consumers
o Help desk support
o Warranties and indemnification guarantee Training
o Professional services for migration and deployment

For a detailed comparison, please see. For more information on components and services available for the OpenOffice.org product, visit the OpenOffice.org Web site.
--
www.sun.com/software/star/openoffice/docs/SO_Comparison_OOo.pdf has a more detailed comparison based on the previous release.

about.openoffice.org/index.html#history has a little of the history of staroffice/openoffice which may be of interest in seeing why things are the way they are.

Oh and openeoffice is free (as in beer) while staroffice costs money for non educational use.

Hope that Helps a bit,
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
19 years 6 months ago #17003 by voyager
HOLD YOUR HORSES!!!!

People seem to have gotten a VERY wrong end of the stick here!

This is not about preventing people using MS Office or about making MS Office users stop being MS Office users!

I don't give a rats ass what software you use to CREATE your content. That is none of mine or anyone else business!

What I DO care about is the format you choose to PUBLISH your content with and that is a very different thing. If you go to my website ( www.minds.nuim.ie/~voyager ) and download a copy of the slides from some of my talks many of them were made with MS Power Point, if you download a copy fo my 4th year thesis it was made in with MS Binder* and MS Word. HOWEVER I have published all these documents in an open format, PDF. This means that regardless of how I made them the documents are viewable by all for all time!

All I am asking is that people convert their documents to an openformat before they publish them here. To do this you can use the free and very small and easy to download PDF print driver. I am also prepared to add any other open format to the list of allowed formats if it makes things easier for people.

To publish your content here you need to do two things:
1) convert it to a publishable format
2) fill in a form to upload it

That is not a lot to ask and is a hell of a lot easier than publishing content on most web sites!

This is not an anti-MS thing it is an accessibility thing. Content on this site must be accessible to all and not just to the purchasers of one product or another.

My Home Page - www.bartbusschots.ie

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

More
19 years 6 months ago #17004 by voyager
Sorry, forgot to add in the details of the little * I put next to MS Binder!

MS Binder is one of the reason I no longer store data in closed formats. Binder was a nice product that shipped with MS Office 97 that allowed you to build up a book from many individual MS Office documents and it would take care of sorting out the numbering etc for you. This was perfect for writting a thesis in. I had each chaper as a separate MS Word Document and I just added them all together in Binder when I need my full thesis.

Great, so what's the poblem? Well MS decided that they were diss-continuing Binder and with no warning it just dissapeared from Office in all versions after 97. So, a few months ago someone asked me for a copy of my thesis so I said "no bother I'll email it to you". I got back and email going "WTF is a Binder file?". I then decided to convert it to a PDF but I hit a snag, my PC at work had been upgraded from Office97 to OfficeXP which had no Binder. I could not open my own Thesis!!!! It took me a lot of time and effort to find an old machine that still had Office 97 to finally convert my thesis to a PDF.

The moral of the story, if you value your data don't entrust it to a closed format, you may never get the bloody data out again!

My Home Page - www.bartbusschots.ie

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

More
19 years 6 months ago #17006 by voyager

Will pdf work with spreadsheets?


Yup! If you can print it you can PDF it! It is a most excellent format. BTW PDF stands for "Portable Document Format" and that is exactly what it is, it is a way to send just about any document in a way that the reciever can read it regardless of what OS they are using or what software they decided to buy, that is a text book example of what computer scientists mean by "portability"

Can someone on dial-up realistically download the Openoffice program?


Nope.

Does your average Joe Soap who has a passing interest in astronomy an a very average knowledge of computers/software really be expected to avoid using Microsoft software?


Nope! But that's not what I'm asking! Use what ever software you like just convert your generated content to an open format for publishing. In the case of an MS Office document that is as simple as clicking print, selecting the PDF Printer (everyone shoult install a PDF printer), clicking 'print' and entering a file name when asked. That's it!

I could understand Bart that you may want to encourage opensource software, but to place a ban on software which the vast majority of people have, is not lookng at the bigger picture.


Software NOT EQUAL file format. I am NOT 'banning' MS software, just proprietart MS File Formats. This is a VERY differnt thing.

BTW, don't get me wrong, the ethics of MS are far from ideal. However, you don't cut off your face to spite your nose.



Interesting analogy but not what I'm proposing at all.

My Home Page - www.bartbusschots.ie

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

More
19 years 6 months ago #17007 by lionsden
Not sure I should stick my snout in here as things look like they could get a little heated. Ah what the hell! Here goes anyway! :P

For free, anyone can download Excel, Word, Powerpoint etc, viewers from the Microsoft website, the link to the Excel one is here:
www.microsoft.com/downloads/details.aspx...0&displaylang=EN

Does this make it open to everyone?

Now I'll duck!!! :D

Leo @ Lionsden
Perhap because light travels faster than sound, some people appear bright until you hear them speak.

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

Moderators: darragh
Time to create page: 0.122 seconds
Powered by Kunena Forum
Settings12.077MBMemory Usage192msRequest Duration
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
Joomla! Version5.3.0
PHP Version8.4.6
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" => "18" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:42 [ "USER" => "www-data" "HOME" => "/var/www" "HTTP_ACCEPT_ENCODING" => "gzip, deflate,...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1745713598 "last" => 1745713598...
registry
array:3 [ "data" => array:3 [ "com_kunena" => array:2 [ "user0_read" => array:32 [ ...
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_webauthn
array:1 [ "returnUrl" => "https://www.irishastronomy.org/kunena/9-bugs-suggestions-and-feedback/16...
  • afterLoad (79.75KB) (790μs)
  • afterInitialise (1.32MB) (13.58ms)
  • afterRoute (187.09KB) (5ms)
  • beforeRenderComponent com_kunena (32.09KB) (1.93ms)
  • Before Access::preloadComponents (all components) (1.42MB) (52.41ms)
  • After Access::preloadComponents (all components) (135.12KB) (884μs)
  • Before Access::getAssetRules (id:213 name:com_kunena) (1.35KB) (21μs)
  • After Access::getAssetRules (id:213 name:com_kunena) (6.89KB) (80μs)
  • afterRenderComponent com_kunena (2MB) (69.09ms)
  • afterDispatch (18.32KB) (281μs)
  • beforeRenderRawModule mod_cblogin (Login) (117.76KB) (694μs)
  • Before Access::getAssetRules (id:1 name:root.1) (789.28KB) (6.58ms)
  • After Access::getAssetRules (id:1 name:root.1) (1.28KB) (11μs)
  • afterRenderRawModule mod_cblogin (Login) (1.01MB) (12.34ms)
  • beforeRenderRawModule mod_custom (Network Online!) (8.05KB) (25μs)
  • afterRenderRawModule mod_custom (Network Online!) (3.98KB) (276μs)
  • beforeRenderRawModule mod_jevents_latest (Upcoming Events) (10.03KB) (30μs)
  • Before Access::getAssetRules (id:1882 name:com_jevents) (314.87KB) (1.37ms)
  • After Access::getAssetRules (id:1882 name:com_jevents) (1.28KB) (10μs)
  • afterRenderRawModule mod_jevents_latest (Upcoming Events) (1.07MB) (6.8ms)
  • beforeRenderRawModule mod_menu (Main Menu) (6.41KB) (47μs)
  • afterRenderRawModule mod_menu (Main Menu) (356.72KB) (2.06ms)
  • beforeRenderRawModule mod_finder (Search) (864B) (27μs)
  • afterRenderRawModule mod_finder (Search) (477.75KB) (3.65ms)
  • beforeRenderRawModule mod_banners (Sponsors) (2.86KB) (28μs)
  • afterRenderRawModule mod_banners (Sponsors) (435.28KB) (3.65ms)
  • beforeRenderRawModule mod_menu (footermenu) (448B) (42μs)
  • afterRenderRawModule mod_menu (footermenu) (112.62KB) (587μs)
  • beforeRenderModule mod_menu (footermenu) (16.51KB) (304μs)
  • afterRenderModule mod_menu (footermenu) (10.9KB) (145μs)
  • beforeRenderModule mod_cblogin (Login) (17.85KB) (80μs)
  • afterRenderModule mod_cblogin (Login) (17.98KB) (89μs)
  • beforeRenderModule mod_custom (Network Online!) (9.59KB) (15μs)
  • afterRenderModule mod_custom (Network Online!) (11.54KB) (55μs)
  • beforeRenderModule mod_jevents_latest (Upcoming Events) (8.47KB) (28μs)
  • afterRenderModule mod_jevents_latest (Upcoming Events) (9.79KB) (51μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (27.12KB) (144μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (96.2KB) (651μs)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (4μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (10.4KB) (60μs)
  • beforeRenderModule mod_banners (Sponsors) (14.23KB) (69μs)
  • afterRenderModule mod_banners (Sponsors) (10.04KB) (50μs)
  • beforeRenderModule mod_finder (Search) (9.77KB) (61μs)
  • afterRenderModule mod_finder (Search) (9.84KB) (47μs)
  • beforeRenderModule mod_menu (Main Menu) (13.63KB) (60μs)
  • afterRenderModule mod_menu (Main Menu) (10.27KB) (45μs)
  • afterRender (1.18MB) (7.16ms)
  • 1 x afterRenderComponent com_kunena (2MB) (36.04%)
    69.09ms
    1 x Before Access::preloadComponents (all components) (1.42MB) (27.34%)
    52.41ms
    1 x afterInitialise (1.32MB) (7.08%)
    13.58ms
    1 x afterRenderRawModule mod_cblogin (Login) (1.01MB) (6.44%)
    12.34ms
    1 x afterRender (1.18MB) (3.73%)
    7.16ms
    1 x afterRenderRawModule mod_jevents_latest (Upcoming Events) (1.07MB) (3.55%)
    6.80ms
    1 x Before Access::getAssetRules (id:1 name:root.1) (789.28KB) (3.43%)
    6.58ms
    1 x afterRoute (187.09KB) (2.61%)
    5.00ms
    1 x afterRenderRawModule mod_banners (Sponsors) (435.28KB) (1.91%)
    3.65ms
    1 x afterRenderRawModule mod_finder (Search) (477.75KB) (1.9%)
    3.65ms
    1 x afterRenderRawModule mod_menu (Main Menu) (356.72KB) (1.08%)
    2.06ms
    1 x beforeRenderComponent com_kunena (32.09KB) (1.01%)
    1.93ms
    1 x Before Access::getAssetRules (id:1882 name:com_jevents) (314.87KB) (0.71%)
    1.37ms
    1 x After Access::preloadComponents (all components) (135.12KB) (0.46%)
    884μs
    1 x afterLoad (79.75KB) (0.41%)
    790μs
    1 x beforeRenderRawModule mod_cblogin (Login) (117.76KB) (0.36%)
    694μs
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (96.2KB) (0.34%)
    651μs
    1 x afterRenderRawModule mod_menu (footermenu) (112.62KB) (0.31%)
    587μs
    1 x beforeRenderModule mod_menu (footermenu) (16.51KB) (0.16%)
    304μs
    1 x afterDispatch (18.32KB) (0.15%)
    281μs
    1 x afterRenderRawModule mod_custom (Network Online!) (3.98KB) (0.14%)
    276μs
    1 x afterRenderModule mod_menu (footermenu) (10.9KB) (0.08%)
    145μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (27.12KB) (0.08%)
    144μs
    1 x afterRenderModule mod_cblogin (Login) (17.98KB) (0.05%)
    89μs
    1 x After Access::getAssetRules (id:213 name:com_kunena) (6.89KB) (0.04%)
    80μs
    1 x beforeRenderModule mod_cblogin (Login) (17.85KB) (0.04%)
    80μs
    1 x beforeRenderModule mod_banners (Sponsors) (14.23KB) (0.04%)
    69μs
    1 x beforeRenderModule mod_finder (Search) (9.77KB) (0.03%)
    61μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (10.4KB) (0.03%)
    60μs
    1 x beforeRenderModule mod_menu (Main Menu) (13.63KB) (0.03%)
    60μs
    1 x afterRenderModule mod_custom (Network Online!) (11.54KB) (0.03%)
    55μs
    1 x afterRenderModule mod_jevents_latest (Upcoming Events) (9.79KB) (0.03%)
    51μs
    1 x afterRenderModule mod_banners (Sponsors) (10.04KB) (0.03%)
    50μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (6.41KB) (0.02%)
    47μs
    1 x afterRenderModule mod_finder (Search) (9.84KB) (0.02%)
    47μs
    1 x afterRenderModule mod_menu (Main Menu) (10.27KB) (0.02%)
    45μs
    1 x beforeRenderRawModule mod_menu (footermenu) (448B) (0.02%)
    42μs
    1 x beforeRenderRawModule mod_jevents_latest (Upcoming Events) (10.03KB) (0.02%)
    30μs
    1 x beforeRenderRawModule mod_banners (Sponsors) (2.86KB) (0.01%)
    28μs
    1 x beforeRenderModule mod_jevents_latest (Upcoming Events) (8.47KB) (0.01%)
    28μs
    1 x beforeRenderRawModule mod_finder (Search) (864B) (0.01%)
    27μs
    1 x beforeRenderRawModule mod_custom (Network Online!) (8.05KB) (0.01%)
    25μs
    1 x Before Access::getAssetRules (id:213 name:com_kunena) (1.35KB) (0.01%)
    21μs
    1 x beforeRenderModule mod_custom (Network Online!) (9.59KB) (0.01%)
    15μs
    1 x After Access::getAssetRules (id:1 name:root.1) (1.28KB) (0.01%)
    11μs
    1 x After Access::getAssetRules (id:1882 name:com_jevents) (1.28KB) (0.01%)
    10μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    4μs
130 statements were executed, 14 of which were duplicates, 116 unique36.28ms492.29KB
  • SELECT @@SESSION.sql_mode;126μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `tifas_session` WHERE `session_id` = ?212μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `tifas_session` WHERE `session_id` = :session_id LIMIT 177μ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)651μ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` = 1339μs33.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tifas_viewlevels`113μ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` = :guest99μ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`520μs4.46KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `tifas_kunena_configuration` WHERE `id` = 1110μs1.2KB/libraries/kunena/src/Config/KunenaConfig.php:1711Copy
  • SELECT sampleData FROM tifas_kunena_version ORDER BY id DESC LIMIT 1295μ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`428μs20.05KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `tifas_kunena_aliases` WHERE `alias` LIKE '9-bugs-suggestions-and-feedback%'158μs704B/libraries/kunena/src/Route/KunenaRoute.php:800Copy
  • SHOW FULL TABLES WHERE table_type="BASE TABLE"1.92ms8.56KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT * FROM `tifas_languages` WHERE `published` = 1 ORDER BY `ordering` ASC138μs1.59KB/libraries/src/Language/LanguageHelper.php:179Copy
  • 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` = 1176μs832B/administrator/components/com_templates/src/Model/StyleModel.php:718Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_sessions`318μs1.34KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_users`329μs3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • 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)492μ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)721μ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)895μs584B/plugins/kunena/joomla/KunenaAccessJoomla.php:388Copy
  • SELECT `user_id`,`category_id`,`role` FROM `tifas_kunena_user_categories` WHERE `role` IN (1,2)112μs800B/libraries/kunena/src/Access/KunenaAccess.php:168Copy
  • SELECT * FROM `tifas_kunena_categories` ORDER BY `ordering`,`name`345μs21.27KB/libraries/kunena/src/Forum/Category/KunenaCategoryHelper.php:101Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_categories`390μs1.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '502'166μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '11'138μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '42'126μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '503'125μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '1'126μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '512'121μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '516'121μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '505'127μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '20'123μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '511'161μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '530'114μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '529'124μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '19'122μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '508'119μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '41'162μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '16'125μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '17'122μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '44'107μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '515'121μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '21'129μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '531'128μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '9'113μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '28'126μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '35'124μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '514'111μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '22'125μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '18'130μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '29'130μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '27'125μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '513'131μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '517'126μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '3'125μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '39'153μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '33'125μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '2'173μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '40'118μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '30'155μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '45'132μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '46'310μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '528'120μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_topics`362μs1.7KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • SELECT * FROM `tifas_kunena_topics` WHERE `id` = '16980'140μs13.81KB/libraries/kunena/src/Tables/TableKunenaTopics.php:223Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_messages`330μs1.58KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • 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` = 16980156μs2.53KB/libraries/kunena/src/Tables/TableKunenaMessages.php:216Copy
  • SELECT COUNT(*) FROM `tifas_kunena_messages` AS `a` WHERE `thread` = '16980' AND `a`.`hold` IN (0)205μs536B/libraries/kunena/src/Database/Finder/KunenaFinder.php:278Copy
  • SELECT a.id FROM `tifas_kunena_messages` AS `a` WHERE `thread` = '16980' AND `a`.`hold` IN (0) ORDER BY a.`time` ASC LIMIT 18, 6199μs616B/libraries/kunena/src/Database/Finder/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 (17001,17002,17003,17004,17006,17007)710μs2.61KB/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:120Copy
  • SELECT * FROM `tifas_kunena_thankyou` WHERE `postid` IN (17001,17002,17003,17004,17006,17007)123μs688B/libraries/kunena/src/Forum/Message/Thankyou/KunenaMessageThankyouHelper.php:116Copy
  • SELECT u.name, u.username, u.email, u.block AS blocked, u.registerDate, u.lastvisitDate, ku.*, u.id AS userid FROM `tifas_users` AS `u` LEFT JOIN `tifas_kunena_users` AS `ku` ON `u`.`id` = `ku`.`userid` WHERE `u`.`id` IN (95,69,65,208)251μs20.89KB/libraries/kunena/src/User/KunenaUserHelper.php:250Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (17001,17002,17003,17004,17006,17007)123μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_user_topics` WHERE (`user_id` = '0') AND (`topic_id` IN (16980))100μs1.27KB/libraries/kunena/src/Forum/Topic/User/KunenaTopicUserHelper.php:159Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_user_topics`301μs1.42KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • 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` = '542'212μs4.69KB/libraries/kunena/src/Tables/KunenaUsers.php:337Copy
  • 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` = '82'361μs4.69KB/libraries/kunena/src/Tables/KunenaUsers.php:337Copy
  • SELECT `code`,`location` FROM `tifas_kunena_smileys`100μs960B/libraries/kunena/src/BBCode/KunenaBBCode.php:1130Copy
  • UPDATE `tifas_kunena_topics` SET `hits` = (`hits` + 1) WHERE `id` = '16980'474μs48B/libraries/src/Table/Table.php:1348Copy
  • 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`812μs1.86KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_polls`302μs1.33KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • SELECT * FROM `tifas_kunena_ranks`106μs1.48KB/libraries/kunena/src/User/KunenaUser.php:1479Copy
  • SELECT userid, MAX(time) AS time FROM `tifas_session` WHERE `client_id` = 0 AND `userid` > 0 AND `time` > '1745711798' GROUP BY `userid` ORDER BY `time` DESC248μs576B/libraries/kunena/src/User/KunenaUserHelper.php:547Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (17001)105μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (17001)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 (17001) GROUP BY `m`.`id`,`mm`.`hold`274μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (17002)116μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (17002)92μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT m.id, mm.hold, m.catid AS category_id, m.thread AS topic_id, SUM(mm.time<m.time) AS before_count, SUM(mm.time>m.time) AS after_count FROM `tifas_kunena_messages` AS `m` INNER JOIN `tifas_kunena_messages` AS `mm` ON `m`.`thread` = `mm`.`thread` WHERE `m`.`id` IN (17002) GROUP BY `m`.`id`,`mm`.`hold`3.45ms832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (17003)203μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (17003)147μ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 (17003) GROUP BY `m`.`id`,`mm`.`hold`434μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (17004)141μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (17004)130μ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 (17004) GROUP BY `m`.`id`,`mm`.`hold`251μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (17006)122μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (17006)127μ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 (17006) GROUP BY `m`.`id`,`mm`.`hold`359μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (17007)126μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (17007)131μ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 (17007) GROUP BY `m`.`id`,`mm`.`hold`311μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • 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 (599)223μs4.84KB/libraries/kunena/src/User/KunenaUserHelper.php:250Copy
  • 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 ASC564μs4.03KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT * FROM `tifas_kunena_announcement` WHERE `published` = 1 AND (`publish_up` = '1000-01-01 00:00:00' OR `publish_up` <= '2025-04-27 00:26:38') AND (`publish_down` ='1000-01-01 00:00:00' OR `publish_down` >= '2025-04-27 00:26:38') ORDER BY `id` DESC LIMIT 1130μs1.42KB/libraries/kunena/src/Forum/Announcement/KunenaAnnouncementHelper.php:145Copy
  • SELECT `params` FROM `tifas_comprofiler_plugin` WHERE `id` = 1116μ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`216μs17.73KBCopy
  • SHOW FULL COLUMNS FROM `tifas_users`354μs1.58KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • 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.ordering597μ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` = 0218μ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` = 0322μs520BCopy
  • SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup FROM `tifas_comprofiler_plugin` WHERE `published` = 1 AND `viewaccesslevel` IN (1) ORDER BY `ordering`224μ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` = 0220μ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` = 0221μ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` = 0203μs536BCopy
  • SHOW FULL COLUMNS FROM `tifas_jev_users`394μs1.58KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • 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`307μ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 asc205μs584B/components/com_jevents/libraries/dbmodel.php:563Copy
  • 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 asc179μs536B/components/com_jevents/libraries/dbmodel.php:563Copy
  • 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-29 00:00:00' AND ev.created <= '2025-10-24 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 10788μs520B/components/com_jevents/libraries/dbmodel.php:277Copy
  • 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-29 00:00:00' AND ev.created <= '2025-10-24 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 ASC296μs10.33KB/components/com_jevents/libraries/dbmodel.php:3305Copy
  • SELECT `name`,`element` FROM `tifas_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1335μs736B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `tifas_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1)117μs584B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • SELECT * FROM `tifas_banners` WHERE (`reset` <= :date AND `reset` IS NOT NULL) AND (`checked_out` IS NULL OR `checked_out` = :userId)325μ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 1421μs2.28KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • UPDATE `tifas_banners` SET `impmade` = `impmade` + 1 WHERE `id` IN (:preparedArray1)421μ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` = :trackDate355μs832BParams/components/com_banners/src/Model/BannersModel.php:352Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `tifas_scheduler_tasks` AS `a` WHERE `a`.`state` = 1164μs1.32KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SHOW FULL TABLES WHERE table_type="BASE TABLE"1.19ms8.56KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT `session_id` FROM `tifas_session` WHERE `session_id` = ?126μs9KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `tifas_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?501μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy