Quantity
create
0
read
31
update
0
delete
0
Time
create
0 s
read
129.46 ms
update
0 s
delete
0 s
Query Profiles
SQL
SELECT `config`.* FROM `config` ORDER BY `config`.`config_path` ASC
Time
236.99 µs
SQL
SELECT `city`.*, COUNT(`landmark`.`landmark_id`) AS `city_landmarknumber`, `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` FROM `city` 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 `landmark` ON `city`.`city_id` = `landmark`.`landmark_city` GROUP BY `city`.`city_id` ORDER BY city.city_order IS NOT NULL DESC, city.city_order ASC LIMIT ?
Params
join1part1 => 'de'
join3part1 => 'de'
join5part1 => 'de'
limit => 14
Time
259.88 µs
SQL
SELECT `city`.*, COUNT(`landmark`.`landmark_id`) AS `city_landmarknumber`, `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` FROM `city` 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 `landmark` ON `city`.`city_id` = `landmark`.`landmark_city` GROUP BY `city`.`city_id` ORDER BY city.city_order IS NOT NULL DESC, city.city_order ASC LIMIT ?
Params
join1part1 => 'de'
join3part1 => 'de'
join5part1 => 'de'
limit => 12
Time
194.07 µs
SQL
SELECT `landmark_images`.*, `image_landmark`.*, `landmark`.* FROM `landmark_images` INNER JOIN `landmark` AS `image_landmark` ON `image_landmark`.`landmark_id` = `landmark_images`.`image_landmark` INNER JOIN `landmark` ON `landmark`.`landmark_id` = `landmark_images`.`image_landmark` WHERE `landmark`.`landmark_city` = ? ORDER BY RAND()
Params
where1 => 50
Time
2.74 ms
SQL
SELECT `landmark_images`.*, `image_landmark`.*, `landmark`.* FROM `landmark_images` INNER JOIN `landmark` AS `image_landmark` ON `image_landmark`.`landmark_id` = `landmark_images`.`image_landmark` INNER JOIN `landmark` ON `landmark`.`landmark_id` = `landmark_images`.`image_landmark` WHERE `landmark`.`landmark_city` = ? ORDER BY RAND()
Params
where1 => 15
Time
3.08 ms
SQL
SELECT `landmark_images`.*, `image_landmark`.*, `landmark`.* FROM `landmark_images` INNER JOIN `landmark` AS `image_landmark` ON `image_landmark`.`landmark_id` = `landmark_images`.`image_landmark` INNER JOIN `landmark` ON `landmark`.`landmark_id` = `landmark_images`.`image_landmark` WHERE `landmark`.`landmark_city` = ? ORDER BY RAND()
Params
where1 => 39
Time
1.97 ms
SQL
SELECT `landmark_images`.*, `image_landmark`.*, `landmark`.* FROM `landmark_images` INNER JOIN `landmark` AS `image_landmark` ON `image_landmark`.`landmark_id` = `landmark_images`.`image_landmark` INNER JOIN `landmark` ON `landmark`.`landmark_id` = `landmark_images`.`image_landmark` WHERE `landmark`.`landmark_city` = ? ORDER BY RAND()
Params
where1 => 148
Time
2.33 ms
SQL
SELECT `landmark_images`.*, `image_landmark`.*, `landmark`.* FROM `landmark_images` INNER JOIN `landmark` AS `image_landmark` ON `image_landmark`.`landmark_id` = `landmark_images`.`image_landmark` INNER JOIN `landmark` ON `landmark`.`landmark_id` = `landmark_images`.`image_landmark` WHERE `landmark`.`landmark_city` = ? ORDER BY RAND()
Params
where1 => 14
Time
1.22 ms
SQL
SELECT `landmark_images`.*, `image_landmark`.*, `landmark`.* FROM `landmark_images` INNER JOIN `landmark` AS `image_landmark` ON `image_landmark`.`landmark_id` = `landmark_images`.`image_landmark` INNER JOIN `landmark` ON `landmark`.`landmark_id` = `landmark_images`.`image_landmark` WHERE `landmark`.`landmark_city` = ? ORDER BY RAND()
Params
where1 => 371
Time
2.20 ms
SQL
SELECT `landmark_images`.*, `image_landmark`.*, `landmark`.* FROM `landmark_images` INNER JOIN `landmark` AS `image_landmark` ON `image_landmark`.`landmark_id` = `landmark_images`.`image_landmark` INNER JOIN `landmark` ON `landmark`.`landmark_id` = `landmark_images`.`image_landmark` WHERE `landmark`.`landmark_city` = ? ORDER BY RAND()
Params
where1 => 65
Time
1.12 ms
SQL
SELECT `landmark_images`.*, `image_landmark`.*, `landmark`.* FROM `landmark_images` INNER JOIN `landmark` AS `image_landmark` ON `image_landmark`.`landmark_id` = `landmark_images`.`image_landmark` INNER JOIN `landmark` ON `landmark`.`landmark_id` = `landmark_images`.`image_landmark` WHERE `landmark`.`landmark_city` = ? ORDER BY RAND()
Params
where1 => 10
Time
646.11 µs
SQL
SELECT `landmark_images`.*, `image_landmark`.*, `landmark`.* FROM `landmark_images` INNER JOIN `landmark` AS `image_landmark` ON `image_landmark`.`landmark_id` = `landmark_images`.`image_landmark` INNER JOIN `landmark` ON `landmark`.`landmark_id` = `landmark_images`.`image_landmark` WHERE `landmark`.`landmark_city` = ? ORDER BY RAND()
Params
where1 => 17
Time
1.36 ms
SQL
SELECT `landmark_images`.*, `image_landmark`.*, `landmark`.* FROM `landmark_images` INNER JOIN `landmark` AS `image_landmark` ON `image_landmark`.`landmark_id` = `landmark_images`.`image_landmark` INNER JOIN `landmark` ON `landmark`.`landmark_id` = `landmark_images`.`image_landmark` WHERE `landmark`.`landmark_city` = ? ORDER BY RAND()
Params
where1 => 71
Time
458.00 µs
SQL
SELECT `landmark_images`.*, `image_landmark`.*, `landmark`.* FROM `landmark_images` INNER JOIN `landmark` AS `image_landmark` ON `image_landmark`.`landmark_id` = `landmark_images`.`image_landmark` INNER JOIN `landmark` ON `landmark`.`landmark_id` = `landmark_images`.`image_landmark` WHERE `landmark`.`landmark_city` = ? ORDER BY RAND()
Params
where1 => 408
Time
493.05 µs
SQL
SELECT `landmark_images`.*, `image_landmark`.*, `landmark`.* FROM `landmark_images` INNER JOIN `landmark` AS `image_landmark` ON `image_landmark`.`landmark_id` = `landmark_images`.`image_landmark` INNER JOIN `landmark` ON `landmark`.`landmark_id` = `landmark_images`.`image_landmark` WHERE `landmark`.`landmark_city` = ? ORDER BY RAND()
Params
where1 => 40
Time
1.55 ms
SQL
SELECT `landmark_images`.*, `image_landmark`.*, `landmark`.* FROM `landmark_images` INNER JOIN `landmark` AS `image_landmark` ON `image_landmark`.`landmark_id` = `landmark_images`.`image_landmark` INNER JOIN `landmark` ON `landmark`.`landmark_id` = `landmark_images`.`image_landmark` WHERE `landmark`.`landmark_city` = ? ORDER BY RAND()
Params
where1 => 340
Time
494.00 µs
SQL
SELECT `landmark_images`.*, `image_landmark`.*, `landmark`.* FROM `landmark_images` INNER JOIN `landmark` AS `image_landmark` ON `image_landmark`.`landmark_id` = `landmark_images`.`image_landmark` INNER JOIN `landmark` ON `landmark`.`landmark_id` = `landmark_images`.`image_landmark` WHERE `landmark`.`landmark_city` = ? ORDER BY RAND()
Params
where1 => 204
Time
602.96 µ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_startpage` = ? ORDER BY `type`.`type_category_order` ASC LIMIT ?
Params
join1part1 => 'de'
join3part1 => 'de'
where1 => 1
limit => 14
Time
117.06 µs
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_image` IS NOT NULL ORDER BY RAND() LIMIT ?
Params
join1part1 => 'de'
join8part1 => 'de'
join10part1 => 'de'
join12part1 => 'de'
join13part1 => 'de'
join14part1 => 'de'
join16part1 => 'de'
limit => 16
Time
44.75 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_random` = ? AND `landmark`.`landmark_image` IS NOT NULL ORDER BY RAND() LIMIT ?
Params
join1part1 => 'de'
join8part1 => 'de'
join10part1 => 'de'
join12part1 => 'de'
join13part1 => 'de'
join14part1 => 'de'
join16part1 => 'de'
where1 => 1
limit => 4
Time
61.15 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 = ? ORDER BY `press`.`press_createdate` DESC LIMIT ?
Params
join2part1 => 'de'
join8part1 => 'de'
join10part1 => 'de'
join12part1 => 'de'
join13part1 => 'de'
join14part1 => 'de'
join16part1 => 'de'
limit => 9
Time
401.97 µs
SQL
SELECT `landmark_preset`.*, `landmarkmodelpreset_lang`.`preset_name` AS `landmarkmodelpreset_lang_preset_name`, `landmarkmodelpreset_lang`.`preset_title` AS `landmarkmodelpreset_lang_preset_title`, `landmarkmodelpreset_lang`.`preset_url_key` AS `landmarkmodelpreset_lang_preset_url_key`, `landmarkmodelpreset_lang`.`preset_subtitle` AS `landmarkmodelpreset_lang_preset_subtitle`, `landmarkmodelpreset_lang`.`preset_lang` AS `landmarkmodelpreset_lang_preset_lang`, `landmarkmodelpreset_lang`.`preset_id` AS `landmarkmodelpreset_lang_preset_id` FROM `landmark_preset` LEFT JOIN `landmark_preset_lang` AS `landmarkmodelpreset_lang` ON `landmarkmodelpreset_lang`.`preset_id` = `landmark_preset`.`preset_id` AND landmarkmodelpreset_lang.preset_lang = ? WHERE `landmark_preset`.`preset_active` = ? ORDER BY landmark_preset.preset_sort, landmarkmodelpreset_lang.preset_name
Params
join1part1 => 'de'
where1 => 1
Time
211.95 µs
SQL
SELECT `membership`.*, COUNT(`landmark`.`landmark_id`) AS `membership_landmarknumber`, `membershipmodelmembership_lang`.`membership_lang` AS `membershipmodelmembership_lang_membership_lang`, `membershipmodelmembership_lang`.`membership_title` AS `membershipmodelmembership_lang_membership_title`, `membershipmodelmembership_lang`.`membership_desc` AS `membershipmodelmembership_lang_membership_desc`, `membershipmodelmembership_lang`.`membership_seo_name` AS `membershipmodelmembership_lang_membership_seo_name`, `membershipmodelmembership_lang`.`membership_keywords` AS `membershipmodelmembership_lang_membership_keywords`, `membershipmodelmembership_lang`.`membership_id` AS `membershipmodelmembership_lang_membership_id` FROM `membership` LEFT JOIN `membership_lang` AS `membershipmodelmembership_lang` ON `membershipmodelmembership_lang`.`membership_id` = `membership`.`membership_id` AND membershipmodelmembership_lang.membership_lang = ? LEFT JOIN `landmark` ON `membership`.`membership_id` = `landmark`.`landmark_city` WHERE `membership`.`membership_megamenu` = ? GROUP BY `membership`.`membership_id` ORDER BY membership.membership_megamenu_order IS NOT NULL, membership.membership_megamenu_order ASC LIMIT ?
Params
join1part1 => 'de'
where1 => 1
limit => 14
Time
231.03 µs
SQL
SELECT `cms_blocks`.* FROM `cms_blocks` WHERE `cms_blocks`.`block_identifier` = ? AND `cms_blocks`.`block_lang` = ?
Params
where1 => 'startpage_about'
where2 => 'de'
Time
202.18 µs
SQL
SELECT `cms_pages`.* FROM `cms_pages` WHERE `cms_pages`.`page_identifier` = ? AND `cms_pages`.`page_lang` = ?
Params
where1 => 'cookies'
where2 => 'de'
Time
140.19 µ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
198.13 µ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
217.91 µ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
299.93 µs
SQL
SELECT `cms_pages`.* FROM `cms_pages` WHERE `cms_pages`.`page_identifier` = ? AND `cms_pages`.`page_lang` = ?
Params
where1 => 'imprint'
where2 => 'de'
Time
197.89 µs
SQL
SELECT `cms_pages`.* FROM `cms_pages` WHERE `cms_pages`.`page_identifier` = ? AND `cms_pages`.`page_lang` = ?
Params
where1 => 'terms'
where2 => 'de'
Time
203.13 µ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
177.15 µs