44 Queries Logged 10.7 ms

6 duplicate found!
2 duplicates: #2  #10
2 duplicates: #4  #5
2 duplicates: #6  #7
Query Time: 0.39 ms Query memory: 0.014 MB Memory before query: 3.427 MB Rows returned: 1
SELECT `data`

  FROM `hyky_session`

  WHERE `session_id` = '67d05cf5b06ad6a0968962cf8526cf25'
Explain
Profile
Call Stack
Query Time: 0.34 ms After last query: 24.42 ms Query memory: 0.013 MB Memory before query: 6.092 MB Rows returned: 1
Duplicate queries: #10
SELECT `value`

  FROM `hyky_admintools_storage`

  WHERE `key` = 'cparams'
Explain
Profile
Call Stack
Query Time: 0.13 ms After last query: 9.31 ms Query memory: 0.012 MB Memory before query: 7.302 MB Rows returned: 0
SELECT `query`

  FROM `hyky_admintools_wafexceptions`

  WHERE (`option` IS NULL OR `option` = '' OR `option` = 'com_hikashop') 
  AND (`view` IS NULL OR `view` = '')

  GROUP BY `query`

  ORDER BY `query` ASC
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
Profile
Call Stack
Query Time: 0.23 ms After last query: 17.41 ms Query memory: 0.010 MB Memory before query: 8.864 MB Rows returned: 1
Duplicate queries: #5
SELECT `enabled`

  FROM `hyky_extensions`

  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'
Explain
Profile
Call Stack
Query Time: 0.19 ms After last query: 29.01 ms Query memory: 0.010 MB Memory before query: 12.494 MB Rows returned: 1
Duplicate queries: #4
SELECT `enabled`

  FROM `hyky_extensions`

  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'
Explain
Profile
Call Stack
Query Time: 0.18 ms After last query: 26.90 ms Query memory: 0.016 MB Memory before query: 14.285 MB Rows returned: 1
Duplicate queries: #7
SELECT template

  FROM hyky_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	10	Using where
Profile
Call Stack
Query Time: 0.10 ms After last query: 0.22 ms Query memory: 0.017 MB Memory before query: 14.301 MB Rows returned: 1
Duplicate queries: #6
SELECT template

  FROM hyky_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	10	Using where
Profile
Call Stack
Query Time: 0.22 ms After last query: 9.49 ms Query memory: 0.011 MB Memory before query: 14.721 MB Rows returned: 2
SELECT extension, file, type

  FROM hyky_rokcommon_configs

  ORDER BY priority
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hyky_rokcommon_configs	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using filesort
Profile
Call Stack
Query Time: 0.15 ms After last query: 3.85 ms Query memory: 0.013 MB Memory before query: 14.890 MB Rows returned: 0
SELECT *

  FROM `hyky_admintools_ipautoban`

  WHERE `ip` = '95.195.214.169'
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
Profile
Call Stack
Query Time: 0.16 ms After last query: 0.24 ms Query memory: 0.014 MB Memory before query: 14.902 MB Rows returned: 1
Duplicate queries: #2
SELECT `value`

  FROM `hyky_admintools_storage`

  WHERE `key` = 'cparams'
Explain
Profile
Call Stack
Query Time: 0.50 ms After last query: 1.30 ms Query memory: 0.014 MB Memory before query: 14.953 MB Rows returned: 1
SELECT `custom_data` 
  FROM `hyky_extensions` 
  WHERE `type` = 'component' 
  AND `element` = 'com_sef'
Explain
Profile
Call Stack
Query Time: 0.71 ms After last query: 25.34 ms Query memory: 0.007 MB Memory before query: 16.609 MB Rows returned: 1
SELECT template, s.params

  FROM hyky_template_styles as s

  LEFT JOIN hyky_extensions as e 
  ON e.type='template' 
  AND e.element=s.template 
  AND e.client_id=s.client_id

  WHERE s.client_id = 1 
  AND id = 118 
  AND e.enabled = 1 OR s.client_id = 1 
  AND home = '1'

  ORDER BY home
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	PRIMARY,idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	10	Using where; Using filesort
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	magnetco_magnet3a.s.template,magnetco_magnet3a.s.client_id	1	Using where
Profile
Call Stack
Query Time: 0.72 ms After last query: 24.42 ms Query memory: 0.012 MB Memory before query: 19.036 MB Rows returned: 469
SELECT * 
  FROM hyky_hikashop_config
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hyky_hikashop_config	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	469	
Profile
Call Stack
Query Time: 0.24 ms After last query: 74.36 ms Query memory: 0.022 MB Memory before query: 26.318 MB Rows returned: 1
SELECT a.id

  FROM hyky_user_usergroup_map AS map

  LEFT JOIN hyky_usergroups AS a 
  ON a.id = map.group_id

  WHERE map.user_id = 4
Explain
Profile
Call Stack
Query Time: 0.36 ms After last query: 12.77 ms Query memory: 0.017 MB Memory before query: 27.701 MB
SELECT * 
  FROM hyky_hikashop_field as a 
  WHERE a.`field_published` = 1 
  AND a.`all`=1 
  AND a.field_table='
  order' 
  AND (a.field_access = 'all' OR a.field_access LIKE '%,8,%')  
  ORDER BY a.`field_ordering` ASC
Explain
Error
Unknown column 'a.all' in 'where clause' SQL=EXPLAIN SELECT * FROM hyky_hikashop_field as a WHERE a.`field_published` = 1 AND a.`all`=1 AND a.field_table='order' AND (a.field_access = 'all' OR a.field_access LIKE '%,8,%') ORDER BY a.`field_ordering` ASC
Profile
Call Stack
Query Time: 1.24 ms After last query: 3.94 ms Query memory: 0.012 MB Memory before query: 27.942 MB Rows returned: 14
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM hyky_modules AS m

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

  LEFT JOIN hyky_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 <= '2013-10-14 05:00:16') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2013-10-14 05:00:16') 
  AND m.access IN (1,1,2,3) 
  AND m.client_id = 1 
  AND (mm.menuid = 0 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	44	Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	magnetco_magnet3a.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	magnetco_magnet3a.m.module,const	1	Using where
Profile
Call Stack
Query Time: 0.21 ms After last query: 18.01 ms Query memory: 0.016 MB Memory before query: 28.547 MB Rows returned: 15
SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native

  FROM hyky_menu_types AS a

  LEFT JOIN hyky_menu AS b 
  ON b.menutype = a.menutype 
  AND b.home != 0

  LEFT JOIN hyky_languages AS l 
  ON l.lang_code = language

  WHERE (b.client_id = 0 OR b.client_id IS NULL)

  GROUP BY a.id, a.menutype, a.description, a.title, b.menutype,b.language,l.image,l.sef,l.title_native
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	15	Using temporary; Using filesort
1	SIMPLE	b	ref	idx_menutype	idx_menutype	74	magnetco_magnet3a.a.menutype	5	Using where
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	21	magnetco_magnet3a.b.language	1	
Profile
Call Stack
Query Time: 1.55 ms After last query: 4.29 ms Query memory: 0.016 MB Memory before query: 28.637 MB Rows returned: 88
SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element

  FROM hyky_menu AS m

  LEFT JOIN hyky_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.client_id = 1 
  AND e.enabled = 1 
  AND m.id > 1

  ORDER BY m.lft
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,idx_client_id_parent_id_alias_language,idx_componentid	idx_client_id_parent_id_alias_language	1	const	91	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	magnetco_magnet3a.m.component_id	1	Using where
Profile
Call Stack
Query Time: 0.24 ms After last query: 121.05 ms Query memory: 0.012 MB Memory before query: 28.916 MB Rows returned: 1
SELECT COUNT(*)

  FROM hyky_messages

  WHERE state = 0 
  AND user_id_to = 4
Explain
Profile
Call Stack
Query Time: 0.42 ms After last query: 0.21 ms Query memory: 0.012 MB Memory before query: 28.928 MB Rows returned: 1
SELECT COUNT(session_id)

  FROM hyky_session

  WHERE guest = 0 
  AND client_id = 1
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hyky_session	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	13	Using where
Profile
Call Stack
Query Time: 0.23 ms After last query: 0.41 ms Query memory: 0.012 MB Memory before query: 28.941 MB Rows returned: 1
SELECT COUNT(session_id)

  FROM hyky_session

  WHERE guest = 0 
  AND client_id = 0
Explain
id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hyky_session	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	13	Using where
Profile
Call Stack
Query Time: 2.17 ms After last query: 1.54 ms Query memory: 0.003 MB Memory before query: 28.866 MB
UPDATE `hyky_session`

  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:32;s:19:\"session.timer.start\";i:1381725281;s:18:\"session.timer.last\";i:1381726806;s:17:\"session.timer.now\";i:1381726816;s:22:\"session.client.browser\";s:108:\"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/30.0.1599.69 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":5:{s:13:\"com_installer\";O:8:\"stdClass\":3:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";s:6:\"update\";O:8:\"stdClass\":1:{s:10:\"limitstart\";s:1:\"0\";}}s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"
  limit\";i:0;}}s:11:\"com_checkin\";O:8:\"stdClass\":1:{s:7:\"checkin\";O:8:\"stdClass\":1:{s:8:\"ordercol\";s:5:\"table\";}}s:12:\"com_hikashop\";O:8:\"stdClass\":2:{s:7:\"product\";O:8:\"stdClass\":2:{s:10:\"limitstart\";i:0;s:9:\"filter_id\";s:2:\"62\";}s:5:\"
  order\";O:8:\"stdClass\":1:{s:14:\"filter_partner\";i:0;}}}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:1:\"4\";s:4:\"name\";s:13:\"Simon Bayliss\";s:8:\"username\";s:10:\"admin-mgnt\";s:5:\"email\";s:24:\"studio09@lumieres.com.au\";s:8:\"password\";s:65:\"8ccb94bf1b384e90dc3903da951dc370:sULoJaVLzy7nVeTHKCiWMVqUidMzJkHC\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2012-11-18 22:55:54\";s:13:\"lastvisitDate\";s:19:\"2013-10-14 04:08:13\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:218:\"{\"admin_style\":\"118\",\"admin_language\":\"en-GB\",\"language\":\"en-GB\",\"editor\":\"jce\",\"helpsite\":\"http:\\/\\/help.joomla.org\\/proxy\\/index.php?option=com_help&keyref=Help{major}{minor}:{keyref}\",\"timezone\":\"Australia\\/Sydney\"}\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:3:\"118\";s:14:\"admin_language\";s:5:\"en-GB\";s:8:\"language\";s:5:\"en-GB\";s:6:\"editor\";s:3:\"jce\";s:8:\"helpsite\";s:89:\"http://help.joomla.org/proxy/index.php?option=com_help&keyref=Help{major}{minor}:{keyref}\";s:8:\"timezone\";s:16:\"Australia/Sydney\";}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"0ea246277770173f8a7134105a5363fe\";}__wf|a:1:{s:13:\"session.token\";s:32:\"2598377d57ad252afcdae73ce5325752\";}'
	, `time` = '1381726817'

  WHERE `session_id` = '67d05cf5b06ad6a0968962cf8526cf25'
Explain
Profile
Call Stack
18 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
2 × SELECT `enabled` 
  FROM `hyky_extensions`
2 × SELECT COUNT(session_id) 
  FROM hyky_session
2 × SELECT template 
  FROM hyky_template_styles as s
2 × SELECT `value` 
  FROM `hyky_admintools_storage`
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM hyky_modules AS m 
  LEFT JOIN hyky_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN hyky_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id
1 × SELECT * 
  FROM hyky_hikashop_field as a
1 × SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native 
  FROM hyky_menu_types AS a 
  LEFT JOIN hyky_menu AS b 
  ON b.menutype = a.menutype 
  AND b.home != 0 
  LEFT JOIN hyky_languages AS l 
  ON l.lang_code = language
1 × SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element 
  FROM hyky_menu AS m 
  LEFT JOIN hyky_extensions AS e 
  ON m.component_id = e.extension_id
1 × SELECT a.id 
  FROM hyky_user_usergroup_map AS map 
  LEFT JOIN hyky_usergroups AS a 
  ON a.id = map.group_id
1 × SELECT COUNT(*) 
  FROM hyky_messages
1 × SELECT template, s.params 
  FROM hyky_template_styles as s 
  LEFT JOIN hyky_extensions as e 
  ON e.type='template' 
  AND e.element=s.template 
  AND e.client_id=s.client_id
1 × SELECT extension, file, type 
  FROM hyky_rokcommon_configs
1 × SELECT `query` 
  FROM `hyky_admintools_wafexceptions`
1 × SELECT * 
  FROM `hyky_admintools_ipautoban`
1 × SELECT `custom_data` 
  FROM `hyky_extensions`
1 × SELECT `data` 
  FROM `hyky_session`
1 × SELECT * 
  FROM hyky_hikashop_confi
OTHER Tables:
1 × UPDATE `hyky_session` 
  SET `data` = '__default|a:8:{s:15:\"session.counter\";i:32;s:19:\"session.timer.start\";i:1381725281;s:18:\"session.timer.last\";i:1381726806;s:17:\"session.timer.now\";i:1381726816;s:22:\"session.client.browser\";s:108:\"Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/30.0.1599.69 Safari/537.36\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":5:{s:13:\"com_installer\";O:8:\"stdClass\":3:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";s:6:\"update\";O:8:\"stdClass\":1:{s:10:\"limitstart\";s:1:\"0\";}}s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:0:\"\";}s:6:\"global\";O:8:\"stdClass\":1:{s:4:\"list\";O:8:\"stdClass\":1:{s:5:\"
  limit\";i:0;}}s:11:\"com_checkin\";O:8:\"stdClass\":1:{s:7:\"checkin\";O:8:\"stdClass\":1:{s:8:\"ordercol\";s:5:\"table\";}}s:12:\"com_hikashop\";O:8:\"stdClass\":2:{s:7:\"product\";O:8:\"stdClass\":2:{s:10:\"limitstart\";i:0;s:9:\"filter_id\";s:2:\"62\";}s:5:\"
  order\";O:8:\"stdClass\":1:{s:14:\"filter_partner\";i:0;}}}}s:4:\"user\";O:5:\"JUser\":24:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:1:\"4\";s:4:\"name\";s:13:\"Simon Bayliss\";s:8:\"username\";s:10:\"admin-mgnt\";s:5:\"email\";s:24:\"studio09@lumieres.com.au\";s:8:\"password\";s:65:\"8ccb94bf1b384e90dc3903da951dc370:sULoJaVLzy7nVeTHKCiWMVqUidMzJkHC\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2012-11-18 22:55:54\";s:13:\"lastvisitDate\";s:19:\"2013-10-14 04:08:13\";s:10:\"activation\";s:0:\"\";s:6:\"params\";s:218:\"{\"admin_style\":\"118\",\"admin_language\":\"en-GB\",\"language\":\"en-GB\",\"editor\":\"jce\",\"helpsite\":\"http:\\/\\/help.joomla.org\\/proxy\\/index.php?option=com_help&keyref=Help{major}{minor}:{keyref}\",\"timezone\":\"Australia\\/Sydney\"}\";s:6:\"groups\";a:1:{i:8;s:1:\"8\";}s:5:\"guest\";i:0;s:13:\"lastResetTime\";s:19:\"0000-00-00 00:00:00\";s:10:\"resetCount\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:3:\"118\";s:14:\"admin_language\";s:5:\"en-GB\";s:8:\"language\";s:5:\"en-GB\";s:6:\"editor\";s:3:\"jce\";s:8:\"helpsite\";s:89:\"http://help.joomla.org/proxy/index.php?option=com_help&keyref=Help{major}{minor}:{keyref}\";s:8:\"timezone\";s:16:\"Australia/Sydney\";}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"0ea246277770173f8a7134105a5363fe\";}__wf|a:1:{s:13:\"session.token\";s:32:\"2598377d57ad252afcdae73ce5325752\";}'  , `time` = '1381726817'