Python Introduction

Details
Category: Python Tutorials

Introduction and Features of Python

Python is a High-Level (Human Readable) programming language developed by Guido Van Rossum in the year 1991 at center for Mathematics and Computer Science run under Dutch Government.

Python name come from a TV Show called "Monty Python's Flying Circus".

Python supports Windows, Linux and Mac operating Systems and it is free and open source. Downloaded from official Website python.org

Features of Python

  • Easy to learn and Simple
  • Portable
  • Interpreted language
  • Free and Open Source
  • Python is Extensible
  • Python is High-Level
  • Big Library
  • Scripting Language
  • Procedure and Object Oriented Language

Easy to learn and Simple: Python Syntax is simple to understand and write. We can write our code with fewer number of steps compared to C, C++, and Java.

Python is Portable: Python is platform independent, that means, Python runs under different operating systems like Windows, Linux, and Mac. It is designed for better portability; it means that the program gives the same result on any system.

Interpreted language: Python does not have compilation phase; it is only interpreted language and it uses Python virtual machine.

Free and Open Source: Python is distributed under Python Software Foundation License which supports GNL General Public License (GPL). Everyone can use the software for free. Python is Extensible: It allows the adding of low-level modules to interpreter for customization.

Python is High-Level: Python is a High-level language, that means it uses English words to write programs, so that everyone can understand and write codes using python.

Big Library: Python consists of a huge set of built-in functions called Standard Library Functions. It also supports third party libraries like, Numpy, Pandas, Sympy, etc. Libraries are available for most of the modern technologies like Data Science, AI, Machine Learning.

Let us see some of the python libraries:

  • Numpy- package for single and multi-dimensional arrays in python. Fiona- Reads and Writes bigdata files
  • Pandas- Data analysis, Time series and statistics.
  • Pillow- python imaging library
  • Scipy- for Scientific and Engineering calculations

Scripting Language: Python is a scripting language, that means, it doesn’t use compiler. Python uses only interpreter to translate source code into machine code while running.

Procedure and Object Oriented Language: Python is both procedural and object oriented, in procedural, we use functions and procedures, where as in object oriented, we use classes and objects.

In python, variables, lists, functions, arrays, etc are considered as objects.

J! InfoRequestSessionProfileQueries57Log15
11MBMemory Usage805msRequest Duration
Joomla! Version4.2.5
PHP Version7.4.33
Identityguest
Response200
Templateg5_helium
Database
Server
mysql
Version
5.7.23-23
Collation
utf8_unicode_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
[]
$_COOKIE
[]
$_SERVER
array:87 [ "LSPHP_ENABLE_USER_INI" => "on" "PATH" => "/usr/local/bin:/usr/bin:/bin" "TEMP" => ...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1748651559 "last" => 1748651559...
registry
array:3 [ "data" => [] "initialized" => false "separator" => "." ]
user
array:18 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
PHPDEBUGBAR_STACK_DATA
[]
  • afterLoad (552.78KB) (5ms)
  • afterInitialise (1.5MB) (20.3ms)
  • afterRoute (825.95KB) (18.91ms)
  • beforeRenderComponent com_content (138.73KB) (1.62ms)
  • Before Access::preloadComponents (all components) (55.55KB) (1.08ms)
  • After Access::preloadComponents (all components) (121KB) (1.19ms)
  • Before Access::preloadPermissions (com_content) (3.88KB) (30μs)
  • After Access::preloadPermissions (com_content) (256.8KB) (1.42ms)
  • Before Access::getAssetRules (id:1038 name:com_content.article.350) (18.8KB) (30μs)
  • After Access::getAssetRules (id:1038 name:com_content.article.350) (8.66KB) (178μs)
  • afterRenderComponent com_content (514.23KB) (17.37ms)
  • afterDispatch (2.25KB) (185μs)
  • beforeRenderRawModule mod_search (Search) (1.14MB) (17.06ms)
  • afterRenderRawModule mod_search (Search) (281.44KB) (4.16ms)
  • beforeRenderModule mod_search (Search) (704B) (12μs)
  • afterRenderModule mod_search (Search) (3.3KB) (226μs)
  • beforeRenderRawModule mod_articles_latest (Python Tutorials) (47.82KB) (1.86ms)
  • Before Access::getAssetRules (id:8 name:com_content) (119.52KB) (1.16ms)
  • After Access::getAssetRules (id:8 name:com_content) (1.59KB) (14μs)
  • afterRenderRawModule mod_articles_latest (Python Tutorials) (67.3KB) (4.05ms)
  • beforeRenderModule mod_articles_latest (Python Tutorials) (344B) (8μs)
  • afterRenderModule mod_articles_latest (Python Tutorials) (4.95KB) (132μs)
  • beforeRenderRawModule mod_jbounce (JBounce) (3.63KB) (51μs)
  • afterRenderRawModule mod_jbounce (JBounce) (2.5KB) (110μs)
  • beforeRenderModule mod_jbounce (JBounce) (720B) (5μs)
  • afterRenderModule mod_jbounce (JBounce) (1.28KB) (87μs)
  • Before Access::getAssetRules (id:1 name:root.1) (727.59KB) (558ms)
  • After Access::getAssetRules (id:1 name:root.1) (6.95KB) (41μs)
  • afterRender (338.7KB) (137ms)
  • 1 x Before Access::getAssetRules (id:1 name:root.1) (727.59KB) (69.23%)
    557.60ms
    1 x afterRender (338.7KB) (16.98%)
    136.78ms
    1 x afterInitialise (1.5MB) (2.52%)
    20.30ms
    1 x afterRoute (825.95KB) (2.35%)
    18.91ms
    1 x afterRenderComponent com_content (514.23KB) (2.16%)
    17.37ms
    1 x beforeRenderRawModule mod_search (Search) (1.14MB) (2.12%)
    17.06ms
    1 x afterLoad (552.78KB) (0.62%)
    5.00ms
    1 x afterRenderRawModule mod_search (Search) (281.44KB) (0.52%)
    4.16ms
    1 x afterRenderRawModule mod_articles_latest (Python Tutorials) (67.3KB) (0.5%)
    4.05ms
    1 x beforeRenderRawModule mod_articles_latest (Python Tutorials) (47.82KB) (0.23%)
    1.86ms
    1 x beforeRenderComponent com_content (138.73KB) (0.2%)
    1.62ms
    1 x After Access::preloadPermissions (com_content) (256.8KB) (0.18%)
    1.42ms
    1 x After Access::preloadComponents (all components) (121KB) (0.15%)
    1.19ms
    1 x Before Access::getAssetRules (id:8 name:com_content) (119.52KB) (0.14%)
    1.16ms
    1 x Before Access::preloadComponents (all components) (55.55KB) (0.13%)
    1.08ms
    1 x afterRenderModule mod_search (Search) (3.3KB) (0.03%)
    226μs
    1 x afterDispatch (2.25KB) (0.02%)
    185μs
    1 x After Access::getAssetRules (id:1038 name:com_content.article.350) (8.66KB) (0.02%)
    178μs
    1 x afterRenderModule mod_articles_latest (Python Tutorials) (4.95KB) (0.02%)
    132μs
    1 x afterRenderRawModule mod_jbounce (JBounce) (2.5KB) (0.01%)
    110μs
    1 x afterRenderModule mod_jbounce (JBounce) (1.28KB) (0.01%)
    87μs
    1 x beforeRenderRawModule mod_jbounce (JBounce) (3.63KB) (0.01%)
    51μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.95KB) (0.01%)
    41μs
    1 x Before Access::preloadPermissions (com_content) (3.88KB) (0%)
    30μs
    1 x Before Access::getAssetRules (id:1038 name:com_content.article.350) (18.8KB) (0%)
    30μs
    1 x After Access::getAssetRules (id:8 name:com_content) (1.59KB) (0%)
    14μs
    1 x beforeRenderModule mod_search (Search) (704B) (0%)
    12μs
    1 x beforeRenderModule mod_articles_latest (Python Tutorials) (344B) (0%)
    8μs
    1 x beforeRenderModule mod_jbounce (JBounce) (720B) (0%)
    5μs
57 statements were executed, 9 of which were duplicates, 48 unique21.19ms374.24KB
UniquesDuplicates 1Duplicates 2Duplicates 3Duplicates 4
  • SELECT @@SESSION.sql_mode;82μs1.59KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:293Copy
  • SELECT `data` FROM `joom_session` WHERE `session_id` = ?155μs1.61KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:261Copy
  • SELECT `session_id` FROM `joom_session` WHERE `session_id` = :session_id LIMIT 1102μs1.61KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `joom_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)215μs944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `joom_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1329μs4.73KB/libraries/src/Component/ComponentHelper.php:393Copy
  • SELECT `id`,`rules` FROM `joom_viewlevels`98μs1.06KB/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `joom_usergroups` AS `a` LEFT JOIN `joom_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest150μs1.67KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `joom_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`573μs11.8KBParams/libraries/src/Plugin/PluginHelper.php:283Copy
  • 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 `joom_menu` AS `m` LEFT JOIN `joom_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`653μs46.23KBParams/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 `joom_categories` AS `s` INNER JOIN `joom_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`387μs6.62KBParams/libraries/src/Categories/Categories.php:360Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `joom_template_styles` AS `s` LEFT JOIN `joom_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` = 1256μs1.47KB/administrator/components/com_templates/src/Model/StyleModel.php:771Copy
  • SELECT s.id, s.template, s.home, s.title AS long_title, s.params FROM joom_template_styles AS s WHERE s.client_id = 0 AND s.template = 'g5_helium' ORDER BY s.id183μs1.23KB/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69Copy
  • SELECT * FROM `joom_languages` WHERE `published` = 1 ORDER BY `ordering` ASC202μs2.44KB/libraries/src/Language/LanguageHelper.php:142Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `joom_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)477μs10.25KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `joom_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 0763μs69.8KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `joom_content`692μs10.39KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:584Copy
  • UPDATE joom_content SET `hits` = (`hits` + 1) WHERE `id` = '350'196μs2.55KB/libraries/src/Table/Table.php:1319Copy
  • 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 `joom_content` AS `a` INNER JOIN `joom_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `joom_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `joom_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `joom_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `joom_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)712μs9.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 `joom_categories` AS `s` INNER JOIN `joom_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`386μs6.67KBParams/libraries/src/Categories/Categories.php:360Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `joom_contentitem_tag_map` AS `m` INNER JOIN `joom_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)435μs5.73KBParams/libraries/src/Helper/TagsHelper.php:364Copy
  • 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 `joom_categories` AS `s` INNER JOIN `joom_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`375μs6.67KBParams/libraries/src/Categories/Categories.php:360Copy
  • 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 joom_fields AS a LEFT JOIN `joom_languages` AS l ON l.lang_code = a.language LEFT JOIN joom_users AS uc ON uc.id=a.checked_out LEFT JOIN joom_viewlevels AS ag ON ag.id = a.access LEFT JOIN joom_users AS ua ON ua.id = a.created_user_id LEFT JOIN joom_fields_groups AS g ON g.id = a.group_id LEFT JOIN `joom_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 ASC568μs6.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165Copy
  • 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 `joom_content` AS `a` LEFT JOIN `joom_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 DESC389μs3.19KBParams/plugins/content/pagenavigation/pagenavigation.php:186Copy
  • 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 `joom_categories` AS `s` INNER JOIN `joom_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`486μs6.67KBParams/libraries/src/Categories/Categories.php:360Copy
  • SELECT `a`.`menutype`,`a`.`title` FROM `joom_menu_types` AS `a` WHERE `a`.`client_id` = 0162μs1.06KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:138Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM joom_menu AS m WHERE m.menutype = 'main-menu' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft355μs3.17KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `joom_modules` AS `m` LEFT JOIN `joom_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `joom_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`805μs3.53KBParams/libraries/src/Cache/Controller/CallbackController.php:52Copy
  • SELECT `alias` FROM `joom_content` WHERE `id` = :id205μs1.64KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT `alias` FROM `joom_content` WHERE `id` = :id175μs1.64KBParams/components/com_content/src/Service/Router.php:168Copy
  • SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id FROM joom_menu AS m WHERE m.menutype = 'my-menu' AND m.parent_id > 0 AND m.client_id = 0 AND m.published >= 0 ORDER BY m.lft312μs1.56KB/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791Copy
  • 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` FROM `joom_content` AS `a` LEFT JOIN `joom_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `joom_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `joom_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `joom_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `joom_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` WHERE `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` IN (:preparedArray1,:preparedArray2) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) ORDER BY RAND() DESC LIMIT 101.37ms64.88KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165Copy
  • 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 `joom_categories` AS `s` INNER JOIN `joom_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`512μs6.67KBParams/libraries/src/Categories/Categories.php:360Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor` FROM `joom_scheduler_tasks` AS `a` LEFT JOIN `joom_users` AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE `a`.`state` = :state AND `a`.`next_execution` <= :now ORDER BY `a`.`title` asc386μs15.45KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy
  • SELECT `a`.`id`,`a`.`asset_id`,`a`.`title`,`a`.`type`,`a`.`execution_rules`,`a`.`state`,`a`.`last_exit_code`,`a`.`locked`,`a`.`last_execution`,`a`.`next_execution`,`a`.`times_executed`,`a`.`times_failed`,`a`.`priority`,`a`.`ordering`,`a`.`note`,`a`.`checked_out`,`a`.`checked_out_time`,`uc`.`name` AS `editor` FROM `joom_scheduler_tasks` AS `a` LEFT JOIN `joom_users` AS `uc` ON `uc`.`id` = `a`.`checked_out` WHERE `a`.`state` = :state AND `a`.`locked` IS NOT NULL ORDER BY `a`.`title` asc308μs4.43KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:391Copy
  • UPDATE `joom_extensions` SET `params` = :params WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'updatenotification'305μs856BParams/plugins/system/updatenotification/updatenotification.php:125Copy
  • SELECT * FROM `joom_extensions` WHERE `element` = :element AND `type` = :type LIMIT 1291μs4.91KBParams/libraries/src/Extension/ExtensionHelper.php:479Copy
  • SELECT DISTINCT `a`.`update_site_id`,`a`.`type`,`a`.`location`,`a`.`last_check_timestamp`,`a`.`extra_query` FROM `joom_update_sites` AS `a` INNER JOIN `joom_update_sites_extensions` AS `b` ON `a`.`update_site_id` = `b`.`update_site_id` WHERE `a`.`enabled` = 1 AND `b`.`extension_id` IN (:preparedArray1)485μs1.93KBParams/libraries/src/Updater/Updater.php:228Copy
  • SELECT DISTINCT `update_site_id` FROM `joom_updates` WHERE `update_site_id` IN ( SELECT `update_site_id` FROM `joom_update_sites` WHERE `last_check_timestamp` IS NULL OR `last_check_timestamp` <= :timestamp)350μs1.7KBParams/libraries/src/Updater/Updater.php:394Copy
  • DELETE FROM `joom_updates` WHERE `update_site_id` = :id320μs808BParams/libraries/src/Updater/Updater.php:163Copy
  • SELECT `name` FROM `joom_update_sites` WHERE `update_site_id` = :id140μs1.64KBParams/libraries/src/Updater/UpdateAdapter.php:196Copy
  • UPDATE `joom_update_sites` SET `enabled` = :enabled WHERE `update_site_id` = :id201μs880BParams/libraries/src/Updater/UpdateAdapter.php:164Copy
  • UPDATE `joom_update_sites` SET `enabled` = :enabled WHERE `update_site_id` = :id649μs832BParams/libraries/src/Updater/UpdateAdapter.php:164Copy
  • SHOW FULL COLUMNS FROM `joom_updates`982μs4.59KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:584Copy
  • SHOW FULL COLUMNS FROM `joom_extensions`582μs5.2KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:584Copy
  • SELECT `update_id` FROM `joom_updates` WHERE element = 'joomla' AND type = 'file' AND client_id = '0' AND folder = ''188μs840B/libraries/src/Table/Update.php:107Copy
  • SELECT `extension_id` FROM `joom_extensions` WHERE element = 'joomla' AND type = 'file' AND client_id = '0' AND folder = ''221μs872B/libraries/src/Table/Extension.php:115Copy
  • SELECT * FROM joom_extensions WHERE `extension_id` = '700'193μs4.09KB/libraries/src/Table/Table.php:749Copy
  • SHOW FULL COLUMNS FROM `joom_updates`523μs4.64KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:584Copy
  • INSERT INTO `joom_updates` (`update_site_id`,`extension_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`data`,`detailsurl`,`infourl`,`changelogurl`,`extra_query`) VALUES ('1','700','Joomla','','joomla','file','','0','4.4.13','','https://update.joomla.org/core/j4/default.xml','','','')201μs0B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:776Copy
  • UPDATE `joom_update_sites` SET `last_check_timestamp` = :timestamp WHERE `update_site_id` = :id180μs880BParams/libraries/src/Updater/Updater.php:425Copy
  • SELECT u.*,`e`.`manifest_cache` FROM `joom_updates` AS `u` LEFT JOIN `joom_extensions` AS `e` ON `e`.`extension_id` = `u`.`extension_id` WHERE `u`.`extension_id` != 0 AND `u`.`extension_id` = :extensionid ORDER BY `u`.`name` asc327μs3.27KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:165Copy
  • SHOW FULL COLUMNS FROM `joom_assets`269μs3.27KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:584Copy
  • SELECT id FROM joom_assets WHERE parent_id = 0121μs872B/libraries/src/Table/Nested.php:1157Copy
  • SELECT `user_id` FROM `joom_user_usergroup_map` WHERE `group_id` IN (:preparedArray1)516μs1.67KBParams/plugins/system/updatenotification/updatenotification.php:328Copy
  • SELECT `id`,`username`,`email` FROM `joom_users` WHERE `id` IN (:preparedArray1,:preparedArray2) AND `block` = 0 AND `sendEmail` = 1186μs1.88KBParams/plugins/system/updatenotification/updatenotification.php:352Copy
  • SELECT * FROM `joom_mail_templates` WHERE `template_id` = :key AND `language` IN (:preparedArray1,:preparedArray2) ORDER BY `language` DESC243μs2.19KBParams/libraries/src/Mail/MailTemplate.php:366Copy
  • SELECT * FROM `joom_mail_templates` WHERE `template_id` = :key AND `language` IN (:preparedArray1,:preparedArray2) ORDER BY `language` DESC267μs2.19KBParams/libraries/src/Mail/MailTemplate.php:366Copy
  • infoupdater - Loading information from update site #1 with name "Joomla! Core" and URL https://update.jo...
  • errormail - Error in Mail API: Sending with mail()
  • errormail - Error in Mail API: Sendmail path: /usr/sbin/sendmail -t -i
  • errormail - Error in Mail API: Envelope sender:
  • errormail - Error in Mail API: To: "rajasekhar.nv@gmail.com" <rajasekhar.nv@gmail.com>
  • errormail - Error in Mail API: Subject: =?utf-8?Q?Joomla!_Update_available_for_pro.programming9_?= =?utf...
  • errormail - Error in Mail API: Headers: Date: Sat, 31 May 2025 00:32:40 +0000 From: "pro.programming9.com...
  • errormail - Error in Mail API: Result: true
  • errormail - Error in Mail API: Sending with mail()
  • errormail - Error in Mail API: Sendmail path: /usr/sbin/sendmail -t -i
  • errormail - Error in Mail API: Envelope sender:
  • errormail - Error in Mail API: To: "rajasekhar.nv@live.com" <rajasekhar.nv@live.com>
  • errormail - Error in Mail API: Subject: =?utf-8?Q?Joomla!_Update_available_for_pro.programming9_?= =?utf...
  • errormail - Error in Mail API: Headers: Date: Sat, 31 May 2025 00:32:40 +0000 From: "pro.programming9.com...
  • errormail - Error in Mail API: Result: true
infoerror