| 0.0002 | INSERT INTO sessions (session_id, ip_address, user_agent, last_activity, aff_id, template, sitename, referer) VALUES ('0c9167409065eb9e2a3b538a00f99c5a', '38.107.191.107', 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', 1268896435, '2', 'oceanblue_dec', 'TravelAffiliatePro', '') |
| 0.0002 | SELECT `city_code`, `city_name`
FROM (`citycodes`)
WHERE `city_id` = 1889
LIMIT 1 |
| 0.0001 | SELECT *
FROM (`affiliate`)
WHERE `aff_id` = '2' |
| 0.0001 | SELECT *
FROM (`affiliate_htmlcode`)
WHERE `user_id` = '2'
AND `type_id` = 1
LIMIT 1 |
| 0.0001 | SELECT *
FROM (`affiliate_htmlcode`)
WHERE `user_id` = '2'
AND `type_id` = 2
LIMIT 1 |
| 0.0003 | SELECT *
FROM (`affiliate_blocked_ip`)
WHERE `ip` = '38.107.191.107'
AND `block_type` = 0
AND `primary_key` = '1' |
| 0.0004 | UPDATE `affiliate_blocked_ip` SET `time` = '2010-03-18 04:13:55' WHERE `block_type` = 0 AND `ip` = '38.107.191.107' AND `primary_key` = '1' |
| 0.0004 | SELECT count(*) as trafficctr
FROM (`affiliate_traffic`)
WHERE `user_id` = '2'
AND `create_date` = '2010-03-18'
AND `product_id` = '1' |
| 0.0006 | UPDATE affiliate_traffic SET clickcount=clickcount+1, from_log=CONCAT(from_log, '
') WHERE user_id='2' AND create_date='2010-03-18' AND product_id='1' |
