Query Time: 16.35 ms

    DELETE 

      FROM `beadr_session`

      WHERE `time` < '1388078383'

    Explain
    EXPLAIN not possible on query: DELETE FROM `beadr_session` WHERE `time` < '1388078383'
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    JROOT\libraries\cms\application\cms.php:689
    JROOT\libraries\cms\application\cms.php:131
    JROOT\libraries\cms\application\administrator.php:45
    JROOT\libraries\cms\application\cms.php:332
    JROOT\libraries\joomla\factory.php:124
    JROOT\administrator\index.php:39
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.20 ms After last query: 0.25 ms

    SELECT `session_id`

      FROM `beadr_session`

      WHERE `session_id` = 'givspjnd2t89vdelpu1joeh4n2' 
      LIMIT 0, 1

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	beadr_session	const	PRIMARY	PRIMARY	602	const	1	Using index
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1320
    JROOT\libraries\cms\application\cms.php:175
    JROOT\libraries\cms\application\cms.php:698
    JROOT\libraries\cms\application\cms.php:131
    JROOT\libraries\cms\application\administrator.php:45
    JROOT\libraries\cms\application\cms.php:332
    JROOT\libraries\joomla\factory.php:124
    JROOT\administrator\index.php:39
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 21.35 ms After last query: 0.28 ms

    INSERT INTO `beadr_session`
    (`session_id`, `client_id`, `guest`, `time`, `userid`, `username`) 
      VALUES 
    ('givspjnd2t89vdelpu1joeh4n2', 1, 0, '1388077959', 258, 'condorazul')

    Explain
    EXPLAIN not possible on query: INSERT INTO `beadr_session` (`session_id`, `client_id`, `guest`, `time`, `userid`, `username`) VALUES ('givspjnd2t89vdelpu1joeh4n2', 1, 0, '1388077959', 258, 'condorazul')
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    JROOT\libraries\cms\application\cms.php:207
    JROOT\libraries\cms\application\cms.php:698
    JROOT\libraries\cms\application\cms.php:131
    JROOT\libraries\cms\application\administrator.php:45
    JROOT\libraries\cms\application\cms.php:332
    JROOT\libraries\joomla\factory.php:124
    JROOT\administrator\index.php:39
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.36 ms After last query: 7.92 ms

    SELECT extension_id AS id, element AS "option", params, enabled

      FROM beadr_extensions

      WHERE `type` = 'component' 
      AND `element` = 'com_languages'

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	beadr_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1242
    JROOT\libraries\joomla\cache\controller\callback.php:158
    JROOT\libraries\cms\component\helper.php:395
    JROOT\libraries\cms\component\helper.php:43
    JROOT\libraries\cms\component\helper.php:91
    JROOT\libraries\cms\application\administrator.php:263
    JROOT\libraries\cms\application\administrator.php:116
    JROOT\libraries\cms\application\cms.php:255
    JROOT\administrator\index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 1.25 ms After last query: 12.55 ms

    SELECT folder AS type, element AS name, params

      FROM beadr_extensions

      WHERE enabled >= 1 
      AND type ='plugin' 
      AND state >= 0 
      AND access IN (1,1,2,3)

      ORDER BY ordering

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	beadr_extensions	ref	extension	extension	62	const	164	Using where; Using filesort
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1281
    JROOT\libraries\cms\plugin\helper.php:312
    JROOT\libraries\cms\plugin\helper.php:88
    JROOT\libraries\cms\plugin\helper.php:130
    JROOT\libraries\cms\application\cms.php:573
    JROOT\libraries\cms\application\administrator.php:285
    JROOT\libraries\cms\application\administrator.php:116
    JROOT\libraries\cms\application\cms.php:255
    JROOT\administrator\index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.37 ms After last query: 43.49 ms

    SELECT extension_id AS id, element AS "option", params, enabled

      FROM beadr_extensions

      WHERE `type` = 'component' 
      AND `element` = 'com_widgetkit'

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	beadr_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1242
    JROOT\libraries\joomla\cache\controller\callback.php:158
    JROOT\libraries\cms\component\helper.php:395
    JROOT\libraries\cms\component\helper.php:43
    JROOT\plugins\system\widgetkit_joomla\widgetkit_joomla.php:32
    JROOT\libraries\joomla\event\event.php:71
    JROOT\libraries\joomla\event\dispatcher.php:162
    JROOT\libraries\joomla\application\base.php:106
    JROOT\libraries\cms\application\cms.php:587
    JROOT\libraries\cms\application\administrator.php:285
    JROOT\libraries\cms\application\administrator.php:116
    JROOT\libraries\cms\application\cms.php:255
    JROOT\administrator\index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.36 ms After last query: 6.14 ms

    SELECT extension_id AS id, element AS "option", params, enabled

      FROM beadr_extensions

      WHERE `type` = 'component' 
      AND `element` = 'com_zoo'

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	beadr_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	Using where
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1242
    JROOT\libraries\joomla\cache\controller\callback.php:158
    JROOT\libraries\cms\component\helper.php:395
    JROOT\libraries\cms\component\helper.php:43
    JROOT\plugins\system\widgetkit_zoo\widgetkit_zoo.php:37
    JROOT\libraries\joomla\event\event.php:71
    JROOT\libraries\joomla\event\dispatcher.php:162
    JROOT\libraries\joomla\application\base.php:106
    JROOT\libraries\cms\application\cms.php:587
    JROOT\libraries\cms\application\administrator.php:285
    JROOT\libraries\cms\application\administrator.php:116
    JROOT\libraries\cms\application\cms.php:255
    JROOT\administrator\index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.34 ms After last query: 54.94 ms

    SELECT extension_id AS id, element AS "option", params, enabled

      FROM beadr_extensions

      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	beadr_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	Using where
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1242
    JROOT\libraries\joomla\cache\controller\callback.php:158
    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:179
    JROOT\libraries\joomla\factory.php:734
    JROOT\libraries\joomla\factory.php:215
    JROOT\plugins\system\sef\sef.php:30
    JROOT\libraries\joomla\event\event.php:71
    JROOT\libraries\joomla\event\dispatcher.php:162
    JROOT\libraries\joomla\application\base.php:106
    JROOT\libraries\cms\application\administrator.php:448
    JROOT\libraries\cms\application\administrator.php:137
    JROOT\libraries\cms\application\cms.php:255
    JROOT\administrator\index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 26.89 ms After last query: 0.36 ms

    UPDATE `beadr_extensions`

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

      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain
    EXPLAIN not possible on query: UPDATE `beadr_extensions` SET `params` = '{\"mediaversion\":\"e402244944e3c769f6037b1a66f6f506\"}' 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:230
    JROOT\libraries\cms\version\version.php:189
    JROOT\libraries\joomla\factory.php:734
    JROOT\libraries\joomla\factory.php:215
    JROOT\plugins\system\sef\sef.php:30
    JROOT\libraries\joomla\event\event.php:71
    JROOT\libraries\joomla\event\dispatcher.php:162
    JROOT\libraries\joomla\application\base.php:106
    JROOT\libraries\cms\application\administrator.php:448
    JROOT\libraries\cms\application\administrator.php:137
    JROOT\libraries\cms\application\cms.php:255
    JROOT\administrator\index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.38 ms After last query: 4.08 ms

    SELECT template, s.params

      FROM beadr_template_styles as s

      LEFT JOIN beadr_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 home = '1'

      ORDER BY home

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ref	idx_home	idx_home	21	const	2	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	cestabase.s.template,const	1	
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1242
    JROOT\libraries\cms\application\administrator.php:203
    JROOT\libraries\cms\application\administrator.php:82
    JROOT\libraries\cms\application\administrator.php:143
    JROOT\libraries\cms\application\cms.php:255
    JROOT\administrator\index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.41 ms After last query: 6.22 ms

    SELECT extension_id AS id, element AS "option", params, enabled

      FROM beadr_extensions

      WHERE `type` = 'component' 
      AND `element` = 'com_hikashop'

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	beadr_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1242
    JROOT\libraries\joomla\cache\controller\callback.php:158
    JROOT\libraries\cms\component\helper.php:395
    JROOT\libraries\cms\component\helper.php:43
    JROOT\libraries\cms\component\helper.php:73
    JROOT\libraries\cms\component\helper.php:319
    JROOT\libraries\cms\application\administrator.php:98
    JROOT\libraries\cms\application\administrator.php:143
    JROOT\libraries\cms\application\cms.php:255
    JROOT\administrator\index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 1.00 ms After last query: 24.09 ms

    SELECT * 
      FROM beadr_hikashop_config

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	beadr_hikashop_config	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	325	
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1281
    JROOT\administrator\components\com_hikashop\classes\config.php:16
    JROOT\administrator\components\com_hikashop\helpers\helper.php:837
    JROOT\administrator\components\com_hikashop\helpers\helper.php:2548
    JROOT\administrator\components\com_hikashop\hikashop.php:14
    JROOT\libraries\cms\component\helper.php:351
    JROOT\libraries\cms\component\helper.php:331
    JROOT\libraries\cms\application\administrator.php:98
    JROOT\libraries\cms\application\administrator.php:143
    JROOT\libraries\cms\application\cms.php:255
    JROOT\administrator\index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.38 ms After last query: 117.71 ms

    SELECT extension_id AS id, element AS "option", params, enabled

      FROM beadr_extensions

      WHERE `type` = 'component' 
      AND `element` = 'com_users'

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	beadr_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1242
    JROOT\libraries\joomla\cache\controller\callback.php:158
    JROOT\libraries\cms\component\helper.php:395
    JROOT\libraries\cms\component\helper.php:43
    JROOT\libraries\cms\component\helper.php:91
    JROOT\libraries\joomla\access\access.php:295
    JROOT\administrator\components\com_hikashop\helpers\helper.php:135
    JROOT\administrator\components\com_hikashop\classes\widget.php:31
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:73
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:22
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:16
    JROOT\libraries\legacy\controller\legacy.php:685
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1322
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1072
    JROOT\libraries\legacy\controller\legacy.php:722
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1310
    JROOT\administrator\components\com_hikashop\hikashop.php:54
    JROOT\libraries\cms\component\helper.php:351
    JROOT\libraries\cms\component\helper.php:331
    JROOT\libraries\cms\application\administrator.php:98
    JROOT\libraries\cms\application\administrator.php:143
    JROOT\libraries\cms\application\cms.php:255
    JROOT\administrator\index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.21 ms After last query: 0.55 ms

    SELECT a.id

      FROM beadr_user_usergroup_map AS map

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

      WHERE map.user_id = 258

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	map	ref	PRIMARY	PRIMARY	4	const	2	Using index
    1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	cestabase.map.group_id	1	Using index
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1131
    JROOT\libraries\joomla\access\access.php:336
    JROOT\administrator\components\com_hikashop\helpers\helper.php:135
    JROOT\administrator\components\com_hikashop\classes\widget.php:31
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:73
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:22
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:16
    JROOT\libraries\legacy\controller\legacy.php:685
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1322
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1072
    JROOT\libraries\legacy\controller\legacy.php:722
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1310
    JROOT\administrator\components\com_hikashop\hikashop.php:54
    JROOT\libraries\cms\component\helper.php:351
    JROOT\libraries\cms\component\helper.php:331
    JROOT\libraries\cms\application\administrator.php:98
    JROOT\libraries\cms\application\administrator.php:143
    JROOT\libraries\cms\application\cms.php:255
    JROOT\administrator\index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 21.47 ms After last query: 0.19 ms

    SELECT * 
      FROM beadr_hikashop_widget 
      WHERE widget_published=1 
      AND (widget_access = 'all' OR widget_access LIKE '%,2,%' OR widget_access LIKE '%,8,%') 
      ORDER BY widget_ordering ASC

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	beadr_hikashop_widget	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	13	Using where; Using filesort
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1281
    JROOT\administrator\components\com_hikashop\classes\widget.php:35
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:73
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:22
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:16
    JROOT\libraries\legacy\controller\legacy.php:685
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1322
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1072
    JROOT\libraries\legacy\controller\legacy.php:722
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1310
    JROOT\administrator\components\com_hikashop\hikashop.php:54
    JROOT\libraries\cms\component\helper.php:351
    JROOT\libraries\cms\component\helper.php:331
    JROOT\libraries\cms\application\administrator.php:98
    JROOT\libraries\cms\application\administrator.php:143
    JROOT\libraries\cms\application\cms.php:255
    JROOT\administrator\index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 4.17 ms After last query: 0.42 ms

    SELECT *, SUM(prod.order_product_price*prod.order_product_quantity) as Total, COUNT(a.order_id) AS quantity 
      FROM beadr_hikashop_order_product AS prod 
      LEFT JOIN beadr_hikashop_order AS a 
      on a.order_id=prod.order_id   
      WHERE a.order_type='sale' 
      AND a.order_created > 1385488183 
      AND a.order_created < 1388080183 
      GROUP BY prod.order_product_name 
      ORDER BY Total DESC  
      LIMIT 7

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	198	Using where; Using temporary; Using filesort
    1	SIMPLE	prod	ref	order_id	order_id	4	cestabase.a.order_id	1	
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1281
    JROOT\administrator\components\com_hikashop\classes\widget.php:1622
    JROOT\administrator\components\com_hikashop\classes\widget.php:951
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:83
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:22
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:16
    JROOT\libraries\legacy\controller\legacy.php:685
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1322
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1072
    JROOT\libraries\legacy\controller\legacy.php:722
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1310
    JROOT\administrator\components\com_hikashop\hikashop.php:54
    JROOT\libraries\cms\component\helper.php:351
    JROOT\libraries\cms\component\helper.php:331
    JROOT\libraries\cms\application\administrator.php:98
    JROOT\libraries\cms\application\administrator.php:143
    JROOT\libraries\cms\application\cms.php:255
    JROOT\administrator\index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 2.29 ms After last query: 0.67 ms

    SELECT COUNT(a.order_id) AS total,a.order_status AS name 
      FROM beadr_hikashop_order AS a 
      WHERE a.order_type='sale' 
      AND a.order_created > 1387475383 
      AND a.order_created < 1388080183 
      GROUP BY a.order_status

    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	198	Using where; Using temporary; Using filesort
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1281
    JROOT\administrator\components\com_hikashop\classes\widget.php:1181
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:83
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:22
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:16
    JROOT\libraries\legacy\controller\legacy.php:685
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1322
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1072
    JROOT\libraries\legacy\controller\legacy.php:722
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1310
    JROOT\administrator\components\com_hikashop\hikashop.php:54
    JROOT\libraries\cms\component\helper.php:351
    JROOT\libraries\cms\component\helper.php:331
    JROOT\libraries\cms\application\administrator.php:98
    JROOT\libraries\cms\application\administrator.php:143
    JROOT\libraries\cms\application\cms.php:255
    JROOT\administrator\index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.23 ms After last query: 0.34 ms

    SELECT category_id 
      FROM beadr_hikashop_category 
      WHERE category_type='root' 
      LIMIT 1

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	beadr_hikashop_category	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	23	Using where
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1320
    JROOT\administrator\components\com_hikashop\classes\category.php:366
    JROOT\administrator\components\com_hikashop\classes\category.php:372
    JROOT\administrator\components\com_hikashop\classes\category.php:413
    JROOT\administrator\components\com_hikashop\classes\category.php:378
    JROOT\administrator\components\com_hikashop\classes\category.php:503
    JROOT\administrator\components\com_hikashop\classes\widget.php:1446
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:83
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:22
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:16
    JROOT\libraries\legacy\controller\legacy.php:685
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1322
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1072
    JROOT\libraries\legacy\controller\legacy.php:722
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1310
    JROOT\administrator\components\com_hikashop\hikashop.php:54
    JROOT\libraries\cms\component\helper.php:351
    JROOT\libraries\cms\component\helper.php:331
    JROOT\libraries\cms\application\administrator.php:98
    JROOT\libraries\cms\application\administrator.php:143
    JROOT\libraries\cms\application\cms.php:255
    JROOT\administrator\index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.15 ms After last query: 0.16 ms

    SELECT category_id 
      FROM beadr_hikashop_category 
      WHERE category_parent_id=1 
      AND category_type='status' 
      LIMIT 1

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	beadr_hikashop_category	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	23	Using where
    Profile
    No SHOW PROFILE (maybe because there are more than 100 queries)
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1320
    JROOT\administrator\components\com_hikashop\classes\category.php:374
    JROOT\administrator\components\com_hikashop\classes\category.php:413
    JROOT\administrator\components\com_hikashop\classes\category.php:378
    JROOT\administrator\components\com_hikashop\classes\category.php:503
    JROOT\administrator\components\com_hikashop\classes\widget.php:1446
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:83
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:22
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:16
    JROOT\libraries\legacy\controller\legacy.php:685
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1322
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1072
    JROOT\libraries\legacy\controller\legacy.php:722
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1310
    JROOT\administrator\components\com_hikashop\hikashop.php:54
    JROOT\libraries\cms\component\helper.php:351
    JROOT\libraries\cms\component\helper.php:331
    JROOT\libraries\cms\application\administrator.php:98
    JROOT\libraries\cms\application\administrator.php:143
    JROOT\libraries\cms\application\cms.php:255
    JROOT\administrator\index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.22 ms After last query: 0.14 ms

    SELECT a.* 
      FROM beadr_hikashop_category AS a 
      WHERE a.category_parent_id = 4 
      ORDER BY category_ordering ASC 
      LIMIT 0, 500

    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	23	Using where; Using filesort
    Profile
    Status	Duration
    starting	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    init	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sorting result	0.0 ms
    Sending data	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1281
    JROOT\administrator\components\com_hikashop\classes\category.php:468
    JROOT\administrator\components\com_hikashop\classes\category.php:378
    JROOT\administrator\components\com_hikashop\classes\category.php:503
    JROOT\administrator\components\com_hikashop\classes\widget.php:1446
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:83
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:22
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:16
    JROOT\libraries\legacy\controller\legacy.php:685
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1322
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1072
    JROOT\libraries\legacy\controller\legacy.php:722
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1310
    JROOT\administrator\components\com_hikashop\hikashop.php:54
    JROOT\libraries\cms\component\helper.php:351
    JROOT\libraries\cms\component\helper.php:331
    JROOT\libraries\cms\application\administrator.php:98
    JROOT\libraries\cms\application\administrator.php:143
    JROOT\libraries\cms\application\cms.php:255
    JROOT\administrator\index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.98 ms After last query: 1.76 ms

    SHOW TABLES LIKE 'beadr_falang_content'

    Explain
    EXPLAIN not possible on query: SHOW TABLES LIKE 'beadr_falang_content'
    Profile
    Status	Duration
    starting	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.1 ms
    System lock	0.0 ms
    init	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    checking permissions	0.7 ms
    Sending data	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    removing tmp table	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1320
    JROOT\administrator\components\com_hikashop\helpers\translation.php:45
    JROOT\administrator\components\com_hikashop\classes\category.php:511
    JROOT\administrator\components\com_hikashop\classes\widget.php:1446
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:83
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:22
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:16
    JROOT\libraries\legacy\controller\legacy.php:685
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1322
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1072
    JROOT\libraries\legacy\controller\legacy.php:722
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1310
    JROOT\administrator\components\com_hikashop\hikashop.php:54
    JROOT\libraries\cms\component\helper.php:351
    JROOT\libraries\cms\component\helper.php:331
    JROOT\libraries\cms\application\administrator.php:98
    JROOT\libraries\cms\application\administrator.php:143
    JROOT\libraries\cms\application\cms.php:255
    JROOT\administrator\index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.76 ms After last query: 0.13 ms

    SHOW TABLES LIKE 'beadr_jf_content'

    Explain
    EXPLAIN not possible on query: SHOW TABLES LIKE 'beadr_jf_content'
    Profile
    Status	Duration
    starting	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.1 ms
    System lock	0.0 ms
    init	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    checking permissions	0.6 ms
    Sending data	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    removing tmp table	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1320
    JROOT\administrator\components\com_hikashop\helpers\translation.php:52
    JROOT\administrator\components\com_hikashop\classes\category.php:511
    JROOT\administrator\components\com_hikashop\classes\widget.php:1446
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:83
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:22
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:16
    JROOT\libraries\legacy\controller\legacy.php:685
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1322
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1072
    JROOT\libraries\legacy\controller\legacy.php:722
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1310
    JROOT\administrator\components\com_hikashop\hikashop.php:54
    JROOT\libraries\cms\component\helper.php:351
    JROOT\libraries\cms\component\helper.php:331
    JROOT\libraries\cms\application\administrator.php:98
    JROOT\libraries\cms\application\administrator.php:143
    JROOT\libraries\cms\application\cms.php:255
    JROOT\administrator\index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 13.04 ms After last query: 0.44 ms

    SELECT *, COUNT(a.order_id) AS total 
      FROM beadr_hikashop_order AS a 
      LEFT JOIN beadr_hikashop_address AS b 
      ON a.order_billing_address_id=b.address_id 
      LEFT JOIN beadr_hikashop_zone AS z 
      ON b.address_country=z.zone_namekey 
      WHERE a.order_type='sale' 
      GROUP BY z.zone_namekey

    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	198	Using where; Using temporary; Using filesort
    1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	cestabase.a.order_billing_address_id	1	
    1	SIMPLE	z	eq_ref	zone_namekey	zone_namekey	767	cestabase.b.address_country	1	
    Profile
    Status	Duration
    starting	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	1.7 ms
    System lock	0.0 ms
    init	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    Creating tmp table	1.5 ms
    executing	0.0 ms
    Copying to tmp table	8.7 ms
    Sorting result	0.0 ms
    Sending data	0.0 ms
    end	0.0 ms
    removing tmp table	0.6 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.1 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1281
    JROOT\administrator\components\com_hikashop\classes\widget.php:1181
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:83
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:22
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:16
    JROOT\libraries\legacy\controller\legacy.php:685
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1322
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1072
    JROOT\libraries\legacy\controller\legacy.php:722
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1310
    JROOT\administrator\components\com_hikashop\hikashop.php:54
    JROOT\libraries\cms\component\helper.php:351
    JROOT\libraries\cms\component\helper.php:331
    JROOT\libraries\cms\application\administrator.php:98
    JROOT\libraries\cms\application\administrator.php:143
    JROOT\libraries\cms\application\cms.php:255
    JROOT\administrator\index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 2.34 ms After last query: 0.35 ms

    SELECT b.*,a.* 
      FROM beadr_hikashop_user AS a 
      LEFT JOIN beadr_users AS b 
      ON a.user_cms_id=b.id  
      WHERE a.user_partner_activated=0 
      AND a.user_created > 1387475383 
      AND a.user_created < 1388080183 
      ORDER BY a.user_id DESC 
      LIMIT 7

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	index	NULL	PRIMARY	4	NULL	7	Using where
    1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	cestabase.a.user_cms_id	1	
    Profile
    Status	Duration
    starting	0.1 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.4 ms
    System lock	0.0 ms
    init	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sorting result	0.0 ms
    Sending data	1.5 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.1 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1281
    JROOT\administrator\components\com_hikashop\classes\widget.php:1181
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:83
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:22
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:16
    JROOT\libraries\legacy\controller\legacy.php:685
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1322
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1072
    JROOT\libraries\legacy\controller\legacy.php:722
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1310
    JROOT\administrator\components\com_hikashop\hikashop.php:54
    JROOT\libraries\cms\component\helper.php:351
    JROOT\libraries\cms\component\helper.php:331
    JROOT\libraries\cms\application\administrator.php:98
    JROOT\libraries\cms\application\administrator.php:143
    JROOT\libraries\cms\application\cms.php:255
    JROOT\administrator\index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.71 ms After last query: 0.37 ms

    SELECT b.*,a.* 
      FROM beadr_hikashop_order AS a 
      LEFT JOIN beadr_hikashop_user AS b 
      ON a.order_user_id=b.user_id  
      WHERE a.order_type='sale' 
      AND a.order_created > 1385488183 
      AND a.order_created < 1388080183 
      ORDER BY a.order_created DESC

    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	198	Using where; Using filesort
    1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	cestabase.a.order_user_id	1	
    Profile
    Status	Duration
    starting	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    init	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sorting result	0.2 ms
    Sending data	0.3 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1281
    JROOT\administrator\components\com_hikashop\classes\widget.php:1181
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:83
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:22
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:16
    JROOT\libraries\legacy\controller\legacy.php:685
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1322
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1072
    JROOT\libraries\legacy\controller\legacy.php:722
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1310
    JROOT\administrator\components\com_hikashop\hikashop.php:54
    JROOT\libraries\cms\component\helper.php:351
    JROOT\libraries\cms\component\helper.php:331
    JROOT\libraries\cms\application\administrator.php:98
    JROOT\libraries\cms\application\administrator.php:143
    JROOT\libraries\cms\application\cms.php:255
    JROOT\administrator\index.php:42
    [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.65 ms

    SELECT b.*,a.* 
      FROM beadr_hikashop_order AS a 
      LEFT JOIN beadr_hikashop_user AS b 
      ON a.order_user_id=b.user_id  
      WHERE a.order_type='sale' 
      ORDER BY a.order_created DESC 
      LIMIT 7

    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	198	Using where; Using filesort
    1	SIMPLE	b	eq_ref	PRIMARY	PRIMARY	4	cestabase.a.order_user_id	1	
    Profile
    Status	Duration
    starting	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    init	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sorting result	0.2 ms
    Sending data	0.1 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1281
    JROOT\administrator\components\com_hikashop\classes\widget.php:1181
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:83
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:22
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:16
    JROOT\libraries\legacy\controller\legacy.php:685
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1322
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1072
    JROOT\libraries\legacy\controller\legacy.php:722
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1310
    JROOT\administrator\components\com_hikashop\hikashop.php:54
    JROOT\libraries\cms\component\helper.php:351
    JROOT\libraries\cms\component\helper.php:331
    JROOT\libraries\cms\application\administrator.php:98
    JROOT\libraries\cms\application\administrator.php:143
    JROOT\libraries\cms\application\cms.php:255
    JROOT\administrator\index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.19 ms After last query: 0.43 ms

    SELECT * 
      FROM beadr_hikashop_category 
      WHERE category_id IN (2)

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	beadr_hikashop_category	const	PRIMARY	PRIMARY	4	const	1	
    Profile
    Status	Duration
    starting	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    init	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sending data	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1281
    JROOT\administrator\components\com_hikashop\classes\widget.php:352
    JROOT\administrator\components\com_hikashop\classes\widget.php:473
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:83
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:22
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:16
    JROOT\libraries\legacy\controller\legacy.php:685
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1322
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1072
    JROOT\libraries\legacy\controller\legacy.php:722
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1310
    JROOT\administrator\components\com_hikashop\hikashop.php:54
    JROOT\libraries\cms\component\helper.php:351
    JROOT\libraries\cms\component\helper.php:331
    JROOT\libraries\cms\application\administrator.php:98
    JROOT\libraries\cms\application\administrator.php:143
    JROOT\libraries\cms\application\cms.php:255
    JROOT\administrator\index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.17 ms After last query: 0.19 ms

    SELECT * 
      FROM beadr_hikashop_category 
      WHERE category_id  = '2' 
      LIMIT 1

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	beadr_hikashop_category	const	PRIMARY	PRIMARY	4	const	1	
    Profile
    Status	Duration
    starting	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    init	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sending data	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1242
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1476
    JROOT\administrator\components\com_hikashop\classes\category.php:35
    JROOT\administrator\components\com_hikashop\classes\category.php:417
    JROOT\administrator\components\com_hikashop\classes\category.php:378
    JROOT\administrator\components\com_hikashop\classes\widget.php:369
    JROOT\administrator\components\com_hikashop\classes\widget.php:473
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:83
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:22
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:16
    JROOT\libraries\legacy\controller\legacy.php:685
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1322
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1072
    JROOT\libraries\legacy\controller\legacy.php:722
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1310
    JROOT\administrator\components\com_hikashop\hikashop.php:54
    JROOT\libraries\cms\component\helper.php:351
    JROOT\libraries\cms\component\helper.php:331
    JROOT\libraries\cms\application\administrator.php:98
    JROOT\libraries\cms\application\administrator.php:143
    JROOT\libraries\cms\application\cms.php:255
    JROOT\administrator\index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.22 ms After last query: 0.16 ms

    SELECT a.* 
      FROM beadr_hikashop_category AS a 
      WHERE a.category_left > 2 
      AND a.category_right < 27 
      AND (a.category_type = 'product' OR a.category_type = 'vendor') 
      LIMIT 0, 20

    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	23	Using where
    Profile
    Status	Duration
    starting	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    init	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sending data	0.1 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1281
    JROOT\administrator\components\com_hikashop\classes\category.php:468
    JROOT\administrator\components\com_hikashop\classes\category.php:378
    JROOT\administrator\components\com_hikashop\classes\widget.php:369
    JROOT\administrator\components\com_hikashop\classes\widget.php:473
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:83
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:22
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:16
    JROOT\libraries\legacy\controller\legacy.php:685
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1322
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1072
    JROOT\libraries\legacy\controller\legacy.php:722
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1310
    JROOT\administrator\components\com_hikashop\hikashop.php:54
    JROOT\libraries\cms\component\helper.php:351
    JROOT\libraries\cms\component\helper.php:331
    JROOT\libraries\cms\application\administrator.php:98
    JROOT\libraries\cms\application\administrator.php:143
    JROOT\libraries\cms\application\cms.php:255
    JROOT\administrator\index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.09 ms After last query: 0.35 ms

    SELECT *, SUM(prod.order_product_quantity) as Total, COUNT(a.order_id) AS quantity 
      FROM beadr_hikashop_order_product AS prod 
      LEFT JOIN beadr_hikashop_order AS a 
      on a.order_id=prod.order_id   
      WHERE  > 1356544183 
      AND  < 1388080183 
      GROUP BY prod.order_product_name 
      ORDER BY Total DESC  
      LIMIT 7

    Explain
    Error
    SQL=EXPLAIN SELECT *, SUM(prod.order_product_quantity) as Total, COUNT(a.order_id) AS quantity FROM beadr_hikashop_order_product AS prod LEFT JOIN beadr_hikashop_order AS a on a.order_id=prod.order_id WHERE > 1356544183 AND < 1388080183 GROUP BY prod.order_product_name ORDER BY Total DESC LIMIT 7
    Profile
    Status	Duration
    starting	0.0 ms
    freeing items	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1281
    JROOT\administrator\components\com_hikashop\classes\widget.php:1622
    JROOT\administrator\components\com_hikashop\classes\widget.php:665
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:83
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:22
    JROOT\administrator\components\com_hikashop\views\dashboard\view.html.php:16
    JROOT\libraries\legacy\controller\legacy.php:685
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1322
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1072
    JROOT\libraries\legacy\controller\legacy.php:722
    JROOT\administrator\components\com_hikashop\helpers\helper.php:1310
    JROOT\administrator\components\com_hikashop\hikashop.php:54
    JROOT\libraries\cms\component\helper.php:351
    JROOT\libraries\cms\component\helper.php:331
    JROOT\libraries\cms\application\administrator.php:98
    JROOT\libraries\cms\application\administrator.php:143
    JROOT\libraries\cms\application\cms.php:255
    JROOT\administrator\index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.74 ms After last query: 4.70 ms

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

      FROM beadr_modules AS m

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

      LEFT JOIN beadr_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-12-26 17:49:43') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2013-12-26 17:49:43') 
      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	45	Using where; Using filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	cestabase.m.id	1	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	cestabase.m.module,const	1	Using where
    Profile
    Status	Duration
    starting	0.1 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    init	0.0 ms
    optimizing	0.0 ms
    statistics	0.1 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sorting result	0.1 ms
    Sending data	0.2 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1281
    JROOT\libraries\cms\module\helper.php:362
    JROOT\libraries\cms\module\helper.php:84
    JROOT\administrator\templates\isis\error.php:34
    JROOT\libraries\joomla\document\error\error.php:135
    JROOT\libraries\joomla\document\error\error.php:107
    JROOT\libraries\legacy\error\error.php:791
    JROOT\plugins\system\redirect\redirect.php:121
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 2.97 ms After last query: 25.24 ms

    SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native

      FROM beadr_menu_types AS a

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

      LEFT JOIN beadr_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	5	Using temporary; Using filesort
    1	SIMPLE	b	ref	idx_menutype	idx_menutype	74	cestabase.a.menutype	13	Using where
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	21	cestabase.b.language	1	
    Profile
    Status	Duration
    starting	0.1 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    init	0.0 ms
    optimizing	0.0 ms
    statistics	0.0 ms
    preparing	0.0 ms
    Creating tmp table	1.3 ms
    executing	0.0 ms
    Copying to tmp table	0.7 ms
    Sorting result	0.0 ms
    Sending data	0.0 ms
    end	0.0 ms
    removing tmp table	0.5 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1281
    JROOT\administrator\modules\mod_menu\helper.php:47
    JROOT\administrator\modules\mod_menu\tmpl\default_enabled.php:139
    JROOT\administrator\modules\mod_menu\tmpl\default.php:14
    JROOT\administrator\modules\mod_menu\mod_menu.php:30
    JROOT\libraries\cms\module\helper.php:177
    JROOT\administrator\templates\isis\error.php:170
    JROOT\libraries\joomla\document\error\error.php:135
    JROOT\libraries\joomla\document\error\error.php:107
    JROOT\libraries\legacy\error\error.php:791
    JROOT\plugins\system\redirect\redirect.php:121
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.97 ms After last query: 1.67 ms

    SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element

      FROM beadr_menu AS m

      LEFT JOIN beadr_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	35	Using where; Using filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	cestabase.m.component_id	1	Using where
    Profile
    Status	Duration
    starting	0.1 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    init	0.0 ms
    optimizing	0.0 ms
    statistics	0.1 ms
    preparing	0.0 ms
    executing	0.0 ms
    Sorting result	0.2 ms
    Sending data	0.3 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.1 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT\libraries\joomla\database\driver.php:1281
    JROOT\administrator\modules\mod_menu\helper.php:85
    JROOT\administrator\modules\mod_menu\tmpl\default_enabled.php:241
    JROOT\administrator\modules\mod_menu\tmpl\default.php:14
    JROOT\administrator\modules\mod_menu\mod_menu.php:30
    JROOT\libraries\cms\module\helper.php:177
    JROOT\administrator\templates\isis\error.php:170
    JROOT\libraries\joomla\document\error\error.php:135
    JROOT\libraries\joomla\document\error\error.php:107
    JROOT\libraries\legacy\error\error.php:791
    JROOT\plugins\system\redirect\redirect.php:121
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

24 Tipos de consultas del registro, Ordenado por acontecimientos.
SELECCIONAR Tablas:

    6 × SELECT extension_id AS id, element AS "option", params, enabled
     
      FROM beadr_extensions

    2 × SELECT b.*,a.* 
      FROM beadr_hikashop_order AS a 
      LEFT JOIN beadr_hikashop_user AS b 
      ON a.order_user_id=b.user_id

    2 × SELECT * 
      FROM beadr_hikashop_category

    2 × SELECT a.* 
      FROM beadr_hikashop_category AS a

    2 × SELECT category_id 
      FROM beadr_hikashop_category

    1 × SELECT folder AS type, element AS name, params
     
      FROM beadr_extensions

    1 × SELECT template, s.params
     
      FROM beadr_template_styles as s
     
      LEFT JOIN beadr_extensions as e 
      ON e.type='template' 
      AND e.element=s.template 
      AND e.client_id=s.client_id

    1 × SELECT *, SUM(prod.order_product_quantity) as Total, COUNT(a.order_id) AS quantity 
      FROM beadr_hikashop_order_product AS prod 
      LEFT JOIN beadr_hikashop_order AS a 
      on a.order_id=prod.order_id

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

    1 × SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element
     
      FROM beadr_menu AS m
     
      LEFT JOIN beadr_extensions AS e 
      ON m.component_id = e.extension_id

    1 × SELECT a.*, SUM(b.home) AS home,b.language,l.image,l.sef,l.title_native
     
      FROM beadr_menu_types AS a
     
      LEFT JOIN beadr_menu AS b 
      ON b.menutype = a.menutype 
      AND b.home != 0
     
      LEFT JOIN beadr_languages AS l 
      ON l.lang_code = language

    1 × SELECT b.*,a.* 
      FROM beadr_hikashop_user AS a 
      LEFT JOIN beadr_users AS b 
      ON a.user_cms_id=b.id

    1 × SELECT *, COUNT(a.order_id) AS total 
      FROM beadr_hikashop_order AS a 
      LEFT JOIN beadr_hikashop_address AS b 
      ON a.order_billing_address_id=b.address_id 
      LEFT JOIN beadr_hikashop_zone AS z 
      ON b.address_country=z.zone_namekey

    1 × SELECT *, SUM(prod.order_product_price*prod.order_product_quantity) as Total, COUNT(a.order_id) AS quantity 
      FROM beadr_hikashop_order_product AS prod 
      LEFT JOIN beadr_hikashop_order AS a 
      on a.order_id=prod.order_id

    1 × SELECT * 
      FROM beadr_hikashop_widget

    1 × SELECT COUNT(a.order_id) AS total,a.order_status AS name 
      FROM beadr_hikashop_order AS a

    1 × SELECT `session_id`
     
      FROM `beadr_session`

    1 × SELECT * 
      FROM beadr_hikashop_confi

    1 × SELECT a.id
     
      FROM beadr_user_usergroup_map AS map
     
      LEFT JOIN beadr_usergroups AS a 
      ON a.id = map.group_id

OTRAS Tablas:

    1 × SHOW TABLES LIKE 'beadr_jf_content

    1 × SHOW TABLES LIKE 'beadr_falang_content

    1 × UPDATE `beadr_extensions`
     
      SET `params` = '{\"mediaversion\":\"e402244944e3c769f6037b1a66f6f506\"}'

    1 × INSERT INTO `beadr_session`
     (`session_id`, `client_id`, `guest`, `time`, `userid`, `username`) 
      VALUES 
     ('givspjnd2t89vdelpu1joeh4n2', 1, 0, '1388077959', 258, 'condorazul'

    1 × DELETE 
     
      FROM `beadr_session`