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

Even geduld...
Bezig met laden configurator

Toepassen

Stap 1 3

Stap 2 3

Bepaal de juiste maat

Pas de deur volledig aan naar jouw situatie.

{stepnumber} {stepname}

{substepvalue} {substepname}

Kies een draairichting

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

Binnendraaiend

Buitendraaiend

{stepnumber} {stepname}

{substepvalue} {substepname}

Stap 3 3

Accessoires

Maak je deur compleet door accessoires toe te voegen.

{stepnumber} {stepname}

{substepvalue} {substepname}

{stepnumber} {stepname}

{substepvalue} {substepname}

Stap 5 5 2

Controleer je bestelling

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

Terug

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

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

* Deze prijs is een indicatie

Mail deze configuratie naar mijn mailadres

Bewaar deze configuratie

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

Voeg configuratie toe aan uw winkelwagen op uw mobiel

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

{stepnumber} {mainstepname} {steps}

{stepvalue} {stepname}:

Request Details
Session Id:	mqqwb42pel5xquwbsepobjhk	Request Type:	GET
Time of Request:	13-9-2026 08:01:30	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,000038	0,000038
aspx.page	Begin Init	0,000048	0,000010
	LoginControl_Init - isValidForThisDomain: True	0,000202	0,000154
	LoginControl - SetupWebsite - proceed: True, GoAnCode: , TagManagerId:	0,000302	0,000100
	This is page: homepage.aspx. With masterpagefile:	0,000562	0,000260
	CSS template IDs found:	0,001085	0,000524
	End load CSS from Wiser...	0,001135	0,000050
	JS template IDs found:	0,001850	0,000714
	NO JS template inline found	0,001877	0,000027
	End load JS from Wiser...	0,001890	0,000013
aspx.page	End Init	0,001942	0,000051
aspx.page	Begin InitComplete	0,001949	0,000007
aspx.page	End InitComplete	0,001955	0,000006
aspx.page	Begin PreLoad	0,001962	0,000007
aspx.page	End PreLoad	0,001967	0,000006
aspx.page	Begin Load	0,001973	0,000006
aspx.page	End Load	0,002025	0,000052
aspx.page	Begin LoadComplete	0,002032	0,000007
aspx.page	End LoadComplete	0,002038	0,000006
aspx.page	Begin PreRender	0,002044	0,000006
aspx.page	End PreRender	0,002391	0,000346
aspx.page	Begin PreRenderComplete	0,002430	0,000039
aspx.page	End PreRenderComplete	0,002441	0,000011
aspx.page	Begin SaveState	0,002651	0,000210
aspx.page	End SaveState	0,002658	0,000007
aspx.page	Begin SaveStateComplete	0,002664	0,000006
aspx.page	End SaveStateComplete	0,002670	0,000006
aspx.page	Begin Render	0,002676	0,000006
	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,011572	0,008896
	Open connection with DB	0,011721	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	0,153783	0,142062
	RenderStep Kies uw buitendeur connected to: 2289 - mainstepnumber: 1 - stepnumber: 1 - dependentvalue: 2289 - datasource connectedid: 2289	0,215232	0,061449
	[RenderValues] set query and/or replacements	0,218264	0,003032
	[RenderValues] Execute query	0,232420	0,014156
	query cachinghours: 200	0,232885	0,000465
	QUERY SYSCON START: SET @doortype = 'buitendeur'; SET @doorsubtype = 'achterdeuren'; SET @_door_id = IF('{door_id}' LIKE '{%}', false, CAST('{door_id}' AS UNSIGNED)); SET @_glass_id = IF('{glass_id}' LIKE '{%}', false, CAST('{glass_id}' AS UNSIGNED)); SELECT door.fsc AS fsc, door.KOMO AS komo, doorCat.isEasy AS gelaktgeleverd, doorCat.cando_comfort as candocomfort, IF(IFNULL(door.warrantyinYears,0)>9,1,0) AS ten_yr_guarantee, door.id AS door_id, doorCat.id AS door_cat_id, doorCat.`name` AS door_name, doorCat.style AS style, IFNULL(doorCat.door_wood_type, "Overig") AS door_wood_type, doorCat.isolerend AS isolerend, GROUP_CONCAT(DISTINCT CONCAT(door.height, "x", door.width)) AS sizes, IFNULL(MIN(glass.id),"") AS glass_id, IFNULL(glass.description_short, "") AS glass_name, doorCat.containsglass AS has_glass, IFNULL(GROUP_CONCAT(DISTINCT glass.glassType),IF(doorCat.containsglass =0,"Dichte deur", "")) AS glass_type, REPLACE(CONCAT_WS(" met ", doorCat.name, glass.description_short), 'met zonder','zonder') AS `name`, GROUP_CONCAT(DISTINCT door.producttype) AS door_type, doorCat.isolerend AS isolerend, door.eancode AS door_ean, glass.eancode AS glass_ean, MIN(door.pricecando) AS door_price, glass.pricecando AS glass_price, REPLACE(TRUNCATE(MIN(door.pricecando) + IFNULL(glass.pricecando,0) + IFNULL(mounting_package.pricecando,0),2), '.',',') AS total_price, IFNULL(CONCAT('<li>',REPLACE(doorCat.usp_s, '\r\n', '</li><li>'),'</li>'),'') AS usps, CONCAT('https://configurator.cando.eu/images/product/overzicht/',IFNULL(IFNULL(img.bestandsnaam,imgBackup.bestandsnaam), '')) AS img_url, REPLACE(CONCAT('https://configurator.cando.eu/images/product/overzicht/',IFNULL(IFNULL(img.bestandsnaam,imgBackup.bestandsnaam), '')),'_klein_','_vergroting_') AS img_url_large, REPLACE(CONCAT('https://configurator.cando.eu/images/product/overzicht/',IFNULL(img2.bestandsnaam, '')),'_klein_','_vergroting_') AS img2_url_large, IFNULL(img2.bestandsnaam, '') AS sfeerImageFile, doorCat.sequence AS `orderNr` FROM shop_products door JOIN shop_pro_cat door_to_cat ON door_to_cat.product_id=door.id JOIN shop_category doorCat ON doorCat.doortype=@doortype AND doorCat.id=door_to_cat.cat_id LEFT JOIN shop_koppeling glass_to_door ON glass_to_door.prod_dest=door.id AND glass_to_door.koppeltype IN("Roede", "Glas") LEFT JOIN shop_products glass ON glass.id=glass_to_door.prod_source LEFT JOIN shop_koppeling mounting_package_to_glass ON mounting_package_to_glass.prod_dest=glass.id AND mounting_package_to_glass.koppeltype="Verplicht item" LEFT JOIN shop_products mounting_package ON mounting_package.id=mounting_package_to_glass.prod_source # needs to be optimized LEFT JOIN shop_pictures img ON img.cat_id=doorCat.id AND img.formaatnaam = 'klein' AND img.fototype='deur' AND IF(glass.description_short IS NULL, img.name = doorCat.`name`, img.name = glass.description_short) #AND img.name = IFNULL(glass.description_short, "") LEFT JOIN shop_pictures imgBackup ON imgBackup.cat_id=doorCat.id AND imgBackup.formaatnaam = 'klein' AND imgBackup.fototype='deur' #AND img.name = IFNULL(glass.description_short, "") #LEFT JOIN shop_pictures imgLarge ON imgLarge.cat_id=doorCat.id AND imgLarge.formaatnaam = 'vergroting' AND imgLarge.fototype='deur' AND IF(glass.description_short IS NULL, imgLarge.name = doorCat.`name`, imgLarge.name = glass.description_short) #AND img.name = IFNULL(glass.description_short, "") #LEFT JOIN shop_pictures imgBackupLarge ON imgBackupLarge.cat_id=doorCat.id AND imgBackupLarge.formaatnaam = 'vergroting' AND imgBackupLarge.fototype='deur' #AND img.name = IFNULL(glass.description_short, "") LEFT JOIN shop_pictures img2 ON img2.cat_id=doorCat.id AND img2.formaatnaam = 'vergroting' AND img2.fototype='sfeerfoto' AND IF(glass.description_short IS NULL, img.name = doorCat.`name`, img.name = glass.description_short) WHERE doorCat.doortype=@doortype AND doorCat.doorsubtype=@doorsubtype AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', door.visiblecando, door.visiblecandoBranch) <> 0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', doorCat.visiblecando, doorCat.visiblecandoBranch) <> 0 AND IF(@_door_id = false, 1, door.id = @_door_id) AND IF(@_glass_id = false, 1, glass.id = @_glass_id) AND (glass.id IS NULL OR glass.visiblecando <> 0) GROUP BY `name` ORDER BY doorCat.sequence	0,232962	0,000078
	Open connection with DB	0,233083	0,000121
	QUERY SYSCON END: SET @doortype = 'buitendeur'; SET @doorsubtype = 'achterdeuren'; SET @_door_id = IF('{door_id}' LIKE '{%}', false, CAST('{door_id}' AS UNSIGNED)); SET @_glass_id = IF('{glass_id}' LIKE '{%}', false, CAST('{glass_id}' AS UNSIGNED)); SELECT door.fsc AS fsc, door.KOMO AS komo, doorCat.isEasy AS gelaktgeleverd, doorCat.cando_comfort as candocomfort, IF(IFNULL(door.warrantyinYears,0)>9,1,0) AS ten_yr_guarantee, door.id AS door_id, doorCat.id AS door_cat_id, doorCat.`name` AS door_name, doorCat.style AS style, IFNULL(doorCat.door_wood_type, "Overig") AS door_wood_type, doorCat.isolerend AS isolerend, GROUP_CONCAT(DISTINCT CONCAT(door.height, "x", door.width)) AS sizes, IFNULL(MIN(glass.id),"") AS glass_id, IFNULL(glass.description_short, "") AS glass_name, doorCat.containsglass AS has_glass, IFNULL(GROUP_CONCAT(DISTINCT glass.glassType),IF(doorCat.containsglass =0,"Dichte deur", "")) AS glass_type, REPLACE(CONCAT_WS(" met ", doorCat.name, glass.description_short), 'met zonder','zonder') AS `name`, GROUP_CONCAT(DISTINCT door.producttype) AS door_type, doorCat.isolerend AS isolerend, door.eancode AS door_ean, glass.eancode AS glass_ean, MIN(door.pricecando) AS door_price, glass.pricecando AS glass_price, REPLACE(TRUNCATE(MIN(door.pricecando) + IFNULL(glass.pricecando,0) + IFNULL(mounting_package.pricecando,0),2), '.',',') AS total_price, IFNULL(CONCAT('<li>',REPLACE(doorCat.usp_s, '\r\n', '</li><li>'),'</li>'),'') AS usps, CONCAT('https://configurator.cando.eu/images/product/overzicht/',IFNULL(IFNULL(img.bestandsnaam,imgBackup.bestandsnaam), '')) AS img_url, REPLACE(CONCAT('https://configurator.cando.eu/images/product/overzicht/',IFNULL(IFNULL(img.bestandsnaam,imgBackup.bestandsnaam), '')),'_klein_','_vergroting_') AS img_url_large, REPLACE(CONCAT('https://configurator.cando.eu/images/product/overzicht/',IFNULL(img2.bestandsnaam, '')),'_klein_','_vergroting_') AS img2_url_large, IFNULL(img2.bestandsnaam, '') AS sfeerImageFile, doorCat.sequence AS `orderNr` FROM shop_products door JOIN shop_pro_cat door_to_cat ON door_to_cat.product_id=door.id JOIN shop_category doorCat ON doorCat.doortype=@doortype AND doorCat.id=door_to_cat.cat_id LEFT JOIN shop_koppeling glass_to_door ON glass_to_door.prod_dest=door.id AND glass_to_door.koppeltype IN("Roede", "Glas") LEFT JOIN shop_products glass ON glass.id=glass_to_door.prod_source LEFT JOIN shop_koppeling mounting_package_to_glass ON mounting_package_to_glass.prod_dest=glass.id AND mounting_package_to_glass.koppeltype="Verplicht item" LEFT JOIN shop_products mounting_package ON mounting_package.id=mounting_package_to_glass.prod_source # needs to be optimized LEFT JOIN shop_pictures img ON img.cat_id=doorCat.id AND img.formaatnaam = 'klein' AND img.fototype='deur' AND IF(glass.description_short IS NULL, img.name = doorCat.`name`, img.name = glass.description_short) #AND img.name = IFNULL(glass.description_short, "") LEFT JOIN shop_pictures imgBackup ON imgBackup.cat_id=doorCat.id AND imgBackup.formaatnaam = 'klein' AND imgBackup.fototype='deur' #AND img.name = IFNULL(glass.description_short, "") #LEFT JOIN shop_pictures imgLarge ON imgLarge.cat_id=doorCat.id AND imgLarge.formaatnaam = 'vergroting' AND imgLarge.fototype='deur' AND IF(glass.description_short IS NULL, imgLarge.name = doorCat.`name`, imgLarge.name = glass.description_short) #AND img.name = IFNULL(glass.description_short, "") #LEFT JOIN shop_pictures imgBackupLarge ON imgBackupLarge.cat_id=doorCat.id AND imgBackupLarge.formaatnaam = 'vergroting' AND imgBackupLarge.fototype='deur' #AND img.name = IFNULL(glass.description_short, "") LEFT JOIN shop_pictures img2 ON img2.cat_id=doorCat.id AND img2.formaatnaam = 'vergroting' AND img2.fototype='sfeerfoto' AND IF(glass.description_short IS NULL, img.name = doorCat.`name`, img.name = glass.description_short) WHERE doorCat.doortype=@doortype AND doorCat.doorsubtype=@doorsubtype AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', door.visiblecando, door.visiblecandoBranch) <> 0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', doorCat.visiblecando, doorCat.visiblecandoBranch) <> 0 AND IF(@_door_id = false, 1, door.id = @_door_id) AND IF(@_glass_id = false, 1, glass.id = @_glass_id) AND (glass.id IS NULL OR glass.visiblecando <> 0) GROUP BY `name` ORDER BY doorCat.sequence	0,462540	0,229457
	[RenderValues] Do last replacements. Num items: 33	0,462631	0,000091
	[RenderValues] replacements done	1,144476	0,681846
	RenderStep (values rendered) Kies uw buitendeur connected to: 2289 - mainstepnumber: 1 - stepnumber: 1 - dependentvalue: 2289 - datasource connectedid: 2289	1,145444	0,000968
	[RenderValues] set query and/or replacements	1,158218	0,012774
	RenderSubStep connected to: - mainstepnumber: 1 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	1,158275	0,000056
	Language 38 is new	1,162151	0,003877
	Caching of languagewords in cache is starting because 'ML_38' is empty	1,162229	0,000078
	QUERY SYSCON START: SELECT fieldname, translation FROM site_languagefields WHERE languageid = ?languageId GROUP BY fieldname	1,162637	0,000408
	Open connection with DB	1,162666	0,000029
	QUERY SYSCON END: SELECT fieldname, translation FROM site_languagefields WHERE languageid = ?languageId GROUP BY fieldname	1,212024	0,049358
	0 woorden gecached voor key 'ML_38'	1,212189	0,000165
	Session 'MlJclLanguage' set to 38	1,212223	0,000034
	Start replace dynamic content	1,217232	0,005009
	Replace dynamic content only once	1,217647	0,000414
	End replace dynamic content	1,217676	0,000030
	Filled translationcomponent from cache.	1,218613	0,000936
	No caching of lanuage 38. Because it is not changed within this session.	1,301260	0,082648
	Cache item 'ML_38' already exists, so language is not cached again	1,301347	0,000087
	Session 'MlJclLanguage' set to 38	1,301356	0,000010
	Start replace dynamic content	1,301779	0,000423
	Replace dynamic content only once	1,302704	0,000925
	End replace dynamic content	1,302722	0,000018
	Filled translationcomponent from cache.	1,303277	0,000556
	Start replacing system objects	1,339050	0,035772
	Start replacing translation	1,340417	0,001368
	Start replacing objects	1,340856	0,000439
	Start replacing request	1,341278	0,000422
	Start replacing session	1,398307	0,057029
	Start replacing standards	1,420291	0,021984
	Start replacing objecs again	1,421005	0,000714
	[RenderValues] set query and/or replacements	1,548583	0,127577
	RenderSubStep connected to: - mainstepnumber: 1 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	1,548646	0,000063
	No caching of lanuage 38. Because it is not changed within this session.	1,548837	0,000191
	Cache item 'ML_38' already exists, so language is not cached again	1,548863	0,000026
	Session 'MlJclLanguage' set to 38	1,548872	0,000009
	Start replace dynamic content	1,548893	0,000021
	Replace dynamic content only once	1,548970	0,000077
	End replace dynamic content	1,548976	0,000007
	Filled translationcomponent from cache.	1,549519	0,000543
	QUERY SYSCON START: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	1,587618	0,038099
	Open connection with DB	1,587808	0,000190
	QUERY SYSCON END: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	1,625510	0,037702
	RenderStep Binnendraaiend connected to: binnendeuren deurtype - mainstepnumber: 2 - stepnumber: 1 - dependentvalue: 1 - datasource connectedid: binnendeuren - deurtype	1,628352	0,002842
	[RenderValues] set query and/or replacements	1,628399	0,000047
	RenderStep (values rendered) Binnendraaiend connected to: binnendeuren deurtype - mainstepnumber: 2 - stepnumber: 1 - dependentvalue: 1 - datasource connectedid: binnendeuren - deurtype	1,628439	0,000040
	[RenderValues] set query and/or replacements	1,628467	0,000029
	[RenderValues] Execute query	1,628753	0,000286
	query cachinghours: 200	1,628830	0,000077
	QUERY SYSCON START: SET @isBinnen = IF('{uitvoering}' ='Binnendraaiend', true,false); SET @isSet = IF('{uitvoering}' LIKE '{%}', false, true); SELECT * FROM ( SELECT 'Links binnendraaiend' AS valuelist_1, 'linksbinnendraaiend' AS valuelist_2, 'L1' AS valuelist_3 UNION SELECT'Rechts binnendraaiend', 'rechtsbinnendraaiend', 'R2' ) binnen WHERE @isBinnen AND @isSet UNION ALL SELECT * FROM ( SELECT 'Links buitendraaiend' AS valuelist_1, 'linksbuitendraaiend' AS valuelist_2, 'L3' AS valuelist_3 UNION SELECT'Rechts buitendraaiend', 'rechtsbuitendraaiend', 'R4' ) buiten WHERE @isBinnen = false AND @isSet;	1,628845	0,000015
	Open connection with DB	1,628862	0,000017
	QUERY SYSCON END: SET @isBinnen = IF('{uitvoering}' ='Binnendraaiend', true,false); SET @isSet = IF('{uitvoering}' LIKE '{%}', false, true); SELECT * FROM ( SELECT 'Links binnendraaiend' AS valuelist_1, 'linksbinnendraaiend' AS valuelist_2, 'L1' AS valuelist_3 UNION SELECT'Rechts binnendraaiend', 'rechtsbinnendraaiend', 'R2' ) binnen WHERE @isBinnen AND @isSet UNION ALL SELECT * FROM ( SELECT 'Links buitendraaiend' AS valuelist_1, 'linksbuitendraaiend' AS valuelist_2, 'L3' AS valuelist_3 UNION SELECT'Rechts buitendraaiend', 'rechtsbuitendraaiend', 'R4' ) buiten WHERE @isBinnen = false AND @isSet;	1,646355	0,017493
	[RenderValues] Do last replacements. Num items: 0	1,646419	0,000064
	[RenderValues] replacements done	1,646431	0,000012
	RenderSubStep Kies een draairichting (binnen)_kopie connected to: draairichting - mainstepnumber: 2 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: draairichting	1,646496	0,000065
	No caching of lanuage 38. Because it is not changed within this session.	1,646922	0,000426
	Cache item 'ML_38' already exists, so language is not cached again	1,646969	0,000048
	Session 'MlJclLanguage' set to 38	1,646988	0,000019
	Start replace dynamic content	1,647041	0,000053
	Replace dynamic content only once	1,647180	0,000139
	End replace dynamic content	1,647194	0,000014
	Filled translationcomponent from cache.	1,647947	0,000753
	No caching of lanuage 38. Because it is not changed within this session.	1,695561	0,047614
	Cache item 'ML_38' already exists, so language is not cached again	1,695638	0,000078
	Session 'MlJclLanguage' set to 38	1,695652	0,000014
	Start replace dynamic content	1,695704	0,000052
	QUERY SYSCON START: SELECT * FROM easy_webpages WHERE id=64	1,709552	0,013848
	Open connection with DB	1,709593	0,000041
	QUERY SYSCON END: SELECT * FROM easy_webpages WHERE id=64	1,726112	0,016519
	Set SEO fields on webpage	1,726174	0,000062
	title: Welkom op mijn website	1,726185	0,000011
	metadescription: Vul hier de meta description in	1,726192	0,000007
	canonicalurl:	1,726199	0,000007
	noindex: False	1,726208	0,000010
	nofollow: False	1,726216	0,000008
	AddSEOFields: Title=Welkom op mijn website, Description=Vul hier de meta description in, Keywords=Vul hier de metatags in, CanonicalURL=, NoIndex=False, NoFollow=False, Robots=	1,726236	0,000020
	Trying to add meta data, but no header with runat='server' was found	1,726245	0,000010
	Start replace dynamic content	1,726297	0,000052
	Replace dynamic content only once	1,726417	0,000120
	End replace dynamic content	1,726428	0,000011
	Filled translationcomponent from cache.	1,727084	0,000656
	Start replace dynamic content	1,729412	0,002328
	End replace dynamic content	1,729555	0,000144
	Filled translationcomponent from cache.	1,729977	0,000422
	End replace dynamic content	1,761146	0,031169
	Filled translationcomponent from cache.	1,762000	0,000854
	[RenderValues] set query and/or replacements	1,792610	0,030610
	[RenderValues] Execute query	1,793045	0,000435
	query cachinghours: 200	1,793171	0,000127
	query from cache 'JCLDC2a8ee254c5365604b0b2bdf7a6987f6c'	1,793200	0,000029
	QUERY SYSCON END (FROM CACHE): SET @isBinnen = IF('{uitvoering}' ='Binnendraaiend', true,false); SET @isSet = IF('{uitvoering}' LIKE '{%}', false, true); SELECT * FROM ( SELECT 'Links binnendraaiend' AS valuelist_1, 'linksbinnendraaiend' AS valuelist_2, 'L1' AS valuelist_3 UNION SELECT'Rechts binnendraaiend', 'rechtsbinnendraaiend', 'R2' ) binnen WHERE @isBinnen AND @isSet UNION ALL SELECT * FROM ( SELECT 'Links buitendraaiend' AS valuelist_1, 'linksbuitendraaiend' AS valuelist_2, 'L3' AS valuelist_3 UNION SELECT'Rechts buitendraaiend', 'rechtsbuitendraaiend', 'R4' ) buiten WHERE @isBinnen = false AND @isSet;	1,793229	0,000029
	[RenderValues] Do last replacements. Num items: 0	1,793261	0,000032
	[RenderValues] replacements done	1,793267	0,000006
	RenderSubStep Kies een draairichting (binnen)_kopie connected to: draairichting - mainstepnumber: 2 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: draairichting	1,793280	0,000013
	No caching of lanuage 38. Because it is not changed within this session.	1,793572	0,000292
	Cache item 'ML_38' already exists, so language is not cached again	1,793594	0,000022
	Session 'MlJclLanguage' set to 38	1,793604	0,000010
	Start replace dynamic content	1,793637	0,000033
	Replace dynamic content only once	1,793716	0,000079
	End replace dynamic content	1,793725	0,000009
	Filled translationcomponent from cache.	1,794217	0,000492
	RenderStep Bepaal de afmeting connected to: deurtype - mainstepnumber: 2 - stepnumber: 2 - dependentvalue: 1 - datasource connectedid: deurtype	1,827211	0,032994
	[RenderValues] set query and/or replacements	1,827275	0,000064
	[RenderValues] Execute query	1,827815	0,000540
	query cachinghours: 200	1,827930	0,000114
	QUERY SYSCON START: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SELECT DISTINCT(door.height) AS hoogte, 0 AS isAllInclusive FROM shop_products door JOIN shop_pro_cat spc ON spc.product_id = door.id JOIN shop_category doorCat ON doorCat.id = spc.cat_id AND doorCat.parent_cat_id=2289 AND doorCat.id=@doorCat AND doorCat.visiblecando<>0 LEFT JOIN shop_products glass_org ON glass_org.id=@doorGlass LEFT JOIN shop_products glass_avail ON glass_avail.description_short=glass_org.description_short LEFT JOIN shop_koppeling k ON k.prod_dest=door.id AND k.prod_source=glass_avail.id WHERE IF(@doorGlass>0, k.id IS NOT NULL, 1) AND door.visiblecando<>0 ORDER BY door.height	1,827957	0,000027
	Open connection with DB	1,827987	0,000031
	QUERY SYSCON END: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SELECT DISTINCT(door.height) AS hoogte, 0 AS isAllInclusive FROM shop_products door JOIN shop_pro_cat spc ON spc.product_id = door.id JOIN shop_category doorCat ON doorCat.id = spc.cat_id AND doorCat.parent_cat_id=2289 AND doorCat.id=@doorCat AND doorCat.visiblecando<>0 LEFT JOIN shop_products glass_org ON glass_org.id=@doorGlass LEFT JOIN shop_products glass_avail ON glass_avail.description_short=glass_org.description_short LEFT JOIN shop_koppeling k ON k.prod_dest=door.id AND k.prod_source=glass_avail.id WHERE IF(@doorGlass>0, k.id IS NOT NULL, 1) AND door.visiblecando<>0 ORDER BY door.height	4,428655	2,600667
	[RenderValues] Do last replacements. Num items: 0	4,428698	0,000043
	[RenderValues] replacements done	4,428704	0,000006
	RenderStep (values rendered) Bepaal de afmeting connected to: deurtype - mainstepnumber: 2 - stepnumber: 2 - dependentvalue: 1 - datasource connectedid: deurtype	4,428759	0,000055
	[RenderValues] set query and/or replacements	4,428831	0,000072
	[RenderValues] Execute query	4,429263	0,000431
	query cachinghours: 200	4,429368	0,000106
	QUERY SYSCON START: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @turnType = IF('{draairichting}' IN ('R2/L3', 'L3', 'R2', 'links'), 'links', 'rechts'); SET @implementation = IF('{uitvoering}' IN('Buitendraaiend', 'Binnendraaiend', 'schuifdeur'), 'stomp', '{uitvoering}'); SET @implementation = IF(@implementation='opdek', CONCAT(@implementation, ' ', @turnType) , @implementation); SELECT DISTINCT(door.width) AS breedte FROM shop_products door JOIN shop_pro_cat spc ON spc.product_id = door.id JOIN shop_category doorCat ON doorCat.id=spc.cat_id AND doorCat.parent_cat_id=2289 AND doorCat.id=@doorCat AND doorCat.visiblecando<>0 LEFT JOIN shop_products glass_org ON glass_org.id=@doorGlass LEFT JOIN shop_products glass_avail ON glass_avail.description_short=glass_org.description_short AND glass_avail .visiblecando<>0 LEFT JOIN shop_koppeling k ON k.prod_dest=door.id AND k.prod_source=glass_avail.id WHERE (door.producttype = @implementation OR door.producttype = CONCAT(@implementation, ' ', @turnType)) AND door.height='{height}' #AND door.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', door.visiblecando, door.visiblecandoBranch) <> 0 AND IF(@doorGlass > 0, k.id IS NOT NULL, 1) ORDER BY door.width	4,429399	0,000031
	Open connection with DB	4,429430	0,000031
	QUERY SYSCON END: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @turnType = IF('{draairichting}' IN ('R2/L3', 'L3', 'R2', 'links'), 'links', 'rechts'); SET @implementation = IF('{uitvoering}' IN('Buitendraaiend', 'Binnendraaiend', 'schuifdeur'), 'stomp', '{uitvoering}'); SET @implementation = IF(@implementation='opdek', CONCAT(@implementation, ' ', @turnType) , @implementation); SELECT DISTINCT(door.width) AS breedte FROM shop_products door JOIN shop_pro_cat spc ON spc.product_id = door.id JOIN shop_category doorCat ON doorCat.id=spc.cat_id AND doorCat.parent_cat_id=2289 AND doorCat.id=@doorCat AND doorCat.visiblecando<>0 LEFT JOIN shop_products glass_org ON glass_org.id=@doorGlass LEFT JOIN shop_products glass_avail ON glass_avail.description_short=glass_org.description_short AND glass_avail .visiblecando<>0 LEFT JOIN shop_koppeling k ON k.prod_dest=door.id AND k.prod_source=glass_avail.id WHERE (door.producttype = @implementation OR door.producttype = CONCAT(@implementation, ' ', @turnType)) AND door.height='{height}' #AND door.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', door.visiblecando, door.visiblecandoBranch) <> 0 AND IF(@doorGlass > 0, k.id IS NOT NULL, 1) ORDER BY door.width	4,624703	0,195274
	[RenderValues] Do last replacements. Num items: 0	4,624762	0,000058
	[RenderValues] replacements done	4,624772	0,000011
	RenderSubStep Breedte_kopie connected to: hoogte - mainstepnumber: 2 - stepnumber: 2 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: hoogte	4,624821	0,000048
	No caching of lanuage 38. Because it is not changed within this session.	4,625224	0,000403
	Cache item 'ML_38' already exists, so language is not cached again	4,625274	0,000050
	Session 'MlJclLanguage' set to 38	4,625331	0,000058
	Start replace dynamic content	4,625386	0,000055
	Replace dynamic content only once	4,625486	0,000100
	End replace dynamic content	4,625495	0,000009
	Filled translationcomponent from cache.	4,626194	0,000699
	No caching of lanuage 38. Because it is not changed within this session.	4,653910	0,027717
	Cache item 'ML_38' already exists, so language is not cached again	4,653997	0,000087
	Session 'MlJclLanguage' set to 38	4,654006	0,000009
	Start replace dynamic content	4,654054	0,000047
	Replace dynamic content only once	4,654171	0,000117
	End replace dynamic content	4,654178	0,000008
	Filled translationcomponent from cache.	4,654806	0,000628
	[RenderValues] set query and/or replacements	4,678860	0,024054
	[RenderValues] Execute query	4,679388	0,000528
	query cachinghours: 200	4,679477	0,000090
	query from cache 'JCLDC0015ac3e0b58c863d35fc83966d4544d'	4,679489	0,000011
	QUERY SYSCON END (FROM CACHE): SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @turnType = IF('{draairichting}' IN ('R2/L3', 'L3', 'R2', 'links'), 'links', 'rechts'); SET @implementation = IF('{uitvoering}' IN('Buitendraaiend', 'Binnendraaiend', 'schuifdeur'), 'stomp', '{uitvoering}'); SET @implementation = IF(@implementation='opdek', CONCAT(@implementation, ' ', @turnType) , @implementation); SELECT DISTINCT(door.width) AS breedte FROM shop_products door JOIN shop_pro_cat spc ON spc.product_id = door.id JOIN shop_category doorCat ON doorCat.id=spc.cat_id AND doorCat.parent_cat_id=2289 AND doorCat.id=@doorCat AND doorCat.visiblecando<>0 LEFT JOIN shop_products glass_org ON glass_org.id=@doorGlass LEFT JOIN shop_products glass_avail ON glass_avail.description_short=glass_org.description_short AND glass_avail .visiblecando<>0 LEFT JOIN shop_koppeling k ON k.prod_dest=door.id AND k.prod_source=glass_avail.id WHERE (door.producttype = @implementation OR door.producttype = CONCAT(@implementation, ' ', @turnType)) AND door.height='{height}' #AND door.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', door.visiblecando, door.visiblecandoBranch) <> 0 AND IF(@doorGlass > 0, k.id IS NOT NULL, 1) ORDER BY door.width	4,679505	0,000017
	[RenderValues] Do last replacements. Num items: 0	4,679517	0,000011
	[RenderValues] replacements done	4,679540	0,000024
	RenderSubStep Breedte_kopie connected to: hoogte - mainstepnumber: 2 - stepnumber: 2 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: hoogte	4,679560	0,000019
	No caching of lanuage 38. Because it is not changed within this session.	4,679796	0,000236
	Cache item 'ML_38' already exists, so language is not cached again	4,679815	0,000019
	Session 'MlJclLanguage' set to 38	4,679826	0,000011
	Start replace dynamic content	4,679848	0,000023
	Replace dynamic content only once	4,679899	0,000051
	End replace dynamic content	4,679905	0,000006
	Filled translationcomponent from cache.	4,680549	0,000644
	QUERY SYSCON START: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	4,709305	0,028756
	Open connection with DB	4,709508	0,000204
	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	4,745420	0,035912
	RenderStep Veiligheidspakket connected to: uitvoering;draairichting;hoogte;breedte; - mainstepnumber: 3 - stepnumber: 1 - dependentvalue: 1 - datasource connectedid: uitvoering;draairichting;hoogte;breedte;	4,747095	0,001675
	[RenderValues] set query and/or replacements	4,747145	0,000050
	[RenderValues] Execute query	4,747643	0,000498
	query cachinghours: 200	4,747737	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 @_height = IF('{height}' LIKE '{%}', '', '{height}'); SET @_width = IF('{width}' LIKE '{%}', '', '{width}'); SET @implementation = IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}'); SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', '{draairichting}','%'), CONCAT('%',@implementation,'%'))); SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1); SELECT @doorId, p.id AS product_id, p.eancode, p.description_short AS description_short, IFNULL(p.serie, p.producttype) AS name, REPLACE(REPLACE(p.priceCando, '.',','), ',00', ',-') AS price, spk.cat_id, sp.bestandsnaam, suitable_for, suitable_for2 FROM shop_products p JOIN shop_koppeling k ON k.prod_dest = @doorId AND k.prod_source = p.id AND k.koppeltype = 'veiligheidspakket' JOIN shop_pro_cat spk ON spk.product_id=p.id LEFT JOIN shop_pictures sp ON sp.product_id=p.id AND sp.formaatnaam='normaal' WHERE IFNULL(p.serie, p.producttype) = 'Veiligheidspakket' AND ( NULLIF(p.suitable_for2,'') IS NULL OR suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(@implementation, 'schuifdeur', 'schuif'), '%') ) AND # turntypes (suitable_for IS NULL OR suitable_for = 'ALLE' OR '{draairichting}' LIKE CONCAT('%', suitable_for , '%') OR ( (SELECT suitable_for FROM shop_products WHERE eancode = '{draairichting}') LIKE CONCAT('%', suitable_for , '%') ) ) #AND p.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblecando, p.visiblecandoBranch) <> 0 /* AND ( ( @_height > CAST(p.min_maat_h AS DECIMAL(15,2)) AND @_height < CAST(p.max_maat_h AS DECIMAL(15,2)) AND @_width > CAST(p.min_maat_b AS DECIMAL(15,2)) AND @_width < CAST(p.max_maat_b AS DECIMAL(15,2)) ) OR ( p.min_maat_h IS NULL OR p.min_maat_h = '' OR CAST(p.min_maat_h = '0' AS DECIMAL(15,2)) ) AND ( p.max_maat_h IS NULL OR p.max_maat_h = '' OR CAST(p.max_maat_h = '0' AS DECIMAL(15,2)) ) AND ( p.min_maat_b IS NULL OR p.min_maat_b = '' OR CAST(p.min_maat_b = '0' AS DECIMAL(15,2)) ) AND ( p.max_maat_b IS NULL OR p.max_maat_b = '' OR CAST(p.max_maat_b = '0' AS DECIMAL(15,2)) ) ) */ ORDER BY name	4,747760	0,000023
	Open connection with DB	4,747825	0,000064
	QUERY SYSCON END: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @_height = IF('{height}' LIKE '{%}', '', '{height}'); SET @_width = IF('{width}' LIKE '{%}', '', '{width}'); SET @implementation = IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}'); SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', '{draairichting}','%'), CONCAT('%',@implementation,'%'))); SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1); SELECT @doorId, p.id AS product_id, p.eancode, p.description_short AS description_short, IFNULL(p.serie, p.producttype) AS name, REPLACE(REPLACE(p.priceCando, '.',','), ',00', ',-') AS price, spk.cat_id, sp.bestandsnaam, suitable_for, suitable_for2 FROM shop_products p JOIN shop_koppeling k ON k.prod_dest = @doorId AND k.prod_source = p.id AND k.koppeltype = 'veiligheidspakket' JOIN shop_pro_cat spk ON spk.product_id=p.id LEFT JOIN shop_pictures sp ON sp.product_id=p.id AND sp.formaatnaam='normaal' WHERE IFNULL(p.serie, p.producttype) = 'Veiligheidspakket' AND ( NULLIF(p.suitable_for2,'') IS NULL OR suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(@implementation, 'schuifdeur', 'schuif'), '%') ) AND # turntypes (suitable_for IS NULL OR suitable_for = 'ALLE' OR '{draairichting}' LIKE CONCAT('%', suitable_for , '%') OR ( (SELECT suitable_for FROM shop_products WHERE eancode = '{draairichting}') LIKE CONCAT('%', suitable_for , '%') ) ) #AND p.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblecando, p.visiblecandoBranch) <> 0 /* AND ( ( @_height > CAST(p.min_maat_h AS DECIMAL(15,2)) AND @_height < CAST(p.max_maat_h AS DECIMAL(15,2)) AND @_width > CAST(p.min_maat_b AS DECIMAL(15,2)) AND @_width < CAST(p.max_maat_b AS DECIMAL(15,2)) ) OR ( p.min_maat_h IS NULL OR p.min_maat_h = '' OR CAST(p.min_maat_h = '0' AS DECIMAL(15,2)) ) AND ( p.max_maat_h IS NULL OR p.max_maat_h = '' OR CAST(p.max_maat_h = '0' AS DECIMAL(15,2)) ) AND ( p.min_maat_b IS NULL OR p.min_maat_b = '' OR CAST(p.min_maat_b = '0' AS DECIMAL(15,2)) ) AND ( p.max_maat_b IS NULL OR p.max_maat_b = '' OR CAST(p.max_maat_b = '0' AS DECIMAL(15,2)) ) ) */ ORDER BY name	6,100644	1,352819
	[RenderValues] Do last replacements. Num items: 0	6,100694	0,000050
	[RenderValues] replacements done	6,100700	0,000007
	RenderStep (values rendered) Veiligheidspakket connected to: uitvoering;draairichting;hoogte;breedte; - mainstepnumber: 3 - stepnumber: 1 - dependentvalue: 1 - datasource connectedid: uitvoering;draairichting;hoogte;breedte;	6,100732	0,000032
	[RenderValues] set query and/or replacements	6,100800	0,000068
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	6,100808	0,000008
	No caching of lanuage 38. Because it is not changed within this session.	6,100988	0,000181
	Cache item 'ML_38' already exists, so language is not cached again	6,101002	0,000013
	Session 'MlJclLanguage' set to 38	6,101011	0,000009
	Start replace dynamic content	6,101032	0,000021
	Replace dynamic content only once	6,101106	0,000074
	End replace dynamic content	6,101135	0,000029
	Filled translationcomponent from cache.	6,101605	0,000471
	No caching of lanuage 38. Because it is not changed within this session.	6,140207	0,038602
	Cache item 'ML_38' already exists, so language is not cached again	6,140302	0,000095
	Session 'MlJclLanguage' set to 38	6,140318	0,000016
	Start replace dynamic content	6,140361	0,000043
	Replace dynamic content only once	6,140473	0,000113
	End replace dynamic content	6,140487	0,000014
	Filled translationcomponent from cache.	6,140926	0,000439
	[RenderValues] set query and/or replacements	6,168685	0,027759
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	6,168743	0,000058
	No caching of lanuage 38. Because it is not changed within this session.	6,169037	0,000294
	Cache item 'ML_38' already exists, so language is not cached again	6,169077	0,000040
	Session 'MlJclLanguage' set to 38	6,169087	0,000010
	Start replace dynamic content	6,169132	0,000045
	Replace dynamic content only once	6,169238	0,000106
	End replace dynamic content	6,169252	0,000014
	Filled translationcomponent from cache.	6,169750	0,000499
	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	6,209362	0,039612
	[RenderValues] set query and/or replacements	6,209428	0,000065
	[RenderValues] Execute query	6,210014	0,000586
	query cachinghours: 200	6,210109	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.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblecando, p.visiblecandoBranch) <> 0 GROUP BY p.id ) res WHERE '{veiligheidspakketJanee}' = 'Nee' AND @results	6,210161	0,000052
	Open connection with DB	6,210210	0,000049
	QUERY SYSCON END: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @implementation = IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}'); SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', '{draairichting}','%'), CONCAT('%',@implementation,'%'))); SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1); SET @isIndustrial = (SELECT IF(COUNT()>0,true,false) FROM shop_category WHERE id=@doorCat AND style LIKE '%industrial%'); SET @isDouble = IF('{dubbel}' = 'Ja', true, false); SET @results = false; SELECT FROM ( SELECT 'Geen driepuntsluiting' AS valuelist_1, 0 AS valuelist_2, 0 AS valuelist_3, 0 AS result UNION SELECT IF(p.serie LIKE '%sleutel%','Sleutelbediend','Krukbediend'), IF(p.serie LIKE '%sleutel%','sleutelbediend','krukbediend'), p.id, GREATEST(@results := true, -1) AS result FROM shop_products p JOIN shop_koppeling k ON k.prod_source=p.id AND k.prod_dest = @doorId AND k.koppeltype = 'Driepuntssluiting' WHERE ( NULLIF(p.suitable_for2,'') IS NULL OR suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(@implementation, 'schuifdeur', 'schuif'), '%') ) AND # turntypes (suitable_for IS NULL OR suitable_for = 'ALLE' OR REPLACE(REPLACE('{draairichting}', 'links', 'R2/L3'), 'rechts', 'L1/R4') LIKE CONCAT('%', suitable_for , '%') OR #inverted suitable_for LIKE CONCAT('%', REPLACE(REPLACE('{draairichting}', 'links', 'R2/L3'), 'rechts', 'L1/R4') , '%') OR ( (SELECT suitable_for FROM shop_products WHERE eancode = '{draairichting}') LIKE CONCAT('%', suitable_for , '%') ) ) #AND p.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblecando, p.visiblecandoBranch) <> 0 GROUP BY p.id ) res WHERE '{veiligheidspakketJanee}' = 'Nee' AND @results	6,231660	0,021450
	[RenderValues] Do last replacements. Num items: 0	6,231723	0,000063
	[RenderValues] replacements done	6,231734	0,000011
	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	6,231773	0,000039
	[RenderValues] set query and/or replacements	6,231847	0,000074
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 2 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	6,231861	0,000014
	No caching of lanuage 38. Because it is not changed within this session.	6,232219	0,000358
	Cache item 'ML_38' already exists, so language is not cached again	6,232255	0,000035
	Session 'MlJclLanguage' set to 38	6,232270	0,000015
	Start replace dynamic content	6,232313	0,000043
	Replace dynamic content only once	6,232409	0,000095
	End replace dynamic content	6,232422	0,000013
	Filled translationcomponent from cache.	6,233071	0,000650
	No caching of lanuage 38. Because it is not changed within this session.	6,269557	0,036485
	Cache item 'ML_38' already exists, so language is not cached again	6,269620	0,000063
	Session 'MlJclLanguage' set to 38	6,269629	0,000009
	Start replace dynamic content	6,269664	0,000035
	Replace dynamic content only once	6,269766	0,000102
	End replace dynamic content	6,269775	0,000009
	Filled translationcomponent from cache.	6,270301	0,000526
	[RenderValues] set query and/or replacements	6,298658	0,028358
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 2 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	6,298717	0,000059
	No caching of lanuage 38. Because it is not changed within this session.	6,298901	0,000184
	Cache item 'ML_38' already exists, so language is not cached again	6,298925	0,000024
	Session 'MlJclLanguage' set to 38	6,298933	0,000008
	Start replace dynamic content	6,298962	0,000029
	Replace dynamic content only once	6,299065	0,000103
	End replace dynamic content	6,299072	0,000007
	Filled translationcomponent from cache.	6,299647	0,000575
	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	6,324628	0,024981
	[RenderValues] set query and/or replacements	6,324677	0,000049
	[RenderValues] Execute query	6,325136	0,000459
	query cachinghours: 200	6,325214	0,000078
	QUERY SYSCON START: # Keep this query the same in ALL configurators for the "Accessoires" STEP!!! SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @implementation = IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}'); SET @turntype = IF('{draairichting}' LIKE '{%}', '','{draairichting}'); SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', @turntype,'%'), CONCAT('%',@implementation,'%'))); SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1); SET @isIndustrial = (SELECT IF(COUNT()>0,true,false) FROM shop_category WHERE id=@doorCat AND style LIKE '%industrial%'); SET @isDouble = IF('{dubbel}' = 'Ja', true, false); SELECT @doorId, IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%', '2x ','') AS ammountPrefix, IFNULL(info.html, '') AS info, p.id AS product_id, CONCAT(IF(@isDouble, ' ', ''), p.description_short) AS product_description, IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', ''))) AS product_name, REPLACE(REPLACE(p.pricecando IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%',2,1), '.',','), ',00', ',-') AS price, 'images/prod-scharnieren.png' AS product_image, spk.cat_id, IFNULL(sp.bestandsnaam, '') AS bestandsnaam, p.suitable_for, p.suitable_for2 FROM shop_products p JOIN shop_koppeling k ON k.prod_dest = @doorId AND k.prod_source = p.id AND k.koppeltype = 'service' JOIN shop_pro_cat spk ON spk.product_id=p.id #AND spk.cat_id IN(2386)# CAT (accessoires) LEFT JOIN easy_webpages info ON info.seoname = CONCAT('uitleg-', IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', '')))) LEFT JOIN shop_pictures sp ON sp.product_id=p.id AND sp.formaatnaam='normaal' WHERE (NULLIF(p.suitable_for2,'') IS NULL OR p.suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(LOWER(@implementation), 'schuifdeur', 'schuif'), '%') ) AND # turntypes (p.suitable_for IS NULL OR p.suitable_for = 'ALLE' OR REPLACE(REPLACE(@turntype, 'links', 'R2/L3'), 'rechts', 'L1/R4') LIKE CONCAT('%', p.suitable_for , '%') OR # reversed p.suitable_for LIKE CONCAT('%', REPLACE(REPLACE(@turntype, 'links', 'R2/L3'), 'rechts', 'L1/R4') , '%') OR ( (SELECT suitable_for FROM shop_products WHERE eancode = @turntype) LIKE CONCAT('%', p.suitable_for , '%') ) ) AND ('{driepuntssluiting}' = '0' OR '{driepuntssluiting}' LIKE '{%}') AND ('{veiligheidspakketJanee}' = 'Nee' OR '{veiligheidspakketJanee}' LIKE '{%}') AND p.producttype='slotgatfrezing' #AND p.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblecando, p.visiblecandoBranch) <> 0 GROUP BY p.id ORDER BY product_name	6,325233	0,000020
	Open connection with DB	6,325293	0,000060
	QUERY SYSCON END: # Keep this query the same in ALL configurators for the "Accessoires" STEP!!! SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @implementation = IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}'); SET @turntype = IF('{draairichting}' LIKE '{%}', '','{draairichting}'); SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', @turntype,'%'), CONCAT('%',@implementation,'%'))); SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1); SET @isIndustrial = (SELECT IF(COUNT()>0,true,false) FROM shop_category WHERE id=@doorCat AND style LIKE '%industrial%'); SET @isDouble = IF('{dubbel}' = 'Ja', true, false); SELECT @doorId, IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%', '2x ','') AS ammountPrefix, IFNULL(info.html, '') AS info, p.id AS product_id, CONCAT(IF(@isDouble, ' ', ''), p.description_short) AS product_description, IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', ''))) AS product_name, REPLACE(REPLACE(p.pricecando IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%',2,1), '.',','), ',00', ',-') AS price, 'images/prod-scharnieren.png' AS product_image, spk.cat_id, IFNULL(sp.bestandsnaam, '') AS bestandsnaam, p.suitable_for, p.suitable_for2 FROM shop_products p JOIN shop_koppeling k ON k.prod_dest = @doorId AND k.prod_source = p.id AND k.koppeltype = 'service' JOIN shop_pro_cat spk ON spk.product_id=p.id #AND spk.cat_id IN(2386)# CAT (accessoires) LEFT JOIN easy_webpages info ON info.seoname = CONCAT('uitleg-', IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', '')))) LEFT JOIN shop_pictures sp ON sp.product_id=p.id AND sp.formaatnaam='normaal' WHERE (NULLIF(p.suitable_for2,'') IS NULL OR p.suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(LOWER(@implementation), 'schuifdeur', 'schuif'), '%') ) AND # turntypes (p.suitable_for IS NULL OR p.suitable_for = 'ALLE' OR REPLACE(REPLACE(@turntype, 'links', 'R2/L3'), 'rechts', 'L1/R4') LIKE CONCAT('%', p.suitable_for , '%') OR # reversed p.suitable_for LIKE CONCAT('%', REPLACE(REPLACE(@turntype, 'links', 'R2/L3'), 'rechts', 'L1/R4') , '%') OR ( (SELECT suitable_for FROM shop_products WHERE eancode = @turntype) LIKE CONCAT('%', p.suitable_for , '%') ) ) AND ('{driepuntssluiting}' = '0' OR '{driepuntssluiting}' LIKE '{%}') AND ('{veiligheidspakketJanee}' = 'Nee' OR '{veiligheidspakketJanee}' LIKE '{%}') AND p.producttype='slotgatfrezing' #AND p.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblecando, p.visiblecandoBranch) <> 0 GROUP BY p.id ORDER BY product_name	6,428395	0,103102
	[RenderValues] Do last replacements. Num items: 0	6,428450	0,000055
	[RenderValues] replacements done	6,428460	0,000010
	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	6,428496	0,000036
	[RenderValues] set query and/or replacements	6,428557	0,000061
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 3 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	6,428565	0,000008
	No caching of lanuage 38. Because it is not changed within this session.	6,428798	0,000233
	Cache item 'ML_38' already exists, so language is not cached again	6,428818	0,000020
	Session 'MlJclLanguage' set to 38	6,428827	0,000009
	Start replace dynamic content	6,428850	0,000022
	Replace dynamic content only once	6,428910	0,000061
	End replace dynamic content	6,428916	0,000006
	Filled translationcomponent from cache.	6,429544	0,000628
	No caching of lanuage 38. Because it is not changed within this session.	6,460091	0,030546
	Cache item 'ML_38' already exists, so language is not cached again	6,460189	0,000098
	Session 'MlJclLanguage' set to 38	6,460209	0,000020
	Start replace dynamic content	6,460252	0,000043
	Replace dynamic content only once	6,460343	0,000091
	End replace dynamic content	6,460350	0,000007
	Filled translationcomponent from cache.	6,460868	0,000518
	[RenderValues] set query and/or replacements	6,485483	0,024616
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 3 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	6,485539	0,000055
	No caching of lanuage 38. Because it is not changed within this session.	6,485722	0,000183
	Cache item 'ML_38' already exists, so language is not cached again	6,485744	0,000023
	Session 'MlJclLanguage' set to 38	6,485756	0,000012
	Start replace dynamic content	6,485774	0,000018
	Replace dynamic content only once	6,485854	0,000080
	End replace dynamic content	6,485863	0,000008
	Filled translationcomponent from cache.	6,486361	0,000498
	RenderStep Accessoires connected to: uitvoering;draairichting;hoogte;breedte - mainstepnumber: 3 - stepnumber: 4 - dependentvalue: 1 - datasource connectedid: uitvoering;draairichting;hoogte;breedte	6,513660	0,027299
	[RenderValues] set query and/or replacements	6,513773	0,000114
	[RenderValues] Execute query	6,514473	0,000700
	query cachinghours: 200	6,514563	0,000090
	QUERY SYSCON START: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @implementation = IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}'); SET @turntype = IF('{draairichting}' LIKE '{%}', '','{draairichting}'); SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', @turntype,'%'), CONCAT('%',@implementation,'%'))); SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1); SET @isIndustrial = (SELECT IF(COUNT()>0,true,false) FROM shop_category WHERE id=@doorCat AND style LIKE '%industrial%'); SET @isDouble = IF('{dubbel}' = 'Ja', true, false); SELECT @doorId, IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%', '2x ','') AS ammountPrefix, #IFNULL(info.html, '') AS info, p.usp_s AS info, p.id AS product_id, CONCAT(IF(@isDouble, ' ', ''), p.description_short) AS product_description, LOWER(IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', '')))) AS product_name, REPLACE(REPLACE(IFNULL(SUM(innerProducts.pricecando), p.pricecando) IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%',2,1), '.',','), ',00', ',-') AS price, 'images/prod-scharnieren.png' AS product_image, spk.cat_id, IFNULL(MIN(spi.bestandsnaam), sp.bestandsnaam) AS bestandsnaam, p.suitable_for, p.suitable_for2 FROM shop_products p JOIN shop_koppeling k ON k.prod_dest = @doorId AND k.prod_source = p.id AND k.koppeltype IN ('accessoire', 'accessoirepakket') JOIN shop_pro_cat spk ON spk.product_id=p.id #AND spk.cat_id IN(2386)# CAT (accessoires) LEFT JOIN easy_webpages info ON info.seoname = CONCAT('uitleg-', IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', '')))) LEFT JOIN shop_pictures sp ON sp.product_id=p.id AND sp.formaatnaam='normaal' LEFT JOIN shop_koppeling k2 ON k2.prod_dest = k.prod_source AND k2.koppeltype='accessoire' # schuifsysteem LEFT JOIN shop_products innerProducts ON innerProducts.id=k2.prod_source LEFT JOIN shop_pictures spi ON spi.product_id=innerProducts.id AND spi.formaatnaam='normaal' WHERE (NULLIF(p.suitable_for2,'') IS NULL OR p.suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(LOWER(@implementation), 'schuifdeur', 'schuif'), '%') ) AND # turntypes (p.suitable_for IS NULL OR p.suitable_for = 'ALLE' OR REPLACE(REPLACE(@turntype, 'links', 'R2/L3'), 'rechts', 'L1/R4') LIKE CONCAT('%', p.suitable_for , '%') OR ( (SELECT suitable_for FROM shop_products WHERE eancode = @turntype) LIKE CONCAT('%', p.suitable_for , '%') ) ) #AND p.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblecando, p.visiblecandoBranch) <> 0 GROUP BY p.id ORDER BY product_name	6,514585	0,000022
	Open connection with DB	6,514636	0,000051
	QUERY SYSCON END: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @implementation = IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}'); SET @turntype = IF('{draairichting}' LIKE '{%}', '','{draairichting}'); SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', @turntype,'%'), CONCAT('%',@implementation,'%'))); SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1); SET @isIndustrial = (SELECT IF(COUNT()>0,true,false) FROM shop_category WHERE id=@doorCat AND style LIKE '%industrial%'); SET @isDouble = IF('{dubbel}' = 'Ja', true, false); SELECT @doorId, IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%', '2x ','') AS ammountPrefix, #IFNULL(info.html, '') AS info, p.usp_s AS info, p.id AS product_id, CONCAT(IF(@isDouble, ' ', ''), p.description_short) AS product_description, LOWER(IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', '')))) AS product_name, REPLACE(REPLACE(IFNULL(SUM(innerProducts.pricecando), p.pricecando) IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%',2,1), '.',','), ',00', ',-') AS price, 'images/prod-scharnieren.png' AS product_image, spk.cat_id, IFNULL(MIN(spi.bestandsnaam), sp.bestandsnaam) AS bestandsnaam, p.suitable_for, p.suitable_for2 FROM shop_products p JOIN shop_koppeling k ON k.prod_dest = @doorId AND k.prod_source = p.id AND k.koppeltype IN ('accessoire', 'accessoirepakket') JOIN shop_pro_cat spk ON spk.product_id=p.id #AND spk.cat_id IN(2386)# CAT (accessoires) LEFT JOIN easy_webpages info ON info.seoname = CONCAT('uitleg-', IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', '')))) LEFT JOIN shop_pictures sp ON sp.product_id=p.id AND sp.formaatnaam='normaal' LEFT JOIN shop_koppeling k2 ON k2.prod_dest = k.prod_source AND k2.koppeltype='accessoire' # schuifsysteem LEFT JOIN shop_products innerProducts ON innerProducts.id=k2.prod_source LEFT JOIN shop_pictures spi ON spi.product_id=innerProducts.id AND spi.formaatnaam='normaal' WHERE (NULLIF(p.suitable_for2,'') IS NULL OR p.suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(LOWER(@implementation), 'schuifdeur', 'schuif'), '%') ) AND # turntypes (p.suitable_for IS NULL OR p.suitable_for = 'ALLE' OR REPLACE(REPLACE(@turntype, 'links', 'R2/L3'), 'rechts', 'L1/R4') LIKE CONCAT('%', p.suitable_for , '%') OR ( (SELECT suitable_for FROM shop_products WHERE eancode = @turntype) LIKE CONCAT('%', p.suitable_for , '%') ) ) #AND p.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblecando, p.visiblecandoBranch) <> 0 GROUP BY p.id ORDER BY product_name	6,556100	0,041463
	[RenderValues] Do last replacements. Num items: 0	6,556170	0,000070
	[RenderValues] replacements done	6,556176	0,000006
	RenderStep (values rendered) Accessoires connected to: uitvoering;draairichting;hoogte;breedte - mainstepnumber: 3 - stepnumber: 4 - dependentvalue: 1 - datasource connectedid: uitvoering;draairichting;hoogte;breedte	6,556208	0,000032
	[RenderValues] set query and/or replacements	6,556274	0,000066
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 4 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	6,556296	0,000022
	No caching of lanuage 38. Because it is not changed within this session.	6,556481	0,000185
	Cache item 'ML_38' already exists, so language is not cached again	6,556497	0,000016
	Session 'MlJclLanguage' set to 38	6,556506	0,000009
	Start replace dynamic content	6,556528	0,000022
	Replace dynamic content only once	6,556583	0,000055
	End replace dynamic content	6,556589	0,000007
	Filled translationcomponent from cache.	6,557017	0,000427
	No caching of lanuage 38. Because it is not changed within this session.	6,591696	0,034680
	Cache item 'ML_38' already exists, so language is not cached again	6,591777	0,000081
	Session 'MlJclLanguage' set to 38	6,591789	0,000012
	Start replace dynamic content	6,591827	0,000038
	Replace dynamic content only once	6,591901	0,000074
	End replace dynamic content	6,591910	0,000009
	Filled translationcomponent from cache.	6,592491	0,000581
	[RenderValues] set query and/or replacements	6,620751	0,028260
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 4 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	6,620808	0,000057
	No caching of lanuage 38. Because it is not changed within this session.	6,621022	0,000214
	Cache item 'ML_38' already exists, so language is not cached again	6,621055	0,000032
	Session 'MlJclLanguage' set to 38	6,621067	0,000012
	Start replace dynamic content	6,621106	0,000039
	Replace dynamic content only once	6,621215	0,000109
	End replace dynamic content	6,621223	0,000007
	Filled translationcomponent from cache.	6,621727	0,000505
	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	6,652067	0,030340
	Open connection with DB	6,652222	0,000155
	QUERY SYSCON END: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	6,688801	0,036578
	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	6,690305	0,001505
	Open connection with DB	6,690490	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	6,718410	0,027920
	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	6,719653	0,001244
	Open connection with DB	6,719781	0,000128
	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	6,750219	0,030439
	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	6,752647	0,002428
	Open connection with DB	6,752814	0,000167
	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	6,781431	0,028617
	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	6,782888	0,001457
	Open connection with DB	6,783062	0,000174
	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	6,811655	0,028593
	No caching of lanuage 38. Because it is not changed within this session.	6,812452	0,000797
	Cache item 'ML_38' already exists, so language is not cached again	6,812531	0,000079
	Session 'MlJclLanguage' set to 38	6,812544	0,000013
	Start replace dynamic content	6,813008	0,000464
	Replace dynamic content only once	6,813979	0,000971
	End replace dynamic content	6,813992	0,000013
	Filled translationcomponent from cache.	6,814492	0,000501
	Start replacing system objects	6,846740	0,032248
	Start replacing translation	6,850669	0,003929
	Start replacing objects	6,851090	0,000421
	Start replacing request	6,851493	0,000403
	Start replacing session	6,990929	0,139435
	Start replacing standards	6,996210	0,005281
	Start replacing objecs again	6,996865	0,000655
aspx.page	End Render	7,007508	0,010643

Control Tree
Control UniqueID	Type	Render Size Bytes (including children)	ViewState Size Bytes (excluding children)	ControlState Size Bytes (excluding children)
__Page	ASP.homepage_aspx	110824	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	mqqwb42pel5xquwbsepobjhk	42
CurrentDomain	cando.juicebv.nl	30

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.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.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.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/1/ROOT
APPL_PHYSICAL_PATH	C:\inetpub\wwwroot\configurator-cando - LIVE\
AUTH_TYPE
AUTH_USER
AUTH_PASSWORD
LOGON_USER
REMOTE_USER
CERT_COOKIE
CERT_FLAGS
CERT_ISSUER
CERT_KEYSIZE
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	1
INSTANCE_META_PATH	/LM/W3SVC/1
LOCAL_ADDR	136.144.214.155
PATH_INFO	/homepage.aspx
PATH_TRANSLATED	C:\inetpub\wwwroot\configurator-cando - LIVE\homepage.aspx
QUERY_STRING	configurator=achterdeuren
REMOTE_ADDR	89.41.168.7
REMOTE_HOST	89.41.168.7
REMOTE_PORT	52424
REQUEST_METHOD	GET
SCRIPT_NAME	/homepage.aspx
SERVER_NAME	cando.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.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