DELETE FROM `customer_session` WHERE UNIX_TIMESTAMP(`time`) < (UNIX_TIMESTAMP()-7200)
1.392 ms
4
DELETE FROM `recover_password` WHERE UNIX_TIMESTAMP(`expiry_time`) < (UNIX_TIMESTAMP()-172800)
0.172 ms
5
SELECT `sid`,`username`,UNIX_TIMESTAMP(`time`) as `timestamp` FROM `customer_session` WHERE `sid`='7c699eadbfdaa9546eb2729f9bd8631e' AND `fingerprint`='6e247f13e8820e974ea39ca4e4b1e54f'
0.31 ms
6
UPDATE `customer_session` SET `time`='20120207114003', `username`='guest' WHERE `sid`='7c699eadbfdaa9546eb2729f9bd8631e' AND `fingerprint`='6e247f13e8820e974ea39ca4e4b1e54f' LIMIT 1
0.37 ms
7
SELECT `sid`,`username`,UNIX_TIMESTAMP(`time`) as `timestamp` FROM `customer_session` WHERE `sid`='7c699eadbfdaa9546eb2729f9bd8631e' AND `fingerprint`='6e247f13e8820e974ea39ca4e4b1e54f'
0.298 ms
8
SELECT *,UNIX_TIMESTAMP(`time`) as `timestamp` FROM `customer_session` WHERE `sid`='7c699eadbfdaa9546eb2729f9bd8631e' AND `fingerprint`='6e247f13e8820e974ea39ca4e4b1e54f'
0.492 ms
9
SELECT `id` FROM `orders` WHERE `sid` = '7c699eadbfdaa9546eb2729f9bd8631e' AND `fingerprint`='6e247f13e8820e974ea39ca4e4b1e54f' ORDER BY `id` DESC LIMIT 1
10.898 ms
10
SELECT `discount` FROM `customer_session` WHERE `sid`='7c699eadbfdaa9546eb2729f9bd8631e' AND `fingerprint`='6e247f13e8820e974ea39ca4e4b1e54f' LIMIT 1
0.391 ms
11
SELECT *,UNIX_TIMESTAMP(`time`) as `timestamp` FROM `customer_session` WHERE `sid`='7c699eadbfdaa9546eb2729f9bd8631e' AND `fingerprint`='6e247f13e8820e974ea39ca4e4b1e54f'
4.877 ms
12
SELECT `sid`,`username`,UNIX_TIMESTAMP(`time`) as `timestamp` FROM `customer_session` WHERE `sid`='7c699eadbfdaa9546eb2729f9bd8631e' AND `fingerprint`='6e247f13e8820e974ea39ca4e4b1e54f'
0.46 ms
13
UPDATE `customer_session` SET `time`='20120207114003', `username`='guest' WHERE `sid`='7c699eadbfdaa9546eb2729f9bd8631e' AND `fingerprint`='6e247f13e8820e974ea39ca4e4b1e54f' LIMIT 1
0.351 ms
14
SELECT `sid`,`username`,UNIX_TIMESTAMP(`time`) as `timestamp` FROM `customer_session` WHERE `sid`='7c699eadbfdaa9546eb2729f9bd8631e' AND `fingerprint`='6e247f13e8820e974ea39ca4e4b1e54f'
0.393 ms
15
SELECT * FROM `countries` ORDER BY `country_name`
0.399 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`