back

Dominator 780 S

IMPECCABLE CONDITION

Drydock incl. underwater hp wash, primer, 2 x antifouling, chemical polishing of entire hull, teak upgrades & refurbishment, full engine service incl. cleaning of turbo chargers, intercoolers, change of injector needles, bearings & thermostats, change of impeller pumbs & air -& fuel filters, full generator service incl. change of impeller pumps and cooling lines, full service of HP Watermaker, full service of AC units, full service of Williams & Seadoo, full service of lifesaving equipment and certification, full service of bow & stern thruster, full service of anchor motor

video

Engines2 x1800 HP MAN V12
Overall length23.95 m
Beam6.05 m
Year2009
LocationAthens, Greece
Cabins4
Fuel tanks capacity7500 lt. (Liter)
Water tanks capacity1500 lt. (Liter)
Crew cabins with head2

Extra options

Aircondition 100.000 BTU
Autopilot Raytheon Pilothouse & Fly
2 x Raymarine Color Radar/GPS/Plot­ter/Depthfinder/Vi­deo
2 x VHF for Pilothouse & Fly
2 x Windindicator
2 x Simrad IS 15 Log Pilot + Fly
2 x Simrad IS 15 Echosounder Pilot + Fly
2 x Simrad IS 15 Electronic Compass Pilot + Fly
Holding Tank
Automatical Antifire System
Anchor Wash
2 x Racor Fuel Filters
Hydraulic Bathing Ladder
Electronic Gas-gearshift Microkommand/Man­nesmann
Crane on fly for Williams / Jetski
Bordcomputer / Digital Engine Instruments Pilot + Fly
2 x Winches in Cockpit
Bowthruster 280hp electric
Barbecue w Fridge on Fly
Ceran Cooking Plate, Dishwasher, Oven/Micro Combi, Icemaker
Fridge, Freezer, Winecooler, Safe
All cabins & public rooms with Bose Sound System
Crew Cabin & Pilothouse access door electrohydraulic w/ remote
Hydraulic Gangway lighted

Rlla propeller, Watermaker HP
Hydraulic sliding bathing plattform, 2×12 person life rafts
Upgrading to onyx owner, VIP and guest bathrooms incl. floors
Handmade sink in Onyx in owner cabin
Owner and VIP bed heads in Imperial leather upgrading
Silhouette curtains in night zone, Electric blinds
All interior lights in LED, 5 external lights on the sofa back
Dimmers for all cabins, Wood: Ebona, Supported Marble two colours all bathrooms
Entrance in salon in onyx with 4 leds, entire interious deluxe w/leather
Tropical Climate Version AC Unit
Full Winter Cover
Jacuzzi on bow area
Bimini top in box area forward, Bimini top hydr. on fly with led lighting
Teak on fly & crew area
Additional fridge 42ltr on corridor for guest area
SAT-Communication / Telephone / Email
All Raymarine Displays upgraded to 15“
Jet Tender Williams 385

made by Vergilio

  ZFDebug log Log variables Variables database 109 in 45.03 ms 9415K in 962ms

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

757ms2600KStartup - ZFDebug construct()
19ms1587KRoute
136ms3903KproductsController::detailAction
168ms4732KDispatch
962ms9123KShutdown

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'
module => 'products'
rewrite_url => 'dominator-780-s'

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 => 'en'
locale => Zend_Locale Object()
localeString => 'en_US'
moduleConfig => Zend_Config_Ini Object()
routesConfig => Zend_Config_Ini Object()

Cookies

 

Database queries – Metadata cache ENABLED

0.55ms connect
0.39ms SELECT `products_folders`.*, `entities`.* FROM `products_folders` INNER JOIN `entities` ON `entities`.entity_id = `products_folders`.entity_id
0.13ms SELECT `products_folders`.`folder_id`, `products_folders`.`parent_id` FROM `products_folders`
2.23ms 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 = "en" 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 = "en" 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (rewrite_url = 'dominator-780-s') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.14ms 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 = "en" 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 = "en" 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 = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.54ms 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` = 5))) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en')
1.92ms 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 = "en" 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 = "en" 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 = "en" 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 = '445')) 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
8.89ms 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 = "en" 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 = "en" 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 = "en" 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:58:40')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:58:40')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') ORDER BY `priority` ASC
1.51ms 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 = "en" 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 = "en" 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (products_folders_associated.folder_id = '64') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:58:40')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:58:40')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') ORDER BY `products_folders_associated`.`priority` ASC
0.67ms 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (`brand_id` = 41) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
2.40ms 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '121263') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:58:40')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:58:40')) AND ((publish = 1)) AND (relation_type = 'image') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'en') 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '121263') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:58:40')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:58:40')) AND ((publish = 1)) AND (relation_type = 'image') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'en') ORDER BY `relation_priority` asc
2.11ms 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '121263') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:58:40')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:58:40')) AND ((publish = 1)) AND (relation_type = 'exterior') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'en') 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '121263') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:58:40')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:58:40')) AND ((publish = 1)) AND (relation_type = 'exterior') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'en') ORDER BY `relation_priority` asc
1.60ms 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '121263') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:58:40')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:58:40')) AND ((publish = 1)) AND (relation_type = 'interior') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'en') 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '121263') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:58:40')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:58:40')) AND ((publish = 1)) AND (relation_type = 'interior') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'en') ORDER BY `relation_priority` asc
1.43ms SELECT `documents`.*, `entities`.*, `entities_related`.`relation_id`, `entities_related`.`priority` AS `relation_priority`, `name_translation`.`value_varchar` AS `Xtranslated_name`, `description_translation`.`value_text` AS `Xtranslated_description`, `description_markup_translation`.`value_text` AS `Xtranslated_description_markup` FROM `documents` INNER JOIN `entities` ON `entities`.entity_id = `documents`.entity_id INNER JOIN `entities_related` ON entities.entity_id = entities_related.slave_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '121263') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:58:40')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:58:40')) AND ((publish = 1)) AND (relation_type = 'layout') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'en') 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '121263') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:58:40')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:58:40')) AND ((publish = 1)) AND (relation_type = 'layout') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'en') ORDER BY `relation_priority` asc
1.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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '121263') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:58:40')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:58:40')) AND ((publish = 1)) AND (relation_type = 'documents') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'en') 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '121263') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:58:40')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:58:40')) AND ((publish = 1)) AND (relation_type = 'documents') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'en') ORDER BY `relation_priority` asc
0.53ms 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 = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.15ms 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '121263') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:58:40')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:58:40')) AND ((publish = 1)) AND (relation_type = 'exterior') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'en') 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '121263') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:58:40')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:58:40')) AND ((publish = 1)) AND (relation_type = 'exterior') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'en') ORDER BY `relation_priority` asc
0.19ms 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '121263') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:58:40')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:58:40')) AND ((publish = 1)) AND (relation_type = 'interior') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'en') 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '121263') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:58:40')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:58:40')) AND ((publish = 1)) AND (relation_type = 'interior') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'en') ORDER BY `relation_priority` asc
0.17ms 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl1` ON ebl1.entity_id = entities.entity_id WHERE (entities_related.master_id = '121263') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:58:40')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:58:40')) AND ((publish = 1)) AND (relation_type = 'layout') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'en') 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 = "en" 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 = "en" 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 = "en" LEFT JOIN `entities_banned_langs` AS `ebl2` ON ebl2.entity_id = entities.entity_id WHERE (entities_related.slave_id = '121263') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:58:40')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:58:40')) AND ((publish = 1)) AND (relation_type = 'layout') AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'en') ORDER BY `relation_priority` asc
0.69ms 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 = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en')
0.44ms SELECT `products_templates_properties`.* FROM `products_templates_properties` WHERE (`group_id` = 11)
0.69ms 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 = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') 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 = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.35ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '445') AND (property_id = '1') LIMIT 1
0.13ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.07ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.22ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '445') AND (property_id = '4') LIMIT 1
0.43ms 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 = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.11ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.09ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.22ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '445') AND (property_id = '7') 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 = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.09ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.07ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.18ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '445') AND (property_id = '8') LIMIT 1
0.08ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.07ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.21ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '445') AND (property_id = '9') LIMIT 1
0.10ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.08ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.13ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '445') AND (property_id = '11') LIMIT 1
0.07ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.08ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.21ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '445') AND (property_id = '12') LIMIT 1
0.10ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.10ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.19ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '445') AND (property_id = '13') LIMIT 1
0.09ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.07ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.20ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '445') AND (property_id = '14') LIMIT 1
0.33ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') 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 = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.19ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '445') AND (property_id = '15') LIMIT 1
0.11ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.07ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.21ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '445') AND (property_id = '16') LIMIT 1
0.54ms SELECT `products_properties_enums`.* FROM `products_properties_enums` WHERE (`enum_id` = 50) LIMIT 1
0.28ms 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 = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.31ms 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 = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.20ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '445') AND (property_id = '17') LIMIT 1
0.06ms 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 = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.08ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.15ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '445') AND (property_id = '18') LIMIT 1
0.07ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.06ms 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 = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.20ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '445') AND (property_id = '19') LIMIT 1
0.07ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.06ms 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 = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.21ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '445') AND (property_id = '20') LIMIT 1
0.29ms 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 = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.33ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.13ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '445') AND (property_id = '21') LIMIT 1
0.07ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.07ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.13ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '445') AND (property_id = '22') LIMIT 1
0.07ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.09ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.11ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '445') AND (property_id = '23') LIMIT 1
0.10ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.08ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.23ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '445') AND (property_id = '29') LIMIT 1
0.27ms 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 = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.08ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.07ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.26ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '445') AND (property_id = '30') LIMIT 1
0.07ms 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 = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.09ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.07ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.18ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '445') AND (property_id = '34') LIMIT 1
0.07ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.07ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.14ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '445') AND (property_id = '39') LIMIT 1
0.07ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.07ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.20ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '445') AND (property_id = '44') LIMIT 1
0.07ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.07ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.16ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '445') AND (property_id = '45') LIMIT 1
0.15ms SELECT `products_templates_properties`.* FROM `products_templates_properties` WHERE (`group_id` = 12)
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 = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.33ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.23ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '445') AND (property_id = '49') LIMIT 1
0.07ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '445') AND (property_id = '49') LIMIT 1
0.18ms SELECT `products_templates_properties`.* FROM `products_templates_properties` WHERE (group_id is null) AND (`template_id` = 4)
1.08ms 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 = "en" 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 = "en" 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 = "en" 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 = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
2.15ms 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 = "en" 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 = "en" 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 = "en" 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 = "en" 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:58:40')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:58:40')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') ORDER BY `priority` ASC
0.11ms SELECT `pages`.*, `entities`.*, `title_translation`.`value_varchar` AS `Xtranslated_title`, `full_title_translation`.`value_varchar` AS `Xtranslated_full_title`, `text_markup_translation`.`value_longtext` AS `Xtranslated_text_markup`, `text_translation`.`value_longtext` AS `Xtranslated_text` FROM `pages` INNER JOIN `entities` ON `entities`.entity_id = `pages`.entity_id LEFT JOIN `entities_translations` AS `title_translation` ON title_translation.entity_id = entities.entity_id and title_translation.column_key = "title" and title_translation.lang = "en" 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 = "en" 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 = "en" 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 = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1
0.11ms SELECT `pages`.*, `entities`.*, `title_translation`.`value_varchar` AS `Xtranslated_title`, `full_title_translation`.`value_varchar` AS `Xtranslated_full_title`, `text_markup_translation`.`value_longtext` AS `Xtranslated_text_markup`, `text_translation`.`value_longtext` AS `Xtranslated_text` FROM `pages` INNER JOIN `entities` ON `entities`.entity_id = `pages`.entity_id LEFT JOIN `entities_translations` AS `title_translation` ON title_translation.entity_id = entities.entity_id and title_translation.column_key = "title" and title_translation.lang = "en" 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 = "en" 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 = "en" 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 = "en" 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 = 'en') AND (ebl.entity_id IS NULL OR ebl.lang != 'en') LIMIT 1