Een samenwerking tussen HORNBACH en SUEZ
Copyright SUEZ Nederland Holding B.V., Meester E.N. van Kleffenstraat 10, 6842 CV Arnhem
Copyright SUEZ Nederland Holding B.V., Meester E.N. van Kleffenstraat 10, 6842 CV Arnhem
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Parameter`.`value` FROM `bouwbakkie`.`parameters` AS `Parameter` LEFT JOIN `bouwbakkie`.`sites` AS `Site` ON (`Parameter`.`site_id` = `Site`.`id`) WHERE `Parameter`.`name` = 'slugprefix' AND ((`Parameter`.`site_id` = 1) OR (`Parameter`.`site_id` = 15)) LIMIT 1 | 1 | 1 | 0 | |
| 2 | SELECT `Nodeliverydate`.`id`, `Nodeliverydate`.`date` FROM `bouwbakkie`.`nodeliverydates` AS `Nodeliverydate` WHERE 1 = 1 | 4 | 4 | 0 | |
| 3 | SELECT `Site`.`id`, `Site`.`name`, `Site`.`url`, `Site`.`layout`, `Site`.`css`, `Site`.`metadescription`, `Site`.`theme`, `Site`.`mobiletheme`, `Site`.`ordercounter`, `Site`.`previous_supplier_id`, `Site`.`active` FROM `bouwbakkie`.`sites` AS `Site` WHERE `Site`.`url` = 'hornbach-container.nl' LIMIT 1 | 1 | 1 | 0 | |
| 4 | SELECT `Parameter`.`value` FROM `bouwbakkie`.`parameters` AS `Parameter` LEFT JOIN `bouwbakkie`.`sites` AS `Site` ON (`Parameter`.`site_id` = `Site`.`id`) WHERE `Parameter`.`name` = 'btwpercentage' AND ((`Parameter`.`site_id` = 1) OR (`Parameter`.`site_id` = 15)) LIMIT 1 | 1 | 1 | 0 | |
| 5 | SELECT `Text`.`id`, `Text`.`name`, `Text`.`string`, `Text`.`metakeywords`, `Text`.`title`, `Text`.`metadescription`, `Text`.`site_id`, `Text`.`created`, `Text`.`modified`, `Site`.`id`, `Site`.`name`, `Site`.`url`, `Site`.`layout`, `Site`.`css`, `Site`.`metadescription`, `Site`.`theme`, `Site`.`mobiletheme`, `Site`.`ordercounter`, `Site`.`previous_supplier_id`, `Site`.`active` FROM `bouwbakkie`.`texts` AS `Text` LEFT JOIN `bouwbakkie`.`sites` AS `Site` ON (`Text`.`site_id` = `Site`.`id`) WHERE `Text`.`name` = 'IDS_SITE_KEYWORDS' AND `Text`.`site_id` = 15 LIMIT 1 | 1 | 1 | 0 | |
| 6 | SELECT `Text`.`id`, `Text`.`name`, `Text`.`string`, `Text`.`metakeywords`, `Text`.`title`, `Text`.`metadescription`, `Text`.`site_id`, `Text`.`created`, `Text`.`modified`, `Site`.`id`, `Site`.`name`, `Site`.`url`, `Site`.`layout`, `Site`.`css`, `Site`.`metadescription`, `Site`.`theme`, `Site`.`mobiletheme`, `Site`.`ordercounter`, `Site`.`previous_supplier_id`, `Site`.`active` FROM `bouwbakkie`.`texts` AS `Text` LEFT JOIN `bouwbakkie`.`sites` AS `Site` ON (`Text`.`site_id` = `Site`.`id`) WHERE `Text`.`name` = 'IDS_SITE_DESCRIPTION' AND `Text`.`site_id` = 15 LIMIT 1 | 1 | 1 | 0 | |
| 7 | SELECT `Text`.`id`, `Text`.`name`, `Text`.`string`, `Text`.`metakeywords`, `Text`.`title`, `Text`.`metadescription`, `Text`.`site_id`, `Text`.`created`, `Text`.`modified`, `Site`.`id`, `Site`.`name`, `Site`.`url`, `Site`.`layout`, `Site`.`css`, `Site`.`metadescription`, `Site`.`theme`, `Site`.`mobiletheme`, `Site`.`ordercounter`, `Site`.`previous_supplier_id`, `Site`.`active` FROM `bouwbakkie`.`texts` AS `Text` LEFT JOIN `bouwbakkie`.`sites` AS `Site` ON (`Text`.`site_id` = `Site`.`id`) WHERE `Text`.`name` = 'IDS_SITE_SLOGAN' AND `Text`.`site_id` = 15 LIMIT 1 | 1 | 1 | 0 | |
| 8 | SELECT `Province`.`id`, `Province`.`provincecode`, `Province`.`name`, `Province`.`capital`, `Province`.`title`, `Province`.`description`, `Province`.`metakeywords`, `Province`.`metadescription`, `Province`.`site_id`, `Site`.`id`, `Site`.`name`, `Site`.`url`, `Site`.`layout`, `Site`.`css`, `Site`.`metadescription`, `Site`.`theme`, `Site`.`mobiletheme`, `Site`.`ordercounter`, `Site`.`previous_supplier_id`, `Site`.`active` FROM `bouwbakkie`.`provinces` AS `Province` LEFT JOIN `bouwbakkie`.`sites` AS `Site` ON (`Province`.`site_id` = `Site`.`id`) WHERE `Province`.`provincecode` != 'Z' AND `Province`.`site_id` = 15 ORDER BY `Province`.`name` ASC | 0 | 0 | 0 | |
| 9 | SELECT `Feedback`.*, `Order`.`invoice_city` FROM `bouwbakkie`.`feedback` AS `Feedback` left JOIN `bouwbakkie`.`orders` AS `Order` ON (`Order`.`ordernumber` = `Feedback`.`ordernumber`) WHERE `Feedback`.`user` <> 'Anoniem' AND `Feedback`.`score` > 3 AND `Feedback`.`status` = 'Goedgekeurd' AND `Feedback`.`text` <> '' ORDER BY `Feedback`.`tfcid` DESC LIMIT 2 | 2 | 2 | 0 | |
| 10 | SELECT `Parameter`.`value` FROM `bouwbakkie`.`parameters` AS `Parameter` LEFT JOIN `bouwbakkie`.`sites` AS `Site` ON (`Parameter`.`site_id` = `Site`.`id`) WHERE `Parameter`.`name` = 'feedback_score' AND ((`Parameter`.`site_id` = 1) OR (`Parameter`.`site_id` = 15)) LIMIT 1 | 1 | 1 | 0 | |
| 11 | SELECT `Parameter`.`value` FROM `bouwbakkie`.`parameters` AS `Parameter` LEFT JOIN `bouwbakkie`.`sites` AS `Site` ON (`Parameter`.`site_id` = `Site`.`id`) WHERE `Parameter`.`name` = 'feedback_noreviews' AND ((`Parameter`.`site_id` = 1) OR (`Parameter`.`site_id` = 15)) LIMIT 1 | 1 | 1 | 0 | |
| 12 | SELECT `Container`.`id`, `Container`.`type`, `Container`.`width`, `Container`.`depth`, `Container`.`height`, `Wastetype`.`id`, `Wastetype`.`wastetype`, `Wastetype`.`soil`, `ContainersWastetype`.`id`, `ContainersWastetype`.`price`, `ContainersWastetype`.`container_id`, `ContainersWastetype`.`wastetype_id`, `ContainersWastetype`.`containertype` FROM `bouwbakkie`.`containers_wastetypes` AS `ContainersWastetype` LEFT JOIN `bouwbakkie`.`containers` AS `Container` ON (`ContainersWastetype`.`container_id` = `Container`.`id` AND `Container`.`site_id` = 15) LEFT JOIN `bouwbakkie`.`wastetypes` AS `Wastetype` ON (`ContainersWastetype`.`wastetype_id` = `Wastetype`.`id` AND `Wastetype`.`site_id` = 15) WHERE `ContainersWastetype`.`id` IS NULL AND `ContainersWastetype`.`site_id` = 15 | 0 | 0 | 0 | |
| 13 | SELECT min(`ContainersWastetype`.`price`) as minprice, max(ContainersWastetype.price) as maxprice FROM `bouwbakkie`.`containers_wastetypes` AS `ContainersWastetype` WHERE `ContainersWastetype`.`site_id` = 15 AND `ContainersWastetype`.`active` = '1' | 1 | 1 | 0 | |
| 14 | SELECT `Parameter`.`site_id`, `Parameter`.`value` FROM `bouwbakkie`.`parameters` AS `Parameter` WHERE `Parameter`.`name` = 'sitelogo' | 6 | 6 | 0 | |
| 15 | SELECT `Parameter`.`id`, `Parameter`.`name`, `Parameter`.`value` FROM `bouwbakkie`.`parameters` AS `Parameter` WHERE ((`Parameter`.`site_id` = 1) OR (`Parameter`.`site_id` = 15)) | 40 | 40 | 0 | |
| 16 | SELECT `Text`.`name`, `Text`.`string`, `Text`.`metakeywords`, `Text`.`title`, `Text`.`metadescription` FROM `bouwbakkie`.`texts` AS `Text` LEFT JOIN `bouwbakkie`.`sites` AS `Site` ON (`Text`.`site_id` = `Site`.`id`) WHERE `Text`.`site_id` = 15 | 28 | 28 | 0 | |
| 17 | SELECT `Blockedip`.`id`, `Blockedip`.`ip`, `Blockedip`.`hostname`, `Blockedip`.`name`, `Blockedip`.`email`, `Blockedip`.`created`, `Blockedip`.`modified` FROM `bouwbakkie`.`blockedips` AS `Blockedip` WHERE `ip` = '54.82.10.219' LIMIT 1 | 0 | 0 | 0 | |
| 18 | SELECT `Session`.`id`, `Session`.`data`, `Session`.`expires` FROM `bouwbakkie`.`cake_sessions` AS `Session` WHERE `Session`.`id` = 'p20qr0g9qkpj5pe1159iia11c5' LIMIT 1 | 0 | 0 | 0 |