Quantity
create
0
read
13
update
0
delete
0
Time
create
0 s
read
34.89 ms
update
0 s
delete
0 s
Query Profiles
SQL
SELECT `config`.* FROM `config` ORDER BY `config`.`config_path` ASC
Time
211.95 µs
SQL
SELECT `url_rewrites`.* FROM `url_rewrites` WHERE `url_rewrites`.`rewrite_url` = ?
Params
where1 => '/de/schweiz/zuerich.html'
Time
14.11 ms
SQL
SELECT `county`.*, COUNT(`landmark`.`landmark_id`) AS `county_landmarknumber`, `countymodelcounty_lang`.`county_name` AS `countymodelcounty_lang_county_name`, `countymodelcounty_lang`.`county_desc` AS `countymodelcounty_lang_county_desc`, `countymodelcounty_lang`.`county_lang` AS `countymodelcounty_lang_county_lang`, `countymodelcounty_lang`.`county_id` AS `countymodelcounty_lang_county_id`, `country`.*, `countrymodelcountry_lang`.`country_name` AS `countrymodelcountry_lang_country_name`, `countrymodelcountry_lang`.`country_lang` AS `countrymodelcountry_lang_country_lang`, `countrymodelcountry_lang`.`country_id` AS `countrymodelcountry_lang_country_id` FROM `county` LEFT JOIN `county_lang` AS `countymodelcounty_lang` ON `countymodelcounty_lang`.`county_id` = `county`.`county_id` AND countymodelcounty_lang.county_lang = ? INNER JOIN `country` ON `country`.`country_id` = `county`.`county_country` LEFT JOIN `country_lang` AS `countrymodelcountry_lang` ON `countrymodelcountry_lang`.`country_id` = `country`.`country_id` AND countrymodelcountry_lang.country_lang = ? LEFT JOIN `city` ON `county`.`county_id` = `city`.`city_county` LEFT JOIN `landmark` ON `city`.`city_id` = `landmark`.`landmark_city` WHERE `county`.`county_id` = ? GROUP BY `county`.`county_id` ORDER BY `countymodelcounty_lang`.`county_name` ASC
Params
join1part1 => 'de'
join3part1 => 'de'
where1 => 104
Time
1.57 ms
SQL
SELECT `landmark`.*, `landmarkmodellandmark_lang`.`landmark_lang` AS `landmarkmodellandmark_lang_landmark_lang`, `landmarkmodellandmark_lang`.`landmark_title` AS `landmarkmodellandmark_lang_landmark_title`, `landmarkmodellandmark_lang`.`landmark_desc` AS `landmarkmodellandmark_lang_landmark_desc`, `landmarkmodellandmark_lang`.`landmark_business_hours` AS `landmarkmodellandmark_lang_landmark_business_hours`, `landmarkmodellandmark_lang`.`landmark_prices` AS `landmarkmodellandmark_lang_landmark_prices`, `landmarkmodellandmark_lang`.`landmark_keywords` AS `landmarkmodellandmark_lang_landmark_keywords`, `landmarkmodellandmark_lang`.`landmark_searchwords` AS `landmarkmodellandmark_lang_landmark_searchwords`, `landmarkmodellandmark_lang`.`landmark_id` AS `landmarkmodellandmark_lang_landmark_id`, `city`.*, `landmark_images`.*, `era`.*, `type`.*, `user`.*, `owner_table`.`user_nick` AS `owner_user_nick`, `owner_table`.`user_fore` AS `owner_user_fore`, `owner_table`.`user_name` AS `owner_user_name`, `owner_table`.`user_mail` AS `owner_user_mail`, `owner_table`.`user_password` AS `owner_user_password`, `owner_table`.`user_creation` AS `owner_user_creation`, `owner_table`.`user_creation_code` AS `owner_user_creation_code`, `owner_table`.`user_mode` AS `owner_user_mode`, `owner_table`.`user_type` AS `owner_user_type`, `owner_table`.`user_points` AS `owner_user_points`, `owner_table`.`user_last_login` AS `owner_user_last_login`, `owner_table`.`user_reset_key` AS `owner_user_reset_key`, `owner_table`.`user_reset_key_date` AS `owner_user_reset_key_date`, `owner_table`.`user_id` AS `owner_user_id`, `citymodelcity_lang`.`city_name` AS `citymodelcity_lang_city_name`, `citymodelcity_lang`.`city_desc` AS `citymodelcity_lang_city_desc`, `citymodelcity_lang`.`city_lang` AS `citymodelcity_lang_city_lang`, `citymodelcity_lang`.`city_id` AS `citymodelcity_lang_city_id`, `county`.*, `countymodelcounty_lang`.`county_name` AS `countymodelcounty_lang_county_name`, `countymodelcounty_lang`.`county_desc` AS `countymodelcounty_lang_county_desc`, `countymodelcounty_lang`.`county_lang` AS `countymodelcounty_lang_county_lang`, `countymodelcounty_lang`.`county_id` AS `countymodelcounty_lang_county_id`, `country`.*, `countrymodelcountry_lang`.`country_name` AS `countrymodelcountry_lang_country_name`, `countrymodelcountry_lang`.`country_lang` AS `countrymodelcountry_lang_country_lang`, `countrymodelcountry_lang`.`country_id` AS `countrymodelcountry_lang_country_id`, `eramodelera_lang`.`era_name` AS `eramodelera_lang_era_name`, `eramodelera_lang`.`era_desc` AS `eramodelera_lang_era_desc`, `eramodelera_lang`.`era_lang` AS `eramodelera_lang_era_lang`, `eramodelera_lang`.`era_id` AS `eramodelera_lang_era_id`, `typemodeltype_lang`.`type_name` AS `typemodeltype_lang_type_name`, `typemodeltype_lang`.`type_name_plural` AS `typemodeltype_lang_type_name_plural`, `typemodeltype_lang`.`type_desc` AS `typemodeltype_lang_type_desc`, `typemodeltype_lang`.`type_lang` AS `typemodeltype_lang_type_lang`, `typemodeltype_lang`.`type_id` AS `typemodeltype_lang_type_id`, `category`.*, `categorymodelcategory_lang`.`category_name` AS `categorymodelcategory_lang_category_name`, `categorymodelcategory_lang`.`category_lang` AS `categorymodelcategory_lang_category_lang`, `categorymodelcategory_lang`.`category_id` AS `categorymodelcategory_lang_category_id` FROM `landmark` LEFT JOIN `landmark_lang` AS `landmarkmodellandmark_lang` ON `landmarkmodellandmark_lang`.`landmark_id` = `landmark`.`landmark_id` AND landmarkmodellandmark_lang.landmark_lang = ? INNER JOIN `city` ON `city`.`city_id` = `landmark`.`landmark_city` LEFT JOIN `landmark_images` ON `landmark_images`.`image_id` = `landmark`.`landmark_image` INNER JOIN `era` ON `era`.`era_id` = `landmark`.`landmark_era` INNER JOIN `type` ON `type`.`type_id` = `landmark`.`landmark_type` LEFT JOIN `user` ON `user`.`user_id` = `landmark`.`landmark_lastchanger` LEFT JOIN `user` AS `owner_table` ON `owner_table`.`user_id` = `landmark`.`landmark_user` LEFT JOIN `city_lang` AS `citymodelcity_lang` ON `citymodelcity_lang`.`city_id` = `city`.`city_id` AND citymodelcity_lang.city_lang = ? INNER JOIN `county` ON `county`.`county_id` = `city`.`city_county` LEFT JOIN `county_lang` AS `countymodelcounty_lang` ON `countymodelcounty_lang`.`county_id` = `county`.`county_id` AND countymodelcounty_lang.county_lang = ? INNER JOIN `country` ON `country`.`country_id` = `county`.`county_country` LEFT JOIN `country_lang` AS `countrymodelcountry_lang` ON `countrymodelcountry_lang`.`country_id` = `country`.`country_id` AND countrymodelcountry_lang.country_lang = ? LEFT JOIN `era_lang` AS `eramodelera_lang` ON `eramodelera_lang`.`era_id` = `era`.`era_id` AND eramodelera_lang.era_lang = ? LEFT JOIN `type_lang` AS `typemodeltype_lang` ON `typemodeltype_lang`.`type_id` = `type`.`type_id` AND typemodeltype_lang.type_lang = ? LEFT JOIN `category` ON `category`.`category_id` = `type`.`type_category` LEFT JOIN `category_lang` AS `categorymodelcategory_lang` ON `categorymodelcategory_lang`.`category_id` = `category`.`category_id` AND categorymodelcategory_lang.category_lang = ? WHERE `city`.`city_county` = ? ORDER BY `landmarkmodellandmark_lang`.`landmark_title` ASC
Params
join1part1 => 'de'
join8part1 => 'de'
join10part1 => 'de'
join12part1 => 'de'
join13part1 => 'de'
join14part1 => 'de'
join16part1 => 'de'
where1 => 104
Time
8.16 ms
SQL
SELECT COUNT(*) AS `c` FROM `landmark` LEFT JOIN `landmark_lang` AS `landmarkmodellandmark_lang` ON `landmarkmodellandmark_lang`.`landmark_id` = `landmark`.`landmark_id` AND landmarkmodellandmark_lang.landmark_lang = ? INNER JOIN `city` ON `city`.`city_id` = `landmark`.`landmark_city` LEFT JOIN `landmark_images` ON `landmark_images`.`image_id` = `landmark`.`landmark_image` INNER JOIN `era` ON `era`.`era_id` = `landmark`.`landmark_era` INNER JOIN `type` ON `type`.`type_id` = `landmark`.`landmark_type` LEFT JOIN `user` ON `user`.`user_id` = `landmark`.`landmark_lastchanger` LEFT JOIN `user` AS `owner_table` ON `owner_table`.`user_id` = `landmark`.`landmark_user` LEFT JOIN `city_lang` AS `citymodelcity_lang` ON `citymodelcity_lang`.`city_id` = `city`.`city_id` AND citymodelcity_lang.city_lang = ? INNER JOIN `county` ON `county`.`county_id` = `city`.`city_county` LEFT JOIN `county_lang` AS `countymodelcounty_lang` ON `countymodelcounty_lang`.`county_id` = `county`.`county_id` AND countymodelcounty_lang.county_lang = ? INNER JOIN `country` ON `country`.`country_id` = `county`.`county_country` LEFT JOIN `country_lang` AS `countrymodelcountry_lang` ON `countrymodelcountry_lang`.`country_id` = `country`.`country_id` AND countrymodelcountry_lang.country_lang = ? LEFT JOIN `era_lang` AS `eramodelera_lang` ON `eramodelera_lang`.`era_id` = `era`.`era_id` AND eramodelera_lang.era_lang = ? LEFT JOIN `type_lang` AS `typemodeltype_lang` ON `typemodeltype_lang`.`type_id` = `type`.`type_id` AND typemodeltype_lang.type_lang = ? LEFT JOIN `category` ON `category`.`category_id` = `type`.`type_category` LEFT JOIN `category_lang` AS `categorymodelcategory_lang` ON `categorymodelcategory_lang`.`category_id` = `category`.`category_id` AND categorymodelcategory_lang.category_lang = ? WHERE `city`.`city_county` = ?
Params
join1part1 => 'de'
join8part1 => 'de'
join10part1 => 'de'
join12part1 => 'de'
join13part1 => 'de'
join14part1 => 'de'
join16part1 => 'de'
where1 => 104
Time
1.97 ms
SQL
SELECT `landmark`.*, `landmarkmodellandmark_lang`.`landmark_lang` AS `landmarkmodellandmark_lang_landmark_lang`, `landmarkmodellandmark_lang`.`landmark_title` AS `landmarkmodellandmark_lang_landmark_title`, `landmarkmodellandmark_lang`.`landmark_desc` AS `landmarkmodellandmark_lang_landmark_desc`, `landmarkmodellandmark_lang`.`landmark_business_hours` AS `landmarkmodellandmark_lang_landmark_business_hours`, `landmarkmodellandmark_lang`.`landmark_prices` AS `landmarkmodellandmark_lang_landmark_prices`, `landmarkmodellandmark_lang`.`landmark_keywords` AS `landmarkmodellandmark_lang_landmark_keywords`, `landmarkmodellandmark_lang`.`landmark_searchwords` AS `landmarkmodellandmark_lang_landmark_searchwords`, `landmarkmodellandmark_lang`.`landmark_id` AS `landmarkmodellandmark_lang_landmark_id`, `city`.*, `landmark_images`.*, `era`.*, `type`.*, `user`.*, `owner_table`.`user_nick` AS `owner_user_nick`, `owner_table`.`user_fore` AS `owner_user_fore`, `owner_table`.`user_name` AS `owner_user_name`, `owner_table`.`user_mail` AS `owner_user_mail`, `owner_table`.`user_password` AS `owner_user_password`, `owner_table`.`user_creation` AS `owner_user_creation`, `owner_table`.`user_creation_code` AS `owner_user_creation_code`, `owner_table`.`user_mode` AS `owner_user_mode`, `owner_table`.`user_type` AS `owner_user_type`, `owner_table`.`user_points` AS `owner_user_points`, `owner_table`.`user_last_login` AS `owner_user_last_login`, `owner_table`.`user_reset_key` AS `owner_user_reset_key`, `owner_table`.`user_reset_key_date` AS `owner_user_reset_key_date`, `owner_table`.`user_id` AS `owner_user_id`, `citymodelcity_lang`.`city_name` AS `citymodelcity_lang_city_name`, `citymodelcity_lang`.`city_desc` AS `citymodelcity_lang_city_desc`, `citymodelcity_lang`.`city_lang` AS `citymodelcity_lang_city_lang`, `citymodelcity_lang`.`city_id` AS `citymodelcity_lang_city_id`, `county`.*, `countymodelcounty_lang`.`county_name` AS `countymodelcounty_lang_county_name`, `countymodelcounty_lang`.`county_desc` AS `countymodelcounty_lang_county_desc`, `countymodelcounty_lang`.`county_lang` AS `countymodelcounty_lang_county_lang`, `countymodelcounty_lang`.`county_id` AS `countymodelcounty_lang_county_id`, `country`.*, `countrymodelcountry_lang`.`country_name` AS `countrymodelcountry_lang_country_name`, `countrymodelcountry_lang`.`country_lang` AS `countrymodelcountry_lang_country_lang`, `countrymodelcountry_lang`.`country_id` AS `countrymodelcountry_lang_country_id`, `eramodelera_lang`.`era_name` AS `eramodelera_lang_era_name`, `eramodelera_lang`.`era_desc` AS `eramodelera_lang_era_desc`, `eramodelera_lang`.`era_lang` AS `eramodelera_lang_era_lang`, `eramodelera_lang`.`era_id` AS `eramodelera_lang_era_id`, `typemodeltype_lang`.`type_name` AS `typemodeltype_lang_type_name`, `typemodeltype_lang`.`type_name_plural` AS `typemodeltype_lang_type_name_plural`, `typemodeltype_lang`.`type_desc` AS `typemodeltype_lang_type_desc`, `typemodeltype_lang`.`type_lang` AS `typemodeltype_lang_type_lang`, `typemodeltype_lang`.`type_id` AS `typemodeltype_lang_type_id`, `category`.*, `categorymodelcategory_lang`.`category_name` AS `categorymodelcategory_lang_category_name`, `categorymodelcategory_lang`.`category_lang` AS `categorymodelcategory_lang_category_lang`, `categorymodelcategory_lang`.`category_id` AS `categorymodelcategory_lang_category_id` FROM `landmark` LEFT JOIN `landmark_lang` AS `landmarkmodellandmark_lang` ON `landmarkmodellandmark_lang`.`landmark_id` = `landmark`.`landmark_id` AND landmarkmodellandmark_lang.landmark_lang = ? INNER JOIN `city` ON `city`.`city_id` = `landmark`.`landmark_city` LEFT JOIN `landmark_images` ON `landmark_images`.`image_id` = `landmark`.`landmark_image` INNER JOIN `era` ON `era`.`era_id` = `landmark`.`landmark_era` INNER JOIN `type` ON `type`.`type_id` = `landmark`.`landmark_type` LEFT JOIN `user` ON `user`.`user_id` = `landmark`.`landmark_lastchanger` LEFT JOIN `user` AS `owner_table` ON `owner_table`.`user_id` = `landmark`.`landmark_user` LEFT JOIN `city_lang` AS `citymodelcity_lang` ON `citymodelcity_lang`.`city_id` = `city`.`city_id` AND citymodelcity_lang.city_lang = ? INNER JOIN `county` ON `county`.`county_id` = `city`.`city_county` LEFT JOIN `county_lang` AS `countymodelcounty_lang` ON `countymodelcounty_lang`.`county_id` = `county`.`county_id` AND countymodelcounty_lang.county_lang = ? INNER JOIN `country` ON `country`.`country_id` = `county`.`county_country` LEFT JOIN `country_lang` AS `countrymodelcountry_lang` ON `countrymodelcountry_lang`.`country_id` = `country`.`country_id` AND countrymodelcountry_lang.country_lang = ? LEFT JOIN `era_lang` AS `eramodelera_lang` ON `eramodelera_lang`.`era_id` = `era`.`era_id` AND eramodelera_lang.era_lang = ? LEFT JOIN `type_lang` AS `typemodeltype_lang` ON `typemodeltype_lang`.`type_id` = `type`.`type_id` AND typemodeltype_lang.type_lang = ? LEFT JOIN `category` ON `category`.`category_id` = `type`.`type_category` LEFT JOIN `category_lang` AS `categorymodelcategory_lang` ON `categorymodelcategory_lang`.`category_id` = `category`.`category_id` AND categorymodelcategory_lang.category_lang = ? WHERE `city`.`city_county` = ? ORDER BY landmark_payment_model = 'premium' DESC, landmark_rating_count > 2 DESC, (landmark_rating/landmark_rating_count) DESC, landmark_title LIMIT ? OFFSET ?
Params
join1part1 => 'de'
join8part1 => 'de'
join10part1 => 'de'
join12part1 => 'de'
join13part1 => 'de'
join14part1 => 'de'
join16part1 => 'de'
where1 => 104
limit => 20
offset => 0
Time
7.47 ms
SQL
SELECT `cms_pages`.* FROM `cms_pages` WHERE `cms_pages`.`page_identifier` = ? AND `cms_pages`.`page_lang` = ?
Params
where1 => 'cookies'
where2 => 'de'
Time
227.93 µs
SQL
SELECT `type`.*, `typemodeltype_lang`.`type_name` AS `typemodeltype_lang_type_name`, `typemodeltype_lang`.`type_name_plural` AS `typemodeltype_lang_type_name_plural`, `typemodeltype_lang`.`type_desc` AS `typemodeltype_lang_type_desc`, `typemodeltype_lang`.`type_lang` AS `typemodeltype_lang_type_lang`, `typemodeltype_lang`.`type_id` AS `typemodeltype_lang_type_id`, `category`.*, `categorymodelcategory_lang`.`category_name` AS `categorymodelcategory_lang_category_name`, `categorymodelcategory_lang`.`category_lang` AS `categorymodelcategory_lang_category_lang`, `categorymodelcategory_lang`.`category_id` AS `categorymodelcategory_lang_category_id` FROM `type` LEFT JOIN `type_lang` AS `typemodeltype_lang` ON `typemodeltype_lang`.`type_id` = `type`.`type_id` AND typemodeltype_lang.type_lang = ? LEFT JOIN `category` ON `category`.`category_id` = `type`.`type_category` LEFT JOIN `category_lang` AS `categorymodelcategory_lang` ON `categorymodelcategory_lang`.`category_id` = `category`.`category_id` AND categorymodelcategory_lang.category_lang = ? WHERE `type`.`type_navigation_level1` = ? ORDER BY `typemodeltype_lang`.`type_name_plural` ASC
Params
join1part1 => 'de'
join3part1 => 'de'
where1 => 1
Time
313.04 µs
SQL
SELECT `type`.*, `typemodeltype_lang`.`type_name` AS `typemodeltype_lang_type_name`, `typemodeltype_lang`.`type_name_plural` AS `typemodeltype_lang_type_name_plural`, `typemodeltype_lang`.`type_desc` AS `typemodeltype_lang_type_desc`, `typemodeltype_lang`.`type_lang` AS `typemodeltype_lang_type_lang`, `typemodeltype_lang`.`type_id` AS `typemodeltype_lang_type_id`, `category`.*, `categorymodelcategory_lang`.`category_name` AS `categorymodelcategory_lang_category_name`, `categorymodelcategory_lang`.`category_lang` AS `categorymodelcategory_lang_category_lang`, `categorymodelcategory_lang`.`category_id` AS `categorymodelcategory_lang_category_id` FROM `type` LEFT JOIN `type_lang` AS `typemodeltype_lang` ON `typemodeltype_lang`.`type_id` = `type`.`type_id` AND typemodeltype_lang.type_lang = ? LEFT JOIN `category` ON `category`.`category_id` = `type`.`type_category` LEFT JOIN `category_lang` AS `categorymodelcategory_lang` ON `categorymodelcategory_lang`.`category_id` = `category`.`category_id` AND categorymodelcategory_lang.category_lang = ? WHERE `type`.`type_navigation_level1` = ? ORDER BY `typemodeltype_lang`.`type_name_plural` ASC
Params
join1part1 => 'de'
join3part1 => 'de'
where1 => 0
Time
220.06 µs
SQL
SELECT `cms_pages`.* FROM `cms_pages` WHERE `cms_pages`.`page_identifier` = ? AND `cms_pages`.`page_lang` = ?
Params
where1 => 'general-information'
where2 => 'de'
Time
194.79 µs
SQL
SELECT `cms_pages`.* FROM `cms_pages` WHERE `cms_pages`.`page_identifier` = ? AND `cms_pages`.`page_lang` = ?
Params
where1 => 'imprint'
where2 => 'de'
Time
152.11 µs
SQL
SELECT `cms_pages`.* FROM `cms_pages` WHERE `cms_pages`.`page_identifier` = ? AND `cms_pages`.`page_lang` = ?
Params
where1 => 'terms'
where2 => 'de'
Time
139.00 µs
SQL
SELECT `cms_pages`.* FROM `cms_pages` WHERE `cms_pages`.`page_identifier` = ? AND `cms_pages`.`page_lang` = ?
Params
where1 => 'prices-and-services'
where2 => 'de'
Time
145.91 µs
