| Time |
Query |
|
0.38ms
|
select * from `ecom_settings` where `id` = '22' limit 1
|
|
0.37ms
|
select * from `ecom_settings` where `id` = '23' limit 1
|
|
0.4ms
|
select * from `ecom_settings` where `key` = 'nieuwe_btw_regels' limit 1
|
|
0.27ms
|
select `waarde`, `key` from `ecom_settings` where `key` in ('mollie_redirect_url', 'mollie_webhook_url')
|
|
2.42ms
|
select * from `ecom_labels`
|
|
1.78ms
|
select * from `ecom_client_labels`
|
|
0.5ms
|
select * from `prdcategorie` where `CATE_SLUG1` = 'shampoo' limit 1
|
|
0.64ms
|
select * from `prdcategorie` where exists ( select productfeatures.idProductfeatures from `ecom_productcategorie` INNER JOIN productfeatures ON productfeatures.idProductfeatures = ecom_productcategorie.idProductfeatures WHERE `prdcategorie`.`idPrdcategorie` = `ecom_productcategorie`.`idPrdcategorie` and `productfeatures`.PRD_ACTIEF = 1 ) and `idBron` = '1499' order by `CATE_NAAM1` asc
|
|
1.62ms
|
select * from `prdcategorie` where exists ( select productfeatures.idProductfeatures from `ecom_productcategorie` INNER JOIN productfeatures ON productfeatures.idProductfeatures = ecom_productcategorie.idProductfeatures WHERE `prdcategorie`.`idPrdcategorie` = `ecom_productcategorie`.`idPrdcategorie` and `productfeatures`.PRD_ACTIEF = 1 ) and `idBron` = '323' order by `CATE_NAAM1` asc
|
|
1.61ms
|
select count(*) as aggregate from `productfeatures` inner join `ecom_productcategorie` on `productfeatures`.`idProductfeatures` = `ecom_productcategorie`.`idProductfeatures` where `ecom_productcategorie`.`idPrdcategorie` = '1499' and `PRD_actief` = '1'
|
|
5.24ms
|
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`, `PRD_EOL`, `PRD_STANDAARDBESTELHOEV`, `productfeatures`.`PRD_GEENKORTING`, `productfeatures`.*, `ecom_productcategorie`.`idPrdcategorie` as `pivot_idPrdcategorie`, `ecom_productcategorie`.`idProductfeatures` as `pivot_idProductfeatures` from `productfeatures` inner join `ecom_productcategorie` on `productfeatures`.`idProductfeatures` = `ecom_productcategorie`.`idProductfeatures` where `ecom_productcategorie`.`idPrdcategorie` = '1499' and `PRD_actief` = '1' order by `PRD_EXTRANAAM1` asc limit 24 offset 0
|
|
1.27ms
|
select `idMerken` from `productfeatures` inner join `ecom_productcategorie` on `productfeatures`.`idProductfeatures` = `ecom_productcategorie`.`idProductfeatures` where `ecom_productcategorie`.`idPrdcategorie` = '1499' and `PRD_ACTIEF` = '1' group by `idMerken`
|
|
0.36ms
|
select `id`, `naam1` from `ecom_merken` where `id` in ('0', '22', '37') order by `naam1` asc
|
|
1.03ms
|
select count(*) as aggregate from `productfeatures` inner join `ecom_productcategorie` on `productfeatures`.`idProductfeatures` = `ecom_productcategorie`.`idProductfeatures` where `ecom_productcategorie`.`idPrdcategorie` = '1499' and `PRD_PROMO` = '1' and `PRD_actief` = '1'
|
|
1.36ms
|
select count(*) as aggregate from `productfeatures` inner join `ecom_productcategorie` on `productfeatures`.`idProductfeatures` = `ecom_productcategorie`.`idProductfeatures` where `ecom_productcategorie`.`idPrdcategorie` = '1499' and `PRD_NIEUW` = '1' and `PRD_actief` = '1'
|
|
0.35ms
|
select * from `prdcategorie` where `prdcategorie`.`idPrdcategorie` = '323' limit 1
|
|
0.28ms
|
select * from `prdcategorie` where `prdcategorie`.`idPrdcategorie` in ('51')
|
|
0.32ms
|
select * from `prdcategorie` where `prdcategorie`.`idPrdcategorie` in ('7')
|
|
0.27ms
|
select * from `prdcategorie` where `prdcategorie`.`idPrdcategorie` in ('0')
|
|
1.54ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.49ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '45139' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.19ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.41ms
|
select * from `product` where `product`.`idProduct` = '45139' limit 1
|
|
0.27ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45139' order by `PRIS_AANTAL` asc
|
|
0.24ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '45139'
|
|
0.12ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.13ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45139' order by `PRIS_AANTAL` asc
|
|
0.11ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.12ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' 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` = '45139'
|
|
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` = '45139'
|
|
0.15ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.14ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.12ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45139' order by `PRIS_AANTAL` asc
|
|
0.15ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.16ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45139' order by `PRIS_AANTAL` asc
|
|
0.14ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.15ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
0.21ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.53ms
|
select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '45139'
|
|
0.23ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.41ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '45138' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.16ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.31ms
|
select * from `product` where `product`.`idProduct` = '45138' limit 1
|
|
0.22ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45138' order by `PRIS_AANTAL` asc
|
|
0.15ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '45138'
|
|
0.08ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.08ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45138' order by `PRIS_AANTAL` asc
|
|
0.08ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.12ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
1.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` = '45138'
|
|
0.16ms
|
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` = '45138'
|
|
0.22ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.54ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.1ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45138' order by `PRIS_AANTAL` asc
|
|
0.15ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.18ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45138' order by `PRIS_AANTAL` asc
|
|
0.17ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.12ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
0.78ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
2ms
|
select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '45138'
|
|
1.69ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
1.45ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '43766' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
1.02ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
1.52ms
|
select * from `product` where `product`.`idProduct` = '43766' limit 1
|
|
0.74ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '43766' order by `PRIS_AANTAL` asc
|
|
1.82ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '43766'
|
|
0.87ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
1.06ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '43766' order by `PRIS_AANTAL` asc
|
|
1.4ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
1.8ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
1.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` = '43766'
|
|
0.88ms
|
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` = '43766'
|
|
1.48ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
1.83ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
1.04ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '43766' order by `PRIS_AANTAL` asc
|
|
1.02ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
1.68ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '43766' order by `PRIS_AANTAL` asc
|
|
1.9ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.89ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
0.26ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.62ms
|
select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '43766'
|
|
0.25ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.45ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '45140' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.18ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.34ms
|
select * from `product` where `product`.`idProduct` = '45140' limit 1
|
|
0.31ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45140' order by `PRIS_AANTAL` asc
|
|
0.22ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '45140'
|
|
0.12ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.14ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45140' order by `PRIS_AANTAL` asc
|
|
0.14ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.1ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
0.33ms
|
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` = '45140'
|
|
0.32ms
|
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` = '45140'
|
|
0.21ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.15ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.15ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45140' order by `PRIS_AANTAL` asc
|
|
0.1ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.14ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45140' order by `PRIS_AANTAL` asc
|
|
0.15ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.16ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
0.15ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.6ms
|
select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '45140'
|
|
0.2ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.37ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '14090' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.36ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.75ms
|
select * from `product` where `product`.`idProduct` = '14090' limit 1
|
|
0.33ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '14090' order by `PRIS_AANTAL` asc
|
|
0.24ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '14090'
|
|
0.13ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.15ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '14090' order by `PRIS_AANTAL` asc
|
|
0.17ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.13ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
0.72ms
|
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` = '14090'
|
|
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` = '14090'
|
|
0.15ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.15ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.27ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '14090' order by `PRIS_AANTAL` asc
|
|
0.12ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.27ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '14090' order by `PRIS_AANTAL` asc
|
|
0.34ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
10.02ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
6.54ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
7.66ms
|
select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '14090'
|
|
0.3ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.53ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '36749' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
2.53ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.48ms
|
select * from `product` where `product`.`idProduct` = '36749' limit 1
|
|
0.35ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '36749' order by `PRIS_AANTAL` asc
|
|
0.2ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '36749'
|
|
0.12ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.14ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '36749' order by `PRIS_AANTAL` asc
|
|
0.13ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.11ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
0.32ms
|
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` = '36749'
|
|
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` = '36749'
|
|
0.19ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.14ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.13ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '36749' order by `PRIS_AANTAL` asc
|
|
0.11ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.13ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '36749' order by `PRIS_AANTAL` asc
|
|
0.41ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.13ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
0.17ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.54ms
|
select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '36749'
|
|
0.17ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.37ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '35332' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.21ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
1.39ms
|
select * from `product` where `product`.`idProduct` = '35332' limit 1
|
|
0.49ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '35332' order by `PRIS_AANTAL` asc
|
|
1.18ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '35332'
|
|
1.16ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
1.18ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '35332' order by `PRIS_AANTAL` asc
|
|
1.18ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.11ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
0.3ms
|
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` = '35332'
|
|
0.14ms
|
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` = '35332'
|
|
0.12ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.17ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.14ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '35332' order by `PRIS_AANTAL` asc
|
|
0.09ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.11ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '35332' order by `PRIS_AANTAL` asc
|
|
0.1ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.58ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
0.15ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
1.27ms
|
select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '35332'
|
|
0.17ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.43ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '35977' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.15ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.26ms
|
select * from `product` where `product`.`idProduct` = '35977' limit 1
|
|
0.24ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '35977' order by `PRIS_AANTAL` asc
|
|
0.15ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '35977'
|
|
0.11ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.12ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '35977' order by `PRIS_AANTAL` asc
|
|
0.09ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.1ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
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` = '35977'
|
|
0.13ms
|
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` = '35977'
|
|
0.11ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.12ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
2.21ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '35977' order by `PRIS_AANTAL` asc
|
|
0.42ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.11ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '35977' order by `PRIS_AANTAL` asc
|
|
0.12ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.07ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
0.09ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.39ms
|
select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '35977'
|
|
0.16ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.29ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '35330' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.12ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.27ms
|
select * from `product` where `product`.`idProduct` = '35330' limit 1
|
|
0.19ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '35330' order by `PRIS_AANTAL` asc
|
|
0.13ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '35330'
|
|
0.08ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.09ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '35330' order by `PRIS_AANTAL` asc
|
|
0.09ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.07ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
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` = '35330'
|
|
0.12ms
|
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` = '35330'
|
|
0.1ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.08ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.1ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '35330' order by `PRIS_AANTAL` asc
|
|
0.1ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.08ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '35330' order by `PRIS_AANTAL` asc
|
|
0.08ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.09ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
0.12ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.4ms
|
select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '35330'
|
|
0.13ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.32ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '36443' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.12ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.69ms
|
select * from `product` where `product`.`idProduct` = '36443' limit 1
|
|
0.25ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '36443' order by `PRIS_AANTAL` asc
|
|
0.15ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '36443'
|
|
0.11ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.09ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '36443' order by `PRIS_AANTAL` asc
|
|
0.3ms
|
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` = '36443'
|
|
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` = '36443'
|
|
0.13ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.46ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.11ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '36443' order by `PRIS_AANTAL` asc
|
|
0.1ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.11ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '36443' order by `PRIS_AANTAL` asc
|
|
0.09ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.43ms
|
select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '36443'
|
|
0.13ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.17ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '47862' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.11ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.27ms
|
select * from `product` where `product`.`idProduct` = '47862' limit 1
|
|
0.11ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '47862' order by `PRIS_AANTAL` asc
|
|
0.1ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '47862'
|
|
0.09ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.08ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '47862' order by `PRIS_AANTAL` asc
|
|
0.09ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.08ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
0.13ms
|
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` = '47862'
|
|
0.11ms
|
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` = '47862'
|
|
0.11ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.09ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.09ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '47862' order by `PRIS_AANTAL` asc
|
|
0.07ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.08ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '47862' order by `PRIS_AANTAL` asc
|
|
0.08ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.08ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
0.1ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.23ms
|
select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '47862'
|
|
0.13ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.16ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '47869' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.12ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.27ms
|
select * from `product` where `product`.`idProduct` = '47869' limit 1
|
|
0.11ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '47869' order by `PRIS_AANTAL` asc
|
|
0.19ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '47869'
|
|
0.18ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.11ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '47869' order by `PRIS_AANTAL` asc
|
|
0.11ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.07ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
0.12ms
|
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` = '47869'
|
|
0.1ms
|
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` = '47869'
|
|
0.09ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.13ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.09ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '47869' order by `PRIS_AANTAL` asc
|
|
5.28ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.22ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '47869' order by `PRIS_AANTAL` asc
|
|
0.83ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.11ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
0.11ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.28ms
|
select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '47869'
|
|
0.13ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.37ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '39701' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.11ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.23ms
|
select * from `product` where `product`.`idProduct` = '39701' limit 1
|
|
0.2ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '39701' order by `PRIS_AANTAL` asc
|
|
0.14ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '39701'
|
|
0.08ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.1ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '39701' order by `PRIS_AANTAL` asc
|
|
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` = '39701'
|
|
0.13ms
|
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` = '39701'
|
|
0.15ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
1.1ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.13ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '39701' order by `PRIS_AANTAL` asc
|
|
0.08ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.08ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '39701' order by `PRIS_AANTAL` asc
|
|
0.13ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.46ms
|
select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '39701'
|
|
0.13ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.27ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '36569' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.12ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.21ms
|
select * from `product` where `product`.`idProduct` = '36569' limit 1
|
|
0.17ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '36569' order by `PRIS_AANTAL` asc
|
|
0.1ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '36569'
|
|
0.09ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.08ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '36569' order by `PRIS_AANTAL` asc
|
|
0.08ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.07ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
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` = '36569'
|
|
0.1ms
|
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` = '36569'
|
|
0.09ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.07ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.08ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '36569' order by `PRIS_AANTAL` asc
|
|
0.07ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.08ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '36569' order by `PRIS_AANTAL` asc
|
|
0.08ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.07ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
0.08ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.35ms
|
select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '36569'
|
|
0.11ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.26ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '45410' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.11ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.23ms
|
select * from `product` where `product`.`idProduct` = '45410' limit 1
|
|
0.2ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45410' order by `PRIS_AANTAL` asc
|
|
0.11ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '45410'
|
|
0.08ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.08ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45410' order by `PRIS_AANTAL` asc
|
|
0.1ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.07ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
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` = '45410'
|
|
0.11ms
|
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` = '45410'
|
|
0.1ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.09ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.08ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45410' order by `PRIS_AANTAL` asc
|
|
0.07ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.09ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45410' order by `PRIS_AANTAL` asc
|
|
0.08ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.07ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
0.08ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.37ms
|
select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '45410'
|
|
0.1ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.26ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '46580' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.13ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.21ms
|
select * from `product` where `product`.`idProduct` = '46580' limit 1
|
|
0.18ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '46580' order by `PRIS_AANTAL` asc
|
|
0.12ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '46580'
|
|
0.08ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.09ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '46580' order by `PRIS_AANTAL` asc
|
|
0.08ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.07ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
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` = '46580'
|
|
0.1ms
|
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` = '46580'
|
|
0.09ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.08ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.09ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '46580' order by `PRIS_AANTAL` asc
|
|
0.07ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.08ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '46580' order by `PRIS_AANTAL` asc
|
|
0.07ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.06ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
0.1ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.34ms
|
select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '46580'
|
|
0.12ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.27ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '40663' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.11ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.21ms
|
select * from `product` where `product`.`idProduct` = '40663' limit 1
|
|
0.19ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '40663' order by `PRIS_AANTAL` asc
|
|
0.14ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '40663'
|
|
0.08ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.1ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '40663' order by `PRIS_AANTAL` asc
|
|
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` = '40663'
|
|
0.14ms
|
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` = '40663'
|
|
0.11ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.12ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.11ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '40663' order by `PRIS_AANTAL` asc
|
|
0.09ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.12ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '40663' order by `PRIS_AANTAL` asc
|
|
0.11ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.38ms
|
select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '40663'
|
|
0.12ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.29ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '45124' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.11ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.22ms
|
select * from `product` where `product`.`idProduct` = '45124' limit 1
|
|
0.21ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45124' order by `PRIS_AANTAL` asc
|
|
0.12ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '45124'
|
|
0.08ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.09ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45124' order by `PRIS_AANTAL` asc
|
|
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` = '45124'
|
|
0.1ms
|
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` = '45124'
|
|
0.09ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.07ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.09ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45124' order by `PRIS_AANTAL` asc
|
|
0.07ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.08ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45124' order by `PRIS_AANTAL` asc
|
|
0.08ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.38ms
|
select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '45124'
|
|
0.12ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.27ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '45235' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.1ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.24ms
|
select * from `product` where `product`.`idProduct` = '45235' limit 1
|
|
0.18ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45235' order by `PRIS_AANTAL` asc
|
|
0.11ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '45235'
|
|
0.07ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.08ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45235' order by `PRIS_AANTAL` asc
|
|
0.08ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.07ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
0.21ms
|
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` = '45235'
|
|
0.1ms
|
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` = '45235'
|
|
0.09ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.1ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.09ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45235' order by `PRIS_AANTAL` asc
|
|
0.07ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.08ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45235' order by `PRIS_AANTAL` asc
|
|
0.1ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.07ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
0.08ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.37ms
|
select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '45235'
|
|
0.1ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.28ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '45234' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.1ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.54ms
|
select * from `product` where `product`.`idProduct` = '45234' limit 1
|
|
0.2ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45234' order by `PRIS_AANTAL` asc
|
|
0.15ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '45234'
|
|
0.08ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.08ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45234' order by `PRIS_AANTAL` asc
|
|
0.08ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.07ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
0.21ms
|
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` = '45234'
|
|
0.1ms
|
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` = '45234'
|
|
0.08ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.15ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.09ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45234' order by `PRIS_AANTAL` asc
|
|
0.07ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.08ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45234' order by `PRIS_AANTAL` asc
|
|
0.08ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.09ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
0.22ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.46ms
|
select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '45234'
|
|
0.19ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
1.61ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '45236' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.13ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.27ms
|
select * from `product` where `product`.`idProduct` = '45236' limit 1
|
|
0.27ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45236' order by `PRIS_AANTAL` asc
|
|
0.15ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '45236'
|
|
0.12ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.09ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45236' order by `PRIS_AANTAL` asc
|
|
0.08ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.07ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
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` = '45236'
|
|
0.11ms
|
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` = '45236'
|
|
0.1ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.08ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.1ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45236' order by `PRIS_AANTAL` asc
|
|
0.07ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.08ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '45236' order by `PRIS_AANTAL` asc
|
|
0.09ms
|
select * from `ecom_settings` where `key` = 'korting'
|
|
0.07ms
|
select `waarde` from `ecom_settings` where `key` = 'contact_shop_korting' limit 1
|
|
0.1ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.42ms
|
select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '45236'
|
|
0.13ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.29ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '34676' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.62ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.22ms
|
select * from `product` where `product`.`idProduct` = '34676' limit 1
|
|
0.2ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '34676' order by `PRIS_AANTAL` asc
|
|
0.18ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '34676'
|
|
0.13ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.14ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '34676' order by `PRIS_AANTAL` asc
|
|
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` = '34676'
|
|
0.27ms
|
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` = '34676'
|
|
0.19ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.12ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.13ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '34676' order by `PRIS_AANTAL` asc
|
|
0.08ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.17ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '34676' order by `PRIS_AANTAL` asc
|
|
0.17ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.4ms
|
select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '34676'
|
|
0.18ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.33ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '34673' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.15ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.27ms
|
select * from `product` where `product`.`idProduct` = '34673' limit 1
|
|
0.22ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '34673' order by `PRIS_AANTAL` asc
|
|
0.19ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '34673'
|
|
0.08ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.12ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '34673' order by `PRIS_AANTAL` asc
|
|
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` = '34673'
|
|
0.15ms
|
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` = '34673'
|
|
0.17ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.16ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.13ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '34673' order by `PRIS_AANTAL` asc
|
|
0.12ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.14ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '34673' order by `PRIS_AANTAL` asc
|
|
0.13ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.43ms
|
select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '34673'
|
|
0.12ms
|
select * from `ecom_settings` where `key` = 'korting' limit 1
|
|
0.31ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '47814' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.11ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.27ms
|
select * from `product` where `product`.`idProduct` = '47814' limit 1
|
|
0.27ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '47814' order by `PRIS_AANTAL` asc
|
|
0.12ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '47814'
|
|
0.08ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.08ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '47814' order by `PRIS_AANTAL` asc
|
|
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` = '47814'
|
|
0.1ms
|
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` = '47814'
|
|
0.09ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.07ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.09ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '47814' order by `PRIS_AANTAL` asc
|
|
0.07ms
|
select `waarde` from `ecom_settings` where `key` = 'gastzietstaffels' limit 1
|
|
0.08ms
|
select * from `prdprijsstaffel` where `prdprijsstaffel`.`idProductfeatures` = '47814' order by `PRIS_AANTAL` asc
|
|
0.08ms
|
select * from `prdbtwpercentage` where `idPrdbtwpercentage` = '21' limit 1
|
|
0.35ms
|
select `productfeatures`.*, `ecom_productfeatures_rel`.`idProductfeatures` as `pivot_idProductfeatures`, `ecom_productfeatures_rel`.`idProductfeatures_rel` as `pivot_idProductfeatures_rel`, `ecom_productfeatures_rel`.`alternatief` as `pivot_alternatief` from `productfeatures` inner join `ecom_productfeatures_rel` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_rel`.`idProductfeatures_rel` where `ecom_productfeatures_rel`.`idProductfeatures` = '47814'
|
|
0.16ms
|
select * from `ecom_winkels` limit 1
|
|
0.14ms
|
select `pagenamelang1`, `slug1`, `id` from `pages` where `status` = '15' and `pagevisibility` = '1' order by `pageorder` asc limit 1
|
|
0.14ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where exists ( select productfeatures.idProductfeatures from `ecom_productcategorie` INNER JOIN productfeatures ON productfeatures.idProductfeatures = ecom_productcategorie.idProductfeatures WHERE `prdcategorie`.`idPrdcategorie` = `ecom_productcategorie`.`idPrdcategorie` and `productfeatures`.PRD_ACTIEF = 1 ) and `prdcategorie`.`CATE_ACTIEF` = '1' and `idBron` = '0'
|
|
0.12ms
|
select `id`, `naam1` from `ecom_merken` where exists ( select productfeatures.idProductfeatures from `productfeatures` WHERE `ecom_merken`.`id` = `productfeatures`.`idMerken` and `productfeatures`.PRD_ACTIEF = 1 ) order by `naam1` asc
|
|
0.08ms
|
select `pagenamelang1`, `slug1`, `id` from `pages` where `idMenu` = '3' and `pagevisibility` = '1' order by `pageorder` asc limit 1
|
|
0.13ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '1' and exists ( select productfeatures.idProductfeatures from `ecom_productcategorie` INNER JOIN productfeatures ON productfeatures.idProductfeatures = ecom_productcategorie.idProductfeatures WHERE `prdcategorie`.`idPrdcategorie` = `ecom_productcategorie`.`idPrdcategorie` and `productfeatures`.PRD_ACTIEF = 1 ) and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc
|
|
0.14ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('14') order by `CATE_VOLGORDE` asc
|
|
0.13ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('212') order by `CATE_VOLGORDE` asc
|
|
0.11ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('949', '950') order by `CATE_VOLGORDE` asc
|
|
0.13ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '14' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc
|
|
0.12ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('212') order by `CATE_VOLGORDE` asc
|
|
0.11ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('949', '950') order by `CATE_VOLGORDE` asc
|
|
0.15ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '2' and exists ( select productfeatures.idProductfeatures from `ecom_productcategorie` INNER JOIN productfeatures ON productfeatures.idProductfeatures = ecom_productcategorie.idProductfeatures WHERE `prdcategorie`.`idPrdcategorie` = `ecom_productcategorie`.`idPrdcategorie` and `productfeatures`.PRD_ACTIEF = 1 ) and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc
|
|
0.96ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('15', '16', '17', '18', '19', '20', '21', '22', '23', '24', '25', '26', '27', '28', '29', '30', '31') order by `CATE_VOLGORDE` asc
|
|
6.49ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('102', '123', '124', '130', '131', '132', '133', '134', '142', '148', '149', '150', '151', '152', '157', '158', '160', '162', '163', '164', '165', '169', '174', '182', '183', '184', '185', '186', '188', '191', '192', '194', '208', '209', '213', '219', '220', '232', '233', '235', '236', '237', '238', '239', '250', '251', '254', '255', '257', '258', '267', '268', '269', '272', '273', '278', '279', '287', '289', '290', '292', '301', '302', '303', '307', '314', '316', '317', '320', '321') order by `CATE_VOLGORDE` asc
|
|
0.77ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('367', '451', '452', '453', '454', '455', '456', '488', '489', '490', '491', '492', '493', '494', '496', '497', '498', '499', '500', '501', '502', '503', '504', '505', '506', '507', '508', '509', '510', '511', '512', '513', '514', '515', '516', '517', '518', '519', '520', '521', '522', '523', '524', '525', '526', '527', '530', '531', '532', '533', '535', '536', '537', '538', '539', '540', '541', '542', '543', '544', '545', '546', '547', '548', '549', '550', '551', '552', '553', '554', '555', '556', '557', '558', '559', '560', '561', '563', '564', '565', '566', '567', '568', '614', '615', '616', '617', '618', '619', '620', '621', '622', '641', '642', '643', '644', '645', '646', '647', '648', '649', '650', '651', '652', '653', '654', '655', '656', '657', '658', '659', '660', '661', '662', '674', '675', '676', '677', '678', '679', '680', '681', '682', '683', '684', '685', '686', '687', '688', '689', '690', '694', '695', '697', '698', '699', '700', '701', '702', '710', '711', '712', '713', '714', '715', '716', '717', '718', '719', '720', '721', '722', '723', '724', '725', '726', '727', '728', '729', '730', '731', '732', '733', '734', '735', '736', '737', '738', '739', '740', '741', '742', '743', '748', '749', '750', '751', '752', '774', '775', '776', '777', '778', '779', '802', '803', '804', '805', '806', '807', '808', '809', '810', '811', '812', '813', '814', '815', '816', '817', '818', '819', '820', '821', '822', '825', '826', '827', '828', '829', '830', '831', '832', '839', '840', '841', '842', '843', '844', '845', '846', '847', '848', '849', '850', '851', '852', '853', '854', '855', '856', '857', '858', '859', '860', '861', '862', '863', '864', '865', '867', '868', '869', '870', '871', '872', '873', '874', '875', '876', '933', '934', '935', '936', '937', '938', '939', '940', '941', '942', '951', '952', '953', '954', '955', '956', '957', '958', '959', '988', '989', '990', '991', '993', '994', '995', '996', '997', '998', '999', '1000', '1001', '1002', '1003', '1004', '1005', '1006', '1007', '1008', '1009', '1010', '1011', '1012', '1013', '1014', '1015', '1016', '1017', '1018', '1019', '1020', '1021', '1022', '1023', '1024', '1025', '1026', '1027', '1028', '1029', '1067', '1068', '1069', '1070', '1071', '1072', '1073', '1074', '1075', '1076', '1077', '1078', '1081', '1082', '1083', '1084', '1085', '1086', '1087', '1088', '1089', '1090', '1091', '1092', '1093', '1094', '1095', '1096', '1097', '1098', '1099', '1100', '1101', '1102', '1103', '1104', '1105', '1106', '1107', '1108', '1109', '1110', '1111', '1112', '1113', '1146', '1147', '1148', '1149', '1150', '1151', '1152', '1153', '1154', '1155', '1156', '1159', '1160', '1161', '1162', '1163', '1164', '1165', '1166', '1167', '1168', '1169', '1170', '1171', '1172', '1173', '1174', '1175', '1180', '1181', '1182', '1183', '1184', '1185', '1186', '1187', '1188', '1189', '1190', '1191', '1192', '1193', '1244', '1245', '1246', '1247', '1248', '1249', '1250', '1251', '1252', '1253', '1254', '1255', '1256', '1257', '1258', '1259', '1264', '1265', '1266', '1267', '1297', '1298', '1299', '1300', '1301', '1302', '1303', '1304', '1305', '1306', '1307', '1308', '1329', '1330', '1331', '1332', '1333', '1334', '1335', '1345', '1346', '1347', '1348', '1349', '1350', '1351', '1352', '1353', '1361', '1380', '1381', '1382', '1383', '1384', '1385', '1386', '1387', '1388', '1389', '1390', '1391', '1392', '1393', '1394', '1395', '1396', '1397', '1398', '1399', '1400', '1401', '1402', '1403', '1423', '1424', '1425', '1426', '1427', '1428', '1429', '1430', '1431', '1432', '1433', '1434', '1435', '1436', '1461', '1462', '1463', '1464', '1465', '1466', '1467', '1468', '1470', '1471', '1472', '1473', '1474', '1475', '1476', '1477', '1483', '1484', '1485', '1486', '1487', '1488', '1489', '1490', '1491') order by `CATE_VOLGORDE` asc
|
|
0.22ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '3' and exists ( select productfeatures.idProductfeatures from `ecom_productcategorie` INNER JOIN productfeatures ON productfeatures.idProductfeatures = ecom_productcategorie.idProductfeatures WHERE `prdcategorie`.`idPrdcategorie` = `ecom_productcategorie`.`idPrdcategorie` and `productfeatures`.PRD_ACTIEF = 1 ) and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc
|
|
0.44ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('32', '33', '34', '35', '36', '37', '38', '39') order by `CATE_VOLGORDE` asc
|
|
1.27ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('92', '97', '98', '99', '100', '136', '141', '143', '144', '168', '175', '176', '201', '207', '225', '231', '241', '245', '249', '263', '274', '282', '286', '304', '310', '313', '315') order by `CATE_VOLGORDE` asc
|
|
0.3ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('347', '348', '358', '359', '360', '361', '362', '363', '364', '573', '574', '612', '613', '623', '624', '625', '626', '627', '628', '629', '630', '631', '632', '746', '747', '780', '781', '782', '783', '784', '785', '786', '787', '788', '906', '907', '930', '931', '932', '1044', '1045', '1066', '1115', '1116', '1128', '1129', '1142', '1143', '1144', '1145', '1229', '1230', '1268', '1269', '1270', '1271', '1272', '1273', '1274', '1275', '1276', '1277', '1312', '1313', '1327', '1328', '1404', '1405', '1406', '1407', '1408', '1442', '1443', '1459', '1460', '1469') order by `CATE_VOLGORDE` asc
|
|
0.31ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '4' and exists ( select productfeatures.idProductfeatures from `ecom_productcategorie` INNER JOIN productfeatures ON productfeatures.idProductfeatures = ecom_productcategorie.idProductfeatures WHERE `prdcategorie`.`idPrdcategorie` = `ecom_productcategorie`.`idPrdcategorie` and `productfeatures`.PRD_ACTIEF = 1 ) and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc
|
|
0.43ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('40', '41', '42', '43') order by `CATE_VOLGORDE` asc
|
|
1.3ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('101', '127', '145', '177', '181', '187', '190', '195', '197', '198', '199', '206', '210', '214', '215', '216', '217', '218', '234', '242', '271', '291', '318') order by `CATE_VOLGORDE` asc
|
|
0.42ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('365', '366', '465', '466', '467', '468', '469', '470', '471', '472', '473', '633', '634', '789', '790', '795', '796', '797', '798', '799', '800', '801', '823', '824', '838', '877', '878', '879', '880', '881', '882', '883', '884', '885', '886', '887', '888', '891', '892', '893', '894', '895', '896', '897', '898', '899', '900', '901', '902', '903', '904', '928', '929', '943', '960', '961', '962', '963', '964', '965', '966', '967', '968', '969', '970', '971', '972', '973', '974', '975', '976', '977', '978', '980', '981', '982', '983', '984', '985', '986', '987', '1079', '1080', '1117', '1118', '1119', '1262', '1263', '1354', '1355', '1356', '1357', '1358', '1359', '1360', '1478', '1479') order by `CATE_VOLGORDE` asc
|
|
0.28ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '40' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc
|
|
0.75ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('271', '234', '210', '187', '318', '291', '206', '177') order by `CATE_VOLGORDE` asc
|
|
0.19ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('789', '790', '823', '824', '928', '929', '943', '1079', '1080', '1262', '1263', '1354', '1355', '1356', '1357', '1358', '1359', '1360', '1478', '1479') order by `CATE_VOLGORDE` asc
|
|
0.22ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '41' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc
|
|
0.27ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('190', '242') order by `CATE_VOLGORDE` asc
|
|
0.2ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('838', '1117', '1118', '1119') order by `CATE_VOLGORDE` asc
|
|
0.2ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '42' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc
|
|
1.04ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('195', '181', '198', '197', '199', '214', '215', '216', '217', '127', '218') order by `CATE_VOLGORDE` asc
|
|
0.37ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('465', '466', '467', '468', '469', '470', '471', '472', '473', '795', '796', '797', '798', '799', '800', '801', '877', '878', '879', '880', '881', '882', '883', '884', '885', '886', '887', '888', '891', '892', '893', '894', '895', '896', '897', '898', '899', '900', '901', '902', '903', '904', '960', '961', '962', '963', '964', '965', '966', '967', '968', '969', '970', '971', '972', '973', '974', '975', '976', '977', '978', '980', '981', '982', '983', '984', '985', '986', '987') order by `CATE_VOLGORDE` asc
|
|
0.22ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '43' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc
|
|
0.26ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('145', '101') order by `CATE_VOLGORDE` asc
|
|
0.14ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('365', '366', '633', '634') order by `CATE_VOLGORDE` asc
|
|
0.45ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '6' and exists ( select productfeatures.idProductfeatures from `ecom_productcategorie` INNER JOIN productfeatures ON productfeatures.idProductfeatures = ecom_productcategorie.idProductfeatures WHERE `prdcategorie`.`idPrdcategorie` = `ecom_productcategorie`.`idPrdcategorie` and `productfeatures`.PRD_ACTIEF = 1 ) and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc
|
|
0.17ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('45') order by `CATE_VOLGORDE` asc
|
|
0.24ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('276') order by `CATE_VOLGORDE` asc
|
|
0.15ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('1284', '1285', '1287', '1288', '1289', '1293') order by `CATE_VOLGORDE` asc
|
|
0.19ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '45' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc
|
|
0.23ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('276') order by `CATE_VOLGORDE` asc
|
|
0.15ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('1284', '1285', '1287', '1288', '1289', '1293') order by `CATE_VOLGORDE` asc
|
|
0.25ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '7' and exists ( select productfeatures.idProductfeatures from `ecom_productcategorie` INNER JOIN productfeatures ON productfeatures.idProductfeatures = ecom_productcategorie.idProductfeatures WHERE `prdcategorie`.`idPrdcategorie` = `ecom_productcategorie`.`idPrdcategorie` and `productfeatures`.PRD_ACTIEF = 1 ) and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc
|
|
0.45ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('46', '48', '49', '50', '51', '52') order by `CATE_VOLGORDE` asc
|
|
2.93ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('90', '126', '129', '153', '154', '155', '161', '222', '230', '243', '275', '306', '322', '323', '324') order by `CATE_VOLGORDE` asc
|
|
0.33ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('332', '333', '334', '335', '336', '337', '338', '339', '340', '341', '342', '343', '344', '460', '461', '462', '463', '464', '481', '482', '483', '484', '485', '486', '487', '663', '664', '665', '666', '667', '668', '669', '670', '671', '672', '703', '704', '705', '706', '707', '708', '709', '1033', '1034', '1035', '1036', '1037', '1038', '1039', '1040', '1065', '1120', '1121', '1122', '1123', '1124', '1125', '1278', '1279', '1280', '1281', '1282', '1283', '1417', '1418', '1419', '1420', '1421', '1422', '1492', '1493', '1494', '1495', '1496', '1497', '1498', '1499', '1500', '1501', '1502', '1503', '1504', '1505', '1506', '1507', '1508', '1509', '1510', '1511', '1512', '1513', '1515', '1516', '1517', '1518', '1519', '1520', '1521', '1522', '1523', '1524') order by `CATE_VOLGORDE` asc
|
|
0.24ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '8' and exists ( select productfeatures.idProductfeatures from `ecom_productcategorie` INNER JOIN productfeatures ON productfeatures.idProductfeatures = ecom_productcategorie.idProductfeatures WHERE `prdcategorie`.`idPrdcategorie` = `ecom_productcategorie`.`idPrdcategorie` and `productfeatures`.PRD_ACTIEF = 1 ) and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc
|
|
0.3ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('53', '54') order by `CATE_VOLGORDE` asc
|
|
0.59ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('89', '91', '121', '122', '128', '156', '166', '200', '252', '280', '281', '308', '309') order by `CATE_VOLGORDE` asc
|
|
0.23ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('326', '327', '330', '345', '346', '443', '445', '446', '447', '448', '449', '450', '474', '475', '476', '477', '478', '479', '673', '744', '905', '1157', '1309', '1310', '1311', '1437', '1438', '1439', '1440', '1441') order by `CATE_VOLGORDE` asc
|
|
0.15ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '53' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc
|
|
0.29ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('89', '156', '121') order by `CATE_VOLGORDE` asc
|
|
1.24ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('326', '327', '330', '443', '673') order by `CATE_VOLGORDE` asc
|
|
0.29ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '54' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc
|
|
0.59ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('280', '128', '91', '166', '309', '252', '281', '308', '122', '200') order by `CATE_VOLGORDE` asc
|
|
0.23ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('345', '346', '445', '446', '447', '448', '449', '450', '474', '475', '476', '477', '478', '479', '744', '905', '1157', '1309', '1310', '1311', '1437', '1438', '1439', '1440', '1441') order by `CATE_VOLGORDE` asc
|
|
0.2ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '9' and exists ( select productfeatures.idProductfeatures from `ecom_productcategorie` INNER JOIN productfeatures ON productfeatures.idProductfeatures = ecom_productcategorie.idProductfeatures WHERE `prdcategorie`.`idPrdcategorie` = `ecom_productcategorie`.`idPrdcategorie` and `productfeatures`.PRD_ACTIEF = 1 ) and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc
|
|
0.21ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('57') order by `CATE_VOLGORDE` asc
|
|
0.29ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('107', '108', '109') order by `CATE_VOLGORDE` asc
|
|
0.19ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('379', '380', '381', '382') order by `CATE_VOLGORDE` asc
|
|
0.21ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '57' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc
|
|
0.27ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('108', '109', '107') order by `CATE_VOLGORDE` asc
|
|
0.15ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('379', '380', '381', '382') order by `CATE_VOLGORDE` asc
|
|
0.25ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '10' and exists ( select productfeatures.idProductfeatures from `ecom_productcategorie` INNER JOIN productfeatures ON productfeatures.idProductfeatures = ecom_productcategorie.idProductfeatures WHERE `prdcategorie`.`idPrdcategorie` = `ecom_productcategorie`.`idPrdcategorie` and `productfeatures`.PRD_ACTIEF = 1 ) and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc
|
|
0.3ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('58', '59', '60', '61', '62') order by `CATE_VOLGORDE` asc
|
|
0.81ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('116', '117', '118', '119', '120', '159', '277', '288', '325') order by `CATE_VOLGORDE` asc
|
|
0.31ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('406', '407', '408', '409', '410', '411', '412', '413', '414', '415', '416', '417', '418', '419', '420', '421', '422', '423', '424', '425', '426', '427', '428', '429', '430', '431', '432', '433', '434', '435', '436', '437', '438', '439', '440', '441', '442', '691', '692', '693', '1294', '1295', '1296', '1336', '1337', '1338', '1339', '1340', '1341', '1342', '1343', '1344', '1525', '1526') order by `CATE_VOLGORDE` asc
|
|
0.17ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '58' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc
|
|
0.38ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('288') order by `CATE_VOLGORDE` asc
|
|
0.23ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('1336', '1337', '1338', '1339', '1340', '1341', '1342', '1343', '1344') order by `CATE_VOLGORDE` asc
|
|
0.19ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '59' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc
|
|
0.23ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('277') order by `CATE_VOLGORDE` asc
|
|
0.2ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('1294', '1295', '1296') order by `CATE_VOLGORDE` asc
|
|
0.22ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '60' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc
|
|
1.01ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('117', '325', '116', '120', '118') order by `CATE_VOLGORDE` asc
|
|
0.58ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('406', '407', '408', '409', '410', '411', '412', '413', '414', '415', '416', '417', '418', '419', '420', '421', '422', '423', '424', '425', '426', '427', '428', '429', '430', '431', '432', '438', '439', '440', '441', '442', '1525', '1526') order by `CATE_VOLGORDE` asc
|
|
0.29ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '61' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc
|
|
0.67ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('119') order by `CATE_VOLGORDE` asc
|
|
4.25ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('433', '434', '435', '436', '437') order by `CATE_VOLGORDE` asc
|
|
5.35ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '62' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc
|
|
0.94ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('159') order by `CATE_VOLGORDE` asc
|
|
0.27ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('691', '692', '693') order by `CATE_VOLGORDE` asc
|
|
0.56ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '11' and exists ( select productfeatures.idProductfeatures from `ecom_productcategorie` INNER JOIN productfeatures ON productfeatures.idProductfeatures = ecom_productcategorie.idProductfeatures WHERE `prdcategorie`.`idPrdcategorie` = `ecom_productcategorie`.`idPrdcategorie` and `productfeatures`.PRD_ACTIEF = 1 ) and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc
|
|
0.5ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('63', '64') order by `CATE_VOLGORDE` asc
|
|
2.06ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('135', '167', '224', '244', '256', '259', '262') order by `CATE_VOLGORDE` asc
|
|
0.44ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('569', '570', '571', '572', '745', '1043', '1126', '1127', '1176', '1177', '1178', '1179', '1194', '1195', '1196', '1197', '1198', '1199', '1200', '1201', '1202', '1203', '1220', '1221', '1222', '1223', '1224', '1225', '1226', '1227', '1228') order by `CATE_VOLGORDE` asc
|
|
0.17ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '63' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc
|
|
0.32ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('167', '259') order by `CATE_VOLGORDE` asc
|
|
0.16ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('745', '1194', '1195', '1196', '1197', '1198', '1199', '1200', '1201', '1202', '1203') order by `CATE_VOLGORDE` asc
|
|
0.15ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '64' and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc
|
|
0.4ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('224', '262', '256', '135', '244') order by `CATE_VOLGORDE` asc
|
|
0.2ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('569', '570', '571', '572', '1043', '1126', '1127', '1176', '1177', '1178', '1179', '1220', '1221', '1222', '1223', '1224', '1225', '1226', '1227', '1228') order by `CATE_VOLGORDE` asc
|
|
0.3ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` where `prdcategorie`.`idBron` = '12' and exists ( select productfeatures.idProductfeatures from `ecom_productcategorie` INNER JOIN productfeatures ON productfeatures.idProductfeatures = ecom_productcategorie.idProductfeatures WHERE `prdcategorie`.`idPrdcategorie` = `ecom_productcategorie`.`idPrdcategorie` and `productfeatures`.PRD_ACTIEF = 1 ) and `prdcategorie`.`CATE_ACTIEF` = '1' group by `prdcategorie`.`idPrdcategorie` order by `CATE_VOLGORDE` asc, `CATE_NAAM1` asc
|
|
0.91ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('65', '66', '67', '68', '69', '70', '71', '72', '74', '73', '75', '76', '77', '78', '79', '80', '81', '83', '82', '84', '85', '86') order by `CATE_VOLGORDE` asc
|
|
4.53ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('93', '94', '95', '96', '103', '110', '111', '112', '113', '114', '115', '125', '137', '138', '139', '140', '146', '147', '170', '171', '172', '173', '178', '179', '180', '193', '202', '203', '204', '205', '221', '226', '227', '228', '229', '246', '247', '248', '260', '261', '264', '265', '266', '283', '284', '285', '293', '294', '295', '296', '297', '298', '299', '300', '305', '311', '312', '319') order by `CATE_VOLGORDE` asc
|
|
0.64ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('349', '350', '351', '352', '353', '354', '355', '356', '357', '368', '369', '370', '371', '383', '384', '385', '386', '387', '388', '389', '390', '391', '392', '393', '394', '395', '396', '397', '398', '399', '400', '401', '402', '403', '404', '405', '457', '458', '459', '575', '576', '577', '578', '579', '580', '582', '583', '584', '585', '586', '587', '588', '589', '590', '591', '592', '593', '594', '595', '596', '597', '598', '599', '600', '601', '602', '603', '604', '605', '606', '607', '608', '609', '610', '611', '635', '636', '637', '638', '639', '640', '753', '754', '755', '756', '757', '758', '759', '760', '761', '762', '763', '764', '765', '766', '767', '768', '769', '770', '771', '772', '773', '791', '792', '793', '794', '866', '908', '909', '910', '911', '912', '913', '914', '915', '916', '917', '918', '919', '920', '921', '922', '923', '924', '925', '926', '927', '1030', '1031', '1032', '1046', '1047', '1048', '1049', '1050', '1051', '1052', '1053', '1054', '1055', '1056', '1057', '1058', '1059', '1060', '1061', '1062', '1063', '1064', '1130', '1131', '1132', '1133', '1134', '1135', '1136', '1137', '1138', '1139', '1140', '1141', '1205', '1206', '1209', '1211', '1212', '1213', '1214', '1215', '1216', '1217', '1218', '1219', '1231', '1232', '1233', '1234', '1235', '1236', '1237', '1238', '1239', '1240', '1241', '1242', '1243', '1314', '1315', '1316', '1317', '1318', '1319', '1320', '1321', '1322', '1323', '1324', '1325', '1326', '1362', '1363', '1364', '1365', '1366', '1367', '1368', '1369', '1370', '1371', '1372', '1373', '1374', '1375', '1376', '1377', '1378', '1379', '1409', '1410', '1411', '1412', '1413', '1414', '1415', '1416', '1444', '1445', '1446', '1447', '1448', '1449', '1450', '1451', '1452', '1453', '1454', '1455', '1456', '1457', '1458', '1480', '1481', '1482') order by `CATE_VOLGORDE` asc
|
|
0.29ms
|
select * from `pages` where `id` = '1' limit 1
|
|
0.19ms
|
select * from `ecom_winkels` limit 1
|
|
0.16ms
|
select `pagenamelang1`, `slug1`, `id` from `pages` where `idMenu` = '1' and `pagevisibility` = '1' order by `pageorder` asc
|
|
0.12ms
|
select `pagenamelang1`, `slug1`, `id` from `pages` where `idMenu` = '2' and `pagevisibility` = '1' order by `pageorder` asc
|
|
0.12ms
|
select `pagenamelang1`, `slug1`, `id`, `pagetextlang1` from `pages` where `idMenu` = '5' and `pagevisibility` = '1' limit 1
|