zurück

Fiat 500 Riva - Cabrio - LIMITED

Year: 2017
Engine: 0,9 twin air turbo
Engine volume: 875 m3
Engine power 77kW / 105hp
Weight: 1055 kg
Km: 550 km

Extra options:

Colour blue Siera metallic
Seats in white leather Frau with Riva logo
Blue convertible roof
Personalized plate 500 by Riva (MennYachtFamily03)
Bi-xenon head lights
Rear view mirror with automatic dim
Uconnect autoradio with 7˝ touch screen, navigation system, bluetooth system, USB and AUX in and digital radio receiver DAB
Tinted rear windows (3)
Riva Steering wheel in leather and wooden inserts with control keys
Rear parking sensors
Wind protection net
Cruise control

video

General information

Year2017

made by Vergiliem

  ZFDebug log Log variables Variables database 148 in 51.57 ms 9264K in 779ms

Event log for productsController->detailAction() (products module)

570ms2601KStartup - ZFDebug construct()
19ms1587KRoute
149ms3718KproductsController::detailAction
182ms4538KDispatch
779ms8939KShutdown

View variables

action => 'detail'
brands =>
0 => ProductFolder Object()
1 => ProductFolder Object()
2 => ProductFolder Object()
3 => ProductFolder Object()
4 => ProductFolder Object()
5 => ProductFolder Object()
6 => ProductFolder Object()
7 => ProductFolder Object()
8 => ProductFolder Object()
9 => ProductFolder Object()
10 => ProductFolder Object()
11 => ProductFolder Object()
12 => ProductFolder Object()
13 => ProductFolder Object()
14 => ProductFolder Object()
15 => ProductFolder Object()
16 => ProductFolder Object()
17 => ProductFolder Object()
18 => ProductFolder Object()
19 => ProductFolder Object()
20 => ProductFolder Object()
21 => ProductFolder Object()
22 => ProductFolder Object()
23 => ProductFolder Object()
24 => ProductFolder Object()
25 => ProductFolder Object()
26 => ProductFolder Object()
27 => ProductFolder Object()
28 => ProductFolder Object()
29 => ProductFolder Object()
30 => ProductFolder Object()
31 => ProductFolder Object()
32 => ProductFolder Object()
33 => ProductFolder Object()
34 => ProductFolder Object()
35 => ProductFolder Object()
36 => ProductFolder Object()
37 => ProductFolder Object()
38 => ProductFolder Object()
39 => ProductFolder Object()
40 => ProductFolder Object()
41 => ProductFolder Object()
42 => ProductFolder Object()
43 => ProductFolder Object()
44 => ProductFolder Object()
45 => ProductFolder Object()
46 => ProductFolder Object()
47 => ProductFolder Object()
48 => ProductFolder Object()
49 => ProductFolder Object()
50 => ProductFolder Object()
51 => ProductFolder Object()
52 => ProductFolder Object()
53 => ProductFolder Object()
54 => ProductFolder Object()
55 => ProductFolder Object()
56 => ProductFolder Object()
57 => ProductFolder Object()
broker => ProductBroker Object()
controller => 'products'
folder => ProductFolder Object()
module => 'products'
paramsString => NULL
parent => ProductFolder Object()
record => Product Object()
subfolders =>
0 => ProductFolder Object()
1 => ProductFolder Object()
2 => ProductFolder Object()
3 => ProductFolder Object()
4 => ProductFolder Object()
5 => ProductFolder Object()
6 => ProductFolder Object()
7 => ProductFolder Object()
8 => ProductFolder Object()
9 => ProductFolder Object()
10 => ProductFolder Object()
11 => ProductFolder Object()
12 => ProductFolder Object()
13 => ProductFolder Object()
14 => ProductFolder Object()
15 => ProductFolder Object()
16 => ProductFolder Object()
17 => ProductFolder Object()
18 => ProductFolder Object()
19 => ProductFolder Object()
20 => ProductFolder Object()
21 => ProductFolder Object()
22 => ProductFolder Object()
23 => ProductFolder Object()
24 => ProductFolder Object()
25 => ProductFolder Object()
26 => ProductFolder Object()
27 => ProductFolder Object()
28 => ProductFolder Object()
29 => ProductFolder Object()
30 => ProductFolder Object()
31 => ProductFolder Object()
32 => ProductFolder Object()
33 => ProductFolder Object()
34 => ProductFolder Object()
35 => ProductFolder Object()
36 => ProductFolder Object()
37 => ProductFolder Object()
38 => ProductFolder Object()
39 => ProductFolder Object()
40 => ProductFolder Object()
41 => ProductFolder Object()
42 => ProductFolder Object()
43 => ProductFolder Object()
44 => ProductFolder Object()
45 => ProductFolder Object()
46 => ProductFolder Object()
47 => ProductFolder Object()
48 => ProductFolder Object()
49 => ProductFolder Object()
50 => ProductFolder Object()
51 => ProductFolder Object()
52 => ProductFolder Object()
53 => ProductFolder Object()
54 => ProductFolder Object()
55 => ProductFolder Object()
56 => ProductFolder Object()
57 => ProductFolder Object()
type => 'preowned-yachts'
yachts => Tajfun_Db_Table_Rowset Object()

Request parameters

action => 'detail'
controller => 'products'
folder => 'preowned-yachts'
lang => 'de'
module => 'products'
rewrite_url => 'fiat-500-c-riva'

Zend Registry

Zend_Controller_Plugin_ActionStack =>
Zend_Locale => Zend_Locale Object()
Zend_Translate => Zend_Translate Object()
Zend_View_Helper_Doctype => ArrayObject Object()
Zend_View_Helper_Placeholder_Registry => Zend_View_Helper_Placeholder_Registry Object()
appType => 'frontend'
config => Zend_Config_Ini Object()
configSection => 'live'
db => Tajfun_Db_Adapter_Pdo_Mysql Object()
lang => 'de'
locale => Zend_Locale Object()
localeString => 'de_DE'
moduleConfig => Zend_Config_Ini Object()
routesConfig => Zend_Config_Ini Object()

Cookies

 

Database queries – Metadata cache ENABLED

0.31ms connect
0.32ms SELECT `products_folders`.*, `entities`.* FROM `products_folders` INNER JOIN `entities` ON `entities`.entity_id = `products_folders`.entity_id
0.09ms SELECT `products_folders`.`folder_id`, `products_folders`.`parent_id` FROM `products_folders`
1.74ms SELECT `products`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name`, `perex_translation`.`value_text` AS `Xtranslated_perex`, `perex_markup_translation`.`value_text` AS `Xtranslated_perex_markup`, `text_translation`.`value_text` AS `Xtranslated_text`, `text_markup_translation`.`value_text` AS `Xtranslated_text_markup` FROM `products` INNER JOIN `entities` ON `entities`.entity_id = `products`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_translations` AS `perex_translation` ON perex_translation.entity_id = entities.entity_id and perex_translation.column_key = "perex" and perex_translation.lang = "de" LEFT JOIN `entities_translations` AS `perex_markup_translation` ON perex_markup_translation.entity_id = entities.entity_id and perex_markup_translation.column_key = "perex_markup" and perex_markup_translation.lang = "de" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "de" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (rewrite_url = 'fiat-500-c-riva') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.09ms SELECT `products_folders`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name`, `text_markup_translation`.`value_text` AS `Xtranslated_text_markup`, `text_translation`.`value_text` AS `Xtranslated_text` FROM `products_folders` INNER JOIN `entities` ON `entities`.entity_id = `products_folders`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "de" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (rewrite_url = 'preowned-yachts') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.10ms SELECT `products_brokers`.*, `entities`.* FROM `products_brokers` INNER JOIN `entities` ON `entities`.entity_id = `products_brokers`.entity_id LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (((`products_brokers`.`broker_id` = 3))) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de')
1.63ms SELECT `products_folders`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name`, `text_markup_translation`.`value_text` AS `Xtranslated_text_markup`, `text_translation`.`value_text` AS `Xtranslated_text` FROM `products_folders` INNER JOIN `entities` ON `entities`.entity_id = `products_folders`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "de" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (folder_id in (select folder_id from products_folders_associated where product_id = '451')) AND (folder_id in ('25', '26', '27', '28', '29', '30', '31', '32', '33', '34', '35', '36', '37', '38', '39', '40', '41', '42', '43', '44', '45', '46', '47', '48', '49', '51', '52', '53', '54', '55', '56', '57', '58', '59', '60', '63', '64', '65', '66', '67', '68', '69', '70', '71', '72', '73', '74', '75', '76', '77', '78', '79', '80', '81', '83', '84', '85', '86')) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
6.84ms SELECT `products_folders`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name`, `text_markup_translation`.`value_text` AS `Xtranslated_text_markup`, `text_translation`.`value_text` AS `Xtranslated_text` FROM `products_folders` INNER JOIN `entities` ON `entities`.entity_id = `products_folders`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "de" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:17')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:17')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') ORDER BY `priority` ASC
2.01ms SELECT `products`.*, `entities`.*, `products_folders_associated`.*, `name_translation`.`value_varchar` AS `Xtranslated_name`, `perex_translation`.`value_text` AS `Xtranslated_perex`, `perex_markup_translation`.`value_text` AS `Xtranslated_perex_markup`, `text_translation`.`value_text` AS `Xtranslated_text`, `text_markup_translation`.`value_text` AS `Xtranslated_text_markup` FROM `products` INNER JOIN `entities` ON `entities`.entity_id = `products`.entity_id LEFT JOIN `products_folders_associated` ON products_folders_associated.product_id = products.product_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_translations` AS `perex_translation` ON perex_translation.entity_id = entities.entity_id and perex_translation.column_key = "perex" and perex_translation.lang = "de" LEFT JOIN `entities_translations` AS `perex_markup_translation` ON perex_markup_translation.entity_id = entities.entity_id and perex_markup_translation.column_key = "perex_markup" and perex_markup_translation.lang = "de" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "de" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (products_folders_associated.folder_id = '27') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:17')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:17')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') ORDER BY `products_folders_associated`.`priority` ASC
0.78ms SELECT `products_brands`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name`, `text_markup_translation`.`value_text` AS `Xtranslated_text_markup`, `text_translation`.`value_text` AS `Xtranslated_text` FROM `products_brands` INNER JOIN `entities` ON `entities`.entity_id = `products_brands`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "de" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`brand_id` = 68) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
2.73ms SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.slave_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_translations` AS `description_translation` ON description_translation.entity_id = entities.entity_id and description_translation.column_key = "description" and description_translation.lang = "de" LEFT JOIN `entities_translations` AS `description_markup_translation` ON description_markup_translation.entity_id = entities.entity_id and description_markup_translation.column_key = "description_markup" and description_markup_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '125011') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:17')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:17')) AND ((publish = 1)) AND (relation_type = 'image') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'de') UNION SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.master_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_translations` AS `description_translation` ON description_translation.entity_id = entities.entity_id and description_translation.column_key = "description" and description_translation.lang = "de" LEFT JOIN `entities_translations` AS `description_markup_translation` ON description_markup_translation.entity_id = entities.entity_id and description_markup_translation.column_key = "description_markup" and description_markup_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '125011') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:17')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:17')) AND ((publish = 1)) AND (relation_type = 'image') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'de') ORDER BY `relation_priority` asc
1.43ms SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.slave_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_translations` AS `description_translation` ON description_translation.entity_id = entities.entity_id and description_translation.column_key = "description" and description_translation.lang = "de" LEFT JOIN `entities_translations` AS `description_markup_translation` ON description_markup_translation.entity_id = entities.entity_id and description_markup_translation.column_key = "description_markup" and description_markup_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '125011') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:17')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:17')) AND ((publish = 1)) AND (relation_type = 'exterior') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'de') UNION SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.master_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_translations` AS `description_translation` ON description_translation.entity_id = entities.entity_id and description_translation.column_key = "description" and description_translation.lang = "de" LEFT JOIN `entities_translations` AS `description_markup_translation` ON description_markup_translation.entity_id = entities.entity_id and description_markup_translation.column_key = "description_markup" and description_markup_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '125011') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:17')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:17')) AND ((publish = 1)) AND (relation_type = 'exterior') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'de') ORDER BY `relation_priority` asc
1.38ms SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.slave_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_translations` AS `description_translation` ON description_translation.entity_id = entities.entity_id and description_translation.column_key = "description" and description_translation.lang = "de" LEFT JOIN `entities_translations` AS `description_markup_translation` ON description_markup_translation.entity_id = entities.entity_id and description_markup_translation.column_key = "description_markup" and description_markup_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '125011') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:17')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:17')) AND ((publish = 1)) AND (relation_type = 'interior') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'de') UNION SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.master_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_translations` AS `description_translation` ON description_translation.entity_id = entities.entity_id and description_translation.column_key = "description" and description_translation.lang = "de" LEFT JOIN `entities_translations` AS `description_markup_translation` ON description_markup_translation.entity_id = entities.entity_id and description_markup_translation.column_key = "description_markup" and description_markup_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '125011') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:17')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:17')) AND ((publish = 1)) AND (relation_type = 'interior') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'de') ORDER BY `relation_priority` asc
1.32ms SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.slave_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_translations` AS `description_translation` ON description_translation.entity_id = entities.entity_id and description_translation.column_key = "description" and description_translation.lang = "de" LEFT JOIN `entities_translations` AS `description_markup_translation` ON description_markup_translation.entity_id = entities.entity_id and description_markup_translation.column_key = "description_markup" and description_markup_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '125011') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:17')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:17')) AND ((publish = 1)) AND (relation_type = 'layout') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'de') UNION SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.master_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_translations` AS `description_translation` ON description_translation.entity_id = entities.entity_id and description_translation.column_key = "description" and description_translation.lang = "de" LEFT JOIN `entities_translations` AS `description_markup_translation` ON description_markup_translation.entity_id = entities.entity_id and description_markup_translation.column_key = "description_markup" and description_markup_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '125011') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:17')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:17')) AND ((publish = 1)) AND (relation_type = 'layout') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'de') ORDER BY `relation_priority` asc
1.23ms SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.slave_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_translations` AS `description_translation` ON description_translation.entity_id = entities.entity_id and description_translation.column_key = "description" and description_translation.lang = "de" LEFT JOIN `entities_translations` AS `description_markup_translation` ON description_markup_translation.entity_id = entities.entity_id and description_markup_translation.column_key = "description_markup" and description_markup_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '125011') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:17')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:17')) AND ((publish = 1)) AND (relation_type = 'documents') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'de') UNION SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.master_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_translations` AS `description_translation` ON description_translation.entity_id = entities.entity_id and description_translation.column_key = "description" and description_translation.lang = "de" LEFT JOIN `entities_translations` AS `description_markup_translation` ON description_markup_translation.entity_id = entities.entity_id and description_markup_translation.column_key = "description_markup" and description_markup_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '125011') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:17')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:17')) AND ((publish = 1)) AND (relation_type = 'documents') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'de') ORDER BY `relation_priority` asc
0.52ms SELECT `products_templates`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_templates` INNER JOIN `entities` ON `entities`.entity_id = `products_templates`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`template_id` = 1) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.13ms SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.slave_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_translations` AS `description_translation` ON description_translation.entity_id = entities.entity_id and description_translation.column_key = "description" and description_translation.lang = "de" LEFT JOIN `entities_translations` AS `description_markup_translation` ON description_markup_translation.entity_id = entities.entity_id and description_markup_translation.column_key = "description_markup" and description_markup_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '125011') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:17')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:17')) AND ((publish = 1)) AND (relation_type = 'exterior') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'de') UNION SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.master_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_translations` AS `description_translation` ON description_translation.entity_id = entities.entity_id and description_translation.column_key = "description" and description_translation.lang = "de" LEFT JOIN `entities_translations` AS `description_markup_translation` ON description_markup_translation.entity_id = entities.entity_id and description_markup_translation.column_key = "description_markup" and description_markup_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '125011') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:17')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:17')) AND ((publish = 1)) AND (relation_type = 'exterior') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'de') ORDER BY `relation_priority` asc
0.13ms SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.slave_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_translations` AS `description_translation` ON description_translation.entity_id = entities.entity_id and description_translation.column_key = "description" and description_translation.lang = "de" LEFT JOIN `entities_translations` AS `description_markup_translation` ON description_markup_translation.entity_id = entities.entity_id and description_markup_translation.column_key = "description_markup" and description_markup_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '125011') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:17')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:17')) AND ((publish = 1)) AND (relation_type = 'interior') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'de') UNION SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.master_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_translations` AS `description_translation` ON description_translation.entity_id = entities.entity_id and description_translation.column_key = "description" and description_translation.lang = "de" LEFT JOIN `entities_translations` AS `description_markup_translation` ON description_markup_translation.entity_id = entities.entity_id and description_markup_translation.column_key = "description_markup" and description_markup_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '125011') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:17')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:17')) AND ((publish = 1)) AND (relation_type = 'interior') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'de') ORDER BY `relation_priority` asc
1.02ms SELECT `products_templates_groups`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_templates_groups` INNER JOIN `entities` ON `entities`.entity_id = `products_templates_groups`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`template_id` = 1) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de')
0.11ms SELECT `products_templates_properties`.* FROM `products_templates_properties` WHERE (`group_id` = 1)
0.10ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 34) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.10ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'motors') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.10ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '34') LIMIT 1
0.09ms SELECT `products_templates_properties`.* FROM `products_templates_properties` WHERE (`group_id` = 2)
0.15ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 18) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.11ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'maximum-speed') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.06ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '18') LIMIT 1
0.07ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 19) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.10ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'cruising-speed') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '19') LIMIT 1
0.58ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 36) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.50ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'transer-speed') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '36') LIMIT 1
0.40ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 37) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.55ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'displacement-speed') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '37') LIMIT 1
0.07ms SELECT `products_templates_properties`.* FROM `products_templates_properties` WHERE (`group_id` = 3)
0.10ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 22) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.09ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'maximum_speed_nm') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.09ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '22') LIMIT 1
0.10ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 23) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.10ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'cruising_speed_nm') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '23') LIMIT 1
0.42ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 24) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.36ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'long-range-cruising-speed-at-11-5-knots') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.13ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '24') LIMIT 1
0.10ms SELECT `products_templates_properties`.* FROM `products_templates_properties` WHERE (`group_id` = 4)
0.09ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 4) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.09ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'overall-length') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '4') LIMIT 1
0.44ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 5) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.47ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'hull-length') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '5') LIMIT 1
0.42ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 6) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.43ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'waterline-length') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '6') LIMIT 1
0.08ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 7) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.09ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'Beam') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '7') LIMIT 1
0.08ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 8) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.08ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'depth-under-propellers') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '8') LIMIT 1
0.07ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 9) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.09ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'displacement-unladen') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '9') LIMIT 1
0.42ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 10) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.43ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'displacement-laden') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '10') LIMIT 1
0.11ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 11) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.09ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'maximum-number-of-persons-on-board') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '11') LIMIT 1
0.08ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 12) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.09ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'design-category-ce-2003-44') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '12') LIMIT 1
0.15ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 13) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.08ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'certification-modules') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '13') LIMIT 1
0.08ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 20) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.09ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'cabins') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.09ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '20') LIMIT 1
0.52ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 38) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.55ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'gross-tonnage') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '38') LIMIT 1
0.11ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 39) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.09ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'net-tonnage') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.06ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '39') LIMIT 1
0.50ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 42) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.40ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'draft-boat-fully-laden') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '42') LIMIT 1
0.13ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 44) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.09ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'crew-cabins-with-head') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '44') LIMIT 1
0.08ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 45) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.09ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'heads') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '45') LIMIT 1
0.09ms SELECT `products_templates_properties`.* FROM `products_templates_properties` WHERE (`group_id` = 5)
0.64ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 25) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.33ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'overall-height-from-keel-to-hard-top') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '25') LIMIT 1
0.40ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 26) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.34ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'minimum-transport-height-from-keel') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.06ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '26') LIMIT 1
0.35ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 27) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.32ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'bow-pulpit') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '27') LIMIT 1
0.33ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 28) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.42ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'stern-platform') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '28') LIMIT 1
0.08ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 29) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.08ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'fuel-tanks-capacity') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.06ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '29') LIMIT 1
0.07ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 30) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.07ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'water-tanks-capacity') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.10ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '30') LIMIT 1
0.39ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 35) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.34ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'hawse') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '35') LIMIT 1
0.57ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 43) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.39ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'propulsion') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '43') LIMIT 1
0.49ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 46) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.39ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'safety-equipment') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.10ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '46') LIMIT 1
0.45ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 47) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.36ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'homologation-category') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '47') LIMIT 1
0.10ms SELECT `products_templates_properties`.* FROM `products_templates_properties` WHERE (`group_id` = 6)
0.45ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 31) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.33ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'standard-version-displacement-of-the-yacht') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '31') LIMIT 1
0.48ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 32) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.44ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'overloading-the-yacht-by') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '32') LIMIT 1
0.51ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 33) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.44ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'top-speed-decreases-of') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '33') LIMIT 1
0.08ms SELECT `products_templates_properties`.* FROM `products_templates_properties` WHERE (group_id is null) AND (`template_id` = 1)
0.07ms SELECT `products_templates_properties`.* FROM `products_templates_properties` WHERE (group_id is null) AND (`template_id` = 1)
0.11ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 14) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.08ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'year') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.06ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '14') LIMIT 1
0.07ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`property_id` = 16) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.08ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (code = 'location') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.09ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '451') AND (property_id = '16') LIMIT 1
0.12ms SELECT `pages`.*, `entities`.*, `title_translation`.`value_varchar` AS `Xtranslated_title`, `full_title_translation`.`value_varchar` AS `Xtranslated_full_title`, `text_markup_translation`.`value_longtext` AS `Xtranslated_text_markup`, `text_translation`.`value_longtext` AS `Xtranslated_text` FROM `pages` INNER JOIN `entities` ON `entities`.entity_id = `pages`.entity_id LEFT JOIN `entities_translations` AS `title_translation` ON title_translation.entity_id = entities.entity_id and title_translation.column_key = "title" and title_translation.lang = "de" LEFT JOIN `entities_translations` AS `full_title_translation` ON full_title_translation.entity_id = entities.entity_id and full_title_translation.column_key = "full_title" and full_title_translation.lang = "de" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "de" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (rewrite_url = 'preowned-yachts') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
3.45ms SELECT `pages`.*, `entities`.*, `title_translation`.`value_varchar` AS `Xtranslated_title`, `full_title_translation`.`value_varchar` AS `Xtranslated_full_title`, `text_markup_translation`.`value_longtext` AS `Xtranslated_text_markup`, `text_translation`.`value_longtext` AS `Xtranslated_text` FROM `pages` INNER JOIN `entities` ON `entities`.entity_id = `pages`.entity_id INNER JOIN `pages_folders` ON `pages_folders`.folder_id = `pages`.folder_id LEFT JOIN `entities_translations` AS `title_translation` ON title_translation.entity_id = entities.entity_id and title_translation.column_key = "title" and title_translation.lang = "de" LEFT JOIN `entities_translations` AS `full_title_translation` ON full_title_translation.entity_id = entities.entity_id and full_title_translation.column_key = "full_title" and full_title_translation.lang = "de" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "de" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (parent_id is null) AND (code = 'mainmenu') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:17')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:17')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') ORDER BY `priority` ASC
0.12ms SELECT `pages`.*, `entities`.*, `title_translation`.`value_varchar` AS `Xtranslated_title`, `full_title_translation`.`value_varchar` AS `Xtranslated_full_title`, `text_markup_translation`.`value_longtext` AS `Xtranslated_text_markup`, `text_translation`.`value_longtext` AS `Xtranslated_text` FROM `pages` INNER JOIN `entities` ON `entities`.entity_id = `pages`.entity_id LEFT JOIN `entities_translations` AS `title_translation` ON title_translation.entity_id = entities.entity_id and title_translation.column_key = "title" and title_translation.lang = "de" LEFT JOIN `entities_translations` AS `full_title_translation` ON full_title_translation.entity_id = entities.entity_id and full_title_translation.column_key = "full_title" and full_title_translation.lang = "de" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "de" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (rewrite_url = 'service') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.11ms SELECT `pages`.*, `entities`.*, `title_translation`.`value_varchar` AS `Xtranslated_title`, `full_title_translation`.`value_varchar` AS `Xtranslated_full_title`, `text_markup_translation`.`value_longtext` AS `Xtranslated_text_markup`, `text_translation`.`value_longtext` AS `Xtranslated_text` FROM `pages` INNER JOIN `entities` ON `entities`.entity_id = `pages`.entity_id LEFT JOIN `entities_translations` AS `title_translation` ON title_translation.entity_id = entities.entity_id and title_translation.column_key = "title" and title_translation.lang = "de" LEFT JOIN `entities_translations` AS `full_title_translation` ON full_title_translation.entity_id = entities.entity_id and full_title_translation.column_key = "full_title" and full_title_translation.lang = "de" LEFT JOIN `entities_translations` AS `text_markup_translation` ON text_markup_translation.entity_id = entities.entity_id and text_markup_translation.column_key = "text_markup" and text_markup_translation.lang = "de" LEFT JOIN `entities_translations` AS `text_translation` ON text_translation.entity_id = entities.entity_id and text_translation.column_key = "text" and text_translation.lang = "de" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (rewrite_url = 'charter') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1