K-Tec

.xls microsoft spreadsheets cannot be uploaded.

More
19 years 5 months ago #17054 by albertw

No Al...not entirely serious...I haven't completely lost my marbles just yet, athough may be getting there! :wink: Just thought I've try and show an "alternative", albeit an amusing one! Besides, if I did write a simple java ap, I've a feeling, albeit I'm open to correction, it may take up more bandwidth than 24kb, which is all my eyepiece calculator.xls file takes up. Ah well...


Ah right, so taking the macro or formulas or whatver out and writing it in Java.

I'd imagine the java would be bigger, you have to weigh up the size of excel and its memory cpu consuption against the JVM's size memory and cpu consumption as well. Then weigh that against the benefits of writing in Java. Your app can run on any webpage which you cant do in excel. It can be downloaded to any computer and run as you intended which you cant do with excel. And if you like you can create it so that the user automatically can connect to your server and download any updates that you have, again which you cant do in excel. Depends on what you want to do. Where do you want to go today versus where do you want to go tomorrow ;-)

But if you want to compare pears with pearlike things I could probably write the tool in C to run on windows in less than 24kb.

Mail be the formula/spreadsheet and I'll look at writing it in java over christmas.

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 5 months ago #17059 by Macros42

Folks,

Please execusea few remarks from an LTL...
(1) GIF is a proprietary format.Brian.


So's PDF but it's also an open format in that it's not OS or software specific. PNG should be the graphical format of choice though :P

Steve
--
"Common sense is the collection of prejudices acquired by age eighteen" -- Albert Einstein

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

More
19 years 5 months ago #17060 by Macros42

Yea right...
They are adding that so that they don't have to supoport opendoc IMHO

informationweek.com/story/showArticle.jhtml?articleID=170700325

Cheers,
~Al


I knew I'd read this somewhere too - MS Office XML
It's their own XML format which they say is Open but it ain't.

Steve
--
"Common sense is the collection of prejudices acquired by age eighteen" -- Albert Einstein

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

More
19 years 5 months ago #17061 by michaeloconnell
Replied by michaeloconnell on topic Re: .xls microsoft spreadsheets cannot be uploaded.

Where do you want to go today versus where do you want to go tomorrow ;-)

I think you've a calling for marketing...must let your bosses know how multi-talented you are! :wink:

Mail be the formula/spreadsheet and I'll look at writing it in java over christmas.


It's ok Al. I'll allow you a java-free Christmas! :wink: However, I appreciate the offer. Besides, I doubt you'll have the time to write a java ap for every spreadsheet that comes along.

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

More
19 years 5 months ago #17062 by michaeloconnell
Replied by michaeloconnell on topic Re: .xls microsoft spreadsheets cannot be uploaded.
BTW, I've enjoyed this discussion, especially as the weather is terrible and I'm on hols for the next 10 days.

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

  • Jed Glover
  • Topic Author
  • Offline
  • Main Sequence
  • Main Sequence
More
19 years 5 months ago #17065 by Jed Glover
Wow, if only everything I said caused as much impact :)

The spread sheet is 17Kb.

As a DBA I can only sympathise with the anti MS slant here, it causes me a lot of problems in my work life as well.

On the data front as open office and most other commercial spread sheets can read .xls I don’t really see the problem. However if the webmaster says no we have to live with this restriction.

I will ask Dave Grennan if he will host it, is it permissible to post a link?

Thanks,

Jed

PS Sorry for causing a fire storm

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

Moderators: darragh
Time to create page: 0.112 seconds
Powered by Kunena Forum
11MBMemory Usage178msRequest 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" => "60" ]
$_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" => 1745218788 "last" => 1745218788...
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/9-bugs-suggestions-and-feedback/16...
  • afterLoad (455.35KB) (734μs)
  • afterInitialise (1.16MB) (10.95ms)
  • afterRoute (123.33KB) (2.81ms)
  • beforeRenderComponent com_kunena (94.38KB) (1.25ms)
  • Before Access::preloadComponents (all components) (1.31MB) (51.45ms)
  • After Access::preloadComponents (all components) (121.84KB) (868μs)
  • Before Access::getAssetRules (id:213 name:com_kunena) (1.23KB) (18μs)
  • After Access::getAssetRules (id:213 name:com_kunena) (6.89KB) (45μs)
  • afterRenderComponent com_kunena (2.15MB) (60.13ms)
  • afterDispatch (18.37KB) (186μs)
  • beforeRenderRawModule mod_cblogin (Login) (76.06KB) (458μs)
  • Before Access::getAssetRules (id:1 name:root.1) (690.91KB) (5.8ms)
  • After Access::getAssetRules (id:1 name:root.1) (1.28KB) (11μs)
  • afterRenderRawModule mod_cblogin (Login) (874.05KB) (12ms)
  • beforeRenderRawModule mod_custom (Network Online!) (7.91KB) (24μs)
  • afterRenderRawModule mod_custom (Network Online!) (14.29KB) (259μs)
  • beforeRenderRawModule mod_jevents_latest (Upcoming Events) (10.03KB) (28μs)
  • Before Access::getAssetRules (id:1882 name:com_jevents) (164.03KB) (1.02ms)
  • After Access::getAssetRules (id:1882 name:com_jevents) (1.28KB) (9μs)
  • afterRenderRawModule mod_jevents_latest (Upcoming Events) (1MB) (6.19ms)
  • beforeRenderRawModule mod_menu (Main Menu) (6.38KB) (46μs)
  • afterRenderRawModule mod_menu (Main Menu) (172.16KB) (1.39ms)
  • beforeRenderRawModule mod_finder (Search) (832B) (26μs)
  • afterRenderRawModule mod_finder (Search) (356.32KB) (3.38ms)
  • beforeRenderRawModule mod_banners (Sponsors) (2.89KB) (26μs)
  • afterRenderRawModule mod_banners (Sponsors) (144.72KB) (3.66ms)
  • beforeRenderRawModule mod_menu (footermenu) (496B) (43μs)
  • afterRenderRawModule mod_menu (footermenu) (54.95KB) (479μs)
  • beforeRenderModule mod_menu (footermenu) (10.25KB) (345μs)
  • afterRenderModule mod_menu (footermenu) (3.43KB) (72μs)
  • beforeRenderModule mod_cblogin (Login) (11.95KB) (59μs)
  • afterRenderModule mod_cblogin (Login) (10.51KB) (91μs)
  • beforeRenderModule mod_custom (Network Online!) (8.96KB) (18μs)
  • afterRenderModule mod_custom (Network Online!) (4.07KB) (29μs)
  • beforeRenderModule mod_jevents_latest (Upcoming Events) (12.96KB) (26μs)
  • afterRenderModule mod_jevents_latest (Upcoming Events) (2.32KB) (23μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (8.89KB) (104μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (38.48KB) (942μs)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (4μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.93KB) (33μs)
  • beforeRenderModule mod_banners (Sponsors) (8.47KB) (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) (42μs)
  • afterRenderModule mod_menu (Main Menu) (2.8KB) (20μs)
  • afterRender (842.49KB) (8.63ms)
  • 1 x afterRenderComponent com_kunena (2.15MB) (33.78%)
    60.13ms
    1 x Before Access::preloadComponents (all components) (1.31MB) (28.9%)
    51.45ms
    1 x afterRenderRawModule mod_cblogin (Login) (874.05KB) (6.74%)
    12.00ms
    1 x afterInitialise (1.16MB) (6.15%)
    10.95ms
    1 x afterRender (842.49KB) (4.85%)
    8.63ms
    1 x afterRenderRawModule mod_jevents_latest (Upcoming Events) (1MB) (3.48%)
    6.19ms
    1 x Before Access::getAssetRules (id:1 name:root.1) (690.91KB) (3.26%)
    5.80ms
    1 x afterRenderRawModule mod_banners (Sponsors) (144.72KB) (2.06%)
    3.66ms
    1 x afterRenderRawModule mod_finder (Search) (356.32KB) (1.9%)
    3.38ms
    1 x afterRoute (123.33KB) (1.58%)
    2.81ms
    1 x afterRenderRawModule mod_menu (Main Menu) (172.16KB) (0.78%)
    1.39ms
    1 x beforeRenderComponent com_kunena (94.38KB) (0.7%)
    1.25ms
    1 x Before Access::getAssetRules (id:1882 name:com_jevents) (164.03KB) (0.57%)
    1.02ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (38.48KB) (0.53%)
    942μs
    1 x After Access::preloadComponents (all components) (121.84KB) (0.49%)
    868μs
    1 x afterLoad (455.35KB) (0.41%)
    734μs
    1 x afterRenderRawModule mod_menu (footermenu) (54.95KB) (0.27%)
    479μs
    1 x beforeRenderRawModule mod_cblogin (Login) (76.06KB) (0.26%)
    458μs
    1 x beforeRenderModule mod_menu (footermenu) (10.25KB) (0.19%)
    345μs
    1 x afterRenderRawModule mod_custom (Network Online!) (14.29KB) (0.15%)
    259μs
    1 x afterDispatch (18.37KB) (0.1%)
    186μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (8.89KB) (0.06%)
    104μs
    1 x afterRenderModule mod_cblogin (Login) (10.51KB) (0.05%)
    91μs
    1 x afterRenderModule mod_menu (footermenu) (3.43KB) (0.04%)
    72μs
    1 x beforeRenderModule mod_cblogin (Login) (11.95KB) (0.03%)
    59μs
    1 x beforeRenderModule mod_banners (Sponsors) (8.47KB) (0.03%)
    54μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (6.38KB) (0.03%)
    46μs
    1 x After Access::getAssetRules (id:213 name:com_kunena) (6.89KB) (0.03%)
    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%)
    42μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.93KB) (0.02%)
    33μs
    1 x afterRenderModule mod_custom (Network Online!) (4.07KB) (0.02%)
    29μs
    1 x beforeRenderRawModule mod_jevents_latest (Upcoming Events) (10.03KB) (0.02%)
    28μs
    1 x beforeRenderRawModule mod_finder (Search) (832B) (0.01%)
    26μs
    1 x beforeRenderRawModule mod_banners (Sponsors) (2.89KB) (0.01%)
    26μs
    1 x beforeRenderModule mod_jevents_latest (Upcoming Events) (12.96KB) (0.01%)
    26μs
    1 x beforeRenderRawModule mod_custom (Network Online!) (7.91KB) (0.01%)
    24μs
    1 x afterRenderModule mod_jevents_latest (Upcoming Events) (2.32KB) (0.01%)
    23μ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%)
    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%)
    18μ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%)
    9μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (720B) (0%)
    4μs
128 statements were executed, 14 of which were duplicates, 114 unique31.22ms527.52KB
  • SELECT @@SESSION.sql_mode;80μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `tifas_session` WHERE `session_id` = ?117μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • 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)473μ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` = 1286μs33.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tifas_viewlevels`91μ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` = :guest91μ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`465μs3.96KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `tifas_kunena_configuration` WHERE `id` = 197μs1.2KB/libraries/kunena/src/Config/KunenaConfig.php:1709Copy
  • SELECT sampleData FROM tifas_kunena_version ORDER BY id DESC LIMIT 189μ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`469μs20.05KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `tifas_kunena_aliases` WHERE `alias` LIKE '9-bugs-suggestions-and-feedback%'130μs704B/libraries/kunena/src/Route/KunenaRoute.php:859Copy
  • SHOW TABLES740μs8.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy
  • SELECT * FROM `tifas_languages` WHERE `published` = 1 ORDER BY `ordering` ASC128μ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` = 1165μs832B/administrator/components/com_templates/src/Model/StyleModel.php:771Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_sessions`418μs1.34KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_users`540μ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)507μ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)679μ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)714μs584B/plugins/kunena/joomla/KunenaAccessJoomla.php:388Copy
  • SELECT `user_id`,`category_id`,`role` FROM `tifas_kunena_user_categories` WHERE `role` IN (1,2)102μs800B/libraries/kunena/src/Access/KunenaAccess.php:184Copy
  • SELECT * FROM `tifas_kunena_categories` ORDER BY `ordering`,`name`287μs21.27KB/libraries/kunena/src/Forum/Category/KunenaCategoryHelper.php:109Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_categories`339μs1.89KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '502'308μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '11'125μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '42'122μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '503'123μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '1'110μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '512'112μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '516'125μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '505'112μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '20'305μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '511'124μs7.16KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '530'122μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '529'109μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '19'112μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '508'162μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '41'117μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '16'113μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '17'112μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '44'300μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '515'118μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '21'119μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '531'105μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '9'110μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '28'112μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '35'128μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '514'115μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '22'113μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '18'115μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '29'117μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '27'114μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '513'113μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '517'115μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '3'119μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '39'117μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '33'127μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '2'111μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '40'116μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '30'115μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '45'113μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '46'110μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SELECT * FROM `tifas_kunena_categories` WHERE `id` = '528'115μs4.66KB/libraries/kunena/src/Tables/TableKunenaCategories.php:295Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_topics`564μs1.7KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • SELECT * FROM `tifas_kunena_topics` WHERE `id` = '16980'117μs13.81KB/libraries/kunena/src/Tables/TableKunenaTopics.php:223Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_messages`446μ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` = 16980450μ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)201μs536B/libraries/kunena/src/Database/Object/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 60, 6208μ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 (17054,17059,17060,17061,17062,17065)2.34ms2.61KB/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:120Copy
  • SELECT * FROM `tifas_kunena_thankyou` WHERE `postid` IN (17054,17059,17060,17061,17062,17065)119μ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,484,95,542)261μs25.05KB/libraries/kunena/src/User/KunenaUserHelper.php:247Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (17054,17059,17060,17061,17062,17065)120μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_user_topics` WHERE (`user_id` = '0') AND (`topic_id` IN (16980))94μs1.27KB/libraries/kunena/src/Forum/Topic/User/KunenaTopicUserHelper.php:159Copy
  • SHOW FULL COLUMNS FROM `tifas_kunena_user_topics`296μ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` = '82'201μs24.97KB/libraries/kunena/src/Tables/KunenaUsers.php:575Copy
  • SELECT `code`,`location` FROM `tifas_kunena_smileys`73μs960B/libraries/kunena/src/BBCode/KunenaBBCode.php:1122Copy
  • UPDATE `tifas_kunena_topics` SET `hits` = (`hits` + 1) WHERE `id` = '16980'392μ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`596μ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`99μ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` > '1745216988' GROUP BY `userid` ORDER BY `time` DESC155μs576B/libraries/kunena/src/User/KunenaUserHelper.php:544Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (17054)97μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (17054)91μ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 (17054) GROUP BY `m`.`id`,`mm`.`hold`243μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (17059)97μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (17059)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 (17059) GROUP BY `m`.`id`,`mm`.`hold`242μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (17060)97μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (17060)98μ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 (17060) GROUP BY `m`.`id`,`mm`.`hold`225μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (17061)115μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (17061)100μ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 (17061) GROUP BY `m`.`id`,`mm`.`hold`238μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (17062)94μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (17062)113μ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 (17062) GROUP BY `m`.`id`,`mm`.`hold`277μs832B/libraries/kunena/src/Forum/Message/KunenaMessageHelper.php:539Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (17065)121μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT * FROM `tifas_kunena_attachments` WHERE `mesid` IN (17065)97μs1.45KB/libraries/kunena/src/Attachment/KunenaAttachmentHelper.php:234Copy
  • SELECT m.id, mm.hold, m.catid AS category_id, m.thread AS topic_id, SUM(mm.time<m.time) AS before_count, SUM(mm.time>m.time) AS after_count FROM `tifas_kunena_messages` AS `m` INNER JOIN `tifas_kunena_messages` AS `mm` ON `m`.`thread` = `mm`.`thread` WHERE `m`.`id` IN (17065) GROUP BY `m`.`id`,`mm`.`hold`248μ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)227μs25KB/libraries/kunena/src/User/KunenaUserHelper.php:247Copy
  • 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 ASC701μ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-21 06:59:48') AND (`publish_down` ='1000-01-01 00:00:00' OR `publish_down` >= '2025-04-21 06:59:48') ORDER BY `id` DESC LIMIT 1104μs1.42KB/libraries/kunena/src/Forum/Announcement/KunenaAnnouncementHelper.php:145Copy
  • SELECT `params` FROM `tifas_comprofiler_plugin` WHERE `id` = 179μ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`199μs17.73KBCopy
  • SHOW FULL COLUMNS FROM `tifas_users`314μ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.ordering601μ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` = 0391μ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` = 0206μs520BCopy
  • SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup FROM `tifas_comprofiler_plugin` WHERE `published` = 1 AND `viewaccesslevel` IN (1) ORDER BY `ordering`170μ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` = 0241μ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` = 0207μ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` = 0193μs536BCopy
  • SHOW FULL COLUMNS FROM `tifas_jev_users`548μ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`255μ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 asc165μ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 asc180μ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-23 00:00:00' AND ev.created <= '2025-10-18 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 10750μ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-23 00:00:00' AND ev.created <= '2025-10-18 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 ASC277μs10.33KB/components/com_jevents/libraries/dbmodel.php:3300Copy
  • SELECT `name`,`element` FROM `tifas_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1299μ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)318μ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)191μ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 1394μs2.28KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • UPDATE `tifas_banners` SET `impmade` = `impmade` + 1 WHERE `id` IN (:preparedArray1)538μ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` = :trackDate426μ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` asc197μ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` asc192μs3.18KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy
  • SHOW TABLES828μs8.51KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:678Copy