| Time |
Query |
|
0.54ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie`, `idBron` from `prdcategorie` where `CATE_SLUG1` = 'vloeistoffen' and `CATE_CATALOOG_P4C` = '1' limit 1
|
|
0.89ms
|
select count(*) as aggregate from `productfeatures` inner join `ecom_productcategorie` on `productfeatures`.`idProductfeatures` = `ecom_productcategorie`.`idProductfeatures` inner join `ecom_productfeatures_shops` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_shops`.`idProductfeatures` where `ecom_productcategorie`.`idPrdcategorie` = '180' and `PRD_APART_BESTELBAAR` = '1' and `PRD_CATALOOG_P4C` = '1' and `ecom_productfeatures_shops`.`idShop` = '1' and `productfeatures`.`PRD_ACTIEF` = '1'
|
|
2.24ms
|
select `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` inner join `ecom_productfeatures_shops` on `productfeatures`.`idProductfeatures` = `ecom_productfeatures_shops`.`idProductfeatures` where `ecom_productcategorie`.`idPrdcategorie` = '180' and `PRD_APART_BESTELBAAR` = '1' and `PRD_CATALOOG_P4C` = '1' and `ecom_productfeatures_shops`.`idShop` = '1' and `productfeatures`.`PRD_ACTIEF` = '1' order by `PRD_VOLGORDE` asc limit 12 offset 0
|
|
0.21ms
|
select * from `prdcategorie` where `prdcategorie`.`idPrdcategorie` = '186' limit 1
|
|
0.15ms
|
select * from `prdcategorie` where `prdcategorie`.`idPrdcategorie` in ('0')
|
|
0.14ms
|
select * from `ecom_settings` where `id` = '22' limit 1
|
|
0.11ms
|
select * from `ecom_settings` where `id` = '23' limit 1
|
|
0.14ms
|
select * from `ecom_winkels` limit 1
|
|
0.1ms
|
select `waarde` from `ecom_settings` where `key` = 'mailaddress' limit 1
|
|
0.21ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` inner join `ecom_shops_categorie` on `prdcategorie`.`idPrdcategorie` = `ecom_shops_categorie`.`idPrdcategorie` where `prdcategorie`.`CATE_ACTIEF` = '1' and `ecom_shops_categorie`.`idShops` = '1' and `CATE_CATALOOG_P4C` = '1' and `prdcategorie`.`idBron` = '0' group by `prdcategorie`.`idPrdcategorie` order by `prdcategorie`.`CATE_VOLGORDE` asc
|
|
1.63ms
|
select * from `ecom_labels`
|
|
0.51ms
|
select * from `ecom_client_labels`
|
|
0.21ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '273' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.19ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('282', '283', '274') order by `CATE_VOLGORDE` asc
|
|
0.14ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '282' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.13ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '283' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '274' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '213' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.13ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '240' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.17ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('241', '196') order by `CATE_VOLGORDE` asc
|
|
0.13ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '241' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '196' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.13ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '175' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.17ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('195', '178', '179') order by `CATE_VOLGORDE` asc
|
|
0.13ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '195' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.13ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '178' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '179' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '233' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.13ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '252' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '249' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.13ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '186' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.42ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('203', '209', '184', '173', '199', '180', '250', '193') order by `CATE_VOLGORDE` asc
|
|
0.19ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('187', '204', '210', '188', '205', '214', '190', '206', '215', '189', '207', '216', '191', '208', '217', '192', '198') order by `CATE_VOLGORDE` asc
|
|
0.17ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '203' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.17ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('204', '205', '206', '207', '208') order by `CATE_VOLGORDE` asc
|
|
0.13ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '209' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.17ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('210', '214', '215', '216', '217') order by `CATE_VOLGORDE` asc
|
|
0.13ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '184' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.13ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '173' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.17ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('187', '188', '190', '189', '191', '192', '198') order by `CATE_VOLGORDE` asc
|
|
0.14ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '199' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.13ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '180' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '250' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '193' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '183' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.17ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('220') order by `CATE_VOLGORDE` asc
|
|
0.14ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '220' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.14ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '172' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.18ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('221', '222', '226', '223', '224', '225', '227', '228', '229', '230', '231') order by `CATE_VOLGORDE` asc
|
|
0.13ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '221' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '222' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '226' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.13ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '223' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '224' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '225' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '227' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '228' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '229' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '230' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '231' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '185' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '171' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.13ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '248' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '200' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '182' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.17ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('202') order by `CATE_VOLGORDE` asc
|
|
0.13ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '202' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '194' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.13ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '211' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.17ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('284', '218', '219') order by `CATE_VOLGORDE` asc
|
|
0.15ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '284' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '218' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '219' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '181' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '253' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.14ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '234' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.19ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('239', '235', '236') order by `CATE_VOLGORDE` asc
|
|
0.16ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('238', '237') order by `CATE_VOLGORDE` asc
|
|
0.15ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '239' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '235' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.16ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('238', '237') order by `CATE_VOLGORDE` asc
|
|
0.13ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '236' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '197' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.13ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '174' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.17ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('177', '176', '232', '212') order by `CATE_VOLGORDE` asc
|
|
0.13ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '177' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '176' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '232' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '212' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '242' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.42ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('243', '251', '245', '244', '247', '246') order by `CATE_VOLGORDE` asc
|
|
0.2ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('254', '256', '276', '280', '255', '257', '275', '279', '258', '262', '265', '277', '259', '261', '272', '278', '260', '263', '281', '266', '270', '267', '271', '264', '268', '269') order by `CATE_VOLGORDE` asc
|
|
0.15ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '243' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.15ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('256', '257', '258', '259', '263', '270', '271') order by `CATE_VOLGORDE` asc
|
|
0.15ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '251' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.15ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('276', '279', '277', '278') order by `CATE_VOLGORDE` asc
|
|
0.14ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '245' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.15ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('280', '275', '265', '272', '260') order by `CATE_VOLGORDE` asc
|
|
0.14ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '244' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.15ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('254', '255', '262', '261', '281', '266', '267', '264', '268', '269') order by `CATE_VOLGORDE` asc
|
|
0.13ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '247' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '246' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.12ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '170' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.13ms
|
select distinct `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie` from `prdcategorie` left join `ecom_shops_categorie` on `ecom_shops_categorie`.`idPrdcategorie` = `prdcategorie`.`idPrdcategorie` where `prdcategorie`.`idBron` = '201' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.34ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '3211644' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
5.23ms
|
select sum(`VRIJE_STOCK`) as aggregate from `tmp_parts4cars_TSTKAFD` where `ARTIKEL` = 'P-1636051880'
|
|
0.18ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '3211644'
|
|
12.02ms
|
select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'P-1636051880' limit 1
|
|
0.36ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '3211646' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
5.54ms
|
select sum(`VRIJE_STOCK`) as aggregate from `tmp_parts4cars_TSTKAFD` where `ARTIKEL` = 'P-1636052280'
|
|
0.17ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '3211646'
|
|
12.25ms
|
select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'P-1636052280' limit 1
|
|
0.32ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '123628' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
9.75ms
|
select sum(`VRIJE_STOCK`) as aggregate from `tmp_parts4cars_TSTKAFD` where `ARTIKEL` = 'CI-1611912080'
|
|
0.19ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '123628'
|
|
5.92ms
|
select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'CI-1611912080' limit 1
|
|
0.32ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '3211645' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
5.29ms
|
select sum(`VRIJE_STOCK`) as aggregate from `tmp_parts4cars_TSTKAFD` where `ARTIKEL` = 'P-1636051980'
|
|
0.17ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '3211645'
|
|
11.81ms
|
select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'P-1636051980' limit 1
|
|
0.34ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '3211648' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
5.46ms
|
select sum(`VRIJE_STOCK`) as aggregate from `tmp_parts4cars_TSTKAFD` where `ARTIKEL` = 'P-1636052480'
|
|
0.18ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '3211648'
|
|
11.97ms
|
select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'P-1636052480' limit 1
|
|
7.66ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '3160837' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
9.42ms
|
select sum(`VRIJE_STOCK`) as aggregate from `tmp_parts4cars_TSTKAFD` where `ARTIKEL` = 'P-1611911680'
|
|
0.2ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '3160837'
|
|
17.84ms
|
select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'P-1611911680' limit 1
|
|
0.34ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '3211649' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
5.13ms
|
select sum(`VRIJE_STOCK`) as aggregate from `tmp_parts4cars_TSTKAFD` where `ARTIKEL` = 'P-1636052580'
|
|
0.18ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '3211649'
|
|
11.85ms
|
select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'P-1636052580' limit 1
|
|
0.32ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '3206167' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
5.12ms
|
select sum(`VRIJE_STOCK`) as aggregate from `tmp_parts4cars_TSTKAFD` where `ARTIKEL` = 'P-1631692580'
|
|
0.18ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '3206167'
|
|
1.83ms
|
select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'P-1631692580' limit 1
|
|
0.29ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '3206168' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
5.24ms
|
select sum(`VRIJE_STOCK`) as aggregate from `tmp_parts4cars_TSTKAFD` where `ARTIKEL` = 'P-1631692680'
|
|
0.16ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '3206168'
|
|
1.81ms
|
select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'P-1631692680' limit 1
|
|
0.31ms
|
select * from `pages` where `id` = '61' limit 1
|
|
0.24ms
|
select * from `pages` inner join `ecom_pages_shops` on `pages`.`id` = `ecom_pages_shops`.`idPages` left join `ecom_pages_klantgroep` on `pages`.`id` = `ecom_pages_klantgroep`.`pages_id` where `ecom_pages_shops`.`idShops` = '1' and (`ecom_pages_klantgroep`.`pages_id` is null) and `idMenu` = '1' and `idMenu` = '1' and `pagevisibility` = '1' order by `pageorder` asc
|
|
0.16ms
|
select * from `pages` where `pages`.`issubpageof` in ('32') order by `pageorder` asc
|
|
0.21ms
|
select * from `pages` inner join `ecom_pages_shops` on `pages`.`id` = `ecom_pages_shops`.`idPages` left join `ecom_pages_klantgroep` on `pages`.`id` = `ecom_pages_klantgroep`.`pages_id` where `ecom_pages_shops`.`idShops` = '1' and (`ecom_pages_klantgroep`.`pages_id` is null) and `idMenu` = '1' and `idMenu` = '1' and `pagevisibility` = '1' order by `pageorder` asc
|
|
0.15ms
|
select * from `pages` where `pages`.`issubpageof` in ('32') order by `pageorder` asc
|
|
0.15ms
|
select * from `pages` where `id` = '32' limit 1
|
|
0.11ms
|
select * from `ecom_winkels` limit 1
|
|
0.31ms
|
select * from `pages` where `idMenu` = '6' and `pagevisibility` = '1' order by `pageorder` asc
|
