Database:0,324 (20) Solr: 0 Other: 0,064 Total: 0,388

-- Query took 0,008sec
SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = '227910' 

-- Query took 0,001sec
SELECT * FROM subCategories WHERE id = 68

-- Query took 0,001sec
SELECT * FROM ProductVersions WHERE id = '641040'

-- Query took 0,012sec
SELECT * FROM youtube WHERE productId = 227910

-- Query took 0,001sec
SELECT * FROM categories WHERE internalKey = 'auto'

-- Query took 0,001sec
SELECT html FROM htmlCache WHERE id = 'a5e8b9696c61d368d407fab341b01ab9' AND timestamp > '2014-10-20 00:47:05' AND  [group] = 'page227910'

-- Query took 0,001sec
SELECT * FROM categories WHERE id = 1

-- Query took 0,008sec
SELECT TOP 201 productVersions.*, filter.* FROM productVersions LEFT JOIN filter_navigatielos AS filter ON filter.productVersionID = productVersions.id WHERE state & 1 = 1 AND productVersions.productID = 227910 ORDER BY (CASE WHEN filter.price IS NULL OR filter.price = 1 THEN 2 ELSE 1 END), filter.price

-- Query took 0,004sec
SELECT Products.*, brands.name AS brand_name, brands.logo AS brand_logo, brands.externID AS brand_externID, brands.externSource AS brand_externSource, ProductRatingsFlat.rate FROM Products LEFT JOIN brands ON (products.brandID = brands.id) LEFT JOIN ProductRatingsFlat ON (productRatingsFlat.productID = Products.id) WHERE Products.id = 227910 

-- Query took 0,02sec
SELECT DISTINCT (id) FROM images JOIN pvimage ON (pvimage.imageID = images.id) WHERE pvimage.productVersionID = 641040 

-- Query took 0,009sec
SELECT
			prices_shopProducts.*,
			prices_shops.id AS shops_id,
			prices_shops.name AS shops_name,
			prices_shops.url AS shops_url,
			prices_shops.address AS shops_address,
			prices_shops.postcode AS shops_postcode,
			prices_shops.city AS shops_city ,
			prices_shops.phone AS shops_phone,
			prices_shops.email AS shops_email,
			prices_shops.description AS shops_description,
			prices_shops.invoiceCompany AS shops_invoiceCompany,
			prices_shops.invoiceName AS shops_invoiceName,
			prices_shops.invoiceAddress AS shops_invoiceAddress,
			prices_shops.invoicePostcode AS shops_invoicePostcode,
			prices_shops.invoiceCity AS shops_invoiceCity,
			prices_shops.invoiceTel AS shops_invoiceTel,
			prices_shops.invoiceEmail AS shops_invoiceEmail,
			prices_shops.dateAdded AS shops_dateAdded,
			prices_shops.logo AS shops_logo,
			prices_shops.state AS shops_state,
			prices_shops.cost AS shops_cost,
			prices_shops.keurmerken AS shops_keurmerken,
			prices_shops.logoimageid as shops_logoimageid,
			prices_shops.availabilityType AS shops_availabilitytype
				FROM prices_shopProducts, prices_shops WHERE prices_shopProducts.shopID = prices_shops.id AND prices_shopProducts.productVersionID = 641040 AND prices_shops.state & 2 != 2 ORDER BY prices_shopProducts.priceEx

-- Query took 0,022sec
SELECT DISTINCT TOP 100 imageID AS id FROM pvImage WHERE productVersionID = (
			SELECT TOP 1 productVersionID
			FROM pvImage JOIN productVersions ON (productVersions.id = productVersionID)
			WHERE productID = 227910 
			GROUP BY pvImage.productVersionID
			ORDER BY COUNT(pvImage.imageID) DESC);

-- Query took 0,017sec
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 = 68
			 AND searchable = "1"
			ORDER BY
				featureGroups.priority DESC, priority DESC, featureLang.name
			

-- Query took 0,123sec
SELECT TOP 20 Reviews.*, ReviewRatingsFlat.rate as reviewRating,
		ReviewRatingsFlat.rate_positive as reviewRatePositive,
		ReviewRatingsFlat.rate_negative as reviewRateNegative
			FROM Reviews
			LEFT JOIN ReviewRatingsFlat ON (ReviewRatingsFlat.reviewID = reviews.id)
			WHERE
				(
					productID = 227910 OR
					productID IN
						(SELECT productID FROM similarProducts WHERE groupID IN
							(SELECT groupID FROM similarProducts WHERE productID = 227910)
						)
				)
				AND onlyRating = 0 AND state & 1 = 1 ORDER BY timestamp DESC

-- Query took 0,002sec
SELECT html FROM htmlCache WHERE id = 'c57dc692e45eeea978d552e80c7d9844' AND timestamp > '2014-10-20 23:47:06' AND  [group] = 'auto'

-- Query took 0,069sec
SELECT COUNT(*) AS cnt FROM Reviews
					WHERE
				(
					productID = 227910 OR
					productID IN
						(SELECT productID FROM similarProducts WHERE groupID IN
							(SELECT groupID FROM similarProducts WHERE productID = 227910)
						)
				)
		 AND state & 1 = 1

-- Query took 0,007sec
SELECT review_rates.id, review_rates.name, AVG(ReviewProductRatings.rate) AS rate FROM ReviewProductRatings JOIN Reviews ON (Reviews.id = ReviewProductRatings.reviewID) JOIN review_rates ON (review_rates.id = ReviewProductRatings.rateID) WHERE Reviews.productID = 227910 AND review_rates.subCategoryID = 68 GROUP BY review_rates.id, review_rates.name, review_rates.weight ORDER BY review_rates.weight

-- Query took 0,006sec
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 = 68
			 AND searchable = "1"
			ORDER BY
				featureGroups.priority DESC, priority DESC, featureLang.name
			

-- Query took 0,004sec



SELECT TOP 7 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 subCategories_id = 68  AND brand_id = 13703  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,009sec

				DELETE FROM htmlCache WHERE id = 'a5e8b9696c61d368d407fab341b01ab9' AND [group] = 'page227910';
				INSERT INTO htmlCache (id, html, [group]) VALUES ('a5e8b9696c61d368d407fab341b01ab9', '
		
		
			










			
			
			
			
			Vergelijk de Mio Moov M410 (5420027519289) met andere Navigatie los - ook specificaties, prijzen, reviews en andere modellen Navigatie los

			


			

			
			

			
			
			


			

			
						
			

			

						
			
					

					
		
		
		
', 'page227910')