ローズ&フランキンセンス ローション(150ml)|プラダーナ/プラダーナの激安アウトレット・セール通販|コスメティックタイムズ

12/1現在
238ブランド
8,078点販売中

最大5%pt還元|最短3日|8,000円以上全国送料無料

ページトップ

この商品のサンプルを希望いたしますか?

ここにサンプル名が入ります。


Debugging Information
ColdFusion Server Developer 2018,0,11,326016
Template /item/detail_item.cfm
Time Stamp 01-Dec-24 01:48 PM
Locale Japanese
User Agent Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Remote IP 172.70.163.89
Host Name 172.70.163.89


Execution Time

Total Time Avg Time Count Template
234 ms 234 ms 1 top level D:\inetpub\public\item\detail_item.cfm
125 ms 125 ms 1 D:/inetpub/public/pc/item/detail_itemList_api.html.cfm
109 ms 109 ms 1 D:/inetpub/public/pc/common/new_header.cfm
78 ms 78 ms 1 CFC[ D:/inetpub/components/CMPopup.cfc | getCommercialPopupDT() ] from D:/inetpub/components/CMPopup.cfc
78 ms 78 ms 1 CFC[ D:/inetpub/components/ItemInfo.cfc | getItemInfo(ITEMCD = 47700029, ECSECRETCD = ) ] from D:/inetpub/components/ItemInfo.cfc
78 ms 78 ms 1 D:/inetpub/public/pc/common/div_PopupC3.cfm
16 ms 16 ms 1 CFC[ D:/inetpub/components/Common.cfc | setMetaInfo(STRMETADT = [complex value], STRSERCHDT = [complex value]) ] from D:/inetpub/components/Common.cfc
16 ms 16 ms 1 D:/inetpub/public/common/metainfo.cfm
16 ms 16 ms 1 D:/inetpub/public/pc/common/new_recent_item.cfm
15 ms 15 ms 1 D:/inetpub/public/pc/common/new_globalnavi_item.cfm
0 ms 0 ms 2 CFC[ D:/inetpub/components/Basket.cfc | getBasketDataInit() ] from D:/inetpub/components/Basket.cfc
0 ms 0 ms 2 CFC[ D:/inetpub/components/Cart.cfc | calcTotalCartData(CALCPOINTFLG = 1) ] from D:/inetpub/components/Cart.cfc
0 ms 0 ms 5 CFC[ D:/inetpub/components/Cart.cfc | getCartDataInit() ] from D:/inetpub/components/Cart.cfc
0 ms 0 ms 2 CFC[ D:/inetpub/components/Cart.cfc | getCartErrDataInit() ] from D:/inetpub/components/Cart.cfc
0 ms 0 ms 1 CFC[ D:/inetpub/components/CartInfoToDB.cfc | getCartInfoFromDB() ] from D:/inetpub/components/CartInfoToDB.cfc
0 ms 0 ms 1 CFC[ D:/inetpub/components/Common.cfc | getHttpOrHttps(/cart/main) ] from D:/inetpub/components/Common.cfc
0 ms 0 ms 1 CFC[ D:/inetpub/components/CookieVariables.cfc | getCartKey() ] from D:/inetpub/components/CookieVariables.cfc
0 ms 0 ms 1 CFC[ D:/inetpub/components/CookieVariables.cfc | getSearchKeyword() ] from D:/inetpub/components/CookieVariables.cfc
0 ms 0 ms 1 CFC[ D:/inetpub/components/CookieVariables.cfc | insRecentItem(ITEMCD = 47700029) ] from D:/inetpub/components/CookieVariables.cfc
0 ms 0 ms 1 CFC[ D:/inetpub/components/Criteo.cfc | dspItemDetailPageTag(ITEMCD = 47700029) ] from D:/inetpub/components/Criteo.cfc
0 ms 0 ms 3 CFC[ D:/inetpub/components/Datetime.cfc | getDateTime({ts '2014-12-01 13:48:06'}, 10) ] from D:/inetpub/components/Datetime.cfc
0 ms 0 ms 1 CFC[ D:/inetpub/components/Datetime.cfc | getDateTime({ts '2014-12-01 13:48:07'}, 10) ] from D:/inetpub/components/Datetime.cfc
0 ms 0 ms 2 CFC[ D:/inetpub/components/Datetime.cfc | getDateTime({ts '2024-12-01 13:48:06'}, 0) ] from D:/inetpub/components/Datetime.cfc
0 ms 0 ms 1 CFC[ D:/inetpub/components/Datetime.cfc | getDateTime({ts '2024-12-01 13:48:06'}, 1) ] from D:/inetpub/components/Datetime.cfc
0 ms 0 ms 1 CFC[ D:/inetpub/components/Datetime.cfc | getDateTime({ts '2024-12-01 13:48:07'}, 1) ] from D:/inetpub/components/Datetime.cfc
0 ms 0 ms 2 CFC[ D:/inetpub/components/DisplayItemString.cfc | getNumberFormat(0) ] from D:/inetpub/components/DisplayItemString.cfc
0 ms 0 ms 1 CFC[ D:/inetpub/components/DisplayItemString.cfc | getNumberFormat(8078) ] from D:/inetpub/components/DisplayItemString.cfc
0 ms 0 ms 1 CFC[ D:/inetpub/components/ItemInfo.cfc | getQueryBrandList(STRLANG = jp, QRYBRANDLIST = [complex value], LISTINITIAL = a,i,u,e,o) ] from D:/inetpub/components/ItemInfo.cfc
0 ms 0 ms 1 CFC[ D:/inetpub/components/ItemInfo.cfc | getQueryBrandList(STRLANG = jp, QRYBRANDLIST = [complex value], LISTINITIAL = ha,hi,hu,he,ho) ] from D:/inetpub/components/ItemInfo.cfc
0 ms 0 ms 1 CFC[ D:/inetpub/components/ItemInfo.cfc | getQueryBrandList(STRLANG = jp, QRYBRANDLIST = [complex value], LISTINITIAL = ka,ki,ku,ke,ko) ] from D:/inetpub/components/ItemInfo.cfc
0 ms 0 ms 1 CFC[ D:/inetpub/components/ItemInfo.cfc | getQueryBrandList(STRLANG = jp, QRYBRANDLIST = [complex value], LISTINITIAL = ma,mi,mu,me,mo) ] from D:/inetpub/components/ItemInfo.cfc
0 ms 0 ms 1 CFC[ D:/inetpub/components/ItemInfo.cfc | getQueryBrandList(STRLANG = jp, QRYBRANDLIST = [complex value], LISTINITIAL = na,ni,nu,ne,no) ] from D:/inetpub/components/ItemInfo.cfc
0 ms 0 ms 1 CFC[ D:/inetpub/components/ItemInfo.cfc | getQueryBrandList(STRLANG = jp, QRYBRANDLIST = [complex value], LISTINITIAL = ra,ri,ru,re,ro) ] from D:/inetpub/components/ItemInfo.cfc
0 ms 0 ms 1 CFC[ D:/inetpub/components/ItemInfo.cfc | getQueryBrandList(STRLANG = jp, QRYBRANDLIST = [complex value], LISTINITIAL = sa,si,su,se,so) ] from D:/inetpub/components/ItemInfo.cfc
0 ms 0 ms 1 CFC[ D:/inetpub/components/ItemInfo.cfc | getQueryBrandList(STRLANG = jp, QRYBRANDLIST = [complex value], LISTINITIAL = ta,ti,tu,te,to) ] from D:/inetpub/components/ItemInfo.cfc
0 ms 0 ms 1 CFC[ D:/inetpub/components/ItemInfo.cfc | getQueryBrandList(STRLANG = jp, QRYBRANDLIST = [complex value], LISTINITIAL = wa) ] from D:/inetpub/components/ItemInfo.cfc
0 ms 0 ms 1 CFC[ D:/inetpub/components/ItemInfo.cfc | getQueryBrandList(STRLANG = jp, QRYBRANDLIST = [complex value], LISTINITIAL = ya,yu,yo) ] from D:/inetpub/components/ItemInfo.cfc
0 ms 0 ms 4 CFC[ D:/inetpub/components/Login.cfc | chkAuthAutoLogin() ] from D:/inetpub/components/Login.cfc
0 ms 0 ms 4 CFC[ D:/inetpub/components/Login.cfc | initCommonLoginInfo() ] from D:/inetpub/components/Login.cfc
0 ms 0 ms 1 CFC[ D:/inetpub/components/rakutenMarketing.cfc | dspGlobalCode() ] from D:/inetpub/components/rakutenMarketing.cfc
0 ms 0 ms 1 CFC[ D:/inetpub/public/Application.cfc | onRequestStart(/item/detail_item.cfm) ] from D:/inetpub/public/Application.cfc
0 ms 0 ms 1 D:/inetpub/public/cfhtml/pc/common/recent_Item_pc.html.cfm
0 ms 0 ms 1 D:/inetpub/public/cfhtml/pc/item/detail_item_contents_pc.html.cfm
0 ms 0 ms 1 D:/inetpub/public/globalvariables.cfm
0 ms 0 ms 1 D:/inetpub/public/html/globalnavi/globalnavi_brand.html
0 ms 0 ms 1 D:/inetpub/public/html/globalnavi/globalnavi_category_00.html
0 ms 0 ms 1 D:/inetpub/public/html/globalnavi/globalnavi_category_01.html
0 ms 0 ms 1 D:/inetpub/public/html/globalnavi/globalnavi_category_02.html
0 ms 0 ms 1 D:/inetpub/public/html/globalnavi/globalnavi_category_03.html
0 ms 0 ms 1 D:/inetpub/public/html/globalnavi/globalnavi_category_04.html
0 ms 0 ms 1 D:/inetpub/public/pc/common/body_noscript.cfm
0 ms 0 ms 1 D:/inetpub/public/pc/common/bottom_cart.cfm
0 ms 0 ms 1 D:/inetpub/public/pc/common/head_script.cfm
0 ms 0 ms 1 D:/inetpub/public/pc/common/new_footer.cfm
0 ms 0 ms 1 D:/inetpub/public/pc/common/popup_list.cfm
0 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
234 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

qrySelItemMST (Datasource=CosmeticTimesR, Time=78ms, Records=1) in D:\inetpub\components\ItemInfo.cfc @ 13:48:06.006
    SELECT
      ID.ItemCD,
      ID.BaseCD,
      ID.ItemTypeFlg,
      ID.DispTypeFlg,
      ID.HKItemCD,
      ID.HKItemCDWH,
      ISNULL(ID.ShippingAreaCD,'00') AS ShippingAreaCD,
      ID.BrandCD,
      ID.BrandName,
      ID.BrandEName,
      ISNULL(ID.CategoryCD,'') AS CategoryCD,
      ISNULL(ID.CategoryName,'') AS CategoryName,
      RTRIM(ISNULL(ID.SubCategoryCD,'')) AS SubCategoryCD,
      ISNULL(ID.SubCategoryName,'') AS SubCategoryName,
      RTRIM(ISNULL(ID.ThirdCategoryCD,'')) AS ThirdCategoryCD,
      ISNULL(ID.ThirdCategoryName,'') AS ThirdCategoryName,
      ISNULL(ID.CategoryCD,'') + RTRIM(ISNULL(ID.SubCategoryCD,'')) + RTRIM(ISNULL(ID.ThirdCategoryCD,'')) AS DispCategoryCD,
      ISNULL(ISNULL(ID.ThirdCategoryName,ID.SubCategoryName),ID.CategoryName) AS DispCategoryName,
      CASE
      WHEN ISNULL(ID.SndCategory,'') = '' THEN
        ID.FstCategory
      WHEN ISNULL(ID.ThirdCategoryCD,'') = '' THEN
        ID.FstCategory + '/' + ID.SndCategory
      ELSE
        ID.FstCategory + '/' + ID.SndCategory + '/' + ID.ThirdCategoryCD
      END AS CategoryLink,
      CASE
      WHEN ISNULL(ID.SndCategory,'') = '' THEN
        'category=' + ID.CategoryCD
      WHEN ISNULL(ID.ThirdCategoryCD,'') = '' THEN 
        'category=' + ID.CategoryCD + '&subCategory=' + ID.SubCategoryCD
      ELSE
        'category=' + ID.CategoryCD + '&subCategory=' + ID.SubCategoryCD + '&thirdCategory=' + ID.ThirdCategoryCD
      END AS CategoryPrm,
      ID.FstCategory,
      ID.SndCategory,
      ID.ItemName,
      ID.ItemEName,
      ISNULL(ID.DiscriptionA,ID.DiscriptionL) AS DiscriptionA,
      ISNULL(ID.DiscriptionB,ID.DiscriptionM) AS DiscriptionB,
      ISNULL(ID.DiscriptionC,ID.DiscriptionS) AS DiscriptionC,
      ID.DiscriptionEC,
      ID.DiscriptionPR,
      ID.Caution,
      ID.Direction,
      ID.Ingredient,
      ID.Net,
      ID.Color,
      ITM.UnitPrice,
      ITM.ReferPrice,
      ITM.SpecialPrice,
      ITM.ConversionPrice,
    
      NULL AS SecretPrice,
      NULL AS EcSecretCD,
    
      VSD.Stock,
      VSD.UnshipmentCount,
      VSD.PublicStock,
      CASE --アウトレットセールの場合は販売上限数を表示
      WHEN ISD.LimitAmount IS NULL THEN
        VSD.PossibleStock
      WHEN ISNULL(ISD.LimitAmount,99999) <= VSD.PossibleStock THEN
        ISD.LimitAmount
      ELSE
        VSD.PossibleStock
      END AS PossibleStock,
      ID.MinUnit,
      ID.MaxUnit,
      ID.Threshold,
      ID.DiscontinuedFlg,
      ID.OrderStopFlg,
      ID.InvalidFlg,
      ID.ReArriveFlg,
      ID.CatalogOrderFlg,
      ID.AmazonFlg,
      ID.InvoiceComment,
      ID.ReArriveMailFlg,
      ID.BasStartDate,
      ID.BasEndDate,
      ID.ITMStartDate,
      ID.ITMEndDate,
      ID.SearchKeyWord,
      ID.Remarks,
      ID.ImageFileName,
      ID.CountryCD,
      ID.ReviewCnt,
      ID.ShipCnt,
      ID.RepeatCnt,
      ISNULL(ID.Rate,0)AS Rate,
      ISNULL(ID.PriceDownFlg,'00') AS PriceDownFlg,
      ISNULL(ID.Evaluate,0) AS Evaluate,
      ID.MaxUnitPrice,
      ID.MinUnitPrice,
      ID.MaxOthersPrice,
      ID.MinOthersPrice,
      ID.UnreleasedFlg,
      ID.EcDiscountPrice,
      ID.EcDiscountFlg,
      FORMAT(ID.EcDiscountEndDate,'M/d') AS EcDiscountEndDate,
      ID.EcDiscountCD,
      ID.EcDiscountListBunnerFile AS ListBunnerFile,
      FORMAT(ID.SaleEndDate,'M/d') AS MaxSaleEndDate,
      ID.SaleDetailBunnerFile AS MaxSaleDetailBunnerFile,
      ID.SaleListBunnerFileSP AS MaxSaleListBunnerFileSP,
      ID.SalesCD AS MaxSaleCD,
      FORMAT(ID.ChoiceSetEndDate,'M/d') AS MaxChoiceSetEndDate,
      ID.ChoiceSetDetailBunnerFile AS MaxChoiceSetDetailBunnerFile,
      ID.ChoiceSetCD AS MaxChoiceSetCD,
      ID.LimitedSaleCD,
      ID.LimitedSaleDetailBunnerFile AS MaxLimitedSaleDetailBunnerFile,
      ID.LimitedSaleListBunnerFileSP AS MaxLimitedSaleListBunnerFileSP,
      ID.ChoiceSetDetailNo AS ChoiceSetDetailNo,
      ID.LimitQuty AS LimitQuty,
      ID.ChoiceDiscription AS ChoiceDiscription,
      ID.ChoiceDiscriptionSP AS ChoiceDiscriptionSP,
      ID.ChoiceCaption AS ChoiceCaption,
      ID.ChoiceDetailColor AS ChoiceDetailColor,
      ISNULL(ID.StockBaseShippingAreaCD,'00') AS StockBaseShippingAreaCD,
      '' AS clickURL,
      '' AS logURL
    FROM
      DM_UnitItemMartDT AS ID WITH (nolock)
      INNER JOIN
      IM_ItemMST AS ITM WITH (nolock) ON
      ID.ItemCD = ITM.ItemCD
      INNER JOIN
      V_StockDT AS VSD WITH (nolock) ON
      ID.ItemCD = VSD.ItemCD
      LEFT JOIN
      (
      SELECT
        ISD.ItemCD,
        CASE
        WHEN JPD.SicStock + JPD.BbStock < ISD.LimitAmount THEN
          JPD.SicStock + JPD.BbStock
        ELSE
          ISD.LimitAmount
        END LimitAmount
      FROM
        IM_SalesItemDT AS ISD  WITH (nolock)
        INNER JOIN
        V_JpmStockDT AS JPD  WITH (nolock) ON
        ISD.ItemCD = JPD.ItemCD
      WHERE
        ISD.SalesCD = '000130' AND
        ISD.InvalidFlg = '00' AND
        ISD.LimitAmount <> 0
      ) ISD ON
      ITM.ItemCD = ISD.ItemCD
    
    WHERE
      0 = 0
      
        AND ID.ItemCD = ? 
        AND ID.InvalidFlg = ?  -- 有効
      ORDER BY
        ID.ItemCD ASC;
    
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = 47700029
Parameter #2(CF_SQL_CHAR) = 00

qryBrandListInitial (Datasource=, Time=0ms, Records=54) in D:\inetpub\components\ItemInfo.cfc @ 13:48:06.006
    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitial  IN( ?,?,?,?,?)
      
      ORDER BY
      
        OrderKana
      
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = a
Parameter #2(CF_SQL_VARCHAR) = i
Parameter #3(CF_SQL_VARCHAR) = u
Parameter #4(CF_SQL_VARCHAR) = e
Parameter #5(CF_SQL_VARCHAR) = o

qryBrandListInitial (Datasource=, Time=0ms, Records=29) in D:\inetpub\components\ItemInfo.cfc @ 13:48:06.006
    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitial  IN( ?,?,?,?,?)
      
      ORDER BY
      
        OrderKana
      
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = ka
Parameter #2(CF_SQL_VARCHAR) = ki
Parameter #3(CF_SQL_VARCHAR) = ku
Parameter #4(CF_SQL_VARCHAR) = ke
Parameter #5(CF_SQL_VARCHAR) = ko

qryBrandListInitial (Datasource=, Time=0ms, Records=38) in D:\inetpub\components\ItemInfo.cfc @ 13:48:06.006
    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitial  IN( ?,?,?,?,?)
      
      ORDER BY
      
        OrderKana
      
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = sa
Parameter #2(CF_SQL_VARCHAR) = si
Parameter #3(CF_SQL_VARCHAR) = su
Parameter #4(CF_SQL_VARCHAR) = se
Parameter #5(CF_SQL_VARCHAR) = so

qryBrandListInitial (Datasource=, Time=0ms, Records=24) in D:\inetpub\components\ItemInfo.cfc @ 13:48:06.006
    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitial  IN( ?,?,?,?,?)
      
      ORDER BY
      
        OrderKana
      
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = ta
Parameter #2(CF_SQL_VARCHAR) = ti
Parameter #3(CF_SQL_VARCHAR) = tu
Parameter #4(CF_SQL_VARCHAR) = te
Parameter #5(CF_SQL_VARCHAR) = to

qryBrandListInitial (Datasource=, Time=0ms, Records=6) in D:\inetpub\components\ItemInfo.cfc @ 13:48:06.006
    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitial  IN( ?,?,?,?,?)
      
      ORDER BY
      
        OrderKana
      
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = na
Parameter #2(CF_SQL_VARCHAR) = ni
Parameter #3(CF_SQL_VARCHAR) = nu
Parameter #4(CF_SQL_VARCHAR) = ne
Parameter #5(CF_SQL_VARCHAR) = no

qryBrandListInitial (Datasource=, Time=0ms, Records=40) in D:\inetpub\components\ItemInfo.cfc @ 13:48:06.006
    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitial  IN( ?,?,?,?,?)
      
      ORDER BY
      
        OrderKana
      
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = ha
Parameter #2(CF_SQL_VARCHAR) = hi
Parameter #3(CF_SQL_VARCHAR) = hu
Parameter #4(CF_SQL_VARCHAR) = he
Parameter #5(CF_SQL_VARCHAR) = ho

qryBrandListInitial (Datasource=, Time=0ms, Records=11) in D:\inetpub\components\ItemInfo.cfc @ 13:48:06.006
    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitial  IN( ?,?,?,?,?)
      
      ORDER BY
      
        OrderKana
      
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = ma
Parameter #2(CF_SQL_VARCHAR) = mi
Parameter #3(CF_SQL_VARCHAR) = mu
Parameter #4(CF_SQL_VARCHAR) = me
Parameter #5(CF_SQL_VARCHAR) = mo

qryBrandListInitial (Datasource=, Time=0ms, Records=3) in D:\inetpub\components\ItemInfo.cfc @ 13:48:06.006
    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitial  IN( ?,?,?)
      
      ORDER BY
      
        OrderKana
      
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = ya
Parameter #2(CF_SQL_VARCHAR) = yu
Parameter #3(CF_SQL_VARCHAR) = yo

qryBrandListInitial (Datasource=, Time=0ms, Records=28) in D:\inetpub\components\ItemInfo.cfc @ 13:48:06.006
    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitial  IN( ?,?,?,?,?)
      
      ORDER BY
      
        OrderKana
      
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = ra
Parameter #2(CF_SQL_VARCHAR) = ri
Parameter #3(CF_SQL_VARCHAR) = ru
Parameter #4(CF_SQL_VARCHAR) = re
Parameter #5(CF_SQL_VARCHAR) = ro

qryBrandListInitial (Datasource=, Time=0ms, Records=0) in D:\inetpub\components\ItemInfo.cfc @ 13:48:06.006
    SELECT 
      *
    FROM  
      qryBrandList    
    WHERE  0=0
    
        AND  BrandInitial  IN( ?)
      
      ORDER BY
      
        OrderKana
      
Query Parameter Value(s) -
Parameter #1(CF_SQL_VARCHAR) = wa

qrySelCommercialPopupDT (Datasource=CosmeticTimesR, Time=78ms, Records=0) in D:\inetpub\components\CMPopup.cfc @ 13:48:06.006
  SELECT
    TOP 1
    CMPopupNo,
    Comment,
    CONVERT(char(19),StartDate,120) AS StartDate,
    CONVERT(char(19),EndDate,120) AS EndDate,
    htmlURL,
    htmlURLSP,
    InvalidFlg,
    InsertOperatorCD,
    UpdateOperatorCD,
    InsertDate,
    UpdateDate,
    iconURL,
    icondispflg,
    logindispflg,
    LinkURL,
    PopupImage
  FROM
    SM_CommercialPopupDT with(nolock)
  WHERE 0 = 0
    AND StartDate <= getdate()
    AND EndDate >= getdate()
    AND InvalidFlg = ?
  ;
Query Parameter Value(s) -
Parameter #1(CF_SQL_CHAR) = 00


Scope Variables

Application Variables:
applicationname=CosmeticTimes
commonfooter=Struct (2)
commonfooter_s=Struct (2)
header=Struct (19)
headerglovalnavictg=Struct (2)
headerpc=Struct (13)
leftnaviguidenavi=Struct (2)
leftnavikeywordnavi=Struct (2)
leftnavisidenavi=Struct (2)
leftnavkeywordnavi=Struct (1)
leftnavsearchnavi=Struct (2)
newcommonfooter=Struct (2)
newheaderglovalnavictg=Struct (2)
pctopnewitem=Struct (2)
pctopslideshow=Struct (2)
pctopstaffreview=Struct (2)
topcachedata=Struct (2)
topfaq_s=Struct (2)
topslideshow_s=Struct (2)
topspcachedata=Struct (2)
CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=D:\inetpub\public\item\detail_item.cfm
CONTENT_LENGTH=0
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=off
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=*/*
HTTP_ACCEPT_ENCODING=gzip, br
HTTP_ACCEPT_LANGUAGE=
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=757713.gxwh.asia
HTTP_REFERER=
HTTP_URL=/item/detail_item.cfm?itemcd=47700029?itemcd=47700029
HTTP_USER_AGENT=Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; [email protected])
LOCAL_ADDR=103.125.217.134
PATH_INFO=
PATH_TRANSLATED=D:\inetpub\public\item\detail_item.cfm
QUERY_STRING=itemcd=47700029
REMOTE_ADDR=172.70.163.89
REMOTE_HOST=172.70.163.89
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/item/detail_item.cfm
SERVER_NAME=757713.gxwh.asia
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/10.0
WEB_SERVER_API=
Cookie Variables:
CT3=47700029
Form Fields:
ADDBRAND=
ADDITEM=
BASECD=
CHKAGE=
ECSECRET=
HDNEVAL=
ITEMCD=47700029
ITEMQAINSTXT=
LISTCNT=20
MTD=Search
NICKNAMETXT=
REVIEWCD=
SEQNO=
SORTTYPE=new
SUBNO=
TERMTYPE=
TERMVAL=
Request Parameters:
3dwhitememberdate=2021-06-01
accessflg=0
amazon_merchantid=A257K01BV4LLIT
amazon_public_key_id=AG6Z3D243ZFIMJA7ZBKY3JCF
amazonpay_sandbox=false
amazonpay_surl=https://www.cosmetic-times.com
append_order=true
arycashbackbrandcd=Array (8)
arycashbackfee=Array (3)
arycashbacklv=Array (3)
arycode_addmissioncd=Array (18)
arycode_aegisresult=Array (6)
arycode_agecd=Array (10)
arycode_appform=Array (2)
arycode_appointtime=Array (7)
arycode_approve=Array (3)
arycode_approvedflg=Array (2)
arycode_cardbrand=Array (6)
arycode_cautioncd=Array (15)
arycode_complaint=Array (12)
arycode_coupondivision=Array (2)
arycode_couponuseterms=Array (4)
arycode_creditpaymentcnt=Array (3)
arycode_creditstate=Array (15)
arycode_deliverybox=Array (2)
arycode_deliverycompanyflg=Array (2)
arycode_deliveryroutetype=Array (2)
arycode_discontinued=Array (2)
arycode_displaycd=Array (6)
arycode_disptypeflg=Array (4)
arycode_dsphidflg=Array (2)
arycode_ecsitecd=Array (4)
arycode_featureitemcls=Array (4)
arycode_fpstate=Array (7)
arycode_gender=Array (2)
arycode_inquiryclass=Array (10)
arycode_invalid=Array (2)
arycode_itemdescriptiontype=Array (4)
arycode_itemsalestate=Array (2)
arycode_itemsort=Array (6)
arycode_itemtypeflg=Array (6)
arycode_mailsendflg=Array (2)
arycode_memberdivisioncd=Array (4)
arycode_memberrankcd=Array (5)
arycode_memberstatus=Array (5)
arycode_necesunneces=Array (2)
arycode_ordercancel=Array (7)
arycode_orderstate=Array (7)
arycode_orderstopflg=Array (2)
arycode_paymentmethod=Array (8)
arycode_paymentstate=Array (4)
arycode_pointmessage=Array (9)
arycode_pointtranflg=Array (5)
arycode_pointtransact=Array (9)
arycode_possibunpossib=Array (2)
arycode_pricedownflg=Array (2)
arycode_processflg=Array (3)
arycode_ranking=Array (4)
arycode_rearrivemailflg=Array (2)
arycode_reshipflg=Array (2)
arycode_returnreason=Array (5)
arycode_reviewsort=Array (4)
arycode_searchpricerange=Array (8)
arycode_sellingflg=Array (2)
arycode_sendflg=Array (2)
arycode_shippingdivisionflg=Array (3)
arycode_splistcount=Array (3)
arycode_splistcount2=Array (3)
arycode_stockwaiting=Array (3)
arycode_troublecd=Array (6)
arycode_unprocproc=Array (2)
arycode_unreleasedflg=Array (2)
arycode_unusedused=Array (2)
arycode_userrequest=Array (3)
arycode_veritransexpireflg=Array (2)
arycode_wantunwant=Array (2)
arycode_warehouse=Array (2)
arycode_whitestatus=Array (3)
authorize_err_mpi=/od/authorize_err_mpi
authorize_res_mpi=/od/authorize_res_mpi
authorize_suc_mpi=/od/authorize_suc_mpi
bodytag_itemscope=
cookieexpire=360
cssversion=?ver=134806
debugflg=0
dtchecklogintime=20231201134806
dtfreecampaignend=2020/11/09 00:00
dtfreecampaignstart=2020/11/03 11:00
ec_id=1234567
ec_testid=
ecdevicetype=P
featuretrouble=False
file_path=D:\Inetpub\public\track\json\
flgcashbackcampaign=0
http_devicetype=P
https=off
image_folder=D:\Inetpub\public\image
image_s_folder=D:\Inetpub\public\sp\image
imgappleiconpath=https://img.cosmetic-times.com/sp/image/common/apple-touch-icon.png
imgiconpath=https://img.cosmetic-times.com/sp/image/common/android-touch-icon.png
imgthumbnailpath=https://img.cosmetic-times.com/image/common/header_logo_ct2.png
intcashbackdiscountratio=0
intcollectfee=324
intdiscountrate=50
intfreecarriageamount=8000
intlimitautherrcnt=3
intlimitofthreshold=300000
intmaxamount=24
intmaxorderamount=50
intmemberrank_ctvip=100000
intmemberrank_friend=15000
intmemberrank_heartful=25000
intmemberrank_lovery=40000
intmemberrank_member=14999
intorderhistorymonth=12
intordernewcustomer=5000
intorderpaymentresults=10000
intorderthreshold=25000
intorderthreshold_amazonpay=20000
intorderthreshold_dpay=100000
intorderthreshold_paypay=500000
intorderthresholdcvs=55000
intpointhistorymonth=12
intreviewpoint=50
iswhitemember=true
jsversion=?ver=134806
metatag_common_description_head=海外国内人気のデパコス、オーガニックコスメ、国内未発売ブランド、サロン・クリニック推奨コスメなど約180ブランドが最大85%OFF!約7千点のブランドコスメがなんと【8,000円以上全国送料無料】本物・新品保証でコスメ好きに嬉しい格安化粧品通販サイトです。
metatag_common_h1string=激安通販
metatag_common_keyword=コスメ,激安,コスメティックタイムズ,化粧品,口コミ,送料無料,通販
metatag_common_title_name=ブランドコスメ激安通販のコスメティックタイムズ
private_keyfile_path=D:\inetpub\Public\track\id_rsa
private_passphrase=@CosmeticTimes1234
public_folder=D:\Inetpub\public
remote_addr=172.70.163.89
run_mode=True
salt=wHgn7DdL1cE17P8C
samesite_value=
sftp_upload_path=data
sitename=コスメティックタイムズ
strdatasourcename=CosmeticTimesR
strdivisioncdinitial_catalog=7
strdivisioncdinitial_ecsite=8
strdivisioncdinitial_guest=2
strdivisioncdinitial_mobile=9
strimgserverurlssl=https://img.cosmetic-times.com
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
[email protected]
strmerchantccid=A100000000000001018249cc
strmerchantpw=c618594fdb80c0e161d0c86f4d3a5993cc3292b562efa1fe3fb2311776ec5506
strorderoperatorcd=900001
strreturnsalescd=000147
strsqlstringescape=\
strwebserverip=20.205.112.97
strwebserverurl=https://www.cosmetic-times.com
strwebserverurlssl=https://www.cosmetic-times.com
totalamountlimit=3000
twittercard=summary_large_image
twittersite=@CosmeticTimes
udfgetcodename=Complex type
upload_file_path=D:\Inetpub\public\track\upload\
vc_sftp_password=
vc_sftp_server=xxxx
vc_sftp_user=xxxx
zip_pass=@CosmeticTimes5678
Server Variables:
coldfusion=Struct (10)
os=Struct (5)
system=Struct (2)
Session Variables:
basketdata=Struct (0)
cartdata=Struct (0)
carterrdata=Struct (0)
listingadtype=0
sessionid=B6BFD4F452980A2E192862E0877C28D0.cfusion
urltoken=CFID=1441070&CFTOKEN=e8d528e08e4bc7d8-0355C3AF-A262-3D8B-80DCFAC87CB2C853&jsessionid=B6BFD4F452980A2E192862E0877C28D0.cfusion
URL Parameters:
itemcd=47700029
Debug Rendering Time: 16 ms