Console Debug Joomla!
password_clear ⇒
groups ⇒
date_value ⇒
4.34 MB (4,547,544 Bytes)
51 query eseguite
SELECT extension_id AS id, element AS "option", params, enabled
FROM avjos16_extensions
WHERE `type` = 'component'
AND `element` = 'com_k2'
SELECT extension_id AS id, element AS "option", params, enabled
FROM avjos16_extensions
WHERE `type` = 'component'
AND `element` = 'com_coalawebtraffic'
SELECT count(*)
FROM `avjos16_cwtraffic`
WHERE ip = '18.191.186.72'
AND tm + '3600'>'1713605184'
INSERT INTO `avjos16_cwtraffic`
(tm, ip)
VALUES
('1713605184','18.191.186.72')
SHOW TABLES
SELECT file_id
from avjos16_jdownloads_files
WHERE published = 1
AND use_timeframe = 1
AND publish_to != '0000-00-00 00:00:00'
AND publish_to <= '2024-04-20 11:26:24'
SELECT file_id
from avjos16_jdownloads_files
WHERE published = 0
AND use_timeframe = 1
AND publish_from != '0000-00-00 00:00:00'
AND publish_from <= '2024-04-20 11:26:24'
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM avjos16_menu AS m
LEFT JOIN avjos16_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lft
SELECT joomlatablename,tablepkID
FROM `avjos16_falang_tableinfo`
SELECT *
FROM avjos16_languages
ORDER BY ordering
SHOW FULL COLUMNS
FROM `avjos16_languages`
SELECT extension_id AS id, element AS "option", params, enabled
FROM avjos16_extensions
WHERE `type` = 'component'
AND `element` = 'com_falang'
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM avjos16_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(115,282,283,284,285,286,288,475,317,366,367,368,400,416,476,123,124,126,127,356,357,358,359,360,361,362,363,364,128,136,137,138,139,140,377,378,379,383,384,385,386,380,381,382,415,141,412,413,151,152,153,477,495,494,478,479,480,481,482,483,484,485,486,487,488,489,490,491,492,493,496,129,130,133,132,134,229,135,156,355,281,101,301,302,455,304,306,307,308,309,310,311,312,313,314,316,315,456,457,458,473,254)
AND falang_content.reference_table='menu'
SELECT id, home, template, s.params
FROM avjos16_template_styles as s
LEFT JOIN avjos16_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1
SHOW TABLES
SELECT extension_id AS id, element AS "option", params, enabled
FROM avjos16_extensions
WHERE `type` = 'component'
AND `element` = 'com_icagenda'
SELECT next AS tNext, dates AS tDates, startdate AS tStartdate, enddate AS tEnddate, weekdays AS tWeekdays, id AS tId, state AS tState, access AS tAccess
FROM `avjos16_icagenda_events` AS e
WHERE e.state = 1 OR e.state = 0
SELECT DISTINCT(user_id)
FROM avjos16_usergroups as ug1
INNER JOIN avjos16_usergroups AS ug2
ON ug2.lft=ug1.lft
AND ug1.rgt=ug2.rgt
INNER JOIN avjos16_user_usergroup_map AS m
ON ug2.id=m.group_id
WHERE ug1.id='8'
SELECT e.id, e.title, e.alias, e.state, e.approval, e.created_by_email, e.username,
e.access, e.language, e.params, e.catid, e.image, e.file,
e.displaytime, e.dates, e.period, e.startdate, e.enddate, e.weekdays, e.time, e.next,
e.desc, e.metadesc, e.address, e.city, e.country, e.phone, e.email, e.name, e.website,
e.place as place_name, e.coordinate as coordinate, e.lat as lat, e.lng as lng,
c.id as cat_id, c.title as cat_title, c.color as cat_color, c.desc as cat_desc, c.alias as cat_alias
FROM `avjos16_icagenda_events` AS e
LEFT JOIN `avjos16_icagenda_category` AS c
ON c.id = e.catid
WHERE e.state =1
AND e.approval <> 1
AND e.next <> '%0000-00-00 00:00:00%'
AND e.access IN (1, 1)
AND (e.`language` = 'it-IT' OR e.`language` = '*')
AND e.id=11
ORDER BY e.next
LIMIT 0, 10
SELECT next AS tNext, dates AS tDates, period AS tPeriod, id AS tId, state AS tState, access AS tAccess
FROM `avjos16_icagenda_events` AS e
WHERE e.state = 1
SELECT count(e.id) AS max
FROM avjos16_icagenda_events AS e
LIMIT 0, 10
SELECT DISTINCT(user_id)
FROM avjos16_usergroups as ug1
INNER JOIN avjos16_usergroups AS ug2
ON ug2.lft=ug1.lft
AND ug1.rgt=ug2.rgt
INNER JOIN avjos16_user_usergroup_map AS m
ON ug2.id=m.group_id
WHERE ug1.id='8'
SELECT count(id) AS nbevents
FROM avjos16_icagenda_events AS e
WHERE (e.state = 1)
AND (e.next != '0000-00-00 00:00:00')
AND ((e.language = 'it-IT') OR (e.language = '*') OR (e.language = NULL) OR (e.language = ''))
AND e.access IN (1, 1)
AND e.approval <> 1
SELECT a.title, a.published, a.id
FROM `avjos16_menu` AS a
WHERE (link = 'index.php?option=com_icagenda&view=list')
AND (published > 0)
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM avjos16_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(229)
AND falang_content.reference_table='menu'
SELECT alias
FROM avjos16_icagenda_events
WHERE id=11
SELECT DISTINCT(user_id)
FROM avjos16_usergroups as ug1
INNER JOIN avjos16_usergroups AS ug2
ON ug2.lft=ug1.lft
AND ug1.rgt=ug2.rgt
INNER JOIN avjos16_user_usergroup_map AS m
ON ug2.id=m.group_id
WHERE ug1.id='8'
SELECT alias
FROM avjos16_icagenda_events
WHERE id=11
SELECT alias
FROM avjos16_icagenda_events
WHERE id=11
SELECT alias
FROM avjos16_icagenda_events
WHERE id=11
SELECT c.color AS cat_color
FROM avjos16_icagenda_category AS c
WHERE (c.id=4)
SELECT sum(r.people) AS registered
FROM avjos16_icagenda_registration AS r
WHERE (r.eventId=11)
AND (r.state > 0)
SELECT sum(r.people) AS registered
FROM avjos16_icagenda_registration AS r
WHERE (r.eventId=11)
AND (r.state > 0)
SELECT alias
FROM avjos16_icagenda_events
WHERE id=11
SELECT alias
FROM avjos16_icagenda_events
WHERE id=11
SELECT alias
FROM avjos16_icagenda_events
WHERE id=11
SELECT sum(r.people) AS registered
FROM avjos16_icagenda_registration AS r
WHERE (r.eventId=11)
AND (r.state > 0)
SELECT r.userid AS userid, r.name AS registeredUsers, r.date as regDate, r.people as regPeople, r.email as regEmail
FROM avjos16_icagenda_registration AS r
WHERE (r.eventId=11)
AND (r.state > 0)
SELECT sum(r.people) AS registered
FROM avjos16_icagenda_registration AS r
WHERE (r.eventId=11)
AND (r.state > 0)
SELECT sum(r.people) AS registered
FROM avjos16_icagenda_registration AS r
WHERE (r.eventId=11)
AND (r.state > 0)
SELECT alias
FROM avjos16_icagenda_events
WHERE id=11
SELECT alias
FROM avjos16_icagenda_events
WHERE id=11
SELECT alias
FROM avjos16_icagenda_events
WHERE id=11
SELECT e.state AS evtState, e.approval AS evtApproval, e.access AS evtAccess,v.title AS accessName
FROM `avjos16_icagenda_events` AS e
LEFT JOIN `avjos16_viewlevels` AS v
ON v.id = e.access
WHERE `e`.`id` = '11'
SELECT e.state AS evtState, e.approval AS evtApproval, e.access AS evtAccess,v.title AS accessName
FROM `avjos16_icagenda_events` AS e
LEFT JOIN `avjos16_viewlevels` AS v
ON v.id = e.access
WHERE `e`.`id` = '11'
SELECT e.state AS evtState, e.approval AS evtApproval, e.access AS evtAccess,v.title AS accessName
FROM `avjos16_icagenda_events` AS e
LEFT JOIN `avjos16_viewlevels` AS v
ON v.id = e.access
WHERE `e`.`id` = '11'
SELECT e.state AS evtState, e.approval AS evtApproval, e.access AS evtAccess,v.title AS accessName
FROM `avjos16_icagenda_events` AS e
LEFT JOIN `avjos16_viewlevels` AS v
ON v.id = e.access
WHERE `e`.`id` = '11'
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM avjos16_modules AS m
LEFT JOIN avjos16_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN avjos16_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 <= '2024-04-20 09:26:24')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-20 09:26:24')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 229 OR mm.menuid <= 0)
AND m.language IN ('it-IT','*')
ORDER BY m.position, m.ordering
SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM avjos16_falang_content AS falang_content
WHERE falang_content.language_id=2
AND falang_content.published=1
AND falang_content.reference_id IN(193,138,155,173,174,192,108,144,113,171,191,83,73,30,76,96,194,195,176,170,166,42)
AND falang_content.reference_table='modules'
SHOW TABLES
UPDATE `avjos16_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1713605184;s:18:\"session.timer.last\";i:1713605184;s:17:\"session.timer.now\";i:1713605184;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:10:\"date_value\";s:0:\"\";}'
, `time` = '1713605184'
WHERE `session_id` = 'nsb0bhjcqn9smv0d7mcdcfepm7'
25 tipi di query eseguite, ordinate per Occurrences
Tabelle SELECT:
10 × SELECT alias
FROM avjos16_icagenda_events
5 × SELECT sum(r.people) AS registered
FROM avjos16_icagenda_registration AS r
4 × SELECT extension_id AS id, element AS "option", params, enabled
FROM avjos16_extensions
4 × SELECT e.state AS evtState, e.approval AS evtApproval, e.access AS evtAccess,v.title AS accessName
FROM `avjos16_icagenda_events` AS e
LEFT JOIN `avjos16_viewlevels` AS v
ON v.id = e.access
3 × SELECT DISTINCT(user_id)
FROM avjos16_usergroups as ug1
INNER JOIN avjos16_usergroups AS ug2
ON ug2.lft=ug1.lft
AND ug1.rgt=ug2.rgt
INNER JOIN avjos16_user_usergroup_map AS m
ON ug2.id=m.group_id
3 × SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value
FROM avjos16_falang_content AS falang_content
2 × SELECT file_id
from avjos16_jdownloads_files
1 × SELECT a.title, a.published, a.id
FROM `avjos16_menu` AS a
1 × SELECT r.userid AS userid, r.name AS registeredUsers, r.date as regDate, r.people as regPeople, r.email as regEmail
FROM avjos16_icagenda_registration AS r
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM avjos16_modules AS m
LEFT JOIN avjos16_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN avjos16_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT c.color AS cat_color
FROM avjos16_icagenda_category AS c
1 × SELECT count(id) AS nbevents
FROM avjos16_icagenda_events AS e
1 × SELECT e.id, e.title, e.alias, e.state, e.approval, e.created_by_email, e.username, e.access, e.language, e.params, e.catid, e.image, e.file, e.displaytime, e.dates, e.period, e.startdate, e.enddate, e.weekdays, e.time, e.next, e.desc, e.metadesc, e.address, e.city, e.country, e.phone, e.email, e.name, e.website, e.place as place_name, e.coordinate as coordinate, e.lat as lat, e.lng as lng, c.id as cat_id, c.title as cat_title, c.color as cat_color, c.desc as cat_desc, c.alias as cat_alias
FROM `avjos16_icagenda_events` AS e
LEFT JOIN `avjos16_icagenda_category` AS c
ON c.id = e.catid
1 × SELECT joomlatablename,tablepkID
FROM `avjos16_falang_tableinfo
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM avjos16_menu AS m
LEFT JOIN avjos16_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT count(*)
FROM `avjos16_cwtraffic`
1 × SELECT *
FROM avjos16_languages
1 × SELECT id, home, template, s.params
FROM avjos16_template_styles as s
LEFT JOIN avjos16_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT next AS tNext, dates AS tDates, period AS tPeriod, id AS tId, state AS tState, access AS tAccess
FROM `avjos16_icagenda_events` AS e
1 × SELECT next AS tNext, dates AS tDates, startdate AS tStartdate, enddate AS tEnddate, weekdays AS tWeekdays, id AS tId, state AS tState, access AS tAccess
FROM `avjos16_icagenda_events` AS e
1 × SELECT count(e.id) AS max
FROM avjos16_icagenda_events AS e
LIMIT 0, 1
ALTRE tabelle:
3 × SHOW TABLE
1 × UPDATE `avjos16_session`
SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1713605184;s:18:\"session.timer.last\";i:1713605184;s:17:\"session.timer.now\";i:1713605184;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\0*\0isRoot\";N;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\0*\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:10:\"date_value\";s:0:\"\";}' , `time` = '1713605184'
1 × SHOW FULL COLUMNS
FROM `avjos16_languages
1 × INSERT INTO `avjos16_cwtraffic` (tm, ip)
VALUES ('1713605184','18.191.186.72'