Free Webinar: AI Challenge 2024 - Results and Winners

Free Webinar AI Challenge Competitive and Market Intellgience

Will AI replace you as a Competitive and Market Intelligence professional? Will it serve as your assistant, or is it simply too limited to perform tasks accurately?

 

In our AI Challenge, over 20 Competitive and Market Intelligence professionals put this question to the test. Nine groups accepted the challenge and utilized various AI technologies step-by-step to solve a CI/MI case, from research planning to analysis, and finally to the creation of a report and a presentation.

 Observations:

  • AI can save up to 80% or 90% of your time for most typical tasks. It excels at more generic tasks, while more specific tasks require human intervention and fine-tuning.
  • Even novice AI users can achieve significant time savings quickly. Experienced AI users can realize even greater time savings.
  • Experienced CI/MI practitioners are needed to guide AI in the right direction and ask the right questions.
  • Close attention must be paid to source validation. This part requires human supervision and will largely remain a manual task. Overall, this step might take somewhat longer than doing it traditionally.

Conclusion: AI cannot operate independently, so it won’t take your job. However, the productivity gain is substantial. Both novice and experienced AI users can complete projects in days instead of weeks. If you don’t integrate AI into your processes, someone who does might take your job.

In our free final webinar, our participants will share their experiences using AI for a real CI/MI case. The winning teams will showcase presentations about this case that were created in hours rather than days. They will share their experiences using AI. Some were quite novice AI users before they joined the challenge and now cannot imagine doing their daily work without AI.

Agenda:

  • Showcase presentations from the winning teams
  • First-hand observations and key learnings from using AI
  • How to get started with AI
  • Discussion
  • Q&A

Facilitators

  • Rainer Michaeli, Director, Institute for Competitive Intelligence.
  • Arthur Weiss, Faculty, Institute for Competitive Intelligence, Managing Director Aware
  • Thorsten Bill, Faculty, Institute for Competitive Intelligence.

Don’t let the future pass you by. Join our free webinar today, learn from the best, and step into the future of CI/MI.

Your journey towards unparalleled efficiency and productivity starts here. 

 

Log in

4.688MBMemory Usage40.88msRequest Duration
Joomla! Version4.4.9
PHP Version8.2.26
Identityguest
Response200
Templategk_university
Database
Server
mysql
Version
8.0.40-31
Collation
utf8mb4_0900_ai_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:76 [ "LSPHP_ENABLE_USER_INI" => "on" "PATH" => "/usr/local/bin:/usr/bin:/bin" "TEMP" => ...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1736076702 "last" => 1736076702...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_webauthn
array:1 [ "returnUrl" => "https://www.institute-for-competitive-intelligence.com/ci-service/news-a...
  • afterLoad (472.37KB) (1.66ms)
  • afterInitialise (1.14MB) (10.22ms)
  • afterRoute (601.2KB) (4.22ms)
  • beforeRenderComponent com_content (98.26KB) (582μs)
  • Before Access::preloadComponents (all components) (33.08KB) (371μs)
  • After Access::preloadComponents (all components) (119.89KB) (493μs)
  • Before Access::preloadPermissions (com_content) (1.63KB) (11μs)
  • After Access::preloadPermissions (com_content) (201.27KB) (515μs)
  • Before Access::getAssetRules (id:1806 name:com_content.article.1476) (10.65KB) (15μs)
  • After Access::getAssetRules (id:1806 name:com_content.article.1476) (7.16KB) (47μs)
  • afterRenderComponent com_content (366.12KB) (11.18ms)
  • afterDispatch (198.78KB) (986μs)
  • Before Access::getAssetRules (id:16 name:com_menus) (891.39KB) (5.41ms)
  • After Access::getAssetRules (id:16 name:com_menus) (5.7KB) (21μs)
  • beforeRenderRawModule mod_login (Login) (4.19KB) (28μs)
  • afterRenderRawModule mod_login (Login) (38.88KB) (795μs)
  • beforeRenderModule mod_login (Login) (704B) (3μs)
  • afterRenderModule mod_login (Login) (1.93KB) (58μs)
  • beforeRenderRawModule mod_banners (Upcoming Events) (8.95KB) (143μs)
  • afterRenderRawModule mod_banners (Upcoming Events) (32.03KB) (1.03ms)
  • beforeRenderModule mod_banners (Upcoming Events) (720B) (4μs)
  • afterRenderModule mod_banners (Upcoming Events) (3.45KB) (45μs)
  • beforeRenderRawModule mod_syndicate (rss) (1.98KB) (83μs)
  • afterRenderRawModule mod_syndicate (rss) (3.91KB) (107μs)
  • beforeRenderModule mod_syndicate (rss) (704B) (2μs)
  • afterRenderModule mod_syndicate (rss) (1.25KB) (20μs)
  • beforeRenderRawModule mod_breadcrumbs (breadcrumps) (2.39KB) (124μs)
  • afterRenderRawModule mod_breadcrumbs (breadcrumps) (5.37KB) (191μs)
  • beforeRenderModule mod_breadcrumbs (breadcrumps) (704B) (3μs)
  • afterRenderModule mod_breadcrumbs (breadcrumps) (2.98KB) (38μs)
  • afterRender (120.78KB) (1.72ms)
  • 1 x afterRenderComponent com_content (366.12KB) (27.35%)
    11.18ms
    1 x afterInitialise (1.14MB) (25%)
    10.22ms
    1 x Before Access::getAssetRules (id:16 name:com_menus) (891.39KB) (13.24%)
    5.41ms
    1 x afterRoute (601.2KB) (10.32%)
    4.22ms
    1 x afterRender (120.78KB) (4.2%)
    1.72ms
    1 x afterLoad (472.37KB) (4.06%)
    1.66ms
    1 x afterRenderRawModule mod_banners (Upcoming Events) (32.03KB) (2.52%)
    1.03ms
    1 x afterDispatch (198.78KB) (2.41%)
    986μs
    1 x afterRenderRawModule mod_login (Login) (38.88KB) (1.94%)
    795μs
    1 x beforeRenderComponent com_content (98.26KB) (1.42%)
    582μs
    1 x After Access::preloadPermissions (com_content) (201.27KB) (1.26%)
    515μs
    1 x After Access::preloadComponents (all components) (119.89KB) (1.21%)
    493μs
    1 x Before Access::preloadComponents (all components) (33.08KB) (0.91%)
    371μs
    1 x afterRenderRawModule mod_breadcrumbs (breadcrumps) (5.37KB) (0.47%)
    191μs
    1 x beforeRenderRawModule mod_banners (Upcoming Events) (8.95KB) (0.35%)
    143μs
    1 x beforeRenderRawModule mod_breadcrumbs (breadcrumps) (2.39KB) (0.3%)
    124μs
    1 x afterRenderRawModule mod_syndicate (rss) (3.91KB) (0.26%)
    107μs
    1 x beforeRenderRawModule mod_syndicate (rss) (1.98KB) (0.2%)
    83μs
    1 x afterRenderModule mod_login (Login) (1.93KB) (0.14%)
    58μs
    1 x After Access::getAssetRules (id:1806 name:com_content.article.1476) (7.16KB) (0.11%)
    47μs
    1 x afterRenderModule mod_banners (Upcoming Events) (3.45KB) (0.11%)
    45μs
    1 x afterRenderModule mod_breadcrumbs (breadcrumps) (2.98KB) (0.09%)
    38μs
    1 x beforeRenderRawModule mod_login (Login) (4.19KB) (0.07%)
    28μs
    1 x After Access::getAssetRules (id:16 name:com_menus) (5.7KB) (0.05%)
    21μs
    1 x afterRenderModule mod_syndicate (rss) (1.25KB) (0.05%)
    20μs
    1 x Before Access::getAssetRules (id:1806 name:com_content.article.1476) (10.65KB) (0.04%)
    15μs
    1 x Before Access::preloadPermissions (com_content) (1.63KB) (0.03%)
    11μs
    1 x beforeRenderModule mod_banners (Upcoming Events) (720B) (0.01%)
    4μs
    1 x beforeRenderModule mod_login (Login) (704B) (0.01%)
    3μs
    1 x beforeRenderModule mod_breadcrumbs (breadcrumps) (704B) (0.01%)
    3μs
    1 x beforeRenderModule mod_syndicate (rss) (704B) (0%)
    2μs
41 statements were executed, 3 of which were duplicates, 38 unique6.91ms107.99KB
  • SELECT @@SESSION.sql_mode;70μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `v2014_session` WHERE `session_id` = ?124μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `v2014_session` WHERE `session_id` = :session_id LIMIT 166μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `v2014_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)202μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `v2014_viewlevels`74μs944B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `v2014_usergroups` AS `a` LEFT JOIN `v2014_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest135μs1.31KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `path` FROM v2014_rsfirewall_ignored WHERE `type`='ignore_folder' OR `type`='ignore_file'61μs552B/administrator/components/com_rsfirewall/helpers/config.php:56Copy
  • SELECT `file` FROM v2014_rsfirewall_hashes WHERE `type`='protect'675μs552B/administrator/components/com_rsfirewall/helpers/config.php:63Copy
  • SELECT * FROM v2014_rsfirewall_configuration113μs2.5KB/administrator/components/com_rsfirewall/helpers/config.php:71Copy
  • SHOW FULL COLUMNS FROM `v2014_rsfirewall_logs`400μs1.42KB/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 `v2014_categories` AS `s` INNER JOIN `v2014_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`192μs3.88KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id` FROM `v2014_content` WHERE `alias` = :alias AND `catid` = :catid131μs1.34KBParams/components/com_content/src/Service/Router.php:263Copy
  • SELECT * FROM v2014_rsfirewall_hashes WHERE `type`='protect' AND (`flag`!='C' OR `flag` IS NULL)695μs848B/plugins/system/rsfirewall/rsfirewall.php:1078Copy
  • SELECT * FROM v2014_rsfirewall_snapshots WHERE `type`='protect'59μs752B/administrator/components/com_rsfirewall/helpers/snapshot.php:49Copy
  • SELECT * FROM `v2014_users` WHERE `id` = '71'71μs2.38KB/plugins/system/rsfirewall/rsfirewall.php:1116Copy
  • SELECT group_id FROM v2014_user_usergroup_map WHERE `user_id`=7162μs536B/administrator/components/com_rsfirewall/helpers/snapshot.php:70Copy
  • SELECT * FROM `v2014_users` WHERE `id` = '630'60μs3.63KB/plugins/system/rsfirewall/rsfirewall.php:1116Copy
  • SELECT group_id FROM v2014_user_usergroup_map WHERE `user_id`=63053μs552B/administrator/components/com_rsfirewall/helpers/snapshot.php:70Copy
  • SELECT * FROM `v2014_users` WHERE `id` = '15'57μs2.38KB/plugins/system/rsfirewall/rsfirewall.php:1116Copy
  • SELECT group_id FROM v2014_user_usergroup_map WHERE `user_id`=1548μs536B/administrator/components/com_rsfirewall/helpers/snapshot.php:70Copy
  • SELECT * FROM `v2014_users` WHERE `id` = '629'57μs2.38KB/plugins/system/rsfirewall/rsfirewall.php:1116Copy
  • SELECT group_id FROM v2014_user_usergroup_map WHERE `user_id`=62958μs552B/administrator/components/com_rsfirewall/helpers/snapshot.php:70Copy
  • SELECT `ip`,`reason` FROM v2014_rsfirewall_lists WHERE (`ip`='18.189.195.131' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='1' AND `published`='1'43μs576B/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT `ip`,`reason` FROM v2014_rsfirewall_lists WHERE (`ip`='18.189.195.131' OR `ip` LIKE '%*%' OR `ip` LIKE '%/%' OR `ip` LIKE '%-%') AND `type`='0' AND `published`='1'36μs576B/plugins/system/rsfirewall/rsfirewall.php:172Copy
  • SELECT * FROM v2014_rsfirewall_exceptions WHERE `published`='1'57μs1.48KB/plugins/system/rsfirewall/rsfirewall.php:729Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `v2014_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)313μs7.44KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `v2014_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0271μs25.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `v2014_content`441μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `v2014_content` SET `hits` = (`hits` + 1) WHERE `id` = '1476'156μs48B/libraries/src/Table/Table.php:1325Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `v2014_content` AS `a` INNER JOIN `v2014_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `v2014_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `v2014_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `v2014_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `v2014_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)255μs6.12KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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 `v2014_categories` AS `s` INNER JOIN `v2014_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`228μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `v2014_contentitem_tag_map` AS `m` INNER JOIN `v2014_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1)150μs3.95KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • 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 `v2014_categories` AS `s` INNER JOIN `v2014_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`219μs6.41KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 v2014_fields AS a LEFT JOIN `v2014_languages` AS l ON l.lang_code = a.language LEFT JOIN v2014_users AS uc ON uc.id=a.checked_out LEFT JOIN v2014_viewlevels AS ag ON ag.id = a.access LEFT JOIN v2014_users AS ua ON ua.id = a.created_user_id LEFT JOIN v2014_fields_groups AS g ON g.id = a.group_id LEFT JOIN `v2014_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2,:preparedArray3)) AND `a`.`access` IN (:preparedArray4)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5)) 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 ASC239μs4.72KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • 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 `v2014_categories` AS `s` INNER JOIN `v2014_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`266μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `v2014_banners` WHERE (`reset` <= :date AND `reset` IS NOT NULL) AND (`checked_out` IS NULL OR `checked_out` = :userId)184μ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 `v2014_banners` AS `a` LEFT JOIN `v2014_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 1217μs2.27KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • 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 `v2014_scheduler_tasks` AS `a` WHERE `a`.`state` = 176μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SET sql_mode=(SELECT REPLACE(@@sql_mode,'STRICT_TRANS_TABLES',''));38μs0B/administrator/components/com_eventbooking/libraries/rad/bootstrap.php:95Copy
  • SELECT `session_id` FROM `v2014_session` WHERE `session_id` = ?67μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • UPDATE `v2014_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?194μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy