Database:0,053 (10) Solr: 0 Other: 0,055 Total: 0,108

-- Query took 0,004sec
SELECT * FROM brands WHERE id = '9289'

-- Query took 0,002sec
SELECT html FROM htmlCache WHERE id = '86b559973b08ead689df761bfeb388a8' AND timestamp > '2014-10-19 06:22:37' AND  [group] = 'page'

-- Query took 0,002sec
SELECT html FROM htmlCache WHERE id = '3532721e2c45afe6e661cef2328ca5ea' AND timestamp > '2014-10-20 05:22:37' AND  [group] = 'global'

-- Query took 0,007sec



SELECT TOP 6 productsSearch.*, stats_productsFlat.num AS productStats  FROM productsSearch  LEFT JOIN stats_productsFlat ON (stats_productsFlat.productID = products_id AND stats_productsFlat.site = 1)
			WHERE products_state & 1 = 1  AND brand_id = 9289  ORDER BY (CASE WHEN products_image IS null THEN 1 ELSE 0 END), (CASE WHEN products_endyear IS NULL THEN 3000 ELSE products_endyear END) DESC, stats_productsFlat.num DESC, products_stats DESC, products_id

-- Query took 0,006sec



SELECT productsSearch.*, stats_productsFlat.num AS productStats  FROM productsSearch  LEFT JOIN stats_productsFlat ON (stats_productsFlat.productID = products_id AND stats_productsFlat.site = 1)
			WHERE products_state & 1 = 1  AND brand_id = 9289  ORDER BY (CASE WHEN products_image IS null THEN 1 ELSE 0 END), categories_name, subcategories_name, products_name, (CASE WHEN products_endyear IS NULL THEN 3000 ELSE products_endyear END) DESC,products_id

-- Query took 0,005sec
SELECT
				categoryFeature.*,
				features.id AS feature_id,
				features.externID AS feature_externID,
				measures.id AS measureid,
				featureGroupLang.name AS featureGroup_name,
				featureGroups.id AS featureGroup_id,
				featureGroups.externid AS featureGroup_externid,
				featureGroups.externsource AS featureGroup_externsource,
				featureGroups.priority AS featureGroup_priority,
				featureLang.name,
				featureLang.description,
				measures.defaultSign AS measure_defaultSign,
				measureLang.name AS measure_name,
				measureLang.description AS measure_description,
				measureLang.sign AS measure_sign
			FROM categoryFeature
				LEFT JOIN features ON features.id = categoryFeature.featureID
				LEFT JOIN measures ON features.measureID = measures.id
				LEFT JOIN featureGroups ON featureGroups.id = categoryFeature.featureGroupID
				LEFT JOIN featureGroupLang ON featureGroups.id = featureGroupLang.featureGroupID
				LEFT JOIN featureLang ON features.id = featureLang.featureID AND featureLang.lang = 'NL'
				LEFT JOIN measureLang ON measures.id = measureLang.measureID AND measureLang.lang = 'NL'
			WHERE
				categoryFeature.subCategoryID = 84
			 AND searchable = "1"
			ORDER BY
				featureGroups.priority DESC, priority DESC, featureLang.name
			

-- Query took 0,004sec
SELECT
				categoryFeature.*,
				features.id AS feature_id,
				features.externID AS feature_externID,
				measures.id AS measureid,
				featureGroupLang.name AS featureGroup_name,
				featureGroups.id AS featureGroup_id,
				featureGroups.externid AS featureGroup_externid,
				featureGroups.externsource AS featureGroup_externsource,
				featureGroups.priority AS featureGroup_priority,
				featureLang.name,
				featureLang.description,
				measures.defaultSign AS measure_defaultSign,
				measureLang.name AS measure_name,
				measureLang.description AS measure_description,
				measureLang.sign AS measure_sign
			FROM categoryFeature
				LEFT JOIN features ON features.id = categoryFeature.featureID
				LEFT JOIN measures ON features.measureID = measures.id
				LEFT JOIN featureGroups ON featureGroups.id = categoryFeature.featureGroupID
				LEFT JOIN featureGroupLang ON featureGroups.id = featureGroupLang.featureGroupID
				LEFT JOIN featureLang ON features.id = featureLang.featureID AND featureLang.lang = 'NL'
				LEFT JOIN measureLang ON measures.id = measureLang.measureID AND measureLang.lang = 'NL'
			WHERE
				categoryFeature.subCategoryID = 86
			 AND searchable = "1"
			ORDER BY
				featureGroups.priority DESC, priority DESC, featureLang.name
			

-- Query took 0,004sec
SELECT
				categoryFeature.*,
				features.id AS feature_id,
				features.externID AS feature_externID,
				measures.id AS measureid,
				featureGroupLang.name AS featureGroup_name,
				featureGroups.id AS featureGroup_id,
				featureGroups.externid AS featureGroup_externid,
				featureGroups.externsource AS featureGroup_externsource,
				featureGroups.priority AS featureGroup_priority,
				featureLang.name,
				featureLang.description,
				measures.defaultSign AS measure_defaultSign,
				measureLang.name AS measure_name,
				measureLang.description AS measure_description,
				measureLang.sign AS measure_sign
			FROM categoryFeature
				LEFT JOIN features ON features.id = categoryFeature.featureID
				LEFT JOIN measures ON features.measureID = measures.id
				LEFT JOIN featureGroups ON featureGroups.id = categoryFeature.featureGroupID
				LEFT JOIN featureGroupLang ON featureGroups.id = featureGroupLang.featureGroupID
				LEFT JOIN featureLang ON features.id = featureLang.featureID AND featureLang.lang = 'NL'
				LEFT JOIN measureLang ON measures.id = measureLang.measureID AND measureLang.lang = 'NL'
			WHERE
				categoryFeature.subCategoryID = 90
			 AND searchable = "1"
			ORDER BY
				featureGroups.priority DESC, priority DESC, featureLang.name
			

-- Query took 0,011sec
SELECT DISTINCT TOP 20
			Reviews.*,
			productsSearch.*,
			ReviewRatingsFlat.rate as reviewRating,
			ReviewRatingsFlat.rate_positive as reviewRatingPositive,
			ReviewRatingsFlat.rate_negative as reviewRatingNegative
			FROM Reviews LEFT JOIN ReviewRatingsFlat ON (ReviewRatingsFlat.reviewID = reviews.id)  JOIN productsSearch ON (reviews.productID = productsSearch.products_id)WHERE onlyRating = 0  AND state & 1 = 1 AND reviews.timestamp > '2014-08-20 06:22:38' AND brand_id = 9289 ORDER BY reviewRating DESC

-- Query took 0,009sec

				DELETE FROM htmlCache WHERE id = '86b559973b08ead689df761bfeb388a8' AND [group] = 'page';
				INSERT INTO htmlCache (id, html, [group]) VALUES ('86b559973b08ead689df761bfeb388a8', '
		
		
			










			
			
			
			
			Alle producten van Mini: reviews, prijzen en specificaties op topproduct.nl

			


			

			
			

			
			
			


			

			
						
			

			

						
			
					

					
		
		
		
', 'page')