Project

General

Profile

Download (21.8 KB)

Bug #14883 ยป query_list.html

Administrator Admin, 2005-07-29 11:40

 
<!DOCTYPE html
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<?xml version="1.0" encoding="iso-8859-1"?>
<?xml-stylesheet href="#internalStyle" type="text/css"?>

<html>
<head>
<!-- TYPO3 Script ID: ext/dbal/mod1/index.php -->
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<meta name="GENERATOR" content="TYPO3 3.8, http://typo3.com, &#169; Kasper Sk&#229;rh&#248;j 1998-2005, extensions are copyright of their respective owners." />
<title>DBAL Analysis Module</title>
<link rel="stylesheet" type="text/css" href="../../../../typo3/stylesheet.css" />
<style type="text/css" id="internalStyle">
/*<![CDATA[*/
/*###POSTCSSMARKER###*/
/*]]>*/
</style>
<link rel="stylesheet" type="text/css" href="../../../../typo3/../typo3conf/ext/adaltas_skin/stylesheet_post.css" />
<script type="text/javascript">
/*<![CDATA[*/
script_ended = 0;
function jumpToUrl(URL) { //
document.location = URL;
}
/*]]>*/
</script>
<!--###POSTJSMARKER###-->
</head>
<body id="ext-dbal-mod1-index-php">

<!-- Wrapping DIV-section for whole page BEGIN -->
<div class="typo3-noDoc">
<form action="" method="post">

<!-- MAIN Header in page top -->
<h2>DBAL Analysis Module</h2>


<!-- Spacer element -->
<div style="padding-top: 5px;"></div>


<!-- ***********************
Begin output section.
*********************** -->
<div>


<!-- Section content -->

<table border="0" cellpadding="0" cellspacing="0" width="100%" id="typo3-funcmenu">
<tr>
<td valign="top" nowrap="nowrap"></td>
<td valign="top" align="right" nowrap="nowrap">

<!-- Function Menu of module -->
<select name="SET[function]" onchange="jumpToUrl('index.php?&amp;id=0&amp;SET[function]='+this.options[this.selectedIndex].value,this);">
<option value="0" selected="selected">Debug log</option>
<option value="info">Cached info</option>
</select>
</td>
</tr>
</table>

<!-- Section header -->
<h4 class="uppercase">Debug log</h4>


<!-- Section content -->

<a href="index.php?cmd=flush">FLUSH LOG</a> -
<a href="index.php?cmd=joins">JOINS</a> -
<a href="index.php?cmd=errors">ERRORS</a> -
<a href="index.php?cmd=parsing">PARSING</a> -
<a href="index.php">LOG</a> -
<a href="index.php?cmd=where">WHERE</a> -

<a href="/dev/typo3conf/ext/dbal/mod1/index.php?specTime=1122629177" target="tx_debuglog">[New window]</a>
<hr />
<table border="1" cellspacing="0">
<tr>
<td>Execution time</td>
<td>Error</td>
<td>Table joins</td>
<td>Data</td>
<td>Query</td>
</tr>
<tr>
<td>9</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT *
FROM be_sessions, be_users
WHERE
be_sessions.ses_id = '97a620167f6786195c652f5bcddc2ec3' AND be_sessions.ses_name = 'be_typo_user' AND be_sessions.ses_userid = be_users.uid AND (be_sessions.ses_iplock = '193.154.213.115' OR be_sessions.ses_iplock = '[DISABLED]') AND be_sessions.ses_hashlock = 111628376 AND be_users.pid = 0 AND be_users.disable = 0 AND be_users.deleted = 0 AND (be_users.starttime &lt;= 1122629178) AND (be_users.endtime = 0 OR be_users.endtime &gt; 1122629178)</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>UPDATE be_sessions
SET
ses_tstamp='1122629177'
WHERE
ses_id = '97a620167f6786195c652f5bcddc2ec3' AND ses_name = 'be_typo_user'</td>
</tr>
<tr>
<td>8</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT *
FROM be_sessions, be_users
WHERE
be_sessions.ses_id = '97a620167f6786195c652f5bcddc2ec3' AND be_sessions.ses_name = 'be_typo_user' AND be_sessions.ses_userid = be_users.uid AND (be_sessions.ses_iplock = '193.154.213.115' OR be_sessions.ses_iplock = '[DISABLED]') AND be_sessions.ses_hashlock = 111628376 AND be_users.pid = 0 AND be_users.disable = 0 AND be_users.deleted = 0 AND (be_users.starttime &lt;= 1122629178) AND (be_users.endtime = 0 OR be_users.endtime &gt; 1122629178)</td>
</tr>
<tr>
<td>3</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>UPDATE be_sessions
SET
ses_tstamp='1122629177'
WHERE
ses_id = '97a620167f6786195c652f5bcddc2ec3' AND ses_name = 'be_typo_user'</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>DELETE FROM be_sessions
WHERE
ses_tstamp &lt; 1122542778 AND ses_name = 'be_typo_user'</td>
</tr>
<tr>
<td>5</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT *
FROM be_groups
WHERE
deleted = 0 AND hidden = 0 AND pid = 0 AND uid IN (1,2) AND (lockToDomain = '' OR lockToDomain = 'playground38.beko-esolutions.com')</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT content
FROM cache_hash
WHERE
hash = '9b7d19ad79ac0f0c189a5e044a38a498'</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>DELETE FROM sys_lockedrecords
WHERE
userid = 1</td>
</tr>
<tr>
<td>4</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT sorting, pid, uid
FROM tt_content
WHERE
pid = 1 AND tt_content.deleted = 0
ORDER BY sorting ASC
LIMIT 1</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT *
FROM pages
WHERE
uid = 1</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT uid
FROM pages
WHERE
uid = 1 AND pages.deleted = 0</td>
</tr>
<tr>
<td>3</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT *
FROM pages
WHERE
uid = 1</td>
</tr>
<tr>
<td>3</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT pid, uid, title, TSconfig, is_siteroot, storage_pid
FROM pages
WHERE
uid = 1 AND pages.deleted = 0</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT content
FROM cache_hash
WHERE
hash = 'b04bd0b01dda3f57d0b59a0f9413d77f'</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT CType
FROM tt_content
WHERE
uid = 0</td>
</tr>
<tr>
<td>1</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT sys_language_uid
FROM tt_content
WHERE
uid = 0</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT colPos
FROM tt_content
WHERE
uid = 0</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT spaceBefore
FROM tt_content
WHERE
uid = 0</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT spaceAfter
FROM tt_content
WHERE
uid = 0</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT section_frame
FROM tt_content
WHERE
uid = 0</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT sectionIndex
FROM tt_content
WHERE
uid = 0</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT linkToTop
FROM tt_content
WHERE
uid = 0</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT header
FROM tt_content
WHERE
uid = 0</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT header_position
FROM tt_content
WHERE
uid = 0</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT header_layout
FROM tt_content
WHERE
uid = 0</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT header_link
FROM tt_content
WHERE
uid = 0</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT date
FROM tt_content
WHERE
uid = 0</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT bodytext
FROM tt_content
WHERE
uid = 0</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT hidden
FROM tt_content
WHERE
uid = 0</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT starttime
FROM tt_content
WHERE
uid = 0</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT endtime
FROM tt_content
WHERE
uid = 0</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT fe_group
FROM tt_content
WHERE
uid = 0</td>
</tr>
<tr>
<td>11</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>INSERT INTO tt_content
(
CType,
starttime,
endtime,
layout,
colPos,
date,
header_position,
header_layout,
text_align,
text_face,
text_size,
text_color,
imagewidth,
imageheight,
imageorient,
imagecols,
imagecaption_position,
cols,
recursive,
menu_type,
list_type,
table_bgColor,
table_border,
table_cellspacing,
table_cellpadding,
spaceBefore,
spaceAfter,
section_frame,
splash_layout,
sectionIndex,
sorting,
pid,
sys_language_uid,
linkToTop,
header,
header_link,
bodytext,
hidden,
fe_group,
l18n_diffsource,
tstamp
) VALUES (
'header',
'0',
'0',
'0',
'0',
'0',
'',
'0',
'',
'0',
'0',
'0',
'0',
'0',
'8',
'0',
'',
'0',
'0',
'0',
'',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'0',
'1',
'1',
'1',
'0',
'0',
'',
'',
'',
'0',
'0',
'a:18:{s:5:\&quot;CType\&quot;;N;s:16:\&quot;sys_language_uid\&quot;;N;s:6:\&quot;colPos\&quot;;N;s:11:\&quot;spaceBefore\&quot;;N;s:10:\&quot;spaceAfter\&quot;;N;s:13:\&quot;section_frame\&quot;;N;s:12:\&quot;sectionIndex\&quot;;N;s:9:\&quot;linkToTop\&quot;;N;s:6:\&quot;header\&quot;;N;s:15:\&quot;header_position\&quot;;N;s:13:\&quot;header_layout\&quot;;N;s:11:\&quot;header_link\&quot;;N;s:4:\&quot;date\&quot;;N;s:8:\&quot;bodytext\&quot;;N;s:6:\&quot;hidden\&quot;;N;s:9:\&quot;starttime\&quot;;N;s:7:\&quot;endtime\&quot;;N;s:8:\&quot;fe_group\&quot;;N;}',
'1122629178'
)</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT *
FROM tt_content
WHERE
uid = 7663</td>
</tr>
<tr>
<td>5</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>INSERT INTO sys_log
(
userid,
type,
action,
error,
details_nr,
details,
log_data,
tablename,
recuid,
recpid,
IP,
tstamp,
event_pid,
NEWid
) VALUES (
'1',
'1',
'1',
'0',
'10',
'Record \'%s\' (%s) was inserted on page \'%s\' (%s)',
'a:4:{i:0;N;i:1;s:15:\&quot;tt_content:7663\&quot;;i:2;s:12:\&quot;[root-level]\&quot;;i:3;N;}',
'tt_content',
'7663',
'0',
'193.154.213.115',
'1122629177',
'0',
'NEW42e9f629390ec'
)</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT pid
FROM tt_content
WHERE
uid = 7663 AND tt_content.deleted = 0</td>
</tr>
<tr>
<td>3</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT pid, uid, title, TSconfig, is_siteroot, storage_pid
FROM pages
WHERE
uid = -1 AND pages.deleted = 0</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT content
FROM cache_hash
WHERE
hash = '32ec4483d02eafd59c74ca37ddd8f85a'</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT pid
FROM tt_content
WHERE
uid = 7663</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>DELETE FROM cache_pages
WHERE
page_id IN (0)</td>
</tr>
<tr>
<td>2</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>DELETE FROM cache_pagesection
WHERE
page_id IN (0)</td>
</tr>
<tr>
<td>5</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT *
FROM sys_log
WHERE
type = 1 AND userid = 1 AND tstamp = 1122629177 AND error != 0</td>
</tr>
<tr>
<td>3</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>SELECT *
FROM tt_content
WHERE
uid = 7663 AND tt_content.deleted = 0</td>
</tr>
<tr>
<td>5</td>
<td>0</td>
<td></td>
<td><table border="1" cellpadding="1" cellspacing="0" bgcolor="white"><tr><td><font face="Verdana,Arial" size="1"><b>EMPTY!</b></font></td></tr></table></td>
<td>Array</td>
</tr>
</table>

<!-- Spacer element -->
<div style="padding-top: 20px;"></div>


<!-- Section content -->
<a href="#" onclick="if (top.shortcutFrame &amp;&amp; confirm(String.fromCharCode(67,114,101,97,116,101,32,97,32,115,104,111,114,116,99,117,116,32,116,111,32,116,104,105,115,32,112,97,103,101,63))){top.shortcutFrame.document.location='../../../../typo3/alt_shortcut.php?modName=tools_txdbalM1&amp;URL=%2Fdev%2Ftypo3conf%2Fext%2Fdbal%2Fmod1%2Findex.php%3F%26id%3D%26SET%5Bfunction%5D%3D0';}return false;">
<img src="../../../../typo3/../typo3conf/ext/adaltas_skin/icons/gfx/shortcut.png" width="18" height="18" title="Create a shortcut to this page?" alt="" /></a>

<!-- Spacer element -->
<div style="padding-top: 10px;"></div>

</div>
<!-- *********************
End output section.
********************* -->

<script type="text/javascript">
/*<![CDATA[*/
if (top.busy && top.busy.loginRefreshed) {
top.busy.loginRefreshed();
}
/*]]>*/
</script>
</form>

<!-- Wrapping DIV-section for whole page END -->
</div>
</body> </html>
    (1-1/1)