[ ### CLOSE ### ]

mem usage: 0.801MB

mem usage peak: 0.855MB

mem usage true: 2MB

mem usage peak true: 2MB

Queries total count: 62

Queries total time: 0.02056793s



============ 2026-06-06 00:45:29 ============
Query #0
Time:0.00014281
Query:select * from settings


============ 2026-06-06 00:45:29 ============
Query #1
Time:7.701E-5
Query:select * from settings


============ 2026-06-06 00:45:29 ============
Query #2
Time:0.0001061
Query:REPLACE INTO active_guests VALUES ('216.73.217.131', '1780695929', 'Greek')


============ 2026-06-06 00:45:29 ============
Query #3
Time:9.298E-5
Query:SELECT * FROM active_guests


============ 2026-06-06 00:45:29 ============
Query #4
Time:6.39E-5
Query:DELETE FROM active_users WHERE timestamp < '1780694429'


============ 2026-06-06 00:45:29 ============
Query #5
Time:4.101E-5
Query:SELECT * FROM active_users


============ 2026-06-06 00:45:29 ============
Query #6
Time:6.199E-5
Query:DELETE FROM active_guests WHERE timestamp < '1780695329'


============ 2026-06-06 00:45:29 ============
Query #7
Time:6.294E-5
Query:SELECT * FROM active_guests


============ 2026-06-06 00:45:29 ============
Query #8
Time:0.00015593
Query:SELECT id from sessions where session_id = '8c6f9a67115f31f036f576c3d996a3d8' and last_active >= (1780695929 - 1800)


============ 2026-06-06 00:45:29 ============
Query #9
Time:0.00012016
Query:UPDATE basket set last_active='2026-06-06 00:45:29' WHERE session_id = '8c6f9a67115f31f036f576c3d996a3d8'


============ 2026-06-06 00:45:29 ============
Query #10
Time:6.604E-5
Query:DELETE FROM sessions WHERE session_id = '8c6f9a67115f31f036f576c3d996a3d8'


============ 2026-06-06 00:45:29 ============
Query #11
Time:9.894E-5
Query:INSERT INTO sessions (session_id, ip_address, referrer, page, last_active) VALUES ('8c6f9a67115f31f036f576c3d996a3d8', '216.73.217.131', '', '/ell/categories/Epaggelmatikes-Syskeyes-Xartioy/all/Toixos_Pagkos_Xeiropetseta-Multifold-W-Fold/1', '1780695929')


============ 2026-06-06 00:45:29 ============
Query #12
Time:7.01E-5
Query:delete from sessions WHERE last_active < (UNIX_TIMESTAMP()-1800);


============ 2026-06-06 00:45:29 ============
Query #13
Time:6.986E-5
Query:delete from basket where last_active < '2026-05-07 00:45:29'


============ 2026-06-06 00:45:29 ============
Query #14
Time:4.387E-5
Query:SELECT * FROM active_users


============ 2026-06-06 00:45:29 ============
Query #15
Time:6.7E-5
Query:SELECT * FROM active_guests


============ 2026-06-06 00:45:29 ============
Query #16
Time:5.293E-5
Query:select * from settings


============ 2026-06-06 00:45:29 ============
Query #17
Time:5.484E-5
Query:SELECT * FROM tags


============ 2026-06-06 00:45:29 ============
Query #18
Time:4.601E-5
Query:SELECT * FROM availability


============ 2026-06-06 00:45:29 ============
Query #19
Time:5.317E-5
Query:select * from settings_tracking


============ 2026-06-06 00:45:29 ============
Query #20
Time:9.203E-5
Query:SELECT * FROM misctexts where lang='Greek' order by text_id asc


============ 2026-06-06 00:45:29 ============
Query #21
Time:0.00050402
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 00:45:29 ============
Query #22
Time:0.00013804
Query:select synckey from prodcat_weight_sync where synckey = 'tJH4VxzkOYp2TuJmlzuf'


============ 2026-06-06 00:45:29 ============
Query #23
Time:0.00109482
Query:delete from prodcat_weight_sync where prod_id not in (select prod_id from products)


============ 2026-06-06 00:45:29 ============
Query #24
Time:0.00668478
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 00:45:29 ============
Query #25
Time:0.00044894
Query:update prodcat_weight_sync set synckey='tJH4VxzkOYp2TuJmlzuf', synctime=NOW() where synctime < '2026-06-05 23:45:29' limit 10


============ 2026-06-06 00:45:29 ============
Query #26
Time:0.00089693
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='tJH4VxzkOYp2TuJmlzuf' group by products.id


============ 2026-06-06 00:45:29 ============
Query #27
Time:0.000103
Query:update prodcat_weight set price='98.49' where prod_id='1768728623'


============ 2026-06-06 00:45:29 ============
Query #28
Time:5.794E-5
Query:update prodcat_weight set price='4.65' where prod_id='1768918829'


============ 2026-06-06 00:45:29 ============
Query #29
Time:4.911E-5
Query:update prodcat_weight set price='21.60' where prod_id='1769243863'


============ 2026-06-06 00:45:29 ============
Query #30
Time:5.198E-5
Query:update prodcat_weight set price='7.90' where prod_id='1769254297'


============ 2026-06-06 00:45:29 ============
Query #31
Time:4.697E-5
Query:update prodcat_weight set price='23.99' where prod_id='1769458944'


============ 2026-06-06 00:45:29 ============
Query #32
Time:4.697E-5
Query:update prodcat_weight set price='51.50' where prod_id='1769610859'


============ 2026-06-06 00:45:29 ============
Query #33
Time:5.102E-5
Query:update prodcat_weight set price='65.15' where prod_id='1769611467'


============ 2026-06-06 00:45:29 ============
Query #34
Time:4.387E-5
Query:update prodcat_weight set price='21.35' where prod_id='1769710006'


============ 2026-06-06 00:45:29 ============
Query #35
Time:4.792E-5
Query:update prodcat_weight set price='20.19' where prod_id='1769852135'


============ 2026-06-06 00:45:29 ============
Query #36
Time:4.792E-5
Query:update prodcat_weight set price='30.15' where prod_id='1769853705'


============ 2026-06-06 00:45:29 ============
Query #37
Time:0.00015187
Query:SELECT * FROM categories WHERE cat_url='Epaggelmatikes-Syskeyes-Xartioy' and lang='Greek' and hidden='0'


============ 2026-06-06 00:45:29 ============
Query #38
Time:0.00021911
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=818 and t1.hidden=0 order by lev1,lev2,lev3,lev4,lev5 asc


============ 2026-06-06 00:45:29 ============
Query #39
Time:0.00228596
Query:SELECT max(price) as mp1 FROM prodcat_weight WHERE prod_id in (select prod_id from prodcat_weight where cat_id in (818)) and hidden=0


============ 2026-06-06 00:45:29 ============
Query #40
Time:0.00014496
Query:
SELECT
c1.category as c1_category, c1.cat_url as c1_cat_url, c1.cat_id as c1_cat_id, c2.category as c2_category, c2.cat_url as c2_cat_url, c2.cat_id as c2_cat_id, c3.category as c3_category, c3.cat_url as c3_cat_url, c3.cat_id as c3_cat_id, c4.category as c4_category, c4.cat_url as c4_cat_url, c4.cat_id as c4_cat_id, c5.category as c5_category, c5.cat_url as c5_cat_url, c5.cat_id as c5_cat_id, c6.category as c6_category, c6.cat_url as c6_cat_url, 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='818'



============ 2026-06-06 00:45:29 ============
Query #41
Time:0.00010014
Query:SELECT cat_id , category, cat_url, cat_image FROM categories WHERE cat_father_id='818' and hidden=0 ORDER BY weight asc


============ 2026-06-06 00:45:29 ============
Query #42
Time:0.00011706
Query:select * from filters where filter_url='Toixos' or filter_url='Pagkos' or filter_url='Xeiropetseta-Multifold-W-Fold'


============ 2026-06-06 00:45:29 ============
Query #43
Time:0.00017214
Query:SELECT `groups`.* FROM `groups` order by weight asc


============ 2026-06-06 00:45:29 ============
Query #44
Time:0.00058413
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 suppliers on suppliers.sid=products.supplier WHERE prodcat_weight.cat_id in (818) and prodcat_weight.hidden='0' and ((fl1.filter_id='191' or fl1.filter_id='190') and (fl2.filter_id='182') ) group by products.supplier


============ 2026-06-06 00:45:29 ============
Query #45
Time:0.00056887
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 on products_filters.product_id=products.id inner join filters on products_filters.filter_id=filters.id WHERE prodcat_weight.cat_id in (818) and prodcat_weight.hidden='0' and ((fl1.filter_id='191' or fl1.filter_id='190') and (fl2.filter_id='182') ) group by filters.id order by filters.weight asc


============ 2026-06-06 00:45:29 ============
Query #46
Time:0.00013018
Query:select * from central_banner where image<>'' and lang='Greek' and position='category' and status='1' order by weight asc


============ 2026-06-06 00:45:29 ============
Query #47
Time:0.00028491
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 WHERE prodcat_weight.cat_id in (818) and prodcat_weight.hidden='0' and ((fl1.filter_id='191' or fl1.filter_id='190') and (fl2.filter_id='182') )


============ 2026-06-06 00:45:29 ============
Query #48
Time:0.00093508
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 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 (818) and prodcat_weight.hidden='0' and ((fl1.filter_id='191' or fl1.filter_id='190') and (fl2.filter_id='182') ) group by products.id order by prodcat_weight.weight ASC, id desc LIMIT 0, 15


============ 2026-06-06 00:45:29 ============
Query #49
Time:0.00013399
Query:SELECT * FROM products_images where prod_id='1646646522' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 00:45:29 ============
Query #50
Time:0.00011492
Query:SELECT * FROM products_images where prod_id='1646132103' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 00:45:29 ============
Query #51
Time:0.00011611
Query:SELECT * FROM products_images where prod_id='1646650096' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 00:45:29 ============
Query #52
Time:0.00011301
Query:SELECT * FROM products_images where prod_id='1684845534' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 00:45:29 ============
Query #53
Time:0.00010514
Query:SELECT * FROM products_images where prod_id='1685891382' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 00:45:29 ============
Query #54
Time:0.00010991
Query:SELECT * FROM products_images where prod_id='1646651806' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 00:45:29 ============
Query #55
Time:9.99E-5
Query:SELECT * FROM products_images where prod_id='1646137256' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 00:45:29 ============
Query #56
Time:0.00010705
Query:SELECT * FROM products_images where prod_id='1678039249' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 00:45:29 ============
Query #57
Time:0.0005312
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 00:45:29 ============
Query #58
Time:0.00059605
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 00:45:29 ============
Query #59
Time:0.00070214
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 = '8c6f9a67115f31f036f576c3d996a3d8' 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 = '8c6f9a67115f31f036f576c3d996a3d8' AND basket.is_=1)



============ 2026-06-06 00:45:29 ============
Query #60
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 00:45:29 ============
Query #61
Time:7.915E-5
Query:select * from central_banner where position='exitpopup' and image<>'' and status='1' order by weight asc limit 1