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:	yylt13h5m4x3bhs4qcfyuy0g	Request Type:	GET
Time of Request:	12-11-2026 07:28:31	Status Code:	200
Request Encoding:	Unicode (UTF-8)	Response Encoding:	Unicode (UTF-8)

Trace Information
Category	Message	From First(s)	From Last(s)
aspx.page	Begin PreInit
aspx.page	End PreInit	0,000032	0,000032
aspx.page	Begin Init	0,000041	0,000009
	LoginControl_Init - isValidForThisDomain: True	0,000158	0,000117
	LoginControl - SetupWebsite - proceed: True, GoAnCode: , TagManagerId:	0,000239	0,000081
	This is page: homepage.aspx. With masterpagefile:	0,000470	0,000231
	CSS template IDs found:	0,000972	0,000502
	End load CSS from Wiser...	0,000987	0,000015
	JS template IDs found:	0,001416	0,000429
	NO JS template inline found	0,001430	0,000013
	End load JS from Wiser...	0,001439	0,000009
aspx.page	End Init	0,001497	0,000058
aspx.page	Begin InitComplete	0,001508	0,000011
aspx.page	End InitComplete	0,001517	0,000009
aspx.page	Begin PreLoad	0,001528	0,000010
aspx.page	End PreLoad	0,001544	0,000016
aspx.page	Begin Load	0,001549	0,000006
aspx.page	End Load	0,001578	0,000028
aspx.page	Begin LoadComplete	0,001584	0,000006
aspx.page	End LoadComplete	0,001589	0,000005
aspx.page	Begin PreRender	0,001595	0,000005
aspx.page	End PreRender	0,001843	0,000249
aspx.page	Begin PreRenderComplete	0,001857	0,000014
aspx.page	End PreRenderComplete	0,001863	0,000006
aspx.page	Begin SaveState	0,002017	0,000154
aspx.page	End SaveState	0,002023	0,000006
aspx.page	Begin SaveStateComplete	0,002029	0,000006
aspx.page	End SaveStateComplete	0,002038	0,000009
aspx.page	Begin Render	0,002043	0,000005
	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,018536	0,016492
	Open connection with DB	0,018722	0,000186
	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,203994	0,185273
	RenderStep Kies uw buitendeur connected to: 2289 - mainstepnumber: 1 - stepnumber: 1 - dependentvalue: 2289 - datasource connectedid: 2289	0,470306	0,266312
	[RenderValues] set query and/or replacements	0,476873	0,006567
	[RenderValues] Execute query	0,500697	0,023824
	query cachinghours: 200	0,501343	0,000645
	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,501492	0,000149
	Open connection with DB	0,501597	0,000106
	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	1,217363	0,715766
	[RenderValues] Do last replacements. Num items: 33	1,217437	0,000074
	[RenderValues] replacements done	1,777616	0,560180
	RenderStep (values rendered) Kies uw buitendeur connected to: 2289 - mainstepnumber: 1 - stepnumber: 1 - dependentvalue: 2289 - datasource connectedid: 2289	1,820546	0,042929
	[RenderValues] set query and/or replacements	1,824005	0,003459
	RenderSubStep connected to: - mainstepnumber: 1 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	1,824072	0,000067
	Language 38 is new	1,872155	0,048083
	Caching of languagewords in cache is starting because 'ML_38' is empty	1,872227	0,000072
	QUERY SYSCON START: SELECT fieldname, translation FROM site_languagefields WHERE languageid = ?languageId GROUP BY fieldname	1,872673	0,000447
	Open connection with DB	1,872707	0,000033
	QUERY SYSCON END: SELECT fieldname, translation FROM site_languagefields WHERE languageid = ?languageId GROUP BY fieldname	1,994231	0,121524
	0 woorden gecached voor key 'ML_38'	1,994487	0,000256
	Session 'MlJclLanguage' set to 38	1,994529	0,000042
	Start replace dynamic content	1,999741	0,005212
	Replace dynamic content only once	2,000069	0,000328
	End replace dynamic content	2,000092	0,000023
	Filled translationcomponent from cache.	2,000899	0,000807
	No caching of lanuage 38. Because it is not changed within this session.	2,089318	0,088419
	Cache item 'ML_38' already exists, so language is not cached again	2,089392	0,000074
	Session 'MlJclLanguage' set to 38	2,089402	0,000010
	Start replace dynamic content	2,089819	0,000417
	Replace dynamic content only once	2,090755	0,000936
	End replace dynamic content	2,090775	0,000021
	Filled translationcomponent from cache.	2,091739	0,000964
	Start replacing system objects	2,124307	0,032567
	Start replacing translation	2,125768	0,001461
	Start replacing objects	2,126190	0,000422
	Start replacing request	2,126641	0,000451
	Start replacing session	2,174931	0,048290
	Start replacing standards	2,195854	0,020923
	Start replacing objecs again	2,196627	0,000773
	[RenderValues] set query and/or replacements	2,374812	0,178185
	RenderSubStep connected to: - mainstepnumber: 1 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	2,374882	0,000070
	No caching of lanuage 38. Because it is not changed within this session.	2,375167	0,000285
	Cache item 'ML_38' already exists, so language is not cached again	2,375209	0,000043
	Session 'MlJclLanguage' set to 38	2,375224	0,000014
	Start replace dynamic content	2,375256	0,000032
	Replace dynamic content only once	2,375344	0,000088
	End replace dynamic content	2,375351	0,000007
	Filled translationcomponent from cache.	2,375879	0,000528
	QUERY SYSCON START: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	2,412969	0,037090
	Open connection with DB	2,413140	0,000171
	QUERY SYSCON END: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	2,471751	0,058611
	RenderStep Binnendraaiend connected to: binnendeuren deurtype - mainstepnumber: 2 - stepnumber: 1 - dependentvalue: 1 - datasource connectedid: binnendeuren - deurtype	2,475347	0,003597
	[RenderValues] set query and/or replacements	2,475456	0,000109
	RenderStep (values rendered) Binnendraaiend connected to: binnendeuren deurtype - mainstepnumber: 2 - stepnumber: 1 - dependentvalue: 1 - datasource connectedid: binnendeuren - deurtype	2,475515	0,000060
	[RenderValues] set query and/or replacements	2,475561	0,000045
	[RenderValues] Execute query	2,475904	0,000344
	query cachinghours: 200	2,475995	0,000090
	QUERY SYSCON START: SET @isBinnen = IF('{uitvoering}' ='Binnendraaiend', true,false); SET @isSet = IF('{uitvoering}' LIKE '{%}', false, true); SELECT * FROM ( SELECT 'Links binnendraaiend' AS valuelist_1, 'linksbinnendraaiend' AS valuelist_2, 'L1' AS valuelist_3 UNION SELECT'Rechts binnendraaiend', 'rechtsbinnendraaiend', 'R2' ) binnen WHERE @isBinnen AND @isSet UNION ALL SELECT * FROM ( SELECT 'Links buitendraaiend' AS valuelist_1, 'linksbuitendraaiend' AS valuelist_2, 'L3' AS valuelist_3 UNION SELECT'Rechts buitendraaiend', 'rechtsbuitendraaiend', 'R4' ) buiten WHERE @isBinnen = false AND @isSet;	2,476017	0,000022
	Open connection with DB	2,476046	0,000029
	QUERY SYSCON END: SET @isBinnen = IF('{uitvoering}' ='Binnendraaiend', true,false); SET @isSet = IF('{uitvoering}' LIKE '{%}', false, true); SELECT * FROM ( SELECT 'Links binnendraaiend' AS valuelist_1, 'linksbinnendraaiend' AS valuelist_2, 'L1' AS valuelist_3 UNION SELECT'Rechts binnendraaiend', 'rechtsbinnendraaiend', 'R2' ) binnen WHERE @isBinnen AND @isSet UNION ALL SELECT * FROM ( SELECT 'Links buitendraaiend' AS valuelist_1, 'linksbuitendraaiend' AS valuelist_2, 'L3' AS valuelist_3 UNION SELECT'Rechts buitendraaiend', 'rechtsbuitendraaiend', 'R4' ) buiten WHERE @isBinnen = false AND @isSet;	2,492608	0,016562
	[RenderValues] Do last replacements. Num items: 0	2,492663	0,000055
	[RenderValues] replacements done	2,492672	0,000009
	RenderSubStep Kies een draairichting (binnen)_kopie connected to: draairichting - mainstepnumber: 2 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: draairichting	2,492721	0,000049
	No caching of lanuage 38. Because it is not changed within this session.	2,493187	0,000466
	Cache item 'ML_38' already exists, so language is not cached again	2,493236	0,000049
	Session 'MlJclLanguage' set to 38	2,493289	0,000053
	Start replace dynamic content	2,493334	0,000045
	Replace dynamic content only once	2,493604	0,000270
	End replace dynamic content	2,493630	0,000026
	Filled translationcomponent from cache.	2,494416	0,000787
	No caching of lanuage 38. Because it is not changed within this session.	2,532942	0,038526
	Cache item 'ML_38' already exists, so language is not cached again	2,533018	0,000076
	Session 'MlJclLanguage' set to 38	2,533037	0,000019
	Start replace dynamic content	2,533124	0,000087
	QUERY SYSCON START: SELECT * FROM easy_webpages WHERE id=64	2,551232	0,018107
	Open connection with DB	2,551281	0,000050
	QUERY SYSCON END: SELECT * FROM easy_webpages WHERE id=64	2,574762	0,023481
	Set SEO fields on webpage	2,574800	0,000039
	title: Welkom op mijn website	2,574811	0,000011
	metadescription: Vul hier de meta description in	2,574818	0,000007
	canonicalurl:	2,574825	0,000007
	noindex: False	2,574833	0,000008
	nofollow: False	2,574840	0,000007
	AddSEOFields: Title=Welkom op mijn website, Description=Vul hier de meta description in, Keywords=Vul hier de metatags in, CanonicalURL=, NoIndex=False, NoFollow=False, Robots=	2,574852	0,000013
	Trying to add meta data, but no header with runat='server' was found	2,574863	0,000010
	Start replace dynamic content	2,574910	0,000047
	Replace dynamic content only once	2,574994	0,000085
	End replace dynamic content	2,575002	0,000007
	Filled translationcomponent from cache.	2,575672	0,000670
	Start replace dynamic content	2,578694	0,003022
	End replace dynamic content	2,578880	0,000186
	Filled translationcomponent from cache.	2,579554	0,000675
	End replace dynamic content	2,613718	0,034164
	Filled translationcomponent from cache.	2,614541	0,000823
	[RenderValues] set query and/or replacements	2,648956	0,034415
	[RenderValues] Execute query	2,649412	0,000456
	query cachinghours: 200	2,649509	0,000097
	query from cache 'JCLDC2a8ee254c5365604b0b2bdf7a6987f6c'	2,649526	0,000017
	QUERY SYSCON END (FROM CACHE): SET @isBinnen = IF('{uitvoering}' ='Binnendraaiend', true,false); SET @isSet = IF('{uitvoering}' LIKE '{%}', false, true); SELECT * FROM ( SELECT 'Links binnendraaiend' AS valuelist_1, 'linksbinnendraaiend' AS valuelist_2, 'L1' AS valuelist_3 UNION SELECT'Rechts binnendraaiend', 'rechtsbinnendraaiend', 'R2' ) binnen WHERE @isBinnen AND @isSet UNION ALL SELECT * FROM ( SELECT 'Links buitendraaiend' AS valuelist_1, 'linksbuitendraaiend' AS valuelist_2, 'L3' AS valuelist_3 UNION SELECT'Rechts buitendraaiend', 'rechtsbuitendraaiend', 'R4' ) buiten WHERE @isBinnen = false AND @isSet;	2,649563	0,000038
	[RenderValues] Do last replacements. Num items: 0	2,649607	0,000043
	[RenderValues] replacements done	2,649615	0,000008
	RenderSubStep Kies een draairichting (binnen)_kopie connected to: draairichting - mainstepnumber: 2 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: draairichting	2,649630	0,000015
	No caching of lanuage 38. Because it is not changed within this session.	2,649929	0,000299
	Cache item 'ML_38' already exists, so language is not cached again	2,649952	0,000023
	Session 'MlJclLanguage' set to 38	2,649965	0,000013
	Start replace dynamic content	2,649996	0,000032
	Replace dynamic content only once	2,650075	0,000079
	End replace dynamic content	2,650085	0,000009
	Filled translationcomponent from cache.	2,650782	0,000698
	RenderStep Bepaal de afmeting connected to: deurtype - mainstepnumber: 2 - stepnumber: 2 - dependentvalue: 1 - datasource connectedid: deurtype	2,677741	0,026959
	[RenderValues] set query and/or replacements	2,677794	0,000054
	[RenderValues] Execute query	2,678166	0,000371
	query cachinghours: 200	2,678237	0,000072
	QUERY SYSCON START: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SELECT DISTINCT(door.height) AS hoogte, 0 AS isAllInclusive FROM shop_products door JOIN shop_pro_cat spc ON spc.product_id = door.id JOIN shop_category doorCat ON doorCat.id = spc.cat_id AND doorCat.parent_cat_id=2289 AND doorCat.id=@doorCat AND doorCat.visiblecando<>0 LEFT JOIN shop_products glass_org ON glass_org.id=@doorGlass LEFT JOIN shop_products glass_avail ON glass_avail.description_short=glass_org.description_short LEFT JOIN shop_koppeling k ON k.prod_dest=door.id AND k.prod_source=glass_avail.id WHERE IF(@doorGlass>0, k.id IS NOT NULL, 1) AND door.visiblecando<>0 ORDER BY door.height	2,678257	0,000020
	Open connection with DB	2,678277	0,000019
	QUERY SYSCON END: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SELECT DISTINCT(door.height) AS hoogte, 0 AS isAllInclusive FROM shop_products door JOIN shop_pro_cat spc ON spc.product_id = door.id JOIN shop_category doorCat ON doorCat.id = spc.cat_id AND doorCat.parent_cat_id=2289 AND doorCat.id=@doorCat AND doorCat.visiblecando<>0 LEFT JOIN shop_products glass_org ON glass_org.id=@doorGlass LEFT JOIN shop_products glass_avail ON glass_avail.description_short=glass_org.description_short LEFT JOIN shop_koppeling k ON k.prod_dest=door.id AND k.prod_source=glass_avail.id WHERE IF(@doorGlass>0, k.id IS NOT NULL, 1) AND door.visiblecando<>0 ORDER BY door.height	2,702166	0,023890
	[RenderValues] Do last replacements. Num items: 0	2,702208	0,000042
	[RenderValues] replacements done	2,702214	0,000006
	RenderStep (values rendered) Bepaal de afmeting connected to: deurtype - mainstepnumber: 2 - stepnumber: 2 - dependentvalue: 1 - datasource connectedid: deurtype	2,702249	0,000035
	[RenderValues] set query and/or replacements	2,702303	0,000054
	[RenderValues] Execute query	2,702789	0,000487
	query cachinghours: 200	2,702874	0,000085
	QUERY SYSCON START: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @turnType = IF('{draairichting}' IN ('R2/L3', 'L3', 'R2', 'links'), 'links', 'rechts'); SET @implementation = IF('{uitvoering}' IN('Buitendraaiend', 'Binnendraaiend', 'schuifdeur'), 'stomp', '{uitvoering}'); SET @implementation = IF(@implementation='opdek', CONCAT(@implementation, ' ', @turnType) , @implementation); SELECT DISTINCT(door.width) AS breedte FROM shop_products door JOIN shop_pro_cat spc ON spc.product_id = door.id JOIN shop_category doorCat ON doorCat.id=spc.cat_id AND doorCat.parent_cat_id=2289 AND doorCat.id=@doorCat AND doorCat.visiblecando<>0 LEFT JOIN shop_products glass_org ON glass_org.id=@doorGlass LEFT JOIN shop_products glass_avail ON glass_avail.description_short=glass_org.description_short AND glass_avail .visiblecando<>0 LEFT JOIN shop_koppeling k ON k.prod_dest=door.id AND k.prod_source=glass_avail.id WHERE (door.producttype = @implementation OR door.producttype = CONCAT(@implementation, ' ', @turnType)) AND door.height='{height}' #AND door.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', door.visiblecando, door.visiblecandoBranch) <> 0 AND IF(@doorGlass > 0, k.id IS NOT NULL, 1) ORDER BY door.width	2,702893	0,000019
	Open connection with DB	2,702930	0,000037
	QUERY SYSCON END: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @turnType = IF('{draairichting}' IN ('R2/L3', 'L3', 'R2', 'links'), 'links', 'rechts'); SET @implementation = IF('{uitvoering}' IN('Buitendraaiend', 'Binnendraaiend', 'schuifdeur'), 'stomp', '{uitvoering}'); SET @implementation = IF(@implementation='opdek', CONCAT(@implementation, ' ', @turnType) , @implementation); SELECT DISTINCT(door.width) AS breedte FROM shop_products door JOIN shop_pro_cat spc ON spc.product_id = door.id JOIN shop_category doorCat ON doorCat.id=spc.cat_id AND doorCat.parent_cat_id=2289 AND doorCat.id=@doorCat AND doorCat.visiblecando<>0 LEFT JOIN shop_products glass_org ON glass_org.id=@doorGlass LEFT JOIN shop_products glass_avail ON glass_avail.description_short=glass_org.description_short AND glass_avail .visiblecando<>0 LEFT JOIN shop_koppeling k ON k.prod_dest=door.id AND k.prod_source=glass_avail.id WHERE (door.producttype = @implementation OR door.producttype = CONCAT(@implementation, ' ', @turnType)) AND door.height='{height}' #AND door.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', door.visiblecando, door.visiblecandoBranch) <> 0 AND IF(@doorGlass > 0, k.id IS NOT NULL, 1) ORDER BY door.width	2,722163	0,019233
	[RenderValues] Do last replacements. Num items: 0	2,722215	0,000052
	[RenderValues] replacements done	2,722226	0,000012
	RenderSubStep Breedte_kopie connected to: hoogte - mainstepnumber: 2 - stepnumber: 2 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: hoogte	2,722269	0,000042
	No caching of lanuage 38. Because it is not changed within this session.	2,722654	0,000385
	Cache item 'ML_38' already exists, so language is not cached again	2,722680	0,000027
	Session 'MlJclLanguage' set to 38	2,722694	0,000014
	Start replace dynamic content	2,722734	0,000040
	Replace dynamic content only once	2,722827	0,000093
	End replace dynamic content	2,722839	0,000012
	Filled translationcomponent from cache.	2,723734	0,000894
	No caching of lanuage 38. Because it is not changed within this session.	2,755078	0,031344
	Cache item 'ML_38' already exists, so language is not cached again	2,755143	0,000065
	Session 'MlJclLanguage' set to 38	2,755152	0,000009
	Start replace dynamic content	2,755188	0,000037
	Replace dynamic content only once	2,755325	0,000137
	End replace dynamic content	2,755364	0,000039
	Filled translationcomponent from cache.	2,755878	0,000514
	[RenderValues] set query and/or replacements	2,789054	0,033176
	[RenderValues] Execute query	2,789687	0,000632
	query cachinghours: 200	2,789797	0,000110
	query from cache 'JCLDC0015ac3e0b58c863d35fc83966d4544d'	2,789813	0,000016
	QUERY SYSCON END (FROM CACHE): SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @turnType = IF('{draairichting}' IN ('R2/L3', 'L3', 'R2', 'links'), 'links', 'rechts'); SET @implementation = IF('{uitvoering}' IN('Buitendraaiend', 'Binnendraaiend', 'schuifdeur'), 'stomp', '{uitvoering}'); SET @implementation = IF(@implementation='opdek', CONCAT(@implementation, ' ', @turnType) , @implementation); SELECT DISTINCT(door.width) AS breedte FROM shop_products door JOIN shop_pro_cat spc ON spc.product_id = door.id JOIN shop_category doorCat ON doorCat.id=spc.cat_id AND doorCat.parent_cat_id=2289 AND doorCat.id=@doorCat AND doorCat.visiblecando<>0 LEFT JOIN shop_products glass_org ON glass_org.id=@doorGlass LEFT JOIN shop_products glass_avail ON glass_avail.description_short=glass_org.description_short AND glass_avail .visiblecando<>0 LEFT JOIN shop_koppeling k ON k.prod_dest=door.id AND k.prod_source=glass_avail.id WHERE (door.producttype = @implementation OR door.producttype = CONCAT(@implementation, ' ', @turnType)) AND door.height='{height}' #AND door.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', door.visiblecando, door.visiblecandoBranch) <> 0 AND IF(@doorGlass > 0, k.id IS NOT NULL, 1) ORDER BY door.width	2,789831	0,000018
	[RenderValues] Do last replacements. Num items: 0	2,789840	0,000009
	[RenderValues] replacements done	2,789846	0,000006
	RenderSubStep Breedte_kopie connected to: hoogte - mainstepnumber: 2 - stepnumber: 2 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid: hoogte	2,789859	0,000013
	No caching of lanuage 38. Because it is not changed within this session.	2,790103	0,000243
	Cache item 'ML_38' already exists, so language is not cached again	2,790117	0,000015
	Session 'MlJclLanguage' set to 38	2,790126	0,000009
	Start replace dynamic content	2,790152	0,000026
	Replace dynamic content only once	2,790203	0,000051
	End replace dynamic content	2,790210	0,000007
	Filled translationcomponent from cache.	2,791366	0,001156
	QUERY SYSCON START: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	2,824063	0,032697
	Open connection with DB	2,824229	0,000166
	QUERY SYSCON END: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	2,853470	0,029242
	RenderStep Veiligheidspakket connected to: uitvoering;draairichting;hoogte;breedte; - mainstepnumber: 3 - stepnumber: 1 - dependentvalue: 1 - datasource connectedid: uitvoering;draairichting;hoogte;breedte;	2,856133	0,002662
	[RenderValues] set query and/or replacements	2,856184	0,000051
	[RenderValues] Execute query	2,856867	0,000684
	query cachinghours: 200	2,856984	0,000117
	QUERY SYSCON START: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @_height = IF('{height}' LIKE '{%}', '', '{height}'); SET @_width = IF('{width}' LIKE '{%}', '', '{width}'); SET @implementation = IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}'); SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', '{draairichting}','%'), CONCAT('%',@implementation,'%'))); SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1); SELECT @doorId, p.id AS product_id, p.eancode, p.description_short AS description_short, IFNULL(p.serie, p.producttype) AS name, REPLACE(REPLACE(p.priceCando, '.',','), ',00', ',-') AS price, spk.cat_id, sp.bestandsnaam, suitable_for, suitable_for2 FROM shop_products p JOIN shop_koppeling k ON k.prod_dest = @doorId AND k.prod_source = p.id AND k.koppeltype = 'veiligheidspakket' JOIN shop_pro_cat spk ON spk.product_id=p.id LEFT JOIN shop_pictures sp ON sp.product_id=p.id AND sp.formaatnaam='normaal' WHERE IFNULL(p.serie, p.producttype) = 'Veiligheidspakket' AND ( NULLIF(p.suitable_for2,'') IS NULL OR suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(@implementation, 'schuifdeur', 'schuif'), '%') ) AND # turntypes (suitable_for IS NULL OR suitable_for = 'ALLE' OR '{draairichting}' LIKE CONCAT('%', suitable_for , '%') OR ( (SELECT suitable_for FROM shop_products WHERE eancode = '{draairichting}') LIKE CONCAT('%', suitable_for , '%') ) ) #AND p.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblecando, p.visiblecandoBranch) <> 0 /* AND ( ( @_height > CAST(p.min_maat_h AS DECIMAL(15,2)) AND @_height < CAST(p.max_maat_h AS DECIMAL(15,2)) AND @_width > CAST(p.min_maat_b AS DECIMAL(15,2)) AND @_width < CAST(p.max_maat_b AS DECIMAL(15,2)) ) OR ( p.min_maat_h IS NULL OR p.min_maat_h = '' OR CAST(p.min_maat_h = '0' AS DECIMAL(15,2)) ) AND ( p.max_maat_h IS NULL OR p.max_maat_h = '' OR CAST(p.max_maat_h = '0' AS DECIMAL(15,2)) ) AND ( p.min_maat_b IS NULL OR p.min_maat_b = '' OR CAST(p.min_maat_b = '0' AS DECIMAL(15,2)) ) AND ( p.max_maat_b IS NULL OR p.max_maat_b = '' OR CAST(p.max_maat_b = '0' AS DECIMAL(15,2)) ) ) */ ORDER BY name	2,857038	0,000054
	Open connection with DB	2,857175	0,000138
	QUERY SYSCON END: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @_height = IF('{height}' LIKE '{%}', '', '{height}'); SET @_width = IF('{width}' LIKE '{%}', '', '{width}'); SET @implementation = IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}'); SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', '{draairichting}','%'), CONCAT('%',@implementation,'%'))); SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1); SELECT @doorId, p.id AS product_id, p.eancode, p.description_short AS description_short, IFNULL(p.serie, p.producttype) AS name, REPLACE(REPLACE(p.priceCando, '.',','), ',00', ',-') AS price, spk.cat_id, sp.bestandsnaam, suitable_for, suitable_for2 FROM shop_products p JOIN shop_koppeling k ON k.prod_dest = @doorId AND k.prod_source = p.id AND k.koppeltype = 'veiligheidspakket' JOIN shop_pro_cat spk ON spk.product_id=p.id LEFT JOIN shop_pictures sp ON sp.product_id=p.id AND sp.formaatnaam='normaal' WHERE IFNULL(p.serie, p.producttype) = 'Veiligheidspakket' AND ( NULLIF(p.suitable_for2,'') IS NULL OR suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(@implementation, 'schuifdeur', 'schuif'), '%') ) AND # turntypes (suitable_for IS NULL OR suitable_for = 'ALLE' OR '{draairichting}' LIKE CONCAT('%', suitable_for , '%') OR ( (SELECT suitable_for FROM shop_products WHERE eancode = '{draairichting}') LIKE CONCAT('%', suitable_for , '%') ) ) #AND p.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblecando, p.visiblecandoBranch) <> 0 /* AND ( ( @_height > CAST(p.min_maat_h AS DECIMAL(15,2)) AND @_height < CAST(p.max_maat_h AS DECIMAL(15,2)) AND @_width > CAST(p.min_maat_b AS DECIMAL(15,2)) AND @_width < CAST(p.max_maat_b AS DECIMAL(15,2)) ) OR ( p.min_maat_h IS NULL OR p.min_maat_h = '' OR CAST(p.min_maat_h = '0' AS DECIMAL(15,2)) ) AND ( p.max_maat_h IS NULL OR p.max_maat_h = '' OR CAST(p.max_maat_h = '0' AS DECIMAL(15,2)) ) AND ( p.min_maat_b IS NULL OR p.min_maat_b = '' OR CAST(p.min_maat_b = '0' AS DECIMAL(15,2)) ) AND ( p.max_maat_b IS NULL OR p.max_maat_b = '' OR CAST(p.max_maat_b = '0' AS DECIMAL(15,2)) ) ) */ ORDER BY name	2,877822	0,020647
	[RenderValues] Do last replacements. Num items: 0	2,877868	0,000046
	[RenderValues] replacements done	2,877879	0,000012
	RenderStep (values rendered) Veiligheidspakket connected to: uitvoering;draairichting;hoogte;breedte; - mainstepnumber: 3 - stepnumber: 1 - dependentvalue: 1 - datasource connectedid: uitvoering;draairichting;hoogte;breedte;	2,877920	0,000041
	[RenderValues] set query and/or replacements	2,877991	0,000071
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	2,878009	0,000018
	No caching of lanuage 38. Because it is not changed within this session.	2,878294	0,000285
	Cache item 'ML_38' already exists, so language is not cached again	2,878317	0,000024
	Session 'MlJclLanguage' set to 38	2,878332	0,000015
	Start replace dynamic content	2,878366	0,000034
	Replace dynamic content only once	2,878477	0,000111
	End replace dynamic content	2,878490	0,000013
	Filled translationcomponent from cache.	2,879291	0,000801
	No caching of lanuage 38. Because it is not changed within this session.	2,918698	0,039407
	Cache item 'ML_38' already exists, so language is not cached again	2,918776	0,000078
	Session 'MlJclLanguage' set to 38	2,918796	0,000020
	Start replace dynamic content	2,918845	0,000049
	Replace dynamic content only once	2,918957	0,000113
	End replace dynamic content	2,918967	0,000010
	Filled translationcomponent from cache.	2,919547	0,000581
	[RenderValues] set query and/or replacements	2,946154	0,026606
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 1 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	2,946210	0,000056
	No caching of lanuage 38. Because it is not changed within this session.	2,946460	0,000250
	Cache item 'ML_38' already exists, so language is not cached again	2,946492	0,000032
	Session 'MlJclLanguage' set to 38	2,946500	0,000009
	Start replace dynamic content	2,946524	0,000024
	Replace dynamic content only once	2,946597	0,000073
	End replace dynamic content	2,946603	0,000007
	Filled translationcomponent from cache.	2,947109	0,000506
	RenderStep Driepuntssluiting (alleen bij geen veiligheidspakket) connected to: veiligheidspakket;uitvoering;draairichting;hoogte;breedte - mainstepnumber: 3 - stepnumber: 2 - dependentvalue: 1 - datasource connectedid: veiligheidspakket;uitvoering;draairichting;hoogte;breedte	2,976938	0,029829
	[RenderValues] set query and/or replacements	2,977004	0,000067
	[RenderValues] Execute query	2,978076	0,001072
	query cachinghours: 200	2,978189	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); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @implementation = IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}'); SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', '{draairichting}','%'), CONCAT('%',@implementation,'%'))); SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1); SET @isIndustrial = (SELECT IF(COUNT()>0,true,false) FROM shop_category WHERE id=@doorCat AND style LIKE '%industrial%'); SET @isDouble = IF('{dubbel}' = 'Ja', true, false); SET @results = false; SELECT FROM ( SELECT 'Geen driepuntsluiting' AS valuelist_1, 0 AS valuelist_2, 0 AS valuelist_3, 0 AS result UNION SELECT IF(p.serie LIKE '%sleutel%','Sleutelbediend','Krukbediend'), IF(p.serie LIKE '%sleutel%','sleutelbediend','krukbediend'), p.id, GREATEST(@results := true, -1) AS result FROM shop_products p JOIN shop_koppeling k ON k.prod_source=p.id AND k.prod_dest = @doorId AND k.koppeltype = 'Driepuntssluiting' WHERE ( NULLIF(p.suitable_for2,'') IS NULL OR suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(@implementation, 'schuifdeur', 'schuif'), '%') ) AND # turntypes (suitable_for IS NULL OR suitable_for = 'ALLE' OR REPLACE(REPLACE('{draairichting}', 'links', 'R2/L3'), 'rechts', 'L1/R4') LIKE CONCAT('%', suitable_for , '%') OR #inverted suitable_for LIKE CONCAT('%', REPLACE(REPLACE('{draairichting}', 'links', 'R2/L3'), 'rechts', 'L1/R4') , '%') OR ( (SELECT suitable_for FROM shop_products WHERE eancode = '{draairichting}') LIKE CONCAT('%', suitable_for , '%') ) ) #AND p.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblecando, p.visiblecandoBranch) <> 0 GROUP BY p.id ) res WHERE '{veiligheidspakketJanee}' = 'Nee' AND @results	2,978217	0,000028
	Open connection with DB	2,978260	0,000043
	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	3,020878	0,042619
	[RenderValues] Do last replacements. Num items: 0	3,020931	0,000053
	[RenderValues] replacements done	3,020940	0,000009
	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	3,020972	0,000031
	[RenderValues] set query and/or replacements	3,021030	0,000059
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 2 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	3,021039	0,000009
	No caching of lanuage 38. Because it is not changed within this session.	3,021274	0,000235
	Cache item 'ML_38' already exists, so language is not cached again	3,021306	0,000031
	Session 'MlJclLanguage' set to 38	3,021318	0,000013
	Start replace dynamic content	3,021340	0,000022
	Replace dynamic content only once	3,021465	0,000125
	End replace dynamic content	3,021480	0,000016
	Filled translationcomponent from cache.	3,022131	0,000651
	No caching of lanuage 38. Because it is not changed within this session.	3,049426	0,027295
	Cache item 'ML_38' already exists, so language is not cached again	3,049488	0,000062
	Session 'MlJclLanguage' set to 38	3,049497	0,000009
	Start replace dynamic content	3,049530	0,000033
	Replace dynamic content only once	3,049620	0,000090
	End replace dynamic content	3,049626	0,000007
	Filled translationcomponent from cache.	3,050034	0,000408
	[RenderValues] set query and/or replacements	3,081624	0,031590
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 2 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	3,081691	0,000067
	No caching of lanuage 38. Because it is not changed within this session.	3,081958	0,000267
	Cache item 'ML_38' already exists, so language is not cached again	3,081996	0,000038
	Session 'MlJclLanguage' set to 38	3,082006	0,000010
	Start replace dynamic content	3,082029	0,000023
	Replace dynamic content only once	3,082148	0,000119
	End replace dynamic content	3,082159	0,000011
	Filled translationcomponent from cache.	3,083015	0,000857
	RenderStep Slotgatfrezing (bij geen driepuntsluiting) nieuw connected to: driepuntsluiting;veiligheidspakket;uitvoering;breedte;hoogte - mainstepnumber: 3 - stepnumber: 3 - dependentvalue: 1 - datasource connectedid: driepuntsluiting;veiligheidspakket;uitvoering;breedte;hoogte	3,112215	0,029200
	[RenderValues] set query and/or replacements	3,112270	0,000055
	[RenderValues] Execute query	3,112864	0,000594
	query cachinghours: 200	3,112953	0,000088
	QUERY SYSCON START: # Keep this query the same in ALL configurators for the "Accessoires" STEP!!! SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @implementation = IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}'); SET @turntype = IF('{draairichting}' LIKE '{%}', '','{draairichting}'); SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', @turntype,'%'), CONCAT('%',@implementation,'%'))); SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1); SET @isIndustrial = (SELECT IF(COUNT()>0,true,false) FROM shop_category WHERE id=@doorCat AND style LIKE '%industrial%'); SET @isDouble = IF('{dubbel}' = 'Ja', true, false); SELECT @doorId, IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%', '2x ','') AS ammountPrefix, IFNULL(info.html, '') AS info, p.id AS product_id, CONCAT(IF(@isDouble, ' ', ''), p.description_short) AS product_description, IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', ''))) AS product_name, REPLACE(REPLACE(p.pricecando IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%',2,1), '.',','), ',00', ',-') AS price, 'images/prod-scharnieren.png' AS product_image, spk.cat_id, IFNULL(sp.bestandsnaam, '') AS bestandsnaam, p.suitable_for, p.suitable_for2 FROM shop_products p JOIN shop_koppeling k ON k.prod_dest = @doorId AND k.prod_source = p.id AND k.koppeltype = 'service' JOIN shop_pro_cat spk ON spk.product_id=p.id #AND spk.cat_id IN(2386)# CAT (accessoires) LEFT JOIN easy_webpages info ON info.seoname = CONCAT('uitleg-', IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', '')))) LEFT JOIN shop_pictures sp ON sp.product_id=p.id AND sp.formaatnaam='normaal' WHERE (NULLIF(p.suitable_for2,'') IS NULL OR p.suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(LOWER(@implementation), 'schuifdeur', 'schuif'), '%') ) AND # turntypes (p.suitable_for IS NULL OR p.suitable_for = 'ALLE' OR REPLACE(REPLACE(@turntype, 'links', 'R2/L3'), 'rechts', 'L1/R4') LIKE CONCAT('%', p.suitable_for , '%') OR # reversed p.suitable_for LIKE CONCAT('%', REPLACE(REPLACE(@turntype, 'links', 'R2/L3'), 'rechts', 'L1/R4') , '%') OR ( (SELECT suitable_for FROM shop_products WHERE eancode = @turntype) LIKE CONCAT('%', p.suitable_for , '%') ) ) AND ('{driepuntssluiting}' = '0' OR '{driepuntssluiting}' LIKE '{%}') AND ('{veiligheidspakketJanee}' = 'Nee' OR '{veiligheidspakketJanee}' LIKE '{%}') AND p.producttype='slotgatfrezing' #AND p.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblecando, p.visiblecandoBranch) <> 0 GROUP BY p.id ORDER BY product_name	3,112971	0,000018
	Open connection with DB	3,113023	0,000052
	QUERY SYSCON END: # Keep this query the same in ALL configurators for the "Accessoires" STEP!!! SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @implementation = IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}'); SET @turntype = IF('{draairichting}' LIKE '{%}', '','{draairichting}'); SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', @turntype,'%'), CONCAT('%',@implementation,'%'))); SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1); SET @isIndustrial = (SELECT IF(COUNT()>0,true,false) FROM shop_category WHERE id=@doorCat AND style LIKE '%industrial%'); SET @isDouble = IF('{dubbel}' = 'Ja', true, false); SELECT @doorId, IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%', '2x ','') AS ammountPrefix, IFNULL(info.html, '') AS info, p.id AS product_id, CONCAT(IF(@isDouble, ' ', ''), p.description_short) AS product_description, IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', ''))) AS product_name, REPLACE(REPLACE(p.pricecando IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%',2,1), '.',','), ',00', ',-') AS price, 'images/prod-scharnieren.png' AS product_image, spk.cat_id, IFNULL(sp.bestandsnaam, '') AS bestandsnaam, p.suitable_for, p.suitable_for2 FROM shop_products p JOIN shop_koppeling k ON k.prod_dest = @doorId AND k.prod_source = p.id AND k.koppeltype = 'service' JOIN shop_pro_cat spk ON spk.product_id=p.id #AND spk.cat_id IN(2386)# CAT (accessoires) LEFT JOIN easy_webpages info ON info.seoname = CONCAT('uitleg-', IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', '')))) LEFT JOIN shop_pictures sp ON sp.product_id=p.id AND sp.formaatnaam='normaal' WHERE (NULLIF(p.suitable_for2,'') IS NULL OR p.suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(LOWER(@implementation), 'schuifdeur', 'schuif'), '%') ) AND # turntypes (p.suitable_for IS NULL OR p.suitable_for = 'ALLE' OR REPLACE(REPLACE(@turntype, 'links', 'R2/L3'), 'rechts', 'L1/R4') LIKE CONCAT('%', p.suitable_for , '%') OR # reversed p.suitable_for LIKE CONCAT('%', REPLACE(REPLACE(@turntype, 'links', 'R2/L3'), 'rechts', 'L1/R4') , '%') OR ( (SELECT suitable_for FROM shop_products WHERE eancode = @turntype) LIKE CONCAT('%', p.suitable_for , '%') ) ) AND ('{driepuntssluiting}' = '0' OR '{driepuntssluiting}' LIKE '{%}') AND ('{veiligheidspakketJanee}' = 'Nee' OR '{veiligheidspakketJanee}' LIKE '{%}') AND p.producttype='slotgatfrezing' #AND p.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblecando, p.visiblecandoBranch) <> 0 GROUP BY p.id ORDER BY product_name	3,138355	0,025332
	[RenderValues] Do last replacements. Num items: 0	3,138439	0,000084
	[RenderValues] replacements done	3,138451	0,000012
	RenderStep (values rendered) Slotgatfrezing (bij geen driepuntsluiting) nieuw connected to: driepuntsluiting;veiligheidspakket;uitvoering;breedte;hoogte - mainstepnumber: 3 - stepnumber: 3 - dependentvalue: 1 - datasource connectedid: driepuntsluiting;veiligheidspakket;uitvoering;breedte;hoogte	3,138492	0,000041
	[RenderValues] set query and/or replacements	3,138571	0,000078
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 3 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	3,138584	0,000013
	No caching of lanuage 38. Because it is not changed within this session.	3,138831	0,000247
	Cache item 'ML_38' already exists, so language is not cached again	3,138868	0,000037
	Session 'MlJclLanguage' set to 38	3,138885	0,000017
	Start replace dynamic content	3,138912	0,000028
	Replace dynamic content only once	3,138995	0,000083
	End replace dynamic content	3,139007	0,000011
	Filled translationcomponent from cache.	3,139659	0,000653
	No caching of lanuage 38. Because it is not changed within this session.	3,174727	0,035067
	Cache item 'ML_38' already exists, so language is not cached again	3,174791	0,000064
	Session 'MlJclLanguage' set to 38	3,174799	0,000009
	Start replace dynamic content	3,174829	0,000030
	Replace dynamic content only once	3,174905	0,000076
	End replace dynamic content	3,174912	0,000007
	Filled translationcomponent from cache.	3,175436	0,000524
	[RenderValues] set query and/or replacements	3,214569	0,039133
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 3 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	3,214628	0,000060
	No caching of lanuage 38. Because it is not changed within this session.	3,214840	0,000212
	Cache item 'ML_38' already exists, so language is not cached again	3,214866	0,000025
	Session 'MlJclLanguage' set to 38	3,214874	0,000008
	Start replace dynamic content	3,214892	0,000018
	Replace dynamic content only once	3,214971	0,000080
	End replace dynamic content	3,214981	0,000010
	Filled translationcomponent from cache.	3,215451	0,000470
	RenderStep Accessoires connected to: uitvoering;draairichting;hoogte;breedte - mainstepnumber: 3 - stepnumber: 4 - dependentvalue: 1 - datasource connectedid: uitvoering;draairichting;hoogte;breedte	3,240653	0,025203
	[RenderValues] set query and/or replacements	3,240735	0,000082
	[RenderValues] Execute query	3,241269	0,000534
	query cachinghours: 200	3,241346	0,000077
	QUERY SYSCON START: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @implementation = IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}'); SET @turntype = IF('{draairichting}' LIKE '{%}', '','{draairichting}'); SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', @turntype,'%'), CONCAT('%',@implementation,'%'))); SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1); SET @isIndustrial = (SELECT IF(COUNT()>0,true,false) FROM shop_category WHERE id=@doorCat AND style LIKE '%industrial%'); SET @isDouble = IF('{dubbel}' = 'Ja', true, false); SELECT @doorId, IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%', '2x ','') AS ammountPrefix, #IFNULL(info.html, '') AS info, p.usp_s AS info, p.id AS product_id, CONCAT(IF(@isDouble, ' ', ''), p.description_short) AS product_description, LOWER(IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', '')))) AS product_name, REPLACE(REPLACE(IFNULL(SUM(innerProducts.pricecando), p.pricecando) IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%',2,1), '.',','), ',00', ',-') AS price, 'images/prod-scharnieren.png' AS product_image, spk.cat_id, IFNULL(MIN(spi.bestandsnaam), sp.bestandsnaam) AS bestandsnaam, p.suitable_for, p.suitable_for2 FROM shop_products p JOIN shop_koppeling k ON k.prod_dest = @doorId AND k.prod_source = p.id AND k.koppeltype IN ('accessoire', 'accessoirepakket') JOIN shop_pro_cat spk ON spk.product_id=p.id #AND spk.cat_id IN(2386)# CAT (accessoires) LEFT JOIN easy_webpages info ON info.seoname = CONCAT('uitleg-', IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', '')))) LEFT JOIN shop_pictures sp ON sp.product_id=p.id AND sp.formaatnaam='normaal' LEFT JOIN shop_koppeling k2 ON k2.prod_dest = k.prod_source AND k2.koppeltype='accessoire' # schuifsysteem LEFT JOIN shop_products innerProducts ON innerProducts.id=k2.prod_source LEFT JOIN shop_pictures spi ON spi.product_id=innerProducts.id AND spi.formaatnaam='normaal' WHERE (NULLIF(p.suitable_for2,'') IS NULL OR p.suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(LOWER(@implementation), 'schuifdeur', 'schuif'), '%') ) AND # turntypes (p.suitable_for IS NULL OR p.suitable_for = 'ALLE' OR REPLACE(REPLACE(@turntype, 'links', 'R2/L3'), 'rechts', 'L1/R4') LIKE CONCAT('%', p.suitable_for , '%') OR ( (SELECT suitable_for FROM shop_products WHERE eancode = @turntype) LIKE CONCAT('%', p.suitable_for , '%') ) ) #AND p.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblecando, p.visiblecandoBranch) <> 0 GROUP BY p.id ORDER BY product_name	3,241394	0,000048
	Open connection with DB	3,241450	0,000056
	QUERY SYSCON END: SET @doorChoice = IF('{deurtype}' LIKE '{%}', '0,0,0', '{deurtype}'); SET @doorCat = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 1), ',', -1) AS UNSIGNED); SET @doorGlass = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 2), ',', -1) AS UNSIGNED); SET @doorExtra = CAST(SUBSTRING_INDEX(SUBSTRING_INDEX(@doorChoice, ',', 3), ',', -1) AS UNSIGNED); SET @implementation = IF('{uitvoering}'='Binnendraaiend' OR '{uitvoering}'='Buitendraaiend', 'stomp','{uitvoering}'); SET @turntype = IF('{draairichting}' LIKE '{%}', '','{draairichting}'); SET @implementationTest = IF(@implementation = 'schuifdeur', '%stomp%', IF(@implementation='opdek', CONCAT('%',@implementation, ' ', @turntype,'%'), CONCAT('%',@implementation,'%'))); SET @doorId = (SELECT p.id FROM shop_products p JOIN shop_pro_cat parent ON parent.product_id=p.id AND parent.cat_id=@doorCat WHERE p.height='{height}' AND p.width='{width}' AND p.producttype LIKE @implementationTest LIMIT 1); SET @isIndustrial = (SELECT IF(COUNT()>0,true,false) FROM shop_category WHERE id=@doorCat AND style LIKE '%industrial%'); SET @isDouble = IF('{dubbel}' = 'Ja', true, false); SELECT @doorId, IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%', '2x ','') AS ammountPrefix, #IFNULL(info.html, '') AS info, p.usp_s AS info, p.id AS product_id, CONCAT(IF(@isDouble, ' ', ''), p.description_short) AS product_description, LOWER(IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', '')))) AS product_name, REPLACE(REPLACE(IFNULL(SUM(innerProducts.pricecando), p.pricecando) IF(p.suitable_for2 LIKE '%enkel%' AND p.suitable_for2 LIKE '%dubbel%',2,1), '.',','), ',00', ',-') AS price, 'images/prod-scharnieren.png' AS product_image, spk.cat_id, IFNULL(MIN(spi.bestandsnaam), sp.bestandsnaam) AS bestandsnaam, p.suitable_for, p.suitable_for2 FROM shop_products p JOIN shop_koppeling k ON k.prod_dest = @doorId AND k.prod_source = p.id AND k.koppeltype IN ('accessoire', 'accessoirepakket') JOIN shop_pro_cat spk ON spk.product_id=p.id #AND spk.cat_id IN(2386)# CAT (accessoires) LEFT JOIN easy_webpages info ON info.seoname = CONCAT('uitleg-', IFNULL(NULLIF(p.producttype,''), IFNULL(p.serie, REPLACE(p.description_short, ' ', '')))) LEFT JOIN shop_pictures sp ON sp.product_id=p.id AND sp.formaatnaam='normaal' LEFT JOIN shop_koppeling k2 ON k2.prod_dest = k.prod_source AND k2.koppeltype='accessoire' # schuifsysteem LEFT JOIN shop_products innerProducts ON innerProducts.id=k2.prod_source LEFT JOIN shop_pictures spi ON spi.product_id=innerProducts.id AND spi.formaatnaam='normaal' WHERE (NULLIF(p.suitable_for2,'') IS NULL OR p.suitable_for2 LIKE CONCAT('%', IF(@isDouble, 'dubbel', 'enkel'), ' ', REPLACE(LOWER(@implementation), 'schuifdeur', 'schuif'), '%') ) AND # turntypes (p.suitable_for IS NULL OR p.suitable_for = 'ALLE' OR REPLACE(REPLACE(@turntype, 'links', 'R2/L3'), 'rechts', 'L1/R4') LIKE CONCAT('%', p.suitable_for , '%') OR ( (SELECT suitable_for FROM shop_products WHERE eancode = @turntype) LIKE CONCAT('%', p.suitable_for , '%') ) ) #AND p.visiblecando<>0 AND IF('{branch}' LIKE '{%}' OR '{branch}' = '', p.visiblecando, p.visiblecandoBranch) <> 0 GROUP BY p.id ORDER BY product_name	3,284971	0,043521
	[RenderValues] Do last replacements. Num items: 0	3,285011	0,000040
	[RenderValues] replacements done	3,285017	0,000006
	RenderStep (values rendered) Accessoires connected to: uitvoering;draairichting;hoogte;breedte - mainstepnumber: 3 - stepnumber: 4 - dependentvalue: 1 - datasource connectedid: uitvoering;draairichting;hoogte;breedte	3,285045	0,000028
	[RenderValues] set query and/or replacements	3,285099	0,000054
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 4 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	3,285108	0,000009
	No caching of lanuage 38. Because it is not changed within this session.	3,285316	0,000208
	Cache item 'ML_38' already exists, so language is not cached again	3,285339	0,000024
	Session 'MlJclLanguage' set to 38	3,285351	0,000012
	Start replace dynamic content	3,285403	0,000052
	Replace dynamic content only once	3,285478	0,000075
	End replace dynamic content	3,285485	0,000007
	Filled translationcomponent from cache.	3,285916	0,000431
	No caching of lanuage 38. Because it is not changed within this session.	3,313275	0,027359
	Cache item 'ML_38' already exists, so language is not cached again	3,313338	0,000063
	Session 'MlJclLanguage' set to 38	3,313347	0,000009
	Start replace dynamic content	3,313403	0,000056
	Replace dynamic content only once	3,313482	0,000079
	End replace dynamic content	3,313489	0,000007
	Filled translationcomponent from cache.	3,313976	0,000488
	[RenderValues] set query and/or replacements	3,341362	0,027386
	RenderSubStep connected to: - mainstepnumber: 3 - stepnumber: 4 - substepnumber: 1 - dependentvalue: 1 - datasource connectedid:	3,341453	0,000091
	No caching of lanuage 38. Because it is not changed within this session.	3,341630	0,000177
	Cache item 'ML_38' already exists, so language is not cached again	3,341660	0,000030
	Session 'MlJclLanguage' set to 38	3,341668	0,000008
	Start replace dynamic content	3,341685	0,000017
	Replace dynamic content only once	3,341759	0,000073
	End replace dynamic content	3,341768	0,000009
	Filled translationcomponent from cache.	3,342177	0,000409
	QUERY SYSCON START: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,369338	0,027162
	Open connection with DB	3,369519	0,000181
	QUERY SYSCON END: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,399807	0,030288
	QUERY SYSCON START: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,401514	0,001707
	Open connection with DB	3,401708	0,000194
	QUERY SYSCON END: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,454722	0,053014
	QUERY SYSCON START: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,455940	0,001217
	Open connection with DB	3,456087	0,000147
	QUERY SYSCON END: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,486257	0,030171
	QUERY SYSCON START: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,488879	0,002622
	Open connection with DB	3,489061	0,000182
	QUERY SYSCON END: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,520902	0,031842
	QUERY SYSCON START: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,522229	0,001327
	Open connection with DB	3,522409	0,000179
	QUERY SYSCON END: SELECT #SUMMARY IFNULL(configvalues_duplicate.summary_template,configvalues.summary_template) AS summary_template ,IFNULL(configvalues_duplicate.summary_mainstep_template,configvalues.summary_mainstep_template) AS summary_mainstep_template ,IFNULL(configvalues_duplicate.summary_step_template,configvalues.summary_step_template) AS summary_step_template #PROGRESS ,IFNULL(configvalues_duplicate.pre_progress_template,configvalues.pre_progress_template) AS progress_pre_template ,IFNULL(configvalues_duplicate.pre_progress_step_template,configvalues.pre_progress_step_template) AS progress_pre_step_template ,IFNULL(configvalues_duplicate.pre_progress_substep_template,configvalues.pre_progress_substep_template) AS progress_pre_substep_template ,IFNULL(configvalues_duplicate.post_progress_template,configvalues.post_progress_template) AS progress_post_template ,IFNULL(configvalues_duplicate.post_progress_step_template,configvalues.post_progress_step_template) AS progress_post_step_template ,IFNULL(configvalues_duplicate.post_progress_substep_template,configvalues.post_progress_substep_template) AS progress_post_substep_template ,IFNULL(configvalues_duplicate.progress_template,configvalues.progress_template) AS progress_template ,IFNULL(configvalues_duplicate.progress_step_template,configvalues.progress_step_template) AS progress_step_template ,IFNULL(configvalues_duplicate.progress_substep_template,configvalues.progress_substep_template) AS progress_substep_template #CONFIGURATOR ,configurator.name ,IFNULL(configvalues_duplicate.template,configvalues.template) AS template ,configvalues.price_calculation_query #MAIN STEPS #,IF(mainstepvalues.step_template IS NULL OR TRIM(mainstepvalues.step_template)='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),mainstepvalues.step_template) AS mainstep_template ,IF(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template) IS NULL OR TRIM(IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template))='',IFNULL(configvalues_duplicate.step_template,configvalues.step_template),IFNULL(mainstepvalues_duplicate.step_template,mainstepvalues.step_template)) AS mainstep_template ,mainsteps.name AS mainstepname ,mainstepvalues.free_content1 AS mainstep_free_content1 ,mainstepvalues.free_content2 AS mainstep_free_content2 ,mainstepvalues.free_content3 AS mainstep_free_content3 ,mainstepvalues.free_content4 AS mainstep_free_content4 ,mainstepvalues.free_content5 AS mainstep_free_content5 #STEPS ,IF(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template) IS NULL OR TRIM(IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template))='',IFNULL(configvalues_duplicate.default_step_template,configvalues.default_step_template),IFNULL(stepvalues_duplicate.step_template,stepvalues.step_template)) AS step_template ,steps.name AS stepname ,IFNULL(stepvalues_duplicate.values_template,stepvalues.values_template) AS values_template ,stepvalues.datasource ,stepvalues.custom_query ,stepvalues.fixed_valuelist ,stepvalues.datasource_connectedtype ,IF(IFNULL(stepvalues.variable_name,'')='',steps.seoname,stepvalues.variable_name) AS variable_name ,stepvalues.free_content1 AS step_free_content1 ,stepvalues.free_content2 AS step_free_content2 ,stepvalues.free_content3 AS step_free_content3 ,stepvalues.free_content4 AS step_free_content4 ,stepvalues.free_content5 AS step_free_content5 ,stepvalues.datasource_connectedid ,stepvalues.isrequired ,stepvalues.check_connectedid #SUBSTEPS ,substeps.name AS substepname ,IFNULL(substepvalues_duplicate.step_template,substepvalues.step_template) AS substep_template ,IFNULL(substepvalues_duplicate.values_template,substepvalues.values_template) AS substep_values_template ,substepvalues.datasource AS substep_datasource ,substepvalues.custom_query AS substep_custom_query ,substepvalues.fixed_valuelist AS substep_fixed_valuelist ,substepvalues.datasource_connectedtype AS substep_datasource_connectedtype ,IF(IFNULL(substepvalues.variable_name,'')='',substeps.seoname,substepvalues.variable_name) AS substep_variable_name ,substepvalues.datasource_connectedid AS substep_datasource_connectedid ,substepvalues.isrequired AS substep_isrequired ,substepvalues.check_connectedid AS substep_check_connectedid #Get the applied regex ,IF(IFNULL(mainstepvalues.urlregex,'')<>'',mainstepvalues.urlregex, IF(IFNULL(stepvalues.urlregex,'')<>'',stepvalues.urlregex,IFNULL(substepvalues.urlregex,''))) AS urlregex FROM easy_items configurator JOIN `easy_configuratorsetup` configvalues ON configvalues.itemid = configurator.id LEFT JOIN `easy_configuratorsetup` configvalues_duplicate ON configvalues_duplicate.itemid=configvalues.duplicatelayoutfrom JOIN easy_items mainsteps ON mainsteps.moduleid=320 AND mainsteps.`level`=2 AND mainsteps.parent_id=configurator.id AND mainsteps.published=1 LEFT JOIN `easy_configuratorsetup` mainstepvalues ON mainstepvalues.itemid = mainsteps.id LEFT JOIN `easy_configuratorsetup` mainstepvalues_duplicate ON mainstepvalues_duplicate.itemid=mainstepvalues.duplicatelayoutfrom LEFT JOIN easy_items steps ON steps.moduleid=320 AND steps.`level`=3 AND steps.parent_id=mainsteps.id AND steps.published=1 LEFT JOIN `easy_configuratorsetup` stepvalues ON stepvalues.itemid = steps.id LEFT JOIN `easy_configuratorsetup` stepvalues_duplicate ON stepvalues_duplicate.itemid=stepvalues.duplicatelayoutfrom LEFT JOIN easy_items substeps ON substeps.moduleid=320 AND substeps.`level`=4 AND substeps.parent_id=steps.id AND substeps.published=1 LEFT JOIN `easy_configuratorsetup` substepvalues ON substepvalues.itemid = substeps.id LEFT JOIN `easy_configuratorsetup` substepvalues_duplicate ON substepvalues_duplicate.itemid=substepvalues.duplicatelayoutfrom WHERE configurator.moduleid=320 AND configurator.`level`=1 AND configurator.`name`=?name ORDER BY mainsteps.volgnr,steps.volgnr	3,565137	0,042728
	No caching of lanuage 38. Because it is not changed within this session.	3,565841	0,000704
	Cache item 'ML_38' already exists, so language is not cached again	3,565894	0,000053
	Session 'MlJclLanguage' set to 38	3,565903	0,000009
	Start replace dynamic content	3,566355	0,000452
	Replace dynamic content only once	3,567459	0,001104
	End replace dynamic content	3,567484	0,000025
	Filled translationcomponent from cache.	3,568034	0,000550
	Start replacing system objects	3,600506	0,032472
	Start replacing translation	3,604207	0,003701
	Start replacing objects	3,604564	0,000357
	Start replacing request	3,604909	0,000344
	Start replacing session	3,758695	0,153786
	Start replacing standards	3,764788	0,006093
	Start replacing objecs again	3,765426	0,000638
aspx.page	End Render	3,779119	0,013693

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	yylt13h5m4x3bhs4qcfyuy0g	42
CurrentDomain	cando.juicebv.nl	30

Headers Collection
Name	Value
Cache-Control	max-age=0
Connection	close
Via	1.1 squid-proxy-5b96dc6d46-hs9x6 (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.10.252.30, 216.73.216.192
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-hs9x6 (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.10.252.30, 216.73.216.192 HTTP_X_FORWARDED_PROTO:http
ALL_RAW	Cache-Control: max-age=0 Connection: close Via: 1.1 squid-proxy-5b96dc6d46-hs9x6 (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.10.252.30, 216.73.216.192 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.5
REMOTE_HOST	89.41.168.5
REMOTE_PORT	20024
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-hs9x6 (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.10.252.30, 216.73.216.192
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