| Time |
Query |
|
6.99ms
|
select * from `redirects` where `van` like 'https://www.promotie-kledij.eu/nl/categorie/bistro-horeca-177.html'
|
|
1.36ms
|
select * from `prdcategorie` where `CATE_SLUG1` = 'bistro-horeca-177' and `CATE_ACTIEF` = '1' limit 1
|
|
0.4ms
|
select * from `prdcategorie` where `prdcategorie`.`idPrdcategorie` = '2' limit 1
|
|
0.22ms
|
select * from `prdcategorie` where `prdcategorie`.`idPrdcategorie` in ('0')
|
|
11.02ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` inner join `ecom_shops_categorie` on `prdcategorie`.`idPrdcategorie` = `ecom_shops_categorie`.`idPrdcategorie` where `prdcategorie`.`CATE_ACTIEF` = '1' and `ecom_shops_categorie`.`idShops` = '1' and `prdcategorie`.`idBron` = '2' group by `prdcategorie`.`idPrdcategorie` order by `prdcategorie`.`CATE_NAAM1` asc
|
|
14.29ms
|
SELECT titel, value_id AS pf_id, count(ecfid) AS aantal, textwaarde, groepwaarde, volgorde, feature_id, textcode, a.idProduct FROM(
SELECT cf.`titel1` AS titel, cf.volgorde as volgorde, pf.id AS ecfid,
`ecom_custfeatwaarde`.`waarde1` AS textwaarde, `ecom_custfeatwaarde`.`code` AS textcode, concat(`ecom_custfeatwaarde`.`waarde1`,cf.id)
AS groepwaarde, ecom_custfeatwaarde.id AS value_id,
concat('single_',pf.id) AS type_id, ecom_custfeatwaarde.`volgorde` AS value_volgorde, cf.id AS feature_id, pf.idProduct
FROM `ecom_productfamiliecustomfeatures` pf
INNER JOIN `ecom_customfeatures` cf ON pf.`idEcomCustomfeatures` = cf.`id`
INNER JOIN `ecom_productfamiliecustomfeatures_waardes` pfw ON pf.`id` = pfw.`productfamiliecustomfeature_id`
INNER JOIN `ecom_custfeatwaarde` ON pfw.`waarde_id` = `ecom_custfeatwaarde`.`id`
INNER JOIN `ecom_customgroep` on (cf.`ecom_customgroep_id` = `ecom_customgroep`.`id`)
INNER JOIN `ecom_productfamiliecategorie` ON `pf`.`idProduct` = `ecom_productfamiliecategorie`.`idProduct` WHERE cf.type = 1 AND cf.active = 1 AND ecom_productfamiliecategorie.idPrdcategorie = 177 GROUP BY pf.idProduct, ecom_custfeatwaarde.id
ORDER BY titel, textwaarde ASC) a
INNER JOIN `ecom_productfamiliecategorie` ON a.idProduct = `ecom_productfamiliecategorie`.`idProduct`
WHERE `ecom_productfamiliecategorie`.`idPrdcategorie` = 177 AND textwaarde IS NOT NULL AND titel IS NOT NULL GROUP BY value_id ORDER BY volgorde, titel asc, textwaarde asc
|
|
49.17ms
|
select count(*) as aggregate from `productfeatures` inner join `product` on `productfeatures`.`idProduct` = `product`.`idProduct` inner join `ecom_productcategorie` on `productfeatures`.`idProductfeatures` = `ecom_productcategorie`.`idProductfeatures` inner join `ecom_productfeatures_shops` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_shops`.`idProductfeatures` where `ecom_productfeatures_shops`.`idShop` = '1' and `productfeatures`.`PRD_ACTIEF` = '1' and `productfeatures`.`PRD_VOLGORDE` = '0' and `ecom_productcategorie`.`idPrdcategorie` = '177'
|
|
11.93ms
|
select `productfeatures`.`PRD_REF`, `productfeatures`.`PRD_ARTIKELCODE`, `productfeatures`.`PRD_EXTRANAAM1`, `productfeatures`.`PRD_SLUG1`, `productfeatures`.`idProductfeatures`, `productfeatures`.`idProduct`, `productfeatures`.`PRD_PRIJS`, `productfeatures`.`idMerken`, `idPrdbtwpercentage`, `PRD_PROMO`, `PRD_NIEUW` from `productfeatures` inner join `product` on `productfeatures`.`idProduct` = `product`.`idProduct` inner join `ecom_productcategorie` on `productfeatures`.`idProductfeatures` = `ecom_productcategorie`.`idProductfeatures` inner join `ecom_productfeatures_shops` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_shops`.`idProductfeatures` where `ecom_productfeatures_shops`.`idShop` = '1' and `productfeatures`.`PRD_ACTIEF` = '1' and `productfeatures`.`PRD_VOLGORDE` = '0' and `ecom_productcategorie`.`idPrdcategorie` = '177' order by `PROD_VOLGORDE` asc limit 24 offset 0
|
|
2.67ms
|
select * from `product` where `product`.`idProduct` in ('3622', '4238', '4138', '3665', '4059', '3993', '1732', '3568', '3621', '3638', '3664', '1500', '3992', '1723', '4227', '3611', '3637', '3648', '4145', '3991', '1711', '4224', '3609', '3633')
|
|
0.82ms
|
select * from `ecom_merken` where `ecom_merken`.`id` in ('15', '9', '29', '32')
|
|
2.16ms
|
select * from `prdmedia` where `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' and `prdmedia`.`idProduct` in ('1500', '1711', '1723', '1732', '3568', '3609', '3611', '3621', '3622', '3633', '3637', '3638', '3648', '3664', '3665', '3991', '3992', '3993', '4059', '4138', '4145', '4224', '4227', '4238')
|
|
11.52ms
|
SELECT `ecom_merken`.`id` AS `id`, `ecom_merken`.`naam1` AS `merknaam`, COUNT(`product`.`idMerken`) AS aantal FROM (
SELECT `productfeatures`.`idProduct` FROM `productfeatures` INNER JOIN `ecom_productcategorie` ON `productfeatures`.`idProductfeatures` = `ecom_productcategorie`.`idProductfeatures`
WHERE `ecom_productcategorie`.`idPrdcategorie` = '177'GROUP BY `productfeatures`.`idProduct`) AS z INNER JOIN `product` ON `z`.`idProduct` = `product`.`idProduct` INNER JOIN `ecom_merken` ON `product`.`idMerken` = `ecom_merken`.`id`GROUP BY `product`.`idMerken` ORDER BY `merknaam` ASC
|
|
0.78ms
|
select * from `ecom_settings` where `id` = '22' limit 1
|
|
0.36ms
|
select * from `ecom_settings` where `id` = '23' limit 1
|
|
0.24ms
|
select * from `ecom_winkels` limit 1
|
|
0.26ms
|
select * from `ecom_settings` where `id` = '41' limit 1
|
|
0.18ms
|
select `waarde`, `key` from `ecom_settings` where `key` in ('mollie_redirect_url', 'mollie_webhook_url')
|
|
0.97ms
|
select * from `ecom_labels`
|
|
1.39ms
|
select * from `ecom_client_labels`
|
|
0.44ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.71ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.79ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '89393' order by `PRIS_AANTAL` asc
|
|
1.72ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' limit 1
|
|
2.86ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '89393'
|
|
0.56ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '89393'
|
|
0.24ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.47ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.51ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '103244' order by `PRIS_AANTAL` asc
|
|
0.28ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' limit 1
|
|
0.34ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '103244'
|
|
0.22ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '103244'
|
|
0.18ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.71ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.44ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '101159' order by `PRIS_AANTAL` asc
|
|
0.19ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' limit 1
|
|
0.6ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '101159'
|
|
0.19ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '101159'
|
|
3.3ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.54ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.47ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '89925' order by `PRIS_AANTAL` asc
|
|
0.35ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' limit 1
|
|
0.73ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '89925'
|
|
0.56ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '89925'
|
|
0.22ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
1.65ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.66ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '100088' order by `PRIS_AANTAL` asc
|
|
0.38ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' limit 1
|
|
0.6ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '100088'
|
|
0.41ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '100088'
|
|
0.51ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.77ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.75ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '98876' order by `PRIS_AANTAL` asc
|
|
0.49ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' limit 1
|
|
1.29ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '98876'
|
|
0.56ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '98876'
|
|
0.41ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.58ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.44ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '44721' order by `PRIS_AANTAL` asc
|
|
0.24ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' limit 1
|
|
0.5ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '44721'
|
|
0.24ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '44721'
|
|
0.24ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.44ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.36ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '88670' order by `PRIS_AANTAL` asc
|
|
0.23ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' limit 1
|
|
0.43ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '88670'
|
|
0.19ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '88670'
|
|
0.21ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
1.14ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
1.93ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '89385' order by `PRIS_AANTAL` asc
|
|
5.86ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' limit 1
|
|
2.17ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '89385'
|
|
0.56ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '89385'
|
|
0.39ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.63ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.49ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '89596' order by `PRIS_AANTAL` asc
|
|
0.2ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' limit 1
|
|
0.39ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '89596'
|
|
0.17ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '89596'
|
|
0.15ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.7ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
1.79ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '89895' order by `PRIS_AANTAL` asc
|
|
0.43ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' limit 1
|
|
0.58ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '89895'
|
|
0.25ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '89895'
|
|
0.28ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
1.56ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
1.74ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '41027' order by `PRIS_AANTAL` asc
|
|
0.57ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' limit 1
|
|
0.59ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '41027'
|
|
0.39ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '41027'
|
|
0.48ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.57ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.51ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '98862' order by `PRIS_AANTAL` asc
|
|
0.28ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' limit 1
|
|
0.64ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '98862'
|
|
0.29ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '98862'
|
|
0.2ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.71ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.82ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '44500' order by `PRIS_AANTAL` asc
|
|
0.35ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' limit 1
|
|
0.83ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '44500'
|
|
0.31ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '44500'
|
|
0.41ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.65ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
1.96ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '103186' order by `PRIS_AANTAL` asc
|
|
0.61ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' limit 1
|
|
0.64ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '103186'
|
|
0.35ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '103186'
|
|
1.03ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.71ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.72ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '89221' order by `PRIS_AANTAL` asc
|
|
0.27ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' limit 1
|
|
0.63ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '89221'
|
|
0.29ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '89221'
|
|
1.45ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.41ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.42ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '89576' order by `PRIS_AANTAL` asc
|
|
0.19ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' limit 1
|
|
0.68ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '89576'
|
|
0.22ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '89576'
|
|
0.21ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.55ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.47ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '89703' order by `PRIS_AANTAL` asc
|
|
0.16ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' limit 1
|
|
0.56ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '89703'
|
|
0.55ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '89703'
|
|
1.6ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.5ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
1.81ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '101339' order by `PRIS_AANTAL` asc
|
|
0.3ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' limit 1
|
|
0.54ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '101339'
|
|
0.28ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '101339'
|
|
0.31ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.26ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.3ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '98834' order by `PRIS_AANTAL` asc
|
|
0.14ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' limit 1
|
|
0.31ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '98834'
|
|
0.23ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '98834'
|
|
0.16ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.47ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.43ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '44195' order by `PRIS_AANTAL` asc
|
|
0.27ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' limit 1
|
|
0.49ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '44195'
|
|
0.37ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '44195'
|
|
0.22ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.28ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.4ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '103169' order by `PRIS_AANTAL` asc
|
|
0.23ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' limit 1
|
|
0.38ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '103169'
|
|
0.2ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '103169'
|
|
0.16ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.48ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.59ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '89179' order by `PRIS_AANTAL` asc
|
|
0.29ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' limit 1
|
|
0.42ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '89179'
|
|
0.26ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '89179'
|
|
0.22ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.46ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.43ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '89546' order by `PRIS_AANTAL` asc
|
|
2.47ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '4' limit 1
|
|
3.28ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '89546'
|
|
5.04ms
|
select `ecom_kosten`.*, `ecom_productfeatures_kosten`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_kosten`.`ecom_kosten_id` as `pivot_ecom_kosten_id`, `ecom_productfeatures_kosten`.`prijs` as `pivot_prijs`, `ecom_productfeatures_kosten`.`id` as `pivot_id`, `ecom_productfeatures_kosten`.`idPrdbtwpercentage` as `pivot_idPrdbtwpercentage` from `ecom_kosten` inner join `ecom_productfeatures_kosten` on `ecom_kosten`.`id` = `ecom_productfeatures_kosten`.`ecom_kosten_id` where `ecom_productfeatures_kosten`.`idProductfeatures` = '89546'
|
|
29.74ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie`, `idBron` from `prdcategorie` inner join `ecom_shops_categorie` on `prdcategorie`.`idPrdcategorie` = `ecom_shops_categorie`.`idPrdcategorie` where `prdcategorie`.`CATE_ACTIEF` = '1' and `ecom_shops_categorie`.`idShops` = '1' and `prdcategorie`.`idBron` = '0' group by `prdcategorie`.`idPrdcategorie` order by `prdcategorie`.`CATE_NAAM1` desc
|
|
0.34ms
|
select `pagenamelang1`, `slug1`, `id` from `pages` where `idMenu` = '1' and `pagevisibility` = '1' order by `pageorder` asc
|
|
0.52ms
|
select `pagenamelang1`, `slug1`, `id` from `pages` where `idMenu` = '1' and `pagevisibility` = '1' order by `pageorder` asc
|
|
7.48ms
|
select `CATE_NAAM1` as `name`, `CATE_SLUG1` as `cslug`, `prdcategorie`.`idPrdcategorie`, `idBron` from `prdcategorie` inner join `ecom_shops_categorie` on `prdcategorie`.`idPrdcategorie` = `ecom_shops_categorie`.`idPrdcategorie` where `prdcategorie`.`CATE_ACTIEF` = '1' and `ecom_shops_categorie`.`idShops` = '1' and `prdcategorie`.`idBron` = '2' group by `prdcategorie`.`idPrdcategorie` order by `prdcategorie`.`CATE_NAAM1` asc
|
|
3.19ms
|
select * from `prdmedia` where `prdmedia`.`idPrdcategorie` = '2' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' limit 1
|
|
6.03ms
|
select `CATE_NAAM1` as `name`, `CATE_SLUG1` as `cslug`, `prdcategorie`.`idPrdcategorie`, `idBron` from `prdcategorie` inner join `ecom_shops_categorie` on `prdcategorie`.`idPrdcategorie` = `ecom_shops_categorie`.`idPrdcategorie` where `prdcategorie`.`CATE_ACTIEF` = '1' and `ecom_shops_categorie`.`idShops` = '1' and `prdcategorie`.`idBron` = '1' group by `prdcategorie`.`idPrdcategorie` order by `prdcategorie`.`CATE_NAAM1` asc
|
|
10.74ms
|
select * from `prdmedia` where `prdmedia`.`idPrdcategorie` = '1' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' limit 1
|
|
0.46ms
|
select `CATE_NAAM1` as `name`, `CATE_SLUG1` as `cslug`, `prdcategorie`.`idPrdcategorie`, `idBron` from `prdcategorie` inner join `ecom_shops_categorie` on `prdcategorie`.`idPrdcategorie` = `ecom_shops_categorie`.`idPrdcategorie` where `prdcategorie`.`CATE_ACTIEF` = '1' and `ecom_shops_categorie`.`idShops` = '1' and `prdcategorie`.`idBron` = '172' group by `prdcategorie`.`idPrdcategorie` order by `prdcategorie`.`CATE_NAAM1` asc
|
|
0.29ms
|
select * from `prdmedia` where `prdmedia`.`idPrdcategorie` = '172' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' limit 1
|
|
0.32ms
|
select * from `prdmedia` where `prdmedia`.`idPages` = '42' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' limit 1
|
|
0.26ms
|
select * from `prdmedia` where `prdmedia`.`idPages` = '43' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' limit 1
|
|
0.23ms
|
select * from `prdmedia` where `prdmedia`.`idPages` = '29' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' limit 1
|
|
10.77ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie`, `idBron` from `prdcategorie` inner join `ecom_shops_categorie` on `prdcategorie`.`idPrdcategorie` = `ecom_shops_categorie`.`idPrdcategorie` where `prdcategorie`.`CATE_ACTIEF` = '1' and `ecom_shops_categorie`.`idShops` = '1' and `prdcategorie`.`idBron` = '0' group by `prdcategorie`.`idPrdcategorie` order by `prdcategorie`.`CATE_NAAM1` desc
|
|
3.59ms
|
select `pagenamelang1`, `slug1`, `id` from `pages` where `idMenu` = '1' and `pagevisibility` = '1' order by `pageorder` asc
|
|
0.35ms
|
select * from `ecom_settings` where `id` = '52' limit 1
|
|
1.41ms
|
select `key`, `waarde` from `ecom_settings` where `key` in ('mollie_creditcard', 'mollie_mistercash', 'mollie_belfius', 'mollie_banktransfer', 'mollie_ideal', 'mollie_kbc', 'mollie_paypal', 'mollie_sofort')
|
|
0.29ms
|
select * from `ecom_winkels` limit 1
|
|
0.62ms
|
select `pagenamelang1`, `slug1`, `id`, `issubpageof` from `pages` where `idMenu` = '2' and `pagevisibility` = '1' and `issubpageof` = '0' order by `pageorder` asc
|
|
4.31ms
|
select * from `pages` where `pages`.`issubpageof` in ('44') order by `pageorder` asc
|
|
1.56ms
|
select `pagenamelang1`, `slug1`, `id`, `issubpageof` from `pages` where `idMenu` = '3' and `pagevisibility` = '1' and `issubpageof` = '0' order by `pageorder` asc
|
|
0.43ms
|
select * from `pages` where `pages`.`issubpageof` in ('53', '59') order by `pageorder` asc
|
|
0.22ms
|
select `pagenamelang1`, `slug1`, `id`, `issubpageof` from `pages` where `idMenu` = '4' and `pagevisibility` = '1' and `issubpageof` = '0' order by `pageorder` asc
|
|
0.84ms
|
select * from `pages` where `pages`.`issubpageof` in ('72') order by `pageorder` asc
|
