Hôm nay, chúng ta tiếp tục bàn luận, xem xét sự khác nhau giữa hai chuẩn RS232/RS485 các bạn nhé!

Như các bạn biết, RS232 có định nghĩa chuẩn giao diện cơ học ( giắc cắm), ở các máy tính PC đều có cổng truyền thông theo chuẩn RS-232 mà ta hay gọi là cổng COM. Còn RS485, thì ta hay thấy nó được truyền trên 2 dây, và khoảng cách xa hơn nhiều so với RS232. Vậy, sự khác nhau cơ bản giữa hai chuẩn này là gì?

Hình dưới sẽ cho chúng ta cái nhìn cơ bản sự khác nhau về mặt vật lý như: độ dài đường truyền, chế độ truyền thông, mức logic vật lý, dải tốc độ truyền thông,....

Ngoài ra, hai chuẩn này có một sư khác nhau cơ bản là ở phương thức truyền dẫn tín hiệu, hay hiểu nôm na là cách thức hoạt động:

  • RS-232 cho phép sử dụng tối thiểu 3 dây: Tx ( truyền), RX ( nhận) và GND ( đất). Trong đó, trạng thái logic của tín hiệu sử dụng mức chênh áp giữa TX và RX so với dây đất GND.
  • RS-485 sử dụng chênh lệch điện áp giữa 2 dây A và B để phân biệt logic 0 và 1,  chứ không so với đất. Đặc biệt, khi truyền tín hiệu xa, nếu có sụt áp thì đồng thời sụt trên cả 2 dây nên tín hiệu vẫn đảm bảo.

Chính vì vậy mà RS485 cho phép truyền tín hiệu xa hơn và tốc độ truyền cho phép cũng cao hơn RS232.

Thêm nữa, RS485 cho phép liên kết đa điểm, gồm nhiều thiết bị có thể truyền thông trong 1 mạng còn RS232 thì chỉ truyền theo phương thức điểm - điểm, tức là khi hai thiết bị đang trực tiếp kết nối truyền thông với nhau thì không thể có thiết bị thứ 3 cùng tham gia vào trao đổi dữ liệu được.

Xem tiếp: Sự khác nhau giữa truyền thông RS485 và RS422

"BKAII - Thiết bị truyền thông TỐT nhất với giá CẠNH TRANH nhất!"


 
 

Số lượng người đang truy cập...

Không thể hiển thị dữ liệu người dùng trực tuyến vào lúc này.

 
36.641MBMemory Usage541msRequest Duration
Joomla! Version4.4.13
PHP Version8.1.32
Identityguest
Response200
Templatet3_bs3_blank
Database
Server
mysql
Version
10.11.8-MariaDB
Collation
latin1_swedish_ci
Conn Collation
utf8mb4_general_ci
$_GET
array:1 [ "srsltid" => "AfmBOoo_XXOUmglxRzdc3ezgTGOQI9MOGDzYCCXwM6WnkHJyXhIUOncK" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:50 [ "PATH" => "/usr/local/bin:/bin:/usr/bin" "HTTP_ACCEPT" => "text/html,application/xhtm...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1749683813 "last" => 1749683813...
registry
array:3 [ "data" => array:3 [ "current_theme" => "red" "current_direction" => "ltr" "c...
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (4.1MB) (24.41ms)
  • afterInitialise (7.13MB) (76.23ms)
  • afterRoute (4.35MB) (69.57ms)
  • beforeRenderComponent com_content (380.31KB) (5.42ms)
  • Before Access::preloadComponents (all components) (477.52KB) (5.78ms)
  • After Access::preloadComponents (all components) (121.71KB) (1.06ms)
  • Before Access::preloadPermissions (com_content) (4.07KB) (30μs)
  • After Access::preloadPermissions (com_content) (1.09MB) (4.7ms)
  • Before Access::getAssetRules (id:265 name:com_content.article.101) (66.8KB) (112μs)
  • After Access::getAssetRules (id:265 name:com_content.article.101) (26.37KB) (499μs)
  • afterRenderComponent com_content (2.73MB) (41.13ms)
  • afterDispatch (2.33KB) (281μs)
  • beforeRenderModule mod_custom ( Mạng xã hội & Thống kê truy cập) (1.87MB) (32.65ms)
  • afterRenderRawModule mod_custom ( Mạng xã hội & Thống kê truy cập) (35.91KB) (1.83ms)
  • beforeRenderModule mod_custom ( Mạng xã hội & Thống kê truy cập) (752B) (11μs)
  • afterRenderModule mod_custom ( Mạng xã hội & Thống kê truy cập) (31.73KB) (660μs)
  • beforeRenderModule mod_custom (Công ty TNHH Tự động hóa và Tin học công nghiệp Bách Khoa (BKAII)) (1.01KB) (78μs)
  • afterRenderRawModule mod_custom (Công ty TNHH Tự động hóa và Tin học công nghiệp Bách Khoa (BKAII)) (2.22KB) (219μs)
  • beforeRenderModule mod_custom (Công ty TNHH Tự động hóa và Tin học công nghiệp Bách Khoa (BKAII)) (800B) (9μs)
  • afterRenderModule mod_custom (Công ty TNHH Tự động hóa và Tin học công nghiệp Bách Khoa (BKAII)) (2.09KB) (216μs)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (824B) (73μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (36.76KB) (1.65ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (9μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.7KB) (295μs)
  • beforeRenderModule mod_whosonline (Số lượng người đang truy cập...) (760B) (87μs)
  • afterRenderRawModule mod_whosonline (Số lượng người đang truy cập...) (9.6KB) (829μs)
  • beforeRenderModule mod_whosonline (Số lượng người đang truy cập...) (752B) (10μs)
  • afterRenderModule mod_whosonline (Số lượng người đang truy cập...) (1.98KB) (245μs)
  • beforeRenderModule mod_articles_latest (Bài viết mới cập nhật...) (520B) (82μs)
  • afterRenderRawModule mod_articles_latest (Bài viết mới cập nhật...) (217.38KB) (91.86ms)
  • beforeRenderModule mod_articles_latest (Bài viết mới cập nhật...) (736B) (12μs)
  • afterRenderModule mod_articles_latest (Bài viết mới cập nhật...) (1.8KB) (194μs)
  • beforeRenderModule mod_menu (Main Menu) (2.13KB) (70μs)
  • afterRenderRawModule mod_menu (Main Menu) (9.1MB) (56.14ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (13μs)
  • afterRenderModule mod_menu (Main Menu) (1.84KB) (202μs)
  • beforeRenderModule mod_articles_categories (Demo Categories) (1.48KB) (35μs)
  • afterRenderRawModule mod_articles_categories (Demo Categories) (66.68KB) (2.22ms)
  • beforeRenderModule mod_articles_categories (Demo Categories) (720B) (8μs)
  • afterRenderModule mod_articles_categories (Demo Categories) (1.78KB) (168μs)
  • beforeRenderModule mod_finder (Smart Search Module) (344B) (63μs)
  • afterRenderRawModule mod_finder (Smart Search Module) (454.68KB) (8.05ms)
  • beforeRenderModule mod_finder (Smart Search Module) (720B) (8μs)
  • afterRenderModule mod_finder (Smart Search Module) (1.73KB) (174μs)
  • afterRender (3.52MB) (113ms)
  • 1 x afterRender (3.52MB) (20.87%)
    112.97ms
    1 x afterRenderRawModule mod_articles_latest (Bài viết mới cập nhật...) (217.38KB) (16.97%)
    91.86ms
    1 x afterInitialise (7.13MB) (14.08%)
    76.23ms
    1 x afterRoute (4.35MB) (12.85%)
    69.57ms
    1 x afterRenderRawModule mod_menu (Main Menu) (9.1MB) (10.37%)
    56.14ms
    1 x afterRenderComponent com_content (2.73MB) (7.6%)
    41.13ms
    1 x beforeRenderModule mod_custom ( Mạng xã hội & Thống kê truy cập) (1.87MB) (6.03%)
    32.65ms
    1 x afterLoad (4.1MB) (4.51%)
    24.41ms
    1 x afterRenderRawModule mod_finder (Smart Search Module) (454.68KB) (1.49%)
    8.05ms
    1 x Before Access::preloadComponents (all components) (477.52KB) (1.07%)
    5.78ms
    1 x beforeRenderComponent com_content (380.31KB) (1%)
    5.42ms
    1 x After Access::preloadPermissions (com_content) (1.09MB) (0.87%)
    4.70ms
    1 x afterRenderRawModule mod_articles_categories (Demo Categories) (66.68KB) (0.41%)
    2.22ms
    1 x afterRenderRawModule mod_custom ( Mạng xã hội & Thống kê truy cập) (35.91KB) (0.34%)
    1.83ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (36.76KB) (0.31%)
    1.65ms
    1 x After Access::preloadComponents (all components) (121.71KB) (0.2%)
    1.06ms
    1 x afterRenderRawModule mod_whosonline (Số lượng người đang truy cập...) (9.6KB) (0.15%)
    829μs
    1 x afterRenderModule mod_custom ( Mạng xã hội & Thống kê truy cập) (31.73KB) (0.12%)
    660μs
    1 x After Access::getAssetRules (id:265 name:com_content.article.101) (26.37KB) (0.09%)
    499μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.7KB) (0.05%)
    295μs
    1 x afterDispatch (2.33KB) (0.05%)
    281μs
    1 x afterRenderModule mod_whosonline (Số lượng người đang truy cập...) (1.98KB) (0.05%)
    245μs
    1 x afterRenderRawModule mod_custom (Công ty TNHH Tự động hóa và Tin học công nghiệp Bách Khoa (BKAII)) (2.22KB) (0.04%)
    219μs
    1 x afterRenderModule mod_custom (Công ty TNHH Tự động hóa và Tin học công nghiệp Bách Khoa (BKAII)) (2.09KB) (0.04%)
    216μs
    1 x afterRenderModule mod_menu (Main Menu) (1.84KB) (0.04%)
    202μs
    1 x afterRenderModule mod_articles_latest (Bài viết mới cập nhật...) (1.8KB) (0.04%)
    194μs
    1 x afterRenderModule mod_finder (Smart Search Module) (1.73KB) (0.03%)
    174μs
    1 x afterRenderModule mod_articles_categories (Demo Categories) (1.78KB) (0.03%)
    168μs
    1 x Before Access::getAssetRules (id:265 name:com_content.article.101) (66.8KB) (0.02%)
    112μs
    1 x beforeRenderModule mod_whosonline (Số lượng người đang truy cập...) (760B) (0.02%)
    87μs
    1 x beforeRenderModule mod_articles_latest (Bài viết mới cập nhật...) (520B) (0.02%)
    82μs
    1 x beforeRenderModule mod_custom (Công ty TNHH Tự động hóa và Tin học công nghiệp Bách Khoa (BKAII)) (1.01KB) (0.01%)
    78μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (824B) (0.01%)
    73μs
    1 x beforeRenderModule mod_menu (Main Menu) (2.13KB) (0.01%)
    70μs
    1 x beforeRenderModule mod_finder (Smart Search Module) (344B) (0.01%)
    63μs
    1 x beforeRenderModule mod_articles_categories (Demo Categories) (1.48KB) (0.01%)
    35μs
    1 x Before Access::preloadPermissions (com_content) (4.07KB) (0.01%)
    30μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
    13μs
    1 x beforeRenderModule mod_articles_latest (Bài viết mới cập nhật...) (736B) (0%)
    12μs
    1 x beforeRenderModule mod_custom ( Mạng xã hội & Thống kê truy cập) (752B) (0%)
    11μs
    1 x beforeRenderModule mod_whosonline (Số lượng người đang truy cập...) (752B) (0%)
    10μs
    1 x beforeRenderModule mod_custom (Công ty TNHH Tự động hóa và Tin học công nghiệp Bách Khoa (BKAII)) (800B) (0%)
    9μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    9μs
    1 x beforeRenderModule mod_articles_categories (Demo Categories) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_finder (Smart Search Module) (720B) (0%)
    8μs
36 statements were executed, 7 of which were duplicates, 29 unique103ms2.92MB
  • SELECT @@SESSION.sql_mode;61μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `idc_session` WHERE `session_id` = ?136μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `idc_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1266μs1.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `idc_viewlevels`82μs976B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `idc_usergroups` AS `a` LEFT JOIN `idc_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest129μs2.27KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `idc_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`563μs4.3KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `m`.`id`,`m`.`menutype`,`m`.`title`,`m`.`alias`,`m`.`note`,`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`,`m`.`path` AS `route`,`e`.`element` AS `component` FROM `idc_menu` AS `m` LEFT JOIN `idc_extensions` AS `e` ON `m`.`component_id` = `e`.`extension_id` WHERE ( (`m`.`published` = 1 AND `m`.`parent_id` > 0 AND `m`.`client_id` = 0) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :currentDate1)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :currentDate2) ORDER BY `m`.`lft`5.02ms820.55KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `idc_categories` AS `s` INNER JOIN `idc_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`329μs5.13KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `idc_template_styles` AS `s` LEFT JOIN `idc_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` = 1231μs2.45KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT * FROM `idc_languages` WHERE `published` = 1 ORDER BY `ordering` ASC184μs2.22KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `idc_assets` WHERE `name` IN (:preparedArray1,:preparedArray2,:preparedArray3,:preparedArray4,:preparedArray5,:preparedArray6,:preparedArray7,:preparedArray8,:preparedArray9,:preparedArray10,:preparedArray11,:preparedArray12,:preparedArray13,:preparedArray14,:preparedArray15,:preparedArray16,:preparedArray17,:preparedArray18,:preparedArray19,:preparedArray20,:preparedArray21,:preparedArray22,:preparedArray23,:preparedArray24,:preparedArray25,:preparedArray26,:preparedArray27,:preparedArray28,:preparedArray29,:preparedArray30,:preparedArray31,:preparedArray32,:preparedArray33,:preparedArray34,:preparedArray35,:preparedArray36,:preparedArray37,:preparedArray38,:preparedArray39,:preparedArray40,:preparedArray41,:preparedArray42,:preparedArray43,:preparedArray44)520μs8.12KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `idc_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 01.37ms173.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `idc_content`554μs2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `idc_content` SET `hits` = (`hits` + 1) WHERE `id` = '101'256μs48B/libraries/src/Table/Table.php:1325Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`state`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`version`,`a`.`ordering`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`metadata`,`a`.`featured`,`a`.`language`,`fp`.`featured_up`,`fp`.`featured_down`,`c`.`title` AS `category_title`,`c`.`alias` AS `category_alias`,`c`.`access` AS `category_access`,`c`.`language` AS `category_language`,`fp`.`ordering`,`u`.`name` AS `author`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1) AS `rating`,`v`.`rating_count` AS `rating_count` FROM `idc_content` AS `a` INNER JOIN `idc_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `idc_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `idc_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `idc_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `idc_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE ( (`a`.`id` = :pk AND `c`.`published` > 0) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND `a`.`state` IN (:preparedArray1,:preparedArray2)439μs24.63KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `idc_categories` AS `s` INNER JOIN `idc_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`318μs5.17KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `idc_contentitem_tag_map` AS `m` INNER JOIN `idc_tags` AS `t` ON `m`.`tag_id` = `t`.`id` WHERE `m`.`type_alias` = :contentType AND `m`.`content_item_id` = :id AND `t`.`published` = 1 AND `t`.`access` IN (:preparedArray1,:preparedArray2)261μs7.72KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `idc_categories` AS `s` INNER JOIN `idc_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`351μs5.17KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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, a.only_use_in_subform,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 idc_fields AS a LEFT JOIN `idc_languages` AS l ON l.lang_code = a.language LEFT JOIN idc_users AS uc ON uc.id=a.checked_out LEFT JOIN idc_viewlevels AS ag ON ag.id = a.access LEFT JOIN idc_users AS ua ON ua.id = a.created_user_id LEFT JOIN idc_fields_groups AS g ON g.id = a.group_id LEFT JOIN `idc_fields_categories` AS fc ON fc.field_id = a.id WHERE ( (`a`.`context` = :context AND (`fc`.`category_id` IS NULL OR `fc`.`category_id` IN (:preparedArray1,:preparedArray2,:preparedArray3)) AND `a`.`access` IN (:preparedArray4,:preparedArray5)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray6,:preparedArray7)) AND `a`.`state` = :state) AND (`a`.`group_id` = 0 OR `g`.`state` = :gstate) AND `a`.`only_use_in_subform` = :only_use_in_subform ORDER BY a.ordering ASC856μs6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`catid`,`a`.`language`, CASE WHEN CHAR_LENGTH(`a`.`alias`) != 0 THEN CONCAT_WS(':', `a`.`id`, `a`.`alias`) ELSE a.id END AS `slug`, CASE WHEN CHAR_LENGTH(`cc`.`alias`) != 0 THEN CONCAT_WS(':', `cc`.`id`, `cc`.`alias`) ELSE cc.id END AS `catslug` FROM `idc_content` AS `a` LEFT JOIN `idc_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND `a`.`access` IN (:preparedArray1,:preparedArray2) AND (`publish_up` IS NULL OR `publish_up` <= :nowDate1) AND (`publish_down` IS NULL OR `publish_down` >= :nowDate2) ORDER BY CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END DESC822μs19.53KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `idc_categories` AS `s` INNER JOIN `idc_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`360μs5.17KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `idc_modules` AS `m` LEFT JOIN `idc_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `idc_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`.`client_id` = :clientId AND `m`.`access` IN (:preparedArray1,:preparedArray2)) AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown)) AND (`mm`.`menuid` = :itemId OR `mm`.`menuid` <= 0) ORDER BY `m`.`position`,`m`.`ordering`1.93ms1.36MBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `a`.`id`,`a`.`title`,`a`.`alias`,`a`.`introtext`,`a`.`fulltext`,`a`.`checked_out`,`a`.`checked_out_time`,`a`.`catid`,`a`.`created`,`a`.`created_by`,`a`.`created_by_alias`,`a`.`modified`,`a`.`modified_by`,CASE WHEN `a`.`publish_up` IS NULL THEN `a`.`created` ELSE `a`.`publish_up` END AS `publish_up`,`a`.`publish_down`,`a`.`images`,`a`.`urls`,`a`.`attribs`,`a`.`metadata`,`a`.`metakey`,`a`.`metadesc`,`a`.`access`,`a`.`hits`,`a`.`featured`,`a`.`language`,LENGTH(`a`.`fulltext`) AS `readmore`,`a`.`ordering`,`fp`.`featured_up`,`fp`.`featured_down`,CASE WHEN `c`.`published` = 2 AND `a`.`state` > 0 THEN 2 WHEN `c`.`published` != 1 THEN 0 ELSE `a`.`state` END AS `state`,`c`.`title` AS `category_title`,`c`.`path` AS `category_route`,`c`.`access` AS `category_access`,`c`.`alias` AS `category_alias`,`c`.`language` AS `category_language`,`c`.`published`,`c`.`published` AS `parents_published`,`c`.`lft`,CASE WHEN `a`.`created_by_alias` > ' ' THEN `a`.`created_by_alias` ELSE `ua`.`name` END AS `author`,`ua`.`email` AS `author_email`,`uam`.`name` AS `modified_by_name`,`parent`.`title` AS `parent_title`,`parent`.`id` AS `parent_id`,`parent`.`path` AS `parent_route`,`parent`.`alias` AS `parent_alias`,`parent`.`language` AS `parent_language`,COALESCE(NULLIF(ROUND(`v`.`rating_sum` / `v`.`rating_count`, 1), 0), 0) AS `rating`,COALESCE(NULLIF(`v`.`rating_count`, 0), 0) AS `rating_count` FROM `idc_content` AS `a` LEFT JOIN `idc_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `idc_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `idc_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `idc_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `idc_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `idc_content_rating` AS `v` ON `a`.`id` = `v`.`content_id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY a.created DESC LIMIT 1584.95ms309.09KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:166Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `idc_categories` AS `s` INNER JOIN `idc_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`528μs5.17KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM idc_hikashop_config572μs152.94KB/administrator/components/com_hikashop/classes/config.php:16Copy
  • SET sql_mode=(SELECT REPLACE(REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''), 'STRICT_TRANS_TABLES', ''));59μs0B/administrator/components/com_hikashop/helpers/helper.php:3422Copy
  • SELECT `c`.`id`,`c`.`asset_id`,`c`.`access`,`c`.`alias`,`c`.`checked_out`,`c`.`checked_out_time`,`c`.`created_time`,`c`.`created_user_id`,`c`.`description`,`c`.`extension`,`c`.`hits`,`c`.`language`,`c`.`level`,`c`.`lft`,`c`.`metadata`,`c`.`metadesc`,`c`.`metakey`,`c`.`modified_time`,`c`.`note`,`c`.`params`,`c`.`parent_id`,`c`.`path`,`c`.`published`,`c`.`rgt`,`c`.`title`,`c`.`modified_user_id`,`c`.`version`, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as `slug` FROM `idc_categories` AS `s` INNER JOIN `idc_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`511μs5.14KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `name`,`element` FROM `idc_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1464μs928B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `idc_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1,5)204μs968B/administrator/components/com_finder/src/Indexer/Taxonomy.php:314Copy
  • SELECT SUM(CASE WHEN `a`.`next_execution` <= :now THEN 1 ELSE 0 END) AS due_count,SUM(CASE WHEN `a`.`locked` IS NULL THEN 0 ELSE 1 END) AS locked_count FROM `idc_scheduler_tasks` AS `a` WHERE `a`.`state` = 1198μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `alias` FROM `idc_content` WHERE `id` = :id109μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `idc_content` WHERE `id` = :id78μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `idc_content` WHERE `id` = :id79μs12.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `idc_content` WHERE `id` = :id85μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `session_id` FROM `idc_session` WHERE `session_id` = ?97μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • INSERT INTO `idc_session` (`data`,`time`,`session_id`) VALUES (?, ?, ?)238μs864BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy