[ ### CLOSE ### ]

mem usage: 0.895MB

mem usage peak: 0.955MB

mem usage true: 2MB

mem usage peak true: 2MB

Queries total count: 50

Queries total time: 0.0131655s



============ 2026-06-06 14:23:39 ============
Query #0
Time:0.000103
Query:select * from settings


============ 2026-06-06 14:23:39 ============
Query #1
Time:0.00014901
Query:select * from settings


============ 2026-06-06 14:23:39 ============
Query #2
Time:0.00017285
Query:REPLACE INTO active_guests VALUES ('216.73.217.131', '1780745019', 'Greek')


============ 2026-06-06 14:23:39 ============
Query #3
Time:0.00024986
Query:SELECT * FROM active_guests


============ 2026-06-06 14:23:39 ============
Query #4
Time:6.986E-5
Query:DELETE FROM active_users WHERE timestamp < '1780743519'


============ 2026-06-06 14:23:39 ============
Query #5
Time:4.601E-5
Query:SELECT * FROM active_users


============ 2026-06-06 14:23:39 ============
Query #6
Time:0.00011301
Query:DELETE FROM active_guests WHERE timestamp < '1780744419'


============ 2026-06-06 14:23:39 ============
Query #7
Time:0.00019479
Query:SELECT * FROM active_guests


============ 2026-06-06 14:23:39 ============
Query #8
Time:0.00015688
Query:SELECT id from sessions where session_id = '2b65cd0a6b64d32b908418a9450759ac' and last_active >= (1780745019 - 1800)


============ 2026-06-06 14:23:39 ============
Query #9
Time:0.000103
Query:UPDATE basket set last_active='2026-06-06 14:23:39' WHERE session_id = '2b65cd0a6b64d32b908418a9450759ac'


============ 2026-06-06 14:23:39 ============
Query #10
Time:9.513E-5
Query:UPDATE sessions set last_active='1780745019', referrer='', page='/ell/brands/Green-Care-Professional/1' where session_id = '2b65cd0a6b64d32b908418a9450759ac'


============ 2026-06-06 14:23:39 ============
Query #11
Time:7.296E-5
Query:delete from sessions WHERE last_active < (UNIX_TIMESTAMP()-1800);


============ 2026-06-06 14:23:39 ============
Query #12
Time:6.39E-5
Query:delete from basket where last_active < '2026-05-07 14:23:39'


============ 2026-06-06 14:23:39 ============
Query #13
Time:4.411E-5
Query:SELECT * FROM active_users


============ 2026-06-06 14:23:39 ============
Query #14
Time:0.00018907
Query:SELECT * FROM active_guests


============ 2026-06-06 14:23:39 ============
Query #15
Time:5.603E-5
Query:select * from settings


============ 2026-06-06 14:23:39 ============
Query #16
Time:5.603E-5
Query:SELECT * FROM tags


============ 2026-06-06 14:23:39 ============
Query #17
Time:5.007E-5
Query:SELECT * FROM availability


============ 2026-06-06 14:23:39 ============
Query #18
Time:5.412E-5
Query:select * from settings_tracking


============ 2026-06-06 14:23:39 ============
Query #19
Time:9.298E-5
Query:SELECT * FROM misctexts where lang='Greek' order by text_id asc


============ 2026-06-06 14:23:39 ============
Query #20
Time:0.00041604
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-06 14:23:39 ============
Query #21
Time:9.108E-5
Query:select synckey from prodcat_weight_sync where synckey = 'uuOmEpwxB7C9xt7l7OTt'


============ 2026-06-06 14:23:39 ============
Query #22
Time:0.00101805
Query:delete from prodcat_weight_sync where prod_id not in (select prod_id from products)


============ 2026-06-06 14:23:39 ============
Query #23
Time:0.00312686
Query:insert ignore into prodcat_weight_sync (prod_id, synckey, synctime) select prod_id, '', '2000-01-01 00:00:00' from products


============ 2026-06-06 14:23:39 ============
Query #24
Time:8.607E-5
Query:update prodcat_weight_sync set synckey='uuOmEpwxB7C9xt7l7OTt', synctime=NOW() where synctime < '2026-06-06 13:23:39' limit 10


============ 2026-06-06 14:23:39 ============
Query #25
Time:0.000458
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='uuOmEpwxB7C9xt7l7OTt' group by products.id


============ 2026-06-06 14:23:39 ============
Query #26
Time:9.584E-5
Query:select * from suppliers where supplier_url='Green-Care-Professional'


============ 2026-06-06 14:23:39 ============
Query #27
Time:0.00068712
Query:select categories.category, categories.cat_url from products inner join prodcat_weight on products.prod_id=prodcat_weight.prod_id inner join categories on prodcat_weight.cat_id=categories.cat_id where categories.hidden=0 and products.hidden=0 and products.supplier='4236' group by categories.cat_id order by category asc


============ 2026-06-06 14:23:39 ============
Query #28
Time:0.00030708
Query:SELECT count(*) as total from products WHERE hidden='0' and supplier='4236'


============ 2026-06-06 14:23:39 ============
Query #29
Time:0.00142789
Query:SELECT products.*, min(products_atts.price) as pricefrom, min(products_atts.pricex) as pricefromx, count(products_atts.product_id) as attcount, products_images.filename as thefile from products 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 products.hidden='0' and products.supplier='4236' group by products.id order by weight_supplier ASC, id desc LIMIT 0, 15


============ 2026-06-06 14:23:39 ============
Query #30
Time:0.00012112
Query:SELECT * FROM products_images where prod_id='1774201669' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 14:23:39 ============
Query #31
Time:9.99E-5
Query:SELECT * FROM products_images where prod_id='1774197661' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 14:23:39 ============
Query #32
Time:9.918E-5
Query:SELECT * FROM products_images where prod_id='1774095418' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 14:23:39 ============
Query #33
Time:8.893E-5
Query:SELECT * FROM products_images where prod_id='1774093295' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 14:23:39 ============
Query #34
Time:9.084E-5
Query:SELECT * FROM products_images where prod_id='1774091854' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 14:23:39 ============
Query #35
Time:9.799E-5
Query:SELECT * FROM products_images where prod_id='1773336901' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 14:23:39 ============
Query #36
Time:9.799E-5
Query:SELECT * FROM products_images where prod_id='1771184045' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 14:23:39 ============
Query #37
Time:0.0001018
Query:SELECT * FROM products_images where prod_id='1738706268' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 14:23:39 ============
Query #38
Time:0.000103
Query:SELECT * FROM products_images where prod_id='1738703837' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 14:23:39 ============
Query #39
Time:0.00010395
Query:SELECT * FROM products_images where prod_id='1738701039' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 14:23:39 ============
Query #40
Time:0.00011206
Query:SELECT * FROM products_images where prod_id='1738522955' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 14:23:39 ============
Query #41
Time:0.000108
Query:SELECT * FROM products_images where prod_id='1738451194' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 14:23:39 ============
Query #42
Time:0.00010991
Query:SELECT * FROM products_images where prod_id='1738449585' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 14:23:39 ============
Query #43
Time:9.99E-5
Query:SELECT * FROM products_images where prod_id='1738447847' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 14:23:39 ============
Query #44
Time:0.00010014
Query:SELECT * FROM products_images where prod_id='1738446644' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 14:23:39 ============
Query #45
Time:0.0004921
Query:
SELECT
c1.category as c1_category, c1.cat_url as c1_cat_url, 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 as c2_category, c2.cat_url as c2_cat_url, 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-06 14:23:39 ============
Query #46
Time:0.00048304
Query:
SELECT
c1.category as c1_category, c1.cat_url as c1_cat_url, 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 as c2_category, c2.cat_url as c2_cat_url, 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-06 14:23:39 ============
Query #47
Time:0.00062203
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 = '2b65cd0a6b64d32b908418a9450759ac' 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 = '2b65cd0a6b64d32b908418a9450759ac' AND basket.is_=1)



============ 2026-06-06 14:23:39 ============
Query #48
Time:0.0001111
Query:select * from central_banner where position='entrypopup' and image<>'' and status='1' order by weight asc limit 1


============ 2026-06-06 14:23:39 ============
Query #49
Time:7.582E-5
Query:select * from central_banner where position='exitpopup' and image<>'' and status='1' order by weight asc limit 1