zpátky

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

vytvořeno Vergiliem

  ZFDebug log Log variables Variables database 120 in 38.21 ms 10155K in 500ms

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

280ms2601KStartup - ZFDebug construct()
18ms1587KRoute
156ms4576KproductsController::detailAction
189ms5433KDispatch
500ms9834KShutdown

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

Cookies

 

Database queries – Metadata cache ENABLED

0.50ms connect
0.42ms 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`
1.56ms 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 = "cs" 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 = "cs" 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 = "cs" 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 = "cs" 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.15ms 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 = "cs" 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 = "cs" 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.08ms 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs')
1.35ms 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 = "cs" 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 = "cs" 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
5.03ms 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 = "cs" 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 = "cs" 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 = "cs" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:59')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:59')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') ORDER BY `priority` ASC
2.00ms 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 = "cs" 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 = "cs" 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 = "cs" 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 = "cs" 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 = "cs" 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:48:59')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:59')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') ORDER BY `products_folders_associated`.`priority` ASC
0.65ms 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 = "cs" 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 = "cs" 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
1.63ms 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 = "cs" 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 = "cs" 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 = "cs" 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:48:59')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:59')) AND ((publish = 1)) AND (relation_type = 'image') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'cs') 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 = "cs" 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 = "cs" 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 = "cs" 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:48:59')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:59')) AND ((publish = 1)) AND (relation_type = 'image') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'cs') ORDER BY `relation_priority` asc
3.35ms 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 = "cs" 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 = "cs" 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 = "cs" 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:48:59')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:59')) AND ((publish = 1)) AND (relation_type = 'exterior') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'cs') 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 = "cs" 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 = "cs" 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 = "cs" 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:48:59')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:59')) AND ((publish = 1)) AND (relation_type = 'exterior') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'cs') ORDER BY `relation_priority` asc
1.82ms 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 = "cs" 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 = "cs" 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 = "cs" 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:48:59')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:59')) AND ((publish = 1)) AND (relation_type = 'interior') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'cs') 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 = "cs" 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 = "cs" 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 = "cs" 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:48:59')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:59')) AND ((publish = 1)) AND (relation_type = 'interior') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'cs') ORDER BY `relation_priority` asc
1.48ms 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 = "cs" 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 = "cs" 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 = "cs" 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:48:59')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:59')) AND ((publish = 1)) AND (relation_type = 'layout') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'cs') 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 = "cs" 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 = "cs" 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 = "cs" 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:48:59')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:59')) AND ((publish = 1)) AND (relation_type = 'layout') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'cs') ORDER BY `relation_priority` asc
1.31ms 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 = "cs" 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 = "cs" 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 = "cs" 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:48:59')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:59')) AND ((publish = 1)) AND (relation_type = 'documents') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'cs') 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 = "cs" 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 = "cs" 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 = "cs" 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:48:59')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:59')) AND ((publish = 1)) AND (relation_type = 'documents') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'cs') ORDER BY `relation_priority` asc
0.49ms 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.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 = "cs" 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 = "cs" 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 = "cs" 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:48:59')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:59')) AND ((publish = 1)) AND (relation_type = 'exterior') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'cs') 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 = "cs" 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 = "cs" 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 = "cs" 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:48:59')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:59')) AND ((publish = 1)) AND (relation_type = 'exterior') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'cs') 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 = "cs" 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 = "cs" 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 = "cs" 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:48:59')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:59')) AND ((publish = 1)) AND (relation_type = 'interior') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'cs') 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 = "cs" 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 = "cs" 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 = "cs" 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:48:59')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:59')) AND ((publish = 1)) AND (relation_type = 'interior') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'cs') ORDER BY `relation_priority` asc
0.14ms 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 = "cs" 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 = "cs" 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 = "cs" 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:48:59')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:59')) AND ((publish = 1)) AND (relation_type = 'layout') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl1.entity_id IS NULL OR ebl1.lang != 'cs') 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 = "cs" 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 = "cs" 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 = "cs" 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:48:59')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:59')) AND ((publish = 1)) AND (relation_type = 'layout') AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl2.entity_id IS NULL OR ebl2.lang != 'cs') ORDER BY `relation_priority` asc
0.88ms 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs')
0.11ms SELECT `products_templates_properties`.* FROM `products_templates_properties` WHERE (`group_id` = 11)
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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.09ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '1') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '4') LIMIT 1
0.50ms 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '7') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.05ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '8') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '9') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '11') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.05ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '12') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '13') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.05ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '14') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '15') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '16') LIMIT 1
0.07ms SELECT `products_properties_enums`.* FROM `products_properties_enums` WHERE (`enum_id` = 7) 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '17') LIMIT 1
0.10ms SELECT `products_properties_enums`.* FROM `products_properties_enums` WHERE (`enum_id` = 3) 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.06ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '18') LIMIT 1
0.28ms 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.06ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '19') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.06ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.09ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.06ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '22') LIMIT 1
0.61ms 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.07ms 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.06ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '29') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '30') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.06ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '34') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.09ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '34') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '39') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '44') LIMIT 1
0.08ms SELECT `products_properties`.*, `entities`.*, `name_translation`.`value_varchar` AS `Xtranslated_name` FROM `products_properties` INNER JOIN `entities` ON `entities`.entity_id = `products_properties`.entity_id LEFT JOIN `entities_translations` AS `name_translation` ON name_translation.entity_id = entities.entity_id and name_translation.column_key = "name" and name_translation.lang = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '45') LIMIT 1
0.08ms SELECT `products_templates_properties`.* FROM `products_templates_properties` WHERE (`group_id` = 12)
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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.08ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.07ms SELECT `products_properties_values`.* FROM `products_properties_values` WHERE (product_id = '398') AND (property_id = '49') LIMIT 1
0.06ms SELECT `products_templates_properties`.* FROM `products_templates_properties` WHERE (group_id is null) AND (`template_id` = 4)
0.12ms SELECT `pages`.*, `entities`.*, `title_translation`.`value_varchar` AS `Xtranslated_title`, `full_title_translation`.`value_varchar` AS `Xtranslated_full_title`, `text_markup_translation`.`value_longtext` AS `Xtranslated_text_markup`, `text_translation`.`value_longtext` AS `Xtranslated_text` FROM `pages` INNER JOIN `entities` ON `entities`.entity_id = `pages`.entity_id LEFT JOIN `entities_translations` AS `title_translation` ON title_translation.entity_id = entities.entity_id and title_translation.column_key = "title" and title_translation.lang = "cs" 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 = "cs" 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 = "cs" 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
2.12ms SELECT `pages`.*, `entities`.*, `title_translation`.`value_varchar` AS `Xtranslated_title`, `full_title_translation`.`value_varchar` AS `Xtranslated_full_title`, `text_markup_translation`.`value_longtext` AS `Xtranslated_text_markup`, `text_translation`.`value_longtext` AS `Xtranslated_text` FROM `pages` INNER JOIN `entities` ON `entities`.entity_id = `pages`.entity_id 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 = "cs" 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 = "cs" 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 = "cs" 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 = "cs" LEFT JOIN `entities_banned_langs` AS `ebl` ON ebl.entity_id = entities.entity_id WHERE (parent_id is null) AND (code = 'mainmenu') AND ((publish_from is null or publish_from = '0000-00-00' or publish_from <= '2018-05-24 13:48:59')) AND ((publish_to is null or publish_to = '0000-00-00' or publish_to >= '2018-05-24 13:48:59')) AND ((publish = 1)) AND (entities.only_in_own_lang = 0 or entities.lang = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') ORDER BY `priority` ASC
0.09ms 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 = "cs" 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 = "cs" 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 = "cs" 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1
0.10ms 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 = "cs" 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 = "cs" 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 = "cs" 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 = "cs" 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 = 'cs') AND (ebl.entity_id IS NULL OR ebl.lang != 'cs') LIMIT 1