0.0003 | INSERT INTO ci_sessions (session_id, ip_address, user_agent, last_activity) VALUES ('ace4613b428c3b4a424bae016673e394', '54.224.100.134', 'CCBot/2.0 (http://commoncrawl.org/faq/)', 1524482437) |
0.0125 | SELECT *,min(r.RackRate) as rate,p.PackageID as PackageID from newest_packages_url pu
join newest_packages p on p.PackageID = pu.PackageID
join newest_packages_countries pc on p.PackageID = pc.PackageID
join country c on pc.CountryID = c.country_id
left join newpackagerates r on r.PackageID = p.PackageID
where pu.new_url = 'green_season_beach_package_latitude_10_hotel'
group by p.PackageID |
0.0001 | SELECT *
FROM (`country`)
WHERE `country_linkname` = 'costa_rica' |
0.0001 | SELECT `country_continent`
FROM (`country`)
WHERE `country_linkname` = 'costa_rica' |
0.0001 | SELECT page_country FROM pages where page_country != '' group by page_country order by page_country |
0.0001 | SELECT countryID from newest_packages_interests where packagetype like '%special%' |
0.0001 | SELECT * FROM country WHERE country_continent = 'south' order by country_name |
0.0001 | SELECT countryID from newest_packages_interests where packagetype like '%special%' |
0.0001 | SELECT * FROM country WHERE country_continent = 'central' order by country_name |
0.0001 | SELECT page_type FROM pages WHERE page_country = 'costa_rica' and page_type != 'package' group by page_type order by page_type |
0.0001 | SELECT `country_continent`
FROM (`country`)
WHERE `country_linkname` = 'costa_rica' |
0.0001 | SELECT * FROM new_package_destinations npd
join country c on c.country_id = npd.countryID where country_linkname = 'costa_rica' |
0.0001 | SELECT * FROM new_package_interests npd
join country c on c.country_id = npd.countryID where country_linkname = 'costa_rica' |
0.0001 | SELECT `country_name`
FROM (`country`)
WHERE `country_linkname` = 'costa_rica' |
0.0001 | SELECT `country_name`
FROM (`country`)
WHERE `country_linkname` = 'costa_rica' |
0.0001 | SELECT * from newest_packages_interests where countryID = '47' and packagetype like '%special%' |
0.0003 | Select * from hotels h
join country c on c.country_id = h.CountryID
where country_linkname = 'costa_rica' |
0.0001 | SELECT `country_id`
FROM (`country`)
WHERE `country_linkname` = 'costa_rica' |
0.0001 | SELECT *
FROM (`unesco`)
WHERE `site_country_id` = '47' |