Connexion


Debugging Information
ColdFusion Server Standard 2016,0,11,314546
Template /index.cfm
Time Stamp 17-Aug-19 03:06 PM
Locale French (Standard)
User Agent CCBot/2.0 (https://commoncrawl.org/faq/)
Remote IP 18.208.126.54
Host Name 18.208.126.54


Execution Time

Total Time Avg Time Count Template
15 ms 15 ms 1 D:/content_manager/config_globale.cfm
7 ms 7 ms 1 D:/content_manager/TEMPLATE/templates/site_b2c/before_all.cfm
3 ms 3 ms 1 D:/content_manager/TEMPLATE/codes/e_commerce_site_b2c/panier/cb_http/amazonPay_params.cfm
1 ms 1 ms 1 CFC[ D:/content_manager/TEMPLATE/application.cfc | onSessionStart() ] from D:/content_manager/TEMPLATE/application.cfc
1 ms 1 ms 1 D:/content_manager/prehome/prehome_bo_template.cfm
0 ms 0 ms 1 D:/content_manager/TEMPLATE/functions_client.cfm
0 ms 0 ms 1 D:/content_manager/app_functions.cfm
0 ms 0 ms 1 D:/content_manager/sql_injection.cfm
36 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
37 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

get_multisite_dns (Datasource=bo_template, Time=12ms, Records=1) in D:\content_manager\config_globale.cfm @ 15:06:44.044
		select 	id, 
				site_name, 
				site_dns as sitedns, 
				default_email_to as defaultmail , 
				partner_id, 
				site_path,
				e_com_skin as skin, 
				site_mapping, 
				e_commerce_code_path,
				protocole,
				url_backoffice,
				url_cdn,
				(select top 1 partner_id from dp_partner with(nolock) where mode & 256 = 256) as PARTNER_ID_ERESA 
		from multisite_management with(nolock)
		where site_dns = 'template-b2c-dev.solusquare.com'
		order by id
	
GetPartner (Datasource=bo_template, Time=1ms, Records=1) in D:\content_manager\config_globale.cfm @ 15:06:44.044
		SELECT
			dp_partner.*, 
			STUFF(
					(
						SELECT distinct ',' + CAST(cat_id AS VARCHAR(15))
						FROM dp_partner_categorie WITH (nolock)
						WHERE partner_id = dp_partner.partner_id
					FOR XML PATH(''), TYPE
					).value('.','VARCHAR(max)'), 1, 1, '') AS SelectionCat
		FROM dp_partner WITH (nolock)
		WHERE partner_id = 1 
getPromoVP (Datasource=bo_template, Time=0ms, Records=1) in D:\content_manager\TEMPLATE\templates\site_b2c\before_all.cfm @ 15:06:44.044
     select count(*) as nb
     from bo_produit_promotion_vp with(nolock) 
     where (date_debut < getdate() and date_fin > getdate()) 
getBreakpoints (Datasource=bo_template, Time=0ms, Records=3) in D:\content_manager\TEMPLATE\templates\site_b2c\before_all.cfm @ 15:06:44.044
	select *
	FROM bo_partner_breakpoint with (nolock)
	where partner_id = 1
	ORDER BY breakpoint_id
getPromoVP (Datasource=bo_template, Time=0ms, Records=1, Cached Query) in D:\content_manager\TEMPLATE\templates\site_b2c\before_all.cfm @ 15:06:44.044
     select count(*) as nb
     from bo_produit_promotion_vp with(nolock) 
     where (date_debut < getdate() and date_fin > getdate()) 
getParamEResa (Datasource=bo_template, Time=0ms, Records=0) in D:\content_manager\TEMPLATE\templates\site_b2c\before_all.cfm @ 15:06:44.044
	SELECT ISNULL(force_inactif,0) AS force_inactif 
	FROM stock_magasin_settings WITH(NOLOCK)
	WHERE code_enseigne = 'SLQ'
getParam_affiche_comparatif (Datasource=bo_template, Time=0ms, Records=1) in D:\content_manager\TEMPLATE\templates\site_b2c\before_all.cfm @ 15:06:44.044
	SELECT	*
	FROM	display_settings WITH(NOLOCK)
	WHERE	setting_name = 'affiche_comparatif'
BreakpointCourant (Datasource=bo_template, Time=0ms, Records=1) in D:\content_manager\TEMPLATE\templates\site_b2c\before_all.cfm @ 15:06:44.044
	select *
	FROM getBreakpoints 
	where libelle = 'default'
	ORDER BY breakpoint_id
qry_get_mode_reglement_am (Datasource=bo_template, Time=2ms, Records=1) in D:\content_manager\TEMPLATE\codes\e_commerce_site_b2c\panier\cb_http\amazonPay_params.cfm @ 15:06:44.044
	SELECT *
	FROM bo_mode_reglement with (nolock)
	WHERE 	statut_reglement & 2 = 2
			and nom_param1 = 'type' 
			and valeur_param1 = 'amazonPay' 
			and partner_id = 1 


Scope Variables

Application Variables:
applicationname=Template
availableresources=0
counter1=1
coupon_path_webservice_storeland=CouponEngineService
coupon_path_webservice_ur=CouponUREngineService
customer_path_webservice_ur=CustomerManagerService
fid_path_webservice_ur=LoyaltyMvtEngineService
getcustomer_path_webservice_ur=CustomerEngineService
histo_path_webservice_storeland=LoyaltyEngineService
marketing_path_webservice_storeland=MarketingEngineService
montant_aladin=5
montant_drop=0
oscc_authentification_password=piix9zgug
oscc_authentification_username=admin
oscc_path_webservice_storeland=OsccService
oscc_path_webservice_ur=CustomerMvtEngineService
oscc_type_carte=7
sessions=179
stock_path_webservice_storeland=StockService
url_webservice_storeland_coupon=https://avantageseco.xxx.com:9081/services/
url_webservice_storeland_oscc=https://avantageseco.xxx.com:9081/services/
url_webservice_ur=http://01.02.03.04:8090/webur/
ws_cartekdo=Struct (4)
ws_coupon=Struct (5)
ws_customer=Struct (6)
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:\content_manager\TEMPLATE\templates\site_b2c\index.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=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-US,en;q=0.5
HTTP_CONNECTION=Keep-Alive
HTTP_COOKIE=
HTTP_HOST=template-b2c-dev.solusquare.com
HTTP_REFERER=
HTTP_URL=
HTTP_USER_AGENT=CCBot/2.0 (https://commoncrawl.org/faq/)
LOCAL_ADDR=192.168.2.15
PATH_INFO=
PATH_TRANSLATED=D:\content_manager\TEMPLATE\templates\site_b2c\index.cfm
QUERY_STRING=
REMOTE_ADDR=18.208.126.54
REMOTE_HOST=18.208.126.54
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=template-b2c-dev.solusquare.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Microsoft-IIS/7.5
WEB_SERVER_API=
Client Variables:
accesskeyamazon=AKIAJJOQJJATCDFAMHKQ
amazon_actif=true
amtimeout=60
captureamazon=false
cfid=920249
cftoken=10465634
class_appmob=
clientidamazon=amzn1.application-oa2-client.53eef175296442778a5914f1da0516ed
clientvp_connecte=0
currencyamazon=EUR
hitcount=1
languageamazon=fr-fr
lastvisit={ts '2019-08-17 15:06:44'}
maxrows=30
merchantidamazon=A2NY5C6EWE03CZ
mode_reglement_amazon=110
nomire=0
regionamazon=DE
sandbox_modeamazon=true
scopeamazon=profile payments:widget payments:shipping_address payments:billing_address
secretkeyamazon=NF94PQzfOIjMF7p1yx6SDbyNOZMiziwhebPRKLGE
sessioncache=0
showlogvp=false
showo=0
tc_off=0
timecreated={ts '2019-08-17 15:06:44'}
toolkit_site_selected=2
type=amazonPay
url_retour_amazon=https://template-b2c-dev.solusquare.com/fr/amazon_matching.cfm
urltoken=CFID=920249&CFTOKEN=10465634
versionab=A
Cookie Variables:
CFID=920249
CFTOKEN=10465634
CODEMAG=
GOOGLEID=
Server Variables:
IS_PRODUCTION=false
ROOTCONTENTMANAGER=\\sophia-web1\d$\content_manager\
SQ=Struct (2)
coldfusion=Struct (10)
os=Struct (5)
Session Variables:
cfid=920249
cftoken=10465634
sessionid=TEMPLATE_920249_10465634
shoppingcart=Struct (1)
started={ts '2019-08-17 15:06:44'}
urltoken=CFID=920249&CFTOKEN=10465634
Debug Rendering Time: 4 ms