SELECT `data`
FROM `hp_session`
WHERE `session_id` = 'selgd9cuip16tbbg3uoql2lp06'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | hp_session | const | PRIMARY | PRIMARY | 602 | const | 1 |
Status | Duration |
---|---|
Starting | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.1 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.1 ms |
Preparing | 0.0 ms |
Unlocking tables | 0.0 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.0 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT extension_id AS id, element AS "option", params, enabled
FROM hp_extensions
WHERE `type` = 'component'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | hp_extensions | ref | extension | extension | 62 | const | 35 | Using index condition |
Status | Duration |
---|---|
Starting | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.1 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.2 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT folder AS type, element AS name, params
FROM hp_extensions
WHERE enabled = 1
AND type ='plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | hp_extensions | ALL | extension | NO INDEX KEY COULD BE USED | NULL | NULL | 203 | Using where; Using filesort |
Status | Duration |
---|---|
Starting | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.1 ms |
Preparing | 0.0 ms |
Sorting result | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.0 ms |
Creating sort index | 0.3 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
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 hp_menu AS m
LEFT JOIN hp_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
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | m | ref | idx_client_id_parent_id_alias_language | idx_client_id_parent_id_alias_language | 1 | const | 134 | Using index condition; Using where; Using filesort |
1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | bvtvhpc1_hp.m.component_id | 1 | Using where |
Status | Duration |
---|---|
Starting | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.1 ms |
Preparing | 0.1 ms |
Sorting result | 0.1 ms |
Executing | 0.0 ms |
Sending data | 0.0 ms |
Creating sort index | 1.3 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT *
FROM hp_languages
WHERE published=1
ORDER BY ordering ASC
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | hp_languages | ALL | NULL | NO INDEX KEY COULD BE USED | NULL | NULL | 5 | Using where; Using filesort |
Status | Duration |
---|---|
Starting | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.0 ms |
Preparing | 0.0 ms |
Sorting result | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.0 ms |
Creating sort index | 0.2 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT extension_id AS id, element AS "option", params, enabled
FROM hp_extensions
WHERE `type` = 'library'
AND `element` = 'joomla'
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | hp_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 364 | const,const | 1 | Using index condition |
Status | Duration |
---|---|
Starting | 4.9 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
init | 0.1 ms |
Optimizing | 0.0 ms |
Statistics | 0.3 ms |
Preparing | 0.0 ms |
Executing | 0.0 ms |
Sending data | 0.1 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
UPDATE `hp_extensions`
SET `params` = '{\"mediaversion\":\"7068baba323e770e913bc98790fbb704\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
Status | Duration |
---|---|
Starting | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
init for update | 0.1 ms |
Updating | 0.1 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT id, home, template, s.params
FROM hp_template_styles as s
LEFT JOIN hp_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
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | extension | 62 | const | 5 | Using index condition; Using where |
1 | SIMPLE | s | ALL | idx_template | NO INDEX KEY COULD BE USED | NULL | NULL | 6 | Using where; Using join buffer (flat, BNL join) |
Status | Duration |
---|---|
Starting | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
init | 0.0 ms |
Optimizing | 0.0 ms |
Statistics | 0.1 ms |
Preparing | 0.1 ms |
Executing | 0.0 ms |
Sending data | 0.1 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
SELECT template
FROM hp_template_styles
WHERE home = 1
AND client_id = 0
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
---|---|---|---|---|---|---|---|---|---|
1 | SIMPLE | hp_template_styles | ALL | idx_home | NO INDEX KEY COULD BE USED | NULL | NULL | 6 | Using where |
Status | Duration |
---|---|
Starting | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table 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 of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.0 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
UPDATE `hp_session`
SET `data` = '__default|a:10:{s:15:\"session.counter\";i:7;s:19:\"session.timer.start\";i:1745607334;s:18:\"session.timer.last\";i:1745607337;s:17:\"session.timer.now\";i:1745607338;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":27:{s:9:\"\\0\\0\\0isRoot\";b:0;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: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:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:3:\"gid\";i:1;}s:16:\"com_mailto.links\";a:5:{s:40:\"6dc6c916b00dd3d9a1f8336b0a9531551d463aee\";O:8:\"stdClass\":2:{s:4:\"link\";s:133:\"https://www.bvtvhp.com/tuyen-dung-2/tr%E1%BA%A7n-phong-vinh-chi%E1%BA%BFm-%C4%91o%E1%BA%A1t-t%C3%A0i-s%E1%BA%A3n-c%C3%B4ng-ty-hp.html\";s:6:\"expiry\";i:1745607335;}s:40:\"55908b998ff206d0461682895000ebb94c5d42d9\";O:8:\"stdClass\":2:{s:4:\"link\";s:166:\"https://www.bvtvhp.com/tin-tuc/tin-hp/h%E1%BB%99i-th%E1%BA%A3o-thu%E1%BB%91c-tr%E1%BB%AB-s%C3%A2u-b%E1%BB%87nh-h%E1%BB%AFu-c%C6%A1-sinh-h%E1%BB%8Dc-amtech-100-ew.html\";s:6:\"expiry\";i:1745607336;}s:40:\"9d8e6a6e3527938b72399c8dfd864520f05594c2\";O:8:\"stdClass\":2:{s:4:\"link\";s:210:\"https://www.bvtvhp.com/tin-tuc/nong-nghiep/qu%E1%BB%B9-t%C4%83ng-tr%C6%B0%E1%BB%9Fng-t%E1%BB%91t,-n%C3%B4ng-d%C3%A2n-%C4%91%C6%B0%E1%BB%A3c-h%E1%BB%97-tr%E1%BB%A3-t%E1%BB%91i-%C4%91a.html?print=1&tmpl=component\";s:6:\"expiry\";i:1745607337;}s:40:\"2d5405e0d886328a5579f682ce316ef743ff2c22\";O:8:\"stdClass\":2:{s:4:\"link\";s:190:\"https://www.bvtvhp.com/tin-tuc/nong-nghiep/v%E1%BB%A1-quy-ho%E1%BA%A1ch,-v%E1%BB%A1-th%E1%BB%8B-tr%C6%B0%E1%BB%9Dng,-v%E1%BB%A1-n%E1%BB%A3-%C4%91%E1%BB%93ng-h%C3%A0nh-nh%C3%A0-n%C3%B4ng.html\";s:6:\"expiry\";i:1745607337;}s:40:\"33b9f6335ea9e476c66984ef8ef7f2a08439ac46\";O:8:\"stdClass\":2:{s:4:\"link\";s:215:\"https://www.bvtvhp.com/tin-tuc/nong-nghiep/%C4%91%E1%BB%81-xu%E1%BA%A5t-mi%E1%BB%85n-thu%E1%BA%BF-%C4%91%E1%BA%A5t-n%C3%B4ng-nghi%E1%BB%87p-%C4%91%E1%BA%A7u-t%C6%B0-tho%E1%BA%A3-%C4%91%C3%A1ng-cho-tam-n%C3%B4ng.html\";s:6:\"expiry\";i:1745607338;}}s:13:\"session.token\";s:32:\"660b0831a523b5d8e96a81a9fee6736a\";s:19:\"com_mailto.formtime\";i:1745607338;}' , `time` = '1745607338'
WHERE `session_id` = 'selgd9cuip16tbbg3uoql2lp06'
Status | Duration |
---|---|
Starting | 0.1 ms |
checking permissions | 0.0 ms |
Opening tables | 0.0 ms |
After opening tables | 0.0 ms |
System lock | 0.0 ms |
table lock | 0.0 ms |
init for update | 0.0 ms |
Updating | 0.1 ms |
End of update loop | 0.0 ms |
Query end | 0.0 ms |
Commit | 0.1 ms |
closing tables | 0.0 ms |
Unlocking tables | 0.0 ms |
closing tables | 0.0 ms |
Starting cleanup | 0.0 ms |
Freeing items | 0.0 ms |
Updating status | 0.0 ms |
Reset for next command | 0.0 ms |
2 × SELECT extension_id AS id, element AS "option", params, enabled
FROM hp_extensions
1 × SELECT id, home, template, s.params
FROM hp_template_styles as s
LEFT JOIN hp_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT template
FROM hp_template_styles
1 × SELECT *
FROM hp_languages
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 hp_menu AS m
LEFT JOIN hp_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT folder AS type, element AS name, params
FROM hp_extensions
1 × SELECT `data`
FROM `hp_session`
1 × UPDATE `hp_session`
SET `data` = '__default|a:10:{s:15:\"session.counter\";i:7;s:19:\"session.timer.start\";i:1745607334;s:18:\"session.timer.last\";i:1745607337;s:17:\"session.timer.now\";i:1745607338;s:22:\"session.client.browser\";s:103:\"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)\";s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":27:{s:9:\"\\0\\0\\0isRoot\";b:0;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: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:1:{i:0;s:1:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:1:{i:0;i:1;}s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:13:\"\\0\\0\\0userHelper\";O:18:\"JUserWrapperHelper\":0:{}s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;s:3:\"gid\";i:1;}s:16:\"com_mailto.links\";a:5:{s:40:\"6dc6c916b00dd3d9a1f8336b0a9531551d463aee\";O:8:\"stdClass\":2:{s:4:\"link\";s:133:\"https://www.bvtvhp.com/tuyen-dung-2/tr%E1%BA%A7n-phong-vinh-chi%E1%BA%BFm-%C4%91o%E1%BA%A1t-t%C3%A0i-s%E1%BA%A3n-c%C3%B4ng-ty-hp.html\";s:6:\"expiry\";i:1745607335;}s:40:\"55908b998ff206d0461682895000ebb94c5d42d9\";O:8:\"stdClass\":2:{s:4:\"link\";s:166:\"https://www.bvtvhp.com/tin-tuc/tin-hp/h%E1%BB%99i-th%E1%BA%A3o-thu%E1%BB%91c-tr%E1%BB%AB-s%C3%A2u-b%E1%BB%87nh-h%E1%BB%AFu-c%C6%A1-sinh-h%E1%BB%8Dc-amtech-100-ew.html\";s:6:\"expiry\";i:1745607336;}s:40:\"9d8e6a6e3527938b72399c8dfd864520f05594c2\";O:8:\"stdClass\":2:{s:4:\"link\";s:210:\"https://www.bvtvhp.com/tin-tuc/nong-nghiep/qu%E1%BB%B9-t%C4%83ng-tr%C6%B0%E1%BB%9Fng-t%E1%BB%91t,-n%C3%B4ng-d%C3%A2n-%C4%91%C6%B0%E1%BB%A3c-h%E1%BB%97-tr%E1%BB%A3-t%E1%BB%91i-%C4%91a.html?print=1&tmpl=component\";s:6:\"expiry\";i:1745607337;}s:40:\"2d5405e0d886328a5579f682ce316ef743ff2c22\";O:8:\"stdClass\":2:{s:4:\"link\";s:190:\"https://www.bvtvhp.com/tin-tuc/nong-nghiep/v%E1%BB%A1-quy-ho%E1%BA%A1ch,-v%E1%BB%A1-th%E1%BB%8B-tr%C6%B0%E1%BB%9Dng,-v%E1%BB%A1-n%E1%BB%A3-%C4%91%E1%BB%93ng-h%C3%A0nh-nh%C3%A0-n%C3%B4ng.html\";s:6:\"expiry\";i:1745607337;}s:40:\"33b9f6335ea9e476c66984ef8ef7f2a08439ac46\";O:8:\"stdClass\":2:{s:4:\"link\";s:215:\"https://www.bvtvhp.com/tin-tuc/nong-nghiep/%C4%91%E1%BB%81-xu%E1%BA%A5t-mi%E1%BB%85n-thu%E1%BA%BF-%C4%91%E1%BA%A5t-n%C3%B4ng-nghi%E1%BB%87p-%C4%91%E1%BA%A7u-t%C6%B0-tho%E1%BA%A3-%C4%91%C3%A1ng-cho-tam-n%C3%B4ng.html\";s:6:\"expiry\";i:1745607338;}}s:13:\"session.token\";s:32:\"660b0831a523b5d8e96a81a9fee6736a\";s:19:\"com_mailto.formtime\";i:1745607338;}' , `time` = '1745607338'
1 × UPDATE `hp_extensions`
SET `params` = '{\"mediaversion\":\"7068baba323e770e913bc98790fbb704\"}'