Detergents - acpe.gr

Filters

Professional detergents for daily cleaning and hygiene in demanding and high-use areas. This category covers solutions for kitchens, surfaces, bathrooms, dishes, laundry, and special applications, so that the right choice can be made for each type of dirt and process.

For faster navigation, use the list of subcategories on the left and go straight to the solution you are looking for: Kitchen, Surfaces, Bathroom, Dishes, Clothes, or Special Cleaners.

What the business gains

✔️ Better consumption control with solutions that match the rate of use and method of application.

✔️ Consistent results in the daily cleaning process, with the right specialization for each application.

✔️ Options in professional packaging for more organized replenishment and storage.

Why from Acpe.gr

✔️ Solutions that cover daily and demanding applications, with priority given to performance and economy of use.

✔️ Huge range of products from leading professional brands, for a safer choice for each application and space requirements.

[ ### CLOSE ### ]

mem usage: 0.72MB

mem usage peak: 0.754MB

mem usage true: 2MB

mem usage peak true: 2MB

Queries total count: 53

Queries total time: 0.01605916s

============ 2026-06-07 01:49:35 ============
Query #0
Time:0.00014806
Query:select * from settings

============ 2026-06-07 01:49:35 ============
Query #1
Time:0.00014496
Query:select * from settings

============ 2026-06-07 01:49:35 ============
Query #2
Time:0.00014091
Query:REPLACE INTO active_guests VALUES ('216.73.216.205', '1780786175', 'English')

============ 2026-06-07 01:49:35 ============
Query #3
Time:0.00010514
Query:SELECT * FROM active_guests

============ 2026-06-07 01:49:35 ============
Query #4
Time:6.39E-5
Query:DELETE FROM active_users WHERE timestamp < '1780784675'

============ 2026-06-07 01:49:35 ============
Query #5
Time:4.387E-5
Query:SELECT * FROM active_users

============ 2026-06-07 01:49:35 ============
Query #6
Time:6.318E-5
Query:DELETE FROM active_guests WHERE timestamp < '1780785575'

============ 2026-06-07 01:49:35 ============
Query #7
Time:6.58E-5
Query:SELECT * FROM active_guests

============ 2026-06-07 01:49:35 ============
Query #8
Time:0.00015998
Query:SELECT id from sessions where session_id = '3de35d00b2de9c7323b623995fc9ccb3' and last_active >= (1780786175 - 1800)

============ 2026-06-07 01:49:35 ============
Query #9
Time:0.00010896
Query:UPDATE basket set last_active='2026-06-07 01:49:35' WHERE session_id = '3de35d00b2de9c7323b623995fc9ccb3'

============ 2026-06-07 01:49:35 ============
Query #10
Time:9.203E-5
Query:UPDATE sessions set last_active='1780786175', referrer='', page='/eng/categories/Professional-Detergents/all/Katharistika-Tzamion_Ygro_WoolSafe/1' where session_id = '3de35d00b2de9c7323b623995fc9ccb3'

============ 2026-06-07 01:49:35 ============
Query #11
Time:0.00014305
Query:delete from sessions WHERE last_active < (UNIX_TIMESTAMP()-1800);

============ 2026-06-07 01:49:35 ============
Query #12
Time:6.795E-5
Query:delete from basket where last_active < '2026-05-08 01:49:35'

============ 2026-06-07 01:49:35 ============
Query #13
Time:4.697E-5
Query:SELECT * FROM active_users

============ 2026-06-07 01:49:35 ============
Query #14
Time:6.604E-5
Query:SELECT * FROM active_guests

============ 2026-06-07 01:49:35 ============
Query #15
Time:6.008E-5
Query:select * from settings

============ 2026-06-07 01:49:35 ============
Query #16
Time:5.507E-5
Query:SELECT * FROM tags

============ 2026-06-07 01:49:35 ============
Query #17
Time:4.578E-5
Query:SELECT * FROM availability

============ 2026-06-07 01:49:35 ============
Query #18
Time:5.507E-5
Query:select * from settings_tracking

============ 2026-06-07 01:49:35 ============
Query #19
Time:9.704E-5
Query:SELECT * FROM misctexts where lang='English' order by text_id asc

============ 2026-06-07 01:49:35 ============
Query #20
Time:0.00043416
Query:SELECT c1.cat_id as c1_cat_id, c1.cat_discount as c1_cat_discount, c2.cat_id as c2_cat_id, c2.cat_discount as c2_cat_discount, c3.cat_id as c3_cat_id, c3.cat_discount as c3_cat_discount, c4.cat_id as c4_cat_id, c4.cat_discount as c4_cat_discount, c5.cat_id as c5_cat_id, c5.cat_discount as c5_cat_discount, c6.cat_id as c6_cat_id, c6.cat_discount as c6_cat_discount from categories as c1 LEFT JOIN categories AS c2 ON c2.cat_father_id = c1.cat_id LEFT JOIN categories AS c3 ON c3.cat_father_id = c2.cat_id LEFT JOIN categories AS c4 ON c4.cat_father_id = c3.cat_id LEFT JOIN categories AS c5 ON c5.cat_father_id = c4.cat_id LEFT JOIN categories AS c6 ON c6.cat_father_id = c5.cat_id where c1.cat_father_id=0 order by c1.cat_id, c2.cat_id, c3.cat_id, c4.cat_id, c5.cat_id, c6.cat_id asc

============ 2026-06-07 01:49:35 ============
Query #21
Time:0.00011492
Query:select synckey from prodcat_weight_sync where synckey = 'c6uuoqJzeZLaSLLHTVbU'

============ 2026-06-07 01:49:35 ============
Query #22
Time:0.00185704
Query:delete from prodcat_weight_sync where prod_id not in (select prod_id from products)

============ 2026-06-07 01:49:35 ============
Query #23
Time:0.00512719
Query:insert ignore into prodcat_weight_sync (prod_id, synckey, synctime) select prod_id, '', '2000-01-01 00:00:00' from products

============ 2026-06-07 01:49:35 ============
Query #24
Time:0.00032401
Query:update prodcat_weight_sync set synckey='c6uuoqJzeZLaSLLHTVbU', synctime=NOW() where synctime < '2026-06-07 00:49:35' limit 10

============ 2026-06-07 01:49:35 ============
Query #25
Time:0.00101304
Query:SELECT products.*, min(products_atts.price) as pricefrom, min(products_atts.pricex) as pricexfrom, count(products_atts.product_id) as attcount from prodcat_weight_sync inner join products on products.prod_id=prodcat_weight_sync.prod_id left join products_atts on products.id=products_atts.product_id WHERE prodcat_weight_sync.synckey='c6uuoqJzeZLaSLLHTVbU' group by products.id

============ 2026-06-07 01:49:35 ============
Query #26
Time:9.799E-5
Query:update prodcat_weight set price='78.31' where prod_id='1726342633'

============ 2026-06-07 01:49:35 ============
Query #27
Time:7.2E-5
Query:update prodcat_weight set price='91.61' where prod_id='1726343143'

============ 2026-06-07 01:49:35 ============
Query #28
Time:7.01E-5
Query:update prodcat_weight set price='78.31' where prod_id='1726343466'

============ 2026-06-07 01:49:35 ============
Query #29
Time:6.294E-5
Query:update prodcat_weight set price='104.19' where prod_id='1726346048'

============ 2026-06-07 01:49:35 ============
Query #30
Time:5.007E-5
Query:update prodcat_weight set price='58.90' where prod_id='1726346404'

============ 2026-06-07 01:49:35 ============
Query #31
Time:4.292E-5
Query:update prodcat_weight set price='67.75' where prod_id='1726398579'

============ 2026-06-07 01:49:35 ============
Query #32
Time:4.888E-5
Query:update prodcat_weight set price='25.40' where prod_id='1726416647'

============ 2026-06-07 01:49:35 ============
Query #33
Time:4.292E-5
Query:update prodcat_weight set price='51.45' where prod_id='1726418527'

============ 2026-06-07 01:49:35 ============
Query #34
Time:4.101E-5
Query:update prodcat_weight set price='132.50' where prod_id='1726499721'

============ 2026-06-07 01:49:35 ============
Query #35
Time:4.387E-5
Query:update prodcat_weight set price='106.50' where prod_id='1726502374'

============ 2026-06-07 01:49:35 ============
Query #36
Time:0.00015306
Query:SELECT * FROM categories WHERE cat_url_English='Professional-Detergents' and lang='Greek' and hidden='0'

============ 2026-06-07 01:49:35 ============
Query #37
Time:0.00024819
Query:SELECT t1.category AS lev1, t1.cat_id AS clev1, t1.cat_url AS curl1, t2.category as lev2, t2.cat_id AS clev2, t2.cat_url AS curl2, t3.category as lev3, t3.cat_id AS clev3, t3.cat_url AS curl3, t4.category as lev4, t4.cat_id AS clev4, t4.cat_url AS curl4, t5.category as lev5, t5.cat_id AS clev5, t5.cat_url AS curl5
FROM categories AS t1
LEFT JOIN categories AS t2 ON t2.cat_father_id = t1.cat_id and t2.hidden=0
LEFT JOIN categories AS t3 ON t3.cat_father_id = t2.cat_id and t3.hidden=0
LEFT JOIN categories AS t4 ON t4.cat_father_id = t3.cat_id and t4.hidden=0
LEFT JOIN categories AS t5 ON t5.cat_father_id = t4.cat_id and t5.hidden=0
where t1.cat_father_id=806 and t1.hidden=0 order by lev1,lev2,lev3,lev4,lev5 asc

============ 2026-06-07 01:49:35 ============
Query #38
Time:0.00053191
Query:SELECT max(price) as mp1 FROM prodcat_weight WHERE prod_id in (select prod_id from prodcat_weight where cat_id in (816,814,819,817,813,836,815,847,806)) and hidden=0

============ 2026-06-07 01:49:35 ============
Query #39
Time:0.00012803
Query:
SELECT
c1.category_English as c1_category_English, c1.cat_url_English as c1_cat_url_English, c1.cat_id as c1_cat_id, c2.category_English as c2_category_English, c2.cat_url_English as c2_cat_url_English, c2.cat_id as c2_cat_id, c3.category_English as c3_category_English, c3.cat_url_English as c3_cat_url_English, c3.cat_id as c3_cat_id, c4.category_English as c4_category_English, c4.cat_url_English as c4_cat_url_English, c4.cat_id as c4_cat_id, c5.category_English as c5_category_English, c5.cat_url_English as c5_cat_url_English, c5.cat_id as c5_cat_id, c6.category_English as c6_category_English, c6.cat_url_English as c6_cat_url_English, c6.cat_id as c6_cat_id
from categories as c1 LEFT JOIN categories AS c2 ON c2.cat_id = c1.cat_father_id LEFT JOIN categories AS c3 ON c3.cat_id = c2.cat_father_id LEFT JOIN categories AS c4 ON c4.cat_id = c3.cat_father_id LEFT JOIN categories AS c5 ON c5.cat_id = c4.cat_father_id LEFT JOIN categories AS c6 ON c6.cat_id = c5.cat_father_id

where
c1.cat_id='806'

============ 2026-06-07 01:49:35 ============
Query #40
Time:0.00014901
Query:SELECT cat_id , category_English, cat_url_English, cat_image FROM categories WHERE cat_father_id='806' and hidden=0 ORDER BY weight asc

============ 2026-06-07 01:49:35 ============
Query #41
Time:0.00014114
Query:select * from filters where filter_url='Katharistika-Tzamion' or filter_url='Ygro' or filter_url='WoolSafe'

============ 2026-06-07 01:49:35 ============
Query #42
Time:0.00017214
Query:SELECT `groups`.* FROM `groups` order by weight asc

============ 2026-06-07 01:49:35 ============
Query #43
Time:0.00046992
Query:SELECT distinct(products.supplier), suppliers.supplier_name, suppliers.supplier_url, count(distinct products.prod_id) as total from prodcat_weight inner join products on products.prod_id = prodcat_weight.prod_id inner join products_filters as fl1 on products.id=fl1.product_id inner join products_filters as fl2 on products.id=fl2.product_id inner join products_filters as fl3 on products.id=fl3.product_id inner join suppliers on suppliers.sid=products.supplier WHERE prodcat_weight.cat_id in (816,814,819,817,813,836,815,847,806) and prodcat_weight.hidden='0' and ((fl1.filter_id='199') and (fl2.filter_id='80') and (fl3.filter_id='62') ) group by products.supplier

============ 2026-06-07 01:49:35 ============
Query #44
Time:0.00030613
Query:SELECT filters.*, count(distinct products.prod_id) as total from prodcat_weight inner join products on products.prod_id = prodcat_weight.prod_id inner join products_filters as fl1 on products.id=fl1.product_id inner join products_filters as fl2 on products.id=fl2.product_id inner join products_filters as fl3 on products.id=fl3.product_id inner join products_filters on products_filters.product_id=products.id inner join filters on products_filters.filter_id=filters.id WHERE prodcat_weight.cat_id in (816,814,819,817,813,836,815,847,806) and prodcat_weight.hidden='0' and ((fl1.filter_id='199') and (fl2.filter_id='80') and (fl3.filter_id='62') ) group by filters.id order by filters.weight asc

============ 2026-06-07 01:49:35 ============
Query #45
Time:0.00010204
Query:select * from central_banner where image<>'' and lang='English' and position='category' and status='1' order by weight asc

============ 2026-06-07 01:49:35 ============
Query #46
Time:0.00018883
Query:SELECT count(DISTINCT products.prod_id) as total from prodcat_weight inner join products on products.prod_id=prodcat_weight.prod_id inner join products_filters as fl1 on products.id=fl1.product_id inner join products_filters as fl2 on products.id=fl2.product_id inner join products_filters as fl3 on products.id=fl3.product_id WHERE prodcat_weight.cat_id in (816,814,819,817,813,836,815,847,806) and prodcat_weight.hidden='0' and ((fl1.filter_id='199') and (fl2.filter_id='80') and (fl3.filter_id='62') )

============ 2026-06-07 01:49:35 ============
Query #47
Time:0.00051188
Query:SELECT products.*
, min(products_atts.price) as pricefrom
, min(products_atts.pricex) as pricexfrom
, max(products_atts.price) as priceto
, max(products_atts.pricex) as pricexto

, count(products_atts.product_id) as attcount, products_images.filename as thefile from prodcat_weight inner join products on products.prod_id=prodcat_weight.prod_id inner join products_filters as fl1 on products.id=fl1.product_id inner join products_filters as fl2 on products.id=fl2.product_id inner join products_filters as fl3 on products.id=fl3.product_id left join products_atts on products.id=products_atts.product_id left join products_images on products.prod_id=products_images.prod_id and products_images.firstimg=1 WHERE prodcat_weight.cat_id in (816,814,819,817,813,836,815,847,806) and prodcat_weight.hidden='0' and ((fl1.filter_id='199') and (fl2.filter_id='80') and (fl3.filter_id='62') ) group by products.id order by prodcat_weight.weight ASC, id desc LIMIT 0, 15

============ 2026-06-07 01:49:35 ============
Query #48
Time:0.00046301
Query:
SELECT
c1.category_English as c1_category_English, c1.cat_url_English as c1_cat_url_English, c1.cat_id as c1_cat_id, c1.cat_father_id as c1_cat_father_id, c1.cat_image as c1_cat_image, c1.image_caption1 as c1_image_caption1, c2.category_English as c2_category_English, c2.cat_url_English as c2_cat_url_English, c2.cat_id as c2_cat_id, c2.cat_father_id as c2_cat_father_id, c2.cat_image as c2_cat_image, c2.image_caption1 as c2_image_caption1
from categories as c1 LEFT JOIN categories AS c2 ON c2.cat_father_id = c1.cat_id and c2.hidden=0

where
c1.cat_father_id=0 and c1.hidden=0 order by c1.weight, c2.weight asc

============ 2026-06-07 01:49:35 ============
Query #49
Time:0.00047398
Query:
SELECT
c1.category_English as c1_category_English, c1.cat_url_English as c1_cat_url_English, c1.cat_id as c1_cat_id, c1.cat_father_id as c1_cat_father_id, c1.cat_image as c1_cat_image, c1.image_caption1 as c1_image_caption1, c2.category_English as c2_category_English, c2.cat_url_English as c2_cat_url_English, c2.cat_id as c2_cat_id, c2.cat_father_id as c2_cat_father_id, c2.cat_image as c2_cat_image, c2.image_caption1 as c2_image_caption1
from categories as c1 LEFT JOIN categories AS c2 ON c2.cat_father_id = c1.cat_id and c2.hidden=0

where
c1.cat_father_id=0 and c1.hidden=0 order by c1.weight, c2.weight asc

============ 2026-06-07 01:49:36 ============
Query #50
Time:0.00061107
Query:
(SELECT basket.*, products.prod_url as prod_url2, products.id as pid FROM basket inner join products on products.prod_id=basket.product_id WHERE session_id = '3de35d00b2de9c7323b623995fc9ccb3' AND basket.is_=0)

union

(SELECT basket.*, paketa_prosforas.p_url as prod_url2, paketa_prosforas.pack_code as pid FROM basket inner join paketa_prosforas on paketa_prosforas.pack_code=basket.product_id WHERE session_id = '3de35d00b2de9c7323b623995fc9ccb3' AND basket.is_=1)

============ 2026-06-07 01:49:36 ============
Query #51
Time:0.00011706
Query:select * from central_banner where position='entrypopup' and image<>'' and status='1' order by weight asc limit 1

============ 2026-06-07 01:49:36 ============
Query #52
Time:7.486E-5
Query:select * from central_banner where position='exitpopup' and image<>'' and status='1' order by weight asc limit 1