garagemortier.be - Nieuwe wagens

Bedrijfsvoertuigen

Fiesta Van

Koetswerk Prijs

Meer informatie

Transit Connect

Koetswerk Prijs

Meer informatie

Ranger

Koetswerk Prijs

Meer informatie

Transit Bestelwagen

Koetswerk Prijs

Meer informatie

Transit Chassis Cabine

Koetswerk Prijs

Meer informatie

Transit Minibus

Koetswerk Prijs

Meer informatie

Tourneo

Koetswerk Prijs

Meer informatie

(default) 53 queries took 113 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `dm_modules`	8	8	1
2	DESCRIBE `dm_fields`	10	10	1
3	DESCRIBE `i18n`	6	6	1
4	DESCRIBE `dm_groups`	4	4	1
5	DESCRIBE `dm_items`	5	5	1
6	DESCRIBE `dm_links`	5	5	1
7	DESCRIBE `images`	10	10	1
8	DESCRIBE `dm_items_images`	4	4	1
9	DESCRIBE `menus`	14	14	1
10	DESCRIBE `products_groups`	10	10	1
11	DESCRIBE `users`	33	33	1
12	DESCRIBE `profiles`	37	37	1
13	DESCRIBE `countries`	3	3	1
14	DESCRIBE `transport_costs`	5	5	1
15	DESCRIBE `contacts`	16	16	1
16	DESCRIBE `products_items`	26	26	1
17	DESCRIBE `products_types`	5	5	1
18	DESCRIBE `products_properties`	9	9	1
19	DESCRIBE `products_types_properties`	2	2	1
20	DESCRIBE `products_brands`	7	7	1
21	DESCRIBE `products_custompricegroups`	4	4	1
22	DESCRIBE `usergroups`	5	5	1
23	DESCRIBE `products_promos`	4	4	1
24	DESCRIBE `products_discounts`	6	6	1
25	DESCRIBE `products_values`	7	7	1
26	DESCRIBE `products_items_images`	3	3	1
27	DESCRIBE `products_items_values`	2	2	1
28	DESCRIBE `file_bindings`	4	4	1
29	DESCRIBE `fileobjs`	10	10	1
30	DESCRIBE `filetypes`	8	8	1
31	DESCRIBE `users_favourites`	2	2	1
32	SELECT `DmModule`.*, `I18n__name`.`content`, `DmModule`.`id` FROM `dm_modules` AS `DmModule` LEFT JOIN `i18n` AS `I18n__name` ON (`DmModule`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Module' AND `I18n__name`.`field` = 'name') WHERE `DmModule`.`token` = 'nieuwewagens' AND `I18n__name`.`locale` = 'dut' LIMIT 1	1	1	16
33	SELECT `DmField`.`id`, `DmField`.`module_id`, `DmField`.`tag`, `DmField`.`class`, `DmField`.`type`, `DmField`.`required`, `DmField`.`label`, `DmField`.`primary`, `DmField`.`is_slug`, `DmField`.`weight` FROM `dm_fields` AS `DmField` WHERE `DmField`.`module_id` = (1)	3	3	20
34	SELECT COUNT(DISTINCT(`DmGroup`.`id`)) AS count FROM `dm_groups` AS `DmGroup` INNER JOIN `i18n` AS `I18nModel` ON (`DmGroup`.`id` = `I18nModel`.`foreign_key` AND `I18nModel`.`model` = 'DmGroup' AND `I18nModel`.`locale` = 'dut') WHERE `DmGroup`.`id` = 2 AND `DmGroup`.`module_id` = 1	1	1	10
35	SELECT `DmGroup`.*, `I18n__name`.`content` FROM `dm_groups` AS `DmGroup` LEFT JOIN `i18n` AS `I18n__name` ON (`DmGroup`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'DmGroup' AND `I18n__name`.`field` = 'name') WHERE `DmGroup`.`id` = 2 AND `I18n__name`.`locale` = 'dut' LIMIT 1	1	1	1
36	SELECT `DmGroup`.`id`, `I18n__name`.`content` FROM `dm_groups` AS `DmGroup` LEFT JOIN `i18n` AS `I18n__name` ON (`DmGroup`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'DmGroup' AND `I18n__name`.`field` = 'name') WHERE `DmGroup`.`module_id` = 1 AND `DmGroup`.`parent_id` = 2 AND `I18n__name`.`locale` = 'dut'	0	0	1
37	SELECT COUNT(DISTINCT(`DmItem`.`id`)) AS count FROM `dm_items` AS `DmItem` INNER JOIN `i18n` AS `I18nModel` ON (`DmItem`.`id` = `I18nModel`.`foreign_key` AND `I18nModel`.`model` = 'Item' AND `I18nModel`.`locale` = 'dut') WHERE `DmItem`.`module_id` = 1 AND `DmItem`.`group_id` = 2 AND `DmItem`.`archived` = 0	1	1	18
38	SELECT `DmItem`.`id`, `I18n__field_1`.`content`, `I18n__field_2`.`content`, `I18n__field_4`.`content` FROM `dm_items` AS `DmItem` LEFT JOIN `i18n` AS `I18n__field_1` ON (`DmItem`.`id` = `I18n__field_1`.`foreign_key` AND `I18n__field_1`.`model` = 'Item' AND `I18n__field_1`.`field` = 'field_1') LEFT JOIN `i18n` AS `I18n__field_2` ON (`DmItem`.`id` = `I18n__field_2`.`foreign_key` AND `I18n__field_2`.`model` = 'Item' AND `I18n__field_2`.`field` = 'field_2') LEFT JOIN `i18n` AS `I18n__field_4` ON (`DmItem`.`id` = `I18n__field_4`.`foreign_key` AND `I18n__field_4`.`model` = 'Item' AND `I18n__field_4`.`field` = 'field_4') WHERE `DmItem`.`module_id` = 1 AND `DmItem`.`group_id` = 2 AND `DmItem`.`archived` = 0 AND `I18n__field_1`.`locale` = 'dut' AND `I18n__field_2`.`locale` = 'dut' AND `I18n__field_4`.`locale` = 'dut' ORDER BY `DmItem`.`weight` DESC LIMIT 25	7	7	6
39	SELECT `DmLink`.`id`, `DmLink`.`item_id`, `DmLink`.`name`, `DmLink`.`href`, `DmLink`.`target` FROM `dm_links` AS `DmLink` WHERE `DmLink`.`item_id` IN (11, 12, 17, 15, 16, 13, 14)	7	7	9
40	SELECT `Image`.`file`, `Image`.`thumb`, `DmItemsImage`.`id`, `DmItemsImage`.`item_id`, `DmItemsImage`.`image_id`, `DmItemsImage`.`weight` FROM `images` AS `Image` JOIN `dm_items_images` AS `DmItemsImage` ON (`DmItemsImage`.`item_id` IN (11, 12, 17, 15, 16, 13, 14) AND `DmItemsImage`.`image_id` = `Image`.`id`) WHERE 1 = 1	7	7	0
41	SELECT Menu.id, Menu.parent_id, IF( Slug.content <> '', CONCAT(Menu.url, Slug.content), Menu.url ) AS url, MenuCaption.content AS caption, 0 AS active, Menu.target, Menu.class FROM menus Menu LEFT JOIN i18n MenuCaption ON MenuCaption.model = 'Menu' AND MenuCaption.field = 'caption' AND MenuCaption.locale = 'dut' AND MenuCaption.foreign_key = Menu.id LEFT JOIN i18n Slug ON Slug.model = Menu.model AND Slug.field = 'slug' AND Slug.locale = 'dut' AND Slug.foreign_key = Menu.foreign_key WHERE Menu.frontend = 1 AND Menu.active = 1 AND Menu.parent_id = 0 ORDER BY Menu.weight ASC	8	8	0
42	SELECT Menu.id, Menu.parent_id, IF( Slug.content <> '', CONCAT(Menu.url, Slug.content), Menu.url ) AS url, MenuCaption.content AS caption, 0 AS active, Menu.target, Menu.class FROM menus Menu LEFT JOIN i18n MenuCaption ON MenuCaption.model = 'Menu' AND MenuCaption.field = 'caption' AND MenuCaption.locale = 'dut' AND MenuCaption.foreign_key = Menu.id LEFT JOIN i18n Slug ON Slug.model = Menu.model AND Slug.field = 'slug' AND Slug.locale = 'dut' AND Slug.foreign_key = Menu.foreign_key WHERE Menu.frontend = 1 AND Menu.active = 1 AND Menu.parent_id = 439 ORDER BY Menu.weight ASC	0	0	0
43	SELECT Menu.id, Menu.parent_id, IF( Slug.content <> '', CONCAT(Menu.url, Slug.content), Menu.url ) AS url, MenuCaption.content AS caption, 0 AS active, Menu.target, Menu.class FROM menus Menu LEFT JOIN i18n MenuCaption ON MenuCaption.model = 'Menu' AND MenuCaption.field = 'caption' AND MenuCaption.locale = 'dut' AND MenuCaption.foreign_key = Menu.id LEFT JOIN i18n Slug ON Slug.model = Menu.model AND Slug.field = 'slug' AND Slug.locale = 'dut' AND Slug.foreign_key = Menu.foreign_key WHERE Menu.frontend = 1 AND Menu.active = 1 AND Menu.parent_id = 440 ORDER BY Menu.weight ASC	0	0	0
44	SELECT Menu.id, Menu.parent_id, IF( Slug.content <> '', CONCAT(Menu.url, Slug.content), Menu.url ) AS url, MenuCaption.content AS caption, 0 AS active, Menu.target, Menu.class FROM menus Menu LEFT JOIN i18n MenuCaption ON MenuCaption.model = 'Menu' AND MenuCaption.field = 'caption' AND MenuCaption.locale = 'dut' AND MenuCaption.foreign_key = Menu.id LEFT JOIN i18n Slug ON Slug.model = Menu.model AND Slug.field = 'slug' AND Slug.locale = 'dut' AND Slug.foreign_key = Menu.foreign_key WHERE Menu.frontend = 1 AND Menu.active = 1 AND Menu.parent_id = 441 ORDER BY Menu.weight ASC	0	0	0
45	SELECT Menu.id, Menu.parent_id, IF( Slug.content <> '', CONCAT(Menu.url, Slug.content), Menu.url ) AS url, MenuCaption.content AS caption, 0 AS active, Menu.target, Menu.class FROM menus Menu LEFT JOIN i18n MenuCaption ON MenuCaption.model = 'Menu' AND MenuCaption.field = 'caption' AND MenuCaption.locale = 'dut' AND MenuCaption.foreign_key = Menu.id LEFT JOIN i18n Slug ON Slug.model = Menu.model AND Slug.field = 'slug' AND Slug.locale = 'dut' AND Slug.foreign_key = Menu.foreign_key WHERE Menu.frontend = 1 AND Menu.active = 1 AND Menu.parent_id = 433 ORDER BY Menu.weight ASC	0	0	0
46	SELECT Menu.id, Menu.parent_id, IF( Slug.content <> '', CONCAT(Menu.url, Slug.content), Menu.url ) AS url, MenuCaption.content AS caption, 0 AS active, Menu.target, Menu.class FROM menus Menu LEFT JOIN i18n MenuCaption ON MenuCaption.model = 'Menu' AND MenuCaption.field = 'caption' AND MenuCaption.locale = 'dut' AND MenuCaption.foreign_key = Menu.id LEFT JOIN i18n Slug ON Slug.model = Menu.model AND Slug.field = 'slug' AND Slug.locale = 'dut' AND Slug.foreign_key = Menu.foreign_key WHERE Menu.frontend = 1 AND Menu.active = 1 AND Menu.parent_id = 442 ORDER BY Menu.weight ASC	0	0	0
47	SELECT Menu.id, Menu.parent_id, IF( Slug.content <> '', CONCAT(Menu.url, Slug.content), Menu.url ) AS url, MenuCaption.content AS caption, 0 AS active, Menu.target, Menu.class FROM menus Menu LEFT JOIN i18n MenuCaption ON MenuCaption.model = 'Menu' AND MenuCaption.field = 'caption' AND MenuCaption.locale = 'dut' AND MenuCaption.foreign_key = Menu.id LEFT JOIN i18n Slug ON Slug.model = Menu.model AND Slug.field = 'slug' AND Slug.locale = 'dut' AND Slug.foreign_key = Menu.foreign_key WHERE Menu.frontend = 1 AND Menu.active = 1 AND Menu.parent_id = 435 ORDER BY Menu.weight ASC	0	0	0
48	SELECT Menu.id, Menu.parent_id, IF( Slug.content <> '', CONCAT(Menu.url, Slug.content), Menu.url ) AS url, MenuCaption.content AS caption, 0 AS active, Menu.target, Menu.class FROM menus Menu LEFT JOIN i18n MenuCaption ON MenuCaption.model = 'Menu' AND MenuCaption.field = 'caption' AND MenuCaption.locale = 'dut' AND MenuCaption.foreign_key = Menu.id LEFT JOIN i18n Slug ON Slug.model = Menu.model AND Slug.field = 'slug' AND Slug.locale = 'dut' AND Slug.foreign_key = Menu.foreign_key WHERE Menu.frontend = 1 AND Menu.active = 1 AND Menu.parent_id = 436 ORDER BY Menu.weight ASC	0	0	0
49	SELECT Menu.id, Menu.parent_id, IF( Slug.content <> '', CONCAT(Menu.url, Slug.content), Menu.url ) AS url, MenuCaption.content AS caption, 0 AS active, Menu.target, Menu.class FROM menus Menu LEFT JOIN i18n MenuCaption ON MenuCaption.model = 'Menu' AND MenuCaption.field = 'caption' AND MenuCaption.locale = 'dut' AND MenuCaption.foreign_key = Menu.id LEFT JOIN i18n Slug ON Slug.model = Menu.model AND Slug.field = 'slug' AND Slug.locale = 'dut' AND Slug.foreign_key = Menu.foreign_key WHERE Menu.frontend = 1 AND Menu.active = 1 AND Menu.parent_id = 437 ORDER BY Menu.weight ASC	0	0	0
50	SELECT item_id AS id FROM blacklists Blacklist WHERE model = 'ProductsGroup' AND user_id = 0	0	0	0
51	SELECT `ProductsGroup`.`id`, `ProductsGroup`.`image_id`, `ProductsGroup`.`parent_id`, `Image`.`thumb`, `Image`.`id`, `I18n__name`.`content`, `I18n__description`.`content` FROM `products_groups` AS `ProductsGroup` LEFT JOIN `i18n` AS `I18n__name` ON (`ProductsGroup`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'ProductsGroup' AND `I18n__name`.`field` = 'name') LEFT JOIN `i18n` AS `I18n__description` ON (`ProductsGroup`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'ProductsGroup' AND `I18n__description`.`field` = 'description') LEFT JOIN `images` AS `Image` ON (`ProductsGroup`.`image_id` = `Image`.`id`) WHERE `parent_id` = 0 AND `hidden` = 0 AND `I18n__name`.`locale` = 'dut' AND `I18n__description`.`locale` = 'dut' ORDER BY `ProductsGroup`.`weight` ASC	0	0	0
52	DESCRIBE `themes`	7	7	1
53	SELECT Theme.slug AS slug, I18n_name.content AS name FROM themes Theme INNER JOIN i18n I18n_name ON I18n_name.model = 'Theme' AND I18n_name.field = 'name' AND I18n_name.locale = 'dut' AND I18n_name.foreign_key = Theme.id	0	0	0

(default) 53 queries took 113 ms

Query

Error

Affected

Num. rows

Took (ms)

DESCRIBE `dm_modules`

DESCRIBE `dm_fields`

DESCRIBE `i18n`

DESCRIBE `dm_groups`

DESCRIBE `dm_items`

DESCRIBE `dm_links`

DESCRIBE `images`

DESCRIBE `dm_items_images`

DESCRIBE `menus`

DESCRIBE `products_groups`

DESCRIBE `users`

DESCRIBE `profiles`

DESCRIBE `countries`

DESCRIBE `transport_costs`

DESCRIBE `contacts`

DESCRIBE `products_items`

DESCRIBE `products_types`

DESCRIBE `products_properties`

DESCRIBE `products_types_properties`

DESCRIBE `products_brands`

DESCRIBE `products_custompricegroups`

DESCRIBE `usergroups`

DESCRIBE `products_promos`

DESCRIBE `products_discounts`

DESCRIBE `products_values`

DESCRIBE `products_items_images`

DESCRIBE `products_items_values`

DESCRIBE `file_bindings`

DESCRIBE `fileobjs`

DESCRIBE `filetypes`

DESCRIBE `users_favourites`

SELECT `DmModule`.*, `I18n__name`.`content`, `DmModule`.`id` FROM `dm_modules` AS `DmModule` LEFT JOIN `i18n` AS `I18n__name` ON (`DmModule`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'Module' AND `I18n__name`.`field` = 'name') WHERE `DmModule`.`token` = 'nieuwewagens' AND `I18n__name`.`locale` = 'dut' LIMIT 1

SELECT `DmField`.`id`, `DmField`.`module_id`, `DmField`.`tag`, `DmField`.`class`, `DmField`.`type`, `DmField`.`required`, `DmField`.`label`, `DmField`.`primary`, `DmField`.`is_slug`, `DmField`.`weight` FROM `dm_fields` AS `DmField` WHERE `DmField`.`module_id` = (1)

SELECT COUNT(DISTINCT(`DmGroup`.`id`)) AS count FROM `dm_groups` AS `DmGroup` INNER JOIN `i18n` AS `I18nModel` ON (`DmGroup`.`id` = `I18nModel`.`foreign_key` AND `I18nModel`.`model` = 'DmGroup' AND `I18nModel`.`locale` = 'dut') WHERE `DmGroup`.`id` = 2 AND `DmGroup`.`module_id` = 1

SELECT `DmGroup`.*, `I18n__name`.`content` FROM `dm_groups` AS `DmGroup` LEFT JOIN `i18n` AS `I18n__name` ON (`DmGroup`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'DmGroup' AND `I18n__name`.`field` = 'name') WHERE `DmGroup`.`id` = 2 AND `I18n__name`.`locale` = 'dut' LIMIT 1

SELECT `DmGroup`.`id`, `I18n__name`.`content` FROM `dm_groups` AS `DmGroup` LEFT JOIN `i18n` AS `I18n__name` ON (`DmGroup`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'DmGroup' AND `I18n__name`.`field` = 'name') WHERE `DmGroup`.`module_id` = 1 AND `DmGroup`.`parent_id` = 2 AND `I18n__name`.`locale` = 'dut'

SELECT COUNT(DISTINCT(`DmItem`.`id`)) AS count FROM `dm_items` AS `DmItem` INNER JOIN `i18n` AS `I18nModel` ON (`DmItem`.`id` = `I18nModel`.`foreign_key` AND `I18nModel`.`model` = 'Item' AND `I18nModel`.`locale` = 'dut') WHERE `DmItem`.`module_id` = 1 AND `DmItem`.`group_id` = 2 AND `DmItem`.`archived` = 0

SELECT `DmItem`.`id`, `I18n__field_1`.`content`, `I18n__field_2`.`content`, `I18n__field_4`.`content` FROM `dm_items` AS `DmItem` LEFT JOIN `i18n` AS `I18n__field_1` ON (`DmItem`.`id` = `I18n__field_1`.`foreign_key` AND `I18n__field_1`.`model` = 'Item' AND `I18n__field_1`.`field` = 'field_1') LEFT JOIN `i18n` AS `I18n__field_2` ON (`DmItem`.`id` = `I18n__field_2`.`foreign_key` AND `I18n__field_2`.`model` = 'Item' AND `I18n__field_2`.`field` = 'field_2') LEFT JOIN `i18n` AS `I18n__field_4` ON (`DmItem`.`id` = `I18n__field_4`.`foreign_key` AND `I18n__field_4`.`model` = 'Item' AND `I18n__field_4`.`field` = 'field_4') WHERE `DmItem`.`module_id` = 1 AND `DmItem`.`group_id` = 2 AND `DmItem`.`archived` = 0 AND `I18n__field_1`.`locale` = 'dut' AND `I18n__field_2`.`locale` = 'dut' AND `I18n__field_4`.`locale` = 'dut' ORDER BY `DmItem`.`weight` DESC LIMIT 25

SELECT `DmLink`.`id`, `DmLink`.`item_id`, `DmLink`.`name`, `DmLink`.`href`, `DmLink`.`target` FROM `dm_links` AS `DmLink` WHERE `DmLink`.`item_id` IN (11, 12, 17, 15, 16, 13, 14)

SELECT `Image`.`file`, `Image`.`thumb`, `DmItemsImage`.`id`, `DmItemsImage`.`item_id`, `DmItemsImage`.`image_id`, `DmItemsImage`.`weight` FROM `images` AS `Image` JOIN `dm_items_images` AS `DmItemsImage` ON (`DmItemsImage`.`item_id` IN (11, 12, 17, 15, 16, 13, 14) AND `DmItemsImage`.`image_id` = `Image`.`id`) WHERE 1 = 1

SELECT Menu.id, Menu.parent_id, IF( Slug.content <> '', CONCAT(Menu.url, Slug.content), Menu.url ) AS url, MenuCaption.content AS caption, 0 AS active, Menu.target, Menu.class FROM menus Menu LEFT JOIN i18n MenuCaption ON MenuCaption.model = 'Menu' AND MenuCaption.field = 'caption' AND MenuCaption.locale = 'dut' AND MenuCaption.foreign_key = Menu.id LEFT JOIN i18n Slug ON Slug.model = Menu.model AND Slug.field = 'slug' AND Slug.locale = 'dut' AND Slug.foreign_key = Menu.foreign_key WHERE Menu.frontend = 1 AND Menu.active = 1 AND Menu.parent_id = 0 ORDER BY Menu.weight ASC

SELECT item_id AS id FROM blacklists Blacklist WHERE model = 'ProductsGroup' AND user_id = 0

SELECT `ProductsGroup`.`id`, `ProductsGroup`.`image_id`, `ProductsGroup`.`parent_id`, `Image`.`thumb`, `Image`.`id`, `I18n__name`.`content`, `I18n__description`.`content` FROM `products_groups` AS `ProductsGroup` LEFT JOIN `i18n` AS `I18n__name` ON (`ProductsGroup`.`id` = `I18n__name`.`foreign_key` AND `I18n__name`.`model` = 'ProductsGroup' AND `I18n__name`.`field` = 'name') LEFT JOIN `i18n` AS `I18n__description` ON (`ProductsGroup`.`id` = `I18n__description`.`foreign_key` AND `I18n__description`.`model` = 'ProductsGroup' AND `I18n__description`.`field` = 'description') LEFT JOIN `images` AS `Image` ON (`ProductsGroup`.`image_id` = `Image`.`id`) WHERE `parent_id` = 0 AND `hidden` = 0 AND `I18n__name`.`locale` = 'dut' AND `I18n__description`.`locale` = 'dut' ORDER BY `ProductsGroup`.`weight` ASC

DESCRIBE `themes`

SELECT Theme.slug AS slug, I18n_name.content AS name FROM themes Theme INNER JOIN i18n I18n_name ON I18n_name.model = 'Theme' AND I18n_name.field = 'name' AND I18n_name.locale = 'dut' AND I18n_name.foreign_key = Theme.id