Medical Research: Houston, we have a problem...

Creator: Fundación Salud por Derecho

Contact: Vanessa López, vanessa.lopez@saludporderecho.org

Description: In this documentary experts and leading thinkers from around the world reveal chilling facts about our obsolete model of medical research.

Country: Spain

Population: Members of the Pharmaceutical Industry

Issue: Access to Medicines

Length: > 30 Minutes

Language (Spoken): English, Spanish

Language (Subtitles): English

**Joomla! Debug Console**

32 Queries Logged 28.2 ms

**Query Time: 1.14 ms**
```
SELECT `data`

  FROM `xu5z7_session`

  WHERE `session_id` = 'b2f0f513245e91f2c4e1be2af02d0984'
```
**Explain**
**EXPLAIN not possible on query: SELECT `data` FROM `xu5z7_session` WHERE `session_id` = 'b2f0f513245e91f2c4e1be2af02d0984'**
**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: 0.88 ms** **After last query: 3.45 ms**
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM xu5z7_extensions

  WHERE `type` = 'component'
```
**Explain**
**EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled FROM xu5z7_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: 1.46 ms** **After last query: 1.43 ms**
```
SELECT folder AS type, element AS name, params

  FROM xu5z7_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 xu5z7_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.92 ms** **After last query: 18.66 ms**
```
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 xu5z7_menu AS m

  LEFT JOIN xu5z7_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 xu5z7_menu AS m LEFT JOIN xu5z7_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: 1.46 ms** **After last query: 4.25 ms**
```
SHOW FULL COLUMNS 
  FROM `xu5z7_jshopping_config`
```
**Explain**
**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `xu5z7_jshopping_config`**
**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/components/com_jshopping/tables/config.php:15
JROOT/components/com_jshopping/lib/factory.php:28
JROOT/components/com_jshopping/lib/factory.php:218
JROOT/components/com_jshopping/lib/factory.php:241
JROOT/components/com_jshopping/router.php:211
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:395
JROOT/libraries/cms/router/router.php:479
JROOT/libraries/cms/router/router.php:234
JROOT/libraries/cms/router/site.php:118
JROOT/libraries/cms/application/cms.php:1089
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.78 ms** **After last query: 2.20 ms**
```
SELECT *

  FROM xu5z7_jshopping_config

  WHERE `id` = '1'
```
**Explain**
**EXPLAIN not possible on query: SELECT * FROM xu5z7_jshopping_config WHERE `id` = '1'**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/libraries/joomla/table/table.php:728
JROOT/components/com_jshopping/lib/factory.php:32
JROOT/components/com_jshopping/lib/factory.php:218
JROOT/components/com_jshopping/lib/factory.php:241
JROOT/components/com_jshopping/router.php:211
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:395
JROOT/libraries/cms/router/router.php:479
JROOT/libraries/cms/router/router.php:234
JROOT/libraries/cms/router/site.php:118
JROOT/libraries/cms/application/cms.php:1089
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.05 ms** **After last query: 1.04 ms**
```
SHOW FULL COLUMNS 
  FROM `xu5z7_jshopping_currencies`
```
**Explain**
**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `xu5z7_jshopping_currencies`**
**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/components/com_jshopping/tables/currency.php:22
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_jshopping/lib/factory.php:675
JROOT/components/com_jshopping/lib/factory.php:623
JROOT/components/com_jshopping/tables/config.php:54
JROOT/components/com_jshopping/lib/factory.php:34
JROOT/components/com_jshopping/lib/factory.php:218
JROOT/components/com_jshopping/lib/factory.php:241
JROOT/components/com_jshopping/router.php:211
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:395
JROOT/libraries/cms/router/router.php:479
JROOT/libraries/cms/router/router.php:234
JROOT/libraries/cms/router/site.php:118
JROOT/libraries/cms/application/cms.php:1089
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.57 ms** **After last query: 0.06 ms**
```
SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value 
  FROM `xu5z7_jshopping_currencies` 
  WHERE currency_publish = '1' 
  ORDER BY currency_ordering
```
**Explain**
**EXPLAIN not possible on query: SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value FROM `xu5z7_jshopping_currencies` WHERE currency_publish = '1' ORDER BY currency_ordering**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/components/com_jshopping/tables/currency.php:30
JROOT/components/com_jshopping/lib/factory.php:624
JROOT/components/com_jshopping/tables/config.php:54
JROOT/components/com_jshopping/lib/factory.php:34
JROOT/components/com_jshopping/lib/factory.php:218
JROOT/components/com_jshopping/lib/factory.php:241
JROOT/components/com_jshopping/router.php:211
JROOT/libraries/cms/component/router/legacy.php:104
JROOT/libraries/cms/router/site.php:395
JROOT/libraries/cms/router/router.php:479
JROOT/libraries/cms/router/router.php:234
JROOT/libraries/cms/router/site.php:118
JROOT/libraries/cms/application/cms.php:1089
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.62 ms** **After last query: 2.55 ms**
```
SELECT extension_id AS id, element AS "option", params, enabled

  FROM xu5z7_extensions

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
**Explain**
**EXPLAIN not possible on query: SELECT extension_id AS id, element AS "option", params, enabled FROM xu5z7_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/advancedmodules/advancedmodules.php:80
JROOT/plugins/system/advancedmodules/advancedmodules.php:32
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.58 ms** **After last query: 0.13 ms**
```
UPDATE `xu5z7_extensions`

  SET `params` = '{\"mediaversion\":\"b202c30dd4ba61e8a4d6fb0a45e299bc\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
**Explain**
**EXPLAIN not possible on query: UPDATE `xu5z7_extensions` SET `params` = '{\"mediaversion\":\"b202c30dd4ba61e8a4d6fb0a45e299bc\"}' 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/advancedmodules/advancedmodules.php:80
JROOT/plugins/system/advancedmodules/advancedmodules.php:32
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.67 ms** **After last query: 1.25 ms**
```
select id,link 
  from xu5z7_menu 
  where `type`='component' 
  and published=1 
  and link like '%option=com_jshopping%' 
  and client_id=0 
  and (language='*' or language='en-GB') 
  and access IN (1,1,5)
```
**Explain**
**EXPLAIN not possible on query: select id,link from xu5z7_menu where `type`='component' and published=1 and link like '%option=com_jshopping%' and client_id=0 and (language='*' or language='en-GB') and access IN (1,1,5)**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/components/com_jshopping/lib/shop_item_menu.php:130
JROOT/components/com_jshopping/lib/shop_item_menu.php:41
JROOT/components/com_jshopping/lib/shop_item_menu.php:35
JROOT/components/com_jshopping/router.php:16
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.58 ms** **After last query: 0.09 ms**
```
select product_id as id, `alias_en-GB` as alias 
  from xu5z7_jshopping_products 
  where `alias_en-GB`!=''
```
**Explain**
**EXPLAIN not possible on query: select product_id as id, `alias_en-GB` as alias from xu5z7_jshopping_products where `alias_en-GB`!=''**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/components/com_jshopping/lib/factory.php:351
JROOT/components/com_jshopping/router.php:70
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.49 ms** **After last query: 0.03 ms**
```
select category_id as id, `alias_en-GB` as alias 
  from xu5z7_jshopping_categories 
  where `alias_en-GB`!=''
```
**Explain**
**EXPLAIN not possible on query: select category_id as id, `alias_en-GB` as alias from xu5z7_jshopping_categories where `alias_en-GB`!=''**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/components/com_jshopping/lib/factory.php:317
JROOT/components/com_jshopping/router.php:71
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.82 ms** **After last query: 0.49 ms**
```
SELECT *

  FROM xu5z7_languages

  WHERE published=1

  ORDER BY ordering ASC
```
**Explain**
**EXPLAIN not possible on query: SELECT * FROM xu5z7_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.82 ms** **After last query: 0.17 ms**
```
SELECT id, home, template, s.params

  FROM xu5z7_template_styles as s

  LEFT JOIN xu5z7_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 xu5z7_template_styles as s LEFT JOIN xu5z7_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: 1.25 ms** **After last query: 26.98 ms**
```
SHOW FULL COLUMNS 
  FROM `xu5z7_jshopping_products`
```
**Explain**
**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `xu5z7_jshopping_products`**
**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/components/com_jshopping/tables/product.php:14
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_jshopping/lib/factory.php:675
JROOT/components/com_jshopping/controllers/product.php:45
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
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.74 ms** **After last query: 0.22 ms**
```
SELECT *

  FROM xu5z7_jshopping_products

  WHERE `product_id` = '42'
```
**Explain**
**EXPLAIN not possible on query: SELECT * FROM xu5z7_jshopping_products WHERE `product_id` = '42'**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/libraries/joomla/table/table.php:728
JROOT/components/com_jshopping/controllers/product.php:46
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
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.53 ms** **After last query: 0.07 ms**
```
SELECT * 
  FROM `xu5z7_jshopping_products_to_categories` 
  WHERE product_id='42'
```
**Explain**
**EXPLAIN not possible on query: SELECT * FROM `xu5z7_jshopping_products_to_categories` WHERE product_id='42'**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/components/com_jshopping/tables/product.php:235
JROOT/components/com_jshopping/controllers/product.php:47
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
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.11 ms** **After last query: 0.35 ms**
```
SHOW FULL COLUMNS 
  FROM `xu5z7_jshopping_taxes`
```
**Explain**
**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `xu5z7_jshopping_taxes`**
**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/components/com_jshopping/tables/tax.php:17
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_jshopping/lib/factory.php:675
JROOT/components/com_jshopping/lib/factory.php:417
JROOT/components/com_jshopping/tables/product.php:664
JROOT/components/com_jshopping/tables/product.php:480
JROOT/components/com_jshopping/controllers/product.php:66
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
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.48 ms** **After last query: 0.06 ms**
```
SELECT tax_id, tax_name, tax_value 
  FROM `xu5z7_jshopping_taxes`
```
**Explain**
**EXPLAIN not possible on query: SELECT tax_id, tax_name, tax_value FROM `xu5z7_jshopping_taxes`**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/components/com_jshopping/tables/tax.php:24
JROOT/components/com_jshopping/lib/factory.php:403
JROOT/components/com_jshopping/lib/factory.php:418
JROOT/components/com_jshopping/tables/product.php:664
JROOT/components/com_jshopping/tables/product.php:480
JROOT/components/com_jshopping/controllers/product.php:66
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
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: 0.13 ms**
```
SHOW FULL COLUMNS 
  FROM `xu5z7_jshopping_users`
```
**Explain**
**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `xu5z7_jshopping_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/components/com_jshopping/tables/usershop.php:14
JROOT/components/com_jshopping/lib/factory.php:122
JROOT/components/com_jshopping/tables/product.php:580
JROOT/components/com_jshopping/tables/product.php:529
JROOT/components/com_jshopping/tables/product.php:481
JROOT/components/com_jshopping/controllers/product.php:66
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
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.13 ms** **After last query: 0.45 ms**
```
SHOW FULL COLUMNS 
  FROM `xu5z7_jshopping_categories`
```
**Explain**
**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `xu5z7_jshopping_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/components/com_jshopping/tables/category.php:15
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_jshopping/lib/factory.php:675
JROOT/components/com_jshopping/controllers/product.php:68
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
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.69 ms** **After last query: 0.13 ms**
```
SELECT *

  FROM xu5z7_jshopping_categories

  WHERE `category_id` = '1'
```
**Explain**
**EXPLAIN not possible on query: SELECT * FROM xu5z7_jshopping_categories WHERE `category_id` = '1'**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/libraries/joomla/table/table.php:728
JROOT/components/com_jshopping/controllers/product.php:69
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
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.56 ms** **After last query: 0.89 ms**
```
UPDATE xu5z7_jshopping_products

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

  WHERE `product_id` = '42'
```
**Explain**
**EXPLAIN not possible on query: UPDATE xu5z7_jshopping_products SET `hits` = (`hits` + 1) WHERE `product_id` = '42'**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/libraries/joomla/table/table.php:1239
JROOT/components/com_jshopping/controllers/product.php:85
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
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.06 ms** **After last query: 1.06 ms**
```
SHOW FULL COLUMNS 
  FROM `xu5z7_jshopping_products_reviews`
```
**Explain**
**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `xu5z7_jshopping_products_reviews`**
**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/components/com_jshopping/tables/review.php:14
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_jshopping/lib/factory.php:675
JROOT/components/com_jshopping/controllers/product.php:101
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
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.99 ms** **After last query: 0.59 ms**
```
SHOW FULL COLUMNS 
  FROM `xu5z7_jshopping_products_extra_field_values`
```
**Explain**
**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `xu5z7_jshopping_products_extra_field_values`**
**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/components/com_jshopping/tables/productfieldvalue.php:16
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_jshopping/lib/factory.php:675
JROOT/components/com_jshopping/lib/factory.php:559
JROOT/components/com_jshopping/tables/product.php:706
JROOT/components/com_jshopping/controllers/product.php:141
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
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.77 ms** **After last query: 0.08 ms**
```
SELECT id, `name_en-GB` as name, field_id 
  FROM `xu5z7_jshopping_products_extra_field_values` 
  order by ordering
```
**Explain**
**EXPLAIN not possible on query: SELECT id, `name_en-GB` as name, field_id FROM `xu5z7_jshopping_products_extra_field_values` order by ordering**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/components/com_jshopping/tables/productfieldvalue.php:27
JROOT/components/com_jshopping/lib/factory.php:560
JROOT/components/com_jshopping/tables/product.php:706
JROOT/components/com_jshopping/controllers/product.php:141
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
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.99 ms** **After last query: 0.50 ms**
```
SHOW FULL COLUMNS 
  FROM `xu5z7_jshopping_products_extra_fields`
```
**Explain**
**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `xu5z7_jshopping_products_extra_fields`**
**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/components/com_jshopping/tables/productfield.php:16
JROOT/libraries/joomla/table/table.php:305
JROOT/components/com_jshopping/lib/factory.php:675
JROOT/components/com_jshopping/lib/factory.php:550
JROOT/components/com_jshopping/tables/product.php:707
JROOT/components/com_jshopping/controllers/product.php:141
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
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.10 ms** **After last query: 0.08 ms**
```
SELECT F.id, F.`name_en-GB` as name, F.`description_en-GB` as description, F.allcats, F.type, F.cats, F.ordering, F.`
  group`, G.`name_en-GB` as groupname, multilist 
  FROM `xu5z7_jshopping_products_extra_fields` as F 
  left join `xu5z7_jshopping_products_extra_field_groups` as G 
  on G.id=F.
  group 
  order by G.ordering, F.ordering
```
**Explain**
**EXPLAIN not possible on query: SELECT F.id, F.`name_en-GB` as name, F.`description_en-GB` as description, F.allcats, F.type, F.cats, F.ordering, F.`group`, G.`name_en-GB` as groupname, multilist FROM `xu5z7_jshopping_products_extra_fields` as F left join `xu5z7_jshopping_products_extra_field_groups` as G on G.id=F.group order by G.ordering, F.ordering**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/components/com_jshopping/tables/productfield.php:50
JROOT/components/com_jshopping/lib/factory.php:551
JROOT/components/com_jshopping/tables/product.php:707
JROOT/components/com_jshopping/controllers/product.php:141
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
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.71 ms** **After last query: 0.11 ms**
```
SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
  FROM `xu5z7_jshopping_products_images` as I 
  left join `xu5z7_jshopping_products` as P 
  on P.product_id=I.product_id
                 
  WHERE I.product_id = '42' 
  ORDER BY sort, I.ordering
```
**Explain**
**EXPLAIN not possible on query: SELECT I.*, IF(P.image=I.image_name,0,1) as sort FROM `xu5z7_jshopping_products_images` as I left join `xu5z7_jshopping_products` as P on P.product_id=I.product_id WHERE I.product_id = '42' ORDER BY sort, I.ordering**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/components/com_jshopping/tables/product.php:321
JROOT/components/com_jshopping/controllers/product.php:221
JROOT/libraries/legacy/controller/legacy.php:728
JROOT/components/com_jshopping/jshopping.php:25
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.95 ms** **After last query: 14.54 ms**
```
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM xu5z7_modules AS m

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

  LEFT JOIN xu5z7_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-12-06 04:03:36') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-12-06 04:03:36') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 101 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 xu5z7_modules AS m LEFT JOIN xu5z7_modules_menu AS mm ON mm.moduleid = m.id LEFT JOIN xu5z7_extensions AS e ON e.element = m.module AND e.client_id = m.client_id WHERE m.published = 1 AND e.enabled = 1 AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-12-06 04:03:36') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-12-06 04:03:36') AND m.access IN (1,1,5) AND m.client_id = 0 AND (mm.menuid = 101 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_sun/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54
JROOT/templates/yoo_sun/layouts/theme.config.php:26
JROOT/templates/yoo_sun/layouts/theme.php:5
JROOT/templates/yoo_sun/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_sun/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: 1.20 ms** **After last query: 23.57 ms**
```
SHOW FULL COLUMNS 
  FROM `xu5z7_jshopping_usergroups`
```
**Explain**
**EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `xu5z7_jshopping_usergroups`**
**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/components/com_jshopping/tables/usergroup.php:14
JROOT/libraries/joomla/table/table.php:305
JROOT/modules/mod_jshopping_filters/mod_jshopping_filters.php:45
JROOT/libraries/cms/module/helper.php:190
JROOT/libraries/joomla/document/html/renderer/module.php:103
JROOT/templates/yoo_sun/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
JROOT/templates/yoo_sun/warp/systems/joomla/layouts/widgets.php:10
JROOT/templates/yoo_sun/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_sun/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
JROOT/templates/yoo_sun/layouts/theme.php:115
JROOT/templates/yoo_sun/warp/src/Warp/Helper/TemplateHelper.php:49
JROOT/templates/yoo_sun/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.**]

31 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

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

**1 × SELECT tax_id, tax_name, tax_value 
  FROM `xu5z7_jshopping_taxes**

**1 × SELECT * 
  FROM `xu5z7_jshopping_products_to_categories`**

**1 × SELECT * 
  FROM xu5z7_jshopping_products**

**1 × SELECT * 
  FROM xu5z7_jshopping_categories**

**1 × SELECT F.id, F.`name_en-GB` as name, F.`description_en-GB` as description, F.allcats, F.type, F.cats, F.ordering, F.`
  group`, G.`name_en-GB` as groupname, multilist 
  FROM `xu5z7_jshopping_products_extra_fields` as F 
  left join `xu5z7_jshopping_products_extra_field_groups` as G 
  on G.id=F.
  group**

**1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM xu5z7_modules AS m 
  LEFT JOIN xu5z7_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN xu5z7_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id**

**1 × SELECT I.*, IF(P.image=I.image_name,0,1) as sort 
  FROM `xu5z7_jshopping_products_images` as I 
  left join `xu5z7_jshopping_products` as P 
  on P.product_id=I.product_id**

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

**1 × SELECT id, `name_en-GB` as name, field_id 
  FROM `xu5z7_jshopping_products_extra_field_values`**

**1 × SELECT * 
  FROM xu5z7_languages**

**1 × SELECT * 
  FROM xu5z7_jshopping_config**

**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 xu5z7_menu AS m 
  LEFT JOIN xu5z7_extensions AS e 
  ON m.component_id = e.extension_id**

**1 × SELECT folder AS type, element AS name, params 
  FROM xu5z7_extensions**

**1 × SELECT currency_id, currency_name, currency_code, currency_code_iso, currency_value 
  FROM `xu5z7_jshopping_currencies`**

**1 × select id,link 
  from xu5z7_menu**

**1 × select category_id as id, `alias_en-GB` as alias 
  from xu5z7_jshopping_categories**

**1 × select product_id as id, `alias_en-GB` as alias 
  from xu5z7_jshopping_products**

**1 × SELECT `data` 
  FROM `xu5z7_session`**

OTHER Tables:

**1 × SHOW FULL COLUMNS 
  FROM `xu5z7_jshopping_products_reviews**

**1 × UPDATE xu5z7_jshopping_products 
  SET `hits` = (`hits` + 1)**

**1 × SHOW FULL COLUMNS 
  FROM `xu5z7_jshopping_products_extra_field_values**

**1 × SHOW FULL COLUMNS 
  FROM `xu5z7_jshopping_products_extra_fields**

**1 × SHOW FULL COLUMNS 
  FROM `xu5z7_jshopping_usergroups**

**1 × SHOW FULL COLUMNS 
  FROM `xu5z7_jshopping_categories**

**1 × SHOW FULL COLUMNS 
  FROM `xu5z7_jshopping_users**

**1 × SHOW FULL COLUMNS 
  FROM `xu5z7_jshopping_currencies**

**1 × UPDATE `xu5z7_extensions` 
  SET `params` = '{\"mediaversion\":\"b202c30dd4ba61e8a4d6fb0a45e299bc\"}'**

**1 × SHOW FULL COLUMNS 
  FROM `xu5z7_jshopping_products**

**1 × SHOW FULL COLUMNS 
  FROM `xu5z7_jshopping_taxes**

**1 × SHOW FULL COLUMNS 
  FROM `xu5z7_jshopping_config**

Medical Research: Houston, we have a problem...

Joomla! Debug Console

Session

__default

Profile Information

Time

Memory

Memory Usage

Database Queries

32 Queries Logged 28.2 ms

31 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Parsing errors in language files

Language Files Loaded

Untranslated Strings

Medical Research: Houston, we have a problem...

**Joomla! Debug Console**

**Session**

__default

**Profile Information**

**Time**

**Memory**

**Memory Usage**

**Database Queries**

**32 Queries Logged** 28.2 ms

**31 Query Types Logged, Sorted by Occurrences.**

**SELECT Tables:**

**OTHER Tables:**

**Parsing errors in language files**

**Language Files Loaded**

**Untranslated Strings**

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

32 Queries Logged 28.2 ms

31 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Parsing errors in language files

Language Files Loaded

Untranslated Strings