- Messaggi: 6
- Ringraziamenti ricevuti 0
Si prega Accedi o Crea un account a partecipare alla conversazione.
Si prega Accedi o Crea un account a partecipare alla conversazione.
Si prega Accedi o Crea un account a partecipare alla conversazione.
Si prega Accedi o Crea un account a partecipare alla conversazione.
Si prega Accedi o Crea un account a partecipare alla conversazione.
Si prega Accedi o Crea un account a partecipare alla conversazione.
{
"__default": {
"session": {
"counter": 8,
"timer": {
"start": 1577014069,
"last": 1577014354,
"now": 1577014354
},
"client": {
"forwarded": "79.31.31.81"
},
"token": "U39CgPTuMFJGDgqAlTUtDriGMzD9IFHl"
},
"registry": {
"com_installer": {
"message": "",
"extension_message": ""
},
"com_icagenda": {
"edit": {
"event": {
"data": null
}
}
},
"com_attachments": {
"current_url": "&return=aHR0cHM6Ly93d3cuZm9jdXNpbmdpdGFsaWEuaXQvYWRtaW5pc3RyYXRvci9pbmRleC5waHA%2Fb3B0aW9uPWNvbV9pY2FnZW5kYSZ2aWV3PWV2ZW50JmxheW91dD1lZGl0"
}
},
"user": {
"id": "281",
"name": "Super User",
"username": "valeriogiuseppe",
"email": "valeriooloda@gmail.com",
"password": "$2y$10$JjduUA.NRbm.Kn37Dauu9uHS5JpLBIZaJTIct\/2ue9yPKOA8Jrsr.",
"password_clear": "",
"block": "0",
"sendEmail": "1",
"registerDate": "2016-10-26 22:00:28",
"lastvisitDate": "2019-12-22 11:32:11",
"activation": "0",
"params": "{\"editor\":\"jce\",\"admin_style\":\"\",\"admin_language\":\"\",\"language\":\"\",\"helpsite\":\"\",\"timezone\":\"\"}",
"groups": {
"8": "8"
},
"guest": 0,
"lastResetTime": "0000-00-00 00:00:00",
"resetCount": "0",
"requireReset": "0",
"otpKey": "",
"otep": ""
},
"ic_submit_catid": null,
"ic_submit_shortdesc": null,
"ic_submit_metadesc": null,
"ic_submit_city": null,
"ic_submit_country": null,
"ic_submit_lat": null,
"ic_submit_lng": null
}
}
la parte query database mi riporta questo: (nonso se serve)
50 query eseguite 55.00 ms
Trovati 13 duplicati!
2 duplicati: #3 #49
2 duplicati: #4 #50
3 duplicati: #19 #23 #29
2 duplicati: #28 #30
2 duplicati: #31 #32
2 duplicati: #35 #38
Tempo della query: 0.64 ms Memoria query: 0.026 MB memoria prima della query: 1.482 MB Righe restituite: 1
SELECT `data`
FROM `vxscv_session`
WHERE `session_id` = '706be369e19431f41c66d38f1ba1246c'
Explain
Profilo
Call Stack
Tempo della query: 1.62 ms Dopo l'ultima query: 5.51 ms Memoria query: 0.031 MB memoria prima della query: 1.600 MB Righe restituite: 16
SHOW FULL COLUMNS
FROM `vxscv_users`
Explain
Profilo
Call Stack
Tempo della query: 0.79 ms Dopo l'ultima query: 0.77 ms Memoria query: 0.028 MB memoria prima della query: 1.640 MB Righe restituite: 1
Query duplicate: #49
SELECT *
FROM `vxscv_users`
WHERE `id` = 281
Explain
Profilo
Call Stack
Tempo della query: 9.91 ms Dopo l'ultima query: 6.04 ms Memoria query: 0.024 MB memoria prima della query: 1.716 MB Righe restituite: 1
Query duplicate: #50
SELECT `g`.`id`,`g`.`title`
FROM `vxscv_usergroups` AS g
INNER JOIN `vxscv_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 281
Explain
Profilo
Call Stack
Tempo della query: 2.12 ms Dopo l'ultima query: 5.81 ms Memoria query: 0.054 MB memoria prima della query: 1.733 MB Righe restituite: 48
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `vxscv_extensions`
WHERE `type` = 'component'
AND `state` = 0
AND `enabled` = 1
Explain
Profilo
Call Stack
Tempo della query: 0.42 ms Dopo l'ultima query: 8.51 ms Memoria query: 0.023 MB memoria prima della query: 2.157 MB Righe restituite: 5
SELECT id, rules
FROM `vxscv_viewlevels`
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE vxscv_viewlevels ALL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 5 100.00 NULL
Profilo
Call Stack
Tempo della query: 0.37 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.023 MB memoria prima della query: 2.171 MB Righe restituite: 2
SELECT b.id
FROM vxscv_user_usergroup_map AS map
LEFT JOIN vxscv_usergroups AS a
ON a.id = map.group_id
LEFT JOIN vxscv_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE map.user_id = 281
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE map ref PRIMARY PRIMARY 4 const 1 100.00 Using index
1 SIMPLE a eq_ref PRIMARY PRIMARY 4 focusing45141.map.group_id 1 100.00 NULL
1 SIMPLE b ALL idx_usergroup_nested_set_lookup NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 9 100.00 Range checked for each record (index map: 0x10)
Profilo
Call Stack
Tempo della query: 1.98 ms Dopo l'ultima query: 1.52 ms Memoria query: 0.040 MB memoria prima della query: 2.195 MB Righe restituite: 142
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM vxscv_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1,1,2,3,6)
ORDER BY ordering
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE vxscv_extensions ref extension extension 82 const 176 100.00 Using index condition; Using where; Using filesort
Profilo
Call Stack
Tempo della query: 2.40 ms Dopo l'ultima query: 57.37 ms Memoria query: 0.029 MB memoria prima della query: 3.061 MB Righe restituite: 48
SELECT `id`,`name`,`rules`,`parent_id`
FROM `vxscv_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_attachments','com_banners','com_cache','com_categories','com_checkin','com_coalawebtraffic','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_db8optimize','com_fields','com_finder','com_gdpr','com_icagenda','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_minitekwall','com_modules','com_newsfeeds','com_osmap','com_pagebuilderck','com_phocagallery','com_plugins','com_postinstall','com_privacy','com_profiles','com_redirect','com_search','com_swmenufree','com_tags','com_templates','com_users','com_weblinks','com_wrapper')
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE vxscv_assets ALL idx_asset_name NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 275 17.82 Using where
Profilo
Call Stack
Tempo della query: 1.18 ms Dopo l'ultima query: 3.60 ms Memoria query: 0.026 MB memoria prima della query: 3.151 MB Righe restituite: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `vxscv_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
Explain
Profilo
Call Stack
Tempo della query: 0.74 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.006 MB memoria prima della query: 3.143 MB
UPDATE `vxscv_extensions`
SET `params` = '{\"mediaversion\":\"931875b7571c513e679a0343dec090ee\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
Explain
Profilo
Call Stack
Tempo della query: 0.61 ms Dopo l'ultima query: 3.29 ms Memoria query: 0.022 MB memoria prima della query: 3.229 MB Righe restituite: 1
SELECT count(*)
FROM `vxscv_extensions`
WHERE `element` = 'cwgears'
AND `extension_id` = ''
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE NULL NULL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
Profilo
Call Stack
Tempo della query: 1.63 ms Dopo l'ultima query: 1.64 ms Memoria query: 0.021 MB memoria prima della query: 3.238 MB Righe restituite: 1
SELECT template, s.params
FROM vxscv_template_styles as s
LEFT JOIN vxscv_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 filtered Extra
1 SIMPLE s ref idx_home idx_home 28 const 2 100.00 Using index condition; Using where; Using filesort
1 SIMPLE e ref element_clientid,element_folder_clientid,extension element_clientid 403 focusing45141.s.template,const 1 100.00 Using where
Profilo
Call Stack
Tempo della query: 2.66 ms Dopo l'ultima query: 25.35 ms Memoria query: 0.038 MB memoria prima della query: 3.862 MB Righe restituite: 47
SHOW FULL COLUMNS
FROM `vxscv_icagenda_events`
Explain
Profilo
Call Stack
Tempo della query: 1.28 ms Dopo l'ultima query: 68.01 ms Memoria query: 0.027 MB memoria prima della query: 4.849 MB Righe restituite: 1
SELECT enabled
FROM `vxscv_extensions`
WHERE `type` = 'plugin'
AND `folder` = 'system'
AND `element` = 'languagefilter'
Explain
Profilo
Call Stack
Tempo della query: 2.11 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.039 MB memoria prima della query: 4.865 MB Righe restituite: 0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM vxscv_fields AS a
LEFT JOIN `vxscv_languages` AS l
ON l.lang_code = a.language
LEFT JOIN vxscv_users AS uc
ON uc.id=a.checked_out
LEFT JOIN vxscv_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN vxscv_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN vxscv_fields_groups AS g
ON g.id = a.group_id
WHERE a.context = 'com_icagenda.event'
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE a ref idx_state,idx_context idx_state 1 const 1 100.00 Using where; Using temporary; Using filesort
1 SIMPLE l eq_ref idx_langcode idx_langcode 28 focusing45141.a.language 1 100.00 Using where
1 SIMPLE uc eq_ref PRIMARY PRIMARY 4 focusing45141.a.checked_out 1 100.00 NULL
1 SIMPLE ag eq_ref PRIMARY PRIMARY 4 focusing45141.a.access 1 100.00 Using where
1 SIMPLE ua eq_ref PRIMARY PRIMARY 4 focusing45141.a.created_user_id 1 100.00 Using where
1 SIMPLE g eq_ref PRIMARY PRIMARY 4 focusing45141.a.group_id 1 100.00 Using where
Profilo
Call Stack
Tempo della query: 0.83 ms Dopo l'ultima query: 10.56 ms Memoria query: 0.024 MB memoria prima della query: 4.886 MB Righe restituite: 3
SELECT c.color AS color, c.title AS title
FROM vxscv_icagenda_category AS c
WHERE c.state = 1
Explain
Profilo
Call Stack
Tempo della query: 1.04 ms Dopo l'ultima query: 15.88 ms Memoria query: 0.027 MB memoria prima della query: 5.115 MB Righe restituite: 3
SELECT c.ordering, c.title, c.state, c.id
FROM `vxscv_icagenda_category` AS c
WHERE `c`.`state` <> -2
AND `c`.`state` IN (1)
ORDER BY c.title ASC
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE c ref idx_state idx_state 1 const 2 100.00 Using where; Using filesort
Profilo
Call Stack
Tempo della query: 0.71 ms Dopo l'ultima query: 13.68 ms Memoria query: 0.032 MB memoria prima della query: 5.230 MB Righe restituite: 1
Query duplicate: #23 #29
SELECT *
FROM vxscv_wf_profiles
WHERE published = 1
ORDER BY ordering ASC
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE vxscv_wf_profiles ALL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 4 100.00 Using where; Using filesort
Profilo
Call Stack
Tempo della query: 1.76 ms Dopo l'ultima query: 0.75 ms Memoria query: 0.036 MB memoria prima della query: 5.247 MB Righe restituite: 18
SHOW FULL COLUMNS
FROM `vxscv_extensions`
Explain
Profilo
Call Stack
Tempo della query: 1.07 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.029 MB memoria prima della query: 5.292 MB Righe restituite: 1
SELECT `extension_id`
FROM `vxscv_extensions`
WHERE type = 'component'
AND element = 'com_icagenda'
Explain
Profilo
Call Stack
Tempo della query: 0.61 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.034 MB memoria prima della query: 5.305 MB Righe restituite: 1
SELECT *
FROM vxscv_extensions
WHERE `extension_id` = '10026'
Explain
Profilo
Call Stack
Tempo della query: 0.49 ms Dopo l'ultima query: 19.85 ms Memoria query: 0.034 MB memoria prima della query: 5.606 MB Righe restituite: 1
Query duplicate: #19 #29
SELECT *
FROM vxscv_wf_profiles
WHERE published = 1
ORDER BY ordering ASC
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE vxscv_wf_profiles ALL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 4 100.00 Using where; Using filesort
Profilo
Call Stack
Tempo della query: 0.57 ms Dopo l'ultima query: 0.64 ms Memoria query: 0.031 MB memoria prima della query: 5.707 MB Righe restituite: 1
SELECT `extension_id`
FROM `vxscv_extensions`
WHERE type = 'plugin'
AND folder = 'editors'
AND element = 'jce'
Explain
Profilo
Call Stack
Tempo della query: 0.36 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.036 MB memoria prima della query: 5.722 MB Righe restituite: 1
SELECT *
FROM vxscv_extensions
WHERE `extension_id` = '10038'
Explain
Profilo
Call Stack
Tempo della query: 0.54 ms Dopo l'ultima query: 0.45 ms Memoria query: 0.031 MB memoria prima della query: 5.738 MB Righe restituite: 1
SELECT `extension_id`
FROM `vxscv_extensions`
WHERE type = 'component'
AND element = 'com_jce'
Explain
Profilo
Call Stack
Tempo della query: 0.40 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.036 MB memoria prima della query: 5.753 MB Righe restituite: 1
SELECT *
FROM vxscv_extensions
WHERE `extension_id` = '10037'
Explain
Profilo
Call Stack
Tempo della query: 0.40 ms Dopo l'ultima query: 11.12 ms Memoria query: 0.031 MB memoria prima della query: 5.794 MB Righe restituite: 1
Query duplicate: #30
SELECT id, template
FROM vxscv_template_styles
WHERE client_id = 0
AND home = '1'
Explain
Profilo
Call Stack
Tempo della query: 0.44 ms Dopo l'ultima query: 13.46 ms Memoria query: 0.038 MB memoria prima della query: 5.983 MB Righe restituite: 1
Query duplicate: #19 #23
SELECT *
FROM vxscv_wf_profiles
WHERE published = 1
ORDER BY ordering ASC
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE vxscv_wf_profiles ALL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 4 100.00 Using where; Using filesort
Profilo
Call Stack
Tempo della query: 0.86 ms Dopo l'ultima query: 4.21 ms Memoria query: 0.031 MB memoria prima della query: 6.035 MB Righe restituite: 1
Query duplicate: #28
SELECT id, template
FROM vxscv_template_styles
WHERE client_id = 0
AND home = '1'
Explain
Profilo
Call Stack
Tempo della query: 0.41 ms Dopo l'ultima query: 30.63 ms Memoria query: 0.029 MB memoria prima della query: 6.441 MB Righe restituite: 0
Query duplicate: #32
SELECT title, id
FROM vxscv_pagebuilderck_pages
WHERE state=1
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE NULL NULL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
Profilo
Call Stack
Tempo della query: 0.24 ms Dopo l'ultima query: 0.03 ms Memoria query: 0.030 MB memoria prima della query: 6.453 MB Righe restituite: 0
Query duplicate: #31
SELECT title, id
FROM vxscv_pagebuilderck_pages
WHERE state=1
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE NULL NULL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
Profilo
Call Stack
Tempo della query: 0.35 ms Dopo l'ultima query: 5.22 ms Memoria query: 0.029 MB memoria prima della query: 6.496 MB Righe restituite: 0
SELECT id AS value, title AS features
FROM vxscv_icagenda_feature
WHERE state=1
AND icon IS NOT NULL
AND icon!=''
ORDER BY features
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE NULL NULL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
Profilo
Call Stack
Tempo della query: 0.44 ms Dopo l'ultima query: 19.23 ms Memoria query: 0.032 MB memoria prima della query: 6.505 MB Righe restituite: 0
SELECT cf.*
FROM `vxscv_icagenda_customfields` AS cf
WHERE `cf`.`parent_form` = '2'
AND `cf`.`state` = 1
ORDER BY cf.ordering ASC
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE NULL NULL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
Profilo
Call Stack
Tempo della query: 0.46 ms Dopo l'ultima query: 6.96 ms Memoria query: 0.028 MB memoria prima della query: 6.561 MB Righe restituite: 5
Query duplicate: #38
SELECT `a`.`id` AS `value`, `a`.`title` AS `text`
FROM `vxscv_viewlevels` AS `a`
GROUP BY `a`.`id`,`a`.`title`,`a`.`ordering`
ORDER BY `a`.`ordering` ASC,`title` ASC
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE a ALL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 5 100.00 Using filesort
Profilo
Call Stack
Tempo della query: 0.41 ms Dopo l'ultima query: 4.04 ms Memoria query: 0.029 MB memoria prima della query: 6.571 MB Righe restituite: 0
SELECT f.*
FROM `vxscv_icagenda_filters` AS f
WHERE `type` = "customfield"
AND `filter` = "groups"
AND `state` = 1
ORDER BY f.option ASC
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE NULL NULL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
Profilo
Call Stack
Tempo della query: 0.43 ms Dopo l'ultima query: 7.50 ms Memoria query: 0.026 MB memoria prima della query: 6.627 MB Righe restituite: 0
SELECT title
FROM vxscv_content
WHERE id = 0
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE NULL NULL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
Profilo
Call Stack
Tempo della query: 0.76 ms Dopo l'ultima query: 14.70 ms Memoria query: 0.029 MB memoria prima della query: 6.653 MB Righe restituite: 5
Query duplicate: #35
SELECT `a`.`id` AS `value`, `a`.`title` AS `text`
FROM `vxscv_viewlevels` AS `a`
GROUP BY `a`.`id`,`a`.`title`,`a`.`ordering`
ORDER BY `a`.`ordering` ASC,`title` ASC
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE a ALL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 5 100.00 Using filesort
Profilo
Call Stack
Tempo della query: 0.51 ms Dopo l'ultima query: 0.76 ms Memoria query: 0.029 MB memoria prima della query: 6.665 MB Righe restituite: 2
SELECT a.lang_code AS value, a.title AS text, a.title_native
FROM vxscv_languages AS a
WHERE a.published >= 0
ORDER BY a.title
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE a ALL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 2 100.00 Using where; Using filesort
Profilo
Call Stack
Tempo della query: 1.12 ms Dopo l'ultima query: 14.10 ms Memoria query: 0.025 MB memoria prima della query: 6.823 MB Righe restituite: 4
SELECT `element`,`name`,`client_id`,`extension_id`
FROM `vxscv_extensions`
WHERE `type` = 'language'
AND `state` = 0
AND `enabled` = 1
Explain
Profilo
Call Stack
Tempo della query: 2.11 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.028 MB memoria prima della query: 6.848 MB Righe restituite: 14
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM vxscv_modules AS m
LEFT JOIN vxscv_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN vxscv_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 <= '2019-12-22 11:32:35')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-12-22 11:32:35')
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 filtered Extra
1 SIMPLE m ref PRIMARY,published,newsfeeds published 1 const 9 100.00 Using index condition; Using where; Using filesort
1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 focusing45141.m.module,const 1 100.00 Using index condition; Using where
1 SIMPLE mm ref PRIMARY PRIMARY 4 focusing45141.m.id 2 100.00 Using where; Using index
Profilo
Call Stack
Tempo della query: 1.34 ms Dopo l'ultima query: 4.96 ms Memoria query: 0.024 MB memoria prima della query: 6.881 MB Righe restituite: 4
SELECT element, name
FROM vxscv_extensions
WHERE `type` = 'plugin'
AND `folder` = 'editors'
AND `enabled` = 1
Explain
Profilo
Call Stack
Tempo della query: 0.51 ms Dopo l'ultima query: 2.74 ms Memoria query: 0.023 MB memoria prima della query: 6.903 MB Righe restituite: 1
SELECT COUNT(*)
FROM vxscv_messages
WHERE state = 0
AND user_id_to = 281
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE NULL NULL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL NULL NULL Impossible WHERE noticed after reading const tables
Profilo
Call Stack
Tempo della query: 1.25 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.023 MB memoria prima della query: 6.909 MB Righe restituite: 1
SELECT COUNT(session_id)
FROM vxscv_session
WHERE guest = 0
AND client_id = 1
Explain
Profilo
Call Stack
Tempo della query: 0.52 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.023 MB memoria prima della query: 6.915 MB Righe restituite: 1
SELECT COUNT(session_id)
FROM vxscv_session
WHERE guest = 0
AND client_id = 0
Explain
Profilo
Call Stack
Tempo della query: 1.05 ms Dopo l'ultima query: 8.10 ms Memoria query: 0.025 MB memoria prima della query: 7.078 MB Righe restituite: 4
SELECT a.title, a.menutype,
CASE COALESCE(SUM(m.home), 0) WHEN 0 THEN '' WHEN 1 THEN
CASE m.language WHEN '*' THEN 'class:icon-home' ELSE CONCAT('image:mod_languages/', l.image, '.gif') END ELSE 'image:mod_languages/icon-16-language.png' END AS icon
FROM vxscv_menu_types AS a
LEFT JOIN vxscv_menu AS m
ON m.menutype = a.menutype
AND m.home = 1
LEFT JOIN vxscv_languages AS l
ON l.lang_code = m.language
WHERE a.client_id = 0
GROUP BY a.id, m.language, l.image
ORDER BY a.title ASC
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE a ALL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 4 100.00 Using where; Using temporary; Using filesort
1 SIMPLE m ref idx_menutype idx_menutype 98 focusing45141.a.menutype 18 100.00 Using where
1 SIMPLE l ALL idx_langcode NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 2 100.00 Using where; Using join buffer (Block Nested Loop)
Profilo
Call Stack
Tempo della query: 0.36 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.025 MB memoria prima della query: 7.097 MB Righe restituite: 0
SELECT title, menutype
FROM vxscv_menu_types
WHERE client_id = 1
ORDER BY title ASC
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE vxscv_menu_types ALL NULL NON È POSSIBILE UTILIZZARE ALCUN INDICE NULL NULL 4 100.00 Using where; Using filesort
Profilo
Call Stack
Tempo della query: 1.35 ms Dopo l'ultima query: 6.72 ms Memoria query: 0.061 MB memoria prima della query: 7.201 MB Righe restituite: 71
SELECT m.*,e.element
FROM vxscv_menu AS m
LEFT JOIN vxscv_extensions AS e
ON m.component_id = e.extension_id
WHERE m.menutype = 'main'
AND m.client_id = 1
AND m.id > 1
AND (e.enabled = 1 OR e.enabled IS NULL)
ORDER BY m.lft
Explain
id select_type table type possible_keys key key_len ref rows filtered Extra
1 SIMPLE m ref PRIMARY,idx_client_id_parent_id_alias_language,idx_menutype idx_client_id_parent_id_alias_language 1 const 59 100.00 Using where; Using filesort
1 SIMPLE e eq_ref PRIMARY PRIMARY 4 focusing45141.m.component_id 1 100.00 Using where
Profilo
Call Stack
Tempo della query: 0.51 ms Dopo l'ultima query: 18.44 ms Memoria query: 0.028 MB memoria prima della query: 7.424 MB Righe restituite: 1
Query duplicate: #3
SELECT *
FROM `vxscv_users`
WHERE `id` = 281
Explain
Profilo
Call Stack
Tempo della query: 0.34 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.024 MB memoria prima della query: 7.434 MB Righe restituite: 1
Query duplicate: #4
SELECT `g`.`id`,`g`.`title`
FROM `vxscv_usergroups` AS g
INNER JOIN `vxscv_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 281
Explain
Profilo
Call Stack
37 tipi di query eseguite, ordinate per Occurrences
Tabelle SELECT:
3 × SELECT *
FROM vxscv_extensions
3 × SELECT `extension_id`
FROM `vxscv_extensions`
3 × SELECT *
FROM vxscv_wf_profiles
2 × SELECT `a`.`id` AS `value`, `a`.`title` AS `text`
FROM `vxscv_viewlevels` AS `a`
GROUP BY `a`.`id`,`a`.`title`,`a`.`ordering`
2 × SELECT id, template
FROM vxscv_template_styles
2 × SELECT *
FROM `vxscv_users`
2 × SELECT title, id
FROM vxscv_pagebuilderck_pages
2 × SELECT COUNT(session_id)
FROM vxscv_session
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `vxscv_extensions`
2 × SELECT `g`.`id`,`g`.`title`
FROM `vxscv_usergroups` AS g
INNER JOIN `vxscv_user_usergroup_map` AS m
ON m.group_id = g.id
1 × SELECT COUNT(*)
FROM vxscv_messages
1 × SELECT element, name
FROM vxscv_extensions
1 × SELECT `element`,`name`,`client_id`,`extension_id`
FROM `vxscv_extensions`
1 × SELECT a.lang_code AS value, a.title AS text, a.title_native
FROM vxscv_languages AS a
1 × SELECT title
FROM vxscv_content
1 × SELECT f.*
FROM `vxscv_icagenda_filters` AS f
1 × SELECT a.title, a.menutype,
CASE COALESCE(SUM(m.home), 0) WHEN 0 THEN '' WHEN 1 THEN
CASE m.language WHEN '*' THEN 'class:icon-home' ELSE CONCAT('image:mod_languages/', l.image, '.gif') END ELSE 'image:mod_languages/icon-16-language.png' END AS icon
FROM vxscv_menu_types AS a
LEFT JOIN vxscv_menu AS m
ON m.menutype = a.menutype
AND m.home = 1
LEFT JOIN vxscv_languages AS l
ON l.lang_code = m.language
1 × SELECT title, menutype
FROM vxscv_menu_types
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM vxscv_modules AS m
LEFT JOIN vxscv_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN vxscv_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT `data`
FROM `vxscv_session`
1 × SELECT cf.*
FROM `vxscv_icagenda_customfields` AS cf
1 × SELECT id AS value, title AS features
FROM vxscv_icagenda_feature
1 × SELECT c.ordering, c.title, c.state, c.id
FROM `vxscv_icagenda_category` AS c
1 × SELECT c.color AS color, c.title AS title
FROM vxscv_icagenda_category AS c
1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM vxscv_fields AS a
LEFT JOIN `vxscv_languages` AS l
ON l.lang_code = a.language
LEFT JOIN vxscv_users AS uc
ON uc.id=a.checked_out
LEFT JOIN vxscv_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN vxscv_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN vxscv_fields_groups AS g
ON g.id = a.group_id
1 × SELECT enabled
FROM `vxscv_extensions`
1 × SELECT template, s.params
FROM vxscv_template_styles as s
LEFT JOIN vxscv_extensions as e
ON e.type='template'
AND e.element=s.template
AND e.client_id=s.client_id
1 × SELECT count(*)
FROM `vxscv_extensions`
1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `vxscv_assets`
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM vxscv_extensions
1 × SELECT b.id
FROM vxscv_user_usergroup_map AS map
LEFT JOIN vxscv_usergroups AS a
ON a.id = map.group_id
LEFT JOIN vxscv_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `vxscv_viewlevels
1 × SELECT m.*,e.element
FROM vxscv_menu AS m
LEFT JOIN vxscv_extensions AS e
ON m.component_id = e.extension_id
ALTRE tabelle:
1 × SHOW FULL COLUMNS
FROM `vxscv_users
1 × UPDATE `vxscv_extensions`
SET `params` = '{\"mediaversion\":\"931875b7571c513e679a0343dec090ee\"}'
1 × SHOW FULL COLUMNS
FROM `vxscv_icagenda_events
1 × SHOW FULL COLUMNS
FROM `vxscv_extensions
Si prega Accedi o Crea un account a partecipare alla conversazione.
Si prega Accedi o Crea un account a partecipare alla conversazione.