About Us

Nyembe Waste Management is owned and managed by Ms Millicent Nyembe. To be able to accomplish her Mission, Ms. Nyembe acquired the necessary training and knowledge that empowered her to run this business in a professional way and comply with relevant laws and regulations. Millicent Nyembe's Entrepreneurial skills earned her a place in the SAB top 5 Young Entrepreneurs.

Here is an excerpt from the article on SAB's website:

Millicent Nyembe (31) is the owner of Nyembe Waste Management, based in Pretoria, which specialises in crime scene cleaning and transportation of health care risk waste. The business has been operational since 2012 and provides a service to emergency services and health care facilities across Gauteng. This year, she has been focusing her efforts on improving customer service, the day to day management of the business, negotiating with existing customers and working on acquiring new customers for long term contracts, as well as improving administrative efficiencies. Millicent says that this year she has gained more confidence in herself as an entrepreneur as a result of the mentorship programme, which she says provided encouragement.

From Tea Lady to Business Owner

- READ THE ARTICLE HERE

Joomla! Debug Console

Time

Memory

Time: 0.0 ms / 0.0 ms Memory: 0.377 MB / 0.38 MB Application: afterLoad

Time: 44.5 ms / 44.5 ms Memory: 1.147 MB / 1.52 MB Application: afterInitialise

Time: 11.3 ms / 55.8 ms Memory: 0.285 MB / 1.81 MB Application: afterRoute

Time: 115.7 ms / 171.6 ms Memory: 1.783 MB / 3.59 MB Application: afterDispatch

Time: 5.4 ms / 177.0 ms Memory: 0.136 MB / 3.73 MB Application: beforeRenderModule mod_sp_simple_youtube (SP Simple Youtube 1)

Time: 2.3 ms / 179.3 ms Memory: 0.013 MB / 3.74 MB Application: afterRenderModule mod_sp_simple_youtube (SP Simple Youtube 1)

Time: 0.1 ms / 179.4 ms Memory: 0.000 MB / 3.74 MB Application: beforeRenderModule mod_sp_simple_youtube (SP Simple Youtube (2))

Time: 0.2 ms / 179.6 ms Memory: 0.008 MB / 3.75 MB Application: afterRenderModule mod_sp_simple_youtube (SP Simple Youtube (2))

Time: 0.1 ms / 179.6 ms Memory: 0.000 MB / 3.75 MB Application: beforeRenderModule mod_sp_simple_youtube (SP Simple Youtube (3))

Time: 0.2 ms / 179.8 ms Memory: 0.008 MB / 3.75 MB Application: afterRenderModule mod_sp_simple_youtube (SP Simple Youtube (3))

Time: 0.2 ms / 180.0 ms Memory: 0.000 MB / 3.75 MB Application: beforeRenderModule mod_custom (contact info )

Time: 1.1 ms / 181.0 ms Memory: 0.010 MB / 3.77 MB Application: afterRenderModule mod_custom (contact info )

Time: 5.5 ms / 186.5 ms Memory: 0.092 MB / 3.86 MB Application: beforeRenderModule mod_custom (Logo)

Time: 0.3 ms / 186.8 ms Memory: 0.007 MB / 3.86 MB Application: afterRenderModule mod_custom (Logo)

Time: 0.8 ms / 187.6 ms Memory: 0.003 MB / 3.87 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 2.6 ms / 190.3 ms Memory: 0.036 MB / 3.90 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 5.5 ms / 195.8 ms Memory: 0.081 MB / 3.98 MB Application: beforeRenderModule mod_custom (Logo (Mobile))

Time: 0.3 ms / 196.1 ms Memory: 0.007 MB / 3.99 MB Application: afterRenderModule mod_custom (Logo (Mobile))

Time: 2.0 ms / 198.1 ms Memory: 0.002 MB / 3.99 MB Application: beforeRenderModule mod_custom (Footer)

Time: 0.3 ms / 198.4 ms Memory: 0.007 MB / 4.00 MB Application: afterRenderModule mod_custom (Footer)

Time: 1.0 ms / 199.4 ms Memory: 0.021 MB / 4.02 MB Application: beforeRenderModule mod_visitorcounter (VCNT - Visitorcounter)

Time: 6.1 ms / 205.5 ms Memory: 0.228 MB / 4.25 MB Application: afterRenderModule mod_visitorcounter (VCNT - Visitorcounter)

Time: 0.8 ms / 206.3 ms Memory: 0.000 MB / 4.23 MB Application: beforeRenderModule mod_menu (Main Menu (Mobile))

Time: 0.9 ms / 207.2 ms Memory: 0.010 MB / 4.24 MB Application: afterRenderModule mod_menu (Main Menu (Mobile))

Time: 6.8 ms / 214.0 ms Memory: 0.112 MB / 4.36 MB Application: afterRender

Database queries total: 19.5 ms

29 Queries Logged 19.5 ms

Query Time: 0.76 ms Query memory: 0.015 MB Memory before query: 0.844 MB Rows returned: 0
```
SELECT `data`

  FROM `jossg_session`

  WHERE `session_id` = 'u7oc5vtosnqaqvfnqm04vl83l6'
```
Explain
EXPLAIN not possible on query: SELECT `data` FROM `jossg_session` WHERE `session_id` = 'u7oc5vtosnqaqvfnqm04vl83l6'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/session/storage/database.php:44
JROOT/libraries/joomla/session/session.php:651
JROOT/libraries/joomla/session/session.php:589
JROOT/libraries/cms/application/cms.php:739
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.29 ms After last query: 2.54 ms Query memory: 0.012 MB Memory before query: 0.902 MB Rows returned: 0
```
SELECT `session_id`

  FROM `jossg_session`

  WHERE `session_id` = 'u7oc5vtosnqaqvfnqm04vl83l6' 
  LIMIT 0, 1
```
Explain
EXPLAIN not possible on query: SELECT `session_id` FROM `jossg_session` WHERE `session_id` = 'u7oc5vtosnqaqvfnqm04vl83l6' LIMIT 0, 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:176
JROOT/libraries/cms/application/cms.php:765
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.29 ms After last query: 0.09 ms Query memory: 0.009 MB Memory before query: 0.914 MB
```
INSERT INTO `jossg_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('u7oc5vtosnqaqvfnqm04vl83l6', 0, '1728017000')
```
Explain
EXPLAIN not possible on query: INSERT INTO `jossg_session` (`session_id`, `client_id`, `time`) VALUES ('u7oc5vtosnqaqvfnqm04vl83l6', 0, '1728017000')
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:208
JROOT/libraries/cms/application/cms.php:765
JROOT/libraries/cms/application/cms.php:131
JROOT/libraries/cms/application/site.php:63
JROOT/libraries/cms/application/cms.php:399
JROOT/libraries/joomla/factory.php:125
JROOT/index.php:42
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.83 ms After last query: 4.58 ms Query memory: 0.018 MB Memory before query: 0.997 MB Rows returned: 32
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM jossg_extensions

  WHERE `type` = 'component'
```
Explain
EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled FROM jossg_extensions WHERE `type` = 'component'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/cms/component/helper.php:435
JROOT/libraries/cms/component/helper.php:43
JROOT/libraries/cms/component/helper.php:120
JROOT/libraries/cms/application/site.php:584
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.72 ms After last query: 1.57 ms Query memory: 0.014 MB Memory before query: 1.055 MB Rows returned: 2
```
SELECT b.id

  FROM jossg_usergroups AS a

  LEFT JOIN jossg_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9
```
Explain
EXPLAIN not possible on query: SELECT b.id FROM jossg_usergroups AS a LEFT JOIN jossg_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 9
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:332
JROOT/libraries/joomla/access/access.php:401
JROOT/libraries/joomla/user/user.php:453
JROOT/libraries/cms/plugin/helper.php:296
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.57 ms After last query: 0.61 ms Query memory: 0.013 MB Memory before query: 1.075 MB Rows returned: 5
```
SELECT id, rules

  FROM `jossg_viewlevels`
```
Explain
EXPLAIN not possible on query: SELECT id, rules FROM `jossg_viewlevels`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:418
JROOT/libraries/joomla/user/user.php:453
JROOT/libraries/cms/plugin/helper.php:296
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.53 ms After last query: 0.14 ms Query memory: 0.012 MB Memory before query: 1.094 MB Rows returned: 39
```
SELECT folder AS type, element AS name, params

  FROM jossg_extensions

  WHERE enabled = 1 
  AND type ='plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering
```
Explain
EXPLAIN not possible on query: SELECT folder AS type, element AS name, params FROM jossg_extensions WHERE enabled = 1 AND type ='plugin' AND state IN (0,1) AND access IN (1,1,5) ORDER BY ordering
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/plugin/helper.php:310
JROOT/libraries/cms/plugin/helper.php:163
JROOT/libraries/cms/application/site.php:589
JROOT/libraries/cms/application/site.php:209
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.93 ms After last query: 13.15 ms Query memory: 0.024 MB Memory before query: 1.579 MB Rows returned: 4
```
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 jossg_menu AS m

  LEFT JOIN jossg_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
```
Explain
EXPLAIN not possible on query: 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 jossg_menu AS m LEFT JOIN jossg_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
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/menu/site.php:45
JROOT/libraries/cms/menu/menu.php:64
JROOT/libraries/cms/menu/menu.php:118
JROOT/libraries/cms/application/cms.php:424
JROOT/libraries/cms/application/site.php:272
JROOT/libraries/cms/router/site.php:57
JROOT/libraries/cms/router/router.php:196
JROOT/libraries/cms/application/cms.php:520
JROOT/libraries/cms/application/site.php:407
JROOT/libraries/cms/application/cms.php:1088
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.36 ms After last query: 2.90 ms Query memory: 0.024 MB Memory before query: 1.699 MB Rows returned: 1
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM jossg_extensions

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled FROM jossg_extensions WHERE `type` = 'library' AND `element` = 'joomla'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/cache/controller/callback.php:157
JROOT/libraries/cms/library/helper.php:156
JROOT/libraries/cms/library/helper.php:47
JROOT/libraries/cms/library/helper.php:90
JROOT/libraries/cms/version/version.php:189
JROOT/libraries/joomla/factory.php:736
JROOT/libraries/joomla/factory.php:216
JROOT/plugins/system/sef/sef.php:29
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.35 ms After last query: 0.21 ms Query memory: 0.017 MB Memory before query: 1.707 MB
```
UPDATE `jossg_extensions`

  SET `params` = '{\"mediaversion\":\"570f4f77ccfb11024d5afead26329235\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
EXPLAIN not possible on query: UPDATE `jossg_extensions` SET `params` = '{\"mediaversion\":\"570f4f77ccfb11024d5afead26329235\"}' WHERE `type` = 'library' AND `element` = 'joomla'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/library/helper.php:119
JROOT/libraries/cms/version/version.php:240
JROOT/libraries/cms/version/version.php:199
JROOT/libraries/joomla/factory.php:736
JROOT/libraries/joomla/factory.php:216
JROOT/plugins/system/sef/sef.php:29
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/libraries/joomla/application/base.php:106
JROOT/libraries/cms/application/cms.php:1098
JROOT/libraries/cms/application/site.php:763
JROOT/libraries/cms/application/site.php:215
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.77 ms After last query: 4.48 ms Query memory: 0.013 MB Memory before query: 1.833 MB Rows returned: 1
```
SELECT *

  FROM jossg_languages

  WHERE published=1

  ORDER BY ordering ASC
```
Explain
EXPLAIN not possible on query: SELECT * FROM jossg_languages WHERE published=1 ORDER BY ordering ASC
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/language/helper.php:164
JROOT/libraries/cms/application/site.php:329
JROOT/libraries/cms/application/site.php:135
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.73 ms After last query: 0.41 ms Query memory: 0.010 MB Memory before query: 1.853 MB Rows returned: 3
```
SELECT id, home, template, s.params

  FROM jossg_template_styles as s

  LEFT JOIN jossg_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
```
Explain
EXPLAIN not possible on query: SELECT id, home, template, s.params FROM jossg_template_styles as s LEFT JOIN jossg_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
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/site.php:484
JROOT/libraries/cms/application/site.php:165
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.80 ms After last query: 10.80 ms Query memory: 0.024 MB Memory before query: 2.080 MB Rows returned: 1
```
SELECT a.rules

  FROM jossg_assets AS a

  WHERE (a.id = 1)

  GROUP BY a.id, a.rules, a.lft
```
Explain
EXPLAIN not possible on query: SELECT a.rules FROM jossg_assets AS a WHERE (a.id = 1) GROUP BY a.id, a.rules, a.lft
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/user/user.php:384
JROOT/components/com_content/models/article.php:55
JROOT/libraries/legacy/model/legacy.php:439
JROOT/components/com_content/models/article.php:75
JROOT/libraries/legacy/view/legacy.php:401
JROOT/components/com_content/views/article/view.html.php:42
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.82 ms After last query: 1.18 ms Query memory: 0.025 MB Memory before query: 2.114 MB Rows returned: 2
```
SELECT b.rules

  FROM jossg_assets AS a

  LEFT JOIN jossg_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
```
Explain
EXPLAIN not possible on query: SELECT b.rules FROM jossg_assets AS a LEFT JOIN jossg_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
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/access/access.php:246
JROOT/libraries/joomla/access/access.php:107
JROOT/libraries/joomla/user/user.php:393
JROOT/components/com_content/models/article.php:55
JROOT/libraries/legacy/model/legacy.php:439
JROOT/components/com_content/models/article.php:75
JROOT/libraries/legacy/view/legacy.php:401
JROOT/components/com_content/views/article/view.html.php:42
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.96 ms After last query: 0.77 ms Query memory: 0.031 MB Memory before query: 2.153 MB Rows returned: 1
```
SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' 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.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,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 jossg_content AS a

  LEFT JOIN jossg_categories AS c 
  on c.id = a.catid

  LEFT JOIN jossg_users AS u 
  on u.id = a.created_by

  LEFT JOIN jossg_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN jossg_content_rating AS v 
  ON a.id = v.content_id

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM jossg_categories AS cat JOIN jossg_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 = 2 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-04 04:43:20') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-04 04:43:20') 
  AND (a.state = 1 OR a.state =2)
```
Explain
EXPLAIN not possible on query: SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, CASE WHEN a.modified = '0000-00-00 00:00:00' 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.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,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 jossg_content AS a LEFT JOIN jossg_categories AS c on c.id = a.catid LEFT JOIN jossg_users AS u on u.id = a.created_by LEFT JOIN jossg_categories as parent ON parent.id = c.parent_id LEFT JOIN jossg_content_rating AS v ON a.id = v.content_id LEFT OUTER JOIN (SELECT cat.id as id FROM jossg_categories AS cat JOIN jossg_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 = 2 AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-04 04:43:20') AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-04 04:43:20') AND (a.state = 1 OR a.state =2)
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_content/models/article.php:159
JROOT/libraries/legacy/view/legacy.php:401
JROOT/components/com_content/views/article/view.html.php:42
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.28 ms After last query: 4.43 ms Query memory: 0.027 MB Memory before query: 2.259 MB Rows returned: 2
```
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 jossg_categories as c

  LEFT JOIN jossg_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 jossg_categories AS cat JOIN jossg_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,5) 
  AND c.published = 1 
  AND s.id=2 
  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, c.version

  ORDER BY c.lft
```
Explain
EXPLAIN not possible on query: 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 jossg_categories as c LEFT JOIN jossg_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 jossg_categories AS cat JOIN jossg_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,5) AND c.published = 1 AND s.id=2 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, c.version ORDER BY c.lft
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/legacy/categories/categories.php:292
JROOT/libraries/legacy/categories/categories.php:184
JROOT/components/com_content/helpers/route.php:44
JROOT/components/com_content/views/article/view.html.php:71
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.09 ms After last query: 4.46 ms Query memory: 0.025 MB Memory before query: 2.346 MB Rows returned: 0
```
SELECT `m`.`tag_id`,`t`.*

  FROM `jossg_contentitem_tag_map` AS m 

  INNER JOIN `jossg_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 2 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)
```
Explain
EXPLAIN not possible on query: SELECT `m`.`tag_id`,`t`.* FROM `jossg_contentitem_tag_map` AS m INNER JOIN `jossg_tags` AS t ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = 'com_content.article' AND `m`.`content_item_id` = 2 AND `t`.`published` = 1 AND t.access IN (1,1,5)
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/helper/tags.php:426
JROOT/components/com_content/views/article/view.html.php:155
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.51 ms After last query: 41.81 ms Query memory: 0.030 MB Memory before query: 2.831 MB Rows returned: 1
```
SELECT id,template 
  FROM jossg_template_styles 
  WHERE client_id=0 
  AND home=1
```
Explain
EXPLAIN not possible on query: SELECT id,template FROM jossg_template_styles WHERE client_id=0 AND home=1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_widgetkit/widgetkit.php:23
JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Container.php:240
JROOT/administrator/components/com_widgetkit/src/Application.php:48
JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Event/EventDispatcher.php:113
JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Application.php:149
JROOT/administrator/components/com_widgetkit/widgetkit.php:67
JROOT/administrator/components/com_widgetkit/widgetkit-app.php:6
JROOT/plugins/content/widgetkit/widgetkit.php:9
JROOT/libraries/joomla/event/event.php:69
JROOT/libraries/joomla/event/dispatcher.php:160
JROOT/components/com_content/views/article/view.html.php:160
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.89 ms After last query: 18.47 ms Query memory: 0.028 MB Memory before query: 3.183 MB Rows returned: 30
```
SHOW FULL COLUMNS 
  FROM `jossg_content`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `jossg_content`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:241
JROOT/libraries/joomla/table/table.php:162
JROOT/libraries/legacy/table/content.php:31
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_content/models/article.php:264
JROOT/components/com_content/views/article/view.html.php:176
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.39 ms After last query: 2.64 ms Query memory: 0.026 MB Memory before query: 3.316 MB Rows returned: 1
```
SELECT *

  FROM jossg_content

  WHERE `id` = '2'
```
Explain
EXPLAIN not possible on query: SELECT * FROM jossg_content WHERE `id` = '2'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:728
JROOT/components/com_content/models/article.php:265
JROOT/components/com_content/views/article/view.html.php:176
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.36 ms After last query: 0.18 ms Query memory: 0.016 MB Memory before query: 3.334 MB
```
UPDATE jossg_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '2'
```
Explain
EXPLAIN not possible on query: UPDATE jossg_content SET `hits` = (`hits` + 1) WHERE `id` = '2'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:1239
JROOT/components/com_content/models/article.php:266
JROOT/components/com_content/views/article/view.html.php:176
JROOT/libraries/legacy/controller/legacy.php:690
JROOT/components/com_content/controller.php:104
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_content/content.php:38
JROOT/libraries/cms/component/helper.php:392
JROOT/libraries/cms/component/helper.php:372
JROOT/libraries/cms/application/site.php:191
JROOT/libraries/cms/application/site.php:230
JROOT/libraries/cms/application/cms.php:252
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 1.29 ms After last query: 24.13 ms Query memory: 0.025 MB Memory before query: 3.664 MB Rows returned: 12
```
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM jossg_modules AS m

  LEFT JOIN jossg_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN jossg_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 <= '2024-10-04 04:43:20') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-04 04:43:20') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 104 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering
```
Explain
EXPLAIN not possible on query: SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid FROM jossg_modules AS m LEFT JOIN jossg_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN jossg_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 <= '2024-10-04 04:43:20') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-10-04 04:43:20') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 104 OR mm.menuid <= 0) ORDER BY m.position, m.ordering
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/module/helper.php:407
JROOT/libraries/cms/module/helper.php:350
JROOT/libraries/cms/module/helper.php:84
JROOT/libraries/joomla/document/html/html.php:501
JROOT/templates/yoo_digit/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54
JROOT/templates/yoo_digit/layouts/theme.config.php:26
JROOT/templates/yoo_digit/layouts/theme.php:10
JROOT/templates/yoo_digit/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_digit/index.php:16
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.25 ms After last query: 24.80 ms Query memory: 0.025 MB Memory before query: 4.086 MB
```
CREATE TABLE IF NOT EXISTS `jossg_vcnt` (`tm` INT NOT NULL, `ip` VARCHAR(16) NOT NULL DEFAULT '0.0.0.0')
```
Explain
EXPLAIN not possible on query: CREATE TABLE IF NOT EXISTS `jossg_vcnt` (`tm` INT NOT NULL, `ip` VARCHAR(16) NOT NULL DEFAULT '0.0.0.0')
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/modules/mod_visitorcounter/helper.php:47
JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:60
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/templates/yoo_digit/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
JROOT/templates/yoo_digit/warp/systems/joomla/layouts/widgets.php:10
JROOT/templates/yoo_digit/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_digit/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
JROOT/templates/yoo_digit/layouts/theme.php:191
JROOT/templates/yoo_digit/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_digit/index.php:16
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.15 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 4.111 MB
```
CREATE TABLE IF NOT EXISTS `jossg_vcnt_pc` (`cnt` INT NOT NULL DEFAULT '0')
```
Explain
EXPLAIN not possible on query: CREATE TABLE IF NOT EXISTS `jossg_vcnt_pc` (`cnt` INT NOT NULL DEFAULT '0')
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/modules/mod_visitorcounter/helper.php:53
JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:60
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/templates/yoo_digit/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
JROOT/templates/yoo_digit/warp/systems/joomla/layouts/widgets.php:10
JROOT/templates/yoo_digit/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_digit/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
JROOT/templates/yoo_digit/layouts/theme.php:191
JROOT/templates/yoo_digit/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_digit/index.php:16
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.56 ms After last query: 0.04 ms Query memory: 0.026 MB Memory before query: 4.136 MB Rows returned: 1
```
SELECT count(*) 
  FROM `jossg_vcnt_pc`
```
Explain
EXPLAIN not possible on query: SELECT count(*) FROM `jossg_vcnt_pc`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/modules/mod_visitorcounter/helper.php:57
JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:60
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/templates/yoo_digit/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
JROOT/templates/yoo_digit/warp/systems/joomla/layouts/widgets.php:10
JROOT/templates/yoo_digit/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_digit/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
JROOT/templates/yoo_digit/layouts/theme.php:191
JROOT/templates/yoo_digit/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_digit/index.php:16
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.58 ms After last query: 0.10 ms Query memory: 0.026 MB Memory before query: 4.163 MB Rows returned: 1
```
SELECT count(*) 
  FROM `jossg_vcnt` 
  WHERE `ip` = '35.171.164.77' 
  AND (`tm` + '86400') > '1728017000'
```
Explain
EXPLAIN not possible on query: SELECT count(*) FROM `jossg_vcnt` WHERE `ip` = '35.171.164.77' AND (`tm` + '86400') > '1728017000'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/modules/mod_visitorcounter/helper.php:142
JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:63
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/templates/yoo_digit/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
JROOT/templates/yoo_digit/warp/systems/joomla/layouts/widgets.php:10
JROOT/templates/yoo_digit/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_digit/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
JROOT/templates/yoo_digit/layouts/theme.php:191
JROOT/templates/yoo_digit/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_digit/index.php:16
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.29 ms After last query: 0.07 ms Query memory: 0.026 MB Memory before query: 4.186 MB Rows returned: 1
```
SELECT count(*) 
  FROM `jossg_vcnt` 
  WHERE `tm` < '1727049600'
```
Explain
EXPLAIN not possible on query: SELECT count(*) FROM `jossg_vcnt` WHERE `tm` < '1727049600'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/modules/mod_visitorcounter/helper.php:237
JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:67
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/templates/yoo_digit/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
JROOT/templates/yoo_digit/warp/systems/joomla/layouts/widgets.php:10
JROOT/templates/yoo_digit/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_digit/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
JROOT/templates/yoo_digit/layouts/theme.php:191
JROOT/templates/yoo_digit/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_digit/index.php:16
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.35 ms After last query: 0.06 ms Query memory: 0.026 MB Memory before query: 4.212 MB Rows returned: 2
```
SELECT `guest`, `client_id` , `username`, `userid` 
  FROM `jossg_session` 
  WHERE `client_id` = 0 
  AND `time` > '1728016400'
```
Explain
EXPLAIN not possible on query: SELECT `guest`, `client_id` , `username`, `userid` FROM `jossg_session` WHERE `client_id` = 0 AND `time` > '1728016400'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/modules/mod_visitorcounter/helper.php:267
JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:72
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/templates/yoo_digit/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
JROOT/templates/yoo_digit/warp/systems/joomla/layouts/widgets.php:10
JROOT/templates/yoo_digit/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_digit/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
JROOT/templates/yoo_digit/layouts/theme.php:191
JROOT/templates/yoo_digit/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_digit/index.php:16
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]
Query Time: 0.80 ms After last query: 0.15 ms Query memory: 0.026 MB Memory before query: 4.240 MB Rows returned: 6
```
SELECT count(*) 
  FROM `jossg_vcnt` UNION ALL SELECT count(*) 
  FROM `jossg_vcnt` 
  WHERE `tm` > '1728000000' UNION ALL SELECT count(*) 
  FROM `jossg_vcnt` 
  WHERE `tm` > '1727913600' 
  AND `tm` < '1728000000' UNION ALL SELECT count(*) 
  FROM `jossg_vcnt` 
  WHERE `tm` >= '1727654400' UNION ALL SELECT count(*) 
  FROM `jossg_vcnt` 
  WHERE `tm` >= '1727740800' UNION ALL SELECT `cnt` 
  FROM `jossg_vcnt_pc`
```
Explain
EXPLAIN not possible on query: SELECT count(*) FROM `jossg_vcnt` UNION ALL SELECT count(*) FROM `jossg_vcnt` WHERE `tm` > '1728000000' UNION ALL SELECT count(*) FROM `jossg_vcnt` WHERE `tm` > '1727913600' AND `tm` < '1728000000' UNION ALL SELECT count(*) FROM `jossg_vcnt` WHERE `tm` >= '1727654400' UNION ALL SELECT count(*) FROM `jossg_vcnt` WHERE `tm` >= '1727740800' UNION ALL SELECT `cnt` FROM `jossg_vcnt_pc`
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/modules/mod_visitorcounter/helper.php:194
JROOT/modules/mod_visitorcounter/mod_visitorcounter.php:84
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/templates/yoo_digit/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
JROOT/templates/yoo_digit/warp/systems/joomla/layouts/widgets.php:10
JROOT/templates/yoo_digit/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_digit/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
JROOT/templates/yoo_digit/layouts/theme.php:191
JROOT/templates/yoo_digit/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_digit/index.php:16
JROOT/libraries/joomla/document/html/html.php:578
JROOT/libraries/joomla/document/html/html.php:635
JROOT/libraries/joomla/document/html/html.php:455
JROOT/libraries/cms/application/cms.php:1045
JROOT/libraries/cms/application/site.php:745
JROOT/libraries/cms/application/cms.php:258
JROOT/index.php:45
[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

2 × SELECT count(*) 
  FROM `jossg_vcnt`

2 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM jossg_extensions

1 × SELECT id,template 
  FROM jossg_template_styles

1 × 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 jossg_categories as c 
  LEFT JOIN jossg_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 jossg_categories AS cat JOIN jossg_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `jossg_contentitem_tag_map` AS m  
  INNER JOIN `jossg_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

```
1 × SELECT * 
  FROM jossg_content
```

1 × SELECT count(*) 
  FROM `jossg_vcnt_pc

1 × SELECT count(*) 
  FROM `jossg_vcnt` UNION ALL SELECT count(*) 
  FROM `jossg_vcnt`

1 × SELECT `guest`, `client_id` , `username`, `userid` 
  FROM `jossg_session`

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' 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.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,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 jossg_content AS a 
  LEFT JOIN jossg_categories AS c 
  on c.id = a.catid 
  LEFT JOIN jossg_users AS u 
  on u.id = a.created_by 
  LEFT JOIN jossg_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN jossg_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM jossg_categories AS cat JOIN jossg_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM jossg_modules AS m 
  LEFT JOIN jossg_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN jossg_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT b.rules 
  FROM jossg_assets AS a 
  LEFT JOIN jossg_assets AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT id, rules 
  FROM `jossg_viewlevels

1 × SELECT b.id 
  FROM jossg_usergroups AS a 
  LEFT JOIN jossg_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT `session_id` 
  FROM `jossg_session`

1 × SELECT folder AS type, element AS name, params 
  FROM jossg_extensions

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 jossg_menu AS m 
  LEFT JOIN jossg_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT a.rules 
  FROM jossg_assets AS a

1 × SELECT id, home, template, s.params 
  FROM jossg_template_styles as s 
  LEFT JOIN jossg_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

```
1 × SELECT * 
  FROM jossg_languages
```

1 × SELECT `data` 
  FROM `jossg_session`

OTHER Tables:

1 × CREATE TABLE IF NOT EXISTS `jossg_vcnt` (`tm` INT NOT NULL, `ip` VARCHAR(16) NOT NULL DEFAULT '0.0.0.0'

1 × CREATE TABLE IF NOT EXISTS `jossg_vcnt_pc` (`cnt` INT NOT NULL DEFAULT '0'

1 × UPDATE jossg_content 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `jossg_content

1 × UPDATE `jossg_extensions` 
  SET `params` = '{\"mediaversion\":\"570f4f77ccfb11024d5afead26329235\"}'

1 × INSERT INTO `jossg_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('u7oc5vtosnqaqvfnqm04vl83l6', 0, '1728017000'

About Us

From Tea Lady to Business Owner

Tel: 012 700 0047 Fax: 086 403 5716 Email: info@nyembewaste.co.za

Joomla! Debug Console

Session

Profile Information