Skip to main content
enms

sitemap 1

call 2

faq 6

Written by Super User on . Posted in Data Terbuka.

Data Terbuka Kerajaan

Pengenalan Data Terbuka

Majlis Daerah Pasir Puteh menyahut inisiatif kerajaan untuk melaksanakan data terbuka bagi meningkatkan kualiti dan ketelusan penyampaian perkhidmatan kerajaan menerusi perkongsian data yang tepat, cepat dan relevan. Halaman ini diwujudkan bertujuan untuk memaparkan set data yang boleh dikongsikan dan digunakan semula oleh rakyat, agensi sektor awam atau swasta untuk sebarang tujuan.
 

Terma Penggunaan ini ditadbir oleh Undang-undang di bawah bidang kuasa dan pemilik data bagi data tersebut :

Pautan Set Data Terbuka Kerajaan

Penggunaan data atau penggunaan semula data hendaklah mematuhi Terma dan Syarat Penggunaan Data Terbuka Kerajaan 1.0 berikut :

Terma Penggunaan Data Terbuka Kerajaan.

J! InfoRequestSessionProfileQueries53
33.964MBMemory Usage505msRequest Duration
Joomla! Version5.2.3
PHP Version8.3.6
Identityguest
Response200
Templateyootheme
Database
Server
mysql
Version
10.11.11-MariaDB-0ubuntu0.24.04.2
Collation
utf8mb4_general_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:2 [ "__koowa" => array:3 [ "__metadata" => & array:1 [ "timer" => array:3 [ ...
$_COOKIE
[]
$_SERVER
array:71 [ "UNIQUE_ID" => "Z-uNNpDM8oJMqN76LAz2MQAAAAE" "HTTPS" => "on" "SSL_TLS_SNI" => "mdpp...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1743490358 "last" => 1743490358...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (3.38MB) (31.44ms)
  • afterInitialise (11.04MB) (99.96ms)
  • afterRoute (2.46MB) (21.06ms)
  • beforeRenderComponent com_content (67.91KB) (1.55ms)
  • Before Access::preloadComponents (all components) (691.7KB) (5.92ms)
  • After Access::preloadComponents (all components) (137.2KB) (2.07ms)
  • Before Access::preloadPermissions (com_content) (1.85KB) (23μs)
  • After Access::preloadPermissions (com_content) (368.48KB) (2.62ms)
  • Before Access::getAssetRules (id:514 name:com_content.article.163) (18.65KB) (40μs)
  • After Access::getAssetRules (id:514 name:com_content.article.163) (24.42KB) (407μs)
  • afterRenderComponent com_content (8.64MB) (96.57ms)
  • afterDispatch (641.99KB) (17.43ms)
  • beforeRenderRawModule mod_jsvisit_counter (VISIT) (203.27KB) (3.11ms)
  • afterRenderRawModule mod_jsvisit_counter (VISIT) (196.98KB) (6.43ms)
  • beforeRenderModule mod_jsvisit_counter (VISIT) (720B) (8μs)
  • afterRenderModule mod_jsvisit_counter (VISIT) (21.45KB) (513μs)
  • beforeRenderRawModule mod_db8sitelastmodified (Site Last Modified) (1.54KB) (99μs)
  • afterRenderRawModule mod_db8sitelastmodified (Site Last Modified) (22.25KB) (1.53ms)
  • beforeRenderModule mod_db8sitelastmodified (Site Last Modified) (736B) (7μs)
  • afterRenderModule mod_db8sitelastmodified (Site Last Modified) (2.96KB) (180μs)
  • beforeRenderRawModule mod_eac_splwpk (SPLWPK - CONTENT GOV POLICIES) (9.02KB) (7.24ms)
  • afterRenderRawModule mod_eac_splwpk (SPLWPK - CONTENT GOV POLICIES) (35.32KB) (4.83ms)
  • beforeRenderModule mod_eac_splwpk (SPLWPK - CONTENT GOV POLICIES) (736B) (7μs)
  • afterRenderModule mod_eac_splwpk (SPLWPK - CONTENT GOV POLICIES) (2.96KB) (178μs)
  • beforeRenderRawModule mod_menu () (1.36KB) (694μs)
  • afterRenderRawModule mod_menu () (3.84MB) (115ms)
  • beforeRenderModule mod_menu () (696B) (12μs)
  • afterRenderModule mod_menu () (38.81KB) (761μs)
  • beforeRenderRawModule mod_finder () (37.85KB) (28μs)
  • afterRenderRawModule mod_finder () (406.51KB) (8.29ms)
  • beforeRenderModule mod_finder () (704B) (9μs)
  • afterRenderModule mod_finder () (3.81KB) (235μs)
  • beforeRenderRawModule mod_custom () (38.54KB) (1.29ms)
  • afterRenderRawModule mod_custom () (101.2KB) (3.73ms)
  • beforeRenderModule mod_custom () (704B) (7μs)
  • afterRenderModule mod_custom () (3.55KB) (174μs)
  • beforeRenderRawModule mod_custom (sitemap) (1.05KB) (488μs)
  • afterRenderRawModule mod_custom (sitemap) (1.09KB) (123μs)
  • beforeRenderModule mod_custom (sitemap) (704B) (5μs)
  • afterRenderModule mod_custom (sitemap) (2.44KB) (155μs)
  • beforeRenderRawModule mod_custom (call) (912B) (22μs)
  • afterRenderRawModule mod_custom (call) (992B) (88μs)
  • beforeRenderModule mod_custom (call) (704B) (4μs)
  • afterRenderModule mod_custom (call) (2.44KB) (114μs)
  • beforeRenderRawModule mod_custom (feedback) (896B) (19μs)
  • afterRenderRawModule mod_custom (feedback) (976B) (82μs)
  • beforeRenderModule mod_custom (feedback) (720B) (4μs)
  • afterRenderModule mod_custom (feedback) (2.44KB) (107μs)
  • beforeRenderRawModule mod_datetime (Display Date and Time) (3.75KB) (1.08ms)
  • afterRenderRawModule mod_datetime (Display Date and Time) (18.95KB) (721μs)
  • beforeRenderModule mod_datetime (Display Date and Time) (720B) (6μs)
  • afterRenderModule mod_datetime (Display Date and Time) (2.45KB) (151μs)
  • beforeRenderRawModule mod_gtranslate (GTranslate) (320B) (35μs)
  • afterRenderRawModule mod_gtranslate (GTranslate) (13.91KB) (905μs)
  • beforeRenderModule mod_gtranslate (GTranslate) (720B) (7μs)
  • afterRenderModule mod_gtranslate (GTranslate) (2.45KB) (146μs)
  • beforeRenderRawModule mod_menu () (5.34KB) (775μs)
  • afterRenderRawModule mod_menu () (63.77KB) (18.59ms)
  • beforeRenderModule mod_menu () (696B) (9μs)
  • afterRenderModule mod_menu () (2.45KB) (383μs)
  • beforeRenderRawModule mod_custom () (15.45KB) (634μs)
  • afterRenderRawModule mod_custom () (960B) (842μs)
  • beforeRenderModule mod_custom () (704B) (7μs)
  • afterRenderModule mod_custom () (3.55KB) (176μs)
  • beforeRenderRawModule mod_custom () (912B) (472μs)
  • afterRenderRawModule mod_custom () (3.39KB) (766μs)
  • beforeRenderModule mod_custom () (704B) (7μs)
  • afterRenderModule mod_custom () (2.98KB) (181μs)
  • afterRender (958.45KB) (42.81ms)
  • 1 x afterRenderRawModule mod_menu () (3.84MB) (22.75%)
    115ms
    1 x afterInitialise (11.04MB) (19.78%)
    99.96ms
    1 x afterRenderComponent com_content (8.64MB) (19.1%)
    96.57ms
    1 x afterRender (958.45KB) (8.47%)
    42.81ms
    1 x afterLoad (3.38MB) (6.22%)
    31.44ms
    1 x afterRoute (2.46MB) (4.17%)
    21.06ms
    1 x afterRenderRawModule mod_menu () (63.77KB) (3.68%)
    18.59ms
    1 x afterDispatch (641.99KB) (3.45%)
    17.43ms
    1 x afterRenderRawModule mod_finder () (406.51KB) (1.64%)
    8.29ms
    1 x beforeRenderRawModule mod_eac_splwpk (SPLWPK - CONTENT GOV POLICIES) (9.02KB) (1.43%)
    7.24ms
    1 x afterRenderRawModule mod_jsvisit_counter (VISIT) (196.98KB) (1.27%)
    6.43ms
    1 x Before Access::preloadComponents (all components) (691.7KB) (1.17%)
    5.92ms
    1 x afterRenderRawModule mod_eac_splwpk (SPLWPK - CONTENT GOV POLICIES) (35.32KB) (0.96%)
    4.83ms
    1 x afterRenderRawModule mod_custom () (101.2KB) (0.74%)
    3.73ms
    1 x beforeRenderRawModule mod_jsvisit_counter (VISIT) (203.27KB) (0.62%)
    3.11ms
    1 x After Access::preloadPermissions (com_content) (368.48KB) (0.52%)
    2.62ms
    1 x After Access::preloadComponents (all components) (137.2KB) (0.41%)
    2.07ms
    1 x beforeRenderComponent com_content (67.91KB) (0.31%)
    1.55ms
    1 x afterRenderRawModule mod_db8sitelastmodified (Site Last Modified) (22.25KB) (0.3%)
    1.53ms
    1 x beforeRenderRawModule mod_custom () (38.54KB) (0.26%)
    1.29ms
    1 x beforeRenderRawModule mod_datetime (Display Date and Time) (3.75KB) (0.21%)
    1.08ms
    1 x afterRenderRawModule mod_gtranslate (GTranslate) (13.91KB) (0.18%)
    905μs
    1 x afterRenderRawModule mod_custom () (960B) (0.17%)
    842μs
    1 x beforeRenderRawModule mod_menu () (5.34KB) (0.15%)
    775μs
    1 x afterRenderRawModule mod_custom () (3.39KB) (0.15%)
    766μs
    1 x afterRenderModule mod_menu () (38.81KB) (0.15%)
    761μs
    1 x afterRenderRawModule mod_datetime (Display Date and Time) (18.95KB) (0.14%)
    721μs
    1 x beforeRenderRawModule mod_menu () (1.36KB) (0.14%)
    694μs
    1 x beforeRenderRawModule mod_custom () (15.45KB) (0.13%)
    634μs
    1 x afterRenderModule mod_jsvisit_counter (VISIT) (21.45KB) (0.1%)
    513μs
    1 x beforeRenderRawModule mod_custom (sitemap) (1.05KB) (0.1%)
    488μs
    1 x beforeRenderRawModule mod_custom () (912B) (0.09%)
    472μs
    1 x After Access::getAssetRules (id:514 name:com_content.article.163) (24.42KB) (0.08%)
    407μs
    1 x afterRenderModule mod_menu () (2.45KB) (0.08%)
    383μs
    2 x afterRenderModule mod_custom () (3.55KB) (0.07%)
    350μs
    1 x afterRenderModule mod_finder () (3.81KB) (0.05%)
    235μs
    1 x afterRenderModule mod_custom () (2.98KB) (0.04%)
    181μs
    1 x afterRenderModule mod_db8sitelastmodified (Site Last Modified) (2.96KB) (0.04%)
    180μs
    1 x afterRenderModule mod_eac_splwpk (SPLWPK - CONTENT GOV POLICIES) (2.96KB) (0.04%)
    178μs
    1 x afterRenderModule mod_custom (sitemap) (2.44KB) (0.03%)
    155μs
    1 x afterRenderModule mod_datetime (Display Date and Time) (2.45KB) (0.03%)
    151μs
    1 x afterRenderModule mod_gtranslate (GTranslate) (2.45KB) (0.03%)
    146μs
    1 x afterRenderRawModule mod_custom (sitemap) (1.09KB) (0.02%)
    123μs
    1 x afterRenderModule mod_custom (call) (2.44KB) (0.02%)
    114μs
    1 x afterRenderModule mod_custom (feedback) (2.44KB) (0.02%)
    107μs
    1 x beforeRenderRawModule mod_db8sitelastmodified (Site Last Modified) (1.54KB) (0.02%)
    99μs
    1 x afterRenderRawModule mod_custom (call) (992B) (0.02%)
    88μs
    1 x afterRenderRawModule mod_custom (feedback) (976B) (0.02%)
    82μs
    1 x Before Access::getAssetRules (id:514 name:com_content.article.163) (18.65KB) (0.01%)
    40μs
    1 x beforeRenderRawModule mod_gtranslate (GTranslate) (320B) (0.01%)
    35μs
    1 x beforeRenderRawModule mod_finder () (37.85KB) (0.01%)
    28μs
    1 x Before Access::preloadPermissions (com_content) (1.85KB) (0%)
    23μs
    1 x beforeRenderRawModule mod_custom (call) (912B) (0%)
    22μs
    2 x beforeRenderModule mod_menu () (696B) (0%)
    21μs
    3 x beforeRenderModule mod_custom () (704B) (0%)
    21μs
    1 x beforeRenderRawModule mod_custom (feedback) (896B) (0%)
    19μs
    1 x beforeRenderModule mod_finder () (704B) (0%)
    9μs
    1 x beforeRenderModule mod_jsvisit_counter (VISIT) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_db8sitelastmodified (Site Last Modified) (736B) (0%)
    7μs
    1 x beforeRenderModule mod_eac_splwpk (SPLWPK - CONTENT GOV POLICIES) (736B) (0%)
    7μs
    1 x beforeRenderModule mod_gtranslate (GTranslate) (720B) (0%)
    7μs
    1 x beforeRenderModule mod_datetime (Display Date and Time) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom (sitemap) (704B) (0%)
    5μs
    1 x beforeRenderModule mod_custom (call) (704B) (0%)
    4μs
    1 x beforeRenderModule mod_custom (feedback) (720B) (0%)
    4μs
53 statements were executed, 15 of which were duplicates, 38 unique37.72ms790.41KB
UniquesDuplicates 1Duplicates 2Duplicates 3Duplicates 4Duplicates 5Duplicates 6
  • SELECT @@SESSION.sql_mode;213μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `mdpp_session` WHERE `session_id` = ?358μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `mdpp_session` WHERE `session_id` = :session_id LIMIT 1261μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `mdpp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)1.01ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `mdpp_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1494μs17.73KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `mdpp_viewlevels`186μs656B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `mdpp_usergroups` AS `a` LEFT JOIN `mdpp_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest180μs1.3KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `mdpp_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1) ORDER BY `ordering`726μs4.46KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT id,template FROM mdpp_template_styles WHERE client_id=0 AND home=1317μs1.2KB/administrator/components/com_widgetkit/widgetkit.php:28Copy
  • 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 `mdpp_menu` AS `m` LEFT JOIN `mdpp_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`1.96ms213.8KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `mdpp_template_styles` AS `s` LEFT JOIN `mdpp_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` = 1555μs112.84KB/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT * FROM `mdpp_languages` WHERE `published` = 1 ORDER BY `ordering` ASC330μs1.59KB/libraries/src/Language/LanguageHelper.php:177Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `mdpp_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,:preparedArray45,:preparedArray46,:preparedArray47,:preparedArray48,:preparedArray49)1.3ms7.81KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `mdpp_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 01.64ms29.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `mdpp_content`947μs1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • UPDATE `mdpp_content` SET `hits` = (`hits` + 1) WHERE `id` = '163'782μs48B/libraries/src/Table/Table.php:1348Copy
  • 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 `mdpp_content` AS `a` INNER JOIN `mdpp_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `mdpp_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `mdpp_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `mdpp_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `mdpp_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)690μs7.38KBParams/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 `mdpp_categories` AS `s` INNER JOIN `mdpp_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) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`870μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `mdpp_contentitem_tag_map` AS `m` INNER JOIN `mdpp_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)452μs3.95KBParams/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 `mdpp_categories` AS `s` INNER JOIN `mdpp_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) AND `c`.`published` = 1 AND `s`.`id` = :id ORDER BY `c`.`lft`1.08ms3.92KBParams/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 `mdpp_categories` AS `c` WHERE (`c`.`extension` = :extension OR `c`.`extension` = 'system') AND `c`.`access` IN (:preparedArray1) AND `c`.`published` = 1 ORDER BY `c`.`lft`2.12ms54.83KBParams/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 mdpp_fields AS a LEFT JOIN `mdpp_languages` AS l ON l.lang_code = a.language LEFT JOIN mdpp_users AS uc ON uc.id=a.checked_out LEFT JOIN mdpp_viewlevels AS ag ON ag.id = a.access LEFT JOIN mdpp_users AS ua ON ua.id = a.created_user_id LEFT JOIN mdpp_fields_groups AS g ON g.id = a.group_id LEFT JOIN `mdpp_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)) AND `a`.`access` IN (:preparedArray3)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray4)) 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 ASC1.53ms4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `mdpp_modules` AS `m` LEFT JOIN `mdpp_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `mdpp_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)) 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.45ms18.22KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `contact`.`id` AS `contactid`,`contact`.`alias`,`contact`.`catid`,`contact`.`webpage`,`contact`.`email_to` FROM `mdpp_contact_details` AS `contact` WHERE `contact`.`published` = 1 AND `contact`.`user_id` = :createdby ORDER BY `contact`.`id` DESC LIMIT 1471μs1.52KBParams/plugins/content/contact/src/Extension/Contact.php:142Copy
  • 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 `mdpp_content` AS `a` LEFT JOIN `mdpp_categories` AS `cc` ON `cc`.`id` = `a`.`catid` WHERE `a`.`catid` = :catid AND `a`.`state` = :state AND `a`.`access` IN (:preparedArray1) 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 DESC1.16ms1.72KBParams/plugins/content/pagenavigation/src/Extension/PageNavigation.php:188Copy
  • SELECT custom_data FROM mdpp_extensions WHERE element = 'yootheme' AND folder = 'system' LIMIT 1395μs48.52KB/templates/yootheme/packages/platform-joomla/src/Storage.php:30Copy
  • select SUM(count) from mdpp_visitors_country where country != 'zz'493μs536B/modules/mod_jsvisit_counter/helper.php:73Copy
  • select count(*) from mdpp_visitors_country where count>0 and country != 'zz'357μs536B/modules/mod_jsvisit_counter/helper.php:81Copy
  • SELECT country, name, count FROM mdpp_visitors_country where country != 'zz' ORDER BY count DESC LIMIT 0183μs640B/modules/mod_jsvisit_counter/helper.php:85Copy
  • select count from mdpp_visitors where id = '7'245μs536B/modules/mod_jsvisit_counter/helper.php:162Copy
  • select count from mdpp_visitors where id = '7'181μs40B/modules/mod_jsvisit_counter/helper.php:165Copy
  • select count from mdpp_visitors where id = '1'194μs536B/modules/mod_jsvisit_counter/helper.php:162Copy
  • select count from mdpp_visitors where id = '1'175μs2.54KB/modules/mod_jsvisit_counter/helper.php:165Copy
  • select count from mdpp_visitors where id = '8'189μs536B/modules/mod_jsvisit_counter/helper.php:162Copy
  • select count from mdpp_visitors where id = '8'178μs40B/modules/mod_jsvisit_counter/helper.php:165Copy
  • select count from mdpp_visitors where id = '7'199μs536B/modules/mod_jsvisit_counter/helper.php:162Copy
  • select count from mdpp_visitors where id = '7'208μs40B/modules/mod_jsvisit_counter/helper.php:165Copy
  • SELECT MAX( created ) AS created, MAX( modified ) AS modified FROM mdpp_content848μs592B/modules/mod_db8sitelastmodified/helper.php:38Copy
  • SELECT MAX( modified ) AS modified FROM mdpp_content683μs536B/modules/mod_eac_splwpk/helper.php:16Copy
  • SELECT MAX( a.modified ) AS modified, a.title AS title FROM `mdpp_content` AS `a` INNER JOIN `mdpp_categories` AS `b` ON `a`.`catid` = `b`.`id` WHERE `b`.`title` LIKE '%'1.92ms592B/modules/mod_eac_splwpk/tmpl/default.php:38Copy
  • SELECT SUBSTRING(table_name, 7) FROM information_schema.tables WHERE table_schema = 'db_mdppkijang24' AND table_name IN ('mdpp_sppagebuilder')429μs536B/modules/mod_eac_splwpk/tmpl/default.php:58Copy
  • 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 `mdpp_menu` AS `m` LEFT JOIN `mdpp_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`2.4ms213.8KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT GROUP_CONCAT(c.slug ORDER BY r.level DESC SEPARATOR '/') FROM `mdpp_docman_category_relations` as r INNER JOIN `mdpp_docman_categories` AS c2 ON c2.slug = 'risalah' LEFT JOIN `mdpp_docman_categories` AS c ON c.docman_category_id = r.ancestor_id WHERE r.descendant_id = c2.docman_category_id ORDER BY r.level DESC494μs536B/components/com_docman/router.php:83Copy
  • SELECT `name`,`element` FROM `mdpp_extensions` WHERE `type` = 'plugin' AND `folder` = 'finder' AND `enabled` = 1865μs704B/administrator/components/com_finder/src/Helper/LanguageHelper.php:135Copy
  • SELECT `title` FROM `mdpp_finder_taxonomy` WHERE `parent_id` = 1 AND `state` = 1 AND `access` IN (1)335μs520B/administrator/components/com_finder/src/Indexer/Taxonomy.php:325Copy
  • 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 mdpp_fields AS a LEFT JOIN `mdpp_languages` AS l ON l.lang_code = a.language LEFT JOIN mdpp_users AS uc ON uc.id=a.checked_out LEFT JOIN mdpp_viewlevels AS ag ON ag.id = a.access LEFT JOIN mdpp_users AS ua ON ua.id = a.created_user_id LEFT JOIN mdpp_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray2)) 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 ASC1.62ms4.03KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT * FROM `mdpp_schemaorg` WHERE `itemId` = :itemId AND `context` = :context295μs1.55KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:403Copy
  • 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 `mdpp_content` AS `a` INNER JOIN `mdpp_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `mdpp_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `mdpp_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `mdpp_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `mdpp_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)755μs6.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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 `mdpp_content` AS `a` INNER JOIN `mdpp_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `mdpp_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `mdpp_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `mdpp_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `mdpp_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)665μs6.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • 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 `mdpp_scheduler_tasks` AS `a` WHERE `a`.`state` = 1350μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:465Copy
  • SELECT sleep_until < '2025-04-01 06:52:39' FROM mdpp_scheduler_metadata WHERE type = 'metadata' LIMIT 1271μs536B/plugins/system/joomlatoolsscheduler/joomlatoolsscheduler.php:128Copy
  • SELECT `session_id` FROM `mdpp_session` WHERE `session_id` = ?491μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `mdpp_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?1.21ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy