Quantity
create
0
read
13
update
0
delete
0
Time
create
0 s
read
91.11 ms
update
0 s
delete
0 s
Query Profiles
SQL
SELECT `config`.* FROM `config` ORDER BY `config`.`config_path` ASC
Time
289.92 µs
SQL
SELECT `url_rewrites`.* FROM `url_rewrites` WHERE `url_rewrites`.`rewrite_url` = ?
Params
where1 => '/de/deutschland/nordrhein-westfalen/koeln/kartcenter-cologne.html'
Time
7.16 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 `landmark`.`landmark_id` = ? ORDER BY `landmarkmodellandmark_lang`.`landmark_title` ASC
Params
join1part1 => 'de'
join8part1 => 'de'
join10part1 => 'de'
join12part1 => 'de'
join13part1 => 'de'
join14part1 => 'de'
join16part1 => 'de'
where1 => 931
Time
1.47 ms
SQL
SELECT `landmark_images`.*, `image_landmark`.* FROM `landmark_images` INNER JOIN `landmark` AS `image_landmark` ON `image_landmark`.`landmark_id` = `landmark_images`.`image_landmark` WHERE `landmark_images`.`image_landmark` = ? ORDER BY `landmark_images`.`image_sort` ASC
Params
where1 => 931
Time
1.27 ms
SQL
SELECT `landmark`.*, (6371*acos(cos(radians(50.870558))*cos(radians(landmark.landmark_lat))*cos(radians(landmark.landmark_lon)-radians(6.987646))+sin(radians(50.870558))*sin(radians(landmark.landmark_lat)))) AS `distance`, `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 `landmark`.`landmark_id` != ? AND `landmark`.`landmark_surround` = ? HAVING distance < 30 ORDER BY RAND()
Params
join1part1 => 'de'
join8part1 => 'de'
join10part1 => 'de'
join12part1 => 'de'
join13part1 => 'de'
join14part1 => 'de'
join16part1 => 'de'
where1 => 931
where2 => 1
Time
78.37 ms
SQL
SELECT `press`.*, `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`.*, `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 `press` LEFT JOIN `landmark` ON `landmark`.`landmark_id` = `press`.`press_landmark` LEFT JOIN `landmark_lang` AS `landmarkmodellandmark_lang` ON `landmarkmodellandmark_lang`.`landmark_id` = `landmark`.`landmark_id` AND landmarkmodellandmark_lang.landmark_lang = ? LEFT JOIN `city` ON `city`.`city_id` = `landmark`.`landmark_city` LEFT JOIN `landmark_images` ON `landmark_images`.`image_id` = `landmark`.`landmark_image` LEFT JOIN `era` ON `era`.`era_id` = `landmark`.`landmark_era` LEFT JOIN `type` ON `type`.`type_id` = `landmark`.`landmark_type` LEFT JOIN `user` ON `user`.`user_id` = `landmark`.`landmark_lastchanger` LEFT JOIN `city_lang` AS `citymodelcity_lang` ON `citymodelcity_lang`.`city_id` = `city`.`city_id` AND citymodelcity_lang.city_lang = ? LEFT 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 = ? LEFT 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 `press`.`press_landmark` = ? ORDER BY `press`.`press_createdate` DESC
Params
join2part1 => 'de'
join8part1 => 'de'
join10part1 => 'de'
join12part1 => 'de'
join13part1 => 'de'
join14part1 => 'de'
join16part1 => 'de'
where1 => 931
Time
1.46 ms
SQL
SELECT `cms_pages`.* FROM `cms_pages` WHERE `cms_pages`.`page_identifier` = ? AND `cms_pages`.`page_lang` = ?
Params
where1 => 'cookies'
where2 => 'de'
Time
155.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
151.87 µ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
195.98 µ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
130.89 µs
SQL
SELECT `cms_pages`.* FROM `cms_pages` WHERE `cms_pages`.`page_identifier` = ? AND `cms_pages`.`page_lang` = ?
Params
where1 => 'imprint'
where2 => 'de'
Time
117.06 µs
SQL
SELECT `cms_pages`.* FROM `cms_pages` WHERE `cms_pages`.`page_identifier` = ? AND `cms_pages`.`page_lang` = ?
Params
where1 => 'terms'
where2 => 'de'
Time
187.16 µ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
153.06 µs
Comments are getting loaded. Please wait.
Dein Kommentar