| |
Query |
Rows |
Time |
| 1 |
SELECT COUNT(*) AS `Language.FindCount` FROM `languages` AS `Language` WHERE `Language`.`domain` = 'www.woonvloeren.nl' |
1 |
0 ms |
| 2 |
SELECT COUNT(*) AS `Language.FindCount` FROM `languages` AS `Language` WHERE `Language`.`domain` = 'www.www.woonvloeren.nl' |
1 |
0 ms |
| 3 |
SELECT `id` as `Language.Id` FROM `languages` AS `Language` WHERE `Language`.`default` = '1' LIMIT 1 |
1 |
0 ms |
| 4 |
SELECT `route` as `Route.Route`, `url` as `Route.Url` FROM `routes` AS `Route` WHERE `Route`.`language` = '1' ORDER BY `route` DESC |
2427 |
0.19 ms |
| 5 |
DESCRIBE `settings` |
4 |
0.01 ms |
| 6 |
SELECT `id` as `Setting.Id`, `value` as `Setting.Value`, `description` as `Setting.Description`, `admin` as `Setting.Admin` FROM `settings` AS `Setting` |
25 |
0 ms |
| 7 |
DELETE FROM `banned` WHERE `ban_till` > 0 AND `ban_till` < 1713964069 |
0 |
0 ms |
| 8 |
SELECT COUNT(*) AS `Ban.FindCount` FROM `banned` AS `Ban` WHERE `Ban`.`ip` = '3.138.125.2' |
1 |
0 ms |
| 9 |
SELECT COUNT(*) AS `Ban.FindCount` FROM `banned` AS `Ban` WHERE `Ban`.`ip` = '3.138.125.*' |
1 |
0 ms |
| 10 |
SELECT COUNT(*) AS `Language.FindCount` FROM `languages` AS `Language` WHERE `Language`.`domain` = 'www.woonvloeren.nl' |
1 |
0 ms |
| 11 |
SELECT COUNT(*) AS `Language.FindCount` FROM `languages` AS `Language` WHERE `Language`.`domain` = 'www.www.woonvloeren.nl' |
1 |
0 ms |
| 12 |
SELECT `id` as `Language.Id` FROM `languages` AS `Language` WHERE `Language`.`default` = '1' LIMIT 1 |
1 |
0 ms |
| 13 |
DESCRIBE `webshop_categories` |
23 |
0.01 ms |
| 14 |
SELECT `id` as `WebshopCategory.Id`, `show_colorfilters` as `WebshopCategory.Show_colorfilters`, `name` as `WebshopCategory.Name`, `language` as `WebshopCategory.Language`, `order` as `WebshopCategory.Order`, `parent` as `WebshopCategory.Parent`, `image` as `WebshopCategory.Image`, `showsubs` as `WebshopCategory.Showsubs`, `showsubpage` as `WebshopCategory.Showsubpage`, `title` as `WebshopCategory.Title`, `intro` as `WebshopCategory.Intro`, `keywords` as `WebshopCategory.Keywords`, `description` as `WebshopCategory.Description`, `author` as `WebshopCategory.Author`, `robots` as `WebshopCategory.Robots`, `metalanguage` as `WebshopCategory.Metalanguage`, `content` as `WebshopCategory.Content`, `priority` as `WebshopCategory.Priority`, `changefreq` as `WebshopCategory.Changefreq`, `layout` as `WebshopCategory.Layout`, `text` as `WebshopCategory.Text`, `active_from` as `WebshopCategory.Active_from`, `active_untill` as `WebshopCategory.Active_untill` FROM `webshop_categories` AS `WebshopCategory` WHERE `active_from` <= FROM_UNIXTIME(1713964069) AND `active_untill` > FROM_UNIXTIME(1713964069) ORDER BY `order` ASC LIMIT 1 |
0 |
0 ms |
| 15 |
SELECT `id` as `WebshopSetting.Id`, `value` as `WebshopSetting.Value` FROM `webshop_settings` AS `WebshopSetting` |
18 |
0 ms |
| 16 |
DELETE FROM `webshop_discount_codes` WHERE `valid_till` < 1713964069 |
0 |
0 ms |
| 17 |
DELETE FROM `webshop_random_discount_codes` WHERE `valid_till` < 1713964069 |
0 |
0 ms |
| 18 |
SELECT COUNT(*) AS `Route.FindCount` FROM `routes` AS `Route` WHERE `Route`.`url` = '/accessoires/rz-laminaatreiniger-800ml' AND `Route`.`language` = '1' |
1 |
0 ms |
| 19 |
SELECT COUNT(*) AS `WebshopProduct.FindCount` FROM `webshop_products` AS `WebshopProduct` WHERE `WebshopProduct`.`deleted` = '0' AND `WebshopProduct`.`id` = '2743' AND `WebshopProduct`.`language` = '1' |
1 |
0 ms |
| 20 |
SELECT COUNT(*) AS `WebshopCategoryProduct.FindCount` FROM `webshop_category_products` AS `WebshopCategoryProduct` WHERE `WebshopCategoryProduct`.`product_id` = '2743' AND `WebshopCategoryProduct`.`hidden` = '0' |
1 |
0.01 ms |
| 21 |
DESCRIBE `webshop_products` |
39 |
0.01 ms |
| 22 |
SELECT `id` as `WebshopProduct.Id`, `language` as `WebshopProduct.Language`, `code` as `WebshopProduct.Code`, `vloerverwarming` as `WebshopProduct.Vloerverwarming`, `title` as `WebshopProduct.Title`, `short` as `WebshopProduct.Short`, `long` as `WebshopProduct.Long`, `price` as `WebshopProduct.Price`, `price_per` as `WebshopProduct.Price_per`, `priceline` as `WebshopProduct.Priceline`, `vat` as `WebshopProduct.Vat`, `piece` as `WebshopProduct.Piece`, `order_per` as `WebshopProduct.Order_per`, `weight` as `WebshopProduct.Weight`, `length` as `WebshopProduct.Length`, `width` as `WebshopProduct.Width`, `q_perpack` as `WebshopProduct.Q_perpack`, `images` as `WebshopProduct.Images`, `stock` as `WebshopProduct.Stock`, `discount` as `WebshopProduct.Discount`, `delivery_days` as `WebshopProduct.Delivery_days`, `types` as `WebshopProduct.Types`, `advantages` as `WebshopProduct.Advantages`, `bulk` as `WebshopProduct.Bulk`, `allow_cross_selling` as `WebshopProduct.Allow_cross_selling`, `compare` as `WebshopProduct.Compare`, `specs` as `WebshopProduct.Specs`, `pdf` as `WebshopProduct.Pdf`, `placed` as `WebshopProduct.Placed`, `deleted` as `WebshopProduct.Deleted`, `pagetitle` as `WebshopProduct.Pagetitle`, `keywords` as `WebshopProduct.Keywords`, `description` as `WebshopProduct.Description`, `author` as `WebshopProduct.Author`, `robots` as `WebshopProduct.Robots`, `metalanguage` as `WebshopProduct.Metalanguage`, `priority` as `WebshopProduct.Priority`, `changefreq` as `WebshopProduct.Changefreq`, `layout` as `WebshopProduct.Layout` FROM `webshop_products` AS `WebshopProduct` WHERE `WebshopProduct`.`id` = '2743' AND `WebshopProduct`.`language` = '1' LIMIT 1 |
1 |
0 ms |
| 23 |
SELECT `category_id` as `WebshopCategoryProduct.Category_id` FROM `webshop_category_products` AS `WebshopCategoryProduct` WHERE `WebshopCategoryProduct`.`product_id` = '2743' ORDER BY `order` ASC LIMIT 1 |
1 |
0.01 ms |
| 24 |
SELECT * FROM `webshop_colors` WHERE `language` = 1 AND `id` IN( SELECT `color_id` FROM `webshop_color_products` WHERE `product_id` = 2743) ORDER BY `order` ASC |
1 |
0.01 ms |
| 25 |
DESCRIBE `webshop_category_visible` |
20 |
0.01 ms |
| 26 |
SELECT `category_id` as `WebshopCategoryVisible.Category_id`, `type` as `WebshopCategoryVisible.Type`, `code` as `WebshopCategoryVisible.Code`, `stock_status` as `WebshopCategoryVisible.Stock_status`, `brand` as `WebshopCategoryVisible.Brand`, `short` as `WebshopCategoryVisible.Short`, `price` as `WebshopCategoryVisible.Price`, `piece` as `WebshopCategoryVisible.Piece`, `originalprice` as `WebshopCategoryVisible.Originalprice`, `chopprice` as `WebshopCategoryVisible.Chopprice`, `chopunit` as `WebshopCategoryVisible.Chopunit`, `frameprice` as `WebshopCategoryVisible.Frameprice`, `frameunit` as `WebshopCategoryVisible.Frameunit`, `profilewidth` as `WebshopCategoryVisible.Profilewidth`, `sponningdepth` as `WebshopCategoryVisible.Sponningdepth`, `sponningheight` as `WebshopCategoryVisible.Sponningheight`, `size` as `WebshopCategoryVisible.Size`, `length1` as `WebshopCategoryVisible.Length1`, `length2` as `WebshopCategoryVisible.Length2`, `strength` as `WebshopCategoryVisible.Strength` FROM `webshop_category_visible` AS `WebshopCategoryVisible` WHERE `WebshopCategoryVisible`.`category_id` = '27' AND `WebshopCategoryVisible`.`type` = '' ORDER BY `category_id` ASC LIMIT 1 |
0 |
0 ms |
| 27 |
SELECT
*,
`webshop_cart`.`id` AS `cid`
FROM
`webshop_cart`
LEFT JOIN
`webshop_products`
LEFT JOIN
`webshop_vat`
ON
`webshop_products`.`vat` = `webshop_vat`.`id`
ON
`webshop_cart`.`product_id` = `webshop_products`.`id`
WHERE
`ip` = '3.138.125.2' AND
`webshop_products`.`language` = '1'
|
0 |
0.06 ms |
| 28 |
DESCRIBE `weblogs` |
19 |
0.01 ms |
| 29 |
SELECT `id` as `Weblog.Id`, `visible` as `Weblog.Visible`, `title` as `Weblog.Title`, `description` as `Weblog.Description`, `keywords` as `Weblog.Keywords`, `placed` as `Weblog.Placed`, `poster_id` as `Weblog.Poster_id`, `short` as `Weblog.Short`, `long` as `Weblog.Long`, `image` as `Weblog.Image`, `imagedescription` as `Weblog.Imagedescription`, `categories` as `Weblog.Categories`, `datetime` as `Weblog.Datetime`, `author` as `Weblog.Author`, `robots` as `Weblog.Robots`, `metalanguage` as `Weblog.Metalanguage`, `priority` as `Weblog.Priority`, `changefreq` as `Weblog.Changefreq`, `layout` as `Weblog.Layout` FROM `weblogs` AS `Weblog` ORDER BY `placed` DESC LIMIT 3 |
3 |
0 ms |
| 30 |
SELECT `id` as `Setting.Id`, `value` as `Setting.Value`, `description` as `Setting.Description`, `admin` as `Setting.Admin` FROM `settings` AS `Setting` |
25 |
0 ms |
| 31 |
SELECT `id` as `WebshopCategory.Id`, `show_colorfilters` as `WebshopCategory.Show_colorfilters`, `name` as `WebshopCategory.Name`, `language` as `WebshopCategory.Language`, `order` as `WebshopCategory.Order`, `parent` as `WebshopCategory.Parent`, `image` as `WebshopCategory.Image`, `showsubs` as `WebshopCategory.Showsubs`, `showsubpage` as `WebshopCategory.Showsubpage`, `title` as `WebshopCategory.Title`, `intro` as `WebshopCategory.Intro`, `keywords` as `WebshopCategory.Keywords`, `description` as `WebshopCategory.Description`, `author` as `WebshopCategory.Author`, `robots` as `WebshopCategory.Robots`, `metalanguage` as `WebshopCategory.Metalanguage`, `content` as `WebshopCategory.Content`, `priority` as `WebshopCategory.Priority`, `changefreq` as `WebshopCategory.Changefreq`, `layout` as `WebshopCategory.Layout`, `text` as `WebshopCategory.Text`, `active_from` as `WebshopCategory.Active_from`, `active_untill` as `WebshopCategory.Active_untill` FROM `webshop_categories` AS `WebshopCategory` ORDER BY `order` ASC |
21 |
0 ms |
| 32 |
DESCRIBE `routes` |
3 |
0.01 ms |
| 33 |
SELECT `url` as `Route.Url`, `route` as `Route.Route`, `language` as `Route.Language` FROM `routes` AS `Route` WHERE `Route`.`url` = '/webshop/categories/42' AND `Route`.`language` = '1' ORDER BY `route` DESC LIMIT 1 |
0 |
0 ms |
| 34 |
SELECT `url` as `Route.Url`, `route` as `Route.Route` FROM `routes` AS `Route` WHERE `language` = 1 AND `url` NOT LIKE '%/webshop/product%' ORDER BY `route` DESC |
76 |
0.02 ms |
| 35 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '0' |
1 |
0 ms |
| 36 |
DESCRIBE `menus` |
9 |
0 ms |
| 37 |
SELECT `id` as `Menu.Id`, `name` as `Menu.Name`, `parent` as `Menu.Parent`, `order` as `Menu.Order`, `language` as `Menu.Language`, `visible` as `Menu.Visible`, `url_frontend` as `Menu.Url_frontend`, `url_manage` as `Menu.Url_manage`, `url_remove` as `Menu.Url_remove` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '0' ORDER BY `parent` ASC, `order` ASC |
23 |
0 ms |
| 38 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '1' |
1 |
0 ms |
| 39 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '4' |
1 |
0 ms |
| 40 |
SELECT `url` as `Route.Url`, `route` as `Route.Route` FROM `routes` AS `Route` WHERE `language` = 1 AND `url` NOT LIKE '%/webshop/product%' ORDER BY `route` DESC |
76 |
0.02 ms |
| 41 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '4' |
1 |
0 ms |
| 42 |
SELECT `id` as `Menu.Id`, `name` as `Menu.Name`, `parent` as `Menu.Parent`, `order` as `Menu.Order`, `language` as `Menu.Language`, `visible` as `Menu.Visible`, `url_frontend` as `Menu.Url_frontend`, `url_manage` as `Menu.Url_manage`, `url_remove` as `Menu.Url_remove` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '4' ORDER BY `parent` ASC, `order` ASC |
7 |
0 ms |
| 43 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '76' |
1 |
0 ms |
| 44 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '77' |
1 |
0 ms |
| 45 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '78' |
1 |
0 ms |
| 46 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '79' |
1 |
0 ms |
| 47 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '86' |
1 |
0 ms |
| 48 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '90' |
1 |
0 ms |
| 49 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '91' |
1 |
0 ms |
| 50 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '7' |
1 |
0 ms |
| 51 |
SELECT `url` as `Route.Url`, `route` as `Route.Route` FROM `routes` AS `Route` WHERE `language` = 1 AND `url` NOT LIKE '%/webshop/product%' ORDER BY `route` DESC |
76 |
0.02 ms |
| 52 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '7' |
1 |
0 ms |
| 53 |
SELECT `id` as `Menu.Id`, `name` as `Menu.Name`, `parent` as `Menu.Parent`, `order` as `Menu.Order`, `language` as `Menu.Language`, `visible` as `Menu.Visible`, `url_frontend` as `Menu.Url_frontend`, `url_manage` as `Menu.Url_manage`, `url_remove` as `Menu.Url_remove` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '7' ORDER BY `parent` ASC, `order` ASC |
4 |
0 ms |
| 54 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '81' |
1 |
0 ms |
| 55 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '82' |
1 |
0 ms |
| 56 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '83' |
1 |
0 ms |
| 57 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '84' |
1 |
0 ms |
| 58 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '68' |
1 |
0 ms |
| 59 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '10' |
1 |
0 ms |
| 60 |
SELECT `url` as `Route.Url`, `route` as `Route.Route` FROM `routes` AS `Route` WHERE `language` = 1 AND `url` NOT LIKE '%/webshop/product%' ORDER BY `route` DESC |
76 |
0.02 ms |
| 61 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '10' |
1 |
0 ms |
| 62 |
SELECT `id` as `Menu.Id`, `name` as `Menu.Name`, `parent` as `Menu.Parent`, `order` as `Menu.Order`, `language` as `Menu.Language`, `visible` as `Menu.Visible`, `url_frontend` as `Menu.Url_frontend`, `url_manage` as `Menu.Url_manage`, `url_remove` as `Menu.Url_remove` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '10' ORDER BY `parent` ASC, `order` ASC |
5 |
0 ms |
| 63 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '87' |
1 |
0 ms |
| 64 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '88' |
1 |
0 ms |
| 65 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '89' |
1 |
0 ms |
| 66 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '92' |
1 |
0 ms |
| 67 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '93' |
1 |
0 ms |
| 68 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '19' |
1 |
0 ms |
| 69 |
SELECT `url` as `Route.Url`, `route` as `Route.Route` FROM `routes` AS `Route` WHERE `language` = 1 AND `url` NOT LIKE '%/webshop/product%' ORDER BY `route` DESC |
76 |
0.02 ms |
| 70 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '19' |
1 |
0 ms |
| 71 |
SELECT `id` as `Menu.Id`, `name` as `Menu.Name`, `parent` as `Menu.Parent`, `order` as `Menu.Order`, `language` as `Menu.Language`, `visible` as `Menu.Visible`, `url_frontend` as `Menu.Url_frontend`, `url_manage` as `Menu.Url_manage`, `url_remove` as `Menu.Url_remove` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '19' ORDER BY `parent` ASC, `order` ASC |
1 |
0 ms |
| 72 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '94' |
1 |
0 ms |
| 73 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '13' |
1 |
0 ms |
| 74 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '52' |
1 |
0 ms |
| 75 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '22' |
1 |
0 ms |
| 76 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '59' |
1 |
0 ms |
| 77 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '28' |
1 |
0 ms |
| 78 |
SELECT `url` as `Route.Url`, `route` as `Route.Route` FROM `routes` AS `Route` WHERE `language` = 1 AND `url` NOT LIKE '%/webshop/product%' ORDER BY `route` DESC |
76 |
0.02 ms |
| 79 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '28' |
1 |
0 ms |
| 80 |
SELECT `id` as `Menu.Id`, `name` as `Menu.Name`, `parent` as `Menu.Parent`, `order` as `Menu.Order`, `language` as `Menu.Language`, `visible` as `Menu.Visible`, `url_frontend` as `Menu.Url_frontend`, `url_manage` as `Menu.Url_manage`, `url_remove` as `Menu.Url_remove` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '28' ORDER BY `parent` ASC, `order` ASC |
1 |
0 ms |
| 81 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '71' |
1 |
0 ms |
| 82 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '31' |
1 |
0 ms |
| 83 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '34' |
1 |
0 ms |
| 84 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '40' |
1 |
0 ms |
| 85 |
SELECT `url` as `Route.Url`, `route` as `Route.Route` FROM `routes` AS `Route` WHERE `language` = 1 AND `url` NOT LIKE '%/webshop/product%' ORDER BY `route` DESC |
76 |
0.02 ms |
| 86 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '40' |
1 |
0 ms |
| 87 |
SELECT `id` as `Menu.Id`, `name` as `Menu.Name`, `parent` as `Menu.Parent`, `order` as `Menu.Order`, `language` as `Menu.Language`, `visible` as `Menu.Visible`, `url_frontend` as `Menu.Url_frontend`, `url_manage` as `Menu.Url_manage`, `url_remove` as `Menu.Url_remove` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '40' ORDER BY `parent` ASC, `order` ASC |
1 |
0 ms |
| 88 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '43' |
1 |
0 ms |
| 89 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '46' |
1 |
0 ms |
| 90 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '49' |
1 |
0 ms |
| 91 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '53' |
1 |
0 ms |
| 92 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '56' |
1 |
0 ms |
| 93 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '62' |
1 |
0 ms |
| 94 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '65' |
1 |
0 ms |
| 95 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '74' |
1 |
0 ms |
| 96 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '75' |
1 |
0 ms |
| 97 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '80' |
1 |
0 ms |
| 98 |
SELECT `url` as `Route.Url` FROM `routes` AS `Route` WHERE `Route`.`route` = '/' AND `Route`.`language` = '1' ORDER BY `route` DESC LIMIT 1 |
1 |
0 ms |
| 99 |
SELECT `name` as `Menu.Name` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`url_frontend` = '/page/show/home' ORDER BY `parent` ASC, `order` ASC LIMIT 1 |
1 |
0 ms |
| 100 |
SELECT `url` as `Route.Url` FROM `routes` AS `Route` WHERE `Route`.`route` = '/accessoires/rz-laminaatreiniger-800ml' ORDER BY `route` DESC LIMIT 1 |
1 |
0 ms |
| 101 |
SELECT `id` as `WebshopCategory.Id`, `show_colorfilters` as `WebshopCategory.Show_colorfilters`, `name` as `WebshopCategory.Name`, `language` as `WebshopCategory.Language`, `order` as `WebshopCategory.Order`, `parent` as `WebshopCategory.Parent`, `image` as `WebshopCategory.Image`, `showsubs` as `WebshopCategory.Showsubs`, `showsubpage` as `WebshopCategory.Showsubpage`, `title` as `WebshopCategory.Title`, `intro` as `WebshopCategory.Intro`, `keywords` as `WebshopCategory.Keywords`, `description` as `WebshopCategory.Description`, `author` as `WebshopCategory.Author`, `robots` as `WebshopCategory.Robots`, `metalanguage` as `WebshopCategory.Metalanguage`, `content` as `WebshopCategory.Content`, `priority` as `WebshopCategory.Priority`, `changefreq` as `WebshopCategory.Changefreq`, `layout` as `WebshopCategory.Layout`, `text` as `WebshopCategory.Text`, `active_from` as `WebshopCategory.Active_from`, `active_untill` as `WebshopCategory.Active_untill` FROM `webshop_categories` AS `WebshopCategory` WHERE `WebshopCategory`.`id` = '27' ORDER BY `order` ASC LIMIT 1 |
1 |
0 ms |
| 102 |
SELECT `id` as `WebshopCategory.Id`, `show_colorfilters` as `WebshopCategory.Show_colorfilters`, `name` as `WebshopCategory.Name`, `language` as `WebshopCategory.Language`, `order` as `WebshopCategory.Order`, `parent` as `WebshopCategory.Parent`, `image` as `WebshopCategory.Image`, `showsubs` as `WebshopCategory.Showsubs`, `showsubpage` as `WebshopCategory.Showsubpage`, `title` as `WebshopCategory.Title`, `intro` as `WebshopCategory.Intro`, `keywords` as `WebshopCategory.Keywords`, `description` as `WebshopCategory.Description`, `author` as `WebshopCategory.Author`, `robots` as `WebshopCategory.Robots`, `metalanguage` as `WebshopCategory.Metalanguage`, `content` as `WebshopCategory.Content`, `priority` as `WebshopCategory.Priority`, `changefreq` as `WebshopCategory.Changefreq`, `layout` as `WebshopCategory.Layout`, `text` as `WebshopCategory.Text`, `active_from` as `WebshopCategory.Active_from`, `active_untill` as `WebshopCategory.Active_untill` FROM `webshop_categories` AS `WebshopCategory` WHERE `WebshopCategory`.`id` = '3' ORDER BY `order` ASC LIMIT 1 |
1 |
0 ms |
| 103 |
SELECT `title` as `WebshopProduct.Title` FROM `webshop_products` AS `WebshopProduct` WHERE `WebshopProduct`.`id` = '2743' LIMIT 1 |
1 |
0 ms |
| 104 |
SELECT `url` as `Route.Url`, `route` as `Route.Route`, `language` as `Route.Language` FROM `routes` AS `Route` WHERE `Route`.`url` = '/' AND `Route`.`language` = '1' ORDER BY `route` DESC LIMIT 1 |
0 |
0 ms |
| 105 |
SELECT `url` as `Route.Url`, `route` as `Route.Route`, `language` as `Route.Language` FROM `routes` AS `Route` WHERE `Route`.`url` = '/accessoires' AND `Route`.`language` = '1' ORDER BY `route` DESC LIMIT 1 |
0 |
0 ms |
| 106 |
SELECT `url` as `Route.Url`, `route` as `Route.Route`, `language` as `Route.Language` FROM `routes` AS `Route` WHERE `Route`.`url` = '/accessoires/vloeronderhoud' AND `Route`.`language` = '1' ORDER BY `route` DESC LIMIT 1 |
0 |
0 ms |
| 107 |
SELECT `url` as `Route.Url`, `route` as `Route.Route`, `language` as `Route.Language` FROM `routes` AS `Route` WHERE `Route`.`url` = '/accessoires/rz-laminaatreiniger-800ml' AND `Route`.`language` = '1' ORDER BY `route` DESC LIMIT 1 |
0 |
0 ms |
| 108 |
SELECT `name` as `WebshopCategory.Name` FROM `webshop_categories` AS `WebshopCategory` WHERE `WebshopCategory`.`id` = '27' ORDER BY `order` ASC LIMIT 1 |
1 |
0 ms |
| 109 |
SELECT COUNT(*) AS `Translation.FindCount` FROM `translations` AS `Translation` WHERE `Translation`.`id` = 'Per stuk' AND `Translation`.`language` = '1' |
1 |
0.01 ms |
| 110 |
SELECT
`product_2` AS `product`
FROM
`webshop_cross_selling`
WHERE
`product_1` = 2743 |
0 |
0 ms |
| 111 |
SELECT
`product_1` AS `product`
FROM
`webshop_cross_selling`
WHERE
`product_2` = 2743 |
0 |
0 ms |
| 112 |
SELECT `brand_id` as `WebshopBrandProduct.Brand_id` FROM `webshop_brand_products` AS `WebshopBrandProduct` WHERE `WebshopBrandProduct`.`product_id` = '2743' ORDER BY `order` ASC LIMIT 1 |
1 |
0.01 ms |
| 113 |
SELECT `product_id` FROM `webshop_brand_products` WHERE `brand_id` = '95' AND `product_id` != '2743' AND `hidden` = '0' LIMIT 4 |
4 |
0 ms |
| 114 |
SELECT
`id`, `language`, `title`, `code`, `price`, `vat`, `piece`, `price_per`, `images`, `allow_cross_selling`
FROM
`webshop_products`
WHERE
`id` IN
(
1942,1943,1944,1945
)
AND `language` =1
GROUP BY
`webshop_products`.`id`
ORDER BY
`price` ASC
|
4 |
0.01 ms |
| 115 |
SELECT `content` as `Page.Content` FROM `pages` AS `Page` WHERE `Page`.`id` = 'footer-showroom' AND `Page`.`language` = '1' LIMIT 1 |
1 |
0 ms |
| 116 |
SELECT `url` as `Route.Url`, `route` as `Route.Route`, `language` as `Route.Language` FROM `routes` AS `Route` WHERE `Route`.`url` = '/weblog/index' AND `Route`.`language` = '1' ORDER BY `route` DESC LIMIT 1 |
0 |
0 ms |
| 117 |
SELECT `url` as `Route.Url`, `route` as `Route.Route`, `language` as `Route.Language` FROM `routes` AS `Route` WHERE `Route`.`url` = '/page/show/algemene-voorwaarden' AND `Route`.`language` = '1' ORDER BY `route` DESC LIMIT 1 |
0 |
0 ms |
| 118 |
SELECT `url` as `Route.Url`, `route` as `Route.Route`, `language` as `Route.Language` FROM `routes` AS `Route` WHERE `Route`.`url` = '/page/show/bestellen-verzenden-retourneren' AND `Route`.`language` = '1' ORDER BY `route` DESC LIMIT 1 |
0 |
0 ms |
| 119 |
SELECT COUNT(*) AS `Translation.FindCount` FROM `translations` AS `Translation` WHERE `Translation`.`id` = 'Wiwi Websolutions' AND `Translation`.`language` = '1' |
1 |
0.01 ms |
