Internet Explorer wordt niet ondersteund voor deze website. U wordt geadviseerd om een moderne webbrowser te gebruiken.

Even geduld...
Bezig met laden configurator

Toepassen

Stap 1 3

Stap 2 3

Bepaal de juiste maat

Pas de deur volledig aan naar jouw situatie.

{stepnumber} {stepname}

{substepvalue} {substepname}

Kies een draairichting

Voor buitendeuren is het belangrijk om aan te geven of de deur naar binnen of naar buiten open draait. De meeste voordeuren gaan naar binnen open en de meeste achterdeuren naar buiten.

Binnendraaiend

Buitendraaiend

{stepnumber} {stepname}

{substepvalue} {substepname}

Stap 3 3

Accessoires

Maak je deur compleet door accessoires toe te voegen.

{stepnumber} {stepname}

{substepvalue} {substepname}

{stepnumber} {stepname}

{substepvalue} {substepname}

Stap 5 5 2

Controleer je bestelling

Je hebt voor de onderstaande producten gekozen. We adviseren je om de informatie nog eenmaal goed te controleren.

Terug

Bestellen/mailen Deze deur wordt speciaal voor jou op maat gemaakt en kan daarom niet geretourneerd worden

Totaalprijs* Mail deze configuratie Sla configuratie op Plaats deur op je bestellijst Plaats in winkelwagen Terug naar overzicht

* Deze prijs is een indicatie

Mail deze configuratie naar mijn mailadres

Bewaar deze configuratie

Vul hier je e-mailadres in en kies een naam voor deze configuratie.

Voeg configuratie toe aan uw winkelwagen op uw mobiel

Door het scannen van de QR-code wordt deze configuratie in de winkelwagen van Praxis geplaatst. Hier kun je de bestelling eenvoudig en veilig afronden.

{stepnumber} {mainstepname} {steps}

{stepvalue} {stepname}:

Request Details
Session Id:	lwlsbiyrhic1o2p2rdadpf20	Request Type:	GET
Time of Request:	7-11-2026 17:05:04	Status Code:	200
Request Encoding:	Unicode (UTF-8)	Response Encoding:	Unicode (UTF-8)

Trace Information
Category	Message	From First(s)	From Last(s)
aspx.page	Begin PreInit
aspx.page	End PreInit	0,000064	0,000064
aspx.page	Begin Init	0,000078	0,000014
	LoginControl_Init - isValidForThisDomain: True	0,000991	0,000913
	LoginControl - SetupWebsite - proceed: True, GoAnCode: , TagManagerId:	0,001588	0,000597
	This is page: homepage.aspx. With masterpagefile:	0,001875	0,000287
	CSS template IDs found:	0,002612	0,000737
	End load CSS from Wiser...	0,002635	0,000023
	JS template IDs found:	0,003195	0,000561
	NO JS template inline found	0,003218	0,000023
	End load JS from Wiser...	0,003227	0,000009
aspx.page	End Init	0,003332	0,000106
aspx.page	Begin InitComplete	0,003345	0,000012
aspx.page	End InitComplete	0,003354	0,000010
aspx.page	Begin PreLoad	0,003366	0,000011
aspx.page	End PreLoad	0,003380	0,000015
aspx.page	Begin Load	0,003391	0,000011
aspx.page	End Load	0,003446	0,000055
aspx.page	Begin LoadComplete	0,003458	0,000012
aspx.page	End LoadComplete	0,003469	0,000011
aspx.page	Begin PreRender	0,003480	0,000011
aspx.page	End PreRender	0,003602	0,000122
aspx.page	Begin PreRenderComplete	0,003620	0,000018
aspx.page	End PreRenderComplete	0,003631	0,000011
aspx.page	Begin SaveState	0,003922	0,000290
aspx.page	End SaveState	0,003935	0,000013
aspx.page	Begin SaveStateComplete	0,003945	0,000010
aspx.page	End SaveStateComplete	0,003955	0,000011
aspx.page	Begin Render	0,003965	0,000010
	QUERY SYSCON START: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	0,219529	0,215564
	Open connection with DB	0,219748	0,000219
	QUERY SYSCON END: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	0,643576	0,423828
	RenderStep Kies uw buitendeur connected to: 2289 - mainstepnumber: 1 - stepnumber: 1 - dependentvalue: 2289 - datasource connectedid: 2289	0,736957	0,093381
	[RenderValues] set query and/or replacements	0,741946	0,004989
	[RenderValues] Execute query	0,747970	0,006024
	query cachinghours: 200	0,750752	0,002782
	QUERY SYSCON START: SET @doortype = 'buitendeur'; SET @doorsubtype = 'achterdeuren'; SET @_door_id = IF('{door_id}' LIKE '{%}', false, CAST('{door_id}' AS UNSIGNED)); SET @_glass_id = IF('{glass_id}' LIKE '{%}', false, CAST('{glass_id}' AS UNSIGNED)); SELECT door.fsc AS fsc, door.KOMO AS komo, doorCat.isEasy AS gelaktgeleverd, doorCat.cando_comfort as candocomfort, IF(IFNULL(door.warrantyinYears,0)>9,1,0) AS ten_yr_guarantee, door.id AS door_id, doorCat.id AS door_cat_id, doorCat.`name` AS door_name, doorCat.style AS style, IFNULL(doorCat.door_wood_type, "Overig") AS door_wood_type, doorCat.isolerend AS isolerend, GROUP_CONCAT(DISTINCT CONCAT(door.height, "x", door.width)) AS sizes, IFNULL(MIN(glass.id),"") AS glass_id, IFNULL(glass.description_short, "") AS glass_name, doorCat.containsglass AS has_glass, IFNULL(GROUP_CONCAT(DISTINCT glass.glassType),IF(doorCat.containsglass =0,"Dichte deur", "")) AS glass_type, REPLACE(CONCAT_WS(" met ", doorCat.name, glass.description_short), 'met zonder','zonder') AS `name`, GROUP_CONCAT(DISTINCT door.producttype) AS door_type, doorCat.isolerend AS isolerend, door.eancode AS door_ean, glass.eancode AS glass_ean, MIN(door.pricecando) AS door_price, glass.pricecando AS glass_price, REPLACE(TRUNCATE(MIN(door.pricecando) + IFNULL(glass.pricecando,0) + IFNULL(mounting_package.pricecando,0),2), '.',',') AS total_price, IFNULL(CONCAT('<li>',REPLACE(doorCat.usp_s, '\r\n', '</li><li>'),'</li>'),'') AS usps, CONCAT('https://configurator.cando.eu/images/product/overzicht/',IFNULL(IFNULL(img.bestandsnaam,imgBackup.bestandsnaam), '')) AS img_url, REPLACE(CONCAT('https://configurator.cando.eu/images/product/overzicht/',IFNULL(IFNULL(img.bestandsnaam,imgBackup.bestandsnaam), '')),'_klein_','_vergroting_') AS img_url_large, REPLACE(CONCAT('https://configurator.cando.eu/images/product/overzicht/',IFNULL(img2.bestandsnaam, '')),'_klein_','_vergroting_') AS img2_url_large, IFNULL(img2.bestandsnaam, '') AS sfeerImageFile, doorCat.sequence AS `orderNr` FROM shop_products door JOIN shop_pro_cat door_to_cat ON door_to_cat.product_id=door.id JOIN shop_category doorCat ON doorCat.doortype=@doortype AND doorCat.id=door_to_cat.cat_id LEFT JOIN shop_koppeling glass_to_door ON glass_to_door.prod_dest=door.id AND glass_to_door.koppeltype IN("Roede", "Glas") LEFT JOIN shop_products glass ON glass.id=glass_to_door.prod_source LEFT JOIN shop_koppeling mounting_package_to_glass ON mounting_package_to_glass.prod_dest=glass.id AND mounting_package_to_glass.koppeltype="Verplicht item" LEFT JOIN shop_products mounting_package ON mounting_package.id=mounting_package_to_glass.prod_source # needs to be optimized LEFT JOIN shop_pictures img ON img.cat_id=doorCat.id AND img.formaatnaam = 'klein' AND img.fototype='deur' AND IF(glass.description_short IS NULL, img.name = doorCat.`name`, img.name = glass.description_short) #AND img.name = IFNULL(glass.description_short, "") LEFT JOIN shop_pictures imgBackup ON imgBackup.cat_id=doorCat.id AND imgBackup.formaatnaam = 'klein' AND imgBackup.fototype='deur' #AND img.name = IFNULL(glass.description_short, "") #LEFT JOIN shop_pictures imgLarge ON imgLarge.cat_id=doorCat.id AND imgLarge.formaatnaam = 'vergroting' AND imgLarge.fototype='deur' AND IF(glass.description_short IS NULL, imgLarge.name = doorCat.`name`, imgLarge.name = glass.description_short) #AND img.name = IFNULL(glass.description_short, "") #LEFT JOIN shop_pictures imgBackupLarge ON imgBackupLarge.cat_id=doorCat.id AND imgBackupLarge.formaatnaam = 'vergroting' AND imgBackupLarge.fototype='deur' #AND img.name = IFNULL(glass.description_short, "") LEFT JOIN shop_pictures img2 ON img2.cat_id=doorCat.id AND img2.formaatnaam = 'vergroting' AND img2.fototype='sfeerfoto' AND IF(glass.description_short IS NULL, img.name = doorCat.`name`, img.name = glass.description_short) WHERE doorCat.doortype=@doortype AND doorCat.doorsubtype=@doorsubtype AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', door.visiblecando, door.visiblecandoBranch) <> 0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', doorCat.visiblecando, doorCat.visiblecandoBranch) <> 0 AND IF(@_door_id = false, 1, door.id = @_door_id) AND IF(@_glass_id = false, 1, glass.id = @_glass_id) AND (glass.id IS NULL OR glass.visiblecando <> 0) GROUP BY `name` ORDER BY doorCat.sequence	0,750873	0,000121
	Open connection with DB	0,750972	0,000099
	QUERY SYSCON END: SET @doortype = 'buitendeur'; SET @doorsubtype = 'achterdeuren'; SET @_door_id = IF('{door_id}' LIKE '{%}', false, CAST('{door_id}' AS UNSIGNED)); SET @_glass_id = IF('{glass_id}' LIKE '{%}', false, CAST('{glass_id}' AS UNSIGNED)); SELECT door.fsc AS fsc, door.KOMO AS komo, doorCat.isEasy AS gelaktgeleverd, doorCat.cando_comfort as candocomfort, IF(IFNULL(door.warrantyinYears,0)>9,1,0) AS ten_yr_guarantee, door.id AS door_id, doorCat.id AS door_cat_id, doorCat.`name` AS door_name, doorCat.style AS style, IFNULL(doorCat.door_wood_type, "Overig") AS door_wood_type, doorCat.isolerend AS isolerend, GROUP_CONCAT(DISTINCT CONCAT(door.height, "x", door.width)) AS sizes, IFNULL(MIN(glass.id),"") AS glass_id, IFNULL(glass.description_short, "") AS glass_name, doorCat.containsglass AS has_glass, IFNULL(GROUP_CONCAT(DISTINCT glass.glassType),IF(doorCat.containsglass =0,"Dichte deur", "")) AS glass_type, REPLACE(CONCAT_WS(" met ", doorCat.name, glass.description_short), 'met zonder','zonder') AS `name`, GROUP_CONCAT(DISTINCT door.producttype) AS door_type, doorCat.isolerend AS isolerend, door.eancode AS door_ean, glass.eancode AS glass_ean, MIN(door.pricecando) AS door_price, glass.pricecando AS glass_price, REPLACE(TRUNCATE(MIN(door.pricecando) + IFNULL(glass.pricecando,0) + IFNULL(mounting_package.pricecando,0),2), '.',',') AS total_price, IFNULL(CONCAT('<li>',REPLACE(doorCat.usp_s, '\r\n', '</li><li>'),'</li>'),'') AS usps, CONCAT('https://configurator.cando.eu/images/product/overzicht/',IFNULL(IFNULL(img.bestandsnaam,imgBackup.bestandsnaam), '')) AS img_url, REPLACE(CONCAT('https://configurator.cando.eu/images/product/overzicht/',IFNULL(IFNULL(img.bestandsnaam,imgBackup.bestandsnaam), '')),'_klein_','_vergroting_') AS img_url_large, REPLACE(CONCAT('https://configurator.cando.eu/images/product/overzicht/',IFNULL(img2.bestandsnaam, '')),'_klein_','_vergroting_') AS img2_url_large, IFNULL(img2.bestandsnaam, '') AS sfeerImageFile, doorCat.sequence AS `orderNr` FROM shop_products door JOIN shop_pro_cat door_to_cat ON door_to_cat.product_id=door.id JOIN shop_category doorCat ON doorCat.doortype=@doortype AND doorCat.id=door_to_cat.cat_id LEFT JOIN shop_koppeling glass_to_door ON glass_to_door.prod_dest=door.id AND glass_to_door.koppeltype IN("Roede", "Glas") LEFT JOIN shop_products glass ON glass.id=glass_to_door.prod_source LEFT JOIN shop_koppeling mounting_package_to_glass ON mounting_package_to_glass.prod_dest=glass.id AND mounting_package_to_glass.koppeltype="Verplicht item" LEFT JOIN shop_products mounting_package ON mounting_package.id=mounting_package_to_glass.prod_source # needs to be optimized LEFT JOIN shop_pictures img ON img.cat_id=doorCat.id AND img.formaatnaam = 'klein' AND img.fototype='deur' AND IF(glass.description_short IS NULL, img.name = doorCat.`name`, img.name = glass.description_short) #AND img.name = IFNULL(glass.description_short, "") LEFT JOIN shop_pictures imgBackup ON imgBackup.cat_id=doorCat.id AND imgBackup.formaatnaam = 'klein' AND imgBackup.fototype='deur' #AND img.name = IFNULL(glass.description_short, "") #LEFT JOIN shop_pictures imgLarge ON imgLarge.cat_id=doorCat.id AND imgLarge.formaatnaam = 'vergroting' AND imgLarge.fototype='deur' AND IF(glass.description_short IS NULL, imgLarge.name = doorCat.`name`, imgLarge.name = glass.description_short) #AND img.name = IFNULL(glass.description_short, "") #LEFT JOIN shop_pictures imgBackupLarge ON imgBackupLarge.cat_id=doorCat.id AND imgBackupLarge.formaatnaam = 'vergroting' AND imgBackupLarge.fototype='deur' #AND img.name = IFNULL(glass.description_short, "") LEFT JOIN shop_pictures img2 ON img2.cat_id=doorCat.id AND img2.formaatnaam = 'vergroting' AND img2.fototype='sfeerfoto' AND IF(glass.description_short IS NULL, img.name = doorCat.`name`, img.name = glass.description_short) WHERE doorCat.doortype=@doortype AND doorCat.doorsubtype=@doorsubtype AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', door.visiblecando, door.visiblecandoBranch) <> 0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', doorCat.visiblecando, doorCat.visiblecandoBranch) <> 0 AND IF(@_door_id = false, 1, door.id = @_door_id) AND IF(@_glass_id = false, 1, glass.id = @_glass_id) AND (glass.id IS NULL OR glass.visiblecando <> 0) GROUP BY `name` ORDER BY doorCat.sequence	0,951094	0,200122
	[RenderValues] Do last replacements. Num items: 33	0,951146	0,000052
	[RenderValues] replacements done	1,689692	0,738546
	RenderStep (values rendered) Kies uw buitendeur connected to: 2289 - mainstepnumber: 1 - stepnumber: 1 - dependentvalue: 2289 - datasource connectedid: 2289	1,694086	0,004395
	[RenderValues] set query and/or replacements	1,698830	0,004743
	RenderSubStep connected to: - mainstepnumber: 1 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	1,698899	0,000069
	Language 38 is new	1,705794	0,006895
	Caching of languagewords in cache is starting because 'ML_38' is empty	1,705894	0,000100
	QUERY SYSCON START: SELECT fieldname, translation FROM site_languagefields WHERE languageid = ?languageId GROUP BY fieldname	1,706380	0,000486
	Open connection with DB	1,706412	0,000032
	QUERY SYSCON END: SELECT fieldname, translation FROM site_languagefields WHERE languageid = ?languageId GROUP BY fieldname	1,815468	0,109055
	0 woorden gecached voor key 'ML_38'	1,815773	0,000305
	Session 'MlJclLanguage' set to 38	1,815802	0,000030
	Start replace dynamic content	1,815861	0,000059
	Replace dynamic content only once	1,815966	0,000106
	End replace dynamic content	1,815976	0,000010
	Filled translationcomponent from cache.	1,816659	0,000683
	No caching of lanuage 38. Because it is not changed within this session.	1,935144	0,118485
	Cache item 'ML_38' already exists, so language is not cached again	1,935269	0,000125
	Session 'MlJclLanguage' set to 38	1,935403	0,000134
	Start replace dynamic content	1,935947	0,000544
	Replace dynamic content only once	1,937378	0,001432
	End replace dynamic content	1,937418	0,000040
	Filled translationcomponent from cache.	1,938331	0,000913
	Start replacing system objects	1,983828	0,045496
	Start replacing translation	1,985260	0,001432
	Start replacing objects	1,985787	0,000527
	Start replacing request	1,986284	0,000497
	Start replacing session	2,049049	0,062765
	Start replacing standards	2,073362	0,024313
	Start replacing objecs again	2,074237	0,000875
	[RenderValues] set query and/or replacements	2,229604	0,155367
	RenderSubStep connected to: - mainstepnumber: 1 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	2,229676	0,000072
	No caching of lanuage 38. Because it is not changed within this session.	2,229893	0,000217
	Cache item 'ML_38' already exists, so language is not cached again	2,229921	0,000028
	Session 'MlJclLanguage' set to 38	2,229931	0,000010
	Start replace dynamic content	2,229971	0,000040
	Replace dynamic content only once	2,230091	0,000120
	End replace dynamic content	2,230104	0,000013
	Filled translationcomponent from cache.	2,230728	0,000623
	QUERY SYSCON START: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	2,288958	0,058230
	Open connection with DB	2,289115	0,000157
	QUERY SYSCON END: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	2,327848	0,038733
	RenderStep Binnendraaiend connected to: binnendeuren deurtype - mainstepnumber: 2 - stepnumber: 1 - dependentvalue: 1 - datasource connectedid: binnendeuren - deurtype	2,335238	0,007390
	[RenderValues] set query and/or replacements	2,335288	0,000050
	RenderStep (values rendered) Binnendraaiend connected to: binnendeuren deurtype - mainstepnumber: 2 - stepnumber: 1 - dependentvalue: 1 - datasource connectedid: binnendeuren - deurtype	2,335365	0,000077
	[RenderValues] set query and/or replacements	2,335407	0,000042
	[RenderValues] Execute query	2,335715	0,000308
	query cachinghours: 200	2,335809	0,000094
	QUERY SYSCON START: SET @isBinnen = IF('{uitvoering}' ='Binnendraaiend', true,false); SET @isSet = IF('{uitvoering}' LIKE '{%}', false, true); SELECT * FROM ( SELECT 'Links binnendraaiend' AS valuelist_1, 'linksbinnendraaiend' AS valuelist_2, 'L1' AS valuelist_3 UNION SELECT'Rechts binnendraaiend', 'rechtsbinnendraaiend', 'R2' ) binnen WHERE @isBinnen AND @isSet UNION ALL SELECT * FROM ( SELECT 'Links buitendraaiend' AS valuelist_1, 'linksbuitendraaiend' AS valuelist_2, 'L3' AS valuelist_3 UNION SELECT'Rechts buitendraaiend', 'rechtsbuitendraaiend', 'R4' ) buiten WHERE @isBinnen = false AND @isSet;	2,335836	0,000027
	Open connection with DB	2,335867	0,000031
	QUERY SYSCON END: SET @isBinnen = IF('{uitvoering}' ='Binnendraaiend', true,false); SET @isSet = IF('{uitvoering}' LIKE '{%}', false, true); SELECT * FROM ( SELECT 'Links binnendraaiend' AS valuelist_1, 'linksbinnendraaiend' AS valuelist_2, 'L1' AS valuelist_3 UNION SELECT'Rechts binnendraaiend', 'rechtsbinnendraaiend', 'R2' ) binnen WHERE @isBinnen AND @isSet UNION ALL SELECT * FROM ( SELECT 'Links buitendraaiend' AS valuelist_1, 'linksbuitendraaiend' AS valuelist_2, 'L3' AS valuelist_3 UNION SELECT'Rechts buitendraaiend', 'rechtsbuitendraaiend', 'R4' ) buiten WHERE @isBinnen = false AND @isSet;	2,353524	0,017657
	[RenderValues] Do last replacements. Num items: 0	2,353575	0,000051
	[RenderValues] replacements done	2,353584	0,000009
	RenderSubStep Kies een draairichting (binnen)_kopie connected to: draairichting - mainstepnumber: 2 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: draairichting	2,353648	0,000064
	No caching of lanuage 38. Because it is not changed within this session.	2,353996	0,000348
	Cache item 'ML_38' already exists, so language is not cached again	2,354033	0,000037
	Session 'MlJclLanguage' set to 38	2,354045	0,000012
	Start replace dynamic content	2,354084	0,000039
	Replace dynamic content only once	2,354175	0,000091
	End replace dynamic content	2,354186	0,000010
	Filled translationcomponent from cache.	2,354908	0,000722
	No caching of lanuage 38. Because it is not changed within this session.	2,399925	0,045017
	Cache item 'ML_38' already exists, so language is not cached again	2,400001	0,000076
	Session 'MlJclLanguage' set to 38	2,400014	0,000013
	Start replace dynamic content	2,400069	0,000055
	QUERY SYSCON START: SELECT * FROM easy_webpages WHERE id=64	2,419390	0,019321
	Open connection with DB	2,419445	0,000056
	QUERY SYSCON END: SELECT * FROM easy_webpages WHERE id=64	2,437899	0,018454
	Set SEO fields on webpage	2,437943	0,000045
	title: Welkom op mijn website	2,437959	0,000016
	metadescription: Vul hier de meta description in	2,437971	0,000012
	canonicalurl:	2,437979	0,000008
	noindex: False	2,437988	0,000009
	nofollow: False	2,437995	0,000007
	AddSEOFields: Title=Welkom op mijn website, Description=Vul hier de meta description in, Keywords=Vul hier de metatags in, CanonicalURL=, NoIndex=False, NoFollow=False, Robots=	2,438008	0,000014
	Trying to add meta data, but no header with runat='server' was found	2,438017	0,000009
	Start replace dynamic content	2,438082	0,000064
	Replace dynamic content only once	2,438196	0,000114
	End replace dynamic content	2,438204	0,000009
	Filled translationcomponent from cache.	2,438880	0,000675
	Start replace dynamic content	2,441587	0,002707
	End replace dynamic content	2,441777	0,000190
	Filled translationcomponent from cache.	2,442295	0,000518
	End replace dynamic content	2,472685	0,030390
	Filled translationcomponent from cache.	2,473369	0,000683
	[RenderValues] set query and/or replacements	2,505463	0,032094
	[RenderValues] Execute query	2,505920	0,000457
	query cachinghours: 200	2,506024	0,000105
	query from cache 'JCLDC2a8ee254c5365604b0b2bdf7a6987f6c'	2,506042	0,000017
	QUERY SYSCON END (FROM CACHE): SET @isBinnen = IF('{uitvoering}' ='Binnendraaiend', true,false); SET @isSet = IF('{uitvoering}' LIKE '{%}', false, true); SELECT * FROM ( SELECT 'Links binnendraaiend' AS valuelist_1, 'linksbinnendraaiend' AS valuelist_2, 'L1' AS valuelist_3 UNION SELECT'Rechts binnendraaiend', 'rechtsbinnendraaiend', 'R2' ) binnen WHERE @isBinnen AND @isSet UNION ALL SELECT * FROM ( SELECT 'Links buitendraaiend' AS valuelist_1, 'linksbuitendraaiend' AS valuelist_2, 'L3' AS valuelist_3 UNION SELECT'Rechts buitendraaiend', 'rechtsbuitendraaiend', 'R4' ) buiten WHERE @isBinnen = false AND @isSet;	2,506063	0,000021
	[RenderValues] Do last replacements. Num items: 0	2,506100	0,000037
	[RenderValues] replacements done	2,506106	0,000006
	RenderSubStep Kies een draairichting (binnen)_kopie connected to: draairichting - mainstepnumber: 2 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: draairichting	2,506120	0,000015
	No caching of lanuage 38. Because it is not changed within this session.	2,506395	0,000275
	Cache item 'ML_38' already exists, so language is not cached again	2,506414	0,000018
	Session 'MlJclLanguage' set to 38	2,506422	0,000009
	Start replace dynamic content	2,506451	0,000029
	Replace dynamic content only once	2,506530	0,000079
	End replace dynamic content	2,506537	0,000007
	Filled translationcomponent from cache.	2,506966	0,000429
	RenderStep Bepaal de afmeting connected to: deurtype - mainstepnumber: 2 - stepnumber: 2 - dependentvalue: 1 - datasource connectedid: deurtype	2,539245	0,032279
	[RenderValues] set query and/or replacements	2,539308	0,000064
	[RenderValues] Execute query	2,539709	0,000401
	query cachinghours: 200	2,539785	0,000076
	QUERY SYSCON START: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SELECT DISTINCT(door.height) AS hoogte, 0 AS isAllInclusive FROM shop_products door JOIN shop_pro_cat spc ON spc.product_id = door.id JOIN shop_category doorCat ON doorCat.id = spc.cat_id AND doorCat.parent_cat_id=2289 AND doorCat.id=@doorCat AND doorCat.visiblecando<>0 LEFT JOIN shop_products glass_org ON glass_org.id=@doorGlass LEFT JOIN shop_products glass_avail ON glass_avail.description_short=glass_org.description_short LEFT JOIN shop_koppeling k ON k.prod_dest=door.id AND k.prod_source=glass_avail.id WHERE IF(@doorGlass>0, k.id IS NOT NULL, 1) AND door.visiblecando<>0 ORDER BY door.height	2,539799	0,000014
	Open connection with DB	2,539828	0,000030
	QUERY SYSCON END: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SELECT DISTINCT(door.height) AS hoogte, 0 AS isAllInclusive FROM shop_products door JOIN shop_pro_cat spc ON spc.product_id = door.id JOIN shop_category doorCat ON doorCat.id = spc.cat_id AND doorCat.parent_cat_id=2289 AND doorCat.id=@doorCat AND doorCat.visiblecando<>0 LEFT JOIN shop_products glass_org ON glass_org.id=@doorGlass LEFT JOIN shop_products glass_avail ON glass_avail.description_short=glass_org.description_short LEFT JOIN shop_koppeling k ON k.prod_dest=door.id AND k.prod_source=glass_avail.id WHERE IF(@doorGlass>0, k.id IS NOT NULL, 1) AND door.visiblecando<>0 ORDER BY door.height	2,558670	0,018842
	[RenderValues] Do last replacements. Num items: 0	2,558714	0,000044
	[RenderValues] replacements done	2,558720	0,000006
	RenderStep (values rendered) Bepaal de afmeting connected to: deurtype - mainstepnumber: 2 - stepnumber: 2 - dependentvalue: 1 - datasource connectedid: deurtype	2,558754	0,000034
	[RenderValues] set query and/or replacements	2,558823	0,000070
	[RenderValues] Execute query	2,559207	0,000384
	query cachinghours: 200	2,559282	0,000075
	QUERY SYSCON START: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @turnType = IF('{draairichting}' IN ('R2/L3', 'L3', 'R2', 'links'), 'links', 'rechts'); SET @implementation = IF('{uitvoering}' IN('Buitendraaiend', 'Binnendraaiend', 'schuifdeur'), 'stomp', '{uitvoering}'); SET @implementation = IF(@implementation='opdek', CONCAT(@implementation, ' ', @turnType) , @implementation); SELECT DISTINCT(door.width) AS breedte FROM shop_products door JOIN shop_pro_cat spc ON spc.product_id = door.id JOIN shop_category doorCat ON doorCat.id=spc.cat_id AND doorCat.parent_cat_id=2289 AND doorCat.id=@doorCat AND doorCat.visiblecando<>0 LEFT JOIN shop_products glass_org ON glass_org.id=@doorGlass LEFT JOIN shop_products glass_avail ON glass_avail.description_short=glass_org.description_short AND glass_avail .visiblecando<>0 LEFT JOIN shop_koppeling k ON k.prod_dest=door.id AND k.prod_source=glass_avail.id WHERE (door.producttype = @implementation OR door.producttype = CONCAT(@implementation, ' ', @turnType)) AND door.height='{height}' #AND door.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', door.visiblecando, door.visiblecandoBranch) <> 0 AND IF(@doorGlass > 0, k.id IS NOT NULL, 1) ORDER BY door.width	2,559300	0,000018
	Open connection with DB	2,559359	0,000059
	QUERY SYSCON END: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @turnType = IF('{draairichting}' IN ('R2/L3', 'L3', 'R2', 'links'), 'links', 'rechts'); SET @implementation = IF('{uitvoering}' IN('Buitendraaiend', 'Binnendraaiend', 'schuifdeur'), 'stomp', '{uitvoering}'); SET @implementation = IF(@implementation='opdek', CONCAT(@implementation, ' ', @turnType) , @implementation); SELECT DISTINCT(door.width) AS breedte FROM shop_products door JOIN shop_pro_cat spc ON spc.product_id = door.id JOIN shop_category doorCat ON doorCat.id=spc.cat_id AND doorCat.parent_cat_id=2289 AND doorCat.id=@doorCat AND doorCat.visiblecando<>0 LEFT JOIN shop_products glass_org ON glass_org.id=@doorGlass LEFT JOIN shop_products glass_avail ON glass_avail.description_short=glass_org.description_short AND glass_avail .visiblecando<>0 LEFT JOIN shop_koppeling k ON k.prod_dest=door.id AND k.prod_source=glass_avail.id WHERE (door.producttype = @implementation OR door.producttype = CONCAT(@implementation, ' ', @turnType)) AND door.height='{height}' #AND door.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', door.visiblecando, door.visiblecandoBranch) <> 0 AND IF(@doorGlass > 0, k.id IS NOT NULL, 1) ORDER BY door.width	2,646836	0,087477
	[RenderValues] Do last replacements. Num items: 0	2,646882	0,000046
	[RenderValues] replacements done	2,646892	0,000010
	RenderSubStep Breedte_kopie connected to: hoogte - mainstepnumber: 2 - stepnumber: 2 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: hoogte	2,646932	0,000041
	No caching of lanuage 38. Because it is not changed within this session.	2,647169	0,000237
	Cache item 'ML_38' already exists, so language is not cached again	2,647181	0,000012
	Session 'MlJclLanguage' set to 38	2,647189	0,000008
	Start replace dynamic content	2,647222	0,000033
	Replace dynamic content only once	2,647279	0,000058
	End replace dynamic content	2,647286	0,000007
	Filled translationcomponent from cache.	2,647943	0,000656
	No caching of lanuage 38. Because it is not changed within this session.	2,677645	0,029702
	Cache item 'ML_38' already exists, so language is not cached again	2,677712	0,000067
	Session 'MlJclLanguage' set to 38	2,677720	0,000008
	Start replace dynamic content	2,677754	0,000034
	Replace dynamic content only once	2,677896	0,000142
	End replace dynamic content	2,677908	0,000012
	Filled translationcomponent from cache.	2,678561	0,000653
	[RenderValues] set query and/or replacements	2,705733	0,027172
	[RenderValues] Execute query	2,706289	0,000556
	query cachinghours: 200	2,706424	0,000136
	query from cache 'JCLDC0015ac3e0b58c863d35fc83966d4544d'	2,706437	0,000013
	QUERY SYSCON END (FROM CACHE): SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @turnType = IF('{draairichting}' IN ('R2/L3', 'L3', 'R2', 'links'), 'links', 'rechts'); SET @implementation = IF('{uitvoering}' IN('Buitendraaiend', 'Binnendraaiend', 'schuifdeur'), 'stomp', '{uitvoering}'); SET @implementation = IF(@implementation='opdek', CONCAT(@implementation, ' ', @turnType) , @implementation); SELECT DISTINCT(door.width) AS breedte FROM shop_products door JOIN shop_pro_cat spc ON spc.product_id = door.id JOIN shop_category doorCat ON doorCat.id=spc.cat_id AND doorCat.parent_cat_id=2289 AND doorCat.id=@doorCat AND doorCat.visiblecando<>0 LEFT JOIN shop_products glass_org ON glass_org.id=@doorGlass LEFT JOIN shop_products glass_avail ON glass_avail.description_short=glass_org.description_short AND glass_avail .visiblecando<>0 LEFT JOIN shop_koppeling k ON k.prod_dest=door.id AND k.prod_source=glass_avail.id WHERE (door.producttype = @implementation OR door.producttype = CONCAT(@implementation, ' ', @turnType)) AND door.height='{height}' #AND door.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', door.visiblecando, door.visiblecandoBranch) <> 0 AND IF(@doorGlass > 0, k.id IS NOT NULL, 1) ORDER BY door.width	2,706464	0,000027
	[RenderValues] Do last replacements. Num items: 0	2,706485	0,000021
	[RenderValues] replacements done	2,706495	0,000010
	RenderSubStep Breedte_kopie connected to: hoogte - mainstepnumber: 2 - stepnumber: 2 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: hoogte	2,706514	0,000019
	No caching of lanuage 38. Because it is not changed within this session.	2,706870	0,000357
	Cache item 'ML_38' already exists, so language is not cached again	2,706899	0,000029
	Session 'MlJclLanguage' set to 38	2,706909	0,000009
	Start replace dynamic content	2,706944	0,000035
	Replace dynamic content only once	2,707005	0,000061
	End replace dynamic content	2,707023	0,000019
	Filled translationcomponent from cache.	2,707614	0,000591
	QUERY SYSCON START: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	2,734946	0,027332
	Open connection with DB	2,735103	0,000157
	QUERY SYSCON END: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	2,767968	0,032865
	RenderStep Veiligheidspakket connected to: uitvoering;draairichting;hoogte;breedte; - mainstepnumber: 3 - stepnumber: 1 - dependentvalue: 1 - datasource connectedid: uitvoering;draairichting;hoogte;breedte;	2,770200	0,002232
	[RenderValues] set query and/or replacements	2,770243	0,000043
	[RenderValues] Execute query	2,770831	0,000588
	query cachinghours: 200	2,770942	0,000111
	QUERY SYSCON START: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @_height = IF('{height}' LIKE '{%}', '', '{height}'); SET @_width = IF('{width}' LIKE '{%}', '', '{width}'); SET @implementation = IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}'); SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', '{draairichting}','%'), CONCAT('%',@implementation,'%'))); SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1); SELECT @doorId, p.id AS product_id, p.eancode, p.description_short AS description_short, IFNULL(p.serie, p.producttype) AS name, REPLACE(REPLACE(p.priceCando, '.',','), ',00', ',-') AS price, spk.cat_id, sp.bestandsnaam, suitable_for, suitable_for2 FROM shop_products p JOIN shop_koppeling k ON k.prod_dest = @doorId AND k.prod_source = p.id AND k.koppeltype = 'veiligheidspakket' JOIN shop_pro_cat spk ON spk.product_id=p.id LEFT JOIN shop_pictures sp ON sp.product_id=p.id AND sp.formaatnaam='normaal' WHERE IFNULL(p.serie, p.producttype) = 'Veiligheidspakket' AND ( NULLIF(p.suitable_for2,'') IS NULL OR suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(@implementation, 'schuifdeur', 'schuif'), '%') ) AND # turntypes (suitable_for IS NULL OR suitable_for = 'ALLE' OR '{draairichting}' LIKE CONCAT('%', suitable_for , '%') OR ( (SELECT suitable_for FROM shop_products WHERE eancode = '{draairichting}') LIKE CONCAT('%', suitable_for , '%') ) ) #AND p.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblecando, p.visiblecandoBranch) <> 0 /* AND ( ( @_height > CAST(p.min_maat_h AS DECIMAL(15,2)) AND @_height < CAST(p.max_maat_h AS DECIMAL(15,2)) AND @_width > CAST(p.min_maat_b AS DECIMAL(15,2)) AND @_width < CAST(p.max_maat_b AS DECIMAL(15,2)) ) OR ( p.min_maat_h IS NULL OR p.min_maat_h = '' OR CAST(p.min_maat_h = '0' AS DECIMAL(15,2)) ) AND ( p.max_maat_h IS NULL OR p.max_maat_h = '' OR CAST(p.max_maat_h = '0' AS DECIMAL(15,2)) ) AND ( p.min_maat_b IS NULL OR p.min_maat_b = '' OR CAST(p.min_maat_b = '0' AS DECIMAL(15,2)) ) AND ( p.max_maat_b IS NULL OR p.max_maat_b = '' OR CAST(p.max_maat_b = '0' AS DECIMAL(15,2)) ) ) */ ORDER BY name	2,770971	0,000028
	Open connection with DB	2,771037	0,000066
	QUERY SYSCON END: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @_height = IF('{height}' LIKE '{%}', '', '{height}'); SET @_width = IF('{width}' LIKE '{%}', '', '{width}'); SET @implementation = IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}'); SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', '{draairichting}','%'), CONCAT('%',@implementation,'%'))); SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1); SELECT @doorId, p.id AS product_id, p.eancode, p.description_short AS description_short, IFNULL(p.serie, p.producttype) AS name, REPLACE(REPLACE(p.priceCando, '.',','), ',00', ',-') AS price, spk.cat_id, sp.bestandsnaam, suitable_for, suitable_for2 FROM shop_products p JOIN shop_koppeling k ON k.prod_dest = @doorId AND k.prod_source = p.id AND k.koppeltype = 'veiligheidspakket' JOIN shop_pro_cat spk ON spk.product_id=p.id LEFT JOIN shop_pictures sp ON sp.product_id=p.id AND sp.formaatnaam='normaal' WHERE IFNULL(p.serie, p.producttype) = 'Veiligheidspakket' AND ( NULLIF(p.suitable_for2,'') IS NULL OR suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(@implementation, 'schuifdeur', 'schuif'), '%') ) AND # turntypes (suitable_for IS NULL OR suitable_for = 'ALLE' OR '{draairichting}' LIKE CONCAT('%', suitable_for , '%') OR ( (SELECT suitable_for FROM shop_products WHERE eancode = '{draairichting}') LIKE CONCAT('%', suitable_for , '%') ) ) #AND p.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblecando, p.visiblecandoBranch) <> 0 /* AND ( ( @_height > CAST(p.min_maat_h AS DECIMAL(15,2)) AND @_height < CAST(p.max_maat_h AS DECIMAL(15,2)) AND @_width > CAST(p.min_maat_b AS DECIMAL(15,2)) AND @_width < CAST(p.max_maat_b AS DECIMAL(15,2)) ) OR ( p.min_maat_h IS NULL OR p.min_maat_h = '' OR CAST(p.min_maat_h = '0' AS DECIMAL(15,2)) ) AND ( p.max_maat_h IS NULL OR p.max_maat_h = '' OR CAST(p.max_maat_h = '0' AS DECIMAL(15,2)) ) AND ( p.min_maat_b IS NULL OR p.min_maat_b = '' OR CAST(p.min_maat_b = '0' AS DECIMAL(15,2)) ) AND ( p.max_maat_b IS NULL OR p.max_maat_b = '' OR CAST(p.max_maat_b = '0' AS DECIMAL(15,2)) ) ) */ ORDER BY name	2,795261	0,024224
	[RenderValues] Do last replacements. Num items: 0	2,795310	0,000049
	[RenderValues] replacements done	2,795343	0,000033
	RenderStep (values rendered) Veiligheidspakket connected to: uitvoering;draairichting;hoogte;breedte; - mainstepnumber: 3 - stepnumber: 1 - dependentvalue: 1 - datasource connectedid: uitvoering;draairichting;hoogte;breedte;	2,795382	0,000039
	[RenderValues] set query and/or replacements	2,795454	0,000072
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	2,795535	0,000080
	No caching of lanuage 38. Because it is not changed within this session.	2,795821	0,000287
	Cache item 'ML_38' already exists, so language is not cached again	2,795843	0,000021
	Session 'MlJclLanguage' set to 38	2,795857	0,000014
	Start replace dynamic content	2,795891	0,000034
	Replace dynamic content only once	2,795977	0,000086
	End replace dynamic content	2,795987	0,000011
	Filled translationcomponent from cache.	2,796692	0,000705
	No caching of lanuage 38. Because it is not changed within this session.	2,826928	0,030236
	Cache item 'ML_38' already exists, so language is not cached again	2,827027	0,000098
	Session 'MlJclLanguage' set to 38	2,827042	0,000015
	Start replace dynamic content	2,827085	0,000043
	Replace dynamic content only once	2,827184	0,000099
	End replace dynamic content	2,827194	0,000010
	Filled translationcomponent from cache.	2,827833	0,000639
	[RenderValues] set query and/or replacements	2,859624	0,031791
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	2,859705	0,000081
	No caching of lanuage 38. Because it is not changed within this session.	2,859919	0,000214
	Cache item 'ML_38' already exists, so language is not cached again	2,859947	0,000028
	Session 'MlJclLanguage' set to 38	2,859956	0,000009
	Start replace dynamic content	2,859981	0,000025
	Replace dynamic content only once	2,860072	0,000092
	End replace dynamic content	2,860083	0,000011
	Filled translationcomponent from cache.	2,860864	0,000781
	RenderStep Driepuntssluiting (alleen bij geen veiligheidspakket) connected to: veiligheidspakket;uitvoering;draairichting;hoogte;breedte - mainstepnumber: 3 - stepnumber: 2 - dependentvalue: 1 - datasource connectedid: veiligheidspakket;uitvoering;draairichting;hoogte;breedte	2,889399	0,028535
	[RenderValues] set query and/or replacements	2,889622	0,000223
	[RenderValues] Execute query	2,890061	0,000439
	query cachinghours: 200	2,890133	0,000072
	QUERY SYSCON START: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @implementation = IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}'); SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', '{draairichting}','%'), CONCAT('%',@implementation,'%'))); SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1); SET @isIndustrial = (SELECT IF(COUNT()>0,true,false) FROM shop_category WHERE id=@doorCat AND style LIKE '%industrial%'); SET @isDouble = IF('{dubbel}' = 'Ja', true, false); SET @results = false; SELECT FROM ( SELECT 'Geen driepuntsluiting' AS valuelist_1, 0 AS valuelist_2, 0 AS valuelist_3, 0 AS result UNION SELECT IF(p.serie LIKE '%sleutel%','Sleutelbediend','Krukbediend'), IF(p.serie LIKE '%sleutel%','sleutelbediend','krukbediend'), p.id, GREATEST(@results := true, -1) AS result FROM shop_products p JOIN shop_koppeling k ON k.prod_source=p.id AND k.prod_dest = @doorId AND k.koppeltype = 'Driepuntssluiting' WHERE ( NULLIF(p.suitable_for2,'') IS NULL OR suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(@implementation, 'schuifdeur', 'schuif'), '%') ) AND # turntypes (suitable_for IS NULL OR suitable_for = 'ALLE' OR REPLACE(REPLACE('{draairichting}', 'links', 'R2/L3'), 'rechts', 'L1/R4') LIKE CONCAT('%', suitable_for , '%') OR #inverted suitable_for LIKE CONCAT('%', REPLACE(REPLACE('{draairichting}', 'links', 'R2/L3'), 'rechts', 'L1/R4') , '%') OR ( (SELECT suitable_for FROM shop_products WHERE eancode = '{draairichting}') LIKE CONCAT('%', suitable_for , '%') ) ) #AND p.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblecando, p.visiblecandoBranch) <> 0 GROUP BY p.id ) res WHERE '{veiligheidspakketJanee}' = 'Nee' AND @results	2,890151	0,000018
	Open connection with DB	2,890215	0,000064
	QUERY SYSCON END: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @implementation = IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}'); SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', '{draairichting}','%'), CONCAT('%',@implementation,'%'))); SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1); SET @isIndustrial = (SELECT IF(COUNT()>0,true,false) FROM shop_category WHERE id=@doorCat AND style LIKE '%industrial%'); SET @isDouble = IF('{dubbel}' = 'Ja', true, false); SET @results = false; SELECT FROM ( SELECT 'Geen driepuntsluiting' AS valuelist_1, 0 AS valuelist_2, 0 AS valuelist_3, 0 AS result UNION SELECT IF(p.serie LIKE '%sleutel%','Sleutelbediend','Krukbediend'), IF(p.serie LIKE '%sleutel%','sleutelbediend','krukbediend'), p.id, GREATEST(@results := true, -1) AS result FROM shop_products p JOIN shop_koppeling k ON k.prod_source=p.id AND k.prod_dest = @doorId AND k.koppeltype = 'Driepuntssluiting' WHERE ( NULLIF(p.suitable_for2,'') IS NULL OR suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(@implementation, 'schuifdeur', 'schuif'), '%') ) AND # turntypes (suitable_for IS NULL OR suitable_for = 'ALLE' OR REPLACE(REPLACE('{draairichting}', 'links', 'R2/L3'), 'rechts', 'L1/R4') LIKE CONCAT('%', suitable_for , '%') OR #inverted suitable_for LIKE CONCAT('%', REPLACE(REPLACE('{draairichting}', 'links', 'R2/L3'), 'rechts', 'L1/R4') , '%') OR ( (SELECT suitable_for FROM shop_products WHERE eancode = '{draairichting}') LIKE CONCAT('%', suitable_for , '%') ) ) #AND p.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblecando, p.visiblecandoBranch) <> 0 GROUP BY p.id ) res WHERE '{veiligheidspakketJanee}' = 'Nee' AND @results	2,942770	0,052555
	[RenderValues] Do last replacements. Num items: 0	2,942842	0,000072
	[RenderValues] replacements done	2,942849	0,000007
	RenderStep (values rendered) Driepuntssluiting (alleen bij geen veiligheidspakket) connected to: veiligheidspakket;uitvoering;draairichting;hoogte;breedte - mainstepnumber: 3 - stepnumber: 2 - dependentvalue: 1 - datasource connectedid: veiligheidspakket;uitvoering;draairichting;hoogte;breedte	2,942883	0,000034
	[RenderValues] set query and/or replacements	2,942950	0,000067
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 2 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	2,942958	0,000008
	No caching of lanuage 38. Because it is not changed within this session.	2,943134	0,000176
	Cache item 'ML_38' already exists, so language is not cached again	2,943151	0,000017
	Session 'MlJclLanguage' set to 38	2,943159	0,000008
	Start replace dynamic content	2,943176	0,000017
	Replace dynamic content only once	2,943233	0,000057
	End replace dynamic content	2,943240	0,000007
	Filled translationcomponent from cache.	2,943916	0,000675
	No caching of lanuage 38. Because it is not changed within this session.	2,975893	0,031978
	Cache item 'ML_38' already exists, so language is not cached again	2,975982	0,000088
	Session 'MlJclLanguage' set to 38	2,975995	0,000013
	Start replace dynamic content	2,976035	0,000041
	Replace dynamic content only once	2,976143	0,000108
	End replace dynamic content	2,976153	0,000010
	Filled translationcomponent from cache.	2,976856	0,000702
	[RenderValues] set query and/or replacements	3,009726	0,032870
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 2 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	3,009799	0,000074
	No caching of lanuage 38. Because it is not changed within this session.	3,010036	0,000237
	Cache item 'ML_38' already exists, so language is not cached again	3,010070	0,000033
	Session 'MlJclLanguage' set to 38	3,010080	0,000010
	Start replace dynamic content	3,010110	0,000031
	Replace dynamic content only once	3,010254	0,000143
	End replace dynamic content	3,010261	0,000007
	Filled translationcomponent from cache.	3,010945	0,000684
	RenderStep Slotgatfrezing (bij geen driepuntsluiting) nieuw connected to: driepuntsluiting;veiligheidspakket;uitvoering;breedte;hoogte - mainstepnumber: 3 - stepnumber: 3 - dependentvalue: 1 - datasource connectedid: driepuntsluiting;veiligheidspakket;uitvoering;breedte;hoogte	3,040615	0,029670
	[RenderValues] set query and/or replacements	3,040674	0,000060
	[RenderValues] Execute query	3,041422	0,000747
	query cachinghours: 200	3,041533	0,000112
	QUERY SYSCON START: # Keep this query the same in ALL configurators for the "Accessoires" STEP!!! SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @implementation = IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}'); SET @turntype = IF('{draairichting}' LIKE '{%}', '','{draairichting}'); SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', @turntype,'%'), CONCAT('%',@implementation,'%'))); SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1); SET @isIndustrial = (SELECT IF(COUNT()>0,true,false) FROM shop_category WHERE id=@doorCat AND style LIKE '%industrial%'); SET @isDouble = IF('{dubbel}' = 'Ja', true, false); SELECT @doorId, IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%', '2x ','') AS ammountPrefix, IFNULL(info.html, '') AS info, p.id AS product_id, CONCAT(IF(@isDouble, ' ', ''), p.description_short) AS product_description, IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', ''))) AS product_name, REPLACE(REPLACE(p.pricecando IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%',2,1), '.',','), ',00', ',-') AS price, 'images/prod-scharnieren.png' AS product_image, spk.cat_id, IFNULL(sp.bestandsnaam, '') AS bestandsnaam, p.suitable_for, p.suitable_for2 FROM shop_products p JOIN shop_koppeling k ON k.prod_dest = @doorId AND k.prod_source = p.id AND k.koppeltype = 'service' JOIN shop_pro_cat spk ON spk.product_id=p.id #AND spk.cat_id IN(2386)# CAT (accessoires) LEFT JOIN easy_webpages info ON info.seoname = CONCAT('uitleg-', IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', '')))) LEFT JOIN shop_pictures sp ON sp.product_id=p.id AND sp.formaatnaam='normaal' WHERE (NULLIF(p.suitable_for2,'') IS NULL OR p.suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(LOWER(@implementation), 'schuifdeur', 'schuif'), '%') ) AND # turntypes (p.suitable_for IS NULL OR p.suitable_for = 'ALLE' OR REPLACE(REPLACE(@turntype, 'links', 'R2/L3'), 'rechts', 'L1/R4') LIKE CONCAT('%', p.suitable_for , '%') OR # reversed p.suitable_for LIKE CONCAT('%', REPLACE(REPLACE(@turntype, 'links', 'R2/L3'), 'rechts', 'L1/R4') , '%') OR ( (SELECT suitable_for FROM shop_products WHERE eancode = @turntype) LIKE CONCAT('%', p.suitable_for , '%') ) ) AND ('{driepuntssluiting}' = '0' OR '{driepuntssluiting}' LIKE '{%}') AND ('{veiligheidspakketJanee}' = 'Nee' OR '{veiligheidspakketJanee}' LIKE '{%}') AND p.producttype='slotgatfrezing' #AND p.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblecando, p.visiblecandoBranch) <> 0 GROUP BY p.id ORDER BY product_name	3,041556	0,000022
	Open connection with DB	3,041618	0,000062
	QUERY SYSCON END: # Keep this query the same in ALL configurators for the "Accessoires" STEP!!! SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @implementation = IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}'); SET @turntype = IF('{draairichting}' LIKE '{%}', '','{draairichting}'); SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', @turntype,'%'), CONCAT('%',@implementation,'%'))); SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1); SET @isIndustrial = (SELECT IF(COUNT()>0,true,false) FROM shop_category WHERE id=@doorCat AND style LIKE '%industrial%'); SET @isDouble = IF('{dubbel}' = 'Ja', true, false); SELECT @doorId, IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%', '2x ','') AS ammountPrefix, IFNULL(info.html, '') AS info, p.id AS product_id, CONCAT(IF(@isDouble, ' ', ''), p.description_short) AS product_description, IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', ''))) AS product_name, REPLACE(REPLACE(p.pricecando IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%',2,1), '.',','), ',00', ',-') AS price, 'images/prod-scharnieren.png' AS product_image, spk.cat_id, IFNULL(sp.bestandsnaam, '') AS bestandsnaam, p.suitable_for, p.suitable_for2 FROM shop_products p JOIN shop_koppeling k ON k.prod_dest = @doorId AND k.prod_source = p.id AND k.koppeltype = 'service' JOIN shop_pro_cat spk ON spk.product_id=p.id #AND spk.cat_id IN(2386)# CAT (accessoires) LEFT JOIN easy_webpages info ON info.seoname = CONCAT('uitleg-', IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', '')))) LEFT JOIN shop_pictures sp ON sp.product_id=p.id AND sp.formaatnaam='normaal' WHERE (NULLIF(p.suitable_for2,'') IS NULL OR p.suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(LOWER(@implementation), 'schuifdeur', 'schuif'), '%') ) AND # turntypes (p.suitable_for IS NULL OR p.suitable_for = 'ALLE' OR REPLACE(REPLACE(@turntype, 'links', 'R2/L3'), 'rechts', 'L1/R4') LIKE CONCAT('%', p.suitable_for , '%') OR # reversed p.suitable_for LIKE CONCAT('%', REPLACE(REPLACE(@turntype, 'links', 'R2/L3'), 'rechts', 'L1/R4') , '%') OR ( (SELECT suitable_for FROM shop_products WHERE eancode = @turntype) LIKE CONCAT('%', p.suitable_for , '%') ) ) AND ('{driepuntssluiting}' = '0' OR '{driepuntssluiting}' LIKE '{%}') AND ('{veiligheidspakketJanee}' = 'Nee' OR '{veiligheidspakketJanee}' LIKE '{%}') AND p.producttype='slotgatfrezing' #AND p.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblecando, p.visiblecandoBranch) <> 0 GROUP BY p.id ORDER BY product_name	3,063065	0,021448
	[RenderValues] Do last replacements. Num items: 0	3,063118	0,000052
	[RenderValues] replacements done	3,063124	0,000006
	RenderStep (values rendered) Slotgatfrezing (bij geen driepuntsluiting) nieuw connected to: driepuntsluiting;veiligheidspakket;uitvoering;breedte;hoogte - mainstepnumber: 3 - stepnumber: 3 - dependentvalue: 1 - datasource connectedid: driepuntsluiting;veiligheidspakket;uitvoering;breedte;hoogte	3,063159	0,000035
	[RenderValues] set query and/or replacements	3,063224	0,000065
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 3 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	3,063232	0,000009
	No caching of lanuage 38. Because it is not changed within this session.	3,063446	0,000214
	Cache item 'ML_38' already exists, so language is not cached again	3,063482	0,000035
	Session 'MlJclLanguage' set to 38	3,063494	0,000013
	Start replace dynamic content	3,063520	0,000026
	Replace dynamic content only once	3,063614	0,000094
	End replace dynamic content	3,063624	0,000010
	Filled translationcomponent from cache.	3,064119	0,000495
	No caching of lanuage 38. Because it is not changed within this session.	3,092108	0,027989
	Cache item 'ML_38' already exists, so language is not cached again	3,092183	0,000075
	Session 'MlJclLanguage' set to 38	3,092192	0,000010
	Start replace dynamic content	3,092225	0,000032
	Replace dynamic content only once	3,092298	0,000074
	End replace dynamic content	3,092307	0,000009
	Filled translationcomponent from cache.	3,092790	0,000483
	[RenderValues] set query and/or replacements	3,121423	0,028633
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 3 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	3,121492	0,000068
	No caching of lanuage 38. Because it is not changed within this session.	3,121723	0,000231
	Cache item 'ML_38' already exists, so language is not cached again	3,121757	0,000034
	Session 'MlJclLanguage' set to 38	3,121770	0,000013
	Start replace dynamic content	3,121803	0,000033
	Replace dynamic content only once	3,121881	0,000079
	End replace dynamic content	3,121888	0,000007
	Filled translationcomponent from cache.	3,122365	0,000477
	RenderStep Accessoires connected to: uitvoering;draairichting;hoogte;breedte - mainstepnumber: 3 - stepnumber: 4 - dependentvalue: 1 - datasource connectedid: uitvoering;draairichting;hoogte;breedte	3,148871	0,026506
	[RenderValues] set query and/or replacements	3,148937	0,000066
	[RenderValues] Execute query	3,149534	0,000597
	query cachinghours: 200	3,149643	0,000110
	QUERY SYSCON START: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @implementation = IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}'); SET @turntype = IF('{draairichting}' LIKE '{%}', '','{draairichting}'); SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', @turntype,'%'), CONCAT('%',@implementation,'%'))); SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1); SET @isIndustrial = (SELECT IF(COUNT()>0,true,false) FROM shop_category WHERE id=@doorCat AND style LIKE '%industrial%'); SET @isDouble = IF('{dubbel}' = 'Ja', true, false); SELECT @doorId, IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%', '2x ','') AS ammountPrefix, #IFNULL(info.html, '') AS info, p.usp_s AS info, p.id AS product_id, CONCAT(IF(@isDouble, ' ', ''), p.description_short) AS product_description, LOWER(IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', '')))) AS product_name, REPLACE(REPLACE(IFNULL(SUM(innerProducts.pricecando), p.pricecando) IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%',2,1), '.',','), ',00', ',-') AS price, 'images/prod-scharnieren.png' AS product_image, spk.cat_id, IFNULL(MIN(spi.bestandsnaam), sp.bestandsnaam) AS bestandsnaam, p.suitable_for, p.suitable_for2 FROM shop_products p JOIN shop_koppeling k ON k.prod_dest = @doorId AND k.prod_source = p.id AND k.koppeltype IN ('accessoire', 'accessoirepakket') JOIN shop_pro_cat spk ON spk.product_id=p.id #AND spk.cat_id IN(2386)# CAT (accessoires) LEFT JOIN easy_webpages info ON info.seoname = CONCAT('uitleg-', IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', '')))) LEFT JOIN shop_pictures sp ON sp.product_id=p.id AND sp.formaatnaam='normaal' LEFT JOIN shop_koppeling k2 ON k2.prod_dest = k.prod_source AND k2.koppeltype='accessoire' # schuifsysteem LEFT JOIN shop_products innerProducts ON innerProducts.id=k2.prod_source LEFT JOIN shop_pictures spi ON spi.product_id=innerProducts.id AND spi.formaatnaam='normaal' WHERE (NULLIF(p.suitable_for2,'') IS NULL OR p.suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(LOWER(@implementation), 'schuifdeur', 'schuif'), '%') ) AND # turntypes (p.suitable_for IS NULL OR p.suitable_for = 'ALLE' OR REPLACE(REPLACE(@turntype, 'links', 'R2/L3'), 'rechts', 'L1/R4') LIKE CONCAT('%', p.suitable_for , '%') OR ( (SELECT suitable_for FROM shop_products WHERE eancode = @turntype) LIKE CONCAT('%', p.suitable_for , '%') ) ) #AND p.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblecando, p.visiblecandoBranch) <> 0 GROUP BY p.id ORDER BY product_name	3,149666	0,000023
	Open connection with DB	3,149717	0,000051
	QUERY SYSCON END: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @implementation = IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}'); SET @turntype = IF('{draairichting}' LIKE '{%}', '','{draairichting}'); SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', @turntype,'%'), CONCAT('%',@implementation,'%'))); SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1); SET @isIndustrial = (SELECT IF(COUNT()>0,true,false) FROM shop_category WHERE id=@doorCat AND style LIKE '%industrial%'); SET @isDouble = IF('{dubbel}' = 'Ja', true, false); SELECT @doorId, IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%', '2x ','') AS ammountPrefix, #IFNULL(info.html, '') AS info, p.usp_s AS info, p.id AS product_id, CONCAT(IF(@isDouble, ' ', ''), p.description_short) AS product_description, LOWER(IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', '')))) AS product_name, REPLACE(REPLACE(IFNULL(SUM(innerProducts.pricecando), p.pricecando) IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%',2,1), '.',','), ',00', ',-') AS price, 'images/prod-scharnieren.png' AS product_image, spk.cat_id, IFNULL(MIN(spi.bestandsnaam), sp.bestandsnaam) AS bestandsnaam, p.suitable_for, p.suitable_for2 FROM shop_products p JOIN shop_koppeling k ON k.prod_dest = @doorId AND k.prod_source = p.id AND k.koppeltype IN ('accessoire', 'accessoirepakket') JOIN shop_pro_cat spk ON spk.product_id=p.id #AND spk.cat_id IN(2386)# CAT (accessoires) LEFT JOIN easy_webpages info ON info.seoname = CONCAT('uitleg-', IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', '')))) LEFT JOIN shop_pictures sp ON sp.product_id=p.id AND sp.formaatnaam='normaal' LEFT JOIN shop_koppeling k2 ON k2.prod_dest = k.prod_source AND k2.koppeltype='accessoire' # schuifsysteem LEFT JOIN shop_products innerProducts ON innerProducts.id=k2.prod_source LEFT JOIN shop_pictures spi ON spi.product_id=innerProducts.id AND spi.formaatnaam='normaal' WHERE (NULLIF(p.suitable_for2,'') IS NULL OR p.suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(LOWER(@implementation), 'schuifdeur', 'schuif'), '%') ) AND # turntypes (p.suitable_for IS NULL OR p.suitable_for = 'ALLE' OR REPLACE(REPLACE(@turntype, 'links', 'R2/L3'), 'rechts', 'L1/R4') LIKE CONCAT('%', p.suitable_for , '%') OR ( (SELECT suitable_for FROM shop_products WHERE eancode = @turntype) LIKE CONCAT('%', p.suitable_for , '%') ) ) #AND p.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblecando, p.visiblecandoBranch) <> 0 GROUP BY p.id ORDER BY product_name	3,173114	0,023396
	[RenderValues] Do last replacements. Num items: 0	3,173155	0,000041
	[RenderValues] replacements done	3,173161	0,000006
	RenderStep (values rendered) Accessoires connected to: uitvoering;draairichting;hoogte;breedte - mainstepnumber: 3 - stepnumber: 4 - dependentvalue: 1 - datasource connectedid: uitvoering;draairichting;hoogte;breedte	3,173195	0,000034
	[RenderValues] set query and/or replacements	3,173263	0,000068
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 4 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	3,173273	0,000010
	No caching of lanuage 38. Because it is not changed within this session.	3,173526	0,000253
	Cache item 'ML_38' already exists, so language is not cached again	3,173557	0,000031
	Session 'MlJclLanguage' set to 38	3,173569	0,000012
	Start replace dynamic content	3,173592	0,000023
	Replace dynamic content only once	3,173655	0,000063
	End replace dynamic content	3,173661	0,000006
	Filled translationcomponent from cache.	3,174166	0,000505
	No caching of lanuage 38. Because it is not changed within this session.	3,200342	0,026177
	Cache item 'ML_38' already exists, so language is not cached again	3,200427	0,000084
	Session 'MlJclLanguage' set to 38	3,200440	0,000013
	Start replace dynamic content	3,200490	0,000051
	Replace dynamic content only once	3,200586	0,000095
	End replace dynamic content	3,200593	0,000008
	Filled translationcomponent from cache.	3,201102	0,000509
	[RenderValues] set query and/or replacements	3,225454	0,024351
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 4 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	3,225517	0,000063
	No caching of lanuage 38. Because it is not changed within this session.	3,225709	0,000192
	Cache item 'ML_38' already exists, so language is not cached again	3,225739	0,000030
	Session 'MlJclLanguage' set to 38	3,225751	0,000012
	Start replace dynamic content	3,225779	0,000027
	Replace dynamic content only once	3,225873	0,000094
	End replace dynamic content	3,225883	0,000011
	Filled translationcomponent from cache.	3,226425	0,000542
	QUERY SYSCON START: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,257501	0,031077
	Open connection with DB	3,257643	0,000142
	QUERY SYSCON END: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,288842	0,031199
	QUERY SYSCON START: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,290211	0,001370
	Open connection with DB	3,290367	0,000155
	QUERY SYSCON END: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,321064	0,030697
	QUERY SYSCON START: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,322572	0,001509
	Open connection with DB	3,322744	0,000172
	QUERY SYSCON END: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,353343	0,030599
	QUERY SYSCON START: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,355226	0,001883
	Open connection with DB	3,355429	0,000203
	QUERY SYSCON END: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,385452	0,030023
	QUERY SYSCON START: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,386988	0,001537
	Open connection with DB	3,387124	0,000136
	QUERY SYSCON END: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,417199	0,030075
	No caching of lanuage 38. Because it is not changed within this session.	3,417915	0,000716
	Cache item 'ML_38' already exists, so language is not cached again	3,417969	0,000054
	Session 'MlJclLanguage' set to 38	3,417980	0,000011
	Start replace dynamic content	3,418520	0,000540
	Replace dynamic content only once	3,419803	0,001283
	End replace dynamic content	3,419847	0,000044
	Filled translationcomponent from cache.	3,420504	0,000657
	Start replacing system objects	3,456209	0,035706
	Start replacing translation	3,459899	0,003690
	Start replacing objects	3,460224	0,000325
	Start replacing request	3,460608	0,000384
	Start replacing session	3,572913	0,112306
	Start replacing standards	3,578639	0,005726
	Start replacing objecs again	3,579419	0,000780
aspx.page	End Render	3,591798	0,012379

Control Tree
Control UniqueID	Type	Render Size Bytes (including children)	ViewState Size Bytes (excluding children)	ControlState Size Bytes (excluding children)
__Page	ASP.homepage_aspx	110054	0	0
ctl00	System.Web.UI.HtmlControls.HtmlHead	774	0	0
ctl01	System.Web.UI.HtmlControls.HtmlMeta	24	0	0
ctl02	System.Web.UI.HtmlControls.HtmlMeta	70	0	0
ctl03	System.Web.UI.HtmlControls.HtmlMeta	45	0	0
LiteralTagmanagerCode	System.Web.UI.WebControls.Literal	60	0	0
ctl09	System.Web.UI.LiteralControl	82	0	0
ctl04	System.Web.UI.HtmlControls.HtmlTitle	51	0	0
ctl05	System.Web.UI.HtmlControls.HtmlGenericControl	68	0	0
ctl06	System.Web.UI.HtmlControls.HtmlGenericControl	130	0	0
ctl10	System.Web.UI.LiteralControl	113	0	0
ctl07	System.Web.UI.HtmlControls.HtmlLink	115	0	0
ctl08	System.Web.UI.HtmlControls.HtmlGenericControl	116	0	0
LoginC	JuiceControlLibrary.LoginControl	24	0	0

Session State
Session Key	Type	Value
JCLSEOURL	System.String
JCLSEOURLWQS	System.String
JCLSEOURLQS	System.String
JuiceControlCustId	System.Int32	290
MlJclLanguage	System.Int32	38

Application State
Application Key	Type	Value

Request Cookies Collection
Name	Value	Size

Response Cookies Collection
Name	Value	Size
ASP.NET_SessionId	lwlsbiyrhic1o2p2rdadpf20	42
CurrentDomain	hubo.cando.eu	27

Headers Collection
Name	Value
Connection	close
Content-Length	0
Accept	/
Accept-Encoding	gzip, br, zstd, deflate
Host	hubo.cando.eu
User-Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)

Response Headers Collection
Name	Value
Cache-Control	private
Content-Type	text/html

Form Collection
Name	Value

Querystring Collection
Name	Value
configurator	achterdeuren

Server Variables
Name	Value
ALL_HTTP	HTTP_CONNECTION:close HTTP_CONTENT_LENGTH:0 HTTP_ACCEPT:/ HTTP_ACCEPT_ENCODING:gzip, br, zstd, deflate HTTP_HOST:hubo.cando.eu HTTP_USER_AGENT:Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
ALL_RAW	Connection: close Content-Length: 0 Accept: / Accept-Encoding: gzip, br, zstd, deflate Host: hubo.cando.eu User-Agent: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
APPL_MD_PATH	/LM/W3SVC/1/ROOT
APPL_PHYSICAL_PATH	C:\inetpub\wwwroot\configurator-cando - LIVE\
AUTH_TYPE
AUTH_USER
AUTH_PASSWORD
LOGON_USER
REMOTE_USER
CERT_COOKIE
CERT_FLAGS
CERT_ISSUER
CERT_KEYSIZE	256
CERT_SECRETKEYSIZE	2048
CERT_SERIALNUMBER
CERT_SERVER_ISSUER	C=NL, O=Trust Provider B.V., CN=Trust Provider B.V. TLS RSA EV CA G2
CERT_SERVER_SUBJECT	C=NL, L=Gorinchem, O=Deli Home Products B.V., CN=*.cando.eu
CERT_SUBJECT
CONTENT_LENGTH	0
CONTENT_TYPE
GATEWAY_INTERFACE	CGI/1.1
HTTPS	on
HTTPS_KEYSIZE	256
HTTPS_SECRETKEYSIZE	2048
HTTPS_SERVER_ISSUER	C=NL, O=Trust Provider B.V., CN=Trust Provider B.V. TLS RSA EV CA G2
HTTPS_SERVER_SUBJECT	C=NL, L=Gorinchem, O=Deli Home Products B.V., CN=*.cando.eu
INSTANCE_ID	1
INSTANCE_META_PATH	/LM/W3SVC/1
LOCAL_ADDR	136.144.214.155
PATH_INFO	/homepage.aspx
PATH_TRANSLATED	C:\inetpub\wwwroot\configurator-cando - LIVE\homepage.aspx
QUERY_STRING	configurator=achterdeuren
REMOTE_ADDR	89.41.168.7
REMOTE_HOST	89.41.168.7
REMOTE_PORT	33644
REQUEST_METHOD	GET
SCRIPT_NAME	/homepage.aspx
SERVER_NAME	hubo.cando.eu
SERVER_PORT	443
SERVER_PORT_SECURE	1
SERVER_PROTOCOL	HTTP/1.1
SERVER_SOFTWARE	Microsoft-IIS/10.0
URL	/homepage.aspx
HTTP_CONNECTION	close
HTTP_CONTENT_LENGTH	0
HTTP_ACCEPT	/
HTTP_ACCEPT_ENCODING	gzip, br, zstd, deflate
HTTP_HOST	hubo.cando.eu
HTTP_USER_AGENT	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)

Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.7.4136.0

Kies uw achterdeur

ML 827 met blank glas

ML 827 zonder glas

ML 840 zonder glas

ML 840 met blank glas

ML 866 zonder glas

ML 866 met blank glas

ML 892 zonder glas

ML 892 met blank glas

ML 733

ML 627 zonder glas

ML 627 met plakroedes 8-ruits

ML 627 met Blank glas

ML 629 met Blank glas

ML 629 zonder glas

ML 630 met Blank glas

ML 630 met Plakroede

ML 630 zonder glas

ML 640 met Plakroede

ML 640 zonder glas

ML 640 met Blank glas

ML 666 met Blank glas

ML 666 met Plakroede

ML 666 zonder glas

ML 692 met Blank glas

ML 692 met Plakroede

ML 692 zonder glas

ML 457 met Draadglas

ML 457 zonder glas

ML 459 zonder glas

ML 459 met Draadglas

ML 465

ML 470

ML 480

Bepaal de juiste maat

Accessoires

Controleer je bestelling

Mail deze configuratie naar mijn mailadres

Bewaar deze configuratie

Voeg configuratie toe aan uw winkelwagen op uw mobiel

Request Details

Trace Information

Control Tree

Session State

Application State

Request Cookies Collection

Response Cookies Collection

Headers Collection

Response Headers Collection

Form Collection

Querystring Collection

Server Variables