The War on Drugs in Mexico - Is There an Alternative?

https://www.youtube.com

Creator: Hungarian Civil Liberties Union (HCLU)
Issue: drug policy, access to justice
Contact: István Gábor Takács, Stefania Kapronczay takacsistvan@tasz.hu; kapronczay.stefania@tasz.hu

Description: The HCLU's video advocacy team travelled to Mexico in 2010 to film about the negative consequences of the war on drugs campaign that has been launched by President Felipe Calderon in 2006. When we first entered the country the number of people killed in the war approached 40.000. Today, the death toll is approximately 60.000. With the help of a like-minded local NGO, Espolea, we interviewed several politicians, professionals and activists to find out why so many people had to die: were they the necessary costs of an unescapable but winnebale war, as many decision makers say, or the victims of a failed policy?

Country: Mexico

Population: People Who Use Drugs

Issue: Access to Justice, Regulation Policies

Length: > 30 Minutes

Language (Spoken): English, Spanish

Language (Subtitles): English, Spanish

**Joomla! Debug Console**

38 Queries Logged 29.2 ms

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

  FROM `xu5z7_session`

  WHERE `session_id` = '897437935ff405a7158c39f13c654f5a'
```
**Explain**
**EXPLAIN not possible on query: SELECT `data` FROM `xu5z7_session` WHERE `session_id` = '897437935ff405a7158c39f13c654f5a'**
**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.58 ms** **After last query: 1.79 ms**
```
DELETE 

  FROM `xu5z7_session`

  WHERE `time` < '1764995789'
```
**Explain**
**EXPLAIN not possible on query: DELETE FROM `xu5z7_session` WHERE `time` < '1764995789'**
**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: 0.51 ms** **After last query: 0.05 ms**
```
SELECT `session_id`

  FROM `xu5z7_session`

  WHERE `session_id` = '897437935ff405a7158c39f13c654f5a' 
  LIMIT 0, 1
```
**Explain**
**EXPLAIN not possible on query: SELECT `session_id` FROM `xu5z7_session` WHERE `session_id` = '897437935ff405a7158c39f13c654f5a' 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.49 ms** **After last query: 0.05 ms**
```
INSERT INTO `xu5z7_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('897437935ff405a7158c39f13c654f5a', 0, '1764996689')
```
**Explain**
**EXPLAIN not possible on query: INSERT INTO `xu5z7_session` (`session_id`, `client_id`, `time`) VALUES ('897437935ff405a7158c39f13c654f5a', 0, '1764996689')**
**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.78 ms** **After last query: 1.95 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: 0.65 ms** **After last query: 0.78 ms**
```
SELECT b.id

  FROM xu5z7_usergroups AS a

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

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

  FROM `xu5z7_viewlevels`
```
**Explain**
**EXPLAIN not possible on query: SELECT id, rules FROM `xu5z7_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.84 ms** **After last query: 0.08 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.86 ms** **After last query: 12.85 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.36 ms** **After last query: 3.54 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.79 ms** **After last query: 1.56 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: 0.99 ms** **After last query: 0.85 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.58 ms** **After last query: 0.05 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.66 ms** **After last query: 2.30 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.56 ms** **After last query: 0.11 ms**
```
UPDATE `xu5z7_extensions`

  SET `params` = '{\"mediaversion\":\"5e754b3b1d5af1e72d0f7e2226cab190\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'
```
**Explain**
**EXPLAIN not possible on query: UPDATE `xu5z7_extensions` SET `params` = '{\"mediaversion\":\"5e754b3b1d5af1e72d0f7e2226cab190\"}' 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.22 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.69 ms** **After last query: 0.10 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.51 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.59 ms** **After last query: 0.47 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.57 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: 0.60 ms** **After last query: 26.77 ms**
```
select * 
  from xu5z7_jshopping_languages
```
**Explain**
**EXPLAIN not possible on query: select * from xu5z7_jshopping_languages**
**Profile**
**No SHOW PROFILE (maybe because there are more than 100 queries)**
**Call Stack**
JROOT/components/com_jshopping/lib/functions.php:274
JROOT/components/com_jshopping/loadparams.php:40
JROOT/components/com_jshopping/jshopping.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: 1.15 ms** **After last query: 6.50 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.67 ms** **After last query: 0.22 ms**
```
SELECT *

  FROM xu5z7_jshopping_products

  WHERE `product_id` = '279'
```
**Explain**
**EXPLAIN not possible on query: SELECT * FROM xu5z7_jshopping_products WHERE `product_id` = '279'**
**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.50 ms** **After last query: 0.07 ms**
```
SELECT * 
  FROM `xu5z7_jshopping_products_to_categories` 
  WHERE product_id='279'
```
**Explain**
**EXPLAIN not possible on query: SELECT * FROM `xu5z7_jshopping_products_to_categories` WHERE product_id='279'**
**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: 0.98 ms** **After last query: 0.34 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.49 ms** **After last query: 0.05 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.07 ms** **After last query: 0.15 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.02 ms** **After last query: 0.51 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.63 ms** **After last query: 0.24 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.59 ms** **After last query: 1.26 ms**
```
UPDATE xu5z7_jshopping_products

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

  WHERE `product_id` = '279'
```
**Explain**
**EXPLAIN not possible on query: UPDATE xu5z7_jshopping_products SET `hits` = (`hits` + 1) WHERE `product_id` = '279'**
**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.01 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: 1.04 ms** **After last query: 0.37 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.75 ms** **After last query: 0.05 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: 1.02 ms** **After last query: 0.44 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: 0.99 ms** **After last query: 0.06 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.69 ms** **After last query: 0.09 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 = '279' 
  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 = '279' 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: 1.10 ms** **After last query: 13.04 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:51:29') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-12-06 04:51:29') 
  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:51:29') AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-12-06 04:51:29') 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.10 ms** **After last query: 24.28 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.**]

37 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

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

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

**1 × SELECT * 
  FROM xu5z7_jshopping_products**

**1 × select * 
  from xu5z7_jshopping_language**

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

**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 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 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 * 
  FROM xu5z7_languages**

**1 × SELECT * 
  FROM xu5z7_jshopping_categories**

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

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

**1 × SELECT id, rules 
  FROM `xu5z7_viewlevels**

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

**1 × SELECT `session_id` 
  FROM `xu5z7_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 xu5z7_menu AS m 
  LEFT JOIN xu5z7_extensions AS e 
  ON m.component_id = e.extension_id**

**1 × SELECT * 
  FROM xu5z7_jshopping_config**

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

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

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

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

OTHER Tables:

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

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

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

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

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

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

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

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

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

**1 × INSERT INTO `xu5z7_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('897437935ff405a7158c39f13c654f5a', 0, '1764996689'**

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

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

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

**1 × DELETE  
  FROM `xu5z7_session`**

The War on Drugs in Mexico - Is There an Alternative?

Joomla! Debug Console

Session

__default

Profile Information

Time

Memory

Memory Usage

Database Queries

38 Queries Logged 29.2 ms

37 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Parsing errors in language files

Language Files Loaded

Untranslated Strings

The War on Drugs in Mexico - Is There an Alternative?

**Joomla! Debug Console**

**Session**

__default

**Profile Information**

**Time**

**Memory**

**Memory Usage**

**Database Queries**

**38 Queries Logged** 29.2 ms

**37 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

38 Queries Logged 29.2 ms

37 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables:

Parsing errors in language files

Language Files Loaded

Untranslated Strings