DELETE FROM `customer_session` WHERE UNIX_TIMESTAMP(`time`) < (UNIX_TIMESTAMP()-7200)
7.993 ms
4
DELETE FROM `recover_password` WHERE UNIX_TIMESTAMP(`expiry_time`) < (UNIX_TIMESTAMP()-172800)
0.219 ms
5
SELECT `sid`,`username`,UNIX_TIMESTAMP(`time`) as `timestamp` FROM `customer_session` WHERE `sid`='5786dcf6c9692604730b7d7644e7f8fb' AND `fingerprint`='ad14650a33122e18c5520c49be94d402'
0.39 ms
6
UPDATE `customer_session` SET `time`='20100730115352', `username`='guest' WHERE `sid`='5786dcf6c9692604730b7d7644e7f8fb' AND `fingerprint`='ad14650a33122e18c5520c49be94d402' LIMIT 1
0.426 ms
7
SELECT `sid`,`username`,UNIX_TIMESTAMP(`time`) as `timestamp` FROM `customer_session` WHERE `sid`='5786dcf6c9692604730b7d7644e7f8fb' AND `fingerprint`='ad14650a33122e18c5520c49be94d402'
0.342 ms
8
SELECT *,UNIX_TIMESTAMP(`time`) as `timestamp` FROM `customer_session` WHERE `sid`='5786dcf6c9692604730b7d7644e7f8fb' AND `fingerprint`='ad14650a33122e18c5520c49be94d402'
0.491 ms
9
SELECT `id` FROM `orders` WHERE `sid` = '5786dcf6c9692604730b7d7644e7f8fb' AND `fingerprint`='ad14650a33122e18c5520c49be94d402' ORDER BY `id` DESC LIMIT 1
0.7 ms
10
SELECT `discount` FROM `customer_session` WHERE `sid`='5786dcf6c9692604730b7d7644e7f8fb' AND `fingerprint`='ad14650a33122e18c5520c49be94d402' LIMIT 1
0.339 ms
11
SELECT *,UNIX_TIMESTAMP(`time`) as `timestamp` FROM `customer_session` WHERE `sid`='5786dcf6c9692604730b7d7644e7f8fb' AND `fingerprint`='ad14650a33122e18c5520c49be94d402'
0.691 ms
12
SELECT `sid`,`username`,UNIX_TIMESTAMP(`time`) as `timestamp` FROM `customer_session` WHERE `sid`='5786dcf6c9692604730b7d7644e7f8fb' AND `fingerprint`='ad14650a33122e18c5520c49be94d402'
0.439 ms
13
UPDATE `customer_session` SET `time`='20100730115352', `username`='guest' WHERE `sid`='5786dcf6c9692604730b7d7644e7f8fb' AND `fingerprint`='ad14650a33122e18c5520c49be94d402' LIMIT 1
0.314 ms
14
SELECT `sid`,`username`,UNIX_TIMESTAMP(`time`) as `timestamp` FROM `customer_session` WHERE `sid`='5786dcf6c9692604730b7d7644e7f8fb' AND `fingerprint`='ad14650a33122e18c5520c49be94d402'
0.348 ms
15
SELECT * FROM `countries` ORDER BY `country_name`
0.358 ms
16
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`