SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('options', 'languages', 'contentTypes', 'codeEventListeners', 'deferredRun', 'simpleCache', 'addOns', 'defaultStyleProperties', 'routeFiltersIn', 'routeFiltersOut', 'routesPublic', 'nodeTypes', 'bannedIps', 'discouragedIps', 'styles', 'displayStyles', 'userBanners', 'smilies', 'bbCode', 'threadPrefixes', 'userTitleLadder', 'reportCounts', 'moderationCounts', 'userModerationCounts', 'notices', 'userFieldsInfo')
Run Time: 0.000548
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 26 | Using where |
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('brListenerClasses', 'brBriviumAddOns')
Run Time: 0.000218
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 2 | Using where |
SELECT *
FROM xf_brivium_addon
ORDER BY addon_id
Run Time: 0.000143
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_brivium_addon | index | | PRIMARY | 77 | | 1 | |
INSERT INTO xf_data_registry
(data_key, data_value)
VALUES
(?, ?)
ON DUPLICATE KEY UPDATE
data_value = VALUES(data_value)
Params: brBriviumAddOns, a:0:{}
Run Time: 0.000165
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000204
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 7d181a792f726c5a739708ecd8c47291, , 1701661281
Run Time: 0.000222
INSERT INTO xf_session_activity
(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date, robot_key)
VALUES
(?, ?, ?, ?, ?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
ip = VALUES(ip),
controller_name = VALUES(controller_name),
controller_action = VALUES(controller_action),
view_state = VALUES(view_state),
params = VALUES(params),
view_date = VALUES(view_date),
robot_key = VALUES(robot_key)
Params: 0, , , EWRporta_ControllerPublic_Portal, Index, valid, , 1701657681,
Run Time: 0.000128
SELECT *
FROM EWRporta_layouts
WHERE layout_id = ?
Params: portal
Run Time: 0.000204
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_layouts | const | PRIMARY | PRIMARY | 77 | const | 1 | |
SELECT *, 'disabled' AS position
FROM EWRporta_blocks
WHERE active = 1
ORDER BY block_id ASC
Run Time: 0.000247
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_blocks | index | | PRIMARY | 77 | | 16 | Using where |
SELECT * FROM EWRporta_caches
Run Time: 0.000241
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_caches | ALL | | | | | 6 | |
SELECT * FROM EWRporta_options
Run Time: 0.000507
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_options | ALL | | | | | 73 | |
SELECT xf_thread.*, xf_user.*, xf_post.message, xf_post.attach_count, xf_node.title AS node_title,
IF(xf_user.username IS NULL, xf_thread.username, xf_user.username) AS username,
IF(EWRporta_promotes.promote_date IS NULL, xf_thread.post_date, EWRporta_promotes.promote_date) AS promote_date,
EWRporta_promotes.promote_icon, EWRporta_promotes.promote_data
FROM xf_thread
LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
INNER JOIN xf_node ON (xf_node.node_id = xf_thread.node_id)
LEFT JOIN EWRporta_promotes ON (EWRporta_promotes.thread_id = xf_thread.thread_id)
WHERE ( xf_thread.node_id IN ('1', '2', '3', '4', '50', '5', '6', '7', '8', '51', '9', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '26', '27') OR EWRporta_promotes.promote_date < ? )
AND xf_thread.discussion_state = 'visible'
AND IF(EWRporta_promotes.promote_date IS NULL, xf_thread.post_date, EWRporta_promotes.promote_date) < ?
ORDER BY promote_date DESC
LIMIT ?, ?
Params: 1701657681, 1701657681, 0, 5
Run Time: 0.018316
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | ALL | node_id_last_post_date,node_id_sticky_state_last_post | | | | 889 | Using where; Using temporary; Using filesort |
SIMPLE | EWRporta_promotes | ALL | PRIMARY | | | | 1 | Using where; Using join buffer (Block Nested Loop) |
SIMPLE | xf_node | eq_ref | PRIMARY | PRIMARY | 4 | vungtauc_br.xf_thread.node_id | 1 | |
SIMPLE | xf_post | eq_ref | PRIMARY | PRIMARY | 4 | vungtauc_br.xf_thread.first_post_id | 1 | |
SIMPLE | xf_user | eq_ref | PRIMARY | PRIMARY | 4 | vungtauc_br.xf_thread.user_id | 1 | |
SELECT *
FROM EWRporta_categories
INNER JOIN EWRporta_catlinks ON (EWRporta_catlinks.category_id = EWRporta_categories.category_id)
WHERE thread_id = ?
ORDER BY EWRporta_categories.category_type ASC, EWRporta_categories.category_name ASC
Params: 3111
Run Time: 0.000207
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_categories | ALL | PRIMARY | | | | 1 | Using filesort |
SIMPLE | EWRporta_catlinks | eq_ref | category_id | category_id | 8 | vungtauc_br.EWRporta_categories.category_id,const | 1 | Using index |
SELECT *
FROM EWRporta_categories
INNER JOIN EWRporta_catlinks ON (EWRporta_catlinks.category_id = EWRporta_categories.category_id)
WHERE thread_id = ?
ORDER BY EWRporta_categories.category_type ASC, EWRporta_categories.category_name ASC
Params: 3110
Run Time: 0.000162
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_categories | ALL | PRIMARY | | | | 1 | Using filesort |
SIMPLE | EWRporta_catlinks | eq_ref | category_id | category_id | 8 | vungtauc_br.EWRporta_categories.category_id,const | 1 | Using index |
SELECT attachment.*,
data.filename, data.file_size, data.file_hash, data.file_path, data.width, data.height, data.thumbnail_width, data.thumbnail_height
FROM xf_attachment AS attachment
INNER JOIN xf_attachment_data AS data ON
(data.data_id = attachment.data_id)
WHERE attachment.content_type = ?
AND attachment.content_id IN (3498)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000281
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | vungtauc_br.attachment.data_id | 1 | |
SELECT *
FROM EWRporta_categories
INNER JOIN EWRporta_catlinks ON (EWRporta_catlinks.category_id = EWRporta_categories.category_id)
WHERE thread_id = ?
ORDER BY EWRporta_categories.category_type ASC, EWRporta_categories.category_name ASC
Params: 3109
Run Time: 0.000167
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_categories | ALL | PRIMARY | | | | 1 | Using filesort |
SIMPLE | EWRporta_catlinks | eq_ref | category_id | category_id | 8 | vungtauc_br.EWRporta_categories.category_id,const | 1 | Using index |
SELECT *
FROM EWRporta_categories
INNER JOIN EWRporta_catlinks ON (EWRporta_catlinks.category_id = EWRporta_categories.category_id)
WHERE thread_id = ?
ORDER BY EWRporta_categories.category_type ASC, EWRporta_categories.category_name ASC
Params: 3108
Run Time: 0.000181
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_categories | ALL | PRIMARY | | | | 1 | Using filesort |
SIMPLE | EWRporta_catlinks | eq_ref | category_id | category_id | 8 | vungtauc_br.EWRporta_categories.category_id,const | 1 | Using index |
SELECT attachment.*,
data.filename, data.file_size, data.file_hash, data.file_path, data.width, data.height, data.thumbnail_width, data.thumbnail_height
FROM xf_attachment AS attachment
INNER JOIN xf_attachment_data AS data ON
(data.data_id = attachment.data_id)
WHERE attachment.content_type = ?
AND attachment.content_id IN (3496)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000265
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | vungtauc_br.attachment.data_id | 1 | |
SELECT *
FROM EWRporta_categories
INNER JOIN EWRporta_catlinks ON (EWRporta_catlinks.category_id = EWRporta_categories.category_id)
WHERE thread_id = ?
ORDER BY EWRporta_categories.category_type ASC, EWRporta_categories.category_name ASC
Params: 3107
Run Time: 0.000181
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_categories | ALL | PRIMARY | | | | 1 | Using filesort |
SIMPLE | EWRporta_catlinks | eq_ref | category_id | category_id | 8 | vungtauc_br.EWRporta_categories.category_id,const | 1 | Using index |
SELECT COUNT(*) AS total
FROM xf_thread
LEFT JOIN EWRporta_promotes ON (EWRporta_promotes.thread_id = xf_thread.thread_id)
WHERE (xf_thread.node_id IN ('1', '2', '3', '4', '50', '5', '6', '7', '8', '51', '9', '10', '11', '12', '13', '14', '15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '26', '27') OR EWRporta_promotes.promote_date < ?)
AND xf_thread.discussion_state = 'visible'
AND IF(EWRporta_promotes.promote_date IS NULL, xf_thread.post_date, EWRporta_promotes.promote_date) < ?
Params: 1701657681, 1701657681
Run Time: 0.000961
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_thread | ALL | node_id_last_post_date,node_id_sticky_state_last_post | | | | 889 | Using where |
SIMPLE | EWRporta_promotes | ALL | PRIMARY | | | | 1 | Using where; Using join buffer (Block Nested Loop) |
SELECT *
FROM EWRporta_caches
WHERE block_id = ?
Params: RecentNews
Run Time: 0.000242
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_caches | const | PRIMARY | PRIMARY | 77 | const | 1 | |
SELECT *
FROM EWRporta_caches
WHERE block_id = ?
Params: RecentNews
Run Time: 0.000127
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | EWRporta_caches | const | PRIMARY | PRIMARY | 77 | const | 1 | |
begin
Run Time: 0.000143
UPDATE `EWRporta_caches` SET `results` = ?, `date` = ? WHERE (block_id = 'RecentNews')
Params: a:2:{s:6:"option";a:9:{s:5:"forum";a:29:{i:0;s:1:"1";i:1;s:1:"2";i:2;s:1:"3";i:3;s:1:"4";i:4;s:2:"50";i:5;s:1:"5";i:6;s:1:"6";i:7;s:1:"7";i:8;s:1:"8";i:9;s:2:"51";i:10;s:1:"9";i:11;s:2:"10";i:12;s:2:"11";i:13;s:2:"12";i:14;s:2:"13";i:15;s:2:"14";i:16;s:2:"15";i:17;s:2:"16";i:18;s:2:"17";i:19;s:2:"18";i:20;s:2:"19";i:21;s:2:"20";i:22;s:2:"21";i:23;s:2:"22";i:24;s:2:"23";i:25;s:2:"24";i:26;s:2:"25";i:27;s:2:"26";i:28;s:2:"27";}s:8:"leftdate";s:1:"1";s:5:"limit";s:1:"5";s:7:"pagenav";s:1:"1";s:6:"social";s:1:"0";s:6:"sticky";s:1:"0";s:8:"truncate";s:4:"1000";s:7:"parseBB";b:1;s:5:"count";i:726;}s:10:"RecentNews";a:5:{i:0;a:59:{s:9:"thread_id";i:3111;s:7:"node_id";i:20;s:5:"title";s:91:"Công ty Cổ phần Dịch vụ Kỹ thuật Vina O&M (Vina O&M) tuyển dụng nhân sự";s:11:"reply_count";i:0;s:10:"view_count";i:37;s:7:"user_id";i:1;s:8:"username";s:5:"Admin";s:9:"post_date";i:1701400326;s:6:"sticky";i:0;s:16:"discussion_state";s:7:"visible";s:15:"discussion_open";i:1;s:15:"discussion_type";s:0:"";s:13:"first_post_id";i:3499;s:16:"first_post_likes";i:0;s:14:"last_post_date";i:1701400326;s:12:"last_post_id";i:3499;s:17:"last_post_user_id";i:1;s:18:"last_post_username";s:5:"Admin";s:9:"prefix_id";i:9;s:4:"tags";s:6:"a:0:{}";s:5:"email";s:25:"hoangnghiathanh@gmail.com";s:6:"gender";s:0:"";s:12:"custom_title";s:0:"";s:11:"language_id";i:2;s:8:"style_id";i:0;s:8:"timezone";s:13:"Europe/London";s:7:"visible";i:1;s:16:"activity_visible";i:1;s:13:"user_group_id";i:3;s:19:"secondary_group_ids";s:1:"4";s:22:"display_style_group_id";i:3;s:25:"permission_combination_id";i:7;s:13:"message_count";i:322;s:20:"conversations_unread";i:0;s:13:"register_date";i:1459585297;s:13:"last_activity";i:1701400327;s:13:"trophy_points";i:18;s:13:"alerts_unread";i:0;s:11:"avatar_date";i:1461896367;s:12:"avatar_width";i:192;s:13:"avatar_height";i:192;s:8:"gravatar";s:0:"";s:10:"user_state";s:5:"valid";s:12:"is_moderator";i:1;s:8:"is_admin";i:1;s:9:"is_banned";i:0;s:10:"like_count";i:8;s:14:"warning_points";i:0;s:8:"is_staff";i:1;s:7:"message";s:1263:"Công ty Cổ phần Dịch vụ Kỹ thuật Vina O&M (Vina O&M) chuyên cung cấp dịch vụ kỹ thuật (bao gồm Chiến dịch bảo trì dài hạn và Đại tu/Tuần hoàn; Bảo trì chung và Bảo trì đặc biệt; Quản lý dự án cho các nhà máy và công trình lớn), cung cấp vật tư thiết bị, kiểm tra nhà máy, bảo trì van, bảo trì thiết bị hiện trường, v.v.) cho các ngành Dầu khí, Hóa dầu, Đóng tàu & Cơ khí Hàng hải, Nhà máy Sản xuất, Điện gió, v.v. Theo kế hoạch triển khai dự án trong thời gian tới, Vina O&M có nhu cầu tuyển dụng nhân sự như sau:
[B]1. Nhân viên thương mại[/B]
Số lượng: 02 người.
Mô tả công việc:
[LIST]
[*]Soạn thảo, theo dõi hợp đồng thương mại, lập phương án kinh doanh.
[*]Theo dõi việc xuất - nhập - lưu kho vật tư.
[*]Các công việc khác theo yêu cầu của ban Lãnh đạo.
[/LIST]
Yêu cầu công việc:
[LIST]
[*]Trình độ chuyên môn: ĐH nghành Quản trị KD, Kinh doanh - Thương mại, ĐH Kỹ thuật.
[*]Kinh nghiệm: Trên 02 năm.
[*]Độ tuổi Nam trên 23 tuổi.
[*]Tiếng Anh khá, có thể xử lý các đơn hàng bằng tiếng...";s:12:"attach_count";i:0;s:10:"node_title";s:26:"Dầu khí - Địa chất";s:12:"promote_date";i:1701400326;s:12:"promote_icon";N;s:12:"promote_data";s:54:"https://tapchitoaan.vn/media/images/Anh%203%20(15).jpg";s:10:"categories";a:0:{}s:3:"day";s:2:"01";s:5:"month";O:14:"XenForo_Phrase":4:{s:14:"