That's One Expensive Upgrade

Sonos Connect

You've heard of Sonos, yes? Whole-house audio, wireless and able to bridge pretty-much any source. It'll play my music library, stream Pandora, talk to Alexa (or Google), and even stream the same music in all rooms. The little boxes can do it over WiFi or ethernet and form their own mesh network as well. All in all, it's pretty slick and incredibly well done. Further, once you buy a device, you're done. There's no subscription cost for their service and upgrades.

Of course, this makes sense, seeing as the boxes are expensive. The "Connect," which is a passive audio source (meaning you need to plug the audio output into an amp, like your home theater system) runs over $450. The powered version (into which you can just connect speakers) is a couple hundred more, around $650. Then they have powered speaker versions for a couple hundred up to $500. And I've not even gotten into their home theater sound bars and subs, which can run, as a set, over a grand.

So you feel me on the cost.

Over the years, I've acquired three Connects, one Amp, and one "One," which is their powered speaker. All are first-gen units.

Now we get to the dilemma: Sonos has noted that these first-gen units are underpowered for modern times and they've given them end-of-life. They now have a v2 (called S2, whereas the older units are called S1) and say that new features and modern features will only come out on S2. S1 gets bugs and security patches, but that's it. Initially, they'd said they'd brick S1 (seriously!) but they walked that back when customers rightly revolted. But if you have any S1 devices in your home, you can't use S2.

There are three options: first, just stay on S1 and life goes on like it is now, but no new features. Second, buy some S2 units and split your home. S1 is one Sonos network and S2 is another. There are problems with this, but generally, you can do it. Or, third...

Upgrade everything to S2. To encourage this, Sonos is giving S1 users a 30% credit on any purchase of an S2 device that maps to an S1 that they already have. So in my case, I could buy three S2 "Connect" equivalents and one S2 "Amp" equivalent and get 30% off each. The offer is only per S1 device you already have. Sonos will take the old devices and recycle them for you if you want, or you can do it yourself. Or... as it appears, you can still use them. That's right, you could grow your system by double, split it (S1 and S2) and get 30% off of the S2 stack as a spiff.

Or, in my case, take my S1 Amp and put it in my travel trailer on its own network. Then I could upgrade the three Connect units into S2 units and give them away to friends. A friend who doesn't have Sonos would be thrilled at S1, as it's still pretty cool. The unit wouldn't be eligible for the discount, but it's usable, albeit with today's older feature set.

But that's 70% of $650 + $450 + $450 + $450. More than just casual chump change.

You can't fault Sonos for not being able to use 15 year-old tech in a modern way. On the other hand, that's one expensive upgrade!

If you give advice here, please be snarky, because I already know what I'm going to do ;)

×
Stay Informed

When you subscribe to the blog, we will send you an e-mail when there are new updates on the site so you wouldn't miss them.

 
35.447MBMemory Usage996msRequest Duration
Joomla! Version5.2.3
PHP Version8.2.28
Identityguest
Response200
Templatert_ambrosia
Database
Server
mysql
Version
8.0.35
Collation
utf8mb4_0900_ai_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:76 [ "USER" => "www-data" "HOME" => "/var/www" "SCRIPT_NAME" => "/index.php" "REQUEST_...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743514322 "last" => 1743514322...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => "" "username" => null "email" => "" "password" => "***redac...
f3f316c3edad2538449df6cf01603b24
1
  • afterLoad (100.96KB) (1.56ms)
  • afterInitialise (1.68MB) (36.37ms)
  • afterRoute (1.62MB) (33.48ms)
  • beforeRenderComponent com_easyblog (15.1KB) (375μs)
  • Before Access::preloadComponents (all components) (19.42KB) (155μs)
  • After Access::preloadComponents (all components) (125.27KB) (2.45ms)
  • Before Access::getAssetRules (id:1 name:root.1) (104B) (24μs)
  • After Access::getAssetRules (id:1 name:root.1) (6.7KB) (94μs)
  • afterRenderComponent com_easyblog (3.53MB) (186ms)
  • afterDispatch (76.35KB) (22.36ms)
  • beforeRenderRawModule mod_gantry5_particle (Amazon Ad) (866.59KB) (25.61ms)
  • afterRenderRawModule mod_gantry5_particle (Amazon Ad) (9.24KB) (1.63ms)
  • beforeRenderModule mod_gantry5_particle (Amazon Ad) (720B) (9μs)
  • afterRenderModule mod_gantry5_particle (Amazon Ad) (4.83KB) (323μs)
  • beforeRenderRawModule mod_jfbcsocialshare (Floating Social Share) (3.72KB) (263μs)
  • afterRenderRawModule mod_jfbcsocialshare (Floating Social Share) (13.12KB) (800μs)
  • beforeRenderModule mod_jfbcsocialshare (Floating Social Share) (736B) (7μs)
  • afterRenderModule mod_jfbcsocialshare (Floating Social Share) (3.7KB) (101μs)
  • Before Access::getAssetRules (id:248 name:com_jfbconnect) (9.81MB) (651ms)
  • After Access::getAssetRules (id:248 name:com_jfbconnect) (1.45KB) (19μs)
  • afterRender (413.75KB) (32.53ms)
  • 1 x Before Access::getAssetRules (id:248 name:com_jfbconnect) (9.81MB) (65.38%)
    651ms
    1 x afterRenderComponent com_easyblog (3.53MB) (18.7%)
    186ms
    1 x afterInitialise (1.68MB) (3.65%)
    36.37ms
    1 x afterRoute (1.62MB) (3.36%)
    33.48ms
    1 x afterRender (413.75KB) (3.27%)
    32.53ms
    1 x beforeRenderRawModule mod_gantry5_particle (Amazon Ad) (866.59KB) (2.57%)
    25.61ms
    1 x afterDispatch (76.35KB) (2.25%)
    22.36ms
    1 x After Access::preloadComponents (all components) (125.27KB) (0.25%)
    2.45ms
    1 x afterRenderRawModule mod_gantry5_particle (Amazon Ad) (9.24KB) (0.16%)
    1.63ms
    1 x afterLoad (100.96KB) (0.16%)
    1.56ms
    1 x afterRenderRawModule mod_jfbcsocialshare (Floating Social Share) (13.12KB) (0.08%)
    800μs
    1 x beforeRenderComponent com_easyblog (15.1KB) (0.04%)
    375μs
    1 x afterRenderModule mod_gantry5_particle (Amazon Ad) (4.83KB) (0.03%)
    323μs
    1 x beforeRenderRawModule mod_jfbcsocialshare (Floating Social Share) (3.72KB) (0.03%)
    263μs
    1 x Before Access::preloadComponents (all components) (19.42KB) (0.02%)
    155μs
    1 x afterRenderModule mod_jfbcsocialshare (Floating Social Share) (3.7KB) (0.01%)
    101μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.7KB) (0.01%)
    94μs
    1 x Before Access::getAssetRules (id:1 name:root.1) (104B) (0%)
    24μs
    1 x After Access::getAssetRules (id:248 name:com_jfbconnect) (1.45KB) (0%)
    19μs
    1 x beforeRenderModule mod_gantry5_particle (Amazon Ad) (720B) (0%)
    9μs
    1 x beforeRenderModule mod_jfbcsocialshare (Floating Social Share) (736B) (0%)
    7μs
92 statements were executed, 10 of which were duplicates, 82 unique125ms534.59KB
  • SELECT @@SESSION.sql_mode;723μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `bit_session` WHERE `session_id` = ?799μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `bit_session` WHERE `session_id` = :session_id LIMIT 1747μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `bit_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)5.87ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `id`,`rules` FROM `bit_viewlevels`767μs976B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `bit_usergroups` AS `a` LEFT JOIN `bit_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest895μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT setting,value FROM bit_jfbconnect_config1.49ms34.06KB/administrator/components/com_jfbconnect/models/config.php:307Copy
  • SELECT * FROM `bit_easyblog_configs` WHERE `name` = 'config'1.85ms80.58KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `bit_easyblog_acl` WHERE `published`='1' ORDER BY `id` ASC945μs2.36KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `bit_easyblog_acl_group` WHERE `content_id` IN (1, 9) AND `type`='group'3.08ms28.73KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT `id` FROM `bit_easyblog_post` WHERE `permalink`='that-s-one-expensive-upgrade'1.03ms536B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `bit_easyblog_post` WHERE `id` = '156'1.04ms21.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `bit_easyblog_revisions` WHERE `id` = '348'2.16ms41.28KB/libraries/src/Table/Table.php:780Copy
  • SELECT COUNT(1) FROM `bit_easyblog_featured` WHERE `content_id`='156' AND `type`='post'764μs536B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `bit_easyblog_meta` WHERE `type`='post' AND `content_id`='156'748μs928B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT s.id, s.template, s.home, s.title AS long_title, s.params FROM bit_template_styles AS s WHERE s.client_id = 0 AND s.template = 'rt_ambrosia' ORDER BY s.id909μs800B/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `bit_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)1.18ms9.06KBParams/libraries/src/Access/Access.php:357Copy
  • DELETE FROM `bit_easyblog_mailq` WHERE `status`='1' AND DATEDIFF(NOW(), `created`) >='7'3.71ms0B/administrator/components/com_easyblog/includes/utils.php:166Copy
  • SELECT `id` FROM `bit_easyblog_mailq` WHERE `status`='0' ORDER BY `id` ASC LIMIT 5769μs520B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `bit_easyblog_post` WHERE `publish_up`<='2025-04-01 13:32:02' AND `published`='2' AND `state`='0' ORDER BY `id` LIMIT 11.21ms5.42KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT id, created_by FROM`bit_easyblog_post` WHERE `publish_down` > `publish_up` AND `publish_down` <= '2025-04-01 13:32:02' AND `publish_down` != '0000-00-00 00:00:00' AND `published` = '1' AND `state` = '0'856μs576B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `bit_easyblog_uploader_tmp` WHERE `created` <= DATE_SUB('2025-04-01 13:32:02' , INTERVAL 120 MINUTE)2.75ms880B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT a.`id` FROM `bit_easyblog_post` as a inner join `bit_easyblog_revisions` as b on a.`id` = b.`post_id` where a.`published` = '9' and a.`created` <= DATE_SUB('2025-04-01 13:32:02', INTERVAL 3 DAY)2.01ms520B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • DELETE a, b FROM `bit_easyblog_post` as a inner join `bit_easyblog_revisions` as b on a.`id` = b.`post_id` where a.`published` = '9' and a.`created` <= DATE_SUB('2025-04-01 13:32:02', INTERVAL 3 DAY)5.18ms0B/administrator/components/com_easyblog/includes/utils.php:166Copy
  • select a.`id`, a.`user_id`, b.`name`, b.`email` from `bit_easyblog_oauth` as a inner join `bit_users` as b on a.`user_id` = b.`id` where a.`type` = 'facebook' and a.`notify` = '0' and a.`system` = '1' and a.`expires` <= DATE_ADD('2025-04-01 13:32:02', INTERVAL 7 DAY)976μs688B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `bit_easyblog_post` WHERE `id` = '156'985μs21.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `bit_easyblog_revisions` WHERE `id` = '348'822μs41.28KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `bit_easyblog_meta` WHERE `type`='post' AND `content_id`='156'868μs928B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT COUNT(1) as `voted`, `uid` FROM `bit_easyblog_ratings` WHERE `uid` = '156' AND `type`='entry' AND `created_by`='0' AND (`sessionid` = 'c1pp01fie1ojn1ubjf8mri9c7h' OR `ip` = '3.14.145.94') GROUP BY `uid` ORDER BY NULL1.04ms576B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` FROM `bit_easyblog_ratings` AS a WHERE a.`uid` IN(156) AND `type`='entry' GROUP BY `uid` ORDER BY NULL1.37ms640B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select a.*, b.`post_id`, b.`primary` from `bit_easyblog_category` as a inner join `bit_easyblog_post_category` as b on a.`id` = b.`category_id` where b.`post_id` IN (156) order by a.`lft` asc1.21ms2.78KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select a.*, b.`post_id` from `bit_easyblog_tag` as a inner join `bit_easyblog_post_tag` as b on a.`id` = b.`tag_id` where b.`post_id` IN (156)870μs1.53KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select a.* from `bit_easyblog_revisions` as a where a.`id` IN ( 348)984μs43.78KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select u.*, e.`id` as `eb_id`, e.`nickname`, e.`avatar`, e.`description`, e.`url`, e.`params` as `eb_params`, e.`published` as `eb_published`, e.`title` as `eb_title`, e.`biography`, e.`permalink`, e.`custom_css`, e.`ordering` from `bit_users` as u left join `bit_easyblog_users` as e ON u.`id` = e.`id` where u.`id` = 641922μs3.06KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SHOW FULL COLUMNS FROM `bit_users`3.27ms1.58KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT * FROM `bit_users` WHERE `id` = :userid2.15ms3.16KBParams/libraries/src/Table/User.php:106Copy
  • SELECT `g`.`id`,`g`.`title` FROM `bit_usergroups` AS `g` INNER JOIN `bit_user_usergroup_map` AS `m` ON `m`.`group_id` = `g`.`id` WHERE `m`.`user_id` = :muserid1.05ms1.38KBParams/libraries/src/Table/User.php:134Copy
  • select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `f`.`ordering` as `f_ordering`,`fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` from `bit_easyblog_category_fields_groups` as a inner join `bit_easyblog_post_category` as p on `a`.`category_id` = `p`.`category_id` inner join `bit_easyblog_fields_groups` as fg on `a`.`group_id` = `fg`.`id` inner join `bit_easyblog_fields` as f on `fg`.`id` = `f`.`group_id` left join `bit_easyblog_fields_values` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id` LEFT JOIN `bit_easyblog_fields_groups_acl` AS acl ON fg.`id` = acl.`group_id` where `p`.`post_id` = '156' AND ( acl.`acl_id` IN(9) AND acl.`acl_type` = 'read' OR acl.`id` IS NULL )1.3ms2.83KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select * from `bit_easyblog_meta` where `content_id` in (156) and `type` = 'post'927μs928B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `bit_easyblog_meta` WHERE `content_id` = '156' AND `type` = 'post'914μs928B/libraries/src/Table/Table.php:780Copy
  • 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 bit_fields AS a LEFT JOIN `bit_languages` AS l ON l.lang_code = a.language LEFT JOIN bit_users AS uc ON uc.id=a.checked_out LEFT JOIN bit_viewlevels AS ag ON ag.id = a.access LEFT JOIN bit_users AS ua ON ua.id = a.created_user_id LEFT JOIN bit_fields_groups AS g ON g.id = a.group_id LEFT JOIN `bit_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 ASC1.44ms4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • UPDATE `bit_easyblog_post` SET `hits` = (`hits` + 1) WHERE `id` = '156'8.27ms48B/libraries/src/Table/Table.php:1348Copy
  • SELECT `key`,`value` FROM `bit_easyblog_post_assets` WHERE `post_id`='156'772μs528B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT COUNT(1) FROM `bit_easyblog_feeds_history` WHERE `post_id`='156'1.41ms536B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select `id` FROM `bit_easyblog_adsense` where user_id = '641'769μs536B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `bit_easyblog_adsense` WHERE `id` = '3'848μs768B/libraries/src/Table/Table.php:780Copy
  • SELECT `id` FROM `bit_menu` WHERE ( `link` LIKE 'index.php?option=com_easyblog&view=entry&id=156%' OR `link` LIKE 'index.php?option=com_easyblog&view=entry&id=156%' ) AND `published`='1' AND (`language`='en-GB' OR `language`='' OR `language`='*') LIMIT 11.45ms520B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT a.`id`, a.`title` FROM `bit_easyblog_post` AS `a` INNER JOIN `bit_users` AS uu ON a.`created_by` = uu.`id` and uu.`block` = 0 WHERE a.`published` = '1' AND a.`state` = '0' AND a.`access`='0' AND a.`source_type`='easyblog.sitewide' AND a.`id` NOT IN(156) AND a.`created` < '2020-09-03 06:02:40' ORDER BY a.`created` DESC LIMIT 11.42ms592B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT a.`id`, a.`title` FROM `bit_easyblog_post` AS `a` INNER JOIN `bit_users` AS uu ON a.`created_by` = uu.`id` and uu.`block` = 0 WHERE a.`published` = '1' AND a.`state` = '0' AND a.`access`='0' AND a.`source_type`='easyblog.sitewide' AND a.`id` NOT IN(156) AND a.`created` > '2020-09-03 06:02:40' ORDER BY a.`created` ASC LIMIT 11.06ms592B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `bit_easyblog_post` WHERE `id` = '155'890μs5.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `bit_easyblog_revisions` WHERE `id` = '347'843μs1.28KB/libraries/src/Table/Table.php:780Copy
  • SELECT COUNT(1) FROM `bit_easyblog_featured` WHERE `content_id`='155' AND `type`='post'841μs536B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `bit_easyblog_meta` WHERE `type`='post' AND `content_id`='155'842μs928B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `bit_easyblog_post` WHERE `id` = '157'1.26ms21.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `bit_easyblog_revisions` WHERE `id` = '350'786μs1.28KB/libraries/src/Table/Table.php:780Copy
  • SELECT COUNT(1) FROM `bit_easyblog_featured` WHERE `content_id`='157' AND `type`='post'798μs536B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `bit_easyblog_meta` WHERE `type`='post' AND `content_id`='157'1.31ms928B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT COUNT(1) as `voted`, `uid` FROM `bit_easyblog_ratings` WHERE `uid` IN (155,157) AND `type`='entry' AND `created_by`='0' AND (`sessionid` = 'c1pp01fie1ojn1ubjf8mri9c7h' OR `ip` = '3.14.145.94') GROUP BY `uid` ORDER BY NULL1.17ms576B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT AVG(`value`) AS `ratings` ,COUNT(1) AS `total` ,`uid` FROM `bit_easyblog_ratings` AS a WHERE a.`uid` IN(155,157) AND `type`='entry' GROUP BY `uid` ORDER BY NULL873μs640B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select a.*, b.`post_id`, b.`primary` from `bit_easyblog_category` as a inner join `bit_easyblog_post_category` as b on a.`id` = b.`category_id` where b.`post_id` IN (155,157) order by a.`lft` asc1.2ms2.8KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select a.*, b.`post_id` from `bit_easyblog_tag` as a inner join `bit_easyblog_post_tag` as b on a.`id` = b.`tag_id` where b.`post_id` IN (155,157)843μs1.5KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select a.* from `bit_easyblog_revisions` as a where a.`id` IN ( 347,350)970μs1.3KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select `a`.`id` as `cat_fg_id`, `a`.`category_id` as `cat_fg_category_id`, `a`.`group_id` as `cat_fg_group_id`, `fg`.`id` as `fg_id`, `fg`.`title` as `fg_title`, `fg`.`description` as `fg_description`, `fg`.`created` as `fg_created`, `fg`.`state` as `fg_state`, `fg`.`read` as `fg_read`, `fg`.`write` as `fg_write`, `fg`.`params` as `fg_params`, `f`.`id` as `f_id`, `f`.`group_id` as `f_group_id`, `f`.`title` as `f_title`, `f`.`help` as `f_help`, `f`.`state` as `f_state`, `f`.`required` as `f_required`, `f`.`type` as `f_type`, `f`.`params` as `f_params`, `f`.`created` as `f_created`, `f`.`options` as `f_options`, `f`.`ordering` as `f_ordering`,`fv`.`id` as `fv_id`, `fv`.`field_id` as `fv_field_id`, `fv`.`post_id` as `fv_post_id`, `fv`.`value` as `fv_value` from `bit_easyblog_category_fields_groups` as a inner join `bit_easyblog_post_category` as p on `a`.`category_id` = `p`.`category_id` inner join `bit_easyblog_fields_groups` as fg on `a`.`group_id` = `fg`.`id` inner join `bit_easyblog_fields` as f on `fg`.`id` = `f`.`group_id` left join `bit_easyblog_fields_values` as fv on `fv`.`field_id` = `f`.`id` and `fv`.`post_id` = `p`.`post_id` LEFT JOIN `bit_easyblog_fields_groups_acl` AS acl ON fg.`id` = acl.`group_id` where p.post_id IN (155,157) AND ( acl.`acl_id` IN(9) AND acl.`acl_type` = 'read' OR acl.`id` IS NULL )1.97ms2.83KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • select * from `bit_easyblog_meta` where `content_id` in (155,157) and `type` = 'post'948μs944B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT `group_id` FROM `bit_user_usergroup_map` WHERE `user_id` = '641'810μs11.54KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `bit_easyblog_acl_group` WHERE `content_id` IN (2, 8) AND `type`='group'2.55ms28.73KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM `bit_easyblog_composer_blocks`897μs2.2KB/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT `template` FROM `bit_template_styles` WHERE `home`!='0' AND `client_id`='0'875μs536B/libraries/foundry/helper.php:553Copy
  • SELECT `id` FROM `bit_easyblog_post` WHERE `permalink`='that-s-one-expensive-upgrade'936μs536B/administrator/components/com_easyblog/includes/utils.php:298Copy
  • SELECT * FROM bit_opengraph_object WHERE plugin = 'easyblog' AND system_name = 'post' AND published = 1766μs1.34KB/components/com_jfbconnect/models/opengraphobject.php:68Copy
  • SELECT * FROM `bit_easyblog_post` WHERE `id` = '156'977μs21.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT lft, rgt FROM bit_easyblog_category WHERE id = 2777μs592B/plugins/opengraph/easyblog/easyblog.php:83Copy
  • SELECT * FROM `bit_easyblog_post` WHERE `id` = '156'861μs21.44KB/libraries/src/Table/Table.php:780Copy
  • SELECT act.* FROM bit_jfbconnect_autopost_activity act WHERE `act`.`ext`='com_easyblog' AND `act`.`layout`='post' AND `act`.`item_id`='156' AND `act`.`type`=1 AND `act`.`status`=2920μs1.45KB/plugins/system/jfbcsystem/jfbcsystem.php:333Copy
  • SELECT `a`.`menutype`,`a`.`title` FROM `bit_menu_types` AS `a` WHERE `a`.`client_id` = 0735μs608B/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:138Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM bit_menu AS m WHERE m.menutype = 'mainmenu' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft886μs912B/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT * FROM `bit_easyblog_category` WHERE `id` = '4'794μs2.72KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `bit_easyblog_category` WHERE `id` = '5'775μs2.72KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `bit_easyblog_category` WHERE `id` = '6'756μs2.72KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `bit_easyblog_category` WHERE `id` = '9'738μs2.72KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `bit_easyblog_category` WHERE `id` = '10'1ms2.72KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `bit_easyblog_category` WHERE `id` = '13'861μs2.72KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `bit_easyblog_category` WHERE `id` = '11'928μs2.72KB/libraries/src/Table/Table.php:780Copy
  • SELECT * FROM `bit_extensions` WHERE `element` = 'com_gsd' AND `type` = 'component'1.25ms2.53KB/plugins/system/nrframework/NRFramework/Extension.php:160Copy
  • SHOW FULL COLUMNS FROM `bit_gsd_config`1.22ms1.3KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT * FROM `bit_gsd_config` WHERE `name` = 'config'752μs592B/libraries/src/Table/Table.php:780Copy
  • SELECT a.* FROM bit_gsd a WHERE a.state = 1 AND a.plugin = 'easyblog' AND a.appview IN ('entry','*') ORDER BY a.id desc1.17ms1.44KB/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT count(id) FROM bit_users WHERE id = '641'801μs536B/plugins/system/nrframework/NRFramework/User.php:68Copy
  • SELECT a.* FROM bit_gsd a WHERE a.state = 1 AND a.plugin = 'menus' AND a.appview IN ('menus','*') ORDER BY a.id desc1.47ms1.44KB/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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 `bit_scheduler_tasks` AS `a` WHERE `a`.`state` = 1851μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465Copy
  • SELECT `session_id` FROM `bit_session` WHERE `session_id` = ?811μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `bit_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?4.77ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy