annual growthThe national HPI has grown at a below-inflation rate of 0.5% over the last 12 months, the smallest gain since November 2009. Moreover, the fact that monthly gains are reported for May and June does not mean that the market recently turned the corner. These two months typically register the strongest growth rates in a year. Indeed, the two latest rises were among the weakest in history for months of May and June. If seasonally adjusted, the national HPI would been down in both months this year. However, the weakness is not regionally broad-based. The national HPI was dragged down by 12-month home price declines in Western Canada metropolitan areas (Vancouver, Calgary, Edmonton and Winnipeg) and a tiny increase in Victoria. In Central Canada and in the East, home price growth ranges from decent to strong (left chart). This is consistent with the state of home resale markets.

For example, the Vancouver market turned favorable to buyers at the end of last year, while the Toronto market remained balanced and Montreal’s market has never been this tight since 2005. That being said, a rebound in home sales recently occurred in Canada which was also felt in the largest Western metropolitan areas. This should help limit home-price deflation in these areas.

The Teranet–National Bank Composite National House Price Index increased 0.8% in June, a second gain in a row after an eight-month string without a rise.

Highlights:

  • On a monthly basis, the index rose in 8 of the 11 markets covered: Winnipeg (0.1%), Quebec City (0.3%), Montreal (0.8%), Toronto (1.3%), Halifax (1.5%), Hamilton (+1.6%), Victoria (+2.1%) and Ottawa-Gatineau (+2.2%). The index was down in Calgary (-0.1%) and Vancouver (-0.3%), and flat in Edmonton.
  • From June 2018 to June 2019, the Composite index rose 0.5%, the smallest 12-month gain in ten years. The HPI declined in Vancouver (-4.9%), Calgary (-3.8%), Edmonton (-2.6%) and Winnipeg (-0.4%). It was up in Victoria (0.3%), Quebec City (1.5%), Halifax (2.7%), Toronto (2.8%), Hamilton (4.8%), Montreal (5.4%) and Ottawa-Gatineau (6.3%).

Source: National Bank Financial Markets; Marc Pinsonneault

Settings26.053MBMemory Usage189msRequest Duration
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
Joomla! Version5.3.0
PHP Version8.2.28
Identityguest
Response200
Templatedefault-template-blog
Database
Server
mysql
Version
10.5.29-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:77 [ "CONTEXT_DOCUMENT_ROOT" => "/home/iainwallace/public_html" "CONTEXT_PREFIX" => "" "...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1747094984 "last" => 1747094984...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (3.65MB) (17.04ms)
  • afterInitialise (11.42MB) (61.61ms)
  • afterRoute (1.37MB) (9.44ms)
  • beforeRenderComponent com_content (80.3KB) (1.79ms)
  • Before Access::preloadComponents (all components) (562.79KB) (3.25ms)
  • After Access::preloadComponents (all components) (135.62KB) (1.04ms)
  • Before Access::preloadPermissions (com_content) (424B) (12μs)
  • After Access::preloadPermissions (com_content) (33.12KB) (444μs)
  • Before Access::getAssetRules (id:121 name:com_content.article.24) (1.15KB) (10μs)
  • After Access::getAssetRules (id:121 name:com_content.article.24) (25.37KB) (237μs)
  • Before Access::getAssetRules (id:1 name:root.1) (1.67MB) (14.17ms)
  • After Access::getAssetRules (id:1 name:root.1) (6.02KB) (30μs)
  • afterRenderComponent com_content (1.68MB) (19.58ms)
  • afterDispatch (11.73KB) (412μs)
  • beforeRenderRawModule mod_maximenuck (Default Menu) (957.02KB) (5.72ms)
  • afterRenderRawModule mod_maximenuck (Default Menu) (1.43MB) (11.42ms)
  • beforeRenderRawModule mod_pagebuilderck (Footer) (18.56KB) (201μs)
  • beforeRenderRawModule mod_maximenuck (Footer Menu) (995.6KB) (7.91ms)
  • afterRenderRawModule mod_maximenuck (Footer Menu) (74.97KB) (4.15ms)
  • beforeRenderModule mod_maximenuck (Footer Menu) (720B) (8μs)
  • afterRenderModule mod_maximenuck (Footer Menu) (17.16KB) (575μs)
  • afterRenderRawModule mod_pagebuilderck (Footer) (668.24KB) (12.14ms)
  • beforeRenderModule mod_pagebuilderck (Footer) (48.56KB) (3.85ms)
  • afterRenderModule mod_pagebuilderck (Footer) (11.98KB) (398μs)
  • beforeRenderModule mod_maximenuck (Default Menu) (18.27KB) (82μs)
  • afterRenderModule mod_maximenuck (Default Menu) (212.69KB) (4.57ms)
  • afterRender (552.25KB) (8.47ms)
  • 1 x afterInitialise (11.42MB) (32.56%)
    61.61ms
    1 x afterRenderComponent com_content (1.68MB) (10.35%)
    19.58ms
    1 x afterLoad (3.65MB) (9.01%)
    17.04ms
    1 x Before Access::getAssetRules (id:1 name:root.1) (1.67MB) (7.49%)
    14.17ms
    1 x afterRenderRawModule mod_pagebuilderck (Footer) (668.24KB) (6.42%)
    12.14ms
    1 x afterRenderRawModule mod_maximenuck (Default Menu) (1.43MB) (6.04%)
    11.42ms
    1 x afterRoute (1.37MB) (4.99%)
    9.44ms
    1 x afterRender (552.25KB) (4.48%)
    8.47ms
    1 x beforeRenderRawModule mod_maximenuck (Footer Menu) (995.6KB) (4.18%)
    7.91ms
    1 x beforeRenderRawModule mod_maximenuck (Default Menu) (957.02KB) (3.02%)
    5.72ms
    1 x afterRenderModule mod_maximenuck (Default Menu) (212.69KB) (2.41%)
    4.57ms
    1 x afterRenderRawModule mod_maximenuck (Footer Menu) (74.97KB) (2.19%)
    4.15ms
    1 x beforeRenderModule mod_pagebuilderck (Footer) (48.56KB) (2.04%)
    3.85ms
    1 x Before Access::preloadComponents (all components) (562.79KB) (1.72%)
    3.25ms
    1 x beforeRenderComponent com_content (80.3KB) (0.94%)
    1.79ms
    1 x After Access::preloadComponents (all components) (135.62KB) (0.55%)
    1.04ms
    1 x afterRenderModule mod_maximenuck (Footer Menu) (17.16KB) (0.3%)
    575μs
    1 x After Access::preloadPermissions (com_content) (33.12KB) (0.23%)
    444μs
    1 x afterDispatch (11.73KB) (0.22%)
    412μs
    1 x afterRenderModule mod_pagebuilderck (Footer) (11.98KB) (0.21%)
    398μs
    1 x After Access::getAssetRules (id:121 name:com_content.article.24) (25.37KB) (0.13%)
    237μs
    1 x beforeRenderRawModule mod_pagebuilderck (Footer) (18.56KB) (0.11%)
    201μs
    1 x beforeRenderModule mod_maximenuck (Default Menu) (18.27KB) (0.04%)
    82μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.02KB) (0.02%)
    30μs
    1 x Before Access::preloadPermissions (com_content) (424B) (0.01%)
    12μs
    1 x Before Access::getAssetRules (id:121 name:com_content.article.24) (1.15KB) (0.01%)
    10μs
    1 x beforeRenderModule mod_maximenuck (Footer Menu) (720B) (0%)
    8μs
45 statements were executed, 13 of which were duplicates, 32 unique13.76ms953.16KB
  • SELECT @@SESSION.sql_mode;59μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `josbc_session` WHERE `session_id` = ?116μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `josbc_session` WHERE `session_id` = :session_id LIMIT 173μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `josbc_session` (`session_id`,`guest`,`time`,`userid`,`username`) VALUES (:session_id, :guest, :time, :user_id, :username)455μs912BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `josbc_viewlevels`93μs976B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `josbc_usergroups` AS `a` LEFT JOIN `josbc_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest143μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT * FROM `josbc_nextend2_section_storage` WHERE `application` = 'smartslider' AND `section` = 'settings'232μs896B/libraries/smartslider3/src/Framework/Database/Joomla/JoomlaConnectorTable.php:182Copy
  • 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 `josbc_categories` AS `s` INNER JOIN `josbc_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`402μs3.86KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `josbc_content` WHERE `id` = :id153μs1.94KBParams/components/com_content/src/Service/Router.php:289Copy
  • SELECT * FROM `josbc_languages` WHERE `published` = 1 ORDER BY `ordering` ASC181μs1.59KB/libraries/src/Language/LanguageHelper.php:179Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `josbc_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)489μs7.81KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `josbc_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0248μs3.23KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `josbc_content`480μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `josbc_content` SET `hits` = (`hits` + 1) WHERE `id` = '24'743μs48B/libraries/src/Table/Table.php:1348Copy
  • 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 `josbc_content` AS `a` INNER JOIN `josbc_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `josbc_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `josbc_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `josbc_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `josbc_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)394μs22.13KBParams/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 `josbc_categories` AS `s` INNER JOIN `josbc_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,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`282μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `josbc_contentitem_tag_map` AS `m` INNER JOIN `josbc_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,:preparedArray2)262μs5.22KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SHOW FULL COLUMNS FROM `josbc_users`476μs1.58KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • SELECT * FROM `josbc_users` WHERE `id` = :userid126μs3.16KBParams/libraries/src/Table/User.php:106Copy
  • SELECT `g`.`id`,`g`.`title` FROM `josbc_usergroups` AS `g` INNER JOIN `josbc_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id` WHERE `m`.`user_id` = :muserid179μs1.37KBParams/libraries/src/Table/User.php:134Copy
  • SELECT * FROM `josbc_users` WHERE `id` = :userid103μs3.16KBParams/libraries/src/Table/User.php:106Copy
  • SELECT `g`.`id`,`g`.`title` FROM `josbc_usergroups` AS `g` INNER JOIN `josbc_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id` WHERE `m`.`user_id` = :muserid144μs1.37KBParams/libraries/src/Table/User.php:134Copy
  • SELECT `b`.`id` FROM `josbc_user_usergroup_map` AS `map` LEFT JOIN `josbc_usergroups` AS `a` ON `a`.`id` = `map`.`group_id` LEFT JOIN `josbc_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `map`.`user_id` = :userId159μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • 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 `josbc_categories` AS `s` INNER JOIN `josbc_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,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`276μs3.91KBParams/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 josbc_fields AS a LEFT JOIN `josbc_languages` AS l ON l.lang_code = a.language LEFT JOIN josbc_users AS uc ON uc.id=a.checked_out LEFT JOIN josbc_viewlevels AS ag ON ag.id = a.access LEFT JOIN josbc_users AS ua ON ua.id = a.created_user_id LEFT JOIN josbc_fields_groups AS g ON g.id = a.group_id LEFT JOIN `josbc_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,:preparedArray4)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) 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 ASC791μs4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`catid`,`a`.`language`, CASE WHEN CHAR_LENGTH(`a`.`alias`) != 0 THEN CONCAT_WS(':', `a`.`id`, `a`.`alias`) ELSE a.id END AS `slug`, CASE WHEN CHAR_LENGTH(`cc`.`alias`) != 0 THEN CONCAT_WS(':', `cc`.`id`, `cc`.`alias`) ELSE cc.id END AS `catslug` FROM `josbc_content` AS `a` LEFT JOIN `josbc_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND `a`.`access` IN (:preparedArray1,:preparedArray2) AND (`publish_up` IS NULL OR `publish_up` <= :nowDate1) AND (`publish_down` IS NULL OR `publish_down` >= :nowDate2) ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC702μs3.22KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:205Copy
  • 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 `josbc_categories` AS `s` INNER JOIN `josbc_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,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`269μs3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `josbc_modules` AS `m` LEFT JOIN `josbc_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `josbc_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,:preparedArray2)) 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`565μs173.97KBParams/libraries/src/Cache/Controller/CallbackController.php:120Copy
  • SELECT params,layoutcss,state from josbc_mobilemenuck_styles WHERE id = 2130μs64.64KB/plugins/system/mobilemenuck/mobilemenuck.php:654Copy
  • SELECT * FROM josbc_modules WHERE published=1 ORDER BY id364μs179.14KB/administrator/components/com_maximenuck/helpers/ckfof.php:168Copy
  • SELECT a.params, a.layoutcss, a.customcss FROM josbc_maximenuck_styles as a WHERE (a.state IN (0, 1)) AND a.id = 4173μs56.64KB/administrator/components/com_maximenuck/helpers/ckfof.php:176Copy
  • SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM josbc_modules AS m LEFT JOIN josbc_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN josbc_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.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-05-13 00:09:44') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-05-13 00:09:44') AND m.access IN (1,5) AND m.client_id = 0 AND m.id = 117221μs912B/components/com_pagebuilderck/models/page.php:748Copy
  • SELECT * FROM josbc_modules WHERE published=1 ORDER BY id366μs181.64KB/administrator/components/com_maximenuck/helpers/ckfof.php:168Copy
  • SELECT a.params, a.layoutcss, a.customcss FROM josbc_maximenuck_styles as a WHERE (a.state IN (0, 1)) AND a.id = 2133μs56.64KB/administrator/components/com_maximenuck/helpers/ckfof.php:176Copy
  • SELECT a.* FROM `josbc_pagebuilderck_fonts` AS a WHERE a.state > 0141μs880B/administrator/components/com_pagebuilderck/helpers/pagebuilderck.php:998Copy
  • SELECT template FROM josbc_template_styles WHERE client_id = 0 AND home = 1144μs536B/administrator/components/com_pagebuilderck/helpers/pagebuilderck.php:609Copy
  • SHOW FULL TABLES WHERE table_type="BASE TABLE"1.86ms3.06KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT * FROM josbc_mobilemenuck_menus WHERE state = 1101μs816B/plugins/system/mobilemenuck/mobilemenuck.php:774Copy
  • SELECT params,layoutcss,state from josbc_mobilemenuck_styles WHERE id = 297μs64.64KB/plugins/system/mobilemenuck/mobilemenuck.php:654Copy
  • SELECT a.params FROM `josbc_mobilemenuck_styles` AS a WHERE (a.state IN (0, 1)) AND a.id = 276μs56.52KB/plugins/system/mobilemenuck/helpers/helper.php:114Copy
  • SELECT * FROM `josbc_schemaorg` WHERE `itemId` = :itemId AND `context` = :context143μs1.55KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:406Copy
  • 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 `josbc_content` AS `a` INNER JOIN `josbc_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `josbc_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `josbc_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `josbc_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `josbc_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)283μs22.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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 `josbc_scheduler_tasks` AS `a` WHERE `a`.`state` = 1147μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `josbc_session` WHERE `session_id` = ?95μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `josbc_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?689μs592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy
Blog