[ ### CLOSE ### ]

mem usage: 0.664MB

mem usage peak: 0.7MB

mem usage true: 2MB

mem usage peak true: 2MB

Queries total count: 35

Queries total time: 0.01459719s



============ 2026-06-05 19:27:00 ============
Query #0
Time:8.392E-5
Query:select * from settings


============ 2026-06-05 19:27:00 ============
Query #1
Time:0.0001502
Query:select * from settings


============ 2026-06-05 19:27:00 ============
Query #2
Time:0.00014806
Query:REPLACE INTO active_guests VALUES ('216.73.217.131', '1780676820', 'Greek')


============ 2026-06-05 19:27:00 ============
Query #3
Time:0.00010014
Query:SELECT * FROM active_guests


============ 2026-06-05 19:27:00 ============
Query #4
Time:4.816E-5
Query:DELETE FROM active_users WHERE timestamp < '1780675320'


============ 2026-06-05 19:27:00 ============
Query #5
Time:4.196E-5
Query:SELECT * FROM active_users


============ 2026-06-05 19:27:00 ============
Query #6
Time:6.104E-5
Query:DELETE FROM active_guests WHERE timestamp < '1780676220'


============ 2026-06-05 19:27:00 ============
Query #7
Time:6.795E-5
Query:SELECT * FROM active_guests


============ 2026-06-05 19:27:00 ============
Query #8
Time:0.00013709
Query:SELECT id from sessions where session_id = '4924da4d2731d6999f0c2c2b91a5882a' and last_active >= (1780676820 - 1800)


============ 2026-06-05 19:27:00 ============
Query #9
Time:0.000108
Query:UPDATE basket set last_active='2026-06-05 19:27:00' WHERE session_id = '4924da4d2731d6999f0c2c2b91a5882a'


============ 2026-06-05 19:27:00 ============
Query #10
Time:9.108E-5
Query:UPDATE sessions set last_active='1780676820', referrer='', page='/ell/blog//all/oikologika-aporrypantika/1' where session_id = '4924da4d2731d6999f0c2c2b91a5882a'


============ 2026-06-05 19:27:00 ============
Query #11
Time:0.0001359
Query:delete from sessions WHERE last_active < (UNIX_TIMESTAMP()-1800);


============ 2026-06-05 19:27:00 ============
Query #12
Time:7.391E-5
Query:delete from basket where last_active < '2026-05-06 19:27:00'


============ 2026-06-05 19:27:00 ============
Query #13
Time:4.482E-5
Query:SELECT * FROM active_users


============ 2026-06-05 19:27:00 ============
Query #14
Time:7.2E-5
Query:SELECT * FROM active_guests


============ 2026-06-05 19:27:00 ============
Query #15
Time:5.698E-5
Query:select * from settings


============ 2026-06-05 19:27:00 ============
Query #16
Time:5.388E-5
Query:SELECT * FROM tags


============ 2026-06-05 19:27:00 ============
Query #17
Time:4.697E-5
Query:SELECT * FROM availability


============ 2026-06-05 19:27:00 ============
Query #18
Time:5.198E-5
Query:select * from settings_tracking


============ 2026-06-05 19:27:00 ============
Query #19
Time:8.988E-5
Query:SELECT * FROM misctexts where lang='Greek' order by text_id asc


============ 2026-06-05 19:27:00 ============
Query #20
Time:0.00047588
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-05 19:27:00 ============
Query #21
Time:0.00012803
Query:select synckey from prodcat_weight_sync where synckey = 'DTOFJjVwR8S3wFwThz2O'


============ 2026-06-05 19:27:00 ============
Query #22
Time:0.00106001
Query:delete from prodcat_weight_sync where prod_id not in (select prod_id from products)


============ 2026-06-05 19:27:00 ============
Query #23
Time:0.00652695
Query:insert ignore into prodcat_weight_sync (prod_id, synckey, synctime) select prod_id, '', '2000-01-01 00:00:00' from products


============ 2026-06-05 19:27:00 ============
Query #24
Time:8.512E-5
Query:update prodcat_weight_sync set synckey='DTOFJjVwR8S3wFwThz2O', synctime=NOW() where synctime < '2026-06-05 18:27:00' limit 10


============ 2026-06-05 19:27:00 ============
Query #25
Time:0.00051999
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='DTOFJjVwR8S3wFwThz2O' group by products.id


============ 2026-06-05 19:27:00 ============
Query #26
Time:0.00105405
Query:SELECT t1.category AS lev1, t1.cat_url AS clev1, t2.category as lev2, t2.cat_url AS clev2, t3.category as lev3, t3.cat_url AS clev3, t4.category as lev4, t4.cat_url AS clev4, t5.category as lev5, t5.cat_url AS clev5, t6.category as lev6, t6.cat_url AS clev6, t7.category as lev7, t7.cat_url AS clev7, t8.category as lev8, t8.cat_url AS clev8, t9.category as lev9, t9.cat_url AS clev9, t10.category as lev10, t10.cat_url AS clev10
FROM categories2 AS t1
LEFT JOIN categories2 AS t2 ON t2.cat_father_id = t1.cat_id and t2.hidden=0
LEFT JOIN categories2 AS t3 ON t3.cat_father_id = t2.cat_id and t3.hidden=0
LEFT JOIN categories2 AS t4 ON t4.cat_father_id = t3.cat_id and t4.hidden=0
LEFT JOIN categories2 AS t5 ON t5.cat_father_id = t4.cat_id and t5.hidden=0
LEFT JOIN categories2 AS t6 ON t6.cat_father_id = t5.cat_id and t6.hidden=0
LEFT JOIN categories2 AS t7 ON t7.cat_father_id = t6.cat_id and t7.hidden=0
LEFT JOIN categories2 AS t8 ON t8.cat_father_id = t7.cat_id and t8.hidden=0
LEFT JOIN categories2 AS t9 ON t9.cat_father_id = t8.cat_id and t9.hidden=0
LEFT JOIN categories2 AS t10 ON t10.cat_father_id = t9.cat_id and t10.hidden=0
where t1.cat_father_id=0 and t1.hidden=0 order by t1.weight,t2.weight,t3.weight,t4.weight,t5.weight,t6.weight,t7.weight,t8.weight,t9.weight,t10.weight asc


============ 2026-06-05 19:27:00 ============
Query #27
Time:0.00044298
Query:SELECT tag_title, tag_url from products2_tags where prod_id in (select id FROM products2 WHERE lang='Greek' and hidden='0') group by tag_title order by tag_title asc


============ 2026-06-05 19:27:00 ============
Query #28
Time:0.00020099
Query:SELECT * FROM products2 WHERE lang='Greek' and hidden='0' and id in (select prod_id from products2_tags where tag_url='oikologika-aporrypantika')


============ 2026-06-05 19:27:00 ============
Query #29
Time:0.00041795
Query: SELECT * FROM products2 WHERE lang='Greek' and hidden=0 and id in (select prod_id from products2_tags where tag_url='oikologika-aporrypantika') order by weight asc LIMIT 0, 15


============ 2026-06-05 19:27:00 ============
Query #30
Time:0.00054908
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-05 19:27:00 ============
Query #31
Time:0.00059009
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-05 19:27:00 ============
Query #32
Time:0.00069308
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 = '4924da4d2731d6999f0c2c2b91a5882a' 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 = '4924da4d2731d6999f0c2c2b91a5882a' AND basket.is_=1)



============ 2026-06-05 19:27:00 ============
Query #33
Time:0.00011206
Query:select * from central_banner where position='entrypopup' and image<>'' and status='1' order by weight asc limit 1


============ 2026-06-05 19:27:00 ============
Query #34
Time:7.701E-5
Query:select * from central_banner where position='exitpopup' and image<>'' and status='1' order by weight asc limit 1