Country Province/State and City Functions and code

Parent Category: Projects

Country Province/State City Functions and Code

We are beginning the release our Country, Province/State and city functions and code. Our goal is to eventually have functions, arrays and code for every programming language, but because we use PHP, Delphi, and Java most of the time in our work, we will be focusing on them.

Below is a PHP function that returns an array of ISO 3166-3 Country Codes and the normal English name of the Country. Please register to see most of the code. Don't worry... it's free, and we won't spam you. Note also that this is a work in progress, and we will add many more functions as time permits.

Note that you can reorder the array below if you don't want Canada and the U.S. to be first. Just put them back into alphabetical order. We use this array with another function to populate Country Select boxes on websites.

 

Login

J! InfoRequestSessionProfileQueries41
3.794MBMemory Usage84.36msRequest Duration
Joomla! Version5.1.3
PHP Version8.3.16
Identityguest
Response200
Templatecassiopeia
Database
Server
mysql
Version
8.0.42-0ubuntu0.22.04.1
Collation
utf8mb4_0900_ai_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:42 [ "USER" => "www-data" "HOME" => "/var/www" "HTTP_PRIORITY" => "u=0, i" "HTTP_ACCEP...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1749313295 "last" => 1749313295...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
plg_system_webauthn
array:1 [ "returnUrl" => "https://bgies.com/index.php/projects/country-province-state-functions-an...
  • afterLoad (80.94KB) (1.27ms)
  • afterInitialise (1.41MB) (21.96ms)
  • afterRoute (220.47KB) (4.79ms)
  • beforeRenderComponent com_content (35.78KB) (1.87ms)
  • Before Access::preloadComponents (all components) (53.78KB) (564μs)
  • After Access::preloadComponents (all components) (125.93KB) (969μs)
  • Before Access::preloadPermissions (com_content) (424B) (21μs)
  • After Access::preloadPermissions (com_content) (8.34KB) (691μs)
  • Before Access::getAssetRules (id:130 name:com_content.article.34) (104B) (20μs)
  • After Access::getAssetRules (id:130 name:com_content.article.34) (8.3KB) (92μs)
  • Before Access::getAssetRules (id:1 name:root.1) (165.17KB) (13.99ms)
  • After Access::getAssetRules (id:1 name:root.1) (6.48KB) (33μs)
  • afterRenderComponent com_content (257.16KB) (9.42ms)
  • afterDispatch (2.27KB) (207μs)
  • beforeRenderRawModule mod_cblogin (Login) (359.98KB) (3.78ms)
  • afterRenderRawModule mod_cblogin (Login) (304.02KB) (11.24ms)
  • beforeRenderRawModule mod_comprofileronline (CB Online) (7.94KB) (57μs)
  • afterRenderRawModule mod_comprofileronline (CB Online) (12.63KB) (750μs)
  • beforeRenderRawModule mod_menu (Main Menu) (2.93KB) (59μs)
  • afterRenderRawModule mod_menu (Main Menu) (136.31KB) (2.42ms)
  • beforeRenderModule mod_cblogin (Login) (1.34KB) (316μs)
  • afterRenderModule mod_cblogin (Login) (6.94KB) (248μs)
  • beforeRenderModule mod_comprofileronline (CB Online) (9.52KB) (27μs)
  • afterRenderModule mod_comprofileronline (CB Online) (2.47KB) (77μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (616B) (169μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (8.99KB) (529μs)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (8μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (4.11KB) (150μs)
  • beforeRenderModule mod_menu (Main Menu) (2.35KB) (80μs)
  • afterRenderModule mod_menu (Main Menu) (6.36KB) (93μs)
  • afterRender (209.61KB) (8.16ms)
  • 1 x afterInitialise (1.41MB) (26.03%)
    21.96ms
    1 x Before Access::getAssetRules (id:1 name:root.1) (165.17KB) (16.58%)
    13.99ms
    1 x afterRenderRawModule mod_cblogin (Login) (304.02KB) (13.33%)
    11.24ms
    1 x afterRenderComponent com_content (257.16KB) (11.16%)
    9.42ms
    1 x afterRender (209.61KB) (9.67%)
    8.16ms
    1 x afterRoute (220.47KB) (5.67%)
    4.79ms
    1 x beforeRenderRawModule mod_cblogin (Login) (359.98KB) (4.47%)
    3.78ms
    1 x afterRenderRawModule mod_menu (Main Menu) (136.31KB) (2.87%)
    2.42ms
    1 x beforeRenderComponent com_content (35.78KB) (2.22%)
    1.87ms
    1 x afterLoad (80.94KB) (1.5%)
    1.27ms
    1 x After Access::preloadComponents (all components) (125.93KB) (1.15%)
    969μs
    1 x afterRenderRawModule mod_comprofileronline (CB Online) (12.63KB) (0.89%)
    750μs
    1 x After Access::preloadPermissions (com_content) (8.34KB) (0.82%)
    691μs
    1 x Before Access::preloadComponents (all components) (53.78KB) (0.67%)
    564μs
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (8.99KB) (0.63%)
    529μs
    1 x beforeRenderModule mod_cblogin (Login) (1.34KB) (0.37%)
    316μs
    1 x afterRenderModule mod_cblogin (Login) (6.94KB) (0.29%)
    248μs
    1 x afterDispatch (2.27KB) (0.25%)
    207μs
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (616B) (0.2%)
    169μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (4.11KB) (0.18%)
    150μs
    1 x afterRenderModule mod_menu (Main Menu) (6.36KB) (0.11%)
    93μs
    1 x After Access::getAssetRules (id:130 name:com_content.article.34) (8.3KB) (0.11%)
    92μs
    1 x beforeRenderModule mod_menu (Main Menu) (2.35KB) (0.09%)
    80μs
    1 x afterRenderModule mod_comprofileronline (CB Online) (2.47KB) (0.09%)
    77μs
    1 x beforeRenderRawModule mod_menu (Main Menu) (2.93KB) (0.07%)
    59μs
    1 x beforeRenderRawModule mod_comprofileronline (CB Online) (7.94KB) (0.07%)
    57μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.48KB) (0.04%)
    33μs
    1 x beforeRenderModule mod_comprofileronline (CB Online) (9.52KB) (0.03%)
    27μs
    1 x Before Access::preloadPermissions (com_content) (424B) (0.02%)
    21μs
    1 x Before Access::getAssetRules (id:130 name:com_content.article.34) (104B) (0.02%)
    20μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0.01%)
    8μs
41 statements were executed, 5 of which were duplicates, 36 unique33.63ms123.11KB
UniquesDuplicates 1Duplicates 2
  • SELECT @@SESSION.sql_mode;103μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `d5l6o_session` WHERE `session_id` = ?226μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `d5l6o_session` WHERE `session_id` = :session_id LIMIT 1150μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `d5l6o_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)5.75ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `d5l6o_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1458μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `d5l6o_viewlevels`165μs656B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `d5l6o_usergroups` AS `a` LEFT JOIN `d5l6o_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest262μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `d5l6o_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`908μs3.98KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT * FROM `d5l6o_kunena_configuration` WHERE `id` = 1154μs1.2KB/libraries/kunena/src/Config/KunenaConfig.php:1709Copy
  • SELECT sampleData FROM d5l6o_kunena_version ORDER BY id DESC LIMIT 1130μs536B/libraries/kunena/src/Forum/KunenaForum.php:374Copy
  • 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 `d5l6o_menu` AS `m` LEFT JOIN `d5l6o_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`620μs19.8KBParams/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 `d5l6o_categories` AS `s` INNER JOIN `d5l6o_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`396μs3.88KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `id` FROM `d5l6o_content` WHERE `alias` = :alias AND `catid` = :catid310μs1.34KBParams/components/com_content/src/Service/Router.php:263Copy
  • SELECT * FROM `d5l6o_languages` WHERE `published` = 1 ORDER BY `ordering` ASC184μs1.59KB/libraries/src/Language/LanguageHelper.php:177Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `d5l6o_template_styles` AS `s` LEFT JOIN `d5l6o_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` = 1261μs832B/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `d5l6o_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)574μs7.56KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `d5l6o_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0357μs3.61KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `d5l6o_content`1.33ms1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • UPDATE `d5l6o_content` SET `hits` = (`hits` + 1) WHERE `id` = '34'5.81ms48B/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 `d5l6o_content` AS `a` INNER JOIN `d5l6o_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `d5l6o_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `d5l6o_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `d5l6o_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `d5l6o_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)585μs6.12KBParams/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 `d5l6o_categories` AS `s` INNER JOIN `d5l6o_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`623μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `d5l6o_contentitem_tag_map` AS `m` INNER JOIN `d5l6o_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)455μs3.97KBParams/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 `d5l6o_categories` AS `s` INNER JOIN `d5l6o_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`534μs3.92KBParams/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 d5l6o_fields AS a LEFT JOIN `d5l6o_languages` AS l ON l.lang_code = a.language LEFT JOIN d5l6o_users AS uc ON uc.id=a.checked_out LEFT JOIN d5l6o_viewlevels AS ag ON ag.id = a.access LEFT JOIN d5l6o_users AS ua ON ua.id = a.created_user_id LEFT JOIN d5l6o_fields_groups AS g ON g.id = a.group_id LEFT JOIN `d5l6o_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 ASC493μs4.81KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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 `d5l6o_content` AS `a` LEFT JOIN `d5l6o_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 DESC518μs1.81KBParams/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 `d5l6o_categories` AS `s` INNER JOIN `d5l6o_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`521μs3.92KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `d5l6o_modules` AS `m` LEFT JOIN `d5l6o_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `d5l6o_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`563μs1.88KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `params` FROM `d5l6o_comprofiler_plugin` WHERE `id` = 1149μs536BCopy
  • SELECT *, CONCAT_WS( "/", `folder`, `element` ) AS lookup FROM `d5l6o_comprofiler_plugin` WHERE `published` = 1 AND `viewaccesslevel` IN (1,5) AND `type` = 'user' ORDER BY `ordering`263μs1.73KBCopy
  • SHOW FULL COLUMNS FROM `d5l6o_users`955μs1.58KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT f.* FROM d5l6o_comprofiler_fields f INNER JOIN d5l6o_comprofiler_tabs AS t ON (f.tabid = t.tabid) WHERE f.published = 1 ORDER BY t.position, t.ordering, f.ordering478μs3.3KBCopy
  • SELECT `id` FROM `d5l6o_menu` WHERE ( `link` = 'index.php?option=com_comprofiler&view=userprofile' OR `link` = 'index.php?option=com_comprofiler&task=userprofile' OR `link` = 'index.php?option=com_comprofiler' ) AND `published` = 1 AND `access` IN ( 1,5 ) AND `language` IN ( 'en-GB', '*', '' ) AND `client_id` = 0365μs552BCopy
  • SELECT `id` FROM `d5l6o_menu` WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=login%' OR `link` LIKE 'index.php?option=com_comprofiler&task=login%' ) AND `published` = 1 AND `access` IN ( 1,5 ) AND `language` IN ( 'en-GB', '*', '' ) AND `client_id` = 0407μs3.02KBCopy
  • SELECT `id` FROM `d5l6o_menu` WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=lostpassword%' OR `link` LIKE 'index.php?option=com_comprofiler&task=lostpassword%' ) AND `published` = 1 AND `access` IN ( 1,5 ) AND `language` IN ( 'en-GB', '*', '' ) AND `client_id` = 0349μs536BCopy
  • SELECT `id` FROM `d5l6o_menu` WHERE ( `link` LIKE 'index.php?option=com_comprofiler&view=registers%' OR `link` LIKE 'index.php?option=com_comprofiler&task=registers%' ) AND `published` = 1 AND `access` IN ( 1,5 ) AND `language` IN ( 'en-GB', '*', '' ) AND `client_id` = 0339μs536BCopy
  • SELECT DISTINCT `userid` FROM `d5l6o_session` WHERE `client_id` = 0 AND `guest` = 0 ORDER BY `time` DESC LIMIT 30205μs520BCopy
  • 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 `d5l6o_scheduler_tasks` AS `a` WHERE `a`.`state` = 1276μs1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:466Copy
  • SELECT * FROM `d5l6o_schemaorg` WHERE `itemId` = :itemId AND `context` = :context260μs17.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 `d5l6o_content` AS `a` INNER JOIN `d5l6o_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `d5l6o_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `d5l6o_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `d5l6o_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `d5l6o_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)606μs6.17KBParams/components/com_content/src/Model/ArticleModel.php:215Copy
  • SELECT `session_id` FROM `d5l6o_session` WHERE `session_id` = ?165μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `d5l6o_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?6.37ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy