Articles
The Time You Have Left
Great video to show how much time we spend sleeping, eating, bathing, working....and then how little time we spend doing what we really want. Makes you think about your choices!
Written by Helen Whelan
Great video to show how much time we spend sleeping, eating, bathing, working....and then how little time we spend doing what we really want. Makes you think about your choices!
session.client.browser ⇒ CCBot/2.0 (https://commoncrawl.org/faq/)
password_clear ⇒
groups ⇒
link ⇒ https://successtelevision.com/index.php/Home/video-on-how-you-spend-your-time.html
Application 0.000 seconds (+0.000); 0.64 MB (+0.643) - afterLoad
Application 0.061 seconds (+0.061); 7.50 MB (+6.853) - afterInitialise
Application 0.098 seconds (+0.037); 8.71 MB (+1.217) - afterRoute
Application 0.195 seconds (+0.097); 16.14 MB (+7.424) - afterDispatch
Application 0.200 seconds (+0.005); 16.41 MB (+0.277) - beforeRenderModule mod_search (What do you want to know?)
Application 0.208 seconds (+0.008); 16.87 MB (+0.455) - afterRenderModule mod_search (What do you want to know?)
Application 0.209 seconds (+0.001); 16.86 MB (-0.006) - beforeRenderModule mod_custom (Logo)
Application 0.211 seconds (+0.002); 16.88 MB (+0.013) - afterRenderModule mod_custom (Logo)
Application 0.211 seconds (+0.001); 16.88 MB (+0.001) - beforeRenderModule mod_menu (Main Menu)
Application 0.216 seconds (+0.005); 16.97 MB (+0.092) - afterRenderModule mod_menu (Main Menu)
Application 0.220 seconds (+0.004); 17.23 MB (+0.261) - beforeRenderModule mod_custom (Google 200x200)
Application 0.220 seconds (+0.000); 17.23 MB (+0.004) - afterRenderModule mod_custom (Google 200x200)
Application 0.221 seconds (+0.001); 17.23 MB (-0.001) - beforeRenderModule mod_custom (Google 160x600)
Application 0.221 seconds (+0.000); 17.24 MB (+0.004) - afterRenderModule mod_custom (Google 160x600)
Application 0.221 seconds (+0.000); 17.24 MB (-0.001) - beforeRenderModule mod_custom (Google 160x600 (2))
Application 0.221 seconds (+0.000); 17.24 MB (+0.004) - afterRenderModule mod_custom (Google 160x600 (2))
Application 0.222 seconds (+0.001); 17.24 MB (+0.001) - beforeRenderModule mod_banners (Banners)
Application 0.226 seconds (+0.003); 17.46 MB (+0.223) - afterRenderModule mod_banners (Banners)
Application 0.226 seconds (+0.000); 17.46 MB (-0.004) - beforeRenderModule mod_custom (Footer)
Application 0.227 seconds (+0.001); 17.46 MB (+0.004) - afterRenderModule mod_custom (Footer)
Application 0.227 seconds (+0.000); 17.47 MB (+0.003) - beforeRenderModule mod_mj_markupchooser (Select Markup)
Application 0.227 seconds (+0.000); 17.48 MB (+0.008) - afterRenderModule mod_mj_markupchooser (Select Markup)
Application 0.240 seconds (+0.013); 17.84 MB (+0.367) - afterRender
17.87 MB (18,741,992 Bytes)
SELECT `data`
FROM `sgj_session`
WHERE `session_id` = '0c96a0dabce399395b9f278256a35bdd'
SELECT `session_id`
FROM `sgj_session`
WHERE `session_id` = '0c96a0dabce399395b9f278256a35bdd'
LIMIT 0, 1
INSERT INTO `sgj_session`
(`session_id`, `client_id`, `time`)
VALUES
('0c96a0dabce399395b9f278256a35bdd', 0, '1550672554')
SELECT extension_id AS id, element AS "option", params, enabled
FROM sgj_extensions
WHERE `type` = 'component'
AND `element` = 'com_users'
SELECT b.id
FROM sgj_usergroups AS a
LEFT JOIN sgj_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
SELECT id, rules
FROM `sgj_viewlevels`
SELECT folder AS type, element AS name, params
FROM sgj_extensions
WHERE enabled >= 1
AND type ='plugin'
AND state >= 0
AND access IN (1,1)
ORDER BY ordering
SELECT extension_id AS id, element AS "option", params, enabled
FROM sgj_extensions
WHERE `type` = 'component'
AND `element` = 'com_languages'
SELECT `enabled`
FROM `sgj_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'
SELECT `data`
FROM `sgj_mj_amdd`
WHERE `ua`='CCBot/2.0 (https://commoncrawl.org/faq/)'
SELECT extension_id AS id, element AS "option", params, enabled
FROM sgj_extensions
WHERE `type` = 'component'
AND `element` = 'com_widgetkit'
SELECT *
FROM sgj_languages
WHERE published=1
ORDER BY ordering ASC
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM sgj_menu AS m
LEFT JOIN sgj_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
select `alias`,`newurl`
from `sgj_sh404sef_aliases`
where `alias` = 'https://successtelevision.comHome/video-
on-how-you-spend-your-time.html' or `alias` = 'Home/video-
on-how-you-spend-your-time.html' or `alias` = 'Home/video-
on-how-you-spend-your-time.html/'
order by `alias` desc
SELECT `oldurl`, `newurl`, `dateadd`
FROM sgj_sh404sef_urls
WHERE `oldurl`='Home/video-
on-how-you-spend-your-time.html'
ORDER BY `rank`;
SELECT p.folder AS type, p.element AS name
FROM sgj_mj_plugins AS mj
LEFT JOIN sgj_extensions AS p
ON p.extension_id=mj.id
WHERE mj.markup='desktop'
SELECT m.id, m.position
FROM sgj_mj_modules AS mj
LEFT JOIN sgj_modules AS m
ON m.id=mj.id
WHERE mj.markup='desktop'
SELECT a.rules
FROM sgj_assets AS a
WHERE (a.id = 1)
GROUP BY a.id, a.rules, a.lft
SELECT b.rules
FROM sgj_assets AS a
LEFT JOIN sgj_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.id = 1)
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT extension_id AS id, element AS "option", params, enabled
FROM sgj_extensions
WHERE `type` = 'component'
AND `element` = 'com_content'
SELECT extension_id AS id, element AS "option", params, enabled
FROM sgj_extensions
WHERE `type` = 'component'
AND `element` = 'com_menus'
SELECT id, home, template, s.params
FROM sgj_template_styles as s
LEFT JOIN sgj_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
SELECT b.rules
FROM sgj_assets AS a
LEFT JOIN sgj_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as 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.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,(
SELECT MAX(contact.id) AS id
FROM sgj_contact_details AS contact
WHERE contact.published = 1
AND contact.user_id = a.created_by) as contactid,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
FROM sgj_content AS a
LEFT JOIN sgj_categories AS c
on c.id = a.catid
LEFT JOIN sgj_users AS u
on u.id = a.created_by
LEFT JOIN sgj_categories as parent
ON parent.id = c.parent_id
LEFT JOIN sgj_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM sgj_categories AS cat JOIN sgj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published <= 0
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE a.id = 2671
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-02-20 14:22:34')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-20 14:22:34')
AND (a.state = 1 OR a.state =2)
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM sgj_categories as c
LEFT JOIN sgj_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM sgj_categories AS cat JOIN sgj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id=88889015
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SHOW FULL COLUMNS
FROM `sgj_users`
SELECT *
FROM `sgj_users`
WHERE `id` = 63
SELECT `g`.`id`,`g`.`title`
FROM `sgj_usergroups` AS g
INNER JOIN `sgj_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 63
SELECT b.id
FROM sgj_user_usergroup_map AS map
LEFT JOIN sgj_usergroups AS a
ON a.id = map.group_id
LEFT JOIN sgj_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE map.user_id = 63
SELECT b.rules
FROM sgj_assets AS a
LEFT JOIN sgj_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE (a.name = 'com_content.article.2671')
GROUP BY b.id, b.rules, b.lft
ORDER BY b.lft
SELECT a.id, a.language,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM sgj_content AS a
LEFT JOIN sgj_categories AS cc
ON cc.id = a.catid
WHERE a.catid = 88889015
AND a.state = 1
AND a.access = 1
AND (a.state = 1 OR a.state = -1)
AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2019-02-20 14:22:34')
AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2019-02-20 14:22:34')
ORDER BY a.ordering
UPDATE sgj_content
SET hits = hits + 1
WHERE id = 2671
SELECT `oldurl`, `dateadd`
FROM sgj_sh404sef_urls
WHERE `newurl`='index.php?option=com_mailto&lang=en&link=f1858ce7557446817e675207f297300d26e81e3b&template=yoo_pure&tmpl=component';
SELECT params
FROM sgj_extensions AS e
WHERE e.element='com_widgetkit'
SELECT extension_id AS id, element AS "option", params, enabled
FROM sgj_extensions
WHERE `type` = 'component'
AND `element` = 'com_media'
SELECT `pageid`
FROM sgj_sh404sef_pageids
WHERE `newurl`='index.php?option=com_content&catid=88889015&id=2671&lang=en&view=article';
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM sgj_modules AS m
LEFT JOIN sgj_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN sgj_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 <= '2019-02-20 14:22:34')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-02-20 14:22:34')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 0 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
SELECT `oldurl`, `dateadd`
FROM sgj_sh404sef_urls
WHERE `newurl`='index.php?option=com_search&catid=88889015&format=opensearch&id=2671&lang=en&view=article';
SELECT `oldurl`
FROM sgj_sh404sef_urls
WHERE `newurl`='index.php?option=com_search&lang=en&view=article';
SELECT `oldurl`, `dateadd`
FROM sgj_sh404sef_urls
WHERE `newurl`='index.php?option=com_content&lang=en';
SELECT `oldurl`, `dateadd`
FROM sgj_sh404sef_urls
WHERE `newurl`='index.php?option=com_search&lang=en&ordering=&searchphrase=all&tmpl=raw&type=json';
SELECT *
FROM sgj_banners
WHERE '2019-02-20 14:22:34' >= `reset`
AND `reset` != '0000-00-00 00:00:00'
AND `reset`!=NULL
AND (`checked_out` = 0 OR `checked_out` = 0)
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM sgj_banners as a
LEFT JOIN sgj_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
ORDER BY a.sticky DESC,a.ordering
SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM sgj_banners as a
LEFT JOIN sgj_banner_clients AS cl
ON cl.id = a.cid
WHERE a.state=1
AND (CURRENT_TIMESTAMP() >= a.publish_up OR a.publish_up = '0000-00-00 00:00:00')
AND (CURRENT_TIMESTAMP() <= a.publish_down OR a.publish_down = '0000-00-00 00:00:00')
AND (a.imptotal = 0 OR a.impmade <= a.imptotal)
ORDER BY a.sticky DESC,a.ordering
LIMIT 0, 1
SELECT `oldurl`, `dateadd`
FROM sgj_sh404sef_urls
WHERE `newurl`='index.php?option=com_xmap&id=1&lang=en&view=xml';
SELECT `oldurl`
FROM sgj_sh404sef_urls
WHERE `newurl`='index.php?option=com_xmap&id=1&lang=en';
SELECT `id`, `title`, `alias`, `catid`, `language`
FROM sgj_content
WHERE `id`=2671;
SELECT *
FROM sgj_categories
WHERE parent_id > 0
and extension = 'com_content'
and path = 'uncategorised'
and level = 1;
SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM sgj_categories as c
LEFT JOIN sgj_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM sgj_categories AS cat JOIN sgj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
WHERE (c.extension='com_content' OR c.extension='system')
AND s.id=88889015
AND badcats.id is null
GROUP BY 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
ORDER BY c.lft
SHOW FULL COLUMNS
FROM `sgj_sh404sef_metas`
SELECT *
FROM sgj_sh404sef_metas
WHERE `newurl`='index.php?option=com_content&catid=88889015&id=2671&lang=en&view=article';
UPDATE `sgj_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1550672554;s:18:\"session.timer.last\";i:1550672554;s:17:\"session.timer.now\";i:1550672554;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:12:\"mobilejoomla\";O:8:\"stdClass\":2:{s:5:\"cache\";s:208:\"ZY9bDoJADEX30hUA8UHufPqvSzCVqTCBETIdNYawdxmRxMSvJue26bmMHKNiB7LycJWQYZRf4jm094GMIgOlkeegINyd1+SC7Iu1CiK3p7OxIeMWXKy4EVc38Zc7z7Vc++A5KpnjTMv5n/MSX4MsYAsaOLBPRhnGSbEBsbeWzClta7SHjlUJRfKdw+VWsU9ltI39x/2/yDRNbw==\";s:6:\"markup\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:16:\"com_mailto.links\";a:1:{s:40:\"f1858ce7557446817e675207f297300d26e81e3b\";O:8:\"stdClass\":2:{s:4:\"link\";s:82:\"https://successtelevision.com/index.php/Home/video-
on-how-you-spend-your-time.html\";s:6:\"expiry\";i:1550672554;}}}'
, `time` = '1550672554'
WHERE `session_id` = '0c96a0dabce399395b9f278256a35bdd'
6 × SELECT extension_id AS id, element AS "option", params, enabled
FROM sgj_extensions
5 × SELECT `oldurl`, `dateadd`
FROM sgj_sh404sef_urls
3 × SELECT b.rules
FROM sgj_assets AS a
LEFT JOIN sgj_assets AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
2 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions
FROM sgj_banners as a
LEFT JOIN sgj_banner_clients AS cl
ON cl.id = a.cid
2 × SELECT `oldurl`
FROM sgj_sh404sef_urls
2 × SELECT c.*,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM sgj_categories as c
LEFT JOIN sgj_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN (SELECT cat.id as id
FROM sgj_categories AS cat JOIN sgj_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT a.id, a.language,
CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug
FROM sgj_content AS a
LEFT JOIN sgj_categories AS cc
ON cc.id = a.catid
1 × SELECT `g`.`id`,`g`.`title`
FROM `sgj_usergroups` AS g
INNER JOIN `sgj_user_usergroup_map` AS m
ON m.group_id = g.id
1 × SELECT *
FROM `sgj_users`
1 × SELECT b.id
FROM sgj_user_usergroup_map AS map
LEFT JOIN sgj_usergroups AS a
ON a.id = map.group_id
LEFT JOIN sgj_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM sgj_modules AS m
LEFT JOIN sgj_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN sgj_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT *
FROM sgj_categories
1 × SELECT *
FROM sgj_sh404sef_metas
1 × SELECT `id`, `title`, `alias`, `catid`, `language`
FROM sgj_content
1 × SELECT *
FROM sgj_banners
1 × SELECT `pageid`
FROM sgj_sh404sef_pageids
1 × SELECT params
FROM sgj_extensions AS e
1 × SELECT id, home, template, s.params
FROM sgj_template_styles as s
LEFT JOIN sgj_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT `enabled`
FROM `sgj_extensions`
1 × SELECT `data`
FROM `sgj_mj_amdd`
1 × SELECT folder AS type, element AS name, params
FROM sgj_extensions
1 × SELECT id, rules
FROM `sgj_viewlevels
1 × SELECT `session_id`
FROM `sgj_session`
1 × SELECT b.id
FROM sgj_usergroups AS a
LEFT JOIN sgj_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT *
FROM sgj_languages
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM sgj_menu AS m
LEFT JOIN sgj_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT a.rules
FROM sgj_assets AS a
1 × SELECT `data`
FROM `sgj_session`
1 × SELECT m.id, m.position
FROM sgj_mj_modules AS mj
LEFT JOIN sgj_modules AS m
ON m.id=mj.id
1 × SELECT p.folder AS type, p.element AS name
FROM sgj_mj_plugins AS mj
LEFT JOIN sgj_extensions AS p
ON p.extension_id=mj.id
1 × select `alias`,`newurl`
from `sgj_sh404sef_aliases`
1 × SELECT `oldurl`, `newurl`, `dateadd`
FROM sgj_sh404sef_urls
1 × SELECT a.id, a.asset_id, a.title, a.alias, a.title_alias, a.introtext, a.fulltext,
CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.mask, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN a.modified = 0 THEN a.created ELSE a.modified END as 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.parentid, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,( SELECT MAX(contact.id) AS id
FROM sgj_contact_details AS contact
1 × UPDATE `sgj_session`
SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1550672554;s:18:\"session.timer.last\";i:1550672554;s:17:\"session.timer.now\";i:1550672554;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:12:\"mobilejoomla\";O:8:\"stdClass\":2:{s:5:\"cache\";s:208:\"ZY9bDoJADEX30hUA8UHufPqvSzCVqTCBETIdNYawdxmRxMSvJue26bmMHKNiB7LycJWQYZRf4jm094GMIgOlkeegINyd1+SC7Iu1CiK3p7OxIeMWXKy4EVc38Zc7z7Vc++A5KpnjTMv5n/MSX4MsYAsaOLBPRhnGSbEBsbeWzClta7SHjlUJRfKdw+VWsU9ltI39x/2/yDRNbw==\";s:6:\"markup\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:16:\"com_mailto.links\";a:1:{s:40:\"f1858ce7557446817e675207f297300d26e81e3b\";O:8:\"stdClass\":2:{s:4:\"link\";s:82:\"https://successtelevision.com/index.php/Home/video-
on-how-you-spend-your-time.html\";s:6:\"expiry\";i:1550672554;}}}' , `time` = '1550672554'
1 × SHOW FULL COLUMNS
FROM `sgj_sh404sef_metas
1 × UPDATE sgj_content
SET hits = hits + 1
1 × SHOW FULL COLUMNS
FROM `sgj_users
1 × INSERT INTO `sgj_session` (`session_id`, `client_id`, `time`)
VALUES ('0c96a0dabce399395b9f278256a35bdd', 0, '1550672554'