| Time |
Query |
|
0.42ms
|
select `CATE_NAAM1`, `CATE_SLUG1`, `prdcategorie`.`idPrdcategorie`, `idBron` from `prdcategorie` where `CATE_SLUG1` = 'finixa-non-paint' and `CATE_CATALOOG_P4C` = '1' limit 1
|
|
18.78ms
|
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` = '172' and `PRD_APART_BESTELBAAR` = '1' and `PRD_CATALOOG_P4C` = '1' and `ecom_productfeatures_shops`.`idShop` = '1' and `productfeatures`.`PRD_ACTIEF` = '1'
|
|
9.43ms
|
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` = '172' 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.33ms
|
select * from `prdcategorie` where `prdcategorie`.`idPrdcategorie` = '0' limit 1
|
|
0.15ms
|
select * from `ecom_settings` where `id` = '22' limit 1
|
|
0.1ms
|
select * from `ecom_settings` where `id` = '23' limit 1
|
|
0.12ms
|
select * from `ecom_winkels` limit 1
|
|
0.09ms
|
select `waarde` from `ecom_settings` where `key` = 'mailaddress' limit 1
|
|
0.19ms
|
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.51ms
|
select * from `ecom_client_labels`
|
|
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` = '273' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.24ms
|
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.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.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` = '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.19ms
|
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.19ms
|
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.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` = '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.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.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` = '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.39ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('203', '209', '184', '173', '199', '180', '250', '193') order by `CATE_VOLGORDE` asc
|
|
0.23ms
|
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.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` = '203' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.19ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('204', '205', '206', '207', '208') 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` = '209' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.19ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('210', '214', '215', '216', '217') 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` = '184' 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` = '173' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.2ms
|
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.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` = '250' 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` = '193' 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` = '183' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.19ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('220') 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` = '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.2ms
|
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.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` = '222' 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` = '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.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` = '224' 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` = '225' 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` = '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.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` = '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.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` = '231' 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` = '185' 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` = '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.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` = '200' 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` = '182' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.2ms
|
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.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` = '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.19ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('284', '218', '219') 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` = '284' 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` = '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.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.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` = '234' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.23ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('239', '235', '236') order by `CATE_VOLGORDE` asc
|
|
0.19ms
|
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` = '239' 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` = '235' and `idShops` = '1' and `CATE_CATALOOG_P4C` = '1' order by `CATE_VOLGORDE` asc
|
|
0.18ms
|
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.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.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.19ms
|
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.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.5ms
|
select * from `prdcategorie` where `prdcategorie`.`idBron` in ('243', '251', '245', '244', '247', '246') order by `CATE_VOLGORDE` asc
|
|
0.19ms
|
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.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` = '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.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` = '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.18ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '2156100' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.29ms
|
select sum(`VRIJE_STOCK`) as aggregate from `tmp_parts4cars_TSTKAFD` where `ARTIKEL` = 'FIN-CLP15'
|
|
0.12ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '2156100'
|
|
0.11ms
|
select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'FIN-CLP15' limit 1
|
|
0.32ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '2156137' 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` = 'FIN-DEB12'
|
|
0.16ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '2156137'
|
|
0.22ms
|
select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'FIN-DEB12' limit 1
|
|
0.27ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '2156143' 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` = 'FIN-DPL20-01'
|
|
0.16ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '2156143'
|
|
0.22ms
|
select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'FIN-DPL20-01' limit 1
|
|
0.28ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '2157453' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.25ms
|
select sum(`VRIJE_STOCK`) as aggregate from `tmp_parts4cars_TSTKAFD` where `ARTIKEL` = 'FIN-GAP00'
|
|
0.16ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '2157453'
|
|
0.21ms
|
select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'FIN-GAP00' limit 1
|
|
0.27ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '2157454' 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` = 'FIN-GAP10'
|
|
0.15ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '2157454'
|
|
0.22ms
|
select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'FIN-GAP10' limit 1
|
|
0.27ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '2157455' 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` = 'FIN-GAP20'
|
|
0.16ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '2157455'
|
|
0.21ms
|
select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'FIN-GAP20' limit 1
|
|
0.28ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '2157463' 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` = 'FIN-GAP60'
|
|
0.16ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '2157463'
|
|
0.23ms
|
select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'FIN-GAP60' limit 1
|
|
0.17ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '2157527' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.2ms
|
select sum(`VRIJE_STOCK`) as aggregate from `tmp_parts4cars_TSTKAFD` where `ARTIKEL` = 'FIN-LRS20'
|
|
0.11ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '2157527'
|
|
0.11ms
|
select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'FIN-LRS20' limit 1
|
|
0.17ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '2157565' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.2ms
|
select sum(`VRIJE_STOCK`) as aggregate from `tmp_parts4cars_TSTKAFD` where `ARTIKEL` = 'FIN-LSP20'
|
|
0.11ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '2157565'
|
|
0.11ms
|
select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'FIN-LSP20' limit 1
|
|
0.28ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '2157567' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.31ms
|
select sum(`VRIJE_STOCK`) as aggregate from `tmp_parts4cars_TSTKAFD` where `ARTIKEL` = 'FIN-MAK00'
|
|
0.16ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '2157567'
|
|
0.2ms
|
select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'FIN-MAK00' limit 1
|
|
0.18ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '2157626' and `MEDIA_TYPE` = 'I' and `MEDIA_STD` = '1' order by `MEDIA_BESTANDSNAAM` asc limit 1
|
|
0.28ms
|
select sum(`VRIJE_STOCK`) as aggregate from `tmp_parts4cars_TSTKAFD` where `ARTIKEL` = 'FIN-MFS40'
|
|
0.11ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '2157626'
|
|
0.11ms
|
select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'FIN-MFS40' limit 1
|
|
0.17ms
|
select * from `prdmedia` where `prdmedia`.`idProductFeatures` = '2157726' 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` = 'FIN-PMP22'
|
|
0.11ms
|
select * from `prdkorting` where `prdkorting`.`idProductfeatures` = '2157726'
|
|
0.11ms
|
select * from `tmp_parts4cars_TARTPRIJSDET` where `AFDELING` = '1P' and `MULTI_NW` = '1P' and `ARTIKEL` = 'FIN-PMP22' limit 1
|
|
0.26ms
|
select * from `pages` where `id` = '61' limit 1
|
|
0.32ms
|
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.21ms
|
select * from `pages` where `pages`.`issubpageof` in ('32') order by `pageorder` asc
|
|
0.28ms
|
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.17ms
|
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.33ms
|
select * from `pages` where `idMenu` = '6' and `pagevisibility` = '1' order by `pageorder` asc
|
