zurück

Pershing 74 #05 ARYA

By far the BEST Pershing 74 on the market. 

All services done in August 2017, tax paid, first owner, EU VAT paid, fantastic condition!

Don't miss this amazing opportunity!

video

Engines2 X 1948 MTU+ZF Searex SR14OS
Overall length22.66 m
Beam5.5 m
Depth under propellers1.45 m
Displacement unladen45.7 t (tonne)
Maximum number of persons on board12
Design category CE 2003/44A
Certification modulesB+F+Aa (sound emissions)
Year2013
Length22,66 m
LocationZadar, Croatia
FlagCroatia
Maximum speed44 kn
Cruising speed40 kn
Cabins3
Beds6
Maximum speed44 nautical miles
Cruising speed40 nautical miles
Fuel tanks capacity4500 lt. (Liter)
Water tanks capacity990 lt. (Liter)

2 x MTU 1948 hp / 1432 kW @ 2450 revolutions

12V, 2000 M94 MTU 

Net tonnage4626 tsn.
Crew cabins with head1

Extra options

Mooring cleats, side, retractable (couple) on the bathing platform
Electric curtains: cabins + upper salon
Cover for windshield
Barbecue in the cockpit 220 V
Xeno lights under bathing platform (2×)
Gelcoat + varnish kit
Second helm station + furniture/seat on the Sun Deck
Painting of the hull Silver Metallic 977
TVCC: thermal night vision Flir Pan/Tilt „Navigator“ camera
Additional capstan 1200 W
Inverter Mastervolt Mass Sine 24V 2500W
Waterproof covers for sun pads, outside sofas and tables
STEEL ANCHOR
Chain counter: digital -each- (1×)
Dimmer lights in cockpit
Dimmer for lights in Master Cabin
Teak on sidewalks and on foredeck
Upper salon fridge
Tiller
Auto Trim for Searex surface drives
Jet-ski winch in the garage + rolls kit
Sun canopy (manual)
Watermaker 180 l/h Idromar
Master cabin's dresser – diff from std
Aft camera

Waterproof covering for driving station on sun deck
Handshower for WC
Simrad Open Array antenna
Boat name in stainless steel letters (backlit, 5 letters)
Do not install bidet in master bathroom, but install the wc in central position
Electric stern thruster 15 HP (double propeller) – proportional
Wine cellar
Furniture wood finishing diff from std
Carpet in VIP, guest and corridor: Louis de Portere president n. 7022. carpet in master cabin: Louis de Portere president 7024
The flooring in saloon, galley, heads and steps diff. Cadorin walnut tissue powder white gold
Upper saloon rug diff from std
Lisage curtains in saloon diff from std ( except back door)
Mosaic in VIP and guest shower and shower floor diff


Curtains compartment in wood, not leather
All galley appliances of one brand (MIELE – except hood and fridge)
Dishwasher 60cm diff from std and storage on side (MIELE)
Modification of master shower and crew bathroom
Repetition anchor alarm from plotter in master cabin
Stern thruster with power control (upgrade)
Chain diameter 14 mm diff from std
Mooring cleats diff from std
Teak floor inside hatch on bathing platform
Move wine cellar instead of std washer/dryer
Galley first and second drawer rack for cutlery ( std set for 8)
Ceiling superstructure in white, not black
Cockpit table in VTR diff from std
Separate washer and dryer unit (MIELE)
N.2 hand showers instead of std heat shower in master bathroom
Sockets outside waterproof

made by Vergiliem

  ZFDebug log Log variables Variables database 120 in 72.51 ms 10055K in 1076ms

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

779ms2601KStartup - ZFDebug construct()
29ms1587KRoute
215ms4493KproductsController::detailAction
258ms5334KDispatch
1076ms9735KShutdown

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 => 'Pershing-74-04'

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.42ms connect
0.46ms SELECT `products_folders`.*, `entities`.* FROM `products_folders` INNER JOIN `entities` ON `entities`.entity_id = `products_folders`.entity_id
0.27ms SELECT `products_folders`.`folder_id`, `products_folders`.`parent_id` FROM `products_folders`
0.95ms 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 = 'Pershing-74-04') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.74ms 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.36ms 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')
0.94ms 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 = '398')) 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
3.50ms 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:47:10')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:47:10')) 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.79ms 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 = '26') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:47:10')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:47:10')) 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.68ms 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` = 1) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
2.76ms 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 = '40020') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:47:10')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:47:10')) 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 = '40020') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:47:10')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:47:10')) 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
5.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 = '40020') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:47:10')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:47:10')) 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 = '40020') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:47:10')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:47:10')) 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
2.91ms 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 = '40020') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:47:10')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:47:10')) 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 = '40020') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:47:10')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:47:10')) 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
2.24ms 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 = '40020') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:47:10')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:47:10')) 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 = '40020') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:47:10')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:47:10')) 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.84ms 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 = '40020') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:47:10')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:47:10')) 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 = '40020') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:47:10')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:47:10')) 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.36ms 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` = 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.27ms 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 = '40020') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:47:10')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:47:10')) 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 = '40020') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:47:10')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:47:10')) 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.25ms 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 = '40020') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:47:10')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:47:10')) 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 = '40020') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:47:10')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:47:10')) 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
0.16ms 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 = '40020') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:47:10')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:47:10')) 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 = '40020') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:47:10')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:47:10')) 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
0.58ms 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` = 4) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de')
0.08ms SELECT `products_templates_properties`.* FROM `products_templates_properties` WHERE (`group_id` = 11)
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` = 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.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 = 'engines') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.19ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '1') 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 (`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.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 (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.16ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '4') LIMIT 1
0.34ms SELECT `products_units`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_units` INNER JOIN `entities` ON `entities`.entity_id = `products_units`.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 (`unit_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.54ms 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.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 (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.22ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '7') LIMIT 1
0.08ms SELECT `products_units`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_units` INNER JOIN `entities` ON `entities`.entity_id = `products_units`.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 (`unit_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.84ms 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.46ms 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.20ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '8') LIMIT 1
0.08ms SELECT `products_units`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_units` INNER JOIN `entities` ON `entities`.entity_id = `products_units`.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 (`unit_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.61ms 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.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 = '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.19ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '9') LIMIT 1
0.41ms SELECT `products_units`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_units` INNER JOIN `entities` ON `entities`.entity_id = `products_units`.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 (`unit_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.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 (`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.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 = '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.19ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '11') 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 (`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.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 = '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.18ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '12') 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` = 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.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 = '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.21ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '13') 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` = 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.37ms 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.15ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '14') LIMIT 1
0.30ms 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` = 15) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') 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 (code = '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.22ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '15') LIMIT 1
0.10ms SELECT `products_units`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_units` INNER JOIN `entities` ON `entities`.entity_id = `products_units`.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 (`unit_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.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` = 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.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 = '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.22ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '16') LIMIT 1
0.17ms SELECT `products_properties_enums`.* FROM `products_properties_enums` WHERE (`enum_id` = 7) 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` = 17) 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 = 'flag') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.20ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '17') LIMIT 1
0.09ms SELECT `products_properties_enums`.* FROM `products_properties_enums` WHERE (`enum_id` = 3) LIMIT 1
0.41ms 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.41ms 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.22ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '18') LIMIT 1
0.45ms SELECT `products_units`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_units` INNER JOIN `entities` ON `entities`.entity_id = `products_units`.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 (`unit_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.41ms 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.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 = '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.29ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '19') LIMIT 1
0.11ms SELECT `products_units`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_units` INNER JOIN `entities` ON `entities`.entity_id = `products_units`.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 (`unit_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.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` = 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.41ms 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.23ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '20') LIMIT 1
0.46ms 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` = 21) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.70ms 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 = 'beds') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.28ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '21') 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` = 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.38ms 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.21ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '22') LIMIT 1
0.36ms SELECT `products_units`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_units` INNER JOIN `entities` ON `entities`.entity_id = `products_units`.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 (`unit_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.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` = 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.38ms 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.21ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '23') LIMIT 1
0.10ms SELECT `products_units`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_units` INNER JOIN `entities` ON `entities`.entity_id = `products_units`.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 (`unit_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.46ms 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.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 = '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.17ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '29') LIMIT 1
0.33ms SELECT `products_units`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_units` INNER JOIN `entities` ON `entities`.entity_id = `products_units`.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 (`unit_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.53ms 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.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 = '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.21ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '30') LIMIT 1
0.14ms SELECT `products_units`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_units` INNER JOIN `entities` ON `entities`.entity_id = `products_units`.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 (`unit_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.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` = 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.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 = '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.33ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '34') LIMIT 1
0.14ms 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.17ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '34') LIMIT 1
0.74ms 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.56ms 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.24ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '39') LIMIT 1
0.44ms SELECT `products_units`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_units` INNER JOIN `entities` ON `entities`.entity_id = `products_units`.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 (`unit_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.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` = 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.63ms 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.41ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '44') 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` = 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.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 (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.22ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '45') LIMIT 1
0.07ms SELECT `products_templates_properties`.* FROM `products_templates_properties` WHERE (`group_id` = 12)
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 (`property_id` = 49) AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
0.46ms 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 = 'equipment') AND (entities.only_in_own_lang = 0 or entities.lang = 'de') AND (ebl.entity_id IS NULL OR ebl.lang != 'de') LIMIT 1
9.15ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '49') LIMIT 1
0.12ms 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 = '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 = '398') AND (property_id = '49') LIMIT 1
0.07ms SELECT `products_templates_properties`.* FROM `products_templates_properties` WHERE (group_id is null) AND (`template_id` = 4)
1.04ms 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
2.40ms 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:47:11')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:47:11')) 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.18ms 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.16ms 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