Por Mathías Gonnet

Feb 21, 2020

LUB

Urunday Universitario fue sancionado con la quita de dos puntos y cinco cierres de cancha en un fallo que responde a los incidentes ocurridos con su parcialidad en el juego ante Defensor Sporting.

La sanción, al establecerse antes del inicio del Reclasificatorio, tendrá en la práctica la pérdida de una sola unidad para el equipo de Da Prá, ya que el puntaje para este tramo del campeonato se reduce a la mitad de lo obtenido hasta el momento. De esta forma, las posiciones para la etapa que dará comienzo el próximo 27 de febrero, quedaron de esta manera:

RECLASIFICACIÓN

Goes 18

Urunday 17.5

Aguada 17

Biguá 17

Capitol 15.5

Sayago 13.5

Etiquetado como

urunday,

Más en esta categoría: « Último intento Cambio obligado »

Mathías Gonnet

Twitter: @GonnetMathias

56 Queries Logged 79.1 ms

15 duplicate found!

4 duplicates: #7 #8 #49 #50

3 duplicates: #14 #21 #22

2 duplicates: #35 #36

2 duplicates: #40 #41

2 duplicates: #42 #43

2 duplicates: #54 #55

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

  FROM `u2tdi_session`

  WHERE `session_id` = 'kcvccd1u3eo95jr7ehkt6o5373'
```
Explain
EXPLAIN not possible on query: SELECT `data` FROM `u2tdi_session` WHERE `session_id` = 'kcvccd1u3eo95jr7ehkt6o5373'
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:665
JROOT/libraries/joomla/session/session.php:603
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: 1.02 ms After last query: 1.19 ms Query memory: 0.008 MB Memory before query: 0.879 MB
```
DELETE 

  FROM `u2tdi_session`

  WHERE `time` < '1695958175'
```
Explain
EXPLAIN not possible on query: DELETE FROM `u2tdi_session` WHERE `time` < '1695958175'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/application/cms.php:756
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: 1.06 ms After last query: 0.14 ms Query memory: 0.012 MB Memory before query: 0.891 MB Rows returned: 0
```
SELECT `session_id`

  FROM `u2tdi_session`

  WHERE `session_id` = 'kcvccd1u3eo95jr7ehkt6o5373' 
  LIMIT 0, 1
```
Explain
EXPLAIN not possible on query: SELECT `session_id` FROM `u2tdi_session` WHERE `session_id` = 'kcvccd1u3eo95jr7ehkt6o5373' 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.82 ms After last query: 0.16 ms Query memory: 0.009 MB Memory before query: 0.903 MB
```
INSERT INTO `u2tdi_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('kcvccd1u3eo95jr7ehkt6o5373', 0, '1695960575')
```
Explain
EXPLAIN not possible on query: INSERT INTO `u2tdi_session` (`session_id`, `client_id`, `time`) VALUES ('kcvccd1u3eo95jr7ehkt6o5373', 0, '1695960575')
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.29 ms After last query: 1.96 ms Query memory: 0.014 MB Memory before query: 1.047 MB Rows returned: 1
```
SELECT b.id

  FROM u2tdi_usergroups AS a

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

  WHERE a.id = 1
```
Explain
EXPLAIN not possible on query: SELECT b.id FROM u2tdi_usergroups AS a LEFT JOIN u2tdi_usergroups AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE a.id = 1
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.24 ms After last query: 0.18 ms Query memory: 0.013 MB Memory before query: 1.066 MB Rows returned: 4
```
SELECT id, rules

  FROM `u2tdi_viewlevels`
```
Explain
EXPLAIN not possible on query: SELECT id, rules FROM `u2tdi_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.24 ms After last query: 1.57 ms Query memory: 0.013 MB Memory before query: 1.267 MB Rows returned: 6
Duplicate queries: #8 #49 #50
```
SELECT a.element AS element

  FROM u2tdi_extensions AS a

  WHERE a.type = 'language' 
  AND a.client_id = 0 
  AND a.enabled = 1
```
Explain
EXPLAIN not possible on query: SELECT a.element AS element FROM u2tdi_extensions AS a WHERE a.type = 'language' AND a.client_id = 0 AND a.enabled = 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_languages/helpers/multilangstatus.php:94
JROOT/plugins/system/languagefilter/languagefilter.php:73
JROOT/libraries/cms/plugin/helper.php:255
JROOT/libraries/cms/plugin/helper.php:170
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.22 ms After last query: 0.13 ms Query memory: 0.013 MB Memory before query: 1.279 MB Rows returned: 6
Duplicate queries: #7 #49 #50
```
SELECT a.element AS element

  FROM u2tdi_extensions AS a

  WHERE a.type = 'language' 
  AND a.client_id = 0 
  AND a.enabled = 1
```
Explain
EXPLAIN not possible on query: SELECT a.element AS element FROM u2tdi_extensions AS a WHERE a.type = 'language' AND a.client_id = 0 AND a.enabled = 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_languages/helpers/multilangstatus.php:94
JROOT/plugins/system/languagefilter/languagefilter.php:73
JROOT/libraries/cms/plugin/helper.php:255
JROOT/libraries/cms/plugin/helper.php:170
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: 4.17 ms After last query: 10.92 ms Query memory: 0.036 MB Memory before query: 1.813 MB Rows returned: 32
```
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 u2tdi_menu AS m

  LEFT JOIN u2tdi_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 u2tdi_menu AS m LEFT JOIN u2tdi_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/plugins/system/languagefilter/languagefilter.php:100
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:654
JROOT/libraries/cms/application/site.php:663
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.81 ms After last query: 3.71 ms Query memory: 0.015 MB Memory before query: 2.274 MB Rows returned: 1
```
SELECT count(1)

  FROM `u2tdi_session`

  WHERE `session_id` = '' 
  AND client_id = 1 
  AND guest = 0
```
Explain
EXPLAIN not possible on query: SELECT count(1) FROM `u2tdi_session` WHERE `session_id` = '' AND client_id = 1 AND guest = 0
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/arktypography/arktypography.php:56
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:654
JROOT/libraries/cms/application/site.php:663
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: 1.13 ms After last query: 7.04 ms Query memory: 0.022 MB Memory before query: 2.799 MB
```
UPDATE `u2tdi_extensions`

  SET `params` = '{\"mediaversion\":\"9b7a0e3a6d1c1284b7e2c2eb72d4fffe\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
Explain
EXPLAIN not possible on query: UPDATE `u2tdi_extensions` SET `params` = '{\"mediaversion\":\"9b7a0e3a6d1c1284b7e2c2eb72d4fffe\"}' 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/libraries/cms/html/behavior.php:349
JROOT/libraries/cms/html/html.php:236
JROOT/libraries/cms/html/html.php:138
JROOT/plugins/system/k2/k2.php:47
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: 1.00 ms After last query: 3.22 ms Query memory: 0.016 MB Memory before query: 2.982 MB Rows returned: 1
```
SELECT COUNT(extension_id)

  FROM u2tdi_extensions

  WHERE element = 'com_arkeditor' 
  AND type = 'component'
```
Explain
EXPLAIN not possible on query: SELECT COUNT(extension_id) FROM u2tdi_extensions WHERE element = 'com_arkeditor' AND type = 'component'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/cms/component/helper.php:104
JROOT/plugins/system/inlinecontent/inlinecontent.php:53
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.28 ms After last query: 0.29 ms Query memory: 0.016 MB Memory before query: 2.999 MB Rows returned: 0
```
SELECT element,views,context,types,params

  FROM u2tdi_ark_editor_inline_views

  WHERE element = 'com_k2' 
  LIMIT 0, 1
```
Explain
EXPLAIN not possible on query: SELECT element,views,context,types,params FROM u2tdi_ark_editor_inline_views WHERE element = 'com_k2' LIMIT 0, 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/inlinecontent/inlinecontent.php:112
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: 1.40 ms After last query: 6.42 ms Query memory: 0.024 MB Memory before query: 3.418 MB Rows returned: 1
Duplicate queries: #21 #22
```
SELECT items.id, categories.id AS catid, 
  CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug 
		
  FROM u2tdi_k2_items AS items 
		
  INNER JOIN u2tdi_k2_categories AS categories 
  ON items.catid = categories.id 
		
  WHERE items.id = 4789
```
Explain
EXPLAIN not possible on query: SELECT items.id, categories.id AS catid, CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug FROM u2tdi_k2_items AS items INNER JOIN u2tdi_k2_categories AS categories ON items.catid = categories.id WHERE items.id = 4789
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/router.php:444
JROOT/components/com_k2/router.php:151
JROOT/libraries/cms/component/router/legacy.php:68
JROOT/libraries/cms/router/site.php:483
JROOT/libraries/cms/router/site.php:452
JROOT/libraries/cms/router/router.php:280
JROOT/libraries/cms/router/site.php:134
JROOT/libraries/joomla/application/route.php:62
JROOT/plugins/system/sef/sef.php:46
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.34 ms After last query: 2.41 ms Query memory: 0.014 MB Memory before query: 3.552 MB Rows returned: 1
```
SELECT a.rules

  FROM u2tdi_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 u2tdi_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_k2/k2.php:16
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.34 ms After last query: 0.49 ms Query memory: 0.016 MB Memory before query: 3.575 MB Rows returned: 2
```
SELECT b.rules

  FROM u2tdi_assets AS a

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

  WHERE (a.name = 'com_k2')

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft
```
Explain
EXPLAIN not possible on query: SELECT b.rules FROM u2tdi_assets AS a LEFT JOIN u2tdi_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt WHERE (a.name = 'com_k2') 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_k2/k2.php:16
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.28 ms After last query: 3.41 ms Query memory: 0.020 MB Memory before query: 3.839 MB Rows returned: 9
```
SELECT id 
  FROM u2tdi_k2_categories 
  WHERE published=1 
  AND trash=0 
  AND access IN(1,1)
```
Explain
EXPLAIN not possible on query: SELECT id FROM u2tdi_k2_categories WHERE published=1 AND trash=0 AND access IN(1,1)
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/helpers/permissions.php:261
JROOT/components/com_k2/views/item/view.html.php:36
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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.14 ms After last query: 0.23 ms Query memory: 0.031 MB Memory before query: 3.859 MB Rows returned: 1
```
SELECT * 
  FROM u2tdi_k2_items 
  WHERE id=4789 
  AND language IN ('en-GB','*') 
  LIMIT 0, 1
```
Explain
EXPLAIN not possible on query: SELECT * FROM u2tdi_k2_items WHERE id=4789 AND language IN ('en-GB','*') LIMIT 0, 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:36
JROOT/components/com_k2/views/item/view.html.php:42
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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.85 ms After last query: 0.44 ms Query memory: 0.029 MB Memory before query: 3.943 MB Rows returned: 14
```
SHOW FULL COLUMNS 
  FROM `u2tdi_k2_categories`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `u2tdi_k2_categories`
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/administrator/components/com_k2/tables/k2category.php:34
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_k2/models/item.php:74
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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.50 ms After last query: 0.77 ms Query memory: 0.024 MB Memory before query: 4.002 MB Rows returned: 1
```
SELECT * 
  FROM u2tdi_k2_categories 
  WHERE id = '78'
```
Explain
EXPLAIN not possible on query: SELECT * FROM u2tdi_k2_categories WHERE id = '78'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_k2/tables/k2category.php:65
JROOT/components/com_k2/models/item.php:75
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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.38 ms After last query: 1.36 ms Query memory: 0.029 MB Memory before query: 4.069 MB Rows returned: 1
Duplicate queries: #14 #22
```
SELECT items.id, categories.id AS catid, 
  CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug 
		
  FROM u2tdi_k2_items AS items 
		
  INNER JOIN u2tdi_k2_categories AS categories 
  ON items.catid = categories.id 
		
  WHERE items.id = 4789
```
Explain
EXPLAIN not possible on query: SELECT items.id, categories.id AS catid, CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug FROM u2tdi_k2_items AS items INNER JOIN u2tdi_k2_categories AS categories ON items.catid = categories.id WHERE items.id = 4789
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/router.php:444
JROOT/components/com_k2/router.php:151
JROOT/libraries/cms/component/router/legacy.php:68
JROOT/libraries/cms/router/site.php:483
JROOT/libraries/cms/router/site.php:452
JROOT/libraries/cms/router/router.php:280
JROOT/libraries/cms/router/site.php:134
JROOT/libraries/joomla/application/route.php:62
JROOT/components/com_k2/models/item.php:82
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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.26 ms After last query: 0.39 ms Query memory: 0.029 MB Memory before query: 4.099 MB Rows returned: 1
Duplicate queries: #14 #21
```
SELECT items.id, categories.id AS catid, 
  CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug 
		
  FROM u2tdi_k2_items AS items 
		
  INNER JOIN u2tdi_k2_categories AS categories 
  ON items.catid = categories.id 
		
  WHERE items.id = 4789
```
Explain
EXPLAIN not possible on query: SELECT items.id, categories.id AS catid, CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug FROM u2tdi_k2_items AS items INNER JOIN u2tdi_k2_categories AS categories ON items.catid = categories.id WHERE items.id = 4789
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/router.php:444
JROOT/components/com_k2/router.php:151
JROOT/libraries/cms/component/router/legacy.php:68
JROOT/libraries/cms/router/site.php:483
JROOT/libraries/cms/router/site.php:452
JROOT/libraries/cms/router/router.php:280
JROOT/libraries/cms/router/site.php:134
JROOT/libraries/joomla/application/route.php:62
JROOT/components/com_k2/models/item.php:85
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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.35 ms After last query: 1.21 ms Query memory: 0.022 MB Memory before query: 4.211 MB Rows returned: 1
```
SELECT tag.*
		
  FROM u2tdi_k2_tags AS tag
		JOIN u2tdi_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
		
  WHERE tag.published=1
		
  AND xref.itemID = 4789 
  ORDER BY xref.id ASC
```
Explain
EXPLAIN not possible on query: SELECT tag.* FROM u2tdi_k2_tags AS tag JOIN u2tdi_k2_tags_xref AS xref ON tag.id = xref.tagID WHERE tag.published=1 AND xref.itemID = 4789 ORDER BY xref.id ASC
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:1353
JROOT/components/com_k2/models/item.php:109
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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.72 ms After last query: 1.01 ms Query memory: 0.022 MB Memory before query: 4.245 MB Rows returned: 0
```
SELECT * 
  FROM u2tdi_k2_attachments 
  WHERE itemID=4789
```
Explain
EXPLAIN not possible on query: SELECT * FROM u2tdi_k2_attachments WHERE itemID=4789
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:1642
JROOT/components/com_k2/models/item.php:190
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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: 2.01 ms After last query: 0.37 ms Query memory: 0.035 MB Memory before query: 4.292 MB Rows returned: 16
```
SHOW FULL COLUMNS 
  FROM `u2tdi_users`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `u2tdi_users`
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/joomla/table/user.php:38
JROOT/libraries/joomla/table/table.php:305
JROOT/libraries/joomla/user/user.php:582
JROOT/libraries/joomla/user/user.php:866
JROOT/libraries/joomla/user/user.php:242
JROOT/libraries/joomla/user/user.php:295
JROOT/libraries/joomla/factory.php:248
JROOT/components/com_k2/models/item.php:247
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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.41 ms After last query: 0.49 ms Query memory: 0.029 MB Memory before query: 4.360 MB Rows returned: 1
```
SELECT *

  FROM `u2tdi_users`

  WHERE `id` = 900
```
Explain
EXPLAIN not possible on query: SELECT * FROM `u2tdi_users` WHERE `id` = 900
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/user.php:84
JROOT/libraries/joomla/user/user.php:869
JROOT/libraries/joomla/user/user.php:242
JROOT/libraries/joomla/user/user.php:295
JROOT/libraries/joomla/factory.php:248
JROOT/components/com_k2/models/item.php:247
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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.27 ms After last query: 2.10 ms Query memory: 0.026 MB Memory before query: 5.121 MB Rows returned: 1
```
SELECT `g`.`id`,`g`.`title`

  FROM `u2tdi_usergroups` AS g

  INNER JOIN `u2tdi_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 900
```
Explain
EXPLAIN not possible on query: SELECT `g`.`id`,`g`.`title` FROM `u2tdi_usergroups` AS g INNER JOIN `u2tdi_user_usergroup_map` AS m ON m.group_id = g.id WHERE `m`.`user_id` = 900
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/user.php:109
JROOT/libraries/joomla/user/user.php:869
JROOT/libraries/joomla/user/user.php:242
JROOT/libraries/joomla/user/user.php:295
JROOT/libraries/joomla/factory.php:248
JROOT/components/com_k2/models/item.php:247
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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.23 ms After last query: 2.93 ms Query memory: 0.023 MB Memory before query: 5.143 MB Rows returned: 1
```
SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM u2tdi_k2_users 
  WHERE userID=900
```
Explain
EXPLAIN not possible on query: SELECT id, gender, description, image, url, `group`, plugins FROM u2tdi_k2_users WHERE userID=900
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:1811
JROOT/components/com_k2/models/item.php:250
JROOT/components/com_k2/views/item/view.html.php:51
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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.90 ms After last query: 8.91 ms Query memory: 0.031 MB Memory before query: 5.400 MB Rows returned: 36
```
SHOW FULL COLUMNS 
  FROM `u2tdi_k2_items`
```
Explain
EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `u2tdi_k2_items`
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/administrator/components/com_k2/tables/k2item.php:56
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_k2/models/item.php:895
JROOT/components/com_k2/views/item/view.html.php:135
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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.15 ms After last query: 0.43 ms Query memory: 0.018 MB Memory before query: 5.496 MB
```
UPDATE u2tdi_k2_items

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

  WHERE `id` = '4789'
```
Explain
EXPLAIN not possible on query: UPDATE u2tdi_k2_items SET `hits` = (`hits` + 1) WHERE `id` = '4789'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/table.php:1239
JROOT/components/com_k2/models/item.php:896
JROOT/components/com_k2/views/item/view.html.php:135
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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.87 ms After last query: 0.26 ms Query memory: 0.022 MB Memory before query: 5.514 MB Rows returned: 0
```
SELECT * 
  FROM u2tdi_k2_comments 
  WHERE itemID=4789 
  AND published=1  
  ORDER BY commentDate DESC 
  LIMIT 0, 10
```
Explain
EXPLAIN not possible on query: SELECT * FROM u2tdi_k2_comments WHERE itemID=4789 AND published=1 ORDER BY commentDate DESC LIMIT 0, 10
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:1666
JROOT/components/com_k2/views/item/view.html.php:231
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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: 3.02 ms After last query: 0.22 ms Query memory: 0.025 MB Memory before query: 5.534 MB Rows returned: 297
```
SELECT DISTINCT itemID 
  FROM u2tdi_k2_tags_xref 
  WHERE tagID IN (46) 
  AND itemID!=4789
```
Explain
EXPLAIN not possible on query: SELECT DISTINCT itemID FROM u2tdi_k2_tags_xref WHERE tagID IN (46) AND itemID!=4789
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/itemlist.php:921
JROOT/components/com_k2/views/item/view.html.php:286
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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: 29.12 ms After last query: 0.43 ms Query memory: 0.029 MB Memory before query: 5.611 MB Rows returned: 3
```
SELECT i.*, c.alias as categoryalias 
  FROM u2tdi_k2_items as i 
				
  LEFT JOIN u2tdi_k2_categories c 
  ON c.id = i.catid 
				
  WHERE i.published = 1 
				
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2023-09-29 04:09:35' ) 
				
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-09-29 04:09:35' )  
  AND i.access IN(1,1)  
  AND i.language IN('en-GB', '*') 
  AND i.trash = 0 
				
  AND c.published = 1  
  AND c.access IN(1,1)  
  AND c.language IN('en-GB', '*') 
  AND c.trash = 0 
				
  AND (i.id) IN (264,260,280,290,301,310,323,330,332,336,341,371,376,434,442,455,490,503,513,521,527,540,546,560,581,586,616,621,647,653,679,701,707,712,716,720,725,730,736,743,754,826,828,840,844,887,892,903,904,907,908,911,935,938,947,949,1065,1232,1284,1610,1624,1627,1639,1647,1669,1699,1702,1721,1733,1740,1758,1791,1843,1864,1873,1880,1897,1913,1922,1945,1959,1964,1979,1996,2061,2077,2113,2133,2146,2152,2153,2173,2181,2197,2199,2212,2220,2238,2251,2445,2526,2564,2744,2745,2802,2843,2906,2921,2932,2935,2946,2973,2992,3011,3037,3065,3125,3136,3155,3169,3182,3216,3226,3231,3246,3263,3280,3295,3323,3358,3368,3378,3456,3460,3473,3489,3501,3525,3536,3541,3554,3571,3594,3600,3612,3616,3622,3624,3626,3644,3645,3653,3655,3674,3675,3748,3845,3896,3990,4297,4313,4353,4373,4375,4380,4385,4403,4432,4442,4461,4492,4508,4514,4524,4525,4536,4547,4560,4627,4641,4654,4671,4682,4691,4708,4730,4743,4759,4810,4826,4837,4851,4900,5039,5191,5222,5242,5261,5298,5318,5320,5331,5347,5351,5367,5369,5378,5384,5402,5423,5479,5496,5532,5534,5542,5563,5615,5623,5639,5649,5660,5671,5683,5695,5738,5747,5840,5844,5852,5861,5868,5873,5876,5960,5972,6026,6053,6127,6142,6216,6261,6273,6288,6316,6361,6365,6374,6385,6393,6404,6424,6446,6457,6478,6479,6487,6507,6519,6523,6556,6564,6574,6589,6596,6616,6620,6633,6643,6664,6677,6687,6696,6788,6793,6836,6951,7019,7052,7127,7146,7155,7159,7177,7192,7200,7204,7215,7217,7228,7233,7249,7261,7269,7270,7277,7283,7310) 
				
  ORDER BY i.created DESC 
  LIMIT 0, 3
```
Explain
EXPLAIN not possible on query: SELECT i.*, c.alias as categoryalias FROM u2tdi_k2_items as i LEFT JOIN u2tdi_k2_categories c ON c.id = i.catid WHERE i.published = 1 AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2023-09-29 04:09:35' ) AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2023-09-29 04:09:35' ) AND i.access IN(1,1) AND i.language IN('en-GB', '*') AND i.trash = 0 AND c.published = 1 AND c.access IN(1,1) AND c.language IN('en-GB', '*') AND c.trash = 0 AND (i.id) IN (264,260,280,290,301,310,323,330,332,336,341,371,376,434,442,455,490,503,513,521,527,540,546,560,581,586,616,621,647,653,679,701,707,712,716,720,725,730,736,743,754,826,828,840,844,887,892,903,904,907,908,911,935,938,947,949,1065,1232,1284,1610,1624,1627,1639,1647,1669,1699,1702,1721,1733,1740,1758,1791,1843,1864,1873,1880,1897,1913,1922,1945,1959,1964,1979,1996,2061,2077,2113,2133,2146,2152,2153,2173,2181,2197,2199,2212,2220,2238,2251,2445,2526,2564,2744,2745,2802,2843,2906,2921,2932,2935,2946,2973,2992,3011,3037,3065,3125,3136,3155,3169,3182,3216,3226,3231,3246,3263,3280,3295,3323,3358,3368,3378,3456,3460,3473,3489,3501,3525,3536,3541,3554,3571,3594,3600,3612,3616,3622,3624,3626,3644,3645,3653,3655,3674,3675,3748,3845,3896,3990,4297,4313,4353,4373,4375,4380,4385,4403,4432,4442,4461,4492,4508,4514,4524,4525,4536,4547,4560,4627,4641,4654,4671,4682,4691,4708,4730,4743,4759,4810,4826,4837,4851,4900,5039,5191,5222,5242,5261,5298,5318,5320,5331,5347,5351,5367,5369,5378,5384,5402,5423,5479,5496,5532,5534,5542,5563,5615,5623,5639,5649,5660,5671,5683,5695,5738,5747,5840,5844,5852,5861,5868,5873,5876,5960,5972,6026,6053,6127,6142,6216,6261,6273,6288,6316,6361,6365,6374,6385,6393,6404,6424,6446,6457,6478,6479,6487,6507,6519,6523,6556,6564,6574,6589,6596,6616,6620,6633,6643,6664,6677,6687,6696,6788,6793,6836,6951,7019,7052,7127,7146,7155,7159,7177,7192,7200,7204,7215,7217,7228,7233,7249,7261,7269,7270,7277,7283,7310) ORDER BY i.created DESC LIMIT 0, 3
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/itemlist.php:969
JROOT/components/com_k2/views/item/view.html.php:286
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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.48 ms Query memory: 0.026 MB Memory before query: 5.663 MB Rows returned: 1
```
SELECT * 
  FROM u2tdi_k2_categories 
  WHERE id = '99'
```
Explain
EXPLAIN not possible on query: SELECT * FROM u2tdi_k2_categories WHERE id = '99'
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_k2/tables/k2category.php:65
JROOT/components/com_k2/models/item.php:75
JROOT/components/com_k2/models/itemlist.php:982
JROOT/components/com_k2/views/item/view.html.php:286
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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.97 ms After last query: 0.99 ms Query memory: 0.030 MB Memory before query: 5.698 MB Rows returned: 1
Duplicate queries: #36
```
SELECT items.id, categories.id AS catid, 
  CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug 
		
  FROM u2tdi_k2_items AS items 
		
  INNER JOIN u2tdi_k2_categories AS categories 
  ON items.catid = categories.id 
		
  WHERE items.id = 7310
```
Explain
EXPLAIN not possible on query: SELECT items.id, categories.id AS catid, CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug FROM u2tdi_k2_items AS items INNER JOIN u2tdi_k2_categories AS categories ON items.catid = categories.id WHERE items.id = 7310
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/router.php:444
JROOT/components/com_k2/router.php:151
JROOT/libraries/cms/component/router/legacy.php:68
JROOT/libraries/cms/router/site.php:483
JROOT/libraries/cms/router/site.php:452
JROOT/libraries/cms/router/router.php:280
JROOT/libraries/cms/router/site.php:134
JROOT/libraries/joomla/application/route.php:62
JROOT/components/com_k2/models/item.php:82
JROOT/components/com_k2/models/itemlist.php:982
JROOT/components/com_k2/views/item/view.html.php:286
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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.29 ms After last query: 0.35 ms Query memory: 0.030 MB Memory before query: 5.729 MB Rows returned: 1
Duplicate queries: #35
```
SELECT items.id, categories.id AS catid, 
  CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug 
		
  FROM u2tdi_k2_items AS items 
		
  INNER JOIN u2tdi_k2_categories AS categories 
  ON items.catid = categories.id 
		
  WHERE items.id = 7310
```
Explain
EXPLAIN not possible on query: SELECT items.id, categories.id AS catid, CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug FROM u2tdi_k2_items AS items INNER JOIN u2tdi_k2_categories AS categories ON items.catid = categories.id WHERE items.id = 7310
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/router.php:444
JROOT/components/com_k2/router.php:151
JROOT/libraries/cms/component/router/legacy.php:68
JROOT/libraries/cms/router/site.php:483
JROOT/libraries/cms/router/site.php:452
JROOT/libraries/cms/router/router.php:280
JROOT/libraries/cms/router/site.php:134
JROOT/libraries/joomla/application/route.php:62
JROOT/components/com_k2/models/item.php:85
JROOT/components/com_k2/models/itemlist.php:982
JROOT/components/com_k2/views/item/view.html.php:286
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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.28 ms After last query: 2.01 ms Query memory: 0.031 MB Memory before query: 5.855 MB Rows returned: 1
```
SELECT *

  FROM `u2tdi_users`

  WHERE `id` = 903
```
Explain
EXPLAIN not possible on query: SELECT * FROM `u2tdi_users` WHERE `id` = 903
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/user.php:84
JROOT/libraries/joomla/user/user.php:869
JROOT/libraries/joomla/user/user.php:242
JROOT/libraries/joomla/user/user.php:295
JROOT/libraries/joomla/factory.php:248
JROOT/components/com_k2/models/item.php:247
JROOT/components/com_k2/models/itemlist.php:982
JROOT/components/com_k2/views/item/view.html.php:286
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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.29 ms After last query: 0.32 ms Query memory: 0.027 MB Memory before query: 5.887 MB Rows returned: 1
```
SELECT `g`.`id`,`g`.`title`

  FROM `u2tdi_usergroups` AS g

  INNER JOIN `u2tdi_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 903
```
Explain
EXPLAIN not possible on query: SELECT `g`.`id`,`g`.`title` FROM `u2tdi_usergroups` AS g INNER JOIN `u2tdi_user_usergroup_map` AS m ON m.group_id = g.id WHERE `m`.`user_id` = 903
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/libraries/joomla/table/user.php:109
JROOT/libraries/joomla/user/user.php:869
JROOT/libraries/joomla/user/user.php:242
JROOT/libraries/joomla/user/user.php:295
JROOT/libraries/joomla/factory.php:248
JROOT/components/com_k2/models/item.php:247
JROOT/components/com_k2/models/itemlist.php:982
JROOT/components/com_k2/views/item/view.html.php:286
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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.35 ms After last query: 2.00 ms Query memory: 0.024 MB Memory before query: 5.909 MB Rows returned: 1
```
SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM u2tdi_k2_users 
  WHERE userID=903
```
Explain
EXPLAIN not possible on query: SELECT id, gender, description, image, url, `group`, plugins FROM u2tdi_k2_users WHERE userID=903
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:1811
JROOT/components/com_k2/models/item.php:250
JROOT/components/com_k2/models/itemlist.php:982
JROOT/components/com_k2/views/item/view.html.php:286
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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: 1.88 ms Query memory: 0.031 MB Memory before query: 5.908 MB Rows returned: 1
Duplicate queries: #41
```
SELECT items.id, categories.id AS catid, 
  CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug 
		
  FROM u2tdi_k2_items AS items 
		
  INNER JOIN u2tdi_k2_categories AS categories 
  ON items.catid = categories.id 
		
  WHERE items.id = 7283
```
Explain
EXPLAIN not possible on query: SELECT items.id, categories.id AS catid, CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug FROM u2tdi_k2_items AS items INNER JOIN u2tdi_k2_categories AS categories ON items.catid = categories.id WHERE items.id = 7283
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/router.php:444
JROOT/components/com_k2/router.php:151
JROOT/libraries/cms/component/router/legacy.php:68
JROOT/libraries/cms/router/site.php:483
JROOT/libraries/cms/router/site.php:452
JROOT/libraries/cms/router/router.php:280
JROOT/libraries/cms/router/site.php:134
JROOT/libraries/joomla/application/route.php:62
JROOT/components/com_k2/models/item.php:82
JROOT/components/com_k2/models/itemlist.php:982
JROOT/components/com_k2/views/item/view.html.php:286
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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.27 ms After last query: 0.31 ms Query memory: 0.030 MB Memory before query: 5.939 MB Rows returned: 1
Duplicate queries: #40
```
SELECT items.id, categories.id AS catid, 
  CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug 
		
  FROM u2tdi_k2_items AS items 
		
  INNER JOIN u2tdi_k2_categories AS categories 
  ON items.catid = categories.id 
		
  WHERE items.id = 7283
```
Explain
EXPLAIN not possible on query: SELECT items.id, categories.id AS catid, CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug FROM u2tdi_k2_items AS items INNER JOIN u2tdi_k2_categories AS categories ON items.catid = categories.id WHERE items.id = 7283
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/router.php:444
JROOT/components/com_k2/router.php:151
JROOT/libraries/cms/component/router/legacy.php:68
JROOT/libraries/cms/router/site.php:483
JROOT/libraries/cms/router/site.php:452
JROOT/libraries/cms/router/router.php:280
JROOT/libraries/cms/router/site.php:134
JROOT/libraries/joomla/application/route.php:62
JROOT/components/com_k2/models/item.php:85
JROOT/components/com_k2/models/itemlist.php:982
JROOT/components/com_k2/views/item/view.html.php:286
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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.97 ms After last query: 4.41 ms Query memory: 0.030 MB Memory before query: 6.034 MB Rows returned: 1
Duplicate queries: #43
```
SELECT items.id, categories.id AS catid, 
  CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug 
		
  FROM u2tdi_k2_items AS items 
		
  INNER JOIN u2tdi_k2_categories AS categories 
  ON items.catid = categories.id 
		
  WHERE items.id = 7277
```
Explain
EXPLAIN not possible on query: SELECT items.id, categories.id AS catid, CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug FROM u2tdi_k2_items AS items INNER JOIN u2tdi_k2_categories AS categories ON items.catid = categories.id WHERE items.id = 7277
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/router.php:444
JROOT/components/com_k2/router.php:151
JROOT/libraries/cms/component/router/legacy.php:68
JROOT/libraries/cms/router/site.php:483
JROOT/libraries/cms/router/site.php:452
JROOT/libraries/cms/router/router.php:280
JROOT/libraries/cms/router/site.php:134
JROOT/libraries/joomla/application/route.php:62
JROOT/components/com_k2/models/item.php:82
JROOT/components/com_k2/models/itemlist.php:982
JROOT/components/com_k2/views/item/view.html.php:286
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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.27 ms After last query: 0.31 ms Query memory: 0.030 MB Memory before query: 6.065 MB Rows returned: 1
Duplicate queries: #42
```
SELECT items.id, categories.id AS catid, 
  CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug 
		
  FROM u2tdi_k2_items AS items 
		
  INNER JOIN u2tdi_k2_categories AS categories 
  ON items.catid = categories.id 
		
  WHERE items.id = 7277
```
Explain
EXPLAIN not possible on query: SELECT items.id, categories.id AS catid, CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug FROM u2tdi_k2_items AS items INNER JOIN u2tdi_k2_categories AS categories ON items.catid = categories.id WHERE items.id = 7277
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/router.php:444
JROOT/components/com_k2/router.php:151
JROOT/libraries/cms/component/router/legacy.php:68
JROOT/libraries/cms/router/site.php:483
JROOT/libraries/cms/router/site.php:452
JROOT/libraries/cms/router/router.php:280
JROOT/libraries/cms/router/site.php:134
JROOT/libraries/joomla/application/route.php:62
JROOT/components/com_k2/models/item.php:85
JROOT/components/com_k2/models/itemlist.php:982
JROOT/components/com_k2/views/item/view.html.php:286
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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: 2.85 ms After last query: 4.19 ms Query memory: 0.029 MB Memory before query: 6.096 MB Rows returned: 1
```
SELECT * 
  FROM u2tdi_k2_items 
  WHERE id != 4789 
  AND catid=78 
  AND ordering > 1791 
  AND published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-09-29 04:09:35' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-09-29 04:09:35' )  
  AND access IN(1,1) 
  AND trash=0 
  AND language IN ('en-GB','*') 
  ORDER BY ordering ASC 
  LIMIT 0, 1
```
Explain
EXPLAIN not possible on query: SELECT * FROM u2tdi_k2_items WHERE id != 4789 AND catid=78 AND ordering > 1791 AND published=1 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-09-29 04:09:35' ) AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-09-29 04:09:35' ) AND access IN(1,1) AND trash=0 AND language IN ('en-GB','*') ORDER BY ordering ASC LIMIT 0, 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:1792
JROOT/components/com_k2/views/item/view.html.php:303
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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.84 ms After last query: 0.44 ms Query memory: 0.028 MB Memory before query: 6.128 MB Rows returned: 1
```
SELECT items.id, categories.id AS catid, 
  CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug 
		
  FROM u2tdi_k2_items AS items 
		
  INNER JOIN u2tdi_k2_categories AS categories 
  ON items.catid = categories.id 
		
  WHERE items.id = 4791
```
Explain
EXPLAIN not possible on query: SELECT items.id, categories.id AS catid, CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug FROM u2tdi_k2_items AS items INNER JOIN u2tdi_k2_categories AS categories ON items.catid = categories.id WHERE items.id = 4791
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/router.php:444
JROOT/components/com_k2/router.php:151
JROOT/libraries/cms/component/router/legacy.php:68
JROOT/libraries/cms/router/site.php:483
JROOT/libraries/cms/router/site.php:452
JROOT/libraries/cms/router/router.php:280
JROOT/libraries/cms/router/site.php:134
JROOT/libraries/joomla/application/route.php:62
JROOT/components/com_k2/views/item/view.html.php:306
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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.23 ms After last query: 0.48 ms Query memory: 0.029 MB Memory before query: 6.155 MB Rows returned: 1
```
SELECT * 
  FROM u2tdi_k2_items 
  WHERE id != 4789 
  AND catid=78 
  AND ordering < 1791 
  AND published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-09-29 04:09:35' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-09-29 04:09:35' )  
  AND access IN(1,1) 
  AND trash=0 
  AND language IN ('en-GB','*') 
  ORDER BY ordering DESC 
  LIMIT 0, 1
```
Explain
EXPLAIN not possible on query: SELECT * FROM u2tdi_k2_items WHERE id != 4789 AND catid=78 AND ordering < 1791 AND published=1 AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2023-09-29 04:09:35' ) AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2023-09-29 04:09:35' ) AND access IN(1,1) AND trash=0 AND language IN ('en-GB','*') ORDER BY ordering DESC LIMIT 0, 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/models/item.php:1747
JROOT/components/com_k2/views/item/view.html.php:344
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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.81 ms After last query: 0.45 ms Query memory: 0.028 MB Memory before query: 6.187 MB Rows returned: 1
```
SELECT items.id, categories.id AS catid, 
  CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug 
		
  FROM u2tdi_k2_items AS items 
		
  INNER JOIN u2tdi_k2_categories AS categories 
  ON items.catid = categories.id 
		
  WHERE items.id = 4784
```
Explain
EXPLAIN not possible on query: SELECT items.id, categories.id AS catid, CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug FROM u2tdi_k2_items AS items INNER JOIN u2tdi_k2_categories AS categories ON items.catid = categories.id WHERE items.id = 4784
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/components/com_k2/router.php:444
JROOT/components/com_k2/router.php:151
JROOT/libraries/cms/component/router/legacy.php:68
JROOT/libraries/cms/router/site.php:483
JROOT/libraries/cms/router/site.php:452
JROOT/libraries/cms/router/router.php:280
JROOT/libraries/cms/router/site.php:134
JROOT/libraries/joomla/application/route.php:62
JROOT/components/com_k2/views/item/view.html.php:347
JROOT/libraries/joomla/cache/controller/view.php:96
JROOT/libraries/legacy/controller/legacy.php:686
JROOT/components/com_k2/controllers/controller.php:20
JROOT/components/com_k2/controllers/item.php:80
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_k2/k2.php:63
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: 3.16 ms Query memory: 0.015 MB Memory before query: 6.204 MB Rows returned: 1
```
SELECT language,id

  FROM `u2tdi_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0
```
Explain
EXPLAIN not possible on query: SELECT language,id FROM `u2tdi_menu` WHERE home = 1 AND published = 1 AND client_id = 0
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_languages/helpers/multilangstatus.php:115
JROOT/plugins/system/languagefilter/languagefilter.php:611
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/site.php:196
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.07 ms After last query: 0.52 ms Query memory: 0.015 MB Memory before query: 6.221 MB Rows returned: 6
Duplicate queries: #7 #8 #50
```
SELECT a.element AS element

  FROM u2tdi_extensions AS a

  WHERE a.type = 'language' 
  AND a.client_id = 0 
  AND a.enabled = 1
```
Explain
EXPLAIN not possible on query: SELECT a.element AS element FROM u2tdi_extensions AS a WHERE a.type = 'language' AND a.client_id = 0 AND a.enabled = 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_languages/helpers/multilangstatus.php:94
JROOT/plugins/system/languagefilter/languagefilter.php:651
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/site.php:196
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.27 ms After last query: 0.15 ms Query memory: 0.015 MB Memory before query: 6.235 MB Rows returned: 6
Duplicate queries: #7 #8 #49
```
SELECT a.element AS element

  FROM u2tdi_extensions AS a

  WHERE a.type = 'language' 
  AND a.client_id = 0 
  AND a.enabled = 1
```
Explain
EXPLAIN not possible on query: SELECT a.element AS element FROM u2tdi_extensions AS a WHERE a.type = 'language' AND a.client_id = 0 AND a.enabled = 1
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/administrator/components/com_languages/helpers/multilangstatus.php:94
JROOT/plugins/system/languagefilter/languagefilter.php:651
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/site.php:196
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.29 ms After last query: 1.39 ms Query memory: 0.017 MB Memory before query: 6.303 MB Rows returned: 1
```
SELECT template_style_id 
  FROM u2tdi_menu 
  WHERE id = 785
```
Explain
EXPLAIN not possible on query: SELECT template_style_id FROM u2tdi_menu WHERE id = 785
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/yt/includes/site/lib/yt_template.php:184
JROOT/plugins/system/yt/includes/site/lib/yt_template.php:30
JROOT/templates/sj_veritymag/includes/frame_inc.php:31
JROOT/templates/sj_veritymag/index.php:23
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.32 ms After last query: 0.10 ms Query memory: 0.017 MB Memory before query: 6.319 MB Rows returned: 1
```
SELECT id 
  FROM u2tdi_template_styles 
  WHERE home = 1 
  AND client_id = 0
```
Explain
EXPLAIN not possible on query: SELECT id FROM u2tdi_template_styles WHERE home = 1 AND client_id = 0
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/yt/includes/site/lib/yt_template.php:188
JROOT/plugins/system/yt/includes/site/lib/yt_template.php:30
JROOT/templates/sj_veritymag/includes/frame_inc.php:31
JROOT/templates/sj_veritymag/index.php:23
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: 4.59 ms After last query: 1.26 ms Query memory: 0.025 MB Memory before query: 6.362 MB Rows returned: 17
```
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM u2tdi_modules AS m

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

  LEFT JOIN u2tdi_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 <= '2023-09-29 04:09:35') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-29 04:09:35') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 785 OR mm.menuid <= 0) 
  AND m.language IN ('en-GB','*')

  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 u2tdi_modules AS m LEFT JOIN u2tdi_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN u2tdi_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 <= '2023-09-29 04:09:35') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-29 04:09:35') AND m.access IN (1,1) AND m.client_id = 0 AND (mm.menuid = 785 OR mm.menuid <= 0) AND m.language IN ('en-GB','*') 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/plugins/system/yt/includes/site/lib/yt_renderxml.php:181
JROOT/plugins/system/yt/includes/site/lib/yt_renderxml.php:117
JROOT/plugins/system/yt/includes/site/lib/yt_renderxml.php:49
JROOT/templates/sj_veritymag/includes/frame_inc.php:101
JROOT/templates/sj_veritymag/index.php:23
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.38 ms After last query: 7.59 ms Query memory: 0.014 MB Memory before query: 6.511 MB Rows returned: 1
Duplicate queries: #55
```
SELECT home 
  FROM u2tdi_menu 
  WHERE id=785
```
Explain
EXPLAIN not possible on query: SELECT home FROM u2tdi_menu WHERE id=785
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/yt/includes/site/lib/yt_template.php:172
JROOT/templates/sj_veritymag/index.php:75
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.33 ms After last query: 0.08 ms Query memory: 0.014 MB Memory before query: 6.525 MB Rows returned: 1
Duplicate queries: #54
```
SELECT home 
  FROM u2tdi_menu 
  WHERE id=785
```
Explain
EXPLAIN not possible on query: SELECT home FROM u2tdi_menu WHERE id=785
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/yt/includes/site/lib/yt_template.php:173
JROOT/templates/sj_veritymag/index.php:75
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.32 ms After last query: 76.78 ms Query memory: 0.015 MB Memory before query: 6.765 MB Rows returned: 1
```
SELECT template

  FROM u2tdi_template_styles

  WHERE home = 1 
  AND client_id = 0
```
Explain
EXPLAIN not possible on query: SELECT template FROM u2tdi_template_styles WHERE home = 1 AND client_id = 0
Profile
No SHOW PROFILE (maybe because there are more than 100 queries)
Call Stack
JROOT/plugins/system/yt/yt.php:280
JROOT/plugins/system/yt/yt.php:161
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:1065
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.]

36 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

11 × SELECT items.id, categories.id AS catid, 
  CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS('-', categories.id, categories.alias) ELSE categories.id END AS catslug    
  FROM u2tdi_k2_items AS items    
  INNER JOIN u2tdi_k2_categories AS categories 
  ON items.catid = categories.id

4 × SELECT a.element AS element 
  FROM u2tdi_extensions AS a

```
3 × SELECT * 
  FROM u2tdi_k2_items
```
```
2 × SELECT * 
  FROM `u2tdi_users`
```

2 × SELECT `g`.`id`,`g`.`title` 
  FROM `u2tdi_usergroups` AS g 
  INNER JOIN `u2tdi_user_usergroup_map` AS m 
  ON m.group_id = g.id

```
2 × SELECT home 
  FROM u2tdi_menu
```

2 × SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM u2tdi_k2_users

2 × SELECT * 
  FROM u2tdi_k2_categories

1 × SELECT language,id 
  FROM `u2tdi_menu`

1 × SELECT i.*, c.alias as categoryalias 
  FROM u2tdi_k2_items as i      
  LEFT JOIN u2tdi_k2_categories c 
  ON c.id = i.catid

1 × SELECT DISTINCT itemID 
  FROM u2tdi_k2_tags_xref

1 × SELECT * 
  FROM u2tdi_k2_comments

1 × SELECT template_style_id 
  FROM u2tdi_menu

1 × SELECT id 
  FROM u2tdi_template_styles

1 × SELECT template 
  FROM u2tdi_template_styles

1 × SELECT `session_id` 
  FROM `u2tdi_session`

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

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

1 × SELECT id, rules 
  FROM `u2tdi_viewlevels

1 × SELECT id 
  FROM u2tdi_k2_categories

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

1 × SELECT a.rules 
  FROM u2tdi_assets AS a

1 × SELECT COUNT(extension_id) 
  FROM u2tdi_extensions

1 × SELECT count(1) 
  FROM `u2tdi_session`

1 × SELECT `data` 
  FROM `u2tdi_session`

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

1 × SELECT * 
  FROM u2tdi_k2_attachments

1 × SELECT tag.*   
  FROM u2tdi_k2_tags AS tag   JOIN u2tdi_k2_tags_xref AS xref 
  ON tag.id = xref.tagID

1 × SELECT element,views,context,types,params 
  FROM u2tdi_ark_editor_inline_views

OTHER Tables:

1 × SHOW FULL COLUMNS 
  FROM `u2tdi_k2_items

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

1 × SHOW FULL COLUMNS 
  FROM `u2tdi_users

1 × SHOW FULL COLUMNS 
  FROM `u2tdi_k2_categories

1 × INSERT INTO `u2tdi_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('kcvccd1u3eo95jr7ehkt6o5373', 0, '1695960575'

1 × UPDATE `u2tdi_extensions` 
  SET `params` = '{\"mediaversion\":\"9b7a0e3a6d1c1284b7e2c2eb72d4fffe\"}'

```
1 × DELETE  
  FROM `u2tdi_session`
```

Palo de viernes

Mathías Gonnet

Artículos relacionados (por etiqueta)

Joomla! Debug Console

Session

__default

Profile Information

Time

Memory

Memory Usage

Database Queries

56 Queries Logged 79.1 ms

15 duplicate found!

36 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: