Table: cnotas, rows: 170

Página 7 de 9
           


Deprecated: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /home/http/docs/santaclara5/libraries/src/HTML/Helpers/Grid.php on line 48

Deprecated: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /home/http/docs/santaclara5/libraries/src/HTML/Helpers/Grid.php on line 48

Deprecated: strtolower(): Passing null to parameter #1 ($string) of type string is deprecated in /home/http/docs/santaclara5/libraries/src/HTML/Helpers/Grid.php on line 48
id titulo contenido
59ssh ohne password von localen zum entfernten RechnerAuf dem localen Rechner:

% ssh-keygen -t rsa

Es fragt nach dem passphrase. Man less es blank
Das generiert die dateien ~/.ssh/id_rsa und ~/.ssh/id_rsa.pub

auf dem entfernten Rechner �ftet man mit einem editor
~/.ssh/authorized_keys und kopiert man die zeile von id_rsa.pub des Servers.
Achtung, diese zeile ist sehr lang
58man pages with extension$ man -S3 getopt
57Suse Release$ cat /etc/SuSE-release
56vmware 4.5.2 any-any-any patchhttp://knihovny.cvut.cz/ftp/pub/vmware/
55vmware nach der kernel patch#reboot
#cd /usr/src/linux
#make cloneconfig
#make prepare-all
#vmwar-config.pl
54Duplicate Linuxcp -a /bin /boot /dev /etc /home /lib
/lost+found /mnt /root /sbin /tmp /usr /var
in to new-disk
53PRINTER: Laserwriter 16/600 PS IPAdress zuweissenarp -s lhepsp9 08:00:07:04:a3:62
52Router SuseMit yast Network services/routing starten

dann

$> modprobe ipt_MASQUERADE # If this fails, try continuing anyway
$> iptables -F; iptables -t nat -F; iptables -t mangle -F
$> iptables -t nat -A POSTROUTING -o eth0 -j SNAT --to 123.12.23.43
$> echo 1 > /proc/sys/net/ipv4/ip_forward
51Redireccion to stdout and stderr$ command >junk 2>&1
to redirect both stdout and stderr to junk
50DHCP server SuSE 8.2datei /etc/dhcpd.conf

subnet 192.168.139.0 netmask 255.255.255.224 {
range 192.168.139.10 192.168.139.20;
option routers 192.168.139.1;
option domain-name "unibe.ch";
option domain-name-servers 130.92.4.41, 130.92.9.50;
}

Example von Internet:

Führen Sie als root folgendes Kommando aus:

route add -host 255.255.255.255 dev eth0

Sollte die Fehlermeldung

255.255.255.255: Unknown host


auftreten, dann tragen Sie folgenden Eintrag in Ihre /etc/hosts ein:


255.255.255.255 dhcp


Ist dieser eingefügt setzen Sie folgendes Kommando ab:

route add -host dhcp dev eth0


Optionen des DHCPD
------------------------------
# Sample /etc/dhcpd.conf
# (add your comments here)
default-lease-time 1200;
max-lease-time 9200;
option subnet-mask 255.255.255.0;
option broadcast-address 192.168.1.255;
option routers 192.168.1.254;
option domain-name-servers 192.168.1.1, 192.168.1.2;
option domain-name "mydomain.org";
subnet 192.168.1.0 netmask 255.255.255.0 {
range 192.168.1.10 192.168.1.100;
range 192.168.1.150 192.168.1.200;
}



Dieses Beispiel erlaubt dem DHCP Server einem Client IP Adressen im Bereich von 192.168.1.10-192.168.1.100 oder 192.168.1.150-192.168.1.200 zuzuweisen.


Wenn der Client keine größeres Zeitfenster anfordert vergibt der DHCP Server eine IP Adresse für 1200 Sekunden. Das maximal erlaubte Zeitfenster für die Adreßzuordnung durch den Server beträgt 9200 Sekunden. Auf Anfrage sendet der Server dem Client die folgenden Parameter:


Benutze 255.255.255.0 als Subnetzmaske
Benutze 192.168.1.255 als Broadcastadresse
Benutze 192.168.1.254 als default Gateway
Benutze 192.168.1.1 und 192.168.1.2 als DNS Server.



Um Windows Clients einen WINS Server zuzuordnen ist in der dhcpd.conf folgende Option notwendig:


option netbios-name-servers 192.168.1.1;


49Masquerading Suse8.2Assuming external internet card is eth0, and external IP is 123.12.23.43
and the internal network card is eth1, then:


$> modprobe ipt_MASQUERADE # If this fails, try continuing anyway
$> iptables -F; iptables -t nat -F; iptables -t mangle -F
$> iptables -t nat -A POSTROUTING -o eth0 -j SNAT --to 123.12.23.43
$> echo 1 > /proc/sys/net/ipv4/ip_forward
48floppy duplicate# dd if=/dev/fd0 of=.img bs=512
# dd if=.img of=/dev/fd0 bs=512
or
# cp /dev/fd0 .img
# cp .img /dev/fd0



47mysql Dump database definitionsmysqldump -h"host" -u"user" -p"passwd" -d --add-drop-table "myDatabase" > Mytmp.sql
46Printer CommandsView printer queue: lpq
View printer status: lpc
enable printer with CUPS: /usr/bin/enable
45Mac: Sharing files with Windows usersYou can share the files on your computer with Windows computer users using SMB/CIFS.

Open System Preferences, click Sharing, and turn on Windows File Sharing in the
Services tab.

Then, still in System Preferences, open Accounts preferences and create a new user
account for each Windows user you want to share with. In the user's settings, be sure to
select "Allow user to log in from Windows."

If you can't log in to your Macintosh from a Windows computer, reenter your user account
name on the Windows computer using all lowercase characters, reenter the password for
the account exactly as you entered it in Mac OS X, then log out and log back in to the
Windows computer using the new name and password.
44nfs neu starten (Sambabuch)rcnfs restart
rcportmaper restart
42Mac: how to change the workgroup used by Windows File Sharing.The default workgroup is "WORKGROUP".
To learn what a workgroup is, see technical document 106138, Windows File Sharing: What is a 'Workgroup'?
To change the workgroup, follow these steps:

1. Open Directory Access (/Applications/Utilities/).
2. Click the padlock to authenticate as an Admin user.
3. Select SMB from the Services list.
4. Click Configure.
5. Select the name of the workgroup from the list, or type the name of the workgroup you wish to create.
6. Click OK.
7. Click Apply.
8. Quit Directory Access.
41Apache21)
In file /etc/php.ini die variable register_globals auf On setzen
zb.
register_globals = On

2)
In /etc/apache2/httpd.conf die zeile einfügen:
Include /etc/apache2/lhep.conf

Diese Datei enthält:

LoadModule php4_module /usr/lib/apache2-prefork/libphp4.so

SetOutputFilter PHP
SetInputFilter PHP

##-----------------------------------------------------------------------
NameVirtualHost *


ServerName www.lhep.unibe.ch
DocumentRoot "/home/lhep/www"

# ------------------------------------------------------------------

AuthUserFile /home/lhep/www/.htpasswd
AuthName "INTERNAL LHEP PAGE"
AuthType Basic

Require user lhep


# ------------------------------------------------------------------

AuthUserFile /home/lhep/www/.htpasswd
AuthName "NEWMASS PRIVATE"
AuthType Basic

Require user newmass


# ------------------------------------------------------------------

AllowOverride None
Options +ExecCGI -Includes
SetHandler cgi-script


# ------------------------------------------------------------------


AuthUserFile /home/lhep/www/.htpasswd
AuthName "ORPHEUS PRIVATE"
AuthType Basic

Require user orpheus


# ------------------------------------------------------------------
#

AllowOverride None
Options FollowSymLinks +ExecCGI +Indexes

#
# ------------------------------------------------------------------


40find exampleschange owner:
find / -uid 500 -exec chown 510 {}\;

delete files:
find Peliculas/English -type f -name "*.nfo" -exec rm {} \;
39mysql MySQL server version 3.22.32
Port 3306
Data directory: /var/lib/mysql

Change password:
# mysqladmin password newpassword
or:
mysql> update user set password=passwor('new_password') where user='username';
mysql>flush privileges;
Example:
mysql> update user set password=password('gu') where user='root';
mysql> update user set password=password('penta') where user='mart';
or:
mysql> GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
ON lm_db.*
TO mart@localhost
IDENTIFIED BY 'penta';
Example:
mysql> grant select,insert,update,delete,create,drop on lm_db.* to mart@"%" identified by 'penta';
mysql> flush privileges;

mysql commands:
mysql> select version();courrentdate();
+-----------+
| version() |
+-----------+
| 3.22.32 |
+-----------+

mysql> select now();
+---------------------+
| now() |
+---------------------+
| 2001-01-24 11:15:41 |
+---------------------+

pc12:~% mysql -u root -pgu

mysql> use mysql;
Database changed
mysql> show tables;
+-----------------+
| Tables in mysql |
+-----------------+
| columns_priv |
| db |
| func |
| host |
| tables_priv |
| user |
+-----------------+
mysql> create database m_db;
mysql> exit;

lheppc12:~% mysqlshow -u root -pgu mysql user
Database: mysql Table: user Rows: 5
+-----------------+---------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+---------------+------+-----+---------+-------+
| Host | char(60) | | PRI | | |
| User | char(16) | | PRI | | |
| Password | char(16) | | | | |
| Select_priv | enum('N','Y') | | | N | |
| Insert_priv | enum('N','Y') | | | N | |
| Update_priv | enum('N','Y') | | | N | |
| Delete_priv | enum('N','Y') | | | N | |
| Create_priv | enum('N','Y') | | | N | |
| Drop_priv | enum('N','Y') | | | N | |
| Reload_priv | enum('N','Y') | | | N | |
| Shutdown_priv | enum('N','Y') | | | N | |
| Process_priv | enum('N','Y') | | | N | |
| File_priv | enum('N','Y') | | | N | |
| Grant_priv | enum('N','Y') | | | N | |
| References_priv | enum('N','Y') | | | N | |
| Index_priv | enum('N','Y') | | | N | |
| Alter_priv | enum('N','Y') | | | N | |
+-----------------+---------------+------+-----+---------+-------+

mysql> select host,user,password from user;
+-------------------+----------+------------------+
| host | user | password |
+-------------------+----------+------------------+
| localhost | root | 6db8a3ad1c53bcbe |
| pc12.unibe.ch | root | 6db8a3ad1c53bcbe |
| localhost | | |
| pc12.unibe.ch | | |
| % | mart | 2ae2f8a422678189 |
+-------------------+----------+------------------+
--------------------------------------------------------------------------------------------------------------
Database accessable from other computer:



mysql> grant all privileges on *.* to myadmin@"%" identified by 'penta' with grant option;

mysql> grant all privileges on *.* to myadmin@localhost identified by 'penta' with grant option;

En MySQL 5.0 o superior hay que comentar la frase en
/etc/mysql/my.cnf
que dice:
#bind-address = 127.0.0.1


-----------------------------------------------------------------------------------------------------------
3.025MBMemory Usage127msRequest Duration
Joomla! Version5.2.5
PHP Version8.3.19
Identityguest
Response200
Templatecassiopeia
Database
Server
mysql
Version
8.0.41-0ubuntu0.24.04.1
Collation
utf8mb4_unicode_ci
Conn Collation
utf8mb4_0900_ai_ci
$_GET
array:3 [ "layout" => "default_items" "start" => "120" "view" => "mdb" ]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:44 [ "SCRIPT_URL" => "/index.php/principal/cnotas" "SCRIPT_URI" => "https://santaclara5.co...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1744586581 "last" => 1744586581...
registry
array:3 [ "data" => array:1 [ "m_db_cnotas" => array:1 [ "mdb" => array:2 [ "lis...
user
array:21 [ "id" => 0 "name" => null "username" => null "email" => null "password" => "***r...
  • afterLoad (85.2KB) (3.01ms)
  • afterInitialise (1.13MB) (46.03ms)
  • afterRoute (89.35KB) (4.59ms)
  • beforeRenderComponent com_readmdb (52.32KB) (5.59ms)
  • Before Access::preloadComponents (all components) (222.26KB) (12.36ms)
  • After Access::preloadComponents (all components) (111.42KB) (2.56ms)
  • Before Access::getAssetRules (id:105 name:com_readmdb) (56B) (59μs)
  • After Access::getAssetRules (id:105 name:com_readmdb) (7.35KB) (193μs)
  • afterRenderComponent com_readmdb (349.66KB) (12.88ms)
  • afterDispatch (2.59KB) (250μs)
  • beforeRenderRawModule mod_menu (Main Menu) (26.04KB) (4.78ms)
  • afterRenderRawModule mod_menu (Main Menu) (24.82KB) (1.16ms)
  • beforeRenderRawModule mod_menu (Principal) (720B) (101μs)
  • afterRenderRawModule mod_menu (Principal) (912B) (279μs)
  • beforeRenderRawModule mod_menu (Molina) (688B) (61μs)
  • afterRenderRawModule mod_menu (Molina) (896B) (239μs)
  • beforeRenderRawModule mod_menu (Enlaces (links)) (720B) (56μs)
  • afterRenderRawModule mod_menu (Enlaces (links)) (1.52KB) (242μs)
  • beforeRenderRawModule mod_menu (Libros y apuntes (books)) (752B) (59μs)
  • afterRenderRawModule mod_menu (Libros y apuntes (books)) (928B) (222μs)
  • beforeRenderRawModule mod_articles_archive (Archived Articles) (2.33KB) (60μs)
  • afterRenderRawModule mod_articles_archive (Archived Articles) (2.95KB) (2.62ms)
  • beforeRenderRawModule mod_menu (Main Menu Blog) (4.13KB) (204μs)
  • afterRenderRawModule mod_menu (Main Menu Blog) (265.52KB) (7.83ms)
  • beforeRenderRawModule mod_tags_popular (Popular Tags) (1.05KB) (185μs)
  • afterRenderRawModule mod_tags_popular (Popular Tags) (31.57KB) (3.58ms)
  • beforeRenderRawModule mod_articles_category (Older Posts) (7.19KB) (121μs)
  • afterRenderRawModule mod_articles_category (Older Posts) (37.09KB) (5.34ms)
  • beforeRenderRawModule mod_tags_similar (Similar Items) (6.91KB) (76μs)
  • afterRenderRawModule mod_tags_similar (Similar Items) (5.95KB) (1.12ms)
  • beforeRenderRawModule mod_menu (Bottom Menu) (1.89KB) (93μs)
  • afterRenderRawModule mod_menu (Bottom Menu) (3.33KB) (368μs)
  • beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (6.98KB) (666μs)
  • afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (10.84KB) (1.54ms)
  • beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (22μs)
  • afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.91KB) (386μs)
  • beforeRenderModule mod_menu (Main Menu Blog) (2.3KB) (164μs)
  • afterRenderModule mod_menu (Main Menu Blog) (10.44KB) (135μs)
  • afterRender (157.76KB) (6.37ms)
  • 1 x afterInitialise (1.13MB) (36.32%)
    46.03ms
    1 x afterRenderComponent com_readmdb (349.66KB) (10.16%)
    12.88ms
    1 x Before Access::preloadComponents (all components) (222.26KB) (9.75%)
    12.36ms
    1 x afterRenderRawModule mod_menu (Main Menu Blog) (265.52KB) (6.18%)
    7.83ms
    1 x afterRender (157.76KB) (5.03%)
    6.37ms
    1 x beforeRenderComponent com_readmdb (52.32KB) (4.42%)
    5.59ms
    1 x afterRenderRawModule mod_articles_category (Older Posts) (37.09KB) (4.21%)
    5.34ms
    1 x beforeRenderRawModule mod_menu (Main Menu) (26.04KB) (3.77%)
    4.78ms
    1 x afterRoute (89.35KB) (3.62%)
    4.59ms
    1 x afterRenderRawModule mod_tags_popular (Popular Tags) (31.57KB) (2.83%)
    3.58ms
    1 x afterLoad (85.2KB) (2.37%)
    3.01ms
    1 x afterRenderRawModule mod_articles_archive (Archived Articles) (2.95KB) (2.07%)
    2.62ms
    1 x After Access::preloadComponents (all components) (111.42KB) (2.02%)
    2.56ms
    1 x afterRenderRawModule mod_breadcrumbs (Breadcrumbs) (10.84KB) (1.21%)
    1.54ms
    1 x afterRenderRawModule mod_menu (Main Menu) (24.82KB) (0.92%)
    1.16ms
    1 x afterRenderRawModule mod_tags_similar (Similar Items) (5.95KB) (0.88%)
    1.12ms
    1 x beforeRenderRawModule mod_breadcrumbs (Breadcrumbs) (6.98KB) (0.53%)
    666μs
    1 x afterRenderModule mod_breadcrumbs (Breadcrumbs) (3.91KB) (0.3%)
    386μs
    1 x afterRenderRawModule mod_menu (Bottom Menu) (3.33KB) (0.29%)
    368μs
    1 x afterRenderRawModule mod_menu (Principal) (912B) (0.22%)
    279μs
    1 x afterDispatch (2.59KB) (0.2%)
    250μs
    1 x afterRenderRawModule mod_menu (Enlaces (links)) (1.52KB) (0.19%)
    242μs
    1 x afterRenderRawModule mod_menu (Molina) (896B) (0.19%)
    239μs
    1 x afterRenderRawModule mod_menu (Libros y apuntes (books)) (928B) (0.18%)
    222μs
    1 x beforeRenderRawModule mod_menu (Main Menu Blog) (4.13KB) (0.16%)
    204μs
    1 x After Access::getAssetRules (id:105 name:com_readmdb) (7.35KB) (0.15%)
    193μs
    1 x beforeRenderRawModule mod_tags_popular (Popular Tags) (1.05KB) (0.15%)
    185μs
    1 x beforeRenderModule mod_menu (Main Menu Blog) (2.3KB) (0.13%)
    164μs
    1 x afterRenderModule mod_menu (Main Menu Blog) (10.44KB) (0.11%)
    135μs
    1 x beforeRenderRawModule mod_articles_category (Older Posts) (7.19KB) (0.1%)
    121μs
    1 x beforeRenderRawModule mod_menu (Principal) (720B) (0.08%)
    101μs
    1 x beforeRenderRawModule mod_menu (Bottom Menu) (1.89KB) (0.07%)
    93μs
    1 x beforeRenderRawModule mod_tags_similar (Similar Items) (6.91KB) (0.06%)
    76μs
    1 x beforeRenderRawModule mod_menu (Molina) (688B) (0.05%)
    61μs
    1 x beforeRenderRawModule mod_articles_archive (Archived Articles) (2.33KB) (0.05%)
    60μs
    1 x Before Access::getAssetRules (id:105 name:com_readmdb) (56B) (0.05%)
    59μs
    1 x beforeRenderRawModule mod_menu (Libros y apuntes (books)) (752B) (0.05%)
    59μs
    1 x beforeRenderRawModule mod_menu (Enlaces (links)) (720B) (0.04%)
    56μs
    1 x beforeRenderModule mod_breadcrumbs (Breadcrumbs) (704B) (0.02%)
    22μs
19 statements were executed41.79ms57.28KB
  • SELECT @@SESSION.sql_mode;317μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:308Copy
  • SELECT `data` FROM `tflp4_session` WHERE `session_id` = ?393μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `session_id` FROM `tflp4_session` WHERE `session_id` = :session_id LIMIT 1348μs1.3KBParams/libraries/src/Session/MetadataManager.php:187Copy
  • INSERT INTO `tflp4_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (:session_id, :guest, :time, :user_id, :username, :client_id)13.47ms944BParams/libraries/src/Session/MetadataManager.php:260Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `tflp4_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 1907μs1.61KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `tflp4_viewlevels`388μs656B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `tflp4_usergroups` AS `a` LEFT JOIN `tflp4_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest672μs1.33KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `tflp4_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`2.17ms3.98KBParams/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 `tflp4_menu` AS `m` LEFT JOIN `tflp4_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.78ms20.8KBParams/libraries/src/Menu/SiteMenu.php:166Copy
  • SELECT * FROM `tflp4_languages` WHERE `published` = 1 ORDER BY `ordering` ASC555μs1.61KB/libraries/src/Language/LanguageHelper.php:177Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `tflp4_template_styles` AS `s` LEFT JOIN `tflp4_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` = 1664μs832B/administrator/components/com_templates/src/Model/StyleModel.php:775Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `tflp4_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)1.48ms7.44KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `tflp4_modules` AS `m` LEFT JOIN `tflp4_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `tflp4_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.93ms2KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT MONTH(`created`) AS created_month,MIN(`created`) AS created,YEAR(`created`) AS created_year FROM `tflp4_content` AS `c` WHERE `c`.`state` = 2 GROUP BY YEAR(`c`.`created`), MONTH(`c`.`created`) ORDER BY YEAR(`c`.`created`) DESC, MONTH(`c`.`created`) DESC LIMIT 10619μs640B/modules/mod_articles_archive/src/Helper/ArticlesArchiveHelper.php:69Copy
  • SELECT MAX(`tag_id`) AS `tag_id`,COUNT(*) AS `count`,MAX(`t`.`title`) AS `title`,MAX(`t`.`access`) AS `access`,MAX(`t`.`alias`) AS `alias`,MAX(`t`.`params`) AS `params`,MAX(`t`.`language`) AS `language` FROM `tflp4_contentitem_tag_map` AS `m` INNER JOIN `tflp4_ucm_content` AS `ucm` ON `m`.`content_item_id` = `ucm`.`core_content_item_id` AND `m`.`type_id` = `ucm`.`core_type_id` INNER JOIN `tflp4_categories` AS `cat` ON `ucm`.`core_catid` = `cat`.`id` INNER JOIN `tflp4_tags` AS `t` ON `tag_id` = `t`.`id` INNER JOIN `tflp4_ucm_content` AS `c` ON `m`.`core_content_id` = `c`.`core_content_id` WHERE `t`.`access` IN (:preparedArray1,:preparedArray2) AND `t`.`published` = 1 AND `cat`.`published` > 0 AND `m`.`type_alias` = `c`.`core_type_alias` AND `c`.`core_state` = 1 AND (`c`.`core_access` IN (:preparedArray3,:preparedArray4) OR `c`.`core_access` = 0) AND (`c`.`core_publish_up` IS NULL OR `c`.`core_publish_up` = :nullDate2 OR `c`.`core_publish_up` <= :nowDate2) AND (`c`.`core_publish_down` IS NULL OR `c`.`core_publish_down` = :nullDate3 OR `c`.`core_publish_down` >= :nowDate3) GROUP BY `tag_id`,`t`.`title`,`t`.`access`,`t`.`alias` ORDER BY `count` DESC LIMIT 81.82ms1.81KBParams/modules/mod_tags_popular/src/Helper/TagsPopularHelper.php:188Copy
  • 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 `tflp4_content` AS `a` LEFT JOIN `tflp4_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `tflp4_users` AS `ua` ON `ua`.`id` = `a`.`created_by` LEFT JOIN `tflp4_users` AS `uam` ON `uam`.`id` = `a`.`modified_by` LEFT JOIN `tflp4_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `tflp4_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND `a`.`catid` = :categoryId 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 62.08ms6.28KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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 `tflp4_scheduler_tasks` AS `a` WHERE `a`.`state` = 1509μs2.62KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SELECT `session_id` FROM `tflp4_session` WHERE `session_id` = ?416μs1KBParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • UPDATE `tflp4_session` SET `data` = ? , `time` = ? WHERE `session_id` = ?11.26ms592BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy