|
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.14 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` < 1701623537 |
0 |
0 ms |
8 |
SELECT COUNT(*) AS `Ban.FindCount` FROM `banned` AS `Ban` WHERE `Ban`.`ip` = '18.206.12.157' |
1 |
0 ms |
9 |
SELECT COUNT(*) AS `Ban.FindCount` FROM `banned` AS `Ban` WHERE `Ban`.`ip` = '18.206.12.*' |
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 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(1701623537) AND `active_untill` > FROM_UNIXTIME(1701623537) 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` < 1701623537 |
0 |
0 ms |
17 |
DELETE FROM `webshop_random_discount_codes` WHERE `valid_till` < 1701623537 |
0 |
0 ms |
18 |
SELECT COUNT(*) AS `Route.FindCount` FROM `routes` AS `Route` WHERE `Route`.`url` = '/vloeren/loose-lay' AND `Route`.`language` = '1' |
1 |
0 ms |
19 |
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` = '8' AND `WebshopCategory`.`language` = '1' ORDER BY `order` ASC LIMIT 1 |
1 |
0 ms |
20 |
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`.`language` = '1' ORDER BY `order` ASC |
21 |
0 ms |
21 |
SELECT `content` as `Page.Content` FROM `pages` AS `Page` WHERE `Page`.`id` = '' AND `Page`.`language` = '1' LIMIT 1 |
0 |
0 ms |
22 |
SELECT COUNT(*) AS `WebshopCategory.FindCount` FROM `webshop_categories` AS `WebshopCategory` WHERE `WebshopCategory`.`parent` = '8' AND `WebshopCategory`.`language` = '1' |
1 |
0 ms |
23 |
SELECT
COUNT(*) as `count`
FROM
`webshop_products`
RIGHT JOIN
`webshop_category_products`
ON
`webshop_category_products`.`product_id` = `webshop_products`.`id`
WHERE
`language` = '1' AND
`price` != '0.00' AND `price` != '0' AND
`hidden` = 0 AND
`deleted` = 0 AND
`category_id` = '8'
AND `category_id` = '8'
|
1 |
0.18 ms |
24 |
SELECT
*
FROM
`webshop_products`
RIGHT JOIN
`webshop_category_products`
ON
`webshop_category_products`.`product_id` = `webshop_products`.`id`
WHERE
`language` = '1' AND
`price` != '0.00' AND `price` != '0' AND
`hidden` = 0 AND
`deleted` = 0 AND
`category_id` = '8'
AND `category_id` = '8'
ORDER BY `order` ASC LIMIT 0, 15 |
0 |
0.01 ms |
25 |
SELECT `show_colorfilters` as `WebshopCategory.Show_colorfilters` FROM `webshop_categories` AS `WebshopCategory` WHERE `WebshopCategory`.`id` = '8' ORDER BY `order` ASC LIMIT 1 |
1 |
0 ms |
26 |
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` = '8' AND `WebshopCategory`.`language` = '1' ORDER BY `order` ASC LIMIT 1 |
1 |
0 ms |
27 |
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` = '1' ORDER BY `order` ASC LIMIT 1 |
1 |
0 ms |
28 |
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`.`parent` = '1' ORDER BY `order` ASC |
5 |
0 ms |
29 |
SELECT COUNT(*) AS `WebshopCategorySpecification.FindCount` FROM `webshop_category_specifications` AS `WebshopCategorySpecification` WHERE `WebshopCategorySpecification`.`category_id` = '' AND `WebshopCategorySpecification`.`language` = '1' |
1 |
0.01 ms |
30 |
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` = '18.206.12.157' AND
`webshop_products`.`language` = '1'
|
0 |
0.05 ms |
31 |
DESCRIBE `weblogs` |
19 |
0.01 ms |
32 |
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 |
33 |
SELECT `id` as `Setting.Id`, `value` as `Setting.Value`, `description` as `Setting.Description`, `admin` as `Setting.Admin` FROM `settings` AS `Setting` |
25 |
0 ms |
34 |
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 |
35 |
DESCRIBE `routes` |
3 |
0 ms |
36 |
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 |
37 |
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 |
38 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '0' |
1 |
0 ms |
39 |
DESCRIBE `menus` |
9 |
0 ms |
40 |
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 |
41 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '1' |
1 |
0 ms |
42 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '4' |
1 |
0 ms |
43 |
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 |
44 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '4' |
1 |
0 ms |
45 |
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 |
46 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '76' |
1 |
0 ms |
47 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '77' |
1 |
0 ms |
48 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '78' |
1 |
0 ms |
49 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '79' |
1 |
0 ms |
50 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '86' |
1 |
0 ms |
51 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '90' |
1 |
0 ms |
52 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '91' |
1 |
0 ms |
53 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '7' |
1 |
0 ms |
54 |
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 |
55 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '7' |
1 |
0 ms |
56 |
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 |
57 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '81' |
1 |
0 ms |
58 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '82' |
1 |
0 ms |
59 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '83' |
1 |
0 ms |
60 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '84' |
1 |
0 ms |
61 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '68' |
1 |
0 ms |
62 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '10' |
1 |
0 ms |
63 |
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 |
64 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '10' |
1 |
0 ms |
65 |
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 |
66 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '87' |
1 |
0 ms |
67 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '88' |
1 |
0 ms |
68 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '89' |
1 |
0 ms |
69 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '92' |
1 |
0 ms |
70 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '93' |
1 |
0 ms |
71 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '19' |
1 |
0 ms |
72 |
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 |
73 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '19' |
1 |
0 ms |
74 |
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 |
75 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '94' |
1 |
0 ms |
76 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '13' |
1 |
0 ms |
77 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '52' |
1 |
0 ms |
78 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '22' |
1 |
0 ms |
79 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '59' |
1 |
0 ms |
80 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '28' |
1 |
0 ms |
81 |
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 |
82 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '28' |
1 |
0 ms |
83 |
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 |
84 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '71' |
1 |
0 ms |
85 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '31' |
1 |
0 ms |
86 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '34' |
1 |
0 ms |
87 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '40' |
1 |
0 ms |
88 |
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 |
89 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '40' |
1 |
0 ms |
90 |
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 |
91 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '43' |
1 |
0 ms |
92 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '46' |
1 |
0 ms |
93 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '49' |
1 |
0 ms |
94 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '53' |
1 |
0 ms |
95 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '56' |
1 |
0 ms |
96 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '62' |
1 |
0 ms |
97 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '65' |
1 |
0 ms |
98 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '74' |
1 |
0 ms |
99 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '75' |
1 |
0 ms |
100 |
SELECT COUNT(*) AS `Menu.FindCount` FROM `menus` AS `Menu` WHERE `Menu`.`language` = '1' AND `Menu`.`parent` = '80' |
1 |
0 ms |
101 |
SELECT `product_id` FROM `webshop_category_products` WHERE `category_id` = 8 AND `hidden` = 0 |
235 |
0 ms |
102 |
DESCRIBE `webshop_colors` |
5 |
0 ms |
103 |
SELECT `id` as `WebshopColor.Id`, `language` as `WebshopColor.Language`, `name` as `WebshopColor.Name`, `css_color` as `WebshopColor.Css_color`, `order` as `WebshopColor.Order` FROM `webshop_colors` AS `WebshopColor` ORDER BY `order` ASC |
3 |
0 ms |
104 |
DESCRIBE `webshop_themes` |
21 |
0.03 ms |
105 |
SELECT `id` as `WebshopTheme.Id`, `name` as `WebshopTheme.Name`, `language` as `WebshopTheme.Language`, `order` as `WebshopTheme.Order`, `parent` as `WebshopTheme.Parent`, `image` as `WebshopTheme.Image`, `showsubs` as `WebshopTheme.Showsubs`, `showsubpage` as `WebshopTheme.Showsubpage`, `title` as `WebshopTheme.Title`, `keywords` as `WebshopTheme.Keywords`, `description` as `WebshopTheme.Description`, `author` as `WebshopTheme.Author`, `robots` as `WebshopTheme.Robots`, `metalanguage` as `WebshopTheme.Metalanguage`, `content` as `WebshopTheme.Content`, `priority` as `WebshopTheme.Priority`, `changefreq` as `WebshopTheme.Changefreq`, `layout` as `WebshopTheme.Layout`, `text` as `WebshopTheme.Text`, `active_from` as `WebshopTheme.Active_from`, `active_untill` as `WebshopTheme.Active_untill` FROM `webshop_themes` AS `WebshopTheme` ORDER BY `order` ASC |
5 |
0 ms |
106 |
SELECT COUNT(*) AS `WebshopThemeProduct.FindCount` FROM `webshop_theme_products` AS `WebshopThemeProduct` WHERE `WebshopThemeProduct`.`theme_id` = '1' |
1 |
0.01 ms |
107 |
SELECT COUNT(*) AS `WebshopThemeProduct.FindCount` FROM `webshop_theme_products` AS `WebshopThemeProduct` WHERE `WebshopThemeProduct`.`theme_id` = '7' |
1 |
0 ms |
108 |
SELECT COUNT(*) AS `WebshopThemeProduct.FindCount` FROM `webshop_theme_products` AS `WebshopThemeProduct` WHERE `WebshopThemeProduct`.`theme_id` = '2' |
1 |
0 ms |
109 |
SELECT COUNT(*) AS `WebshopThemeProduct.FindCount` FROM `webshop_theme_products` AS `WebshopThemeProduct` WHERE `WebshopThemeProduct`.`theme_id` = '3' |
1 |
0 ms |
110 |
SELECT COUNT(*) AS `WebshopThemeProduct.FindCount` FROM `webshop_theme_products` AS `WebshopThemeProduct` WHERE `WebshopThemeProduct`.`theme_id` = '5' |
1 |
0 ms |
111 |
SELECT distinct `brand_id` FROM `webshop_brand_products` WHERE `product_id` IN(2,3,4,5,6,7,8,9,10,11,12,13,14,15,27,28,61,63,64,67,71,72,77,89,90,95,98,109,114,123,124,186,187,188,189,190,191,192,193,198,199,204,205,206,207,208,209,210,211,212,213,214,215,216,276,280,309,313,314,315,316,317,318,319,320,321,323,324,325,326,327,331,339,340,341,342,343,344,345,346,347,348,349,350,351,352,454,455,456,457,458,460,461,462,463,464,465,466,467,468,469,470,471,472,473,474,475,476,477,478,479,480,481,482,483,484,485,486,489,490,491,492,493,494,495,496,497,498,499,500,501,502,503,504,508,511,512,513,518,749,2698,2699,2708,2709,2715,2716,2717,2718,2720,2721,2722,2723,2724,2725,2726,2728,2730,2731,2732,2733,2854,2971,2972,2973,2974,2975,2976,2977,2978,2979,2980,2981,2982,2983,2989,2990,2996,2997,3001,3008,3012,3016,3019,3021,3023,3025,3026,3031,3036,3037,3039,3040,3198,3199,3200,3201,3202,3203,3204,3205,3206,3207,3208,3209,3210,3211,3212,3213,3214,3215,3216,3217,3218,3220,3221,3222,3223,3224,3225,3226,3227,3228,3229,3230,3231,3232,3233,3234,3235,3236,3237,3238,3239,3240,3241) AND `hidden` = 0 |
16 |
0.01 ms |
112 |
DESCRIBE `webshop_brands` |
22 |
0.02 ms |
113 |
SELECT `id` as `WebshopBrand.Id`, `name` as `WebshopBrand.Name`, `language` as `WebshopBrand.Language`, `order` as `WebshopBrand.Order`, `parent` as `WebshopBrand.Parent`, `image` as `WebshopBrand.Image`, `showsubs` as `WebshopBrand.Showsubs`, `showsubpage` as `WebshopBrand.Showsubpage`, `title` as `WebshopBrand.Title`, `intro` as `WebshopBrand.Intro`, `keywords` as `WebshopBrand.Keywords`, `description` as `WebshopBrand.Description`, `author` as `WebshopBrand.Author`, `robots` as `WebshopBrand.Robots`, `metalanguage` as `WebshopBrand.Metalanguage`, `content` as `WebshopBrand.Content`, `priority` as `WebshopBrand.Priority`, `changefreq` as `WebshopBrand.Changefreq`, `layout` as `WebshopBrand.Layout`, `text` as `WebshopBrand.Text`, `active_from` as `WebshopBrand.Active_from`, `active_untill` as `WebshopBrand.Active_untill` FROM `webshop_brands` AS `WebshopBrand` WHERE `id` IN(10,12,13,14,17,22,25,27,29,51,96,97,98,114,127,128) ORDER BY `parent` ASC |
12 |
0 ms |
114 |
SELECT `id` as `WebshopBrand.Id`, `name` as `WebshopBrand.Name`, `language` as `WebshopBrand.Language`, `order` as `WebshopBrand.Order`, `parent` as `WebshopBrand.Parent`, `image` as `WebshopBrand.Image`, `showsubs` as `WebshopBrand.Showsubs`, `showsubpage` as `WebshopBrand.Showsubpage`, `title` as `WebshopBrand.Title`, `intro` as `WebshopBrand.Intro`, `keywords` as `WebshopBrand.Keywords`, `description` as `WebshopBrand.Description`, `author` as `WebshopBrand.Author`, `robots` as `WebshopBrand.Robots`, `metalanguage` as `WebshopBrand.Metalanguage`, `content` as `WebshopBrand.Content`, `priority` as `WebshopBrand.Priority`, `changefreq` as `WebshopBrand.Changefreq`, `layout` as `WebshopBrand.Layout`, `text` as `WebshopBrand.Text`, `active_from` as `WebshopBrand.Active_from`, `active_untill` as `WebshopBrand.Active_untill` FROM `webshop_brands` AS `WebshopBrand` WHERE `WebshopBrand`.`id` = '3' ORDER BY `order` ASC LIMIT 1 |
1 |
0 ms |
115 |
SELECT `id` as `WebshopBrand.Id`, `name` as `WebshopBrand.Name`, `language` as `WebshopBrand.Language`, `order` as `WebshopBrand.Order`, `parent` as `WebshopBrand.Parent`, `image` as `WebshopBrand.Image`, `showsubs` as `WebshopBrand.Showsubs`, `showsubpage` as `WebshopBrand.Showsubpage`, `title` as `WebshopBrand.Title`, `intro` as `WebshopBrand.Intro`, `keywords` as `WebshopBrand.Keywords`, `description` as `WebshopBrand.Description`, `author` as `WebshopBrand.Author`, `robots` as `WebshopBrand.Robots`, `metalanguage` as `WebshopBrand.Metalanguage`, `content` as `WebshopBrand.Content`, `priority` as `WebshopBrand.Priority`, `changefreq` as `WebshopBrand.Changefreq`, `layout` as `WebshopBrand.Layout`, `text` as `WebshopBrand.Text`, `active_from` as `WebshopBrand.Active_from`, `active_untill` as `WebshopBrand.Active_untill` FROM `webshop_brands` AS `WebshopBrand` WHERE `WebshopBrand`.`id` = '6' ORDER BY `order` ASC LIMIT 1 |
1 |
0 ms |
116 |
SELECT `id` as `WebshopBrand.Id`, `name` as `WebshopBrand.Name`, `language` as `WebshopBrand.Language`, `order` as `WebshopBrand.Order`, `parent` as `WebshopBrand.Parent`, `image` as `WebshopBrand.Image`, `showsubs` as `WebshopBrand.Showsubs`, `showsubpage` as `WebshopBrand.Showsubpage`, `title` as `WebshopBrand.Title`, `intro` as `WebshopBrand.Intro`, `keywords` as `WebshopBrand.Keywords`, `description` as `WebshopBrand.Description`, `author` as `WebshopBrand.Author`, `robots` as `WebshopBrand.Robots`, `metalanguage` as `WebshopBrand.Metalanguage`, `content` as `WebshopBrand.Content`, `priority` as `WebshopBrand.Priority`, `changefreq` as `WebshopBrand.Changefreq`, `layout` as `WebshopBrand.Layout`, `text` as `WebshopBrand.Text`, `active_from` as `WebshopBrand.Active_from`, `active_untill` as `WebshopBrand.Active_untill` FROM `webshop_brands` AS `WebshopBrand` WHERE `WebshopBrand`.`id` = '8' ORDER BY `order` ASC LIMIT 1 |
1 |
0 ms |
117 |
SELECT `id` as `WebshopBrand.Id`, `name` as `WebshopBrand.Name`, `language` as `WebshopBrand.Language`, `order` as `WebshopBrand.Order`, `parent` as `WebshopBrand.Parent`, `image` as `WebshopBrand.Image`, `showsubs` as `WebshopBrand.Showsubs`, `showsubpage` as `WebshopBrand.Showsubpage`, `title` as `WebshopBrand.Title`, `intro` as `WebshopBrand.Intro`, `keywords` as `WebshopBrand.Keywords`, `description` as `WebshopBrand.Description`, `author` as `WebshopBrand.Author`, `robots` as `WebshopBrand.Robots`, `metalanguage` as `WebshopBrand.Metalanguage`, `content` as `WebshopBrand.Content`, `priority` as `WebshopBrand.Priority`, `changefreq` as `WebshopBrand.Changefreq`, `layout` as `WebshopBrand.Layout`, `text` as `WebshopBrand.Text`, `active_from` as `WebshopBrand.Active_from`, `active_untill` as `WebshopBrand.Active_untill` FROM `webshop_brands` AS `WebshopBrand` WHERE `WebshopBrand`.`id` = '9' ORDER BY `order` ASC LIMIT 1 |
1 |
0 ms |
118 |
SELECT `id` as `WebshopBrand.Id`, `name` as `WebshopBrand.Name`, `language` as `WebshopBrand.Language`, `order` as `WebshopBrand.Order`, `parent` as `WebshopBrand.Parent`, `image` as `WebshopBrand.Image`, `showsubs` as `WebshopBrand.Showsubs`, `showsubpage` as `WebshopBrand.Showsubpage`, `title` as `WebshopBrand.Title`, `intro` as `WebshopBrand.Intro`, `keywords` as `WebshopBrand.Keywords`, `description` as `WebshopBrand.Description`, `author` as `WebshopBrand.Author`, `robots` as `WebshopBrand.Robots`, `metalanguage` as `WebshopBrand.Metalanguage`, `content` as `WebshopBrand.Content`, `priority` as `WebshopBrand.Priority`, `changefreq` as `WebshopBrand.Changefreq`, `layout` as `WebshopBrand.Layout`, `text` as `WebshopBrand.Text`, `active_from` as `WebshopBrand.Active_from`, `active_untill` as `WebshopBrand.Active_untill` FROM `webshop_brands` AS `WebshopBrand` WHERE `WebshopBrand`.`id` = '113' ORDER BY `order` ASC LIMIT 1 |
1 |
0 ms |
119 |
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 |
120 |
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 |
121 |
SELECT `url` as `Route.Url` FROM `routes` AS `Route` WHERE `Route`.`route` = '/vloeren/loose-lay' ORDER BY `route` DESC LIMIT 1 |
1 |
0 ms |
122 |
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` = '8' ORDER BY `order` ASC LIMIT 1 |
1 |
0 ms |
123 |
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` = '1' ORDER BY `order` ASC LIMIT 1 |
1 |
0 ms |
124 |
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 |
125 |
SELECT `url` as `Route.Url`, `route` as `Route.Route`, `language` as `Route.Language` FROM `routes` AS `Route` WHERE `Route`.`url` = '/vloeren' AND `Route`.`language` = '1' ORDER BY `route` DESC LIMIT 1 |
0 |
0 ms |
126 |
SELECT `url` as `Route.Url`, `route` as `Route.Route`, `language` as `Route.Language` FROM `routes` AS `Route` WHERE `Route`.`url` = '/vloeren/loose-lay' AND `Route`.`language` = '1' ORDER BY `route` DESC LIMIT 1 |
0 |
0 ms |
127 |
SELECT `content` as `Page.Content` FROM `pages` AS `Page` WHERE `Page`.`id` = 'footer-showroom' AND `Page`.`language` = '1' LIMIT 1 |
1 |
0 ms |
128 |
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 |
129 |
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 |
130 |
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 |
131 |
SELECT COUNT(*) AS `Translation.FindCount` FROM `translations` AS `Translation` WHERE `Translation`.`id` = 'Wiwi Websolutions' AND `Translation`.`language` = '1' |
1 |
0.01 ms |