USR-N540: Chuyển đổi 4 cổng RS232/RS485/RS422 sang Ethernet

5 5 21 Product
Giá: Liên hệ

USR-N540 Bộ chuyển đổi tín hiệu đồng thời 4 cổng RS232/RS485/RS422 sang Ethernet của hãng USR hiện đang được BKAII phân phối rộng rãi tại thị trường Việt Nam. USR-N540  được thiết kế theo tiêu chuẩn công nghiệp, nhỏ gọn, dễ dàng lấy được tín hiệu về PLC, máy tính, vi xử lý, máy tính nhúng. Sản phẩm hiện đang được sử dụng trong các bài toán M2M, IoT của các lĩnh vực: Điện lực, khí tượng thủy văn, giao thông thông minh, hệ thống kiểm soát an ninh,…

Tính năng của sản phẩm:

  • TI Cortex-M4 kernel,industrial working temperature range and TCPIP protocol stack.
  • Auto-MDI/MDIX,RJ45 port with 10/100Mbps
  • TCP Server,TCP Client,UDP Client,UDP Server and HTTPD Client work mode
  • 4 ports can work independently at the same time
  • Can distinguish which serial port connects to the device via port number
  • Support virtual serial port and provide corresponding software USR-VCOM
  • Serial baud rate from 600bps to 230.4K bps
  • DNS and DHCP supported
  • Provide PC TCP/IP socket programming example such as VB,C++,Delphi,Android and IOS
  • Built-in webpage;also can customize webpage for users
  • The global unique MAC address bought from IEEE (begin with D8-B0-4C);user can define MAC address
  • Support upgrade firmware via network
  • Support keepalive,rapidly detect dead links
  • Support account and password,can be used to page login and network settings
  • Support one channel Websocket,realize bidirectional transparent transmission between webpage and serial 0
  • Support Modbus RTU to Modbus TCP
  • Support UDP broadcast function
  • Each serial can work as rs232,rs485 or rs422; Default port is RS232 BD9 male port
  • Four channel serial communication indicator: TX/RX, CTS/RTS, XON/XOFF
  • Support DC adapter and 5.08-2 terminal power supply
  • Reload button,one key to restore default settings
  • RJ45 with Link/Data indicator light,built-in isolation transformer and 2 KV electromagnetic isolation

 Thông số kỹ thuật của sản phẩm:

System Information
Processor Cortex-M4
Basic Frequency 120MHz
Flash 512K byte
Ethernet
Port Number 1
Interface Standard 8 pin RJ45
Rate 10/100 Mbps, MDI/MDIX, auto switch between cross and direct connection
Protection 2KV electromagnetism isolation, shell insulation blocking
Network Protocol IP,TCP,UDP,DHCP,DNS,HTTP,ARP,ICMP,Web socket,Httpd client
Receive Buffer Max 16k bytes buffer
Serial
Port Number 4 (Each port can work as RS-232,RS-485 and RS-422, can work at the same time)
Interface Standard RS-232: DB9 pin type, RS-485: 2 wire (A+,B-), RS-422 (A,B,Y,Z)
Data Bits 5,6,7,8
Stop Bit 1,2
Check Bit None,Even,Odd,Space,Mark
Baud Rate 600bps ~ 230.4Kbps
Flow Control RTS/CTS XON XOFF
Buffer Send and receive 2k bytes respectively
Protection RS-485: anti-static 2KV,lightning protection
RS-485 Pull-up and Pull-Down Resistor 2.2 KΩ
Software
Virtual Serial(USR-VCOM) Windows 2000 or higher(32 bit/64 bit)
Configuration Built-in webpage, computer set-up software, serial command
Basic Parameter
Size 222 x 122 x 29 mm (including shell and terminals)
Operating Temp. -40 ~ 85°C (industry)
Storage Temp. -40 ~ 85°C, 5 ~ 95% RH (no condensation)
Input Voltage DC 5 ~ 36V
Working Current 53mA @ 12V

Các bài viết tham khảo:

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

MES600 Series: IEC61850 8 cổng Managed Ethernet Swich với 4 cổng RS232/485/422

Giá: Liên hệ
MES600 Series  Switch công nghiệp được quản lý theo tiêu chuẩ...

EKI-1521: 1-port RS-232/422/485 Serial Device Server

Giá: Liên hệ
EKI-1521 1 cổng RS-232/422/485 Serial Device Server của hãng&nbs...

EKI-1521I: 1-port RS-232/422/485 Serial Device Server with Wide Temperature

Giá: Liên hệ
EKI-1521I 1 cổng RS-232/422/485 Serial Device Server với nhiệt độ hoạt đ�...

NPort 5630-8: Bộ chuyển đổi tín hiệu 08 cổng RS485/422 sang Ethernet

Giá: Liên hệ
NPort 5630-8 Bộ chuyển đổi tín hiệu 08 cổng RS485/422 sang Ethernet dạng rackmoun...

NP318T-8DI(RS-485): Bộ chuyển đổi tín hiệu 8 cổng RS485/422 sang 2 cổng Ethernet

Giá: Liên hệ
NP318T-8DI(RS-485) Bộ chuyển đổi tín hiệu 8 cổng RS485/422 sang 2 cổng Ethe...

NP318T-8D(3IN1)-RJ45: Bộ chuyển đổi tín hiệu 8 cổng RS232/485/422 sang 2 cổng Ethernet tốc độ 10/100Base-T(X)

Giá: Liên hệ
NP318T-8D(3IN1)-RJ45 Bộ chuyển đổi tín hiệu 8 cổng RS232/485/422 sang 2 cổn...

ADAM-4571: Bộ chuyển đổi tín hiệu 1 cổng RS-232/422/485 sang Ethernet

Giá: Liên hệ
ADAM-4571 Bộ chuyển đổi tín hiệu 1 cổng RS-232/422/485 sang Ethernet của hãng&nb...

NPort 5210A: Bộ chuyển đổi 10/100M Ethernet sang 2 cổng RS-232

Giá: Liên hệ
NPort 5210A Bộ chuyển đổi 10/100M Ethernet sang 2 cổng RS-232 của hãng MOXA- Đài ...

Nport 5150A/EU: Bộ chuyển đổi 10/100M Ethernet sang 1 cổng RS-232/485/422

Giá: Liên hệ
Nport 5150A/EU Bộ chuyển đổi tín hiệu từ  RS-232/485/422 sang Ethernet (TCP/IP...

EKI-1521-CE: 1-port RS-232/422/485 Serial Device Server

Giá: Liên hệ
EKI-1521-CE 1 cổng RS-232/422/485 Serial Device Server của hãng A...
Kết quả 241 - 250 of 250

Bài viết mới cập nhật...

40.134MBMemory Usage730msRequest 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:2 [ "limitstart" => "240" "srsltid" => "AfmBOookYjaXMHDSbhN-qnXHHGaekvnY4qlAs0gIPmWHNsVGU2...
$_POST
[]
$_SESSION
array:2 [ "hikashop_viewed_products" => array:1 [ 376 => 376 ] "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" => 1753540280 "last" => 1753540280...
registry
array:3 [ "data" => array:4 [ "com_hikashop" => array:3 [ "ssl_redirect" => 0 "use...
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (4.1MB) (24.79ms)
  • afterInitialise (7.13MB) (62.83ms)
  • afterRoute (10.35MB) (161ms)
  • beforeRenderComponent com_hikashop (25.47KB) (1.3ms)
  • beforeRenderModule mod_hikashop (Associated products listing for category listing menu 648) (5.47MB) (88.74ms)
  • afterRenderRawModule mod_hikashop (Associated products listing for category listing menu 648) (986.71KB) (117ms)
  • beforeRenderModule mod_hikashop (Associated products listing for category listing menu 648) (768B) (12μs)
  • afterRenderModule mod_hikashop (Associated products listing for category listing menu 648) (37.78KB) (567μs)
  • afterRenderComponent com_hikashop (69.8KB) (120μs)
  • afterDispatch (2.95KB) (149μs)
  • beforeRenderModule mod_custom ( Mạng xã hội & Thống kê truy cập) (1.74MB) (20.42ms)
  • afterRenderRawModule mod_custom ( Mạng xã hội & Thống kê truy cập) (15.09KB) (1.03ms)
  • beforeRenderModule mod_custom ( Mạng xã hội & Thống kê truy cập) (752B) (8μs)
  • afterRenderModule mod_custom ( Mạng xã hội & Thống kê truy cập) (2.05KB) (210μ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) (81μs)
  • afterRenderRawModule mod_custom (Công ty TNHH Tự động hóa và Tin học công nghiệp Bách Khoa (BKAII)) (1.09KB) (179μ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) (6μs)
  • afterRenderModule mod_custom (Công ty TNHH Tự động hóa và Tin học công nghiệp Bách Khoa (BKAII)) (3.34KB) (158μs)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (824B) (50μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (33.92KB) (1.28ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (12μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.08KB) (346μs)
  • beforeRenderModule mod_articles_latest (Bài viết mới cập nhật...) (472B) (80μs)
  • afterRenderRawModule mod_articles_latest (Bài viết mới cập nhật...) (778.56KB) (96.28ms)
  • beforeRenderModule mod_articles_latest (Bài viết mới cập nhật...) (736B) (15μs)
  • afterRenderModule mod_articles_latest (Bài viết mới cập nhật...) (1.8KB) (218μs)
  • beforeRenderModule mod_menu (Main Menu) (2.13KB) (83μs)
  • afterRenderRawModule mod_menu (Main Menu) (4.24MB) (16.95ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (20μs)
  • afterRenderModule mod_menu (Main Menu) (1.84KB) (384μs)
  • beforeRenderModule mod_articles_categories (Demo Categories) (1.48KB) (52μs)
  • afterRenderRawModule mod_articles_categories (Demo Categories) (37.18KB) (2.12ms)
  • beforeRenderModule mod_articles_categories (Demo Categories) (720B) (7μs)
  • afterRenderModule mod_articles_categories (Demo Categories) (4.28KB) (161μs)
  • beforeRenderModule mod_finder (Smart Search Module) (344B) (63μs)
  • afterRenderRawModule mod_finder (Smart Search Module) (454.18KB) (7.91ms)
  • beforeRenderModule mod_finder (Smart Search Module) (720B) (7μs)
  • afterRenderModule mod_finder (Smart Search Module) (1.73KB) (172μs)
  • afterRender (3.73MB) (125ms)
  • 1 x afterRoute (10.35MB) (22.01%)
    160.64ms
    1 x afterRender (3.73MB) (17.09%)
    124.78ms
    1 x afterRenderRawModule mod_hikashop (Associated products listing for category listing menu 648) (986.71KB) (16.04%)
    117.07ms
    1 x afterRenderRawModule mod_articles_latest (Bài viết mới cập nhật...) (778.56KB) (13.19%)
    96.28ms
    1 x beforeRenderModule mod_hikashop (Associated products listing for category listing menu 648) (5.47MB) (12.16%)
    88.74ms
    1 x afterInitialise (7.13MB) (8.61%)
    62.83ms
    1 x afterLoad (4.1MB) (3.4%)
    24.79ms
    1 x beforeRenderModule mod_custom ( Mạng xã hội & Thống kê truy cập) (1.74MB) (2.8%)
    20.42ms
    1 x afterRenderRawModule mod_menu (Main Menu) (4.24MB) (2.32%)
    16.95ms
    1 x afterRenderRawModule mod_finder (Smart Search Module) (454.18KB) (1.08%)
    7.91ms
    1 x afterRenderRawModule mod_articles_categories (Demo Categories) (37.18KB) (0.29%)
    2.12ms
    1 x beforeRenderComponent com_hikashop (25.47KB) (0.18%)
    1.30ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (33.92KB) (0.18%)
    1.28ms
    1 x afterRenderRawModule mod_custom ( Mạng xã hội & Thống kê truy cập) (15.09KB) (0.14%)
    1.03ms
    1 x afterRenderModule mod_hikashop (Associated products listing for category listing menu 648) (37.78KB) (0.08%)
    567μs
    1 x afterRenderModule mod_menu (Main Menu) (1.84KB) (0.05%)
    384μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.08KB) (0.05%)
    346μs
    1 x afterRenderModule mod_articles_latest (Bài viết mới cập nhật...) (1.8KB) (0.03%)
    218μs
    1 x afterRenderModule mod_custom ( Mạng xã hội & Thống kê truy cập) (2.05KB) (0.03%)
    210μ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)) (1.09KB) (0.02%)
    179μs
    1 x afterRenderModule mod_finder (Smart Search Module) (1.73KB) (0.02%)
    172μs
    1 x afterRenderModule mod_articles_categories (Demo Categories) (4.28KB) (0.02%)
    161μ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)) (3.34KB) (0.02%)
    158μs
    1 x afterDispatch (2.95KB) (0.02%)
    149μs
    1 x afterRenderComponent com_hikashop (69.8KB) (0.02%)
    120μs
    1 x beforeRenderModule mod_menu (Main Menu) (2.13KB) (0.01%)
    83μ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%)
    81μs
    1 x beforeRenderModule mod_articles_latest (Bài viết mới cập nhật...) (472B) (0.01%)
    80μ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%)
    52μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (824B) (0.01%)
    50μs
    1 x beforeRenderModule mod_menu (Main Menu) (704B) (0%)
    20μs
    1 x beforeRenderModule mod_articles_latest (Bài viết mới cập nhật...) (736B) (0%)
    15μs
    1 x beforeRenderModule mod_hikashop (Associated products listing for category listing menu 648) (768B) (0%)
    12μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    12μs
    1 x beforeRenderModule mod_custom ( Mạng xã hội & Thống kê truy cập) (752B) (0%)
    8μs
    1 x beforeRenderModule mod_articles_categories (Demo Categories) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_finder (Smart Search Module) (720B) (0%)
    7μ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%)
    6μs
92 statements were executed, 14 of which were duplicates, 78 unique302ms3.25MB
  • SELECT @@SESSION.sql_mode;68μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `idc_session` WHERE `session_id` = ?105μ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` = 1280μs1.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `idc_viewlevels`83μ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` = :guest130μ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`569μ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`4.6ms820.55KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM idc_hikashop_config333μ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', ''));48μs1.25KB/administrator/components/com_hikashop/helpers/helper.php:3422Copy
  • SELECT product_id FROM idc_hikashop_product WHERE product_alias = 'usr-n540-chuyen-doi-4-cong-rs232-rs485-rs422-sang-ethernet'88.88ms856B/components/com_hikashop/router.php:357Copy
  • 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` = 1282μs1.2KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT * FROM `idc_languages` WHERE `published` = 1 ORDER BY `ordering` ASC159μs2.22KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT product.*, product_category.product_category_id, product_category.category_id, product_category.ordering FROM idc_hikashop_product AS product LEFT JOIN idc_hikashop_product_category AS product_category ON product.product_id = product_category.product_id WHERE (product.product_id = 376) LIMIT 1349μs24.06KB/components/com_hikashop/views/product/view.html.php:1274Copy
  • SELECT * FROM idc_modules WHERE id IN (152,0) AND language IN ('*', '', 'vi-VN')169μs3.66KB/administrator/components/com_hikashop/helpers/module.php:123Copy
  • SELECT cart.cart_id FROM idc_hikashop_cart AS cart WHERE (cart.cart_type = 'cart') AND (cart.session_id = 'ab2dabbc01fb8f13313a898303996e61') ORDER BY cart.cart_current DESC, cart.cart_modified DESC76μs840B/administrator/components/com_hikashop/classes/cart.php:69Copy
  • SELECT * FROM idc_hikashop_currency WHERE currency_id IN (175)111μs2.06KB/administrator/components/com_hikashop/classes/currency.php:1995Copy
  • UPDATE idc_hikashop_product SET product_hit = product_hit + 1, product_last_seen_date = 1753540280 WHERE product_id = 376136μs2.55KB/administrator/components/com_hikashop/classes/product.php:4186Copy
  • SELECT p.* FROM idc_hikashop_product_related AS pr LEFT JOIN idc_hikashop_product AS p ON pr.product_related_id = p.product_id WHERE (pr.product_id = 376) AND (pr.product_related_type = 'options') AND (p.product_published = 1) AND ((p.product_sale_start = '' OR p.product_sale_start <= 1753540280)) AND ((p.product_sale_end = '' OR p.product_sale_end > 1753540280)) ORDER BY pr.product_related_ordering ASC, pr.product_related_id ASC271μs7.91KB/components/com_hikashop/views/product/view.html.php:1392Copy
  • SELECT * FROM idc_hikashop_product WHERE (product_parent_id IN (376)) AND (product_published = 1)186μs7.95KB/components/com_hikashop/views/product/view.html.php:1437Copy
  • SELECT v.*, c.* FROM idc_hikashop_variant AS v INNER JOIN idc_hikashop_characteristic AS c ON v.variant_characteristic_id = c.characteristic_id WHERE v.variant_product_id IN (376) ORDER BY v.ordering ASC, c.characteristic_ordering ASC88μs2.08KB/components/com_hikashop/views/product/view.html.php:1478Copy
  • SELECT * FROM idc_hikashop_file WHERE file_ref_id IN (376) AND file_type IN ('product','file') ORDER BY file_ordering ASC, file_id ASC7.82ms2.17KB/components/com_hikashop/views/product/view.html.php:1523Copy
  • SELECT currency_id FROM idc_hikashop_currency WHERE currency_published=1 OR currency_id = 175127μs888B/administrator/components/com_hikashop/classes/currency.php:473Copy
  • SELECT p.* FROM idc_hikashop_price as p WHERE (p.price_currency_id IN (1,2,175)) AND (p.price_start_date < 1753540280) AND ((p.price_end_date < 1 OR p.price_end_date > 1753540280)) AND (p.price_product_id IN (376)) AND ((p.price_users = '' OR p.price_users LIKE '%,0,%')) ORDER BY p.price_site_id ASC, p.price_value DESC144μs1.95KB/administrator/components/com_hikashop/classes/currency.php:1718Copy
  • SELECT * FROM idc_hikashop_discount WHERE (discount_type = 'discount') AND (discount_published = 1) AND (discount_quota > discount_used_times OR discount_quota = 0) AND (discount_start < 1753540280) AND (discount_end > 1753540280 OR discount_end = 0) AND (discount_product_id IN ('','0','376') OR discount_product_id LIKE '%,376,%') AND (discount_flat_amount != 0 OR discount_percent_amount != 0) AND ((discount_flat_amount = 0 OR discount_currency_id =175)) AND ((discount_user_id = '' OR discount_user_id LIKE '%,0,%'))156μs4.33KB/administrator/components/com_hikashop/classes/currency.php:1778Copy
  • SELECT category_id FROM idc_hikashop_product_category WHERE product_id IN (376) ORDER BY ordering ASC115μs904B/administrator/components/com_hikashop/classes/product.php:1192Copy
  • SELECT hk_parent.* FROM idc_hikashop_category AS hk_cat LEFT JOIN idc_hikashop_category AS hk_parent ON (hk_parent.category_left <= hk_cat.category_left AND hk_parent.category_right >= hk_cat.category_right) WHERE hk_cat.category_id IN (52,699,63,55) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left1.18ms4.11KB/administrator/components/com_hikashop/classes/category.php:774Copy
  • SELECT * FROM idc_hikashop_field as a WHERE a.`field_published` = 1 AND a.`field_frontcomp` = 1 AND a.field_table='product' AND ((((field_with_sub_categories = 0 AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,52,%' OR field_categories LIKE '%,699,%' OR field_categories LIKE '%,63,%' OR field_categories LIKE '%,55,%'))OR (field_with_sub_categories = 1 AND (field_categories = "all" OR field_categories = "" OR field_categories LIKE '%,1,%' OR field_categories LIKE '%,2,%' OR field_categories LIKE '%,25,%' OR field_categories LIKE '%,52,%' OR field_categories LIKE '%,699,%' OR field_categories LIKE '%,55,%' OR field_categories LIKE '%,63,%'))) AND field_products="") OR (field_products LIKE '%,376,%')) ORDER BY a.`field_ordering` ASC205μs3.98KB/administrator/components/com_hikashop/classes/field.php:167Copy
  • SELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1753540280 AND (a.badge_end >= 1753540280 OR a.badge_end = 0) AND a.badge_published = 1 AND (a.badge_quantity = '' OR a.badge_quantity = -1) AND (a.badge_new_period = 0 OR a.badge_new_period >= 248786923) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '52' OR badge_category_id LIKE '%,52,%' OR badge_category_id = '699' OR badge_category_id LIKE '%,699,%' OR badge_category_id = '63' OR badge_category_id LIKE '%,63,%' OR badge_category_id = '55' OR badge_category_id LIKE '%,55,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '52' OR badge_category_id LIKE '%,52,%' OR badge_category_id = '699' OR badge_category_id LIKE '%,699,%' OR badge_category_id = '55' OR badge_category_id LIKE '%,55,%' OR badge_category_id = '63' OR badge_category_id LIKE '%,63,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC171μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151Copy
  • SELECT b.* FROM idc_hikashop_product_category AS a LEFT JOIN idc_hikashop_category AS b ON a.category_id = b.category_id WHERE a.product_id = 376 ORDER BY a.product_category_id ASC227μs4.05KB/components/com_hikashop/views/product/view.html.php:1843Copy
  • SELECT a.id FROM idc_menu AS a INNER JOIN `idc_menu_types` as b on a.menutype = b.menutype WHERE a.type='component' AND a.published=1 AND b.title IS NOT NULL AND a.access IN (1,5) AND a.client_id=0 AND a.link='index.php?option=com_hikashop&view=checkout&layout=show' AND a.language IN ('*', '', 'vi-VN')1.53ms840B/administrator/components/com_hikashop/classes/menus.php:327Copy
  • SELECT a.id FROM idc_menu AS a INNER JOIN `idc_menu_types` as b on a.menutype = b.menutype WHERE a.type='component' AND a.published=1 AND b.title IS NOT NULL AND a.access IN (1,5) AND a.client_id=0 AND a.link LIKE 'index.php?option=com_hikashop&view=%' AND a.language IN ('*', '', 'vi-VN')1.77ms2.82KB/administrator/components/com_hikashop/classes/menus.php:327Copy
  • SELECT a.*, c.currency_symbol FROM idc_hikashop_shipping AS a INNER JOIN idc_hikashop_currency AS c ON c.currency_id = a.shipping_currency_id WHERE (a.shipping_params LIKE '%s:20:\"shipping_per_product\";s:1:\"1\"%' OR a.shipping_params LIKE '%s:20:\"shipping_per_product\";i:1%') ORDER BY a.shipping_id113μs2.27KB/plugins/hikashop/shippingmanual_prices/shippingmanual_prices.php:45Copy
  • SELECT * FROM idc_extensions WHERE folder='hikashop' AND element='shippingmanual_prices' AND type='plugin'180μs14.78KB/administrator/components/com_hikashop/classes/plugins.php:113Copy
  • SELECT * FROM idc_extensions WHERE folder='system' AND element='hikashopsocial' AND type='plugin'160μs3.78KB/administrator/components/com_hikashop/classes/plugins.php:113Copy
  • SELECT * FROM idc_extensions WHERE folder='content' AND element='hikashopsocial' AND type='plugin'156μs3.77KB/administrator/components/com_hikashop/classes/plugins.php:113Copy
  • SELECT product_average_score, product_total_vote FROM idc_hikashop_product WHERE product_id = 376109μs912B/components/com_hikashop/views/vote/view.html.php:346Copy
  • SELECT * FROM idc_hikashop_vote WHERE (vote_type = 'product') AND (vote_rating != 0) AND (vote_ref_id = 376) AND (vote_ip = '216.73.216.14') AND (vote_user_id IN ( '' , '0', '216.73.216.14'))5.99ms2.08KB/administrator/components/com_hikashop/classes/vote.php:688Copy
  • 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)225μs5.22KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT * FROM idc_extensions WHERE folder='hikashop' AND element='google_products' AND type='plugin'175μs3.77KB/administrator/components/com_hikashop/classes/plugins.php:113Copy
  • SELECT * FROM idc_hikashop_vote WHERE vote_type = 'product' AND vote_published > 0 AND vote_ref_id = 3766.01ms2.45KB/components/com_hikashop/views/product/tmpl/show_microdata.php:86Copy
  • SELECT params FROM idc_modules WHERE id = 15289μs856B/modules/mod_hikashop/mod_hikashop.php:33Copy
  • SELECT a.category_id FROM idc_hikashop_product_category AS a INNER JOIN idc_hikashop_category AS b ON a.category_id=b.category_id WHERE b.category_published=1 AND a.product_id=376 ORDER BY a.product_category_id ASC185μs904B/components/com_hikashop/views/product/view.html.php:299Copy
  • SELECT cart.cart_id FROM idc_hikashop_cart AS cart WHERE (cart.cart_type = 'cart') AND (cart.session_id = 'ab2dabbc01fb8f13313a898303996e61') ORDER BY cart.cart_current DESC, cart.cart_modified DESC101μs840B/administrator/components/com_hikashop/classes/cart.php:69Copy
  • SELECT a.*,b.* FROM idc_hikashop_category AS a LEFT JOIN idc_hikashop_file AS b ON a.category_id = b.file_ref_id AND b.file_type = 'category' WHERE a.category_id = 52 LIMIT 1320μs7.09KB/administrator/components/com_hikashop/classes/category.php:35Copy
  • SELECT DISTINCT b.* FROM idc_hikashop_product_category AS a LEFT JOIN idc_hikashop_product AS b ON a.product_id=b.product_id WHERE (b.product_published = 1) AND (b.product_id!=376) AND (b.product_parent_id!=376) AND (b.product_type = 'main') AND (a.category_id IN (52,55,63,699)) ORDER BY a.ordering ASC, b.product_id ASC LIMIT 240, 2064.62ms392.11KB/components/com_hikashop/views/product/view.html.php:898Copy
  • SELECT * FROM idc_hikashop_file WHERE file_ref_id IN (2976,985,986,3133,3412,3413,1008,559,11880,12071) AND file_type IN ('product','file') ORDER BY file_ref_id ASC, file_ordering ASC, file_id ASC10.75ms2.8KB/administrator/components/com_hikashop/classes/product.php:2430Copy
  • SELECT variant_product_id FROM idc_hikashop_variant WHERE variant_product_id IN (2976,985,986,3133,3412,3413,1008,559,11880,12071)67μs840B/administrator/components/com_hikashop/classes/product.php:2458Copy
  • SELECT product_id FROM idc_hikashop_product_related WHERE product_related_type = 'options' AND product_id IN (2976,985,986,3133,3412,3413,1008,559,11880,12071)256μs840B/administrator/components/com_hikashop/classes/product.php:2474Copy
  • SELECT product_parent_id, product_id, product_tax_id FROM idc_hikashop_product WHERE product_parent_id IN ('2976','985','986','3133','3412','3413','1008','559','11880','12071') AND product_published = 1 AND product_type = 'variant' AND product_sale_start < 1753540280 AND (product_sale_end > 1753540280 OR product_sale_end = 0)329μs960B/administrator/components/com_hikashop/classes/currency.php:1060Copy
  • SELECT * FROM idc_hikashop_discount WHERE discount_type='discount' AND discount_published=1 AND (discount_quota > discount_used_times OR discount_quota = 0) AND discount_start < 1753540280 AND (discount_end > 1753540280 OR discount_end = 0) AND ( (discount_product_id IN ('','0','2976','985','986','3133','3412','3413','1008','559','11880','12071')) OR (discount_product_id LIKE '%,2976,%') OR (discount_product_id LIKE '%,985,%') OR (discount_product_id LIKE '%,986,%') OR (discount_product_id LIKE '%,3133,%') OR (discount_product_id LIKE '%,3412,%') OR (discount_product_id LIKE '%,3413,%') OR (discount_product_id LIKE '%,1008,%') OR (discount_product_id LIKE '%,559,%') OR (discount_product_id LIKE '%,11880,%') OR (discount_product_id LIKE '%,12071,%') ) AND (discount_flat_amount != 0 OR discount_percent_amount != 0) AND (discount_flat_amount = 0 OR discount_currency_id =175) AND (discount_user_id = '' OR discount_user_id LIKE '%,0,%')216μs4.33KB/administrator/components/com_hikashop/classes/currency.php:558Copy
  • SELECT a.*, CASE WHEN price_site_id = 0 OR price_site_id = '[unselected]' THEN '' ELSE price_site_id END AS price_site_id FROM idc_hikashop_price AS a WHERE a.price_product_id IN (2976,985,986,3133,3412,3413,1008,559,11880,12071) AND a.price_currency_id IN (1,2,175) AND a.price_start_date < 1753540280 AND (a.price_end_date < 1 OR a.price_end_date > 1753540280) AND (a.price_access = 'all' OR a.price_access LIKE '%,13,%' OR ISNULL(a.price_access)) AND (a.price_users = '' OR a.price_users LIKE '%,0,%') ORDER BY a.price_site_id ASC, a.price_value DESC172μs2.05KB/administrator/components/com_hikashop/classes/currency.php:589Copy
  • SELECT c.*, pc.* FROM idc_hikashop_category AS c LEFT JOIN idc_hikashop_product_category AS pc ON c.category_id = pc.category_id WHERE pc.product_id IN (2976,985,986,3133,3412,3413,1008,559,11880,12071);498μs20.73KB/administrator/components/com_hikashop/classes/product.php:2525Copy
  • SELECT hk_parent.* FROM idc_hikashop_category AS hk_cat LEFT JOIN idc_hikashop_category AS hk_parent ON (hk_parent.category_left <= hk_cat.category_left AND hk_parent.category_right >= hk_cat.category_right) WHERE hk_cat.category_id IN (71,55,72) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left1.09ms4.08KB/administrator/components/com_hikashop/classes/category.php:774Copy
  • SELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1753540280 AND (a.badge_end >= 1753540280 OR a.badge_end = 0) AND a.badge_published = 1 AND (a.badge_quantity = '' OR a.badge_quantity = -1) AND (a.badge_new_period = 0 OR a.badge_new_period >= 200475430) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '71' OR badge_category_id LIKE '%,71,%' OR badge_category_id = '55' OR badge_category_id LIKE '%,55,%' OR badge_category_id = '72' OR badge_category_id LIKE '%,72,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '55' OR badge_category_id LIKE '%,55,%' OR badge_category_id = '71' OR badge_category_id LIKE '%,71,%' OR badge_category_id = '72' OR badge_category_id LIKE '%,72,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC174μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151Copy
  • SELECT hk_parent.* FROM idc_hikashop_category AS hk_cat LEFT JOIN idc_hikashop_category AS hk_parent ON (hk_parent.category_left <= hk_cat.category_left AND hk_parent.category_right >= hk_cat.category_right) WHERE hk_cat.category_id IN (55,75) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left881μs4.06KB/administrator/components/com_hikashop/classes/category.php:774Copy
  • SELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1753540280 AND (a.badge_end >= 1753540280 OR a.badge_end = 0) AND a.badge_published = 1 AND (a.badge_quantity = '' OR a.badge_quantity = -1) AND (a.badge_new_period = 0 OR a.badge_new_period >= 217928587) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '55' OR badge_category_id LIKE '%,55,%' OR badge_category_id = '75' OR badge_category_id LIKE '%,75,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '55' OR badge_category_id LIKE '%,55,%' OR badge_category_id = '75' OR badge_category_id LIKE '%,75,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC156μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151Copy
  • SELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1753540280 AND (a.badge_end >= 1753540280 OR a.badge_end = 0) AND a.badge_published = 1 AND (a.badge_quantity = '' OR a.badge_quantity = -1) AND (a.badge_new_period = 0 OR a.badge_new_period >= 217927004) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '55' OR badge_category_id LIKE '%,55,%' OR badge_category_id = '75' OR badge_category_id LIKE '%,75,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '55' OR badge_category_id LIKE '%,55,%' OR badge_category_id = '75' OR badge_category_id LIKE '%,75,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC149μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151Copy
  • SELECT hk_parent.* FROM idc_hikashop_category AS hk_cat LEFT JOIN idc_hikashop_category AS hk_parent ON (hk_parent.category_left <= hk_cat.category_left AND hk_parent.category_right >= hk_cat.category_right) WHERE hk_cat.category_id IN (68,55,704,714) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left1.01ms4.11KB/administrator/components/com_hikashop/classes/category.php:774Copy
  • SELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1753540280 AND (a.badge_end >= 1753540280 OR a.badge_end = 0) AND a.badge_published = 1 AND (a.badge_quantity = '' OR a.badge_quantity = -1) AND (a.badge_new_period = 0 OR a.badge_new_period >= 199341134) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '68' OR badge_category_id LIKE '%,68,%' OR badge_category_id = '55' OR badge_category_id LIKE '%,55,%' OR badge_category_id = '704' OR badge_category_id LIKE '%,704,%' OR badge_category_id = '714' OR badge_category_id LIKE '%,714,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '55' OR badge_category_id LIKE '%,55,%' OR badge_category_id = '68' OR badge_category_id LIKE '%,68,%' OR badge_category_id = '704' OR badge_category_id LIKE '%,704,%' OR badge_category_id = '714' OR badge_category_id LIKE '%,714,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC170μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151Copy
  • SELECT hk_parent.* FROM idc_hikashop_category AS hk_cat LEFT JOIN idc_hikashop_category AS hk_parent ON (hk_parent.category_left <= hk_cat.category_left AND hk_parent.category_right >= hk_cat.category_right) WHERE hk_cat.category_id IN (55,72) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left876μs4.06KB/administrator/components/com_hikashop/classes/category.php:774Copy
  • SELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1753540280 AND (a.badge_end >= 1753540280 OR a.badge_end = 0) AND a.badge_published = 1 AND (a.badge_quantity = '' OR a.badge_quantity = -1) AND (a.badge_new_period = 0 OR a.badge_new_period >= 196581557) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '55' OR badge_category_id LIKE '%,55,%' OR badge_category_id = '72' OR badge_category_id LIKE '%,72,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '55' OR badge_category_id LIKE '%,55,%' OR badge_category_id = '72' OR badge_category_id LIKE '%,72,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC157μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151Copy
  • SELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1753540280 AND (a.badge_end >= 1753540280 OR a.badge_end = 0) AND a.badge_published = 1 AND (a.badge_quantity = '' OR a.badge_quantity = -1) AND (a.badge_new_period = 0 OR a.badge_new_period >= 196580606) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '55' OR badge_category_id LIKE '%,55,%' OR badge_category_id = '72' OR badge_category_id LIKE '%,72,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '55' OR badge_category_id LIKE '%,55,%' OR badge_category_id = '72' OR badge_category_id LIKE '%,72,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC188μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151Copy
  • SELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1753540280 AND (a.badge_end >= 1753540280 OR a.badge_end = 0) AND a.badge_published = 1 AND (a.badge_quantity = '' OR a.badge_quantity = -1) AND (a.badge_new_period = 0 OR a.badge_new_period >= 217855493) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '55' OR badge_category_id LIKE '%,55,%' OR badge_category_id = '75' OR badge_category_id LIKE '%,75,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '55' OR badge_category_id LIKE '%,55,%' OR badge_category_id = '75' OR badge_category_id LIKE '%,75,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC152μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151Copy
  • SELECT hk_parent.* FROM idc_hikashop_category AS hk_cat LEFT JOIN idc_hikashop_category AS hk_parent ON (hk_parent.category_left <= hk_cat.category_left AND hk_parent.category_right >= hk_cat.category_right) WHERE hk_cat.category_id IN (55,113,68,704,714) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left1.12ms4.11KB/administrator/components/com_hikashop/classes/category.php:774Copy
  • SELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1753540280 AND (a.badge_end >= 1753540280 OR a.badge_end = 0) AND a.badge_published = 1 AND (a.badge_quantity = '' OR a.badge_quantity = -1) AND (a.badge_new_period = 0 OR a.badge_new_period >= 229324215) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '55' OR badge_category_id LIKE '%,55,%' OR badge_category_id = '113' OR badge_category_id LIKE '%,113,%' OR badge_category_id = '68' OR badge_category_id LIKE '%,68,%' OR badge_category_id = '704' OR badge_category_id LIKE '%,704,%' OR badge_category_id = '714' OR badge_category_id LIKE '%,714,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '55' OR badge_category_id LIKE '%,55,%' OR badge_category_id = '68' OR badge_category_id LIKE '%,68,%' OR badge_category_id = '704' OR badge_category_id LIKE '%,704,%' OR badge_category_id = '714' OR badge_category_id LIKE '%,714,%' OR badge_category_id = '113' OR badge_category_id LIKE '%,113,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC192μs11.8KB/administrator/components/com_hikashop/classes/badge.php:151Copy
  • SELECT hk_parent.* FROM idc_hikashop_category AS hk_cat LEFT JOIN idc_hikashop_category AS hk_parent ON (hk_parent.category_left <= hk_cat.category_left AND hk_parent.category_right >= hk_cat.category_right) WHERE hk_cat.category_id IN (55,68,704,714) GROUP BY hk_parent.category_id ORDER BY hk_parent.category_left1.04ms4.11KB/administrator/components/com_hikashop/classes/category.php:774Copy
  • SELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1753540280 AND (a.badge_end >= 1753540280 OR a.badge_end = 0) AND a.badge_published = 1 AND (a.badge_quantity = '' OR a.badge_quantity = -1) AND (a.badge_new_period = 0 OR a.badge_new_period >= 42013743) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '55' OR badge_category_id LIKE '%,55,%' OR badge_category_id = '68' OR badge_category_id LIKE '%,68,%' OR badge_category_id = '704' OR badge_category_id LIKE '%,704,%' OR badge_category_id = '714' OR badge_category_id LIKE '%,714,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '55' OR badge_category_id LIKE '%,55,%' OR badge_category_id = '68' OR badge_category_id LIKE '%,68,%' OR badge_category_id = '704' OR badge_category_id LIKE '%,704,%' OR badge_category_id = '714' OR badge_category_id LIKE '%,714,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC175μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151Copy
  • SELECT a.* FROM idc_hikashop_badge AS a WHERE a.badge_start <= 1753540280 AND (a.badge_end >= 1753540280 OR a.badge_end = 0) AND a.badge_published = 1 AND (a.badge_quantity = '' OR a.badge_quantity = -1) AND (a.badge_new_period = 0 OR a.badge_new_period >= 38922886) AND (badge_discount_id = '0' OR badge_discount_id = '') AND ((badge_category_childs = 0 AND (badge_category_id = '0' OR badge_category_id = '' OR badge_category_id = '55' OR badge_category_id LIKE '%,55,%' OR badge_category_id = '75' OR badge_category_id LIKE '%,75,%')) OR (badge_category_childs = 1 AND (badge_category_id='0' OR badge_category_id='' OR badge_category_id = '1' OR badge_category_id LIKE '%,1,%' OR badge_category_id = '2' OR badge_category_id LIKE '%,2,%' OR badge_category_id = '25' OR badge_category_id LIKE '%,25,%' OR badge_category_id = '55' OR badge_category_id LIKE '%,55,%' OR badge_category_id = '75' OR badge_category_id LIKE '%,75,%'))) ORDER BY a.badge_ordering ASC,a.badge_id ASC162μs3.8KB/administrator/components/com_hikashop/classes/badge.php:151Copy
  • SELECT COUNT( DISTINCT b.product_id ) FROM idc_hikashop_product_category AS a LEFT JOIN idc_hikashop_product AS b ON a.product_id=b.product_id WHERE (b.product_published = 1) AND (b.product_id!=376) AND (b.product_parent_id!=376) AND (b.product_type = 'main') AND (a.category_id IN (52,55,63,699)) ORDER BY a.ordering ASC, b.product_id ASC4.58ms856B/components/com_hikashop/views/product/view.html.php:950Copy
  • SELECT * FROM idc_hikashop_characteristic WHERE characteristic_values_on_listing > 0 ORDER BY characteristic_ordering ASC;94μs1.89KB/components/com_hikashop/views/product/view.html.php:1177Copy
  • 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.98ms1.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 1583.15ms277.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`366μs5.17KBParams/libraries/src/Categories/Categories.php:375Copy
  • 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`410μs5.14KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `name`,`element` FROM `idc_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1315μ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)170μ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` = 1179μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `alias` FROM `idc_content` WHERE `id` = :id111μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • 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`345μs5.16KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `idc_content` WHERE `id` = :id103μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `idc_content` WHERE `id` = :id113μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `idc_content` WHERE `id` = :id108μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `idc_content` WHERE `id` = :id114μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `idc_content` WHERE `id` = :id108μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `idc_content` WHERE `id` = :id122μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `idc_content` WHERE `id` = :id111μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `idc_content` WHERE `id` = :id121μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `idc_content` WHERE `id` = :id116μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • 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` = :id113μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `session_id` FROM `idc_session` WHERE `session_id` = ?130μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • INSERT INTO `idc_session` (`data`,`time`,`session_id`) VALUES (?, ?, ?)331μs864BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy