DELETE FROM `customer_session` WHERE UNIX_TIMESTAMP(`time`) < (UNIX_TIMESTAMP()-7200)
4.545 ms
6
DELETE FROM `recover_password` WHERE UNIX_TIMESTAMP(`expiry_time`) < (UNIX_TIMESTAMP()-172800)
0.311 ms
7
SELECT `sid`,`username`,UNIX_TIMESTAMP(`time`) as `timestamp` FROM `customer_session` WHERE `sid`='e78c08eb65736d2bb9ebf380e79a4440' AND `fingerprint`='6279b224a0785e9bd27f39a977553428'
SELECT `sid`,`username`,UNIX_TIMESTAMP(`time`) as `timestamp` FROM `customer_session` WHERE `sid`='e78c08eb65736d2bb9ebf380e79a4440' AND `fingerprint`='6279b224a0785e9bd27f39a977553428'
0.209 ms
10
SELECT *,UNIX_TIMESTAMP(`time`) as `timestamp` FROM `customer_session` WHERE `sid`='e78c08eb65736d2bb9ebf380e79a4440' AND `fingerprint`='6279b224a0785e9bd27f39a977553428'
0.304 ms
11
SELECT `id` FROM `orders` WHERE `sid` = 'e78c08eb65736d2bb9ebf380e79a4440' AND `fingerprint`='6279b224a0785e9bd27f39a977553428' ORDER BY `id` DESC LIMIT 1
0.682 ms
12
SELECT `discount` FROM `customer_session` WHERE `sid`='e78c08eb65736d2bb9ebf380e79a4440' AND `fingerprint`='6279b224a0785e9bd27f39a977553428' LIMIT 1
0.215 ms
13
SELECT *,UNIX_TIMESTAMP(`time`) as `timestamp` FROM `customer_session` WHERE `sid`='e78c08eb65736d2bb9ebf380e79a4440' AND `fingerprint`='6279b224a0785e9bd27f39a977553428'
0.408 ms
14
SELECT `sid`,`username`,UNIX_TIMESTAMP(`time`) as `timestamp` FROM `customer_session` WHERE `sid`='e78c08eb65736d2bb9ebf380e79a4440' AND `fingerprint`='6279b224a0785e9bd27f39a977553428'
0.237 ms
15
UPDATE `customer_session` SET `time`='20081011123400', `username`='guest' WHERE `sid`='e78c08eb65736d2bb9ebf380e79a4440' AND `fingerprint`='6279b224a0785e9bd27f39a977553428' LIMIT 1
0.212 ms
16
SELECT `sid`,`username`,UNIX_TIMESTAMP(`time`) as `timestamp` FROM `customer_session` WHERE `sid`='e78c08eb65736d2bb9ebf380e79a4440' AND `fingerprint`='6279b224a0785e9bd27f39a977553428'
0.195 ms
17
SELECT * FROM `countries` ORDER BY `country_name`
0.371 ms
18
SELECT `pachete_comandate`.`id_pachet`, `pachete_comandate`.`parent_order_id`, `pachete_comandate`.`pret`, `pachete`.`name_sr` FROM `pachete_comandate`,`pachete` WHERE `pachete_comandate`.`order_id`='0' AND `pachete_comandate`.`purchased`='0' AND `pachete_comandate`.`id_pachet`=`pachete`.`id`