[ ### CLOSE ### ]

mem usage: 0.983MB

mem usage peak: 0.994MB

mem usage true: 2MB

mem usage peak true: 2MB

Queries total count: 65

Queries total time: 0.0135348s



============ 2026-06-06 12:43:35 ============
Query #0
Time:0.000144
Query:select * from settings


============ 2026-06-06 12:43:35 ============
Query #1
Time:7.391E-5
Query:select * from settings


============ 2026-06-06 12:43:35 ============
Query #2
Time:0.0001049
Query:REPLACE INTO active_guests VALUES ('216.73.217.131', '1780739015', 'Greek')


============ 2026-06-06 12:43:35 ============
Query #3
Time:9.203E-5
Query:SELECT * FROM active_guests


============ 2026-06-06 12:43:35 ============
Query #4
Time:5.913E-5
Query:DELETE FROM active_users WHERE timestamp < '1780737515'


============ 2026-06-06 12:43:35 ============
Query #5
Time:3.982E-5
Query:SELECT * FROM active_users


============ 2026-06-06 12:43:35 ============
Query #6
Time:6.008E-5
Query:DELETE FROM active_guests WHERE timestamp < '1780738415'


============ 2026-06-06 12:43:35 ============
Query #7
Time:7.081E-5
Query:SELECT * FROM active_guests


============ 2026-06-06 12:43:35 ============
Query #8
Time:0.00015283
Query:SELECT id from sessions where session_id = 'ebf001d71ce591dfe35fb971efb67db1' and last_active >= (1780739015 - 1800)


============ 2026-06-06 12:43:35 ============
Query #9
Time:0.00010395
Query:UPDATE basket set last_active='2026-06-06 12:43:35' WHERE session_id = 'ebf001d71ce591dfe35fb971efb67db1'


============ 2026-06-06 12:43:35 ============
Query #10
Time:9.99E-5
Query:UPDATE sessions set last_active='1780739015', referrer='', page='/ell/product/Kimberly-Clark-syskeyi-sapoynioy-se-afro' where session_id = 'ebf001d71ce591dfe35fb971efb67db1'


============ 2026-06-06 12:43:35 ============
Query #11
Time:0.00011086
Query:delete from sessions WHERE last_active < (UNIX_TIMESTAMP()-1800);


============ 2026-06-06 12:43:35 ============
Query #12
Time:6.509E-5
Query:delete from basket where last_active < '2026-05-07 12:43:35'


============ 2026-06-06 12:43:35 ============
Query #13
Time:4.292E-5
Query:SELECT * FROM active_users


============ 2026-06-06 12:43:35 ============
Query #14
Time:6.986E-5
Query:SELECT * FROM active_guests


============ 2026-06-06 12:43:35 ============
Query #15
Time:5.412E-5
Query:select * from settings


============ 2026-06-06 12:43:35 ============
Query #16
Time:5.388E-5
Query:SELECT * FROM tags


============ 2026-06-06 12:43:35 ============
Query #17
Time:4.506E-5
Query:SELECT * FROM availability


============ 2026-06-06 12:43:35 ============
Query #18
Time:6.008E-5
Query:select * from settings_tracking


============ 2026-06-06 12:43:35 ============
Query #19
Time:9.704E-5
Query:SELECT * FROM misctexts where lang='Greek' order by text_id asc


============ 2026-06-06 12:43:35 ============
Query #20
Time:0.00041294
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 12:43:35 ============
Query #21
Time:0.00011492
Query:select synckey from prodcat_weight_sync where synckey = '1VEmYid9N1PYAOdDLVly'


============ 2026-06-06 12:43:35 ============
Query #22
Time:0.00100613
Query:delete from prodcat_weight_sync where prod_id not in (select prod_id from products)


============ 2026-06-06 12:43:35 ============
Query #23
Time:0.00312281
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 12:43:35 ============
Query #24
Time:0.00024199
Query:update prodcat_weight_sync set synckey='1VEmYid9N1PYAOdDLVly', synctime=NOW() where synctime < '2026-06-06 11:43:35' limit 10


============ 2026-06-06 12:43:35 ============
Query #25
Time:0.00069284
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='1VEmYid9N1PYAOdDLVly' group by products.id


============ 2026-06-06 12:43:35 ============
Query #26
Time:7.892E-5
Query:update prodcat_weight set price='14.65' where prod_id='1646049012'


============ 2026-06-06 12:43:35 ============
Query #27
Time:5.293E-5
Query:update prodcat_weight set price='19.20' where prod_id='1646050834'


============ 2026-06-06 12:43:35 ============
Query #28
Time:5.102E-5
Query:update prodcat_weight set price='14.72' where prod_id='1646061238'


============ 2026-06-06 12:43:35 ============
Query #29
Time:4.506E-5
Query:update prodcat_weight set price='9.47' where prod_id='1646062991'


============ 2026-06-06 12:43:35 ============
Query #30
Time:4.387E-5
Query:update prodcat_weight set price='74.12' where prod_id='1646068956'


============ 2026-06-06 12:43:35 ============
Query #31
Time:4.482E-5
Query:update prodcat_weight set price='114.59' where prod_id='1646070939'


============ 2026-06-06 12:43:35 ============
Query #32
Time:4.292E-5
Query:update prodcat_weight set price='15.27' where prod_id='1646071688'


============ 2026-06-06 12:43:35 ============
Query #33
Time:4.22E-5
Query:update prodcat_weight set price='154.05' where prod_id='1646072187'


============ 2026-06-06 12:43:35 ============
Query #34
Time:4.005E-5
Query:update prodcat_weight set price='131.21' where prod_id='1646072830'


============ 2026-06-06 12:43:35 ============
Query #35
Time:4.506E-5
Query:update prodcat_weight set price='1.38' where prod_id='1647686106'


============ 2026-06-06 12:43:35 ============
Query #36
Time:0.00019813
Query:SELECT * FROM products WHERE prod_url='Kimberly-Clark-syskeyi-sapoynioy-se-afro' and lang='Greek' and hidden='0'


============ 2026-06-06 12:43:35 ============
Query #37
Time:0.00012279
Query:SELECT * FROM products_images where prod_id='1648471555' ORDER BY weight, id asc


============ 2026-06-06 12:43:35 ============
Query #38
Time:0.00014687
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 and c2.hidden=0 LEFT JOIN categories AS c3 ON c3.cat_id = c2.cat_father_id and c3.hidden=0 LEFT JOIN categories AS c4 ON c4.cat_id = c3.cat_father_id and c4.hidden=0 LEFT JOIN categories AS c5 ON c5.cat_id = c4.cat_father_id and c5.hidden=0 LEFT JOIN categories AS c6 ON c6.cat_id = c5.cat_father_id and c6.hidden=0

where
c1.cat_id='819' and c1.hidden=0



============ 2026-06-06 12:43:35 ============
Query #39
Time:0.00010085
Query:SELECT * FROM products_atts where product_id='344' ORDER BY color_id, size_id, availability_id


============ 2026-06-06 12:43:35 ============
Query #40
Time:7.105E-5
Query:SELECT * FROM suppliers where sid='4216'


============ 2026-06-06 12:43:35 ============
Query #41
Time:0.00011182
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='819'



============ 2026-06-06 12:43:35 ============
Query #42
Time:6.008E-5
Query:select cat_image from categories where cat_id = 819


============ 2026-06-06 12:43:35 ============
Query #43
Time:0.0001359
Query:select products_atts.id as attrid, products_atts.price, products_atts.code, products_atts.pricex, products_atts.stock, colors.color_code, colors.color_name, availability.name, availability.canbuy, sizes.size_name , sizes.size_id AS size_id from products_atts left join colors on colors.color_id=products_atts.color_id left join sizes on sizes.size_id=products_atts.size_id left join availability on availability.id=products_atts.availability_id where products_atts.id in (8438,8439)


============ 2026-06-06 12:43:35 ============
Query #44
Time:0.00084901
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 hidden=0 AND products.prod_id IN ('1684348583', '1685891382', '1648463810', '1684845534', '1648469693', '1684330274', '1731236443', '1648472345') group by products.id ORDER BY field(products.prod_id, '1684348583', '1685891382', '1648463810', '1684845534', '1648469693', '1684330274', '1731236443', '1648472345') desc, id asc


============ 2026-06-06 12:43:35 ============
Query #45
Time:0.00012398
Query:SELECT * FROM products_images where prod_id='1648472345' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 12:43:35 ============
Query #46
Time:0.00011206
Query:SELECT * FROM products_images where prod_id='1731236443' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 12:43:35 ============
Query #47
Time:0.00010991
Query:SELECT * FROM products_images where prod_id='1684330274' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 12:43:35 ============
Query #48
Time:0.000108
Query:SELECT * FROM products_images where prod_id='1648469693' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 12:43:35 ============
Query #49
Time:0.00010705
Query:SELECT * FROM products_images where prod_id='1684845534' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 12:43:35 ============
Query #50
Time:0.0001092
Query:SELECT * FROM products_images where prod_id='1648463810' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 12:43:35 ============
Query #51
Time:0.000103
Query:SELECT * FROM products_images where prod_id='1685891382' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 12:43:35 ============
Query #52
Time:0.00053287
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 hidden=0 AND products.prod_id IN ('1648472345', '1648471555') group by products.id ORDER BY field(products.prod_id, '1648472345', '1648471555') desc, id asc


============ 2026-06-06 12:43:35 ============
Query #53
Time:0.00012302
Query:SELECT * FROM products_images where prod_id='1648471555' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 12:43:35 ============
Query #54
Time:0.000108
Query:SELECT * FROM products_images where prod_id='1648471555' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 12:43:35 ============
Query #55
Time:0.00010395
Query:SELECT * FROM products_images where prod_id='1648472345' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 12:43:35 ============
Query #56
Time:0.0001049
Query:SELECT * FROM products_images where prod_id='1648472345' and firstimg=0 ORDER BY weight, id asc limit 0,1


============ 2026-06-06 12:43:35 ============
Query #57
Time:0.00015903
Query:select group_concat(concat('

  • ' ,features.name, '
  • ') separator ' ') as fname, features_groups.name as gname from products_features inner join features on products_features.feature_id=features.id left join features_groups on features.features_group_id=features_groups.id where products_features.product_id='344' group by features.features_group_id


    ============ 2026-06-06 12:43:35 ============
    Query #58
    Time:0.00023293
    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 hidden=0 AND bundle='1' AND products.prod_id='1752312857'


    ============ 2026-06-06 12:43:35 ============
    Query #59
    Time:0.00011396
    Query:SELECT * FROM products_images where prod_id='' and firstimg=0 ORDER BY weight, id asc limit 0,1


    ============ 2026-06-06 12:43:35 ============
    Query #60
    Time:0.00047398
    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 12:43:35 ============
    Query #61
    Time:0.00050282
    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 12:43:35 ============
    Query #62
    Time:0.00064111
    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 = 'ebf001d71ce591dfe35fb971efb67db1' 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 = 'ebf001d71ce591dfe35fb971efb67db1' AND basket.is_=1)



    ============ 2026-06-06 12:43:35 ============
    Query #63
    Time:0.00011396
    Query:select * from central_banner where position='entrypopup' and image<>'' and status='1' order by weight asc limit 1


    ============ 2026-06-06 12:43:35 ============
    Query #64
    Time:7.582E-5
    Query:select * from central_banner where position='exitpopup' and image<>'' and status='1' order by weight asc limit 1