Tutorials

Tutorials
Zugriffe: 6115

Automatische Sicherung der SQL-Datenbank

1. Einleitung :

Im folgenden Text wird das Anlegen einer Windows Aufgabe beschrieben, die regelmäßig und automatisch eine Datensicherung Ihrer SQL-Datenbank erstellt.

2. Batch-Datei anlegen :

Öffnen Sie einen Standard-Texteditor (z.B. Editor von Microsoft) und kopieren folgenden Text hinein.

@echo off
echo Sicherung Datenbank CTO Warenwirtschaft
FOR /F "tokens=1,2,3 delims=/: " %%a in ('Time/T') do set CTIME=%%a%%b%%c set ZEIT=%CTIME% set DATUM=%date%
c:\programme\mysql\bin\mysqldump -PPort -uNutzer -pPasswort DatenbankName >
d:\Datensicherung\CTOWarenwirtschaft_%DATUM%_%ZEIT%.sql

 

2.1 Batch-Datei anpassen :

WICHTIG! Ersetzen Sie folgende Abschnitte durch Ihre eigenen Angaben!

1. c:\programme\mysql\bin
Ersetzen Sie diesen Verzeichnispfad durch Ihren eigenen. In diesem Verzeichnis muss die Datei MySQLDump.exe enthalten sein.

2. -PPort
Tragen Sie hier den Port der SQL-Datenbank ein. Ist der Port z.B. 3306, tragen Sie bitte -P3306 ein.

3. -uNutzer
Tragen Sie hier Ihren Benutzernamen der SQL-Datenbank ein. Ist Ihr Benutzername z.B. root, tragen Sie bitte -uroot ein.

4. -pPasswort
Tragen Sie hier Ihr Passwort für die SQL-Datenbank ein. Ist Ihr Passwort z.B. 1234ay, tragen Sie bitte -p1234ay ein.

5. DatenbankName
Tragen Sie hier den Namen Ihrer SQL-Datenbank ein. Ist Ihr Datenbankname z.B. wawisql, tragen Sie bitte wawisql ein.

6. d:\Datensicherung
Tragen Sie hier einen Verzeichnispfad ein, in dem die SQL-Sicherung gespeichert werden soll. Wir empfehlen als Zielverzeichnis eines zu wählen, das sich nicht auf dem selbem PC wie der SQL-Server befindet.

 

2.2 Batch-Datei speichern :

Nach der Anpassung der Batch-Datei (siehe Kapitel 2.1) speichern Sie diese in einem Verzeichnis Ihrer Wahl mit der Endung .bat oder .cmd.
Beispiel: C:\Programme\MySql\bin\CTOWawiSicherung.bat

 

3. Windows Aufgabenplanung einrichten :

Mit der Windows Aufgabenplanung können Sie eine neue Aufgabe anlegen, die eine Sicherung Ihrer SQL-Datenbank mithilfe der Batch-Datei (siehe Kapitel 2) automatisch und regelmäßig ausführt.
Öffnen Sie hierzu die Windows Aufgabenplanung über das Startmenü -> Zubehör -> Systemprogramme -> Aufgabenplanung (vgl. Abbildung 1).

 

 

3.1 Einfache Aufgabe erstellen :

Über den Menüpunkt Aktion wählen Sie die Option Einfache Aufgabe erstellen... (vgl. Abbildung 1). Bitte legen Sie einen Namen und eine Beschreibung für diese Aufgabe an (siehe Abbildung 2) und klicken anschließend auf Weiter.

 

 

3.2 Zeitpunkt festlegen

Wählen Sie nun einen Zeitpunkt für die Durchführung der regelmäßigen Sicherung aus. Sie können z.B. täglich oder wöchentlich die automatische Sicherung ausführen. Wählen Sie im besten Fall einen Zeitpunkt aus, zu dem der PC gestartet ist, aber nur wenige oder keine Zugriffe zur Datenbank erfolgen. In dem Beispiel wurde eine wöchentliche Sicherung gewählt, die immer freitags um 00:30 Uhr ausgeführt wird (vgl. Abbildung 3). Bestätigen Sie Ihre Eingaben mit Weiter.

 

 

3.3 Aktion wählen

Wählen Sie im nächsten Fenster als Aktion Programm starten und bestätigen die Eingabe mit Weiter. Nun geben Sie den Pfad zu Ihrer erstellten Batch-Datei (siehe Kapitel 2) ein (vgl. Abbildung 4) und bestätigen die Eingabe mit Weiter. Im Fenster Zusammenfassung können Sie Ihre Eingaben überprüfen und die Erstellung der Aufgabe über Fertig stellen abschließen.

 

3.4 Aufgabe testen

Bitte führen Sie die in Kapitel 3.1 angelegte Aufgabe einmal manuell aus, um diese zu testen. Wechseln Sie dafür in der Windows Aufgabenplanung in die Aufgabenplanungsbibliothek. Hier markieren Sie die Aufgabe SQL-Datensicherung CTO Warenwirtschaft und rufen per Rechtsklick das Kontextmenü auf. Um die Aufgabe manuell zu testen, wählen Sie die Option Ausführen (vgl. Abbildung 5). Sie können das Ergebnis des Tests in der Spalte Ergebnis der letzten Ausführung überprüfen. In dem von Ihnen angegebenen Zeilverzeichnis sollte eine neue SQL-Datei befinden.

 

 

4. SQL-Sicherungen regelmäßig löschen

Die automatisch erzeugten Dateien zur Sicherung Ihrer SQL-Datenbank werden nicht automatisch gelöscht oder überschrieben. Bitte löschen Sie selbst regelmäßig veraltete, nicht mehr benötigte Dateien, um Speicherplatz zu sparen und Ordnung in Ihrem Sicherungsverzeichnis zu schaffen.

 

 

pdfAnleitung automatisches SQL-Dump Beliebt
Download

Wir nutzen Cookies auf unserer Website. Diese sind essenziell für den Betrieb der Seite. Diese Webseite verwendet keine Cookies die das Nutzerverhalten erfassen (Tracking Cookies).

Sie können selbst entscheiden, ob Sie die Cookies zulassen möchten. Bitte beachten Sie, dass bei einer Ablehnung womöglich nicht mehr alle Funktionalitäten der Seite zur Verfügung stehen.

Akzeptieren Ablehnen
Weitere Informationen
J! InfoRequestSessionProfileQueries97
Settings37.963MBMemory Usage1.44sRequest Duration
Theme
Open Button Position
Hide Empty Tabs
Autoshow
Reset to defaults
Joomla! Version5.3.0
PHP Version8.2.28
Identityguest
Response200
Templateshaper_helix3
Database
Server
mysql
Version
10.11.7-MariaDB-log
Collation
utf8mb3_general_ci
Conn Collation
utf8mb4_general_ci
$_GET
[]
$_POST
[]
$_SESSION
array:1 [ "joomla" => "***redacted***" ]
$_COOKIE
[]
$_SERVER
array:45 [ "REDIRECT_STATUS" => "200" "UNIQUE_ID" => "aD7GnkmGoldpDsvR7CXigQAADd0" "SCRIPT_URL...
session
array:3 [ "counter" => 1 "timer" => array:3 [ "start" => 1748944542 "last" => 1748944542...
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://ctosoftware.de/cto/support/tutorials/101-automatische-sicherung-...
gtag
false
  • afterLoad (3.53MB) (82.2ms)
  • afterInitialise (15.62MB) (458ms)
  • afterRoute (2.21MB) (190ms)
  • beforeRenderComponent com_content (64.27KB) (9.11ms)
  • Before Access::preloadComponents (all components) (423.93KB) (12.36ms)
  • After Access::preloadComponents (all components) (129.32KB) (3.07ms)
  • Before Access::preloadPermissions (com_content) (1.76KB) (20μs)
  • After Access::preloadPermissions (com_content) (190.95KB) (2.85ms)
  • Before Access::getAssetRules (id:332 name:com_content.article.101) (10.65KB) (27μs)
  • After Access::getAssetRules (id:332 name:com_content.article.101) (89.46KB) (705μs)
  • Before Access::getAssetRules (id:1 name:root.1) (3.99MB) (188ms)
  • After Access::getAssetRules (id:1 name:root.1) (6.02KB) (42μs)
  • Before Access::getAssetRules (id:694 name:com_jdownloads) (1.57KB) (76μs)
  • After Access::getAssetRules (id:694 name:com_jdownloads) (6.34KB) (31μs)
  • Before Access::preloadPermissions (com_jdownloads) (7.7KB) (102μs)
  • After Access::preloadPermissions (com_jdownloads) (49.47KB) (3.15ms)
  • Before Access::getAssetRules (id:719 name:com_jdownloads.download.27) (680B) (118μs)
  • After Access::getAssetRules (id:719 name:com_jdownloads.download.27) (6.96KB) (74μs)
  • afterRenderComponent com_content (826.73KB) (111ms)
  • afterDispatch (153.72KB) (4.22ms)
  • beforeRenderRawModule mod_custom (Produktbild) (1.63MB) (19.62ms)
  • afterRenderRawModule mod_custom (Produktbild) (36.52KB) (3.56ms)
  • beforeRenderModule mod_custom (Produktbild) (720B) (8μs)
  • afterRenderModule mod_custom (Produktbild) (20.35KB) (1.56ms)
  • beforeRenderRawModule mod_custom (Supportbild) (12.04KB) (2.32ms)
  • afterRenderRawModule mod_custom (Supportbild) (1.11KB) (291μs)
  • beforeRenderModule mod_custom (Supportbild) (720B) (6μs)
  • afterRenderModule mod_custom (Supportbild) (2.69KB) (337μs)
  • beforeRenderRawModule mod_login (Login) (13.05KB) (2.67ms)
  • afterRenderRawModule mod_login (Login) (359.15KB) (14.12ms)
  • beforeRenderModule mod_login (Login) (704B) (10μs)
  • afterRenderModule mod_login (Login) (4.81KB) (413μs)
  • beforeRenderRawModule mod_menu (SideMenu) (97.55KB) (15.83ms)
  • afterRenderRawModule mod_menu (SideMenu) (143.88KB) (11.45ms)
  • beforeRenderModule mod_menu (SideMenu) (704B) (8μs)
  • afterRenderModule mod_menu (SideMenu) (5.63KB) (378μs)
  • beforeRenderRawModule mod_custom (Fernwartung) (2.18KB) (78μs)
  • afterRenderRawModule mod_custom (Fernwartung) (976B) (346μs)
  • beforeRenderModule mod_custom (Fernwartung) (720B) (8μs)
  • afterRenderModule mod_custom (Fernwartung) (2.75KB) (487μs)
  • beforeRenderRawModule mod_custom (Familienfreundliche Unternehmen) (408B) (78μs)
  • afterRenderRawModule mod_custom (Familienfreundliche Unternehmen) (992B) (282μs)
  • beforeRenderModule mod_custom (Familienfreundliche Unternehmen) (736B) (7μs)
  • afterRenderModule mod_custom (Familienfreundliche Unternehmen) (3.02KB) (362μs)
  • beforeRenderRawModule mod_custom (Zertifizierung) (232B) (67μs)
  • afterRenderRawModule mod_custom (Zertifizierung) (976B) (303μs)
  • beforeRenderModule mod_custom (Zertifizierung) (720B) (6μs)
  • afterRenderModule mod_custom (Zertifizierung) (2.59KB) (306μs)
  • beforeRenderRawModule mod_sppagebuilder (KontaktTop) (272B) (132μs)
  • beforeRenderRawModule mod_search (Suchbox) (6.78MB) (125ms)
  • afterRenderRawModule mod_search (Suchbox) (19.19KB) (2.57ms)
  • beforeRenderModule mod_search (Suchbox) (704B) (10μs)
  • afterRenderModule mod_search (Suchbox) (3.25KB) (407μs)
  • afterRenderRawModule mod_sppagebuilder (KontaktTop) (57.04KB) (1.85ms)
  • beforeRenderModule mod_sppagebuilder (KontaktTop) (720B) (8μs)
  • afterRenderModule mod_sppagebuilder (KontaktTop) (14.38KB) (529μs)
  • afterRender (1.02MB) (160ms)
  • 1 x afterInitialise (15.62MB) (31.91%)
    458ms
    1 x afterRoute (2.21MB) (13.22%)
    190ms
    1 x Before Access::getAssetRules (id:1 name:root.1) (3.99MB) (13.12%)
    188ms
    1 x afterRender (1.02MB) (11.17%)
    160ms
    1 x beforeRenderRawModule mod_search (Suchbox) (6.78MB) (8.7%)
    125ms
    1 x afterRenderComponent com_content (826.73KB) (7.71%)
    111ms
    1 x afterLoad (3.53MB) (5.73%)
    82.20ms
    1 x beforeRenderRawModule mod_custom (Produktbild) (1.63MB) (1.37%)
    19.62ms
    1 x beforeRenderRawModule mod_menu (SideMenu) (97.55KB) (1.1%)
    15.83ms
    1 x afterRenderRawModule mod_login (Login) (359.15KB) (0.98%)
    14.12ms
    1 x Before Access::preloadComponents (all components) (423.93KB) (0.86%)
    12.36ms
    1 x afterRenderRawModule mod_menu (SideMenu) (143.88KB) (0.8%)
    11.45ms
    1 x beforeRenderComponent com_content (64.27KB) (0.63%)
    9.11ms
    1 x afterDispatch (153.72KB) (0.29%)
    4.22ms
    1 x afterRenderRawModule mod_custom (Produktbild) (36.52KB) (0.25%)
    3.56ms
    1 x After Access::preloadPermissions (com_jdownloads) (49.47KB) (0.22%)
    3.15ms
    1 x After Access::preloadComponents (all components) (129.32KB) (0.21%)
    3.07ms
    1 x After Access::preloadPermissions (com_content) (190.95KB) (0.2%)
    2.85ms
    1 x beforeRenderRawModule mod_login (Login) (13.05KB) (0.19%)
    2.67ms
    1 x afterRenderRawModule mod_search (Suchbox) (19.19KB) (0.18%)
    2.57ms
    1 x beforeRenderRawModule mod_custom (Supportbild) (12.04KB) (0.16%)
    2.32ms
    1 x afterRenderRawModule mod_sppagebuilder (KontaktTop) (57.04KB) (0.13%)
    1.85ms
    1 x afterRenderModule mod_custom (Produktbild) (20.35KB) (0.11%)
    1.56ms
    1 x After Access::getAssetRules (id:332 name:com_content.article.101) (89.46KB) (0.05%)
    705μs
    1 x afterRenderModule mod_sppagebuilder (KontaktTop) (14.38KB) (0.04%)
    529μs
    1 x afterRenderModule mod_custom (Fernwartung) (2.75KB) (0.03%)
    487μs
    1 x afterRenderModule mod_login (Login) (4.81KB) (0.03%)
    413μs
    1 x afterRenderModule mod_search (Suchbox) (3.25KB) (0.03%)
    407μs
    1 x afterRenderModule mod_menu (SideMenu) (5.63KB) (0.03%)
    378μs
    1 x afterRenderModule mod_custom (Familienfreundliche Unternehmen) (3.02KB) (0.03%)
    362μs
    1 x afterRenderRawModule mod_custom (Fernwartung) (976B) (0.02%)
    346μs
    1 x afterRenderModule mod_custom (Supportbild) (2.69KB) (0.02%)
    337μs
    1 x afterRenderModule mod_custom (Zertifizierung) (2.59KB) (0.02%)
    306μs
    1 x afterRenderRawModule mod_custom (Zertifizierung) (976B) (0.02%)
    303μs
    1 x afterRenderRawModule mod_custom (Supportbild) (1.11KB) (0.02%)
    291μs
    1 x afterRenderRawModule mod_custom (Familienfreundliche Unternehmen) (992B) (0.02%)
    282μs
    1 x beforeRenderRawModule mod_sppagebuilder (KontaktTop) (272B) (0.01%)
    132μs
    1 x Before Access::getAssetRules (id:719 name:com_jdownloads.download.27) (680B) (0.01%)
    118μs
    1 x Before Access::preloadPermissions (com_jdownloads) (7.7KB) (0.01%)
    102μs
    1 x beforeRenderRawModule mod_custom (Fernwartung) (2.18KB) (0.01%)
    78μs
    1 x beforeRenderRawModule mod_custom (Familienfreundliche Unternehmen) (408B) (0.01%)
    78μs
    1 x Before Access::getAssetRules (id:694 name:com_jdownloads) (1.57KB) (0.01%)
    76μs
    1 x After Access::getAssetRules (id:719 name:com_jdownloads.download.27) (6.96KB) (0.01%)
    74μs
    1 x beforeRenderRawModule mod_custom (Zertifizierung) (232B) (0%)
    67μs
    1 x After Access::getAssetRules (id:1 name:root.1) (6.02KB) (0%)
    42μs
    1 x After Access::getAssetRules (id:694 name:com_jdownloads) (6.34KB) (0%)
    31μs
    1 x Before Access::getAssetRules (id:332 name:com_content.article.101) (10.65KB) (0%)
    27μs
    1 x Before Access::preloadPermissions (com_content) (1.76KB) (0%)
    20μs
    1 x beforeRenderModule mod_login (Login) (704B) (0%)
    10μs
    1 x beforeRenderModule mod_search (Suchbox) (704B) (0%)
    10μs
    1 x beforeRenderModule mod_sppagebuilder (KontaktTop) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_custom (Produktbild) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_menu (SideMenu) (704B) (0%)
    8μs
    1 x beforeRenderModule mod_custom (Fernwartung) (720B) (0%)
    8μs
    1 x beforeRenderModule mod_custom (Familienfreundliche Unternehmen) (736B) (0%)
    7μs
    1 x beforeRenderModule mod_custom (Supportbild) (720B) (0%)
    6μs
    1 x beforeRenderModule mod_custom (Zertifizierung) (720B) (0%)
    6μs
97 statements were executed, 42 of which were duplicates, 55 unique186ms762.38KB
UniquesDuplicates 1Duplicates 2Duplicates 3Duplicates 4Duplicates 5Duplicates 6Duplicates 7Duplicates 8Duplicates 9Duplicates 10Duplicates 11Duplicates 12Duplicates 13Duplicates 14Duplicates 15
  • SELECT @@SESSION.sql_mode;951μs968B/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:259Copy
  • SELECT `data` FROM `cto_session` WHERE `session_id` = ?899μs1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:250Copy
  • SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` FROM `cto_extensions` WHERE `type` = 'component' AND `state` = 0 AND `enabled` = 12.16ms17.42KB/libraries/src/Component/ComponentHelper.php:399Copy
  • SELECT `id`,`rules` FROM `cto_viewlevels`1.16ms656B/libraries/src/Access/Access.php:955Copy
  • SELECT `b`.`id` FROM `cto_usergroups` AS `a` LEFT JOIN `cto_usergroups` AS `b` ON `b`.`lft` <= `a`.`lft` AND `b`.`rgt` >= `a`.`rgt` WHERE `a`.`id` = :guest1.45ms1.64KBParams/libraries/src/Access/Access.php:868Copy
  • SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` FROM `cto_extensions` WHERE `enabled` = 1 AND `type` = 'plugin' AND `state` IN (0,1) AND `access` IN (:preparedArray1,:preparedArray2) ORDER BY `ordering`2.6ms4.48KBParams/libraries/src/Plugin/PluginHelper.php:294Copy
  • SELECT `template` FROM `cto_template_styles` WHERE `client_id` = 0 AND `home` = 1952μs536B/components/com_sppagebuilder/parser/addon-parser.php:1403Copy
  • SELECT `template` FROM `cto_template_styles` WHERE `client_id` = 0 AND `home` = 11.18ms536B/plugins/system/helix3/helix3.php:247Copy
  • select email from cto_users where id=498 LIMIT 1990μs1.15KB/plugins/system/bfstop/helpers/db.php:311Copy
  • SELECT id, ipaddress from cto_bfstop_allowlist WHERE (ipaddress='3.139.66.158' AND LOCATE('/', ipaddress) = 0)1.04ms576B/plugins/system/bfstop/helpers/db.php:192Copy
  • SELECT id, ipaddress from cto_bfstop_allowlist WHERE ((LOCATE('/', ipaddress) != 0 AND LOCATE('.', ipaddress) != 0 AND (INET_ATON('3.139.66.158') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1))))1.04ms576B/plugins/system/bfstop/helpers/db.php:192Copy
  • SELECT id, ipaddress, crdate, duration FROM cto_bfstop_bannedip b WHERE (ipaddress='3.139.66.158' AND LOCATE('/', ipaddress) = 0) AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2025-06-03 09:55:42') AND NOT EXISTS (SELECT 1 FROM cto_bfstop_unblock u WHERE b.id = u.block_id)1.14ms688B/plugins/system/bfstop/helpers/db.php:192Copy
  • SELECT id, ipaddress, crdate, duration FROM cto_bfstop_bannedip b WHERE ((LOCATE('/', ipaddress) != 0 AND LOCATE('.', ipaddress) != 0 AND (INET_ATON('3.139.66.158') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)))) AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2025-06-03 09:55:42') AND NOT EXISTS (SELECT 1 FROM cto_bfstop_unblock u WHERE b.id = u.block_id)1.12ms688B/plugins/system/bfstop/helpers/db.php:192Copy
  • 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 `cto_menu` AS `m` LEFT JOIN `cto_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.73ms101.3KBParams/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 `cto_categories` AS `s` INNER JOIN `cto_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`1.6ms11.86KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `alias` FROM `cto_content` WHERE `id` = :id959μs1.31KBParams/components/com_content/src/Service/Router.php:289Copy
  • SHOW FULL TABLES WHERE table_type="BASE TABLE"2.88ms4.31KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT `id`,`home`,`template`,`s`.`params`,`inheritable`,`parent` FROM `cto_template_styles` AS `s` LEFT JOIN `cto_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` = 11.23ms40.83KB/administrator/components/com_templates/src/Model/StyleModel.php:718Copy
  • SELECT * FROM `cto_template_styles` WHERE `client_id` = 0 AND `id` = '9'1.07ms40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `cto_languages` WHERE `published` = 1 ORDER BY `ordering` ASC1.04ms1.61KB/libraries/src/Language/LanguageHelper.php:179Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `cto_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)1.83ms7.81KBParams/libraries/src/Access/Access.php:357Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `cto_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 01.48ms25.48KBParams/libraries/src/Access/Access.php:301Copy
  • SHOW FULL COLUMNS FROM `cto_content`2.86ms1.77KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:539Copy
  • UPDATE `cto_content` SET `hits` = (`hits` + 1) WHERE `id` = '101'6.94ms48B/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 `cto_content` AS `a` INNER JOIN `cto_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `cto_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `cto_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `cto_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `cto_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)2.03ms22.13KBParams/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 `cto_categories` AS `s` INNER JOIN `cto_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`2.56ms3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `cto_contentitem_tag_map` AS `m` INNER JOIN `cto_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)3.62ms3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT enabled FROM `cto_extensions` WHERE `element` = 'com_sppagebuilder' AND `type` = 'component'2.28ms536B/plugins/content/sppagebuilder/sppagebuilder.php:314Copy
  • SELECT id, link from cto_menu WHERE link LIKE 'index.php?option=com_jdownloads&view=category%' AND published = 11.23ms672B/plugins/content/jdownloads/jdownloads.php:76Copy
  • SELECT id, link, published, access, language FROM cto_menu WHERE (link LIKE 'index.php?option=com_jdownloads%') AND published = 1 AND client_id = 0 AND language = 'de-de' AND access IN (1,5)1.01ms752B/components/com_jdownloads/src/Helper/JDHelper.php:247Copy
  • SELECT id, link, published, access, language FROM cto_menu WHERE (link LIKE 'index.php?option=com_jdownloads%') AND published = 1 AND client_id = 0 AND access IN (1,5)1.16ms848B/components/com_jdownloads/src/Helper/JDHelper.php:252Copy
  • SELECT id FROM cto_menu WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories' ) AND published = 1 AND client_id = 0 AND language = 'de-de' AND access IN (1,5)1ms520B/components/com_jdownloads/src/Helper/JDHelper.php:305Copy
  • SELECT id FROM cto_menu WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories' ) AND published = 1 AND client_id = 0 AND access IN (1,5)1.13ms3.02KB/components/com_jdownloads/src/Helper/JDHelper.php:310Copy
  • SELECT id FROM cto_menu WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories' ) AND published = 1 AND client_id = 0 AND language = 'de-de' AND access IN (1,5)930μs520B/components/com_jdownloads/src/Helper/JDHelper.php:359Copy
  • SELECT id FROM cto_menu WHERE (link LIKE 'index.php?option=com_jdownloads&Itemid=' OR link LIKE 'index.php?option=com_jdownloads&view=categories' ) AND published = 1 AND client_id = 0 AND access IN (1,5)1.11ms536B/components/com_jdownloads/src/Helper/JDHelper.php:364Copy
  • SELECT id FROM cto_menu WHERE link = 'index.php?option=com_jdownloads&view=search' AND published = 1 AND client_id = 0 AND access IN (1,5)1.03ms520B/components/com_jdownloads/src/Helper/JDHelper.php:378Copy
  • SELECT id FROM cto_menu WHERE link = 'index.php?option=com_jdownloads&view=form&layout=edit' AND published = 1 AND client_id = 0 AND access IN (1,5)1ms520B/components/com_jdownloads/src/Helper/JDHelper.php:383Copy
  • SELECT id, link from cto_menu WHERE link LIKE 'index.php?option=com_jdownloads&view=category&catid%' AND published = 1 AND access IN (1,5)1.22ms656B/components/com_jdownloads/src/Helper/JDHelper.php:415Copy
  • 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 `cto_categories` AS `s` INNER JOIN `cto_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`1.37ms3.91KBParams/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 cto_fields AS a LEFT JOIN `cto_languages` AS l ON l.lang_code = a.language LEFT JOIN cto_users AS uc ON uc.id=a.checked_out LEFT JOIN cto_viewlevels AS ag ON ag.id = a.access LEFT JOIN cto_users AS ua ON ua.id = a.created_user_id LEFT JOIN cto_fields_groups AS g ON g.id = a.group_id LEFT JOIN `cto_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,:preparedArray4)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) 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 ASC2.14ms4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT * FROM `cto_sppagebuilder` WHERE `extension` = 'com_content' AND `extension_view` = 'article' AND `view_id` = '101' AND `active` = 12.58ms2.98KB/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:255Copy
  • SELECT `id`,`name`,`rules`,`parent_id` FROM `cto_assets` WHERE `name` LIKE :asset OR `name` = :extension OR `parent_id` = 01.68ms2.36KBParams/libraries/src/Access/Access.php:301Copy
  • SELECT a.id, a.asset_id, a.title, a.alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_mail, a.submitted_by, a.changelog, a.password, a.password_md5, a.views, a.update_active, a.featured, a.published, CASE WHEN badcats.id is null THEN a.published ELSE 0 END AS state, a.catid, a.created, a.created_by, a.file_date, a.modified, a.publish_up, a.publish_down, a.modified_by, a.checked_out, a.checked_out_time, a.ordering, a.metakey, a.metadesc, a.robots, a.access, a.user_access, a.downloads, a.language,aa.url_download AS filename_from_other_download,c.title AS category_title, c.alias AS category_alias, c.access AS category_access, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent, c.published AS category_published,u.name AS creator,u2.name AS modifier,u3.name AS user_access_name,contact.id as contactid,l.title AS license_title, l.url AS license_url, l.description AS license_text, l.id as lid,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias FROM cto_jdownloads_files AS a LEFT JOIN cto_jdownloads_files AS aa on aa.id = a.other_file_id INNER JOIN cto_jdownloads_categories AS c on c.id = a.catid LEFT JOIN cto_users AS u on u.id = a.created_by LEFT JOIN cto_users AS u2 on u2.id = a.modified_by LEFT JOIN cto_users AS u3 on u3.id = a.user_access LEFT JOIN ( SELECT contact.user_id, MAX(contact.id) AS id, contact.language FROM cto_contact_details AS contact WHERE contact.published = 1 GROUP BY contact.user_id, contact.language) AS contact ON contact.user_id = a.created_by LEFT JOIN cto_jdownloads_licenses AS l on l.id = a.license LEFT JOIN cto_jdownloads_ratings AS r on r.file_id = a.id LEFT JOIN cto_jdownloads_categories as parent ON parent.id = c.parent_id LEFT OUTER JOIN (SELECT cat.id as id FROM cto_jdownloads_categories AS cat JOIN cto_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt WHERE parent.published <= 0 GROUP BY cat.id) AS badcats ON badcats.id = c.id WHERE ( (c.published > 0 AND a.id = 27) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp)) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown) AND a.access IN (1,5) AND c.access IN (1,5) AND (a.published = 1)3.1ms10.44KBParams/components/com_jdownloads/src/Model/DownloadModel.php:258Copy
  • 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 cto_fields AS a LEFT JOIN `cto_languages` AS l ON l.lang_code = a.language LEFT JOIN cto_users AS uc ON uc.id=a.checked_out LEFT JOIN cto_viewlevels AS ag ON ag.id = a.access LEFT JOIN cto_users AS ua ON ua.id = a.created_user_id LEFT JOIN cto_fields_groups AS g ON g.id = a.group_id LEFT JOIN `cto_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,:preparedArray4)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray5,:preparedArray6)) 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.81ms4.75KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • SELECT `m`.`tag_id`,`t`.* FROM `cto_contentitem_tag_map` AS `m` INNER JOIN `cto_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)1.93ms3.97KBParams/libraries/src/Helper/TagsHelper.php:388Copy
  • SELECT * FROM cto_jdownloads_templates WHERE (template_name = 'einfach') AND (template_typ = 2)2.03ms2.72KB/plugins/content/jdownloads/jdownloads.php:533Copy
  • SELECT * FROM `cto_sppagebuilder` WHERE `extension` = 'com_content' AND `extension_view` = 'article' AND `view_id` = '27' AND `active` = 13.45ms2.98KB/administrator/components/com_sppagebuilder/helpers/sppagebuilder.php:255Copy
  • SELECT group_id, importance, id FROM cto_jdownloads_usergroups_limits ORDER BY importance1.24ms800B/components/com_jdownloads/src/Helper/JDHelper.php:91Copy
  • SELECT * FROM cto_jdownloads_usergroups_limits WHERE group_id IN (1)1.56ms11.91KB/components/com_jdownloads/src/Helper/JDHelper.php:115Copy
  • SELECT * FROM `cto_usergroups` WHERE `id` = :id992μs1.54KBParams/libraries/src/Helper/UserGroupsHelper.php:237Copy
  • SET SESSION SQL_BIG_SELECTS = 1824μs0B/components/com_jdownloads/src/Helper/CategoriesHelper.php:236Copy
  • SELECT c.*, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as slug,( SELECT COUNT(`files`.`id`) FROM `cto_jdownloads_files` AS `files` WHERE `files`.`catid` = `c`.`id` AND `files`.`published` = 1 AND files.access IN (1,5) AND files.user_access = 0 AND (files.publish_up IS NULL OR files.publish_up <= '2025-06-03 09:55:42') AND (files.publish_down IS NULL OR files.publish_down >= '2025-06-03 09:55:42')) AS `numitems`,( SELECT COUNT(*) FROM `cto_jdownloads_categories` AS `cat` WHERE `cat`.`parent_id` = `c`.`id` AND cat.parent_id > 1 AND cat.published = 1 AND cat.access IN (1,5)) AS `subcatitems`,u.name AS creator,u2.name AS modifier,menu.id AS menu_itemid FROM `cto_jdownloads_categories` AS `s` INNER JOIN `cto_jdownloads_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) LEFT JOIN `cto_jdownloads_files` AS files ON files.`catid` = c.id AND files.published = 1 LEFT JOIN cto_users AS u on u.id = files.created_by LEFT JOIN cto_users AS u2 on u2.id = files.modified_by LEFT JOIN (SELECT id, link, access, published from cto_menu GROUP BY link) AS menu on menu.link LIKE CONCAT('index.php?option=com_jdownloads&view=category&catid=', c.id) AND menu.published = 1 AND menu.access IN (1,5) WHERE c.access IN (1,5) AND c.published = 1 AND `s`.`id` = c.id GROUP BY c.id, c.cat_dir, c.cat_dir_parent, c.parent_id, c.lft, c.rgt, c.level, c.title, c.alias, c.access ORDER BY c.lft17.44ms4.83KB/components/com_jdownloads/src/Helper/CategoriesHelper.php:433Copy
  • SELECT alias, id FROM cto_jdownloads_categories WHERE id > 1 ORDER BY `id`993μs832B/components/com_jdownloads/src/Helper/LegacyRouter.php:75Copy
  • SELECT alias, id FROM cto_jdownloads_files ORDER BY `id`1.05ms1.81KB/components/com_jdownloads/src/Helper/LegacyRouter.php:85Copy
  • SET SESSION SQL_BIG_SELECTS = 1855μs0B/components/com_jdownloads/src/Helper/CategoriesHelper.php:236Copy
  • SELECT c.*, CASE WHEN CHAR_LENGTH(`c`.`alias`) != 0 THEN CONCAT_WS(':', `c`.`id`, `c`.`alias`) ELSE `c`.`id` END as slug,( SELECT COUNT(`files`.`id`) FROM `cto_jdownloads_files` AS `files` WHERE `files`.`catid` = `c`.`id` AND `files`.`published` = 1 AND files.access IN (1,5) AND files.user_access = 0 AND (files.publish_up IS NULL OR files.publish_up <= '2025-06-03 09:55:42') AND (files.publish_down IS NULL OR files.publish_down >= '2025-06-03 09:55:42')) AS `numitems`,( SELECT COUNT(*) FROM `cto_jdownloads_categories` AS `cat` WHERE `cat`.`parent_id` = `c`.`id` AND cat.parent_id > 1 AND cat.published = 1 AND cat.access IN (1,5)) AS `subcatitems`,u.name AS creator,u2.name AS modifier,menu.id AS menu_itemid FROM `cto_jdownloads_categories` AS `s` INNER JOIN `cto_jdownloads_categories` AS `c` ON (`s`.`lft` <= `c`.`lft` AND `c`.`lft` < `s`.`rgt`) OR (`c`.`lft` < `s`.`lft` AND `s`.`rgt` < `c`.`rgt`) LEFT JOIN `cto_jdownloads_files` AS files ON files.`catid` = c.id AND files.published = 1 LEFT JOIN cto_users AS u on u.id = files.created_by LEFT JOIN cto_users AS u2 on u2.id = files.modified_by LEFT JOIN (SELECT id, link, access, published from cto_menu GROUP BY link) AS menu on menu.link LIKE CONCAT('index.php?option=com_jdownloads&view=category&catid=', c.id) AND menu.published = 1 AND menu.access IN (1,5) WHERE c.access IN (1,5) AND c.published = 1 AND `s`.`id` = c.id GROUP BY c.id, c.cat_dir, c.cat_dir_parent, c.parent_id, c.lft, c.rgt, c.level, c.title, c.alias, c.access ORDER BY c.lft19.83ms4.83KB/components/com_jdownloads/src/Helper/CategoriesHelper.php:433Copy
  • 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 cto_fields AS a LEFT JOIN `cto_languages` AS l ON l.lang_code = a.language LEFT JOIN cto_users AS uc ON uc.id=a.checked_out LEFT JOIN cto_viewlevels AS ag ON ag.id = a.access LEFT JOIN cto_users AS ua ON ua.id = a.created_user_id LEFT JOIN cto_fields_groups AS g ON g.id = a.group_id WHERE ( (`a`.`context` = :context AND `a`.`access` IN (:preparedArray1,:preparedArray2)) AND (`a`.`group_id` = 0 OR `g`.`access` IN (:preparedArray3,: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.92ms4.06KBParams/libraries/src/MVC/Model/BaseDatabaseModel.php:164Copy
  • 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 `cto_categories` AS `s` INNER JOIN `cto_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`2.91ms3.91KBParams/libraries/src/Categories/Categories.php:375Copy
  • SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params FROM cto_modules AS m WHERE m.published = 1 AND m.id = 111 AND m.id = 111 AND (m.publish_up IS NULL OR m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-06-03 09:55:42') AND (m.publish_down IS NULL OR m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-06-03 09:55:42') AND m.access IN (1,5) AND m.client_id = 0 ORDER BY position, ordering981μs896B/plugins/system/helix3/core/classes/menu.php:605Copy
  • SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params FROM cto_modules AS m WHERE m.published = 1 AND m.id = 113 AND m.id = 113 AND (m.publish_up IS NULL OR m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-06-03 09:55:42') AND (m.publish_down IS NULL OR m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-06-03 09:55:42') AND m.access IN (1,5) AND m.client_id = 0 ORDER BY position, ordering1.06ms896B/plugins/system/helix3/core/classes/menu.php:605Copy
  • SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params FROM cto_modules AS m WHERE m.published = 1 AND m.id = 16 AND m.id = 16 AND (m.publish_up IS NULL OR m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2025-06-03 09:55:42') AND (m.publish_down IS NULL OR m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-06-03 09:55:42') AND m.access IN (1,5) AND m.client_id = 0 ORDER BY position, ordering1.18ms896B/plugins/system/helix3/core/classes/menu.php:605Copy
  • SELECT `alias`,`catid` FROM cto_content WHERE `id` = :key1.04ms1.37KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT `m`.`id`,`m`.`title`,`m`.`module`,`m`.`position`,`m`.`content`,`m`.`showtitle`,`m`.`params`,`mm`.`menuid` FROM `cto_modules` AS `m` LEFT JOIN `cto_modules_menu` AS `mm` ON `mm`.`moduleid` = `m`.`id` LEFT JOIN `cto_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.83ms2.06KBParams/libraries/src/Cache/Controller/CallbackController.php:51Copy
  • SELECT `alias`,`catid` FROM cto_content WHERE `id` = :key938μs1.37KBParams/libraries/src/Component/Router/Rules/PreprocessRules.php:123Copy
  • SELECT * FROM `cto_sppagebuilder` WHERE `extension` = 'mod_sppagebuilder' AND `extension_view` = 'module' AND `view_id` = '181'1.99ms62KB/modules/mod_sppagebuilder/helper.php:49Copy
  • SELECT enabled FROM `cto_extensions` WHERE `name` = 'com_easystore'1.07ms520B/administrator/components/com_sppagebuilder/editor/helpers/ApplicationHelper.php:138Copy
  • SELECT `template` FROM `cto_template_styles` WHERE `client_id` = 0 AND `home` = 1983μs536B/components/com_sppagebuilder/builder/classes/base.php:87Copy
  • SELECT DISTINCT a.id, a.title, a.level, a.published, a.lft, a.parent_id FROM ( SELECT id,title,level,published,parent_id,lft,rgt FROM cto_tags WHERE `published` = '1') AS a LEFT JOIN `cto_tags` AS b ON a.lft > b.lft AND a.rgt < b.rgt WHERE `a`.`level` != '0' ORDER BY a.lft ASC1.51ms2.3KB/components/com_sppagebuilder/builder/classes/base.php:373Copy
  • SELECT a.enabled FROM `cto_extensions` AS `a` WHERE `a`.`name` = 'com_k2'1.01ms520B/components/com_sppagebuilder/builder/classes/base.php:972Copy
  • SELECT a.enabled FROM `cto_extensions` AS `a` WHERE `a`.`name` = 'com_k2'1.02ms520B/components/com_sppagebuilder/builder/classes/base.php:972Copy
  • SELECT DISTINCT a.id, a.title, a.level, a.published, a.lft, a.parent_id FROM ( SELECT id,title,level,published,parent_id,lft,rgt FROM cto_tags WHERE `published` = '1') AS a LEFT JOIN `cto_tags` AS b ON a.lft > b.lft AND a.rgt < b.rgt WHERE `a`.`level` != '0' ORDER BY a.lft ASC2.38ms2.3KB/components/com_sppagebuilder/builder/classes/base.php:373Copy
  • SELECT a.enabled FROM `cto_extensions` AS `a` WHERE `a`.`name` = 'com_k2'1.37ms520B/components/com_sppagebuilder/builder/classes/base.php:972Copy
  • SELECT id,collection_id,value,item_id FROM `cto_sppagebuilder_collection_fields` AS `collection_field` LEFT JOIN `cto_sppagebuilder_collection_item_values` AS `collection_item_value` ON (`collection_item_value`.`field_id` = `collection_field`.`id`) WHERE `collection_field`.`type` = 'title' ORDER BY `collection_item_value`.`item_id` ASC1.26ms688B/administrator/components/com_sppagebuilder/dynamic-content/QueryBuilder.php:703Copy
  • SELECT id,title,alias FROM `cto_sppagebuilder_collections` AS `collection` WHERE `collection`.`published` = 1 ORDER BY `collection`.`ordering` ASC1.03ms640B/administrator/components/com_sppagebuilder/dynamic-content/QueryBuilder.php:703Copy
  • SELECT id,collection_id,value,item_id FROM `cto_sppagebuilder_collection_fields` AS `collection_field` LEFT JOIN `cto_sppagebuilder_collection_item_values` AS `collection_item_value` ON (`collection_item_value`.`field_id` = `collection_field`.`id`) WHERE `collection_field`.`type` = 'title' ORDER BY `collection_item_value`.`item_id` ASC1.23ms688B/administrator/components/com_sppagebuilder/dynamic-content/QueryBuilder.php:703Copy
  • SELECT id,title,alias FROM `cto_sppagebuilder_collections` AS `collection` WHERE `collection`.`published` = 1 ORDER BY `collection`.`ordering` ASC942μs640B/administrator/components/com_sppagebuilder/dynamic-content/QueryBuilder.php:703Copy
  • SELECT a.enabled FROM `cto_extensions` AS `a` WHERE (`a`.`element` = 'com_acymailing' OR `a`.`element` = 'com_acym')1ms520B/components/com_sppagebuilder/builder/classes/base.php:865Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `cto_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'980μs592B/components/com_sppagebuilder/helpers/helper.php:1780Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `cto_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'945μs592B/components/com_sppagebuilder/helpers/helper.php:1780Copy
  • SELECT `a`.`name`,`a`.`css_path` FROM `cto_sppagebuilder_assets` AS `a` WHERE `a`.`published` = 11ms576B/components/com_sppagebuilder/helpers/helper.php:1809Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `cto_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'975μs592B/components/com_sppagebuilder/helpers/helper.php:1780Copy
  • SELECT e.manifest_cache,`e`.`manifest_cache` FROM `cto_extensions` AS `e` WHERE `e`.`element` = 'com_sppagebuilder'952μs592B/components/com_sppagebuilder/helpers/helper.php:1780Copy
  • SELECT `template` FROM `cto_template_styles` WHERE `client_id` = 0 AND `home` = 1956μs536B/components/com_sppagebuilder/builder/classes/base.php:87Copy
  • SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params FROM cto_modules AS m WHERE ( (m.published = 1 AND `m`.`position` = 'breadcrumb') AND (`m`.`publish_up` IS NULL OR `m`.`publish_up` <= :publishUp)) AND (`m`.`publish_down` IS NULL OR `m`.`publish_down` >= :publishDown) AND m.access IN (1,5) AND m.client_id = 0 ORDER BY m.ordering ASC1.88ms1.72KBParams/components/com_sppagebuilder/addons/module/site.php:159Copy
  • SELECT * FROM `cto_template_styles` WHERE `client_id` = 0 AND `id` = '9'1.3ms40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `cto_template_styles` WHERE `client_id` = 0 AND `id` = '9'1.51ms40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `cto_template_styles` WHERE `client_id` = 0 AND `id` = '9'1.31ms40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `cto_template_styles` WHERE `client_id` = 0 AND `id` = '9'1.45ms40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `cto_template_styles` WHERE `client_id` = 0 AND `id` = '9'1.3ms40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT * FROM `cto_schemaorg` WHERE `itemId` = :itemId AND `context` = :context996μs1.55KBParams/plugins/system/schemaorg/src/Extension/Schemaorg.php:406Copy
  • 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 `cto_content` AS `a` INNER JOIN `cto_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `cto_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `cto_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `cto_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `cto_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)1.47ms22.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 `cto_content` AS `a` INNER JOIN `cto_categories` AS `c` ON `c`.`id` = `a`.`catid` LEFT JOIN `cto_content_frontpage` AS `fp` ON `fp`.`content_id` = `a`.`id` LEFT JOIN `cto_users` AS `u` ON `u`.`id` = `a`.`created_by` LEFT JOIN `cto_categories` AS `parent` ON `parent`.`id` = `c`.`parent_id` LEFT JOIN `cto_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)1.55ms22.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 `cto_scheduler_tasks` AS `a` WHERE `a`.`state` = 11.05ms1.37KBParams/administrator/components/com_scheduler/src/Model/TasksModel.php:517Copy
  • SHOW FULL TABLES WHERE table_type="BASE TABLE"4.54ms3.06KB/libraries/vendor/joomla/database/src/Mysqli/MysqliDriver.php:587Copy
  • SELECT * FROM `cto_template_styles` WHERE `client_id` = 0 AND `id` = '9'1.25ms40.91KB/plugins/system/helixultimate/src/Platform/Helper.php:54Copy
  • SELECT `session_id` FROM `cto_session` WHERE `session_id` = ?1.19ms1008BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:277Copy
  • INSERT INTO `cto_session` (`data`,`time`,`session_id`) VALUES (?, ?, ?)2.92ms544BParams/libraries/vendor/joomla/session/src/Handler/DatabaseHandler.php:301Copy