| Time |
Query |
|
0.43ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie`, `idBron` from `prdcategorie` where `CATE_SLUG1` = 'outlet' and `CATE_CATALOOG_P4C` = '1' limit 1
|
|
0.79ms
|
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` = '182' and `PRD_APART_BESTELBAAR` = '1' and `PRD_CATALOOG_P4C` = '1' and `ecom_productfeatures_shops`.`idShop` = '1' and `productfeatures`.`PRD_ACTIEF` = '1'
|
|
1.92ms
|
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` = '182' 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.24ms
|
select * from `prdcategorie` where `prdcategorie`.`idPrdcategorie` = '0' limit 1
|
|
0.15ms
|
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.2ms
|
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.56ms
|
select * from `ecom_labels`
|
|
0.46ms
|
select * from `ecom_client_labels`
|
|
0.19ms
|
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.16ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('282', '283', '274') 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` = '282' 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` = '283' 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` = '274' 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` = '213' 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` = '240' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.15ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('241', '196') 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` = '241' 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` = '196' 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` = '175' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.19ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('195', '178', '179') 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` = '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.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` = '179' 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` = '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.18ms
|
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.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` = '186' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.4ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('203', '209', '184', '173', '199', '180', '250', '193') order by `CATE_VOLGORDE` asc
|
|
0.18ms
|
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.15ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('204', '205', '206', '207', '208') 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` = '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.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` = '184' 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` = '173' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.15ms
|
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.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` = '180' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' 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` = '250' 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` = '193' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' 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` = '183' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.14ms
|
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.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` = '172' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.16ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('221', '222', '226', '223', '224', '225', '227', '228', '229', '230', '231') 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` = '221' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' 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` = '222' 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` = '226' 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` = '223' 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` = '224' 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` = '225' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
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` = '227' 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` = '228' 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` = '229' 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` = '230' 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` = '231' 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` = '185' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.16ms
|
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.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` = '200' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.23ms
|
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.21ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('202') 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` = '202' 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` = '194' 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` = '211' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.15ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('284', '218', '219') 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` = '284' 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` = '218' 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` = '219' 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` = '181' 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` = '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.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` = '239' 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` = '235' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.15ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('238', '237') 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` = '236' 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` = '197' 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` = '174' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.16ms
|
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.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` = '176' 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` = '232' 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` = '212' 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` = '242' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.44ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('243', '251', '245', '244', '247', '246') order by `CATE_VOLGORDE` asc
|
|
0.38ms
|
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.25ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('256', '257', '258', '259', '263', '270', '271') order by `CATE_VOLGORDE` asc
|
|
0.16ms
|
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.26ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('276', '279', '277', '278') 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` = '245' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.23ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('280', '275', '265', '272', '260') 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` = '244' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.25ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('254', '255', '262', '261', '281', '266', '267', '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` = '247' 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` = '246' 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` = '170' 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` = '201' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.4ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '2296452' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.4ms
|
select sum(`VRIJE_STOCK`) as aggregate from `tmp_parts4cars_TSTKAFD` where `ARTIKEL` = 'KEM-12.105'
|
|
0.2ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '2296452'
|
|
0.83ms
|
select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'KEM-12.105' limit 1
|
|
0.29ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '2734867' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.24ms
|
select sum(`VRIJE_STOCK`) as aggregate from `tmp_parts4cars_TSTKAFD` where `ARTIKEL` = 'NOR-7410-001-002'
|
|
0.18ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '2734867'
|
|
0.27ms
|
select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'NOR-7410-001-002' limit 1
|
|
0.28ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '2734870' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.24ms
|
select sum(`VRIJE_STOCK`) as aggregate from `tmp_parts4cars_TSTKAFD` where `ARTIKEL` = 'NOR-7410-001-005'
|
|
0.16ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '2734870'
|
|
0.22ms
|
select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'NOR-7410-001-005' limit 1
|
|
0.28ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '3530182' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.23ms
|
select sum(`VRIJE_STOCK`) as aggregate from `tmp_parts4cars_TSTKAFD` where `ARTIKEL` = 'RI-R04102'
|
|
0.17ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '3530182'
|
|
0.22ms
|
select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'RI-R04102' limit 1
|
|
0.28ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '2734879' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.21ms
|
select sum(`VRIJE_STOCK`) as aggregate from `tmp_parts4cars_TSTKAFD` where `ARTIKEL` = 'NOR-SCH-R-1821-Z'
|
|
0.17ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '2734879'
|
|
0.2ms
|
select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'NOR-SCH-R-1821-Z' limit 1
|
|
0.3ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '2734878' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.19ms
|
select sum(`VRIJE_STOCK`) as aggregate from `tmp_parts4cars_TSTKAFD` where `ARTIKEL` = 'NOR-SCH-39901-00'
|
|
0.16ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '2734878'
|
|
0.23ms
|
select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'NOR-SCH-39901-00' limit 1
|
|
0.32ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '2296194' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.33ms
|
select sum(`VRIJE_STOCK`) as aggregate from `tmp_parts4cars_TSTKAFD` where `ARTIKEL` = 'KEM-11.204220-STAR'
|
|
0.17ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '2296194'
|
|
0.24ms
|
select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'KEM-11.204220-STAR' limit 1
|
|
0.33ms
|
select * from `pages` where `id` = '61' limit 1
|
|
0.27ms
|
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.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.17ms
|
select * from `pages` where `id` = '32' limit 1
|
|
0.11ms
|
select * from `ecom_winkels` limit 1
|
|
0.37ms
|
select * from `pages` where `idMenu` = '6' and `pagevisibility` = '1' order by `pageorder` asc
|
