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 Plaats in winkelwagen 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:	0dxjtapmu1mbfkkwxg4m4sx1	Request Type:	GET
Time of Request:	17-3-2026 14:18:35	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,000035	0,000035
aspx.page	Begin Init	0,000048	0,000013
	LoginControl_Init - isValidForThisDomain: True	0,000219	0,000171
	LoginControl - SetupWebsite - proceed: True, GoAnCode: , TagManagerId:	0,000347	0,000127
	This is page: homepage.aspx. With masterpagefile:	0,000587	0,000241
	CSS template IDs found:	0,000885	0,000298
	End load CSS from Wiser...	0,000908	0,000023
	JS template IDs found:	0,001224	0,000317
	NO JS template inline found	0,001237	0,000013
	End load JS from Wiser...	0,001250	0,000013
aspx.page	End Init	0,001301	0,000051
aspx.page	Begin InitComplete	0,001312	0,000011
aspx.page	End InitComplete	0,001323	0,000011
aspx.page	Begin PreLoad	0,001334	0,000010
aspx.page	End PreLoad	0,001347	0,000013
aspx.page	Begin Load	0,001357	0,000010
aspx.page	End Load	0,001394	0,000037
aspx.page	Begin LoadComplete	0,001405	0,000011
aspx.page	End LoadComplete	0,001416	0,000012
aspx.page	Begin PreRender	0,001428	0,000012
aspx.page	End PreRender	0,001498	0,000070
aspx.page	Begin PreRenderComplete	0,001511	0,000012
aspx.page	End PreRenderComplete	0,001521	0,000010
aspx.page	Begin SaveState	0,001750	0,000229
aspx.page	End SaveState	0,001760	0,000011
aspx.page	Begin SaveStateComplete	0,001771	0,000010
aspx.page	End SaveStateComplete	0,001781	0,000010
aspx.page	Begin Render	0,001791	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,014285	0,012494
	Open connection with DB	0,014477	0,000192
	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,153000	0,138524
	RenderStep Kies uw buitendeur connected to: 2289 - mainstepnumber: 1 - stepnumber: 1 - dependentvalue: 2289 - datasource connectedid: 2289	0,211725	0,058724
	[RenderValues] set query and/or replacements	0,213937	0,002212
	[RenderValues] Execute query	0,233330	0,019393
	query cachinghours: 200	0,233751	0,000421
	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.pricepraxis) AS door_price, glass.pricepraxis AS glass_price, REPLACE(TRUNCATE(MIN(door.pricepraxis) + IFNULL(glass.pricepraxis,0) + IFNULL(mounting_package.pricepraxis,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.visiblepraxis, door.visiblepraxisBranch) <> 0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', doorCat.visiblepraxis, doorCat.visiblepraxisBranch) <> 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.visiblepraxis <> 0) GROUP BY `name` ORDER BY doorCat.sequence	0,233831	0,000079
	Open connection with DB	0,233911	0,000080
	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.pricepraxis) AS door_price, glass.pricepraxis AS glass_price, REPLACE(TRUNCATE(MIN(door.pricepraxis) + IFNULL(glass.pricepraxis,0) + IFNULL(mounting_package.pricepraxis,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.visiblepraxis, door.visiblepraxisBranch) <> 0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', doorCat.visiblepraxis, doorCat.visiblepraxisBranch) <> 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.visiblepraxis <> 0) GROUP BY `name` ORDER BY doorCat.sequence	0,446296	0,212385
	[RenderValues] Do last replacements. Num items: 33	0,446329	0,000033
	[RenderValues] replacements done	0,962196	0,515867
	RenderStep (values rendered) Kies uw buitendeur connected to: 2289 - mainstepnumber: 1 - stepnumber: 1 - dependentvalue: 2289 - datasource connectedid: 2289	0,964485	0,002289
	[RenderValues] set query and/or replacements	0,967311	0,002827
	RenderSubStep connected to: - mainstepnumber: 1 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	0,967354	0,000043
	Language 38 is new	0,969188	0,001834
	Caching of languagewords in cache is starting because 'ML_38' is empty	0,969239	0,000051
	QUERY SYSCON START: SELECT fieldname, translation FROM site_languagefields WHERE languageid = ?languageId GROUP BY fieldname	0,969535	0,000296
	Open connection with DB	0,969554	0,000019
	QUERY SYSCON END: SELECT fieldname, translation FROM site_languagefields WHERE languageid = ?languageId GROUP BY fieldname	0,986971	0,017417
	0 woorden gecached voor key 'ML_38'	0,987074	0,000103
	Session 'MlJclLanguage' set to 38	0,987093	0,000019
	Start replace dynamic content	0,991258	0,004165
	Replace dynamic content only once	0,991403	0,000145
	End replace dynamic content	0,991412	0,000008
	Filled translationcomponent from cache.	0,991883	0,000471
	No caching of lanuage 38. Because it is not changed within this session.	1,067850	0,075968
	Cache item 'ML_38' already exists, so language is not cached again	1,067930	0,000080
	Session 'MlJclLanguage' set to 38	1,067939	0,000010
	Start replace dynamic content	1,068398	0,000459
	Replace dynamic content only once	1,069381	0,000983
	End replace dynamic content	1,069399	0,000019
	Filled translationcomponent from cache.	1,069900	0,000500
	Start replacing system objects	1,096292	0,026392
	Start replacing translation	1,097419	0,001127
	Start replacing objects	1,097702	0,000284
	Start replacing request	1,098067	0,000365
	Start replacing session	1,140630	0,042563
	Start replacing standards	1,159397	0,018767
	Start replacing objecs again	1,160048	0,000651
	[RenderValues] set query and/or replacements	1,302876	0,142828
	RenderSubStep connected to: - mainstepnumber: 1 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	1,302961	0,000086
	No caching of lanuage 38. Because it is not changed within this session.	1,303236	0,000275
	Cache item 'ML_38' already exists, so language is not cached again	1,303278	0,000042
	Session 'MlJclLanguage' set to 38	1,303292	0,000014
	Start replace dynamic content	1,303319	0,000027
	Replace dynamic content only once	1,303426	0,000108
	End replace dynamic content	1,303440	0,000014
	Filled translationcomponent from cache.	1,304102	0,000662
	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	1,349648	0,045546
	Open connection with DB	1,349864	0,000216
	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	1,389486	0,039623
	RenderStep Binnendraaiend connected to: binnendeuren deurtype - mainstepnumber: 2 - stepnumber: 1 - dependentvalue: 1 - datasource connectedid: binnendeuren - deurtype	1,396918	0,007432
	[RenderValues] set query and/or replacements	1,396974	0,000056
	RenderStep (values rendered) Binnendraaiend connected to: binnendeuren deurtype - mainstepnumber: 2 - stepnumber: 1 - dependentvalue: 1 - datasource connectedid: binnendeuren - deurtype	1,397025	0,000051
	[RenderValues] set query and/or replacements	1,397071	0,000046
	[RenderValues] Execute query	1,397403	0,000332
	query cachinghours: 200	1,397507	0,000104
	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;	1,397533	0,000026
	Open connection with DB	1,397558	0,000025
	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;	1,417325	0,019767
	[RenderValues] Do last replacements. Num items: 0	1,417370	0,000045
	[RenderValues] replacements done	1,417379	0,000010
	RenderSubStep Kies een draairichting (binnen)_kopie connected to: draairichting - mainstepnumber: 2 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: draairichting	1,417439	0,000060
	No caching of lanuage 38. Because it is not changed within this session.	1,417786	0,000347
	Cache item 'ML_38' already exists, so language is not cached again	1,417814	0,000028
	Session 'MlJclLanguage' set to 38	1,417835	0,000021
	Start replace dynamic content	1,417874	0,000039
	Replace dynamic content only once	1,417983	0,000109
	End replace dynamic content	1,417997	0,000014
	Filled translationcomponent from cache.	1,418599	0,000602
	No caching of lanuage 38. Because it is not changed within this session.	1,454048	0,035449
	Cache item 'ML_38' already exists, so language is not cached again	1,454123	0,000075
	Session 'MlJclLanguage' set to 38	1,454138	0,000015
	Start replace dynamic content	1,454194	0,000056
	QUERY SYSCON START: SELECT * FROM easy_webpages WHERE id=64	1,470383	0,016188
	Open connection with DB	1,470432	0,000050
	QUERY SYSCON END: SELECT * FROM easy_webpages WHERE id=64	1,488829	0,018397
	Set SEO fields on webpage	1,488872	0,000043
	title: Welkom op mijn website	1,488923	0,000051
	metadescription: Vul hier de meta description in	1,488936	0,000013
	canonicalurl:	1,488946	0,000010
	noindex: False	1,488958	0,000013
	nofollow: False	1,488968	0,000010
	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=	1,488985	0,000017
	Trying to add meta data, but no header with runat='server' was found	1,488994	0,000009
	Start replace dynamic content	1,489049	0,000055
	Replace dynamic content only once	1,489182	0,000133
	End replace dynamic content	1,489196	0,000014
	Filled translationcomponent from cache.	1,489830	0,000634
	Start replace dynamic content	1,492724	0,002894
	End replace dynamic content	1,492912	0,000188
	Filled translationcomponent from cache.	1,493534	0,000622
	End replace dynamic content	1,525875	0,032341
	Filled translationcomponent from cache.	1,526694	0,000819
	[RenderValues] set query and/or replacements	1,559654	0,032960
	[RenderValues] Execute query	1,560091	0,000438
	query cachinghours: 200	1,560184	0,000093
	query from cache 'JCLDC2a8ee254c5365604b0b2bdf7a6987f6c'	1,560205	0,000021
	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;	1,560244	0,000039
	[RenderValues] Do last replacements. Num items: 0	1,560310	0,000066
	[RenderValues] replacements done	1,560320	0,000010
	RenderSubStep Kies een draairichting (binnen)_kopie connected to: draairichting - mainstepnumber: 2 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: draairichting	1,560343	0,000023
	No caching of lanuage 38. Because it is not changed within this session.	1,560634	0,000291
	Cache item 'ML_38' already exists, so language is not cached again	1,560654	0,000020
	Session 'MlJclLanguage' set to 38	1,560683	0,000029
	Start replace dynamic content	1,560714	0,000031
	Replace dynamic content only once	1,560795	0,000082
	End replace dynamic content	1,560815	0,000020
	Filled translationcomponent from cache.	1,561459	0,000644
	RenderStep Bepaal de afmeting connected to: deurtype - mainstepnumber: 2 - stepnumber: 2 - dependentvalue: 1 - datasource connectedid: deurtype	1,593601	0,032142
	[RenderValues] set query and/or replacements	1,593659	0,000058
	[RenderValues] Execute query	1,594137	0,000478
	query cachinghours: 200	1,594238	0,000101
	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.visiblepraxis<>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.visiblepraxis<>0 ORDER BY door.height	1,594261	0,000024
	Open connection with DB	1,594291	0,000029
	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.visiblepraxis<>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.visiblepraxis<>0 ORDER BY door.height	1,639734	0,045443
	[RenderValues] Do last replacements. Num items: 0	1,639780	0,000046
	[RenderValues] replacements done	1,639786	0,000006
	RenderStep (values rendered) Bepaal de afmeting connected to: deurtype - mainstepnumber: 2 - stepnumber: 2 - dependentvalue: 1 - datasource connectedid: deurtype	1,639816	0,000029
	[RenderValues] set query and/or replacements	1,639870	0,000054
	[RenderValues] Execute query	1,640258	0,000388
	query cachinghours: 200	1,640320	0,000062
	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.visiblepraxis<>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 .visiblepraxis<>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.visiblepraxis<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', door.visiblepraxis, door.visiblepraxisBranch) <> 0 AND IF(@doorGlass > 0, k.id IS NOT NULL, 1) ORDER BY door.width	1,640338	0,000019
	Open connection with DB	1,640370	0,000032
	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.visiblepraxis<>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 .visiblepraxis<>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.visiblepraxis<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', door.visiblepraxis, door.visiblepraxisBranch) <> 0 AND IF(@doorGlass > 0, k.id IS NOT NULL, 1) ORDER BY door.width	1,665723	0,025353
	[RenderValues] Do last replacements. Num items: 0	1,665770	0,000047
	[RenderValues] replacements done	1,665776	0,000006
	RenderSubStep Breedte_kopie connected to: hoogte - mainstepnumber: 2 - stepnumber: 2 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: hoogte	1,665804	0,000029
	No caching of lanuage 38. Because it is not changed within this session.	1,666081	0,000277
	Cache item 'ML_38' already exists, so language is not cached again	1,666105	0,000024
	Session 'MlJclLanguage' set to 38	1,666114	0,000009
	Start replace dynamic content	1,666147	0,000032
	Replace dynamic content only once	1,666233	0,000086
	End replace dynamic content	1,666243	0,000010
	Filled translationcomponent from cache.	1,666711	0,000468
	No caching of lanuage 38. Because it is not changed within this session.	1,693074	0,026363
	Cache item 'ML_38' already exists, so language is not cached again	1,693133	0,000058
	Session 'MlJclLanguage' set to 38	1,693141	0,000008
	Start replace dynamic content	1,693170	0,000029
	Replace dynamic content only once	1,693248	0,000078
	End replace dynamic content	1,693255	0,000007
	Filled translationcomponent from cache.	1,693699	0,000444
	[RenderValues] set query and/or replacements	1,716396	0,022697
	[RenderValues] Execute query	1,716871	0,000475
	query cachinghours: 200	1,716958	0,000088
	query from cache 'JCLDC824d2f766cc06bc2f8f64a4c3cf64ea6'	1,716979	0,000021
	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.visiblepraxis<>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 .visiblepraxis<>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.visiblepraxis<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', door.visiblepraxis, door.visiblepraxisBranch) <> 0 AND IF(@doorGlass > 0, k.id IS NOT NULL, 1) ORDER BY door.width	1,716994	0,000015
	[RenderValues] Do last replacements. Num items: 0	1,717010	0,000016
	[RenderValues] replacements done	1,717018	0,000008
	RenderSubStep Breedte_kopie connected to: hoogte - mainstepnumber: 2 - stepnumber: 2 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: hoogte	1,717031	0,000014
	No caching of lanuage 38. Because it is not changed within this session.	1,717283	0,000251
	Cache item 'ML_38' already exists, so language is not cached again	1,717298	0,000015
	Session 'MlJclLanguage' set to 38	1,717308	0,000010
	Start replace dynamic content	1,717334	0,000026
	Replace dynamic content only once	1,717401	0,000066
	End replace dynamic content	1,717409	0,000008
	Filled translationcomponent from cache.	1,717957	0,000548
	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	1,742721	0,024764
	Open connection with DB	1,742896	0,000175
	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	1,775335	0,032440
	RenderStep Veiligheidspakket connected to: uitvoering;draairichting;hoogte;breedte; - mainstepnumber: 3 - stepnumber: 1 - dependentvalue: 1 - datasource connectedid: uitvoering;draairichting;hoogte;breedte;	1,777407	0,002072
	[RenderValues] set query and/or replacements	1,777455	0,000047
	[RenderValues] Execute query	1,777960	0,000506
	query cachinghours: 200	1,778068	0,000107
	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.visiblepraxis<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblepraxis, p.visiblepraxisBranch) <> 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	1,778100	0,000033
	Open connection with DB	1,778169	0,000068
	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.visiblepraxis<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblepraxis, p.visiblepraxisBranch) <> 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	1,798298	0,020129
	[RenderValues] Do last replacements. Num items: 0	1,798348	0,000050
	[RenderValues] replacements done	1,798358	0,000010
	RenderStep (values rendered) Veiligheidspakket connected to: uitvoering;draairichting;hoogte;breedte; - mainstepnumber: 3 - stepnumber: 1 - dependentvalue: 1 - datasource connectedid: uitvoering;draairichting;hoogte;breedte;	1,798401	0,000044
	[RenderValues] set query and/or replacements	1,798483	0,000081
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	1,798503	0,000020
	No caching of lanuage 38. Because it is not changed within this session.	1,798791	0,000288
	Cache item 'ML_38' already exists, so language is not cached again	1,798809	0,000018
	Session 'MlJclLanguage' set to 38	1,798822	0,000013
	Start replace dynamic content	1,798846	0,000025
	Replace dynamic content only once	1,798989	0,000143
	End replace dynamic content	1,799002	0,000013
	Filled translationcomponent from cache.	1,799633	0,000631
	No caching of lanuage 38. Because it is not changed within this session.	1,825002	0,025369
	Cache item 'ML_38' already exists, so language is not cached again	1,825059	0,000057
	Session 'MlJclLanguage' set to 38	1,825080	0,000021
	Start replace dynamic content	1,825109	0,000029
	Replace dynamic content only once	1,825182	0,000074
	End replace dynamic content	1,825189	0,000007
	Filled translationcomponent from cache.	1,825606	0,000417
	[RenderValues] set query and/or replacements	1,848290	0,022684
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	1,848338	0,000048
	No caching of lanuage 38. Because it is not changed within this session.	1,848523	0,000185
	Cache item 'ML_38' already exists, so language is not cached again	1,848550	0,000027
	Session 'MlJclLanguage' set to 38	1,848558	0,000008
	Start replace dynamic content	1,848573	0,000015
	Replace dynamic content only once	1,848651	0,000078
	End replace dynamic content	1,848658	0,000007
	Filled translationcomponent from cache.	1,849105	0,000447
	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	1,871607	0,022502
	[RenderValues] set query and/or replacements	1,871655	0,000048
	[RenderValues] Execute query	1,872139	0,000483
	query cachinghours: 200	1,872212	0,000073
	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.visiblepraxis<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblepraxis, p.visiblepraxisBranch) <> 0 GROUP BY p.id ) res WHERE '{veiligheidspakketJanee}' = 'Nee' AND @results	1,872236	0,000025
	Open connection with DB	1,872274	0,000038
	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.visiblepraxis<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblepraxis, p.visiblepraxisBranch) <> 0 GROUP BY p.id ) res WHERE '{veiligheidspakketJanee}' = 'Nee' AND @results	1,908219	0,035945
	[RenderValues] Do last replacements. Num items: 0	1,908279	0,000060
	[RenderValues] replacements done	1,908285	0,000006
	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	1,908317	0,000032
	[RenderValues] set query and/or replacements	1,908375	0,000058
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 2 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	1,908384	0,000009
	No caching of lanuage 38. Because it is not changed within this session.	1,908567	0,000184
	Cache item 'ML_38' already exists, so language is not cached again	1,908580	0,000013
	Session 'MlJclLanguage' set to 38	1,908588	0,000008
	Start replace dynamic content	1,908605	0,000017
	Replace dynamic content only once	1,908685	0,000080
	End replace dynamic content	1,908693	0,000008
	Filled translationcomponent from cache.	1,909180	0,000487
	No caching of lanuage 38. Because it is not changed within this session.	1,932472	0,023292
	Cache item 'ML_38' already exists, so language is not cached again	1,932533	0,000061
	Session 'MlJclLanguage' set to 38	1,932541	0,000009
	Start replace dynamic content	1,932579	0,000038
	Replace dynamic content only once	1,932652	0,000072
	End replace dynamic content	1,932658	0,000007
	Filled translationcomponent from cache.	1,933163	0,000505
	[RenderValues] set query and/or replacements	1,955594	0,022431
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 2 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	1,955645	0,000051
	No caching of lanuage 38. Because it is not changed within this session.	1,955912	0,000267
	Cache item 'ML_38' already exists, so language is not cached again	1,955946	0,000034
	Session 'MlJclLanguage' set to 38	1,955968	0,000022
	Start replace dynamic content	1,955993	0,000025
	Replace dynamic content only once	1,956122	0,000129
	End replace dynamic content	1,956131	0,000009
	Filled translationcomponent from cache.	1,956569	0,000438
	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	1,982543	0,025974
	[RenderValues] set query and/or replacements	1,982603	0,000061
	[RenderValues] Execute query	1,983222	0,000618
	query cachinghours: 200	1,983347	0,000125
	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.pricepraxis 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.visiblepraxis<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblepraxis, p.visiblepraxisBranch) <> 0 GROUP BY p.id ORDER BY product_name	1,983375	0,000028
	Open connection with DB	1,983437	0,000063
	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.pricepraxis 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.visiblepraxis<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblepraxis, p.visiblepraxisBranch) <> 0 GROUP BY p.id ORDER BY product_name	2,010489	0,027052
	[RenderValues] Do last replacements. Num items: 0	2,010538	0,000049
	[RenderValues] replacements done	2,010547	0,000009
	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	2,010591	0,000044
	[RenderValues] set query and/or replacements	2,010681	0,000091
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 3 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	2,010701	0,000019
	No caching of lanuage 38. Because it is not changed within this session.	2,010966	0,000266
	Cache item 'ML_38' already exists, so language is not cached again	2,011002	0,000036
	Session 'MlJclLanguage' set to 38	2,011015	0,000013
	Start replace dynamic content	2,011045	0,000030
	Replace dynamic content only once	2,011127	0,000081
	End replace dynamic content	2,011138	0,000011
	Filled translationcomponent from cache.	2,011765	0,000627
	No caching of lanuage 38. Because it is not changed within this session.	2,039081	0,027316
	Cache item 'ML_38' already exists, so language is not cached again	2,039150	0,000069
	Session 'MlJclLanguage' set to 38	2,039159	0,000009
	Start replace dynamic content	2,039191	0,000032
	Replace dynamic content only once	2,039266	0,000075
	End replace dynamic content	2,039272	0,000007
	Filled translationcomponent from cache.	2,039781	0,000509
	[RenderValues] set query and/or replacements	2,067943	0,028161
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 3 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	2,068006	0,000064
	No caching of lanuage 38. Because it is not changed within this session.	2,068270	0,000264
	Cache item 'ML_38' already exists, so language is not cached again	2,068307	0,000037
	Session 'MlJclLanguage' set to 38	2,068324	0,000017
	Start replace dynamic content	2,068351	0,000026
	Replace dynamic content only once	2,068467	0,000117
	End replace dynamic content	2,068480	0,000013
	Filled translationcomponent from cache.	2,069156	0,000676
	RenderStep Accessoires connected to: uitvoering;draairichting;hoogte;breedte - mainstepnumber: 3 - stepnumber: 4 - dependentvalue: 1 - datasource connectedid: uitvoering;draairichting;hoogte;breedte	2,094708	0,025552
	[RenderValues] set query and/or replacements	2,094768	0,000059
	[RenderValues] Execute query	2,095301	0,000533
	query cachinghours: 200	2,095383	0,000083
	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.pricepraxis), p.pricepraxis) 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.visiblepraxis<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblepraxis, p.visiblepraxisBranch) <> 0 GROUP BY p.id ORDER BY product_name	2,095430	0,000047
	Open connection with DB	2,095505	0,000075
	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.pricepraxis), p.pricepraxis) 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.visiblepraxis<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblepraxis, p.visiblepraxisBranch) <> 0 GROUP BY p.id ORDER BY product_name	2,253902	0,158398
	[RenderValues] Do last replacements. Num items: 0	2,253951	0,000049
	[RenderValues] replacements done	2,253961	0,000010
	RenderStep (values rendered) Accessoires connected to: uitvoering;draairichting;hoogte;breedte - mainstepnumber: 3 - stepnumber: 4 - dependentvalue: 1 - datasource connectedid: uitvoering;draairichting;hoogte;breedte	2,254001	0,000040
	[RenderValues] set query and/or replacements	2,254066	0,000065
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 4 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	2,254078	0,000012
	No caching of lanuage 38. Because it is not changed within this session.	2,254337	0,000259
	Cache item 'ML_38' already exists, so language is not cached again	2,254361	0,000024
	Session 'MlJclLanguage' set to 38	2,254375	0,000013
	Start replace dynamic content	2,254401	0,000027
	Replace dynamic content only once	2,254492	0,000091
	End replace dynamic content	2,254504	0,000013
	Filled translationcomponent from cache.	2,255142	0,000637
	No caching of lanuage 38. Because it is not changed within this session.	2,289650	0,034508
	Cache item 'ML_38' already exists, so language is not cached again	2,289748	0,000098
	Session 'MlJclLanguage' set to 38	2,289762	0,000014
	Start replace dynamic content	2,289802	0,000040
	Replace dynamic content only once	2,289920	0,000118
	End replace dynamic content	2,289934	0,000014
	Filled translationcomponent from cache.	2,290581	0,000646
	[RenderValues] set query and/or replacements	2,325818	0,035237
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 4 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	2,325893	0,000075
	No caching of lanuage 38. Because it is not changed within this session.	2,326176	0,000283
	Cache item 'ML_38' already exists, so language is not cached again	2,326218	0,000042
	Session 'MlJclLanguage' set to 38	2,326233	0,000015
	Start replace dynamic content	2,326261	0,000028
	Replace dynamic content only once	2,326362	0,000101
	End replace dynamic content	2,326372	0,000011
	Filled translationcomponent from cache.	2,327016	0,000644
	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,361803	0,034786
	Open connection with DB	2,362018	0,000215
	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,392113	0,030095
	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,393550	0,001437
	Open connection with DB	2,393725	0,000175
	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,424444	0,030719
	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,426167	0,001723
	Open connection with DB	2,426338	0,000171
	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,467131	0,040793
	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,468874	0,001743
	Open connection with DB	2,469016	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	2,583554	0,114539
	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,584881	0,001327
	Open connection with DB	2,585051	0,000170
	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,649591	0,064540
	No caching of lanuage 38. Because it is not changed within this session.	2,651006	0,001415
	Cache item 'ML_38' already exists, so language is not cached again	2,651061	0,000055
	Session 'MlJclLanguage' set to 38	2,651076	0,000015
	Start replace dynamic content	2,651648	0,000572
	Replace dynamic content only once	2,652981	0,001334
	End replace dynamic content	2,653013	0,000032
	Filled translationcomponent from cache.	2,660327	0,007314
	Start replacing system objects	2,692010	0,031683
	Start replacing translation	2,695581	0,003571
	Start replacing objects	2,695861	0,000280
	Start replacing request	2,696196	0,000336
	Start replacing session	2,812376	0,116180
	Start replacing standards	2,817121	0,004745
	Start replacing objecs again	2,817702	0,000581
aspx.page	End Render	2,830310	0,012608

Control Tree
Control UniqueID	Type	Render Size Bytes (including children)	ViewState Size Bytes (excluding children)	ControlState Size Bytes (excluding children)
__Page	ASP.homepage_aspx	110978	0	0
ctl00	System.Web.UI.HtmlControls.HtmlHead	1301	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	587	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	0dxjtapmu1mbfkkwxg4m4sx1	42
CurrentDomain	cando-praxis.juicebv.nl	37

Headers Collection
Name	Value
Cache-Control	max-age=0
Connection	close
Via	1.1 squid-proxy-5b5d847c96-xwghq (squid/6.10)
Content-Length	0
Accept	/
Accept-Encoding	gzip, br, zstd, deflate
Host	cando-praxis.juicebv.nl
User-Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
X-Forwarded-For	10.1.131.34, 216.73.216.107
X-Forwarded-Proto	http

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_CACHE_CONTROL:max-age=0 HTTP_CONNECTION:close HTTP_VIA:1.1 squid-proxy-5b5d847c96-xwghq (squid/6.10) HTTP_CONTENT_LENGTH:0 HTTP_ACCEPT:/ HTTP_ACCEPT_ENCODING:gzip, br, zstd, deflate HTTP_HOST:cando-praxis.juicebv.nl HTTP_USER_AGENT:Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) HTTP_X_FORWARDED_FOR:10.1.131.34, 216.73.216.107 HTTP_X_FORWARDED_PROTO:http
ALL_RAW	Cache-Control: max-age=0 Connection: close Via: 1.1 squid-proxy-5b5d847c96-xwghq (squid/6.10) Content-Length: 0 Accept: / Accept-Encoding: gzip, br, zstd, deflate Host: cando-praxis.juicebv.nl User-Agent: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) X-Forwarded-For: 10.1.131.34, 216.73.216.107 X-Forwarded-Proto: http
APPL_MD_PATH	/LM/W3SVC/3/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
CERT_SECRETKEYSIZE
CERT_SERIALNUMBER
CERT_SERVER_ISSUER
CERT_SERVER_SUBJECT
CERT_SUBJECT
CONTENT_LENGTH	0
CONTENT_TYPE
GATEWAY_INTERFACE	CGI/1.1
HTTPS	off
HTTPS_KEYSIZE
HTTPS_SECRETKEYSIZE
HTTPS_SERVER_ISSUER
HTTPS_SERVER_SUBJECT
INSTANCE_ID	3
INSTANCE_META_PATH	/LM/W3SVC/3
LOCAL_ADDR	136.144.214.154
PATH_INFO	/homepage.aspx
PATH_TRANSLATED	C:\inetpub\wwwroot\configurator-cando - LIVE\homepage.aspx
QUERY_STRING	configurator=achterdeuren
REMOTE_ADDR	89.41.168.6
REMOTE_HOST	89.41.168.6
REMOTE_PORT	8064
REQUEST_METHOD	GET
SCRIPT_NAME	/homepage.aspx
SERVER_NAME	cando-praxis.juicebv.nl
SERVER_PORT	80
SERVER_PORT_SECURE	0
SERVER_PROTOCOL	HTTP/1.1
SERVER_SOFTWARE	Microsoft-IIS/10.0
URL	/homepage.aspx
HTTP_CACHE_CONTROL	max-age=0
HTTP_CONNECTION	close
HTTP_VIA	1.1 squid-proxy-5b5d847c96-xwghq (squid/6.10)
HTTP_CONTENT_LENGTH	0
HTTP_ACCEPT	/
HTTP_ACCEPT_ENCODING	gzip, br, zstd, deflate
HTTP_HOST	cando-praxis.juicebv.nl
HTTP_USER_AGENT	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
HTTP_X_FORWARDED_FOR	10.1.131.34, 216.73.216.107
HTTP_X_FORWARDED_PROTO	http

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