Raspberry PI đã và đang dần đóng vai trò quan trọng trong cuộc cách mạng công nghiệp 4.0, cụ thể là sự hiện diện trong các sản phẩm tích hợp IoT. Hôm nay, BKAII sẽ chia sẻ với các bạn bài viết hướng dẫn cách bật SSH, VNC và thiết lập IP tĩnh mà BKAII tham khảo trên mạng internet.

Firmware sử dụng từ link https://www.raspberrypi.org/downloads/raspbian/ phiên bản mới nhất cập nhật ngày 05/07/2017
Tên file là 2017-07-05-raspbian-jessie.img
Chương trình ghi SD vẫn là Win32 Disk Image



Click vào ảnh để xem ảnh lớn hơn. 

Name:	maxresdefault.jpg 
Views:	0 
Size:	73.9 KB 
ID:	43706



SSH và VNC
Chức năng SSH và VNC là các thiết lập cho phép người sử dụng có thể điều khiển từ xa RPi (cài Raspbian, hệ điều hành khác mình không rỏ). Với firmware trên thì SSH và VNC đã được cài đặt sẵn, ta chỉ cần Enable là xong.
- Có thể sử dụng 1 trong 2 hoặc cả 2 cách này để điều khiển từ xa. Tùy thích :)
- SSH có thể dùng phần mềm PUTTY để config RPi từ xa. Thao tác dùng lệnh như thao tác trên Terminal windows trên RPi.
- VNC cho phép điều khiển từ xa với giao diện đồ họa, kiểu như TeamView vậy.

Hai soft này sử dụng cụ thể thế nào thì từ từ rồi tính. Khi vừa ghi SD và boot với RPi thì... cả 2 chức năng này đều Disable

Để Enable thì khá đơn giản.
1. Boot RPi với màn hình, bàn phím, chuột đầy đủ.
2. Sau khi boot thì vào chức năng... Preferences -> Raspberry Pi Configuration -> Interfaces
3. Chọn Enable các mục cần (ở đây là SSL và VNC) xong thì Ok
Name:  Setup-VNC-Server-in-Raspbian-Jessie-with-Pixel-Raspberry-Pi-Configuration-Interfaces.jpg
Views: 22
Size:  24.5 KB
4. Reboot xong rồi Yes hoặc Ok các thông báo hiện ra là xong.
5. Dùng PUTTY hoặc VNC (mình thử với VNC Google App) kết nối vào
Dùng user pi và pass raspberry để login nếu được hỏi (lưu ý là chưa thay đổi pass mặc định của RPi)



Click vào ảnh để xem ảnh lớn hơn. 

Name:	maxresdefault.jpg 
Views:	0 
Size:	144.1 KB 
ID:	43707



IP tĩnh (static IP)
Trong một số yêu cầu cần IP tĩnh, ví dụ cài đặt RPi làm local server thì việc cài đặt IP tĩnh là cần thiết.
Mình đã test nhiều cách được hướng dẫn tìm được qua Google, nhưng hầu hết đều không đúng vì các hướng dẫn ấy dùng cho các version cũ. Với version như trên, thì cách làm như sau: Thay đổi nội dung file dhcpcd.conf trong thu mục etc, trong cửa sổ Terminal...

1. Chạy lệnh

Mã:
sudo nano /etc/dhcpcd.conf

2. Trong cửa sổ edit, chèn các lệnh sau vào phía dưới cùng

Mã:
interface wlan0
static ip_address=192.168.1.XX/24
static routers=192.168.1.1
static domain_name_servers=192.168.1.1

Với:
- wlan0 là config cho thiết bị wlan0
- 192.168.1.XX là IP mong muốn
- 192.168.1.1 là gateway
* Các thiết lập IP thay đổi cho phù hợp với hệ thống mạng đang dùng.

Dùng:
Ctrl+O xong Enter để lưu nội dung
Ctrl+X để thoát

Name:  02-Static IP config.jpg
Views: 17
Size:  59.8 KB

3. Reboot để các thiết lập được thực hiện

 


Bài viết mới cập 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.676MBMemory Usage428msRequest 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
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:49 [ "PATH" => "/usr/local/bin:/bin:/usr/bin" "HTTP_ACCEPT" => "text/html,application/xhtm...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1753228177 "last" => 1753228177...
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.04ms)
  • afterInitialise (7.13MB) (59.57ms)
  • afterRoute (4.35MB) (27.45ms)
  • beforeRenderComponent com_content (380.31KB) (3.27ms)
  • Before Access::preloadComponents (all components) (477.52KB) (3.54ms)
  • After Access::preloadComponents (all components) (121.71KB) (786μs)
  • Before Access::preloadPermissions (com_content) (4.07KB) (19μs)
  • After Access::preloadPermissions (com_content) (1.1MB) (3.05ms)
  • Before Access::getAssetRules (id:298 name:com_content.article.133) (66.8KB) (68μs)
  • After Access::getAssetRules (id:298 name:com_content.article.133) (26.37KB) (332μs)
  • afterRenderComponent com_content (2.76MB) (27.47ms)
  • afterDispatch (2.33KB) (156μs)
  • beforeRenderModule mod_custom ( Mạng xã hội & Thống kê truy cập) (1.87MB) (21.27ms)
  • afterRenderRawModule mod_custom ( Mạng xã hội & Thống kê truy cập) (35.91KB) (1.24ms)
  • 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) (31.73KB) (438μ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) (56μ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) (162μ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)) (2.09KB) (158μs)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (824B) (50μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (36.82KB) (1.15ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (7μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.7KB) (211μs)
  • beforeRenderModule mod_whosonline (Số lượng người đang truy cập...) (760B) (60μs)
  • afterRenderRawModule mod_whosonline (Số lượng người đang truy cập...) (9.6KB) (582μs)
  • beforeRenderModule mod_whosonline (Số lượng người đang truy cập...) (752B) (7μs)
  • afterRenderModule mod_whosonline (Số lượng người đang truy cập...) (1.98KB) (165μs)
  • beforeRenderModule mod_articles_latest (Bài viết mới cập nhật...) (520B) (54μs)
  • afterRenderRawModule mod_articles_latest (Bài viết mới cập nhật...) (217.88KB) (82.75ms)
  • 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) (203μs)
  • beforeRenderModule mod_menu (Main Menu) (2.13KB) (69μs)
  • afterRenderRawModule mod_menu (Main Menu) (9.1MB) (51.25ms)
  • beforeRenderModule mod_menu (Main Menu) (704B) (11μs)
  • afterRenderModule mod_menu (Main Menu) (1.84KB) (205μs)
  • beforeRenderModule mod_articles_categories (Demo Categories) (1.48KB) (30μs)
  • afterRenderRawModule mod_articles_categories (Demo Categories) (66.68KB) (1.78ms)
  • beforeRenderModule mod_articles_categories (Demo Categories) (720B) (7μs)
  • afterRenderModule mod_articles_categories (Demo Categories) (1.78KB) (170μs)
  • beforeRenderModule mod_finder (Smart Search Module) (344B) (64μs)
  • afterRenderRawModule mod_finder (Smart Search Module) (454.68KB) (7.71ms)
  • beforeRenderModule mod_finder (Smart Search Module) (720B) (8μs)
  • afterRenderModule mod_finder (Smart Search Module) (1.73KB) (170μs)
  • afterRender (3.49MB) (107ms)
  • 1 x afterRender (3.49MB) (25.11%)
    107.46ms
    1 x afterRenderRawModule mod_articles_latest (Bài viết mới cập nhật...) (217.88KB) (19.34%)
    82.75ms
    1 x afterInitialise (7.13MB) (13.92%)
    59.57ms
    1 x afterRenderRawModule mod_menu (Main Menu) (9.1MB) (11.98%)
    51.25ms
    1 x afterRenderComponent com_content (2.76MB) (6.42%)
    27.47ms
    1 x afterRoute (4.35MB) (6.41%)
    27.45ms
    1 x afterLoad (4.1MB) (5.62%)
    24.04ms
    1 x beforeRenderModule mod_custom ( Mạng xã hội & Thống kê truy cập) (1.87MB) (4.97%)
    21.27ms
    1 x afterRenderRawModule mod_finder (Smart Search Module) (454.68KB) (1.8%)
    7.71ms
    1 x Before Access::preloadComponents (all components) (477.52KB) (0.83%)
    3.54ms
    1 x beforeRenderComponent com_content (380.31KB) (0.76%)
    3.27ms
    1 x After Access::preloadPermissions (com_content) (1.1MB) (0.71%)
    3.05ms
    1 x afterRenderRawModule mod_articles_categories (Demo Categories) (66.68KB) (0.42%)
    1.78ms
    1 x afterRenderRawModule mod_custom ( Mạng xã hội & Thống kê truy cập) (35.91KB) (0.29%)
    1.24ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (36.82KB) (0.27%)
    1.15ms
    1 x After Access::preloadComponents (all components) (121.71KB) (0.18%)
    786μs
    1 x afterRenderRawModule mod_whosonline (Số lượng người đang truy cập...) (9.6KB) (0.14%)
    582μs
    1 x afterRenderModule mod_custom ( Mạng xã hội & Thống kê truy cập) (31.73KB) (0.1%)
    438μs
    1 x After Access::getAssetRules (id:298 name:com_content.article.133) (26.37KB) (0.08%)
    332μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (2.7KB) (0.05%)
    211μs
    1 x afterRenderModule mod_menu (Main Menu) (1.84KB) (0.05%)
    205μs
    1 x afterRenderModule mod_articles_latest (Bài viết mới cập nhật...) (1.8KB) (0.05%)
    203μs
    1 x afterRenderModule mod_articles_categories (Demo Categories) (1.78KB) (0.04%)
    170μs
    1 x afterRenderModule mod_finder (Smart Search Module) (1.73KB) (0.04%)
    170μs
    1 x afterRenderModule mod_whosonline (Số lượng người đang truy cập...) (1.98KB) (0.04%)
    165μ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%)
    162μ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%)
    158μs
    1 x afterDispatch (2.33KB) (0.04%)
    156μs
    1 x beforeRenderModule mod_menu (Main Menu) (2.13KB) (0.02%)
    69μs
    1 x Before Access::getAssetRules (id:298 name:com_content.article.133) (66.8KB) (0.02%)
    68μs
    1 x beforeRenderModule mod_finder (Smart Search Module) (344B) (0.01%)
    64μs
    1 x beforeRenderModule mod_whosonline (Số lượng người đang truy cập...) (760B) (0.01%)
    60μ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%)
    56μs
    1 x beforeRenderModule mod_articles_latest (Bài viết mới cập nhật...) (520B) (0.01%)
    54μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (824B) (0.01%)
    50μs
    1 x beforeRenderModule mod_articles_categories (Demo Categories) (1.48KB) (0.01%)
    30μs
    1 x Before Access::preloadPermissions (com_content) (4.07KB) (0%)
    19μ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_menu (Main Menu) (704B) (0%)
    11μ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_finder (Smart Search Module) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0%)
    7μs
    1 x beforeRenderModule mod_articles_categories (Demo Categories) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_whosonline (Số lượng người đang truy cập...) (752B) (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
33 statements were executed, 3 of which were duplicates, 30 unique92.63ms2.89MB
  • SELECT @@SESSION.sql_mode;63μs1.57KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:334Copy
  • SELECT `data` FROM `idc_session` WHERE `session_id` = ?112μ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` = 1279μs1.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `idc_viewlevels`86μ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` = :guest134μ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`578μ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.54ms820.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`312μ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` = 1212μs2.45KB/administrator/components/com_templates/src/Model/StyleModel.php:773Copy
  • SELECT * FROM `idc_languages` WHERE `published` = 1 ORDER BY `ordering` ASC126μ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)461μ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.33ms173.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `idc_content`512μs2.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:625Copy
  • UPDATE `idc_content` SET `hits` = (`hits` + 1) WHERE `id` = '133'233μ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)319μ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`273μ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)199μ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`269μ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 ASC754μ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 DESC753μ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`280μ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.91ms1.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 1576.84ms281.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`338μs5.17KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT * FROM idc_hikashop_config336μ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', ''));43μ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`331μs5.14KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `name`,`element` FROM `idc_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1287μ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)141μ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` = 1171μs1.68KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `alias` FROM `idc_content` WHERE `id` = :id103μs1.63KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `session_id` FROM `idc_session` WHERE `session_id` = ?84μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:291Copy
  • INSERT INTO `idc_session` (`data`,`time`,`session_id`) VALUES (?, ?, ?)221μs11.84KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:318Copy