Predictions for the major currencies and exchange rates, including the Pound, Euro, Dollar, Australian Dollar, New Zealand Dollar and Canadian Dollar. Sourced from options market pricing, investment banks and technical analysts.

Click Here for the Pound to Euro Forecast page.

Created with Highstock 6.0.4Forward Forecast PointsTodayTomorrow1-Week1 Month2 Months3 Months4 Months5 Months6 Months7 Months8 Months9 Months10 Months11 Months12 Months1.141.151.161.171.18

Click Here for the Pound to US Dollar Forecast page.

Created with Highstock 6.0.4Forward Forecast PointsTodayOvernightTomorrow1-Week2-Weeks3-Weeks1 Month2 Months3 Months4 Months5 Months6 Months7 Months8 Months9 Months10 Months11 Months12 Months1.3271.32751.3281.32851.329

Click Here for the Euro to US Dollar Forecast page.

Created with Highstock 6.0.4Forward Forecast PointsTodayOvernightTomorrow1-Week2-Weeks3-Weeks1 Month2 Months3 Months4 Months5 Months6 Months7 Months8 Months9 Months10 Months11 Months12 Months1.121.131.141.151.16
Theme: GKNEWS
34.176MBMemory Usage653msRequest Duration
Joomla! Version5.2.2
PHP Version8.3.19
Identityguest
Response200
Templategk_news
Database
Server
mysql
Version
8.0.40
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
array:1 [ "start" => "1500" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
array:3 [ "cfzs_google-analytics_v4" => "{"tzGq_pageviewCounter":{"v":"1"}}" "cfz_google-analyti...
$_SERVER
array:78 [ "TZ" => "UTC" "REDIRECT_REDIRECT_UNIQUE_ID" => "aBh3tW03rDDTx806OabJ3gAAAB8" "REDIR...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1746433974 "last" => 1746433974...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_languagefilter
array:1 [ "language" => "en-GB" ]
  • afterLoad (3.77MB) (30.27ms)
  • afterInitialise (17.84MB) (162ms)
  • afterRoute (2.21MB) (14.58ms)
  • beforeRenderComponent com_tags (85.48KB) (1.39ms)
  • Before Access::preloadComponents (all components) (4.75MB) (230ms)
  • After Access::preloadComponents (all components) (166.76KB) (3.99ms)
  • Before Access::getAssetRules (id:1013 name:com_tags) (1.85KB) (51μs)
  • After Access::getAssetRules (id:1013 name:com_tags) (24.77KB) (448μs)
  • afterRenderComponent com_tags (694.35KB) (91.18ms)
  • afterDispatch (11.73KB) (4.7ms)
  • afterRender (2.32MB) (100ms)
  • 1 x Before Access::preloadComponents (all components) (4.75MB) (35.23%)
    230ms
    1 x afterInitialise (17.84MB) (24.81%)
    162ms
    1 x afterRender (2.32MB) (15.37%)
    100ms
    1 x afterRenderComponent com_tags (694.35KB) (13.96%)
    91.18ms
    1 x afterLoad (3.77MB) (4.63%)
    30.27ms
    1 x afterRoute (2.21MB) (2.23%)
    14.58ms
    1 x afterDispatch (11.73KB) (0.72%)
    4.70ms
    1 x After Access::preloadComponents (all components) (166.76KB) (0.61%)
    3.99ms
    1 x beforeRenderComponent com_tags (85.48KB) (0.21%)
    1.39ms
    1 x After Access::getAssetRules (id:1013 name:com_tags) (24.77KB) (0.07%)
    448μs
    1 x Before Access::getAssetRules (id:1013 name:com_tags) (1.85KB) (0.01%)
    51μs
91 statements were executed, 41 of which were duplicates, 50 unique220ms2.96MB
  • SELECT @@SESSION.sql_mode;1.13ms968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `cj3l9_session` WHERE `session_id` = ?1.14ms1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `id`,`rules` FROM `cj3l9_viewlevels`1.14ms640B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `cj3l9_usergroups` AS `a` LEFT JOIN `cj3l9_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest1.2ms1.31KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT * FROM `cj3l9_nextend2_section_storage` WHERE `application` = 'smartslider' AND `section` = 'settings'1.18ms1.19KB/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:182Copy
  • SELECT `template` FROM `cj3l9_template_styles` WHERE `client_id` = 0 AND `home` = 11.17ms536B/components/com_sppagebuilder/parser/addon-parser.php:1273Copy
  • SELECT template FROM cj3l9_template_styles as s WHERE s.client_id = 0 AND s.home = 11.22ms536B/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31Copy
  • SELECT template FROM cj3l9_template_styles as s WHERE s.client_id = 0 AND s.home = 11.51ms536B/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31Copy
  • SELECT extension, file, type FROM cj3l9_rokcommon_configs ORDER BY priority1.12ms1.28KB/plugins/system/rokcommon/rokcommon.php:131Copy
  • SELECT * FROM cj3l9_speedcache_urls WHERE type = "exclude" AND url ='exchange-rate-forecasts/695/8046-ubs-fx-forecasts-for-2018?start=1500'1.22ms1.48KB/plugins/system/speedcache/speedcache.php:771Copy
  • SELECT * FROM cj3l9_speedcache_urls WHERE type="rules_exclude"1.2ms1.52KB/plugins/system/speedcache/speedcache.php:789Copy
  • SELECT * FROM cj3l9_speedcache_urls WHERE type = "include" AND url ='exchange-rate-forecasts/695/8046-ubs-fx-forecasts-for-2018?start=1500'1.3ms1.48KB/plugins/system/speedcache/speedcache.php:821Copy
  • SELECT * FROM cj3l9_speedcache_urls WHERE type="rules_include"1.2ms1.5KB/plugins/system/speedcache/speedcache.php:844Copy
  • SELECT `template` FROM `cj3l9_template_styles` WHERE `client_id` = 0 AND `home` = 11.19ms536B/plugins/system/helix3/helix3.php:247Copy
  • SELECT `id` FROM `cj3l9_tags` WHERE `alias` = :alias1.64ms1.3KBParams/components/com_tags/src/Service/Router.php:387Copy
  • SELECT `id` FROM `cj3l9_tags` WHERE `alias` = :alias1.17ms1.3KBParams/components/com_tags/src/Service/Router.php:387Copy
  • SHOW FULL COLUMNS FROM `cj3l9_tags`2.08ms3.02KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • UPDATE `cj3l9_tags` SET `hits` = (`hits` + 1) WHERE `id` = '695'5.06ms48B/libraries/src/Table/Table.php:1348Copy
  • SELECT * FROM `cj3l9_tags` WHERE `id` = '695'1.27ms3.05KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `cj3l9_content_types`2.31ms33.2KB/libraries/src/Helper/TagsHelper.php:798Copy
  • SELECT `m`.`type_alias`,`m`.`content_item_id`,`m`.`core_content_id`,COUNT(`m`.`tag_id`) AS `match_count`,MAX(`m`.`tag_date`) AS `tag_date`,MAX(`c`.`core_title`) AS `core_title`,MAX(`c`.`core_params`) AS `core_params`,MAX(`c`.`core_alias`) AS `core_alias`,MAX(`c`.`core_body`) AS `core_body`,MAX(`c`.`core_state`) AS `core_state`,MAX(`c`.`core_access`) AS `core_access`,MAX(`c`.`core_metadata`) AS `core_metadata`,MAX(`c`.`core_created_user_id`) AS `core_created_user_id`,MAX(`c`.`core_created_by_alias`) AS`core_created_by_alias`,MAX(`c`.`core_created_time`) AS `core_created_time`,MAX(`c`.`core_images`) AS `core_images`,CASE WHEN `c`.`core_modified_time` = :nullDate THEN `c`.`core_created_time` ELSE `c`.`core_modified_time` END AS `core_modified_time`,MAX(`c`.`core_language`) AS `core_language`,MAX(`c`.`core_catid`) AS `core_catid`,MAX(`c`.`core_publish_up`) AS `core_publish_up`,MAX(`c`.`core_publish_down`) AS `core_publish_down`,MAX(`ct`.`type_title`) AS `content_type_title`,MAX(`ct`.`router`) AS `router`,CASE WHEN `c`.`core_created_by_alias` > ' ' THEN `c`.`core_created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email` FROM `cj3l9_contentitem_tag_map` AS `m` INNER JOIN `cj3l9_ucm_content` AS `c` ON `m`.`type_alias` = `c`.`core_type_alias` AND `m`.`core_content_id` = `c`.`core_content_id` INNER JOIN `cj3l9_content_types` AS `ct` ON `ct`.`type_alias` = `m`.`type_alias` LEFT JOIN `cj3l9_categories` AS `tc` ON `tc`.`id` = `c`.`core_catid` LEFT JOIN `cj3l9_users` AS `ua` ON `ua`.`id` = `c`.`core_created_user_id` WHERE ( ( (`c`.`core_state` IN (:preparedArray1) AND `m`.`tag_id` IN (:preparedArray2,:preparedArray3,:preparedArray4)) AND (`c`.`core_catid` = 0 OR `tc`.`published` = 1) AND `m`.`type_alias` IN (:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24) AND `c`.`core_access` IN (:preparedArray25,:preparedArray26)) AND (`c`.`core_publish_up` = :nullDate1 OR `c`.`core_publish_up` IS NULL OR `c`.`core_publish_up` <= :nowDate1)) AND (`c`.`core_publish_down` = :nullDate2 OR `c`.`core_publish_down` IS NULL OR `c`.`core_publish_down` >= :nowDate2) GROUP BY `m`.`type_alias`,`m`.`content_item_id`,`m`.`core_content_id`,`core_modified_time`,`core_created_time`,`core_created_by_alias`,`author`,`author_email`44.91ms2.65MBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:209Copy
  • SELECT `m`.`type_alias`,`m`.`content_item_id`,`m`.`core_content_id`,COUNT(`m`.`tag_id`) AS `match_count`,MAX(`m`.`tag_date`) AS `tag_date`,MAX(`c`.`core_title`) AS `core_title`,MAX(`c`.`core_params`) AS `core_params`,MAX(`c`.`core_alias`) AS `core_alias`,MAX(`c`.`core_body`) AS `core_body`,MAX(`c`.`core_state`) AS `core_state`,MAX(`c`.`core_access`) AS `core_access`,MAX(`c`.`core_metadata`) AS `core_metadata`,MAX(`c`.`core_created_user_id`) AS `core_created_user_id`,MAX(`c`.`core_created_by_alias`) AS`core_created_by_alias`,MAX(`c`.`core_created_time`) AS `core_created_time`,MAX(`c`.`core_images`) AS `core_images`,CASE WHEN `c`.`core_modified_time` = :nullDate THEN `c`.`core_created_time` ELSE `c`.`core_modified_time` END AS `core_modified_time`,MAX(`c`.`core_language`) AS `core_language`,MAX(`c`.`core_catid`) AS `core_catid`,MAX(`c`.`core_publish_up`) AS `core_publish_up`,MAX(`c`.`core_publish_down`) AS `core_publish_down`,MAX(`ct`.`type_title`) AS `content_type_title`,MAX(`ct`.`router`) AS `router`,CASE WHEN `c`.`core_created_by_alias` > ' ' THEN `c`.`core_created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email` FROM `cj3l9_contentitem_tag_map` AS `m` INNER JOIN `cj3l9_ucm_content` AS `c` ON `m`.`type_alias` = `c`.`core_type_alias` AND `m`.`core_content_id` = `c`.`core_content_id` INNER JOIN `cj3l9_content_types` AS `ct` ON `ct`.`type_alias` = `m`.`type_alias` LEFT JOIN `cj3l9_categories` AS `tc` ON `tc`.`id` = `c`.`core_catid` LEFT JOIN `cj3l9_users` AS `ua` ON `ua`.`id` = `c`.`core_created_user_id` WHERE ( ( (`c`.`core_state` IN (:preparedArray1) AND `m`.`tag_id` IN (:preparedArray2,:preparedArray3,:preparedArray4)) AND (`c`.`core_catid` = 0 OR `tc`.`published` = 1) AND `m`.`type_alias` IN (:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24) AND `c`.`core_access` IN (:preparedArray25,:preparedArray26)) AND (`c`.`core_publish_up` = :nullDate1 OR `c`.`core_publish_up` IS NULL OR `c`.`core_publish_up` <= :nowDate1)) AND (`c`.`core_publish_down` = :nullDate2 OR `c`.`core_publish_down` IS NULL OR `c`.`core_publish_down` >= :nowDate2) GROUP BY `m`.`type_alias`,`m`.`content_item_id`,`m`.`core_content_id`,`core_modified_time`,`core_created_time`,`core_created_by_alias`,`author`,`author_email` ORDER BY MAX(`c`.`core_publish_up`) DESC LIMIT 1500, 2032.34ms54.5KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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 `cj3l9_categories` AS `s` INNER JOIN `cj3l9_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray2,:preparedArray3)) 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`1.86ms3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `cj3l9_categories` AS `s` INNER JOIN `cj3l9_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray2,:preparedArray3)) 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`1.9ms3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `cj3l9_categories` AS `s` INNER JOIN `cj3l9_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray2,:preparedArray3)) 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`1.78ms3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `cj3l9_categories` AS `s` INNER JOIN `cj3l9_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray2,:preparedArray3)) 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`1.85ms3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `cj3l9_categories` AS `s` INNER JOIN `cj3l9_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray2,:preparedArray3)) 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`1.78ms3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `cj3l9_categories` AS `s` INNER JOIN `cj3l9_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray2,:preparedArray3)) 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`1.77ms3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `cj3l9_categories` AS `s` INNER JOIN `cj3l9_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray2,:preparedArray3)) 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`2.22ms3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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 `cj3l9_categories` AS `s` INNER JOIN `cj3l9_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray2,:preparedArray3)) 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`2.14ms3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM `cj3l9_tags` WHERE `id` = '695'1.49ms3.09KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `cj3l9_tags` WHERE `id` = '695'1.43ms3.09KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `cj3l9_tags` WHERE `id` = '8046'1.43ms5.58KB/libraries/src/Table/Table.php:780Copy
  • 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 `cj3l9_categories` AS `s` INNER JOIN `cj3l9_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray2,:preparedArray3)) 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`1.82ms3.94KBParams/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 cj3l9_fields AS a LEFT JOIN `cj3l9_languages` AS l ON l.lang_code = a.language LEFT JOIN cj3l9_users AS uc ON uc.id=a.checked_out LEFT JOIN cj3l9_viewlevels AS ag ON ag.id = a.access LEFT JOIN cj3l9_users AS ua ON ua.id = a.created_user_id LEFT JOIN cj3l9_fields_groups AS g ON g.id = a.group_id LEFT JOIN `cj3l9_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)) AND `a`.`access` IN (:preparedArray3)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform AND `a`.`language` IN (:preparedArray5,:preparedArray6) ORDER BY a.ordering ASC1.56ms4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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 `cj3l9_categories` AS `s` INNER JOIN `cj3l9_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray2,:preparedArray3)) 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`1.95ms3.94KBParams/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 cj3l9_fields AS a LEFT JOIN `cj3l9_languages` AS l ON l.lang_code = a.language LEFT JOIN cj3l9_users AS uc ON uc.id=a.checked_out LEFT JOIN cj3l9_viewlevels AS ag ON ag.id = a.access LEFT JOIN cj3l9_users AS ua ON ua.id = a.created_user_id LEFT JOIN cj3l9_fields_groups AS g ON g.id = a.group_id LEFT JOIN `cj3l9_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)) AND `a`.`access` IN (:preparedArray3)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform AND `a`.`language` IN (:preparedArray5,:preparedArray6) ORDER BY a.ordering ASC1.55ms4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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 `cj3l9_categories` AS `s` INNER JOIN `cj3l9_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray2,:preparedArray3)) 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`1.86ms3.94KBParams/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 cj3l9_fields AS a LEFT JOIN `cj3l9_languages` AS l ON l.lang_code = a.language LEFT JOIN cj3l9_users AS uc ON uc.id=a.checked_out LEFT JOIN cj3l9_viewlevels AS ag ON ag.id = a.access LEFT JOIN cj3l9_users AS ua ON ua.id = a.created_user_id LEFT JOIN cj3l9_fields_groups AS g ON g.id = a.group_id LEFT JOIN `cj3l9_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)) AND `a`.`access` IN (:preparedArray3)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform AND `a`.`language` IN (:preparedArray5,:preparedArray6) ORDER BY a.ordering ASC1.54ms4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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 `cj3l9_categories` AS `s` INNER JOIN `cj3l9_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray2,:preparedArray3)) 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`1.89ms3.94KBParams/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 cj3l9_fields AS a LEFT JOIN `cj3l9_languages` AS l ON l.lang_code = a.language LEFT JOIN cj3l9_users AS uc ON uc.id=a.checked_out LEFT JOIN cj3l9_viewlevels AS ag ON ag.id = a.access LEFT JOIN cj3l9_users AS ua ON ua.id = a.created_user_id LEFT JOIN cj3l9_fields_groups AS g ON g.id = a.group_id LEFT JOIN `cj3l9_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)) AND `a`.`access` IN (:preparedArray3)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform AND `a`.`language` IN (:preparedArray5,:preparedArray6) ORDER BY a.ordering ASC1.57ms4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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 `cj3l9_categories` AS `s` INNER JOIN `cj3l9_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray2,:preparedArray3)) 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`1.92ms3.94KBParams/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 cj3l9_fields AS a LEFT JOIN `cj3l9_languages` AS l ON l.lang_code = a.language LEFT JOIN cj3l9_users AS uc ON uc.id=a.checked_out LEFT JOIN cj3l9_viewlevels AS ag ON ag.id = a.access LEFT JOIN cj3l9_users AS ua ON ua.id = a.created_user_id LEFT JOIN cj3l9_fields_groups AS g ON g.id = a.group_id LEFT JOIN `cj3l9_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)) AND `a`.`access` IN (:preparedArray3)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform AND `a`.`language` IN (:preparedArray5,:preparedArray6) ORDER BY a.ordering ASC1.57ms4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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 `cj3l9_categories` AS `s` INNER JOIN `cj3l9_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray2,:preparedArray3)) 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`1.85ms3.94KBParams/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 cj3l9_fields AS a LEFT JOIN `cj3l9_languages` AS l ON l.lang_code = a.language LEFT JOIN cj3l9_users AS uc ON uc.id=a.checked_out LEFT JOIN cj3l9_viewlevels AS ag ON ag.id = a.access LEFT JOIN cj3l9_users AS ua ON ua.id = a.created_user_id LEFT JOIN cj3l9_fields_groups AS g ON g.id = a.group_id LEFT JOIN `cj3l9_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)) AND `a`.`access` IN (:preparedArray3)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform AND `a`.`language` IN (:preparedArray5,:preparedArray6) ORDER BY a.ordering ASC1.56ms4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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 `cj3l9_categories` AS `s` INNER JOIN `cj3l9_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray2,:preparedArray3)) 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`1.86ms3.94KBParams/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 cj3l9_fields AS a LEFT JOIN `cj3l9_languages` AS l ON l.lang_code = a.language LEFT JOIN cj3l9_users AS uc ON uc.id=a.checked_out LEFT JOIN cj3l9_viewlevels AS ag ON ag.id = a.access LEFT JOIN cj3l9_users AS ua ON ua.id = a.created_user_id LEFT JOIN cj3l9_fields_groups AS g ON g.id = a.group_id LEFT JOIN `cj3l9_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)) AND `a`.`access` IN (:preparedArray3)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform AND `a`.`language` IN (:preparedArray5,:preparedArray6) ORDER BY a.ordering ASC1.59ms4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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 `cj3l9_categories` AS `s` INNER JOIN `cj3l9_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray2,:preparedArray3)) 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`1.77ms3.94KBParams/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 cj3l9_fields AS a LEFT JOIN `cj3l9_languages` AS l ON l.lang_code = a.language LEFT JOIN cj3l9_users AS uc ON uc.id=a.checked_out LEFT JOIN cj3l9_viewlevels AS ag ON ag.id = a.access LEFT JOIN cj3l9_users AS ua ON ua.id = a.created_user_id LEFT JOIN cj3l9_fields_groups AS g ON g.id = a.group_id LEFT JOIN `cj3l9_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)) AND `a`.`access` IN (:preparedArray3)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray4)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform AND `a`.`language` IN (:preparedArray5,:preparedArray6) ORDER BY a.ordering ASC1.63ms4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `cj3l9_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,:preparedArray48,:preparedArray49,:preparedArray50,:preparedArray51,:preparedArray52,:preparedArray53,:preparedArray54,:preparedArray55,:preparedArray56,:preparedArray57,:preparedArray58,:preparedArray59,:preparedArray60,:preparedArray61,:preparedArray62,:preparedArray63,:preparedArray64)2.16ms8.31KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `alias` FROM `cj3l9_content` WHERE `id` = :id1.36ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • 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 `cj3l9_categories` AS `s` INNER JOIN `cj3l9_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray2,:preparedArray3)) 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`2.06ms3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `cj3l9_content` WHERE `id` = :id1.3ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • 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 `cj3l9_categories` AS `s` INNER JOIN `cj3l9_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray2,:preparedArray3)) 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`1.91ms3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `cj3l9_content` WHERE `id` = :id1.35ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • 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 `cj3l9_categories` AS `s` INNER JOIN `cj3l9_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray2,:preparedArray3)) 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`1.86ms3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `cj3l9_content` WHERE `id` = :id1.45ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • 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 `cj3l9_categories` AS `s` INNER JOIN `cj3l9_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray2,:preparedArray3)) 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`1.92ms3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `cj3l9_content` WHERE `id` = :id1.43ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `cj3l9_content` WHERE `id` = :id1.24ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `cj3l9_content` WHERE `id` = :id1.36ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `cj3l9_content` WHERE `id` = :id1.21ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • 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 `cj3l9_categories` AS `s` INNER JOIN `cj3l9_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray2,:preparedArray3)) 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`1.83ms3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `cj3l9_content` WHERE `id` = :id1.23ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `cj3l9_content` WHERE `id` = :id1.41ms12.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `cj3l9_content` WHERE `id` = :id1.19ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • 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 `cj3l9_categories` AS `s` INNER JOIN `cj3l9_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray2,:preparedArray3)) 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`1.85ms3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `cj3l9_content` WHERE `id` = :id1.24ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `cj3l9_content` WHERE `id` = :id1.23ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `cj3l9_content` WHERE `id` = :id1.2ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • 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 `cj3l9_categories` AS `s` INNER JOIN `cj3l9_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray2,:preparedArray3)) 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`1.82ms3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `cj3l9_content` WHERE `id` = :id1.24ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `cj3l9_content` WHERE `id` = :id1.24ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `cj3l9_content` WHERE `id` = :id1.22ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • 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 `cj3l9_categories` AS `s` INNER JOIN `cj3l9_categories` AS `c` ON (`s`.`lft` < `c`.`lft` AND `c`.`lft` < `s`.`rgt` AND `c`.`language` IN (:preparedArray2,:preparedArray3)) 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`1.86ms3.94KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `cj3l9_content` WHERE `id` = :id1.35ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `cj3l9_content` WHERE `id` = :id1.36ms1.31KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `language`,`id` FROM `cj3l9_menu` WHERE `home` = '1' AND `published` = 1 AND `client_id` = 02.1ms608B/libraries/src/Language/Multilanguage.php:123Copy
  • SELECT * FROM cj3l9_jmap_metainfo WHERE `linkurl` = 'https://www.poundsterlinglive.com/exchange-rate-forecasts/695/8046-ubs-fx-forecasts-for-2018?start=1500' AND `published` = 11.16ms912B/plugins/system/jmap/jmap.php:818Copy
  • SELECT * FROM cj3l9_jmap_canonicals WHERE `linkurl` = 'https://www.poundsterlinglive.com/exchange-rate-forecasts/695/8046-ubs-fx-forecasts-for-2018?start=1500'1.5ms640B/plugins/system/jmap/jmap.php:920Copy
  • 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 `cj3l9_scheduler_tasks` AS `a` WHERE `a`.`state` = 11.38ms1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465Copy
  • SELECT * FROM cj3l9_jmap_headings WHERE `linkurl` = 'https://www.poundsterlinglive.com/exchange-rate-forecasts/695/8046-ubs-fx-forecasts-for-2018?start=1500'1.39ms752B/plugins/system/jmap/jmap.php:1135Copy
  • SELECT `original_text`, `target_text`, `original_text_regex`, `target_text_regex` FROM `cj3l9_jmap_text_replacements` WHERE `published` = 11.32ms688B/plugins/system/jmap/jmap.php:508Copy
  • SELECT title FROM cj3l9_usergroups WHERE id IN (1)1.39ms536B/plugins/system/speedcache/speedcache.php:543Copy
  • SELECT title FROM cj3l9_usergroups WHERE id IN (1)1.2ms536B/plugins/system/speedcache/speedcache.php:543Copy
  • SELECT * FROM cj3l9_speedcache_urls WHERE type = "exclude" AND url ='exchange-rate-forecasts/695/8046-ubs-fx-forecasts-for-2018?start=1500'1.28ms1.48KB/plugins/system/speedcache/speedcache.php:771Copy
  • SELECT * FROM cj3l9_speedcache_urls WHERE type="rules_exclude"1.36ms1.52KB/plugins/system/speedcache/speedcache.php:789Copy
  • SELECT * FROM cj3l9_speedcache_urls WHERE type = "include" AND url ='exchange-rate-forecasts/695/8046-ubs-fx-forecasts-for-2018?start=1500'1.31ms1.48KB/plugins/system/speedcache/speedcache.php:821Copy
  • SELECT * FROM cj3l9_speedcache_urls WHERE type="rules_include"1.32ms1.5KB/plugins/system/speedcache/speedcache.php:844Copy
  • SELECT `session_id` FROM `cj3l9_session` WHERE `session_id` = ?1.17ms1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • INSERT INTO `cj3l9_session` (`data`,`time`,`session_id`) VALUES (?, ?, ?)5.32ms544BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy
  • inforokcommon - Registering library path [ROOT]/components/com_roksprocket/lib for roksprocket
  • inforokcommon - Loading container config file for roksprocket from [ROOT]/components/com_roksprocket/con...