General
Name |
Open Connections |
Max Connections |
periana |
6 |
INF |
lucee_scope |
0 |
INF |
inteka_clientsession |
2 |
INF |
imeh_clientsession |
3 |
INF |
immoportal_clientsession |
3 |
INF |
modek_clientsession |
2 |
INF |
modek |
1 |
INF |
imeh_webprotokoll |
1 |
INF |
inteka_webprotokoll |
1 |
INF |
immoportal |
2 |
INF |
imeh |
1 |
INF |
immoportal_webprotokoll |
1 |
INF |
immoportal_anzeigenstatistik |
1 |
INF |
inteka |
8 |
INF |
www_global |
3 |
INF |
fashion_ag |
1 |
INF |
modek_webprotokoll |
0 |
INF |
SQL Queries
|
Name |
Records |
Time |
Usage |
Datasource |
Source |
Line |
Cached |
|
qryCarts
|
0 |
0.856 ms |
- |
periana |
H:\www\periana.de\www\initialisierung_session.cfm |
82 |
No |
SQL
SELECT Clienttoken
FROM clientparameter
WHERE Clienttoken = 'E1881W7141224021912'
|
|
BOTS
|
76 |
0.595 ms |
- |
www_global |
H:\www\periana.de\www\initialisierung_session.cfm |
97 |
No |
SQL
Select kennung
From crawler_bots
Where Kennung <> '' AND KENNUNG IS NOT NULL
GROUP BY Kennung
|
|
BOTS_IP
|
1 |
0.394 ms |
- |
www_global |
H:\www\periana.de\www\initialisierung_session.cfm |
104 |
No |
SQL
Select ip
From crawler_bots
Where IP <> '' AND IP IS NOT NULL
GROUP BY Kennung
|
|
clientparameterletzte
|
1 |
0.631 ms |
- |
periana |
H:\www\periana.de\www\initialisierung_session.cfm |
122 |
No |
SQL
SELECT *
FROM clientparameter
WHERE Kundennummer = '0'
ORDER BY ID DESC
|
|
parametereintragen
|
0 |
5.22 ms |
- |
periana |
H:\www\periana.de\www\initialisierung_session.cfm |
141 |
No |
SQL (Merged Parameters)
INSERT INTO clientparameter
(
cftoken,
cfid,
clienttoken,
Waehrung,
AnzahlartikelAnzeigen,
IP,
Browser,
HTTPReferer,
Besuche,
Sound,
Kundennummer,
affiliate
)
Values
(
'0',
'ea0f7662-6755-46ee-a244-907c873eb1d5',
'E1881W7141224021912',
'€',
20,
'13.58.228.106',
'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)',
'',
1,
0,
'0',
"1"
)
SQL (Explicit Parameters)
INSERT INTO clientparameter
(
cftoken,
cfid,
clienttoken,
Waehrung,
AnzahlartikelAnzeigen,
IP,
Browser,
HTTPReferer,
Besuche,
Sound,
Kundennummer,
affiliate
)
Values
(
{type: "CF_SQL_VARCHAR", value: '0'},
{type: "CF_SQL_VARCHAR", value: 'ea0f7662-6755-46ee-a244-907c873eb1d5'},
{type: "CF_SQL_VARCHAR", value: 'E1881W7141224021912'},
'€',
20,
{type: "CF_SQL_VARCHAR", value: '13.58.228.106'},
{type: "CF_SQL_VARCHAR", value: 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'},
{type: "CF_SQL_VARCHAR", value: ''},
1,
0,
'0',
"1"
)
|
|
parameterupdate
|
0 |
4.93 ms |
- |
periana |
H:\www\periana.de\www\initialisierung_session.cfm |
181 |
No |
SQL (Merged Parameters)
UPDATE clientparameter SET
Besuche = Besuche + 1,
HTTPReferer = '',
IP = '13.58.228.106',
Browser = 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
WHERE clienttoken = 'E1881W7141224021912'
SQL (Explicit Parameters)
UPDATE clientparameter SET
Besuche = Besuche + 1,
HTTPReferer = {type: "CF_SQL_VARCHAR", value: ''},
IP = {type: "CF_SQL_VARCHAR", value: '13.58.228.106'},
Browser = {type: "CF_SQL_VARCHAR", value: 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'}
WHERE clienttoken = 'E1881W7141224021912'
|
|
clientparameter2
|
1 |
0.393 ms |
- |
periana |
H:\www\periana.de\www\initialisierung_session.cfm |
193 |
No |
SQL
SELECT AnzahlartikelAnzeigen, Waehrung, sound, Kundennummer
FROM clientparameter
WHERE clienttoken = 'E1881W7141224021912'
|
|
Sonderangebote
|
1 |
0.558 ms |
- |
periana |
H:\www\periana.de\www\initialisierung_session.cfm |
231 |
No |
SQL
SELECT Count(ID) AS SonderangebotAnzahl
FROM Artikel
WHERE Freigabeprioritaet <= 1 AND now() BETWEEN AngebotVon AND AngebotBis
|
|
Affiliate
|
0 |
0.564 ms |
- |
periana |
H:\www\periana.de\www\initialisierung-Gutschein.cfm |
30 |
No |
SQL
Select *
FROM Affiliate
WHERE AffiliateNr = 0
|
|
WarengruppeEbene1
|
8 |
0.535 ms |
- |
periana |
H:\www\periana.de\www\http\shop\warengruppenauswahl-horizontal.cfm |
29 |
No |
SQL
SELECT WarengruppeNr, WarengruppeText
FROM Warengruppen
WHERE WarengruppeEbene = 1 AND Freigabe = 0
ORDER BY WarengruppePrioritaet
|
|
Infos
|
5 |
0.454 ms |
- |
periana |
H:\www\periana.de\www\http\Spalte-rechts.cfm |
9 |
No |
SQL
SELECT ID, Headline
FROM Infos
ORDER BY Datum DESC
|
|
Jobs
|
0 |
0.494 ms |
- |
periana |
H:\www\periana.de\www\http\Spalte-rechts.cfm |
14 |
No |
SQL
Select ID, Job
FROM Jobs
WHERE Geloescht = 0 AND Bewerbungsschluss > {ts '2024-12-14 14:19:12'}
ORDER BY JobArt
|
|
TermineNav
|
0 |
0.496 ms |
- |
periana |
H:\www\periana.de\www\http\Spalte-rechts.cfm |
20 |
No |
SQL
SELECT ID, thema, DatumVon, DatumBis
FROM Terminkalender
WHERE DatumBis > now() OR DatumVon > now()
ORDER BY DatumVon
|
|
Tipps
|
42 |
0.427 ms |
- |
periana |
H:\www\periana.de\www\http\navigation.cfm |
153 |
No |
SQL
SELECT ID FROM Wussten_Sie
|
|
Tipp
|
1 |
0.278 ms |
- |
periana |
H:\www\periana.de\www\http\navigation.cfm |
159 |
No |
SQL
SELECT ID, spruch
FROM Wussten_Sie
where ID = 34
|
|
Rezept
|
1 |
0.542 ms |
- |
periana |
H:\www\periana.de\www\http\navigation.cfm |
174 |
No |
SQL
SELECT ID, Headline, Beschreibung, Bild
FROM Rezepte
ORDER BY eingabedatum DESC
|
|
|