| 0.0004 | INSERT INTO ci_sessions (session_id, ip_address, user_agent, last_activity) VALUES ('b5637e3775f1235fdee840a7098ec7d1', '38.103.63.59', 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', 1227182991) |
| 0.0004 | SELECT *
FROM (`country`)
WHERE `country_linkname` = 'argentina' |
| 0.0003 | SELECT `country_continent`
FROM (`country`)
WHERE `country_linkname` = 'argentina' |
| 0.0006 | SELECT * FROM new_package_destinations npd
join country c on c.country_id = npd.countryID where country_linkname = 'argentina' |
| 0.0006 | SELECT * FROM new_package_interests npd
join country c on c.country_id = npd.countryID where country_linkname = 'argentina' |
| 0.0002 | SELECT `country_name`
FROM (`country`)
WHERE `country_linkname` = 'argentina' |
| 0.0016 | SELECT *,min(r.RackRate) as rate
FROM common_be.packages p
join new_package_types pt on p.PackageTypeID = pt.PackageTypeID
join common_be.packages_countries pc on p.PackageID = pc.PackageID
join country c on pc.CountryID = c.country_id
join new_package_url pu on pu.PackageID = p.PackageID
join common_be.packagerates r on r.PackageID = p.PackageID
where pu.new_url = 'packages' group by p.PackageID |
| 0.0002 | SELECT `country_continent`
FROM (`country`)
WHERE `country_linkname` IS NULL |
| 0.0006 | SELECT * FROM new_package_destinations npd
join country c on c.country_id = npd.countryID where country_linkname = '' |
| 0.0005 | SELECT * FROM new_package_interests npd
join country c on c.country_id = npd.countryID where country_linkname = '' |
| 0.0002 | SELECT * FROM common_be.packageitineraries p
where p.PackageID = '' |
| 0.0004 | SELECT * FROM common_be.packages_suggestedhotels p
join common_be.hotels h on p.HotelID = h.HotelID
join hotel_urls hu on hu.hotelID = h.HotelID
where p.PackageID = '' |
| 0.0016 | SELECT page_type FROM pages WHERE page_country = '' and page_type != 'argentina' group by page_type order by page_type |
| 0.0004 | SELECT * FROM country WHERE country_continent = 'south' order by country_name |
| 0.0004 | SELECT * FROM country WHERE country_continent = 'central' order by country_name |
| 0.0009 | SELECT * FROM common_be.cruises c
join common_be.cruisedestinations d on c.CruiseDestinationID = d.CruiseDestinationID
join common_be.cruises_countries cc on c.CruiseID = cc.CruiseID
join country ac on cc.CountryID = ac.country_id
where ac.country_linkname = ''
and (c.CruiseDestinationID = 1 or c.CruiseDestinationID = 4 or c.CruiseDestinationID = 5) |
| 0.0002 | SELECT `country_name`
FROM (`country`)
WHERE `country_linkname` IS NULL |
| 0.0002 | SELECT `country_continent`
FROM (`country`)
WHERE `country_linkname` IS NULL |
| 0.0001 | SELECT `country_name`
FROM (`country`)
WHERE `country_linkname` IS NULL |
| 0.0005 | Select * from common_be.hotels h
join country c on c.country_id = h.CountryID
where country_linkname = '' |
| 0.0002 | SELECT `country_id`
FROM (`country`)
WHERE `country_linkname` IS NULL |
| 0.0002 | SELECT *
FROM (`unesco`)
WHERE `site_country_id` IS NULL |
| 0.0003 | SELECT IncludedService FROM common_be.packageincludedservices WHERE PackageID = '' |
| 0.0002 | SELECT ExcludedService FROM common_be.packageexcludedservices WHERE PackageID = '' |
