Joomla! Debug Console

1. Error loading component: com_cck, 1
   

   Call stack
   #	Function	Location
   1	JSite->dispatch()	JROOT/index.php:42
   2	JComponentHelper::renderComponent()	JROOT/includes/application.php:194
   3	JComponentHelper::executeComponent()	JROOT/libraries/joomla/application/component/helper.php:348
   4	require_once()	JROOT/libraries/joomla/application/component/helper.php:380
   5	JController->execute()	JROOT/components/com_xmap/xmap.php:24
   6	XmapController->display()	JROOT/libraries/joomla/application/component/controller.php:761
   7	JController->display()	JROOT/components/com_xmap/controller.php:57
   8	JCacheControllerView->get()	JROOT/libraries/joomla/application/component/controller.php:718
   9	XmapViewHtml->display()	JROOT/libraries/joomla/cache/controller/view.php:98
   10	JView->get()	JROOT/components/com_xmap/views/html/view.html.php:47
   11	XmapModelSitemap->getItems()	JROOT/libraries/joomla/application/component/view.php:386
   12	XmapHelper::getMenuItems()	JROOT/components/com_xmap/models/sitemap.php:161
   13	JComponentHelper::getParams()	JROOT/components/com_xmap/helpers/xmap.php:79
   14	JComponentHelper::getComponent()	JROOT/libraries/joomla/application/component/helper.php:92
   15	JComponentHelper::_load()	JROOT/libraries/joomla/application/component/helper.php:43
   16	JError::raiseWarning()	JROOT/libraries/joomla/application/component/helper.php:412
   17	JError::raise()	JROOT/libraries/joomla/error/error.php:276

216 Queries Logged

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 iola_menu AS m
  LEFT JOIN iola_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
2. SELECT joomlatablename,tablepkID
  FROM `iola_falang_tableinfo`
3. SELECT *
  FROM iola_languages
  ORDER BY ordering
4. SHOW FULL COLUMNS
  FROM `iola_languages`
5. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(101,213,214,215,216,102,210,219,220,221,265,222,223,267,224,225,226,227,228,229,230,109,110,189,188,187,186,185,184,183,182,181,191,192,193,194,195,241,245,243,246,264,269)
  AND falang_content.reference_table='menu'
6. SELECT extension_id AS id, element AS "option", params, enabled
  FROM iola_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_xmap'
7. SELECT a.*
  FROM iola_xmap_sitemap AS a
  WHERE a.id = 1
  AND a.state = 1
  AND a.access IN (1,1)
8. SELECT n.id, n.title, n.alias, n.path, n.level, n.link, n.type, n.params, n.home, n.parent_id,n.`browserNav`
  FROM iola_menu AS n
  INNER JOIN iola_menu AS p
  ON p.lft = 0
  WHERE n.lft > p.lft
  AND n.lft < p.rgt
  AND n.menutype = 'iolan-user-menu'
  AND n.published = 1
  AND n.access IN (1,1)
  AND n.language in ('en-GB','*')
  ORDER BY n.lft
9. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(245,243)
  AND falang_content.reference_table='menu'
10. SELECT extension_id AS id, element AS "option", params, enabled
  FROM iola_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_hikashop'
11. SELECT *
  FROM iola_extensions AS n
  WHERE n.folder = 'xmap'
  AND n.enabled = 1
12. SELECT n.id, n.title, n.alias, n.path, n.level, n.link, n.type, n.params, n.home, n.parent_id,n.`browserNav`
  FROM iola_menu AS n
  INNER JOIN iola_menu AS p
  ON p.lft = 0
  WHERE n.lft > p.lft
  AND n.lft < p.rgt
  AND n.menutype = 'topmenu'
  AND n.published = 1
  AND n.access IN (1,1)
  AND n.language in ('en-GB','*')
  ORDER BY n.lft
13. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(109,110,246,269)
  AND falang_content.reference_table='menu'
14. SELECT extension_id AS id, element AS "option", params, enabled
  FROM iola_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_acymailing'
15. SELECT n.id, n.title, n.alias, n.path, n.level, n.link, n.type, n.params, n.home, n.parent_id,n.`browserNav`
  FROM iola_menu AS n
  INNER JOIN iola_menu AS p
  ON p.lft = 0
  WHERE n.lft > p.lft
  AND n.lft < p.rgt
  AND n.menutype = 'mainmenu'
  AND n.published = 1
  AND n.access IN (1,1)
  AND n.language in ('en-GB','*')
  ORDER BY n.lft
16. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(101,213,214,215,216,102,210,219,220,221,265,222,223,267,224,225,226,227,228,229,230,241,264)
  AND falang_content.reference_table='menu'
17. SELECT extension_id AS id, element AS "option", params, enabled
  FROM iola_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_content'
18. SELECT extension_id AS id, element AS "option", params, enabled
  FROM iola_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_cck'
19. SELECT a.rules
  FROM iola_assets AS a
  WHERE (a.id = 1)
  GROUP BY a.id, a.rules, a.lft
20. SELECT b.rules
  FROM iola_assets AS a
  LEFT JOIN iola_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
  WHERE (a.name = 'com_xmap')
  GROUP BY b.id, b.rules, b.lft
  ORDER BY b.lft
21. SELECT *
  FROM iola_modules
  WHERE module='mod_menu'
  AND params LIKE '%"menutype":"iolan-user-menu"%'
  AND access IN (1,1)
  AND published=1
  AND client_id=0
  AND language in ('en-GB','*')
  LIMIT 1
22. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(141)
  AND falang_content.reference_table='modules'
23. SELECT *
  FROM iola_hikashop_config
24. SELECT *
  FROM iola_modules
  WHERE module='mod_menu'
  AND params LIKE '%"menutype":"topmenu"%'
  AND access IN (1,1)
  AND published=1
  AND client_id=0
  AND language in ('en-GB','*')
  LIMIT 1
25. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(31)
  AND falang_content.reference_table='modules'
26. SELECT *
  FROM iola_modules
  WHERE module='mod_menu'
  AND params LIKE '%"menutype":"mainmenu"%'
  AND access IN (1,1)
  AND published=1
  AND client_id=0
  AND language in ('en-GB','*')
  LIMIT 1
27. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(1)
  AND falang_content.reference_table='modules'
28. SELECT extension_id AS id, element AS "option", params, enabled
  FROM iola_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_contact'
29. SELECT *
  FROM iola_menu
  WHERE id = '210'
  LIMIT 1
30. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(210)
  AND falang_content.reference_table='menu'
31. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=12
  AND category_published=1
  AND product_type='main'
32. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,47,60,67,68,69,70,71,72,84,85,92,983,1025,1027,1029)
  AND falang_content.reference_table='hikashop_product'
33. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(12)
  AND falang_content.reference_table='hikashop_category'
34. SELECT *
  FROM iola_menu
  WHERE id = '219'
  LIMIT 1
35. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(219)
  AND falang_content.reference_table='menu'
36. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=13
37. SELECT *
  FROM iola_modules
  WHERE id = '133'
  LIMIT 1
38. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(133)
  AND falang_content.reference_table='modules'
39. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=13
  AND category_published=1
  AND product_type='main'
40. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(79,80,81,82,83,96,99,100,101,102,107,110,111,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132)
  AND falang_content.reference_table='hikashop_product'
41. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(13)
  AND falang_content.reference_table='hikashop_category'
42. SELECT *
  FROM iola_menu
  WHERE id = '220'
  LIMIT 1
43. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(220)
  AND falang_content.reference_table='menu'
44. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=14
45. SELECT *
  FROM iola_modules
  WHERE id = '134'
  LIMIT 1
46. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(134)
  AND falang_content.reference_table='modules'
47. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=14
  AND category_published=1
  AND product_type='main'
48. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(133,134,135,136,137,141,145,149,150,151,152,153,154,155,156,157,158,159,160,161,203,255,256)
  AND falang_content.reference_table='hikashop_product'
49. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(14)
  AND falang_content.reference_table='hikashop_category'
50. SELECT *
  FROM iola_menu
  WHERE id = '221'
  LIMIT 1
51. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(221)
  AND falang_content.reference_table='menu'
52. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=15
53. SELECT *
  FROM iola_modules
  WHERE id = '135'
  LIMIT 1
54. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(135)
  AND falang_content.reference_table='modules'
55. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=15
  AND category_published=1
  AND product_type='main'
56. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(95,162,163,167,171,175,185,186,187,188,189,190,191,192,193,194,197,200,201,202,843,844,845,846,847,893,894,895,896,897,898,899,900,909)
  AND falang_content.reference_table='hikashop_product'
57. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(15)
  AND falang_content.reference_table='hikashop_category'
58. SELECT *
  FROM iola_menu
  WHERE id = '265'
  LIMIT 1
59. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(265)
  AND falang_content.reference_table='menu'
60. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=25
  AND category_published=1
  AND product_type='main'
61. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(238,239,240,241,242,243,244,245,246,248,249,250,251,252,253,254)
  AND falang_content.reference_table='hikashop_product'
62. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(25)
  AND falang_content.reference_table='hikashop_category'
63. SELECT *
  FROM iola_menu
  WHERE id = '222'
  LIMIT 1
64. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(222)
  AND falang_content.reference_table='menu'
65. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=16
  AND category_published=1
  AND product_type='main'
66. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(204,205,206,207,208,209,210,215,224,225,226,227,228,229,230,231,232,233,234,235,236,237,554,922,1042,1043)
  AND falang_content.reference_table='hikashop_product'
67. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(16)
  AND falang_content.reference_table='hikashop_category'
68. SELECT *
  FROM iola_menu
  WHERE id = '223'
  LIMIT 1
69. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(223)
  AND falang_content.reference_table='menu'
70. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=17
  AND category_published=1
  AND product_type='main'
71. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(880,901,902,903,904,905,906,907,908,930,931,938,949,957,964,965,971,973)
  AND falang_content.reference_table='hikashop_product'
72. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(17)
  AND falang_content.reference_table='hikashop_category'
73. SELECT *
  FROM iola_menu
  WHERE id = '224'
  LIMIT 1
74. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(224)
  AND falang_content.reference_table='menu'
75. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=18
  AND category_published=1
  AND product_type='main'
76. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(257,258,259,260,261,612,923)
  AND falang_content.reference_table='hikashop_product'
77. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(18)
  AND falang_content.reference_table='hikashop_category'
78. SELECT *
  FROM iola_menu
  WHERE id = '225'
  LIMIT 1
79. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(225)
  AND falang_content.reference_table='menu'
80. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=19
  AND category_published=1
  AND product_type='main'
81. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(271,350,355,365,618)
  AND falang_content.reference_table='hikashop_product'
82. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(19)
  AND falang_content.reference_table='hikashop_category'
83. SELECT *
  FROM iola_menu
  WHERE id = '226'
  LIMIT 1
84. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(226)
  AND falang_content.reference_table='menu'
85. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=20
  AND category_published=1
  AND product_type='main'
86. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(376,383,395,407,507,535,542,555,562,864,881,887,923)
  AND falang_content.reference_table='hikashop_product'
87. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(20)
  AND falang_content.reference_table='hikashop_category'
88. SELECT *
  FROM iola_menu
  WHERE id = '227'
  LIMIT 1
89. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(227)
  AND falang_content.reference_table='menu'
90. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=21
  AND category_published=1
  AND product_type='main'
91. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(574,581,587,600)
  AND falang_content.reference_table='hikashop_product'
92. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(21)
  AND falang_content.reference_table='hikashop_category'
93. SELECT *
  FROM iola_menu
  WHERE id = '228'
  LIMIT 1
94. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(228)
  AND falang_content.reference_table='menu'
95. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=22
  AND category_published=1
  AND product_type='main'
96. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(628,635,653,665,677,689,701,706,713,792)
  AND falang_content.reference_table='hikashop_product'
97. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(22)
  AND falang_content.reference_table='hikashop_category'
98. SELECT *
  FROM iola_menu
  WHERE id = '229'
  LIMIT 1
99. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(229)
  AND falang_content.reference_table='menu'
100. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=23
  AND category_published=1
  AND product_type='main'
101. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(753,754,755,756,757,759,760,761,762,763,797)
  AND falang_content.reference_table='hikashop_product'
102. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(23)
  AND falang_content.reference_table='hikashop_category'
103. SELECT *
  FROM iola_menu
  WHERE id = '267'
  LIMIT 1
104. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(267)
  AND falang_content.reference_table='menu'
105. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=26
106. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(18,19,20,21,22,23)
  AND falang_content.reference_table='hikashop_category'
107. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=18
108. SELECT *
  FROM iola_modules
  WHERE id = '150'
  LIMIT 1
109. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(150)
  AND falang_content.reference_table='modules'
110. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=18
  AND category_published=1
  AND product_type='main'
111. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(257,258,259,260,261,612,923)
  AND falang_content.reference_table='hikashop_product'
112. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(18)
  AND falang_content.reference_table='hikashop_category'
113. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=19
114. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=19
  AND category_published=1
  AND product_type='main'
115. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(271,350,355,365,618)
  AND falang_content.reference_table='hikashop_product'
116. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(19)
  AND falang_content.reference_table='hikashop_category'
117. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=20
118. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=20
  AND category_published=1
  AND product_type='main'
119. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(376,383,395,407,507,535,542,555,562,864,881,887,923)
  AND falang_content.reference_table='hikashop_product'
120. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(20)
  AND falang_content.reference_table='hikashop_category'
121. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=21
122. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=21
  AND category_published=1
  AND product_type='main'
123. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(574,581,587,600)
  AND falang_content.reference_table='hikashop_product'
124. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(21)
  AND falang_content.reference_table='hikashop_category'
125. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=22
126. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=22
  AND category_published=1
  AND product_type='main'
127. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(628,635,653,665,677,689,701,706,713,792)
  AND falang_content.reference_table='hikashop_product'
128. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(22)
  AND falang_content.reference_table='hikashop_category'
129. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=23
130. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=23
  AND category_published=1
  AND product_type='main'
131. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(753,754,755,756,757,759,760,761,762,763,797)
  AND falang_content.reference_table='hikashop_product'
132. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(23)
  AND falang_content.reference_table='hikashop_category'
133. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=26
  AND category_published=1
  AND product_type='main'
134. SELECT *
  FROM iola_menu
  WHERE id = '230'
  LIMIT 1
135. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(230)
  AND falang_content.reference_table='menu'
136. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=24
  AND category_published=1
  AND product_type='main'
137. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(791,798,799,800,809,826)
  AND falang_content.reference_table='hikashop_product'
138. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(24)
  AND falang_content.reference_table='hikashop_category'
139. SELECT *
  FROM iola_menu
  WHERE id = '102'
  LIMIT 1
140. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(102)
  AND falang_content.reference_table='menu'
141. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=2
142. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(12,13,14,15,16,17,24,25,26)
  AND falang_content.reference_table='hikashop_category'
143. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=12
144. SELECT *
  FROM iola_modules
  WHERE id = '126'
  LIMIT 1
145. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(126)
  AND falang_content.reference_table='modules'
146. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=12
  AND category_published=1
  AND product_type='main'
147. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,47,60,67,68,69,70,71,72,84,85,92,983,1025,1027,1029)
  AND falang_content.reference_table='hikashop_product'
148. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(12)
  AND falang_content.reference_table='hikashop_category'
149. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=13
150. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=13
  AND category_published=1
  AND product_type='main'
151. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(79,80,81,82,83,96,99,100,101,102,107,110,111,113,114,115,116,117,118,119,120,121,122,123,124,125,126,127,128,129,130,131,132)
  AND falang_content.reference_table='hikashop_product'
152. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(13)
  AND falang_content.reference_table='hikashop_category'
153. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=14
154. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=14
  AND category_published=1
  AND product_type='main'
155. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(133,134,135,136,137,141,145,149,150,151,152,153,154,155,156,157,158,159,160,161,203,255,256)
  AND falang_content.reference_table='hikashop_product'
156. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(14)
  AND falang_content.reference_table='hikashop_category'
157. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=15
158. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=15
  AND category_published=1
  AND product_type='main'
159. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(95,162,163,167,171,175,185,186,187,188,189,190,191,192,193,194,197,200,201,202,843,844,845,846,847,893,894,895,896,897,898,899,900,909)
  AND falang_content.reference_table='hikashop_product'
160. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(15)
  AND falang_content.reference_table='hikashop_category'
161. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=16
162. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=16
  AND category_published=1
  AND product_type='main'
163. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(204,205,206,207,208,209,210,215,224,225,226,227,228,229,230,231,232,233,234,235,236,237,554,922,1042,1043)
  AND falang_content.reference_table='hikashop_product'
164. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(16)
  AND falang_content.reference_table='hikashop_category'
165. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=17
166. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=17
  AND category_published=1
  AND product_type='main'
167. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(880,901,902,903,904,905,906,907,908,930,931,938,949,957,964,965,971,973)
  AND falang_content.reference_table='hikashop_product'
168. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(17)
  AND falang_content.reference_table='hikashop_category'
169. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=24
170. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=24
  AND category_published=1
  AND product_type='main'
171. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(791,798,799,800,809,826)
  AND falang_content.reference_table='hikashop_product'
172. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(24)
  AND falang_content.reference_table='hikashop_category'
173. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=25
174. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=25
  AND category_published=1
  AND product_type='main'
175. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(238,239,240,241,242,243,244,245,246,248,249,250,251,252,253,254)
  AND falang_content.reference_table='hikashop_product'
176. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(25)
  AND falang_content.reference_table='hikashop_category'
177. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=26
178. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(18,19,20,21,22,23)
  AND falang_content.reference_table='hikashop_category'
179. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=18
180. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=18
  AND category_published=1
  AND product_type='main'
181. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(257,258,259,260,261,612,923)
  AND falang_content.reference_table='hikashop_product'
182. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(18)
  AND falang_content.reference_table='hikashop_category'
183. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=19
184. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=19
  AND category_published=1
  AND product_type='main'
185. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(271,350,355,365,618)
  AND falang_content.reference_table='hikashop_product'
186. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(19)
  AND falang_content.reference_table='hikashop_category'
187. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=20
188. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=20
  AND category_published=1
  AND product_type='main'
189. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(376,383,395,407,507,535,542,555,562,864,881,887,923)
  AND falang_content.reference_table='hikashop_product'
190. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(20)
  AND falang_content.reference_table='hikashop_category'
191. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=21
192. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=21
  AND category_published=1
  AND product_type='main'
193. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(574,581,587,600)
  AND falang_content.reference_table='hikashop_product'
194. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(21)
  AND falang_content.reference_table='hikashop_category'
195. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=22
196. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=22
  AND category_published=1
  AND product_type='main'
197. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(628,635,653,665,677,689,701,706,713,792)
  AND falang_content.reference_table='hikashop_product'
198. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(22)
  AND falang_content.reference_table='hikashop_category'
199. SELECT *
  FROM iola_hikashop_category
  WHERE (category_access='all' OR category_access LIKE '%,1,%')
  AND category_published=1
  AND category_parent_id=23
200. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=23
  AND category_published=1
  AND product_type='main'
201. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(753,754,755,756,757,759,760,761,762,763,797)
  AND falang_content.reference_table='hikashop_product'
202. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(23)
  AND falang_content.reference_table='hikashop_category'
203. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=26
  AND category_published=1
  AND product_type='main'
204. SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
  WHERE (product_access='all' OR jhp.product_access LIKE '%,1,%')
  AND product_published=1
  AND jhpc.category_id=2
  AND category_published=1
  AND product_type='main'
205. UPDATE iola_xmap_sitemap
  SET views_html = views_html + 1, count_html = 50, lastvisit_html = 1701980905
  WHERE id = 1
206. SELECT params
  FROM iola_extensions AS e
  WHERE e.element='com_widgetkit'
207. SELECT extension_id AS id, element AS "option", params, enabled
  FROM iola_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_media'
208. SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM iola_modules AS m
  LEFT JOIN iola_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN iola_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-12-07 20:28:25')
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-12-07 20:28:25')
  AND m.access IN (1,1)
  AND m.client_id = 0
  AND (mm.menuid = 269 OR mm.menuid <= 0)
  AND m.language IN ('en-GB','*')
  ORDER BY m.position, m.ordering
209. SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
  WHERE falang_content.language_id=1
  AND falang_content.published=1
  AND falang_content.reference_id IN(31,32,38,86,1,143,40,122,141,149,61,137)
  AND falang_content.reference_table='modules'
210. SELECT `link`
  FROM `iola_menu`
  WHERE `published`=1
  AND `id`='193'
211. SELECT a.*
  FROM iola_hikashop_cart AS a
  WHERE (a.session_id = 'fd93986b6b52f99c9124550252e6d412')
  AND a.cart_type = 'cart'
  ORDER BY a.cart_modified DESC
  LIMIT 1
212. SELECT currency_id
  FROM iola_hikashop_currency
  WHERE currency_published=1 OR currency_id = 1
213. SELECT *
  FROM iola_hikashop_field as a
  WHERE a.`field_published` = 1
  AND a.`field_frontcomp` = 1
  AND a.field_table='item'
  AND (a.field_access = 'all' OR a.field_access LIKE '%,1,%')
  ORDER BY a.`field_ordering` ASC
214. SELECT extension_id AS id, element AS "option", params, enabled
  FROM iola_extensions
  WHERE `type` = 'component'
  AND `element` = 'com_installer'
215. SELECT `value`
  FROM `iola_admintools_storage`
  WHERE `key` = 'atoolsjupdatecheck_lastrun'
216. UPDATE `iola_session`
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1701980903;s:18:\"session.timer.last\";i:1701980903;s:17:\"session.timer.now\";i:1701980903;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:12:\"com_hikashop\";O:8:\"stdClass\":1:{s:7:\"zone_id\";s:2:\"84\";}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"a1ee93446c058a8582a9286b0428779d\";}' , `time` = '1701980905'
  WHERE `session_id` = 'fd93986b6b52f99c9124550252e6d412'

25 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 100 × SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
  FROM iola_falang_content AS falang_content
2. 37 × SELECT *
  FROM iola_hikashop_product jhp
  INNER JOIN iola_hikashop_product_category jhpc
  ON jhp.product_id=jhpc.product_id
  INNER JOIN iola_hikashop_category jhc
  ON jhc.category_id=jhpc.category_id
3. 26 × SELECT *
  FROM iola_hikashop_category
4. 16 × SELECT *
  FROM iola_menu
5. 8 × SELECT *
  FROM iola_modules
6. 8 × SELECT extension_id AS id, element AS "option", params, enabled
  FROM iola_extensions
7. 3 × SELECT n.id, n.title, n.alias, n.path, n.level, n.link, n.type, n.params, n.home, n.parent_id,n.`browserNav`
  FROM iola_menu AS n
  INNER JOIN iola_menu AS p
  ON p.lft = 0
8. 1 × SELECT `link`
  FROM `iola_menu`
9. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
  FROM iola_modules AS m
  LEFT JOIN iola_modules_menu AS mm
  ON mm.moduleid = m.id
  LEFT JOIN iola_extensions AS e
  ON e.element = m.module
  AND e.client_id = m.client_id
10. 1 × SELECT a.*
  FROM iola_hikashop_cart AS a
11. 1 × SELECT currency_id
  FROM iola_hikashop_currency
12. 1 × SELECT `value`
  FROM `iola_admintools_storage`
13. 1 × SELECT *
  FROM iola_hikashop_field as a
14. 1 × SELECT params
  FROM iola_extensions AS e
15. 1 × SELECT *
  FROM iola_languages
16. 1 × SELECT a.rules
  FROM iola_assets AS a
17. 1 × SELECT *
  FROM iola_extensions AS n
18. 1 × SELECT b.rules
  FROM iola_assets AS a
  LEFT JOIN iola_assets AS b
  ON b.lft <= a.lft
  AND b.rgt >= a.rgt
19. 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 iola_menu AS m
  LEFT JOIN iola_extensions AS e
  ON m.component_id = e.extension_id
20. 1 × SELECT a.*
  FROM iola_xmap_sitemap AS a
21. 1 × SELECT *
  FROM iola_hikashop_confi
22. 1 × SELECT joomlatablename,tablepkID
  FROM `iola_falang_tableinfo

OTHER Tables:

1. 1 × UPDATE `iola_session`
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1701980903;s:18:\"session.timer.last\";i:1701980903;s:17:\"session.timer.now\";i:1701980903;s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":1:{s:12:\"com_hikashop\";O:8:\"stdClass\":1:{s:7:\"zone_id\";s:2:\"84\";}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"a1ee93446c058a8582a9286b0428779d\";}' , `time` = '1701980905'
2. 1 × UPDATE iola_xmap_sitemap
  SET views_html = views_html + 1, count_html = 50, lastvisit_html = 1701980905
3. 1 × SHOW FULL COLUMNS
  FROM `iola_languages