teste

Database Queries
38 Queries Logged 8.9 ms

6 duplicate found!
2 duplicates: #11  #12
2 duplicates: #17  #18
2 duplicates: #27  #29

    Query Time: 0.24 ms Query memory: 0.013 MB Memory before query: 2.317 MB Rows returned: 1

    SELECT `data`

      FROM `an1sp0t_session`

      WHERE `session_id` = '94ede3bdf9b6946f4c5a6bc3f10bb5e2'

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	an1sp0t_session	const	PRIMARY	PRIMARY	602	const	1
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.1 ms
    System lock	0.0 ms
    Waiting for query cache 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
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    storing result in query cache	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT/libraries/joomla/session/storage/database.php:46
    JROOT/libraries/joomla/session/session.php:658
    JROOT/libraries/joomla/session/session.php:596
    JROOT/libraries/cms/application/cms.php:672
    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.44 ms After last query: 6.69 ms Query memory: 0.011 MB Memory before query: 3.040 MB Rows returned: 49

    SELECT folder AS type, element AS name, params

      FROM an1sp0t_extensions

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

      ORDER BY ordering

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	an1sp0t_extensions	ref	extension	extension	62	const	63	Using where; Using filesort
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    Waiting for query cache 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.1 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
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    storing result in query cache	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    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:301
    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.13 ms After last query: 6.06 ms Query memory: 0.011 MB Memory before query: 3.933 MB Rows returned: 1

    SELECT `enabled`

      FROM `an1sp0t_extensions`

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

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	an1sp0t_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    Waiting for query cache 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
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    storing result in query cache	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT/plugins/system/srp/srp.php:47
    JROOT/libraries/cms/plugin/helper.php:232
    JROOT/libraries/cms/plugin/helper.php:172
    JROOT/libraries/cms/application/cms.php:586
    JROOT/libraries/cms/application/administrator.php:301
    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.14 ms After last query: 8.44 ms Query memory: 0.017 MB Memory before query: 4.630 MB Rows returned: 1

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

      FROM an1sp0t_extensions

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

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	an1sp0t_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    Waiting for query cache 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
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    storing result in query cache	0.1 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT/libraries/joomla/cache/controller/callback.php:158
    JROOT/libraries/cms/component/helper.php:396
    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:301
    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.14 ms After last query: 3.44 ms Query memory: 0.021 MB Memory before query: 4.954 MB Rows returned: 1

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

      FROM an1sp0t_extensions

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

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	an1sp0t_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	Using where
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    Waiting for query cache 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
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    storing result in query cache	0.1 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    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:464
    JROOT/libraries/cms/application/administrator.php:153
    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.20 ms After last query: 0.20 ms Query memory: 0.017 MB Memory before query: 4.961 MB

    UPDATE `an1sp0t_extensions`

      SET `params` = '{\"mediaversion\":\"73e7ec1d21dbffbc91f7ef5e4faad250\"}'

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

    Explain
    EXPLAIN not possible on query: UPDATE `an1sp0t_extensions` SET `params` = '{\"mediaversion\":\"73e7ec1d21dbffbc91f7ef5e4faad250\"}' WHERE `type` = 'library' AND `element` = 'joomla'
    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
    Updating	0.0 ms
    end	0.0 ms
    Waiting for query cache lock	0.0 ms
    end	0.6 ms
    query end	0.5 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/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:464
    JROOT/libraries/cms/application/administrator.php:153
    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: 1.53 ms Query memory: 0.008 MB Memory before query: 5.178 MB Rows returned: 1

    SELECT template, s.params

      FROM an1sp0t_template_styles as s

      LEFT JOIN an1sp0t_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	anispotc_bd.s.template,const	1
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    Waiting for query cache 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
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    storing result in query cache	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT/libraries/cms/application/administrator.php:219
    JROOT/libraries/cms/application/administrator.php:82
    JROOT/libraries/cms/application/administrator.php:159
    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.14 ms After last query: 1.28 ms Query memory: 0.013 MB Memory before query: 5.252 MB Rows returned: 1

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

      FROM an1sp0t_extensions

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

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	an1sp0t_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    Waiting for query cache 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
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    storing result in query cache	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT/libraries/joomla/cache/controller/callback.php:158
    JROOT/libraries/cms/component/helper.php:396
    JROOT/libraries/cms/component/helper.php:43
    JROOT/libraries/cms/component/helper.php:73
    JROOT/libraries/cms/component/helper.php:320
    JROOT/libraries/cms/application/administrator.php:98
    JROOT/libraries/cms/application/administrator.php:159
    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.45 ms After last query: 5.42 ms Query memory: 0.016 MB Memory before query: 5.756 MB Rows returned: 11

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

      FROM an1sp0t_modules AS m

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

      LEFT JOIN an1sp0t_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 <= '2014-05-27 11:31:20')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2014-05-27 11:31:20')
      AND m.access IN (1,1,2,3,6)
      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	ALL	PRIMARY,published,newsfeeds	NO INDEX KEY COULD BE USED	NULL	NULL	23	Using where; Using filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	anispotc_bd.m.id	1	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	anispotc_bd.m.module,const	1	Using where
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.1 ms
    System lock	0.0 ms
    Waiting for query cache 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.1 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    storing result in query cache	0.1 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT/libraries/cms/module/helper.php:376
    JROOT/libraries/cms/module/helper.php:84
    JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:50
    JROOT/libraries/legacy/controller/legacy.php:685
    JROOT/libraries/legacy/controller/legacy.php:722
    JROOT/administrator/components/com_cpanel/cpanel.php:15
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/administrator.php:98
    JROOT/libraries/cms/application/administrator.php:159
    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.30 ms After last query: 13.93 ms Query memory: 0.024 MB Memory before query: 7.366 MB Rows returned: 75

    SHOW TABLES

    Explain
    EXPLAIN not possible on query: SHOW TABLES
    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
    checking permissions	0.2 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/fof/table/table.php:2041
    JROOT/libraries/fof/table/table.php:529
    JROOT/libraries/fof/table/table.php:426
    JROOT/libraries/fof/model/model.php:1963
    JROOT/libraries/fof/model/model.php:1920
    JROOT/libraries/fof/model/model.php:1987
    JROOT/administrator/components/com_postinstall/models/messages.php:32
    JROOT/libraries/fof/model/model.php:1152
    JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:59
    JROOT/libraries/legacy/controller/legacy.php:685
    JROOT/libraries/legacy/controller/legacy.php:722
    JROOT/administrator/components/com_cpanel/cpanel.php:15
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/administrator.php:98
    JROOT/libraries/cms/application/administrator.php:159
    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.64 ms After last query: 0.14 ms Query memory: 0.024 MB Memory before query: 7.405 MB Rows returned: 14
    Duplicate queries: #12

    SHOW FULL COLUMNS
      FROM `an1sp0t_postinstall_messages`

    Explain
    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `an1sp0t_postinstall_messages`
    Profile
    Status	Duration
    starting	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.2 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
    Opening tables	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Sending data	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    removing tmp table	0.1 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/fof/table/table.php:2126
    JROOT/libraries/fof/table/table.php:529
    JROOT/libraries/fof/table/table.php:426
    JROOT/libraries/fof/model/model.php:1963
    JROOT/libraries/fof/model/model.php:1920
    JROOT/libraries/fof/model/model.php:1987
    JROOT/administrator/components/com_postinstall/models/messages.php:32
    JROOT/libraries/fof/model/model.php:1152
    JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:59
    JROOT/libraries/legacy/controller/legacy.php:685
    JROOT/libraries/legacy/controller/legacy.php:722
    JROOT/administrator/components/com_cpanel/cpanel.php:15
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/administrator.php:98
    JROOT/libraries/cms/application/administrator.php:159
    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.42 ms After last query: 3.95 ms Query memory: 0.024 MB Memory before query: 7.661 MB Rows returned: 14
    Duplicate queries: #11

    SHOW FULL COLUMNS
      FROM `an1sp0t_postinstall_messages`

    Explain
    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `an1sp0t_postinstall_messages`
    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
    Opening tables	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 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/fof/model/model.php:2049
    JROOT/libraries/fof/model/behavior/filters.php:35
    JROOT/libraries/fof/utils/observable/event.php:63
    JROOT/libraries/fof/utils/observable/dispatcher.php:146
    JROOT/libraries/fof/model/model.php:2033
    JROOT/administrator/components/com_postinstall/models/messages.php:32
    JROOT/libraries/fof/model/model.php:1152
    JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:59
    JROOT/libraries/legacy/controller/legacy.php:685
    JROOT/libraries/legacy/controller/legacy.php:722
    JROOT/administrator/components/com_cpanel/cpanel.php:15
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/administrator.php:98
    JROOT/libraries/cms/application/administrator.php:159
    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.05 ms After last query: 10.85 ms Query memory: 0.016 MB Memory before query: 7.946 MB Rows returned: 2

    SELECT `an1sp0t_postinstall_messages`.*

      FROM `an1sp0t_postinstall_messages`

      WHERE `extension_id` = '700'
      AND `enabled` = '1'

      ORDER BY `postinstall_message_id` ASC

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	an1sp0t_postinstall_messages	index	NULL	PRIMARY	8	NULL	4	Using where
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking privileges on cached 	0.0 ms
    checking permissions	0.0 ms
    sending cached result to clien	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT/libraries/fof/model/model.php:1879
    JROOT/libraries/fof/model/model.php:1158
    JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:59
    JROOT/libraries/legacy/controller/legacy.php:685
    JROOT/libraries/legacy/controller/legacy.php:722
    JROOT/administrator/components/com_cpanel/cpanel.php:15
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/administrator.php:98
    JROOT/libraries/cms/application/administrator.php:159
    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: 3.97 ms Query memory: 0.029 MB Memory before query: 8.273 MB Rows returned: 1

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

      FROM an1sp0t_extensions

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

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	an1sp0t_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    Waiting for query cache 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
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    storing result in query cache	0.1 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT/libraries/joomla/cache/controller/callback.php:158
    JROOT/libraries/cms/component/helper.php:396
    JROOT/libraries/cms/component/helper.php:43
    JROOT/plugins/quickicon/jcefilebrowser/jcefilebrowser.php:33
    JROOT/libraries/cms/plugin/helper.php:257
    JROOT/libraries/cms/plugin/helper.php:172
    JROOT/administrator/modules/mod_quickicon/helper.php:150
    JROOT/administrator/modules/mod_quickicon/mod_quickicon.php:14
    JROOT/libraries/cms/module/helper.php:190
    JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:23
    JROOT/libraries/legacy/view/legacy.php:663
    JROOT/libraries/legacy/view/legacy.php:211
    JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
    JROOT/libraries/legacy/controller/legacy.php:685
    JROOT/libraries/legacy/controller/legacy.php:722
    JROOT/administrator/components/com_cpanel/cpanel.php:15
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/administrator.php:98
    JROOT/libraries/cms/application/administrator.php:159
    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.53 ms After last query: 1.26 ms Query memory: 0.024 MB Memory before query: 8.336 MB

    UPDATE `an1sp0t_extensions`

      SET `enabled` = '0'

      WHERE `element` = 'akeebabackup'
      AND `folder` = 'quickicon'

    Explain
    EXPLAIN not possible on query: UPDATE `an1sp0t_extensions` SET `enabled` = '0' WHERE `element` = 'akeebabackup' AND `folder` = 'quickicon'
    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
    Updating	0.0 ms
    end	0.0 ms
    Waiting for query cache lock	0.0 ms
    end	0.1 ms
    query end	0.3 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/plugins/quickicon/akeebabackup/akeebabackup.php:42
    JROOT/libraries/cms/plugin/helper.php:232
    JROOT/libraries/cms/plugin/helper.php:172
    JROOT/administrator/modules/mod_quickicon/helper.php:150
    JROOT/administrator/modules/mod_quickicon/mod_quickicon.php:14
    JROOT/libraries/cms/module/helper.php:190
    JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:23
    JROOT/libraries/legacy/view/legacy.php:663
    JROOT/libraries/legacy/view/legacy.php:211
    JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
    JROOT/libraries/legacy/controller/legacy.php:685
    JROOT/libraries/legacy/controller/legacy.php:722
    JROOT/administrator/components/com_cpanel/cpanel.php:15
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/administrator.php:98
    JROOT/libraries/cms/application/administrator.php:159
    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.13 ms After last query: 0.21 ms Query memory: 0.030 MB Memory before query: 8.382 MB Rows returned: 1

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

      FROM an1sp0t_extensions

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

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	an1sp0t_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    Waiting for query cache 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
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    storing result in query cache	0.1 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT/libraries/joomla/cache/controller/callback.php:158
    JROOT/libraries/cms/component/helper.php:396
    JROOT/libraries/cms/component/helper.php:43
    JROOT/libraries/cms/component/helper.php:73
    JROOT/plugins/quickicon/akeebabackup/akeebabackup.php:77
    JROOT/libraries/cms/plugin/helper.php:232
    JROOT/libraries/cms/plugin/helper.php:172
    JROOT/administrator/modules/mod_quickicon/helper.php:150
    JROOT/administrator/modules/mod_quickicon/mod_quickicon.php:14
    JROOT/libraries/cms/module/helper.php:190
    JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:23
    JROOT/libraries/legacy/view/legacy.php:663
    JROOT/libraries/legacy/view/legacy.php:211
    JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
    JROOT/libraries/legacy/controller/legacy.php:685
    JROOT/libraries/legacy/controller/legacy.php:722
    JROOT/administrator/components/com_cpanel/cpanel.php:15
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/administrator.php:98
    JROOT/libraries/cms/application/administrator.php:159
    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.05 ms After last query: 17.87 ms Query memory: 0.031 MB Memory before query: 9.867 MB Rows returned: 1
    Duplicate queries: #18

    SELECT *

      FROM an1sp0t_wf_profiles

      WHERE published = 1

      ORDER BY ordering ASC

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	an1sp0t_wf_profiles	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	4	Using where; Using filesort
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking privileges on cached 	0.0 ms
    checking permissions	0.0 ms
    sending cached result to clien	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT/components/com_jce/editor/libraries/classes/editor.php:93
    JROOT/administrator/components/com_jce/models/model.php:115
    JROOT/administrator/components/com_jce/helpers/browser.php:20
    JROOT/plugins/quickicon/jcefilebrowser/jcefilebrowser.php:90
    JROOT/libraries/joomla/event/event.php:71
    JROOT/libraries/joomla/event/dispatcher.php:162
    JROOT/libraries/joomla/application/base.php:106
    JROOT/administrator/modules/mod_quickicon/helper.php:152
    JROOT/administrator/modules/mod_quickicon/mod_quickicon.php:14
    JROOT/libraries/cms/module/helper.php:190
    JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:23
    JROOT/libraries/legacy/view/legacy.php:663
    JROOT/libraries/legacy/view/legacy.php:211
    JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
    JROOT/libraries/legacy/controller/legacy.php:685
    JROOT/libraries/legacy/controller/legacy.php:722
    JROOT/administrator/components/com_cpanel/cpanel.php:15
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/administrator.php:98
    JROOT/libraries/cms/application/administrator.php:159
    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.05 ms After last query: 3.73 ms Query memory: 0.032 MB Memory before query: 10.217 MB Rows returned: 1
    Duplicate queries: #17

    SELECT *

      FROM an1sp0t_wf_profiles

      WHERE published = 1

      ORDER BY ordering ASC

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	an1sp0t_wf_profiles	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	4	Using where; Using filesort
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking privileges on cached 	0.0 ms
    checking permissions	0.0 ms
    sending cached result to clien	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT/components/com_jce/editor/libraries/classes/editor.php:93
    JROOT/administrator/components/com_jce/models/editor.php:89
    JROOT/components/com_jce/editor/libraries/classes/editor.php:169
    JROOT/administrator/components/com_jce/models/model.php:115
    JROOT/administrator/components/com_jce/helpers/browser.php:20
    JROOT/plugins/quickicon/jcefilebrowser/jcefilebrowser.php:90
    JROOT/libraries/joomla/event/event.php:71
    JROOT/libraries/joomla/event/dispatcher.php:162
    JROOT/libraries/joomla/application/base.php:106
    JROOT/administrator/modules/mod_quickicon/helper.php:152
    JROOT/administrator/modules/mod_quickicon/mod_quickicon.php:14
    JROOT/libraries/cms/module/helper.php:190
    JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:23
    JROOT/libraries/legacy/view/legacy.php:663
    JROOT/libraries/legacy/view/legacy.php:211
    JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
    JROOT/libraries/legacy/controller/legacy.php:685
    JROOT/libraries/legacy/controller/legacy.php:722
    JROOT/administrator/components/com_cpanel/cpanel.php:15
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/administrator.php:98
    JROOT/libraries/cms/application/administrator.php:159
    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.54 ms After last query: 1.44 ms Query memory: 0.041 MB Memory before query: 10.301 MB Rows returned: 17

    SHOW FULL COLUMNS
      FROM `an1sp0t_extensions`

    Explain
    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `an1sp0t_extensions`
    Profile
    Status	Duration
    starting	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.2 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
    Opening tables	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Sending data	0.0 ms
    end	0.0 ms
    query end	0.0 ms
    closing tables	0.0 ms
    removing tmp table	0.1 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/table/table.php:229
    JROOT/libraries/joomla/table/table.php:150
    JROOT/libraries/joomla/table/extension.php:31
    JROOT/libraries/joomla/table/table.php:294
    JROOT/administrator/components/com_jce/helpers/extension.php:76
    JROOT/components/com_jce/editor/libraries/classes/editor.php:246
    JROOT/components/com_jce/editor/libraries/classes/editor.php:308
    JROOT/administrator/components/com_jce/models/editor.php:559
    JROOT/components/com_jce/editor/libraries/classes/editor.php:170
    JROOT/administrator/components/com_jce/models/model.php:115
    JROOT/administrator/components/com_jce/helpers/browser.php:20
    JROOT/plugins/quickicon/jcefilebrowser/jcefilebrowser.php:90
    JROOT/libraries/joomla/event/event.php:71
    JROOT/libraries/joomla/event/dispatcher.php:162
    JROOT/libraries/joomla/application/base.php:106
    JROOT/administrator/modules/mod_quickicon/helper.php:152
    JROOT/administrator/modules/mod_quickicon/mod_quickicon.php:14
    JROOT/libraries/cms/module/helper.php:190
    JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:23
    JROOT/libraries/legacy/view/legacy.php:663
    JROOT/libraries/legacy/view/legacy.php:211
    JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
    JROOT/libraries/legacy/controller/legacy.php:685
    JROOT/libraries/legacy/controller/legacy.php:722
    JROOT/administrator/components/com_cpanel/cpanel.php:15
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/administrator.php:98
    JROOT/libraries/cms/application/administrator.php:159
    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.16 ms After last query: 0.54 ms Query memory: 0.036 MB Memory before query: 10.396 MB Rows returned: 1

    SELECT `extension_id`

      FROM `an1sp0t_extensions`

      WHERE type = 'plugin'
      AND folder = 'editors'
      AND element = 'jce'

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	an1sp0t_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    Waiting for query cache 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
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    storing result in query cache	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT/libraries/joomla/table/extension.php:108
    JROOT/administrator/components/com_jce/helpers/extension.php:79
    JROOT/components/com_jce/editor/libraries/classes/editor.php:246
    JROOT/components/com_jce/editor/libraries/classes/editor.php:308
    JROOT/administrator/components/com_jce/models/editor.php:559
    JROOT/components/com_jce/editor/libraries/classes/editor.php:170
    JROOT/administrator/components/com_jce/models/model.php:115
    JROOT/administrator/components/com_jce/helpers/browser.php:20
    JROOT/plugins/quickicon/jcefilebrowser/jcefilebrowser.php:90
    JROOT/libraries/joomla/event/event.php:71
    JROOT/libraries/joomla/event/dispatcher.php:162
    JROOT/libraries/joomla/application/base.php:106
    JROOT/administrator/modules/mod_quickicon/helper.php:152
    JROOT/administrator/modules/mod_quickicon/mod_quickicon.php:14
    JROOT/libraries/cms/module/helper.php:190
    JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:23
    JROOT/libraries/legacy/view/legacy.php:663
    JROOT/libraries/legacy/view/legacy.php:211
    JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
    JROOT/libraries/legacy/controller/legacy.php:685
    JROOT/libraries/legacy/controller/legacy.php:722
    JROOT/administrator/components/com_cpanel/cpanel.php:15
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/administrator.php:98
    JROOT/libraries/cms/application/administrator.php:159
    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.11 ms After last query: 0.15 ms Query memory: 0.036 MB Memory before query: 10.435 MB Rows returned: 1

    SELECT *

      FROM an1sp0t_extensions

      WHERE `extension_id` = '10001'

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	an1sp0t_extensions	const	PRIMARY	PRIMARY	4	const	1
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    Waiting for query cache 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
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    storing result in query cache	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT/libraries/joomla/table/table.php:705
    JROOT/administrator/components/com_jce/helpers/extension.php:82
    JROOT/components/com_jce/editor/libraries/classes/editor.php:246
    JROOT/components/com_jce/editor/libraries/classes/editor.php:308
    JROOT/administrator/components/com_jce/models/editor.php:559
    JROOT/components/com_jce/editor/libraries/classes/editor.php:170
    JROOT/administrator/components/com_jce/models/model.php:115
    JROOT/administrator/components/com_jce/helpers/browser.php:20
    JROOT/plugins/quickicon/jcefilebrowser/jcefilebrowser.php:90
    JROOT/libraries/joomla/event/event.php:71
    JROOT/libraries/joomla/event/dispatcher.php:162
    JROOT/libraries/joomla/application/base.php:106
    JROOT/administrator/modules/mod_quickicon/helper.php:152
    JROOT/administrator/modules/mod_quickicon/mod_quickicon.php:14
    JROOT/libraries/cms/module/helper.php:190
    JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:23
    JROOT/libraries/legacy/view/legacy.php:663
    JROOT/libraries/legacy/view/legacy.php:211
    JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
    JROOT/libraries/legacy/controller/legacy.php:685
    JROOT/libraries/legacy/controller/legacy.php:722
    JROOT/administrator/components/com_cpanel/cpanel.php:15
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/administrator.php:98
    JROOT/libraries/cms/application/administrator.php:159
    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.12 ms After last query: 0.19 ms Query memory: 0.036 MB Memory before query: 10.476 MB Rows returned: 1

    SELECT `extension_id`

      FROM `an1sp0t_extensions`

      WHERE type = 'component'
      AND element = 'com_jce'

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	an1sp0t_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    Waiting for query cache 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
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    storing result in query cache	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT/libraries/joomla/table/extension.php:108
    JROOT/administrator/components/com_jce/helpers/extension.php:37
    JROOT/components/com_jce/editor/libraries/classes/editor.php:259
    JROOT/components/com_jce/editor/libraries/classes/editor.php:308
    JROOT/administrator/components/com_jce/models/editor.php:559
    JROOT/components/com_jce/editor/libraries/classes/editor.php:170
    JROOT/administrator/components/com_jce/models/model.php:115
    JROOT/administrator/components/com_jce/helpers/browser.php:20
    JROOT/plugins/quickicon/jcefilebrowser/jcefilebrowser.php:90
    JROOT/libraries/joomla/event/event.php:71
    JROOT/libraries/joomla/event/dispatcher.php:162
    JROOT/libraries/joomla/application/base.php:106
    JROOT/administrator/modules/mod_quickicon/helper.php:152
    JROOT/administrator/modules/mod_quickicon/mod_quickicon.php:14
    JROOT/libraries/cms/module/helper.php:190
    JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:23
    JROOT/libraries/legacy/view/legacy.php:663
    JROOT/libraries/legacy/view/legacy.php:211
    JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
    JROOT/libraries/legacy/controller/legacy.php:685
    JROOT/libraries/legacy/controller/legacy.php:722
    JROOT/administrator/components/com_cpanel/cpanel.php:15
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/administrator.php:98
    JROOT/libraries/cms/application/administrator.php:159
    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.11 ms After last query: 0.14 ms Query memory: 0.036 MB Memory before query: 10.514 MB Rows returned: 1

    SELECT *

      FROM an1sp0t_extensions

      WHERE `extension_id` = '10003'

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	an1sp0t_extensions	const	PRIMARY	PRIMARY	4	const	1
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    Waiting for query cache 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
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    storing result in query cache	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT/libraries/joomla/table/table.php:705
    JROOT/administrator/components/com_jce/helpers/extension.php:40
    JROOT/components/com_jce/editor/libraries/classes/editor.php:259
    JROOT/components/com_jce/editor/libraries/classes/editor.php:308
    JROOT/administrator/components/com_jce/models/editor.php:559
    JROOT/components/com_jce/editor/libraries/classes/editor.php:170
    JROOT/administrator/components/com_jce/models/model.php:115
    JROOT/administrator/components/com_jce/helpers/browser.php:20
    JROOT/plugins/quickicon/jcefilebrowser/jcefilebrowser.php:90
    JROOT/libraries/joomla/event/event.php:71
    JROOT/libraries/joomla/event/dispatcher.php:162
    JROOT/libraries/joomla/application/base.php:106
    JROOT/administrator/modules/mod_quickicon/helper.php:152
    JROOT/administrator/modules/mod_quickicon/mod_quickicon.php:14
    JROOT/libraries/cms/module/helper.php:190
    JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:23
    JROOT/libraries/legacy/view/legacy.php:663
    JROOT/libraries/legacy/view/legacy.php:211
    JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
    JROOT/libraries/legacy/controller/legacy.php:685
    JROOT/libraries/legacy/controller/legacy.php:722
    JROOT/administrator/components/com_cpanel/cpanel.php:15
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/administrator.php:98
    JROOT/libraries/cms/application/administrator.php:159
    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.44 ms After last query: 1.97 ms Query memory: 0.025 MB Memory before query: 10.527 MB

    UPDATE `an1sp0t_extensions`

      SET `enabled` = '1'

      WHERE `element` = 'akeebabackup'
      AND `folder` = 'quickicon'

    Explain
    EXPLAIN not possible on query: UPDATE `an1sp0t_extensions` SET `enabled` = '1' WHERE `element` = 'akeebabackup' AND `folder` = 'quickicon'
    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
    Updating	0.0 ms
    end	0.0 ms
    Waiting for query cache lock	0.0 ms
    end	0.1 ms
    query end	0.2 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/plugins/quickicon/akeebabackup/akeebabackup.php:253
    JROOT/libraries/joomla/event/event.php:71
    JROOT/libraries/joomla/event/dispatcher.php:162
    JROOT/libraries/joomla/application/base.php:106
    JROOT/administrator/modules/mod_quickicon/helper.php:152
    JROOT/administrator/modules/mod_quickicon/mod_quickicon.php:14
    JROOT/libraries/cms/module/helper.php:190
    JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:23
    JROOT/libraries/legacy/view/legacy.php:663
    JROOT/libraries/legacy/view/legacy.php:211
    JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
    JROOT/libraries/legacy/controller/legacy.php:685
    JROOT/libraries/legacy/controller/legacy.php:722
    JROOT/administrator/components/com_cpanel/cpanel.php:15
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/administrator.php:98
    JROOT/libraries/cms/application/administrator.php:159
    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: 11.82 ms Query memory: 0.022 MB Memory before query: 10.650 MB Rows returned: 1

    SELECT s.time, s.client_id, u.id, u.name, u.username

      FROM an1sp0t_session AS s

      LEFT JOIN an1sp0t_users AS u
      ON s.userid = u.id

      WHERE s.guest = 0
      LIMIT 0, 5

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
    1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	anispotc_bd.s.userid	1
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.1 ms
    System lock	0.0 ms
    Waiting for query cache 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
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    storing result in query cache	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT/administrator/modules/mod_logged/helper.php:43
    JROOT/administrator/modules/mod_logged/mod_logged.php:15
    JROOT/libraries/cms/module/helper.php:190
    JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:72
    JROOT/libraries/legacy/view/legacy.php:663
    JROOT/libraries/legacy/view/legacy.php:211
    JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
    JROOT/libraries/legacy/controller/legacy.php:685
    JROOT/libraries/legacy/controller/legacy.php:722
    JROOT/administrator/components/com_cpanel/cpanel.php:15
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/administrator.php:98
    JROOT/libraries/cms/application/administrator.php:159
    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: 4.68 ms Query memory: 0.026 MB Memory before query: 11.016 MB Rows returned: 1

    SELECT enabled

      FROM `an1sp0t_extensions`

      WHERE `type` = 'plugin'
      AND `folder` = 'system'
      AND `element` = 'languagefilter'

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	an1sp0t_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    Waiting for query cache 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
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    storing result in query cache	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT/libraries/cms/language/multilang.php:61
    JROOT/libraries/cms/language/associations.php:121
    JROOT/administrator/components/com_content/models/articles.php:59
    JROOT/libraries/legacy/model/legacy.php:198
    JROOT/administrator/modules/mod_popular/helper.php:35
    JROOT/administrator/modules/mod_popular/mod_popular.php:16
    JROOT/libraries/cms/module/helper.php:190
    JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:72
    JROOT/libraries/legacy/view/legacy.php:663
    JROOT/libraries/legacy/view/legacy.php:211
    JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
    JROOT/libraries/legacy/controller/legacy.php:685
    JROOT/libraries/legacy/controller/legacy.php:722
    JROOT/administrator/components/com_cpanel/cpanel.php:15
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/administrator.php:98
    JROOT/libraries/cms/application/administrator.php:159
    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.04 ms After last query: 0.30 ms Query memory: 0.027 MB Memory before query: 11.065 MB Rows returned: 1
    Duplicate queries: #29

    SELECT COUNT(*)

      FROM an1sp0t_content AS a

      LEFT JOIN `an1sp0t_languages` AS l
      ON l.lang_code = a.language

      LEFT JOIN an1sp0t_users AS uc
      ON uc.id=a.checked_out

      LEFT JOIN an1sp0t_viewlevels AS ag
      ON ag.id = a.access

      LEFT JOIN an1sp0t_categories AS c
      ON c.id = a.catid

      LEFT JOIN an1sp0t_users AS ua
      ON ua.id = a.created_by

    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
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	21	anispotc_bd.a.language	1	Using index
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	anispotc_bd.a.checked_out	1	Using index
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	anispotc_bd.a.access	1	Using index
    1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	anispotc_bd.a.catid	1	Using index
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	anispotc_bd.a.created_by	1	Using index
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking privileges on cached 	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    sending cached result to clien	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT/libraries/legacy/model/legacy.php:327
    JROOT/libraries/legacy/model/list.php:276
    JROOT/libraries/legacy/model/list.php:310
    JROOT/libraries/legacy/model/list.php:171
    JROOT/administrator/components/com_content/models/articles.php:371
    JROOT/administrator/modules/mod_popular/helper.php:72
    JROOT/administrator/modules/mod_popular/mod_popular.php:16
    JROOT/libraries/cms/module/helper.php:190
    JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:72
    JROOT/libraries/legacy/view/legacy.php:663
    JROOT/libraries/legacy/view/legacy.php:211
    JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
    JROOT/libraries/legacy/controller/legacy.php:685
    JROOT/libraries/legacy/controller/legacy.php:722
    JROOT/administrator/components/com_cpanel/cpanel.php:15
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/administrator.php:98
    JROOT/libraries/cms/application/administrator.php:159
    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.05 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 11.083 MB Rows returned: 5

    SELECT a.id, a.title, a.checked_out, a.checked_out_time,  a.created, a.hits,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name

      FROM an1sp0t_content AS a

      LEFT JOIN `an1sp0t_languages` AS l
      ON l.lang_code = a.language

      LEFT JOIN an1sp0t_users AS uc
      ON uc.id=a.checked_out

      LEFT JOIN an1sp0t_viewlevels AS ag
      ON ag.id = a.access

      LEFT JOIN an1sp0t_categories AS c
      ON c.id = a.catid

      LEFT JOIN an1sp0t_users AS ua
      ON ua.id = a.created_by

      ORDER BY a.hits DESC
      LIMIT 0, 5

    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 filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	21	anispotc_bd.a.language	1
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	anispotc_bd.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	anispotc_bd.a.access	1
    1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	anispotc_bd.a.catid	1
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	anispotc_bd.a.created_by	1
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking privileges on cached 	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    sending cached result to clien	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT/libraries/legacy/model/legacy.php:301
    JROOT/libraries/legacy/model/list.php:171
    JROOT/administrator/components/com_content/models/articles.php:371
    JROOT/administrator/modules/mod_popular/helper.php:72
    JROOT/administrator/modules/mod_popular/mod_popular.php:16
    JROOT/libraries/cms/module/helper.php:190
    JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:72
    JROOT/libraries/legacy/view/legacy.php:663
    JROOT/libraries/legacy/view/legacy.php:211
    JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
    JROOT/libraries/legacy/controller/legacy.php:685
    JROOT/libraries/legacy/controller/legacy.php:722
    JROOT/administrator/components/com_cpanel/cpanel.php:15
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/administrator.php:98
    JROOT/libraries/cms/application/administrator.php:159
    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.04 ms After last query: 2.94 ms Query memory: 0.027 MB Memory before query: 11.167 MB Rows returned: 1
    Duplicate queries: #27

    SELECT COUNT(*)

      FROM an1sp0t_content AS a

      LEFT JOIN `an1sp0t_languages` AS l
      ON l.lang_code = a.language

      LEFT JOIN an1sp0t_users AS uc
      ON uc.id=a.checked_out

      LEFT JOIN an1sp0t_viewlevels AS ag
      ON ag.id = a.access

      LEFT JOIN an1sp0t_categories AS c
      ON c.id = a.catid

      LEFT JOIN an1sp0t_users AS ua
      ON ua.id = a.created_by

    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
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	21	anispotc_bd.a.language	1	Using index
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	anispotc_bd.a.checked_out	1	Using index
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	anispotc_bd.a.access	1	Using index
    1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	anispotc_bd.a.catid	1	Using index
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	anispotc_bd.a.created_by	1	Using index
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking privileges on cached 	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    sending cached result to clien	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT/libraries/legacy/model/legacy.php:327
    JROOT/libraries/legacy/model/list.php:276
    JROOT/libraries/legacy/model/list.php:310
    JROOT/libraries/legacy/model/list.php:171
    JROOT/administrator/components/com_content/models/articles.php:371
    JROOT/administrator/modules/mod_latest/helper.php:83
    JROOT/administrator/modules/mod_latest/mod_latest.php:15
    JROOT/libraries/cms/module/helper.php:190
    JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:72
    JROOT/libraries/legacy/view/legacy.php:663
    JROOT/libraries/legacy/view/legacy.php:211
    JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
    JROOT/libraries/legacy/controller/legacy.php:685
    JROOT/libraries/legacy/controller/legacy.php:722
    JROOT/administrator/components/com_cpanel/cpanel.php:15
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/administrator.php:98
    JROOT/libraries/cms/application/administrator.php:159
    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.04 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 11.185 MB Rows returned: 5

    SELECT a.id, a.title, a.checked_out, a.checked_out_time,  a.access, a.created, a.created_by, a.created_by_alias, a.featured, a.state,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name

      FROM an1sp0t_content AS a

      LEFT JOIN `an1sp0t_languages` AS l
      ON l.lang_code = a.language

      LEFT JOIN an1sp0t_users AS uc
      ON uc.id=a.checked_out

      LEFT JOIN an1sp0t_viewlevels AS ag
      ON ag.id = a.access

      LEFT JOIN an1sp0t_categories AS c
      ON c.id = a.catid

      LEFT JOIN an1sp0t_users AS ua
      ON ua.id = a.created_by

      ORDER BY created DESC
      LIMIT 0, 5

    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 filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	21	anispotc_bd.a.language	1
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	anispotc_bd.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	anispotc_bd.a.access	1
    1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	anispotc_bd.a.catid	1
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	anispotc_bd.a.created_by	1
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking privileges on cached 	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    sending cached result to clien	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT/libraries/legacy/model/legacy.php:301
    JROOT/libraries/legacy/model/list.php:171
    JROOT/administrator/components/com_content/models/articles.php:371
    JROOT/administrator/modules/mod_latest/helper.php:83
    JROOT/administrator/modules/mod_latest/mod_latest.php:15
    JROOT/libraries/cms/module/helper.php:190
    JROOT/administrator/components/com_cpanel/views/cpanel/tmpl/default.php:72
    JROOT/libraries/legacy/view/legacy.php:663
    JROOT/libraries/legacy/view/legacy.php:211
    JROOT/administrator/components/com_cpanel/views/cpanel/view.html.php:63
    JROOT/libraries/legacy/controller/legacy.php:685
    JROOT/libraries/legacy/controller/legacy.php:722
    JROOT/administrator/components/com_cpanel/cpanel.php:15
    JROOT/libraries/cms/component/helper.php:352
    JROOT/libraries/cms/component/helper.php:332
    JROOT/libraries/cms/application/administrator.php:98
    JROOT/libraries/cms/application/administrator.php:159
    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.12 ms After last query: 2.89 ms Query memory: 0.019 MB Memory before query: 11.373 MB Rows returned: 1

    SELECT params
      FROM an1sp0t_extensions AS e
      WHERE e.element='com_widgetkit'

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	302	const	1	Using where
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    Waiting for query cache 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
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    storing result in query cache	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT/administrator/components/com_widgetkit/helpers/system.php:254
    JROOT/administrator/components/com_widgetkit/helpers/system.php:54
    JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129
    JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76
    JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137
    JROOT/administrator/components/com_widgetkit/widgetkit.php:17
    JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
    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:103
    JROOT/libraries/cms/application/administrator.php:159
    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.14 ms After last query: 3.18 ms Query memory: 0.020 MB Memory before query: 11.418 MB Rows returned: 1

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

      FROM an1sp0t_extensions

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

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	an1sp0t_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    Waiting for query cache 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
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    storing result in query cache	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT/libraries/joomla/cache/controller/callback.php:158
    JROOT/libraries/cms/component/helper.php:396
    JROOT/libraries/cms/component/helper.php:43
    JROOT/libraries/cms/component/helper.php:91
    JROOT/administrator/components/com_widgetkit/helpers/system.php:80
    JROOT/administrator/components/com_widgetkit/widgetkit.php:17
    JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
    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:103
    JROOT/libraries/cms/application/administrator.php:159
    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.04 ms After last query: 12.31 ms Query memory: 0.015 MB Memory before query: 12.233 MB Rows returned: 1

    SELECT COUNT(*)

      FROM an1sp0t_messages

      WHERE state = 0
      AND user_id_to = 105

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	an1sp0t_messages	ref	useridto_state	useridto_state	5	const,const	1	Using index
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking privileges on cached 	0.0 ms
    checking permissions	0.0 ms
    sending cached result to clien	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT/administrator/modules/mod_status/mod_status.php:25
    JROOT/libraries/cms/module/helper.php:190
    JROOT/libraries/joomla/document/html/renderer/module.php:105
    JROOT/libraries/joomla/document/html/renderer/modules.php:46
    JROOT/libraries/joomla/document/html/html.php:408
    JROOT/libraries/joomla/document/html/html.php:690
    JROOT/libraries/joomla/document/html/html.php:471
    JROOT/libraries/cms/application/cms.php:992
    JROOT/libraries/cms/application/administrator.php:436
    JROOT/libraries/cms/application/cms.php:261
    JROOT/administrator/index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.11 ms After last query: 0.08 ms Query memory: 0.015 MB Memory before query: 12.250 MB Rows returned: 1

    SELECT COUNT(session_id)

      FROM an1sp0t_session

      WHERE guest = 0
      AND client_id = 1

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	an1sp0t_session	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    Waiting for query cache 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
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    storing result in query cache	0.1 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT/administrator/modules/mod_status/mod_status.php:34
    JROOT/libraries/cms/module/helper.php:190
    JROOT/libraries/joomla/document/html/renderer/module.php:105
    JROOT/libraries/joomla/document/html/renderer/modules.php:46
    JROOT/libraries/joomla/document/html/html.php:408
    JROOT/libraries/joomla/document/html/html.php:690
    JROOT/libraries/joomla/document/html/html.php:471
    JROOT/libraries/cms/application/cms.php:992
    JROOT/libraries/cms/application/administrator.php:436
    JROOT/libraries/cms/application/cms.php:261
    JROOT/administrator/index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.10 ms After last query: 0.13 ms Query memory: 0.015 MB Memory before query: 12.267 MB Rows returned: 1

    SELECT COUNT(session_id)

      FROM an1sp0t_session

      WHERE guest = 0
      AND client_id = 0

    Explain
    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	an1sp0t_session	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.0 ms
    System lock	0.0 ms
    Waiting for query cache 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
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    storing result in query cache	0.1 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    JROOT/administrator/modules/mod_status/mod_status.php:63
    JROOT/libraries/cms/module/helper.php:190
    JROOT/libraries/joomla/document/html/renderer/module.php:105
    JROOT/libraries/joomla/document/html/renderer/modules.php:46
    JROOT/libraries/joomla/document/html/html.php:408
    JROOT/libraries/joomla/document/html/html.php:690
    JROOT/libraries/joomla/document/html/html.php:471
    JROOT/libraries/cms/application/cms.php:992
    JROOT/libraries/cms/application/administrator.php:436
    JROOT/libraries/cms/application/cms.php:261
    JROOT/administrator/index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.05 ms After last query: 7.84 ms Query memory: 0.019 MB Memory before query: 12.538 MB Rows returned: 1

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

      FROM an1sp0t_menu_types AS a

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

      LEFT JOIN an1sp0t_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	1	Using temporary; Using filesort
    1	SIMPLE	b	ref	idx_menutype	idx_menutype	74	anispotc_bd.a.menutype	5	Using where
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	21	anispotc_bd.b.language	1
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking privileges on cached 	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    sending cached result to clien	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    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:190
    JROOT/libraries/joomla/document/html/renderer/module.php:105
    JROOT/libraries/joomla/document/html/renderer/modules.php:46
    JROOT/libraries/joomla/document/html/html.php:408
    JROOT/libraries/joomla/document/html/html.php:690
    JROOT/libraries/joomla/document/html/html.php:471
    JROOT/libraries/cms/application/cms.php:992
    JROOT/libraries/cms/application/administrator.php:436
    JROOT/libraries/cms/application/cms.php:261
    JROOT/administrator/index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.39 ms After last query: 0.43 ms Query memory: 0.019 MB Memory before query: 12.569 MB Rows returned: 33

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

      FROM an1sp0t_menu AS m

      LEFT JOIN an1sp0t_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	33	Using where; Using filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	anispotc_bd.m.component_id	1	Using where
    Profile
    Status	Duration
    starting	0.0 ms
    Waiting for query cache lock	0.0 ms
    checking query cache for query	0.0 ms
    checking permissions	0.0 ms
    checking permissions	0.0 ms
    Opening tables	0.1 ms
    System lock	0.0 ms
    Waiting for query cache 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.1 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
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    Waiting for query cache lock	0.0 ms
    freeing items	0.0 ms
    storing result in query cache	0.0 ms
    logging slow query	0.0 ms
    cleaning up	0.0 ms
    Call Stack
    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:190
    JROOT/libraries/joomla/document/html/renderer/module.php:105
    JROOT/libraries/joomla/document/html/renderer/modules.php:46
    JROOT/libraries/joomla/document/html/html.php:408
    JROOT/libraries/joomla/document/html/html.php:690
    JROOT/libraries/joomla/document/html/html.php:471
    JROOT/libraries/cms/application/cms.php:992
    JROOT/libraries/cms/application/administrator.php:436
    JROOT/libraries/cms/application/cms.php:261
    JROOT/administrator/index.php:42
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]
    Query Time: 0.50 ms After last query: 27.67 ms Query memory: 0.003 MB Memory before query: 12.678 MB

    UPDATE `an1sp0t_session`

      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:7;s:19:\"session.timer.start\";i:1401189954;s:18:\"session.timer.last\";i:1401189965;s:17:\"session.timer.now\";i:1401190280;s:22:\"session.client.browser\";s:81:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:29.0) Gecko/20100101 Firefox/29.0\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":2:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:5:\"en-GB\";}s:13:\"com_installer\";O:8:\"stdClass\":2:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":27:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"105\";s:4:\"name\";s:7:\"AniSpot\";s:8:\"username\";s:7:\"anispot\";s:5:\"email\";s:26:\"[email protected]\";s:8:\"password\";s:60:\"$2y$10$w0G58liabngNYJplbZireue/zIexPkfJh2NPDE178xyKW3Z2Rp.ki\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2014-05-24 16:27:30\";s:13:\"lastvisitDate\";s:19:\"2014-05-27 10:58:31\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";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:12:\"requireReset\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:5:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:6;}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:6:\"otpKey\";s:0:\"\";s:4:\"otep\";s:0:\"\";}s:13:\"session.token\";s:32:\"6a99ed8b574f9daf4450f8f400b93bd7\";}__wf|a:1:{s:13:\"session.token\";s:32:\"8e24e3cc6fd7b4a38bbcdc6968ecf7a7\";}'
    	, `time` = '1401190280'

      WHERE `session_id` = '94ede3bdf9b6946f4c5a6bc3f10bb5e2'

    Explain
    EXPLAIN not possible on query: UPDATE `an1sp0t_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:7;s:19:\"session.timer.start\";i:1401189954;s:18:\"session.timer.last\";i:1401189965;s:17:\"session.timer.now\";i:1401190280;s:22:\"session.client.browser\";s:81:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:29.0) Gecko/20100101 Firefox/29.0\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":2:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:5:\"en-GB\";}s:13:\"com_installer\";O:8:\"stdClass\":2:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":27:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"105\";s:4:\"name\";s:7:\"AniSpot\";s:8:\"username\";s:7:\"anispot\";s:5:\"email\";s:26:\"[email protected]\";s:8:\"password\";s:60:\"$2y$10$w0G58liabngNYJplbZireue/zIexPkfJh2NPDE178xyKW3Z2Rp.ki\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2014-05-24 16:27:30\";s:13:\"lastvisitDate\";s:19:\"2014-05-27 10:58:31\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";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:12:\"requireReset\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:5:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:6;}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:6:\"otpKey\";s:0:\"\";s:4:\"otep\";s:0:\"\";}s:13:\"session.token\";s:32:\"6a99ed8b574f9daf4450f8f400b93bd7\";}__wf|a:1:{s:13:\"session.token\";s:32:\"8e24e3cc6fd7b4a38bbcdc6968ecf7a7\";}' , `time` = '1401190280' WHERE `session_id` = '94ede3bdf9b6946f4c5a6bc3f10bb5e2'
    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
    Updating	0.0 ms
    end	0.0 ms
    Waiting for query cache lock	0.0 ms
    end	0.1 ms
    query end	0.2 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/session/storage/database.php:85
    [Add xdebug.file_link_format directive to your php.ini file to have links for files]

27 Query Types Logged, Sorted by Occurrences.
SELECT Tables:

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

    2 × SELECT `extension_id`
      FROM `an1sp0t_extensions`

    2 × SELECT COUNT(*)
      FROM an1sp0t_content AS a
      LEFT JOIN `an1sp0t_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN an1sp0t_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN an1sp0t_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN an1sp0t_categories AS c
      ON c.id = a.catid
      LEFT JOIN an1sp0t_users AS ua
      ON ua.id = a.created_b

    2 × SELECT COUNT(session_id)
      FROM an1sp0t_session

    2 × SELECT *
      FROM an1sp0t_wf_profiles

    2 × SELECT *
      FROM an1sp0t_extensions

    1 × SELECT params
      FROM an1sp0t_extensions AS e

    1 × SELECT a.id, a.title, a.checked_out, a.checked_out_time,  a.access, a.created, a.created_by, a.created_by_alias, a.featured, a.state,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name
      FROM an1sp0t_content AS a
      LEFT JOIN `an1sp0t_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN an1sp0t_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN an1sp0t_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN an1sp0t_categories AS c
      ON c.id = a.catid
      LEFT JOIN an1sp0t_users AS ua
      ON ua.id = a.created_by

    1 × SELECT COUNT(*)
      FROM an1sp0t_messages

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

    1 × SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element
      FROM an1sp0t_menu AS m
      LEFT JOIN an1sp0t_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 an1sp0t_menu_types AS a
      LEFT JOIN an1sp0t_menu AS b
      ON b.menutype = a.menutype
      AND b.home != 0
      LEFT JOIN an1sp0t_languages AS l
      ON l.lang_code = language

    1 × SELECT a.id, a.title, a.checked_out, a.checked_out_time,  a.created, a.hits,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS category_title,ua.name AS author_name
      FROM an1sp0t_content AS a
      LEFT JOIN `an1sp0t_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN an1sp0t_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN an1sp0t_viewlevels AS ag
      ON ag.id = a.access
      LEFT JOIN an1sp0t_categories AS c
      ON c.id = a.catid
      LEFT JOIN an1sp0t_users AS ua
      ON ua.id = a.created_by

    1 × SELECT `enabled`
      FROM `an1sp0t_extensions`

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

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

    1 × SELECT `data`
      FROM `an1sp0t_session`

    1 × SELECT s.time, s.client_id, u.id, u.name, u.username
      FROM an1sp0t_session AS s
      LEFT JOIN an1sp0t_users AS u
      ON s.userid = u.id

    1 × SELECT enabled
      FROM `an1sp0t_extensions`

    1 × SELECT `an1sp0t_postinstall_messages`.*
      FROM `an1sp0t_postinstall_messages`

OTHER Tables:

    2 × SHOW FULL COLUMNS
      FROM `an1sp0t_postinstall_messages

    1 × UPDATE `an1sp0t_extensions`
      SET `enabled` = '1'

    1 × UPDATE `an1sp0t_session`
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:7;s:19:\"session.timer.start\";i:1401189954;s:18:\"session.timer.last\";i:1401189965;s:17:\"session.timer.now\";i:1401190280;s:22:\"session.client.browser\";s:81:\"Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:29.0) Gecko/20100101 Firefox/29.0\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":2:{s:11:\"application\";O:8:\"stdClass\":1:{s:4:\"lang\";s:5:\"en-GB\";}s:13:\"com_installer\";O:8:\"stdClass\":2:{s:7:\"message\";s:0:\"\";s:17:\"extension_message\";s:0:\"\";}}}s:4:\"user\";O:5:\"JUser\":27:{s:9:\"\\0\\0\\0isRoot\";b:1;s:2:\"id\";s:3:\"105\";s:4:\"name\";s:7:\"AniSpot\";s:8:\"username\";s:7:\"anispot\";s:5:\"email\";s:26:\"[email protected]\";s:8:\"password\";s:60:\"$2y$10$w0G58liabngNYJplbZireue/zIexPkfJh2NPDE178xyKW3Z2Rp.ki\";s:14:\"password_clear\";s:0:\"\";s:5:\"block\";s:1:\"0\";s:9:\"sendEmail\";s:1:\"1\";s:12:\"registerDate\";s:19:\"2014-05-24 16:27:30\";s:13:\"lastvisitDate\";s:19:\"2014-05-27 10:58:31\";s:10:\"activation\";s:1:\"0\";s:6:\"params\";s:92:\"{\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"editor\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}\";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:12:\"requireReset\";s:1:\"0\";s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":6:{s:11:\"admin_style\";s:0:\"\";s:14:\"admin_language\";s:0:\"\";s:8:\"language\";s:0:\"\";s:6:\"editor\";s:0:\"\";s:8:\"helpsite\";s:0:\"\";s:8:\"timezone\";s:0:\"\";}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:8;}s:14:\"\\0\\0\\0_authLevels\";a:5:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:6;}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:6:\"otpKey\";s:0:\"\";s:4:\"otep\";s:0:\"\";}s:13:\"session.token\";s:32:\"6a99ed8b574f9daf4450f8f400b93bd7\";}__wf|a:1:{s:13:\"session.token\";s:32:\"8e24e3cc6fd7b4a38bbcdc6968ecf7a7\";}'  , `time` = '1401190280'

    1 × SHOW FULL COLUMNS
      FROM `an1sp0t_extensions

    1 × UPDATE `an1sp0t_extensions`
      SET `enabled` = '0'

    1 × SHOW TABLE

    1 × UPDATE `an1sp0t_extensions`
      SET `params` = '{\"mediaversion\":\"73e7ec1d21dbffbc91f7ef5e4faad250\"}'