Il n'y a aucune réponse
Retour


Request Details
Session Id:dtzt5455ghtylbmt1xp4ck45Request Type:GET
Time of Request:04/07/2009 04:37:58Status Code:200
Request Encoding:Unicode (UTF-8)Response Encoding:Unicode (UTF-8)

Trace Information
CategoryMessageFrom First(s)From Last(s)
dtTableSELECT DISTINCT  RLD_FORMCOLUMN.FORMCOLUMN_TABLE, RLD_FORMCOLUMN.FORMCOLUMN_ID, RLD_FORMCOLUMN.FORMCOLUMN_COLUMN,  
RLD_FORMCOLUMN.FORMCOLUMN_VALUE, RLD_FORMFIELD.FORMFIELD_NAME, RLD_FORMFIELD.FORMFIELD_ID,  RLD_FORMFIELD.FORMFIELD_TYPE,
RLD_FORMFIELD.FORMFIELD_ISHIDDEN, RLD_V_CHAMP.CHAMP_FR, RLD_V_CHAMP.OBJETTOUR_CODE , RLD_V_CHAMP.TYPETOUR_CODE
FROM RLD_FORMFIELD
INNER JOIN RLD_FORMCOLUMN ON RLD_FORMFIELD.FORMFIELD_ID = RLD_FORMCOLUMN.FORMFIELD_ID
INNER JOIN RLD_V_CHAMP
ON
(RLD_FORMCOLUMN.FORMCOLUMN_TABLE = RLD_V_CHAMP.TABLE_NOM
AND  RLD_FORMCOLUMN.FORMCOLUMN_COLUMN = RLD_V_CHAMP.CHAMP_NOM
AND  RLD_V_CHAMP.OBJETTOUR_CODE = 'FMA')
OR
(substring(RLD_FORMCOLUMN.FORMCOLUMN_COLUMN,charindex('.',RLD_FORMCOLUMN.FORMCOLUMN_COLUMN)+1,len(RLD_FORMCOLUMN.FORMCOLUMN_COLUMN) - charindex('.',RLD_FORMCOLUMN.FORMCOLUMN_COLUMN) - charindex('.',reverse(RLD_FORMCOLUMN.FORMCOLUMN_COLUMN))) = RLD_V_CHAMP.TABLE_NOM
AND  right(RLD_FORMCOLUMN.FORMCOLUMN_COLUMN,
CASE charindex('.',reverse(RLD_FORMCOLUMN.FORMCOLUMN_COLUMN))-1
WHEN -1 THEN 0
ELSE charindex('.',reverse(RLD_FORMCOLUMN.FORMCOLUMN_COLUMN))-1
END) = RLD_V_CHAMP.CHAMP_NOM
AND RLD_FORMCOLUMN.FORMCOLUMN_TABLE LIKE 'FMA%')
WHERE (RLD_FORMFIELD.SEARCH_ID = '9d179ee3-922a-4e53-8a70-aaeecb4f66c4')
SELECT [FMA].ID, [FMA].OBJETTOUR_CODE , [FMA1_HORAIR].DAT_FIN AS [DATE_CACHE] ,[T_ZONE].ZONE_ID AS [ZONE_ZONE] , [FMA].ID_COMMUNE AS [ZONE] , [FMA1_HORAIR].DAT_DEBUT AS [DATE_FIN] , [FMA1_HORAIR].DAT_FIN AS [DATE_DEBUT] FROM [FMA] LEFT JOIN [FMA1_HORAIR] ON [FMA1_HORAIR].ID = [FMA].ID AND [FMA1_HORAIR].STATUT <> 'S' LEFT JOIN [J_ZONECOMMUNE] AS [T_ZONE] ON [T_ZONE].COMMUNE_INSEE = [FMA].ID_COMMUNE WHERE [FMA].STATUT <> 'S' AND CONVERT(DateTime,isnull([FMA1_HORAIR].DAT_FIN,'')) >= '' + CONVERT(nvarchar,GETDATE(),103) + '' AND ([T_ZONE].ZONE_ID IN (0,58)) AND CONVERT(DateTime,isnull([FMA1_HORAIR].DAT_DEBUT,'')) <= '31/05/2009' AND CONVERT(DateTime,isnull([FMA1_HORAIR].DAT_FIN,'')) >= '01/10/2008' 0,1552880,155288
40,2345920,079304
filtre final = '' = ''0,2346650,000073
test10,3195710,084906
aspx.pageBegin PreRender0,4030650,083494
aspx.pageEnd PreRender0,4030890,000025
aspx.pageBegin SaveViewState0,4083100,005221
aspx.pageEnd SaveViewState0,4097480,001437
aspx.pageBegin Render0,4097640,000017
aspx.pageEnd Render0,4111230,001359

Control Tree
Control IdTypeRender Size Bytes (including children)Viewstate Size Bytes (excluding children)
__PAGEASP.listing_aspx206624
    _ctl6System.Web.UI.ResourceBasedLiteralControl2980
    frmSystem.Web.UI.HtmlControls.HtmlForm17520
        moduleIdSystem.Web.UI.HtmlControls.HtmlInputHidden980
        _ctl7System.Web.UI.LiteralControl2040
        nbResultSystem.Web.UI.WebControls.Literal79140
        _ctl8System.Web.UI.LiteralControl220
        ctl_listASP.LISTING_FR_d855eb34_ec4e_4e7e_9ee6_c4edaced24a9_ascx4310
            ctl_list:__SEARCH_IDSystem.Web.UI.HtmlControls.HtmlInputHidden1220
            ctl_list:_ctl0System.Web.UI.LiteralControl20
            ctl_list:__LISTINGTEMPLATE_IDSystem.Web.UI.HtmlControls.HtmlInputHidden1400
            ctl_list:_ctl1System.Web.UI.LiteralControl20
            ctl_list:__LGSystem.Web.UI.HtmlControls.HtmlInputHidden740
            ctl_list:_ctl2System.Web.UI.LiteralControl20
            ctl_list:__LISTETourInFrance.RLD.Control.DataListTheme87236
            ctl_list:_ctl3System.Web.UI.LiteralControl20
        _ctl9System.Web.UI.LiteralControl40
        tdPaginationSystem.Web.UI.HtmlControls.HtmlTable032
            _ctl0System.Web.UI.HtmlControls.HtmlTableRow00
                _ctl1System.Web.UI.HtmlControls.HtmlTableCell00
                    _ctl10System.Web.UI.LiteralControl00
                _ctl2System.Web.UI.HtmlControls.HtmlTableCell00
                    _ctl11System.Web.UI.LiteralControl00
                _ctl3System.Web.UI.HtmlControls.HtmlTableCell00
                    _ctl12System.Web.UI.LiteralControl00
            _ctl4System.Web.UI.HtmlControls.HtmlTableRow00
                tdPrecedentSystem.Web.UI.HtmlControls.HtmlTableCell00
                    precedentSystem.Web.UI.WebControls.ImageButton00
                tdPrecedentVideSystem.Web.UI.HtmlControls.HtmlTableCell032
                    precedentVideSystem.Web.UI.WebControls.Image00
                _ctl5System.Web.UI.HtmlControls.HtmlTableCell00
                    _ctl13System.Web.UI.LiteralControl00
                    Pagination1FS.Web.UI.WebControls.Pagination060
                    _ctl14System.Web.UI.LiteralControl00
                tdSuivantSystem.Web.UI.HtmlControls.HtmlTableCell00
                    suivantSystem.Web.UI.WebControls.ImageButton00
                tdSuivantVideSystem.Web.UI.HtmlControls.HtmlTableCell032
                    suivantVideSystem.Web.UI.WebControls.Image00
        _ctl15System.Web.UI.LiteralControl180
    _ctl16System.Web.UI.LiteralControl160

Session state
Session KeyTypeValue
Info9d179ee3-922a-4e53-8a70-aaeecb4f66c4TourInFrance.RLD.Control.InfoFormTourInFrance.RLD.Control.InfoForm

Headers Collection
NameValue
Cache-Controlno-cache
ConnectionKeep-Alive
Pragmano-cache
AcceptAccept: application/xhtml+xml,text/html;q=0.9,text/plain;
Accept-CharsetISO-8859-1,utf-8;q=0.7,*;q=0.7
Accept-Languageen-us,en;q=0.5
Hostcdt64.tourinsoft.com
User-AgentCCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Reverse-ViaFS-ISA-A1
x-cc-listList:1 For:195.95.168.42
AspFilterSessionIddtzt5455ghtylbmt1xp4ck45

Server Variables
NameValue
ALL_HTTPHTTP_CACHE_CONTROL:no-cache HTTP_CONNECTION:Keep-Alive HTTP_PRAGMA:no-cache HTTP_ACCEPT:Accept: application/xhtml+xml,text/html;q=0.9,text/plain; HTTP_ACCEPT_CHARSET:ISO-8859-1,utf-8;q=0.7,*;q=0.7 HTTP_ACCEPT_LANGUAGE:en-us,en;q=0.5 HTTP_HOST:cdt64.tourinsoft.com HTTP_USER_AGENT:CCBot/1.0 (+http://www.commoncrawl.org/bot.html) HTTP_REVERSE_VIA:FS-ISA-A1 HTTP_X_CC_LIST:List:1 For:195.95.168.42 HTTP_ASPFILTERSESSIONID:dtzt5455ghtylbmt1xp4ck45
ALL_RAWCache-Control: no-cache Connection: Keep-Alive Pragma: no-cache Accept: Accept: application/xhtml+xml,text/html;q=0.9,text/plain; Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.7 Accept-Language: en-us,en;q=0.5 Host: cdt64.tourinsoft.com User-Agent: CCBot/1.0 (+http://www.commoncrawl.org/bot.html) Reverse-Via: FS-ISA-A1 x-cc-list: List:1 For:195.95.168.42 AspFilterSessionId: dtzt5455ghtylbmt1xp4ck45
APPL_MD_PATH/LM/W3SVC/39/ROOT
APPL_PHYSICAL_PATH\\share\web\TourInSoft\Client\CDT64\
AUTH_TYPE 
AUTH_USER 
AUTH_PASSWORD 
LOGON_USER 
REMOTE_USER 
CERT_COOKIE 
CERT_FLAGS 
CERT_ISSUER 
CERT_KEYSIZE 
CERT_SECRETKEYSIZE 
CERT_SERIALNUMBER 
CERT_SERVER_ISSUER 
CERT_SERVER_SUBJECT 
CERT_SUBJECT 
CONTENT_LENGTH0
CONTENT_TYPE 
GATEWAY_INTERFACECGI/1.1
HTTPSoff
HTTPS_KEYSIZE 
HTTPS_SECRETKEYSIZE 
HTTPS_SERVER_ISSUER 
HTTPS_SERVER_SUBJECT 
INSTANCE_ID39
INSTANCE_META_PATH/LM/W3SVC/39
LOCAL_ADDR192.168.2.102
PATH_INFO/RLD/Syndication/23f85868-dd8d-4666-9558-4ba6f17c1dd3/listing.aspx
PATH_TRANSLATED\\share\web\TourInSoft\Client\CDT64\RLD\Syndication\23f85868-dd8d-4666-9558-4ba6f17c1dd3\listing.aspx
QUERY_STRING 
REMOTE_ADDR38.103.63.55
REMOTE_HOST38.103.63.55
REMOTE_PORT59101
REQUEST_METHODGET
SCRIPT_NAME/RLD/Syndication/23f85868-dd8d-4666-9558-4ba6f17c1dd3/listing.aspx
SERVER_NAMEcdt64.tourinsoft.com
SERVER_PORT80
SERVER_PORT_SECURE0
SERVER_PROTOCOLHTTP/1.1
SERVER_SOFTWAREMicrosoft-IIS/7.0
URL/RLD/Syndication/23f85868-dd8d-4666-9558-4ba6f17c1dd3/listing.aspx
HTTP_CACHE_CONTROLno-cache
HTTP_CONNECTIONKeep-Alive
HTTP_PRAGMAno-cache
HTTP_ACCEPTAccept: application/xhtml+xml,text/html;q=0.9,text/plain;
HTTP_ACCEPT_CHARSETISO-8859-1,utf-8;q=0.7,*;q=0.7
HTTP_ACCEPT_LANGUAGEen-us,en;q=0.5
HTTP_HOSTcdt64.tourinsoft.com
HTTP_USER_AGENTCCBot/1.0 (+http://www.commoncrawl.org/bot.html)
HTTP_REVERSE_VIAFS-ISA-A1
HTTP_X_CC_LISTList:1 For:195.95.168.42
HTTP_ASPFILTERSESSIONIDdtzt5455ghtylbmt1xp4ck45