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:	cwg5wlmcx4mxxj5edtme4ksg	Request Type:	GET
Time of Request:	15-9-2026 07:13:47	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,000032	0,000032
aspx.page	Begin Init	0,000048	0,000017
	LoginControl_Init - isValidForThisDomain: True	0,000171	0,000123
	LoginControl - SetupWebsite - proceed: True, GoAnCode: , TagManagerId:	0,000250	0,000079
	This is page: homepage.aspx. With masterpagefile:	0,000397	0,000147
	CSS template IDs found:	0,000622	0,000226
	End load CSS from Wiser...	0,000630	0,000008
	JS template IDs found:	0,000860	0,000231
	NO JS template inline found	0,000868	0,000008
	End load JS from Wiser...	0,000874	0,000006
aspx.page	End Init	0,000935	0,000061
aspx.page	Begin InitComplete	0,000942	0,000007
aspx.page	End InitComplete	0,000948	0,000006
aspx.page	Begin PreLoad	0,000953	0,000006
aspx.page	End PreLoad	0,000959	0,000005
aspx.page	Begin Load	0,000964	0,000005
aspx.page	End Load	0,000990	0,000026
aspx.page	Begin LoadComplete	0,001001	0,000011
aspx.page	End LoadComplete	0,001007	0,000006
aspx.page	Begin PreRender	0,001012	0,000005
aspx.page	End PreRender	0,001055	0,000043
aspx.page	Begin PreRenderComplete	0,001067	0,000012
aspx.page	End PreRenderComplete	0,001072	0,000006
aspx.page	Begin SaveState	0,001210	0,000138
aspx.page	End SaveState	0,001216	0,000006
aspx.page	Begin SaveStateComplete	0,001221	0,000005
aspx.page	End SaveStateComplete	0,001227	0,000005
aspx.page	Begin Render	0,001238	0,000011
	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,007237	0,005999
	Open connection with DB	0,007384	0,000147
	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,171485	0,164101
	RenderStep Kies uw buitendeur connected to: 2289 - mainstepnumber: 1 - stepnumber: 1 - dependentvalue: 2289 - datasource connectedid: 2289	0,219637	0,048153
	[RenderValues] set query and/or replacements	0,222716	0,003079
	[RenderValues] Execute query	0,234016	0,011300
	query cachinghours: 200	0,234419	0,000403
	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,234476	0,000058
	Open connection with DB	0,234564	0,000088
	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,427803	0,193239
	[RenderValues] Do last replacements. Num items: 33	0,427843	0,000040
	[RenderValues] replacements done	1,543450	1,115607
	RenderStep (values rendered) Kies uw buitendeur connected to: 2289 - mainstepnumber: 1 - stepnumber: 1 - dependentvalue: 2289 - datasource connectedid: 2289	1,544306	0,000856
	[RenderValues] set query and/or replacements	1,546975	0,002670
	RenderSubStep connected to: - mainstepnumber: 1 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	1,547007	0,000032
	Language 38 is new	1,547931	0,000924
	Caching of languagewords in cache is starting because 'ML_38' is empty	1,547970	0,000039
	QUERY SYSCON START: SELECT fieldname, translation FROM site_languagefields WHERE languageid = ?languageId GROUP BY fieldname	1,548296	0,000326
	Open connection with DB	1,548311	0,000015
	QUERY SYSCON END: SELECT fieldname, translation FROM site_languagefields WHERE languageid = ?languageId GROUP BY fieldname	1,882997	0,334686
	0 woorden gecached voor key 'ML_38'	1,883138	0,000141
	Session 'MlJclLanguage' set to 38	1,883159	0,000021
	Start replace dynamic content	1,887014	0,003856
	Replace dynamic content only once	1,887237	0,000223
	End replace dynamic content	1,887252	0,000015
	Filled translationcomponent from cache.	1,887767	0,000515
	No caching of lanuage 38. Because it is not changed within this session.	1,969445	0,081678
	Cache item 'ML_38' already exists, so language is not cached again	1,969542	0,000098
	Session 'MlJclLanguage' set to 38	1,969556	0,000014
	Start replace dynamic content	1,969985	0,000429
	Replace dynamic content only once	1,970915	0,000930
	End replace dynamic content	1,970929	0,000014
	Filled translationcomponent from cache.	1,971467	0,000538
	Start replacing system objects	2,002060	0,030592
	Start replacing translation	2,003179	0,001120
	Start replacing objects	2,003465	0,000286
	Start replacing request	2,003825	0,000360
	Start replacing session	2,045248	0,041423
	Start replacing standards	2,061510	0,016263
	Start replacing objecs again	2,062139	0,000629
	[RenderValues] set query and/or replacements	2,169337	0,107197
	RenderSubStep connected to: - mainstepnumber: 1 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	2,169388	0,000052
	No caching of lanuage 38. Because it is not changed within this session.	2,169580	0,000192
	Cache item 'ML_38' already exists, so language is not cached again	2,169606	0,000025
	Session 'MlJclLanguage' set to 38	2,169614	0,000009
	Start replace dynamic content	2,169633	0,000019
	Replace dynamic content only once	2,169720	0,000087
	End replace dynamic content	2,169727	0,000007
	Filled translationcomponent from cache.	2,170174	0,000447
	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,196840	0,026666
	Open connection with DB	2,196999	0,000160
	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,287614	0,090615
	RenderStep Binnendraaiend connected to: binnendeuren deurtype - mainstepnumber: 2 - stepnumber: 1 - dependentvalue: 1 - datasource connectedid: binnendeuren - deurtype	2,289998	0,002385
	[RenderValues] set query and/or replacements	2,290041	0,000043
	RenderStep (values rendered) Binnendraaiend connected to: binnendeuren deurtype - mainstepnumber: 2 - stepnumber: 1 - dependentvalue: 1 - datasource connectedid: binnendeuren - deurtype	2,290080	0,000039
	[RenderValues] set query and/or replacements	2,290109	0,000029
	[RenderValues] Execute query	2,290400	0,000290
	query cachinghours: 200	2,290473	0,000074
	QUERY SYSCON START: SET @isBinnen = IF('{uitvoering}' ='Binnendraaiend', true,false); SET @isSet = IF('{uitvoering}' LIKE '{%}', false, true); SELECT * FROM ( SELECT 'Links binnendraaiend' AS valuelist_1, 'linksbinnendraaiend' AS valuelist_2, 'L1' AS valuelist_3 UNION SELECT'Rechts binnendraaiend', 'rechtsbinnendraaiend', 'R2' ) binnen WHERE @isBinnen AND @isSet UNION ALL SELECT * FROM ( SELECT 'Links buitendraaiend' AS valuelist_1, 'linksbuitendraaiend' AS valuelist_2, 'L3' AS valuelist_3 UNION SELECT'Rechts buitendraaiend', 'rechtsbuitendraaiend', 'R4' ) buiten WHERE @isBinnen = false AND @isSet;	2,290490	0,000017
	Open connection with DB	2,290514	0,000024
	QUERY SYSCON END: SET @isBinnen = IF('{uitvoering}' ='Binnendraaiend', true,false); SET @isSet = IF('{uitvoering}' LIKE '{%}', false, true); SELECT * FROM ( SELECT 'Links binnendraaiend' AS valuelist_1, 'linksbinnendraaiend' AS valuelist_2, 'L1' AS valuelist_3 UNION SELECT'Rechts binnendraaiend', 'rechtsbinnendraaiend', 'R2' ) binnen WHERE @isBinnen AND @isSet UNION ALL SELECT * FROM ( SELECT 'Links buitendraaiend' AS valuelist_1, 'linksbuitendraaiend' AS valuelist_2, 'L3' AS valuelist_3 UNION SELECT'Rechts buitendraaiend', 'rechtsbuitendraaiend', 'R4' ) buiten WHERE @isBinnen = false AND @isSet;	2,315545	0,025031
	[RenderValues] Do last replacements. Num items: 0	2,315598	0,000054
	[RenderValues] replacements done	2,315604	0,000006
	RenderSubStep Kies een draairichting (binnen)_kopie connected to: draairichting - mainstepnumber: 2 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: draairichting	2,315641	0,000036
	No caching of lanuage 38. Because it is not changed within this session.	2,315966	0,000325
	Cache item 'ML_38' already exists, so language is not cached again	2,315989	0,000024
	Session 'MlJclLanguage' set to 38	2,315998	0,000009
	Start replace dynamic content	2,316033	0,000035
	Replace dynamic content only once	2,316094	0,000061
	End replace dynamic content	2,316100	0,000006
	Filled translationcomponent from cache.	2,316587	0,000487
	No caching of lanuage 38. Because it is not changed within this session.	2,346171	0,029584
	Cache item 'ML_38' already exists, so language is not cached again	2,346233	0,000062
	Session 'MlJclLanguage' set to 38	2,346242	0,000009
	Start replace dynamic content	2,346279	0,000038
	QUERY SYSCON START: SELECT * FROM easy_webpages WHERE id=64	2,358730	0,012451
	Open connection with DB	2,358777	0,000047
	QUERY SYSCON END: SELECT * FROM easy_webpages WHERE id=64	2,375822	0,017045
	Set SEO fields on webpage	2,375862	0,000040
	title: Welkom op mijn website	2,375873	0,000011
	metadescription: Vul hier de meta description in	2,375880	0,000007
	canonicalurl:	2,375910	0,000030
	noindex: False	2,375919	0,000009
	nofollow: False	2,375926	0,000007
	AddSEOFields: Title=Welkom op mijn website, Description=Vul hier de meta description in, Keywords=Vul hier de metatags in, CanonicalURL=, NoIndex=False, NoFollow=False, Robots=	2,375939	0,000014
	Trying to add meta data, but no header with runat='server' was found	2,375945	0,000006
	Start replace dynamic content	2,375990	0,000045
	Replace dynamic content only once	2,376094	0,000105
	End replace dynamic content	2,376108	0,000013
	Filled translationcomponent from cache.	2,376537	0,000429
	Start replace dynamic content	2,378691	0,002154
	End replace dynamic content	2,378853	0,000162
	Filled translationcomponent from cache.	2,379300	0,000446
	End replace dynamic content	2,408119	0,028819
	Filled translationcomponent from cache.	2,408924	0,000805
	[RenderValues] set query and/or replacements	2,437545	0,028621
	[RenderValues] Execute query	2,437879	0,000334
	query cachinghours: 200	2,437967	0,000088
	query from cache 'JCLDC2a8ee254c5365604b0b2bdf7a6987f6c'	2,437977	0,000010
	QUERY SYSCON END (FROM CACHE): SET @isBinnen = IF('{uitvoering}' ='Binnendraaiend', true,false); SET @isSet = IF('{uitvoering}' LIKE '{%}', false, true); SELECT * FROM ( SELECT 'Links binnendraaiend' AS valuelist_1, 'linksbinnendraaiend' AS valuelist_2, 'L1' AS valuelist_3 UNION SELECT'Rechts binnendraaiend', 'rechtsbinnendraaiend', 'R2' ) binnen WHERE @isBinnen AND @isSet UNION ALL SELECT * FROM ( SELECT 'Links buitendraaiend' AS valuelist_1, 'linksbuitendraaiend' AS valuelist_2, 'L3' AS valuelist_3 UNION SELECT'Rechts buitendraaiend', 'rechtsbuitendraaiend', 'R4' ) buiten WHERE @isBinnen = false AND @isSet;	2,437994	0,000017
	[RenderValues] Do last replacements. Num items: 0	2,438017	0,000023
	[RenderValues] replacements done	2,438022	0,000006
	RenderSubStep Kies een draairichting (binnen)_kopie connected to: draairichting - mainstepnumber: 2 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: draairichting	2,438032	0,000010
	No caching of lanuage 38. Because it is not changed within this session.	2,438223	0,000191
	Cache item 'ML_38' already exists, so language is not cached again	2,438233	0,000010
	Session 'MlJclLanguage' set to 38	2,438244	0,000010
	Start replace dynamic content	2,438263	0,000020
	Replace dynamic content only once	2,438313	0,000050
	End replace dynamic content	2,438321	0,000008
	Filled translationcomponent from cache.	2,438821	0,000500
	RenderStep Bepaal de afmeting connected to: deurtype - mainstepnumber: 2 - stepnumber: 2 - dependentvalue: 1 - datasource connectedid: deurtype	2,461760	0,022939
	[RenderValues] set query and/or replacements	2,461812	0,000053
	[RenderValues] Execute query	2,462181	0,000368
	query cachinghours: 200	2,462244	0,000064
	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	2,462263	0,000018
	Open connection with DB	2,462282	0,000020
	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	2,486518	0,024235
	[RenderValues] Do last replacements. Num items: 0	2,486572	0,000055
	[RenderValues] replacements done	2,486580	0,000008
	RenderStep (values rendered) Bepaal de afmeting connected to: deurtype - mainstepnumber: 2 - stepnumber: 2 - dependentvalue: 1 - datasource connectedid: deurtype	2,486611	0,000031
	[RenderValues] set query and/or replacements	2,486699	0,000089
	[RenderValues] Execute query	2,487110	0,000410
	query cachinghours: 200	2,487180	0,000071
	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	2,487201	0,000021
	Open connection with DB	2,487231	0,000030
	QUERY SYSCON END: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); 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	2,511205	0,023975
	[RenderValues] Do last replacements. Num items: 0	2,511247	0,000042
	[RenderValues] replacements done	2,511255	0,000008
	RenderSubStep Breedte_kopie connected to: hoogte - mainstepnumber: 2 - stepnumber: 2 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: hoogte	2,511289	0,000034
	No caching of lanuage 38. Because it is not changed within this session.	2,511713	0,000425
	Cache item 'ML_38' already exists, so language is not cached again	2,511745	0,000032
	Session 'MlJclLanguage' set to 38	2,511755	0,000010
	Start replace dynamic content	2,511787	0,000033
	Replace dynamic content only once	2,511849	0,000062
	End replace dynamic content	2,511856	0,000006
	Filled translationcomponent from cache.	2,512447	0,000592
	No caching of lanuage 38. Because it is not changed within this session.	2,538310	0,025863
	Cache item 'ML_38' already exists, so language is not cached again	2,538377	0,000067
	Session 'MlJclLanguage' set to 38	2,538385	0,000009
	Start replace dynamic content	2,538417	0,000032
	Replace dynamic content only once	2,538510	0,000093
	End replace dynamic content	2,538517	0,000007
	Filled translationcomponent from cache.	2,538989	0,000472
	[RenderValues] set query and/or replacements	2,568968	0,029979
	[RenderValues] Execute query	2,569406	0,000438
	query cachinghours: 200	2,569471	0,000065
	query from cache 'JCLDC824d2f766cc06bc2f8f64a4c3cf64ea6'	2,569483	0,000012
	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	2,569496	0,000012
	[RenderValues] Do last replacements. Num items: 0	2,569507	0,000011
	[RenderValues] replacements done	2,569512	0,000006
	RenderSubStep Breedte_kopie connected to: hoogte - mainstepnumber: 2 - stepnumber: 2 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: hoogte	2,569523	0,000011
	No caching of lanuage 38. Because it is not changed within this session.	2,569739	0,000216
	Cache item 'ML_38' already exists, so language is not cached again	2,569751	0,000012
	Session 'MlJclLanguage' set to 38	2,569792	0,000041
	Start replace dynamic content	2,569812	0,000020
	Replace dynamic content only once	2,569864	0,000052
	End replace dynamic content	2,569870	0,000006
	Filled translationcomponent from cache.	2,570313	0,000443
	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,601965	0,031652
	Open connection with DB	2,602109	0,000144
	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,647088	0,044979
	RenderStep Veiligheidspakket connected to: uitvoering;draairichting;hoogte;breedte; - mainstepnumber: 3 - stepnumber: 1 - dependentvalue: 1 - datasource connectedid: uitvoering;draairichting;hoogte;breedte;	2,648814	0,001725
	[RenderValues] set query and/or replacements	2,648867	0,000053
	[RenderValues] Execute query	2,649386	0,000519
	query cachinghours: 200	2,649468	0,000082
	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	2,649485	0,000017
	Open connection with DB	2,649551	0,000066
	QUERY SYSCON END: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @_height = IF('{height}' LIKE '{%}', '', '{height}'); SET @_width = IF('{width}' LIKE '{%}', '', '{width}'); SET @implementation = IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}'); SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', '{draairichting}','%'), CONCAT('%',@implementation,'%'))); SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1); SELECT @doorId, p.id AS product_id, p.eancode, p.description_short AS description_short, IFNULL(p.serie, p.producttype) AS name, REPLACE(REPLACE(p.priceCando, '.',','), ',00', ',-') AS price, spk.cat_id, sp.bestandsnaam, suitable_for, suitable_for2 FROM shop_products p JOIN shop_koppeling k ON k.prod_dest = @doorId AND k.prod_source = p.id AND k.koppeltype = 'veiligheidspakket' JOIN shop_pro_cat spk ON spk.product_id=p.id LEFT JOIN shop_pictures sp ON sp.product_id=p.id AND sp.formaatnaam='normaal' WHERE IFNULL(p.serie, p.producttype) = 'Veiligheidspakket' AND ( NULLIF(p.suitable_for2,'') IS NULL OR suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(@implementation, 'schuifdeur', 'schuif'), '%') ) AND # turntypes (suitable_for IS NULL OR suitable_for = 'ALLE' OR '{draairichting}' LIKE CONCAT('%', suitable_for , '%') OR ( (SELECT suitable_for FROM shop_products WHERE eancode = '{draairichting}') LIKE CONCAT('%', suitable_for , '%') ) ) #AND p.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	2,679543	0,029992
	[RenderValues] Do last replacements. Num items: 0	2,679594	0,000051
	[RenderValues] replacements done	2,679600	0,000006
	RenderStep (values rendered) Veiligheidspakket connected to: uitvoering;draairichting;hoogte;breedte; - mainstepnumber: 3 - stepnumber: 1 - dependentvalue: 1 - datasource connectedid: uitvoering;draairichting;hoogte;breedte;	2,679632	0,000031
	[RenderValues] set query and/or replacements	2,679703	0,000072
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	2,679712	0,000009
	No caching of lanuage 38. Because it is not changed within this session.	2,679951	0,000239
	Cache item 'ML_38' already exists, so language is not cached again	2,679978	0,000027
	Session 'MlJclLanguage' set to 38	2,679989	0,000011
	Start replace dynamic content	2,680013	0,000024
	Replace dynamic content only once	2,680101	0,000088
	End replace dynamic content	2,680109	0,000009
	Filled translationcomponent from cache.	2,680528	0,000418
	No caching of lanuage 38. Because it is not changed within this session.	2,711496	0,030968
	Cache item 'ML_38' already exists, so language is not cached again	2,711570	0,000074
	Session 'MlJclLanguage' set to 38	2,711579	0,000009
	Start replace dynamic content	2,711614	0,000036
	Replace dynamic content only once	2,711713	0,000099
	End replace dynamic content	2,711721	0,000007
	Filled translationcomponent from cache.	2,712267	0,000546
	[RenderValues] set query and/or replacements	2,742588	0,030321
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	2,742647	0,000059
	No caching of lanuage 38. Because it is not changed within this session.	2,742884	0,000238
	Cache item 'ML_38' already exists, so language is not cached again	2,742924	0,000040
	Session 'MlJclLanguage' set to 38	2,742938	0,000013
	Start replace dynamic content	2,742966	0,000028
	Replace dynamic content only once	2,743053	0,000087
	End replace dynamic content	2,743060	0,000007
	Filled translationcomponent from cache.	2,743776	0,000716
	RenderStep Driepuntssluiting (alleen bij geen veiligheidspakket) connected to: veiligheidspakket;uitvoering;draairichting;hoogte;breedte - mainstepnumber: 3 - stepnumber: 2 - dependentvalue: 1 - datasource connectedid: veiligheidspakket;uitvoering;draairichting;hoogte;breedte	2,769443	0,025667
	[RenderValues] set query and/or replacements	2,769523	0,000081
	[RenderValues] Execute query	2,770071	0,000547
	query cachinghours: 200	2,770165	0,000095
	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	2,770199	0,000034
	Open connection with DB	2,770240	0,000042
	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	2,808717	0,038477
	[RenderValues] Do last replacements. Num items: 0	2,808776	0,000059
	[RenderValues] replacements done	2,808782	0,000007
	RenderStep (values rendered) Driepuntssluiting (alleen bij geen veiligheidspakket) connected to: veiligheidspakket;uitvoering;draairichting;hoogte;breedte - mainstepnumber: 3 - stepnumber: 2 - dependentvalue: 1 - datasource connectedid: veiligheidspakket;uitvoering;draairichting;hoogte;breedte	2,808823	0,000041
	[RenderValues] set query and/or replacements	2,808911	0,000088
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 2 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	2,808924	0,000013
	No caching of lanuage 38. Because it is not changed within this session.	2,809169	0,000246
	Cache item 'ML_38' already exists, so language is not cached again	2,809198	0,000029
	Session 'MlJclLanguage' set to 38	2,809215	0,000017
	Start replace dynamic content	2,809238	0,000023
	Replace dynamic content only once	2,809306	0,000068
	End replace dynamic content	2,809315	0,000009
	Filled translationcomponent from cache.	2,809840	0,000524
	No caching of lanuage 38. Because it is not changed within this session.	2,842961	0,033121
	Cache item 'ML_38' already exists, so language is not cached again	2,843039	0,000078
	Session 'MlJclLanguage' set to 38	2,843058	0,000018
	Start replace dynamic content	2,843099	0,000041
	Replace dynamic content only once	2,843218	0,000119
	End replace dynamic content	2,843232	0,000014
	Filled translationcomponent from cache.	2,843972	0,000740
	[RenderValues] set query and/or replacements	2,876142	0,032170
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 2 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	2,876195	0,000054
	No caching of lanuage 38. Because it is not changed within this session.	2,876398	0,000202
	Cache item 'ML_38' already exists, so language is not cached again	2,876432	0,000035
	Session 'MlJclLanguage' set to 38	2,876452	0,000020
	Start replace dynamic content	2,876474	0,000022
	Replace dynamic content only once	2,876581	0,000106
	End replace dynamic content	2,876587	0,000007
	Filled translationcomponent from cache.	2,877130	0,000543
	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	2,902490	0,025360
	[RenderValues] set query and/or replacements	2,902562	0,000071
	[RenderValues] Execute query	2,903079	0,000518
	query cachinghours: 200	2,903162	0,000082
	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	2,903184	0,000023
	Open connection with DB	2,903238	0,000054
	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,935552	0,032314
	[RenderValues] Do last replacements. Num items: 0	2,935597	0,000044
	[RenderValues] replacements done	2,935603	0,000007
	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,935635	0,000031
	[RenderValues] set query and/or replacements	2,935707	0,000073
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 3 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	2,935720	0,000013
	No caching of lanuage 38. Because it is not changed within this session.	2,935920	0,000200
	Cache item 'ML_38' already exists, so language is not cached again	2,935935	0,000014
	Session 'MlJclLanguage' set to 38	2,935946	0,000012
	Start replace dynamic content	2,935964	0,000018
	Replace dynamic content only once	2,936027	0,000063
	End replace dynamic content	2,936033	0,000006
	Filled translationcomponent from cache.	2,936544	0,000510
	No caching of lanuage 38. Because it is not changed within this session.	2,961496	0,024953
	Cache item 'ML_38' already exists, so language is not cached again	2,961573	0,000076
	Session 'MlJclLanguage' set to 38	2,961590	0,000018
	Start replace dynamic content	2,961630	0,000040
	Replace dynamic content only once	2,961728	0,000097
	End replace dynamic content	2,961735	0,000007
	Filled translationcomponent from cache.	2,962221	0,000486
	[RenderValues] set query and/or replacements	2,985749	0,023528
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 3 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	2,985800	0,000051
	No caching of lanuage 38. Because it is not changed within this session.	2,986067	0,000267
	Cache item 'ML_38' already exists, so language is not cached again	2,986111	0,000044
	Session 'MlJclLanguage' set to 38	2,986119	0,000008
	Start replace dynamic content	2,986138	0,000019
	Replace dynamic content only once	2,986212	0,000074
	End replace dynamic content	2,986218	0,000006
	Filled translationcomponent from cache.	2,986736	0,000517
	RenderStep Accessoires connected to: uitvoering;draairichting;hoogte;breedte - mainstepnumber: 3 - stepnumber: 4 - dependentvalue: 1 - datasource connectedid: uitvoering;draairichting;hoogte;breedte	3,011134	0,024398
	[RenderValues] set query and/or replacements	3,011202	0,000068
	[RenderValues] Execute query	3,011766	0,000565
	query cachinghours: 200	3,011860	0,000094
	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	3,011883	0,000023
	Open connection with DB	3,011938	0,000055
	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	3,041096	0,029157
	[RenderValues] Do last replacements. Num items: 0	3,041142	0,000047
	[RenderValues] replacements done	3,041149	0,000006
	RenderStep (values rendered) Accessoires connected to: uitvoering;draairichting;hoogte;breedte - mainstepnumber: 3 - stepnumber: 4 - dependentvalue: 1 - datasource connectedid: uitvoering;draairichting;hoogte;breedte	3,041184	0,000036
	[RenderValues] set query and/or replacements	3,041256	0,000071
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 4 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	3,041276	0,000021
	No caching of lanuage 38. Because it is not changed within this session.	3,041461	0,000185
	Cache item 'ML_38' already exists, so language is not cached again	3,041480	0,000019
	Session 'MlJclLanguage' set to 38	3,041495	0,000015
	Start replace dynamic content	3,041523	0,000028
	Replace dynamic content only once	3,041613	0,000090
	End replace dynamic content	3,041624	0,000011
	Filled translationcomponent from cache.	3,042196	0,000572
	No caching of lanuage 38. Because it is not changed within this session.	3,070149	0,027953
	Cache item 'ML_38' already exists, so language is not cached again	3,070220	0,000071
	Session 'MlJclLanguage' set to 38	3,070230	0,000010
	Start replace dynamic content	3,070263	0,000033
	Replace dynamic content only once	3,070343	0,000080
	End replace dynamic content	3,070349	0,000007
	Filled translationcomponent from cache.	3,070815	0,000466
	[RenderValues] set query and/or replacements	3,097374	0,026559
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 4 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	3,097428	0,000054
	No caching of lanuage 38. Because it is not changed within this session.	3,097676	0,000248
	Cache item 'ML_38' already exists, so language is not cached again	3,097713	0,000037
	Session 'MlJclLanguage' set to 38	3,097723	0,000010
	Start replace dynamic content	3,097745	0,000023
	Replace dynamic content only once	3,097832	0,000086
	End replace dynamic content	3,097843	0,000011
	Filled translationcomponent from cache.	3,098308	0,000466
	QUERY SYSCON START: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,126366	0,028057
	Open connection with DB	3,126553	0,000187
	QUERY SYSCON END: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,163870	0,037318
	QUERY SYSCON START: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,165174	0,001304
	Open connection with DB	3,165307	0,000133
	QUERY SYSCON END: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,203514	0,038207
	QUERY SYSCON START: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,204913	0,001400
	Open connection with DB	3,205063	0,000149
	QUERY SYSCON END: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,245757	0,040695
	QUERY SYSCON START: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,248085	0,002328
	Open connection with DB	3,248269	0,000185
	QUERY SYSCON END: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,290855	0,042585
	QUERY SYSCON START: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,292228	0,001373
	Open connection with DB	3,292365	0,000137
	QUERY SYSCON END: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,328477	0,036112
	No caching of lanuage 38. Because it is not changed within this session.	3,329084	0,000607
	Cache item 'ML_38' already exists, so language is not cached again	3,329117	0,000033
	Session 'MlJclLanguage' set to 38	3,329126	0,000010
	Start replace dynamic content	3,329585	0,000459
	Replace dynamic content only once	3,330554	0,000969
	End replace dynamic content	3,330570	0,000017
	Filled translationcomponent from cache.	3,331048	0,000477
	Start replacing system objects	3,362566	0,031519
	Start replacing translation	3,366624	0,004058
	Start replacing objects	3,367023	0,000398
	Start replacing request	3,367387	0,000364
	Start replacing session	3,471458	0,104071
	Start replacing standards	3,476298	0,004840
	Start replacing objecs again	3,476916	0,000618
aspx.page	End Render	3,491467	0,014551

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	cwg5wlmcx4mxxj5edtme4ksg	42
CurrentDomain	cando-praxis.juicebv.nl	37

Headers Collection
Name	Value
Cache-Control	max-age=0
Connection	close
Via	1.1 squid-proxy-5b96dc6d46-t2mp7 (squid/6.13)
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.8.200.22, 216.73.217.72
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-5b96dc6d46-t2mp7 (squid/6.13) 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.8.200.22, 216.73.217.72 HTTP_X_FORWARDED_PROTO:http
ALL_RAW	Cache-Control: max-age=0 Connection: close Via: 1.1 squid-proxy-5b96dc6d46-t2mp7 (squid/6.13) 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.8.200.22, 216.73.217.72 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.155
PATH_INFO	/homepage.aspx
PATH_TRANSLATED	C:\inetpub\wwwroot\configurator-cando - LIVE\homepage.aspx
QUERY_STRING	configurator=achterdeuren
REMOTE_ADDR	89.41.168.5
REMOTE_HOST	89.41.168.5
REMOTE_PORT	37208
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-5b96dc6d46-t2mp7 (squid/6.13)
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.8.200.22, 216.73.217.72
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