| 0.0125 | INSERT INTO ci_sessions (session_id, ip_address, user_agent, last_activity) VALUES ('cc00ff0a23fc17a6625cfeb6f9a84ea2', '38.103.63.59', 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', 1227205552) |
| 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.0833 | SELECT *,min(r.RackRate) as rate
FROM new_packages np
left join new_package_url npu on npu.PackageID = np.PackageID
join new_package_destinations t on t.PackageTypeID = np.PackageTypeID
join common_be.packages p on p.PackageID = np.PackageID
join common_be.packagerates r on r.PackageID = np.PackageID
join country c on c.country_id = t.CountryID
where c.country_linkname = 'argentina' and t.PackageTypeUrl = 'culture' and np.PackageTypeType = 'd' group by p.PackageID order by rate |
| 0.0032 | SELECT *,min(r.RackRate) as rate
FROM common_be.packages p
join new_packages np on np.PackageID = p.PackageID
join new_package_interests npt on npt.PackageTypeID = np.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 c.country_linkname = 'argentina' and npt.PackageTypeUrl = 'culture' and np.PackageTypeType = 'i' group by p.PackageID order by rate |
| 0.0035 | SELECT *
FROM (`pages`)
WHERE `page_type` = 'packages'
AND `page_country` = 'argentina'
AND `page_name` = 'culture' |
| 0.0003 | SELECT p.PackageType FROM new_package_destinations p where p.PackageTypeUrl = 'culture' |
| 0.0002 | SELECT p.PackageType FROM new_package_interests p where p.PackageTypeUrl = 'culture' |
| 0.0109 | 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 = 'argentina'
and (c.CruiseDestinationID = 1 or c.CruiseDestinationID = 4 or c.CruiseDestinationID = 5) |
| 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.0003 | SELECT `country_name`
FROM (`country`)
WHERE `country_linkname` = 'argentina' |
| 0.0003 | SELECT `country_continent`
FROM (`country`)
WHERE `country_linkname` = 'argentina' |
| 0.0002 | SELECT `country_name`
FROM (`country`)
WHERE `country_linkname` = 'argentina' |
| 0.0017 | Select * from common_be.hotels h
join country c on c.country_id = h.CountryID
where country_linkname = 'argentina' |
| 0.0003 | SELECT `country_id`
FROM (`country`)
WHERE `country_linkname` = 'argentina' |
| 0.0004 | SELECT *
FROM (`unesco`)
WHERE `site_country_id` = '8' |
