Mine

$page = 'http://'.$_SERVER['SERVER_NAME'].$_SERVER['REDIRECT_URL'];
$ref = $db->getOne('select id from larpro_log_url_list where url=?',array($_SERVER['HTTP_REFERER']));
$url = $db->getOne('select id from larpro_log_url_list where url=?',array($page));
if (!$ref) {
	if ($_SERVER['HTTP_REFERER']) {
		$db->query('insert into larpro_log_url_list (url, class) values (?, ?)', array($_SERVER['HTTP_REFERER'], strncmp( CONF_URL_BASE, $_SERVER['HTTP_REFERER'], strlen(CONF_URL_BASE) ) ? 'external' : 'internal') );
		$ref = $db->getOne('select LAST_INSERT_ID()');
	} else $ref=0;
} if (!$url) {
	$db->query('insert into larpro_log_url_list (url, class) values (?, ?)', array($page, 'internal') );
	$url = $db->getOne('select LAST_INSERT_ID()');
}
$db->query('insert into larpro_log_url_visit (visitor_id, url, ref) values (?,?,?)', array($visitor_id, $url, $ref) );