|
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.2 ms |
5 |
DESCRIBE `settings` |
4 |
0.06 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` < 1716315703 |
0 |
0 ms |
8 |
SELECT COUNT(*) AS `Ban.FindCount` FROM `banned` AS `Ban` WHERE `Ban`.`ip` = '3.145.202.123' |
1 |
0 ms |
9 |
SELECT COUNT(*) AS `Ban.FindCount` FROM `banned` AS `Ban` WHERE `Ban`.`ip` = '3.145.202.*' |
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(1716315703) AND `active_untill` > FROM_UNIXTIME(1716315703) 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` < 1716315703 |
0 |
0 ms |
17 |
DELETE FROM `webshop_random_discount_codes` WHERE `valid_till` < 1716315703 |
0 |
0 ms |
18 |
SELECT COUNT(*) AS `Route.FindCount` FROM `routes` AS `Route` WHERE `Route`.`url` = '/accessoires/bergamo-royal-red' 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` = '1810' AND `WebshopProduct`.`language` = '1' |
1 |
0.01 ms |
20 |
SELECT COUNT(*) AS `WebshopCategoryProduct.FindCount` FROM `webshop_category_products` AS `WebshopCategoryProduct` WHERE `WebshopCategoryProduct`.`product_id` = '1810' 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` = '1810' 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` = '1810' 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` = 1810) 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` = '26' 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.145.202.123' AND
`webshop_products`.`language` = '1'
|
0 |
0.08 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.01 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.03 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.01 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.03 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.03 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.03 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.01 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.03 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.03 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/bergamo-royal-red' 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` = '26' 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.01 ms |
103 |
SELECT `title` as `WebshopProduct.Title` FROM `webshop_products` AS `WebshopProduct` WHERE `WebshopProduct`.`id` = '1810' 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/trapmatten' 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/bergamo-royal-red' 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` = '26' ORDER BY `order` ASC LIMIT 1 |
1 |
0 ms |
109 |
SELECT
`product_2` AS `product`
FROM
`webshop_cross_selling`
WHERE
`product_1` = 1810 |
0 |
0 ms |
110 |
SELECT
`product_1` AS `product`
FROM
`webshop_cross_selling`
WHERE
`product_2` = 1810 |
0 |
0 ms |
111 |
SELECT `brand_id` as `WebshopBrandProduct.Brand_id` FROM `webshop_brand_products` AS `WebshopBrandProduct` WHERE `WebshopBrandProduct`.`product_id` = '1810' ORDER BY `order` ASC LIMIT 1 |
1 |
0.01 ms |
112 |
SELECT `product_id` FROM `webshop_brand_products` WHERE `brand_id` = '83' AND `product_id` != '1810' AND `hidden` = '0' LIMIT 4 |
3 |
0 ms |
113 |
SELECT `category_id` as `WebshopCategoryProduct.Category_id` FROM `webshop_category_products` AS `WebshopCategoryProduct` WHERE `WebshopCategoryProduct`.`product_id` = '' ORDER BY `order` ASC LIMIT 1 |
0 |
0.01 ms |
114 |
SELECT `product_id` FROM `webshop_category_products` WHERE `category_id` = '' AND `product_id` != 'Array' AND `hidden` = '0' LIMIT 1 |
0 |
0 ms |
115 |
SELECT
`id`, `language`, `title`, `code`, `price`, `vat`, `piece`, `price_per`, `images`, `allow_cross_selling`
FROM
`webshop_products`
WHERE
`id` IN
(
1811,2563,2564
)
AND `language` =1
GROUP BY
`webshop_products`.`id`
ORDER BY
`price` ASC
|
3 |
0.02 ms |
116 |
SELECT `url` as `Route.Url`, `route` as `Route.Route`, `language` as `Route.Language` FROM `routes` AS `Route` WHERE `Route`.`url` = '/webshop/product/2563' 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` = '/webshop/product/2563' 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` = '/webshop/product/2564' AND `Route`.`language` = '1' ORDER BY `route` DESC LIMIT 1 |
0 |
0 ms |
119 |
SELECT `url` as `Route.Url`, `route` as `Route.Route`, `language` as `Route.Language` FROM `routes` AS `Route` WHERE `Route`.`url` = '/webshop/product/2564' AND `Route`.`language` = '1' ORDER BY `route` DESC LIMIT 1 |
0 |
0 ms |
120 |
SELECT `content` as `Page.Content` FROM `pages` AS `Page` WHERE `Page`.`id` = 'footer-showroom' AND `Page`.`language` = '1' LIMIT 1 |
1 |
0 ms |
121 |
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 |
122 |
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 |
123 |
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 |
124 |
SELECT COUNT(*) AS `Translation.FindCount` FROM `translations` AS `Translation` WHERE `Translation`.`id` = 'Wiwi Websolutions' AND `Translation`.`language` = '1' |
1 |
0.01 ms |